X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=gl%2Finquiry%2Fgl_trial_balance.php;h=969cfcca0dd6c8030c6877e3afe950de87456d16;hb=4d5c386a745f07e2f937c5a3fcfffdb431551cc5;hp=28653ff0e57d6327ebff246fa2a093d19b98d284;hpb=da8311619dd73feae101d246a1957b972e00cbd2;p=fa-stable.git diff --git a/gl/inquiry/gl_trial_balance.php b/gl/inquiry/gl_trial_balance.php index 28653ff0..969cfcca 100644 --- a/gl/inquiry/gl_trial_balance.php +++ b/gl/inquiry/gl_trial_balance.php @@ -5,15 +5,25 @@ $path_to_root="../.."; include_once($path_to_root . "/includes/session.inc"); -page(_("Trial Balance")); - include_once($path_to_root . "/includes/date_functions.inc"); include_once($path_to_root . "/includes/ui.inc"); include_once($path_to_root . "/includes/data_checks.inc"); include_once($path_to_root . "/gl/includes/gl_db.inc"); +$js = ""; +if ($use_date_picker) + $js = get_js_date_picker(); + +page(_("Trial Balance"), false, false, "", $js); + //---------------------------------------------------------------------------------------------------- +// Ajax updates +// +if (get_post('Show')) +{ + $Ajax->activate('balance_tbl'); +} function gl_inquiry_controls() @@ -22,11 +32,11 @@ 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(); } @@ -36,9 +46,9 @@ function gl_inquiry_controls() 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"; + WHERE account='$account'"; - if ($from) + if ($from) { $from_date = date2sql($from); if ($from_incl) @@ -47,7 +57,7 @@ function get_balance($account, $from, $to, $from_incl=true, $to_incl=true) { $sql .= " AND tran_date > '$from_date'"; } - if ($to) + if ($to) { $to_date = date2sql($to); if ($to_incl) @@ -68,6 +78,7 @@ function display_trial_balance() { global $table_style, $path_to_root; + div_start('balance_tbl'); start_table($table_style); $tableheader = "