Esempio n. 1
0
 public function index()
 {
     if (isset($this->state->filter->plan) && $this->state->filter->plan > 0) {
         $mis = microIntegrationHandler::getMIsbyPlan($this->state->filter->plan);
         if (!empty($mis)) {
             $this->addConstraint("id IN (" . implode(',', $mis) . ")");
         } else {
             $this->state->filter->plan = "";
         }
     }
     $rows = $this->getRows();
     foreach ($rows as $rid => $row) {
         if (!empty($row->desc)) {
             $rows[$rid]->desc = stripslashes(strip_tags($row->desc));
             if (strlen($rows[$rid]->desc) > 50) {
                 $rows[$rid]->desc = substr($rows[$rid]->desc, 0, 50) . ' ...';
             }
         }
     }
     $sel = array();
     $sel[] = JHTML::_('select.option', 'ordering ASC', JText::_('ORDERING_ASC'));
     $sel[] = JHTML::_('select.option', 'ordering DESC', JText::_('ORDERING_DESC'));
     $sel[] = JHTML::_('select.option', 'id ASC', JText::_('ID_ASC'));
     $sel[] = JHTML::_('select.option', 'id DESC', JText::_('ID_DESC'));
     $sel[] = JHTML::_('select.option', 'name ASC', JText::_('NAME_ASC'));
     $sel[] = JHTML::_('select.option', 'name DESC', JText::_('NAME_DESC'));
     $sel[] = JHTML::_('select.option', 'class_name ASC', JText::_('CLASSNAME_ASC'));
     $sel[] = JHTML::_('select.option', 'class_name DESC', JText::_('CLASSNAME_DESC'));
     $lists['orderNav'] = JHTML::_('select.genericlist', $sel, 'orderby_mi', 'class="inputbox" size="1" onchange="document.adminForm.submit();"', 'value', 'text', $this->state->sort);
     // Get list of plans for filter
     $query = 'SELECT `id`, `name`' . ' FROM #__acctexp_plans' . ' ORDER BY `ordering`';
     $this->db->setQuery($query);
     $db_plans = $this->db->loadObjectList();
     $plans[] = JHTML::_('select.option', '0', JText::_('FILTER_PLAN'), 'id', 'name');
     if (is_array($db_plans)) {
         $plans = array_merge($plans, $db_plans);
     }
     $lists['filter_planid'] = JHTML::_('select.genericlist', $plans, 'planid', 'class="inputbox" size="1" onchange="document.adminForm.submit();"', 'id', 'name', $this->state->filter->plan);
     HTML_AcctExp::listMicroIntegrations($rows, $this->state, $this->getPagination(), $lists);
 }