X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=gl%2Finquiry%2Fbank_inquiry.php;h=e287d77bfcad714654a60b0ba8a64fae550c30cd;hb=ac93b30fdf9beabafa02a577a0f7db62eb703672;hp=d5147f5ff1ecc624ff4fa66ef9b1e1c7534c8574;hpb=45e45a854c40a7a2f9cc8f11e07a259c6923babd;p=fa-stable.git diff --git a/gl/inquiry/bank_inquiry.php b/gl/inquiry/bank_inquiry.php index d5147f5f..e287d77b 100644 --- a/gl/inquiry/bank_inquiry.php +++ b/gl/inquiry/bank_inquiry.php @@ -1,6 +1,15 @@ . +***********************************************************************/ +$page_security = 'SA_BANKTRANSVIEW'; $path_to_root="../.."; include_once($path_to_root . "/includes/session.inc"); @@ -37,7 +46,7 @@ bank_accounts_list_cells(_("Account:"), 'bank_account', null); date_cells(_("From:"), 'TransAfterDate', '', null, -30); date_cells(_("To:"), 'TransToDate'); -submit_cells('Show',_("Show"),'','', true); +submit_cells('Show',_("Show"),'','', 'default'); end_row(); end_table(); end_form(); @@ -63,7 +72,7 @@ display_heading($act['bank_account_name']." - ".$act['bank_curr_code']); start_table($table_style); -$th = array(_("Type"), _("#"), _("Reference"), _("Type"), _("Date"), +$th = array(_("Type"), _("#"), _("Reference"), _("Date"), _("Debit"), _("Credit"), _("Balance"), _("Person/Item"), ""); table_header($th); @@ -72,11 +81,12 @@ $sql = "SELECT SUM(amount) FROM ".TB_PREF."bank_trans WHERE bank_act='" . $_POST $before_qty = db_query($sql, "The starting balance on hand could not be calculated"); start_row("class='inquirybg'"); -label_cell(""._("Opening Balance")." - ".$_POST['TransAfterDate']."", "colspan=5"); +label_cell(""._("Opening Balance")." - ".$_POST['TransAfterDate']."", "colspan=4"); $bfw_row = db_fetch_row($before_qty); $bfw = $bfw_row[0]; display_debit_or_credit_cells($bfw); label_cell(""); +label_cell("", "colspan=2"); end_row(); $running_total = $bfw; @@ -110,9 +120,10 @@ while ($myrow = db_fetch($result)) //end of while loop start_row("class='inquirybg'"); -label_cell("" . _("Ending Balance")." - ". $_POST['TransToDate']. "", "colspan=5"); +label_cell("" . _("Ending Balance")." - ". $_POST['TransToDate']. "", "colspan=4"); display_debit_or_credit_cells($running_total); label_cell(""); +label_cell("", "colspan=2"); end_row(); end_table(2); div_end();