Импорт/экспорт - страница 19 - Импорт-экспорт данных

<?php
defined( '_JEXEC' ) or die( 'Restricted access' );
jimport('joomla.filesystem.folder');

class IeSimpleImportUtf8 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();


        $_products = &JModel::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;

                    $product =& JTable::getInstance('product', 'jshop');
                    $product_id = $row[0];
                    if ($product_id!=""){
                        $product->set("product_id", $product_id);
                    }
					else
					{
					//получаем product_id поиском по ean
					$query = "SELECT product_id FROM `#__jshopping_products` WHERE product_ean ='".$row[1]."' LIMIT 1";
					$db->setQuery($query);
					$product->set("product_id", $db->loadResult());
					}

                    $product->set("product_ean", $row[1]);
                    $product->set("product_quantity", $row[2]);
                    $product->set("product_price", $row[3]);
                    
                    $product->store();
                    if ($product_id==null){
                        $product_id = $product->get("product_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);
        }
    }

}

?>

foreach($data as $k=>$row){
	if (count($row)<2 || $k==0) continue;
	$query = "SELECT product_id FROM `#__jshopping_products` WHERE product_ean ='".$row[0]."' LIMIT 1";
	$db->setQuery($query);
	if ($db->loadResult()){
		$product = JTable::getInstance('product', 'jshop');
		$product->load($db->loadResult());
		$product->set("product_ean", $row[0]);
		$product->set("product_quantity", $row[1]);
		$product->set("product_price", $row[2]);
		$product->store();
		unset($product);
	}
}

<?php
defined( '_JEXEC' ) or die( 'Restricted access' );
jimport('joomla.filesystem.folder');

class IeSimpleImportUtf8 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();


        $_products = &JModel::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;
					$query = "SELECT product_id FROM `#__jshopping_products` WHERE product_ean ='".$row[0]."' LIMIT 1";
					$db->setQuery($query);
					if ($db->loadResult()){
						$product = JTable::getInstance('product', 'jshop');
						$product->load($db->loadResult());
						$product->set("product_ean", $row[0]);
						$product->set("product_quantity", $row[1]);
						$product->set("product_price", $row[2]);
						$product->store();
						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);
        }
    }

}

?>

$product->set($lang->get("meta_title"), ($row[ХХ]));