- $data_after = date2sql($_POST['OrdersAfterDate']);
- $date_before = date2sql($_POST['OrdersToDate']);
-
- $sql .= " AND ".TB_PREF."purch_orders.ord_date >= '$data_after'";
- $sql .= " AND ".TB_PREF."purch_orders.ord_date <= '$date_before'";
-
- if (isset($_POST['StockLocation']) && $_POST['StockLocation'] != reserved_words::get_all())
- {
- $sql .= " AND ".TB_PREF."purch_orders.into_stock_location = '". $_POST['StockLocation'] . "' ";
- }
- if (isset($selected_stock_item))
- {
- $sql .= " AND ".TB_PREF."purch_order_details.item_code='". $selected_stock_item ."' ";
- }
-
-} //end not order number selected
-
-$sql .= " GROUP BY ".TB_PREF."purch_orders.order_no";
-
-$result = db_query($sql,"No orders were returned");
-
-start_table("$table_style colspan=7 width=80%");
-
-if (isset($_POST['StockLocation']) && $_POST['StockLocation'] == reserved_words::get_all())
- $th = array(_("#"), _("Reference"), _("Supplier"), _("Location"),
- _("Supplier's Reference"), _("Order Date"), _("Currency"), _("Order Total"));
-else
- $th = array(_("#"), _("Reference"), _("Supplier"),
- _("Supplier's Reference"), _("Order Date"), _("Currency"), _("Order Total"));