".TB_PREF."stock_category
WHERE ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id";
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");
}
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
- $rep->Header();
+ $rep->NewPage();
$result = fetch_items($category);
{
$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();