Standard sql separator in date functions.

[fa-stable.git] / gl / inquiry / gl_account_inquiry.php

diff --git a/gl/inquiry/gl_account_inquiry.php b/gl/inquiry/gl_account_inquiry.php
index 0b0c2709a93ee5aa5e69163e376eeeb16d83fdc7..6f1378a890730d1c732ba6a656d53e9a547073bb 100644 (file)
--- a/gl/inquiry/gl_account_inquiry.php
+++ b/gl/inquiry/gl_account_inquiry.php
@@ -21,6 +21,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 +56,7 @@ function gl_inquiry_controls()
 
        date_cells(_("from:"), 'TransFromDate', '', null, -30);
        date_cells(_("to:"), 'TransToDate');
-    submit_cells('Show',_("Show"));
+       submit_cells('Show',_("Show"),'','', true);
 
     end_row();
 
@@ -83,6 +89,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"]. "   ".$act_name);
 
@@ -102,7 +109,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);
        }
@@ -159,6 +166,7 @@ function show_results()
        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();
 }
 
 //----------------------------------------------------------------------------------------------------