Gecko [ 196.203.21.74 ]

Name	Size	Permission
resultAff	[ DIR ]	drwxrwxrwx
NourWebService.php	61.33 KB	-rw-rw-rw-
NourWebService_bkp.php	46.32 KB	-rw-rw-rw-
NourWebService_bkp1.php	47.71 KB	-rw-rw-rw-
cnx.php	119 B	-rw-rw-rw-

Code Editor : NourWebService.php

<?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 (isset($_FILES['fileToUpload']) && $_FILES['fileToUpload']['error'] === UPLOAD_ERR_OK) {
	    $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");

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 (isset($_FILES['fileToUpload']) && $_FILES['fileToUpload']['error'] === UPLOAD_ERR_OK) {
	   $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'" );

$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 (isset($_FILES['fileToUpload']) && $_FILES['fileToUpload']['error'] === UPLOAD_ERR_OK) {

$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 (isset($_FILES['fileToUpload']) && $_FILES['fileToUpload']['error'] === UPLOAD_ERR_OK) {

$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 (isset($_FILES['fileToUpload']) && $_FILES['fileToUpload']['error'] === UPLOAD_ERR_OK) {

$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");

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

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

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

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

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

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=="insert_table"){
	 
	$name = addslashes(utf8_encode($_POST['name']));
	$table_name = $_POST['table_name'];
        $coloneName= $_POST['coloneName'];
	
	
	
	
	 $mysqli->query("INSERT INTO $table_name ($coloneName) VALUES ('$name')");
     
	
  }
else if($op=="insert_table_cvc"){
	 
	$emplacememnt = addslashes(utf8_encode($_POST['emplacememnt']));
	$ligne = addslashes(utf8_encode($_POST['ligne']));
       $machine = addslashes(utf8_encode($_POST['machine']));
     $typemachine = addslashes(utf8_encode($_POST['typemachine']));
 $prb = addslashes(utf8_encode($_POST['prb']));
	
	
	
	
	 $mysqli->query("INSERT INTO cvc (emplacement,ligne,machine,type_machine,probleme) VALUES ('$emplacememnt','$ligne','$machine','$typemachine','$prb')");
     
	
  }

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=="modifier_table"){
	 
	$id = $_POST['id'];
	$table_name = $_POST['table_name'];
	$name = addslashes(utf8_encode($_POST['name']));
	$coloneName = $_POST['coloneName'];
	
	
	
	 $mysqli->query("update $table_name set $coloneName ='$name'  where id ='$id'");
     
	
  } 
else if($op=="modifier_table_cvc"){
	 
			$id = addslashes(utf8_encode($_POST['id']));
			$ligne = addslashes(utf8_encode($_POST['ligne']));
			$machine = addslashes(utf8_encode($_POST['machine']));
			$typemachine = addslashes(utf8_encode($_POST['typemachine']));
			$prb = addslashes(utf8_encode($_POST['prb']));
			$emb = addslashes(utf8_encode($_POST['emb']));
	
	
	 $mysqli->query("update cvc set  emplacement='$emb' , ligne='$ligne' , machine='$machine' , type_machine='$typemachine', probleme='$prb' where id ='$id'");
     
	
  } 
  else if($op=="modifier_messangerGrp"){
	 
	$id = $_POST['id'];
	$table_name = $_POST['table_name'];
	$name = $_POST['name'];
	
	
	
	
	 $mysqli->query("update $table_name set groupe_id ='$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);      
      
     	  $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=="insert_user_grpMessanger"){
	 
	
	$grp_messanger = $_POST['grp_messanger'];
	$user_id = $_POST['user_id'];
	$user_name = $_POST['user_name'];
	
	
	
	
	 $mysqli->query("INSERT INTO sna_messanger_grp_user (id_user,nomp_user,group_messanger	) VALUES ('$user_id','$user_name','$grp_messanger')");
     
	
  } 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);
			}   
	
     
	
  }
   else if($op=="liste_message_grp"){
////////////////////// Lire message by groupe
    $date_du = date("Y-m-d", strtotime($_POST['date_du']))." 00:00:00";
	$id_grp=$_POST['grp_id'];
	
	$result = $mysqli->query("SELECT * FROM sna_messanger where grp='$id_grp' AND date_message>='$date_du'");
	
    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
			header('Content-Type: application/json; Charset=UTF-8');

$grp=$_POST['grp'];
	
	$result = $mysqli->query("SELECT * FROM sna_messanger_grp_user where group_messanger='$grp'");
	
    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
			header('Content-Type: application/json; Charset=UTF-8');

while($row = $result->fetch_array()) {
            $myArray['RESULT'][] = $row;
    }
	
    echo json_encode($myArray);
	  
	
       }
	   else
    {
	    echo json_encode(99009900);
		
	
      }
	
  }
   else if($op=="liste_message_user_grp"){

$user_id=$_POST['user_id'];
	
	$result = $mysqli->query("SELECT * FROM sna_messanger_grp_user where id_user='$user_id'");
	
    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
			header('Content-Type: application/json; Charset=UTF-8');

while($row = $result->fetch_array()) {
            $myArray['RESULT'][] = $row;
    }
	
    echo json_encode($myArray);
	  
	
       }
	   else
    {
	    echo json_encode(99009900);
		
	
      }
	
  }
  
  
  
  
  else if($op=="liste_message_grp_mot"){
////////////////////// Lire message by groupe
            $id_grp=$_POST['grp_id'];
	
			$mot_cle = mysqli_real_escape_string($mysqli,utf8_encode($_POST["mot_cle"]));

$result = $mysqli->query("SELECT * FROM sna_messanger where grp='$id_grp' AND message_ like '%$mot_cle%'");
	
    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
			header('Content-Type: application/json; Charset=UTF-8');

while($row = $result->fetch_array()) {
            $myArray['RESULT'][] = $row;
    }
	
    echo json_encode($myArray);
	  
	
       }
	   else
    {
	    echo json_encode(99009900);
		
	
      }
	
  }
  else if($op == "insert_message"){
        $nomp = $_POST["nomp"];
		$grp = $_POST["grp"];
		$message_ = mysqli_real_escape_string($mysqli,utf8_encode($_POST["message_"]));
		
		$path_pj = $_POST["path_pj"];
  	 
	
	
	$result = $mysqli->query("INSERT INTO sna_messanger (nomp,grp,message_,date_message,path_pj) VALUES ('$nomp','$grp','$message_',NOW(),'$path_pj' )");
    if($result){
		
	}else{
		echo json_encode(99009900);
	}
		
   
   
		 
			 
	   
  }
  
  else if($op == "insert_idee"){
      
		$emplacement_name=utf8_encode($_POST["emplacement_name"]);
	$zone_production=utf8_encode($_POST["zone_production"]);
	$idee_par=$_POST["idee_par"];
	$idee=mysqli_real_escape_string($mysqli,utf8_encode($_POST["idee"]));
	$path=$_POST["path"];
	$ajouter_par=$_POST["ajouter_par"];
  	 
	
	
	$result = $mysqli->query("INSERT INTO ideeamelioration (emplacement_name,zone_production,idee_par,idee,path,ajouter_par,date_inse) VALUES 
	('$emplacement_name','$zone_production','$idee_par','$idee','$path','$ajouter_par',NOW() )");
    if($result){
		
	}else{
		echo json_encode(99009900);
	}
		
   
   
		 
			 
	   
  }
   else if($op=="liste_idee"){

$result = $mysqli->query("SELECT * FROM ideeamelioration ");
	
    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
			header('Content-Type: application/json; Charset=UTF-8');

while($row = $result->fetch_array()) {
            $myArray['RESULT'][] = $row;
    }
	
    echo json_encode($myArray);
	  
	
       }
	   else
    {
	    echo json_encode(99009900);
		
	
      }
	
  }
  
  else if($op=="insert_alert1"){
	 
		$ServiceAlert=utf8_encode($_POST['ServiceAlert']);
	$typeAlert=utf8_encode($_POST['typeAlert']);
	$Recepteur_alert=utf8_encode($_POST['Recepteur_alert']);
	$gammFab=utf8_encode($_POST['gammFab']);
	$articleAlert=utf8_encode($_POST['articleAlert']);
	$clientAlert=utf8_encode($_POST['clientAlert']);
	$sPecPrduitAlert=utf8_encode($_POST['sPecPrduitAlert']);
	$sQuantite=$_POST['sQuantite'];
	$emplacement=utf8_encode($_POST['emplacement']);
	$ligne=utf8_encode($_POST['ligne']);
	$Mat_operateur=$_POST['sMat_operateur'];
	$Machine=utf8_encode($_POST['Machine']);
	$typeMachine=utf8_encode($_POST['typeMachine']);
	$ProblemeAlert=utf8_encode($_POST['sProblemeAlert']);
	//$commentaire=utf8_encode($_POST['commantaire']);
	$commentaire = mysqli_real_escape_string($mysqli, utf8_encode($_POST['commantaire']));

$path_img=$_POST['path_img'];
    $Env_par=$_POST['Env_par'];
	
	
	
    $mysqli->query("INSERT INTO sna_alert_incident1(service_alert,type_alert,recepteur_alerte,gam_fab,article_alert,client_alert,spec_prduit_cnc,quantite,emplacement,ligne,mat_operateur,machine,type_machine,probleme_alert,commentaire_alert,path_pj,etat_alert,env_par,date_env) VALUES
	('$ServiceAlert','$typeAlert','$Recepteur_alert','$gammFab','$articleAlert','$clientAlert','$sPecPrduitAlert','$sQuantite','$emplacement','$ligne','$Mat_operateur','$Machine','$typeMachine','$ProblemeAlert','$commentaire','$path_img','1','$Env_par',NOW())");
      if($mysqli){
		echo json_encode(1);
	}else{
		echo json_encode(99009900);
	}
	
  }
    else if($op=="liste_alert"){

$alert_etat=$_POST['alert_etat'];
	$result = $mysqli->query("SELECT * FROM sna_alert_incident1 where etat_alert='$alert_etat'");
	
    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
			header('Content-Type: application/json; Charset=UTF-8');

while($row = $result->fetch_array()) {
            $myArray['RESULT'][] = $row;
    }
	
    echo json_encode($myArray);
	  
	
       }
	   else
    {
	    echo json_encode(99009900);
		
	
      }
	
  }
    else if($op=="liste_alert_id"){

$alertID=$_POST['alertID'];
	$result = $mysqli->query("SELECT * FROM sna_alert_incident1 where id='$alertID'");
	
    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
			header('Content-Type: application/json; Charset=UTF-8');

while($row = $result->fetch_array()) {
            $myArray['RESULT'][] = $row;
    }
	
    echo json_encode($myArray);
	  
	
       }
	   else
    {
	    echo json_encode(99009900);
		
	
      }
	
  }
 else if($op=="selectAlertConfig"){
	 
	
	$alert_env = $_POST['alert_env'];
	
	
	
	
	$result = $mysqli->query("SELECT * FROM sna_alert_incident1_config where alert_type = '$alert_env' ");
    $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_alert_config"){
	 
	$alert = addslashes(utf8_encode(($_POST['alert'])));
	$alert_detaille = addslashes(utf8_encode(($_POST['alert_detaille'])));
	
	
	
	
	 $mysqli->query("INSERT INTO sna_alert_incident1_config (alert_type,alert_detaille) VALUES ('$alert','$alert_detaille')");
      if($result){
		echo json_encode(1);
	}else{
		echo json_encode(99009900);
	}
	
  }else if($op=="modifier_alert_config"){
	 
	$id = $_POST['id'];
	$table_name = $_POST['table_name'];
	$alert_detaille = $_POST['alert_detaille'];
	
	
	
	
	 $mysqli->query("update $table_name set alert_detaille ='$alert_detaille'  where id ='$id'");
     
	
  } 
  else if($op=="updateAlert"){
	 
	
	$action = mysqli_real_escape_string($mysqli,utf8_encode( $_POST['action']));
	$column1 = $_POST['column1'];
	$column2 = $_POST['column2'];
	$column3 = $_POST['column3'];
	$id = $_POST['id'];
	$AlertEtat = $_POST['AlertEtat'];
	$par = $_POST['par'];
	
	
	
	
	$result = $mysqli->query("update sna_alert_incident1 set $column1='$action' , $column2='$par' , $column3=NOW(),etat_alert='$AlertEtat' where id='$id'");
    
   
   if($result){
		
   echo json_encode(1);
       }
	   else
    {
	    echo json_encode(0);
	
      }
	
     
	
  }
  else if($op=="updateAlerval"){
	 
	
	$valider_desc = $_POST['valider_desc'];
	$valide_par = $_POST['valide_par'];
	
	$id = $_POST['id'];
	
	
	
	
	
	$result = $mysqli->query("update sna_alert_incident1 set valide_par='$valide_par' , valider_desc='$valider_desc' , date_valide=NOW(),etat_alert='3' where id='$id'");
    
   
   if($result){
		
   echo json_encode(1);
       }
	   else
    {
	    echo json_encode(0);
	
      }
	
     
	
  }
  else if($op=="select_alert_adm"){
	 
	
	$date_du = date("Y-m-d", strtotime($_GET['date_du']))." 00:00:00";
	$date_au = date("Y-m-d", strtotime($_GET['date_au']))." 23:59:59";
	//$alertEtat= $_GET['alertEtat'];
	
	
	
	$result = $mysqli->query("SELECT * FROM sna_alert_incident1 where date_env 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=="select_alertData"){
	 
	
	$table_name = $_POST['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 == "insert_analyse"){
      $date_choix = date("Y-m-d", strtotime($_POST['datec']))." 00:00:00";
		$typeAnalyse=utf8_encode($_POST["typeAnalyse"]);
	$idee_par=utf8_encode($_POST["idee_par"]);
	$champsPrev=$_POST["champsPrev"];
	$valeurCh=mysqli_real_escape_string($mysqli,utf8_encode($_POST["valeurCh"]));
	$degreeUrg=$_POST["degreeUrg"];
	$objetd=$_POST["objetd"];
	$ajouter_par=$_POST["ajouter_par"];
	
	$sPecification=$_POST["sPecification"];
	$sTypeAnalyses=$_POST["sTypeAnalyses"];
	$sRefanalyse=$_POST["sRefanalyse"];
  	 
	
	
	$result = $mysqli->query("INSERT INTO demande_analyse (date_choix,typeAnalyse,idee_par,champsPrev,valeurCh,degreeUrg,objetd,ajouter_par,dateEng) VALUES 
	('$date_choix','$typeAnalyse','$idee_par','$champsPrev','$valeurCh','$degreeUrg','$objetd','$ajouter_par',NOW() )");
    if($result){
		
	}else{
		echo json_encode(99009900);
	}
		
   
   
		 
			 
	   
  }
   else if($op=="liste_analyse"){

//$typeAn=$_POST['typeAn'];
	
	$result = $mysqli->query("SELECT * FROM demande_analyse ");
	
    $rowcount=mysqli_num_rows($result);
   
   if($rowcount>0){
			header('Content-Type: application/json; Charset=UTF-8');

while($row = $result->fetch_array()) {
            $myArray['RESULT'][] = $row;
    }
	
    echo json_encode($myArray);
	  
	
       }
	   else
    {
	    echo json_encode(99009900);
		
	
      }
	
  }
?>

${this.title}

Code Editor : NourWebService.php