<?php
ini_set('display_errors',1);
error_reporting(0);

// Démarrage de la session
session_start();
// On vérifie si le champ Login n'est pas vide.
if ($_SESSION['login']=='')
// Si c'est le cas, le visiteur ne s'est pas loger et subit une redirection
{
	exit('');
}
require_once '../modules/functions.php';
// BDD SITE 

require_once('../bdd.php');

switch($_GET['mode']){
	case 'ajax_set_image_page' :
            
                if(!empty($_FILES['image'])){
                    
                    $link = "images/upload/photo_p/page-".$_GET['id'];
                    $storeFolder = "/var/www/soiree31decembre/site/".$link."/";
                    
                    if(!is_dir($storeFolder)) mkdir($storeFolder,0777,true);
                
                    $infoExt        =   getimagesize($_FILES['image']['tmp_name']);
                    $fileName      =   str_replace(" ","",trim($_FILES['image']['name']));
                    $file          =   explode(".",$fileName);
                    $File_Ext       =   substr($_FILES['image']['name'], strrpos($_FILES['image']['name'],'.'));

                    if($infoExt['mime'] == 'image/gif' || $infoExt['mime'] == 'image/jpeg' || $infoExt['mime'] == 'image/png')
                    {
                        $s=1;
                        $fileName   =   "page-".rand(0,999).time().$File_Ext;
                        $path   =   trim($storeFolder.$fileName);
                        
                        if(move_uploaded_file($_FILES['image']['tmp_name'], $path))
                        {
                            $Sflag      =   1; // success
                        }else{
                            $Sflag  = 2; // file not move to the destination
                        }
                    }
                    else
                    {
                        $Sflag  = 3; //extention not valid
                    }
                        
                    if($Sflag==1){
                        $result['msg'] =  'Page modifiée !';
                        
                    }else if($Sflag==2){
                        $result['msg'] = 'Impossible d\'envoyer l\'image.';
                    }else if($Sflag==3){
                        $result['msg'] = 'Extension de fichier incorrect. Essayer .PNG, .JPEG, .GIF, .JPG';
                    }
                    $url = $link."/".$fileName;
                    
                    $query = "UPDATE ad_pages_libres SET image='".$url."' WHERE id=".$_GET['id'];
                    $mysqli->query($query);
                    $result['url'] =  $url;
                }
                
                $storeFolder_big = "/var/www/soiree31decembre/site/images/upload/photos/page-".$_GET['id'];
                if(!is_dir($storeFolder_big)) mkdir($storeFolder_big,0777,true);
                
		copy($path,$storeFolder_big."/".$fileName);
                
                echo json_encode($result);
                
	break;
	case 'ajax_set_image' :
            
                if(!empty($_FILES['flyer'])){
                    
                    $link = "images/upload/photo_p/flyer-".$_GET['id'];
                    $storeFolder = "/var/www/soiree31decembre/site/".$link."/";
                    
                    if(!is_dir($storeFolder)) mkdir($storeFolder,0777,true);
                    $infoExt        =   getimagesize($_FILES['flyer']['tmp_name']);
                    $fileName      =   str_replace(" ","",trim($_FILES['flyer']['name']));
                    $file          =   explode(".",$fileName);
                    $File_Ext       =   substr($_FILES['flyer']['name'], strrpos($_FILES['flyer']['name'],'.'));

                    if($infoExt['mime'] == 'image/gif' || $infoExt['mime'] == 'image/jpeg' || $infoExt['mime'] == 'image/png')
                    {
                        $s=1;
                        $fileName   =   "flyer-".rand(0,999).time().$File_Ext;
                        $path   =   trim($storeFolder.$fileName);
                        
                        if(move_uploaded_file($_FILES['flyer']['tmp_name'], $path))
                        {
                            $Sflag      =   1; // success
                        }else{
                            $Sflag  = 2; // file not move to the destination
                        }
                    }
                    else
                    {
                        $Sflag  = 3; //extention not valid
                    }
                        
                    if($Sflag==1){
                        $result['msg'] =  'Flyer modifié !';
                        
                    }else if($Sflag==2){
                        $result['msg'] = 'Impossible d\'envoyer le flyer.';
                    }else if($Sflag==3){
                        $result['msg'] = 'Extension de fichier incorrect. Essayer .PNG, .JPEG, .GIF, .JPG';
                    }
                    $url = $link."/".$fileName;
                    
                    $query = "UPDATE ad_soirees SET flyer='".$url."' WHERE id=".$_GET['id'];
                    $mysqli->query($query);
                    $result['url'] =  $url;
                }
                
                $storeFolder_big = "/var/www/soiree31decembre/site/images/upload/photos/flyer-".$_GET['id'];
                if(!is_dir($storeFolder_big)) mkdir($storeFolder_big,0777,true);
                
		copy($path,$storeFolder_big."/".$fileName);
                
                 /* Redimensionnement Photo Petite */
                redimensionne($path,320,320);
                
                echo json_encode($result);
                
	break;
        case 'ajax_set_logo_lieu' :
            
                if(!empty($_FILES['logo'])){
                    
                    $link = "images/upload/photo_p/logo-".$_GET['id'];
                    $storeFolder = "/var/www/soiree31decembre/site/".$link."/";
                    
                    if(!is_dir($storeFolder)) mkdir($storeFolder,0777,true);
                
                    $infoExt        =   getimagesize($_FILES['logo']['tmp_name']);
                    $fileName      =   str_replace(" ","",trim($_FILES['logo']['name']));
                    $file          =   explode(".",$fileName);
                    $File_Ext       =   substr($_FILES['logo']['name'], strrpos($_FILES['logo']['name'],'.'));

                    if($infoExt['mime'] == 'image/gif' || $infoExt['mime'] == 'image/jpeg' || $infoExt['mime'] == 'image/png')
                    {
                        $s=1;
                        $fileName   =   "logo-".rand(0,999).time().$File_Ext;
                        $path   =   trim($storeFolder.$fileName);
                        
                        if(move_uploaded_file($_FILES['logo']['tmp_name'], $path))
                        {
                            $Sflag      =   1; // success
                        }else{
                            $Sflag  = 2; // file not move to the destination
                        }
                    }
                    else
                    {
                        $Sflag  = 3; //extention not valid
                    }
                        
                    if($Sflag==1){
                        $result['msg'] =  'Logo modifié !';
                        
                    }else if($Sflag==2){
                        $result['msg'] = 'Impossible d\'envoyer le logo.';
                    }else if($Sflag==3){
                        $result['msg'] = 'Extension de fichier incorrect. Essayer .PNG, .JPEG, .GIF, .JPG';
                    }
                    $url = $link."/".$fileName;
                    
                    $query = "UPDATE ad_lieux SET image_logo='".$url."' WHERE id=".$_GET['id'];
                    $mysqli->query($query);
                    $result['url'] =  $url;
                }
                
                $storeFolder_big = "/var/www/soiree31decembre/site/images/upload/photos/logo-".$_GET['id'];
                if(!is_dir($storeFolder_big)) mkdir($storeFolder_big,0777,true);
                
		copy($path,$storeFolder_big."/".$fileName);
                
                
                echo json_encode($result);
                
	break;
        
        case 'ajax_set_images_lieu' : // Upload image des lieux 
            
            
            if(!empty($_FILES['files'])){
                
                $link = "images/upload/photo_p/lieu-".$_GET['id'];
                $storeFolder = "/var/www/soiree31decembre/site/".$link."/";
                

                if(!is_dir($storeFolder)) mkdir($storeFolder,0777,true);
                    
                $n=0;
                $s=0;
                $prepareNames   =   array();
                foreach($_FILES['files']['name'] as $val)
                {
                    $infoExt        =   getimagesize($_FILES['files']['tmp_name'][$n]);
                    $s++;
                    $filesName      =   str_replace(" ","",trim($_FILES['files']['name'][$n]));
                    $files          =   explode(".",$filesName);
                    $File_Ext       =   substr($_FILES['files']['name'][$n], strrpos($_FILES['files']['name'][$n],'.'));

                    if($infoExt['mime'] == 'image/gif' || $infoExt['mime'] == 'image/jpeg' || $infoExt['mime'] == 'image/png')
                    {
                        $fileName   =   $s.rand(0,999).time().$File_Ext;
                        $url = $link."/".$fileName;
                        $path   =   trim($storeFolder.$fileName);
                        if(move_uploaded_file($_FILES['files']['tmp_name'][$n], $path))
                        {
                            $prepareNames[] .=  $url; //need to be fixed.
                            $Sflag      =   1; // success
                        }else{
                            $Sflag  = 2; // file not move to the destination
                        }
                    }
                    else
                    {
                        $Sflag  = 3; //extention not valid
                    }
                    $n++;
                    $storeFolder_big = "/var/www/soiree31decembre/site/images/upload/photos/lieu-".$_GET['id'];
                    if(!is_dir($storeFolder_big)) mkdir($storeFolder_big,0777,true);

                    copy($path,$storeFolder_big."/".$fileName);
                    /* Redimensionnement Photo Petite */
                    redimensionne($path,150,100);
                }
                if($Sflag==1){
                    echo '{Images uploaded successfully!}';
                }else if($Sflag==2){
                    echo '{File not move to the destination.}';
                }else if($Sflag==3){
                    echo '{File extention not good. Try with .PNG, .JPEG, .GIF, .JPG}';
                }

                if(!empty($prepareNames)){
                    $nb_photos = count($prepareNames);
                    $mysqli->query("UPDATE ad_lieux_photos SET ordre=(ordre+$nb_photos) WHERE id_lieu = ".$_GET['id']);
                    $count  =   1;
                    foreach($prepareNames as $name){
                        $query ="INSERT INTO `ad_lieux_photos` (`id_lieu`, `image`, `date_creation`, `ordre`) "
                                . " VALUES ("
                                . $_GET['id'].",'".$name."',NOW(),".$count++
                                . ");";
                        $result = $mysqli->query($query);
                    }
                }
            }
            break;
}
switch($_POST['mode']){
    
        case 'ajax_set_images_ordre_lieu' : 
            //get images id and generate ids array
            
            // 
            if($_POST['ids']!='') {
             $query = "SELECT image from ad_lieux_photos  WHERE id NOT IN (".$_POST['ids'].") AND id_lieu = ".$_POST['id'];
            }else{
              $query = "SELECT image from ad_lieux_photos  WHERE id_lieu = ".$_POST['id'];  
            }
            
            if ($result_sql = $mysqli->query($query)) {

                    /* Tableau associatif de la ligne sélectionnée */
                    while ($row = $result_sql->fetch_assoc()) {
                            $image = $row['image'];
                            $file_obj = "/var/www/soiree31decembre/site/".$image;
                            if(file_exists($file_obj)) {
                              unlink($file_obj);
                            }
                            $file_obj = "/var/www/soiree31decembre/site/".str_replace("photo_p","photos",$image);
                            if(file_exists($file_obj)) {
                             $test =   unlink($file_obj);
                            }
                    }
                    /* Libération du jeu de résultats */
                    $result_sql->close();
            }
            
            // On supprime les photos retirées 
              if($_POST['ids']!='') {
                $delete_files = "DELETE FROM ad_lieux_photos WHERE id NOT IN (".$_POST['ids'].") AND id_lieu = ".$_POST['id'];
              }else{
                 $delete_files = "DELETE FROM ad_lieux_photos WHERE id_lieu = ".$_POST['id'];
              }
            $result = $mysqli->query($delete_files);
            
            $idArray = explode(",",$_POST['ids']);
            //update images order
            $count = 1;
            foreach ($idArray as $id){
               $query ="UPDATE `ad_lieux_photos` SET ordre = $count WHERE id = $id  AND id_lieu = ".$_POST['id'];
               $result = $mysqli->query($query);
                
                $count ++;
            }
            echo '1';
            break;
	case 'ajax_get_image' :
		$result  = array();
            
                    $soiree = null;
                        $query = "SELECT flyer from ad_soirees  WHERE id=".$_POST['id'];
                        if ($result_sql = $mysqli->query($query)) {

                                /* Tableau associatif de la ligne sélectionnée */
                                while ($row = $result_sql->fetch_assoc()) {
                                        $soiree = $row;
                                }
                                /* Libération du jeu de résultats */
                                $result_sql->close();
                        }


		$file_obj = "/var/www/soiree31decembre/site/".$soiree['flyer'];
                
                $obj['url'] = "http://www.soiree31decembre.fr/".$soiree['flyer'];
                $obj['name'] = $soiree['flyer'];
                $obj['size'] = filesize($file_obj);
                $result[] = $obj;

		header('Content-type: text/json');              //3
		header('Content-type: application/json');
		echo json_encode($result);

	break;
        case 'switch_publier_lieu' : 
            $query ="UPDATE ad_lieux set publier='".$_POST['value']."' WHERE id = ".$_POST['id'].";";
            $result = $mysqli->query($query);
        break;
        case 'switch_publier_soiree' : 
            $query ="UPDATE ad_soirees set publier='".$_POST['value']."' WHERE id = ".$_POST['id'].";";
            $result = $mysqli->query($query);
        break;
        case 'switch_status_soiree' : 
            $query ="UPDATE ad_soirees set status='".$_POST['value']."' WHERE id = ".$_POST['id'].";";
            $result = $mysqli->query($query);
        break;
        case 'switch_publier_page' : 
            $query ="UPDATE ad_pages_libres set publier='".$_POST['value']."' WHERE id = ".$_POST['id'].";";
            $result = $mysqli->query($query);
        break;
        case 'switch_publier_faq' : 
            $query ="UPDATE ad_faqs_new set publier='".$_POST['value']."' WHERE id = ".$_POST['id'].";";
            $result = $mysqli->query($query);
        break;
        case 'switch_publier_tag' : 
            $query ="UPDATE ad_tags set publier='".$_POST['value']."' WHERE id = ".$_POST['id'].";";
            $result = $mysqli->query($query);
        break;
	case 'ajax_update_order_soirees':
                foreach($_POST['ordre'] as $cle => $val) {
                    $query ="UPDATE ad_soirees set ordre='".$val."' WHERE id = ".$cle.";";
                    $result = $mysqli->query($query);
                    
//                    $query ="UPDATE ad_soiree_accueil set ordre='".$val."' WHERE id_soiree = ".$cle.";";
//                    $result = $mysqli->query($query);
                    
                }
                $result->close();
                //
	break;
        
	case 'ajax_update_order_lieux':
                foreach($_POST['ordre'] as $cle => $val) {
                    $query ="UPDATE ad_lieux set ordre='".$val."' WHERE id = ".$cle.";";
                    $result = $mysqli->query($query);
                }
                $result->close();
                //
	break;
	case 'ajax_update_order_pages':
                foreach($_POST['ordre'] as $cle => $val) {
                    $query ="UPDATE ad_pages_libres set ordre='".$val."' WHERE id = ".$cle.";";
                    $result = $mysqli->query($query);
                }
                $result->close();
                //
	break;
	case 'ajax_update_order_faqs':
                foreach($_POST['ordre'] as $cle => $val) {
                    $query ="UPDATE ad_faqs_new set ordre='".$val."' WHERE id = ".$cle.";";
                    $result = $mysqli->query($query);
                }
                $result->close();
                //
	break;
	case 'ajax_update_order_tags':
                foreach($_POST['ordre'] as $cle => $val) {
                    $query ="UPDATE ad_tags set ordre='".$val."' WHERE id = ".$cle.";";
                    $result = $mysqli->query($query);
                }
                $result->close();
                //
	break;
        case 'delete_soiree' : 
//            
//            $query = "SELECT flyer from ad_soirees  WHERE id=".$_POST['id'];
//                if ($result_sql = $mysqli->query($query)) {
//
//                        /* Tableau associatif de la ligne sélectionnée */
//                        while ($row = $result_sql->fetch_assoc()) {
//                                $flyer = $row['flyer'];
//                        }
//                        /* Libération du jeu de résultats */
//                        $result_sql->close();
//                        $file_obj = "/var/www/soiree31decembre/site/".$flyer;
//                        if(file_exists($file_obj)) unlink($file_obj);
//                }
//            
            $delete_soiree = "DELETE FROM ad_soirees WHERE id= ".$_POST['id'];
            $result = $mysqli->query($delete_soiree);
           
//            $delete_soiree_accueil = "DELETE FROM ad_soiree_accueil WHERE id_soiree = ".$_POST['id'];
//            $result = $mysqli->query($delete_soiree_accueil);
            
            $delete_soiree_faqs = "DELETE FROM ad_faqs_soirees WHERE id_soiree = ".$_POST['id'];
            $result = $mysqli->query($delete_soiree_faqs);
           
            break;
            
        case 'delete_lieu' : 
            
//             $query = "SELECT image from ad_lieux_photos  WHERE id_lieu=".$_POST['id'];
//                if ($result_sql = $mysqli->query($query)) {
//
//                        /* Tableau associatif de la ligne sélectionnée */
//                        while ($row = $result_sql->fetch_assoc()) {
//                                $image = $row['image'];
//                                $file_obj = "/var/www/soiree31decembre/site/".$image;
//                                if(file_exists($file_obj)) unlink($file_obj);
//                        }
//                        /* Libération du jeu de résultats */
//                        $result_sql->close();
//                       
//                }
                
            $delete_lieu = "DELETE FROM ad_lieux WHERE id= ".$_POST['id'];
            $result = $mysqli->query($delete_lieu);
           
            $delete_lieu_pohotos = "DELETE FROM ad_lieux_photos WHERE id_lieu= ".$_POST['id'];
            $result = $mysqli->query($delete_lieu_pohotos);
                
            
        break;
        
           
        case 'delete_page' : 
            
            $delete_page = "DELETE FROM ad_pages_libres WHERE id= ".$_POST['id'];
            $result = $mysqli->query($delete_page);
           
        break;
    
        case 'delete_tag' : 
            
            $delete_tag = "DELETE FROM ad_tags WHERE id= ".$_POST['id'];
            $result = $mysqli->query($delete_tag);
           
        break;
    
         case 'delete_faq' : 
            
            $delete_faq = "DELETE FROM ad_faqs_new WHERE id= ".$_POST['id'];
            $result = $mysqli->query($delete_faq);
            
            $delete_faq_soirees = "DELETE FROM ad_faqs_soirees WHERE id_faq= ".$_POST['id'];
            $result = $mysqli->query($delete_faq_soirees);
           
        break;


}