public function getInput() { $options = array(); $multiple = $this->element['multiple'] ? 'multiple="multiple"' : ''; $size = $this->element['size'] ? 'size="' . $this->element['size'] . '"' : ''; $onchange = $this->element['onchange'] ? 'onchange="' . $this->element['onchange'] . '"' : ''; $all_membs = RSMembershipHelper::getMembershipsList(); $options = array_merge($options, $all_membs); return JHTML::_('select.genericlist', $options, $this->name, 'class="' . $this->element['class'] . '" ' . $onchange . ' ' . $multiple . ' ' . $size, 'value', 'text', $this->value, $this->id); }
public function _getDefaultFilters() { $db = JFactory::getDBO(); $query = $db->getQuery(true); $filters = array(); // set the default values for fields in xml $filters['report'] = 'report_2'; $filters['from_date'] = ''; $filters['to_date'] = RSMembershipHelper::showDate(JFactory::getDate()->toUnix(), 'Y-m-d'); $filters['unit'] = 'day'; $filters['user_id'] = ''; $filters['memberships'] = array_keys(RSMembershipHelper::getMembershipsList(false)); $filters['status_memberships'] = array(0, 1, 2, 3); $filters['status_transactions'] = array('pending', 'completed', 'denied'); $filters['price_from'] = 0; $filters['price_to'] = ''; $filters['transaction_types'] = array('new', 'upgrade', 'addextra', 'renew'); $query->select('DISTINCT(gateway)')->from($db->qn('#__rsmembership_transactions'))->order($db->qn('gateway') . ' ASC'); $db->setQuery($query); $filters['gateways'] = $db->loadColumn(); return $filters; }