<?php
/*
@author suxoza <suxoza@gmail.com>
*/
if(realpath(__FILE__) == realpath($_SERVER['SCRIPT_FILENAME']))die("__main__ ".__FILE__);

    
    //$_->pre($_POST);
    //$_->pre($_FILES);

    
    
    $_array = [];
    //$_->pre($_POST);
    $last_insert_id = '';
    if(in_array('new', $url))start_gallery($_,$select_menu,$last_insert_id);
    elseif(in_array('more', $url))save_gallery($_,$select_menu,$url);
    
  //start_gallery($_,$select_body,$select_menu);
   
    
  function start_gallery($_,$select_menu,&$last_insert_id){ 
    $insert = ['page_id','page_count','date'];
    $value  = [$select_menu['id'],$_->clier($_POST['page_count']),time()];
    for($i = 0; $i < count($_->language_config); $i++){
         $insert[] = "name_".$_->language_config[$i];
         $value[] = $_->clier($_POST['alboum_name_'.$_->language_config[$i]]);
    }
    if($_->insert("body",[$insert,$value]))$_id = $_->con->lastInsertId();  
    else die("error while insert!!!");  
    
    $last_insert_id = $_id;
    
    $iterator = 1;  
    foreach($_POST as $key => $value){
        if($_->startsWith($key,'file_')){
          if(isset($_POST['title_'.$_->language_config[0].'_'.$iterator])){  
            $file = '';
            if($value){
              if($_->startsWith($value,'http'))
                 copy_file($key,$value,$iterator,$_,$file);
              else if($_->startsWith($value,'data:'))
                 move_uploaded($key,$value,$iterator,$_,$file); 
            }
            
                $insert = ['page_id','logo','attributes','page_date','date_modify','date'];
                $value  = [$_id,$file,'',time(),time(),time()];
                for($i = 0; $i < count($_->language_config); $i++){
                     $insert[] = "name_".$_->language_config[$i];
                     $insert[] = "body_".$_->language_config[$i];
                     $value[] = $_->clier($_POST['alboum_name_'.$_->language_config[$i]]);
                     $value[] = $_->clier($_POST['title_'.$_->language_config[$i].'_'.$iterator]);
                }
                   $_->insert("body",[$insert,$value]);
                
            }
            $iterator++;    
        }
    }
  }    
    
    
  function save_gallery($_,$select_menu,$url){
     try{
        if(!isset($url[4]) || !is_numeric($url[4]))throw new Exception("bad uri format!!!");    
     }catch(Exception $exc) {
        die($exc->getMessage());
     }
    $select_body = $_->select("*","body","big",["page_id",$url[4]]);  
    $select_body = (isset($select_body['body']) && count($select_body['body']))?$select_body['body']:FALSE; 
      
      
    deletes($_);  
    $iterator = 1;  
    foreach($_POST as $key => $value){
        if($_->startsWith($key,'file_')){
          if(isset($_POST['title_'.$_->language_config[0].'_'.$iterator])){  
            $bool = (isset($_POST['id_'.$iterator]))?$_POST['id_'.$iterator]:'';
            $file = ($bool)?find_in_array($select_body,$bool):'SAXLI';
           // echo $file."<br/>";
            //echo  ($bool)?'id_exists '.$iterator.'<br/>':'id_not_exists '.$iterator.'<br/>';
            if($value){
                
                delete_old_file($file,$_);
                
             if($_->startsWith($value,'http'))
                 copy_file($key,$value,$iterator,$_,$file);
              else if($_->startsWith($value,'data:'))
                 move_uploaded($key,$value,$iterator,$_,$file); 
            }
            
                $insert = ['logo','attributes','page_date','date_modify'];
                $value  = [$file,'',time(),time()];
                for($i = 0; $i < count($_->language_config); $i++){
                     $insert[] = "body_".$_->language_config[$i];
                     $value[] = $_->clier($_POST['title_'.$_->language_config[$i].'_'.$iterator]);
                }
                if(!$bool){
                   array_push($insert,'page_id','date');
                   array_push($value,$url[4],time());
                   $_->insert("body",[$insert,$value]);
                }else{ 
                   $_->update("body",[$insert,$value,["page_id",$url[4],"id",$bool]]);               
                }
                
            }
            $iterator++;    
        }
    }
    
   $insert_big = ['page_count'];
   $value_big  = [$_->select("id","body","count",["page_id",$url[4]])];
    for($i = 0; $i < count($_->language_config); $i++){
      $insert_big[] = "name_".$_->language_config[$i];
      $value_big[]  = $_->clier($_POST['alboum_name_'.$_->language_config[$i]]);
    } 
    $_->update("body",[$insert_big,$value_big,["id",$url[4]]]);
  }
 
    
   
 function copy_file($key,$file,$iterator,$_,&$_array){
     $masiv = explode('.',$file);
     $end = end($masiv);
     $file_name = str_replace(' ','_',$key).'_'.time().'_'.$iterator;
     if(copy($file,$_->_dir.'img/banners/'.$file_name.'.'.$end)){
         $_->main_images($file_name.'.'.$end,$_->_dir.'img/banners',$_->_dir.'img/banners/small',$file_name,240,2);
                 $_array = $file_name.'.'.$end;
     }
 }  
 
 function move_uploaded($key,$file,$iterator,$_,&$_array){   
    $file_name = str_replace(' ','_',$key).'_'.time().'_'.$iterator;
     if(substr($file,0,5) == 'data:'){
         $dat = explode(';',$file);
         $dat = explode('/',$dat[0]);
         $dat = str_replace('e','',$dat[1]);
         $data = base64_decode(str_replace(' ','+',explode(',', $file)[1]));
//        if(substr($file,5,5) == 'video'){
//            if(file_put_contents('img/video/'.$file_name.'.'.$dat,$data)){
//                  $file = 'img/video/'.$file_name.'.'.$dat;
//             }    
//         }
//         else
           if(substr($file,5,5) == 'image'){
             if(file_put_contents($_->_dir.'img/banners/'.$file_name.'.'.$dat,$data)){
                 $_->main_images($file_name.'.'.$dat,$_->_dir.'img/banners',$_->_dir.'img/banners/small',$file_name,240,2);
                 $_array = $file_name.'.'.$dat;
               }
            }
         }
 }
 
  function deletes($_){   
    if($_POST['deletes']){
        $delete = substr($_POST['deletes'], 0, -1);
        $delete = explode('|', $delete);
        $obj = new stdClass();
        $obj->c_type = "big";
        $obj->sql = " and id in(".join(",",$delete).")";
        $sel = $_->select("*","body",$obj)['body'];
        for($i = 0; $i < count($sel); $i++){
            $file = $sel[$i]['logo'];
            delete_old_file($file,$_);
        }
        $sql = "delete from body where id in(".join(",",$delete).")";
        $_->con->exec($sql);
        //echo $sql;
    }
 }  
 
 function delete_old_file(&$file,$_){
        if($file){
            if(file_exists($_->_dir.'img/banners/'.$file))@unlink($_->_dir.'img/banners/'.$file);
            if(file_exists($_->_dir.'img/banners/small/'.$file))@unlink($_->_dir.'img/banners/small/'.$file);
            $file = '';
        }
 }
 
 function find_in_array($array,$id){
     if(!count($array))return '';
     $length = count($array);
     for($i = 0; $i < $length; $i++){
         if($array[$i]['id'] == $id)
             return $array[$i]['logo'];
     }return '';
 }
 
 $navig_name = '/'.$url[1].'/'.$url[2];
 
 function location($a,$navig_name,$_,$last_insert_id){
      if(!$a)return $_SERVER['HTTP_REFERER'];
      elseif($a == 1)return $navig_name;
      elseif($a == 2)return $navig_name.'/more/'.$last_insert_id;
  }  
    
    header("Location:".location($_POST['added_params'],$navig_name,$_,$last_insert_id).$_COOKIE['location_href_menu']."/changed/");
    exit;
    
    
    ///////////////////////////////////////////////////////////////
    ///////////////////////////////////////////////////////////////
    ///////////////////////////////////////////////////////////////
    ///////////////////////////////////////////////////////////////
    ///////////////////////////////////////////////////////////////
    ///////////////////////////////////////////////////////////////
    ///////////////////////////////////////////////////////////////
    ///////////////////////////////////////////////////////////////
    ///////////////////////////////////////////////////////////////
    ///////////////////////////////////////////////////////////////
    ///////////////////////////////////////////////////////////////
    ///////////////////////////////////////////////////////////////
    
    
    
    

//    $select_body = $_->select("logo","body","small",["page_id",$select_menu['id']]);
//    $_logo = $select_body;  
//    
//    if($_FILES['file']['name'] && preg_match('/[.](jpg)|(JPG)|(jpeg)|(JPEG)|(gif)|(GIF)|(png)|(PNG)$/',$_FILES['file']['name']))
//           $_logo = $_->upload_image($_FILES['file'],$_logo);
//    else{
//
//
//
//        if($_POST['delete_logo']){
//                if($_logo){
//                    if(file_exists($_->_dir.'img/banners/'.$_logo))@unlink($_->_dir.'img/banners/'.$_logo);
//                    if(file_exists($_->_dir.'img/banners/small/'.$_logo))@unlink($_->_dir.'img/banners/small/'.$_logo);
//                    $_logo = '';
//               }            
//        }
//    }   
//    $_time = 0;
//    if($_POST['time']){
//        list($day,$month,$year) = explode('/',$_->clier($_POST['time']));
//        $_time = mktime(0, 0, 0, $month, $day, $year);
//    }
//    
//    $insert = ['page_id','logo','attributes','page_date','date_modify'];
//    $value = [$select_menu['id'],$_logo,'',$_time,time()];
//    for($i = 0; $i < count($_->language_config); $i++){
//           $insert[] = "name_".$_->language_config[$i];
//           $insert[] = "body_".$_->language_config[$i];
//           $value[] = $_->clier($_POST['name_'.$_->language_config[$i]]);
//           $value[] = $_->clier($_POST['body_'.$_->language_config[$i]]);
//    }
//
//    
//    if($_->update("body",[$insert,$value,["page_id",$select_menu['id']]]))
//        header("Location:".$_SERVER['HTTP_REFERER'].$_COOKIE['location_href_menu']."/changed/");
//    else
//        die("insert error!!!!!");
    



?>