
<?php
error_reporting(E_ERROR | E_WARNING | E_PARSE | E_NOTICE);

header('Content-Type: application/json; Charset=UTF-8');

include 'cnx.php';
$op = $_GET['op'];

////////// ajouter question
if($op=="nvx_question"){
	 if ( isset($_POST['question']) )
         {
	$question = $_POST['question'];
	$order_ques = $_POST['order_ques'];
	$type_ques = $_POST['type_ques'];
	$id_module = $_POST['id_module'];
	
	
	
	 $mysqli->query("INSERT INTO sna_question (question, order_question,type_question,id_module) VALUES ('$question','$order_ques','$type_ques','$id_module')");
          $row['succe']=1;
    $myArray['RESULT'][] = $row;
	   echo json_encode($myArray);
		 }
	
  } else if($op=="liste_section"){
////////////////////// Lire tout section

	
	$result = $mysqli->query("SELECT * FROM sna_section ");
    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
		
       while($row = $result->fetch_array()) {
            $myArray['RESULT'][] = $row;
    }
	
    echo json_encode($myArray);
	  
	
       }
	   else
    {
	    echo json_encode("99");
	
      }
	
  } else if($op=="moduleBySection"){
  ///////// select module by section
  
	  $id_section = $_GET["id_section"];
	
	$result = $mysqli->query("SELECT * FROM sna_module where id_section='$id_section' ");
    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
		
       while($row = $result->fetch_array()) {
            $myArray['RESULT'][] =$row; 
    }
	header('Content-Type: application/json; Charset=UTF-8');

    echo json_encode($myArray);
	  
	
       }
	   else
    {
	    echo json_encode("99");
	
      }
	
  } else if($op=="questionBymodule"){
    ///////// select question by module
  
	  $id_module = $_GET["id_module"];
	
	$result = $mysqli->query("SELECT * FROM sna_question where id_module='$id_module' order by order_question ");
    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
		
       while($row = $result->fetch_array()) {
            $myArray['RESULT'][] =$row; 
    }
	header('Content-Type: application/json; Charset=UTF-8');

    echo json_encode($myArray);
	  
	
       }
	   else
    {
	    echo json_encode("99");
	
      }
	
  } else if($op == "insertReponse"){
      $values_g=str_replace('1#1', "'", $_POST['reponses_g']);
	  $result =$mysqli->query("INSERT INTO sna_reponse_g(nomp,date_sys,id_module,id_section,commentaire) values ".$values_g) ;      
      $lastInsertedPeopleId = mysqli_insert_id($mysqli);
          if (!empty ($_FILES)){
			  
		 
	    $file_name = $_FILES['fileToUpload']['name'];
         $dir ='../RFS/uploads/';
		 $file_path= $dir.$lastInsertedPeopleId.basename($_FILES['fileToUpload']['name']); 
		 if(move_uploaded_file($_FILES['fileToUpload']['tmp_name'],$file_path)){
			
			
		 $mysqli->query("update sna_reponse_g set path_img='$file_path' where id='$lastInsertedPeopleId'" );

			}   
	   }
	  
	  
	  $values=str_replace('1#1', "'", $_POST['reponses']);
	  $values=str_replace('keygh',$lastInsertedPeopleId, $values);
	  $result =$mysqli->query("INSERT INTO sna_reponse(id_question,reponse,nomp,dateh_rep,observation,id_module,date_inser,id_reponse_g,path_pj) values ".$values) ;
	       
      
     	 
	  
	  
	  //echo $result ;
	 //$result ="INSERT INTO sna_reponse(id_question,reponse,nomp,dateh_rep,observation,id_module) values ".$values ;
         if($result){
			 $row['lastID']=$lastInsertedPeopleId;
    $myArray['RESULT'][] = $row;
	   echo json_encode($myArray);
            			
		 }else{
		       echo json_encode(0);
		 }
			 
	   
  }
                   ///////////////////verifier l'existande de reponse
   else if($op == "verifExist"){
 
  	  $date_rech = $_GET["date_rech"];
	  $nomp = $_GET["nomp"];
	  $id_module = $_GET["id_module"];
	
	
	$result = $mysqli->query("SELECT *  FROM sna_reponse where dateh_rep='$date_rech' and nomp='$nomp' and id_module='$id_module' ");
    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
		
       while($row = $result->fetch_array()) {
            $myArray['RESULT'][] =$row; 
    }
	header('Content-Type: application/json; Charset=UTF-8');

    echo json_encode($myArray);
	  
	
       }
	   else
    {
		$row['id']='0';
		$myArray['RESULT'][] =$row;
	    echo json_encode($myArray);
	
      }
		 
			 
	   
  }
        ///////////////////s'authetifier
   else if($op == "auth"){
 
  	  $login = $_GET["login"];
	  $pwd = $_GET["pwd"];
	
	
	
	$result = $mysqli->query("SELECT *  FROM sna_user where login='$login' and pwd='$pwd'");
    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
		
       while($row = $result->fetch_array()) {
            $myArray['RESULT'][] =$row; 
    }
	header('Content-Type: application/json; Charset=UTF-8');

    echo json_encode($myArray);
	  
	
       }
	   else
    {
		$row['id']='0';
		$myArray['RESULT'][] =$row;
	    echo json_encode($myArray);
	
      }
		 
			 
	   
  }
 
 ///////////////////user select
   else if($op == "user_select"){
 
  	 
	
	
	$result = $mysqli->query("SELECT *  FROM sna_user ");
    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
		
       while($row = $result->fetch_array()) {
            $myArray['RESULT'][] =$row; 
    }
	header('Content-Type: application/json; Charset=UTF-8');

    echo json_encode($myArray);
	  
	
       }
	   else
    {
		$row['id']='0';
		$myArray['RESULT'][] =$row;
	    echo json_encode($myArray);
	
      }
		 
			 
	   
  }
  ///////////////////user insert
   else if($op == "user_insert"){
        $nomp = $_GET["nomp"];
		$login = $_GET["login"];
		$pwd = $_GET["pwd"];
		$role_u = $_GET["role_u"];
		$email_u = $_GET["email_u"];
  	 
	
	
	$result = $mysqli->query("INSERT INTO sna_user (nomp, login,pwd,role_u,email_u) VALUES ('$nomp','$login','$pwd','$role_u','$email_u' )");
    $row['id']='1';
		$myArray['RESULT'][] =$row;
	    echo json_encode($myArray);
   
   
		 
			 
	   
  }
        ////////////////////////select reponse g    
   else if($op == "reponse_g"){
    $date_rech_deb= date("Y-m-d", strtotime($_GET['date_rech_deb']))." 00:00:00";
	$date_rech_fin= date("Y-m-d",strtotime($_GET['date_rech_fin']))." 23:59:59"; 
	$id_section=$_GET['id_section'];
  
	$result = $mysqli->query("SELECT sna_reponse_g.commentaire,sna_reponse_g.nomp, sna_reponse_g.date_sys,sna_reponse_g.id_module,sna_reponse_g.path_img, COUNT(CASE WHEN reponse = 'oui' THEN 1 ELSE NULL END ) AS oui, 
	COUNT(CASE WHEN reponse = 'non' THEN 1 ELSE NULL END ) AS non, 
	COUNT(CASE WHEN reponse <> 'non' AND reponse <> 'oui' THEN 1 ELSE NULL END ) AS autre, 
    COUNT(CASE WHEN observation <> '' THEN 1 ELSE NULL END ) AS observation, 
    id_reponse_g
     FROM sna_reponse
     INNER JOIN sna_reponse_g ON sna_reponse.id_reponse_g = sna_reponse_g.id where sna_reponse_g.date_sys BETWEEN '$date_rech_deb'  AND '$date_rech_fin' AND sna_reponse_g.id_section='$id_section'
GROUP BY id_reponse_g");
     
		
	
    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
		
       while($row = $result->fetch_array()) {
            $myArray['RESULT'][] =$row; 
    }
	header('Content-Type: application/json; Charset=UTF-8');

    echo json_encode($myArray);
	  
	
       }
	   else
    {
		$row['id_reponse_g']='0';
		$myArray['RESULT'][] =$row;
	    echo json_encode($myArray);
	
      }
	
   
		 
			 
	   
  }
  
  ///////////// REPONSE IMP
 else if($op == "reponse_imp"){
    
  	$id_reponse_g= $_GET['id_reponse_g']; 
	
	$result = $mysqli->query("SELECT sna_reponse_g.id, sna_question.question, sna_reponse.reponse, sna_reponse.observation,sna_question.order_question,path_pj
FROM sna_reponse_g
INNER JOIN sna_reponse ON sna_reponse.id_reponse_g = sna_reponse_g.id
INNER JOIN sna_question ON sna_question.id = sna_reponse.id_question
WHERE sna_reponse_g.id ='$id_reponse_g'
ORDER BY sna_question.order_question");

    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
		
       while($row = $result->fetch_array()) {
            $myArray['RESULT'][] =$row; 
    }
	header('Content-Type: application/json; Charset=UTF-8');

    echo json_encode($myArray);
	  
	
       }
	   else
    {
		$row['id_reponse_g']='0';
		$myArray['RESULT'][] =$row;
	    echo json_encode($myArray);
	
      }
 }
     ///////////// liste posteAcceuil
 else if($op == "poste_acceuil"){
    
  	
	$result = $mysqli->query("SELECT *
FROM sna_posteAcceuil");

    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
		
       while($row = $result->fetch_array()) {
            $myArray['RESULT'][] =$row; 
    }
	header('Content-Type: application/json; Charset=UTF-8');

    echo json_encode($myArray);
	  
	
       }
	   else
    {
		$row['id_reponse_g']='0';
		$myArray['RESULT'][] =$row;
	    echo json_encode($myArray);
	
      }
	  
 }////////////////////////////////////////////// 
 else if($op=="nvx_question_audit"){
	 if ( isset($_POST['question']) )
         {
	$question = $_POST['question'];
	$order_ques = $_POST['order_ques'];
	$type_ques = $_POST['type_ques'];
	$id_module = $_POST['id_module'];
	
	
	
	 $mysqli->query("INSERT INTO sna_module_audite_question (question, order_question,type_question,id_module_lieu) VALUES ('$question','$order_ques','$type_ques','$id_module')");
          $row['succe']=1;
    $myArray['RESULT'][] = $row;
	   echo json_encode($myArray);
		 }
	
  } else if($op=="liste_sna_module_audite_lieu"){
////////////////////// Lire tout section

	$id_lieu=$_GET['id_lieu'];
	$result = $mysqli->query("SELECT * FROM sna_module_audite_lieu where id_lieu='$id_lieu'");
    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
		
       while($row = $result->fetch_array()) {
            $myArray['RESULT'][] =$row; 
    }
	
    echo json_encode($myArray);
	  
	
       }
	   else
    {
	    echo json_encode("99");
	
      }
	
  } 
  
  else if($op=="questionAuditeLieuBymodule"){
    ///////// select question by module
  
	  $id_module_lieu = $_GET["id_module_lieu"];
	
	$result = $mysqli->query("SELECT * FROM sna_module_audite_question where id_module_lieu='$id_module_lieu' ");
    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
		
       while($row = $result->fetch_array()) {
            $myArray['RESULT'][] =$row; 
    }
	header('Content-Type: application/json; Charset=UTF-8');

    echo json_encode($myArray);
	  
	
       }
	   else
    {
	    echo json_encode("99");
	
      }
	
  }
  else if($op=="listelieu"){
    ///////// select liste lieu
	 
	
	$result = $mysqli->query("SELECT * FROM sna_module_audite_lieu_name");
    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
		
       while($row = $result->fetch_array()) {
            $myArray['RESULT'][] =$row; 
    }
	header('Content-Type: application/json; Charset=UTF-8');

    echo json_encode($myArray);
	  
	
       }
	   else
    {
	    echo json_encode("99");
	
      }
	
  }
  else if($op == "insertReponseAuditLieu"){
      $values_g=str_replace('1#1', "'", $_POST['reponses_g']);
	  $result =$mysqli->query("INSERT INTO sna_module_audite_reponse_g(nomp,date_sys,id_module,id_lieu,commentaire,ligne,poste_t) values ".$values_g) ;      
      $lastInsertedPeopleId = mysqli_insert_id($mysqli);
	  
	  if (!empty ($_FILES)){
	   $file_name = $_FILES['fileToUpload']['name'];
         $dir ='../RFS/uploads/';
		 $file_path= $dir.$lastInsertedPeopleId.basename($_FILES['fileToUpload']['name']); 
		 if(move_uploaded_file($_FILES['fileToUpload']['tmp_name'],$file_path)){
			
			
		 $mysqli->query("update sna_module_audite_reponse_g set path_img='$file_path' where id='$lastInsertedPeopleId'" );

			} 
	  }
 
	  $values=str_replace('1#1', "'", $_POST['reponses']);
	  $values=str_replace('keygh',$lastInsertedPeopleId, $values);
	  $result =$mysqli->query("INSERT INTO sna_module_audite_reponse(id_question,reponse,nomp,dateh_rep,observation,id_module,date_inser,id_reponse_g,path_pj) values ".$values) ;
	  //echo $result ;
	 //$result ="INSERT INTO sna_reponse(id_question,reponse,nomp,dateh_rep,observation,id_module) values ".$values ;
          if($result){
			 $row['lastID']=$lastInsertedPeopleId;
    $myArray['RESULT'][] = $row;
	   echo json_encode($myArray);
            			
		 }else{
		       echo json_encode(0);
		 }
			 
	   
  }
   else if($op=="liste_sna_module_equipement"){
////////////////////// Lire tout section

	
	$result = $mysqli->query("SELECT * FROM sna_module_equipement ");
    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
		
       while($row = $result->fetch_array()) {
		    $myArray['RESULT'][] =$row; 
           // $myArray['RESULT'][] = $row;
    }
	
    echo json_encode($myArray);
	  
	
       }
	   else
    {
	    echo json_encode("99");
	
      }
	
  } 
  ////////////////////////////////////////////// 
 else if($op=="nvx_question_equipement"){
	 if ( isset($_POST['question']) )
         {
	$question = $_POST['question'];
	$order_ques = $_POST['order_ques'];
	$type_ques = $_POST['type_ques'];
	$id_module = $_POST['id_module'];
	
	
	
	 $mysqli->query("INSERT INTO sna_module_equipement_question (question, order_question,type_question,id_module_equipement) VALUES ('$question','$order_ques','$type_ques','$id_module')");
          $row['succe']=1;
    $myArray['RESULT'][] = $row;
	   echo json_encode($myArray);
		 }
	
  }
    else if($op=="liste_sna_question_equipement"){
////////////////////// Lire tout question equipement
 
	$id_module = $_GET['id_module_equipement'];
	$result = $mysqli->query("SELECT * FROM sna_module_equipement_question where id_module_equipement = '$id_module' order by order_question ");
    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
		
       while($row = $result->fetch_array()) {
		    $myArray['RESULT'][] =$row; 
           // $myArray['RESULT'][] = $row;
    }
	
    echo json_encode($myArray);
	  
	
       }
	   else
    {
	    echo json_encode("99");
	
      }
	
  } 
	 ////////////////////////////////////////////// 
 else if($op=="nvx_question_audit5s"){
	 if ( isset($_POST['question']) )
         {
	$question = $_POST['question'];
	$order_ques = $_POST['order_ques'];
	$type_ques = $_POST['type_ques'];
	$id_module = $_POST['id_module'];
	
	
	
	 $mysqli->query("INSERT INTO sna_audit_5s_question (question, order_question,type_question,id_module) VALUES ('$question','$order_ques','$type_ques','$id_module')");
          $row['succe']=1;
    $myArray['RESULT'][] = $row;
	   echo json_encode($myArray);
		 }
	
  }	 
	    else if($op=="liste_sna_question_audit5s"){
////////////////////// Lire tout question audit 5s 
 
	
	$result = $mysqli->query("SELECT * FROM sna_audit_5s_question  order by order_question ");
    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
		
       while($row = $result->fetch_array()) {
		    $myArray['RESULT'][] =$row; 
           // $myArray['RESULT'][] = $row;
    }
	
    echo json_encode($myArray);
	  
	
       }
	   else
    {
	    echo json_encode("99");
	
      }
	
  } 	
	 ////////////////////////////////////////////// 
 else if($op=="nvx_question_documentaire"){
	 if ( isset($_POST['question']) )
         {
	$question = $_POST['question'];
	$order_ques = $_POST['order_ques'];
	$type_ques = $_POST['type_ques'];
	$id_module = $_POST['id_module'];
	
	
	
	 $mysqli->query("INSERT INTO sna_documentaire (question, order_question,type_question,id_module) VALUES ('$question','$order_ques','$type_ques','$id_module')");
          $row['succe']=1;
    $myArray['RESULT'][] = $row;
	   echo json_encode($myArray);
		 }
	
  }	
	    else if($op=="liste_sna_question_documentaire"){
////////////////////// Lire tout question audit 5s 
 
	
	$result = $mysqli->query("SELECT * FROM sna_documentaire  order by order_question ");
    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
		
       while($row = $result->fetch_array()) {
		    $myArray['RESULT'][] =$row; 
           // $myArray['RESULT'][] = $row;
    }
	
    echo json_encode($myArray);
	  
	
       }
	   else
    {
	    echo json_encode("99");
	
      }
	
  }   
         ///////////////// verifExistAuditLieu
    /*else if($op == "verifExistAuditLieu"){
     $date_rech = $_GET["date_rech"];
	  $nomp = $_GET["nomp"];
	  $id_module = $_GET["id_module"];
	
	             $result = $mysqli->query("   SELECT *
FROM sna_module_audite_reponse_g
INNER JOIN sna_module_audite_reponse ON sna_module_audite_reponse_g.id = sna_module_audite_reponse.id_reponse_g where dateh_rep='$date_rech' and nomp='$nomp' and id_module='$id_module'"); 
    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
		
       while($row = $result->fetch_array()) {
            $myArray['RESULT'][] =$row; 
    }
	header('Content-Type: application/json; Charset=UTF-8');

    echo json_encode($myArray);
	  
	
       }
	   else
    {
		$row['id']='0';
		$myArray['RESULT'][] =$row;
	    echo json_encode($myArray);
	
      }
			 
	   
  }*/
  ////////////////// insert Equipement
    else if($op == "insertReponseEquipement"){
      $values_g=str_replace('1#1', "'", $_POST['reponses_g']);
	  $result =$mysqli->query("INSERT INTO sna_module_equipement_reponse_g(nomp,date_sys,id_module,id_lieu,commentaire) values ".$values_g) ;      
	  
      $lastInsertedPeopleId = mysqli_insert_id($mysqli);
	  
	  if (!empty ($_FILES)){
	   $file_name = $_FILES['fileToUpload']['name'];
         $dir ='../RFS/uploads/';
		 $file_path= $dir.$lastInsertedPeopleId.basename($_FILES['fileToUpload']['name']); 
		 if(move_uploaded_file($_FILES['fileToUpload']['tmp_name'],$file_path)){
			
			
		 $mysqli->query("update sna_module_equipement_reponse_g set path_img='$file_path' where id='$lastInsertedPeopleId'" );

			} 
	  }
	  
 
	  $values=str_replace('1#1', "'", $_POST['reponses']);
	  $values=str_replace('keygh',$lastInsertedPeopleId, $values);
	  $result =$mysqli->query("INSERT INTO sna_module_equipement_reponse(id_question,reponse,nomp,dateh_rep,observation,id_module,date_inser,id_reponse_g,path_pj) values ".$values) ;
	  //echo $result ;
	 //$result ="INSERT INTO sna_reponse(id_question,reponse,nomp,dateh_rep,observation,id_module) values ".$values ;
           if($result){
			 $row['lastID']=$lastInsertedPeopleId;
    $myArray['RESULT'][] = $row;
	   echo json_encode($myArray);
            			
		 }else{
		       echo json_encode(0);
		 }
			 
	   
  }
   ////////////////// insert Audit5s
    else if($op == "insertReponseAudit5s"){
      $values_g=str_replace('1#1', "'", $_POST['reponses_g']);
	  $result =$mysqli->query("INSERT INTO sna_audit_5s_reponse_g(nomp,date_sys,id_module,id_lieu,commentaire,ligne,poste_t) values ".$values_g) ;      
	  
      $lastInsertedPeopleId = mysqli_insert_id($mysqli);
	  if (!empty ($_FILES)){
	  
  $file_name = $_FILES['fileToUpload']['name'];
         $dir ='../RFS/uploads/';
		 $file_path= $dir.$lastInsertedPeopleId.basename($_FILES['fileToUpload']['name']); 
		 if(move_uploaded_file($_FILES['fileToUpload']['tmp_name'],$file_path)){
			
			
		 $mysqli->query("update sna_audit_5s_reponse_g set path_img='$file_path' where id='$lastInsertedPeopleId'" );

			}
	  }			
	  $values=str_replace('1#1', "'", $_POST['reponses']);
	  $values=str_replace('keygh',$lastInsertedPeopleId, $values);
	  $result =$mysqli->query("INSERT INTO sna_audit_5s_reponse(id_question,reponse,nomp,dateh_rep,observation,id_module,date_inser,id_reponse_g,path_pj) values ".$values) ;
	  //echo $result ;
	 //$result ="INSERT INTO sna_reponse(id_question,reponse,nomp,dateh_rep,observation,id_module) values ".$values ;
          if($result){
			 $row['lastID']=$lastInsertedPeopleId;
    $myArray['RESULT'][] = $row;
	   echo json_encode($myArray);
            			
		 }else{
		       echo json_encode(0);
		 }
	   
  }
    ////////////////// insert documentaire
    else if($op == "insertReponseDoc"){
      $values_g=str_replace('1#1', "'", $_POST['reponses_g']);
	  $result =$mysqli->query("INSERT INTO sna_documentaire_reponse_g(nomp,date_sys,id_module,id_lieu,commentaire,ligne,poste_t) values ".$values_g) ;      
	  
      $lastInsertedPeopleId = mysqli_insert_id($mysqli);
	  
	  if (!empty ($_FILES)){
	   $file_name = $_FILES['fileToUpload']['name'];
         $dir ='../RFS/uploads/';
		 $file_path= $dir.$lastInsertedPeopleId.basename($_FILES['fileToUpload']['name']); 
		 if(move_uploaded_file($_FILES['fileToUpload']['tmp_name'],$file_path)){
			
			
		 $mysqli->query("update sna_documentaire_reponse_g set path_img='$file_path' where id='$lastInsertedPeopleId'" );

			} 
	  }
 
	  $values=str_replace('1#1', "'", $_POST['reponses']);
	  $values=str_replace('keygh',$lastInsertedPeopleId, $values);
	  $result =$mysqli->query("INSERT INTO sna_documentaire_reponse(id_question,reponse,nomp,dateh_rep,observation,id_module,date_inser,id_reponse_g,path_pj) values ".$values) ;
	  //echo $result ;
	 //$result ="INSERT INTO sna_reponse(id_question,reponse,nomp,dateh_rep,observation,id_module) values ".$values ;
          if($result){
			 $row['lastID']=$lastInsertedPeopleId;
    $myArray['RESULT'][] = $row;
	   echo json_encode($myArray);
            			
		 }else{
		       echo json_encode(0);
		 }
			 
	   
  }
  ///////////////////////reponse Audit 5s
   else if($op == "reponse_gAudit5s"){
    
  	$date_rech_deb= date("Y-m-d", strtotime($_GET['date_rech_deb']))." 00:00:00";
	$date_rech_fin= date("Y-m-d",strtotime($_GET['date_rech_fin']))." 23:59:59"; ; 
	
	$result = $mysqli->query("SELECT sna_audit_5s_reponse_g.id_lieu,sna_audit_5s_reponse_g.commentaire,sna_audit_5s_reponse_g.nomp, sna_audit_5s_reponse_g.date_sys,sna_audit_5s_reponse_g.id_module,sna_audit_5s_reponse_g.path_img, COUNT(CASE WHEN reponse = 'Ok' THEN 1 ELSE NULL END ) AS oui, 
	COUNT(CASE WHEN reponse = 'NOk' THEN 1 ELSE NULL END ) AS non, 
	COUNT(CASE WHEN reponse <> 'NOk' AND reponse <> 'Ok' AND reponse <> '' THEN 1 ELSE NULL END ) AS autre, 
    COUNT(CASE WHEN observation <> '' THEN 1 ELSE NULL END ) AS observation, 
    id_reponse_g
     FROM  sna_audit_5s_reponse
     INNER JOIN sna_audit_5s_reponse_g ON  sna_audit_5s_reponse.id_reponse_g = sna_audit_5s_reponse_g.id where sna_audit_5s_reponse_g.date_sys BETWEEN  '$date_rech_deb'  AND '$date_rech_fin'
GROUP BY id_reponse_g");

    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
		
       while($row = $result->fetch_array()) {
            $myArray['RESULT'][] =$row; 
    }
	header('Content-Type: application/json; Charset=UTF-8');

    echo json_encode($myArray);
	  
	
       }
	   else
    {
		$row['id_reponse_g']='0';
		$myArray['RESULT'][] =$row;
	    echo json_encode($myArray);
	
      }
	
   
		 
			 
	   
  }
  ///////////// REPONSE IMP AUDIT 5D
 else if($op == "reponse_imp_audit5S"){
    
  	$id_reponse_g= $_GET['id_reponse_g']; 
	
	$result = $mysqli->query("SELECT  sna_audit_5s_reponse_g.id, sna_audit_5s_question.question, sna_audit_5s_reponse.reponse, sna_audit_5s_reponse.observation,sna_audit_5s_question.order_question,sna_audit_5s_reponse.path_pj
FROM  sna_audit_5s_reponse_g
INNER JOIN sna_audit_5s_reponse ON sna_audit_5s_reponse.id_reponse_g =  sna_audit_5s_reponse_g.id
INNER JOIN sna_audit_5s_question ON sna_audit_5s_question.id = sna_audit_5s_reponse.id_question
WHERE  sna_audit_5s_reponse_g.id ='$id_reponse_g'
ORDER BY sna_audit_5s_question.order_question");

    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
		
       while($row = $result->fetch_array()) {
            $myArray['RESULT'][] =$row; 
    }
	header('Content-Type: application/json; Charset=UTF-8');

    echo json_encode($myArray);
	  
	
       }
	   else
    {
		$row['id_reponse_g']='0';
		$myArray['RESULT'][] =$row;
	    echo json_encode($myArray);
	
      }
 }
  ///////////////////////reponse Documentaire
   else if($op == "reponse_gDocumentaire"){
    
  	$date_rech_deb= date("Y-m-d", strtotime($_GET['date_rech_deb']))." 00:00:00";
	$date_rech_fin= date("Y-m-d",strtotime($_GET['date_rech_fin']))." 23:59:59"; ; 
	
	$result = $mysqli->query("SELECT sna_documentaire_reponse_g.id_lieu,sna_documentaire_reponse_g.commentaire,sna_documentaire_reponse_g.nomp, sna_documentaire_reponse_g.date_sys,sna_documentaire_reponse_g.id_module,sna_documentaire_reponse_g.path_img, COUNT(CASE WHEN reponse = 'Valable' THEN 1 ELSE NULL END ) AS oui, 
	COUNT(CASE WHEN reponse = 'Necessite maj' THEN 1 ELSE NULL END ) AS non, 
	COUNT(CASE WHEN reponse = 'Manquant' THEN 1 ELSE NULL END ) AS autre, 
    COUNT(CASE WHEN observation <> '' THEN 1 ELSE NULL END ) AS observation, 
    id_reponse_g
     FROM  sna_documentaire_reponse
     INNER JOIN sna_documentaire_reponse_g ON  sna_documentaire_reponse.id_reponse_g = sna_documentaire_reponse_g.id where sna_documentaire_reponse_g.date_sys BETWEEN  '$date_rech_deb'  AND '$date_rech_fin'
GROUP BY id_reponse_g");

    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
		
       while($row = $result->fetch_array()) {
            $myArray['RESULT'][] =$row; 
    }
	header('Content-Type: application/json; Charset=UTF-8');

    echo json_encode($myArray);
	  
	
       }
	   else
    {
		$row['id_reponse_g']='0';
		$myArray['RESULT'][] =$row;
	    echo json_encode($myArray);
	
      }
	
   
		 
			 
	   
  }
  ///////////// REPONSE IMP Documentaire
 else if($op == "reponse_imp_documentaire"){
    
  	$id_reponse_g= $_GET['id_reponse_g']; 
	
	$result = $mysqli->query("SELECT  sna_documentaire_reponse_g.id, sna_documentaire.question, sna_documentaire_reponse.reponse, sna_documentaire_reponse.observation,sna_documentaire.order_question,sna_documentaire_reponse.path_pj
FROM  sna_documentaire_reponse_g
INNER JOIN sna_documentaire_reponse ON sna_documentaire_reponse.id_reponse_g =  sna_documentaire_reponse_g.id
INNER JOIN sna_documentaire ON sna_documentaire.id = sna_documentaire_reponse.id_question
WHERE  sna_documentaire_reponse_g.id ='$id_reponse_g'
ORDER BY sna_documentaire.order_question");

    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
		
       while($row = $result->fetch_array()) {
            $myArray['RESULT'][] =$row; 
    }
	header('Content-Type: application/json; Charset=UTF-8');

    echo json_encode($myArray);
	  
	
       }
	   else
    {
		$row['id_reponse_g']='0';
		$myArray['RESULT'][] =$row;
	    echo json_encode($myArray);
	
      }
 }
     ////////////////////////select reponse g    
   else if($op == "reponse_g_equipement"){
    $date_rech_deb= date("Y-m-d", strtotime($_GET['date_rech_deb']))." 00:00:00";
	$date_rech_fin= date("Y-m-d",strtotime($_GET['date_rech_fin']))." 23:59:59"; 
	$id_section=$_GET['id_section'];
	
  
	$result = $mysqli->query("SELECT   sna_module_equipement_reponse_g.commentaire, sna_module_equipement_reponse_g.nomp,   sna_module_equipement_reponse_g.date_sys,  sna_module_equipement_reponse_g.id_module,sna_module_equipement_reponse_g.path_img, COUNT(CASE WHEN reponse = 'Ok' THEN 1 ELSE NULL END ) AS oui, 
	COUNT(CASE WHEN reponse = 'NOk' THEN 1 ELSE NULL END ) AS non, 
	COUNT(CASE WHEN reponse <> 'NOk' AND reponse <> 'Ok' THEN 1 ELSE NULL END ) AS autre, 
    COUNT(CASE WHEN observation <> '' THEN 1 ELSE NULL END ) AS observation, 
    id_reponse_g
     FROM sna_module_equipement_reponse
     INNER JOIN   sna_module_equipement_reponse_g ON sna_module_equipement_reponse.id_reponse_g =   sna_module_equipement_reponse_g.id where   sna_module_equipement_reponse_g.date_sys BETWEEN '$date_rech_deb'  AND '$date_rech_fin' AND sna_module_equipement_reponse_g.id_lieu='$id_section'
GROUP BY id_reponse_g");
     
		
	
    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
		
       while($row = $result->fetch_array()) {
            $myArray['RESULT'][] =$row; 
    }
	header('Content-Type: application/json; Charset=UTF-8');

    echo json_encode($myArray);
	  
	
       }
	   else
    {
		$row['id_reponse_g']='0';
		$myArray['RESULT'][] =$row;
	    echo json_encode($myArray);
	
      }
	
   
		 
			 
	   
  }
 
 ////////////////////// imp equipement
  else if($op == "reponse_imp_equipement"){
    
  	$id_reponse_g= $_GET['id_reponse_g']; 
	
	$result = $mysqli->query("SELECT sna_module_equipement_reponse_g.id,  sna_module_equipement_question.question, sna_module_equipement_reponse.reponse, sna_module_equipement_reponse.observation, sna_module_equipement_question.order_question,sna_module_equipement_reponse.path_pj
FROM sna_module_equipement_reponse_g
INNER JOIN sna_module_equipement_reponse ON sna_module_equipement_reponse.id_reponse_g = sna_module_equipement_reponse_g.id
INNER JOIN  sna_module_equipement_question ON  sna_module_equipement_question.id = sna_module_equipement_reponse.id_question
WHERE sna_module_equipement_reponse_g.id ='$id_reponse_g'
ORDER BY  sna_module_equipement_question.order_question");

    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
		
       while($row = $result->fetch_array()) {
            $myArray['RESULT'][] =$row; 
    }
	header('Content-Type: application/json; Charset=UTF-8');

    echo json_encode($myArray);
	  
	
       }
	   else
    {
		$row['id_reponse_g']='0';
		$myArray['RESULT'][] =$row;
	    echo json_encode($myArray);
	
      }
 }
 //////////////////////////////// Reponse g Audit lieu
 else if($op == "reponse_g_AuditLieu"){
    $date_rech_deb= date("Y-m-d", strtotime($_GET['date_rech_deb']))." 00:00:00";
	$date_rech_fin= date("Y-m-d",strtotime($_GET['date_rech_fin']))." 23:59:59"; 
	$id_section=$_GET['id_section'];
  
	$result = $mysqli->query("SELECT sna_module_audite_reponse_g.commentaire,sna_module_audite_reponse_g.nomp, sna_module_audite_reponse_g.date_sys,sna_module_audite_reponse_g.id_module,sna_module_audite_reponse_g.path_img, COUNT(CASE WHEN reponse = 'Ok' THEN 1 ELSE NULL END ) AS oui, 
	COUNT(CASE WHEN reponse = 'NOk' THEN 1 ELSE NULL END ) AS non, 
	COUNT(CASE WHEN reponse <> 'NOk' AND reponse <> 'Ok' THEN 1 ELSE NULL END ) AS autre, 
    COUNT(CASE WHEN observation <> '' THEN 1 ELSE NULL END ) AS observation, 
    id_reponse_g
     FROM sna_module_audite_reponse
     INNER JOIN sna_module_audite_reponse_g ON sna_module_audite_reponse.id_reponse_g = sna_module_audite_reponse_g.id where sna_module_audite_reponse_g.date_sys BETWEEN '$date_rech_deb'  AND '$date_rech_fin' AND sna_module_audite_reponse_g.id_lieu='$id_section'
GROUP BY id_reponse_g");
     
		
	
    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
		
       while($row = $result->fetch_array()) {
            $myArray['RESULT'][] =$row; 
    }
	header('Content-Type: application/json; Charset=UTF-8');

    echo json_encode($myArray);
	  
	
       }
	   else
    {
		$row['id_reponse_g']='0';
		$myArray['RESULT'][] =$row;
	    echo json_encode($myArray);
	
      }
	
   
		 
			 
	   
  }
 
 ////////////////////// imp AUDIT LIEU
  else if($op == "reponse_imp_audit_lieu"){
    
  	$id_reponse_g= $_GET['id_reponse_g']; 
	
	$result = $mysqli->query("SELECT sna_module_audite_reponse_g.id,  sna_module_audite_question.question, sna_module_audite_reponse.reponse, sna_module_audite_reponse.observation, sna_module_audite_question.order_question,sna_module_audite_reponse.path_pj
FROM sna_module_audite_reponse_g
INNER JOIN sna_module_audite_reponse ON sna_module_audite_reponse.id_reponse_g = sna_module_audite_reponse_g.id
INNER JOIN  sna_module_audite_question ON  sna_module_audite_question.id = sna_module_audite_reponse.id_question
WHERE sna_module_audite_reponse_g.id ='$id_reponse_g'
ORDER BY  sna_module_audite_question.order_question");

    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
		
       while($row = $result->fetch_array()) {
            $myArray['RESULT'][] =$row; 
    }
	header('Content-Type: application/json; Charset=UTF-8');

    echo json_encode($myArray);
	  
	
       }
	   else
    {
		$row['id_reponse_g']='0';
		$myArray['RESULT'][] =$row;
	    echo json_encode($myArray);
	
      }
 }else if($op == "insertMail"){
      $mailu=$_GET['mailu'];
	  $result =$mysqli->query("INSERT INTO sna_mail_conf(mail_u) values('$mailu')") ;      
                  
         if($result){
			echo json_encode(12);
            			
		 }else{
		       echo json_encode(0);
		 }
			 
	   
  }
  else if($op == "listMail"){
     $result = $mysqli->query("SELECT *  FROM sna_mail_conf ");
    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
		
       while($row = $result->fetch_array()) {
            $myArray['RESULT'][] =$row; 
    }
	header('Content-Type: application/json; Charset=UTF-8');

    echo json_encode($myArray);
	  
	
       }
	   else
    {
		$row['id']='0';
		$myArray['RESULT'][] =$row;
	    echo json_encode($myArray);
	
      }
			 
	   
  }
else if($op == "deletMail"){
	$id=$_GET['id'];
     $result = $mysqli->query("delete FROM sna_mail_conf where id='$id' ");
     $result = $mysqli->query("Delete from sna_mail_grp_conf where id_mail= '$id' ");
                 
         if($result){
			echo json_encode(12);
            			
		 }else{
		       echo json_encode(0);
		 }
	
  }
  
  else if($op == "updateQuestion"){
	$id=$_POST['id'];
	$table=$_POST['table'];
	$question=addslashes(utf8_encode(($_POST['question'])));
	$order=$_POST['order'];
	$type=$_POST['type'];
	$result = $mysqli->query("update $table set question='$question',order_question='$order',type_question='$type' where id='$id' ");
      
                 
         if($result){
			echo json_encode(1);
            			
		 }else{
		       echo json_encode(0);
		 }
	
  }
   else if($op == "AjoutQuestion"){
	$id_module=$_POST['id_module'];
	$table=$_POST['table'];
	$question=addslashes(utf8_encode(($_POST['question'])));
	$order=$_POST['order'];
	$type=$_POST['type'];
	$id_module_name=$_POST['id_module_name'];
	$result = $mysqli->query("INSERT INTO  $table (question,order_question,type_question,$id_module_name) values('$question','$order','$type','$id_module') ");
      
                 
         if($result){
			echo json_encode(1);
            			
		 }else{
		       echo json_encode(0);
		 }
	
  }
    else if($op == "DeleteQuestion"){
	
	 $id=str_replace('1#1', "'", $_POST['id']);
	$table=$_POST['table'];
	
	$result = $mysqli->query("DELETE FROM  $table WHERE id IN ($id)");
      
                 
         if($result){
			echo json_encode(1);
            			
		 }else{
		       echo json_encode(0);
		 }
	
  }
 else if($op == "deletcompte"){
	$id=$_GET['id'];
     $result = $mysqli->query("delete FROM sna_user where id='$id' ");
      
                 
         if($result){
			echo json_encode(12);
            			
		 }else{
		       echo json_encode(0);
		 }
	
  }
else if($op == "AjoutGrpEmail"){
	$groupe_name=$_POST['groupe_name'];
	
	$result = $mysqli->query("INSERT INTO  sna_mail_grp (groupe_name) values('$groupe_name') ");
      
                 
         if($result){
			echo json_encode(1);
            			
		 }else{
		       echo json_encode(0);
		 }
	
  } 
  else if($op == "SelectGrpEmail"){

	$result = $mysqli->query("SELECT * FROM sna_mail_grp  ");
    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
		
       while($row = $result->fetch_array()) {
            $myArray['RESULT'][] =$row; 
    }
	header('Content-Type: application/json; Charset=UTF-8');

    echo json_encode($myArray);
	  
	
       }
	   else
    {
	    echo json_encode("99");
	
      }
	
  } else if($op == "ModifGrpEmail"){
	$id=$_POST['id'];
	$grpname = $_POST['grpname'];
	
	$result = $mysqli->query("update sna_mail_grp set groupe_name ='$grpname' where id= '$id' ");
      
                 
         if($result){
			echo json_encode(1);
            			
		 }else{
		       echo json_encode(0);
		 }
	
  }else if($op == "DeleteGrpEmail"){
	$id=$_GET['id'];
	
	
	$result = $mysqli->query("Delete from sna_mail_grp where id= '$id' ");
	$result = $mysqli->query("Delete from sna_mail_grp_conf where id_grp= '$id' ");
      
                 
         if($result){
			echo json_encode(1);
            			
		 }else{
		       echo json_encode(0);
		 }
	
  }
  else if($op == "insertMailGrp"){
      $mail_grp=str_replace('1#1', "'", $_POST['mail_grp']);
	  $result =$mysqli->query("INSERT INTO sna_mail_grp_conf(id_mail,id_grp,mail_u) values ".$mail_grp) ;      
   
         if($result){
			echo json_encode(1);
            			
		 }else{
		       echo json_encode(0);
		 }
			 
	   
  }else if($op == "SelectGrpEmailParGrp"){
     $id_grp = $_GET['id_grp'];
	$result = $mysqli->query("SELECT * FROM sna_mail_grp_conf where id_grp='$id_grp' ");
    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
		
       while($row = $result->fetch_array()) {
            $myArray['RESULT'][] =$row; 
    }
	header('Content-Type: application/json; Charset=UTF-8');

    echo json_encode($myArray);
	  
	
       }
	   else
    {
	    echo json_encode("100");
	
      }
	
  }else if($op == "deletMailconf"){
	$id=$_GET['id'];

	$result = $mysqli->query("Delete from sna_mail_grp_conf where id= '$id' ");
      
                 
         if($result){
			echo json_encode(1);
            			
		 }else{
		       echo json_encode(0);
		 }
	
  }
 else if($op == "SelectToutGrpEmail"){
    
	$result = $mysqli->query("SELECT * FROM sna_mail_grp_conf  ");
    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
		
       while($row = $result->fetch_array()) {
            $myArray['RESULT'][] =$row; 
    }
	header('Content-Type: application/json; Charset=UTF-8');

    echo json_encode($myArray);
	  
	
       }
	   else
    {
	    echo json_encode("100");
	
      }
	
  }
    ////////////////////////Toute non conformite 
   else if($op == "toute_non_conformite"){
	   $myArray = array();
	   //Audit ligne
    $date_rech_deb= date("Y-m-d", strtotime($_GET['date_rech_deb']))." 00:00:00";
	$date_rech_fin= date("Y-m-d",strtotime($_GET['date_rech_fin']))." 23:59:59"; 
	
  
	$result = $mysqli->query("SELECT   *
     FROM sna_reponse_g
     INNER JOIN   sna_module ON sna_reponse_g.id_module =   sna_module.id_module
	 INNER JOIN   sna_section ON sna_reponse_g.id_section =   sna_section.id_section
	 INNER JOIN   sna_reponse ON sna_reponse_g.id =   sna_reponse.id_reponse_g
     INNER JOIN   sna_question ON sna_question.id =   sna_reponse.id_question 

	 where   sna_reponse_g.date_sys BETWEEN '$date_rech_deb'  AND '$date_rech_fin' AND sna_reponse.reponse='Non'
    order by sna_reponse_g.date_sys");
     
		

		
       while($row = $result->fetch_array()) {
		    $row['op']='reponse_imp';
			$row['audit']='Audit Ligne';
            $myArray['RESULT'][] =$row; 
    }
	
	//Audit HSE lieu de travaille
	$result = $mysqli->query("SELECT   *,sna_module_audite_reponse_g.id_lieu as id_section,nom as module,name as nom_section
     FROM sna_module_audite_reponse_g
     INNER JOIN   sna_module_audite_lieu ON sna_module_audite_reponse_g.id_module =   sna_module_audite_lieu.id
	 INNER JOIN   sna_module_audite_lieu_name ON sna_module_audite_reponse_g.id_lieu =   sna_module_audite_lieu_name.id
	 INNER JOIN   sna_module_audite_reponse ON sna_module_audite_reponse_g.id =   sna_module_audite_reponse.id_reponse_g 
     INNER JOIN   sna_module_audite_question ON sna_module_audite_question.id =   sna_module_audite_reponse.id_question 
	 
	 where   sna_module_audite_reponse_g.date_sys BETWEEN '$date_rech_deb'  AND '$date_rech_fin' AND sna_module_audite_reponse.reponse='NOk'
    order by sna_module_audite_reponse_g.date_sys");
     
		

		
       while($row = $result->fetch_array()) {
		   $row['op']='reponse_imp_audit_lieu';
		   $row['audit']='Inspection HSE(Lieu de travail)';
            $myArray['RESULT'][] =$row; 
    }
	//Audit HSE equipement
	
	$result = $mysqli->query("SELECT   * ,sna_module_equipement_reponse_g.id_lieu as id_section ,equipement as module,name as nom_section
     FROM sna_module_equipement_reponse_g
     INNER JOIN   sna_module_equipement ON sna_module_equipement_reponse_g.id_module =   sna_module_equipement.id
	 INNER JOIN   sna_module_audite_lieu_name ON sna_module_equipement_reponse_g.id_lieu =   sna_module_audite_lieu_name.id
	 INNER JOIN   sna_module_equipement_reponse ON sna_module_equipement_reponse_g.id =   sna_module_equipement_reponse.id_reponse_g 
     INNER JOIN   sna_module_equipement_question ON sna_module_equipement_question.id =   sna_module_equipement_reponse.id_question
	 
	 
	 where   sna_module_equipement_reponse_g.date_sys BETWEEN '$date_rech_deb'  AND '$date_rech_fin' AND sna_module_equipement_reponse.reponse='NOk'
    order by sna_module_equipement_reponse_g.date_sys");
     
		

		
       while($row = $result->fetch_array()) {
		    $row['op']='reponse_imp_equipement';
			 $row['audit']='Inspection HSE(equipement_outil)';
            $myArray['RESULT'][] =$row; 
    }
	
		//Audit 5s 
	
	$result = $mysqli->query("SELECT   * ,id_lieu as id_section ,name as nom_section
     FROM sna_audit_5s_reponse_g
	 INNER JOIN   sna_module_audite_lieu_name ON sna_audit_5s_reponse_g.id_lieu =   sna_module_audite_lieu_name.id
	 INNER JOIN   sna_audit_5s_reponse ON sna_audit_5s_reponse_g.id =   sna_audit_5s_reponse.id_reponse_g 
	  INNER JOIN   sna_audit_5s_question ON sna_audit_5s_question.id =   sna_audit_5s_reponse.id_question

	 where   sna_audit_5s_reponse_g.date_sys BETWEEN '$date_rech_deb'  AND '$date_rech_fin' AND sna_audit_5s_reponse.reponse='NOk'
    order by sna_audit_5s_reponse_g.date_sys");
     
		

		
       while($row = $result->fetch_array()) {
		    $row['op']='reponse_imp_audit5S';
			$row['audit']='Audit 5s';
            $myArray['RESULT'][] =$row; 
    }
   	//Audit documentaire
	
	$result = $mysqli->query("SELECT   * ,id_lieu as id_section ,name as nom_section
     FROM sna_documentaire_reponse_g
	 INNER JOIN   sna_module_audite_lieu_name ON sna_documentaire_reponse_g.id_lieu =   sna_module_audite_lieu_name.id
	 INNER JOIN   sna_documentaire_reponse ON sna_documentaire_reponse_g.id =   sna_documentaire_reponse.id_reponse_g 
     INNER JOIN   sna_documentaire ON sna_documentaire.id =   sna_documentaire_reponse.id_question
	 
	 where   sna_documentaire_reponse_g.date_sys BETWEEN '$date_rech_deb'  AND '$date_rech_fin' AND (sna_documentaire_reponse.reponse='Manquant' or sna_documentaire_reponse.reponse='Necessite maj')
    order by sna_documentaire_reponse_g.date_sys");
     
		

		
       while($row = $result->fetch_array()) {
		    $row['op']='reponse_imp_documentaire';
			$row['audit']='Audit Documentaire';
            $myArray['RESULT'][] =$row; 
    }
		 
	header('Content-Type: application/json; Charset=UTF-8');

	if(count($myArray) == 0){
            $row['id']='0';
            $myArray['RESULT'][] =$row; 
			 echo json_encode($myArray);
	}
else{
    echo json_encode($myArray);
} 		 
	   
  }else if($op=="insert_service_poste"){
	 
	$service_poste = $_POST['service_poste'];
	$table_name = $_POST['table_name'];
	
	
	
	
	 $mysqli->query("INSERT INTO $table_name (name) VALUES ('$service_poste')");
     
	
  } else if($op=="select_service_poste"){
	 
	
	$table_name = $_GET['table_name'];
	
	
	
	
	$result = $mysqli->query("SELECT * FROM $table_name ");
    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
		
       while($row = $result->fetch_array()) {
            $myArray['RESULT'][] = $row;
    }
	
    echo json_encode($myArray);
	  
	
       }
	   else
    {
	    echo json_encode("99");
	
      }
	
     
	
  }else if($op=="delete_service_poste"){
	 
	$id = $_POST['id'];
	$table_name = $_POST['table_name'];
	
	
	
	
	 $mysqli->query("Delete from $table_name where id ='$id'");
     
	
  } else if($op=="modifier_service_poste"){
	 
	$id = $_POST['id'];
	$table_name = $_POST['table_name'];
	$name = $_POST['name'];
	
	
	
	
	 $mysqli->query("update $table_name set name ='$name'  where id ='$id'");
     
	
  } else if($op=="insert_alert"){
	  

	  
		
	  
		
	$date_du = date("Y-m-d", strtotime($_POST['date_du']))." 00:00:00";
	$date_au = date("Y-m-d", strtotime($_POST['date_au']))." 00:00:00";
	$emetteur = $_POST['emetteur'];
	$service = $_POST['service'];
	$poste = $_POST['poste'];
	$objet_alert = $_POST['objet_alert'];
	$ligne_zone = $_POST['ligne_zone'];
	$produit = $_POST['produit'];
	$op_act = $_POST['op_act'];
	$situation = $_POST['situation'];
	
	
	
	 $mysqli->query("INSERT INTO  sna_alert_incident (date_du, date_au,emeteur,service_d,poste_d,objet_alert,ligne_zone,produit,op_act,situation,path_img,date_sys)
	 VALUES ('$date_du','$date_au','$emetteur','$service','$poste','$objet_alert','$ligne_zone','$produit','$op_act','$situation','',NOW())");
      $lastInsertedPeopleId = mysqli_insert_id($mysqli);      
          
		  if (!empty ($_FILES)){
     	  $file_name = $_FILES['fileToUpload']['name'];
         $dir ='../RFS/uploads/';
		 $file_path= $dir.$lastInsertedPeopleId.basename($_FILES['fileToUpload']['name']); 
		 if(move_uploaded_file($_FILES['fileToUpload']['tmp_name'],$file_path)){
			
			
		 $mysqli->query("update sna_alert_incident set path_img='$file_path' where id='$lastInsertedPeopleId'" );

			}  
		  }

	  $row['succe']=1;
    $myArray['RESULT'][] = $row;
	   echo json_encode($myArray);
		
	
  } else if($op=="select_alert"){
	 
	
	$date_du = date("Y-m-d", strtotime($_GET['date_du']))." 00:00:00";
	$date_au = date("Y-m-d", strtotime($_GET['date_au']))." 00:00:00";
	
	
	
	
	$result = $mysqli->query("SELECT * FROM sna_alert_incident where date_du BETWEEN '$date_du' AND '$date_au' OR date_au  BETWEEN '$date_du' AND '$date_au'  ");
    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
		
       while($row = $result->fetch_array()) {
            $myArray['RESULT'][] = $row;
    }
	
    echo json_encode($myArray);
	  
	
       }
	   else
    {
	    echo json_encode("99");
	
      }
	
     
	
  }else if($op=="insert_module"){
	 
	$module1 = addslashes(utf8_encode(($_POST['module1'])));
	$module2 = $_POST['module2'];
	$table_name = $_POST['table_name'];
	$colone1 = $_POST['colone1'];
	$colone2 = $_POST['colone2'];
	
	
	
	 $mysqli->query("INSERT INTO $table_name ($colone1,$colone2) VALUES ('$module1','$module2')");
     
	
  }else if($op=="delete_module"){
	 
	$id_name = $_POST['id_name'];
	$id = $_POST['id'];
	
	$table_name = $_POST['table_name'];

	
	
	
	 $mysqli->query("DELETE from $table_name where $id_name='$id' ");
     
	
  }else if($op=="update_module"){
	 
	$id_name = $_POST['id_name'];
	$id = $_POST['id'];
	
	$table_name = $_POST['table_name'];
	$module_name = $_POST['module_name'];
	$module = addslashes(utf8_encode($_POST['module']));

	
	
	
	 $mysqli->query("update  $table_name SET $module_name='$module' where $id_name='$id' ");
     
	
  }
  else if($op=="delete_reponse"){
	
	$id = $_POST['id'];
	
	$tablereponse_g = $_POST['tablereponse_g'];
	$table_reponse = $_POST['table_reponse'];


	
	
	 $mysqli->query("DELETE FROM  $tablereponse_g  where id='$id' ");
	 $mysqli->query("DELETE FROM  $table_reponse  where id_reponse_g='$id' ");
     
	
  }
   else if($op=="delete_Alert"){
	
	$id = $_POST['id'];
	
	 $mysqli->query("DELETE FROM  sna_alert_incident  where id='$id' ");
	
     
	
  }
  /// upload piece Joint pour chaque question
   else if($op=="upld_pj"){
	
	
	$file_name = $_FILES['fileToUpload']['name'];
         $dir ='../RFS/uploads/';
		  $newname = date('YmdHis',time()).basename($_FILES['fileToUpload']['name']); 
		 $file_path= $dir.$newname; 
		
		 if(move_uploaded_file($_FILES['fileToUpload']['tmp_name'],$file_path)){
			
			 $row['succe']=$file_path;
    $myArray['RESULT'][] = $row;
	   echo json_encode($myArray);
			

			}else{
				$row['succe']=0;
    $myArray['RESULT'][] = $row;
	   echo json_encode($myArray);
			}   
	
     
	
  }
 
?>