Файловый менеджер - Редактировать - /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; } } home/lmsyaran/public_html/modules/mod_phocacart_search/helper.php 0000644 00000003040 15117226655 0021423 0 ustar 00 <?php /* @package Joomla * @copyright Copyright (C) Open Source Matters. All rights reserved. * @license http://www.gnu.org/copyleft/gpl.html GNU/GPL, see LICENSE.php * @extension Phoca Extension * @copyright Copyright (C) Jan Pavelka www.phoca.cz * @license http://www.gnu.org/copyleft/gpl.html GNU/GPL */ defined('_JEXEC') or die; class ModPhocaCartSearchHelper { public static function getAjax() { jimport('joomla.application.module.helper'); if (!JComponentHelper::isEnabled('com_phocacart')) { echo '<div class="alert alert-error alert-danger">'.JText::_('Phoca Cart Error') . ' - ' . JText::_('Phoca Cart is not installed on your system').'</div>'; return; } JLoader::registerPrefix('Phocacart', JPATH_ADMINISTRATOR . '/components/com_phocacart/libraries/phocacart'); $lang = JFactory::getLanguage(); $lang->load('com_phocacart'); $module = JModuleHelper::getModule('phocacart_search'); $params = new JRegistry(); $params->loadString($module->params); $search = new PhocacartSearch(); $search->ajax = 1; $search->search_options = $params->get( 'search_options', 0 ); $search->hide_buttons = $params->get( 'hide_buttons', 0 ); $search->display_inner_icon = $params->get( 'display_inner_icon', 0 ); $search->load_component_media = $params->get( 'load_component_media', 1 ); $search->placeholder_text = $params->get( 'placeholder_text', '' ); $search->display_active_parameters = $params->get( 'display_active_parameters', 0 ); echo $search->renderSearch(); } }
| ver. 1.4 |
Github
|
.
| PHP 8.1.33 | Генерация страницы: 0.05 |
proxy
|
phpinfo
|
Настройка