Example #1
0
 /**
  * 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;
 }
Example #2
0
<?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'));
}