'filter_id');
function saveForm(){
$app = JFactory::getApplication();
$filter = new stdClass();
$filter->filter_id = hikashop_getCID('filter_id');
$new=false;
$problem=false;
if(empty($filter->filter_id)) $new = true;
$formData = JRequest::getVar( 'data', array(), '', 'array' );
foreach($formData['filter'] as $column => $value){
hikashop_secureField($column);
if(is_array($value)){
$value = implode(',',$value);
}
$filter->$column = strip_tags($value);
}
if(empty($filter->filter_name)){
$app->enqueueMessage(JText::_('SPECIFY_A_NAME'), 'error');
$problem = true;
}
if(empty($filter->filter_id)){
$filter->filter_namekey=$filter->filter_name;
$search = explode(",","ç,æ,œ,á,é,í,ó,ú,à,è,ì,ò,ù,ä,ë,ï,ö,ü,ÿ,â,ê,î,ô,û,å,e,i,ø,u");
$replace = explode(",","c,ae,oe,a,e,i,o,u,a,e,i,o,u,a,e,i,o,u,y,a,e,i,o,u,a,e,i,o,u");
$test = str_replace($search, $replace, $filter->filter_namekey);
$test=preg_replace('#[^a-z0-9_-]#i','',$test);
if(empty($test)){
$query = 'SELECT MAX(`filter_id`) FROM '.hikashop_table('filter');
$this->database->setQuery($query);
$last_pid = $this->database->loadResult();
$last_pid++;
$filter->filter_namekey = 'filter_'.$last_pid;
}else{
$query = 'SELECT filter_id FROM '.hikashop_table('filter').' WHERE filter_namekey = '.$this->database->Quote($filter->filter_name).' AND filter_id!='.(int)$filter->filter_id.' LIMIT 1';
$this->database->setQuery($query);
if($this->database->loadResult()){
$app = JFactory::getApplication();
$app->enqueueMessage(JText::_( 'DUPLICATE_PRODUCT' ), 'error');
JRequest::setVar( 'fail', $filter );
return false;
}
$test = str_replace($search, $replace, $filter->filter_name);
$filter->filter_namekey = preg_replace('#[^a-z0-9_-]#i','_',$test);
}
}
if($formData['filter']['filter_type']=='text'){
$filter->filter_data=serialize(@$formData['filter']['filter_data_text']);
}else if($formData['filter']['filter_type']=='cursor'){
$filter->filter_data=serialize(@$formData['filter']['filter_data_cursor']);
}else{
$filter->filter_data=serialize(@$formData['filter']['filter_data']);
}
if($formData['filter']['filter_type']=='checkbox' && $formData['filter']['filter_data']=='sort'){
$app->enqueueMessage(JText::sprintf('NOT_COMPAT_WITH_SORTING',JText::_('FIELD_CHECKBOX'),JText::_('FIELD_RADIO')));
$filter->filter_type='radio';
}
if($formData['filter']['filter_type']=='multipledropdown' && $formData['filter']['filter_data']=='sort'){
$app->enqueueMessage(JText::sprintf('NOT_COMPAT_WITH_SORTING',JText::_('FIELD_MULTIPLEDROPDOWN'),JText::_('FIELD_SINGLEDROPDOWN')));
$filter->filter_type='singledropdown';
}
if(($formData['filter']['filter_type']=='checkbox' || $formData['filter']['filter_type']=='radio' || $formData['filter']['filter_type']=='cursor') && @$formData['filter']['title_position']=='inside'){
$app->enqueueMessage(JText::_('NO_TITLE_INSIDE'));
$filter->filter_options['title_position']='top';
}else{
$filter->filter_options['title_position']=@$formData['filter']['title_position'];
}
if(empty($formData['filter']['filter_currencies']) && $formData['filter']['filter_data']=='price' && $formData['filter']['filter_type']!='text' && $formData['filter']['filter_type']!='cursor'){
$app->enqueueMessage(JText::_('NO_CURRENCY_SELECTED'));
$formData['filter']['filter_currencies']=array();
$formData['filter']['filter_currencies'][0]=1;
}
if($formData['filter']['filter_data']=='custom_field'){
if($formData['filter']['filter_category_childs']){
$categories_filter=array();
$categoryClass = hikashop_get('class.category');
$childs = $categoryClass->getChilds($formData['filter']['filter_category_id'],true);
foreach($childs as $cat){
$categories_filter[]='field_categories LIKE \'%,'.$cat->category_id.',%\'';
}
$filters=implode(' OR ',$categories_filter);
if(empty($filters)){
$filters.= ' field_categories LIKE \'%,'.(int)$formData['filter']['filter_category_id'].',%\'';
}else{
$filters.= 'OR field_categories LIKE \'%,'.(int)$formData['filter']['filter_category_id'].',%\'';
}
}else{
$filters= 'field_categories LIKE \'%,'.(int)$formData['filter']['filter_category_id'].',%\'';
}
$found=false;
if(!empty($formData['filter']['custom_field'])){
$database = JFactory::getDBO();
$database->setQuery('SELECT * FROM '.hikashop_table('field').' WHERE ('.$filters.' OR field_categories LIKE "all") AND field_table IN ("product") AND field_published=1');
$fields=$database->loadObjectList('field_realname');
if(!empty($fields)){
foreach($fields as $field){
if($field->field_namekey==$formData['filter']['custom_field']){
$filter->filter_options['custom_field']=$formData['filter']['custom_field'];
$found=true;
break;
}
}
}
}
if(!$found){
$app->enqueueMessage(JText::_('CUSTOM_FIELD_NOT_AVAILABLE_FOR_CATEGORY'));
if(!empty($fields)){
$fields=reset($fields);
$filter->filter_options['custom_field']=$fields->field_namekey;
}else{
$filter->filter_options['custom_field']='';
}
}
}
$filterValues = JRequest::getVar('filter_values', array(), '', 'array' );
if(!empty($filterValues)){
$filterValuesFinal=array();
foreach($filterValues['value'] as $key => $value){
if(is_numeric($value)){
$filterValuesFinal[]= strip_tags($key).'::'.strip_tags($value);
}
}
$filter->filter_value=implode("\n",$filterValuesFinal);
}
$filter->filter_options['column_width']=$formData['filter']['column_width'];
if(!empty($formData['filter']['filter_size'])){
$filter->filter_options['filter_size']=$formData['filter']['filter_size'];
}else{
$filter->filter_options['filter_size']=1;
}
if($formData['filter']['filter_type']=='cursor'){
$filter->filter_options['cursor_number']=$formData['filter']['cursor_number'];
if(empty($formData['filter']['cursor_min'])){
$formData['filter']['cursor_min']='0';
}
if(empty($formData['filter']['cursor_max']) || $formData['filter']['cursor_min']==$formData['filter']['cursor_max']){
$app->enqueueMessage(JText::_('MIN_MAX_NOT_SET'), 'error');
$problem = true;
}
$filter->filter_options['cursor_min']=$formData['filter']['cursor_min'];
$filter->filter_options['cursor_max']=$formData['filter']['cursor_max'];
$filter->filter_options['cursor_step']=$formData['filter']['cursor_step'];
$filter->filter_options['cursor_effect']=$formData['filter']['cursor_effect'];
$filter->filter_options['cursor_width']=$formData['filter']['cursor_width'];
$filter->filter_options['cursor_width']=$formData['filter']['cursor_width'];
$filter->filter_options['title_position']=$formData['filter']['title_position_cursor'];
}
if(!empty($formData['filter']['defined_limits'])){
$filter->filter_options['defined_limits']=@$formData['filter']['defined_limits'];
}
if($formData['filter']['filter_data']=='price'){
$filter->filter_options['currencies']=@$formData['filter']['filter_currencies'];
}
if($formData['filter']['filter_type']=='text'){
$filter->filter_options['max_char']=$formData['filter']['max_char'];
$filter->filter_options['textBoxSize']=$formData['filter']['textBoxSize'];
$filter->filter_options['searchProcessing']=$formData['filter']['searchProcessing'];
}
if($formData['filter']['filter_data']=='characteristic'){
$filter->filter_options['filter_charac']=$formData['filter']['filter_charac'];
}
if($formData ['filter']['filter_data']=='information' || $formData ['filter']['filter_type']=='cursor'){
if(($formData['filter']['product_information']=='weight' && $formData ['filter']['filter_type']!='cursor') || (($formData['filter']['filter_data_cursor']=='weight' && $formData ['filter']['filter_type']=='cursor')) ){
$filter->filter_options['information_unit']=$formData['filter']['weight_unit'];
}else{
$filter->filter_options['information_unit']=$formData['filter']['dimension_unit'];
}
}
if($formData ['filter']['filter_type']!='cursor'){
$filter->filter_options['product_information']=$formData['filter']['product_information'];
}else{
$filter->filter_options['product_information']=$formData['filter']['filter_data'];
}
$filter->filter_options['button_align']=$formData['filter']['button_align'];
if($formData['filter']['filter_data']=='sort'){
if(isset($formData['filter']['sort_by'])){
$filter->filter_options['sort_by']=$formData['filter']['sort_by'];
}else{
$app->enqueueMessage(JText::_('CHOOSE_SORT_OPTIONS'), 'error');
$problem = true;
}
}
$filter->filter_options['parent_category_id']=$formData['filter']['parent_category_id'];
unset($filter->column_width);
unset($filter->title_position);
unset($filter->filter_size);
unset($filter->cursor_number);
unset($filter->cursor_min);
unset($filter->cursor_max);
unset($filter->filter_currencies);
unset($filter->max_char);
unset($filter->defined_limits);
unset($filter->filter_charac);
unset($filter->sort_by);
unset($filter->product_information);
unset($filter->custom_field);
unset($filter->filter_data_text);
unset($filter->filter_data_cursor);
unset($filter->button_align);
unset($filter->dimension_unit);
unset($filter->weight_unit);
unset($filter->information_unit);
unset($filter->parent_category_id);
unset($filter->textBoxSize);
unset($filter->cursor_step);
unset($filter->cursor_effect);
unset($filter->cursor_width);
unset($filter->title_position_cursor);
unset($filter->searchProcessing);
if($problem){
JRequest::setVar( 'fail', $filter );
}else{
$status = $this->save($filter);
if($new && $status){
$orderClass = hikashop_get('helper.order');
$orderClass->pkey = 'filter_id';
$orderClass->table = 'filter';
$orderClass->orderingMap = 'filter_ordering';
$orderClass->reOrder();
}
JRequest::setVar( 'filter_id', $filter->filter_id);
return $status;
}
return false;
}
function save(&$filter){
if(isset($filter->filter_options) && is_array($filter->filter_options)){
$filter->filter_options=serialize($filter->filter_options);
}
$return = parent::save($filter);
return $return;
}
function getFilters($category_id){
$database = JFactory::getDBO();
$conditions = array('filter_published = 1');
hikashop_addACLFilters($conditions,'filter_access');
$query='SELECT * FROM '.hikashop_table('filter').' WHERE '.implode(' AND ',$conditions).' ORDER BY filter_ordering';
$database->setQuery($query);
$filters=$database->loadObjectList();
$filterList=array();
foreach($filters as $filter){
$filter->filter_options=unserialize($filter->filter_options);
$filter->filter_data=unserialize($filter->filter_data);
if(!empty($filter->filter_value)){
$filter->filter_value=explode("\n", $filter->filter_value);
foreach($filter->filter_value as $key => $val){
$temp=explode("::", $val);
$filter->filter_value[$key]=$temp[1];
}
sort($filter->filter_value);
}
}
if(!empty($category_id)){
$categoryClass = hikashop_get('class.category');
$parents = $categoryClass->getParents($category_id);
foreach($filters as $filter){
if(empty($filter->filter_category_id) || $filter->filter_category_id==$category_id){
$filterList[]=$filter;
}else{
if($filter->filter_category_childs==1){
foreach($parents as $parent){
if($parent->category_id == $filter->filter_category_id){
$filterList[]=$filter;
break;
}
}
}
}
}
}else{
return $filters;
}
return $filterList;
}
function displayFilter($filter, $divName, &$parent, $datas=''){
$html ='';
if($filter->filter_type=='text' || $filter->filter_type=='singledropdown' || $filter->filter_type=='multipledropdown' || $filter->filter_type=='radio' || $filter->filter_type=='list' || $filter->filter_type=='checkbox' || $filter->filter_type=='cursor' || $filter->filter_type=='instockcheckbox'){
$classType = 'hikashop'.ucfirst($filter->filter_type).'Class';
$class = new $classType();
$html = $class->display($filter, $divName, $parent, $datas);
}else{
JPluginHelper::importPlugin( 'hikashop' );
$dispatcher = JDispatcher::getInstance();
$dispatcher->trigger( 'onFilterDisplay', array( & $filter ,&$html, &$divName, &$parent, &$datas) );
}
return $html;
}
function addFilter(&$filter,&$filters,&$select,&$select2,&$a,&$b,&$on,&$order,&$parent, $divName){
if($filter->filter_type=='text' || $filter->filter_type=='singledropdown' || $filter->filter_type=='multipledropdown' || $filter->filter_type=='radio' || $filter->filter_type=='list' || $filter->filter_type=='checkbox' || $filter->filter_type=='cursor' || $filter->filter_type=='instockcheckbox'){
$classType = 'hikashop'.ucfirst($filter->filter_type).'Class';
$class = new $classType();
$html = $class->addFilter($filter,$filters,$select,$select2,$a,$b,$on,$order,$parent, $divName);
}else{
JPluginHelper::importPlugin( 'hikashop' );
$dispatcher = JDispatcher::getInstance();
$dispatcher->trigger( 'onFilterAdd', array( & $filter ,&$filters, &$select, &$select2, &$a, &$b, &$on, &$order, &$divName, &$parent) );
}
}
function getFieldToLoad($filter, $divName, &$parent){
$html ='';
if($filter->filter_type=='text' || $filter->filter_type=='singledropdown' || $filter->filter_type=='multipledropdown' || $filter->filter_type=='radio' || $filter->filter_type=='list' || $filter->filter_type=='checkbox' || $filter->filter_type=='cursor' || $filter->filter_type=='instockcheckbox'){
$classType = 'hikashop'.ucfirst($filter->filter_type).'Class';
$class = new $classType();
$html = $class->getFieldToLoad($filter, $divName, $parent);
}else{
JPluginHelper::importPlugin( 'hikashop' );
$dispatcher = JDispatcher::getInstance();
$dispatcher->trigger( 'onFilterToLoad', array( & $filter ,&$html, &$divName, &$parent) );
}
return $html;
}
function getProductList(&$parent, $filters){
$fields='';
$datas = array();
if(!empty($filters)){
foreach($filters as $filter){
$fields[$filter->filter_namekey]=$this->getFieldToLoad($filter, $parent->params->get('main_div_name'), $parent);
if($filter->filter_data=='category' && strpos($parent->listingQuery,'LEFT JOIN')===false){
$parent->listingQuery=str_replace('WHERE','LEFT JOIN '.hikashop_table('product_category').' as a ON b.product_id=a.product_id WHERE',$parent->listingQuery);
}
}
}
$fieldsLimits = array();
if(!empty($fields)){
foreach($fields as $key => $field){
if(empty($field)){
unset($fields[$key]);
}else{
$fields[$key]=$field;
$fieldsLimits[]='max('.$field.') as max_'.$key.'';
$fieldsLimits[]='min('.$field.') as min_'.$key.'';
}
}
$fields=implode(', ', $fields);
if(!empty($fields)){ $fields=','.$fields; }
}
if(!empty($fieldsLimits)){
$fieldsLimits=implode(', ', $fieldsLimits);
$fieldsLimits=','.$fieldsLimits;
}else{
$fieldsLimits='';
}
$database = JFactory::getDBO();
$query='SELECT DISTINCT b.product_id'.$fields.' '.$parent->listingQuery;
$database->setQuery($query);
$datas['products']=$database->loadObjectList();
$query='SELECT DISTINCT b.product_id'.$fieldsLimits.' '.$parent->listingQuery;
$database->setQuery($query);
$datas['limits']=$database->loadObject();
return $datas;
}
function cleanFilter($filter){
if($filter->filter_type!='cursor' && $filter->filter_type!='instockcheckbox' && $filter->filter_data=='price' ){
$currency = hikashop_getCurrency();
if(!empty($filter->filter_options['currencies']) && !in_array($currency, $filter->filter_options['currencies'])){
return false;
}
if(empty($filter->filter_value)){
return false;
}
}
return true;
}
}
class hikashopFilterTypeClass extends hikashopClass{
var $receivedFilter = '';
function display($filter, $divName, &$parent, $completion=''){
$app = JFactory::getApplication();
$cid = JRequest::getInt("cid",'itemid_'.JRequest::getInt("Itemid",0));
if(JRequest::getVar('reseted')==1){
return array();
$app->setUserState('com_hikashop.'.$cid.'_filter_'.$filter->filter_namekey.$completion, '');
}
if(JRequest::getVar('filtered')==1){
$infoGet = JRequest::getVar('filter_'.$filter->filter_namekey.$completion);
$app->setUserState('com_hikashop.'.$cid.'_filter_'.$filter->filter_namekey.$completion, $infoGet);
}else{
$infoGet = $app->getUserStateFromRequest( 'com_hikashop.'.$cid.'_filter_'.$filter->filter_namekey.$completion, 'filter_'.$filter->filter_namekey.$completion);
}
if(!empty($infoGet)){
$copyGet=$infoGet[0];
$result=explode(',',$copyGet);
if(!($result[0]==$infoGet[0])){
foreach($result as $key => $res){
$infoGet[$key]=$res;
}
}
}
return $infoGet;
}
function addFilter(&$filter,&$filters,&$select,&$select2, &$a,&$b,&$on,&$order,&$parent, $divName){
static $i = 0;
$i++;
$app = JFactory::getApplication();
$database = JFactory::getDBO();
$infoGet= array();
static $pagination_reset = false;
if(!$pagination_reset){
$new_filter = JRequest::getVar('filter_'.$filter->filter_namekey,null);
if(!is_null($new_filter)){
$module = hikashop_get('helper.module');
$module->initialize($this);
$cid = JRequest::getInt("cid",$this->params->get('selectparentlisting'));
if($this->params->get('content_type')!='product'){
foreach($this->modules as $module){
$main_div_name ='hikashop_category_information_module_'.$module->id;
JRequest::setVar('limitstart_'.$main_div_name.'_'.$cid,0);
}
}else{
JRequest::setVar('limitstart_'.$this->params->get('main_div_name').'_'.$cid,0);
}
$pagination_reset=true;
}
}
$cid = JRequest::getInt("cid",'itemid_'.JRequest::getInt("Itemid",0));
if(JRequest::getVar('filtered')==1){
$infoGet = JRequest::getVar('filter_'.$filter->filter_namekey);
$app->setUserState('com_hikashop.'.$cid.'_filter_'.$filter->filter_namekey, $infoGet);
}else{
$infoGet = $app->getUserStateFromRequest( 'com_hikashop.'.$cid .'_filter_'.$filter->filter_namekey, 'filter_'.$filter->filter_namekey, $infoGet, 'array' );
}
if(JRequest::getVar('reseted')==1){
$app->setUserState('com_hikashop.'.$cid.'_filter_'.$filter->filter_namekey, '');
return array();
}
if(!empty($infoGet)&& !is_array($infoGet)){
$infoGet = array($infoGet);
}
if(isset($infoGet[0])){
$infoGet[0] = trim($infoGet[0]);
}
if(isset($infoGet) && !empty($infoGet[0])){
if($filter->filter_type=='instockcheckbox' && $infoGet[0]=='in_stock'){
$filters[]=' b.product_quantity!=0 ';
}
if($filter->filter_type=='text'){
if($filter->filter_name == $infoGet[0]){
return false;
}
if(!empty($filter->filter_options['max_char']) && strlen($infoGet[0])>$filter->filter_options['max_char']){
$app->enqueueMessage(JTEXT::_( 'TEXT_ENTERED_TOO_LONG' ));
return false;
}
if(empty($filter->filter_data) || $filter->filter_data[0]=='all'){
$query = 'SELECT * FROM '.hikashop_table('product').' LIMIT 1';
$database->setQuery($query);
$object = $database->loadObject();
foreach($object as $key => $obj){
$searchField[]=$key;
}
}else{
$searchField=$filter->filter_data;
}
$list=array();
$translationFilters=array();
$translationList=array();
$fields=array();
$searchProcessing='any';
if(isset($filter->filter_options['searchProcessing']))
$searchProcessing=$filter->filter_options['searchProcessing'];
$terms=$infoGet[0];
if(!isset($filter->filter_options['searchProcessing'])) $filter->filter_options['searchProcessing']='any';
if($filter->filter_options['searchProcessing']=='operators'){
$searchProcessing='any';
if(preg_match('*. .*',$infoGet[0])){
$searchProcessing='any';
}
if(preg_match('*.\+.*',$infoGet[0])){
echo 'ok';
$terms=str_replace('+',' ',$terms);
$searchProcessing='every';
}
if(preg_match('#^(["\']).*\1$#',$infoGet[0])){
$searchProcessing='complete';
$terms=trim($terms, '"');
}
}
if($searchProcessing=='complete'){
$terms = array($terms);
}else{
$terms = explode(' ',$terms);
}
if(@$searchProcessing!='any'){
foreach($terms as $term){
$array =array();
foreach($searchField as $column){
$array[]=' b.'.$column.' LIKE \'%'.hikashop_getEscaped($term, true).'%\' ';
$fields[] = ' reference_field = \''.$column.'\' ';
}
$list[]='('.implode(' OR ', $array).')';
$translationList[] = 'value LIKE \'%'.hikashop_getEscaped($term, true).'%\'';
}
$filters[]='('.implode(' AND ', $list).')';
$translationFilters = '('.implode(' AND ', $translationList).')';
}else{
foreach($terms as $term){
foreach($searchField as $column){
$list[]=' b.'.$column.' LIKE \'%'.hikashop_getEscaped($term, true).'%\' ';
$fields[] = ' reference_field = \''.$column.'\' ';
}
$translationList[] = 'value LIKE \'%'.hikashop_getEscaped($term, true).'%\'';
}
$filters[]='('.implode(' OR ', $list).')';
$translationFilters = '('.implode(' OR ', $translationList).')';
}
$translationHelper = hikashop_get('helper.translation');
if($translationHelper->isMulti(true)){
$trans_table = 'jf_content';
if($translationHelper->falang) {
$trans_table = 'falang_content';
}
$query = 'SELECT DISTINCT reference_id FROM '.hikashop_table($trans_table,false).' WHERE reference_table=\'hikashop_product\' AND '.$translationFilters.' AND ('.implode(' OR ', $fields).') AND published=1 ORDER BY reference_id ASC';
$this->database->setQuery($query);
if(!HIKASHOP_J25){
$translatedProducts= $database->loadResultArray();
} else {
$translatedProducts = $database->loadColumn();
}
if(!empty($translatedProducts)){
$filters[] = '('.array_pop($filters).' OR b.product_id IN ('.implode(',', $translatedProducts).'))';
}
}
}
if($filter->filter_data=='category'){
if(!($infoGet[0]==$filter->filter_namekey && count($infoGet)==1)){
$categoriesList='';
foreach($infoGet as $cat){
if($cat!=$filter->filter_namekey){
$categoriesList.=(int)$cat.',';
}
}
$categoriesList=substr($categoriesList,0,-1);
$table = 'a';
if(preg_match('#hikashop_product AS ([a-z0-9_]+)#i',$a,$matches)){
$table = $matches[1];
}
$on.=' INNER JOIN '.hikashop_table('product_category').' AS '.$filter->filter_namekey.$i.' ON '.$filter->filter_namekey.$i.'.product_id='.$table.'.product_id AND '.$filter->filter_namekey.$i.'.category_id IN ('.$categoriesList.')';
}
}
if($filter->filter_data=='information'||$filter->filter_data=='price'){
$limit=array();
$type=$filter->filter_options['product_information'];
if($filter->filter_data=='price') $type='price';
$case='( '.$this->getUnitSelect($filter, $type,$i).' )';
$copyGet=$infoGet[0];
$result=explode(',',$copyGet);
if(!($result[0]==$infoGet[0])){
foreach($result as $key => $res){
$infoGet[(int)$key]=(int)$res;
}
}
foreach($infoGet as $slice){
$values=explode('::', $slice);
if(empty($values[0])){ $limit[]=' '.$case.' <= '.(int)$values[1].' '; }
else if(empty($values[1])){ $limit[]=' '.$case.' >= '.(int)$values[0].' '; }
else{ $limit[]=' '.$case.' BETWEEN '.(int)$values[0].' AND '.(int)$values[1].' '; }
}
$filters[]=' ('.implode('OR', $limit).') ';
}
if($filter->filter_data=='characteristic'){
if(!($infoGet[0]==$filter->filter_namekey && count($infoGet)==1)){
$charList='';
foreach($infoGet as $charac){
$charList.=(int)$charac.',';
}
$charList=substr($charList,0,-1);
if(strpos($on,' LEFT JOIN '.hikashop_table('product').' AS c ON b.product_id=c.product_parent_id')===false){
$on.=' LEFT JOIN '.hikashop_table('product').' AS c ON b.product_id=c.product_parent_id';
}
$on.=' LEFT JOIN '.hikashop_table('variant').' AS '.$filter->filter_namekey.$i.' ON '.$filter->filter_namekey.$i.'.variant_product_id=c.product_id';
$filters[]=' '.$filter->filter_namekey.$i.'.variant_characteristic_id IN ('.$charList.') ';
$filters[]=' c.product_quantity!=0 ';
}
}
if($filter->filter_data=='quantity'){
if(!($infoGet[0]==$filter->filter_namekey && count($infoGet)==1)){
$filters[]=' b.product_quantity!=0 ';
}
}
if($filter->filter_data=='custom_field'){
if(empty($filter->filter_value)){
if(!($infoGet[0]==$filter->filter_namekey && count($infoGet)==1)){
$fieldsList=array();
foreach($infoGet as $field){
if($field!=$filter->filter_namekey && $field!=' '){
$fieldsList[]='b.'.$filter->filter_options['custom_field'].' LIKE \'%'.hikashop_getEscaped($field,true).'%\'';
}
}
if(!empty($fieldsList)){
$fieldsList='('.implode(' OR ',$fieldsList).')';
$filters[]=$fieldsList;
}
}
}else{
foreach($infoGet as $slice){
$values=explode('::', $slice);
if(empty($values[0])){ $limit[]=' b.'.$filter->filter_options['custom_field'].' <= '.(int)$values[1].' '; }
else if(empty($values[1])){ $limit[]=' b.'.$filter->filter_options['custom_field'].' >= '.(int)$values[0].' '; }
else{ $limit[]=' b.'.$filter->filter_options['custom_field'].' BETWEEN '.(int)$values[0].' AND '.(int)$values[1].' '; }
}
$filters[]=' ('.implode('OR', $limit).') ';
}
}
$infos=explode('--',$infoGet[0]);
$sort_by_price=false;
if(isset($filter->filter_options['sort_by'])){
if(!is_array($filter->filter_options['sort_by'])){
$temp = $filter->filter_options['sort_by'];
$filter->filter_options['sort_by'] = array();
$filter->filter_options['sort_by'][] = $temp;
}
foreach($filter->filter_options['sort_by'] as $sort_by){
if($sort_by=="price"){ $sort_by_price=true; }
}
}
if(isset($infos[1]) && ($filter->filter_data=='sort' && $sort_by_price && (($infos[1]=='lth') || ($infos[1]=='htl')))|| $filter->filter_data=='price'){
$subfilters = array();
$where = '';
hikashop_addACLFilters($subfilters,'price_access','price'.$i,2,true);
$subfilters[]='product'.$i.'.product_type=\'main\'';
$where = ' WHERE '.implode(' AND ',$subfilters);
$subquery ='SELECT * FROM '.hikashop_table('product').' AS product'.$i.' LEFT JOIN '.hikashop_table('price').' AS price'.$i.' ON product'.$i.'.product_id=price'.$i.'.price_product_id '.$where.' GROUP BY product'.$i.'.product_id ORDER BY price'.$i.'.price_min_quantity ASC';
$a = '('.$subquery.') AS b';
}
if($filter->filter_data=='sort' && isset($infoGet[0]) && $infoGet[0]!='none'){
$type=$infos[0];
$case=$this->getUnitSelect($filter, $type, $i);
if(!empty($case)){
$select2.=' ,'.$case.' as product_'.$type.'_normalized';
if($infos[1]=='lth'){
$order= ' ORDER BY product_'.$type.'_normalized*1 ASC';
}else{
$order= ' ORDER BY product_'.$type.'_normalized*1 DESC';
}
}else{
if($infos[1]=='lth'){
$order= ' ORDER BY '.$type.' ASC';
}else{
$order= ' ORDER BY '.$type.' DESC';
}
}
}
if($filter->filter_data=='manufacturers'){
if(!($infoGet[0]==$filter->filter_namekey && count($infoGet)==1)){
$manufacturerList='';
foreach($infoGet as $manufacturer_id){
$manufacturerList.=(int)$manufacturer_id.',';
}
$manufacturerList=substr($manufacturerList,0,-1);
$on.=' INNER JOIN '.hikashop_table('category').' AS '.$filter->filter_namekey.$i.' ON '.$filter->filter_namekey.$i.'.category_id=a.category_id AND b.product_manufacturer_id IN ('.$manufacturerList.') ';
}
}
if($filter->filter_type=='cursor'){
if(empty($infoGet[0])){
return false;
}
$infoGet = $app->getUserStateFromRequest( $parent->paramBase.'filter_'.$filter->filter_namekey.'_values', 'filter_'.$filter->filter_namekey.'_values', $infoGet, 'array' );
if(is_array($infoGet)){
$data =& $infoGet[0];
}else{
$data =& $infoGet;
}
$values=explode(' - ', $data);
if(count($values)!=2 || ($values[0]==$filter->filter_options['cursor_min'] && $values[1]==$filter->filter_options['cursor_max'])){
return false;
}
if(in_array($filter->filter_data,array('weight','length','width','height','surface','volume','price'))){
$type=$filter->filter_data;
$case='( '.$this->getUnitSelect($filter, $type, $i).' )';
$limit=' '.$case.' BETWEEN '.(int)$values[0].' AND '.(int)$values[1].' ';
}else{
$limit=' b.'.$filter->filter_data.' BETWEEN '.(int)$values[0].' AND '.(int)$values[1].' ';
}
$filters[]=$limit;
}
}else{
return false;
}
}
function getFieldToLoad($filter, $divName, &$parent){
if($filter->filter_type=='text'){ return ''; }
if($filter->filter_data=='category'){ return 'a.category_id'; }
if($filter->filter_data=='information'){ return 'b.product_'.$filter->filter_options['product_information']; }
if($filter->filter_data=='characteristic'){ return ''; }
if($filter->filter_data=='custom_field' && !empty($filter->filter_options['custom_field'])){ return 'b.'.$filter->filter_options['custom_field']; }
if($filter->filter_data=='sort' ){ return ''; }
if($filter->filter_data=='manufacturers'){ return ''; }
if($filter->filter_type=='cursor'){
if($filter->filter_data=='weight' || $filter->filter_data=='length' || $filter->filter_data=='width' || $filter->filter_data=='height' || $filter->filter_data=='surface' || $filter->filter_data=='volume'){
if($filter->filter_data=='surface'){
return 'b.product_width*b.product_length';
}
if($filter->filter_data=='volume'){
return 'b.product_width*b.product_length*b.product_height';
}
return 'b.product_'.$filter->filter_data;
}
if($filter->filter_data=='price'){
return '';
}
return 'b.'.$filter->filter_data;
}
return '';
}
function displayInList($filter, $divName, $selected, $tab=""){
$html='';
$br='
';
if($filter->filter_type=='text'){
$html.=''.$selected[0].', ';
$html=$this->getDeleteButton($filter, $divName, $selected[0].' ', $html, $br);
}
if($filter->filter_data=='category'){
$categories_name=$this->getCategories($filter);
$val='';
foreach($categories_name as $cat){
if(is_array($selected) && in_array($cat->category_id, $selected)){
$html.=''.$cat->category_name.', ';
$val.=$cat->category_id.',';
}
}
$html=$this->getDeleteButton($filter, $divName, $val, $html, $br);
}
if(($filter->filter_data=='price' || $filter->filter_data=='information') && !empty($filter->filter_value)){
if($this->checkCurrency($filter)==false){ return false;}
$size=count($filter->filter_value);
$val='';
foreach($filter->filter_value as $key => $value){
list($formatVal, $oldVal)=$this->formatUnits($filter, $key, $value);
if($key==0 && is_array($selected) && in_array('::'.$value, $selected)){
$val.='::'.$value.',';
$html.=''.JText::sprintf('X_AND_INFERIOR',$formatVal).', ';
}else if($key!=0 && is_array($selected) && in_array($filter->filter_value[$key-1].'::'.$value, $selected)) {
$val.=$filter->filter_value[$key-1].'::'.$value.',';
$html.=''.JText::sprintf('FROM_X_TO_Y', $oldVal, $formatVal ).', ';
}
if($key==$size-1 && is_array($selected) && in_array($value.'::', $selected)){
$val.=$value.'::,';
$html.=''.JText::sprintf('X_AND_SUPERIOR', $formatVal ).', ';
}
}
$html=$this->getDeleteButton($filter, $divName, $val, $html, $br);
}
if($filter->filter_data=='characteristic'){
$characteristic_values=$this->getCharacteristics($filter);
$values='';
foreach($characteristic_values as $val){
if(!empty($selected) && is_array($selected) && in_array($val->characteristic_id, $selected)){
$html.='> '.$val->characteristic_value.', ';
$values.=$val->characteristic_id.',';
}
}
$html=$this->getDeleteButton($filter, $divName, $values, $html, $br);
}
if($filter->filter_data=='manufacturers'){
$manufacturers=$this->getManufacturers($filter);
$val='';
foreach($manufacturers as $manufacturer){
if(!empty($selected) && is_array($selected) && in_array($manufacturer->category_id, $selected)){
$html.='> '.$manufacturer->category_name.', ';
$val.=$manufacturer->category_id.',';
}
}
$html=$this->getDeleteButton($filter, $divName, $val, $html,$br);
}
if($filter->filter_data=='custom_field'){
$field=$this->getFields($filter);
if(is_array($field)) $field=reset($field);
$values='';
if(isset($field->field_value) && is_array($field->field_value)){
foreach($field->field_value as $val){
if(!empty($selected) && is_array($selected) && in_array($val[0], $selected)){
$html.='> '.JText::_($val[1]).', ';
$values.=$val[0].',';
}
}
}else{
if(is_array($selected)){
$value = implode(' - ',$selected);
}
$value = str_replace('::',' - ',$value);
$html.='> '.$value.', ';
}
$html=$this->getDeleteButton($filter, $divName, $selected, $html, $br);
}
if($filter->filter_data=='sort'){
if($selected[0]=='lth'){
$html.='> '.JText::_('ASCENDING' ).', ';
}
if($selected[0]=='htl'){
$html.='> '.JText::_('DESCENDING' ).', ';
}
$html=$this->getDeleteButton($filter, $divName, $selected[0].',', $html, $br);
}
if($filter->filter_type=='cursor'){
if(!is_array($selected)){
$selected=explode(' - ', $selected[0]);
}
$html=''.$selected[0].' - '.$selected[1].', ';
$html=$this->getDeleteButton($filter, $divName, 11, $html, $br);
}
$html=$this->titlePosition($filter, $html, true);
return $html;
}
function getDeleteButton($filter, $divName, $val, $html, $br, $onlyButton=false, $id=''){
if($onlyButton){
if(empty($id)){ $id='filter_'.$filter->filter_namekey.'_'.$divName; }
return '
';
}
$html=substr($html,0,-2);
if(is_array($val)){
foreach($val as $v){
$html.='';
}
}else{
if($filter->filter_data=='sort'){
if(isset($val) && !empty($val)){
$selected=explode('--',$val);
$selected[1]=substr($selected[1], 0, 3);
}
if(isset($fields[$selected[0]])){ $typeName=$fields[$selected[0]]->field_realname; }
else if($selected[0]=='b.product_name'){ $typeName= JText::_('PRODUCT_NAME'); }
else if($selected[0]=='price'){ $typeName= JText::_('PRICE'); }
else if($selected[0]=='b.product_average_score'){ $typeName= JText::_('RATING'); }
else if($selected[0]=='b.product_created' || $theType=='b.product_modified'){ $typeName= JText::_('RECENT'); }
else if($selected[0]=='b.product_sales'){ $typeName= JText::_('SALES'); }
else if($selected[0]=='b.product_hit'){ $typeName= JText::_('CLICKS'); }
else{ $typeName=JText::_('PRODUCT_'.$selected[0]); }
if(JText::_('SORT_ASCENDING_'.$typeName)!='SORT_ASCENDING_'.$typeName){ $asc_name=JText::_('SORT_ASCENDING_'.$typeName); }
else{ $asc_name=JText::sprintf('SORT_ASCENDING', $typeName); }
if(JText::_('SORT_DESCENDING_'.$typeName)!='SORT_DESCENDING_'.$typeName){ $desc_name=JText::_('SORT_DESCENDING_'.$typeName); }
else{ $desc_name=JText::sprintf('SORT_DESCENDING', $typeName); }
if($selected[1]=='lth'){ $html.=''.$asc_name.''; }
else{ $html.=''.$desc_name.''; }
}
$val=substr($val,0,-1);
$html.='';
}
$html.='
';
return $html;
}
function getUnitSelect($filter, $type, $i=0){
$case=' case';
$weightHelper=hikashop_get('helper.weight');
$volumeHelper=hikashop_get('helper.volume');
$config =& hikashop_config();
$defaulUnit='cm';
if($type=='weight'){
$infoType='b.product_weight';
$unitType='b.product_weight_unit';
$units=$weightHelper->conversion;
$defaulUnit='kg';
}else if($type=='volume'){
$infoType='(b.product_width*b.product_length*b.product_height)';
$unitType='b.product_dimension_unit';
$units=$volumeHelper->conversion;
}else if($type=='surface'){
$infoType[]='b.product_width';
$infoType[]='b.product_length';
$unitType='b.product_dimension_unit';
$units=$volumeHelper->conversionDimension;
}else if($type=='height' || $type=='length' || $type=='width'){
$unitType='b.product_dimension_unit';
$units=$volumeHelper->conversionDimension;
if($type=='height'){ $infoType='b.product_height'; }
if($type=='length'){ $infoType='b.product_length'; }
if($type=='width'){ $infoType='b.product_width'; }
}elseif($type=='price'){
$currentCurrency = hikashop_getCurrency();
$unitType='b.price_value';
$currencyType = hikashop_get('type.currency');
$currencyClass = hikashop_get('class.currency');
$dstCurrency = $currencyClass->get($currentCurrency);
$currencyType->load(0);
$currencies = $currencyType->currencies;
$config =& hikashop_config();
$main_currency = $config->get('main_currency',1);
if($config->get('price_with_tax')){
$categoryClass=hikashop_get('class.category');
$main = 'tax';
$categoryClass->getMainElement($main);
$tax_categories = $categoryClass->getChilds($main);
$taxes = array();
foreach($tax_categories as $tax_category){
$taxes[$tax_category->category_id] = (float)$currencyClass->getTax(hikashop_getZone(),$tax_category->category_id);
}
$taxes[0] = 0;
}
foreach($currencies as $currency){
$calculatedVal=$unitType;
if($main_currency!=$currency->currency_id){
if(bccomp($currency->currency_percent_fee,0,2)){
$calculatedVal='('.$calculatedVal.'*'.(floatval($currency->currency_percent_fee+100)/100.0).')';
}
$calculatedVal='('.$calculatedVal.'/'.floatval($currency->currency_rate).')';
}
if($main_currency!=$currentCurrency){
$calculatedVal='('.$calculatedVal.'*'.floatval($dstCurrency->currency_rate).')';
if(bccomp($dstCurrency->currency_percent_fee,0,2)){
$calculatedVal='('.$calculatedVal.'*'.(floatval($dstCurrency->currency_percent_fee+100)/100.0).')';
}
}else{
$case .= ' when b.price_currency_id IS NULL then 0';
}
if(!empty($taxes)){
$ids=array();
foreach($taxes as $id => $tax){
if($id!=0){
$ids[]=$id;
$case .= ' when b.price_currency_id = \''.$currency->currency_id.'\' and b.product_tax_id = \''.$id.'\' then '.$calculatedVal.'+'.$calculatedVal.'*'.$tax;
}
}
$case .= ' when b.price_currency_id = \''.$currency->currency_id.'\' and b.product_tax_id NOT IN (\''.implode('\',\'',$ids).'\') then '.$calculatedVal;
}else{
$case .= ' when b.price_currency_id = \''.$currency->currency_id.'\' then '.$calculatedVal;
}
}
$case.= ' end ';
return $case;
}else{
return '';
}
if(isset($filter->filter_options['information_unit'])){
$selectedUnit=$filter->filter_options['information_unit'];
}else{
$selectedUnit=$defaulUnit;
}
foreach( $units as $key => $unit){
$calculatedVal='';
if($key==$selectedUnit){ $val=1; }
else{ $val=$unit[$selectedUnit]; }
if(is_array($infoType)){
foreach($infoType as $type){
$calculatedVal.='('.$type.'*'.$val.')*';
}
$calculatedVal=substr($calculatedVal,0,-1);
}else{
$calculatedVal=$infoType.'*'.$val;
}
$case .= ' when '.$unitType.' = \''.$key.'\' then '.$calculatedVal;
}
$case.= ' else '.$unitType.' end ';
return $case;
}
function titlePosition($filter, $html='', $list=false, $opt=''){
$name=$this->trans($filter->filter_name);
if($list && $filter->filter_options['title_position']='inside'){
$position='top';
}
else{
$position=$filter->filter_options['title_position'];
}
switch ($position){
case 'bottom':
$html=$html.'
'.$name.' '.$opt;
break;
case 'top':
$html=$name.' '.$opt.'
'.$html;
break;
case 'left':
$html=$name.' '.$opt.' '.$html;
break;
case 'right':
$html=$html.' '.$name.' '.$opt;
break;
}
return $html;
}
function trans($name){
$val = preg_replace('#[^a-z0-9]#i','_',strtoupper($name));
$trans = JText::_($val);
if($val==$trans){
$trans = $name;
}
return ''.$trans.'';
}
function getCategories($filter, $datas=''){
$optionElement=''; $left='';
if(!empty($datas['products'])){
$left=' LEFT JOIN '.hikashop_table('product_category').' AS b ON a.category_id=b.category_id ';
foreach($datas['products'] as $data){
$optionElement[$data->product_id]=$data->product_id;
}
$optionElement='AND b.product_id IN ('.implode(',', $optionElement).')';
}
if(!empty($filter->filter_options['parent_category_id'])){
$parentCat=$filter->filter_options['parent_category_id'];
}else{
$parentCat=0;
}
$database = JFactory::getDBO();
$query='SELECT * FROM '.hikashop_table('category').' AS a '.$left.' WHERE category_parent_id='.$parentCat.' '.$optionElement.' ORDER BY a.category_ordering ASC';
$database->setQuery($query);
$categories_name=$database->loadObjectList('category_id');
return $categories_name;
}
/*edited */
function getCharacteristics($filter, $datas=''){
$optionElement=''; $left='';
$database = JFactory::getDBO();
if(!empty($datas['products'])){
$left=' LEFT JOIN '.hikashop_table('variant').' AS b ON a.characteristic_id=b.variant_characteristic_id ';
$option_pid = array();
foreach($datas['products'] as $data){
$option_pid[$data->product_id]=$data->product_id;
}
$query='SELECT product_id FROM '.hikashop_table('product').' WHERE product_parent_id IN ('.implode(',',$option_pid).')';
$database->setQuery($query);
$results = $database->loadObjectList();
$result_pid = array();
foreach($results as $result){
$result_pid[] = $result->product_id;
}
if(!empty($result_pid))
$optionElement='AND b.variant_product_id IN ('.implode(',', $result_pid).')';
}
/* end edit */
$config =& hikashop_config();
$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 DISTINCT a.* FROM '.hikashop_table('characteristic').' AS a '.$left.' WHERE characteristic_parent_id='.$filter->filter_options['filter_charac'].' '.$optionElement.' ORDER BY a.'.$order;
$database->setQuery($query);
$characteristic_values=$database->loadObjectList();
return $characteristic_values;
}
function getManufacturers($filter, $datas=''){
$optionElement=''; $left='';
if(!empty($datas['products'])){
$left=' LEFT JOIN '.hikashop_table('product').' AS b ON a.category_id=b.product_manufacturer_id ';
foreach($datas['products'] as $data){
$optionElement[$data->product_id]=$data->product_id;
}
$optionElement='AND b.product_id IN ('.implode(',', $optionElement).')';
}
$database = JFactory::getDBO();
$query='SELECT a.* FROM '.hikashop_table('category').' AS a '.$left.' WHERE a.category_type="manufacturer" AND a.category_parent_id!=\'1\' '.$optionElement.' AND a.category_published=1 ORDER BY a.category_ordering ASC';
$database->setQuery($query);
$manufacturers=$database->loadObjectList('category_id');
return $manufacturers;
}
function getFields($filter, $datas=''){
$database = JFactory::getDBO();
$query='SELECT * FROM '.hikashop_table('field').' WHERE field_namekey = \''.$filter->filter_options['custom_field'].'\'';
$database->setQuery($query);
$field=$database->loadObject();
if(!empty($datas['products'])){
foreach($datas['products'] as $data){
$optionElement[$data->product_id]=$data->product_id;
}
$optionElement='product_id IN ('.implode(',', $optionElement).')';
$query='SELECT DISTINCT '.$filter->filter_options['custom_field'].' FROM '.hikashop_table('product').' WHERE '.$optionElement.'';
$database->setQuery($query);
if(!HIKASHOP_J25){
$values=$database->loadResultArray();
} else {
$values=$database->loadColumn();
}
foreach($values as $val){
$els = explode(',',$val);
if(count($els)>1){
foreach($els as $el){
$values[]=$el;
}
}
}
}
if(!empty($field->field_value)){
$field->field_value=explode("\n", $field->field_value);
$unset=array();
foreach($field->field_value as $key => $val){
$temp=explode("::", $val);
if(!empty($datas['products']) && !in_array($temp[0],$values)){
$unset[]=$key;
}else{
$field->field_value[$key]=array($temp[0],$temp[1]);
}
}
if(!empty($unset)){
foreach($unset as $u){
unset($field->field_value[$u]);
}
}
}
return $field;
}
function formatUnits($filter, $key, $value){
$currencyClass = hikashop_get('class.currency');
$currency = hikashop_getCurrency();
$formatVal= $value;
$oldVal=0;
if($key!=0){ $oldVal=$filter->filter_value[$key-1]; }
if($filter->filter_data=='price'){
$formatVal=$currencyClass->format($formatVal,$currency);
if($key!=0){ $oldVal=$currencyClass->format($oldVal,$currency); }
}else if(isset($filter->filter_options['information_unit'])){
$formatVal=$formatVal.$filter->filter_options['information_unit'];
if($key!=0){ $oldVal=$oldVal.$filter->filter_options['information_unit']; }
}
$array=array();
$array[]=$formatVal;
$array[]=$oldVal;
return $array;
}
function checkCurrency($filter){
$currency = hikashop_getCurrency();
if($filter->filter_data=='price' && !in_array($currency, $filter->filter_options['currencies'])){
return false;
}
return true;
}
}
class hikashopTextClass extends hikashopFilterTypeClass{
function display($filter, $divName, &$parent, $datas=''){
$html='';
$name='';
$selected=parent::display($filter, $divName, $parent);
if(!is_array($selected)){
$selected = array($selected);
}
if(!empty($selected)){
$name=htmlentities($selected[0], ENT_COMPAT, 'UTF-8');
}
if($filter->filter_deletable && ( isset($selected[0]) && $selected[0]!='none' && !in_array($selected[0],array(" ",'')))){
$html=parent::displayInList($filter, $divName, $selected);
return $html;
}
$style='';
if($filter->filter_options['textBoxSize']){
$style='style="width: 90%;"';
}
$onBlur='';
if($filter->filter_direct_application){
$onBlur='onblur="document.forms[\'hikashop_filter_form_'.$divName.'\'].submit();"';
}
if($filter->filter_options['title_position']=='inside'){
$onClick='';
if(empty($name)){
$name=$filter->filter_name;
$onClick=' onclick="this.value=\'\';"';
}
$html='';
}else{
$html = '';
}
$html=parent::titlePosition($filter, $html);
return $html;
}
}
class hikashopSingledropdownClass extends hikashopFilterTypeClass{
function display($filter, $divName, &$parent, $datas='', $multiple='', $tab=''){
$selected=parent::display($filter, $divName, $parent);
if(!is_array($selected)){
$selected=array($selected);
}
if(!($filter->filter_dynamic)){
$datas='';
}
if(!empty($selected)){
if($filter->filter_deletable && $selected[0]!=$filter->filter_namekey && $selected[0]!='none' && ( isset($selected[0]) && !in_array($selected[0],array(" ",'')))){
$html=parent::displayInList($filter, $divName, $selected, $tab);
return $html;
}
}
$onClick='';
if($filter->filter_direct_application){
$onClick='onchange="document.forms[\'hikashop_filter_form_'.$divName.'\'].submit();"';
}
$html='';
if(!empty($tab)){
$html.= '';
}
$html.='';
return $html;
}
}
class hikashopRadioClass extends hikashopFilterTypeClass{
function display($filter, $divName, &$parent, $datas='', $type='radio', $tab=''){
$selected=parent::display($filter, $divName, $parent);
if(!($filter->filter_dynamic)){
$datas='';
}
if(!is_array($selected)){
$selected = array($selected);
}
if($filter->filter_deletable && isset($selected[0]) && $selected[0]!='none' && !in_array($selected[0],array(" ",''))){
$html=parent::displayInList($filter, $divName, $selected, $tab);
return $html;
}
$onClick='';
if($filter->filter_direct_application){
$onClick='onchange="document.forms[\'hikashop_filter_form_'.$divName.'\'].submit();"';
}
$html='';
$br='';
if(isset($filter->filter_options['button_align']) && $filter->filter_options['button_align']==0){ $br='
'; }
if(!empty($tab)){
$html.= '';
}
if($filter->filter_data=='category'){
$categories_name=parent::getCategories($filter, $datas);
if(!empty($categories_name)){
foreach($categories_name as $cat){
$checked='';$deleteButton='';
if(!empty($selected) && is_array($selected) && in_array($cat->category_id, $selected)){
$checked='checked="checked"';
if($type=='radio'){ $deleteButton=' '.parent::getDeleteButton($filter, $divName, '', $html, '', true, 'filter_'.$filter->filter_id.'_'.$cat->category_id.'_'.$divName); }
}
$html.=''.$deleteButton.''.$br;
}
}
}
if(($filter->filter_data=='price' || $filter->filter_data=='information' || $filter->filter_data=='custom_field') && !empty($filter->filter_value)){
if(parent::checkCurrency($filter)==false){ return false;}
$size=count($filter->filter_value);
if($size){
foreach($filter->filter_value as $key => $value){
$checked=''; $deleteButton='';
if($key>0){ $previousVal=$filter->filter_value[$key-1];}
list($formatVal, $oldVal)=parent::formatUnits($filter, $key, $value);
if($key==0){
if(!empty($selected) && is_array($selected) && in_array('::'.$value, $selected)){
$checked='checked="checked"';
if($type=='radio'){ $deleteButton=' '.parent::getDeleteButton($filter, $divName, '', $html, '', true, 'filter_'.$filter->filter_id.'_'.$value.'' ); }
}
$html.=''.$deleteButton.''.$br;
parent::getDeleteButton($filter, $divName, '', $html, true);
}else{
if(!empty($selected) && is_array($selected) && in_array($filter->filter_value[$key-1].'::'.$value, $selected)){
$checked='checked="checked"';
if($type=='radio'){ $deleteButton=' '.parent::getDeleteButton($filter, $divName, '', $html, '', true, 'filter_'.$filter->filter_id.'_'.$value.'' ); }
}
$html.=''.$deleteButton.''.$br;
}
if($key==$size-1){
$checked=''; $deleteButton='';
if(!empty($selected) && is_array($selected) && in_array($value.'::', $selected)){
$checked='checked="checked"';
if($type=='radio'){ $deleteButton=' '.parent::getDeleteButton($filter, $divName, '', $html, '', true, 'filter_'.$filter->filter_id.'_'.$value.''); }
}
$html.=''.$deleteButton.''.$br;
parent::getDeleteButton($filter, $divName, '', $html, true);
}
}
}
}
if($filter->filter_data=='characteristic'){
$characteristic_values=parent::getCharacteristics($filter, $datas);
if(!empty($characteristic_values)){
foreach($characteristic_values as $val){
$checked=''; $deleteButton='';
if(!empty($selected) && is_array($selected) && in_array($val->characteristic_id, $selected)){
$checked='checked="checked"';
if($type=='radio'){ $deleteButton=' '.parent::getDeleteButton($filter, $divName, '', $html, '', true, 'filter_'.$filter->filter_id.'_'.$val->characteristic_id.'_'.$divName); }
}
$html.=''.$deleteButton.''.$br;
}
}
}
if($filter->filter_data=='manufacturers'){
$manufacturers=parent::getManufacturers($filter, $datas);
if(!empty($manufacturers)){
foreach($manufacturers as $manufacturer){
$checked=''; $deleteButton='';
if(!empty($selected) && is_array($selected) && in_array($manufacturer->category_id, $selected)){
$checked='checked="checked"';
if($type=='radio'){ $deleteButton=' '.parent::getDeleteButton($filter, $divName, '', $html, '', true, 'filter_'.$filter->filter_id.'_'.$manufacturer->category_id.'_'.$divName); }
}
$html.=''.$deleteButton.''.$br;
}
}
}
if($filter->filter_data=='custom_field' && empty($filter->filter_value)){
$field=parent::getFields($filter, $datas);
if(!empty($field)){
if(is_array($field->field_value)){
foreach($field->field_value as $key => $val){
$checked='';
$deleteButton='';
$input='';
if(!empty($selected) && is_array($selected) && in_array($val[0], $selected)){
$checked='checked="checked"';
if($type=='radio'){
$deleteButton=' '.parent::getDeleteButton($filter, $divName, '', $html, '', true, 'field_'.$filter->filter_id.'_'.$key.'_'.$divName);
}
}
if($type!='hidden') $input = '';
$html.=''.$input.''.$deleteButton.''.$br;
}
}
}
}
if($filter->filter_data=='sort'){
$null=null;
$fieldsClass = hikashop_get('class.field');
$fields=$fieldsClass->getFields('frontcomp',$null,'product');
if(!is_array($filter->filter_options['sort_by'])){
$temp = $filter->filter_options['sort_by'];
$filter->filter_options['sort_by'] = array();
$filter->filter_options['sort_by'][] = $temp;
}
foreach($filter->filter_options['sort_by'] as $theType){
$checked1=''; $checked2='';$deleteButton=''; $deleteButton2='';
if(!empty($selected)){
if($selected[0]==$theType.'--lth'){
$checked1='checked="checked" id="filter_'.$filter->filter_namekey.'_'.$divName.'"';
if($type=='radio'){ $deleteButton=' '.parent::getDeleteButton($filter, $divName, '', $html, '', true); }
}
if($selected[0]==$theType.'--htl'){
$checked2='checked="checked" id="filter_'.$filter->filter_namekey.'_'.$divName.'"';
if($type=='radio'){ $deleteButton2=' '.parent::getDeleteButton($filter, $divName, '', $html, '', true); }
}
}
if(isset($fields[$theType])){ $typeName=$fields[$theType]->field_realname; }
else if($theType=='b.product_name'){ $typeName= JText::_('PRODUCT_NAME'); }
else if($theType=='price'){ $typeName= JText::_('PRICE'); }
else if($theType=='b.product_average_score'){ $typeName= JText::_('RATING'); }
else if($theType=='b.product_created' || $theType=='b.product_modified'){ $typeName= JText::_('RECENT'); }
else if($theType=='b.product_sales'){ $typeName= JText::_('SALES'); }
else if($theType=='b.product_hit'){ $typeName= JText::_('CLICKS'); }
else{ $typeName=JText::_('PRODUCT_'.$theType); }
if(JText::_('SORT_ASCENDING_'.$typeName)!='SORT_ASCENDING_'.$typeName){ $asc_name=JText::_('SORT_ASCENDING_'.$typeName); }
else{ $asc_name=JText::sprintf('SORT_ASCENDING', $typeName); }
if(JText::_('SORT_DESCENDING_'.$typeName)!='SORT_DESCENDING_'.$typeName){ $desc_name=JText::_('SORT_DESCENDING_'.$typeName); }
else{ $desc_name=JText::sprintf('SORT_DESCENDING', $typeName); }
$html.=''.$asc_name.''.$deleteButton.''.$br;
$html.=''.$desc_name.''.$deleteButton2.''.$br;
}
}
$html.='';
$html=parent::titlePosition($filter, $html);
return $html;
}
}
class hikashopListClass extends hikashopFilterTypeClass{
function display($filter, $divName, &$parent, $datas=''){
$selected=parent::display($filter, $divName, $parent);
if(!($filter->filter_dynamic)){
$datas='';
}
if($filter->filter_deletable &&(is_array($selected) && !empty($selected) && $selected[0]!='none' && ( isset($selected[0]) && !in_array($selected[0],array(" ",''))))){
$html=parent::displayInList($filter, $divName, $selected);
return $html;
}
$html='';
if($filter->filter_data=='category'){
$categories_name=parent::getCategories($filter, $datas);
if(!empty($categories_name)){
foreach($categories_name as $cat){
if(!empty($selected) && (is_numeric($selected)&&$cat->category_id==$selected) ||(is_array($selected) && in_array($cat->category_id, $selected))){
$html.='- '.$cat->category_name.'';
$html.='
';
}else{
$html.'- '.$cat->category_name.'
';
}
}
}
}
if(($filter->filter_data=='price' || $filter->filter_data=='information' || $filter->filter_data=='custom_field') && !empty($filter->filter_value)){
if(parent::checkCurrency($filter)==false){ return false;}
$size=count($filter->filter_value);
if(!empty($size)){
foreach($filter->filter_value as $key => $value){
list($formatVal, $oldVal)=parent::formatUnits($filter, $key, $value);
if($key==0){
if(!empty($selected) && is_array($selected) && in_array('::'.$value, $selected)){
$html.='- '.JText::sprintf('X_AND_INFERIOR',$formatVal).'';
$html.='
';
}else{
$html.='- '.JText::sprintf('X_AND_INFERIOR',$formatVal).'
';
}
}else{
if(!empty($selected) && is_array($selected) && in_array($filter->filter_value[$key-1].'::'.$value, $selected)){
$html.='- '.JText::sprintf('FROM_X_TO_Y', $oldVal, $formatVal ).'';
$html.='
';
}else{
$html.='- ' .JText::sprintf('FROM_X_TO_Y', $oldVal, $formatVal ).'
';
}
}
if($key==$size-1){
if(!empty($selected) && is_array($selected) && in_array($value.'::', $selected)){
$html.='- '.JText::sprintf('X_AND_SUPERIOR', $formatVal ).'';
$html.='
';
}else{
$html.='- '.JText::sprintf('X_AND_SUPERIOR', $formatVal ).'
';
}
}
}
}
}
if($filter->filter_data=='characteristic'){
$characteristic_values=parent::getCharacteristics($filter, $datas);
if(!empty($characteristic_values)){
foreach($characteristic_values as $val){
if(!empty($selected) && is_array($selected) && in_array($val->characteristic_id, $selected)){
$html.='- '.$val->characteristic_value.'';
$html.='
';
}else{
$html.='- '.$val->characteristic_value.'
';
}
}
}
}
if($filter->filter_data=='manufacturers'){
$manufacturers=parent::getManufacturers($filter, $datas);
if(!empty($manufacturers)){
foreach($manufacturers as $manufacturer){
if(!empty($selected) && is_array($selected) && in_array($manufacturer->category_id, $selected)){
$html.='- '.$manufacturer->category_name.'';
$html.='
';
}else{
$html.='- '.$manufacturer->category_name.'
';
}
}
}
}
if($filter->filter_data=='custom_field'){
$field=parent::getFields($filter, $datas);
if(is_array($field->field_value)){
foreach($field->field_value as $key => $val){
if(!empty($selected) && is_array($selected) && in_array($val[0], $selected)){
$html.='- '.JText::_($val[1]).'';
$html.='
';
}else{
$html.='- '.JText::_($val[1]).'
- ';
}
}
}
}
if($filter->filter_data=='sort'){
$null=null;
$fieldsClass = hikashop_get('class.field');
$fields=$fieldsClass->getFields('frontcomp',$null,'product');
if(!is_array($filter->filter_options['sort_by'])){
$temp = $filter->filter_options['sort_by'];
$filter->filter_options['sort_by'] = array();
$filter->filter_options['sort_by'][] = $temp;
}
foreach($filter->filter_options['sort_by'] as $theType){
$checked1=''; $checked2='';$deleteButton=''; $deleteButton2='';
if(!empty($selected)){
if($selected[0]==$theType.'--lth'){
$checked1='checked="checked" id="filter_'.$filter->filter_namekey.'_'.$divName.'"';
$deleteButton=' '.parent::getDeleteButton($filter, $divName, '', $html, '', true);
}
if($selected[0]==$theType.'--htl'){
$checked2='checked="checked" id="filter_'.$filter->filter_namekey.'_'.$divName.'"';
$deleteButton2=' '.parent::getDeleteButton($filter, $divName, '', $html, '', true);
}
}
if(isset($fields[$theType])){ $typeName=$fields[$theType]->field_realname; }
else if($theType=='b.product_name'){ $typeName= JText::_('PRODUCT_NAME'); }
else if($theType=='price'){ $typeName= JText::_('PRICE'); }
else if($theType=='b.product_average_score'){ $typeName= JText::_('RATING'); }
else if($theType=='b.product_created' || $theType=='b.product_modified'){ $typeName= JText::_('RECENT'); }
else if($theType=='b.product_sales'){ $typeName= JText::_('SALES'); }
else if($theType=='b.product_hit'){ $typeName= JText::_('CLICKS'); }
else{ $typeName=JText::_('PRODUCT_'.$theType); }
if(JText::_('SORT_ASCENDING_'.$typeName)!='SORT_ASCENDING_'.$typeName){ $asc_name=JText::_('SORT_ASCENDING_'.$typeName); }
else{ $asc_name=JText::sprintf('SORT_ASCENDING', $typeName); }
if(JText::_('SORT_DESCENDING_'.$typeName)!='SORT_DESCENDING_'.$typeName){ $desc_name=JText::_('SORT_DESCENDING_'.$typeName); }
else{ $desc_name=JText::sprintf('SORT_DESCENDING', $typeName); }
if(!empty($checked1)){
$html.='
- '.$asc_name.''.$deleteButton.'
';
}else{
$html.='- '.$asc_name.'
';
}
if(!empty($checked2)){
$html.='- '.$desc_name.''.$deleteButton2.'
- ';
}else{
$html.='
- '.$desc_name.'
';
}
}
}
$html.='
';
$html=parent::titlePosition($filter, $html);
return $html;
}
}
class hikashopCursorClass extends hikashopFilterTypeClass{
function display($filter, $divName, &$parent, $datas=''){
$selected=parent::display($filter, $divName, $parent);
if(!empty($selected) && !empty($selected[0])){
$values=parent::display($filter, $divName, $parent, '_values');
if(!is_array($values)){
$values = explode(' - ',$values);
}
if($filter->filter_deletable && $values[0]!='none' && ( isset($values[0]) && !in_array($selected[0],array(" ",'')))){
$html=parent::displayInList($filter, $divName, $values);
return $html;
}
}
$cursorStep='';
$html='';
$cursorMin=0;
$cursorMax=1000;
$cursorEffect='';
$cursorWidth='width:250px;';
$float='';
$deleteButton='';
if($filter->filter_options['cursor_min']!='none' && isset($filter->filter_options['cursor_min']) && !in_array($filter->filter_options['cursor_min'],array(" ",''))){
$cursorMin=$filter->filter_options['cursor_min'];
}
if(!empty($filter->filter_options['cursor_max'])){
$cursorMax=$filter->filter_options['cursor_max'];
}
$minVal=$cursorMin;
$maxVal=$cursorMax;
if(!empty($filter->filter_options['cursor_effect'])){
$cursorEffect='animate: true,';
}
if(!empty($filter->filter_options['cursor_width'])){
$cursorWidth='width:'.$filter->filter_options['cursor_width'].'px;';
}
if(!empty($filter->filter_options['cursor_step'])){
$cursorStep='step:'.$filter->filter_options['cursor_step'].',';
}
if(isset($values)){
if(is_array($values) && count($values)!=2){
$data =& $values[0];
}else{
$data =& $values;
}
if( isset($data) && (is_array($data) || !in_array($data,array(" ",'')))){
if(!is_array($data)){
$data=explode(' - ',$data);
}
$minVal=(int)@$data[0];
$maxVal=(int)@$data[1];
}
}
if(!empty($datas) && $filter->filter_dynamic){
$nameMax='max_'.$filter->filter_namekey;
$nameMin='min_'.$filter->filter_namekey;
$array = $datas['limits'];
if(!empty($array->$nameMax)){
$maxVal=(int)$array->$nameMax;
}else{
$maxVal=1000;
}
if(!empty($array->$nameMin)){
$minVal=(int)$array->$nameMin;
}else{
$minVal=0;
}
}
if($minVal>$maxVal){
$tmp = $maxVal;
$maxVal = $minVal;
$minVal = $tmp;
}
if($cursorMin>$cursorMax){
$tmp = $cursorMax;
$cursorMax = $cursorMin;
$cursorMin = $tmp;
}
$onClick='';
if($filter->filter_direct_application){
$onClick='document.getElementById(\'slider_'.$filter->filter_namekey.'_'.$divName.'\').value="";document.forms[\'hikashop_filter_form_'.$divName.'\'].submit();';
}
$js='if(!hkjQuery) window.hkjQuery = window.jQuery;
hkjQuery(document).ready(function(){
hkjQuery("#slider_'.$filter->filter_namekey.'_'.$divName.'").prop(\'slide\',null).slider({
'.$cursorEffect.'
range: true,
min: '.$cursorMin.',
max: '.$cursorMax.',
'.$cursorStep.'
values: ['.$minVal.', '.$maxVal.'],
slide: function( event, ui ) {
hkjQuery( "#filter_'.$filter->filter_namekey.'_'.$divName.'_values" ).val( ui.values[ 0 ] + " - " + ui.values[ 1 ] );
hkjQuery( "#filter_'.$filter->filter_namekey.'_'.$divName.'" ).val(1);
hkjQuery( "#filter_span_'.$filter->filter_namekey.'_'.$divName.'" ).html( ui.values[ 0 ] + " - " + ui.values[ 1 ] );
},
change: function( event, ui ) {' .
$onClick .'
}
});
hkjQuery( "#filter_'.$filter->filter_namekey.'_'.$divName.'_values" ).val( hkjQuery( "#slider_'.$filter->filter_namekey.'_'.$divName.'" ).slider( "values", 0 ) + " - " + hkjQuery( "#slider_'.$filter->filter_namekey.'_'.$divName.'" ).slider( "values", 1 ) );
hkjQuery( "#filter_span_'.$filter->filter_namekey.'_'.$divName.'" ).html( hkjQuery( "#slider_'.$filter->filter_namekey.'_'.$divName.'" ).slider( "values", 0 ) + " - " + hkjQuery( "#slider_'.$filter->filter_namekey.'_'.$divName.'" ).slider( "values", 1 ) );
hkjQuery(\'#dialog_link, ul#icons li\').hover(
function() { hkjQuery(this).addClass(\'ui-state-hover\'); },
function() { hkjQuery(this).removeClass(\'ui-state-hover\'); }
);
});';
if(HIKASHOP_PHP5){
$doc = JFactory::getDocument();
}else{
$doc =& JFactory::getDocument();
}
$doc->addScriptDeclaration("\n\n");
static $done=true;
if($done){
$done=false;
hikashop_loadJslib('jquery');
hikashop_loadJslib('jquery-ui');
}
$hasValue='';
if(!empty($selected) && $selected[0]==1){
if($values[0]!='none' && ( isset($data) && !in_array($data,array(" ",'')))){
$deleteButton=' '.parent::getDeleteButton($filter, $divName, '11', $html, '', true);
$hasValue='1';
}
}
if($filter->filter_options['title_position']=='left'){
$float='float:left;';
}
$html='';
$html=$this->cursorTitlePosition($filter, $html, $cursorWidth, $divName,$deleteButton,$hasValue);
return $html;
}
function cursorTitlePosition($filter, $html, $width, $divName,$deleteButton,$hasValue){
$unit='';
if(empty($filter->filter_options['range_size'])){
$size=10;
}else{
$size=$filter->filter_options['range_size'];
}
$input='';
$input.='';
$input.=''.$deleteButton;
if($filter->filter_data=='weight' || $filter->filter_data=='length' || $filter->filter_data=='width' || $filter->filter_data=='height' || $filter->filter_data=='surface' || $filter->filter_data=='volume'){
$unit=' ('.$filter->filter_options['information_unit'].')';
}
$name=parent::trans($filter->filter_name).$unit;
$position=$filter->filter_options['title_position'];
switch($position){
case 'top_left':
$html=$name.': '.$input.$html;
break;
case 'top_right':
$html=''.$name.': '.$input.''.$html.'
';
break;
case 'top_center':
$html=''.$name.': '.$input.' '.$html.'
';
break;
case 'bottom_left':
$html=$html.$name.': '.$input;
break;
case 'bottom_right':
$html=''.$html.$name.': '.$input.'
';
break;
case 'bottom_center':
$html=''.$html.$name.': '.$input.'
';
break;
}
return $html;
}
}
class hikashopMultipledropdownClass extends hikashopSingledropdownClass{
function display($filter, $divName, &$parent, $datas='', $multiple='', $tab=''){
$multiple='multiple="multiple" size="5"';
$tab='[]';
return parent::display($filter, $divName, $parent, $datas, $multiple, $tab);
}
}
class hikashopCheckboxClass extends hikashopRadioClass{
function display($filter, $divName, &$parent, $datas='', $type='',$tab=''){
$type='checkbox';
$tab='[]';
return parent::display($filter, $divName, $parent, $datas, $type,$tab);
}
}
class hikashopInStockCheckboxClass extends hikashopFilterTypeClass{
function display($filter, $divName, &$parent, $datas='', $type='',$tab=''){
$html='';
$selected=parent::display($filter, $divName, $parent);
$checked='';
if($selected=='in_stock'){
$checked='checked="checked"';
}
$onClick='';
if($filter->filter_direct_application){
$onClick='onchange="document.forms[\'hikashop_filter_form_'.$divName.'\'].submit();"';
}
$html.= '';
$html.=''.$filter->filter_name.'';
return $html;
}
}