<?php
-
+/**********************************************************************
+ Copyright (C) FrontAccounting, LLC.
+ Released under the terms of the GNU General Public License, GPL,
+ as published by the Free Software Foundation, either version 3
+ of the License, or (at your option) any later version.
+ This program is distributed in the hope that it will be useful,
+ but WITHOUT ANY WARRANTY; without even the implied warranty of
+ MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
+ See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
+***********************************************************************/
$page_security = 8;
$path_to_root="../..";
include_once($path_to_root . "/includes/session.inc");
include_once($path_to_root . "/gl/includes/gl_db.inc");
-$js = get_js_set_focus('account');
+$js = '';
+set_focus('account');
if ($use_popup_windows)
$js .= get_js_open_window(800, 500);
+if ($use_date_picker)
+ $js .= get_js_date_picker();
-page(_("General Ledger Account Inquiry"), false, false, "setFocus()", $js);
+page(_("General Ledger Account Inquiry"), false, false, '', $js);
//----------------------------------------------------------------------------------------------------
+// Ajax updates
+//
+if (get_post('Show'))
+{
+ $Ajax->activate('trans_tbl');
+}
if (isset($_GET["account"]))
$_POST["account"] = $_GET["account"];
function gl_inquiry_controls()
{
global $table_style2;
-
+
$dim = get_company_pref('use_dimension');
start_form();
//start_table($table_style2);
start_table("class='tablestyle_noborder'");
start_row();
-
+
gl_all_accounts_list_cells(_("Account:"), 'account', null);
- date_cells(_("from:"), 'TransFromDate', null, -30);
+ date_cells(_("from:"), 'TransFromDate', '', null, -30);
date_cells(_("to:"), 'TransToDate');
- submit_cells('Show',_("Show"));
-
+ submit_cells('Show',_("Show"),'','', 'default');
+
end_row();
if ($dim >= 1)
if ($dim > 1)
dimensions_list_row(_("Dimension")." 2", 'Dimension2', null, true, " ", false, 2);
end_table();
-
+
end_form();
}
$result = get_gl_transactions($_POST['TransFromDate'], $_POST['TransToDate'], -1,
$_POST["account"], $_POST['Dimension'], $_POST['Dimension2']);
- if (db_num_rows($result) == 0)
- {
- display_note(_("No general ledger transactions have been created for this account on the selected dates."), 0, 1);
- return;
- }
$colspan = ($dim == 2 ? "6" : ($dim == 1 ? "5" : "4"));
+ div_start('trans_tbl');
//echo "\nDimension =". $_POST['Dimension'];
display_heading($_POST["account"]. " ".$act_name);
else if ($dim == 1)
$th = array(_("Type"), _("#"), _("Date"), _("Dimension"),
_("Person/Item"), _("Debit"), _("Credit"), _("Balance"), _("Memo"));
- else
- $th = array(_("Type"), _("#"), _("Date"),
+ else
+ $th = array(_("Type"), _("#"), _("Date"),
_("Person/Item"), _("Debit"), _("Credit"), _("Balance"), _("Memo"));
table_header($th);
- $bfw = get_gl_balance_from_to("", $_POST['TransFromDate'], $_POST["account"], $_POST['Dimension'], $_POST['Dimension2']);
+ if (is_account_balancesheet($_POST["account"]))
+ $begin = "";
+ else
+ {
+ $begin = begin_fiscalyear();
+ if (date1_greater_date2($begin, $_POST['TransFromDate']))
+ $begin = $_POST['TransFromDate'];
+ $begin = add_days($begin, -1);
+ }
+
+ $bfw = get_gl_balance_from_to($begin, $_POST['TransFromDate'], $_POST["account"], $_POST['Dimension'], $_POST['Dimension2']);
start_row("class='inquirybg'");
label_cell("<b>"._("Opening Balance")." - ".$_POST['TransFromDate']."</b>", "colspan=$colspan");
display_debit_or_credit_cells($bfw);
label_cell("");
+ label_cell("");
end_row();
//$running_total =0;
$running_total = $bfw;
$j = 1;
$k = 0; //row colour counter
- while ($myrow = db_fetch($result))
+ while ($myrow = db_fetch($result))
{
alt_table_row_color($k);
$j++;
if ($j == 12)
- {
- $j = 1;
+ {
+ $j = 1;
table_header($th);
}
}
label_cell("<b>" . _("Ending Balance") ." - ".$_POST['TransToDate']. "</b>", "colspan=$colspan");
display_debit_or_credit_cells($running_total);
label_cell("");
+ label_cell("");
end_row();
end_table(2);
+ if (db_num_rows($result) == 0)
+ display_note(_("No general ledger transactions have been created for this account on the selected dates."), 0, 1);
+ div_end();
}
//----------------------------------------------------------------------------------------------------