paramBase = HIKASHOP_COMPONENT.'.'.$this->getName(); $function = $this->getLayout(); $this->params =& $params; if(!in_array($function,array('cart','add_to_cart_listing','listing_price')) && JRequest::getInt('popup') && JRequest::getVar('tmpl')!='component'){ $js = $this->getJS(); if(!empty($js)){ $doc = JFactory::getDocument(); $doc->addScriptDeclaration("\n\n"); } } if(method_exists($this,$function)) $this->$function(); parent::display($tpl); } function getJS(){ static $done = false; if($done) return ''; $done = true; $class = hikashop_get('helper.cart'); $this->addToCartJs = $class->getJS($this->init()); $js = ' window.addEvent(\'domready\', function() { SqueezeBox.fromElement(\'hikashop_notice_box_trigger_link\',{parse: \'rel\'}); }); '; return $js; } function filter(){ if(!hikashop_level(2)) return true; $filterClass = hikashop_get('class.filter'); $filterTypeClass = hikashop_get('class.filterType'); $config =& hikashop_config(); $cart = hikashop_get('helper.cart'); $displayedFilters = ''; if(!empty($this->params) && $this->params->get('module') == 'mod_hikashop_filter'){ $this->params->set('main_div_name','module_'.(int)$this->params->get('id')); $showButton=$this->params->get('show_filter_button',1); $showResetButton=$config->get('show_reset_button',0); $maxColumn=$this->params->get('filter_column_number',1); $maxFilter=$this->params->get('filter_limit'); $heightConfig=$this->params->get('filter_height',100); $displayFieldset=$this->params->get('display_fieldset',0); $buttonPosition=$this->params->get('filter_button_position','right'); $displayedFilters=trim($this->params->get('filters')); if(!empty($displayedFilters)){ $displayedFilters = explode(',',$displayedFilters); } $cid = 0; if(!$this->params->get('force_redirect',0)){ if(JRequest::getVar('option','')=='com_hikashop'){ $cid = JRequest::getInt('cid'); if($cid){ if(JRequest::getVar('ctrl','product')!='product'){ if(JRequest::getVar('ctrl','product')!='category' || JRequest::getVar('task','listing')!='listing'){ $cid = 0; } }elseif(JRequest::getVar('task','listing')!='listing'){ $cid = 0; } }elseif(in_array(JRequest::getVar('ctrl','product'),array('product','category'))&& JRequest::getVar('task','listing')=='listing'){ global $Itemid; $app = JFactory::getApplication(); $menus = $app->getMenu(); $menu = $menus->getActive(); if(empty($menu)){ if(!empty($Itemid)){ $menus->setActive($Itemid); $menu = $menus->getItem($Itemid); } } if(!empty($menu->id)){ $menuClass = hikashop_get('class.menus'); $menuData = $menuClass->get($menu->id); if(@$menuData->hikashop_params['content_type']=='manufacturer'){ $new_id = 'manufacturer'; $class = hikashop_get('class.category'); $class->getMainElement($new_id); $menuData->hikashop_params['selectparentlisting']=$new_id; } if(!empty($menuData->hikashop_params['selectparentlisting'])){ $cid = $menuData->hikashop_params['selectparentlisting']; } } } } } }else{ $cid = reset($this->pageInfo->filter->cid); $showButton=$config->get('show_filter_button',1); $showResetButton=$config->get('show_reset_button',0); $maxColumn=$config->get('filter_column_number',2); $maxFilter=$config->get('filter_limit'); $heightConfig=$config->get('filter_height',100); $displayFieldset=$config->get('display_fieldset',1); $buttonPosition=$config->get('filter_button_position','right'); } $filters=$filterClass->getFilters($cid); if(empty($maxFilter)){ $maxFilter=count($filters)-1; } if(empty($maxColumn)){ $maxColumn=1; } $this->assignRef('currentId',$cid); $this->assignRef('displayedFilters',$displayedFilters); $this->assignRef('cart',$cart); $this->assignRef('maxFilter',$maxFilter); $this->assignRef('maxColumn',$maxColumn); $this->assignRef('filters',$filters); $this->assignRef('filterClass',$filterClass); $this->assignRef('filterTypeClass',$filterTypeClass); $this->assignRef('heightConfig',$heightConfig); $this->assignRef('showResetButton',$showResetButton); $this->assignRef('showButton',$showButton); $this->assignRef('displayFieldset',$displayFieldset); $this->assignRef('buttonPosition',$buttonPosition); if(!isset($this->listingQuery) && $config->get('hikashopListingQuery','')!=''){ $this->listingQuery = $config->get('hikashopListingQuery',''); } } function listing(){ $config =& hikashop_config(); $this->assignRef('config',$config); $module = hikashop_get('helper.module'); $module->initialize($this); $this->paramBase.='_'.$this->params->get('main_div_name'); $database = JFactory::getDBO(); $app = JFactory::getApplication(); $pageInfo = new stdClass(); $pageInfo->filter = new stdClass(); $pageInfo->filter->order = new stdClass(); $pageInfo->limit = new stdClass(); $filters = array('b.product_published=1'); $category_selected=''; $select=''; $is_synchronized=false; $table='b'; $defaultParams = $config->get('default_params'); if($this->params->get('price_display_type','inherit')=='inherit'){ $this->params->set('price_display_type',@$defaultParams['price_display_type']); } if($this->params->get('product_order','inherit')=='inherit'){ $this->params->set('product_order',@$defaultParams['product_order']); if($this->params->get('product_order','inherit')=='inherit'){ $this->params->set('product_order','ordering'); } } if($this->params->get('product_order','ordering')=='ordering'){ $table='a'; } if($this->params->get('random','-1')=='-1'){ $this->params->set('random',@$defaultParams['random']); } if($this->params->get('limit','')==''){ $this->params->set('limit',@$defaultParams['limit']); } if( (int)$this->params->get('limit') == 0 ) { $this->params->set('limit', 1); } if($this->params->get('product_synchronize',4)==4){ $this->params->set('product_synchronize',@$defaultParams['product_synchronize']); } if($this->params->get('order_dir','inherit')=='inherit' || $this->params->get('order_dir','inherit')==''){ $this->params->set('order_dir',@$defaultParams['order_dir']); if($this->params->get('order_dir','inherit')=='inherit' || $this->params->get('order_dir','inherit')==''){ $this->params->set('order_dir','ASC'); } } if($this->params->get('div_item_layout_type','inherit')=='inherit'){ $this->params->set('div_item_layout_type',@$defaultParams['div_item_layout_type']); } if($this->params->get('columns','')==''){ $this->params->set('columns',@$defaultParams['columns']); } if($this->params->get('margin','')==''){ $this->params->set('margin',@$defaultParams['margin']); } if($this->params->get('text_center','-1')=='-1'){ $this->params->set('text_center',@$defaultParams['text_center']); } if($this->params->get('border_visible','-1')=='-1'){ $this->params->set('border_visible',@$defaultParams['border_visible']); } if($this->params->get('link_to_product_page','-1')=='-1'){ $this->params->set('link_to_product_page',@$defaultParams['link_to_product_page']); } if($this->params->get('show_price','-1')=='-1'){ $this->params->set('show_price',@$defaultParams['show_price']); } if($this->params->get('add_to_cart','-1')=='-1'){ $this->params->set('add_to_cart',@$defaultParams['add_to_cart']); } if($this->params->get('add_to_wishlist','-1')=='-1'){ if(empty($defaultParams['add_to_wishlist']))$defaultParams['add_to_wishlist'] = 0; $this->params->set('add_to_wishlist',@$defaultParams['add_to_wishlist']); } if($this->params->get('layout_type','inherit')=='inherit'){ $this->params->set('layout_type',@$defaultParams['layout_type']); } if($this->params->get('display_badges','-1')=='-1'){ $this->params->set('display_badges',@$defaultParams['display_badges']); } if(!empty($this->module)){ $pageInfo->search = ''; $force_recently_viewed = false; $pageInfo->filter->order->dir = $this->params->get('order_dir','ASC'); $pageInfo->filter->order->value = $table.'.'.$this->params->get('product_order','ordering'); $synchro = $this->params->get('content_synchronize'); if($this->params->get('recently_viewed','-1')=='-1'){ $this->params->set('recently_viewed',@$defaultParams['recently_viewed']); } $recently_viewed = (int)$this->params->get('recently_viewed',0); if($synchro){ if(JRequest::getString('option','')==HIKASHOP_COMPONENT){ if(JRequest::getString('ctrl','category')=='product'){ $product_synchronize = (int)$this->params->get('product_synchronize',0); if($product_synchronize){ $product_id = hikashop_getCID('product_id'); if(!empty($product_id)){ $pageInfo->filter->cid = $this->params->get('selectparentlisting'); if($product_synchronize==2){ $filters[]='a.product_related_type=\'related\''; $filters[]='a.product_id='.$product_id; $select='SELECT DISTINCT b.*'; $b = hikashop_table('product_related').' AS a LEFT JOIN '; $a = hikashop_table('product').' AS b'; $on = ' ON a.product_related_id=b.product_id'; if($this->params->get('product_order')=='ordering'){ $pageInfo->filter->order->value = 'a.product_related_ordering'; } }elseif($product_synchronize==3){ $query = "SELECT product_manufacturer_id FROM ".hikashop_table('product').' WHERE product_id='.$product_id.' OR product_parent_id='.$product_id; $database->setQuery($query); $filters[]='b.product_manufacturer_id ='.(int)$database->loadResult(); $filters[]='b.product_id!='.$product_id; $filters[]='b.product_parent_id!='.$product_id; $select='SELECT DISTINCT b.*'; $b = ''; $on = ''; $a = hikashop_table('product').' AS b'; $pageInfo->filter->order->value =''; }elseif($product_synchronize==4){ $filters[]='b.product_parent_id='.$product_id; $select='SELECT DISTINCT b.*'; $b = ''; $on = ''; $a = hikashop_table('product').' AS b'; $this->type = 'variant'; }else{ $config =& hikashop_config(); $pathway_sef_name = $config->get('pathway_sef_name','category_pathway'); $pathway = JRequest::getInt($pathway_sef_name,0); $filters[]='b.product_id!='.$product_id; $filters[]='b.product_parent_id!='.$product_id; if(empty($pathway)){ $query = "SELECT category_id FROM ".hikashop_table('product_category').' WHERE product_id='.$product_id.' ORDER BY product_category_id ASC'; $database->setQuery($query); if(!HIKASHOP_J25){ $pageInfo->filter->cid = $database->loadResultArray(); } else { $pageInfo->filter->cid = $database->loadColumn(); } }else{ $pageInfo->filter->cid = array($pathway); } } } } }elseif(JRequest::getString('ctrl','category')=='category'){ $pageInfo->filter->cid = JRequest::getInt("cid",$this->params->get('selectparentlisting')); $is_synchronized=true; }else{ $pageInfo->filter->cid = $this->params->get('selectparentlisting'); } }else{ $pageInfo->filter->cid = $this->params->get('selectparentlisting'); } }elseif($recently_viewed && !empty($_SESSION['hikashop_viewed_products'])){ $force_recently_viewed = true; }else{ $pageInfo->filter->cid = $this->params->get('selectparentlisting'); } if(!empty($pageInfo->filter->cid) && !is_array($pageInfo->filter->cid)){ $category_selected = '_'.$pageInfo->filter->cid; $this->paramBase.=$category_selected; } $pageInfo->filter->price_display_type = $this->params->get('price_display_type'); if(JRequest::getVar('hikashop_front_end_main',0)){ $oldValue = $app->getUserState($this->paramBase.'.list_limit'); if(empty($oldValue)){ $oldValue = $this->params->get('limit'); } $pageInfo->limit->value = $app->getUserStateFromRequest( $this->paramBase.'.list_limit', 'limit_'.$this->params->get('main_div_name').$category_selected, $this->params->get('limit'), 'int' ); if($oldValue!=$pageInfo->limit->value){ JRequest::setVar('limitstart_'.$this->params->get('main_div_name').$category_selected,0); } }else{ $pageInfo->limit->value = $this->params->get('limit'); $pageInfo->limit->start = 0; } if($pageInfo->limit->value < 0) $pageInfo->limit->value = 1; if($force_recently_viewed){ $i = $pageInfo->limit->value; $viewed_products_ids = $_SESSION['hikashop_viewed_products']; $ids_for_the_query = array(); for($i=$pageInfo->limit->value;$i>0 && count($viewed_products_ids);$i--){ $ids_for_the_query[]=array_shift($viewed_products_ids); } $filters[]='b.product_id IN ('.implode(',',$ids_for_the_query).')'; $select='SELECT DISTINCT b.*'; $b = ''; $on = ''; $a = hikashop_table('product').' AS b'; if($this->params->get('product_order')=='ordering'){ $pageInfo->filter->order->value = 'b.product_id'; } } }else{ $doc = JFactory::getDocument(); $pageInfo->filter->cid = JRequest::getInt("cid",$this->params->get('selectparentlisting')); if($config->get('show_feed_link', 1) == 1){ if($config->get('hikarss_format') != 'none'){ $doc_title = $config->get('hikarss_name',''); if(empty($doc_title)){ $category = hikashop_get('class.category'); $catData = $category->get($pageInfo->filter->cid); if($catData) $doc_title = $catData->category_name; } if($config->get('hikarss_format') != 'both'){ $link = '&format=feed&limitstart='; $attribs = array('type' => 'application/rss+xml', 'title' => $doc_title.' RSS 2.0'); $doc->addHeadLink(JRoute::_($link.'&type='.$config->get('hikarss_format')), 'alternate', 'rel', $attribs); } else{ $link = '&format=feed&limitstart='; $attribs = array('type' => 'application/rss+xml', 'title' => $doc_title.' RSS 2.0'); $doc->addHeadLink(JRoute::_($link.'&type=rss'), 'alternate', 'rel', $attribs); $attribs = array('type' => 'application/atom+xml', 'title' => $doc_title.' Atom 1.0'); $doc->addHeadLink(JRoute::_($link.'&type=atom'), 'alternate', 'rel', $attribs); } } } $category_selected = '_'.$pageInfo->filter->cid; $this->paramBase.=$category_selected; $pageInfo->filter->order->value = $table.'.'.$this->params->get('product_order','ordering'); $pageInfo->filter->order->value = $app->getUserStateFromRequest( $this->paramBase.".filter_order", 'filter_order_'.$this->params->get('main_div_name').$category_selected, $pageInfo->filter->order->value,'cmd' ); $pageInfo->filter->order->dir = $app->getUserStateFromRequest( $this->paramBase.".filter_order_Dir", 'filter_order_Dir_'.$this->params->get('main_div_name').$category_selected, $this->params->get('order_dir','ASC'), 'word' ); $oldValue = $app->getUserState($this->paramBase.'.list_limit'); if(empty($oldValue)){ $oldValue = $this->params->get('limit'); } $pageInfo->limit->value = $app->getUserStateFromRequest( $this->paramBase.'.list_limit', 'limit_'.$this->params->get('main_div_name').$category_selected, $this->params->get('limit'), 'int' ); if($oldValue!=$pageInfo->limit->value){ JRequest::setVar('limitstart_'.$this->params->get('main_div_name').$category_selected,0); } $pageInfo->filter->price_display_type = $app->getUserStateFromRequest( $this->paramBase.'.price_display_type', 'price_display_type_'.$this->params->get('main_div_name').$category_selected, $this->params->get('price_display_type'), 'word' ); } $this->assignRef('category_selected',$category_selected); $classbadge=hikashop_get('class.badge'); $this->assignRef('classbadge',$classbadge); $currencyClass = hikashop_get('class.currency'); $this->assignRef('currencyHelper',$currencyClass); $pageInfo->currency_id = hikashop_getCurrency(); if($config->get('tax_zone_type','shipping')=='billing'){ $pageInfo->zone_id = hikashop_getZone('billing'); }else{ $pageInfo->zone_id = hikashop_getZone('shipping'); } $show_price_weight = (int)$config->get('show_price_weight',0); $this->params->set('show_price_weight',$show_price_weight); if(hikashop_level(2)){ $this->params->set('show_compare',(int)$config->get('show_compare',0)); } else { $this->params->set('show_compare',0); } if(!empty($pageInfo->filter->cid)){ $acl_filters = array(); hikashop_addACLFilters($acl_filters,'category_access'); if(!empty($acl_filters)){ if(!is_array($pageInfo->filter->cid)){ $pageInfo->filter->cid = array($pageInfo->filter->cid); } $acl_filters[]='category_id IN ('.implode(',',$pageInfo->filter->cid).')'; $query = 'SELECT category_id FROM '.hikashop_table('category').' WHERE '.implode(' AND ',$acl_filters); $database->setQuery($query); if(!HIKASHOP_J25){ $pageInfo->filter->cid = $database->loadResultArray(); } else { $pageInfo->filter->cid = $database->loadColumn(); } } } if(empty($pageInfo->filter->cid)){ $query = 'SELECT category_id FROM '.hikashop_table('category').' WHERE category_type=\'product\' AND category_parent_id=0 LIMIT 1'; $database->setQuery($query); $pageInfo->filter->cid = $database->loadResult(); } $searchMap = array('b.product_name','b.product_description','b.product_id','b.product_code'); $filters[]='b.product_type = '.$database->Quote($this->type); if(!empty($pageInfo->search)){ $searchVal = '\'%'.hikashop_getEscaped($pageInfo->search,true).'%\''; $filters[] = implode(" LIKE $searchVal OR ",$searchMap)." LIKE $searchVal"; } if(!is_array($pageInfo->filter->cid)){ $pageInfo->filter->cid=array((int)$pageInfo->filter->cid); } $this->assignRef('pageInfo',$pageInfo); if(hikashop_level(2)) $this->filter(); $class = hikashop_get('class.category'); $element = $class->get(reset($pageInfo->filter->cid),true); $this->assignRef('element',$element); if(empty($select)){ $parentCategories = implode(',',$pageInfo->filter->cid); $catName = 'a.category_id'; $type = 'product'; if(!empty($element->category_type) && $element->category_type=='manufacturer'){ if($pageInfo->filter->order->value=='a.ordering'){ $pageInfo->filter->order->value='b.product_name'; } $type = 'manufacturer'; $catName = 'b.product_manufacturer_id'; $b = ''; $a = hikashop_table('product').' AS b'; $on = ''; $select='SELECT DISTINCT b.*'; }else{ $b = hikashop_table('product_category').' AS a LEFT JOIN '; $a = hikashop_table('product').' AS b'; $on = ' ON a.product_id=b.product_id'; $select='SELECT DISTINCT b.*'; } if($this->params->get('filter_type',2)==2){ $defaultParams = $config->get('default_params'); $this->params->set('filter_type',$defaultParams['filter_type']); } if(!$this->params->get('filter_type')){ $filters[]=$catName.' IN ('.$parentCategories.')'; }else{ $categoryClass = hikashop_get('class.category'); $categoryClass->parentObject =& $this; $categoryClass->type = $type; $childs = $categoryClass->getChilds($pageInfo->filter->cid,true,array(),'',0,0); $filter = $catName.' IN ('; foreach($childs as $child){ $filter .= $child->category_id.','; } $filters[]=$filter.$parentCategories.')'; } } $order = ''; if(!empty($pageInfo->filter->order->value)){ $order = ' ORDER BY '.$pageInfo->filter->order->value.' '.$pageInfo->filter->order->dir; } if($this->params->get('add_to_cart','-1')=='-1'){ $defaultParams = $config->get('default_params'); $this->params->set('add_to_cart',$defaultParams['add_to_cart']); } if($this->params->get('add_to_cart')){ $cart = hikashop_get('helper.cart'); $this->assignRef('cart',$cart); $catalogue = (int)$config->get('catalogue',0); $this->params->set('catalogue',$catalogue); $cart->cartCount(1); $cart->cartCount(1); $cart->getJS($this->init()); } if(!$config->get('show_out_of_stock',1)){ $filters[]='b.product_quantity!=0'; } hikashop_addACLFilters($filters,'product_access','b'); if($this->params->get('random')){ $order = ' ORDER BY RAND()'; } $select2=''; if(hikashop_level(2) && JRequest::getVar('hikashop_front_end_main',0) && JRequest::getVar('task','listing')!='show'){ foreach($this->filters as $uniqueFitler){ $this->filterClass->addFilter($uniqueFitler, $filters,$select,$select2, $a, $b, $on, $order, $this, $this->params->get('main_div_name')); } } JPluginHelper::importPlugin( 'hikashop' ); $dispatcher = JDispatcher::getInstance(); $dispatcher->trigger( 'onBeforeProductListingLoad', array( & $filters, & $order, & $this, & $select, & $select2, & $a, & $b, & $on) ); $translationFilter=''; if(isset($filters['translation'])){ $translationFilter=' OR '.$filters['translation'].' '; unset($filters['translation']); } $query = $select2.' FROM '.$b.$a.$on.' WHERE '.implode(' AND ',$filters).$translationFilter.$order; if(hikashop_level(2) && JRequest::getVar('hikashop_front_end_main',0) && JRequest::getVar('task','listing')!='show'){ $config->set('hikashopListingQuery', $query); $this->assignRef('listingQuery', $query); } if(!isset($pageInfo->limit->start)){ $pageInfo->limit->start = $app->getUserStateFromRequest( $this->paramBase.'.limitstart', 'limitstart_'.$this->params->get('main_div_name').$category_selected, 0, 'int' ); } $database->setQuery($select.$query,(int)$pageInfo->limit->start,(int)$pageInfo->limit->value); $rows = $database->loadObjectList(); if(!empty($rows)){ $ids = array(); $productClass = hikashop_get('class.product'); foreach($rows as $key => $row){ $ids[]=$row->product_id; $productClass->addAlias($rows[$key]); } $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'; $database->setQuery($queryImage); $images = $database->loadObjectList(); foreach($rows as $k=>$row){ if(!empty($images)){ foreach($images as $image){ if($row->product_id==$image->file_ref_id){ if(!isset($row->file_ref_id)){ foreach(get_object_vars($image) as $key => $name){ $rows[$k]->$key = $name; } } break; } } } if(!isset($rows[$k]->file_name)){ $rows[$k]->file_name = $row->product_name; } } $database->setQuery('SELECT variant_product_id FROM '.hikashop_table('variant').' WHERE variant_product_id IN ('.implode(',',$ids).')'); $variants = $database->loadObjectList(); if(!empty($variants)){ foreach($rows as $k => $product){ foreach($variants as $variant){ if($product->product_id==$variant->variant_product_id){ $rows[$k]->has_options = true; break; } } } } $database->setQuery('SELECT product_id FROM '.hikashop_table('product_related').' WHERE product_related_type = '.$database->quote('options').' AND product_id IN ('.implode(',',$ids).')'); $options = $database->loadObjectList(); if(!empty($options)){ foreach($rows as $k => $product){ foreach($options as $option){ if($product->product_id==$option->product_id){ $rows[$k]->has_options = true; break; } } } } $currencyClass->getListingPrices($rows,$pageInfo->zone_id,$pageInfo->currency_id,$pageInfo->filter->price_display_type); } $database->setQuery('SELECT count( DISTINCT b.product_id)'.$query); $pageInfo->elements = new stdClass(); $pageInfo->elements->total = $database->loadResult(); $pageInfo->elements->page = count($rows); $toggleClass = hikashop_get('helper.toggle'); $this->assignRef('toggleClass',$toggleClass); $classbadge=hikashop_get('class.badge'); if(!empty($rows)){ foreach($rows as $k => $row){ $classbadge->loadBadges($rows[$k]); } } $this->assignRef('classbadge',$classbadge); $this->assignRef('rows',$rows); $this->assignRef('pageInfo',$pageInfo); $this->assignRef('modules',$this->modules); $image=hikashop_get('helper.image'); $this->assignRef('image',$image); global $Itemid; $menus = $app->getMenu(); $menu = $menus->getActive(); if(empty($menu)){ if(!empty($Itemid)){ $menus->setActive($Itemid); $menu = $menus->getItem($Itemid); } } $url_itemid = ''; if(!empty($Itemid)){ $url_itemid = '&Itemid='.(int)$Itemid; } $pagination = hikashop_get('helper.pagination', $pageInfo->elements->total, $pageInfo->limit->start, $pageInfo->limit->value); $pagination->hikaSuffix = '_'.$this->params->get('main_div_name').$category_selected; $this->assignRef('pagination',$pagination); if(empty($this->module)){ $fieldsClass = hikashop_get('class.field'); $fields = $fieldsClass->getFields('frontcomp',$element,'category','checkout&task=state'); $this->assignRef('fieldsClass',$fieldsClass); $this->assignRef('fields',$fields); $title = $this->params->get('page_title'); if(empty($title)){ $title = $this->params->get('title'); } $use_module = $this->params->get('use_module_name'); if(empty($use_module) && !empty($element->category_name)){ $title = $element->category_name; } if(!empty($element->category_page_title)){ $page_title = $element->category_page_title; }else{ $page_title = $title; } if (empty($page_title)) { $page_title = $app->getCfg('sitename'); } elseif ($app->getCfg('sitename_pagetitles', 0) == 1) { $page_title = JText::sprintf('JPAGETITLE', $app->getCfg('sitename'), $page_title); } elseif ($app->getCfg('sitename_pagetitles', 0) == 2) { $page_title = JText::sprintf('JPAGETITLE', $page_title, $app->getCfg('sitename')); } $this->params->set('page_title',$title); $document = JFactory::getDocument(); if(!empty($element->category_keywords)){ $document->setMetadata('keywords', $element->category_keywords); } if(!empty($element->category_meta_description)){ $document->setMetadata('description', $element->category_meta_description); } $document->setTitle(strip_tags($page_title)); if(!$this->params->get('random')){ $this->params->set('show_limit',1); } if(empty($menu)){ $pathway = $app->getPathway(); $pathway_sef_name = $config->get('pathway_sef_name','category_pathway'); $category_pathway = '&'.$pathway_sef_name.'='.JRequest::getVar('menu_main_category'); $categories = $class->getParents(reset($pageInfo->filter->cid)); $one = true; if(!empty($categories)){ foreach($categories as $category){ if($one){ $one = false; }else{ $class->addAlias($category); $pathway->addItem($category->category_name,hikashop_completeLink('category&task=listing&cid='.(int)$category->category_id.'&name='.$category->alias)); } } } } }else{ $main = JRequest::getVar('hikashop_front_end_main',0); if($main){ if(!empty($product_id)){ $pathway_sef_name = $config->get('pathway_sef_name','category_pathway'); $related_sef_name = $config->get('related_sef_name','related_product'); $category_pathway = JRequest::getInt($pathway_sef_name,0); $category_pathway = '&'.$pathway_sef_name.'='.JRequest::getInt($category_pathway,0).'&'.$related_sef_name.'='.$product_id; } if( !$this->params->get('random')){ $this->params->set('show_limit',1); } } $module_item_id = $this->params->get('itemid'); if(!empty($module_item_id)){ $url_itemid='&Itemid='.(int)$module_item_id; } if(empty($category_pathway) && !empty($menu) && strpos($menu->link,'option='.HIKASHOP_COMPONENT)!==false && (strpos($menu->link,'view=category')!==false || strpos($menu->link,'view=')===false) && !JRequest::getInt('no_cid',0)){ $pathway_sef_name = $config->get('pathway_sef_name','category_pathway'); $category_pathway = '&'.$pathway_sef_name.'='.reset($pageInfo->filter->cid); } } $this->assignRef('itemid',$url_itemid); if($config->get('simplified_breadcrumbs',1)){ $category_pathway=''; } $this->assignRef('category_pathway',$category_pathway); $url = $this->init(true); $this->assignRef('redirect_url',$url); $fieldClass = hikashop_get('class.field'); $this->assignRef('fieldsClass',$fieldClass); } function show(){ $app = JFactory::getApplication(); $product_id = (int)hikashop_getCID('product_id'); $config =& hikashop_config(); $this->assignRef('config',$config); global $Itemid; $menus = $app->getMenu(); $menu = $menus->getActive(); if(empty($menu)){ if(!empty($Itemid)){ $menus->setActive($Itemid); $menu = $menus->getItem($Itemid); } } if(empty($product_id)){ if (is_object( $menu )) { jimport('joomla.html.parameter'); $category_params = new HikaParameter( $menu->params ); $product_id = $category_params->get('product_id'); if(is_array($product_id)){ $product_id = (int)$product_id[0]; }else{ $product_id = (int)$product_id; } JRequest::setVar('product_id',$product_id); } } if(empty($product_id)){ return; } $filters=array('a.product_id='.$product_id); hikashop_addACLFilters($filters,'product_access','a'); $query = 'SELECT a.*, b.product_category_id, b.category_id, b.ordering FROM '.hikashop_table('product').' AS a LEFT JOIN '.hikashop_table('product_category').' AS b ON a.product_id = b.product_id WHERE '.implode(' AND ',$filters). ' LIMIT 1'; $database = JFactory::getDBO(); $database->setQuery($query); $element = $database->loadObject(); if(empty($element)){ return; } $this->modules = $config->get('product_show_modules',''); $module = hikashop_get('helper.module'); $this->modules=$module->setModuleData($this->modules); $currencyClass = hikashop_get('class.currency'); $default_params = $config->get('default_params'); $empty=''; jimport('joomla.html.parameter'); $params = new HikaParameter($empty); foreach($default_params as $k => $param){ $params->set($k,$param); } $main_currency = (int)$config->get('main_currency',1); $params->set('main_currency',$main_currency); $discount_before_tax = (int)$config->get('discount_before_tax',0); $params->set('discount_before_tax',$discount_before_tax); $catalogue = (int)$config->get('catalogue',0); $params->set('catalogue',$catalogue); $show_price_weight = (int)$config->get('show_price_weight',0); $params->set('show_price_weight',$show_price_weight); $params->set('price_with_tax',$config->get('price_with_tax')); $currency_id = hikashop_getCurrency(); if($config->get('tax_zone_type','shipping')=='billing'){ $zone_id = hikashop_getZone('billing'); }else{ $zone_id = hikashop_getZone('shipping'); } $params->set('characteristic_display',$config->get('characteristic_display','table')); $params->set('characteristic_display_text',$config->get('characteristic_display_text',1)); $params->set('show_quantity_field',$config->get('show_quantity_field',1)); $this->assignRef('params',$params); $cart = hikashop_get('helper.cart'); $this->assignRef('cart',$cart); $this->selected_variant_id=0; if($element->product_type=='variant'){ $this->selected_variant_id = $product_id; $filters=array('a.product_id='.$element->product_parent_id); hikashop_addACLFilters($filters,'product_access','a'); $query = 'SELECT a.*,b.* FROM '.hikashop_table('product').' AS a LEFT JOIN '.hikashop_table('product_category').' AS b ON a.product_id = b.product_id WHERE '.implode(' AND ',$filters). ' ORDER BY product_category_id ASC LIMIT 1'; $database->setQuery($query); $element = $database->loadObject(); if(empty($element)){ return; } $product_id = $element->product_id; JRequest::setVar('product_id',$product_id); } if(!isset($_SESSION['hikashop_viewed_products'])) $_SESSION['hikashop_viewed_products'] = array(); else $arr = array_reverse($_SESSION['hikashop_viewed_products'], true); $arr[$product_id] = $product_id; $_SESSION['hikashop_viewed_products'] = array_reverse($arr, true); $productClass=hikashop_get('class.product'); $productClass->addAlias($element); if(!$element->product_published){ return; } $prod = new stdClass(); $prod->product_id = $product_id; $prod->product_hit = $element->product_hit+1; $prod->product_last_seen_date = time(); $productClass->save($prod,true); $filters=array('a.product_id ='.$product_id,'a.product_related_type=\'options\'','b.product_published=1','(b.product_sale_start=\'\' OR b.product_sale_start<='.time().')','(b.product_sale_end=\'\' OR b.product_sale_end>'.time().')'); hikashop_addACLFilters($filters,'product_access','b'); $query = 'SELECT b.* FROM '.hikashop_table('product_related').' AS a LEFT JOIN '.hikashop_table('product').' AS b ON a.product_related_id = b.product_id WHERE '.implode(' AND ',$filters).' ORDER BY a.product_related_ordering ASC, a.product_related_id ASC'; $database->setQuery($query); $element->options = $database->loadObjectList('product_id'); $ids = array($product_id); if(!empty($element->options)){ foreach($element->options as $optionElement){ $ids[]=$optionElement->product_id; } } $filters=array('product_parent_id IN ('.implode(',',$ids).')'); hikashop_addACLFilters($filters,'product_access'); $query = 'SELECT * FROM '.hikashop_table('product').' WHERE '.implode(' AND ',$filters); $database->setQuery($query); $variants = $database->loadObjectList(); if(!empty($variants)){ foreach($variants as $variant){ $ids[]=$variant->product_id; if($variant->product_parent_id==$product_id){ $element->variants[$variant->product_id]=$variant; } if(!empty($element->options)){ foreach($element->options as $k => $optionElement){ if($variant->product_parent_id==$optionElement->product_id){ $element->options[$k]->variants[$variant->product_id] = $variant; break; } } } } } $sort = $config->get('characteristics_values_sorting'); if($sort=='old'){ $order = 'characteristic_id ASC'; }elseif($sort=='alias'){ $order = 'characteristic_alias ASC'; }elseif($sort=='ordering'){ $order = 'characteristic_ordering ASC'; }else{ $order = 'characteristic_value ASC'; } $query = 'SELECT a.*,b.* FROM '.hikashop_table('variant').' AS a LEFT JOIN '.hikashop_table('characteristic').' AS b ON a.variant_characteristic_id=b.characteristic_id WHERE a.variant_product_id IN ('.implode(',',$ids).') ORDER BY a.ordering ASC,b.'.$order; $database->setQuery($query); $characteristics = $database->loadObjectList(); if(!empty($characteristics)){ $mainCharacteristics = array(); foreach($characteristics as $characteristic){ if($product_id==$characteristic->variant_product_id){ $mainCharacteristics[$product_id][$characteristic->characteristic_parent_id][$characteristic->characteristic_id]=$characteristic; } if(!empty($element->options)){ foreach($element->options as $k => $optionElement){ if($optionElement->product_id==$characteristic->variant_product_id){ $mainCharacteristics[$optionElement->product_id][$characteristic->characteristic_parent_id][$characteristic->characteristic_id]=$characteristic; } } } } if(!empty($element->variants)){ $this->addCharacteristics($element,$mainCharacteristics,$characteristics); } if(!empty($element->options)){ foreach($element->options as $k => $optionElement){ if(!empty($optionElement->variants)){ $this->addCharacteristics($element->options[$k],$mainCharacteristics,$characteristics); if(count(@$mainCharacteristics[$optionElement->product_id][0])){ $optionsVariants = array(); $sort = $config->get('characteristics_values_sorting'); if($sort=='old'){ $order = 'characteristic_id'; }elseif($sort=='alias'){ $order = 'characteristic_alias'; }elseif($sort=='ordering'){ $order = 'characteristic_ordering'; }else{ $order = 'characteristic_value'; } foreach($optionElement->variants as $k2 => $variant){ $key = ''; foreach($variant->characteristics as $char){ $key .= sprintf('%04d', $char->$order).'_'; } $key.=$variant->product_id; $optionsVariants[$key]=&$element->options[$k]->variants[$k2]; } ksort($optionsVariants); $element->options[$k]->variants=$optionsVariants; } } } } } $query = 'SELECT * FROM '.hikashop_table('file').' WHERE file_ref_id IN ('.implode(',',$ids).') AND file_type IN (\'product\',\'file\') ORDER BY file_ordering ASC, file_id ASC'; $database->setQuery($query); $product_files = $database->loadObjectList(); if(!empty($product_files)){ $productClass->addFiles($element,$product_files); } $defaultParams = $config->get('default_params'); $detault_display_type=@$defaultParams['price_display_type']; $currencyClass->getListingPrices($elements,$zone_id,$currency_id,$detault_display_type); $fieldsClass = hikashop_get('class.field'); $fields = $fieldsClass->getFields('frontcomp',$element,'product','checkout&task=state'); $this->assignRef('fieldsClass',$fieldsClass); $this->assignRef('fields',$fields); if(hikashop_level(2)){ $itemFields = $fieldsClass->getFields('frontcomp',$element,'item','checkout&task=state'); $null=array(); $fieldsClass->addJS($null,$null,$null); $fieldsClass->jsToggle($itemFields,$element,0); $this->assignRef('itemFields',$itemFields); $extraFields = array('item'=>&$itemFields); $requiredFields = array(); $validMessages = array(); $values = array('item'=>$element); $fieldsClass->checkFieldsForJS($extraFields,$requiredFields,$validMessages,$values); $fieldsClass->addJS($requiredFields,$validMessages,array('item')); } $this->checkVariants($element); if(!empty($element->options)){ foreach($element->options as $k => $optionElement){ $this->checkVariants($element->options[$k]); } } $this->setDefault($element); if(!empty($element->options)){ foreach($element->options as $k => $optionElement){ $this->setDefault($element->options[$k]); } } $this->assignRef('element',$element); $doc = JFactory::getDocument(); $product_name = $this->element->product_name; $product_page_title = $this->element->product_page_title; $product_description = $element->product_meta_description; $product_keywords = $element->product_keywords; if(!empty($this->element->main)){ $product_name = $this->element->main->product_name; if(!empty($this->element->main->product_page_title)){ $product_page_title = $this->element->main->product_page_title; } if(!empty($this->element->main->product_meta_description)){ $product_description = $this->element->main->product_meta_description; } if(!empty($this->element->main->product_keywords)){ $product_keywords = $this->element->main->product_keywords; } } if(!empty($product_keywords)){ $doc->setMetadata('keywords', $product_keywords); } if(!empty($product_description)){ $doc->setMetadata('description', $product_description); } $parent = 0; $url_itemid=''; if(!empty($Itemid)){ $url_itemid='&Itemid='.$Itemid; } if(empty($menu) || !(strpos($menu->link,'option='.HIKASHOP_COMPONENT)!==false && strpos($menu->link,'view=product')!==false && strpos($menu->link,'layout=show')!==false)){ $pathway = $app->getPathway(); $config =& hikashop_config(); $pathway_sef_name = $config->get('pathway_sef_name','category_pathway'); $category_pathway = JRequest::getInt($pathway_sef_name,0); if($category_pathway){ $class = hikashop_get('class.category'); if(!empty($menu->id)){ $menuClass = hikashop_get('class.menus'); $menuData = $menuClass->get($menu->id); if(@$menuData->hikashop_params['content_type']=='manufacturer'){ $new_id = 'manufacturer'; $class->getMainElement($new_id); $menuData->hikashop_params['selectparentlisting']=$new_id; } if(!empty($menuData->hikashop_params['selectparentlisting'])){ $parent = $menuData->hikashop_params['selectparentlisting']; } } $categories = $class->getParents($category_pathway,$parent); $one = true; foreach($categories as $category){ if($one){ $one = false; }else{ $class->addAlias($category); $pathway->addItem($category->category_name,hikashop_completeLink('category&task=listing&cid='.(int)$category->category_id.'&name='.$category->alias.$url_itemid)); } } } $related_sef_name = $config->get('related_sef_name','related_product'); $related = JRequest::getInt($related_sef_name,0); if($config->get('simplified_breadcrumbs',1) || !$category_pathway){ $category_pathway=''; }else{ $pathway_sef_name = $config->get('pathway_sef_name','category_pathway'); $category_pathway='&'.$pathway_sef_name.'='.$category_pathway; } if(!empty($related)){ $class = hikashop_get('class.product'); $prod = $class->get($related); if(!empty($prod)){ $class->addAlias($prod); $pathway->addItem($prod->product_name,hikashop_completeLink('product&task=show&cid='.(int)$prod->product_id.'&name='.$prod->alias.$category_pathway.$url_itemid)); } } $pathway->addItem($product_name,hikashop_completeLink('product&task=show&cid='.(int)$element->product_id.'&name='.$element->alias.$category_pathway.$url_itemid)); } $classbadge=hikashop_get('class.badge'); $this->assignRef('classbadge',$classbadge); $classbadge->loadBadges($element); $links = new stdClass(); $links->previous = ''; $links->next = ''; if($config->get('show_other_product_shortcut')){ $pathway_sef_name = $config->get('pathway_sef_name','category_pathway'); $category_id = JRequest::getInt($pathway_sef_name,0); if(empty($category_id) && !empty($menu->id) && !$config->get('simplified_breadcrumbs',1)){ $menuClass = hikashop_get('class.menus'); $menuData = $menuClass->get($menu->id); if(!empty($menuData->hikashop_params['selectparentlisting'])){ if($menuData->hikashop_params['filter_type']==2){ $menuData->hikashop_params['filter_type'] = $config->get('fitler_type'); } if(!$menuData->hikashop_params['filter_type']){ $category_id = $menuData->hikashop_params['selectparentlisting']; } } } if(empty($category_id)){ $query='SELECT a.category_id FROM '.hikashop_table('product_category').' AS a WHERE a.product_id='.(int)$product_id.' ORDER BY a.product_category_id ASC'; $database->setQuery($query); $category_id = $database->loadResult(); } $filters = array('b.product_published=1','a.category_id = '.(int)$category_id,'b.product_type=\'main\''); hikashop_addACLFilters($filters,'product_access','b'); if(!$config->get('show_out_of_stock',1)){ $filters[]='b.product_quantity!=0'; } $query='SELECT DISTINCT a.product_id FROM '.hikashop_table('product_category').' AS a LEFT JOIN '.hikashop_table('product').' AS b ON a.product_id=b.product_id WHERE '.implode(' AND ',$filters).' GROUP BY a.product_id ORDER BY a.ordering ASC'; $database->setQuery($query); if(!HIKASHOP_J25){ $articles = $database->loadResultArray(); } else { $articles = $database->loadColumn(); } if(!empty($articles)){ foreach($articles as $k => $article){ if($article == $element->product_id || $article == $element->product_parent_id){ $links->path= JURI::root(); $links->path .= 'media/com_hikashop/images/icons/'; $class = hikashop_get('class.product'); if(!isset($category_pathway)){ $pathway = ''; }else{ $pathway = $pathway_sef_name.'='.$category_pathway; } if($k != 0){ $p = $k - 1; $id_previous = $articles[$p]; $elt = $class->get($id_previous); $class->addAlias($elt); $pathway_sef_name = $config->get('pathway_sef_name','category_pathway'); $links->previous = hikashop_completeLink('product&task=show&cid='.(int)$id_previous.'&name='.$elt->alias.'&'.$pathway.$url_itemid); } $n = $k; while(isset($articles[$n]) && ($articles[$n]==$element->product_id||$articles[$n]==$element->product_parent_id)){ $n = $n + 1; } if(isset($articles[$n])){ $id_next = $articles[$n]; $elt = $class->get($id_next); $class->addAlias($elt); $pathway_sef_name = $config->get('pathway_sef_name','category_pathway'); $links->next = hikashop_completeLink('product&task=show&cid='.(int)$id_next.'&name='.$elt->alias.'&'.$pathway.$url_itemid); } break; } } } } $this->assignRef('links',$links); $image = hikashop_get('helper.image'); $this->assignRef('image',$image); $this->assignRef('currencyHelper',$currencyClass); $characteristic = hikashop_get('type.characteristic'); $this->assignRef('characteristic',$characteristic); $query = 'SELECT b.* FROM '.hikashop_table('product_category').' AS a LEFT JOIN '.hikashop_table('category').' AS b ON a.category_id = b.category_id WHERE a.product_id = '.(int)$prod->product_id.' ORDER BY a.ordering ASC'; $database->setQuery($query); $categories = $database->loadObjectList(); $this->assignRef('categories',$categories); $productlayout = $element->product_layout; $productDisplayType = hikashop_get('type.productdisplay'); if(!empty($element->main->product_layout)){ $productlayout=$element->main->product_layout; } if(!$productDisplayType->check( $productlayout, $app->getTemplate())) { $productlayout = ''; } if(empty($productlayout) && !empty($categories) ) { foreach($categories as $category) { if(!empty($category->category_layout) && $productDisplayType->check($category->category_layout, $app->getTemplate())) { $productlayout = $category->category_layout; break; } } } if(empty($productlayout) && $productDisplayType->check($config->get('product_display'), $app->getTemplate())) { $productlayout = $config->get('product_display'); } if(empty($productlayout)) { $productlayout = 'show_default'; } $this->assignRef('productlayout',$productlayout); $document = JFactory::getDocument(); if(!empty($product_page_title)){ $product_name = $product_page_title; } if (empty($product_name)) { $product_name = $app->getCfg('sitename'); } elseif ($app->getCfg('sitename_pagetitles', 0) == 1) { $product_name = JText::sprintf('JPAGETITLE', $app->getCfg('sitename'), $product_name); } elseif ($app->getCfg('sitename_pagetitles', 0) == 2) { $product_name = JText::sprintf('JPAGETITLE', $product_name, $app->getCfg('sitename')); } $document->setTitle( strip_tags($product_name) ); $url = $this->init(); $cart->getJS($url); $this->assignRef('redirect_url',$url); } function compare() { if(!hikashop_level(2)) { return; } $app = JFactory::getApplication(); $cids = JRequest::getVar('cid', array(), '', 'array'); $config =& hikashop_config(); $this->assignRef('config',$config); global $Itemid; $menus = $app->getMenu(); $menu = $menus->getActive(); if(empty($menu)){ if(!empty($Itemid)){ $menus->setActive($Itemid); $menu = $menus->getItem($Itemid); } } if(empty($cids)){ if (is_object( $menu )) { jimport('joomla.html.parameter'); $category_params = new HikaParameter( $menu->params ); $cids = $category_params->get('product_id'); if(!is_array($cids)) $cids = array($cids); foreach($cids as $k => $cid){ if($k > 7) unset($cids[$k]); } } } if(empty($cids)){ return; } $c = array(); foreach($cids as $cid) { if( strpos($cid,',')!==false) { $c = array_merge($c,explode(',',$cid)); } else { $c[] = (int)$cid; } } $cids = $c; JArrayHelper::toInteger($cids); $empty = ''; $default_params = $config->get('default_params'); jimport('joomla.html.parameter'); $params = new HikaParameter($empty); foreach($default_params as $k => $param){ $params->set($k,$param); } $main_currency = (int)$config->get('main_currency',1); $params->set('main_currency',$main_currency); $discount_before_tax = (int)$config->get('discount_before_tax',0); $params->set('discount_before_tax',$discount_before_tax); $params->set('show_compare',(int)$config->get('show_compare',0)); $compare_limit = (int)$config->get('compare_limit',5); $params->set('compare_limit',$compare_limit); $compare_inc_lastseen = (int)$config->get('compare_inc_lastseen',0); $params->set('compare_inc_lastseen',$compare_inc_lastseen); $params->set('compare_show_name_separator',(int)$config->get('compare_show_name_separator',1)); $params->set('catalogue',(int)$config->get('catalogue',0)); $params->set('add_to_cart',(int)1); $params->set('show_price_weight',(int)$config->get('show_price_weight',0)); $params->set('characteristic_display',$config->get('characteristic_display','table')); $params->set('characteristic_display_text',$config->get('characteristic_display_text',1)); $params->set('show_quantity_field',$config->get('show_quantity_field',1)); $this->assignRef('params',$params); if( count($cids) > $compare_limit ) { $cids = array_slice($cids, 0, $compare_limit ); } $filters=array('a.product_id IN ('.implode(',',$cids).')'); hikashop_addACLFilters($filters,'product_access','a'); $query = 'SELECT DISTINCT a.product_id, a.*,b.product_category_id, b.category_id, b.ordering FROM '.hikashop_table('product').' AS a LEFT JOIN '.hikashop_table('product_category').' AS b ON a.product_id = b.product_id WHERE '.implode(' AND ',$filters).' ORDER BY b.ordering ASC, a.product_id ASC'; $database = JFactory::getDBO(); $database->setQuery($query); $elements = $database->loadObjectList(); if(empty($elements)){ return; } $this->modules = $config->get('product_show_modules',''); $module = hikashop_get('helper.module'); $this->modules = $module->setModuleData($this->modules); $currencyClass = hikashop_get('class.currency'); $currency_id = hikashop_getCurrency(); if($config->get('tax_zone_type','shipping')=='billing'){ $zone_id = hikashop_getZone('billing'); }else{ $zone_id = hikashop_getZone('shipping'); } $cart = hikashop_get('helper.cart'); $this->assignRef('cart',$cart); $this->selected_variant_id=0; $productClass=hikashop_get('class.product'); $this->assignRef('currencyHelper',$currencyClass); $fieldsClass = hikashop_get('class.field'); $this->assignRef('fieldsClass',$fieldsClass); $classbadge = hikashop_get('class.badge'); $this->assignRef('classbadge',$classbadge); $fields = array( 0 => array() ); $unset=array(); $done = array(); foreach($elements as $k => $element) { $product_id = $element->product_id; if(isset($done[$product_id])){ $unset[]=$k; continue; }else{ $done[$product_id]=$product_id; } if( $element->product_type == 'variant' ) { $filters = array('a.product_id='.$element->product_parent_id); hikashop_addACLFilters($filters,'product_access','a'); $query = 'SELECT a.*,b.* FROM '.hikashop_table('product').' AS a LEFT JOIN '.hikashop_table('product_category').' AS b ON a.product_id = b.product_id WHERE '.implode(' AND ',$filters). ' LIMIT 1'; $database->setQuery($query); $elements[$k] = $database->loadObject(); if(empty($elements[$k])){ return; } $k = array_search($product_id,$cids); if( $k !== false ) { $cids[$k] = $element->product_id; } } $productClass->addAlias($elements[$k]); if(!$elements[$k]->product_published){ return; } if( $compare_inc_lastseen ) { $prod = new stdClass(); $prod->product_id = $product_id; $prod->product_hit = $element->product_hit+1; $prod->product_last_seen_date = time(); $productClass->save($prod,true); } $f = $fieldsClass->getFields('frontcomp',$element,'product','checkout&task=state'); $fields[$element->product_id] =& $f; foreach($f as $i => $v) { $fields[0][$i] = $v; } } if(!empty($unset)){ foreach($unset as $u){ unset($elements[$u]); } } $query = 'SELECT * FROM '.hikashop_table('file').' WHERE file_ref_id IN ('.implode(',',$cids).') AND file_type IN (\'product\',\'file\') ORDER BY file_ref_id ASC, file_ordering ASC, file_id ASC'; $database->setQuery($query); $product_files = $database->loadObjectList(); if(!empty($product_files)){ foreach($elements as $k => $element) { $productClass->addFiles($elements[$k],$product_files); } } $currencyClass->getPrices($elements,$cids,$currency_id,$main_currency,$zone_id,$discount_before_tax); $this->assignRef('elements',$elements); $image = hikashop_get('helper.image'); $this->assignRef('image',$image); $this->assignRef('fields',$fields); $url = $this->init(); $cart->getJS($url); $this->assignRef('redirect_url',$url); } function addCharacteristics(&$element,&$mainCharacteristics,&$characteristics){ $element->characteristics = @$mainCharacteristics[$element->product_id][0]; if(!empty($element->characteristics) && is_array($element->characteristics)){ foreach($element->characteristics as $k => $characteristic){ if(!empty($mainCharacteristics[$element->product_id][$k])){ $element->characteristics[$k]->default=end($mainCharacteristics[$element->product_id][$k]); }else{ $app =& JFactory::getApplication(); $app->enqueueMessage('The default value of one of the characteristics of that product isn\'t available as a variant. Please check the characteristics and variants of that product'); } } } if(!empty($element->variants)){ foreach($characteristics as $characteristic){ foreach($element->variants as $k => $variant){ if($variant->product_id==$characteristic->variant_product_id){ $element->variants[$k]->characteristics[$characteristic->characteristic_parent_id]=$characteristic; $element->characteristics[$characteristic->characteristic_parent_id]->values[$characteristic->characteristic_id]=$characteristic; if($this->selected_variant_id && $variant->product_id==$this->selected_variant_id){ $element->characteristics[$characteristic->characteristic_parent_id]->default=$characteristic; } } } } if(isset($_REQUEST['hikashop_product_characteristic'])){ if(is_array($_REQUEST['hikashop_product_characteristic'])){ JArrayHelper::toInteger($_REQUEST['hikashop_product_characteristic']); $chars = $_REQUEST['hikashop_product_characteristic']; }else{ $chars = JRequest::getCmd('hikashop_product_characteristic',''); $chars = explode('_',$chars); } if(!empty($chars)){ foreach($element->variants as $k => $variant){ $chars = array(); foreach($variant->characteristics as $val){ $i = 0; $ordering = @$element->characteristics[$val->characteristic_parent_id]->ordering; while(isset($chars[$ordering])&& $i < 30){ $i++; $ordering++; } $chars[$ordering] = $val; } ksort($chars); $element->variants[$k]->characteristics=$chars; $variant->characteristics=$chars; $choosed = true; foreach($variant->characteristics as $characteristic){ $ok = false; foreach($chars as $k => $char){ if(!empty($char)){ if($characteristic->characteristic_id==$char){ $ok = true; break; } } } if(!$ok){ $choosed=false; }else{ $element->characteristics[$characteristic->characteristic_parent_id]->default=$characteristic; } } if($choosed){ break; } } } } foreach($element->variants as $k => $variant){ $temp=array(); foreach($element->characteristics as $k2 => $characteristic2){ if(!empty($variant->characteristics)){ foreach($variant->characteristics as $k3 => $characteristic3){ if($k2==$k3){ $temp[$k3]=$characteristic3; break; } } } } $element->variants[$k]->characteristics=$temp; } } } function setDefault(&$element){ if(!empty($element->characteristics)&&!empty($element->variants)){ $match = false; if(!isset($element->main) || is_null($element->main))$element->main= new stdClass(); foreach($element->variants as $k => $variant){ $default = true; foreach($element->characteristics as $characteristic){ $found=false; foreach($variant->characteristics as $k => $characteristic2){ if(!empty($characteristic->default->characteristic_id) && $characteristic2->characteristic_id==$characteristic->default->characteristic_id){ $found=true; break; } } if(!$found){ $default = false; break; } } if($default){ foreach(get_object_vars($variant) as $field=>$value){ if(isset($element->$field)) $element->main->$field=$element->$field; else $element->main->$field =''; if(!in_array($field, array('product_keywords','product_meta_description','product_page_title','product_canonical','product_alias','product_url'))) $element->$field = $value; } $match = true; break; } } if(!$match){ $variant = reset($element->variants); foreach(get_object_vars($variant) as $field=>$value){ $element->main->$field=@$element->$field; $element->$field = $value; } } } } function checkVariants(&$element){ if(!empty($element->characteristics)){ $mapping = array(); foreach($element->characteristics as $characteristic){ $tempmapping = array(); if(!empty($characteristic->values) && !empty($characteristic->characteristic_id)){ foreach($characteristic->values as $k => $value){ if(empty($mapping)){ $tempmapping[]=array($characteristic->characteristic_id=>$k); }else{ foreach($mapping as $val){ $val[$characteristic->characteristic_id]=$k; $tempmapping[]=$val; } } } } $mapping = $tempmapping; } if(empty($element->variants)){ $element->variants = array(); } $productClass = hikashop_get('class.product'); foreach($mapping as $map){ $found=false; foreach($element->variants as $k2 => $variant){ $ok = true; foreach($map as $k => $id){ if(empty($variant->characteristics[$k]->characteristic_id) || $variant->characteristics[$k]->characteristic_id != $id){ $ok = false; break; } } if($ok){ $found = true; $productClass->checkVariant($element->variants[$k2],$element,$map); break; } } if(!$found){ $new = new stdClass; $new->product_published = 0; $new->product_quantity = 0; $productClass->checkVariant($new,$element,$map); $element->variants[$new->map]=$new; } } } } function _getCheckoutURL(){ global $Itemid; $url_itemid=''; if(!empty($Itemid)){ $url_itemid='&Itemid='.$Itemid; } return hikashop_completeLink('checkout'.$url_itemid,false,true); } function init($cart=false){ $config =& hikashop_config(); $url = $config->get('redirect_url_after_add_cart','stay_if_cart'); switch($url){ case 'checkout': $url = $this->_getCheckoutURL(); break; case 'stay_if_cart': $url=''; if(!$cart){ $url = $this->_getCheckoutURL(); break; } case 'ask_user': case 'stay': $url=''; case '': default: if(empty($url)){ $url = hikashop_currentURL('return_url'); } break; } return urlencode($url); } function cart(){ $module = hikashop_get('helper.module'); $module->initialize($this); if(!HIKASHOP_PHP5) { $app =& JFactory::getApplication(); $database =& JFactory::getDBO(); $config =& hikashop_config(); } else { $app = JFactory::getApplication(); $database = JFactory::getDBO(); $config = hikashop_config(); } $currencyClass = hikashop_get('class.currency'); $class = hikashop_get('class.cart'); $productClass = hikashop_get('class.product'); $main_currency = (int)$config->get('main_currency',1); $currency_id = hikashop_getCurrency(); if($config->get('tax_zone_type','shipping')=='billing'){ $zone_id = hikashop_getZone('billing'); }else{ $zone_id = hikashop_getZone('shipping'); } $discount_before_tax = (int)$config->get('discount_before_tax',0); $cart_type = $this->params->get('cart_type','cart'); $cart_id =$app->getUserState( HIKASHOP_COMPONENT.'.'.$cart_type.'_id', 0, 'int' ); $class->get($cart_id,true,$cart_type); $full = $class->loadFullCart(true); $rows = $full->products; $total = new stdClass(); $total =& $full->total; $this->assignRef('total',$total); $this->assignRef('rows',$rows); $this->assignRef('config',$config); $cart=hikashop_get('helper.cart'); $this->assignRef('cart',$cart); $this->assignRef('currencyHelper',$currencyClass); $cart->cartCount(true); $url = $this->init(true); $this->params->set('url',$url); ob_start(); $cart->getJS($url,false); $notice_html = ob_get_clean(); $this->assignRef('notice_html',$notice_html); if(hikashop_level(2)){ $null=null; $fieldsClass=hikashop_get('class.field'); $itemFields = $fieldsClass->getFields('frontcomp',$null,'item','checkout&task=state'); $this->assignRef('itemFields',$itemFields); $this->assignRef('fieldsClass',$fieldsClass); } } function contact(){ $user = hikashop_loadUser(true); $this->assignRef('element',$user); $app = JFactory::getApplication(); $product_id = (int)hikashop_getCID('product_id'); $config =& hikashop_config(); $this->assignRef('config',$config); $filters=array('a.product_id='.$product_id); hikashop_addACLFilters($filters,'product_access','a'); $query = 'SELECT a.*,b.product_category_id, b.category_id, b.ordering FROM '.hikashop_table('product').' AS a LEFT JOIN '.hikashop_table('product_category').' AS b ON a.product_id = b.product_id WHERE '.implode(' AND ',$filters). ' LIMIT 1'; $database = JFactory::getDBO(); $database->setQuery($query); $element = $database->loadObject(); if(empty($element)){ return; } if($element->product_type=='variant'){ $this->selected_variant_id = $product_id; $filters=array('a.product_id='.$element->product_parent_id); hikashop_addACLFilters($filters,'product_access','a'); $query = 'SELECT a.*,b.* FROM '.hikashop_table('product').' AS a LEFT JOIN '.hikashop_table('product_category').' AS b ON a.product_id = b.product_id WHERE '.implode(' AND ',$filters). ' LIMIT 1'; $database->setQuery($query); $element = $database->loadObject(); if(empty($element)){ return; } $product_id = $element->product_id; } $productClass = hikashop_get('class.product'); $productClass->addAlias($element); if(!$element->product_published){ return; } $this->assignRef('product',$element); global $Itemid; $url_itemid=''; if(!empty($Itemid)){ $url_itemid='&Itemid='.$Itemid; } $product_url = hikashop_completeLink('product&task=show&cid='.(int)$element->product_id.'&name='.$element->alias.$url_itemid); $this->assignRef('product_url',$product_url); } function status(){ $app =& JFactory::getApplication(); $shipping_method=$app->getUserState( HIKASHOP_COMPONENT.'.shipping_method' ); $shipping_id=$app->getUserState( HIKASHOP_COMPONENT.'.shipping_id' ); $shipping_data=$app->getUserState( HIKASHOP_COMPONENT.'.shipping_data' ); $payment_method=$app->getUserState( HIKASHOP_COMPONENT.'.payment_method' ); $payment_id=$app->getUserState( HIKASHOP_COMPONENT.'.payment_id' ); $payment_data=$app->getUserState( HIKASHOP_COMPONENT.'.payment_data' ); $address=$app->getUserState( HIKASHOP_COMPONENT.'.shipping_address' ); $this->assignRef('payment_method',$payment_method); $this->assignRef('payment_id',$payment_id); $this->assignRef('payment_data',$payment_data); $this->assignRef('shipping_method',$shipping_method); $this->assignRef('shipping_id',$shipping_id); $this->assignRef('shipping_data',$shipping_data); } function waitlist(){ $user = hikashop_loadUser(true); $this->assignRef('element',$user); $app = JFactory::getApplication(); $product_id = (int)hikashop_getCID('product_id'); $config =& hikashop_config(); $this->assignRef('config',$config); $filters=array('a.product_id='.$product_id); hikashop_addACLFilters($filters,'product_access','a'); $query = 'SELECT a.*,b.product_category_id, b.category_id, b.ordering FROM '.hikashop_table('product').' AS a LEFT JOIN '.hikashop_table('product_category').' AS b ON a.product_id = b.product_id WHERE '.implode(' AND ',$filters). ' LIMIT 1'; $database = JFactory::getDBO(); $database->setQuery($query); $element = $database->loadObject(); if(empty($element)){ return; } if($element->product_type=='variant'){ $this->selected_variant_id = $product_id; $filters=array('a.product_id='.$element->product_parent_id); hikashop_addACLFilters($filters,'product_access','a'); $query = 'SELECT a.*,b.* FROM '.hikashop_table('product').' AS a LEFT JOIN '.hikashop_table('product_category').' AS b ON a.product_id = b.product_id WHERE '.implode(' AND ',$filters). ' LIMIT 1'; $database->setQuery($query); $main = $database->loadObject(); if(empty($main)){ return; } $main->variants =array($element); $element = $main; $product_id = $element->product_id; $ids = array($element->variants[0]->product_id,$product_id); $query = 'SELECT a.*,b.* FROM '.hikashop_table('variant').' AS a LEFT JOIN '.hikashop_table('characteristic').' AS b ON a.variant_characteristic_id=b.characteristic_id WHERE a.variant_product_id IN ('.implode(',',$ids).') ORDER BY a.ordering,b.characteristic_value'; $database->setQuery($query); $characteristics = $database->loadObjectList(); if(!empty($characteristics)){ $mainCharacteristics = array(); foreach($characteristics as $characteristic){ if($product_id==$characteristic->variant_product_id){ $mainCharacteristics[$product_id][$characteristic->characteristic_parent_id][$characteristic->characteristic_id]=$characteristic; } } $cartClass = hikashop_get('class.cart'); $cartClass->addCharacteristics($element,$mainCharacteristics,$characteristics); $productClass = hikashop_get('class.product'); $productClass->checkVariant($element->variants[0],$element); $element=$element->variants[0]; } } $productClass = hikashop_get('class.product'); $productClass->addAlias($element); if(!$element->product_published){ return; } $this->assignRef('product',$element); global $Itemid; $url_itemid=''; if(!empty($Itemid)){ $url_itemid='&Itemid='.$Itemid; } $product_url = hikashop_completeLink('product&task=show&cid='.(int)$element->product_id.'&name='.$element->alias.$url_itemid); $this->assignRef('product_url',$product_url); } function pagination_display($type, $divName, $id, $currentId, $position, $products){ if($position=='top' || $position=='bottom'){ if($type=='numbers'){ echo ''.($id+1).''; } if($type=='rounds'){ echo ''; } if($type=='thumbnails'){ echo ''; } if($type=='names'){ echo ''; } } else{ if($type=='numbers'){ echo ''.($id+1).'
'; } if($type=='rounds'){ echo '
'; } if($type=='thumbnails'){ echo ''; } if($type=='names'){ echo ''; } } } function scaleImage($x, $y, $cx, $cy){ if(empty($cx)){ $cx = ($x*$cy)/$y; } if(empty($cy)){ $cy = ($y*$cx)/$x; } return array($cx,$cy); } function checkSize(&$width,&$height,&$row){ $imageHelper = hikashop_get('helper.image'); $imageHelper->checkSize($width,$height,$row); } function add_to_cart_listing(){ if($this->params->get('display_custom_item_fields','-1')=='-1'){ $config =& hikashop_config(); $default_params = $config->get('default_params'); $this->params->set('display_custom_item_fields',@$default_params['display_custom_item_fields']); } $obj=$_SESSION['hikashop_product']; $this->row =& $obj; $this->params->set('js',1); $config =& hikashop_config(); $this->assignRef('config',$config); $cart=hikashop_get('helper.cart'); $this->assignRef('cart',$cart); $cart->cartCount(true); $url = $this->init(true); $this->params->set('url',$url); $cart->getJS($url); $this->assignRef('redirect_url',$url); $this->category_pathway = ''; global $Itemid; $url_itemid=''; if(!empty($Itemid)){ $url_itemid='&Itemid='.$Itemid; } $this->assignRef('itemid',$url_itemid); $fieldsClass = hikashop_get('class.field'); if(JRequest::getInt('popup')){ $js = $this->getJS(); if(!empty($js)){ echo ''; $modal = JHTML::script('system/modal.js',false,true,true); $body = JResponse::getBody(); if(!strpos($body,'function hikashopModifyQuantity(')){ $body=str_replace('','',$body); JResponse::setBody($body); } if(!strpos($body,$modal)){ $conf = JFactory::getConfig(); if(HIKASHOP_J30){ $debug = $conf->get('debug'); } else { $debug = $conf->getValue('config.debug'); } $mootools = JHtml::script('system/mootools-core.js', false, true, true, false, $debug); if(!strpos($body,$mootools))$body=str_replace('','',$body); $core = JHtml::script('system/core.js', false, true,true); if(!strpos($body,$core))$body=str_replace('','',$body); if(!HIKASHOP_J16){ $modalcss = JHtml::stylesheet('system/modal.css', '',array()); }else{ $modalcss = JHtml::stylesheet('system/modal.css', array(), true,true); } $body=str_replace('','',$body); $body=str_replace('','',$body); $js=" window.addEvent('domready', function() { SqueezeBox.initialize(); SqueezeBox.assign($$('a.modal'), { parse: 'rel' }); });"; $body=str_replace('','',$body); JResponse::setBody($body); } } } $this->assignRef('fieldsClass',$fieldsClass); } function listing_price(){ $obj=$_SESSION['hikashop_product']; $this->row =& $obj; $currencyHelper = hikashop_get('class.currency'); $this->assignRef('currencyHelper',$currencyHelper); } }