X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Frep108.php;h=84a80ca18279d32172ecd5e6cafa3c1a3ef0affd;hb=17b390efcf904072b02ec866b2a427490471a260;hp=b438e641c2d31153bc90755e53c3578a7b11a905;hpb=1571869d54be48452fdbe08f25130972ff0a7b5a;p=fa-stable.git diff --git a/reporting/rep108.php b/reporting/rep108.php index b438e641..84a80ca1 100644 --- a/reporting/rep108.php +++ b/reporting/rep108.php @@ -83,9 +83,9 @@ function print_statements() if ($email == 0) $rep = new FrontReport(_('STATEMENT'), "StatementBulk", user_pagesize(), 9, $orientation); - if ($orientation == 'L') + if ($orientation == 'L') recalculate_cols($cols); - + $sql = "SELECT debtor_no, name AS DebtorName, address, tax_id, curr_code, curdate() AS tran_date FROM ".TB_PREF."debtors_master"; if ($customer != ALL_TEXT) $sql .= " WHERE debtor_no = ".db_escape($customer); @@ -95,6 +95,9 @@ function print_statements() while ($myrow=db_fetch($result)) { + if ($currency != ALL_TEXT && $myrow['curr_code'] != $currency) { + continue; + } $date = date('Y-m-d'); $myrow['order_'] = ""; @@ -113,13 +116,13 @@ function print_statements() } $contacts = get_customer_contacts($myrow['debtor_no'], 'invoice'); - $rep->SetHeaderType('Header2'); $rep->currency = $cur; $rep->Font(); $rep->Info($params, $cols, null, $aligns); //= get_branch_contacts($branch['branch_code'], 'invoice', $branch['debtor_no']); $rep->SetCommonData($myrow, null, null, $baccount, ST_STATEMENT, $contacts); + $rep->SetHeaderType('Header2'); $rep->NewPage(); $rep->NewLine(); $doctype = ST_STATEMENT; @@ -174,4 +177,3 @@ function print_statements() $rep->End(); } -?>