.
***********************************************************************/
$page_security = 'SA_TAXREP';
$path_to_root="../..";
include_once($path_to_root . "/includes/session.inc");
include_once($path_to_root . "/includes/date_functions.inc");
include_once($path_to_root . "/includes/ui.inc");
include_once($path_to_root . "/includes/data_checks.inc");
include_once($path_to_root . "/gl/includes/gl_db.inc");
$js = '';
set_focus('account');
if ($SysPrefs->use_popup_windows)
$js .= get_js_open_window(800, 500);
if (user_use_date_picker())
$js .= get_js_date_picker();
page(_($help_context = "Tax Inquiry"), false, false, '', $js);
//----------------------------------------------------------------------------------------------------
// Ajax updates
//
if (get_post('Show'))
{
$Ajax->activate('trans_tbl');
}
if (get_post('TransFromDate') == "" && get_post('TransToDate') == "")
{
$date = Today();
$row = get_company_prefs();
$edate = add_months($date, -$row['tax_last']);
$edate = end_month($edate);
$bdate = begin_month($edate);
$bdate = add_months($bdate, -$row['tax_prd'] + 1);
$_POST["TransFromDate"] = $bdate;
$_POST["TransToDate"] = $edate;
}
//----------------------------------------------------------------------------------------------------
function tax_inquiry_controls()
{
start_form();
start_table(TABLESTYLE_NOBORDER);
start_row();
date_cells(_("from:"), 'TransFromDate', '', null, -user_transaction_days());
date_cells(_("to:"), 'TransToDate');
submit_cells('Show',_("Show"),'','', 'default');
end_row();
end_table();
end_form();
}
//----------------------------------------------------------------------------------------------------
function show_results()
{
global $path_to_root;
/*Now get the transactions */
div_start('trans_tbl');
start_table(TABLESTYLE);
$th = array(_("Type"), _("Description"), _("Amount"), _("Outputs")."/"._("Inputs"));
table_header($th);
$k = 0;
$total = 0;
$bdate = date2sql($_POST['TransFromDate']);
$edate = date2sql($_POST['TransToDate']);
$taxes = get_tax_summary($_POST['TransFromDate'], $_POST['TransToDate']);
while ($tx = db_fetch($taxes))
{
$payable = $tx['payable'];
$collectible = $tx['collectible'];
$net = $collectible + $payable;
$total += $net;
alt_table_row_color($k);
label_cell($tx['name'] . " " . $tx['rate'] . "%");
label_cell(_("Charged on sales") . " (" . _("Output Tax")."):");
amount_cell($payable);
amount_cell($tx['net_output']);
end_row();
alt_table_row_color($k);
label_cell($tx['name'] . " " . $tx['rate'] . "%");
label_cell(_("Paid on purchases") . " (" . _("Input Tax")."):");
amount_cell($collectible);
amount_cell($tx['net_input']);
end_row();
alt_table_row_color($k);
label_cell("".$tx['name'] . " " . $tx['rate'] . "%");
label_cell(""._("Net payable or collectible") . ":");
amount_cell($net, true);
label_cell("");
end_row();
}
alt_table_row_color($k);
label_cell("");
label_cell(""._("Total payable or refund") . ":");
amount_cell($total, true);
label_cell("");
end_row();
end_table(2);
div_end();
}
//----------------------------------------------------------------------------------------------------
tax_inquiry_controls();
show_results();
//----------------------------------------------------------------------------------------------------
end_page();