".TB_PREF."stock_category.description
FROM ".TB_PREF."stock_master,
".TB_PREF."stock_category
- WHERE ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id";
+ WHERE ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id AND NOT ".TB_PREF."stock_master.inactive";
if ($category != 0)
- $sql .= " AND ".TB_PREF."stock_category.category_id = '$category'";
+ $sql .= " AND ".TB_PREF."stock_category.category_id = ".db_escape($category);
$sql .= " ORDER BY ".TB_PREF."stock_master.category_id,
".TB_PREF."stock_master.stock_id";
ON i.category_id=c.category_id";
$sql .= " WHERE !i.is_foreign AND i.item_code!=i.stock_id";
if ($category != 0)
- $sql .= " AND c.category_id = '$category'";
+ $sql .= " AND c.category_id = ".db_escape($category);
$sql .= " GROUP BY i.item_code";
return db_query($sql,"No kits were returned");
}
function print_price_listing()
{
- global $comp_path, $path_to_root, $pic_height, $pic_width;
+ global $path_to_root, $pic_height, $pic_width;
$currency = $_POST['PARAM_0'];
$category = $_POST['PARAM_1'];
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
- $rep->Header();
+ $rep->NewPage();
$result = fetch_items($category);
}
if ($pictures)
{
- $image = $comp_path . '/'. $user_comp . "/images/"
+ $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->Header();
+ $rep->NewPage();
$rep->AddImage($image, $rep->cols[1], $rep->row - $pic_height, 0, $pic_height);
$rep->row -= $pic_height;
$rep->NewLine();