";
        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');
 }
 
}