+function get_allocatable_sales_orders($customer_id = null, $trans_no=null, $type=null)
+{
+ $sql = "SELECT
+ sorder.trans_type as type,
+ sorder.order_no as trans_no,
+ sorder.reference,
+ sorder.ord_date,
+ debtor.name AS DebtorName,
+ debtor.curr_code,
+ total-IFNULL(invoiced.amount,0) as Total,
+ sorder.alloc,
+ sorder.delivery_date as due_date,
+ debtor.address,
+ sorder.version,
+ amt,
+ sorder.debtor_no,
+ sorder.branch_code
+ FROM ".TB_PREF."sales_orders as sorder
+ LEFT JOIN ".TB_PREF."debtors_master as debtor ON sorder.debtor_no = debtor.debtor_no
+ LEFT JOIN ".TB_PREF."cust_allocations as alloc
+ ON sorder.order_no = alloc.trans_no_to AND sorder.trans_type = alloc.trans_type_to AND alloc.person_id=sorder.debtor_no
+ LEFT JOIN (SELECT order_, sum(prep_amount) amount FROM ".TB_PREF."debtor_trans dt
+ WHERE prep_amount>0 AND dt.type=".ST_SALESINVOICE." GROUP BY order_) as invoiced ON sorder.order_no = invoiced.order_
+ WHERE sorder.trans_type=".ST_SALESORDER;