= '$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;
start_table($table_style);
$tableheader = "
";
echo $tableheader;
$k = 0;
$accounts = get_gl_accounts();
while ($account = db_fetch($accounts))
{
if (is_account_balancesheet($account["account_code"]))
$begin = null;
else
{
$begin = begin_fiscalyear();
if ($_POST['TransFromDate'] < $begin)
$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;
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();
}
end_table(1);
}
//----------------------------------------------------------------------------------------------------
gl_inquiry_controls();
display_trial_balance();
//----------------------------------------------------------------------------------------------------
end_page();
?>