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();
    }