projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Report fixed according to changed headers API in FrontReport class.
[fa-stable.git]
/
reporting
/
rep104.php
diff --git
a/reporting/rep104.php
b/reporting/rep104.php
index 53d8fea1df6d438c4bfdd79e1fa27afdd993d297..2c34f63a096d4ece97ea05de1ef5f5200b2d7e64 100644
(file)
--- a/
reporting/rep104.php
+++ b/
reporting/rep104.php
@@
-40,7
+40,7
@@
function fetch_items($category=0)
".TB_PREF."stock_category
WHERE ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id";
if ($category != 0)
".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";
$sql .= " ORDER BY ".TB_PREF."stock_master.category_id,
".TB_PREF."stock_master.stock_id";
@@
-57,7
+57,7
@@
function get_kits($category=0)
ON i.category_id=c.category_id";
$sql .= " WHERE !i.is_foreign AND i.item_code!=i.stock_id";
if ($category != 0)
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");
}
$sql .= " GROUP BY i.item_code";
return db_query($sql,"No kits were returned");
}
@@
-125,7
+125,7
@@
function print_price_listing()
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
- $rep->
Header
();
+ $rep->
NewPage
();
$result = fetch_items($category);
$result = fetch_items($category);
@@
-165,7
+165,7
@@
function print_price_listing()
{
$rep->NewLine();
if ($rep->row - $pic_height < $rep->bottomMargin)
{
$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();
$rep->AddImage($image, $rep->cols[1], $rep->row - $pic_height, 0, $pic_height);
$rep->row -= $pic_height;
$rep->NewLine();