<?php
	ini_set('upload_max_filesize', '200M');
	    header("Content-Type:application/json");
include "cnx.php";

$op = $_GET['op'];

if($op=="GetAllType"){
	$type = $_GET['type'];
 $sql = "select distinct Type_vt
                                               
                    from  bd_vt_nour where type='$type' order by Type_vt
                    ";           

            $stmt = $pdo->prepare($sql);
            $stmt->execute();
           
            $data = [];

            while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {          
                 $data[] = $row;  
            } 

           $response         = [];
           $response['RESULT'] =  $data;

           echo json_encode($response, JSON_PRETTY_PRINT);


}else if($op=="GetMarque"){
$Type_vt =$_POST['Type_vt'];
$Engine_vt =$_POST['Engine_vt'];
$annee_deb =$_POST['annee_deb'];
$annee_fin =$_POST['annee_fin'];
$type = $_GET['type'];
$sql = "SELECT DISTINCT Marque from bd_vt_nour WHERE Type_vt= ? AND Engine_vt= ? and annee_deb<=".$annee_deb." and annee_fin>=".$annee_fin." and type='".$type."' order by Marque";           
        // echo  $sql;  
            $stmt = $pdo->prepare($sql);
			
			$stmt->bindParam(1, $Type_vt );
			$stmt->bindParam(2, $Engine_vt);
			//$stmt->bindParam(3, $annee_deb,PDO::PARAM_INT);
			//$stmt->bindParam(4, $annee_fin,PDO::PARAM_INT);
               
			$stmt->execute();
           
           
            $data = [];

            while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {          
                 $data[] = $row;  
            } 

           $response         = [];
           $response['RESULT'] =  $data;

           echo json_encode($response, JSON_PRETTY_PRINT);
}else if($op=="GetModel"){
$Type_vt =$_POST['Type_vt'];
$Engine_vt =$_POST['Engine_vt'];
$annee_deb =$_POST['annee_deb'];
$annee_fin =$_POST['annee_fin'];
$marque =$_POST['marque'];
$type = $_GET['type'];
$sql = "SELECT DISTINCT Modele from bd_vt_nour WHERE Type_vt= ? AND Engine_vt= ? and annee_deb<=".$annee_deb." and annee_fin>=".$annee_fin." and Marque= ?  and type='".$type."' order by Marque";           
            
            $stmt = $pdo->prepare($sql);
			
			$stmt->bindParam(1, $Type_vt );
			$stmt->bindParam(2, $Engine_vt);
			$stmt->bindParam(3, $marque);
			//$stmt->bindParam(3, $annee_deb,PDO::PARAM_INT);
			//$stmt->bindParam(4, $annee_fin,PDO::PARAM_INT);
               
			$stmt->execute();
           
           
            $data = [];

            while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {          
                 $data[] = $row;  
            } 

           $response         = [];
           $response['RESULT'] =  $data;

           echo json_encode($response, JSON_PRETTY_PRINT);
}else if($op=="GetModelBatterie"){
$Type_vt =$_POST['Type_vt'];
$Engine_vt =$_POST['Engine_vt'];
$annee_deb =$_POST['annee_deb'];
$annee_fin =$_POST['annee_fin'];
$marque =$_POST['marque'];
$model =$_POST['model'];
$sql = "SELECT Batterie1,Batterie2,Batterie3,Batterie4,Batterie5,Batterie6 from bd_vt_nour WHERE Type_vt= ? AND Engine_vt= ? and annee_deb<=".$annee_deb." and annee_fin>=".$annee_fin." and Marque= ? and Modele= ? ";           
            
            $stmt = $pdo->prepare($sql);
			
			$stmt->bindParam(1, $Type_vt );
			$stmt->bindParam(2, $Engine_vt);
			$stmt->bindParam(3, $marque);
			$stmt->bindParam(4, $model);
			//$stmt->bindParam(3, $annee_deb,PDO::PARAM_INT);
			//$stmt->bindParam(4, $annee_fin,PDO::PARAM_INT);
               
			$stmt->execute();
           
           
            $data = [];

            while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {          
                 $data[] = $row;  
            } 

           $response         = [];
           $response['RESULT'] =  $data;

           echo json_encode($response, JSON_PRETTY_PRINT);
}

else if($op=="GetActuelDate"){

$sql = "SELECT NOW() as actuelDate";           
            
            $stmt = $pdo->prepare($sql);
			
			

			$stmt->execute();
           
           
            $data = [];

            while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {          
                 $data[] = $row;  
            } 

           $response         = [];
           $response['RESULT'] =  $data;

           echo json_encode($response, JSON_PRETTY_PRINT);
}
 else if($op=="upld_pj"){
	
	
	$file_name = $_FILES['fileToUpload']['name'];
         $dir ='../RFS/nourMobileUploads/';
		  $newname = date('YmdHis',time()).basename($_FILES['fileToUpload']['name']); 
		 $file_path= $dir.$newname; 
		
		 if(move_uploaded_file($_FILES['fileToUpload']['tmp_name'],$file_path)){
			
			 $row['succe']=$newname;
    $myArray['RESULT'][] = $row;
	   echo json_encode($myArray, JSON_PRETTY_PRINT);
			

			}else{
				$row['succe']='NOK';
    $myArray['RESULT'][] = $row;
	   echo json_encode($myArray, JSON_PRETTY_PRINT);
			}   
	
     
	
  }
  else if($op=="delete_pj"){
	 
	  
 $dir ='../RFS/nourMobileUploads/'; 	    
$file_pointer = $_POST['file_delete'];
$cats = explode(",", $file_pointer);
foreach($cats as $cat) {
   
  unlink($dir.$cat);
}
 $row['succe']='ok';
    $myArray['RESULT'][] = $row;
	   echo json_encode($myArray, JSON_PRETTY_PRINT);
	  }
else if($op=="InsertReclamation"){
	/*$date_retourApp = date_create("2013-03-15");
	echo 
	*/
$agence_code =$_POST['agence_code'];
$date_retourApp = date_format(date_create($_POST['date_retourApp']),"Y-m-d");
$code_user =$_POST['code_user'];
$evaluation_agence =$_POST['evaluation_agence'];
$decision_agence =$_POST['decision_agence'];
$img_path1 =$_POST['img_path1'];
$img_path2 =$_POST['img_path2'];
$img_path3 =$_POST['img_path3'];
$img_path4 =$_POST['img_path4'];


$sql = "INSERT INTO  reclamation_table (agence_code,date_retourApp,code_user,evaluation_agence,decision_agence,img_path1,img_path2,img_path3, img_path4,date_heur_insert_agence) VALUES(?,?,?,?,?,?,?,?,?,NOW())";          
            
            $stmt = $pdo->prepare($sql);
			
			$stmt->bindParam(1, $agence_code );
			$stmt->bindParam(2, $date_retourApp);
			$stmt->bindParam(3, $code_user);
			$stmt->bindParam(4, $evaluation_agence);
			$stmt->bindParam(5, $decision_agence);
			$stmt->bindParam(6, $img_path1);
			$stmt->bindParam(7, $img_path2);
			$stmt->bindParam(8, $img_path3);
			$stmt->bindParam(9, $img_path4);
			
			
           
           if(!$stmt->execute()){
		  // echo $stmt->error;
		  $row['succe']='NoK';
    $myArray['RESULT'][] = $row;
		   }else{
		$row['succe']='ok';
    $myArray['RESULT'][] = $row;
	  
		   }
          
		 
           echo json_encode($myArray, JSON_PRETTY_PRINT);
		   
}
else if($op=="GetAllEnCoursAgence"){
	//echo"aa";
	$agence_code =$_POST['agence_code'];
	$data = [];
	/////////////////////////////Encour/////////////
 $sql = "select count(*) as ct_enCour
                                               
                    from  reclamation_table where agence_code = ? and agence_suivie='0'
                    ";           

            $stmt = $pdo->prepare($sql);
			$stmt->bindParam(1, $agence_code );
            $stmt->execute();
           
            

           $row1 = $stmt->fetch(PDO::FETCH_ASSOC);
			
             
			/////////////////////////////valide/////////////
  $sql = "select count(*) as ct_valide
                                               
                    from  reclamation_table where agence_code = ? and agence_suivie='1' and agence_vue='0'
                    ";           

            $stmt = $pdo->prepare($sql);
			$stmt->bindParam(1, $agence_code );
            $stmt->execute();
           
            

           $row2 = $stmt->fetch(PDO::FETCH_ASSOC);


		/////////////////////////////refusee/////////////
  $sql = "select count(*) as ct_refusee
                                               
                    from  reclamation_table where agence_code = ? and agence_suivie='2' and agence_vue='0'
                    ";           

            $stmt = $pdo->prepare($sql);
			$stmt->bindParam(1, $agence_code );
            $stmt->execute();
           
            

            $row3 = $stmt->fetch(PDO::FETCH_ASSOC);
			
                 $data[] = $row1;
				  $data[] = $row2;
				   $data[] = $row3;
				 
            












           $response         = [];
           $response['RESULT'] =  $data;

           echo json_encode($response, JSON_PRETTY_PRINT);


}
else if($op=="GetReclamation"){
	
$agence_code =$_POST['agence_code'];

$sql = "SELECT id,code_user,evaluation_agence,decision_agence,date_heur_insert_agence FROM reclamation_table WHERE agence_code =? and agence_suivie = '0' order by date_heur_insert_agence DESC ";           
            
            $stmt = $pdo->prepare($sql);
			
			$stmt->bindParam(1, $agence_code );
			
	
               
			$stmt->execute();
           
           
            $data = [];

            while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { 
			
                 $data[] = array_map("utf8_encode", $row);
            } 

           $response         = [];
           $response['RESULT'] =  $data;

           echo json_encode($response, JSON_PRETTY_PRINT);
}	
else if($op=="GetagenceListe"){
	
$ver = $_POST['agence_verif'];

$sql = "SELECT * FROM agence_table ";           
            
            $stmt = $pdo->prepare($sql);
			
			//$stmt->bindParam(1, $agence_code );
			
	
               
			$stmt->execute();
           
           
            $data = [];

            while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { 
			
                 $data[] = array_map("utf8_encode", $row);
            } 

           $response         = [];
           $response['RESULT'] =  $data;

           echo json_encode($response, JSON_PRETTY_PRINT);
}
else if($op=="updateAgenceListe"){
	
$id_agence = $_POST['id_agence'];
$stt = $_POST['stt'];

$sql = "update agence_table set statut = ? where id =".$id_agence;           
           //echo $sql; 
            $stmt = $pdo->prepare($sql);
			
			$stmt->bindParam(1, $stt);
			//$stmt->bindParam(2, $id_agence);
			
	
               
			$stmt->execute();
           
           
            if(!$stmt->execute()){
		  // echo $stmt->error;
		  $row['succe']='NoK';
    $myArray['RESULT'][] = $row;
		   }else{
		$row['succe']='ok';
    $myArray['RESULT'][] = $row;
	  
		   }
          
		 
           echo json_encode($myArray, JSON_PRETTY_PRINT);
}
else if($op=="updateAgenceListeCnt"){
	
$id_agence = $_POST['id_agence'];
$agence_name = $_POST['agence_name'];
$emplacement = $_POST['emplacement'];
$login = $_POST['login'];
$pwd = $_POST['pwd'];
$sql = "update agence_table set agence_name = ? , emplacement=? , login=? , pwd=? where id =".$id_agence;           
           //echo $sql; 
            $stmt = $pdo->prepare($sql);
			
			$stmt->bindParam(1, $agence_name);
			$stmt->bindParam(2, $emplacement);
			$stmt->bindParam(3, $login);
			$stmt->bindParam(4, $pwd);
			//$stmt->bindParam(2, $id_agence);
			
	
               
			$stmt->execute();
           
           
            if(!$stmt->execute()){
		  // echo $stmt->error;
		  $row['succe']='NoK';
    $myArray['RESULT'][] = $row;
		   }else{
		$row['succe']='ok';
    $myArray['RESULT'][] = $row;
	  
		   }
          
		 
           echo json_encode($myArray, JSON_PRETTY_PRINT);
}
else if($op=="listeReclamationNour"){
	
$agence_suivie = $_POST['agence_suivie'];

$sql = "select code_user,reclamation_table.id,agence_code,date_heur_insert_agence,evaluation_agence,decision_agence,img_path1,img_path2,img_path3,img_path4,date_heur_remarque_nour,agence_name from reclamation_table
INNER JOIN agence_table ON agence_table.id = reclamation_table.agence_code
where agence_suivie = ? order by date_heur_insert_agence DESC ";           
           //echo $sql; 
            $stmt = $pdo->prepare($sql);
			
			$stmt->bindParam(1, $agence_suivie);
			
			//$stmt->bindParam(2, $id_agence);
			
	
               
			$stmt->execute();
           
           
         $data = [];

            while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { 
			
                 $data[] = array_map("utf8_encode", $row);
            } 

           $response         = [];
           $response['RESULT'] =  $data;

           echo json_encode($response, JSON_PRETTY_PRINT);
}
else if($op=="countReclamationNour"){
	
	$agence_suivie = $_POST['agence_suivie'];

$sql = "select count(*) as ct from reclamation_table
where agence_suivie = ? ";           
           //echo $sql; 
            $stmt = $pdo->prepare($sql);
			
			$stmt->bindParam(1, $agence_suivie);
			
			//$stmt->bindParam(2, $id_agence);
			
	
               
			$stmt->execute();
           
           
         $data = [];

            while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { 
			
                 $data[] = array_map("utf8_encode", $row);
            } 

           $response         = [];
           $response['RESULT'] =  $data;

           echo json_encode($response, JSON_PRETTY_PRINT);
}
else if($op=="updateValiderRefuser"){
$agence_val_refu = $_POST['agence_val_refu'];	
$id_agence = $_POST['id_agence'];
$cause = $_POST['cause'];

$sql = "update reclamation_table set agence_suivie = ?, nour_remarque=?,agence_vue='0' ,date_heur_remarque_nour=NOW()  where id =".$id_agence;           
           //echo $sql; 
            $stmt = $pdo->prepare($sql);
			
			$stmt->bindParam(1, $agence_val_refu);
			$stmt->bindParam(2, $cause);
		
			//$stmt->bindParam(2, $id_agence);
			
	
               
			
           
           
            if(!$stmt->execute()){
		  // echo $stmt->error;
		  $row['succe']='NoK';
    $myArray['RESULT'][] = $row;
		   }else{
		$row['succe']='ok';
    $myArray['RESULT'][] = $row;
	  
		   }
          
		 
           echo json_encode($myArray, JSON_PRETTY_PRINT);
}
else if($op=="selectAllDB"){
	
	//$code = $_POST['code'];
$type = $_GET['type'];
$sql = "select * from bd_vt_nour where type='$type' ";           
           //echo $sql; 
            $stmt = $pdo->prepare($sql);
			
			//$stmt->bindParam(1, $agence_suivie);
			
			//$stmt->bindParam(2, $id_agence);
			
	
               
			$stmt->execute();
           
           
         $data = [];

            while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { 
			
                 $data[] = array_map("utf8_encode", $row);
            } 

           $response         = [];
           $response['RESULT'] =  $data;

           echo json_encode($response, JSON_PRETTY_PRINT);
}
else if($op=="selectAllDBcount"){
	
	$type = $_GET['type'];

$sql = "select count(*) as ct from bd_vt_nour where type='$type'";           
           //echo $sql; 
            $stmt = $pdo->prepare($sql);
			
			//$stmt->bindParam(1, $agence_suivie);
			
			//$stmt->bindParam(2, $id_agence);
			
	
               
			$stmt->execute();
           
           
         $data = [];

            while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { 
			
                 $data[] = array_map("utf8_encode", $row);
            } 

           $response         = [];
           $response['RESULT'] =  $data;

           echo json_encode($response, JSON_PRETTY_PRINT);
}
else if($op=="selectUser"){
	
$login = $_POST['login'];	
$pwd = $_POST['pwd'];

$sql = "select * from agence_table where login =? and pwd=?";           
           //echo $sql; 
            $stmt = $pdo->prepare($sql);
			
			$stmt->bindParam(1, $login);
			$stmt->bindParam(2, $pwd);
			
			//$stmt->bindParam(2, $id_agence);
			
	
               
			$stmt->execute();
           
           
         $data = [];
            $i = 0;
            while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { 
			$i++;
                 $data[] = array_map("utf8_encode", $row);
            } 
              if($i>0){
			  $response         = [];
           $response['RESULT'] =  $data;
				  }else{
				  $row['id']='0';
    $response['RESULT'][] = $row;
				  }
           

           echo json_encode($response, JSON_PRETTY_PRINT);
}
else if($op=="selectUserAgence"){
	
$login = $_POST['login'];	
$pwd = $_POST['pwd'];

$sql = "select * from agence_table where login =? and pwd=? and statut='0'";           
           //echo $sql; 
            $stmt = $pdo->prepare($sql);
			
			$stmt->bindParam(1, $login);
			$stmt->bindParam(2, $pwd);
			
			//$stmt->bindParam(2, $id_agence);
			
	
               
			$stmt->execute();
           
           
         $data = [];
            $i = 0;
            while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { 
			$i++;
                 $data[] = array_map("utf8_encode", $row);
            } 
              if($i>0){
			  $response         = [];
           $response['RESULT'] =  $data;
				  }else{
				  $row['id']='0';
    $response['RESULT'][] = $row;
				  }
           

           echo json_encode($response, JSON_PRETTY_PRINT);
}
else if($op=="GetReclamationValideRefuse"){
	
$agence_code =$_POST['agence_code'];
$valide_Refuse =$_POST['valide_Refuse'];

$sql = "SELECT id,code_user,evaluation_agence,decision_agence,date_heur_insert_agence,nour_remarque,date_heur_remarque_nour FROM reclamation_table WHERE agence_code =? and agence_suivie = ? and agence_vue='0' order by date_heur_insert_agence DESC ";           
            
            $stmt = $pdo->prepare($sql);
			
			$stmt->bindParam(1, $agence_code );
			$stmt->bindParam(2, $valide_Refuse );
	
               
			$stmt->execute();
           
           
            $data = [];

            while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { 
			
                 $data[] = array_map("utf8_encode", $row);
            } 

           $response         = [];
           $response['RESULT'] =  $data;

           echo json_encode($response, JSON_PRETTY_PRINT);
}	
else if($op=="UpdateVueReclamationValideRefuse"){
	
$agence_code =$_POST['agence_code'];
$valide_Refuse =$_POST['valide_Refuse'];

$sql = "update  reclamation_table set agence_vue = '1' WHERE agence_vue='0' and agence_suivie=? and agence_code=? ";           
            
            $stmt = $pdo->prepare($sql);
			
			
			$stmt->bindParam(1, $valide_Refuse );
			$stmt->bindParam(2, $agence_code );
	
               
				
           
           
            if(!$stmt->execute()){
		  // echo $stmt->error;
		  $row['succe']='NoK';
    $myArray['RESULT'][] = $row;
		   }else{
		$row['succe']='ok';
    $myArray['RESULT'][] = $row;
	  
		   }
          
		 
           echo json_encode($myArray, JSON_PRETTY_PRINT);
}	
else if($op=="UpdatePwdAgence"){
	
$agence_code =$_POST['agence_code'];
$agence_pwd =$_POST['agence_pwd'];

$sql = "update  agence_table set pwd = ? WHERE id= ? ";           
            
            $stmt = $pdo->prepare($sql);
			
			
			$stmt->bindParam(1, $agence_pwd );
			$stmt->bindParam(2, $agence_code );
	
               
				
           
           
            if(!$stmt->execute()){
		  // echo $stmt->error;
		  $row['succe']='NoK';
    $myArray['RESULT'][] = $row;
		   }else{
		$row['succe']='ok';
    $myArray['RESULT'][] = $row;
	  
		   }
          
		 
           echo json_encode($myArray, JSON_PRETTY_PRINT);
}
else if($op=="GetReclamationHisAgence"){
$date_du = date_format(date_create($_POST['date_du']."00:00:00"),"Y-m-d H:i:s");


$agence_code =$_POST['agence_code'];

$date_au=date_format(date_create($_POST['date_au']."23:59:59"),"Y-m-d H:i:s");
$rech_par=$_POST['rech_par'];


if($rech_par=="1"){
	
$sql = "SELECT id,code_user,evaluation_agence,decision_agence,date_heur_insert_agence,nour_remarque,date_heur_remarque_nour,agence_suivie FROM reclamation_table WHERE agence_code =? and agence_suivie <> 0 and date_heur_insert_agence BETWEEN ? and ? order by date_heur_insert_agence DESC ";           
	
}else if($rech_par=="2"){

$sql = "SELECT id,code_user,evaluation_agence,decision_agence,date_heur_insert_agence,nour_remarque,date_heur_remarque_nour,agence_suivie FROM reclamation_table WHERE agence_code =? and agence_suivie <> 0 and date_heur_remarque_nour BETWEEN ? and ? order by date_heur_remarque_nour DESC ";           

}
	
            
            $stmt = $pdo->prepare($sql);
			
			$stmt->bindParam(1, $agence_code );
			//$stmt->bindParam(2, '0' );
	        $stmt->bindParam(2, $date_du  );
			 $stmt->bindParam(3, $date_au  );
               
			$stmt->execute();
           
           
            $data = [];

            while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { 
			
                 $data[] = array_map("utf8_encode", $row);
            } 

           $response         = [];
           $response['RESULT'] =  $data;

           echo json_encode($response, JSON_PRETTY_PRINT);
		   
}
else if($op=="GetReclamationHisNour"){

$rech_par=$_POST['rech_par'];


if($rech_par=="1"){
	$date_du = date_format(date_create($_POST['date_du']."00:00:00"),"Y-m-d H:i:s");
   $date_au=date_format(date_create($_POST['date_au']."23:59:59"),"Y-m-d H:i:s");
$sql = "SELECT  agence_suivie,code_user,reclamation_table.id,agence_code,date_heur_insert_agence,evaluation_agence,decision_agence,img_path1,img_path2,img_path3,img_path4,date_heur_remarque_nour,agence_name,nour_remarque from reclamation_table
INNER JOIN agence_table ON agence_table.id = reclamation_table.agence_code  WHERE agence_suivie <> 0 and date_heur_insert_agence BETWEEN ? and ? order by date_heur_insert_agence DESC ";           
	 $stmt = $pdo->prepare($sql);
			
			//$stmt->bindParam(1, $agence_code );
			//$stmt->bindParam(2, '0' );
	        $stmt->bindParam(1, $date_du  );
			$stmt->bindParam(2, $date_au  );
}else if($rech_par=="2"){
	$date_du = date_format(date_create($_POST['date_du']."00:00:00"),"Y-m-d H:i:s");
   $date_au=date_format(date_create($_POST['date_au']."23:59:59"),"Y-m-d H:i:s");
$sql = "SELECT  agence_suivie,code_user,reclamation_table.id,agence_code,date_heur_insert_agence,evaluation_agence,decision_agence,img_path1,img_path2,img_path3,img_path4,date_heur_remarque_nour,agence_name,nour_remarque from reclamation_table
INNER JOIN agence_table ON agence_table.id = reclamation_table.agence_code  WHERE  agence_suivie <> 0 and date_heur_remarque_nour BETWEEN ? and ? order by date_heur_remarque_nour DESC ";           
			 $stmt = $pdo->prepare($sql);
			$stmt->bindParam(1, $date_du  );
			$stmt->bindParam(2, $date_au  );
}else if ($rech_par=="3"){
$id = $_POST['id'];
$sql = "SELECT  agence_suivie,code_user,reclamation_table.id,agence_code,date_heur_insert_agence,evaluation_agence,decision_agence,img_path1,img_path2,img_path3,img_path4,date_heur_remarque_nour,agence_name,nour_remarque from reclamation_table
INNER JOIN agence_table ON agence_table.id = reclamation_table.agence_code  WHERE reclamation_table.id =?  ";           
			 $stmt = $pdo->prepare($sql);
			$stmt->bindParam(1, $id);
}
	
            
           
               
			$stmt->execute();
            $count=$stmt->rowCount();
             $row['count']= $count;
           
		   $data = [];
                $data[]=$row;
            while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { 
			
                 $data[] = array_map("utf8_encode", $row);
            } 

           $response         = [];
           $response['RESULT'] =  $data;

           echo json_encode($response, JSON_PRETTY_PRINT);
		   
}
else if($op=="updateBD"){
	
$id = $_POST['id'];
$Type_vt = $_POST['Type_vt'];
$Marque = $_POST['Marque'];
$Modele = $_POST['Modele'];
$Engine_vt = $_POST['Engine_vt'];
$Batterie1 = $_POST['Batterie1'];
$Batterie2 = $_POST['Batterie2'];
$Batterie3 = $_POST['Batterie3'];
$Batterie4 = $_POST['Batterie4'];
$Batterie5 = $_POST['Batterie5'];
$Batterie6 = $_POST['Batterie6'];
$annee_deb = $_POST['annee_deb'];
$annee_fin = $_POST['annee_fin'];
$sql="UPDATE `bd_vt_nour` SET `Type_vt`=?,`Marque`=?,`Modele`=?,`Engine_vt`=?,`Batterie1`=?,`Batterie2`=?,`Batterie3`=?,`Batterie4`=?,`Batterie5`=?,`Batterie6`=?,`annee_deb`=?,`annee_fin`=? WHERE id = ?";
           //echo $sql; 
            $stmt = $pdo->prepare($sql);
			
			$stmt->bindParam(1, $Type_vt);
			$stmt->bindParam(2, $Marque);
			$stmt->bindParam(3, $Modele);
			$stmt->bindParam(4, $Engine_vt);
			$stmt->bindParam(5, $Batterie1);
			$stmt->bindParam(6, $Batterie2);
			$stmt->bindParam(7, $Batterie3);
			$stmt->bindParam(8, $Batterie4);
			$stmt->bindParam(9, $Batterie5);
			$stmt->bindParam(10, $Batterie6);
			$stmt->bindParam(11, $annee_deb);
			$stmt->bindParam(12, $annee_fin);
			$stmt->bindParam(13, $id);
			//$stmt->bindParam(2, $id_agence);
			
	
               
		//	$stmt->execute();
           
           
            if(!$stmt->execute()){
		  // echo $stmt->error;
		  $row['succe']='NoK';
    $myArray['RESULT'][] = $row;
		   }else{
		$row['succe']='ok';
    $myArray['RESULT'][] = $row;
	  
		   }
          
		 
           echo json_encode($myArray, JSON_PRETTY_PRINT);
}
else if($op=="InsertNewCar"){
	/*$date_retourApp = date_create("2013-03-15");
	echo 
	*/
$Type_vt =$_POST['Type_vt'];
$Marque = $_POST['Marque'];
$Modele =$_POST['Modele'];
$Engine_vt =$_POST['Engine_vt'];
$Batterie1 =$_POST['Batterie1'];
$Batterie2 =$_POST['Batterie2'];
$Batterie3 =$_POST['Batterie3'];
$Batterie4 =$_POST['Batterie4'];
$Batterie5 =$_POST['Batterie5'];
$Batterie6 =$_POST['Batterie6'];
$annee_deb =$_POST['annee_deb'];
$annee_fin =$_POST['annee_fin'];
$type=$_POST['type'];

$sql = "INSERT INTO `bd_vt_nour`( `Type_vt`, `Marque`, `Modele`, `Engine_vt`,`Batterie1`, `Batterie2`, `Batterie3`, `Batterie4`, `Batterie5`, `Batterie6`, `annee_deb`, `annee_fin`,`type`) VALUES 
(?,?,?,?,?,?,?,?,?,?,?,?,?)";          
            
            $stmt = $pdo->prepare($sql);
			
			$stmt->bindParam(1, $Type_vt );
			$stmt->bindParam(2, $Marque);
			$stmt->bindParam(3, $Modele);
			$stmt->bindParam(4, $Engine_vt);
			$stmt->bindParam(5, $Batterie1);
			$stmt->bindParam(6, $Batterie2);
			$stmt->bindParam(7, $Batterie3);
			$stmt->bindParam(8, $Batterie4);
			$stmt->bindParam(9, $Batterie5);
			$stmt->bindParam(10, $Batterie6);
			$stmt->bindParam(11, $annee_deb);
			$stmt->bindParam(12, $annee_fin);
			$stmt->bindParam(13, $type);
			
			
           
           if(!$stmt->execute()){
		  // echo $stmt->error;
		  $row['succe']='NoK';
    $myArray['RESULT'][] = $row;
		   }else{
		$row['succe']='ok';
    $myArray['RESULT'][] = $row;
	  
		   }
          
		 
           echo json_encode($myArray, JSON_PRETTY_PRINT);
		   
}
else if($op=="DeleteCar"){
	
$id =$_POST['id'];



$sql = "DELETE FROM `bd_vt_nour` WHERE id =?";          
            
            $stmt = $pdo->prepare($sql);
			
			$stmt->bindParam(1, $id );
		
			
			
           
           if(!$stmt->execute()){
		  // echo $stmt->error;
		  $row['succe']='NoK';
    $myArray['RESULT'][] = $row;
		   }else{
		$row['succe']='ok';
    $myArray['RESULT'][] = $row;
	  
		   }
          
		 
           echo json_encode($myArray, JSON_PRETTY_PRINT);
		   
}
else if($op=="InsertProposition"){
	
$Type =$_POST['Type'];
$Marque =$_POST['Marque'];
$AnneCnc =$_POST['AnneCnc'];
$Carburant =$_POST['Carburant'];
$Modele_vt =$_POST['Modele_vt'];
$Version_vt =$_POST['Version_vt'];
$MdlBattNour =$_POST['MdlBattNour'];
$agenceName =$_POST['agenceName'];


$sql = "INSERT INTO  prposition_vt (Type,Marque,AnneCnc,Carburant,Modele_vt,Version_vt,MdlBattNour,agenceName,vue_adm) VALUES(?,?,?,?,?,?,?,?,'0')";          
            
            $stmt = $pdo->prepare($sql);
			
			$stmt->bindParam(1, $Type );
			$stmt->bindParam(2, $Marque);
			$stmt->bindParam(3, $AnneCnc);
			$stmt->bindParam(4, $Carburant);
			$stmt->bindParam(5, $Modele_vt);
			$stmt->bindParam(6, $Version_vt);
			$stmt->bindParam(7, $MdlBattNour);
			$stmt->bindParam(8, $agenceName);
			//$stmt->bindParam(9, 0);
			
			
			
           
           if(!$stmt->execute()){
		  // echo $stmt->error;
		  $row['succe']='NoK';
    $myArray['RESULT'][] = $row;
		   }else{
		$row['succe']='ok';
    $myArray['RESULT'][] = $row;
	  
		   }
          
		 
           echo json_encode($myArray, JSON_PRETTY_PRINT);
		   
}

else if($op=="selectCountProposition"){

$t = $_POST['agence_suivie'];
$sql = "SELECT count(*) as ct_prp FROM prposition_vt WHERE vue_adm ='0' ";           
            
            $stmt = $pdo->prepare($sql);
			
			
               
			$stmt->execute();
           
           
            $data = [];

            while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { 
			
                 $data[] = array_map("utf8_encode", $row);
            } 

           $response         = [];
           $response['RESULT'] =  $data;

           echo json_encode($response, JSON_PRETTY_PRINT);
}
else if($op=="selectProposition"){

$t = $_POST['agence_suivie'];
$sql = "SELECT *  FROM prposition_vt WHERE vue_adm ='0' ";           
            
            $stmt = $pdo->prepare($sql);
			
			
               
			$stmt->execute();
           
           
            $data = [];

            while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { 
			
                 $data[] = array_map("utf8_encode", $row);
            } 

           $response         = [];
           $response['RESULT'] =  $data;

           echo json_encode($response, JSON_PRETTY_PRINT);
}
else if($op=="UpdateProposition"){
	
$id =$_POST['id'];
$val =$_POST['val'];

$sql = "update  prposition_vt set vue_adm = ? WHERE id= ? ";           
            
            $stmt = $pdo->prepare($sql);
			
			
			$stmt->bindParam(1, $val );
			$stmt->bindParam(2, $id );
	
               
				
           
           
            if(!$stmt->execute()){
		  // echo $stmt->error;
		  $row['succe']='NoK';
    $myArray['RESULT'][] = $row;
		   }else{
		$row['succe']='ok';
    $myArray['RESULT'][] = $row;
	  
		   }
          
		 
           echo json_encode($myArray, JSON_PRETTY_PRINT);
}
else if($op=="insertNewUser"){
	
$agenceUser =$_POST['agenceUser'];
$emplacement =$_POST['emplacement'];
$login =$_POST['login'];
$pwd =$_POST['pwd'];
$role =$_POST['role'];
$sql = "INSERT INTO `agence_table`(`agence_name`, `emplacement`, `login`, `pwd`,`role`) VALUES (?,?,?,?,?)";           
           // ECHO $sql;
            $stmt = $pdo->prepare($sql);
			
			
			$stmt->bindParam(1, $agenceUser );
			$stmt->bindParam(2, $emplacement );
			$stmt->bindParam(3, $login );
			$stmt->bindParam(4, $pwd );
			$stmt->bindParam(5, $role );
			
	
               
				
           
           
            if(!$stmt->execute()){
		  // echo $stmt->error;
		  $row['succe']='NoK';
    $myArray['RESULT'][] = $row;
		   }else{
		$row['succe']='ok';
    $myArray['RESULT'][] = $row;
	  
		   }
          
		 
           echo json_encode($myArray, JSON_PRETTY_PRINT);
}



?>