X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=gl%2Finquiry%2Fgl_account_inquiry.php;h=17a889075211ed8a028c70609ac125b7edae04b8;hb=ac93b30fdf9beabafa02a577a0f7db62eb703672;hp=0b0c2709a93ee5aa5e69163e376eeeb16d83fdc7;hpb=d67d5295b9342c011697ce4df325197e29898588;p=fa-stable.git

diff --git a/gl/inquiry/gl_account_inquiry.php b/gl/inquiry/gl_account_inquiry.php
index 0b0c2709..17a88907 100644
--- a/gl/inquiry/gl_account_inquiry.php
+++ b/gl/inquiry/gl_account_inquiry.php
@@ -1,7 +1,16 @@
 <?php
-
-$page_security = 8;
-$path_to_root="../..";
+/**********************************************************************
+    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 = 'SA_GLTRANSVIEW';
+$path_to_root = "../..";
 include_once($path_to_root . "/includes/session.inc");
 
 
@@ -21,6 +30,12 @@ if ($use_date_picker)
 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"];
@@ -50,7 +65,7 @@ function gl_inquiry_controls()
 
 	date_cells(_("from:"), 'TransFromDate', '', null, -30);
 	date_cells(_("to:"), 'TransToDate');
-    submit_cells('Show',_("Show"));
+	submit_cells('Show',_("Show"),'','', 'default');
 
     end_row();
 
@@ -83,6 +98,7 @@ function show_results()
     	$_POST["account"], $_POST['Dimension'], $_POST['Dimension2']);
 
 	$colspan = ($dim == 2 ? "6" : ($dim == 1 ? "5" : "4"));
+	div_start('trans_tbl');
 	//echo "\nDimension =". $_POST['Dimension'];
 	display_heading($_POST["account"]. "&nbsp;&nbsp;&nbsp;".$act_name);
 
@@ -102,7 +118,7 @@ function show_results()
 	else
 	{
 		$begin = begin_fiscalyear();
-		if ($_POST['TransFromDate'] < $begin)
+		if (date1_greater_date2($begin, $_POST['TransFromDate']))
 			$begin = $_POST['TransFromDate'];
 		$begin = add_days($begin, -1);
 	}
@@ -113,6 +129,7 @@ function show_results()
 	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;
@@ -154,11 +171,13 @@ function show_results()
 	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();
 }
 
 //----------------------------------------------------------------------------------------------------