function print_bill_of_material()
{
global $path_to_root;
include_once $path_to_root . "reporting/includes/pdf_report.inc";
$frompart = $_REQUEST['PARAM_0'];
$topart = $_REQUEST['PARAM_1'];
$comments = $_REQUEST['PARAM_2'];
$dec = user_qty_dec();
$cols = array(0, 50, 305, 375, 445, 515);
$headers = array(tr('Component'), tr('Description'), tr('Loc'), tr('Wrk Ctr'), tr('Quantity'));
$aligns = array('left', 'left', 'left', 'left', 'right');
$params = array(0 => $comments, 1 => array('text' => tr('Component'), 'from' => $frompart, 'to' => $topart));
$rep = new FrontReport(tr('Bill of Material Listing'), "BillOfMaterial.pdf", user_pagesize());
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->Header();
$res = getTransactions($frompart, $topart);
$parent = '';
while ($trans = db_fetch($res)) {
if ($parent != $trans['parent']) {
if ($parent != '') {
$rep->Line($rep->row - 2);
$rep->NewLine(2, 3);
}
$rep->TextCol(0, 1, $trans['parent']);
$desc = get_item($trans['parent']);
$rep->TextCol(1, 2, $desc['description']);
$parent = $trans['parent'];
$rep->NewLine();
}
$rep->NewLine();
$rep->TextCol(0, 1, $trans['component']);
$rep->TextCol(1, 2, $trans['CompDescription']);
$rep->TextCol(2, 3, $trans['loc_code']);
$rep->TextCol(3, 4, $trans['workcentre_added']);
$rep->TextCol(4, 5, number_format2($trans['quantity'], $dec));
}
$rep->Line($rep->row - 4);
$rep->End();
}
function print_po()
{
global $path_to_root, $show_po_item_codes;
include_once $path_to_root . "/reporting/includes/pdf_report.inc";
$from = $_POST['PARAM_0'];
$to = $_POST['PARAM_1'];
$currency = $_POST['PARAM_2'];
$email = $_POST['PARAM_3'];
$comments = $_POST['PARAM_4'];
$orientation = $_POST['PARAM_5'];
if (!$from || !$to) {
return;
}
$orientation = $orientation ? 'L' : 'P';
$dec = user_price_dec();
$cols = array(4, 60, 225, 300, 340, 385, 450, 515);
// $headers in doctext.inc
$aligns = array('left', 'left', 'left', 'right', 'left', 'right', 'right');
$params = array('comments' => $comments);
$cur = get_company_Pref('curr_default');
if ($email == 0) {
$rep = new FrontReport(_('PURCHASE ORDER'), "PurchaseOrderBulk", user_pagesize(), 9, $orientation);
}
if ($orientation == 'L') {
recalculate_cols($cols);
}
for ($i = $from; $i <= $to; $i++) {
$myrow = get_po($i);
$baccount = get_default_bank_account($myrow['curr_code']);
$params['bankaccount'] = $baccount['id'];
if ($email == 1) {
$rep = new FrontReport("", "", user_pagesize(), 9, $orientation);
$rep->title = _('PURCHASE ORDER');
$rep->filename = "PurchaseOrder" . $i . ".pdf";
}
$rep->SetHeaderType('Header2');
$rep->currency = $cur;
$rep->Font();
$rep->Info($params, $cols, null, $aligns);
$contacts = get_supplier_contacts($myrow['supplier_id'], 'order');
$rep->SetCommonData($myrow, null, $myrow, $baccount, ST_PURCHORDER, $contacts);
$rep->NewPage();
$result = get_po_details($i);
$SubTotal = 0;
$items = $prices = array();
while ($myrow2 = db_fetch($result)) {
$data = get_purchase_data($myrow['supplier_id'], $myrow2['item_code']);
if ($data !== false) {
if ($data['supplier_description'] != "") {
$myrow2['description'] = $data['supplier_description'];
}
if ($data['suppliers_uom'] != "") {
$myrow2['units'] = $data['suppliers_uom'];
}
if ($data['conversion_factor'] != 1) {
$myrow2['unit_price'] = round2($myrow2['unit_price'] * $data['conversion_factor'], user_price_dec());
$myrow2['quantity_ordered'] = round2($myrow2['quantity_ordered'] / $data['conversion_factor'], user_qty_dec());
}
}
$Net = round2($myrow2["unit_price"] * $myrow2["quantity_ordered"], user_price_dec());
$prices[] = $Net;
$items[] = $myrow2['item_code'];
$SubTotal += $Net;
$dec2 = 0;
$DisplayPrice = price_decimal_format($myrow2["unit_price"], $dec2);
$DisplayQty = number_format2($myrow2["quantity_ordered"], get_qty_dec($myrow2['item_code']));
$DisplayNet = number_format2($Net, $dec);
if ($show_po_item_codes) {
$rep->TextCol(0, 1, $myrow2['item_code'], -2);
$rep->TextCol(1, 2, $myrow2['description'], -2);
} else {
$rep->TextCol(0, 2, $myrow2['description'], -2);
}
$rep->TextCol(2, 3, sql2date($myrow2['delivery_date']), -2);
$rep->TextCol(3, 4, $DisplayQty, -2);
$rep->TextCol(4, 5, $myrow2['units'], -2);
$rep->TextCol(5, 6, $DisplayPrice, -2);
$rep->TextCol(6, 7, $DisplayNet, -2);
$rep->NewLine(1);
if ($rep->row < $rep->bottomMargin + 15 * $rep->lineHeight) {
$rep->NewPage();
}
}
if ($myrow['comments'] != "") {
$rep->NewLine();
$rep->TextColLines(1, 5, $myrow['comments'], -2);
}
$DisplaySubTot = number_format2($SubTotal, $dec);
$rep->row = $rep->bottomMargin + 15 * $rep->lineHeight;
$doctype = ST_PURCHORDER;
$rep->TextCol(3, 6, _("Sub-total"), -2);
$rep->TextCol(6, 7, $DisplaySubTot, -2);
$rep->NewLine();
$tax_items = get_tax_for_items($items, $prices, 0, $myrow['tax_group_id'], $myrow['tax_included'], null);
$first = true;
foreach ($tax_items as $tax_item) {
if ($tax_item['Value'] == 0) {
continue;
}
$DisplayTax = number_format2($tax_item['Value'], $dec);
$tax_type_name = $tax_item['tax_type_name'];
if ($myrow['tax_included']) {
if (isset($alternative_tax_include_on_docs) && $alternative_tax_include_on_docs == 1) {
if ($first) {
$rep->TextCol(3, 6, _("Total Tax Excluded"), -2);
$rep->TextCol(6, 7, number_format2($sign * $tax_item['net_amount'], $dec), -2);
$rep->NewLine();
}
$rep->TextCol(3, 6, $tax_type_name, -2);
$rep->TextCol(6, 7, $DisplayTax, -2);
$first = false;
} else {
$rep->TextCol(3, 7, _("Included") . " " . $tax_type_name . _("Amount") . ": " . $DisplayTax, -2);
}
} else {
$SubTotal += $tax_item['Value'];
$rep->TextCol(3, 6, $tax_type_name, -2);
$rep->TextCol(6, 7, $DisplayTax, -2);
}
$rep->NewLine();
}
$rep->NewLine();
$DisplayTotal = number_format2($SubTotal, $dec);
$rep->Font('bold');
$rep->TextCol(3, 6, _("TOTAL PO"), -2);
$rep->TextCol(6, 7, $DisplayTotal, -2);
$words = price_in_words($SubTotal, ST_PURCHORDER);
if ($words != "") {
$rep->NewLine(1);
$rep->TextCol(1, 7, $myrow['curr_code'] . ": " . $words, -2);
}
$rep->Font();
if ($email == 1) {
$myrow['DebtorName'] = $myrow['supp_name'];
if ($myrow['reference'] == "") {
$myrow['reference'] = $myrow['order_no'];
}
$rep->End($email);
}
}
if ($email == 0) {
$rep->End();
}
}
function print_inventory_planning()
{
global $path_to_root;
include_once $path_to_root . "reporting/includes/pdf_report.inc";
$category = $_REQUEST['PARAM_0'];
$location = $_REQUEST['PARAM_1'];
$comments = $_REQUEST['PARAM_2'];
$dec = user_qty_dec();
if ($category == reserved_words::get_all_numeric()) {
$category = 0;
}
if ($category == 0) {
$cat = tr('All');
} else {
$cat = get_category_name($category);
}
if ($location == reserved_words::get_all()) {
$location = 'all';
}
if ($location == 'all') {
$loc = tr('All');
} else {
$loc = $location;
}
$cols = array(0, 50, 150, 180, 210, 240, 270, 300, 330, 390, 435, 480, 525);
$per0 = strftime('%b', mktime(0, 0, 0, date('m'), date('d'), date('Y')));
$per1 = strftime('%b', mktime(0, 0, 0, date('m') - 1, date('d'), date('Y')));
$per2 = strftime('%b', mktime(0, 0, 0, date('m') - 2, date('d'), date('Y')));
$per3 = strftime('%b', mktime(0, 0, 0, date('m') - 3, date('d'), date('Y')));
$per4 = strftime('%b', mktime(0, 0, 0, date('m') - 4, date('d'), date('Y')));
$headers = array(tr('Category'), '', $per4, $per3, $per2, $per1, $per0, '3*M', tr('QOH'), tr('Cust Ord'), tr('Supp Ord'), tr('Sugg Ord'));
$aligns = array('left', 'left', 'right', 'right', 'right', 'right', 'right', 'right', 'right', 'right', 'right', 'right');
$params = array(0 => $comments, 1 => array('text' => tr('Category'), 'from' => $cat, 'to' => ''), 2 => array('text' => tr('Location'), 'from' => $loc, 'to' => ''));
$rep = new FrontReport(tr('Inventory Planning Report'), "InventoryPlanning.pdf", user_pagesize());
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->Header();
$res = getTransactions($category, $location);
$catt = '';
while ($trans = db_fetch($res)) {
if ($catt != $trans['cat_description']) {
if ($catt != '') {
$rep->Line($rep->row - 2);
$rep->NewLine(2, 3);
}
$rep->TextCol(0, 1, $trans['category_id']);
$rep->TextCol(1, 2, $trans['cat_description']);
$catt = $trans['cat_description'];
$rep->NewLine();
}
$custqty = getCustQty($trans['stock_id'], $trans['loc_code']);
$custqty += getCustAsmQty($trans['stock_id'], $trans['loc_code']);
$suppqty = getSuppQty($trans['stock_id'], $trans['loc_code']);
$period = getPeriods($trans['stock_id'], $trans['loc_code']);
$rep->NewLine();
$rep->TextCol(0, 1, $trans['stock_id']);
$rep->TextCol(1, 2, $trans['description']);
$rep->TextCol(2, 3, number_format2($period['prd0'], $dec));
$rep->TextCol(3, 4, number_format2($period['prd1'], $dec));
$rep->TextCol(4, 5, number_format2($period['prd2'], $dec));
$rep->TextCol(5, 6, number_format2($period['prd3'], $dec));
$rep->TextCol(6, 7, number_format2($period['prd4'], $dec));
$MaxMthSales = Max($period['prd0'], $period['prd1'], $period['prd2'], $period['prd3']);
$IdealStockHolding = $MaxMthSales * 3;
$rep->TextCol(7, 8, number_format2($IdealStockHolding, $dec));
$rep->TextCol(8, 9, number_format2($trans['qty_on_hand'], $dec));
$rep->TextCol(9, 10, number_format2($custqty, $dec));
$rep->TextCol(10, 11, number_format2($suppqty, $dec));
$SuggestedTopUpOrder = $IdealStockHolding - $trans['qty_on_hand'] + $custqty - $suppqty;
if ($SuggestedTopUpOrder < 0.0) {
$SuggestedTopUpOrder = 0.0;
}
$rep->TextCol(11, 12, number_format2($SuggestedTopUpOrder, $dec));
}
$rep->Line($rep->row - 4);
$rep->End();
}
if ($chg_theme || $chg_lang || $chg_date_format || $chg_date_sep) {
meta_forward($_SERVER['PHP_SELF']);
}
if ($allow_demo_mode) {
display_warning(_("Display settings have been updated. Keep in mind that changed settings are restored on every login in demo mode."));
} else {
display_notification_centered(_("Display settings have been updated."));
}
}
}
start_form();
start_outer_table(TABLESTYLE2);
table_section(1);
table_section_title(_("Decimal Places"));
number_list_row(_("Prices/Amounts:"), 'prices_dec', user_price_dec(), 0, 10);
number_list_row(_("Quantities:"), 'qty_dec', user_qty_dec(), 0, 10);
number_list_row(_("Exchange Rates:"), 'rates_dec', user_exrate_dec(), 0, 10);
number_list_row(_("Percentages:"), 'percent_dec', user_percent_dec(), 0, 10);
table_section_title(_("Dateformat and Separators"));
dateformats_list_row(_("Dateformat:"), "date_format", user_date_format());
dateseps_list_row(_("Date Separator:"), "date_sep", user_date_sep());
/* The array $dateseps is set up in config.php for modifications
possible separators can be added by modifying the array definition by editing that file */
thoseps_list_row(_("Thousand Separator:"), "tho_sep", user_tho_sep());
/* The array $thoseps is set up in config.php for modifications
possible separators can be added by modifying the array definition by editing that file */
decseps_list_row(_("Decimal Separator:"), "dec_sep", user_dec_sep());
/* The array $decseps is set up in config.php for modifications
possible separators can be added by modifying the array definition by editing that file */
if (!isset($_POST['language'])) {
$_POST['language'] = $_SESSION['language']->code;
function print_salesman_list()
{
global $path_to_root;
include_once $path_to_root . "reporting/includes/pdf_report.inc";
$from = $_REQUEST['PARAM_0'];
$to = $_REQUEST['PARAM_1'];
$summary = $_REQUEST['PARAM_2'];
$comments = $_REQUEST['PARAM_3'];
if ($summary == 0) {
$sum = tr("No");
} else {
$sum = tr("Yes");
}
$dec = user_qty_dec();
$cols = array(0, 60, 150, 220, 325, 385, 450, 515);
$headers = array(tr('Invoice'), tr('Customer'), tr('Branch'), tr('Customer Ref'), tr('Inv Date'), tr('Total'), tr('Provision'));
$aligns = array('left', 'left', 'left', 'left', 'left', 'right', 'right');
$headers2 = array(tr('Salesman'), " ", tr('Phone'), tr('Email'), tr('Provision'), tr('Break Pt.'), tr('Provision') . " 2");
$params = array(0 => $comments, 1 => array('text' => tr('Period'), 'from' => $from, 'to' => $to), 2 => array('text' => tr('Summary Only'), 'from' => $sum, 'to' => ''));
$cols2 = $cols;
$aligns2 = $aligns;
$rep = new FrontReport(tr('Salesman Listing'), "SalesmanListing.pdf", user_pagesize());
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns, $cols2, $headers2, $aligns2);
$rep->Header();
$salesman = 0;
$subtotal = $total = $subprov = $provtotal = 0;
$result = GetSalesmanTrans($from, $to);
while ($myrow = db_fetch($result)) {
if ($rep->row < $rep->bottomMargin + 2 * $rep->lineHeight) {
$salesman = 0;
$rep->Header();
}
$rep->NewLine(0, 2, false, $salesman);
if ($salesman != $myrow['salesman_code']) {
if ($salesman != 0) {
$rep->Line($rep->row - 8);
$rep->NewLine(2);
$rep->TextCol(0, 3, tr('Total'));
$rep->TextCol(5, 6, number_format2($subtotal, $dec));
$rep->TextCol(6, 7, number_format2($subprov, $dec));
$rep->Line($rep->row - 4);
$rep->NewLine(2);
//$rep->Line($rep->row);
}
$rep->TextCol(0, 2, $myrow['salesman_code'] . " " . $myrow['salesman_name']);
$rep->TextCol(2, 3, $myrow['salesman_phone']);
$rep->TextCol(3, 4, $myrow['salesman_email']);
$rep->TextCol(4, 5, number_format2($myrow['provision'], user_percent_dec()) . " %");
$rep->TextCol(5, 6, number_format2($myrow['break_pt'], $dec));
$rep->TextCol(6, 7, number_format2($myrow['provision2'], user_percent_dec()) . " %");
$rep->NewLine(2);
$salesman = $myrow['salesman_code'];
$total += $subtotal;
$provtotal += $subprov;
$subtotal = 0;
$subprov = 0;
}
$date = sql2date($myrow['tran_date']);
$rate = get_exchange_rate_from_home_currency($myrow['curr_code'], $date);
$amt = $myrow['InvoiceTotal'] * $rate;
if ($subprov > $myrow['break_pt'] && $myrow['provision2'] != 0) {
$prov = $myrow['provision2'] * $amt / 100;
} else {
$prov = $myrow['provision'] * $amt / 100;
}
if (!$summary) {
$rep->TextCol(0, 1, $myrow['trans_no']);
$rep->TextCol(1, 2, $myrow['DebtorName']);
$rep->TextCol(2, 3, $myrow['br_name']);
$rep->TextCol(3, 4, $myrow['contact_name']);
$rep->TextCol(4, 5, $date);
$rep->TextCol(5, 6, number_format2($amt, $dec));
$rep->TextCol(6, 7, number_format2($prov, $dec));
$rep->NewLine();
if ($rep->row < $rep->bottomMargin + 2 * $rep->lineHeight) {
$salesman = 0;
$rep->Header();
}
}
$subtotal += $amt;
$subprov += $prov;
}
if ($salesman != 0) {
$rep->Line($rep->row - 4);
$rep->NewLine(2);
$rep->TextCol(0, 3, tr('Total'));
$rep->TextCol(5, 6, number_format2($subtotal, $dec));
$rep->TextCol(6, 7, number_format2($subprov, $dec));
$rep->Line($rep->row - 4);
$rep->NewLine(2);
//$rep->Line($rep->row);
$total += $subtotal;
$provtotal += $subprov;
}
$rep->fontSize += 2;
$rep->TextCol(0, 3, tr('Grand Total'));
$rep->fontSize -= 2;
$rep->TextCol(5, 6, number_format2($total, $dec));
$rep->TextCol(6, 7, number_format2($provtotal, $dec));
$rep->Line($rep->row - 4);
$rep->End();
}
if ($chg_theme || $chg_lang || $chg_date_format || $chg_date_sep) {
meta_forward($_SERVER['PHP_SELF']);
}
if ($allow_demo_mode) {
display_warning(_("Display settings have been updated. Keep in mind that changed settings are restored on every login in demo mode."));
} else {
display_notification_centered(_("Display settings have been updated."));
}
}
}
start_form();
start_outer_table(TABLESTYLE2);
table_section(1);
table_section_title(_("Decimal Places"));
text_row_ex(_("Prices/Amounts:"), 'prices_dec', 5, 5, '', user_price_dec());
text_row_ex(_("Quantities:"), 'qty_dec', 5, 5, '', user_qty_dec());
text_row_ex(_("Exchange Rates:"), 'rates_dec', 5, 5, '', user_exrate_dec());
text_row_ex(_("Percentages:"), 'percent_dec', 5, 5, '', user_percent_dec());
table_section_title(_("Dateformat and Separators"));
dateformats_list_row(_("Dateformat:"), "date_format", user_date_format());
dateseps_list_row(_("Date Separator:"), "date_sep", user_date_sep());
/* The array $dateseps is set up in config.php for modifications
possible separators can be added by modifying the array definition by editing that file */
thoseps_list_row(_("Thousand Separator:"), "tho_sep", user_tho_sep());
/* The array $thoseps is set up in config.php for modifications
possible separators can be added by modifying the array definition by editing that file */
decseps_list_row(_("Decimal Separator:"), "dec_sep", user_dec_sep());
/* The array $decseps is set up in config.php for modifications
possible separators can be added by modifying the array definition by editing that file */
if (!isset($_POST['language'])) {
$_POST['language'] = $_SESSION['language']->code;
function print_po()
{
global $path_to_root;
include_once $path_to_root . "reporting/includes/pdf_report.inc";
$from = $_REQUEST['PARAM_0'];
$to = $_REQUEST['PARAM_1'];
$currency = $_REQUEST['PARAM_2'];
$bankaccount = $_REQUEST['PARAM_3'];
$email = $_REQUEST['PARAM_4'];
$comments = $_REQUEST['PARAM_5'];
if ($from == null) {
$from = 0;
}
if ($to == null) {
$to = 0;
}
$dec = user_price_dec();
$cols = array(4, 60, 225, 300, 325, 385, 450, 515);
// $headers in doctext.inc
$aligns = array('left', 'left', 'left', 'left', 'right', 'right', 'right');
$params = array('comments' => $comments, 'bankaccount' => $bankaccount);
$baccount = get_bank_account($params['bankaccount']);
$cur = get_company_Pref('curr_default');
if ($email == 0) {
$rep = new FrontReport(tr('PURCHASE ORDER'), "PurchaseOrderBulk.pdf", user_pagesize());
$rep->currency = $cur;
$rep->Font();
$rep->Info($params, $cols, null, $aligns);
}
for ($i = $from; $i <= $to; $i++) {
$myrow = get_po($i);
if ($email == 1) {
$rep = new FrontReport("", "", user_pagesize());
$rep->currency = $cur;
$rep->Font();
$rep->title = tr('PURCHASE ORDER');
$rep->filename = "PurchaseOrder" . $i . ".pdf";
$rep->Info($params, $cols, null, $aligns);
} else {
$rep->title = tr('PURCHASE ORDER');
}
$rep->Header2($myrow, null, $myrow, $baccount, 8);
$result = get_po_details($i);
$SubTotal = 0;
while ($myrow2 = db_fetch($result)) {
$Net = round($myrow2["unit_price"] * $myrow2["quantity_ordered"], user_price_dec());
$SubTotal += $Net;
$DisplayPrice = number_format2($myrow2["unit_price"], $dec);
$DisplayQty = number_format2($myrow2["quantity_ordered"], user_qty_dec());
$DisplayNet = number_format2($Net, $dec);
//$rep->TextCol(0, 1, $myrow2['item_code'], -2);
$rep->TextCol(0, 2, $myrow2['description'], -2);
$rep->TextCol(2, 3, $myrow2['delivery_date'], -2);
$rep->TextCol(3, 4, $DisplayQty, -2);
$rep->TextCol(4, 5, $myrow2['units'], -2);
$rep->TextCol(5, 6, $DisplayPrice, -2);
$rep->TextCol(6, 7, $DisplayNet, -2);
$rep->NewLine(1);
if ($rep->row < $rep->bottomMargin + 15 * $rep->lineHeight) {
$rep->Header2($myrow, $branch, $sales_order, $baccount);
}
}
if ($myrow['comments'] != "") {
$rep->NewLine();
$rep->TextColLines(1, 5, $myrow['comments'], -2);
}
$DisplaySubTot = number_format2($SubTotal, $dec);
$rep->row = $rep->bottomMargin + 15 * $rep->lineHeight;
$linetype = true;
$doctype = 8;
if ($rep->currency != $myrow['curr_code']) {
include $path_to_root . "reporting/includes/doctext2.inc";
} else {
include $path_to_root . "reporting/includes/doctext.inc";
}
$rep->TextCol(3, 6, $doc_Sub_total, -2);
$rep->TextCol(6, 7, $DisplaySubTot, -2);
$rep->NewLine();
$DisplayTotal = number_format2($SubTotal, $dec);
$rep->Font('bold');
$rep->TextCol(3, 6, $doc_TOTAL_PO, -2);
$rep->TextCol(6, 7, $DisplayTotal, -2);
$rep->Font();
if ($email == 1) {
$myrow['contact_email'] = $myrow['email'];
$myrow['DebtorName'] = $myrow['supp_name'];
$myrow['reference'] = $myrow['order_no'];
$rep->End($email, $doc_Order_no . " " . $myrow['reference'], $myrow);
}
}
if ($email == 0) {
$rep->End();
}
}
function print_order_status_list()
{
global $path_to_root;
include_once $path_to_root . "reporting/includes/pdf_report.inc";
$from = $_REQUEST['PARAM_0'];
$to = $_REQUEST['PARAM_1'];
$category = $_REQUEST['PARAM_2'];
$location = $_REQUEST['PARAM_3'];
$backorder = $_REQUEST['PARAM_4'];
$comments = $_REQUEST['PARAM_5'];
$dec = user_qty_dec();
if ($category == reserved_words::get_all_numeric()) {
$category = 0;
}
if ($location == reserved_words::get_all()) {
$location = null;
}
if ($category == 0) {
$cat = tr('All');
} else {
$cat = get_category_name($category);
}
if ($location == null) {
$loc = tr('All');
} else {
$loc = $location;
}
if ($backorder == 0) {
$back = tr('All Orders');
} else {
$back = tr('Back Orders Only');
}
$cols = array(0, 60, 150, 260, 325, 385, 450, 515);
$headers2 = array(tr('Order'), tr('Customer'), tr('Branch'), tr('Customer Ref'), tr('Ord Date'), tr('Del Date'), tr('Loc'));
$aligns = array('left', 'left', 'right', 'right', 'right', 'right', 'right');
$headers = array(tr('Code'), tr('Description'), tr('Ordered'), tr('Invoiced'), tr('Outstanding'), '');
$params = array(0 => $comments, 1 => array('text' => tr('Period'), 'from' => $from, 'to' => $to), 2 => array('text' => tr('Category'), 'from' => $cat, 'to' => ''), 3 => array('text' => tr('Location'), 'from' => $loc, 'to' => ''), 4 => array('text' => tr('Selection'), 'from' => $back, 'to' => ''));
$cols2 = $cols;
$aligns2 = $aligns;
$rep = new FrontReport(tr('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']);
$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, tr('Outstanding'));
$rep->Font();
}
$rep->NewLine();
if ($rep->row < $rep->bottomMargin + 2 * $rep->lineHeight) {
$orderno = 0;
$rep->Header();
}
}
$rep->Line($rep->row);
$rep->End();
}
function print_inventory_valuation_report()
{
global $path_to_root;
include_once $path_to_root . "reporting/includes/pdf_report.inc";
$category = $_REQUEST['PARAM_0'];
$location = $_REQUEST['PARAM_1'];
$detail = $_REQUEST['PARAM_2'];
$comments = $_REQUEST['PARAM_3'];
$dec = user_price_dec();
if ($category == reserved_words::get_all_numeric()) {
$category = 0;
}
if ($category == 0) {
$cat = tr('All');
} else {
$cat = get_category_name($category);
}
if ($location == reserved_words::get_all()) {
$location = 'all';
}
if ($location == 'all') {
$loc = tr('All');
} else {
$loc = $location;
}
$cols = array(0, 100, 250, 350, 450, 515);
$headers = array(tr('Category'), '', tr('Quantity'), tr('Unit Cost'), tr('Value'));
$aligns = array('left', 'left', 'right', 'right', 'right');
$params = array(0 => $comments, 1 => array('text' => tr('Category'), 'from' => $cat, 'to' => ''), 2 => array('text' => tr('Location'), 'from' => $loc, 'to' => ''));
$rep = new FrontReport(tr('Inventory Valuation Report'), "InventoryValReport.pdf", user_pagesize());
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->Header();
$res = getTransactions($category, $location);
$total = $grandtotal = 0.0;
$catt = '';
while ($trans = db_fetch($res)) {
if ($catt != $trans['cat_description']) {
if ($catt != '') {
if ($detail) {
$rep->NewLine(2, 3);
$rep->TextCol(0, 4, tr('Total'));
}
$rep->Textcol(4, 5, number_format2($total, $dec));
if ($detail) {
$rep->Line($rep->row - 2);
$rep->NewLine();
}
$rep->NewLine();
$total = 0.0;
}
$rep->TextCol(0, 1, $trans['category_id']);
$rep->TextCol(1, 2, $trans['cat_description']);
$catt = $trans['cat_description'];
if ($detail) {
$rep->NewLine();
}
}
if ($detail) {
$rep->NewLine();
$rep->fontsize -= 2;
$rep->TextCol(0, 1, $trans['stock_id']);
$rep->TextCol(1, 2, $trans['description']);
$rep->TextCol(2, 3, number_format2($trans['QtyOnHand'], user_qty_dec()));
$rep->TextCol(3, 4, number_format2($trans['UnitCost'], $dec));
$rep->TextCol(4, 5, number_format2($trans['ItemTotal'], $dec));
$rep->fontsize += 2;
}
$total += $trans['ItemTotal'];
$grandtotal += $trans['ItemTotal'];
}
if ($detail) {
$rep->NewLine(2, 3);
$rep->TextCol(0, 4, tr('Total'));
}
$rep->Textcol(4, 5, number_format2($total, $dec));
if ($detail) {
$rep->Line($rep->row - 2);
$rep->NewLine();
}
$rep->NewLine(2, 1);
$rep->TextCol(0, 4, tr('Grand Total'));
$rep->TextCol(4, 5, number_format2($grandtotal, $dec));
$rep->Line($rep->row - 4);
$rep->End();
}
$supp_result = db_query($sql, "check failed");
$supp_row = db_fetch($supp_result);
if (strlen($supp_row['supp_name']) > 0) {
$person = $supp_row['supp_name'];
}
} elseif ($myrow["type"] == systypes::location_transfer() || $myrow["type"] == systypes::inventory_adjustment()) {
// get the adjustment type
$movement_type = get_movement_type($myrow["person_id"]);
$person = $movement_type["name"];
} elseif ($myrow["type"] == systypes::work_order() || $myrow["type"] == 28 || $myrow["type"] == 29) {
$person = "";
}
label_cell($person);
label_cell($myrow["qty"] >= 0 ? $quantity_formatted : "", "nowrap align=right");
label_cell($myrow["qty"] < 0 ? $quantity_formatted : "", "nowrap align=right");
label_cell(number_format2($after_qty, user_qty_dec()), "nowrap align=right");
end_row();
$j++;
if ($j == 12) {
$j = 1;
table_header($th);
}
//end of page full new headings if
}
//end of while loop
if ($total_in != 0 || $total_out != 0) {
start_row("class='inquirybg'");
label_cell("<b>" . tr("Quantity on hand after") . " " . $_POST['BeforeDate'] . "</b>", "align=center colspan=7");
qty_cell($after_qty);
end_row();
}
function print_deliveries()
{
global $path_to_root;
include_once $path_to_root . "reporting/includes/pdf_report.inc";
$from = $_REQUEST['PARAM_0'];
$to = $_REQUEST['PARAM_1'];
$email = $_REQUEST['PARAM_2'];
$comments = $_REQUEST['PARAM_3'];
if ($from == null) {
$from = 0;
}
if ($to == null) {
$to = 0;
}
$dec = user_price_dec();
$fno = explode("-", $from);
$tno = explode("-", $to);
$cols = array(5, 70, 260, 340, 365, 420, 470, 520);
// $headers in doctext.inc
$aligns = array('left', 'left', 'right', 'left', 'right', 'right', 'right');
$params = array('comments' => $comments);
$cur = get_company_Pref('curr_default');
if ($email == 0) {
$rep = new FrontReport(tr('DELIVERY'), "DeliveryNoteBulk.pdf", user_pagesize());
$rep->currency = $cur;
$rep->fontSize = 10;
$rep->Font();
$rep->Info($params, $cols, null, $aligns);
}
for ($i = $fno[0]; $i <= $tno[0]; $i++) {
if (!exists_customer_trans(13, $i)) {
continue;
}
$myrow = get_customer_trans($i, 13);
$sales_order = get_sales_order_header($myrow["order_"]);
// ?
$branch = get_branch($myrow["branch_code"]);
$lang = $branch["lang_code"];
// get language from customer
readstrings($lang);
$tax_group_id = $branch['tax_group_id'];
$tax_rate = 0;
$tax_name = '';
$msg = "Error retrieving tax values";
$sql = "select rate from tax_group_items ";
$sql = $sql . "where tax_group_id=" . $tax_group_id . " limit 1";
$result1 = db_query($sql, $msg);
if (db_num_rows($result1) != 0) {
$myrow1 = db_fetch_row($result1);
$tax_rate = $myrow1[0];
}
$sql = "select name from tax_groups ";
$sql = $sql . "where id=" . $tax_group_id . " limit 1";
$result1 = db_query($sql, $msg);
if (db_num_rows($result1) != 0) {
$myrow1 = db_fetch_row($result1);
$tax_name = $myrow1[0];
}
$tax_included = 0;
if ($email == 1) {
$rep = new FrontReport("", "", user_pagesize());
$rep->currency = $cur;
$rep->Font();
$rep->title = tr('DELIVERY NOTE');
$rep->filename = "Delivery" . $myrow['reference'] . ".pdf";
$rep->Info($params, $cols, null, $aligns);
} else {
$rep->title = tr('DELIVERY NOTE');
}
$rep->Header2($myrow, $branch, $sales_order, '', 13);
$result = get_customer_trans_details(13, $i);
$SubTotal = 0;
while ($myrow2 = db_fetch($result)) {
$Net = round((1 - $myrow2["discount_percent"]) * $myrow2["unit_price"] * $myrow2["quantity"], user_price_dec());
$SubTotal += $Net;
$DisplayPrice = number_format2($myrow2["unit_price"], $dec, 1);
$DisplayQty = number_format2($myrow2["quantity"], user_qty_dec(), 1);
$DisplayNet = number_format2($Net, $dec, 1);
$DisplayDate = sql2date($myrow2["date_from"], 1);
if ($myrow2["discount_percent"] == 0) {
$DisplayDiscount = "";
} else {
$DisplayDiscount = number_format2($myrow2["discount_percent"] * 100, user_percent_dec(), 1) . "%";
}
$rep->TextCol(0, 1, $myrow2['stock_id'], -2);
$rep->TextCol(1, 2, $DisplayDate . " " . $myrow2['description'], -2);
$rep->TextCol(2, 3, $DisplayQty, -2);
$rep->TextCol(3, 4, $myrow2['units'], -2);
$rep->TextCol(4, 5, $DisplayPrice, -2);
$rep->TextCol(5, 6, $DisplayDiscount, -2);
$rep->TextCol(6, 7, $DisplayNet, -2);
$rep->NewLine(1);
if ($rep->row < $rep->bottomMargin + 15 * $rep->lineHeight) {
$rep->Header2($myrow, $branch, $sales_order, '', 13);
}
}
$comments = get_comments(13, $i);
if ($comments && db_num_rows($comments)) {
$rep->NewLine();
while ($comment = db_fetch($comments)) {
$rep->TextColLines(0, 6, $comment['memo_'], -2);
}
}
$DisplaySubTot = number_format2($SubTotal, $dec, 1);
$DisplayFreight = number_format2($myrow["ov_freight"], $dec, 1);
$rep->row = $rep->bottomMargin + 15 * $rep->lineHeight;
$linetype = true;
$doctype = 13;
if ($rep->currency != $myrow['curr_code']) {
include $path_to_root . "reporting/includes/doctext.inc";
} else {
include $path_to_root . "reporting/includes/doctext.inc";
}
$amount = $myrow["ov_freight"] + $SubTotal;
$subtotal3 = number_format2($amount, $dec, 1);
$rep->TextCol(3, 6, $doc_Sub_total, -2);
$rep->TextCol(6, 7, $DisplaySubTot, -2);
$rep->NewLine();
$rep->TextCol(3, 6, $doc_Shipping, -2);
$rep->TextCol(6, 7, $DisplayFreight, -2);
$rep->NewLine();
$rep->TextCol(3, 6, $doc_Sub_total, -2);
$rep->TextCol(6, 7, $subtotal3, -2);
$rep->NewLine();
$amount_tax = $amount / 100 * $tax_rate;
if ($rep->currency == 'CHF') {
$val = $amount_tax;
$val1 = floatval(intval(round($val * 20, 0)) / 20);
$amount_tax = $val1;
}
$amount_tot = $amount + $amount_tax;
$DisplayTax = number_format2($amount_tax, $dec, 1);
$DisplayTotal = number_format2($amount_tot, $dec, 1);
if ($tax_included) {
$rep->TextCol(3, 7, $doc_Included . " " . $tax_nmae . " (" . $tax_rate . "%) " . $doc_Amount . ":" . $DisplayTax, -2);
} else {
$rep->TextCol(3, 6, $tax_name . " (" . $tax_rate . "%)", -2);
$rep->TextCol(6, 7, $DisplayTax, -2);
}
$rep->NewLine();
$rep->Font('bold');
$rep->TextCol(3, 6, $doc_TOTAL_DELIVERY, -2);
$rep->TextCol(6, 7, $DisplayTotal, -2);
$rep->Font();
/*
$tax_items = get_customer_trans_tax_details(13, $i);
while ($tax_item = db_fetch($tax_items))
{
$DisplayTax = number_format2($tax_item['amount'], $dec,1);
if ($tax_item['included_in_price'])
{
$rep->TextCol(3, 7, $doc_Included . " " . $tax_item['tax_type_name'] .
" (" . $tax_item['rate'] . "%) " . $doc_Amount . ":" . $DisplayTax, -2);
}
else
{
$rep->TextCol(3, 6, $tax_item['tax_type_name'] . " (" .
$tax_item['rate'] . "%)", -2);
$rep->TextCol(6, 7, $DisplayTax, -2);
}
$rep->NewLine();
}
//$rep->NewLine();
$DisplayTotal = number_format2($myrow["ov_freight"] +$myrow["ov_freight_tax"] + $myrow["ov_gst"] +
$myrow["ov_amount"],$dec,1);
$rep->Font('bold');
$rep->TextCol(3, 6, $doc_TOTAL_DELIVERY, - 2);
$rep->TextCol(6, 7, $DisplayTotal, -2);
$rep->Font();
*/
if ($email == 1) {
$myrow['dimension_id'] = $paylink;
// helper for pmt link
if ($myrow['email'] == '') {
$myrow['email'] = $branch['email'];
$myrow['DebtorName'] = $branch['br_name'];
}
$rep->End($email, $doc_Delivery_no . " " . $myrow['reference'], $myrow, 13);
}
}
if ($email == 0) {
$rep->End();
}
}
//-------------------------------------------------------------------------------------------------
if (isset($_POST['setprefs'])) {
$theme = user_theme();
set_user_prefs($_POST['prices'], $_POST['Quantities'], $_POST['Rates'], $_POST['Percent'], check_value('show_gl'), check_value('show_codes'), $_POST['date_format'], $_POST['date_sep'], $_POST['tho_sep'], $_POST['dec_sep'], $_POST['theme'], $_POST['page_size']);
language::set_language($_POST['language']);
flush_dir($comp_path . '/' . user_company() . '/js_cache');
if (user_theme() != $theme) {
reload_page("");
}
display_notification_centered(tr("Display settings have been updated."));
}
start_form();
start_table($table_style2);
table_section_title(tr("Decimal Places"));
text_row_ex(tr("Prices/Amounts:"), 'prices', 5, 5, user_price_dec());
text_row_ex(tr("Quantities:"), 'Quantities', 5, 5, user_qty_dec());
text_row_ex(tr("Exchange Rates:"), 'Rates', 5, 5, user_exrate_dec());
text_row_ex(tr("Percentages:"), 'Percent', 5, 5, user_percent_dec());
table_section_title(tr("Dateformat and Separators"));
dateformats_list_row(tr("Dateformat:"), "date_format", user_date_format());
dateseps_list_row(tr("Date Separator:"), "date_sep", user_date_sep());
/* The array $dateseps is set up in config.php for modifications
possible separators can be added by modifying the array definition by editing that file */
thoseps_list_row(tr("Thousand Separator:"), "tho_sep", user_tho_sep());
/* The array $thoseps is set up in config.php for modifications
possible separators can be added by modifying the array definition by editing that file */
decseps_list_row(tr("Decimal Separator:"), "dec_sep", user_dec_sep());
/* The array $decseps is set up in config.php for modifications
possible separators can be added by modifying the array definition by editing that file */
table_section_title(tr("Miscellaneous"));
check_row(tr("Show GL Information:"), 'show_gl', user_show_gl_info());
function small_qty_cells($label, $name, $init = null, $params = null, $post_label = null, $dec = null)
{
if (!isset($dec)) {
$dec = user_qty_dec();
}
$this->amount_cells_ex($label, $name, 7, 12, $init, $params, $post_label, $dec);
}
function printit($from, $to, $currency, $bank, $email, $quote, $comments, $file)
{
global $path_to_root;
global $print_as_quote;
include_once $path_to_root . "reporting/includes/pdf_report.inc";
$dec = user_price_dec();
$cols = array(5, 70, 260, 340, 365, 420, 470, 520);
// $headers in doctext.inc
$aligns = array('left', 'left', 'right', 'left', 'right', 'right', 'right');
$params = array('comments' => $comments, 'bankaccount' => $bankaccount);
$baccount = get_bank_account($params['bankaccount']);
$cur = get_company_Pref('curr_default');
if ($quote == 1) {
$print_as_quote = 1;
}
if ($email == 0) {
if ($quote == 1) {
$rep = new FrontReport(tr("QUOTE"), "QuoteBulk.pdf", user_pagesize());
} else {
$rep = new FrontReport(tr("SALES ORDER"), "SalesOrderBulk.pdf", user_pagesize());
}
$rep->currency = $cur;
$rep->fontSize = 10;
$rep->Font();
$rep->Info($params, $cols, null, $aligns);
}
for ($i = $from; $i <= $to; $i++) {
$myrow = get_sales_order_header($i);
$branch = get_branch($myrow["branch_code"]);
$lang = $branch["lang_code"];
// get language from customer
readstrings($lang);
$tax_group_id = $branch['tax_group_id'];
$tax_rate = 0;
$tax_name = '';
$msg = "Error retrieving tax values";
$sql = "select rate from tax_group_items ";
$sql = $sql . "where tax_group_id=" . $tax_group_id . " limit 1";
$result1 = db_query($sql, $msg);
if (db_num_rows($result1) != 0) {
$myrow1 = db_fetch_row($result1);
$tax_rate = $myrow1[0];
}
$sql = "select name from tax_groups ";
$sql = $sql . "where id=" . $tax_group_id . " limit 1";
$result1 = db_query($sql, $msg);
if (db_num_rows($result1) != 0) {
$myrow1 = db_fetch_row($result1);
$tax_name = $myrow1[0];
}
$tax_included = 0;
if ($email == 1) {
$rep = new FrontReport("", "", user_pagesize());
$rep->currency = $cur;
$rep->Font();
if ($quote == 1) {
$rep->title = tr("QUOTE");
$rep->filename = "Quote" . $i . ".pdf";
} else {
$rep->title = tr("SALES ORDER");
$rep->filename = "SalesOrder" . $i . ".pdf";
}
$rep->Info($params, $cols, null, $aligns);
} else {
$rep->title = $quote == 1 ? tr("QUOTE") : tr("SALES ORDER");
}
$rep->Header2($myrow, $branch, $myrow, $baccount, 9);
$result = get_sales_order_details($i);
$SubTotal = 0;
while ($myrow2 = db_fetch($result)) {
$Net = round((1 - $myrow2["discount_percent"]) * $myrow2["unit_price"] * $myrow2["quantity"], user_price_dec());
$SubTotal += $Net;
$DisplayPrice = number_format2($myrow2["unit_price"], $dec, 1);
$DisplayQty = number_format2($myrow2["quantity"], user_qty_dec(), 1);
$DisplayNet = number_format2($Net, $dec, 1);
$DisplayDate = sql2date($myrow2["date_from"], 1);
if ($myrow2["discount_percent"] == 0) {
$DisplayDiscount = "";
} else {
$DisplayDiscount = number_format2($myrow2["discount_percent"] * 100, user_percent_dec(), 1) . "%";
}
$rep->TextCol(0, 1, $myrow2['stk_code'], -2);
$rep->TextCol(1, 2, $DisplayDate . " " . $myrow2['description'], -2);
$rep->TextCol(2, 3, $DisplayQty, -2);
$rep->TextCol(3, 4, $myrow2['units'], -2);
$rep->TextCol(4, 5, $DisplayPrice, -2);
$rep->TextCol(5, 6, $DisplayDiscount, -2);
$rep->TextCol(6, 7, $DisplayNet, -2);
$rep->NewLine(1);
if ($rep->row < $rep->bottomMargin + 15 * $rep->lineHeight) {
$rep->Header2($myrow, $branch, $sales_order, $baccount);
}
if ($myrow2['notes'] != "") {
$rep->TextColLines(1, 2, $myrow2['notes'], -2);
}
}
if ($myrow['comments'] != "") {
$rep->NewLine();
$rep->TextColLines(1, 5, $myrow['comments'], -2);
}
$DisplaySubTot = number_format2($SubTotal, $dec, 1);
$DisplayFreight = number_format2($myrow["freight_cost"], $dec, 1);
$rep->row = $rep->bottomMargin + 15 * $rep->lineHeight;
$linetype = true;
$doctype = 9;
if ($rep->currency != $myrow['curr_code']) {
include $path_to_root . "reporting/includes/doctext.inc";
} else {
include $path_to_root . "reporting/includes/doctext.inc";
}
$amount = $myrow["freight_cost"] + $SubTotal;
$subtotal3 = number_format2($amount, $dec, 1);
$rep->TextCol(3, 6, $doc_Sub_total, -4);
$rep->TextCol(6, 7, $DisplaySubTot, -4);
$rep->NewLine();
$rep->TextCol(3, 6, $doc_Shipping, -3);
$rep->TextCol(6, 7, $DisplayFreight, -3);
$rep->NewLine();
$rep->TextCol(3, 6, $doc_Sub_total, -2);
$rep->TextCol(6, 7, $subtotal3, -2);
$rep->NewLine();
$amount_tax = $amount / 100 * $tax_rate;
if ($rep->currency == 'CHF') {
$val = $amount_tax;
$val1 = floatval(intval(round($val * 20, 0)) / 20);
$amount_tax = $val1;
}
$amount_tot = $amount + $amount_tax;
$DisplayTax = number_format2($amount_tax, $dec, 1);
$DisplayTotal = number_format2($amount_tot, $dec, 1);
if ($tax_included) {
$rep->TextCol(3, 7, $doc_Included . " " . $tax_nmae . " (" . $tax_rate . "%) " . $doc_Amount . ":" . $DisplayTax, -2);
} else {
$rep->TextCol(3, 6, $tax_name . " (" . $tax_rate . "%)", -2);
$rep->TextCol(6, 7, $DisplayTax, -2);
}
$rep->NewLine();
$rep->Font('bold');
$rep->TextCol(3, 6, $doc_TOTAL_ORDER_INCL, -2);
$rep->TextCol(6, 7, $DisplayTotal, -2);
$rep->Font();
if ($email == 1) {
if ($myrow['contact_email'] == '') {
$myrow['contact_email'] = $branch['email'];
$myrow['DebtorName'] = $branch['br_name'];
}
$rep->End($file);
}
}
if ($email == 0) {
$rep->End($file);
}
}
function print_stock_check()
{
global $comp_path, $path_to_root, $pic_height, $pic_width;
include_once $path_to_root . "reporting/includes/pdf_report.inc";
$category = $_REQUEST['PARAM_0'];
$location = $_REQUEST['PARAM_1'];
$pictures = $_REQUEST['PARAM_2'];
$comments = $_REQUEST['PARAM_3'];
$dec = user_qty_dec();
if ($category == reserved_words::get_all_numeric()) {
$category = 0;
}
if ($category == 0) {
$cat = tr('All');
} else {
$cat = get_category_name($category);
}
if ($location == reserved_words::get_all()) {
$location = 'all';
}
if ($location == 'all') {
$loc = tr('All');
} else {
$loc = $location;
}
$cols = array(0, 100, 305, 375, 445, 515);
$headers = array(tr('Category'), tr('Description'), tr('Quantity'), tr('Demand'), tr('Difference'));
$aligns = array('left', 'left', 'right', 'right', 'right');
$params = array(0 => $comments, 1 => array('text' => tr('Category'), 'from' => $cat, 'to' => ''), 2 => array('text' => tr('Location'), 'from' => $loc, 'to' => ''));
if ($pictures) {
$user_comp = user_company();
} else {
$user_comp = "";
}
$rep = new FrontReport(tr('Stock Check Sheets'), "StockCheckSheet.pdf", user_pagesize());
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->Header();
$res = getTransactions($category, $location);
$catt = '';
while ($trans = db_fetch($res)) {
if ($catt != $trans['cat_description']) {
if ($catt != '') {
$rep->Line($rep->row - 2);
$rep->NewLine(2, 3);
}
$rep->TextCol(0, 1, $trans['category_id']);
$rep->TextCol(1, 2, $trans['cat_description']);
$catt = $trans['cat_description'];
$rep->NewLine();
}
$demandqty = getDemandQty($trans['stock_id'], $trans['loc_code']);
$demandqty += getDemandAsmQty($trans['stock_id'], $trans['loc_code']);
$rep->NewLine();
$rep->TextCol(0, 1, $trans['stock_id']);
$rep->TextCol(1, 2, $trans['description']);
$rep->TextCol(2, 3, number_format2($trans['QtyOnHand'], $dec));
$rep->TextCol(3, 4, number_format2($demandqty, $dec));
$rep->TextCol(4, 5, number_format2($trans['QtyOnHand'] - $demandqty, $dec));
if ($pictures) {
$image = $comp_path . '/' . $user_comp . '/images/' . $trans['stock_id'] . '.jpg';
if (file_exists($image)) {
$rep->NewLine();
if ($rep->row - $height < $rep->bottomMargin) {
$rep->Header();
}
$rep->AddImage($image, $rep->cols[1], $rep->row - $pic_height, $pic_width, $pic_height);
$rep->row -= $pic_height;
$rep->NewLine();
}
}
}
$rep->Line($rep->row - 4);
$rep->End();
}
stock_item_heading($_POST['stock_id']);
set_global_stock_item($_POST['stock_id']);
start_table("{$table_style} width=30%");
$th = array(tr("Location"), tr("Quantity On Hand"), tr("Re-Order Level"));
table_header($th);
$j = 1;
$k = 0;
//row colour counter
$result = get_loc_details($_POST['stock_id']);
while ($myrow = db_fetch($result)) {
alt_table_row_color($k);
if (isset($_POST['UpdateData']) && check_num($myrow["loc_code"])) {
$myrow["reorder_level"] = input_num($myrow["loc_code"]);
set_reorder_level($_POST['stock_id'], $myrow["loc_code"], input_num($myrow["loc_code"]));
}
$qoh = get_qoh_on_date($_POST['stock_id'], $myrow["loc_code"]);
label_cell($myrow["location_name"]);
$_POST[$myrow["loc_code"]] = qty_format($myrow["reorder_level"]);
label_cell(number_format2($qoh, user_qty_dec()), "nowrap align='right'");
qty_cells(null, $myrow["loc_code"]);
end_row();
$j++;
if ($j == 12) {
$j = 1;
table_header($th);
}
}
end_table(1);
submit('UpdateData', tr("Update"));
end_form();
end_page();
