page(_("Trial Balance"), false, false, "", $js);
//----------------------------------------------------------------------------------------------------
+// Ajax updates
+//
+if (get_post('Show'))
+{
+ $Ajax->activate('balance_tbl');
+}
function gl_inquiry_controls()
start_table("class='tablestyle_noborder'");
- date_cells(_("From:"), 'TransFromDate', null, -30);
+ date_cells(_("From:"), 'TransFromDate', '', null, -30);
date_cells(_("To:"), 'TransToDate');
check_cells(_("No zero values"), 'NoZero', null);
- submit_cells('Show',_("Show"));
+ submit_cells('Show',_("Show"),'','', true);
end_table();
end_form();
}
{
global $table_style, $path_to_root;
+ div_start('balance_tbl');
start_table($table_style);
$tableheader = "<tr>
<td rowspan=2 class='tableheader'>" . _("Account") . "</td>
$k = 0;
+ $totprev = $totcurr = 0.0;
$accounts = get_gl_accounts();
while ($account = db_fetch($accounts))
$begin = null;
else
{
- if ($from < $begin)
- $begin = add_days($_POST['TransFromDate'], -1);
- else
- $begin = add_days(begin_fiscalyear(), -1);
+ $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 = "<a href='$path_to_root/gl/inquiry/gl_account_inquiry.php?" . SID . "TransFromDate=" . $_POST["TransFromDate"] . "&TransToDate=" . $_POST["TransToDate"] . "&account=" . $account["account_code"] . "'>" . $account["account_code"] . "</a>";
display_debit_or_credit_cells($prev_balance + $curr_balance);
end_row();
}
+ start_row("class='inquirybg'");
+ label_cell("<b>" . _("Ending Balance") ." - ".$_POST['TransToDate']. "</b>", "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();
}
//----------------------------------------------------------------------------------------------------