='$fromdate' AND ".TB_PREF."sales_orders.ord_date <='$todate'"; if ($category > 0) $sql .= " AND ".TB_PREF."stock_master.category_id=$category"; if ($location != null) $sql .= " AND ".TB_PREF."sales_orders.from_stk_loc='$location'"; if ($backorder) $sql .= "AND ".TB_PREF."sales_order_details.quantity - ".TB_PREF."sales_order_details.qty_sent > 0"; $sql .= " ORDER BY ".TB_PREF."sales_orders.order_no"; return db_query($sql, "Error getting order details"); } //---------------------------------------------------------------------------------------------------- function print_order_status_list() { global $path_to_root; include_once($path_to_root . "reporting/includes/pdf_report.inc"); $from = $_POST['PARAM_0']; $to = $_POST['PARAM_1']; $category = $_POST['PARAM_2']; $location = $_POST['PARAM_3']; $backorder = $_POST['PARAM_4']; $comments = $_POST['PARAM_5']; if ($category == reserved_words::get_all_numeric()) $category = 0; if ($location == reserved_words::get_all()) $location = null; if ($category == 0) $cat = _('All'); else $cat = get_category_name($category); if ($location == null) $loc = _('All'); else $loc = $location; if ($backorder == 0) $back = _('All Orders'); else $back = _('Back Orders Only'); $cols = array(0, 60, 150, 260, 325, 385, 450, 515); $headers2 = array(_('Order'), _('Customer'), _('Branch'), _('Customer Ref'), _('Ord Date'), _('Del Date'), _('Loc')); $aligns = array('left', 'left', 'right', 'right', 'right', 'right', 'right'); $headers = array(_('Code'), _('Description'), _('Ordered'), _('Invoiced'), _('Outstanding'), ''); $params = array( 0 => $comments, 1 => array( 'text' => _('Period'), 'from' => $from, 'to' => $to), 2 => array( 'text' => _('Category'), 'from' => $cat,'to' => ''), 3 => array( 'text' => _('Location'), 'from' => $loc, 'to' => ''), 4 => array( 'text' => _('Selection'),'from' => $back,'to' => '')); $cols2 = $cols; $aligns2 = $aligns; $rep = new FrontReport(_('Order Status Listing'), "OrderStatusListing.pdf", user_pagesize()); $rep->Font(); $rep->Info($params, $cols, $headers, $aligns, $cols2, $headers2, $aligns2); $rep->Header(); $orderno = 0; $result = GetSalesOrders($from, $to, $category, $location, $backorder); while ($myrow=db_fetch($result)) { if ($rep->row < $rep->bottomMargin + (2 * $rep->lineHeight)) { $orderno = 0; $rep->Header(); } $rep->NewLine(0, 2, false, $orderno); if ($orderno != $myrow['order_no']) { if ($orderno != 0) { $rep->Line($rep->row); $rep->NewLine(); } $rep->TextCol(0, 1, $myrow['order_no']); $rep->TextCol(1, 2, get_customer_name($myrow['debtor_no'])); $rep->TextCol(2, 3, get_branch_name($myrow['branch_code'])); $rep->TextCol(3, 4, $myrow['customer_ref']); $rep->TextCol(4, 5, sql2date($myrow['ord_date'])); $rep->TextCol(5, 6, sql2date($myrow['delivery_date'])); $rep->TextCol(6, 7, $myrow['from_stk_loc']); $rep->NewLine(2); $orderno = $myrow['order_no']; } $rep->TextCol(0, 1, $myrow['stk_code']); $rep->TextCol(1, 2, $myrow['description']); $dec = get_qty_dec($myrow['stk_code']); $rep->TextCol(2, 3, number_format2($myrow['quantity'], $dec)); $rep->TextCol(3, 4, number_format2($myrow['qty_sent'], $dec)); $rep->TextCol(4, 5, number_format2($myrow['quantity'] - $myrow['qty_sent'], $dec)); if ($myrow['quantity'] - $myrow['qty_sent'] > 0) { $rep->Font('italic'); $rep->TextCol(5, 6, _('Outstanding')); $rep->Font(); } $rep->NewLine(); if ($rep->row < $rep->bottomMargin + (2 * $rep->lineHeight)) { $orderno = 0; $rep->Header(); } } $rep->Line($rep->row); $rep->End(); } ?>