achmadzainulkarim

Untitled

May 7th, 2020
1,554
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT po.id, po.supplier_id, s.name as supplier_name, po.po_code, s.approved as supplier_approved, s.code as supplier_code, s.address as supplier_address, s.city as supplier_city, s.phone as suplier_phone, s.email as supplier_email, sb.account_number as supplier_account_number, sb.account_name as supplier_account_name, b.bank_name as supplier_bank_name, po.po_date, po.schedule_date, po.warehouse_id, w.company_name, w.name as warehouse_name, w.email as warehouse_email, w.city as warehouse_city, w.district as warehouse_district, w.address as warehouse_address, w.phone as warehouse_phone, po.payment_type, po.payment_due_date, po.status, po.note, po.delivery_type, po.pic, users.username as pic_name FROM purchase_orders as po INNER JOIN suppliers as s ON s.id=po.supplier_id LEFT JOIN users ON users.id=po.pic LEFT JOIN warehouses w ON w.id=po.warehouse_id LEFT JOIN supplier_banks sb ON sb.id=po.supplier_bank_id LEFT JOIN banks b ON sb.bank_id=b.id WHERE 1=1 AND po.deleted_at IS NULL AND po.id=316
RAW Paste Data