function print_price_listing() { global $path_to_root, $pic_height, $pic_width; $currency = $_POST['PARAM_0']; $category = $_POST['PARAM_1']; $salestype = $_POST['PARAM_2']; $pictures = $_POST['PARAM_3']; $showGP = $_POST['PARAM_4']; $comments = $_POST['PARAM_5']; $orientation = $_POST['PARAM_6']; $destination = $_POST['PARAM_7']; if ($destination) { include_once $path_to_root . "/reporting/includes/excel_report.inc"; } else { include_once $path_to_root . "/reporting/includes/pdf_report.inc"; } $orientation = $orientation ? 'L' : 'P'; $dec = user_price_dec(); $home_curr = get_company_pref('curr_default'); if ($currency == ALL_TEXT) { $currency = $home_curr; } $curr = get_currency($currency); $curr_sel = $currency . " - " . $curr['currency']; if ($category == ALL_NUMERIC) { $category = 0; } if ($salestype == ALL_NUMERIC) { $salestype = 0; } if ($category == 0) { $cat = _('All'); } else { $cat = get_category_name($category); } if ($salestype == 0) { $stype = _('All'); } else { $stype = get_sales_type_name($salestype); } if ($showGP == 0) { $GP = _('No'); } else { $GP = _('Yes'); } $cols = array(0, 100, 360, 385, 450, 515); $headers = array(_('Category/Items'), _('Description'), _('UOM'), _('Price'), _('GP %')); $aligns = array('left', 'left', 'left', 'right', 'right'); $params = array(0 => $comments, 1 => array('text' => _('Currency'), 'from' => $curr_sel, 'to' => ''), 2 => array('text' => _('Category'), 'from' => $cat, 'to' => ''), 3 => array('text' => _('Sales Type'), 'from' => $stype, 'to' => ''), 4 => array('text' => _('Show GP %'), 'from' => $GP, 'to' => '')); if ($pictures) { $user_comp = user_company(); } else { $user_comp = ""; } $rep = new FrontReport(_('Price Listing'), "PriceListing", user_pagesize(), 9, $orientation); if ($orientation == 'L') { recalculate_cols($cols); } $rep->Font(); $rep->Info($params, $cols, $headers, $aligns); $rep->NewPage(); $result = fetch_items($category); $catgor = ''; $_POST['sales_type_id'] = $salestype; while ($myrow = db_fetch($result)) { if ($catgor != $myrow['description']) { $rep->Line($rep->row - $rep->lineHeight); $rep->NewLine(2); $rep->fontSize += 2; $rep->TextCol(0, 3, $myrow['category_id'] . " - " . $myrow['description']); $catgor = $myrow['description']; $rep->fontSize -= 2; $rep->NewLine(); } $rep->NewLine(); $rep->TextCol(0, 1, $myrow['stock_id']); $rep->TextCol(1, 2, $myrow['name']); $rep->TextCol(2, 3, $myrow['units']); $price = get_price($myrow['stock_id'], $currency, $salestype); $rep->AmountCol(3, 4, $price, $dec); if ($showGP) { $price2 = get_price($myrow['stock_id'], $home_curr, $salestype); if ($price2 != 0.0) { $disp = ($price2 - $myrow['Standardcost']) * 100 / $price2; } else { $disp = 0.0; } $rep->TextCol(4, 5, number_format2($disp, user_percent_dec()) . " %"); } if ($pictures) { $image = company_path() . "/images/" . item_img_name($myrow['stock_id']) . ".jpg"; if (file_exists($image)) { $rep->NewLine(); if ($rep->row - $pic_height < $rep->bottomMargin) { $rep->NewPage(); } $rep->AddImage($image, $rep->cols[1], $rep->row - $pic_height, 0, $pic_height); $rep->row -= $pic_height; $rep->NewLine(); } } else { $rep->NewLine(0, 1); } } $rep->Line($rep->row - 4); $result = get_kits($category); $catgor = ''; while ($myrow = db_fetch($result)) { if ($catgor != $myrow['cat_name']) { if ($catgor == '') { $rep->NewLine(2); $rep->fontSize += 2; $rep->TextCol(0, 3, _("Sales Kits")); $rep->fontSize -= 2; } $rep->Line($rep->row - $rep->lineHeight); $rep->NewLine(2); $rep->fontSize += 2; $rep->TextCol(0, 3, $myrow['cat_id'] . " - " . $myrow['cat_name']); $catgor = $myrow['cat_name']; $rep->fontSize -= 2; $rep->NewLine(); } $rep->NewLine(); $rep->TextCol(0, 1, $myrow['kit_code']); $rep->TextCol(1, 3, $myrow['kit_name']); $price = get_kit_price($myrow['kit_code'], $currency, $salestype); $rep->AmountCol(3, 4, $price, $dec); $rep->NewLine(0, 1); } $rep->Line($rep->row - 4); $rep->NewLine(); $rep->End(); }
function print_price_listing() { global $comp_path, $path_to_root, $pic_height, $pic_width; include_once $path_to_root . "reporting/includes/pdf_report.inc"; $category = $_REQUEST['PARAM_0']; $salestype = $_REQUEST['PARAM_1']; $pictures = $_REQUEST['PARAM_2']; $showGP = $_REQUEST['PARAM_3']; $comments = $_REQUEST['PARAM_4']; $dec = user_price_dec(); if ($category == reserved_words::get_all_numeric()) { $category = 0; } if ($salestype == reserved_words::get_all_numeric()) { $salestype = 0; } if ($category == 0) { $cat = tr('All'); } else { $cat = get_category_name($category); } if ($salestype == 0) { $stype = tr('All'); } else { $stype = get_sales_type_name($salestype); } if ($showGP == 0) { $GP = tr('No'); } else { $GP = tr('Yes'); } $cols = array(0, 100, 385, 450, 515); $headers = array(tr('Category/Items'), tr('Description'), tr('Price'), tr('GP %')); $aligns = array('left', 'left', 'right', 'right'); $params = array(0 => $comments, 1 => array('text' => tr('Category'), 'from' => $cat, 'to' => ''), 2 => array('text' => tr('Sales Type'), 'from' => $stype, 'to' => ''), 3 => array('text' => tr('Show GP %'), 'from' => $GP, 'to' => '')); if ($pictures) { $user_comp = user_company(); } else { $user_comp = ""; } $rep = new FrontReport(tr('Price Listing'), "PriceListing.pdf", user_pagesize()); $rep->Font(); $rep->Info($params, $cols, $headers, $aligns); $rep->Header(); $result = fetch_prices($category, $salestype); $currcode = ''; $catgor = ''; while ($myrow = db_fetch($result)) { if ($currcode != $myrow['curr_abrev']) { $rep->NewLine(2); $rep->fontSize += 2; $rep->TextCol(0, 3, $myrow['curr_abrev'] . " " . tr('Prices')); $currcode = $myrow['curr_abrev']; $rep->fontSize -= 2; $rep->NewLine(); } if ($catgor != $myrow['description']) { $rep->Line($rep->row - $rep->lineHeight); $rep->NewLine(2); $rep->fontSize += 2; $rep->TextCol(0, 3, $myrow['category_id'] . " - " . $myrow['description']); $catgor = $myrow['description']; $rep->fontSize -= 2; $rep->NewLine(); } $rep->NewLine(); $rep->TextCol(0, 1, $myrow['stock_id']); $rep->TextCol(1, 2, $myrow['name']); $rep->TextCol(2, 3, number_format2($myrow['price'], $dec)); if ($showGP) { if ($myrow['price'] != 0.0) { $disp = ($myrow['price'] - $myrow['Standardcost']) * 100 / $myrow['price']; } else { $disp = 0.0; } $rep->TextCol(3, 4, number_format2($disp, user_percent_dec()) . " %"); } if ($pictures) { $image = $comp_path . '/' . $user_comp . "/images/" . $myrow['stock_id'] . ".jpg"; if (file_exists($image)) { $rep->NewLine(); if ($rep->row - $pic_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(); } } else { $rep->NewLine(0, 1); } } $rep->Line($rep->row - 4); $rep->End(); }