<?php
defined( '_JEXEC' ) or die( 'Restricted access' );
jimport('joomla.filesystem.folder');
class IeNRImportUtf8 extends IeController{
function view(){
$jshopConfig = &JSFactory::getConfig();
$ie_id = JRequest::getInt("ie_id");
$_importexport = &JTable::getInstance('ImportExport', 'jshop');
$_importexport->load($ie_id);
$name = $_importexport->get('name');
JToolBarHelper::title(_JSHOP_IMPORT. ' "'.$name.'"', 'generic.png' );
JToolBarHelper::custom("backtolistie", "back", 'browser.png', _JSHOP_BACK_TO.' "'._JSHOP_PANEL_IMPORT_EXPORT.'"', false );
JToolBarHelper::spacer();
JToolBarHelper::save("save", _JSHOP_IMPORT);
include(dirname(__FILE__)."/form.php");
}
function save(){
$mainframe =& JFactory::getApplication();
$jshopConfig = &JSFactory::getConfig();
require_once(JPATH_COMPONENT_SITE.'/lib/uploadfile.class.php');
require_once(JPATH_COMPONENT_SITE."/lib/csv.io.class.php");
$ie_id = JRequest::getInt("ie_id");
if (!$ie_id) $ie_id = $this->get('ie_id');
$lang = &JSFactory::getLang();
$db = &JFactory::getDBO();
$_importexport = &JTable::getInstance('ImportExport', 'jshop');
$_importexport->load($ie_id);
$alias = $_importexport->get('alias');
$_importexport->set('endstart', time());
$_importexport->store();
//get list tax
$query = "SELECT tax_id, tax_value FROM `#__jshopping_taxes`";
$db->setQuery($query);
$rows = $db->loadObjectList();
$listTax = array();
foreach($rows as $row){
$listTax[intval($row->tax_value)] = $row->tax_id;
}
//
//get list category
$query = "SELECT category_id as id, `".$lang->get("name")."` as name FROM `#__jshopping_categories`";
$db->setQuery($query);
$rows = $db->loadObjectList();
$listCat = array();
foreach($rows as $row){
$listCat[$row->name] = $row->id;
}
//
$_products = &JModelLegacy::getInstance('products', 'JshoppingModel');
$dir = $jshopConfig->importexport_path.$alias."/";
$upload = new UploadFile($_FILES['file']);
$upload->setAllowFile(array('csv'));
$upload->setDir($dir);
if ($upload->upload()){
$filename = $dir."/".$upload->getName();
@chmod($filename, 0777);
$csv = new csv();
$data = $csv->read($filename);
if (is_array($data)){
foreach($data as $k=>$row){
if (count($row)<2 || $k==0) continue;
$tax_value = intval($row[5]);
if (!isset($listTax[$tax_value])){
$tax = &JTable::getInstance('tax', 'jshop');
$tax->set('tax_name', $tax_value);
$tax->set('tax_value', $tax_value);
$tax->store();
$listTax[$tax_value] = $tax->get("tax_id");
}
$category_name = $row['6'];
if (!isset($listCat[$category_name]) && $category_name!=""){
$cat = &JTable::getInstance("category","jshop");
$query = "SELECT max(ordering) FROM `#__jshopping_categories`";
$db->setQuery($query);
$ordering = $db->loadResult() + 1;
$cat->set($lang->get("name"), $category_name);
$cat->set("category_ordertype", 1);
$cat->set("products_page", 12);
$cat->set("products_row", 1);
$cat->set("category_publish", 0);
$cat->set("ordering", $ordering);
$cat->store();
$listCat[$category_name] = $cat->get("category_id");
}
$product =& JTable::getInstance('product', 'jshop');
$product_id = $row[0];
if ($product_id!=""){
$product->set("product_id", $product_id);
}
$product->set("product_ean", $row[1]);
$product->set("product_quantity", $row[2]);
$product->set("product_date_added", $row[3]);
$product->set("product_date_added", date("Y-m-d H:i:s"));
$product->set("product_price", $row[4]);
$product->set("product_tax_id", $listTax[$tax_value]);
$product->set($lang->get("name"), ($row[7]));
$product->set($lang->get("short_description"), ($row[8]));
$product->set($lang->get("description"), ($row[9]));
$product->set("product_manufacturer_id", $row[11]);
$product->set($lang->get("meta_description"), ($row[12]));
$product->set($lang->get("meta_keyword"), ($row[13]));
$product->set("product_publish", $row[14]);
$product->set("product_template", $row[15]);
$product->set("delivery_times_id", $row[16]);
$product->store();
if ($product_id==null){
$product_id = $product->get("product_id");
}
$category_id = $row[10];
if ($category_id==""){
$category_id = $listCat[$category_name];
}
if ($category_name!="" && $category_id){
$_products->setCategoryToProduct($product_id, array($category_id));
}
unset($product);
}
}
}else{
JError::raiseWarning("", _JSHOP_ERROR_UPLOADING);
}
if (!JRequest::getInt("noredirect")){
$mainframe->redirect("index.php?option=com_jshopping&controller=importexport&task=view&ie_id=".$ie_id, _JSHOP_COMPLETED);
}
}
}
?>
04.02.2021, 09:32:19