projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
[0000607] Issue with Inventory Adjustment with 0 cost value
[fa-stable.git]
/
reporting
/
rep102.php
diff --git
a/reporting/rep102.php
b/reporting/rep102.php
index bba5c01859998d74cbfe95e787aac0d53164a9e4..8bd7714ade3d191063e92b355165488b71d4e526 100644
(file)
--- a/
reporting/rep102.php
+++ b/
reporting/rep102.php
@@
-50,7
+50,7
@@
function get_invoices($customer_id, $to)
".TB_PREF."debtor_trans
WHERE ".TB_PREF."debtor_trans.type <> ".ST_CUSTDELIVERY."
".TB_PREF."debtor_trans
WHERE ".TB_PREF."debtor_trans.type <> ".ST_CUSTDELIVERY."
- AND ".TB_PREF."debtor
s_master
.payment_terms = ".TB_PREF."payment_terms.terms_indicator
+ AND ".TB_PREF."debtor
_trans
.payment_terms = ".TB_PREF."payment_terms.terms_indicator
AND ".TB_PREF."debtors_master.debtor_no = ".TB_PREF."debtor_trans.debtor_no
AND ".TB_PREF."debtor_trans.debtor_no = $customer_id
AND ".TB_PREF."debtor_trans.tran_date <= '$todate'
AND ".TB_PREF."debtors_master.debtor_no = ".TB_PREF."debtor_trans.debtor_no
AND ".TB_PREF."debtor_trans.debtor_no = $customer_id
AND ".TB_PREF."debtor_trans.tran_date <= '$todate'
@@
-64,7
+64,7
@@
function get_invoices($customer_id, $to)
function print_aged_customer_analysis()
{
function print_aged_customer_analysis()
{
-
global $comp_path,
$path_to_root, $systypes_array;
+
global
$path_to_root, $systypes_array;
$to = $_POST['PARAM_0'];
$fromcust = $_POST['PARAM_1'];
$to = $_POST['PARAM_0'];
$fromcust = $_POST['PARAM_1'];
@@
-84,7
+84,7
@@
function print_aged_customer_analysis()
$pg = new graph();
}
$pg = new graph();
}
- if ($fromcust == ALL_
NUMERIC
)
+ if ($fromcust == ALL_
TEXT
)
$from = _('All');
else
$from = get_customer_name($fromcust);
$from = _('All');
else
$from = get_customer_name($fromcust);
@@
-128,14
+128,14
@@
function print_aged_customer_analysis()
$headers[2] = _('Currency');
$rep = new FrontReport(_('Aged Customer Analysis'), "AgedCustomerAnalysis", user_pagesize());
$headers[2] = _('Currency');
$rep = new FrontReport(_('Aged Customer Analysis'), "AgedCustomerAnalysis", user_pagesize());
-
$rep->Font();
-
$rep->Info($params, $cols, $headers, $aligns);
-
$rep->Header
();
+ $rep->Font();
+ $rep->Info($params, $cols, $headers, $aligns);
+
$rep->NewPage
();
$total = array(0,0,0,0, 0);
$sql = "SELECT debtor_no, name, curr_code FROM ".TB_PREF."debtors_master";
$total = array(0,0,0,0, 0);
$sql = "SELECT debtor_no, name, curr_code FROM ".TB_PREF."debtors_master";
- if ($fromcust != ALL_
NUMERIC
)
+ if ($fromcust != ALL_
TEXT
)
$sql .= " WHERE debtor_no=".db_escape($fromcust);
$sql .= " ORDER BY name";
$result = db_query($sql, "The customers could not be retrieved");
$sql .= " WHERE debtor_no=".db_escape($fromcust);
$sql .= " ORDER BY name";
$result = db_query($sql, "The customers could not be retrieved");
@@
-230,16
+230,15
@@
function print_aged_customer_analysis()
$pg->type = $graphics;
$pg->skin = $graph_skin;
$pg->built_in = false;
$pg->type = $graphics;
$pg->skin = $graph_skin;
$pg->built_in = false;
- $pg->fontfile = $path_to_root . "/reporting/fonts/Vera.ttf";
$pg->latin_notation = ($decseps[$_SESSION["wa_current_user"]->prefs->dec_sep()] != ".");
$pg->latin_notation = ($decseps[$_SESSION["wa_current_user"]->prefs->dec_sep()] != ".");
- $filename =
$comp_path .'/'. user_company(). "/images/test
.png";
+ $filename =
company_path(). "/pdf_files/". uniqid("")."
.png";
$pg->display($filename, true);
$w = $pg->width / 1.5;
$h = $pg->height / 1.5;
$x = ($rep->pageWidth - $w) / 2;
$rep->NewLine(2);
if ($rep->row - $h < $rep->bottomMargin)
$pg->display($filename, true);
$w = $pg->width / 1.5;
$h = $pg->height / 1.5;
$x = ($rep->pageWidth - $w) / 2;
$rep->NewLine(2);
if ($rep->row - $h < $rep->bottomMargin)
- $rep->
Header
();
+ $rep->
NewPage
();
$rep->AddImage($filename, $x, $rep->row - $h, $w, $h);
}
$rep->NewLine();
$rep->AddImage($filename, $x, $rep->row - $h, $w, $h);
}
$rep->NewLine();