X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Frep709.php;h=9b762ddc4a084e0ea992bb7f6819cf83362e2599;hb=11e485e4a7c5f12c9424713b7330815a9cc5e4ae;hp=238bd3094974479a539ae480f5d0cd7c567a3a6f;hpb=4e436722cb991b7273c08bdc1dc53b5390772972;p=fa-stable.git diff --git a/reporting/rep709.php b/reporting/rep709.php index 238bd309..9b762ddc 100644 --- a/reporting/rep709.php +++ b/reporting/rep709.php @@ -1,15 +1,15 @@ . + See the License here . ***********************************************************************/ -$page_security = 2; +$page_security = 'SA_TAXREP'; // ---------------------------------------------------------------- // $ Revision: 2.0 $ // Creator: Joe Hunt @@ -33,9 +33,9 @@ function getTaxTransactions($from, $to) $fromdate = date2sql($from); $todate = date2sql($to); - $sql = "SELECT taxrec.*, - stype.type_name, - if(supp.supp_name is null, debt.name, supp.supp_name) as name, + $sql = "SELECT taxrec.*, taxrec.amount*ex_rate AS amount, + taxrec.net_amount*ex_rate AS net_amount, + IF(ISNULL(supp.supp_name), debt.name, supp.supp_name) as name, branch.br_name FROM ".TB_PREF."trans_tax_details taxrec LEFT JOIN ".TB_PREF."supp_trans strans @@ -44,9 +44,8 @@ function getTaxTransactions($from, $to) LEFT JOIN ".TB_PREF."debtor_trans dtrans ON taxrec.trans_no=dtrans.trans_no AND taxrec.trans_type=dtrans.type LEFT JOIN ".TB_PREF."debtors_master as debt ON dtrans.debtor_no=debt.debtor_no - LEFT JOIN ".TB_PREF."cust_branch as branch ON dtrans.branch_code=branch.branch_code, - ".TB_PREF."sys_types stype - WHERE taxrec.trans_type=stype.type_id + LEFT JOIN ".TB_PREF."cust_branch as branch ON dtrans.branch_code=branch.branch_code + WHERE (taxrec.amount != 0 OR taxrec.net_amount != 0) AND taxrec.trans_type != 13 AND taxrec.tran_date >= '$fromdate' AND taxrec.tran_date <= '$todate' @@ -72,19 +71,18 @@ function getTaxInfo($id) function print_tax_report() { - global $path_to_root, $trans_dir; + global $path_to_root, $trans_dir, $Hooks; - - include_once($path_to_root . "/reporting/includes/pdf_report.inc"); - - $rep = new FrontReport(_('Tax Report'), "TaxReport.pdf", user_pagesize()); - $from = $_POST['PARAM_0']; $to = $_POST['PARAM_1']; $summaryOnly = $_POST['PARAM_2']; $comments = $_POST['PARAM_3']; + + include_once($path_to_root . "/reporting/includes/pdf_report.inc"); + $dec = user_price_dec(); + $rep = new FrontReport(_('Tax Report'), "TaxReport", user_pagesize()); if ($summaryOnly == 1) $summary = _('Summary Only'); else @@ -96,20 +94,19 @@ function print_tax_report() while ($tax=db_fetch($res)) $taxes[$tax['id']] = array('in'=>0, 'out'=>0, 'taxin'=>0, 'taxout'=>0); - if (!$summaryOnly) - { - $cols = array(0, 80, 130, 180, 290, 370, 455, 505, 555); - - $headers = array(_('Trans Type'), _('Ref'), _('Date'), _('Name'), _('Branch Name'), - _('Net'), _('Rate'), _('Tax')); - $aligns = array('left', 'left', 'left', 'left', 'left', 'right', 'right', 'right'); + $params = array( 0 => $comments, + 1 => array('text' => _('Period'), 'from' => $from, 'to' => $to), + 2 => array('text' => _('Type'), 'from' => $summary, 'to' => '')); - $params = array( 0 => $comments, - 1 => array('text' => _('Period'), 'from' => $from, 'to' => $to), - 2 => array('text' => _('Type'), 'from' => $summary, 'to' => '')); + $cols = array(0, 100, 130, 180, 290, 370, 420, 470, 520); - $rep->Font(); - $rep->Info($params, $cols, $headers, $aligns); + $headers = array(_('Trans Type'), _('Ref'), _('Date'), _('Name'), _('Branch Name'), + _('Net'), _('Rate'), _('Tax')); + $aligns = array('left', 'left', 'left', 'left', 'left', 'right', 'right', 'right'); + $rep->Font(); + $rep->Info($params, $cols, $headers, $aligns); + if (!$summaryOnly) + { $rep->Header(); } @@ -119,22 +116,24 @@ function print_tax_report() while ($trans=db_fetch($transactions)) { - if (in_array($trans['trans_type'], array(11,20,1))) { + if (in_array($trans['trans_type'], array(11,20))) { $trans['net_amount'] *= -1; $trans['amount'] *= -1; } if (!$summaryOnly) { - $rep->TextCol(0, 1, $trans['type_name']); + $rep->TextCol(0, 1, systypes::name($trans['trans_type'])); + if ($trans['memo'] == '') + $trans['memo'] = get_reference($trans['trans_type'], $trans['trans_no']); $rep->TextCol(1, 2, $trans['memo']); - $rep->TextCol(2, 3, sql2date($trans['tran_date'])); + $rep->DateCol(2, 3, $trans['tran_date'], true); $rep->TextCol(3, 4, $trans['name']); $rep->TextCol(4, 5, $trans['br_name']); - $rep->TextCol(5, 6, number_format2($trans['net_amount'], $dec)); - $rep->TextCol(6, 7, number_format2($trans['rate'], $dec)); - $rep->TextCol(7, 8, number_format2($trans['amount'], $dec)); + $rep->AmountCol(5, 6, $trans['net_amount'], $dec); + $rep->AmountCol(6, 7, $trans['rate'], $dec); + $rep->AmountCol(7, 8, $trans['amount'], $dec); $rep->NewLine(); @@ -144,14 +143,13 @@ function print_tax_report() $rep->Header(); } } - if ($trans['amount'] > 0) { + if (in_array($trans['trans_type'], array(2,10,11))) { + $taxes[$trans['tax_type_id']]['taxout'] += $trans['amount']; + $taxes[$trans['tax_type_id']]['out'] += $trans['net_amount']; + } else { $taxes[$trans['tax_type_id']]['taxin'] += $trans['amount']; $taxes[$trans['tax_type_id']]['in'] += $trans['net_amount']; - } else { - $taxes[$trans['tax_type_id']]['taxout'] -= $trans['amount']; - $taxes[$trans['tax_type_id']]['out'] -= $trans['net_amount']; } - $totalnet += $trans['net_amount']; $totaltax += $trans['amount']; } @@ -176,12 +174,12 @@ function print_tax_report() $tx = getTaxInfo($id); $rep->TextCol(0, 1, $tx['name'] . " " . number_format2($tx['rate'], $dec) . "%"); - $rep->TextCol(1, 2, number_format2($sum['out'], $dec)); - $rep->TextCol(2, 3,number_format2($sum['taxout'], $dec)); - $rep->TextCol(3, 4, number_format2($sum['in'], $dec)); - $rep->TextCol(4, 5,number_format2($sum['taxin'], $dec)); - $rep->TextCol(5, 6, number_format2($sum['taxin']-$sum['taxout'], $dec)); - $taxtotal += $sum['taxin']-$sum['taxout']; + $rep->AmountCol(1, 2, $sum['out'], $dec); + $rep->AmountCol(2, 3, $sum['taxout'], $dec); + $rep->AmountCol(3, 4, $sum['in'], $dec); + $rep->AmountCol(4, 5, $sum['taxin'], $dec); + $rep->AmountCol(5, 6, $sum['taxout']+$sum['taxin'], $dec); + $taxtotal += $sum['taxout']+$sum['taxin']; $rep->NewLine(); } @@ -189,20 +187,14 @@ function print_tax_report() $rep->NewLine(); $rep->Line($rep->row + $rep->lineHeight); $rep->TextCol(3, 5, _("Total payable or refund")); - $rep->TextCol(5, 6, number_format2($taxtotal, $dec)); + $rep->AmountCol(5, 6, $taxtotal, $dec); $rep->Line($rep->row - 5); $rep->Font(); $rep->NewLine(); - $locale = $path_to_root . "/lang/" . $_SESSION['language']->code . "/locale.inc"; - if (file_exists($locale)) + if (method_exists($Hooks, 'TaxFunction')) { - $taxinclude = true; - include($locale); - -// if (function_exists("TaxFunction")) -// TaxFunction(); - + $Hooks->TaxFunction(); } $rep->End();