= '$date_after'";
$sql .= " AND ".TB_PREF."sales_orders.ord_date <= '$date_before'";
if ($selected_customer != -1)
$sql .= " AND ".TB_PREF."sales_orders.debtor_no='" . $selected_customer . "'";
if (isset($selected_stock_item))
$sql .= " AND ".TB_PREF."sales_order_details.stk_code='". $selected_stock_item ."'";
if (isset($_POST['StockLocation']) && $_POST['StockLocation'] != reserved_words::get_all())
$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("" . _("Edit") . "");
label_cell("" . _("Invoice") . "");
}
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();
if ($overdue_items)
display_note(_("Marked items are overdue."), 0, 1, "class='overduefg'");
}
echo "
";
end_page();
?>