- $sql .= " AND ".TB_PREF."sales_orders.from_stk_loc = '". $_POST['StockLocation'] . "' ";
-
- if ($_POST['OutstandingOnly'] == true)
- $sql .= " AND ".TB_PREF."sales_order_details.qty_invoiced < ".TB_PREF."sales_order_details.quantity";
-
- $sql .= " GROUP BY ".TB_PREF."sales_orders.order_no, ".TB_PREF."sales_orders.debtor_no, ".TB_PREF."sales_orders.branch_code,
- ".TB_PREF."sales_orders.customer_ref, ".TB_PREF."sales_orders.ord_date, ".TB_PREF."sales_orders.deliver_to";
-
-} //end not order number selected
-
-$result = db_query($sql,"No orders were returned");
-
-//-----------------------------------------------------------------------------------
-
-if ($result)
-{
-
- /*show a table of the orders returned by the sql */
-
- start_table("$table_style colspan=6 width=95%");
- $th = array(_("Order #"), _("Customer"), _("Branch"), _("Cust Order #"), _("Order Date"),
- _("Required By"), _("Delivery To"), _("Order Total"), _("Currency"), "", "");
- table_header($th);
-
- $j = 1;
- $k = 0; //row colour counter
- $overdue_items = false;
- while ($myrow = db_fetch($result))
- {
-
- $view_page = get_customer_trans_view_str(systypes::sales_order(), $myrow["order_no"]);
- $formated_del_date = sql2date($myrow["delivery_date"]);
- $formated_order_date = sql2date($myrow["ord_date"]);
-
- // if overdue orders, then highlight as so
- if (date1_greater_date2(Today(), $formated_del_date))
- {
- start_row("class='overduebg'");
- $overdue_items = true;
- }
- else
- {
- alt_table_row_color($k);
- }
-
- label_cell($view_page);
- label_cell($myrow["name"]);
- label_cell($myrow["br_name"]);
- label_cell($myrow["customer_ref"]);
- label_cell($formated_order_date);
- label_cell($formated_del_date);
- label_cell($myrow["deliver_to"]);
- amount_cell($myrow["OrderValue"]);
- label_cell($myrow["curr_code"]);
-
- if ($_POST['OutstandingOnly'] == true || $myrow["TotInvoiced"] < $myrow["TotQuantity"])
- {
- $modify_page = $path_to_root . "/sales/sales_order_entry.php?" . SID . "ModifyOrderNumber=" . $myrow["order_no"];
- $issue_invoice = $path_to_root . "/sales/customer_invoice.php?" . SID . "OrderNumber=" .$myrow["order_no"];
-
- label_cell("<a href='$modify_page'>" . _("Edit") . "</a>");
- label_cell("<a href='$issue_invoice'>" . _("Invoice") . "</a>");
- }
- else
- {
- label_cell("");
- label_cell("");
- }
- end_row();;
-
- $j++;
- If ($j == 12)
- {
- $j = 1;
- table_header($th);
- }
- //end of page full new headings if
- }
- //end of while loop
-
- end_table();