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 a3a7cfad11921e214f1eb5ce47bbf2e815decc25..ec1d59111dd309e45aaf46c875e5032e7907c541 100644 (file)
--- a/reporting/includes/reports_classes.inc
+++ b/reporting/includes/reports_classes.inc
@@ -230,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
@@ -350,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";