Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function getProducts99($id) {
- return $this->db->select(
- 'p.code, p.name, p.unit, p.quantity, s.po, s.po_cust, s.currentdate, s.date, s.customer_id, s.total, si.quantity as qty, si.price as qprice, si.gross_total as grossTotal, si.serial_no, si.discount_value, si.discount, si.discount_id, si.product_id, p.code as verifikasi'
- )
- ->from('sales s')
- ->join('sales_items si', 'si.sales_id = s.sales_id', 'left')
- ->join('products p', 'p.product_id = si.product_id', 'left')
- // ->join('product_grouping d', 'd.product_id = p.product_id', 'left')
- // ->join('bonus_items bi', 'bi.product = p.product_id','left')
- ->where('s.sales_id',$id)
- ->get()
- ->result();
- }
- public function getSalesItems_new($sales_id) {
- $this->db->select('si.*')
- ->from('sales_items si')
- ->where('si.sales_id',$sales_id)
- ->get()->result();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement