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 = add_months($edate, -$row['tax_prd'] + 1); $_POST["TransFromDate"] = begin_month($bdate); $_POST["TransToDate"] = $edate; } //---------------------------------------------------------------------------------------------------- function get_tax_types() { $sql = "SELECT * FROM ".TB_PREF."tax_types ORDER BY id"; return db_query($sql,"No transactions were returned"); } function tax_inquiry_controls() { global $table_style2; start_form(); //start_table($table_style2); start_table("class='tablestyle_noborder'"); start_row(); date_cells(_("from:"), 'TransFromDate', '', null, -30); date_cells(_("to:"), 'TransToDate'); submit_cells('Show',_("Show"),'','', true); end_row(); end_table(); end_form(); } //---------------------------------------------------------------------------------------------------- function show_results() { global $path_to_root, $table_style; $taxes = get_tax_types(); /*Now get the transactions */ div_start('trans_tbl'); start_table($table_style); $th = array(_("Type"), _("Description"), _("Amount")); table_header($th); $k = 0; $total = 0; $bdate = date2sql($_POST['TransFromDate']); $edate = date2sql($_POST['TransToDate']); while ($tx = db_fetch($taxes)) { if ($tx['sales_gl_code'] == $tx['purchasing_gl_code']) { $sql = "SELECT SUM(IF(amount >= 0, amount, 0)) AS payable, SUM(IF(amount < 0, -amount, 0)) AS collectible FROM ".TB_PREF."gl_trans WHERE account = '".$tx['sales_gl_code']."' AND tran_date >= '$bdate' AND tran_date <= '$edate'"; $result = db_query($sql, "Error retrieving tax inquiry"); $row = db_fetch($result); $payable = -$row['payable']; $collectible.= -$row['collectible']; } else { $sql = "SELECT SUM(amount) AS collectible FROM ".TB_PREF."gl_trans WHERE account = '".$tx['sales_gl_code']."' AND tran_date >= '$bdate' AND tran_date <= '$edate'"; $result = db_query($sql, "Error retrieving tax inquiry"); $row = db_fetch($result); $collectible = -$row['collectible']; $sql = "SELECT SUM(amount) AS payable FROM ".TB_PREF."gl_trans WHERE account = '".$tx['purchasing_gl_code']."' AND tran_date >= '$bdate' AND tran_date <= '$edate'"; $result = db_query($sql, "Error retrieving tax inquiry"); $row = db_fetch($result); $payable = -$row['payable']; } $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($collectible); end_row(); alt_table_row_color($k); label_cell($tx['name'] . " " . $tx['rate'] . "%"); label_cell(_("Paid on purchases") . " (" . _("Input Tax")."):"); amount_cell($payable); end_row(); alt_table_row_color($k); label_cell($tx['name'] . " " . $tx['rate'] . "%"); label_cell(_("Net payable or collectible") . ":"); amount_cell($net, true); end_row(); } alt_table_row_color($k); label_cell(""); label_cell(""._("Total payable or refund") . ":"); amount_cell($total, true); end_row(); end_table(2); div_end(); } //---------------------------------------------------------------------------------------------------- tax_inquiry_controls(); show_results(); //---------------------------------------------------------------------------------------------------- end_page(); ?>