Optimized database indexes.

[fa-stable.git] / reporting / includes / reports_classes.inc

diff --git a/reporting/includes/reports_classes.inc b/reporting/includes/reports_classes.inc
index 4069c873b9c8f30bf881bc75f70f70c420058b87..ec1d59111dd309e45aaf46c875e5032e7907c541 100644 (file)
--- a/reporting/includes/reports_classes.inc
+++ b/reporting/includes/reports_classes.inc
@@ -12,6 +12,7 @@
 class BoxReports
 {
        var $ar_classes;
+       var $ctrl_handlers = array();
 
        function ReportClasses()
        {
@@ -229,8 +230,6 @@ class BoxReports
                                        return "<textarea rows=4 cols=30 name='$name'></textarea>";
 
                                case 'ACCOUNTS': // not used
-//                                     $sql = "SELECT id, name FROM ".TB_PREF."chart_types";
-//                                     return combo_input($name, '', $sql, 'id', 'name',array('spec_option'=>_("No Account Group Filter"),'spec_id'=>ALL_NUMERIC));
                                        return gl_account_types_list($name, null, _("No Account Group Filter"), true);
 
                                case 'ACCOUNTS_NO_FILTER': // not used
@@ -349,10 +348,7 @@ class BoxReports
                                        return sales_persons_list($name, null, _("No Sales Folk Filter"));
                                        
                                case 'TRANS_YEARS':
-                                       $sql = "SELECT DISTINCT YEAR(tran_date) AS tran_date, YEAR(tran_date) AS tran_date2 FROM ".TB_PREF."gl_trans";
-                                       return combo_input($name, '', $sql, 'tran_date', 'tran_date2',array('order'=>array('tran_date')));
-// FIX shouldn't it be fiscal year selector?
-//                                     return fiscalyears_list($name);
+                                       return fiscalyears_list($name);
 
                                case 'USERS':
                                        $sql = "SELECT id, user_id FROM ".TB_PREF."users";
@@ -377,7 +373,6 @@ class Report
        var $name;
        var $ar_params;
        var $controls;
-       var $ctrl_handlers = array();
        
        function Report($id, $name, $ar_params = null)
        {