Spade
Mini Shell
home/lmsyaran/public_html/modules/mod_articles_categories/helper.php000064400000002025151167371450022147
0ustar00<?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.php000064400000007170151167413770020521
0ustar00<?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.php000064400000003040151172266550021423
0ustar00<?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();
}
}