/**
* Do something getItems method
*
* @param
* @return
*/
public static function getList($params)
{
$type = $params->get('type');
$Itemid = JRequest::getVar('categories', null);
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('SQL_CALC_FOUND_ROWS p.id');
$query->from('#__ksenmart_products AS p');
if ($Itemid[0]) {
$query->leftjoin('#__ksenmart_products_categories AS c ON c.product_id=p.id');
$query->where('c.category_id=' . $Itemid[0]);
}
$query->where('p.published = 1');
if ($type == 'hot') {
$query->where('(p.hot = 1)');
}
if ($type == 'new') {
$query->where('(p.new = 1)');
}
if ($type == 'recommendation') {
$query->where('(p.recommendation = 1)');
}
if ($type == 'promotion') {
$query->where('(p.promotion = 1)');
}
$query->where('(p.parent_id = 0)');
$query->order('p.ordering ASC');
$query->group('p.id');
$db->setQuery($query, 0, $params->get('col', 10));
$list = $db->loadObjectList();
$db->setQuery('SELECT FOUND_ROWS();');
//no reloading the query! Just asking for total without limit
jimport('joomla.html.pagination');
self::$pagination = new JPagination($db->loadResult(), 0, $params->get('col', 10));
return $list;
}
<?php
/**
* @copyright Copyright (C) 2013. All rights reserved.
* @license GNU General Public License version 2 or later; see LICENSE.txt
*/
defined('_JEXEC') or die;
JDispatcher::getInstance()->trigger('onLoadKsen', array('ksenmart', array('common'), array(), array('angularJS' => 0)));
KSLoader::loadLocalHelpers(array('common'));
if (!class_exists('KsenmartHtmlHelper')) {
require JPATH_ROOT . DS . 'components' . DS . 'com_ksenmart' . DS . 'helpers' . DS . 'head.php';
}
KsenmartHtmlHelper::AddHeadTags();
$km_params = JComponentHelper::getParams('com_ksenmart');
if ($km_params->get('modules_styles', true)) {
$document = JFactory::getDocument();
}
require_once dirname(__FILE__) . DS . 'helper.php';
$products = ModKsenmartProductsListHelper::getList($params);
$pagination = ModKsenmartProductsListHelper::$pagination;
$com_params = JComponentHelper::getParams('com_ksenmart');
if (count($products) > 0) {
$products = ModKsenmartProductsListHelper::setOtherParams($products);
require JModuleHelper::getLayoutPath('mod_km_products_list', $params->get('layout', 'default'));
}