Файловый менеджер

Файловый менеджер - Редактировать - /home/lmsyaran/public_html/administrator/components/com_rsmembership/models/subscriptions.php

Назад
<?php /** * @package RSMembership! * @copyright (c) 2009 - 2016 RSJoomla! * @link https://www.rsjoomla.com * @license GNU General Public License http://www.gnu.org/licenses/gpl-3.0.en.html */ defined('_JEXEC') or die('Restricted access'); class RSMembershipModelSubscriptions extends JModelList { protected $context = null; public function __construct($config = array()) { if (empty($config['filter_fields'])) { $config['filter_fields'] = array('ms.user_id', 'u.username', 'u.email', 'ms.membership_start', 'ms.membership_end', 'm.name', 'category_name', 'ms.status', 'ms.notified', 'ms.published'); } $config['ignore_request'] = false; parent::__construct($config); } public function getContext() { return $this->context; } protected function getListQuery() { $db = JFactory::getDBO(); $query = $db->getQuery(true); $query ->select($db->qn('ms.id')) ->select($db->qn('ms.user_id')) ->select($db->qn('m.name')) ->select($db->qn('m.category_id')) ->select($db->qn('c.name', 'category_name')) ->select($db->qn('ms.extras')) ->select($db->qn('u.username')) ->select($db->qn('u.email')) ->select($db->qn('ms.status')) ->select($db->qn('ms.notified')) ->select($db->qn('ms.membership_start')) ->select($db->qn('ms.membership_end')) ->select($db->qn('ms.published')) ->select($db->qn('ms.membership_id')) ->from($db->qn('#__rsmembership_membership_subscribers', 'ms')) ->join('left', $db->qn('#__users','u').' ON '.$db->qn('u.id').' = '.$db->qn('ms.user_id')) ->join('left', $db->qn('#__rsmembership_memberships', 'm').' ON '.$db->qn('ms.membership_id').' = '.$db->qn('m.id')) ->join('left',$db->qn('#__rsmembership_categories', 'c').' ON '.$db->qn('m.category_id').' = '.$db->qn('c.id')); // search filter $where = ""; $filter_word = $this->getState($this->context.'.filter.filter_search'); if ( strlen($filter_word) ) { $where .= "( "; $where .= $db->qn('u.email').' LIKE '.$db->q('%'.$filter_word.'%').' OR '; $where .= $db->qn('u.username').' LIKE '.$db->q('%'.$filter_word.'%').' OR '; $where .= $db->qn('u.name').' LIKE '.$db->q('%'.$filter_word.'%'); $where .= " )"; } // status filter $filter_status = $this->getState($this->context.'.filter.filter_status'); if (is_numeric($filter_status)) $where .= ($where!='' ? ' AND ': '').$db->qn('ms.status') . ' = ' . $db->q($filter_status); // membersips filter $filter_memberships = $this->getState($this->context.'.filter.filter_memberships'); $filter_resetselected = $this->getState($this->context.'.filter.filter_resetselected'); // reset memberships filter if($filter_resetselected == '0') { if (is_array($filter_memberships)) { $where .= ($where!='' ? ' AND (': '('); foreach ($filter_memberships as $membership) { $where .= $db->qn('ms.membership_id') . ' = ' . $db->q($membership).' OR '; } $where = substr($where, 0 , -4); $where .= " )"; } } if ($where) { $query->where($where); } $listOrdering = $this->getState('list.ordering', 'ms.user_id'); $listDirection = $this->getState('list.direction', 'ASC'); $query->order($db->qn($listOrdering).' '.$db->escape($listDirection)); return $query; } protected function populateState($ordering = null, $direction = null) { $app = JFactory::getApplication(); $this->setState($this->context.'.filter.filter_search', $app->getUserStateFromRequest($this->context.'.filter_search', 'filter_search')); $this->setState($this->context.'.filter.filter_status', $app->getUserStateFromRequest($this->context.'.filter_status', 'filter_status')); $this->setState($this->context.'.filter.filter_memberships', $app->getUserStateFromRequest($this->context.'.filter_memberships', 'filter_memberships')); $this->setState($this->context.'.filter.filter_resetselected', $app->getUserStateFromRequest($this->context.'.filter_resetselected', 'filter_resetselected')); parent::populateState('ms.user_id', 'ASC'); } public function getFilterBar() { require_once JPATH_COMPONENT.'/helpers/adapters/filterbar.php'; // Search filter $options['search'] = array( 'label' => JText::_('JSEARCH_FILTER'), 'value' => $this->getState($this->context.'.filter.filter_search') ); $options['listOrder'] = $this->getState('list.ordering', 'ms.user_id'); $options['listDirn'] = $this->getState('list.direction', 'ASC'); $options['sortFields'] = array( JHtml::_('select.option', 'ms.user_id', JText::_('COM_RSMEMBERSHIP_SUBSCRIBER_ID')), JHtml::_('select.option', 'u.username', JText::_('COM_RSMEMBERSHIP_USERNAME')), JHtml::_('select.option', 'u.email', JText::_('COM_RSMEMBERSHIP_EMAIL')), JHtml::_('select.option', 'ms.membership_start', JText::_('COM_RSMEMBERSHIP_START_DATE')), JHtml::_('select.option', 'ms.membership_end', JText::_('COM_RSMEMBERSHIP_START_END')), JHtml::_('select.option', 'ms.status', JText::_('COM_RSMEMBERSHIP_STATUS')), JHtml::_('select.option', 'ms.notified', JText::_('COM_RSMEMBERSHIP_NOTIFIED')), JHtml::_('select.option', 'm.name', JText::_('COM_RSMEMBERSHIP_MEMBERSHIP')), JHtml::_('select.option', 'category_name', JText::_('COM_RSMEMBERSHIP_CATEGORY_NAME')), JHtml::_('select.option', 'ms.published', JText::_('JPUBLISHED')) ); $options['limitBox'] = $this->getPagination()->getLimitBox(); $options['filter_status'] = $this->getState($this->context.'.filter.filter_status'); $statuses = array(MEMBERSHIP_STATUS_ACTIVE, MEMBERSHIP_STATUS_PENDING, MEMBERSHIP_STATUS_EXPIRED, MEMBERSHIP_STATUS_CANCELLED); $options['statuses'][] = JHtml::_('select.option', '', JText::_('COM_RSMEMBERSHIP_SELECT_STATUS')); foreach ( $statuses as $status ) { $options['statuses'][] = JHtml::_('select.option', $status, JText::_('COM_RSMEMBERSHIP_STATUS_'.$status)); } // Joomla 2.5 $options['rightItems'] = array( array( 'input' => '<select name="filter_status" class="inputbox" onchange="this.form.submit()">'."\n" .JHtml::_('select.options', $options['statuses'], 'value', 'text', $options['filter_status'], false)."\n" .'</select>' ) ); $bar = new RSFilterBar($options); return $bar; } public function getSideBar() { require_once JPATH_COMPONENT.'/helpers/toolbar.php'; // Status filter $options['filter_status'] = $this->getState($this->context.'.filter.filter_status'); $statuses = array(MEMBERSHIP_STATUS_ACTIVE, MEMBERSHIP_STATUS_PENDING, MEMBERSHIP_STATUS_EXPIRED, MEMBERSHIP_STATUS_CANCELLED); foreach ( $statuses as $status ) { $options['statuses'][] = JHtml::_('select.option', $status, JText::_('COM_RSMEMBERSHIP_STATUS_'.$status)); } RSMembershipToolbarHelper::addFilter( JText::_('COM_RSMEMBERSHIP_SELECT_STATUS'), 'filter_status', JHtml::_('select.options', $options['statuses'], 'value', 'text', $options['filter_status'], true) ); return RSMembershipToolbarHelper::render(); } public function getMemberships() { $db = JFactory::getDBO(); $query = $db->getQuery(true); $query ->select($db->qn('id')) ->select($db->qn('name')) ->from($db->qn('#__rsmembership_memberships')) ->where($db->qn('published')." = 1") ->order($db->qn('ordering').' ASC'); $db->setQuery($query); $memberships = $db->loadObjectList(); return $memberships; } public function getTotalItems() { $query = $this->getListQuery(); $db = JFactory::getDbo(); $query->clear('select') ->clear('order') ->select('COUNT('.$db->qn('ms.id').')'); return (int) $db->setQuery($query)->loadResult(); } public function writeCSV($from, $fileHash = '') { require_once JPATH_COMPONENT.'/helpers/export.php'; // setting the function arguments $query = $this->getListQuery(); $totalItems = (int) $this->getTotalItems(); $filename = JText::_('COM_RSMEMBERSHIP_SUBSCRIPTIONS'); $type = 'subscriptions'; return RSMembershipExport::writeCSV($type, $query, $totalItems, $from, $fileHash, $filename); } public function getExtraValues() { $cache = RSMembershipHelper::getCache(); return $cache->extra_values; } }

| ver. 1.4 | Github | . | PHP 8.1.33 | Генерация страницы: 0 | proxy | phpinfo | Настройка