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;
}
