-$sql = "SELECT ".TB_PREF."debtor_trans.trans_no, "
- .TB_PREF."debtors_master.curr_code, "
- .TB_PREF."debtors_master.name, "
- .TB_PREF."cust_branch.br_name, "
- .TB_PREF."debtor_trans.reference, "
- .TB_PREF."debtor_trans.tran_date, "
- .TB_PREF."debtor_trans.due_date, "
- .TB_PREF."sales_orders.customer_ref, "
- .TB_PREF."sales_orders.deliver_to, ";
-
-$sql .= " Sum(".TB_PREF."debtor_trans_details.quantity-"
- .TB_PREF."debtor_trans_details.qty_done) AS Outstanding, ";
-
-$sql .= " Sum(".TB_PREF."debtor_trans_details.qty_done) AS Done, ";
-
-$sql .= "(ov_amount+ov_gst+ov_freight+ov_freight_tax) AS DeliveryValue";
-$sql .=" FROM "
- .TB_PREF."sales_orders, "
- .TB_PREF."debtor_trans, "
- .TB_PREF."debtor_trans_details, "
- .TB_PREF."debtors_master, "
- .TB_PREF."cust_branch
- WHERE "
- .TB_PREF."sales_orders.order_no = ".TB_PREF."debtor_trans.order_ AND "
- .TB_PREF."debtor_trans.debtor_no = ".TB_PREF."debtors_master.debtor_no
- AND ".TB_PREF."debtor_trans.type = 13
- AND ".TB_PREF."debtor_trans_details.debtor_trans_no = ".TB_PREF."debtor_trans.trans_no
- AND ".TB_PREF."debtor_trans_details.debtor_trans_type = ".TB_PREF."debtor_trans.type
- AND ".TB_PREF."debtor_trans.branch_code = ".TB_PREF."cust_branch.branch_code
- AND ".TB_PREF."debtor_trans.debtor_no = ".TB_PREF."cust_branch.debtor_no ";
-
- if ($_POST['OutstandingOnly'] == true) {
- $sql .= " AND ".TB_PREF."debtor_trans_details.qty_done < ".TB_PREF."debtor_trans_details.quantity ";
- }
+function trans_view($trans, $trans_no)
+{
+ return get_customer_trans_view_str(13, $trans['trans_no']);
+}
+
+function batch_checkbox($row)
+{
+ $name = "Sel_" .$row['trans_no'];
+ return $row['Done'] ? '' :
+ "<input type='checkbox' name='$name' value='1' >"
+// add also trans_no => branch code for checking after 'Batch' submit
+ ."<input name='Sel_[".$row['trans_no']."]' type='hidden' value='"
+ .$row['branch_code']."'>\n";
+}
+
+function edit_link($row)
+{
+ return $row["Outstanding"]==0 ? '' :
+ pager_link(_('Edit'), "/sales/customer_delivery.php?ModifyDelivery="
+ .$row['trans_no'], ICON_EDIT);
+}
+
+function prt_link($row)
+{
+ return print_document_link($row['trans_no'], _("Print"), true, 13, ICON_PRINT);
+}
+
+function invoice_link($row)
+{
+ return $row["Outstanding"]==0 ? '' :
+ pager_link(_('Invoice'), "/sales/customer_invoice.php?DeliveryNumber="
+ .$row['trans_no'], ICON_DOC);
+}
+
+function check_overdue($row)
+{
+ return date1_greater_date2(Today(), sql2date($row["due_date"])) &&
+ $row["Outstanding"]!=0;
+}
+//------------------------------------------------------------------------------------------------
+$sql = "SELECT trans.trans_no,
+ debtor.name,
+ branch.branch_code,
+ branch.br_name,
+ sorder.deliver_to,
+ trans.reference,
+ sorder.customer_ref,
+ trans.tran_date,
+ trans.due_date,
+ (ov_amount+ov_gst+ov_freight+ov_freight_tax) AS DeliveryValue,
+ debtor.curr_code,
+ Sum(line.quantity-line.qty_done) AS Outstanding,
+ Sum(line.qty_done) AS Done
+ FROM "
+ .TB_PREF."sales_orders as sorder, "
+ .TB_PREF."debtor_trans as trans, "
+ .TB_PREF."debtor_trans_details as line, "
+ .TB_PREF."debtors_master as debtor, "
+ .TB_PREF."cust_branch as branch
+ WHERE
+ sorder.order_no = trans.order_ AND
+ trans.debtor_no = debtor.debtor_no
+ AND trans.type = 13
+ AND line.debtor_trans_no = trans.trans_no
+ AND line.debtor_trans_type = trans.type
+ AND trans.branch_code = branch.branch_code
+ AND trans.debtor_no = branch.debtor_no ";
+
+if ($_POST['OutstandingOnly'] == true) {
+ $sql .= " AND line.qty_done < line.quantity ";
+}