function print_sales_summary_report()
{
global $path_to_root;
$from = $_POST['PARAM_0'];
$to = $_POST['PARAM_1'];
$tax_id = $_POST['PARAM_2'];
$comments = $_POST['PARAM_3'];
$orientation = $_POST['PARAM_4'];
$destination = $_POST['PARAM_5'];
if ($tax_id == 0) {
$tid = _('No');
} else {
$tid = _('Yes');
}
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(_('Sales Summary Report'), "SalesSummaryReport", user_pagesize(), 9, $orientation);
$params = array(0 => $comments, 1 => array('text' => _('Period'), 'from' => $from, 'to' => $to), 2 => array('text' => _('Tax Id Only'), 'from' => $tid, 'to' => ''));
$cols = array(0, 130, 180, 270, 350, 400, 500);
$headers = array(_('Customer'), _('Total ex. Tax'), _('Tax'), _('Total'), _('Balance'), _('Due'));
$aligns = array('left', 'left', 'right', 'right', 'right', 'right');
if ($orientation == 'L') {
recalculate_cols($cols);
}
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->NewPage();
$totalnet = 0.0;
$totaltax = 0.0;
$transactions = getTaxTransactions($from, $to, $tax_id);
$rep->TextCol(0, 4, _('Balances in Home Currency'));
$rep->NewLine(2);
$custno = 0;
$tax = $total = 0;
$custname = $tax_id = "";
while ($trans = db_fetch($transactions)) {
$customer_record = get_customer_details($custno);
$customer_crm = getPhone($custno);
if ($custno != $trans['debtor_no']) {
if ($custno != 0) {
$rep->TextCol(0, 1, $custname);
//$rep->TextCol(1, 2, $tax_id);
$rep->TextCol(1, 2, $custno, $dec);
$rep->TextCol(2, 3, $trans['debtor_no'], $dec);
$rep->TextCol(3, 4, $customer_crm['phone'], $dec);
$rep->AmountCol(4, 5, $tax + $total, $dec);
$rep->AmountCol(5, 6, $customer_record["Balance"], $dec);
$totalnet += $total;
$totaltax += $tax;
$total = $tax = 0;
$rep->NewLine();
if ($rep->row < $rep->bottomMargin + $rep->lineHeight) {
$rep->Line($rep->row - 2);
$rep->NewPage();
}
}
$custno = $trans['debtor_no'];
$custname = $trans['cust_name'];
$tax_id = $trans['tax_id'];
}
$taxes = getTaxes($trans['type'], $trans['trans_no']);
if ($taxes != null) {
if ($taxes['included_in_price']) {
$trans['total'] -= $taxes['tax'];
}
$tax += $taxes['tax'];
}
$total += $trans['total'];
}
if ($custno != 0) {
$customer_record = get_customer_details($custno);
$rep->TextCol(0, 1, $custname);
//$rep->TextCol(1, 2, $tax_id);
$rep->AmountCol(1, 2, $total, $dec);
$rep->AmountCol(2, 3, $tax, $dec);
$rep->AmountCol(3, 4, $tax + $total, $dec);
$rep->AmountCol(4, 5, $customer_record["Balance"], $dec);
$rep->AmountCol(5, 6, $customer_record["Due"], $dec);
$totalnet += $total;
$totaltax += $tax;
$rep->NewLine();
}
$rep->Font('bold');
$rep->NewLine();
$rep->Line($rep->row + $rep->lineHeight);
$rep->TextCol(0, 1, _("Total"));
$rep->AmountCol(1, 2, $totalnet, $dec);
$rep->AmountCol(2, 3, $totaltax, $dec);
$rep->AmountCol(3, 4, $totaltax + $totalnet, $dec);
$rep->Line($rep->row - 5);
$rep->Font();
$rep->End();
}
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();
}