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

Файловый менеджер - Редактировать - /home/lmsyaran/public_html/administrator/components/com_rsmembership/models/subscribers.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 RSMembershipModelSubscribers extends JModelList { protected $context = null; public function __construct($config = array()) { require_once JPATH_COMPONENT.'/helpers/rsmembership.php'; if (empty($config['filter_fields'])) { $config['filter_fields'] = array('mu.user_id', 'u.name', 'u.email', 'u.username', 'num_subs', 'num_activesubs'); if ($customFields = RSMembership::getCustomFields(array('showinsubscribers' => 1))) { foreach ($customFields as $field) { $config['filter_fields'][] = 'mu.f'.$field->id; } } } $config['ignore_request'] = false; parent::__construct($config); } protected function getListQuery() { $db = JFactory::getDBO(); $query = $db->getQuery(true); $customFields = RSMembership::getCustomFields(array()); $query ->select($db->qn('u.id')) ->select($db->qn('u.block')) ->select($db->qn('u.name')) ->select($db->qn('u.username')) ->select($db->qn('u.email')); if ($customFields) { foreach ($customFields as $properties) { if ($properties->showinsubscribers) { $query->select($db->qn('mu.f'.$properties->id, JText::_($properties->name))); } } } $subqueryActiveSubs = $db->getQuery(true) ->select('COUNT('.$db->qn('user_id').')') ->from($db->qn('#__rsmembership_membership_subscribers', 'activesubs')) ->where($db->qn('u.id').' = '.$db->qn('activesubs.user_id')) ->where($db->qn('activesubs.status').'='.$db->q(0)) ->where($db->qn('activesubs.published').'='.$db->q(1)); $subqueryTotalSubs = $db->getQuery(true) ->select('COUNT('.$db->qn('user_id').')') ->from($db->qn('#__rsmembership_membership_subscribers', 'subs')) ->where($db->qn('u.id').' = '.$db->qn('subs.user_id')); $query->select('('.$subqueryActiveSubs.') AS num_activesubs'); $query->select('('.$subqueryTotalSubs.') AS num_subs'); $query->from($db->qn('#__users','u')) ->join('left', $db->qn('#__rsmembership_subscribers', 'mu').' ON '.$db->qn('u.id').' = '.$db->qn('mu.user_id')) ->group($db->qn('u.id')); // search filter $filter_word = $this->getState($this->context.'.filter.filter_search'); if (strlen($filter_word)) { $query->where($db->qn('u.name').' LIKE '.$db->q('%'.$filter_word.'%'),'OR'); $query->where($db->qn('u.email').' LIKE '.$db->q('%'.$filter_word.'%'),'OR'); $query->where($db->qn('u.username').' LIKE '.$db->q('%'.$filter_word.'%'), 'OR'); if ($customFields) { foreach ($customFields as $properties) { $query->where($db->qn('mu.f'.$properties->id).' LIKE '.$db->q('%'.$filter_word.'%'), 'OR'); } } } $listOrdering = $this->getState('list.ordering', 'mu.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')); parent::populateState('mu.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') ); // reset button $options['reset_button'] = true; $options['listOrder'] = $this->getState('list.ordering', 'mu.user_id'); $options['listDirn'] = $this->getState('list.direction', 'ASC'); $options['sortFields'] = array( JHtml::_('select.option', 'mu.user_id', JText::_('COM_RSMEMBERSHIP_SUBSCRIBER_ID')), JHtml::_('select.option', 'u.username', JText::_('COM_RSMEMBERSHIP_USERNAME')), JHtml::_('select.option', 'u.name', JText::_('COM_RSMEMBERSHIP_NAME')), JHtml::_('select.option', 'u.email', JText::_('COM_RSMEMBERSHIP_EMAIL')) ); $customFields = RSMembership::getCustomFields(array('showinsubscribers'=>1)); if ($customFields) { foreach ($customFields as $id => $properties) { $options['sortFields'][] = JHtml::_('select.option', 'mu.f'.$properties->id, ($properties->label ? JText::_($properties->label) : JText::_('COM_RSMEMBERSHIP_NO_TITLE'))); } } $options['sortFields'][] = JHtml::_('select.option', 'num_subs', JText::_('COM_RSMEMBERSHIP_TOTAL_SUBSCRIPTIONS')); $options['sortFields'][] = JHtml::_('select.option', 'num_activesubs', JText::_('COM_RSMEMBERSHIP_ACTIVE_SUBSCRIPTIONS')); $options['limitBox'] = $this->getPagination()->getLimitBox(); $bar = new RSFilterBar($options); return $bar; } public function getSideBar() { require_once JPATH_COMPONENT.'/helpers/toolbar.php'; return RSMembershipToolbarHelper::render(); } public function getTable($type = 'Subscriber', $prefix = 'RSMembershipTable', $config = array()) { return JTable::getInstance($type, $prefix, $config); } public function getMemberships() { $db = JFactory::getDBO(); $query = $db->getQuery(true); $query->select($db->qn('id')) ->select($db->qn('name')) ->from($db->qn('#__rsmembership_memberships')) ->order($db->qn('ordering').' ASC'); $db->setQuery($query); return $db->loadObjectList(); } public function getTotalItems() { $query = $this->getListQuery(); $db = JFactory::getDbo(); $query->clear('select') ->clear('group') ->clear('order') ->select('COUNT('.$db->qn('u.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(); $customFields = RSMembership::getCustomFields(array('showinsubscribers'=>1)); $filename = JText::_('COM_RSMEMBERSHIP_SUBSCRIBERS'); $type = 'subscribers'; return RSMembershipExport::writeCSV($type, $query, $totalItems, $from, $fileHash, $filename, $customFields); } }

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