Spade
Mini Shell
| Directory:~$ /proc/self/root/home/lmsyaran/public_html/components/com_hikashop/views/category/ |
| [Home] [System Details] [Kill Me] |
<?php
/**
* @package HikaShop for Joomla!
* @version 2.2.3
* @author hikashop.com
* @copyright (C) 2010-2013 HIKARI SOFTWARE. All rights reserved.
* @license GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html
*/
defined('_JEXEC') or die('Restricted access');
?><?php
jimport( 'joomla.application.component.view');
class CategoryViewCategory extends HikaShopView {
function display($tpl = null){
global $mainframe;
global $Itemid;
$db = JFactory::getDBO();
$app = JFactory::getApplication();
$this->params = $app->getParams();
$doc = JFactory::getDocument();
$feedEmail = (@$app->getCfg('feed_email')) ?
$app->getCfg('feed_email') : 'author';
$siteEmail = $app->getCfg('mailfrom');
$menus = $app->getMenu();
$menu = $menus->getActive();
$config = hikashop_config();
if(empty($menu) AND !empty($Itemid)){
$menus->setActive($Itemid);
$menu = $menus->getItem($Itemid);
}
$myItem = empty($Itemid) ? '' :
'&Itemid='.$Itemid;
if (is_object( $menu )) {
jimport('joomla.html.parameter');
$menuparams = new HikaParameter( $menu->params );
}
$cid = hikashop_getCID('category_id');
if(empty($cid)){
$params = new stdClass();
$module = hikashop_get('helper.module');
$module->initialize($params);
$cid = $params->params->get('selectparentlisting');
}
if(!empty($cid)){
$categoryClass = hikashop_get('class.category');
$category = $categoryClass->get($cid);
if($category->category_type=='manufacturer'){
$query = 'SELECT * FROM
'.hikashop_table('product').' as a ' .
'JOIN '.hikashop_table('category').' as cat
' .
'ON a.product_manufacturer_id = cat.category_id ' .
'WHERE a.product_access=\'all\' ' .
'AND a.product_type=\'main\' ' .
'AND a.product_published=1 AND cat.category_id='.(int)$cid;
}else{
$filters = array();
if($config->get('hikarss_child',0) == 1){
$categoryClass->parentObject =& $this;
$childs =
$categoryClass->getChilds($cid,true,array(),'',0,0);
$filter = 'cat.category_id IN (';
foreach($childs as $child){
$filter .= $child->category_id.',';
}
$filters[]=$filter.$cid.')';
}
else{
$filter = 'cat.category_id IN (';
$filters[]=$filter.$cid.')';
}
$query = 'SELECT * FROM
'.hikashop_table('product').' as a ' .
'JOIN '.hikashop_table('product_category').'
as c ' .
'ON a.product_id = c.product_id ' .
'JOIN '.hikashop_table('category').' as cat
' .
'ON c.category_id = cat.category_id ' .
'WHERE a.product_access=\'all\' ' .
'AND a.product_published=1 ' .
'AND a.product_type=\'main\' ' .
'AND '.implode(',',$filters);
}
}
else{
$query = 'SELECT a.* FROM
'.hikashop_table('product').' AS a WHERE
a.product_access=\'all\' AND a.product_published=1 AND
a.product_type=\'main\'';
}
$query .= ' AND ( product_sale_start < '.time().' OR
product_sale_start = 0 )' .
' AND ( product_sale_end > '.time().' OR
product_sale_end = 0 ) ';
if(!$config->get('show_out_of_stock',1)){
$query.=' AND product_quantity!=0 ';
}
$query .= ' ORDER BY
a.'.$config->get('hikarss_order','product_id').'
DESC';
$query .= ' LIMIT
'.$config->get('hikarss_element','10');
$db->setQuery($query);
$products = $db->loadObjectList();
if(!empty($products)){
$ids = array();
$productClass = hikashop_get('class.product');
foreach($products as $key => $row){
$ids[]=$row->product_id;
$productClass->addAlias($products[$key]);
}
$queryCategoryId='SELECT * FROM
'.hikashop_table('product_category').' WHERE product_id
IN ('.implode(',',$ids).')';
$db->setQuery($queryCategoryId);
$categoriesId = $db->loadObjectList();
foreach($products as $k=>$row){
foreach($categoriesId as $catId){
if($row->product_id==$catId->product_id){
$products[$k]->categories_id[0]=$catId->category_id;
}
}
}
$queryImage = 'SELECT * FROM
'.hikashop_table('file').' WHERE file_ref_id IN
('.implode(',',$ids).') AND
file_type=\'product\' ORDER BY file_ref_id ASC, file_ordering
ASC, file_id ASC';
$db->setQuery($queryImage);
$images = $db->loadObjectList();
foreach($products as $k=>$row){
foreach($images as $image){
if($row->product_id==$image->file_ref_id){
foreach(get_object_vars($image) as $key => $name){
$products[$k]->images[0]->$key = $name;
}
break;
}
}
}
$db->setQuery('SELECT * FROM
'.hikashop_table('variant').' WHERE variant_product_id
IN ('.implode(',',$ids).')');
$variants = $db->loadObjectList();
if(!empty($variants)){
foreach($products as $k => $product){
foreach($variants as $variant){
if($product->product_id==$variant->variant_product_id){
$products[$k]->has_options = true;
}
}
}
}
}
else{
return true;
}
$zone_id=hikashop_getZone();
$currencyClass = hikashop_get('class.currency');
$config =& hikashop_config();
$main_currency = (int)$config->get('main_currency',1);
$currencyClass->getListingPrices($products,$zone_id,$main_currency,'cheapest');
$uploadFolder =
ltrim(JPath::clean(html_entity_decode($config->get('uploadfolder'))),DS);
$uploadFolder = rtrim($uploadFolder,DS).DS;
$this->uploadFolder_url =
str_replace(DS,'/',$uploadFolder);
$this->uploadFolder = JPATH_ROOT.DS.$uploadFolder;
$app = JFactory::getApplication();
$this->thumbnail = $config->get('thumbnail',1);
$this->thumbnail_x=$config->get('thumbnail_x',100);
$this->thumbnail_y=$config->get('thumbnail_y',100);
$this->main_thumbnail_x=$this->thumbnail_x;
$this->main_thumbnail_y=$this->thumbnail_y;
$this->main_uploadFolder_url = $this->uploadFolder_url;
$this->main_uploadFolder = $this->uploadFolder;
$doc_description =
$config->get('hikarss_description','');
$doc_title = $config->get('hikarss_name','');
$doc->title = $doc_title;
$doc->description = $doc_description;
$imageHelper = hikashop_get('helper.image');
foreach ( $products as $product ){
if($product->category_id == $cid &&
empty($doc_description)){
$doc->description =
strip_tags(html_entity_decode(preg_replace('#<hr
*id="system-readmore"
*/>#i','',$product->category_description)));
}
if($product->category_id == $cid && empty($doc_title)){
$doc->title = $this->escape( $product->category_name);
$doc->title = html_entity_decode( $doc->title );
}
$title = $this->escape( $product->product_name );
$title = html_entity_decode( $title );
$pathway_sef_name =
$config->get('pathway_sef_name','category_pathway');
$link =
JURI::base().'index.php?option=com_hikashop&ctrl=product&task=show&cid='.$product->product_id.'&name='.$product->alias.'&Itemid='.$Itemid.'&'.$pathway_sef_name.'='.$product->category_id;
if($product->prices['0']->price_value_with_tax != 0 ){
$desc =
$product->product_description.JText::_('CART_PRODUCT_PRICE').'
:
'.$currencyClass->format($product->prices[0]->price_value_with_tax,$product->prices[0]->price_currency_id);
}
else{
$desc=
$product->product_description.JText::_('FREE_PRICE');
}
$desc = preg_replace('#<hr *id="system-readmore"
*/>#i','',$desc);
$description =
'<table><tr><td>'.$imageHelper->display(@$product->images[0]->file_path,false,$title,
'' , '' , $imageHelper->main_thumbnail_x,
$imageHelper->main_thumbnail_y).'</td><td>'.$desc.'</td></tr></table>';
$item = new JFeedItem();
$item->title = $title;
$item->link = $link;
$item->description = $description;
$item->date = $product->product_created;
$item->category = $product->category_id;
$doc->addItem( $item );
}
}
}