Файловый менеджер

Файловый менеджер - Редактировать - /home/lmsyaran/public_html/administrator/components/com_hikashop/classes/massaction.php

Назад
<?php /** * @package HikaShop for Joomla! * @version 2.2.3 * @author hikashop.com * @copyright (C) 2010-2013 HIKARI SOFTWARE. All rights reserved. * @license GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html / defined('_JEXEC') or die('Restricted access'); ?><?php class hikashopMassactionClass extends hikashopClass{ var $tables = array('massaction'); var $pkeys = array('massaction_id'); var $toggle = array('massaction_published'=>'massaction_id'); var $report = array(); function saveForm(){ $element = new stdClass(); $element->massaction_id = hikashop_getCID('massaction_id'); $formData = JRequest::getVar( 'data', array(), '', 'array' ); foreach($formData['massaction'] as $column => $value){ hikashop_secureField($column); $element->$column = strip_tags($value); } $this->_retreiveData($element,'trigger'); $this->_retreiveData($element,'filter'); $this->_retreiveData($element,'action'); $class = hikashop_get('helper.translation'); $class->getTranslations($element); $result = $this->save($element); if($result){ $class->handleTranslations('massaction',$result,$element); JRequest::setVar( 'cid', $result); } return $result; } function _retreiveData(&$element, $type='trigger'){ $var_name='massaction_'.$type.'s'; $element->$var_name = ''; $formData = JRequest::getVar( $type, array(), '', 'array' ); if(count($formData[$element->massaction_table])>1) $element->$var_name = array(); foreach($formData[$element->massaction_table]['type'] as $i => $selection){ if(empty($selection)) continue; $obj = new stdClass(); $obj->name = $selection; $obj->data = array(); foreach($formData[$element->massaction_table] as $k => $v){ if(is_int($k) && $k==$i){ $obj->data = $v[$selection]; break; } } $element->{$var_name}[$i] = $obj; } } function organizeExportColumn($data,$table,&$elements,&$action,&$types){ switch($data){ case 'product': switch($table){ case 'product': $ids = array(); $database = JFactory::getDBO(); foreach($elements as $element){ if(isset($element->product_parent_id->id)){ $ids[] = $element->product_parent_id->id; }else if($element->product_parent_id){ $ids[] = $element->product_parent_id; } } if(!empty($ids)){ $query = 'SELECT product_id, product_code'; $query .= ' FROM '.hikashop_table('product'); $query .= ' WHERE product_id IN ('.implode(',',$ids).')'; $database->setQuery($query); $rows = $database->loadObjectList(); foreach($elements as $element){ $id = $element->product_parent_id; $element->product_parent_id = ''; $types['product_parent_id']->type = 'text'; foreach($rows as $row){ if($id->id != $row->product_id){continue;} $element->product_parent_id = $row->product_code; } } } break; case 'related': $ids = array(); $database = JFactory::getDBO(); foreach($elements as $element){ $ids[] = $element->product_id; } $query = 'SELECT pr.product_id, p.product_code'; $query .= ' FROM '.hikashop_table('product').' AS p'; $query .= ' INNER JOIN '.hikashop_table('product_related').' AS pr ON pr.product_related_id = p.product_id'; $query .= ' WHERE pr.product_id IN ('.implode(',',$ids).')'; $database->setQuery($query); $rows = $database->loadObjectList(); $types['related']->type = 'text'; foreach($elements as $element){ foreach($element as $key=>$related){ if($key == 'related'){ foreach($related as $product){ $product->related = ''; foreach($rows as $row){ if($element->product_id != $row->product_id){continue;} $product->related = $row->product_code; } } } } } break; case 'category': unset($action['category']); $database = JFactory::getDBO(); $ids = array(); foreach($elements as $element){ foreach($element as $key=>$data){ if($key == 'category'){ foreach($data as $category){ if(isset($category->category_id)){ $ids[] = $category->category_id; } } } } } if(!empty($ids)){ $query = 'SELECT DISTINCT category_name, category_id'; $query .= ' FROM '.hikashop_table('category'); $query .= ' WHERE category_id IN ('.implode(',',$ids).')'; $database->setQuery($query); $rows = $database->loadObjectList(); foreach($elements as $element){ foreach($element as $key=>$data){ if($key == 'category'){ foreach($data as $category){ if(isset($category->category_id)){ $array = array(); foreach($rows as $row){ if($row->category_id == $category->category_id){ $array[] = $row->category_name; } } $category->categories = $this->separator($array,$data,$table); $types['categories'] = new stdClass(); $types['categories']->type = 'text'; $action['category']['categories'] = 'categories'; } } } } } } break; } break; case 'user': switch($table){ case 'address': foreach($elements as $element){ if(!isset($element->address)){continue;} foreach($element->address as $k=>$address){ if($address->address_default != 1){ unset($element->address[$k]); } } } break; } break; case 'category': unset($action['category']); $database = JFactory::getDBO(); $ids = array(); foreach($elements as $category){ if(isset($category->category_id)){ $ids[] = $category->category_id; } if(isset($category->category_parent_id)){ $ids[] = $category->category_parent_id->id; } } if(!empty($ids)){ $query = 'SELECT DISTINCT category_name, category_id'; $query .= ' FROM '.hikashop_table('category'); $query .= ' WHERE category_id IN ('.implode(',',$ids).')'; $database->setQuery($query); $rows = $database->loadObjectList(); foreach($elements as $category){ if(isset($category->category_parent_id->id)){ $array = array(); foreach($rows as $row){ if($row->category_id == $category->category_parent_id->id){ $array[] = $row->category_name; } } $category->parent_category = $this->separator($array,$data,$table); $types['parent_category']->type = 'text'; $action['category']['parent_category'] = 'parent_category'; } if(isset($category->category_id)){ $array = array(); foreach($rows as $row){ if($row->category_id == $category->category_id){ $array[] = $row->category_name; } } $category->categories = $this->separator($array,$data,$table); $types['categories']->type = 'text'; $action['category']['categories'] = 'categories'; } } } break; case 'order': switch($table){ case 'address': if(isset($action['address'])){ foreach($elements as $element){ $element->shipping_address = array(); $element->billing_address = array(); if(!isset($element->address)){continue;} foreach($element->address as $address){ if($address->address_id === $element->order_shipping_address_id && $address->address_id === $element->order_billing_address_id){ $object = new stdClass(); foreach($address as $column=>$value){ if(isset($action['address'][$column])){continue;} $shipping_column = 'shipping_'.$column; $billing_column = 'billing_'.$column; $action['shipping_address']->$shipping_column = $shipping_column; $action['billing_address']->$billing_column = $billing_column; $object->$shipping_column=$value; $object->$billing_column=$value; $types[$billing_column]->type = $types[$column]->type; $types[$shipping_column]->type = $types[$column]->type; } $element->shipping_address[] = $object; $element->billing_address[] = $object; }else if($address->address_id === $element->order_shipping_address_id){ $object = new stdClass(); foreach($address as $column=>$value){ if(isset($action['address'][$column])){continue;} $shipping_column = 'shipping_'.$column; $action['shipping_address']->$shipping_column = $shipping_column; $object->$shipping_column=$value; $types[$shipping_column]->type = $types[$column]->type; } $element->shipping_address[] = $object; }else if($address->address_id === $element->order_billing_address_id){ $object = new stdClass(); foreach($address as $column=>$value){ if(!isset($action['address'][$column])){continue;} $billing_column = 'billing_'.$column; $action['billing_address']->$billing_column = $billing_column; $object->$billing_column=$value; $types[$billing_column]->type = $types[$column]->type; } $element->billing_address[] = $object; } } } unset($action['address']); } break; case 'order_product': if(isset($action['order_product'])){ foreach($elements as $element){ $cpt = 1; if(!isset($element->order_product)){continue;} if(!isset($element->order_full_tax)){ $element->order_full_tax->value = 0; $action['order']['order_full_tax'] = 'order_full_tax'; $types['order_full_tax']->type = 'price'; } $element->order_full_tax->value += (int)$element->order_shipping_tax->value - (int)$element->order_discount_tax->value; $element->order_full_tax->currency = $element->order_currency_id; foreach($element->order_product as $product){ if(isset($product->order_product_quantity) && isset($product->order_product_tax)){ $element->order_full_tax->value+=round($product->order_product_quantity$product->order_product_tax,2); } $tablename = 'product'.$cpt; $object = new stdClass(); foreach($product as $column=>$value){ if(!isset($action['order_product'][$column])){continue;} $product_column = 'item'.$cpt.'_'.$column; $action[$tablename]->$product_column = $product_column; $object->$product_column = $value; $types[$product_column]->type = $types[$column]->type; } $element->$tablename = array($object); $cpt++; } } unset($action['order_product']); } break; } break; } } function sortResult($table_name,$params){ $params->types = array(); $characteristics = array(); $sub_ids = array('order_user_id','order_partner_id'); $prices = array( 'order_discount_price'=>'order_currency_id', 'order_shipping_price'=>'order_currency_id', 'order_shipping_tax'=>'order_currency_id', 'order_discount_tax'=>'order_currency_id', 'order_payment_price'=>'order_currency_id', 'price_value'=>'price_currency_id', 'order_full_price'=>'order_currency_id', 'user_partern_price'=>'user_partner_currency_id', 'user_unpaid_amout'=>'user_currency_id' ); $weights = array('product_weight'=>'product_weight_unit'); $timestamps = array('product_sale_start','product_sale_end','product_last_seen_date'); $methods_name = array('order_shipping_id'=>'order_shipping_method','order_payment_id'=>'order_payment_method'); $dimensions_unit = array('product_dimension_unit'); $dimensions = array('product_width','product_height','product_length'); $yesnos = array('product_published','order_partner_paid','order_invoice_created','category_published','address_published','address_default','user_partner_paid',array('block','sendEmail')); $jdate = array(); foreach($params->action as $key=>$table){ foreach($table as $action){ $type = new stdClass(); if($action == $key.'_id' \|\| $action == $key.'_parent_id'){ $type->type = 'id'; }else{ $type->type = 'text'; } $params->types[$action] = $type; } } foreach($params->action as $key=>$table){ if($key === 'joomla_users'){ foreach($table as $action){ $params->types[$action]->type = 'joomla_users'; $params->types[$action]->sub_type = 'text'; foreach($jdate as $date){ if($action === $date){ $params->types[$action]->sub_type = 'jdate'; } } foreach($yesnos as $yesno){ if(is_array($yesno)){ foreach($yesno as $y){ if($action === $y){ $params->types[$action]->sub_type = 'yesno'; } } } } } } } foreach($params->action as $key=>$table){ if($key==='usergroups'){ foreach($table as $action){ $params->types[$action]->type = 'usergroups'; } } } foreach($params->action as $key=>$table){ if($key==='joomla_users'){ foreach($table as $action){ $params->types[$action]->type = 'joomla_users'; } } } foreach($params->elements as $element){ foreach($prices as $price=>$currency){ if(isset($element->$currency)){ $params->types[$currency] = new stdClass(); $params->types[$currency]->type = 'currency'; if(isset($element->$price)){ $params->types[$price] = new stdClass(); $params->types[$price]->type = 'price'; $p = new stdClass(); $p->value = $element->$price; $p->currency = $element->$currency; $element->$price = $p; } }else{ foreach($element as $array){ if(is_array($array)){ foreach($array as $data){ if(isset($data->$currency)){ $params->types[$currency] = new stdClass(); $params->types[$currency]->type = 'currency'; if(isset($data->$price)){ $params->types[$price] = new stdClass(); $params->types[$price]->type = 'price'; $p = new stdClass(); $p->value = $data->$price; $p->currency = $data->$currency; $data->$price = $p; } } } } } } } foreach($weights as $weight=>$unit){ if(isset($element->$unit)){ $params->types[$unit] = new stdClass(); $params->types[$unit]->type = 'weight_unit'; if(isset($element->$weight)){ $params->types[$weight] = new stdClass(); $params->types[$weight]->type = 'weight'; } }else{ foreach($element as $array){ if(is_array($array)){ foreach($array as $data){ if(isset($data->$unit)){ $params->types[$unit] = new stdClass(); $params->types[$unit]->type = 'weight_unit'; if(isset($data->$weight)){ $params->types[$weight] = new stdClass(); $params->types[$weight]->type = 'weight'; } } } } } } } if(!empty($element)){ foreach($element as $key=>$related){ if($key == 'related'){ foreach($related as $elem){ $elem->related = new stdClass(); $elem->related->id = $elem->related_id; $elem->related->name = $elem->product_name; $type = new stdClass(); $type->type = 'related'; $params->types['related'] = $type; } }else if($key == 'options'){ foreach($related as $elem){ $elem->options = new stdClass(); $elem->options->id = $elem->options_id; $elem->options->name = $elem->product_name; $type = new stdClass(); $type->type = 'options'; $params->types['options'] = $type; unset($params->action['related']['options']); $params->action['options']['options'] = 'options'; } } } foreach($element as $key=>$charac){ if($key === 'characteristic'){ foreach($charac as $elem){ if(isset($elem->characteristic_parent_id) && $elem->characteristic_parent_id === '0'){ $var_name = $elem->characteristic_value; $characteristics[$elem->characteristic_id] = $var_name; $params->types[$var_name]->type = 'characteristic'; }else if(isset($params->column)){ $column = $params->column; $characteristics[$elem->characteristic_id] = $column; $params->types[$column]->type = 'characteristic'; } } } } } foreach($timestamps as $timestamp){ foreach($params->action as $table){ if(isset($table[$timestamp])){ $params->types[$timestamp]->type = 'date'; } } } if($table_name == 'order'){ if(isset($params->action['order']['order_shipping_id']) && isset($params->action['order']['order_shipping_method'])){ $shipping = array(); $shipping['shipping']['shipping_name'] = 'shipping_name'; $params->action = $this->array_insert($params->action,1,$shipping); $params->types['shipping_name'] = new stdClass(); $params->types['shipping_name']->type = 'method_name'; } if(isset($params->action['order']['order_payment_id']) && isset($params->action['order']['order_payment_method'])){ $payment = array(); $payment['payment']['payment_name'] = 'payment_name'; $params->action = $this->array_insert($params->action,2,$payment); $params->types['payment_name'] = new stdClass(); $params->types['payment_name']->type = 'method_name'; } } foreach($params->action as $key => $action){ if(isset($action[$key.'_created'])){ $column = $key.'_created'; $params->types[$column]->type = 'date'; } if(isset($action[$key.'_modified'])){ $column = $key.'_modified'; $params->types[$column]->type = 'date'; } } if(isset($params->action['product']['product_dimension_unit'])){ $params->types['product_dimension_unit']->type = 'dimension_unit'; } $dim = new stdClass(); foreach($dimensions as $dimension){ if(isset($params->action[$table_name][$dimension])){ $dimension_unit = $table_name.'_dimension_unit'; if(is_object($element->$dimension)) $value = $element->$dimension->value; else $value = $element->$dimension; $element->$dimension = new stdClass(); $element->$dimension->unit = $element->$dimension_unit; $element->$dimension->value = $value; $params->types[$dimension]->type = 'dimension'; } } foreach($params->action as $key => $elem){ $path = $key.'_parent_id'; if(isset($element->$path) && isset($elem[$path])){ $params->types[$path]->type = 'parent'; if(isset($element->$path->id)){ $id = $element->$path->id; }else{ $id = $element->$path; } if(isset($id) && $id != '0'){ $row = $this->parentResults($key, $id); $pathElem = $key.'_name'; $parent = new stdClass(); $parent->id = $element->$path; if($row[0] != null) $parent->name = $row[0]->$pathElem; $element->$path = $parent; }else{ $parent = new stdClass(); $parent->id = '0'; $parent->name = 'None'; $element->$path = $parent; } }else{ if(is_array($element)){ foreach($element as $ele){ if(is_array($ele)){ foreach($ele as $data){ if(isset($data->$path) && isset($elem[$path])){ $id = $data->$path; if(isset($data->$path->id)){ $id = $data->$path->id; }else{ $id = $data->$path; } $params->types[$path]->type = 'parent'; if($id != '0'){ $row = $this->parentResults($key, $id); $pathElem = $key.'_name'; $parent = new stdClass(); $parent->id = $data->$path; if($row[0] != null) $parent->name = $row[0]->$pathElem; $data->$path = $parent; }else{ $parent = new stdClass(); $parent->id = '0'; $parent->name = 'None'; $data->$path = $parent; } } } } } } } } if(!empty($element)){ foreach($element as $key=>$charac){ if($key === 'characteristic'){ foreach($charac as $elem){ foreach($characteristics as $k => $data){ if(isset($elem->characteristic_parent_id) && $k == $elem->characteristic_parent_id){ $characteristic = new stdClass(); $characteristic->name = $data; $characteristic->value = $elem->characteristic_value; $elem->$data = $characteristic; }else if(isset($params->column) && $k == $elem->characteristic_id){ $characteristic = new stdClass(); $characteristic->name = $data; $characteristic->value = $elem->characteristic_value; $elem->$data = $characteristic; } } } } } foreach($element as $key=>$charac){ if($key === 'usergroups'){ foreach($charac as $elem){ $elem->usergroups = $elem->title; } } } } } foreach($params->action as $key=>$action){ $column_layout = $key.'_layout'; if(isset($params->action[$key][$column_layout])){ $type = new stdClass(); $type->type = 'layout'; $params->types[$column_layout] = $type; } $column_status = $key.'_status'; if(isset($params->action[$key][$column_status])){ $type = new stdClass(); $type->type = 'status'; $params->types[$column_status] = $type; } } foreach($yesnos as $yesno){ foreach($params->action as $key=>$table){ if(!is_array($yesno) && isset($table[$yesno])){ $params->types[$yesno]->type = 'yesno'; } } } if(isset($params->action['shipping']['shipping_name'])){ unset($params->action['order']['order_shipping_id']); unset($params->action['order']['order_shipping_method']); } if(isset($params->action['payment']['payment_name'])){ unset($params->action['order']['order_payment_id']); unset($params->action['order']['order_payment_method']); } foreach($sub_ids as $sub_id){ foreach($params->action as $table){ if(isset($table[$sub_id])){ $params->types[$sub_id]->type = 'sub_id'; } } } $params->lock = array(); $params->lock['product']['product_id'] = new stdClass(); $params->lock['product']['product_type'] = new stdClass(); $params->lock['product']['product_parent_id'] = new stdClass(); $params->lock['price']['price_id'] = new stdClass(); $params->lock['price']['price_product_id'] = new stdClass(); $params->lock['category']['category_id'] = new stdClass(); switch($table_name){ case 'product': $params->lock['product']['product_id'] = new stdClass(); $params->lock['product']['product_id']->column = true; $params->lock['product']['product_id']->square = true; $params->lock['product']['product_id']->ids = 'all'; $params->lock['product']['product_type'] = new stdClass(); $params->lock['product']['product_type']->column = true; $params->lock['product']['product_type']->square = true; $params->lock['product']['product_type']->ids = 'all'; $params->lock['product']['product_parent_id'] = new stdClass(); $params->lock['product']['product_parent_id']->column = true; $params->lock['product']['product_parent_id']->square = true; $params->lock['product']['product_parent_id']->ids = 'all'; $params->lock['product']['price_id'] = new stdClass(); $params->lock['price']['price_id']->column = true; $params->lock['price']['price_id']->square = true; $params->lock['price']['price_id']->ids = 'all'; $params->lock['product']['category_id'] = new stdClass(); $params->lock['category']['category_id']->column = true; $params->lock['category']['category_id']->square = false; $params->lock['category']['category_id']->ids = ''; $params->lock['product']['price_product_id'] = new stdClass(); $params->lock['price']['price_product_id']->column = true; $params->lock['price']['price_product_id']->square = true; $params->lock['price']['price_product_id']->ids = 'all'; foreach($params->action as $key=>$table){ foreach($table as $action){ if($key == 'category' && $action !='category_id'){ $params->lock['category'][$action] = new stdClass(); $params->lock['category'][$action]->column = true; $params->lock['category'][$action]->square = true; $params->lock['category'][$action]->ids = 'all'; } if($key == 'characteristic'){ $params->lock['characteristic'][$action] = new stdClass(); $params->lock['characteristic'][$action]->column = true; $params->lock['characteristic'][$action]->square = true; foreach($params->elements as $element){ if($element->product_type == 'variant'){ $params->lock['characteristic'][$action]->ids[] = $element->product_id; } } } } } break; case 'category': $params->lock['category']['category_id'] = new stdClass(); $params->lock['category']['category_id']->column = true; $params->lock['category']['category_id']->square = true; $params->lock['category']['category_id']->ids = 'all'; $params->lock['category']['category_type'] = new stdClass(); $params->lock['category']['category_type']->column = true; $params->lock['category']['category_type']->square = true; $params->lock['category']['category_type']->ids = 'all'; $params->lock['category']['category_parent_id'] = new stdClass(); $params->lock['category']['category_parent_id']->column = true; $params->lock['category']['category_parent_id']->square = false; $params->lock['category']['category_parent_id']->ids = ''; $params->lock['category']['category_left'] = new stdClass(); $params->lock['category']['category_left']->column = true; $params->lock['category']['category_left']->square = true; $params->lock['category']['category_left']->ids = 'all'; $params->lock['category']['category_right'] = new stdClass(); $params->lock['category']['category_right']->column = true; $params->lock['category']['category_right']->square = true; $params->lock['category']['category_right']->ids = 'all'; $params->lock['category']['category_depth'] = new stdClass(); $params->lock['category']['category_depth']->column = true; $params->lock['category']['category_depth']->square = true; $params->lock['category']['category_depth']->ids = 'all'; $params->lock['category']['category_menu'] = new stdClass(); $params->lock['category']['category_menu']->column = true; $params->lock['category']['category_menu']->square = true; $params->lock['category']['category_menu']->ids = 'all'; break; case 'order': $params->lock['order']['order_id'] = new stdClass(); $params->lock['order']['order_id']->column = true; $params->lock['order']['order_id']->square = true; $params->lock['order']['order_id']->ids = 'all'; $params->lock['order']['order_type'] = new stdClass(); $params->lock['order']['order_type']->column = true; $params->lock['order']['order_type']->square = true; $params->lock['order']['order_type']->ids = 'all'; $params->lock['order']['order_tax_info'] = new stdClass(); $params->lock['order']['order_tax_info']->column = true; $params->lock['order']['order_tax_info']->square = true; $params->lock['order']['order_tax_info']->ids = 'all'; $params->lock['order']['order_full_price'] = new stdClass(); $params->lock['order']['order_full_price']->column = true; $params->lock['order']['order_full_price']->square = true; $params->lock['order']['order_full_price']->ids = 'all'; $params->lock['order']['order_user_id'] = new stdClass(); $params->lock['order']['order_user_id']->column = true; $params->lock['order']['order_user_id']->square = false; $params->lock['order']['order_user_id']->ids = ''; $params->lock['order']['order_partner_id'] = new stdClass(); $params->lock['order']['order_partner_id']->column = true; $params->lock['order']['order_partner_id']->square = false; $params->lock['order']['order_partner_id']->ids = ''; $params->lock['order_product']['order_product_id'] = new stdClass(); $params->lock['order_product']['order_product_id']->column = true; $params->lock['order_product']['order_product_id']->square = true; $params->lock['order_product']['order_product_id']->ids = 'all'; $params->lock['order_product']['product_id'] = new stdClass(); $params->lock['order_product']['product_id']->column = true; $params->lock['order_product']['product_id']->square = true; $params->lock['order_product']['product_id']->ids = 'all'; $params->lock['order_product']['order_id'] = new stdClass(); $params->lock['order_product']['order_id']->column = true; $params->lock['order_product']['order_id']->square = true; $params->lock['order_product']['order_id']->ids = 'all'; $params->lock['order_product']['order_product_name'] = new stdClass(); $params->lock['order_product']['order_product_name']->column = true; $params->lock['order_product']['order_product_name']->square = true; $params->lock['order_product']['order_product_name']->ids = 'all'; $params->lock['order_product']['order_product_code'] = new stdClass(); $params->lock['order_product']['order_product_code']->column = true; $params->lock['order_product']['order_product_code']->square = true; $params->lock['order_product']['order_product_code']->ids = 'all'; $params->lock['order_product']['order_product_price'] = new stdClass(); $params->lock['order_product']['order_product_price']->column = true; $params->lock['order_product']['order_product_price']->square = true; $params->lock['order_product']['order_product_price']->ids = 'all'; $params->lock['order_product']['order_product_tax_info'] = new stdClass(); $params->lock['order_product']['order_product_tax_info']->column = true; $params->lock['order_product']['order_product_tax_info']->square = true; $params->lock['order_product']['order_product_tax_info']->ids = 'all'; $params->lock['order_product']['order_product_option'] = new stdClass(); $params->lock['order_product']['order_product_option']->column = true; $params->lock['order_product']['order_product_option']->square = true; $params->lock['order_product']['order_product_option']->ids = 'all'; $params->lock['order_product']['order_product_parent_id'] = new stdClass(); $params->lock['order_product']['order_product_parent_id']->column = true; $params->lock['order_product']['order_product_parent_id']->square = true; $params->lock['order_product']['order_product_parent_id']->ids = 'all'; $params->lock['order_product']['order_product_wishlist_id'] = new stdClass(); $params->lock['order_product']['order_product_wishlist_id']->column = true; $params->lock['order_product']['order_product_wishlist_id']->square = true; $params->lock['order_product']['order_product_wishlist_id']->ids = 'all'; $params->lock['order_product']['order_product_options'] = new stdClass(); $params->lock['order_product']['order_product_options']->column = true; $params->lock['order_product']['order_product_options']->square = true; $params->lock['order_product']['order_product_options']->ids = 'all'; $params->lock['order_product']['order_product_tax'] = new stdClass(); $params->lock['order_product']['order_product_tax']->column = true; $params->lock['order_product']['order_product_tax']->square = true; $params->lock['order_product']['order_product_tax']->ids = 'all'; $params->lock['order_product']['order_product_option_parent_id'] = new stdClass(); $params->lock['order_product']['order_product_option_parent_id']->column = true; $params->lock['order_product']['order_product_option_parent_id']->square = true; $params->lock['order_product']['order_product_option_parent_id']->ids = 'all'; $params->lock['order_product']['order_product_shipping_id'] = new stdClass(); $params->lock['order_product']['order_product_shipping_id']->column = true; $params->lock['order_product']['order_product_shipping_id']->square = true; $params->lock['order_product']['order_product_shipping_id']->ids = 'all'; $params->lock['order_product']['order_product_shipping_price'] = new stdClass(); $params->lock['order_product']['order_product_shipping_price']->column = true; $params->lock['order_product']['order_product_shipping_price']->square = true; $params->lock['order_product']['order_product_shipping_price']->ids = 'all'; $params->lock['order_product']['order_product_shipping_tax'] = new stdClass(); $params->lock['order_product']['order_product_shipping_tax']->column = true; $params->lock['order_product']['order_product_shipping_tax']->square = true; $params->lock['order_product']['order_product_shipping_tax']->ids = 'all'; $params->lock['order_product']['order_product_shipping_params'] = new stdClass(); $params->lock['order_product']['order_product_shipping_params']->column = true; $params->lock['order_product']['order_product_shipping_params']->square = true; $params->lock['order_product']['order_product_shipping_params']->ids = 'all'; $params->lock['order_product']['order_product_shipping_method'] = new stdClass(); $params->lock['order_product']['order_product_shipping_method']->column = true; $params->lock['order_product']['order_product_shipping_method']->square = true; $params->lock['order_product']['order_product_shipping_method']->ids = 'all'; foreach($params->action as $key=>$table){ foreach($table as $action){ if($key == 'user' \|\| $key == 'joomla_users'){ $params->lock[$key][$action] = new stdClass(); $params->lock[$key][$action]->column = true; $params->lock[$key][$action]->square = true; $params->lock[$key][$action]->ids = 'all'; } } } break; case 'user': $params->lock['user']['user_id'] = new stdClass(); $params->lock['user']['user_id']->column = true; $params->lock['user']['user_id']->square = true; $params->lock['user']['user_id']->ids = 'all'; $params->lock['user']['user_cms_id'] = new stdClass(); $params->lock['user']['user_cms_id']->column = true; $params->lock['user']['user_cms_id']->square = true; $params->lock['user']['user_cms_id']->ids = 'all'; $params->lock['user']['params'] = new stdClass(); $params->lock['user']['params']->column = true; $params->lock['user']['params']->square = false; $params->lock['user']['params']->ids = ''; $params->lock['joomla_users']['params'] = new stdClass(); $params->lock['joomla_users']['params']->column = true; $params->lock['joomla_users']['params']->square = false; $params->lock['joomla_users']['params']->ids = ''; $params->lock['usergroups']['usergroups'] = new stdClass(); $params->lock['usergroups']['usergroups']->column = true; $params->lock['usergroups']['usergroups']->square = true; $params->lock['usergroups']['usergroups']->ids = 'all'; $params->lock['address']['address_id'] = new stdClass(); $params->lock['address']['address_id']->column = true; $params->lock['address']['address_id']->square = true; $params->lock['address']['address_id']->ids = 'all'; $params->lock['address']['address_user_id'] = new stdClass(); $params->lock['address']['address_user_id']->column = true; $params->lock['address']['address_user_id']->square = true; $params->lock['address']['address_user_id']->ids = 'all'; break; case 'address': $params->lock['address']['address_id'] = new stdClass(); $params->lock['address']['address_id']->column = true; $params->lock['address']['address_id']->square = true; $params->lock['address']['address_id']->ids = 'all'; $params->lock['address']['address_user_id'] = new stdClass(); $params->lock['address']['address_user_id']->column = true; $params->lock['address']['address_user_id']->square = true; $params->lock['address']['address_user_id']->ids = 'all'; $params->lock['user']['user_id'] = new stdClass(); $params->lock['user']['user_id']->column = true; $params->lock['user']['user_id']->square = true; $params->lock['user']['user_id']->ids = 'all'; $params->lock['user']['user_cms_id'] = new stdClass(); $params->lock['user']['user_cms_id']->column = true; $params->lock['user']['user_cms_id']->square = true; $params->lock['user']['user_cms_id']->ids = 'all'; $params->lock['joomla_users']['id'] = new stdClass(); $params->lock['joomla_users']['id']->column = true; $params->lock['joomla_users']['id']->square = true; $params->lock['joomla_users']['id']->ids = 'all'; break; } if($params->table != 'product' && $params->table != 'category' && $params->table != 'user' && $params->table != 'order' && $params->table != 'address'){ if(!isset($this->dispatcher)){ JPluginHelper::importPlugin('hikashop'); $this->dispatcher = JDispatcher::getInstance(); } $this->dispatcher->trigger('onSortData'.$params->table.'MassAction',array($table_name,&$params)); } return $params; } function separator($array,$data,$table){ $separator = array(); $separator['product']['price'] = ' \| '; $separator['product']['category'] = ';'; $separator['product']['related'] = ';'; $separator['user']['usergroups'] = ';'; $cpt = 0; $row = ''; foreach($array as $element){ if($cpt == 0){ $row .= $element; $cpt++; }else{ if(!isset($separator[$data][$table])){ $row .= $element; }else{ $row .= $separator[$data][$table].$element; } } } return $row; } function displayByType($types,$element,$column,$format=null){ $square = ''; foreach($types as $key => $type){ if($key === $column){ switch($type->type){ case 'price': if($element->$column->currency != '0' && JRequest::getVar('from_task','displayResults') == 'displayResults'){ $currency = hikashop_get('class.currency'); $square = $currency->format($element->$column->value,$element->$column->currency); }else{ $square = $element->$column->value; } break; case 'date': $square = hikashop_getDate($element->$column,$format); break; case 'joomla_users': switch($type->sub_type){ case 'jdate': $square = hikashop_getDate($element->$column,$format); break; default: $square = $element->$column; break; } break; case 'parent': $square = $element->$column->id.' : '.$element->$column->name; break; case 'dimension': $square = $element->$column->value.' '.$element->$column->unit; break; case 'weight': case 'weight_unit': case 'dimension_unit': case 'custom_text' : case 'custom_singledropdown': case 'custom_textarea': case 'custom_radio': case 'custom_checkbox': case 'custom_multipledropdown': case 'custom_file': case 'custom_image': case 'custom_zone': case 'text': $square = $element->$column; break; case 'characteristic': $square = $element->$column->value; break; case 'currency' : if($element->$column == '0'){ $square = '0'; }else{ $currency = hikashop_get('class.currency'); $data = $currency->get($element->$column); $square = $data->currency_code; } break; case 'related' : case 'options' : $square = $element->$column->id.' : '.$element->$column->name; break; default : if(strpos($type->type,'custom_') === 0){ if(!isset($this->dispatcher)){ JPluginHelper::importPlugin('hikashop'); $this->dispatcher = JDispatcher::getInstance(); } $this->dispatcher->trigger('onDisplayByTypeMassAction'.$type->type,array($element,$column,$format=null)); }else{ $square = $element->$column; } break; } return $square; } } } function array_insert($array, $index, $insert) { $key_insert = array_keys($insert); $key_array = array_keys($array); $values_insert = array_values ($insert); $values_array = array_values ($array); $k = array(); $v = array(); for($i = 0;$i<count($array) + count($insert);$i++){ if($i<$index){ $k[$i] = $key_array[$i]; }else if($i == $index){ $k[$i] = $key_insert[0]; }else if($i < $index + count($insert)){ $k[$i] = $key_insert[$i-count($array)]; }else{ $k[$i] = $key_array[$i-count($insert)]; } } for($i = 0;$i<count($array) + count($insert);$i++){ if($i<$index){ $v[$i] = $values_array[$i]; }else if($i == $index){ $v[$i] = $values_insert[0]; }else if($i < $index + count($insert)){ $v[$i] = $values_insert[$i-count($array)]; }else{ $v[$i] = $values_array[$i-count($insert)]; } } $r = array(); for ($i = 0; $i < count ($k); $i ++) $r[$k[$i]] = $v[$i]; return $r; } function parentResults($table,$id){ $database = JFactory::getDBO(); switch($table){ case 'category': $query = 'SELECT category_name, category_id'; $query .= ' FROM '.hikashop_table('category'); $query .= ' WHERE category_id = '.(int)$id; break; case 'product': $query = 'SELECT product_name, product_id'; $query .= ' FROM '.hikashop_table('product'); $query .= ' WHERE product_id = '.(int)$id; break; default: if(!isset($this->dispatcher)){ JPluginHelper::importPlugin('hikashop'); $this->dispatcher = JDispatcher::getInstance(); } $this->dispatcher->trigger('onLoadParentResultMassAction'.$table,array($table,$id)); break; } if(!empty($query)){ $database->setQuery($query); $rows = $database->loadObjectList(); return $rows; } return false; } function save(&$element){ if(isset($element->massaction_triggers) && empty($element->massaction_triggers)) $element->massaction_triggers = ''; if(isset($element->massaction_filters) && empty($element->massaction_filters)) $element->massaction_filters = ''; if(isset($element->massaction_actions) && empty($element->massaction_actions)) $element->massaction_actions = ''; if(!isset($this->dispatcher)){ JPluginHelper::importPlugin('hikashop'); $this->dispatcher = JDispatcher::getInstance(); } $this->dispatcher->trigger('onBeforeMassactionCreate',array(&$element)); $this->dispatcher->trigger('onBeforeMassactionUpdate',array(&$element)); $this->prepare($element,'serialize'); $status = parent::save($element); if(!$status){ return false; } $this->dispatcher->trigger('onAfterMassactionCreate',array(&$element)); $this->dispatcher->trigger('onAfterMassactionUpdate',array(&$element)); return $status; } function get($id,$default=null){ $element = parent::get($id); if($element){ $this->prepare($element); } return $element; } function prepare(&$massaction,$action='unserialize'){ $vars = array('triggers','actions','filters'); foreach($vars as $var){ $key = 'massaction_'.$var; if(!empty($massaction->$key)){ $massaction->$key = $action($massaction->$key); } } } function trigger($trigger,$elements=array()){ if(empty($trigger)) return false; static $done = array(); if(isset($done[$trigger])) return true; $done[$trigger]=true; static $massactions = null; if(!isset($massactions)){ $this->database->setQuery('SELECT * FROM #__hikashop_massaction WHERE massaction_published=1 && massaction_triggers!=\'\''); $massactionsFromDB = $this->database->loadObjectList(); $ordered = array(); if(!empty($massactionsFromDB)){ foreach($massactionsFromDB as $massactionFromDB){ $this->prepare($massactionFromDB); if(!empty($massactionFromDB->massaction_triggers) && is_array($massactionFromDB->massaction_triggers) && count($massactionFromDB->massaction_triggers)){ foreach($massactionFromDB->massaction_triggers as $k=>$data){ if(!isset($ordered[$data->name])){ $ordered[$data->name] = array(); } $ordered[$data->name][] = $massactionFromDB; } } } } $massactions = $ordered; } if(empty($massactions[$trigger])){ return true; } foreach($massactions[$trigger] as $massaction){ $this->process($massaction,$elements); } return true; } function process(&$massaction,&$elements){ if(!isset($this->dispatcher)){ JPluginHelper::importPlugin('hikashop'); $this->dispatcher = JDispatcher::getInstance(); } $query = new HikaShopQuery(); $table = strtolower($massaction->massaction_table); $query->select = 'hk_'.$table.'.'; $query->from = '#__hikashop_'.$table.' as hk_'.$table; $oldElement = $elements; if(!empty($massaction->massaction_filters)){ foreach($massaction->massaction_filters as $k => $filter){ $this->dispatcher->trigger('onProcess'.ucfirst($massaction->massaction_table).'MassFilter'.$filter->name,array(&$elements,&$query,&$filter->data,$k)); } } if((!is_array($elements) \|\| !count($elements)) && empty($oldElement)){ $query->select = array($query->select); $elements = $query->execute(); } if(is_array($elements) && count($elements) && !empty($massaction->massaction_actions)){ foreach($massaction->massaction_actions as $k => $action){ $this->report = array_merge($this->report,$this->dispatcher->trigger('onProcess'.ucfirst($massaction->massaction_table).'MassAction'.$action->name,array(&$elements,&$action->data,$k))); } } return true; } function editionSquare($data,$data_id,$table,$column,$value,$id,$type){ hikashop_securefield($column); hikashop_securefield($table); hikashop_securefield($data); $database = JFactory::getDBO(); switch($type){ case 'date': $value = hikashop_getTime($value); break; } if(!isset($this->dispatcher)){ JPluginHelper::importPlugin('hikashop'); $this->dispatcher = JDispatcher::getInstance(); } $this->dispatcher->trigger('onSaveEditionSquareMassAction',array($data,$data_id,$table,$column,$value,$id,$type)); } function checkInElement($element, $filter){ if(is_null($element)) return false; $in = false; if(in_array($filter['operator'],array('<=','>=','<','>')) && !preg_match('/^(?:\d+\|\d\.\d+)$/',$filter['value'])){ $in = false; }else{ switch($filter['operator']){ case 'BEGINS': if(preg_match('/^'.$filter['value'].'/i',$element->$filter['type'])){ $in = true; } break; case 'END': if(preg_match('/'.$filter['value'].'$/i',$element->$filter['type'])){ $in = true; } break; case 'LIKE': if(preg_match('/\b'.$filter['value'].'\b/i',$element->$filter['type'])){ $in = true; } break; case 'NOT LIKE': if(!preg_match('/\b'.$filter['value'].'\b/i',$element->$filter['type'])){ $in = true; } break; case 'CONTAINS': if(preg_match('/'.$filter['value'].'/i',$element->$filter['type'])){ $in = true; } break; case 'NOTCONTAINS': if(!preg_match('/'.$filter['value'].'/i',$element->$filter['type'])){ $in = true; } break; case 'REGEXP': if(preg_match($filter['value'],$element->$filter['type'])){ $in = true; } break; case 'NOT REGEXP': if(!preg_match($filter['value'],$element->$filter['type'])){ $in = true; } break; case 'IS NULL': if($element->$filter['type'] == null){ $in = true; } break; case 'IS NOT NULL': if($element->$filter['type'] != null){ $in = true; } break; case '>': if($element->$filter['type'] > $filter['value']){ $in = true; } break; case '<': if($element->$filter['type'] < $filter['value']){ $in = true; } break; case '>=': if($element->$filter['type'] >= $filter['value']){ $in = true; } break; case '<=': if($element->$filter['type'] <= $filter['value']){ $in = true; } break; case '!=': if($element->$filter['type'] != $filter['value']){ $in = true; } break; default: if($element->$filter['type'] == $filter['value']){ $in = true; } break; } } return $in; } function getRequest($filter, $prefix = ''){ $db = JFactory::getDBO(); $filter['type'] = strip_tags($filter['type']); if(!in_array($filter['operator'],array('<','<='))) $filter['operator'] = strip_tags($filter['operator']); if(!empty($prefix)) $prefix = $prefix.'.'; if((in_array($filter['operator'],array('<=','>=','<','>')) && !preg_match('/^(?:\d+\|\d\.\d+)$/',$filter['value']))){ echo JText::_('WRONG_VALUE').' - '; return '1 = 2'; } switch($filter['operator']){ case 'BEGINS': return $prefix.$filter['type'].' LIKE '.$db->quote($filter['value'].'%'); break; case 'END': return $prefix.$filter['type'].' LIKE '.$db->quote('%'.$filter['value']); break; case 'CONTAINS': return $prefix.$filter['type'].' LIKE '.$db->quote('%'.$filter['value'].'%'); break; case 'NOTCONTAINS': return $prefix.$filter['type'].' NOT LIKE '.$db->quote('%'.$filter['value'].'%'); break; case 'IS NULL': return $prefix.$filter['type'].' IS NULL'; break; case 'IS NOT NULL': return $prefix.$filter['type'].' IS NOT NULL'; break; default: return $prefix.$filter['type'].' '.$filter['operator'].' '.$db->quote($filter['value']); break; } } function getFromFile($element, $check = false){ $data = new stdClass(); $app = JFactory::getApplication(); $importHelper = hikashop_get('helper.import'); $importFile = array(); $elts = explode('/',$element['path']); if($elts == null) return false; $nb = count($elts); if($nb == 1){ $elts = explode('\\',$element['path']); $nb = count($elts); } if(!file_exists($element['path'])){ if(!$check)$app->enqueueMessage(JText::sprintf( 'NO_FILE_FOUND',$element['path']), 'error'); $data->error = 'not_found'; return $data; } hikashop_increasePerf(); $contentFile = @file_get_contents($element['path']); if(!$contentFile){ if(!$check)$app->enqueueMessage(JText::sprintf( 'FAIL_OPEN',$element['path']), 'error'); $data->error = 'fail_open'; return $data; }; $contentFile = str_replace(array("\r\n","\r"),"\n",$contentFile); $importLines = explode("\n", $contentFile); $columns = strip_tags(str_replace('"','',$importLines[0])); $listSeparators = array(';',',','\|',"\t"); $separator = ';'; foreach($listSeparators as $sep){ if(preg_match('#(?!\\\\)'.$sep.'#',$columns)){ $separator = $sep; $columns=str_replace($sep,'\|',$columns); break; } } unset($importLines[0]); if(empty($importLines)){ if(!$check)$app->enqueueMessage('EMPTY','error'); $data->error = 'empty'; return $data; } $columns = explode('\|',$columns); $numberColumns = count($columns); $db = JFactory::getDBO(); if(!HIKASHOP_J25) { $tmp = $db->getTableFields(hikashop_table('product')); $productColumns = reset($tmp); unset($tmp); $tmp = $db->getTableFields(hikashop_table('price')); $priceColumns = reset($tmp); unset($tmp); } else { $productColumns = $db->getTableColumns(hikashop_table('product')); $priceColumns = $db->getTableColumns(hikashop_table('price')); } $db->setQuery('SELECT characteristic_value FROM '.hikashop_table('characteristic').' WHERE characteristic_parent_id = 0'); $characteristicColumns = $db->loadResultArray(); $categoryColumns = array('categories_ordering','parent_category','categories_image','categories'); $otherColumns = array('files','images','related','options'); if(!is_array($characteristicColumns)) $characteristicColumns = array($characteristicColumns); $mergedColumns = array_merge(array_keys($productColumns),array_keys($priceColumns),$categoryColumns,$characteristicColumns,$otherColumns); $wrongColumns = array_diff($columns,$mergedColumns); if(!empty($wrongColumns) && $check){ if(!$check)$app->enqueueMessage('WRONG_COLUMNS','error'); $data->wrongColumns = $wrongColumns; $data->validColumns = $mergedColumns; $data->error = 'wrong_columns'; return $data; }elseif($check){ $data->error = 'valid'; return $data; } if(isset($element['change']) && is_array($element['change'])){ foreach($columns as $num => $column){ foreach($element['change'] as $key => $value){ if($column == $key && $value != 'delete'){ $columns[$num] = $value; } elseif($column == $key && $value == 'delete'){ unset($columns[$num]); } } } } $pool = array(); $missingIds = array(); $missingCodes = array(); foreach($importLines as $key => $importLine){ $product = $this->getProduct($importLines, $key, $numberColumns, $separator); if(!is_array($product)) continue; $newProduct = new stdClass(); foreach($product as $num => $value){ if(!empty($columns[$num])){ $field = $columns[$num]; if( strpos('\|',$field) !== false ) { $field = str_replace('\|','__tr__',$field); } $newProduct->$field = preg_replace('#^[\'" ]{1}(.)[\'" ]{1}$#','$1',$value); } } $pool[$key] = new stdClass(); if(isset($newProduct->product_id)){ $pool[$key]->product_id = $newProduct->product_id; } if(isset($newProduct->product_code)){ $pool[$key]->product_code = $newProduct->product_code; } if(!isset($pool[$key]->product_id) && !isset($pool[$key]->product_code)){ continue; } if(!isset($pool[$key]->product_code)){ $missingCodes[] = $pool[$key]->product_id; } if(!isset($pool[$key]->product_id)){ $missingIds[] = $pool[$key]->product_code; } } $missing = array(); if(!empty($missingCodes)){ $db->setQuery('SELECT * FROM '.hikashop_table('product').' WHERE product_id IN ('.implode(',',$missingCodes).')'); $missingCodes = $db->loadObjectList(); } if(!empty($missingIds)){ $db->setQuery('SELECT * FROM '.hikashop_table('product').' WHERE product_code IN ('.implode(',',$db->quote($missingIds)).')'); $missingIds = $db->loadObjectList(); } $errorcount = 0; $importProducts = array(); foreach($importLines as $key => $importLine){ $product = $this->getProduct($importLines, $key, $numberColumns, $separator); if(!is_array($product)) continue; $newProduct = new stdClass(); foreach($product as $num => $value){ if(!empty($columns[$num])){ $field = $columns[$num]; if( strpos('\|',$field) !== false ) { $field = str_replace('\|','__tr__',$field); } $newProduct->$field = preg_replace('#^[\'" ]{1}(.)[\'" ]{1}$#','$1',$value); } } if(empty($newProduct->product_id)){ foreach($missingIds as $missingId){ if($newProduct->product_code == $missingId->product_code){ $newProduct->product_id = $missingId->product_id; } } } if(empty($newProduct->product_code)){ foreach($missingCodes as $missingCode){ if($newProduct->product_id == $missingCode->product_id){ $newProduct->product_code = $missingCode->product_code; } } } if(empty($newProduct->product_code) \|\| empty($newProduct->product_id)){ $errorcount++; if($errorcount<20){ if(isset($importLine[$key-1]))$app->enqueueMessage(JText::sprintf('IMPORT_ERRORLINE',$importLines[$key-1]).' '.JText::_('PRODUCT_NOT_FOUND'),'notice'); }elseif($errorcount == 20){ $app->enqueueMessage('...','notice'); } }else{ $importProducts[$newProduct->product_id] = $newProduct; $ids[] = $newProduct->product_id; } } $data->ids = $ids; $data->elements = $importProducts; return $data; } function getProduct($importLines, $key, $numberColumns, $separator){ $false = false; if(!isset($importLines[$key]) \|\| empty($importLines[$key])){ return $false; } $quoted = false; $dataPointer=0; $data = array(''); while($data!==false && isset($importLines[$key]) && (count($data) < $numberColumns\|\|$quoted)){ $k = 0; $total = strlen($importLines[$key]); while($k < $total){ switch($importLines[$key][$k]){ case '"': if($quoted && isset($importLines[$key][$k+1]) && $importLines[$key][$k+1]=='"'){ $data[$dataPointer].='"'; $k++; }elseif($quoted){ $quoted = false; }elseif(empty($data[$dataPointer])){ $quoted = true; }else{ $data[$dataPointer].='"'; } break; case $separator: if(!$quoted){ $data[]=''; $dataPointer++; break; } default: $data[$dataPointer].=$importLines[$key][$k]; break; } $k++; } $this->_checkLineData($data,true,$numberColumns,$importLines[$key]); if(count($data) < $numberColumns\|\|$quoted){ $data[$dataPointer].="\r\n"; } } if($data!=false) $this->_checkLineData($data,true,$numberColumns,$importLines[$key]); return $data; } function _checkLineData(&$data,$type=true,$numberColumns,$importLine){ if($type){ $not_ok = count($data) > $numberColumns; }else{ $not_ok = count($data) != $numberColumns; } if($not_ok){ static $errorcount = 0; if(empty($errorcount)){ $app = JFactory::getApplication(); $app->enqueueMessage(JText::sprintf('IMPORT_ARGUMENTS',$numberColumns),'error'); } $errorcount++; if($errorcount<20){ $app = JFactory::getApplication(); $app->enqueueMessage(JText::sprintf('IMPORT_ERRORLINE',$importLine),'notice'); }elseif($errorcount == 20){ $app = JFactory::getApplication(); $app->enqueueMessage('...','notice'); } } } function updateValuesSecure(&$action,&$possibleTables = array(),&$queryTables = array()){ $db = JFactory::getDBO(); $app = JFactory::getApplication(); $tableType = explode('_',$action['type']); if(preg_match('/order_product/',$action['type'])) $tableType = array('order_product'); if($tableType[0] == 'joomla') $queryTables[] = $tableType[0].'_'.$tableType[1]; else $queryTables[] = $tableType[0]; $mainFields = array(); foreach($possibleTables as $possibleTable){ if(version_compare(JVERSION,'3.0','<')){ if(preg_match('/joomla_/',$possibleTable)){ $fieldsTable = $db->getTableFields('#__'.str_replace('joomla_','',$possibleTable)); $fields = reset($fieldsTable); $fieldsTable = $fields; } else{ $fieldsTable = $db->getTableFields('#__hikashop_'.$possibleTable); $fields = reset($fieldsTable); } } else { if(preg_match('/joomla_/',$possibleTable)){ $fields = $db->getTableColumns('#__'.str_replace('joomla_','',$possibleTable)); } else $fields = $db->getTableColumns('#__hikashop_'.$possibleTable); } $mainFields = array_merge($mainFields,$fields); } foreach($mainFields as $key => $field){ $field = str_replace(',','',$field); if($key == $action['type']){ switch($action['operation']){ case 'int': if(in_array($field,array('boolean'))){ $app->enqueueMessage(JText::sprintf( 'WRONG_COLUMN_TYPE', $field)); $queryTables = ''; } break; case 'float': if(in_array($field,array('int','boolean'))){ $app->enqueueMessage(JText::sprintf( 'WRONG_COLUMN_TYPE', $field)); $queryTables = ''; } break; case 'string': if(!in_array($field,array('varchar','text','char'))){ $app->enqueueMessage(JText::sprintf( 'WRONG_COLUMN_TYPE', $field)); $queryTables = ''; } break; } } } if($action['operation'] == 'int'){$value = (int)$action['value'];} elseif($action['operation'] == 'float'){$value = (float)$action['value'];} elseif($action['operation'] == 'string'){$value = $db->quote($action['value']);} elseif($action['operation'] == 'operation'){ $symbols = array('%','+','-','/','','(',')'); $string = str_replace($symbols,'',$action['value']); $string = preg_replace('/[0-9]/i', '',$string); $strings = explode('.',$string); $type = 'table'; if(!empty($mainFields)){ foreach($strings as $string){ if(!empty($string) && $type == 'table'){ if(!in_array($string, $possibleTables)){ $app->enqueueMessage(JText::sprintf('TABLE_NOT_EXIST',$string)); $queryTables = ''; continue; } if(!in_array($string, $queryTables)){ $queryTables[] = 'hk_'.$string; } $type = 'column'; }elseif(!empty($string) && $type == 'column'){ $colKey = array(); foreach($mainFields as $key => $field){ $colKey[] = $key; } if(!in_array($string, $colKey)){ $app->enqueueMessage(JText::sprintf('COLUMN_NOT_EXIST',$string)); $queryTables = ''; } $type = 'table'; } } } if(!preg_match('/^(?:\d+\|\d\.\d+)$/',$action['value'])){ if(in_array($action['value'][0], array('+','-'))){ $value = $action['type'].$action['value']; } else{ $value = 'hk_'.$action['value']; } $value = strip_tags($value); } else{ $value = $db->quote($action['value']); } }else{$value = '';} return $value; } function initDefaultDiv(&$value, $key, $type, $table, &$loadedData, $html){ if($type == 'filter'){ if(!is_int($key)){ $filters_html = '<div id="'.$table.$type.'__num__'.$value->name.'">'; $filters_html .= $html.'</div>'; $loadedData->massaction_filters[$key]->name = ''; return $filters_html; }else{ $loadedData->massaction_filters[$key]->html = '<div id="'.$table.$type.'area_'.$key.'" class="hikamassactionarea">'; $loadedData->massaction_filters[$key]->html .= $html.'</div>'; } }elseif($type == 'action'){ if(!is_int($key)){ $filters_html = '<div id="'.$table.$type.'__num__'.$value->name.'">'; $filters_html .= $html.'</div>'; $loadedData->massaction_actions[$key]->name = ''; return $filters_html; }else{ $loadedData->massaction_actions[$key]->html = '<div id="'.$table.$type.'area_'.$key.'" class="hikamassactionarea">'; $loadedData->massaction_actions[$key]->html .= $html.'</div>'; } } } function _displayResults($table_name,&$elements,&$action,$k){ $params = new stdClass(); $params->elements = $elements; $params->action = $action; $params->table = $table_name; switch($table_name){ case 'product': $ids = array(); foreach($params->elements as $element){ array_push($ids,$element->product_id); } $params->rows_id = $ids; foreach($params->action as $k => $table){ $columns = array(); if($table == $table_name){continue;} foreach($table as $column){ array_push($columns,$column); } $rows = $this->_loadResults($table_name,$k,$ids,$columns); if(!is_array($rows)){continue;} foreach($rows as $row){ foreach($params->elements as $i => $element){ switch($k){ case 'price': if($row->price_product_id != $element->product_id) continue; $params->elements[$i]->price[] = $row; break; case 'category': if($row->product_id != $element->product_id) continue; $params->elements[$i]->category[] = $row; break; case 'characteristic': if($row->variant_product_id != $element->product_id) continue; $params->elements[$i]->characteristic[] = $row; break; case 'related': if($row->product_id != $element->product_id) continue; if($row->product_related_type == 'related'){ $params->elements[$i]->related[] = $row; }else if($row->product_related_type == 'options'){ if(isset($row->related_id)){ $row->options_id = $row->related_id; unset($row->related_id); }else{ $row->options_id = ''; } $params->elements[$i]->options[] = $row; } break; } } } } break; case 'category': $ids = array(); foreach($params->elements as $key=>$element){ if($element->category_parent_id === '0'){ unset($params->elements[$key]); }else{ array_push($ids,$element->category_id); } } $params->rows_id = $ids; break; case 'order': $ids = array(); foreach($params->elements as $element){ array_push($ids,$element->order_id); } $params->rows_id = $ids; foreach($params->action as $k => $table){ $columns = array(); if($table != $table_name){ foreach($table as $column){ array_push($columns,$column); } } $rows = $this->_loadResults($table_name,$k,$ids,$columns); if(!is_array($rows)){continue;} foreach($rows as $row){ foreach($params->elements as $i => $element){ switch($k){ case 'order': if($row->order_id != $element->order_id) continue; $payment = new stdClass(); $payment->payment_name = $row->payment_name; $payment->payment_id = $row->payment_id; $shipping = new stdClass(); $shipping->shipping_name = $row->shipping_name; $shipping->shipping_id = $row->shipping_id; $element->payment[] = $payment; $element->shipping[] = $shipping; break; case 'order_product': if($row->order_id != $element->order_id) continue; $params->elements[$i]->order_product[] = $row; break; case 'address': if($row->order_id != $element->order_id) continue; $params->elements[$i]->address[] = $row; break; case 'user': if($row->user_id != $element->order_user_id) continue; $params->elements[$i]->user[] = $row; break; case 'joomla_users': $test = false; foreach($element as $key=>$elem){ if(is_array($elem) && $key=='user'){ foreach($elem as $data){ if($data->user_cms_id != $row->id){ $test = true; } } } } if($test) continue; $params->elements[$i]->joomla_users[] = $row; break; } } } } break; case 'user': $ids = array(); foreach($params->elements as $element){ array_push($ids,$element->user_id); } $params->rows_id = $ids; foreach($params->action as $k => $table){ $columns = array(); if($table == $table_name){continue;} foreach($table as $column){ array_push($columns,$column); } $rows = $this->_loadResults($table_name,$k,$ids,$columns); if(!is_array($rows)){continue;} foreach($rows as $row){ foreach($params->elements as $i => $element){ switch($k){ case 'address': if($row->address_user_id != $element->user_id) continue; $params->elements[$i]->address[] = $row; break; case 'joomla_users': if($row->joomla_users_id != $element->user_cms_id) continue; $params->elements[$i]->joomla_users[] = $row; break; case 'usergroups': if($row->user_id != $element->user_id) continue; $params->elements[$i]->usergroups[] = $row; break; } } } } break; case 'address': $ids = array(); foreach($params->elements as $element){ array_push($ids,$element->address_id); } $params->rows_id = $ids; foreach($params->action as $k => $table){ $columns = array(); if($table == $table_name){continue;} foreach($table as $column){ array_push($columns,$column); } $rows = $this->_loadResults($table_name,$k,$ids,$columns); if(is_array($rows)){ foreach($rows as $row){ foreach($params->elements as $i => $element){ switch($k){ case 'user': if($row->user_id != $element->address_user_id) continue; $params->elements[$i]->user[] = $row; break; case 'joomla_users': if($row->user_id != $element->address_user_id) continue; $params->elements[$i]->joomla_users[] = $row; break; } } } } } break; } return $params; } function _trigger($trigger,$elements=array()){ $this->trigger($trigger,$elements); } function _loadResults($table_name,$switch_table,$ids,$columns=null){ $database = JFactory::getDBO(); $query = ''; JArrayHelper::toInteger($ids); if(!in_array($switch_table, array('characteristic'))){ foreach($columns as $column){ hikashop_securefield($column); } } switch($table_name){ case 'product': switch($switch_table){ case 'price': $query = 'SELECT '.implode(',',$columns).', price_product_id, price_id'; $query .= ' FROM '.hikashop_table('price'); $query .= ' WHERE price_product_id IN ('.implode(',',$ids).')'; $query .= ' ORDER BY price_id ASC'; break; case 'category': $query = 'SELECT '.hikashop_table('category').'.'.implode(',',$columns).','.hikashop_table('product_category').'.product_id,'.hikashop_table('category').'.category_id'; $query .= ' FROM '.hikashop_table('category'); $query .= ' INNER JOIN '.hikashop_table('product_category').' ON '.hikashop_table('product_category').'.category_id = '.hikashop_table('category').'.category_id'; $query .= ' WHERE product_id IN ('.implode(',',$ids).')'; $query .= ' ORDER BY product_category_id'; break; case 'characteristic': $query = 'SELECT DISTINCT characteristic.characteristic_id,characteristic.characteristic_parent_id, characteristic.characteristic_value, variant.variant_product_id FROM '.hikashop_table('characteristic').' AS characteristic '; $query .= ' LEFT JOIN '.hikashop_table('variant').' AS variant ON characteristic.characteristic_id = variant.variant_characteristic_id'; $query .= ' WHERE variant_product_id IN ('.implode(',',$ids).')'; $query .= ' ORDER BY variant.ordering'; break; case 'related': $query = 'SELECT r.product_id ,p.product_id as \'related_id\',p.product_name, r.product_related_type'; $query .= ' FROM '.hikashop_table('product_related').' AS r'; $query .= ' INNER JOIN '.hikashop_table('product').' AS p ON r.product_related_id = p.product_id'; $query .= ' WHERE r.product_id IN ('.implode(',',$ids).')'; $query .= ' ORDER BY p.product_id ASC'; break; } break; case 'order': switch($switch_table){ case 'order': $query = 'SELECT o.order_id,p.payment_name,p.payment_id,s.shipping_name,s.shipping_id'; $query .= ' FROM '.hikashop_table('order').' as o'; $query .= ' LEFT JOIN '.hikashop_table('shipping').' as s ON o.order_shipping_id = s.shipping_id'; $query .= ' LEFT JOIN '.hikashop_table('payment').' as p ON o.order_payment_id = p.payment_id'; $query .= ' WHERE order_id IN ('.implode(',',$ids).')'; $query .= ' ORDER BY order_id ASC'; break; case 'order_product': $query = 'SELECT '.implode(',',$columns).', order_product_id, order_id'; $query .= ' FROM '.hikashop_table('order_product'); $query .= ' WHERE order_id IN ('.implode(',',$ids).')'; $query .= ' ORDER BY order_product_id ASC'; break; case 'address': foreach($columns as $k => $column){ $columns[$k] = 'address.'.$column; } $query = 'SELECT DISTINCT '.implode(',',$columns).', address.address_id, order1.order_id'; $query .= ' FROM '.hikashop_table('address').' AS address'; $query .= ' INNER JOIN '.hikashop_table('order').' AS order1 ON address.address_id = order1.order_shipping_address_id OR address.address_id = order1.order_billing_address_id'; $query .= ' WHERE order1.order_id IN ('.implode(',',$ids).')'; $query .= ' ORDER BY address_id ASC'; break; case 'user': foreach($columns as $k => $column){ $columns[$k] = 'user.'.$column; } $query = 'SELECT DISTINCT '.implode(',',$columns).', user.user_id, user.user_cms_id'; $query .= ' FROM '.hikashop_table('user').' AS user'; $query .= ' INNER JOIN '.hikashop_table('order').' AS _order ON user.user_id = _order.order_user_id'; $query .= ' WHERE _order.order_id IN ('.implode(',',$ids).')'; $query .= ' ORDER BY user_id ASC'; break; case 'joomla_users': foreach($columns as $k => $column){ $columns[$k] = 'user.'.$column; } $query = 'SELECT DISTINCT '.implode(',',$columns).', user.id'; $query .= ' FROM '.hikashop_table('users',false).' AS user'; $query .= ' INNER JOIN '.hikashop_table('user').' AS hk_user ON user.id = hk_user.user_cms_id'; $query .= ' INNER JOIN '.hikashop_table('order').' AS hk_order ON hk_user.user_id = hk_order.order_user_id'; $query .= ' WHERE hk_order.order_id IN ('.implode(',',$ids).')'; $query .= ' ORDER BY id ASC'; break; } break; case 'user': switch($switch_table){ case 'address': $query = 'SELECT '.implode(',',$columns).', address_user_id, address_default, address_id'; $query .= ' FROM '.hikashop_table('address'); $query .= ' WHERE address_user_id IN ('.implode(',',$ids).') AND address_published = 1'; $query .= ' ORDER BY address_default DESC, address_id DESC'; break; case 'joomla_users': foreach($columns as $k => $column){ $columns[$k] = 'user.'.$column; } $query = 'SELECT DISTINCT '.implode(',',$columns).', user.id as \'joomla_users_id\''; $query .= ' FROM '.hikashop_table('users',false).' AS user'; $query .= ' INNER JOIN '.hikashop_table('user').' AS hk_user ON user.id = hk_user.user_cms_id'; $query .= ' WHERE hk_user.user_id IN ('.implode(',',$ids).')'; $query .= ' ORDER BY id ASC'; break; case 'usergroups': $query = 'SELECT DISTINCT usergroups.title, hk_user.user_id, usergroups.id as \'usergroups_id\''; $query .= ' FROM '.hikashop_table('usergroups',false).' AS usergroups'; $query .= ' INNER JOIN '.hikashop_table('user_usergroup_map',false).' AS user_usergroup ON usergroups.id = user_usergroup.group_id'; $query .= ' INNER JOIN '.hikashop_table('users',false).' AS user ON user.id = user_usergroup.user_id'; $query .= ' INNER JOIN '.hikashop_table('user').' AS hk_user ON user.id = hk_user.user_cms_id'; $query .= ' WHERE hk_user.user_id IN ('.implode(',',$ids).')'; $query .= ' ORDER BY usergroups.id ASC'; break; } break; case 'address': switch($switch_table){ case 'user': foreach($columns as $k => $column){ $columns[$k] = 'user.'.$column; } $query = 'SELECT DISTINCT '.implode(',',$columns).', user.user_id'; $query .= ' FROM '.hikashop_table('user').' AS user'; $query .= ' INNER JOIN '.hikashop_table('address').' AS address ON user.user_id = address.address_user_id'; $query .= ' WHERE address.address_id IN ('.implode(',',$ids).')'; $query .= ' ORDER BY user_id ASC'; break; case 'joomla_users': foreach($columns as $k => $column){ $columns[$k] = 'user.'.$column; } $query = 'SELECT DISTINCT '.implode(', ',$columns).', user.id as \'joomla_users_id\', hk_user.user_id'; $query .= ' FROM '.hikashop_table('users',false).' AS user'; $query .= ' INNER JOIN '.hikashop_table('user').' AS hk_user ON user.id = hk_user.user_cms_id'; $query .= ' INNER JOIN '.hikashop_table('address').' AS address ON hk_user.user_id = address.address_user_id'; $query .= ' WHERE address.address_id IN ('.implode(',',$ids).')'; $query .= ' ORDER BY id ASC'; break; } break; } if(!empty($query)){ $database->setQuery($query); $rows = $database->loadObjectList(); return $rows; } } function _onProcessMassFilteraccessLevel(&$elements,&$query,$filter,$num,$type='product'){ $column_name = $type.'_access'; if(count($elements)){ foreach($elements as $k => $element){ if(empty($filter['type']) \|\| $filter['type'] == 'IN'){ if($element->$column_name=='all' \|\| strpos($element->$column_name,','.$filter['group'].',')!==false){ continue; } }else{ if(strpos($element->$column_name,','.$filter['group'].',')===false){ continue; } } unset($elements[$k]); } }else{ $type = 'hk_'.$type; $operator = (empty($filter['type']) \|\| $filter['type'] == 'IN') ? 'LIKE' : "NOT LIKE"; $where = $type.'.'.$column_name.' '.$operator." '%,".(int)$filter['group'].",%'"; if($operator=='LIKE')$where.= ' OR '.$type.'.'.$column_name."='all'"; else $where.= ' AND '.$type.'.'.$column_name."!='all'"; $query->where[] = $where; } } function _exportCSV($params){ $config =& hikashop_config(); $export = hikashop_get('helper.spreadsheet'); $massaction = hikashop_get('class.massaction'); switch($params->formatExport){ case 'csv': $format = $config->get('export_format','csv'); $separator = $config->get('csv_separator',';'); $force_quote = $config->get('csv_force_quote',1); $export->init($format, 'hikashop_export', $separator, $force_quote); break; case 'xls': $format = 'xls'; $export->init($format, 'hikashop_export',';',true); break; } if(!empty($params->action)){ $row = array(); foreach($params->action as $keyTable=>$table){ $massaction->organizeExportColumn($params->table,$keyTable,$params->elements,$params->action,$params->types); } foreach($params->action as $keyTable=>$table){ foreach($table as $column){ $row[] = $column; } } $export->writeLine($row); } JRequest::setVar('from_task','exportCsv'); if(!empty($params->action)){ foreach($params->elements as $k1=>$element){ $row = array(); foreach($params->action as $key=>$table){ foreach($table as $column){ $find = false; $square = ''; if(isset($element->$column) && ($key===$k1 \|\| $key===$params->table)){ $square .= $massaction->displayByType($params->types,$element,$column); $find = true; }else{ $r = array(); foreach($element as $k=>$elem){ if(!is_array($elem)){continue;} foreach($elem as $data){ if(!isset($data->$column)){continue;} if($k != $key){continue;} $r[] = $massaction->displayByType($params->types,$data,$column); $find = true; } } $square .= $massaction->separator($r,$params->table,$key); } if(!$find){ $row[]=''; }else{ $row[]=$square; } } } $export->writeLine($row); } } if(empty($params->path)){ $export->send(); }else{ $file = hikashop_get('class.file'); $name = ''; $path = explode(DS,$params->path); $name = $path[count($path)-1]; unset($path[count($path)-1]); $params->path = implode(DS,$path); $uploadFolder = rtrim(JPath::clean(html_entity_decode($params->path)), DS.' ').DS; if(!preg_match('#^([A-Z]:)?/.#',$uploadFolder)) { if(!$uploadFolder[0]=='/' \|\| !is_dir($uploadFolder)) { $uploadFolder = JPath::clean($file->getPath('file').trim($uploadFolder, DS.' ').DS); } } if(strstr($name,'.')){ JFile::write($uploadFolder.$name, $export->buffer); } } } } class HikaShopQuery{ var $leftjoin = array(); var $join = array(); var $where = array(); var $from = '#__hikashop_product as product'; var $select = array('product.*'); var $start = 0; var $value = 500; function HikaShopQuery(){ $this->db = JFactory::getDBO(); } function count($type='hk_product.product_id'){ $myquery = $this->getQuery(array('COUNT(DISTINCT '.$type.')')); $this->db->setQuery($myquery); return $this->db->loadResult(); } function execute(){ $this->db->setQuery($this->getQuery(),$this->start,$this->value); return $this->db->loadObjectList(); } function getQuery($select = array()){ $query = ''; if(!empty($select)) $query .= ' SELECT '.implode(',',$select); elseif(!empty($this->select)) $query .= ' SELECT '.implode(',',$this->select); if(!empty($this->from)) $query .= ' FROM '.$this->from; if(!empty($this->join)) $query .= ' JOIN '.implode(' JOIN ',$this->join); if(!empty($this->leftjoin)) $query .= ' LEFT JOIN '.implode(' LEFT JOIN ',$this->leftjoin); if(!empty($this->where)) $query .= ' WHERE ('.implode(') AND (',$this->where).')'; return $query; } function convertQuery($as,$column,$operator,$value){ if($operator == 'CONTAINS'){ $operator = 'LIKE'; $value = '%'.$value.'%'; }elseif($operator == 'BEGINS'){ $operator = 'LIKE'; $value = $value.'%'; }elseif($operator == 'END'){ $operator = 'LIKE'; $value = '%'.$value; }elseif($operator == 'NOTCONTAINS'){ $operator = 'NOT LIKE'; $value = '%'.$value.'%'; }elseif(!in_array($operator,array('REGEXP','NOT REGEXP','IS NULL','IS NOT NULL','NOT LIKE','LIKE','=','!=','>','<','>=','<='))){ die('Operator not safe : '.$operator); } if(strpos($value,'{time}') !== false){ $value = $this->_replaceDate($value); $value = strftime('%Y-%m-%d %H:%M:%S',$value); } $replace = array('{year}','{month}','{day}'); $replaceBy = array(date('Y'),date('m'),date('d')); $value = str_replace($replace,$replaceBy,$value); if(!is_numeric($value) OR in_array($operator,array('REGEXP','NOT REGEXP','NOT LIKE','LIKE'))){ $value = $this->db->Quote($value); } if(in_array($operator,array('IS NULL','IS NOT NULL'))){ $value = ''; } return $as.'.`'.hikashop_secureField($column).'` '.$operator.' '.$value; } function _replaceDate($mydate){ if(strpos($mydate,'{time}') === false) return $mydate; $mydate = str_replace('{time}',time(),$mydate); $operators = array('+','-'); foreach($operators as $oneOperator){ if(!strpos($mydate,$oneOperator)) continue; list($part1,$part2) = explode($oneOperator,$mydate); if($oneOperator == '+'){ $mydate = trim($part1) + trim($part2); }elseif($oneOperator == '-'){ $mydate = trim($part1) - trim($part2); } } return $mydate; } }

| ver. 1.4 | Github | . | PHP 8.1.33 | Генерация страницы: 0.09 | proxy | phpinfo | Настройка