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

Файловый менеджер - Редактировать - /home/lmsyaran/public_html/administrator/components/com_hikashop/helpers/importopenc.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 hikashopImportopencHelper extends hikashopImportHelper { var $hikaDatabaseName; var $opencDatabase; var $opencRootPath; var $sessionParams; var $importcurrencies; function __construct() { parent::__construct(); $this->importName = 'openc'; $this->copyImgDir = ''; $this->copyCatImgDir = ''; $this->copyDownloadDir = ''; $this->copyManufDir = ''; $this->sessionParams = HIKASHOP_COMPONENT.'openc'; jimport('joomla.filesystem.file'); } function importFromOpenc() { @ob_clean(); echo $this->getHtmlPage(); $this->token = hikashop_getFormToken(); flush(); if( isset($_GET['import']) && $_GET['import'] == '1' ) { $app = JFactory::getApplication(); $this->opencDatabase = $app->getUserState($this->sessionParams.'dbName'); $this->opencRootPath = $app->getUserState($this->sessionParams.'rootPath'); $this->hikaDatabaseName = $config->getValue( 'db' ); $this->importcurrencies = $app->getUserState($this->sessionParams.'importcurrencies'); (!empty($this->opencRootPath) && substr($this->opencRootPath, -1))=='/' ? $includestring = 'admin/config.php' : $includestring .= '/admin/config.php'; if (!empty($this->opencRootPath)) include($this->opencRootPath . $includestring); $time = microtime(true); $processed = $this->doImport(); if( $processed ) { $elasped = microtime(true) - $time; if( !$this->refreshPage ) echo '<p></br><a'.$this->linkstyle.'href="'.hikashop_completeLink('import&task=import&importfrom=openc&'.$this->token.'=1&import=1').'">'.JText::_('HIKA_NEXT').'</a></p>'; echo '<p style="font-size:0.85em; color:#605F5D;">Elasped time: ' . round($elasped 1000, 2) . 'ms</p>'; } else { echo '<a'.$this->linkstyle.'href="'.hikashop_completeLink('import&task=show').'">'.JText::_('HIKA_BACK').'</a>'; } } else { echo $this-> getStartPage(); } if( $this->refreshPage ) { echo "<script type=\"text/javascript\">\r\nr = true;\r\n</script>"; } echo '</body></html>'; exit; } function getStartPage() { $app = JFactory::getApplication(); $database = JFactory::getDBO(); $returnString = '<p '.$this->titlefont.'><span'.$this->titlestyle.'>Step 0</span></p>'; $continue = true; $this->opencDatabase = $app->getUserStateFromRequest($this->sessionParams.'dbName', 'opencDbName', '', 'string' ); //getUserStateFromRequest( 'keyFromSession', 'keyFromRequest', '', 'typeKey' ) - JRequest::getString() $this->opencRootPath = $app->getUserStateFromRequest($this->sessionParams.'rootPath', 'opencRootPath', '', 'string' ); $config =& JFactory::getConfig(); $this->hikaDatabaseName = $config->getValue( 'db' ); $this->importcurrencies = $app->getUserStateFromRequest($this->sessionParams.'importcurrencies', 'import_currencies', '', 'string' ); if (empty($this->opencDatabase)) { $returnString .= '<p style="color:red">Please specify a name for your Opencart Database.</p>'; } else { $query = 'SHOW TABLES FROM '.$this->opencDatabase.' LIKE '.$database->Quote(substr(hikashop_table('oc_product',false),3)).';'; try { $database->setQuery($query); $table = $database->loadResult(); } catch(Exception $e) { $returnString .= '<p style="color:red">Error with the openning of the `'.$this->opencDatabase.'` database.</br><span style="font-size:0.75em">Mysql Error :'.$e.'</span></p>'; $continue = false; } if ($continue) { if (empty($table)) $returnString .= '<p style="color:red">Opencart has not been found in the database you specified : '.$this->opencDatabase.'</p>'; else $returnString .= 'The import will now start from the database `'.$this->opencDatabase.'`.</br>First, make a backup of your databases.<br/>'. 'When ready, click on <a '.$this->linkstyle.' href="'.hikashop_completeLink('import&task=import&importfrom=openc&'.$this->token.'=1&import=1').'">'.JText::_('HIKA_NEXT').'</a>, otherwise '; } } $returnString .= '<a'.$this->linkstyle.' href="'.hikashop_completeLink('import&task=show').'">'.JText::_('HIKA_BACK').'</a>'; return $returnString; } function doImport() { if( $this->db == null ) return false; $this->loadConfiguration(); $current = $this->options->current; $ret = true; $next = false; switch($this->options->state) { case 0: $next = $this->createTables(); break; case 1: $next = $this->importTaxes(); break; case 2: $next = $this->importManufacturers(); break; case 3: $next = $this->importCategories(); break; case 4: $next = $this->importProducts(); break; case 5: $next = $this->importProductPrices(); break; case 6: $next = $this->importProductCategory(); break; case 7: $next = $this->importUsers(); break; case 8: $next = $this->importDiscount(); break; case 9: $next = $this->importOrders(); break; case 10: $next = $this->importOrderItems(); break; case 11: $next = $this->importDownloads(); break; case MAX_IMPORT_ID: $next = $this->finishImport(); $ret = false; break; case MAX_IMPORT_ID+1: $next = false; $ret = $this->proposeReImport(); break; default: $ret = false; break; } if( $ret && $next ) { $sql = "UPDATE `#__hikashop_config` SET config_value=(config_value+1) WHERE config_namekey = 'openc_import_state'; "; $this->db->setQuery($sql); $this->db->query(); $sql = "UPDATE `#__hikashop_config` SET config_value=0 WHERE config_namekey = 'openc_import_current';"; $this->db->setQuery($sql); $this->db->query(); } else if( $current != $this->options->current ) { $sql = "UPDATE `#__hikashop_config` SET config_value=".$this->options->current." WHERE config_namekey = 'openc_import_current';"; $this->db->setQuery($sql); $this->db->query(); } return $ret; } function loadConfiguration() { $this->options = null; $firsttime = false; $data = array( 'uploadfolder', 'uploadsecurefolder', 'main_currency', 'openc_import_state', 'openc_import_current', 'openc_import_tax_id', 'openc_import_main_cat_id', 'openc_import_max_hk_cat', 'openc_import_max_hk_prod', 'openc_import_last_openc_cat', 'openc_import_last_openc_prod', 'openc_import_last_openc_user', 'openc_import_last_openc_order', 'openc_import_last_openc_pfile', 'openc_import_last_openc_coupon', 'openc_import_last_openc_voucher', 'openc_import_last_openc_taxrate', 'openc_import_last_openc_taxclass', 'openc_import_last_openc_manufacturer', 'openc_import_max_joomla_user' ); $this->db->setQuery('SELECT config_namekey, config_value FROM `#__hikashop_config` WHERE config_namekey IN ('."'".implode("','",$data)."'".');'); $result = $this->db->loadObjectList(); if (!empty($result)) { foreach($result as $o) { if( substr($o->config_namekey, 0, 13) == 'openc_import_' ) $nk = substr($o->config_namekey, 13); else $nk = $o->config_namekey; $this->options->$nk = $o->config_value; } } else { $firsttime = true; } $this->options->uploadfolder = rtrim(JPath::clean(html_entity_decode($this->options->uploadfolder)),DS.' ').DS; if(!preg_match('#^([A-Z]:)?/.#',$this->options->uploadfolder)){ if(!$this->options->uploadfolder[0]=='/' \|\| !is_dir($this->options->uploadfolder)){ $this->options->uploadfolder = JPath::clean(HIKASHOP_ROOT.DS.trim($this->options->uploadfolder,DS.' ').DS); } } $this->options->uploadsecurefolder = rtrim(JPath::clean(html_entity_decode($this->options->uploadsecurefolder)),DS.' ').DS; if(!preg_match('#^([A-Z]:)?/.#',$this->options->uploadsecurefolder)){ if(!$this->options->uploadsecurefolder[0]=='/' \|\| !is_dir($this->options->uploadsecurefolder)){ $this->options->uploadsecurefolder = JPath::clean(HIKASHOP_ROOT.DS.trim($this->options->uploadsecurefolder,DS.' ').DS); } } if( $firsttime ) { $this->options->state = 0; $this->options->current = 0; $this->options->tax_id = 0; $this->options->last_openc_coupon = 0; $this->options->last_openc_voucher = 0; $this->options->last_openc_pfile = 0; $this->options->last_openc_taxrate = 0; $this->options->last_openc_taxclass = 0; $this->options->last_openc_manufacturer = 0; $element = 'product'; $categoryClass = hikashop_get('class.category'); $categoryClass->getMainElement($element); $this->options->main_cat_id = $element; $this->db->setQuery("SELECT max(category_id) as 'max' FROM `#__hikashop_category`;"); $data = $this->db->loadObjectList(); $this->options->max_hk_cat = (int)($data[0]->max); $this->db->setQuery("SELECT max(product_id) as 'max' FROM `#__hikashop_product`;"); $data = $this->db->loadObjectList(); $this->options->max_hk_prod = (int)($data[0]->max); $this->db->setQuery("SELECT max(id) as 'max' FROM `#__users`;"); $data = $this->db->loadObjectList(); $this->options->max_joomla_user = (int)($data[0]->max); $query='SHOW TABLES LIKE '.$this->db->Quote($this->db->getPrefix().substr(hikashop_table('openc_cat'),3)); $this->db->setQuery($query); $table = $this->db->loadResult(); if(!empty($table)) { $this->db->setQuery("SELECT max(openc_id) as 'max' FROM `#__hikashop_openc_cat`;"); $data = $this->db->loadObjectList(); if( $data ) $this->options->last_openc_cat = (int)($data[0]->max); else $this->options->last_openc_cat = 0; $this->db->setQuery("SELECT max(openc_id) as 'max' FROM `#__hikashop_openc_prod`;"); $data = $this->db->loadObjectList(); if( $data ) $this->options->last_openc_prod = (int)($data[0]->max); else $this->options->last_openc_prod = 0; $this->db->setQuery("SELECT max(order_openc_id) as 'max' FROM `#__hikashop_order`;"); $data = $this->db->loadObjectList(); if( $data ) $this->options->last_openc_order = (int)($data[0]->max); else $this->options->last_openc_order = 0; } else { $this->options->last_openc_cat = 0; $this->options->last_openc_prod = 0; $this->options->last_openc_order = 0; } $this->options->last_openc_user = 0; $sql = 'INSERT IGNORE INTO `#__hikashop_config` (`config_namekey`,`config_value`,`config_default`) VALUES '. "('openc_import_state',".$this->options->state.",".$this->options->state.")". ",('openc_import_current',".$this->options->current.",".$this->options->current.")". ",('openc_import_tax_id',".$this->options->tax_id.",".$this->options->tax_id.")". ",('openc_import_main_cat_id',".$this->options->main_cat_id.",".$this->options->main_cat_id.")". ",('openc_import_max_hk_cat',".$this->options->max_hk_cat.",".$this->options->max_hk_cat.")". ",('openc_import_max_joomla_user',".$this->options->max_joomla_user.",".$this->options->max_joomla_user.")". ",('openc_import_max_hk_prod',".$this->options->max_hk_prod.",".$this->options->max_hk_prod.")". ",('openc_import_last_openc_cat',".$this->options->last_openc_cat.",".$this->options->last_openc_cat.")". ",('openc_import_last_openc_prod',".$this->options->last_openc_prod.",".$this->options->last_openc_prod.")". ",('openc_import_last_openc_user',".$this->options->last_openc_user.",".$this->options->last_openc_user.")". ",('openc_import_last_openc_order',".$this->options->last_openc_order.",".$this->options->last_openc_order.")". ",('openc_import_last_openc_pfile',".$this->options->last_openc_pfile.",".$this->options->last_openc_pfile.")". ",('openc_import_last_openc_coupon',".$this->options->last_openc_coupon.",".$this->options->last_openc_coupon.")". ",('openc_import_last_openc_voucher',".$this->options->last_openc_voucher.",".$this->options->last_openc_voucher.")". ",('openc_import_last_openc_taxrate',".$this->options->last_openc_taxrate.",".$this->options->last_openc_taxrate.")". ",('openc_import_last_openc_taxclass',".$this->options->last_openc_taxclass.",".$this->options->last_openc_taxclass.")". ",('openc_import_last_openc_manufacturer',".$this->options->last_openc_manufacturer.",".$this->options->last_openc_manufacturer.")". ';'; $this->db->setQuery($sql); $this->db->query(); } } function createTables() { echo '<p '.$this->titlefont.'><span'.$this->titlestyle.'>Step 1 :</span> Initialization Tables</p>'; $create = true; $query='SHOW TABLES LIKE '.$this->db->Quote($this->db->getPrefix().substr(hikashop_table('openc_cat'),3)); $this->db->setQuery($query); $table = $this->db->loadResult(); if (!empty($table)) $create = false; if ($create) { $this->db->setQuery("CREATE TABLE IF NOT EXISTS `#__hikashop_openc_prod` (`openc_id` int(11) unsigned NOT NULL DEFAULT '0', `hk_id` int(11) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`openc_id`)) ENGINE=MyISAM"); $this->db->query(); $this->db->setQuery("CREATE TABLE IF NOT EXISTS `#__hikashop_openc_cat` (`openc_cat_id` INT(11) unsigned NOT NULL AUTO_INCREMENT, `openc_id` int(11) unsigned NOT NULL DEFAULT '0', `hk_id` int(11) unsigned NOT NULL DEFAULT '0', `category_type` varchar(255) NULL, PRIMARY KEY (`openc_cat_id`)) ENGINE=MyISAM"); $this->db->query(); $this->db->setQuery("CREATE TABLE IF NOT EXISTS `#__hikashop_openc_user` (`openc_user_id` int(11) unsigned NOT NULL DEFAULT '0', `hk_user_cms_id` int(11) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`openc_user_id`)) ENGINE=MyISAM"); $this->db->query(); $this->db->setQuery("CREATE TABLE IF NOT EXISTS `#__hikashop_openc_customer` (`openc_customer_id` int(11) unsigned NOT NULL DEFAULT '0', `hk_customer_cms_id` int(11) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`openc_customer_id`)) ENGINE=MyISAM"); $this->db->query(); $this->db->setQuery('ALTER IGNORE TABLE `#__hikashop_address` ADD `address_openc_order_info_id` INT(11) NULL'); $this->db->query(); $this->db->setQuery('ALTER IGNORE TABLE `#__hikashop_order` ADD `order_openc_id` INT(11) NULL'); $this->db->query(); $this->db->setQuery('ALTER IGNORE TABLE `#__hikashop_order` ADD INDEX ( `order_openc_id` )'); $this->db->query(); $this->db->setQuery('ALTER IGNORE TABLE `#__hikashop_taxation` ADD `tax_openc_id` INT(11) NULL'); $this->db->query(); echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> All table created</p>'; } else { echo '<p>Tables have been already created.</p>'; } return true; } function importTaxes() { echo '<p '.$this->titlefont.'><span'.$this->titlestyle.'>Step 2 :</span> Import Taxes<p>'; $ret = false; $data = array( 'tax_namekey' => "CONCAT('OPENC_TAX_', octr.tax_rate_id)", 'tax_rate' => 'octr.rate' ); $sql = 'INSERT IGNORE INTO `'.$this->hikaDatabaseName.'`.`#__hikashop_tax` (`'.implode('`,`',array_keys($data)).'`) '. 'SELECT ' . implode(',',$data).' FROM `'.$this->opencDatabase.'`.`oc_tax_rate` AS octr '. 'WHERE octr.tax_rate_id > ' . (int)$this->options->last_openc_taxrate; $this->db->setQuery($sql); $this->db->query(); $total = $this->db->getAffectedRows(); echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Imported taxes: ' . $total . '</p>'; $element = 'tax'; $categoryClass = hikashop_get('class.category'); $categoryClass->getMainElement($element); $data = array( 'category_type' => "'tax'", 'category_name' => "CONCAT('Tax imported (', octc.title,')')", 'category_published' => '1', 'category_parent_id' => $element, 'category_namekey' => " CONCAT('OPENC_TAX_CATEGORY_', octc.tax_class_id)" ); $sql = 'INSERT IGNORE INTO `'.$this->hikaDatabaseName.'`.`#__hikashop_category` (`'.implode('`,`',array_keys($data)).'`) '. 'SELECT ' . implode(',',$data).' FROM `'.$this->opencDatabase.'`.`oc_tax_class` AS octc '; 'WHERE octc.tax_class_id > ' . (int)$this->options->last_openc_taxclass; $this->db->setQuery($sql); $this->db->query(); $total = $this->db->getAffectedRows(); echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Imported Taxes Categories: ' . $total . '</p>'; if( $total > 0 ) { $this->options->max_hk_cat += $total; $this->db->setQuery("UPDATE `#__hikashop_config` SET config_value = ".$this->options->max_hk_cat." WHERE config_namekey = 'openc_import_max_hk_cat'; "); $this->db->query(); $this->importRebuildTree(); } $data = array( 'zone_namekey' => "case when hkz.zone_namekey IS NULL then '' else hkz.zone_namekey end", 'category_namekey' => "CONCAT('OPENC_TAX_CATEGORY_', octc.tax_class_id)", //"case when hkz.zone_id IS NULL then CONCAT('openc_TAX_', octr.tax_rate_id,'_0') else CONCAT('openc_TAX_', octr.tax_rate_id,'_',hkz.zone_id) end", 'tax_namekey' => "CONCAT('OPENC_TAX_', octra.tax_rate_id)", 'taxation_published' => '1', 'taxation_type' => "''", 'tax_openc_id' => 'octc.tax_class_id' //'octra.tax_rate_id' See import product ); $sql = 'INSERT IGNORE INTO `'.$this->hikaDatabaseName.'`.`#__hikashop_taxation` (`'.implode('`,`',array_keys($data)).'`) '. 'SELECT ' . implode(',',$data).' FROM `'.$this->opencDatabase.'`.`oc_tax_class` AS octc '. 'INNER JOIN `'.$this->opencDatabase.'`.`oc_tax_rule` AS octr ON octc.tax_class_id = octr.tax_class_id '. 'INNER JOIN `'.$this->opencDatabase.'`.`oc_tax_rate` AS octra ON octr.tax_rate_id = octra.tax_rate_id '. 'LEFT JOIN `'.$this->opencDatabase.'`.`oc_zone_to_geo_zone` AS ocz ON octra.geo_zone_id = ocz.geo_zone_id '. 'LEFT JOIN `'.$this->opencDatabase.'`.`oc_country` AS occ ON ocz.country_id = occ.country_id ' . "LEFT JOIN `".$this->hikaDatabaseName."`.`#__hikashop_zone` hkz ON occ.iso_code_3 = hkz.zone_code_3 AND hkz.zone_type = 'country' ". 'WHERE octra.tax_rate_id > ' . (int)$this->options->last_openc_taxrate; $this->db->setQuery($sql); $this->db->query(); $total = $this->db->getAffectedRows(); echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Imported Taxations: ' . $total . '</p>'; $ret = true; return $ret; } function importManufacturers() { echo '<p '.$this->titlefont.'><span'.$this->titlestyle.'>Step 3 :</span> Import Manufacturers</p>'; $ret = false; $count = 100; $rebuild = false; $sql1 = 'SELECT * FROM `'.$this->opencDatabase.'`.`oc_manufacturer` ocm '. 'LEFT JOIN `'.$this->hikaDatabaseName.'`.`#__hikashop_openc_cat` hkoc ON ocm.manufacturer_id = hkoc.openc_id AND category_type=\'manufacturer\' '. 'WHERE ocm.manufacturer_id > ' . (int)$this->options->last_openc_manufacturer; 'ORDER BY ocm.manufacturer_id ASC;'; $this->db->setQuery($sql1); $this->db->query(); $datas = $this->db->loadObjectList(); $sql2 = 'INSERT INTO `'.$this->hikaDatabaseName.'`.`#__hikashop_category` (`category_id`,`category_parent_id`,`category_type`,`category_name`,`category_published`,'. '`category_namekey`,`category_description`,`category_menu`) VALUES '; $sql3 = 'INSERT INTO `'.$this->hikaDatabaseName.'`.`#__hikashop_openc_cat` (`openc_id`,`hk_id`,`category_type`) VALUES '; $sql4 = 'INSERT INTO `'.$this->hikaDatabaseName.'`.`#__hikashop_file` (`file_name`,`file_description`,`file_path`,`file_type`,`file_ref_id`) VALUES '; $doSql3 = false; $doSql4 = false; $i = $this->options->max_hk_cat + 1; $ids = array( 0 => $this->options->main_cat_id); $sep = ''; $sep2 = ''; $cpt=0; $echo=false; if( empty($datas) ) { echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Imported manufacturers : 0</p>'; return true; } else { foreach($datas as $data) { if( !empty($data->openc_id) ) { $ids[$data->manufacturer_id] = $data->hk_id; } else { $doSql3 = true; $ids[$data->manufacturer_id] = $i; $sql3 .= $sep.'('.$data->manufacturer_id.','.$i.',\'manufacturer\')'; $i++; $sep = ','; } $cpt++; if( $cpt >= $count ) break; } $sql3 .= ';'; $cpt = 0; $sep = ''; foreach($datas as $data) { if( !empty($data->openc_id) ) continue; $id = $ids[$data->manufacturer_id]; $element = 'manufacturer'; $categoryClass = hikashop_get('class.category'); $categoryClass->getMainElement($element); $d = array( $id, $element, "'manufacturer'", $this->db->quote($data->name), '1', "CONCAT('OPENC_MANUFAC_', ".$data->manufacturer_id .")", "'manufacturer imported from Opencart'", '0' ); $sql2 .= $sep.'('.implode(',',$d).')'; if( !empty($data->image) && !empty($this->opencRootPath)) { $this->copyManufDir = str_replace('\\','/',rtrim(JPath::clean(html_entity_decode(DIR_IMAGE)),DS.' ').DS); if (!$echo) { echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Copying manufacturers images... </p>'; $echo=true; } $doSql4 = true; $sql4 .= $sep2."(".$this->db->quote($data->name).",'',".$this->db->quote($data->image).",'category',".$id.')'; $sep2 = ','; $file_name = str_replace('\\','/',$data->image); if( strpos($file_name,'/') !== false ) { $file_name = substr($file_name, strrpos($file_name,'/')); } $this->copyFile($this->copyManufDir,$data->image, str_replace('//','/',str_replace('\\','/',$this->options->uploadfolder.$file_name))); } $sep = ','; $cpt++; if( $cpt >= $count ) break; } } if($cpt > 0) { $sql2 .= ';'; $sql4 .= ';'; $this->db->setQuery($sql2); $this->db->query(); $total = $this->db->getAffectedRows(); echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Imported Manufacturers : ' . $total . '</p>'; } else { echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Imported Manufacturers : 0</p>'; } if( isset($total) && $total > 0) { $rebuild = true; $this->options->max_hk_cat += $total; $this->db->setQuery("UPDATE `#__hikashop_config` SET config_value = ".$this->options->max_hk_cat." WHERE config_namekey = 'openc_import_max_hk_cat'; "); $this->db->query(); } if ($doSql3) { $this->db->setQuery($sql3); $this->db->query(); $total = $this->db->getAffectedRows(); echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Fallback links : ' . $total . '</p>'; } if($doSql4) { $this->db->setQuery($sql4); $this->db->query(); $total = $this->db->getAffectedRows(); echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Manufacturers files : ' . $total . '</p>'; } if( $rebuild ) $this->importRebuildTree(); if( $cpt < $count ) $ret = true; return $ret; } function importCategories() { echo '<p '.$this->titlefont.'><span'.$this->titlestyle.'>Step 4 :</span> Import General Categories</p>'; jimport('joomla.filesystem.file'); $categoryClass = hikashop_get('class.category'); $rebuild = false; $ret = false; $offset = 0; $count = 100; $cpt = 0; $sep = ''; $sep2 = ''; $echo = false; $statuses = array( 'P' => 'created', 'C' => 'confirmed', 'X' => 'cancelled', 'R'=> 'refunded' , 'S' => 'shipped' ); $this->db->setQuery("SELECT category_keywords, category_parent_id FROM `#__hikashop_category` WHERE category_type = 'status' AND category_name = 'confirmed'"); $data = $this->db->loadObject(); $status_category = $data->category_parent_id; if( $data->category_keywords != 'C' ) { foreach($statuses as $k => $v) { $this->db->setQuery("UPDATE `#__hikashop_category` SET category_keywords = '".$k."' WHERE category_type = 'status' AND category_name = '".$v."'; "); $this->db->query(); } } $this->db->setQuery("SELECT order_status_id, name FROM `".$this->opencDatabase."`.`oc_order_status` WHERE name NOT IN ('".implode("','",$statuses)."','canceled');"); $data = $this->db->loadObjectList(); if( count($data) > 0 ) { $sql0 = 'INSERT IGNORE INTO `'.$this->hikaDatabaseName.'`.`#__hikashop_category` (`category_id`,`category_parent_id`,`category_type`,`category_name`,`category_description`,`category_published`,'. '`category_namekey`,`category_access`,`category_menu`,`category_keywords`) VALUES '; $id = $this->options->max_hk_cat + 1; $sep = ''; foreach($data as $c) { $d = array( $id++, $status_category, "'status'", $this->db->quote( strtolower($c->name) ), "'Order status imported from Opencart'", '1', $this->db->quote('status_openc_import_'.strtolower(str_replace(' ','_',$c->name))), "'all'", '0', $this->db->quote( $c->order_status_id ) ); $sql0 .= $sep.'('.implode(',',$d).')'; $sep = ','; } $this->db->setQuery($sql0); $this->db->query(); $total = $this->db->getAffectedRows(); if( $total > 0 ) { echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Imported order status categories : ' . $total . '</p>'; $rebuild = true; $this->options->max_hk_cat += $total; $this->db->setQuery("UPDATE `#__hikashop_config` SET config_value = ".$this->options->max_hk_cat." WHERE config_namekey = 'openc_import_max_hk_cat'; "); $this->db->query(); $sql0 = ''; } else { echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Imported order status categories : 0</p>'; } } $sql1 = 'SELECT * FROM `'.$this->opencDatabase.'`.`oc_category` occ '. 'INNER JOIN `'.$this->opencDatabase.'`.`oc_category_description` occd ON occ.category_id = occd.category_id '. 'LEFT JOIN `'.$this->hikaDatabaseName.'`.`#__hikashop_openc_cat` hkoc ON occ.category_id = hkoc.openc_id AND category_type=\'category\' '. 'WHERE occ.category_id > '.$this->options->last_openc_cat.' '. 'ORDER BY occ.parent_id ASC, occ.category_id ASC;'; $this->db->setQuery($sql1); $this->db->query(); $datas = $this->db->loadObjectList(); $sql2 = 'INSERT INTO `'.$this->hikaDatabaseName.'`.`#__hikashop_category` (`category_id`,`category_parent_id`,`category_type`,`category_name`,`category_description`,`category_published`,'. '`category_ordering`,`category_namekey`,`category_created`,`category_modified`,`category_access`,`category_menu`) VALUES '; $sql3 = 'INSERT INTO `'.$this->hikaDatabaseName.'`.`#__hikashop_openc_cat` (`openc_id`,`hk_id`,`category_type`) VALUES '; $sql4 = 'INSERT INTO `'.$this->hikaDatabaseName.'`.`#__hikashop_file` (`file_name`,`file_description`,`file_path`,`file_type`,`file_ref_id`) VALUES '; $doSql3 = false; $doSql4 = false; $i = $this->options->max_hk_cat + 1; $ids = array( 0 => $this->options->main_cat_id); $sep = ''; if( empty($datas) ) { echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Imported category : 0</p>'; if( $rebuild ) $this->importRebuildTree(); return true; } else { foreach($datas as $data) { if( !empty($data->openc_id) ) { $ids[$data->category_id] = $data->hk_id; } else { $doSql3 = true; $ids[$data->category_id] = $i; $sql3 .= $sep.'('.$data->category_id.','.$i.',\'category\')'; $i++; $sep = ','; } $cpt++; if( $cpt >= $count ) break; } $sql3 .= ';'; $cpt = 0; $sep = ''; foreach($datas as $data) { if( !empty($data->openc_id) ) continue; $id = $ids[$data->category_id]; if(!empty($ids[$data->parent_id])) $pid = (int)$ids[$data->parent_id]; else $pid = $ids[0]; $element = new stdClass(); $element->category_id = $id; $element->category_parent_id = $pid; $element->category_name = $data->name; $nameKey = $categoryClass->getNameKey($element); $d = array( $id, $pid, "'product'", $this->db->quote($data->name), $this->db->quote($data->description), '1', $data->sort_order, $this->db->quote($nameKey), "'".$data->date_added."'", "'".$data->date_modified."'", "'all'", '0' ); $sql2 .= $sep.'('.implode(',',$d).')'; if( !empty($data->image) && !empty($this->opencRootPath)) { $this->copyCatImgDir = str_replace('\\','/',rtrim(JPath::clean(html_entity_decode(DIR_IMAGE)),DS.' ').DS); if (!$echo) { echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Copying categories images... </p>'; $echo=true; } $doSql4 = true; $sql4 .= $sep2."('','','".$data->image."','category',".$id.')'; $sep2 = ','; $file_name = str_replace('\\','/',$data->image); if( strpos($file_name,'/') !== false ) { $file_name = substr($file_name, strrpos($file_name,'/')); } $this->copyFile($this->copyCatImgDir,$data->image, str_replace('//','/',str_replace('\\','/',$this->options->uploadfolder.$file_name))); } $sep = ','; $cpt++; if( $cpt >= $count ) break; } } if($cpt > 0) { $sql2 .= ';'; $sql4 .= ';'; $this->db->setQuery($sql2); $this->db->query(); $total = $this->db->getAffectedRows(); echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Imported Categories : ' . $total . '</p>'; } else { echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Imported category : 0</p>'; } if( isset($total) && $total > 0) { $rebuild = true; $this->options->max_hk_cat += $total; $this->db->setQuery("UPDATE `#__hikashop_config` SET config_value = ".$this->options->max_hk_cat." WHERE config_namekey = 'openc_import_max_hk_cat'; "); $this->db->query(); } if ($doSql3) { $this->db->setQuery($sql3); $this->db->query(); $total = $this->db->getAffectedRows(); echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Fallback links : ' . $total . '</p>'; } if($doSql4) { $this->db->setQuery($sql4); $this->db->query(); $total = $this->db->getAffectedRows(); echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Categories files : ' . $total . '</p>'; } if( $rebuild ) $this->importRebuildTree(); if( $cpt < $count ) $ret = true; return $ret; } function importProducts() { echo '<p '.$this->titlefont.'><span'.$this->titlestyle.'>Step 5 :</span> Import Products</p>'; $ret = false; $count = 100; $offset = $this->options->current; $max = 0; jimport('joomla.filesystem.file'); $categoryClass = hikashop_get('class.category'); $this->db->setQuery('SELECT ocp.product_id, ocpi.image FROM `'.$this->opencDatabase.'`.`oc_product` ocp '. 'LEFT JOIN `'.$this->opencDatabase.'`.`oc_product_image` ocpi ON ocp.product_id = ocpi.product_id '. 'LEFT JOIN `'.$this->hikaDatabaseName.'`.`#__hikashop_openc_prod` hkprod ON ocp.product_id = hkprod.openc_id '. "WHERE ocp.product_id > ".(int)$offset." AND hkprod.hk_id IS NULL AND (ocp.image IS NOT NULL) AND ocp.image <> '' ". 'ORDER BY product_id ASC LIMIT '.$count.';' ); $datas = $this->db->loadObjectList(); if (!empty($datas) && !empty($this->opencRootPath)) { echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Copying products images... </p>'; $this->copyImgDir = str_replace('\\','/',rtrim(JPath::clean(html_entity_decode(DIR_IMAGE)),DS.' ').DS); foreach($datas as $data) { if( !empty($data->image) ) { $file_name = str_replace('\\','/',$data->image); if( strpos($file_name,'/') !== false ) { $file_name = substr($file_name, strrpos($file_name,'/')); } $this->copyFile($this->copyImgDir,$data->image, $this->options->uploadfolder.$file_name); $max = $data->product_id; } } } if( $max > 0 ) { echo '<p>Copying files...(last proccessed product id: ' . $max . ')</p>'; $this->options->current = $max; $this->refreshPage = true; return $ret; } $data = array( 'product_name' => 'ocpd.name', 'product_description' => 'ocpd.description', 'product_quantity' => 'case when ocp.quantity IS NULL or ocp.quantity < 0 then 0 else ocp.quantity end', 'product_code' => 'ocp.hika_sku', 'product_published' => 'ocp.status', 'product_hit' => 'ocp.viewed', 'product_created' => 'ocp.date_added', 'product_modified' => 'ocp.date_modified', 'product_sale_start' => 'ocp.date_available', 'product_tax_id' => 'hkc.category_id', 'product_type' => "'main'", 'product_url' => "''", 'product_weight' => 'ocp.weight', 'product_weight_unit' => "LOWER(ocwcd.unit)", 'product_dimension_unit' => "LOWER(oclcd.unit)", 'product_min_per_order' => 'ocp.minimum', 'product_sales' => '0', 'product_width' => 'ocp.width', 'product_length' => 'ocp.length', 'product_height' => 'ocp.height', 'product_parent_id' => '0' ); $sql1 = 'INSERT IGNORE INTO `'.$this->hikaDatabaseName.'`.`#__hikashop_product` (`'.implode('`,`',array_keys($data)).'`) '. 'SELECT '.implode(',',$data).' FROM `'.$this->opencDatabase.'`.`oc_product` AS ocp '. 'INNER JOIN `'.$this->opencDatabase.'`.`oc_weight_class_description` ocwcd ON ocp.weight_class_id = ocwcd.weight_class_id '. 'INNER JOIN `'.$this->opencDatabase.'`.`oc_length_class_description` oclcd ON ocp.length_class_id = oclcd.length_class_id '. 'INNER JOIN `'.$this->opencDatabase.'`.`oc_product_description` ocpd ON ocp.product_id = ocpd.product_id '. 'LEFT JOIN `'.$this->hikaDatabaseName.'`.`#__hikashop_taxation` hkt ON hkt.tax_openc_id = ocp.tax_class_id '. 'LEFT JOIN `'.$this->hikaDatabaseName.'`.`#__hikashop_category` hkc ON hkc.category_namekey = hkt.category_namekey '. 'LEFT JOIN `'.$this->hikaDatabaseName.'`.`#__hikashop_openc_prod` AS hkp ON ocp.product_id = hkp.openc_id '. 'WHERE hkp.hk_id IS NULL ORDER BY ocp.product_id ASC;'; $this->db->setQuery("SHOW COLUMNS FROM `".$this->opencDatabase."`.`oc_product` LIKE 'hika_sku';"); $data = $this->db->loadObjectList(); if (empty($data)) { $this->db->setQuery('ALTER TABLE `'.$this->opencDatabase.'`.`oc_product` ADD COLUMN `hika_sku` VARCHAR(255) NOT NULL;'); $this->db->query(); } $this->db->setQuery('UPDATE `'.$this->opencDatabase.'`.`oc_product` AS ocp SET ocp.hika_sku = ocp.sku;'); $this->db->query(); $this->db->setQuery("UPDATE `".$this->opencDatabase."`.`oc_product` AS ocp SET ocp.hika_sku = CONCAT(ocp.model,'_',ocp.product_id) WHERE ocp.hika_sku='';"); $this->db->query(); $this->db->setQuery('SELECT hika_sku FROM `'.$this->opencDatabase.'`.`oc_product` GROUP BY hika_sku HAVING COUNT(hika_sku)>1'); $data = $this->db->loadObjectList(); if (!empty($data)) { foreach ($data as $d) { $this->db->setQuery("UPDATE `oc_product` AS ocp SET ocp.hika_sku = CONCAT(ocp.hika_sku,'_',ocp.product_id) WHERE ocp.hika_sku = '".$d->hika_sku."';"); $this->db->query(); } } echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> SKU generated: '.count($data).'</p>'; $data = array( 'openc_id' => 'ocp.product_id', 'hk_id' => 'hkp.product_id' ); $sql2 = 'INSERT IGNORE INTO `'.$this->hikaDatabaseName.'`.`#__hikashop_openc_prod` (`'.implode('`,`',array_keys($data)).'`) '. 'SELECT '.implode(',',$data).' FROM `'.$this->opencDatabase.'`.`oc_product` AS ocp '. 'INNER JOIN `'.$this->hikaDatabaseName.'`.`#__hikashop_product` AS hkp ON CONVERT(ocp.hika_sku USING utf8) = CONVERT(hkp.product_code USING utf8) '. 'LEFT JOIN `'.$this->hikaDatabaseName.'`.`#__hikashop_openc_prod` hkocp ON hkocp.openc_id = ocp.product_id '. 'WHERE hkocp.hk_id IS NULL;'; $data = array( 'file_name' => "''", 'file_description' => "''", 'file_path' => "SUBSTRING_INDEX(ocpi.image,'/',-1)", 'file_type' => "'product'", 'file_ref_id' => 'hkocp.hk_id' ); $sql4 = 'INSERT IGNORE INTO `'.$this->hikaDatabaseName.'`.`#__hikashop_file` (`'.implode('`,`',array_keys($data)).'`) '. 'SELECT '.implode(',',$data).' FROM `'.$this->opencDatabase.'`.`oc_product` AS ocp '. 'INNER JOIN `'.$this->opencDatabase.'`.`oc_product_image` ocpi ON ocp.product_id = ocpi.product_id '. 'INNER JOIN `'.$this->hikaDatabaseName.'`.`#__hikashop_openc_prod` AS hkocp ON ocp.product_id = hkocp.openc_id '. 'WHERE ocp.product_id > '.(int)$this->options->last_openc_prod. ' AND (ocpi.image IS NOT NULL) AND (ocpi.image <>'." '');"; $sql5 = 'UPDATE `'.$this->hikaDatabaseName.'`.`#__hikashop_product` AS hkp '. 'INNER JOIN `'.$this->hikaDatabaseName.'`.`#__hikashop_openc_prod` AS hkocp ON hkp.product_id = hkocp.hk_id '. 'INNER JOIN `'.$this->opencDatabase.'`.`oc_product` AS ocp ON hkocp.openc_id = ocp.product_id '. "INNER JOIN `".$this->hikaDatabaseName."`.`#__hikashop_category` AS hkc ON hkc.category_type = 'manufacturer' AND ocp.manufacturer_id = hkc.category_menu ". 'SET hkp.product_manufacturer_id = hkc.category_id '. 'WHERE ocp.manufacturer_id > '.(int)$this->options->last_openc_manufacturer.' OR ocp.product_id > '.$this->options->last_openc_prod.';'; $this->db->setQuery($sql1); $this->db->query(); $total = $this->db->getAffectedRows(); echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Inserted products: ' . $total . '</p>'; $this->db->setQuery($sql2); $this->db->query(); $total = $this->db->getAffectedRows(); echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Fallback links: ' . $total . '</p>'; $this->db->setQuery($sql4); $this->db->query(); $total = $this->db->getAffectedRows(); echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Inserted products files: ' . $total . '</p>'; $this->db->setQuery($sql5); $this->db->query(); $total = $this->db->getAffectedRows(); echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Updating products manufacturers: ' . $total . '</p>'; $ret = true; return $ret; } function importVariant() { } function importProductPrices() { echo '<p '.$this->titlefont.'><span'.$this->titlestyle.'>Step 6 :</span> Import Product Prices</p>'; $ret = false; $cpt = 0; $this->db->setQuery('SELECT hkcur.currency_id FROM `'.$this->opencDatabase.'`.`oc_currency` occ '. 'INNER JOIN `'.$this->hikaDatabaseName.'`.`#__hikashop_currency` hkcur ON CONVERT(occ.code USING utf8) = CONVERT( hkcur.currency_code USING utf8) '. "WHERE occ.value = '1.0';"); $data = $this->db->loadObjectList(); if (!empty($data)) { $this->db->setQuery('INSERT IGNORE INTO `'.$this->hikaDatabaseName.'`.`#__hikashop_price` (`price_product_id`,`price_value`,`price_currency_id`,`price_min_quantity`,`price_access`) ' ."SELECT hkprod.hk_Id, ocp.price, '".$data[0]->currency_id."', '0', 'all' " .'FROM `'.$this->opencDatabase.'`.`oc_product` ocp INNER JOIN `'.$this->hikaDatabaseName.'`.`#__hikashop_openc_prod` hkprod ON ocp.product_id = hkprod.openc_id ' .'WHERE ocp.product_id > ' . (int)$this->options->last_openc_prod ); } else { echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Prices imported : 0</p>'; } $ret = $this->db->query(); $cpt = $this->db->getAffectedRows(); echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Prices imported : ' . $cpt .'</p>'; if ($this->importcurrencies) $this->importCurrencies(); return $ret; } function importProductCategory() { echo '<p '.$this->titlefont.'><span'.$this->titlestyle.'>Step 7 :</span> Import Product Category</p>'; $ret = false; $data = array( 'category_id' => 'hocc.hk_id', 'product_id' => 'hocp.hk_id', 'ordering' => '0', ); $sql = 'INSERT IGNORE INTO `'.$this->hikaDatabaseName.'`.`#__hikashop_product_category` (`'.implode('`,`',array_keys($data)).'`) '. 'SELECT ' . implode(',',$data).' FROM `'.$this->opencDatabase.'`.`oc_product_to_category` ocpc '. 'INNER JOIN #__hikashop_openc_cat hocc ON ocpc.category_id = hocc.openc_id AND category_type=\'category\' '. 'INNER JOIN #__hikashop_openc_prod hocp ON ocpc.product_id = hocp.openc_id '. 'WHERE hocp.openc_id > ' . (int)$this->options->last_openc_prod . ' OR hocc.openc_id > ' . $this->options->last_openc_cat; $this->db->setQuery($sql); $ret = $this->db->query(); $total = $this->db->getAffectedRows(); $this->importRebuildTree(); echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Inserted products categories: ' . $total . '</p>'; return $ret; } function importUsers() { echo '<p '.$this->titlefont.'><span'.$this->titlestyle.'>Step 8 :</span> Import Users</p>'; $ret = false; $sqla = 'SELECT ocu.* FROM `'.$this->opencDatabase.'`.`oc_user` ocu '. 'LEFT JOIN `'.$this->hikaDatabaseName.'`.`#__hikashop_openc_user` hkocu ON ocu.user_id = hkocu.openc_user_id '. 'WHERE hkocu.openc_user_id IS NULL '. 'ORDER BY ocu.user_id ASC;'; $this->db->setQuery($sqla); $this->db->query(); $datas = $this->db->loadObjectList(); $i = $this->options->max_joomla_user + 1; if( empty($datas) ) { echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Imported user to Joomla : 0</p>'; } else { $total = $this->importUsersToJoomla($datas,$i,false); echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Imported users to Joomla : ' . $total . '</p>'; echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Fallback links (users) : ' . $total . '</p>'; } $sqla = 'SELECT occu.* FROM `'.$this->opencDatabase.'`.`oc_customer` occu '. 'LEFT JOIN `'.$this->hikaDatabaseName.'`.`#__hikashop_openc_customer` hkoccu ON occu.customer_id = hkoccu.openc_customer_id '. 'WHERE hkoccu.openc_customer_id IS NULL '. 'ORDER BY occu.customer_id ASC;'; $this->db->setQuery($sqla); $this->db->query(); $datas = $this->db->loadObjectList(); if( empty($datas) ) { echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Imported customer to Joomla : 0</p>'; } else { $total = $this->importUsersToJoomla($datas,$i,true); echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Imported customers to Joomla : ' . $total . '</p>'; echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Fallback links (customers) : ' . $total . '</p>'; } $sql0 = 'INSERT IGNORE INTO `'.$this->hikaDatabaseName.'`.`#__hikashop_user` (`user_cms_id`,`user_email`) '. 'SELECT hkoccu.hk_customer_cms_id, occ.email FROM `'.$this->opencDatabase.'`.`oc_customer` occ '. 'INNER JOIN `'.$this->hikaDatabaseName.'`.`#__hikashop_openc_customer` hkoccu ON hkoccu.openc_customer_id = occ.customer_id '. 'LEFT JOIN `'.$this->hikaDatabaseName.'`.`#__hikashop_user` AS hkusr ON hkoccu.hk_customer_cms_id = hkusr.user_cms_id '. 'WHERE hkusr.user_cms_id IS NULL;'; $data = array( 'address_user_id' => 'hku.user_id', 'address_title' => "'Mr'", 'address_firstname' => 'oca.firstname', 'address_lastname' => 'oca.lastname', 'address_company' => 'oca.company', 'address_street' => 'CONCAT(oca.address_1,\' \',oca.address_2)', 'address_post_code' => 'oca.postcode', 'address_city' => 'oca.city', 'address_telephone' => 'occu.telephone', 'address_fax' => 'occu.fax', 'address_state' => 'hkzsta.zone_namekey', 'address_country' => 'hkzcou.zone_namekey', 'address_published' => 4 ); $sql1 = 'INSERT IGNORE INTO `'.$this->hikaDatabaseName.'`.`#__hikashop_address` (`'.implode('`,`',array_keys($data)).'`) '. 'SELECT '.implode(',',$data).' FROM `'.$this->opencDatabase.'`.`oc_customer` AS occu '. 'INNER JOIN `'.$this->opencDatabase.'`.`oc_address` AS oca ON occu.customer_id = oca.customer_id '. 'INNER JOIN `'.$this->hikaDatabaseName.'`.`#__hikashop_openc_customer` hkoccu ON oca.customer_id = hkoccu.openc_customer_id '. 'INNER JOIN `'.$this->hikaDatabaseName.'`.`#__hikashop_user` AS hku ON hkoccu.hk_customer_cms_id = hku.user_cms_id '. 'INNER JOIN `'.$this->opencDatabase.'`.`oc_country` AS occ ON oca.country_id = occ.country_id '. 'INNER JOIN `'.$this->opencDatabase.'`.`oc_zone` AS ocz ON oca.zone_id = ocz.zone_id '. 'LEFT JOIN `'.$this->hikaDatabaseName.'`.`#__hikashop_zone` AS hkzcou ON occ.iso_code_3 = hkzcou.zone_code_3 AND hkzcou.zone_type=\'country\' '. 'INNER JOIN `'.$this->hikaDatabaseName.'`.`#__hikashop_zone_link` AS hkzl ON hkzcou.zone_namekey = hkzl.zone_parent_namekey '. 'INNER JOIN `'.$this->hikaDatabaseName.'`.`#__hikashop_zone` AS hkzsta ON ocz.code = hkzsta.zone_code_3 AND hkzsta.zone_type=\'state\' AND hkzsta.zone_namekey = hkzl.zone_child_namekey '. 'WHERE occu.customer_id > '.(int)$this->options->last_openc_user.' ORDER BY oca.customer_id ASC'; $this->db->setQuery($sql0); $this->db->query(); $total = $this->db->getAffectedRows(); echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Imported users to Hikashop : ' . $total . '</p>'; $this->db->setQuery($sql1); $this->db->query(); $total = $this->db->getAffectedRows(); echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Imported addresses : ' . $total . '</p>'; $ret = true; return $ret; } function importUsersToJoomla($datas,&$i,$customer) { $cpt = 0; foreach($datas as $data) { if ($customer) $data->username = $data->email; $this->db->setQuery("SELECT * FROM `#__users` WHERE username = ".$this->db->quote($data->username).";"); $this->db->query(); $result = $this->db->loadObjectList(); if (!empty($result)) { echo '<p><span'.$this->bullstyle.'>►</span> The user <strong>'.$data->username.'</strong> won\'t be imported because an user with the same name already exists on Joomla.</p>'; } else { $sqlb = 'INSERT IGNORE INTO `#__users` (id, name, username, email, password, block, sendEmail, registerDate, params) VALUES '; $sqlc = 'INSERT IGNORE INTO `#__user_usergroup_map` (user_id, group_id) VALUES '; if ($customer) { $sqld = 'INSERT IGNORE INTO `#__hikashop_openc_customer` (openc_customer_id, hk_customer_cms_id) VALUES '; $block = !$data->approved; } else { $sqld = 'INSERT IGNORE INTO `#__hikashop_openc_user` (openc_user_id, hk_user_cms_id) VALUES '; $block = 0; } $d = array( $i, $this->db->quote($data->lastname), $this->db->quote($data->username), $this->db->quote($data->email), "CONCAT(".$this->db->quote(@$data->password).",':',".$this->db->quote(@$data->salt).")", $this->db->quote($block), '0', $this->db->quote($data->date_added), "'{}'", ); $sqlb .= '('.implode(',',$d).');'; if (isset($data->password)) //Don't insert guest { $this->db->setQuery($sqlb); $this->db->query(); } if (!$customer) $data->user_group_id == 1 ? $group = 8 : $group = 2; else $group = 2; $sqlc .= '('.$i.','.$group.')'; if (isset($data->password)) //Don't insert guest { $this->db->setQuery($sqlc); $this->db->query(); } if ($customer) $sqld .= '('.$data->customer_id.','.$i.')'; else $sqld .= '('.$data->user_id.','.$i.')'; $this->db->setQuery($sqld); $this->db->query(); $i++; $cpt++; } } return $cpt; } function importOrders() { echo '<p '.$this->titlefont.'><span'.$this->titlestyle.'>Step 10 :</span> Import Orders</p>'; $ret = false; $offset = $this->options->current; $count = 100; $total = 0; $vat_cols = "''"; $data = array( 'order_number' => 'oco.order_id', 'order_openc_id' => 'oco.order_id', 'order_user_id' => 'hkusr.user_id', 'order_status' => 'hkc.category_name', 'order_created' => 'oco.date_added', 'order_ip' => 'oco.ip', 'order_currency_id' => 'hkcur.currency_id', 'order_shipping_price' => "''", //? 'order_shipping_method' => 'oco.shipping_method', 'order_shipping_id' => '1', 'order_payment_id' => 0, 'order_payment_method' => 'oco.payment_method', 'order_full_price' => 'ocot.value', 'order_modified' => 'oco.date_modified', 'order_partner_id' => 0, 'order_partner_price' => 0, 'order_partner_paid' => 0, 'order_type' => "'sale'", 'order_partner_currency_id' => 0, 'order_shipping_tax' => "''", //? 'order_discount_tax' => 0 ); $sql1 = 'INSERT IGNORE INTO `'.$this->hikaDatabaseName.'`.`#__hikashop_order` (`'.implode('`,`',array_keys($data)).'`) '. 'SELECT '.implode(',',$data).' FROM `'.$this->opencDatabase.'`.`oc_order` AS oco '. 'INNER JOIN `'.$this->opencDatabase.'`.`oc_order_product` ocop ON ocop.order_id = oco.order_id '. 'INNER JOIN `'.$this->hikaDatabaseName.'`.`#__hikashop_category` AS hkc ON oco.order_status_id = hkc.category_keywords AND hkc.category_type = \'status\' '. 'INNER JOIN `'.$this->hikaDatabaseName.'`.`#__hikashop_currency` AS hkcur ON CONVERT(oco.currency_code USING utf8) = CONVERT(hkcur.currency_code USING utf8) '. 'INNER JOIN `'.$this->opencDatabase.'`.`oc_order_total` ocot ON oco.order_id = ocot.order_id AND code=\'total\' '. 'INNER JOIN `'.$this->hikaDatabaseName.'`.`#__hikashop_openc_customer` hkoccu ON oco.customer_id = hkoccu.openc_customer_id '. 'INNER JOIN `'.$this->hikaDatabaseName.'`.`#__hikashop_user` AS hkusr ON hkoccu.hk_customer_cms_id = hkusr.user_cms_id '. 'WHERE oco.order_id > ' . (int)$this->options->last_openc_order . ' '. 'GROUP BY oco.order_id '. 'ORDER BY oco.order_id ASC;'; $sql1_1 = 'UPDATE `'.$this->hikaDatabaseName.'`.`#__hikashop_order` AS hko '. 'INNER JOIN `'.$this->opencDatabase.'`.`oc_voucher` AS ocv ON hko.order_openc_id = ocv.order_id '. 'INNER JOIN `'.$this->hikaDatabaseName.'`.`#__hikashop_discount` AS hkd ON hkd.discount_code = ocv.code '. 'SET hko.order_discount_code = hkd.discount_code AND hko.order_discount_price = hkd.discount_flat_amount'; $data = array( 'address_user_id' => 'oco.customer_id', 'address_firstname' => 'oco.payment_firstname', 'address_lastname' => 'oco.payment_lastname', 'address_company' => 'oco.payment_company', 'address_street' => 'CONCAT(oco.payment_address_1,\' \',oco.payment_address_2)', 'address_post_code' => 'oco.payment_postcode', 'address_city' => 'oco.payment_city ', 'address_telephone' => 'oco.telephone', 'address_fax' => 'oco.fax', 'address_state' => 'hkzsta.zone_namekey', 'address_country' => 'hkzcou.zone_namekey', 'address_published' => '7', 'address_vat' => $vat_cols, 'address_openc_order_info_id' => 'oco.order_id' //8 ); $sql2_1 = 'INSERT IGNORE INTO `'.$this->hikaDatabaseName.'`.`#__hikashop_address` (`'.implode('`,`',array_keys($data)).'`) '. 'SELECT '.implode(',',$data).' FROM `'.$this->opencDatabase.'`.`oc_order` AS oco '. 'INNER JOIN `'.$this->opencDatabase.'`.`oc_country` AS occ ON oco.payment_country_id = occ.country_id '. 'INNER JOIN `'.$this->opencDatabase.'`.`oc_zone` AS ocz ON oco.payment_zone_id = ocz.zone_id '. 'LEFT JOIN `'.$this->hikaDatabaseName.'`.`#__hikashop_zone` AS hkzcou ON occ.iso_code_3 = hkzcou.zone_code_3 AND hkzcou.zone_type=\'country\' '. 'INNER JOIN `'.$this->hikaDatabaseName.'`.`#__hikashop_zone_link` AS hkzl ON hkzcou.zone_namekey = hkzl.zone_parent_namekey '. 'INNER JOIN `'.$this->hikaDatabaseName.'`.`#__hikashop_zone` AS hkzsta ON ocz.code = hkzsta.zone_code_3 AND hkzsta.zone_type=\'state\' AND hkzsta.zone_namekey = hkzl.zone_child_namekey '. 'WHERE oco.order_id > ' . (int)$this->options->last_openc_order; $sql2_2 = 'UPDATE `#__hikashop_address` AS a '. 'JOIN `#__hikashop_zone` AS hkz ON (a.address_country = hkz.zone_code_3 AND hkz.zone_type = "country") '. 'SET address_country = hkz.zone_namekey, address_published = 6 WHERE address_published >= 7;'; $sql2_3 = 'UPDATE `#__hikashop_address` AS a '. 'JOIN `#__hikashop_zone_link` AS zl ON (a.address_country = zl.zone_parent_namekey) '. 'JOIN `#__hikashop_zone` AS hks ON (hks.zone_namekey = zl.zone_child_namekey AND hks.zone_type = "state" AND hks.zone_code_3 = a.address_state) '. 'SET address_state = hks.zone_namekey, address_published = 5 WHERE address_published = 6;'; $sql2_4 = 'UPDATE `#__hikashop_address` AS a '. 'SET address_published = 0 WHERE address_published > 4;'; $sql3 = 'UPDATE `#__hikashop_order` AS o '. 'INNER JOIN `#__hikashop_address` AS a ON a.address_openc_order_info_id = o.order_openc_id '. 'SET o.order_billing_address_id = a.address_id, o.order_shipping_address_id = a.address_id '. "WHERE o.order_billing_address_id = 0 AND address_published >= 7 ;"; $sql4 = 'UPDATE `#__hikashop_order` AS o '. 'INNER JOIN `#__hikashop_address` AS a ON a.address_openc_order_info_id = o.order_openc_id '. 'SET o.order_shipping_address_id = a.address_id '. "WHERE o.order_shipping_address_id = 0 AND address_published >= 8 ;"; $sql5 = 'UPDATE `'.$this->hikaDatabaseName.'`.`#__hikashop_order` AS hko '. 'JOIN `'.$this->opencDatabase.'`.`oc_order` AS oco ON hko.order_openc_id = oco.order_id '. "SET hko.order_payment_method = CONCAT('openc import: ', oco.payment_method) ". 'WHERE hko.order_openc_id > ' . (int)$this->options->last_openc_order; $this->db->setQuery($sql1); $this->db->query(); $total = $this->db->getAffectedRows(); echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Imported orders: ' . $total . '</p>'; $this->db->setQuery($sql1_1); $this->db->query(); $total = $this->db->getAffectedRows(); echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Updating discount orders: ' . $total . '</p>'; $this->db->setQuery($sql2_1); $this->db->query(); $total = $this->db->getAffectedRows(); echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Imported orders addresses: ' . $total . '</p>'; $this->db->setQuery($sql3); $this->db->query(); $total = $this->db->getAffectedRows(); echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Updating billing addresses: ' . $total . '</p>'; $this->db->setQuery($sql4); $this->db->query(); $total = $this->db->getAffectedRows(); echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Updating shipping addresses: ' . $total . '</p>'; $this->db->setQuery($sql5); $this->db->query(); $total = $this->db->getAffectedRows(); echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Updating order payments: ' . $total . '</p>'; $this->db->setQuery($sql2_2); $this->db->query(); $total = $this->db->getAffectedRows(); echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Updating orders: ' . $total; $this->db->setQuery($sql2_3); $this->db->query(); $total = $this->db->getAffectedRows(); echo '/' . $total; $this->db->setQuery($sql2_4); $this->db->query(); $total = $this->db->getAffectedRows(); echo '/' . $total . '</p>'; $ret = true; return $ret; } function importOrderItems() { echo '<p '.$this->titlefont.'><span'.$this->titlestyle.'>Step 11 :</span> Import Order Items</p>'; $ret = false; $offset = $this->options->current; $count = 100; $data = array( 'order_id' => 'hko.order_id', 'product_id' => 'hkp.hk_id', 'order_product_quantity' => 'ocop.quantity', 'order_product_name' => 'ocop.name', 'order_product_code' => 'ocp.hika_sku', 'order_product_price' => 'ocop.price', 'order_product_tax' => 'ocop.tax', 'order_product_options' => "''" ); $sql = 'INSERT IGNORE INTO `'.$this->hikaDatabaseName.'`.`#__hikashop_order_product` (`'.implode('`,`',array_keys($data)).'`) '. 'SELECT '.implode(',',$data).' FROM `'.$this->opencDatabase.'`.`oc_order_product` AS ocop '. 'INNER JOIN `'.$this->opencDatabase.'`.`oc_product` ocp ON ocop.product_id=ocp.product_id '. 'INNER JOIN `'.$this->hikaDatabaseName.'`.`#__hikashop_order` AS hko ON ocop.order_id = hko.order_openc_id '. 'INNER JOIN `'.$this->hikaDatabaseName.'`.`#__hikashop_openc_prod` AS hkp ON hkp.openc_id = ocop.product_id '. 'WHERE ocop.order_id > ' . (int)$this->options->last_openc_order . ';'; $this->db->setQuery($sql); $this->db->query(); $total = $this->db->getAffectedRows(); echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Orders Items : '. $total .'</p>'; $ret = true; return $ret; } function importDownloads() { echo '<p '.$this->titlefont.'><span'.$this->titlestyle.'>Step 12 :</span> Import Downloads</p>'; $ret = false; jimport('joomla.filesystem.file'); $categoryClass = hikashop_get('class.category'); $count = 100; $offset = $this->options->current; if( $offset == 0 ) $offset = $this->options->last_openc_pfile; $sql = "SELECT `config_value` FROM `#__hikashop_config` WHERE config_namekey = 'download_number_limit';"; $this->db->setQuery($sql); $data = $this->db->loadObjectList(); $dl_limit = $data[0]->config_value; $sql = 'SELECT ocd.download_id, ocd.filename FROM `'.$this->opencDatabase.'`.`oc_download` AS ocd WHERE ocd.download_id > '.$offset.';'; //Why no Mask FFS $this->db->setQuery($sql); $data = $this->db->loadObjectList(); $max = 0; if (!empty($data) && !empty($this->opencRootPath)) { $this->copyDownloadDir = str_replace('\\','/',rtrim(JPath::clean(html_entity_decode(DIR_DOWNLOAD)),DS.' ').DS); echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Copying downloads files... </p>'; foreach($data as $c) { $file_name = end(explode('/',str_replace('\\','/',$c->filename))); if( strpos($file_name,'/') !== false ) { $file_name = substr($file_name, strrpos($file_name,'/')); } $dstFolder = $this->options->uploadfolder; //secure ? $this->copyFile($this->copyDownloadDir, $c->filename, $dstFolder.$file_name); $max = $c->download_id; } if( $max > 0 ) { echo '<p>Copying files...<br/>(Last processed file id: ' . $max . '</p>'; $this->options->current = $max; $this->refreshPage = true; return $ret; } } $data = array( 'file_name' => 'ocdd.name', 'file_description' => "''", 'file_path' => "SUBSTRING_INDEX(ocd.filename ,'/',-1)", //Why no filename ? 'file_type' => "'file'", 'file_ref_id' => 'hkocp.hk_id' ); $sql = 'INSERT IGNORE INTO `'.$this->hikaDatabaseName.'`.`#__hikashop_file` (`'.implode('`,`',array_keys($data)).'`) '. 'SELECT '.implode(',',$data).' FROM `'.$this->opencDatabase.'`.`oc_download` AS ocd '. 'INNER JOIN `'.$this->opencDatabase.'`.`oc_download_description` ocdd ON ocd.download_id = ocdd.download_id '. 'LEFT JOIN `'.$this->opencDatabase.'`.`oc_product_to_download` ocpd ON ocd.download_id = ocpd.download_id '. 'LEFT JOIN `'.$this->hikaDatabaseName.'`.`#__hikashop_openc_prod` AS hkocp ON ocpd.product_id = hkocp.openc_id '. 'WHERE ocd.download_id > '.(int)$this->options->last_openc_pfile; $this->db->setQuery($sql); $this->db->query(); $total = $this->db->getAffectedRows(); echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Downloable files imported : ' . $total . '</p>'; $data = array( 'file_id' => 'hkf.file_id', 'order_id' => 'hko.order_id', 'download_number' => '(' . $dl_limit . '- ocd.remaining)' //$dl_limit ? ); $sql = 'INSERT IGNORE INTO `'.$this->hikaDatabaseName.'`.`#__hikashop_download` (`'.implode('`,`',array_keys($data)).'`) '. 'SELECT '.implode(',',$data).' FROM `'.$this->opencDatabase.'`.`oc_download` AS ocd '. 'INNER JOIN `'.$this->opencDatabase.'`.`oc_download_description` ocdd ON ocd.download_id = ocdd.download_id '. 'INNER JOIN `'.$this->hikaDatabaseName.'`.`#__hikashop_file` AS hkf ON ( CONVERT(hkf.file_name USING utf8) = CONVERT(ocdd.name USING utf8) )'. 'INNER JOIN `'.$this->opencDatabase.'`.`oc_product_to_download` AS ocpd ON ocd.download_id = ocpd.download_id '. 'INNER JOIN `'.$this->opencDatabase.'`.`oc_order_product` AS ocop ON ocpd.product_id = ocop.product_id '. 'INNER JOIN `'.$this->hikaDatabaseName.'`.`#__hikashop_order` AS hko ON hko.order_openc_id = ocop.order_id '. 'WHERE ocd.download_id > '.(int)$this->options->last_openc_pfile; $this->db->setQuery($sql); $this->db->query(); $total = $this->db->getAffectedRows(); echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Downloable order files imported : ' . $total . '</p>'; $ret = true; return $ret; } function importDiscount() { echo '<p '.$this->titlefont.'><span'.$this->titlestyle.'>Step 9 :</span> Import Discount</p>'; $ret = false; $sql = "SELECT `config_value` FROM `#__hikashop_config` WHERE config_namekey = 'main_currency';"; $this->db->setQuery($sql); $data = $this->db->loadObjectList(); $main_currency = $data[0]->config_value; $data = array( 'discount_type' => "'coupon'", 'discount_start' => 'date_start', 'discount_end' => 'date_end', 'discount_quota' => 'uses_total', 'discount_quota_per_user' => 'uses_customer', 'discount_published' => 'status', 'discount_code' => 'code', 'discount_currency_id' => $main_currency, 'discount_flat_amount' => "case when type = 'F' then discount else 0 end", 'discount_percent_amount' => "case when type = 'P' then discount else 0 end", 'discount_quota' => '0' ); $sql = 'INSERT IGNORE INTO `'.$this->hikaDatabaseName.'`.`#__hikashop_discount` (`'.implode('`,`',array_keys($data)).'`) '. 'SELECT '.implode(',',$data).' FROM `'.$this->opencDatabase.'`.`oc_coupon` WHERE coupon_id > ' . $this->options->last_openc_coupon; $this->db->setQuery($sql); $this->db->query(); $total = $this->db->getAffectedRows(); echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Discount codes/coupons imported : ' . $total . '</p>'; $data = array( 'discount_type' => "'coupon'", 'discount_code' => 'code', 'discount_currency_id' => $main_currency, 'discount_flat_amount' => 'amount', 'discount_percent_amount' => '0', 'discount_published' => 'status', ); $sql = 'INSERT IGNORE INTO `'.$this->hikaDatabaseName.'`.`#__hikashop_discount` (`'.implode('`,`',array_keys($data)).'`) '. 'SELECT '.implode(',',$data).' FROM `'.$this->opencDatabase.'`.`oc_voucher` WHERE voucher_id > ' . $this->options->last_openc_voucher; $this->db->setQuery($sql); $this->db->query(); $total = $this->db->getAffectedRows(); echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Vouchers imported : ' . $total . '</p>'; $ret = true; return $ret; } function importCurrencies() { if( $this->db == null ) return false; $this->db->setQuery('UPDATE `'.$this->hikaDatabaseName.'`.`#__hikashop_currency` AS hkcur '. 'INNER JOIN `'.$this->opencDatabase.'`.`oc_currency` occ ON CONVERT(occ.code USING utf8) = CONVERT( hkcur.currency_code USING utf8) '. 'SET hkcur.currency_rate = occ.value' ); $ret = $this->db->query(); $cpt = $this->db->getAffectedRows(); echo '<p '.$this->pmarginstyle.'><span'.$this->bullstyle.'></span> Currencies values imported : ' . $cpt .'</p>'; return true; } function finishImport() { $this->db->setQuery("SELECT max(category_id) as 'max' FROM `#__hikashop_category`;"); $data = $this->db->loadObjectList(); $this->options->max_hk_cat = (int)($data[0]->max); $this->db->setQuery("SELECT max(id) as 'max' FROM `#__users`;"); $data = $this->db->loadObjectList(); $this->options->max_joomla_user = (int)($data[0]->max); $this->db->setQuery("SELECT max(product_id) as 'max' FROM `#__hikashop_product`;"); $data = $this->db->loadObjectList(); $this->options->max_hk_prod = (int)($data[0]->max); $this->db->setQuery("SELECT max(openc_id) as 'max' FROM `#__hikashop_openc_cat`;"); $data = $this->db->loadObjectList(); $this->options->last_openc_cat = (int)($data[0]->max); $this->db->setQuery("SELECT max(openc_id) as 'max' FROM `#__hikashop_openc_prod`;"); $data = $this->db->loadObjectList(); $this->options->last_openc_prod = (int)($data[0]->max); $this->db->setQuery("SELECT max(customer_id) as 'max' FROM `".$this->opencDatabase."`.`oc_customer`;"); $data = $this->db->loadObjectList(); $this->options->last_openc_user = (int)($data[0]->max); $this->db->setQuery("SELECT max(order_openc_id) as 'max' FROM `#__hikashop_order`;"); $data = $this->db->loadObjectList(); $this->options->last_openc_order = (int)($data[0]->max); $this->db->setQuery("SELECT max(ocpi.product_image_id) as 'max' FROM `".$this->opencDatabase."`.`oc_product_image` ocpi INNER JOIN `".$this->opencDatabase."`.`oc_product` ocp ON ocpi.product_id = ocp.product_id"); $data = $this->db->loadObject(); $this->options->last_openc_pfile = (int)($data->max); $this->db->setQuery("SELECT max(coupon_id) as 'max' FROM `".$this->opencDatabase."`.`oc_coupon`;"); $data = $this->db->loadObject(); $this->options->last_openc_coupon = (int)($data->max); $this->db->setQuery("SELECT max(voucher_id) as 'max' FROM `".$this->opencDatabase."`.`oc_voucher`;"); $data = $this->db->loadObject(); $this->options->last_openc_voucher = (int)($data->max); $this->db->setQuery("SELECT max(tax_rate_id) as 'max' FROM `".$this->opencDatabase."`.`oc_tax_rate`;"); $data = $this->db->loadObject(); $this->options->last_openc_taxrate = (int)($data->max); $this->db->setQuery("SELECT max(tax_class_id) as 'max' FROM `".$this->opencDatabase."`.`oc_tax_class`;"); $data = $this->db->loadObject(); $this->options->last_openc_taxclass = (int)($data->max); $this->db->setQuery("SELECT max(manufacturer_id) as 'max' FROM `".$this->opencDatabase."`.`oc_manufacturer`;"); $data = $this->db->loadObjectList(); $this->options->last_openc_manufacturer = (int)($data[0]->max); $this->options->state = (MAX_IMPORT_ID+1); $query = 'REPLACE INTO `#__hikashop_config` (`config_namekey`,`config_value`,`config_default`) VALUES '. "('openc_import_state',".$this->options->state.",".$this->options->state.")". ",('openc_import_max_hk_cat',".$this->options->max_hk_cat.",".$this->options->max_hk_cat.")". ",('openc_import_max_joomla_user',".$this->options->max_joomla_user.",".$this->options->max_joomla_user.")". ",('openc_import_max_hk_prod',".$this->options->max_hk_prod.",".$this->options->max_hk_prod.")". ",('openc_import_last_openc_cat',".$this->options->last_openc_cat.",".$this->options->last_openc_cat.")". ",('openc_import_last_openc_prod',".$this->options->last_openc_prod.",".$this->options->last_openc_prod.")". ",('openc_import_last_openc_user',".$this->options->last_openc_user.",".$this->options->last_openc_user.")". ",('openc_import_last_openc_order',".$this->options->last_openc_order.",".$this->options->last_openc_order.")". ",('openc_import_last_openc_pfile',".$this->options->last_openc_pfile.",".$this->options->last_openc_pfile.")". ",('openc_import_last_openc_coupon',".$this->options->last_openc_coupon.",".$this->options->last_openc_coupon.")". ",('openc_import_last_openc_voucher',".$this->options->last_openc_voucher.",".$this->options->last_openc_voucher.")". ",('openc_import_last_openc_taxrate',".$this->options->last_openc_taxrate.",".$this->options->last_openc_taxrate.")". ",('openc_import_last_openc_taxclass',".$this->options->last_openc_taxclass.",".$this->options->last_openc_taxclass.")". ",('openc_import_last_openc_manufacturer',".$this->options->last_openc_manufacturer.",".$this->options->last_openc_manufacturer.")". ';'; $this->db->setQuery($query); $this->db->query(); echo '<p'.$this->titlefont.'>Import finished !</p>'; $class = hikashop_get('class.plugins'); } }

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