";
         * print_r($data);
         * print"

";
         * print_r($products);
         * print"

";
            print_r ($row);
            print "

";
            print_r ($row);
            print "

";
        // print_r($rubrics);
        // print"

";print_r($row);print"

";
        
        $this->clearTmpProduct ();
        
        for ($i = 0; $row_line = File_FGetCSV::fgetcsv ($f, 15000, ";"); $i ++)
        {
            // foreach($arr_line as $line){
            // $row_line = fgetcsv(";",$line);
            $rubric_id = $this->import_saveRubric ($row_line[0], 0);
            $rubric_parent_id = $this->import_saveRubric ($row_line[1], $rubric_id);
            $brend_id = $this->import_saveBrend ($row_line[2], $rubric_parent_id);
            $pruduct_name = trim ($row_line[3]);
            $pruduct_about = trim ($row_line[4]);
            $pruduct_text = trim ($row_line[5]);
            $sex = explode (',', $row_line[8]);
            $pruduct_sex = array ();
            
            foreach ($sex as $s)
            {
                switch (trim ($s))
                {
                    case 'ìóæñêîé' :
                        $pruduct_sex[] = 1;
                        break;
                    case 'æåíñêèé' :
                        $pruduct_sex[] = 2;
                        break;
                    case 'äåòñêèé' :
                        $pruduct_sex[] = 3;
                        break;
                    case 'óíèñåêñ' :
                        $pruduct_sex[] = 4;
                        break;
                    default :
                        $pruduct_sex[] = array ();
                        break;
                }
            }
            
            $pruduct_date = trim ($row_line[9]);
            $pruduct_cine = trim ($row_line[10]);
            $pruduct_cine_last = trim ($row_line[11]);
            
            if ($pruduct_cine < 1)
            {
                $pruduct_cine = $pruduct_cine_last;
                $pruduct_cine_last = 0;
            }
            
            $pruduct_akcii_id = trim ($row_line[12]);
            $pruduct_strnumber = trim ($row_line[13]);
            $pruduct_active = trim ($row_line[14]);
            $pruduct_params = trim ($row_line[15]);
            $pruduct_pic_tmp = trim ($row_line[17]);
            $pruduct_gallery_pics = trim ($row_line[18]);
            $pruduct_video = trim ($row_line[16]);
            $pruduct_update_id = $this->getProductID_R ($pruduct_name, $rubric_parent_id);
            
            if ($pruduct_update_id > 0)
            {
                $row_product = $this->db->getRow ('
                select update_text, about, text
                from catalogs_products
                where id=?', array (
                    $pruduct_update_id 
                ), DB_FETCHMODE_ASSOC);
                
                // íå îáíîâëÿòü ïðè èìïîðòå?
                // 0 - îáíîâëÿòü
                // 1 - íå îáíîâëÿòü
                if ($row_product['update_text'] == 1)
                {
                    // about - ukr
                    $pruduct_about = $row_product['about'];
                    
                    // text - ru
                    $pruduct_text = $row_product['text'];
                }
            }
            
            $upload_pruduct = (strlen ($pruduct_pic_tmp) > 0 && is_file ("./uploaded/pic/catalogs/products/big/$pruduct_pic_tmp")) ? array (
                'pic' => array (
                    'tmp_name' => "./uploaded/pic/catalogs/products/big/$pruduct_pic_tmp",
                    'name' => $pruduct_pic_tmp,
                    'big' => true 
                ) 
            ) : null;
            
            $product_id = $this->saveProduct (array (
                'rubric_id' => $rubric_parent_id,
                'rubric_parent_id' => $rubric_parent_id,
                'brend_id' => $brend_id,
                'name' => $pruduct_name,
                'about' => $pruduct_about,
                'update_text' => isset ($row_product['update_text']) ? $row_product['update_text'] : 0,
                'text' => $pruduct_text,
                'video_code' => $pruduct_video,
                'sex' => $pruduct_sex,
                'date' => $pruduct_date,
                'cine' => $pruduct_cine,
                'cine_last' => $pruduct_cine_last,
                'akcii_id' => $pruduct_akcii_id,
                'strnumber' => $pruduct_strnumber,
                'active' => $pruduct_active,
                'meta_title' => $pruduct_name,
                'meta_description' => $pruduct_name,
                'meta_keywords' => $pruduct_name,
                'meta_about' => $pruduct_name,
                'filter' => $this->import_saveFilters ($rubric_parent_id, $row_line[6]),
                'filter2' => $this->import_saveFilters2 ($rubric_parent_id, $row_line[7]),
                'years' => $this->import_saveYear ($rubric_parent_id, $pruduct_date),
                'akcii' => array (),
                'update_id' => $pruduct_update_id 
            ), $upload_pruduct);
            
            // print $pruduct_update_id;exit;
            $this->saveProductParams ($product_id, $pruduct_params);
            $this->saveGalleryPics ($product_id, $pruduct_gallery_pics);
            // íå óäàëÿåì !
            // $this->deleteProductModifications ($product_id, true);
            $m_i = 0;
            
            for ($i = 19; $i < count ($row_line); $i ++)
            {
                $arr_mod = trim ($row_line[$i]);
                
                if (strlen ($arr_mod) > 0)
                {
                    $row_mod = explode ("=", $arr_mod);
                    
                    $upload_mod = (strlen ($row_mod[3]) > 0 && is_file ("./uploaded/pic/catalogs/modifications/big/" . $row_mod[3])) ? array (
                        'pic' => array (
                            'tmp_name' => "./uploaded/pic/catalogs/modifications/big/" . $row_mod[3],
                            'name' => $row_mod[3],
                            'big' => true 
                        ) 
                    ) : null;
                    
                    $size_mod = explode ("*", $row_mod[1]);
                    $rost = (isset ($size_mod[1])) ? $size_mod[1] : '';
                    
                    // íàõîäèì modifications_id
                    $modifications_id = $this->getModification ($product_id, $row_mod[0]);
                    
                    // ñîõðàíÿåì
                    $this->SaveModification (array (
                        'product_id' => $product_id,
                        'code' => $row_mod[0],
                        'size' => $size_mod[0],
                        'rost' => $rost,
                        'color' => $row_mod[2],
                        'active' => $row_mod[4],
                        'update_id' => (int) $modifications_id 
                    ), $upload_mod);
                    
                    if ($row_mod[4] > 0)
                    {
                        $m_i ++;
                    }
                }
            }
            
            $this->updateProduct_countModification ($product_id, $m_i);
            
            // $this->import_saveFilters($product_id,$rubric_parent_id,$row_line[6]);
            // $strnumber = $this->getProductID($row_line[3]); $this->save_keysProductsFilters($id,$data);
            // print_r($row_line);
            
            $this->saveTmpProduct ($row_line, $product_id);
            if (($i % 30) == 0)
            {
                sleep (1);
            }
        }
        // print"

";
        $i = 0;
        $mktime = mktime ();
        foreach ($arr_line as $line)
        {
            $row_line = explode (";", $line);
            $this->import_updateProductCine ($this->getModificationProduct_id ($row_line[0]), $row_line, $line, $mktime);
            
            if (($i % 30) == 0)
            {
                sleep (1);
            }
            
            $i ++;
        }
    }
    
    function loadCSV_cine ($upload)
    {
        if ($upload['file']['name'] != "file_1.csv")
        {
            print "Îøèáêà! Òîëüêî file_1.csv";
            exit ();
        }
        
        $file = $_SERVER['DOCUMENT_ROOT'] . "/cron/file_1.csv";
        
        // echo $file;
        // exit;
        
        move_uploaded_file ($upload['file']['tmp_name'], $file);
    }
    
    function is_loadCSV_cine ()
    {
        $is = is_file ($_SERVER['DOCUMENT_ROOT'] . '/cron/file_1.csv');
        $this->tpl->assign ('is', $is);
    }
    
    function CronImportCSV_cine ($upload)
    {
        $this->importCSV_cine ($upload);
    }
    
    function updateCountModificationProducts ()
    {
        $res = $this->db->getAll ("
       select id
       from catalogs_products
    ", array (), DB_FETCHMODE_ASSOC);
        
        $i = 0;
        
        foreach ($res as $row)
        {
            $count = $this->db->getOne ("
           select count(*)
           from catalogs_modifications
           where product_id=? and active>0", array (
                $row['id'] 
            ));
            
            $this->db->autoExecute ("catalogs_products", array (
                'count_modifications' => $count 
            ), DB_AUTOQUERY_UPDATE, "id='" . $row['id'] . "'");
            
            $i ++;
        }
    }
    
    function config_update ($id, $value)
    {
        $this->db->autoExecute ("catalogs_config", array (
            'value' => $value 
        ), DB_AUTOQUERY_UPDATE, "id='" . $id . "'");
    }
    
    function view_config_value ($id)
    {
        $r = $this->db->getOne ("select value from catalogs_config where id=?", $id);
        $this->tpl->assign ("config", $r);
        return $r;
    }
    
    function addViewProduct ($product_id)
    {
        $i = 0;
        foreach ($_SESSION['view_product'] as $id)
        {
            if ($product_id == $id)
                $i ++;
        }
        if ($i == 0)
            $_SESSION['view_product'][] = $product_id;
    }
    
    function viewUserProducts ($limit = "all")
    { // unset($_SESSION['view_product']);
        if (isset ($_SESSION['view_product']) && count ($_SESSION['view_product']) > 0)
        {
            $sql = "select catalogs_products.*,catalogs_brends.name as brend_name,r.translit as rubric_translit from catalogs_products 
  LEFT JOIN catalogs_brends ON catalogs_brends.id=catalogs_products.brend_id
  LEFT JOIN catalogs_rubrics r ON r.id=catalogs_products.rubric_id
  WHERE catalogs_products.id IN (" . implode (",", $_SESSION['view_product']) . ") ";
            if ($limit != "all")
                $sql .= "LIMIT " . $limit;
            $res = $this->db->getAll ($sql, array (), DB_FETCHMODE_ASSOC);
            $this->tpl->assign ("products_view", $res);
        }
    }
    
    function viewSimilarProducts ($product_id, $brend, $rubric_id, $mods)
    {
        IF ($brend == 'Dakine')
        {
            $rub_arr = array (
                14071,
                14069,
                14070,
                14072 
            );
            unset ($rub_arr[array_search ('rubric_id', $rub_arr)]);
            
            if (count ($mods) > 1)
            {
                $r = array ();
                foreach ($mods as $key => $mod)
                {
                    $r[$key]['color'] = $mod['color'];
                    $row = $this->db->getRow ("select * from catalogs_products where id=?", array (
                        $product_id 
                    ), DB_FETCHMODE_ASSOC);
                    $sql = "select catalogs_products.*,m.pic,catalogs_brends.name as brend_name,r.translit as rubric_translit from catalogs_products 
  LEFT JOIN catalogs_brends ON catalogs_brends.id=catalogs_products.brend_id
  LEFT JOIN catalogs_rubrics r ON r.id=catalogs_products.rubric_id
  LEFT JOIN catalogs_modifications m ON m.product_id=catalogs_products.id
  WHERE catalogs_products.rubric_id IN (" . implode (',', $rub_arr) . ") and catalogs_products.count_modifications>0 and catalogs_products.cinedb->getAll ($sql, array (
                        $row['cine'],
                        $brend,
                        $mod['color'] 
                    ), DB_FETCHMODE_ASSOC);
                    
                    $sql = "select catalogs_products.*,m.pic,catalogs_brends.name as brend_name,r.translit as rubric_translit from catalogs_products 
  LEFT JOIN catalogs_brends ON catalogs_brends.id=catalogs_products.brend_id
  LEFT JOIN catalogs_rubrics r ON r.id=catalogs_products.rubric_id
  LEFT JOIN catalogs_modifications m ON m.product_id=catalogs_products.id
  WHERE catalogs_products.rubric_id IN (" . implode (',', $rub_arr) . ") and catalogs_products.count_modifications>0 and catalogs_products.cine>? and catalogs_brends.name=? and m.color=? and m.active=1 Order by catalogs_products.cine DESC LIMIT 5";
                    $r[$key]["products_similar_next"] = $this->db->getAll ($sql, array (
                        $row['cine'],
                        $brend,
                        $mod['color'] 
                    ), DB_FETCHMODE_ASSOC);
                }
                // print_r($r);
                $this->tpl->assign ("products_similar", $r);
            }
            else
            {
                
                $row = $this->db->getRow ("select * from catalogs_products where id=?", array (
                    $product_id 
                ), DB_FETCHMODE_ASSOC);
                $sql = "select catalogs_products.*,catalogs_brends.name as brend_name,r.translit as rubric_translit from catalogs_products 
  LEFT JOIN catalogs_brends ON catalogs_brends.id=catalogs_products.brend_id
  LEFT JOIN catalogs_rubrics r ON r.id=catalogs_products.rubric_id
  WHERE catalogs_products.rubric_id IN (" . implode (',', $rub_arr) . ") and catalogs_products.count_modifications>0 and catalogs_products.cinedb->getAll ($sql, array (
                    $row['cine'],
                    $brend 
                ), DB_FETCHMODE_ASSOC);
                $this->tpl->assign ("products_similar_prev", $res);
                
                $sql = "select catalogs_products.*,catalogs_brends.name as brend_name,r.translit as rubric_translit from catalogs_products 
  LEFT JOIN catalogs_brends ON catalogs_brends.id=catalogs_products.brend_id
  LEFT JOIN catalogs_rubrics r ON r.id=catalogs_products.rubric_id
  WHERE catalogs_products.rubric_id IN (" . implode (',', $rub_arr) . ") and catalogs_products.count_modifications>0 and catalogs_products.cine>? and catalogs_brends.name=? Order by catalogs_products.cine DESC LIMIT 5";
                $res = $this->db->getAll ($sql, array (
                    $row['cine'],
                    $brend 
                ), DB_FETCHMODE_ASSOC);
                $this->tpl->assign ("products_similar_next", $res);
            }
        }
        else
        {
            $row = $this->db->getRow ("select * from catalogs_products where id=?", array (
                $product_id 
            ), DB_FETCHMODE_ASSOC);
            $sql = "select catalogs_products.*,catalogs_brends.name as brend_name,r.translit as rubric_translit from catalogs_products 
  LEFT JOIN catalogs_brends ON catalogs_brends.id=catalogs_products.brend_id
  LEFT JOIN catalogs_rubrics r ON r.id=catalogs_products.rubric_id
  WHERE catalogs_products.rubric_id=? and catalogs_products.count_modifications>0 and catalogs_products.cinedb->getAll ($sql, array (
                $row['rubric_id'],
                $row['cine'] 
            ), DB_FETCHMODE_ASSOC);
            $this->tpl->assign ("products_similar_prev", $res);
            
            $sql = "select catalogs_products.*,catalogs_brends.name as brend_name,r.translit as rubric_translit from catalogs_products 
  LEFT JOIN catalogs_brends ON catalogs_brends.id=catalogs_products.brend_id
  LEFT JOIN catalogs_rubrics r ON r.id=catalogs_products.rubric_id
  WHERE catalogs_products.rubric_id=? and catalogs_products.count_modifications>0 and catalogs_products.cine>? Order by catalogs_products.cine DESC LIMIT 5";
            $res = $this->db->getAll ($sql, array (
                $row['rubric_id'],
                $row['cine'] 
            ), DB_FETCHMODE_ASSOC);
            $this->tpl->assign ("products_similar_next", $res);
        }
    }
    
    function displayCatalogsCurs ()
    {
        $this->tpl->assign ("tpl", 'catalogs_curs.tpl');
    }
    
    function displayCatalogs ()
    {
        $this->tpl->assign ("tpl", 'catalogs.tpl');
    }
    
    function displayProducts ()
    {
        $this->tpl->assign ("tpl", 'catalogs_product-list.tpl');
    }
    
    function displayProductsTops ()
    {
        $this->tpl->assign ("tpl", 'catalogs_products_tops.tpl');
    }
    
    function displayProductsHits ()
    {
        $this->tpl->assign ("tpl", 'catalogs_products_hits.tpl');
    }
    
    function displayProductsHitsAll ()
    {
        $this->tpl->assign ("tpl", 'catalogs_products_hits_all.tpl');
    }
    
    function displayBasket ($count_products, $cine_products, $cine_products_discount, $discount)
    {
        $this->tpl->assign ("count_products", $count_products);
        $this->tpl->assign ("cine_products", $cine_products);
        $this->tpl->assign ("cine_products_discount", $cine_products_discount);
        $this->tpl->assign ("discount", $discount);
        $this->tpl->display ('basket.tpl');
    }
    
    function displayProduct ()
    {
        $this->tpl->assign ("tpl", 'catalogs_product.tpl');
    }
    
    function displayProductBasket ()
    {
        $this->tpl->assign ("tpl", 'catalogs_basket.tpl');
    }
    
    function displayBrends ()
    {
        $this->tpl->assign ("tpl", 'catalogs_brends.tpl');
    }
    
    function displayBrend ()
    {
        $this->tpl->assign ("tpl", 'catalogs_brend.tpl');
    }
    
    function displayCities ()
    {
        $this->tpl->assign ("tpl", 'catalogs_cities.tpl');
    }
    
    function displayProductBasketSend ()
    {
        $this->tpl->assign ("tpl", 'catalogs_basket_send.tpl');
    }
    
    function displayReg ()
    {
        $this->tpl->assign ("tpl", 'catalogs_reg.tpl');
    }
    
    function displayEditUser ()
    {
        $this->tpl->assign ("tpl", 'catalogs_user_edit.tpl');
    }
    
    function displayNoPsw ()
    {
        $this->tpl->assign ("tpl", 'catalogs_nopsw.tpl');
    }
    
    function displayOrders ()
    {
        $this->tpl->assign ("tpl", 'catalogs_orders.tpl');
    }
    
    function displayOrder ()
    {
        $this->tpl->assign ("tpl", 'catalogs_order.tpl');
    }
    
    function displayUsers ()
    {
        $this->tpl->assign ("tpl", 'catalogs_users.tpl');
    }
    
    function displayUser ()
    {
        $this->tpl->assign ("tpl", 'catalogs_user.tpl');
    }
    
    function displayFilters ()
    {
        $this->tpl->assign ("tpl", 'catalogs_filters.tpl');
    }
    
    function displayFilters2 ()
    {
        $this->tpl->assign ("tpl", 'catalogs_filters2.tpl');
    }
    
    function displayYears ()
    {
        $this->tpl->assign ("tpl", 'catalogs_years.tpl');
    }
    
    function displayWinProducts ()
    {
        $this->tpl->display ('catalogs_win_products.tpl');
    }
    
    function displayModifications ()
    {
        $this->tpl->assign ("tpl", 'catalogs_modifications.tpl');
    }
    
    function displayImport ()
    {
        $this->tpl->assign ("tpl", 'catalogs_import.tpl');
    }
    
    function displayImportCine ()
    {
        $this->tpl->assign ("tpl", 'catalogs_import_cine.tpl');
    }
    
    function displayAkcii ()
    {
        $this->tpl->assign ("tpl", 'catalogs_akcii.tpl');
    }
    
    function displayCompare ()
    {
        $this->tpl->assign ("tpl", 'catalogs_compare.tpl');
    }
    
    function displayTmpProducts ()
    {
        $this->tpl->assign ("tpl", 'catalogs_tmp_products.tpl');
    }
}