+
+function get_order_summary() {
+ $sql = "SELECT debtor_no, debtor_ref, branch_ref
+ , min(delivery_date)
+ , sum(quantity - qty_sent) as quantity
+ , sum((quantity - qty_sent)*unit_price*(1-discount_percent/100)) as amount
+ , min(required_date)
+ , group_concat(distinct comments separator ';') as order_comment
+ , group_concat(distinct comment separator ';') as detail_comment
+ FROM ".TB_PREF."sales_order_details sod
+ JOIN ".TB_PREF."sales_orders so ON (so.order_no = sod.order_no
+ AND so.trans_type = sod.trans_type
+ AND so.trans_type = ".ST_SALESORDER."
+ )
+ NATURAL JOIN ".TB_PREF."debtors_master
+ NATURAL JOIN ".TB_PREF."cust_branch
+ WHERE quantity > qty_sent AND ".ST_SALESORDER."
+ GROUP BY debtor_no, branch_code
+ ";
+
+ return $sql;
+}