Файловый менеджер - Редактировать - /home/lmsyaran/public_html/khsh/helper.php.tar
Назад
home/lmsyaran/public_html/modules/mod_articles_categories/helper.php 0000644 00000002025 15116737145 0022147 0 ustar 00 <?php /** * @package Joomla.Site * @subpackage mod_articles_categories * * @copyright Copyright (C) 2005 - 2020 Open Source Matters, Inc. All rights reserved. * @license GNU General Public License version 2 or later; see LICENSE.txt */ defined('_JEXEC') or die; /** * Helper for mod_articles_categories * * @since 1.5 */ abstract class ModArticlesCategoriesHelper { /** * Get list of articles * * @param \Joomla\Registry\Registry &$params module parameters * * @return array * * @since 1.5 */ public static function getList(&$params) { $options = array(); $options['countItems'] = $params->get('numitems', 0); $categories = JCategories::getInstance('Content', $options); $category = $categories->get($params->get('parent', 'root')); if ($category !== null) { $items = $category->getChildren(); $count = $params->get('count', 0); if ($count > 0 && count($items) > $count) { $items = array_slice($items, 0, $count); } return $items; } } } home/lmsyaran/public_html/modules/mod_consultants/helper.php 0000644 00000007170 15116741377 0020521 0 ustar 00 <?php class ModConsultantsHelper { public static function getConsultants($params) { // select consultans id that do atleast 1 consultation $db = JFactory::getDbo(); $query = $db->getQuery(true); $query ->select('distinct co.id as consultantid') ->from($db->quoteName('#__reservation_session', 's')) ->join('INNER', $db->quoteName('#__reservation_plan', 'p') . ' ON ' . $db->quoteName('s.planid') . ' = ' . $db->quoteName('p.id')) ->join('INNER', $db->quoteName('#__reservation_consultant', 'co') . ' ON ' . $db->quoteName('p.consultantid') . ' = ' . $db->quoteName('co.id')) ->where($db->quoteName('s.pay').'= 1'); $db->setQuery($query); $results = $db->loadColumn(); // select consultants info that their ids are in $results if($results) { $db = JFactory::getDbo(); $query = $db->getQuery(true); $query ->select($db->quoteName(array('a.id','a.alt','a.image', 'b.name','c.title'),array('consultantid','alt','image','consultantname','specialty'))) ->from($db->quoteName('#__reservation_consultant', 'a')) ->join('INNER', $db->quoteName('#__users', 'b') . ' ON ' . $db->quoteName('a.userid') . ' = ' . $db->quoteName('b.id')) ->join('INNER', $db->quoteName('#__categories', 'c') . ' ON ' . $db->quoteName('a.catid') . ' = ' . $db->quoteName('c.id')) ->where($db->quoteName('a.published') . ' = 1 ') ->where($db->quoteName('a.id') . ' IN ('.implode(',',$results).') ') ->order('RAND() LIMIT 8'); $db->setQuery($query); $consultantInfo = $db->loadObjectList(); $consultantid=[]; foreach ($consultantInfo as $item) { $consultantid[]= $item->consultantid; } // select number of sessions performed by consultants $db = JFactory::getDbo(); $query = $db->getQuery(true); $query ->select('co.id as consultantid , COUNT(consultantid) as count') ->from($db->quoteName('#__reservation_session', 's')) ->join('INNER', $db->quoteName('#__reservation_plan', 'p') . ' ON ' . $db->quoteName('s.planid') . ' = ' . $db->quoteName('p.id')) ->join('INNER', $db->quoteName('#__reservation_consultant', 'co') . ' ON ' . $db->quoteName('p.consultantid') . ' = ' . $db->quoteName('co.id')) ->where($db->quoteName('s.pay').'= 1') ->where($db->quoteName('co.id').' IN ('.implode(',',$consultantid).')') ->group('consultantid'); $db->setQuery($query); $sessionCount = $db->loadAssocList('consultantid'); $commentInfo= self::commentInfo($consultantid); return [$consultantInfo,$sessionCount, $commentInfo]; } return [0,0]; } public static function commentInfo($consultantid) { $db= JFactory::getDbo(); $query= $db->getQuery(true) ->select('consultantid, count(consultantid) as count, sum(rate) as rate') ->from($db->quoteName('#__reservation_comment','cm')) ->where($db->quoteName('cm.consultantid'). 'IN ('.implode(',',$consultantid).')') ->where($db->quoteName('cm.published'). '= 1') ->group('consultantid'); $db->setQuery($query); $result= $db->loadObjectList('consultantid'); return $result; } }
| ver. 1.4 |
Github
|
.
| PHP 8.1.33 | Генерация страницы: 0.01 |
proxy
|
phpinfo
|
Настройка