activate('balance_tbl');
}
function gl_inquiry_controls()
{
start_form();
start_table("class='tablestyle_noborder'");
date_cells(_("From:"), 'TransFromDate', '', null, -30);
date_cells(_("To:"), 'TransToDate');
check_cells(_("No zero values"), 'NoZero', null);
submit_cells('Show',_("Show"),'','', true);
end_table();
end_form();
}
//----------------------------------------------------------------------------------------------------
function get_balance($account, $from, $to, $from_incl=true, $to_incl=true) {
$sql = "SELECT SUM(amount) As TransactionSum FROM ".TB_PREF."gl_trans
WHERE account='$account'";
if ($from)
{
$from_date = date2sql($from);
if ($from_incl)
$sql .= " AND tran_date >= '$from_date'";
else
$sql .= " AND tran_date > '$from_date'";
}
if ($to)
{
$to_date = date2sql($to);
if ($to_incl)
$sql .= " AND tran_date <= '$to_date' ";
else
$sql .= " AND tran_date < '$to_date' ";
}
$result = db_query($sql,"No general ledger accounts were returned");
$row = db_fetch_row($result);
return $row[0];
}
//----------------------------------------------------------------------------------------------------
function display_trial_balance()
{
global $table_style, $path_to_root;
div_start('balance_tbl');
start_table($table_style);
$tableheader = "
";
echo $tableheader;
$k = 0;
$totprev = $totcurr = 0.0;
$accounts = get_gl_accounts();
while ($account = db_fetch($accounts))
{
if (is_account_balancesheet($account["account_code"]))
$begin = null;
else
{
$begin = begin_fiscalyear();
if (date1_greater_date2($begin, $_POST['TransFromDate']))
$begin = $_POST['TransFromDate'];
$begin = add_days($begin, -1);
}
$prev_balance = get_balance($account["account_code"], $begin, $_POST['TransFromDate'], false, false);
$curr_balance = get_balance($account["account_code"], $_POST['TransFromDate'], $_POST['TransToDate']);
if (check_value("NoZero") && !$prev_balance && !$curr_balance)
continue;
$totprev += $prev_balance;
$totcurr += $curr_balance;
alt_table_row_color($k);
$url = "" . $account["account_code"] . "";
label_cell($url);
label_cell($account["account_name"]);
display_debit_or_credit_cells($prev_balance);
display_debit_or_credit_cells($curr_balance);
display_debit_or_credit_cells($prev_balance + $curr_balance);
end_row();
}
start_row("class='inquirybg'");
label_cell("" . _("Ending Balance") ." - ".$_POST['TransToDate']. "", "colspan=2");
display_debit_or_credit_cells($totprev);
display_debit_or_credit_cells($totcurr);
display_debit_or_credit_cells($totprev + $totcurr);
end_row();
end_table(1);
div_end();
}
//----------------------------------------------------------------------------------------------------
gl_inquiry_controls();
display_trial_balance();
//----------------------------------------------------------------------------------------------------
end_page();
?>