function print_tax_report()
{
global $path_to_root, $trans_dir, $Hooks, $systypes_array;
$from = $_POST['PARAM_0'];
$to = $_POST['PARAM_1'];
$summaryOnly = $_POST['PARAM_2'];
$comments = $_POST['PARAM_3'];
$orientation = $_POST['PARAM_4'];
$destination = $_POST['PARAM_5'];
if ($destination) {
include_once $path_to_root . "/reporting/includes/excel_report.inc";
} else {
include_once $path_to_root . "/reporting/includes/pdf_report.inc";
}
$orientation = $orientation ? 'L' : 'P';
$dec = user_price_dec();
$rep = new FrontReport(_('Tax Report'), "TaxReport", user_pagesize(), 9, $orientation);
if ($summaryOnly == 1) {
$summary = _('Summary Only');
} else {
$summary = _('Detailed Report');
}
$res = getTaxTypes();
$taxes = array();
while ($tax = db_fetch($res)) {
$taxes[$tax['id']] = array('in' => 0, 'out' => 0, 'taxin' => 0, 'taxout' => 0);
}
$params = array(0 => $comments, 1 => array('text' => _('Period'), 'from' => $from, 'to' => $to), 2 => array('text' => _('Type'), 'from' => $summary, 'to' => ''));
$cols = array(0, 80, 130, 180, 270, 350, 400, 430, 480, 485, 520);
$headers = array(_('Trans Type'), _('Ref'), _('Date'), _('Name'), _('Branch Name'), _('Net'), _('Rate'), _('Tax'), '', _('Name'));
$aligns = array('left', 'left', 'left', 'left', 'left', 'right', 'right', 'right', 'right', 'left');
if ($orientation == 'L') {
recalculate_cols($cols);
}
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
if (!$summaryOnly) {
$rep->NewPage();
}
$totalnet = 0.0;
$totaltax = 0.0;
$transactions = getTaxTransactions($from, $to);
while ($trans = db_fetch($transactions)) {
if (in_array($trans['trans_type'], array(ST_CUSTCREDIT, ST_SUPPINVOICE, ST_JOURNAL))) {
$trans['net_amount'] *= -1;
$trans['amount'] *= -1;
}
if (!$summaryOnly) {
$rep->TextCol(0, 1, $systypes_array[$trans['trans_type']]);
if ($trans['memo'] == '') {
$trans['memo'] = get_reference($trans['trans_type'], $trans['trans_no']);
}
$rep->TextCol(1, 2, $trans['memo']);
$rep->DateCol(2, 3, $trans['tran_date'], true);
$rep->TextCol(3, 4, $trans['name']);
$rep->TextCol(4, 5, $trans['br_name']);
$rep->AmountCol(5, 6, $trans['net_amount'], $dec);
$rep->AmountCol(6, 7, $trans['rate'], $dec);
$rep->AmountCol(7, 8, $trans['amount'], $dec);
$rep->TextCol(9, 10, $trans['taxname']);
$rep->NewLine();
if ($rep->row < $rep->bottomMargin + $rep->lineHeight) {
$rep->Line($rep->row - 2);
$rep->NewPage();
}
}
if ($trans['trans_type'] == ST_JOURNAL && $trans['amount'] < 0) {
$taxes[$trans['tax_type_id']]['taxin'] += $trans['amount'];
$taxes[$trans['tax_type_id']]['in'] += $trans['net_amount'];
} elseif ($trans['trans_type'] == ST_JOURNAL && $trans['amount'] >= 0) {
$taxes[$trans['tax_type_id']]['taxout'] += $trans['amount'];
$taxes[$trans['tax_type_id']]['out'] += $trans['net_amount'];
} elseif (in_array($trans['trans_type'], array(ST_BANKDEPOSIT, ST_SALESINVOICE, ST_CUSTCREDIT))) {
$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'];
}
$totalnet += $trans['net_amount'];
$totaltax += $trans['amount'];
}
// Summary
$cols2 = array(0, 100, 180, 260, 340, 420, 500);
if ($orientation == 'L') {
recalculate_cols($cols2);
}
$headers2 = array(_('Tax Rate'), _('Outputs'), _('Output Tax'), _('Inputs'), _('Input Tax'), _('Net Tax'));
$aligns2 = array('left', 'right', 'right', 'right', 'right', 'right', 'right');
$rep->Info($params, $cols2, $headers2, $aligns2);
//for ($i = 0; $i < count($cols2); $i++)
// $rep->cols[$i] = $rep->leftMargin + $cols2[$i];
$rep->headers = $headers2;
$rep->aligns = $aligns2;
$rep->NewPage();
$taxtotal = 0;
foreach ($taxes as $id => $sum) {
$tx = getTaxInfo($id);
$rep->TextCol(0, 1, $tx['name'] . " " . number_format2($tx['rate'], $dec) . "%");
$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();
}
$rep->Font('bold');
$rep->NewLine();
$rep->Line($rep->row + $rep->lineHeight);
$rep->TextCol(3, 5, _("Total payable or refund"));
$rep->AmountCol(5, 6, $taxtotal, $dec);
$rep->Line($rep->row - 5);
$rep->Font();
$rep->NewLine();
hook_tax_report_done();
$rep->End();
}
function print_tax_report()
{
global $path_to_root;
include_once $path_to_root . "reporting/includes/pdf_report.inc";
$rep = new FrontReport(tr('Tax Report'), "TaxReport.pdf", user_pagesize());
$from = $_REQUEST['PARAM_0'];
$to = $_REQUEST['PARAM_1'];
$summaryOnly = $_REQUEST['PARAM_2'];
$comments = $_REQUEST['PARAM_3'];
$dec = user_price_dec();
if ($summaryOnly == 1) {
$summary = tr('Summary Only');
} else {
$summary = tr('Detailed Report');
}
$res = getTaxTypes();
$taxes = array();
$i = 0;
while ($tax = db_fetch($res)) {
$taxes[$i++] = $tax['id'];
}
$idcounter = count($taxes);
$totalinvout = array(0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
$totaltaxout = array(0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
$totalinvin = array(0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
$totaltaxin = array(0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
if (!$summaryOnly) {
$cols = array(0, 80, 130, 190, 290, 370, 435, 500, 565);
$headers = array(tr('Trans Type'), tr('#'), tr('Date'), tr('Name'), tr('Branch Name'), tr('Net'), tr('Tax'));
$aligns = array('left', 'left', 'left', 'left', 'left', 'right', 'right');
$params = array(0 => $comments, 1 => array('text' => tr('Period'), 'from' => $from, 'to' => $to), 2 => array('text' => tr('Type'), 'from' => $summary, 'to' => ''));
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->Header();
}
$totalnet = 0.0;
$totaltax = 0.0;
$transactions = getCustTransactions($from, $to);
while ($trans = db_fetch($transactions)) {
if (!$summaryOnly) {
$rep->TextCol(0, 1, $trans['type_name']);
$rep->TextCol(1, 2, $trans['reference']);
$rep->TextCol(2, 3, sql2date($trans['tran_date']));
$rep->TextCol(3, 4, $trans['name']);
if ($trans["branch_code"] > 0) {
$rep->TextCol(4, 5, get_branch_name($trans["branch_code"]));
}
$rep->TextCol(5, 6, number_format2($trans['NetAmount'], $dec));
$rep->TextCol(6, 7, number_format2($trans['Tax'], $dec));
$rep->NewLine();
if ($rep->row < $rep->bottomMargin + $rep->lineHeight) {
$rep->Line($rep->row - 2);
$rep->Header();
}
}
$totalnet += $trans['NetAmount'];
$totaltax += $trans['Tax'];
}
if (!$summaryOnly) {
$rep->NewLine();
if ($rep->row < $rep->bottomMargin + $rep->lineHeight) {
$rep->Line($rep->row - 2);
$rep->Header();
}
$rep->Line($rep->row + $rep->lineHeight);
$rep->TextCol(3, 5, tr('Total Outputs'));
$rep->TextCol(5, 6, number_format2($totalnet, $dec));
$rep->TextCol(6, 7, number_format2($totaltax, $dec));
$rep->Line($rep->row - 5);
$rep->Header();
}
$totalinnet = 0.0;
$totalintax = 0.0;
$transactions = getSuppTransactions($from, $to);
while ($trans = db_fetch($transactions)) {
if (!$summaryOnly) {
$rep->TextCol(0, 1, $trans['type_name']);
$rep->TextCol(1, 2, $trans['supp_reference']);
$rep->TextCol(2, 3, sql2date($trans['tran_date']));
$rep->TextCol(3, 5, $trans['supp_name']);
$rep->TextCol(5, 6, number_format2($trans['NetAmount'], $dec));
$rep->TextCol(6, 7, number_format2($trans['Tax'], $dec));
$rep->NewLine();
if ($rep->row < $rep->bottomMargin + $rep->lineHeight) {
$rep->Line($rep->row - 2);
$rep->Header();
}
}
$totalinnet += $trans['NetAmount'];
$totalintax += $trans['Tax'];
}
if (!$summaryOnly) {
$rep->NewLine();
if ($rep->row < $rep->bottomMargin + $rep->lineHeight) {
$rep->Line($rep->row - 2);
$rep->Header();
}
$rep->Line($rep->row + $rep->lineHeight);
$rep->TextCol(3, 5, tr('Total Inputs'));
$rep->TextCol(5, 6, number_format2($totalinnet, $dec));
$rep->TextCol(6, 7, number_format2($totalintax, $dec));
$rep->Line($rep->row - 5);
}
$cols2 = array(0, 100, 200, 300, 400, 500, 600);
$headers2 = array(tr('Tax Rate'), tr('Outputs'), tr('Output Tax'), tr('Inputs'), tr('Input Tax'));
$aligns2 = array('left', 'right', 'right', 'right', 'right');
$invamount = 0.0;
for ($i = 0; $i < $idcounter; $i++) {
$amt = getCustInvTax($taxes[$i], $from, $to);
$totalinvout[$i] += $amt[0];
$totaltaxout[$i] += $amt[1];
$invamount += $amt[0];
}
if ($totalnet != $invamount) {
$totalinvout[$idcounter] = $invamount - $totalnet;
}
for ($i = 0; $i < $idcounter; $i++) {
$amt = getSuppInvTax($taxes[$i], $from, $to);
$totalinvin[$i] += $amt[0];
$totaltaxin[$i] += $amt[1];
$invamount += $amt[0];
}
if ($totalinnet != $invamount) {
$totalinvin[$idcounter] = $totalinnet - $invamount;
}
for ($i = 0; $i < count($cols2) - 2; $i++) {
$rep->cols[$i] = $rep->leftMargin + $cols2[$i];
$rep->headers[$i] = $headers2[$i];
$rep->aligns[$i] = $aligns2[$i];
}
$rep->Header();
$counter = count($totalinvout);
$counter = max($counter, $idcounter);
$trow = $rep->row;
$i = 0;
for ($j = 0; $j < $counter; $j++) {
if (isset($taxes[$j]) && $taxes[$j] > 0) {
$tx = getTaxInfo($taxes[$j]);
$str = $tx['name'] . " " . number_format2($tx['rate'], $dec) . "%";
} else {
$str = tr('No tax specified');
}
$rep->TextCol($i, $i + 1, $str);
$rep->NewLine();
}
$i++;
$rep->row = $trow;
for ($j = 0; $j < $counter; $j++) {
$rep->TextCol($i, $i + 1, number_format2($totalinvout[$j], $dec));
$rep->NewLine();
}
$i++;
$rep->row = $trow;
for ($j = 0; $j < $counter; $j++) {
$rep->TextCol($i, $i + 1, number_format2($totaltaxout[$j], $dec));
$rep->NewLine();
}
$i++;
$rep->row = $trow;
for ($j = 0; $j < $counter; $j++) {
$rep->TextCol($i, $i + 1, number_format2($totalinvin[$j], $dec));
$rep->NewLine();
}
$i++;
$rep->row = $trow;
for ($j = 0; $j < $counter; $j++) {
$rep->TextCol($i, $i + 1, number_format2($totaltaxin[$j], $dec));
$rep->NewLine();
}
$rep->Line($rep->row - 4);
$locale = $path_to_root . "lang/" . $_SESSION['language']->code . "/locale.inc";
if (file_exists($locale)) {
$taxinclude = true;
include $locale;
/*
if (function_exists("TaxFunction"))
TaxFunction();
*/
}
$rep->End();
}