<?php
 include 'cnx1.php';
header('Content-Type: text/html; charset=utf-8');

?>
<!doctype html>

<html lang="en">
  <head>
    <!-- Required meta tags -->
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <link href="https://fonts.googleapis.com/css?family=Roboto:300,400&display=swap" rel="stylesheet">

    <link rel="stylesheet" href="fonts/icomoon/style.css">

    <link rel="stylesheet" href="css/owl.carousel.min.css">

    <!-- Bootstrap CSS -->
    <link rel="stylesheet" href="css/bootstrap.min.css">
    
    <!-- Style -->
    <link rel="stylesheet" href="css/style.css">

    <title>Table #9</title>
  </head>
  <body>
  

  <div class="content">
    
    <div class="container">
      <h2 class="mb-5"> <?php 
	  
	  echo urldecode(str_replace('_', " ", $_GET['title'])).'<br><br><br>' ; 
	   echo urldecode('Envoyé par :' .str_replace('_', " ", $_GET['env'])).'<br><br>' ; 
	  
	    echo urldecode(str_replace('_', " ", $_GET['commentaire'])).'<br><br>' ; 
		 echo urldecode('T.Conformité Audit :' .str_replace('_', " ", $_GET['tc'])).'<br><br>' ; 
	  ?> 
	  
	  
	  </h2>

      <div class="table-responsive">

        <table class="table custom-table">
          <thead>
            <tr>
             
              <th scope="col">N°</th>
              <th scope="col">Question</th>
              <th scope="col">Reponse</th>
              <th scope="col">Observation</th>
			  <th scope="col">Pièce jointe</th>
            </tr>
          </thead>
          <tbody>
            <tr>
           <?php
		   
		   $id_reponse_g= $_GET['lastID']; 
	          $source_input = $_GET['source_input'];
			  $table_name="question";
  
			/* $query = "SELECT sna_documentaire_reponse_g.id, sna_documentaire.question, sna_documentaire_reponse.reponse, sna_documentaire_reponse.observation,sna_documentaire.order_question,path_pj,sna_documentaire_reponse.id as idrep
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 '<br>'.$query.'<br>';
*/
  
	 if($source_input =='documentaire_'){
  $result = $mysqli->query("SELECT sna_documentaire_reponse_g.id, sna_documentaire.question, sna_documentaire_reponse.reponse, sna_documentaire_reponse.observation,sna_documentaire.order_question,path_pj,sna_documentaire_reponse.id as idrep
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");
   
   }else{		  
	$result = $mysqli->query("SELECT sna_".$source_input."reponse_g.id, sna_".$source_input."question.question, sna_".$source_input."reponse.reponse, sna_".$source_input."reponse.observation,sna_".$source_input."question.order_question,path_pj,sna_".$source_input."reponse.id as idrep
FROM sna_".$source_input."reponse_g
INNER JOIN sna_".$source_input."reponse ON sna_".$source_input."reponse.id_reponse_g = sna_".$source_input."reponse_g.id
INNER JOIN sna_".$source_input."question ON sna_".$source_input."question.id = sna_".$source_input."reponse.id_question
WHERE sna_".$source_input."reponse_g.id ='$id_reponse_g'
ORDER BY sna_".$source_input."question.order_question");
   }
    
    $rowcount=mysqli_num_rows($result);
 
   if($rowcount>0){
		
       while($row = $result->fetch_array()) {
		   ?>
            
			<td>
               <?php echo $row['order_question'] ; ?>
              </td>
              <td><?php echo $row['question'] ; ?></td>
              <td>
               <?php echo $row['reponse'] ; ?>
              </td>
              <td><?php echo $row['observation'] ; ?></td>
              <td>
			  <?php if($row['path_pj'] <> ""){ ?>
			  <button type="button" class="btn btn-primary" data-toggle="modal" data-target=<?php echo "#myModal".$row['idrep'] ;  ?> > Pièce jointe </button>

<div id=<?php echo "myModal".$row['idrep'] ;  ?> class="modal fade" tabindex="-1" role="dialog">
  <div class="modal-dialog">
    <div class="modal-content">
        <div class="modal-body">
            <img src=<?php echo "http://192.168.213.201/".substr($row['path_pj'], 2) ?>  style="width:470px;height:600px;" class="img-responsive">
        </div>
    </div>
  </div>
			  </div>   <?php } ?>
               
              </td>
            </tr>
   <?php }
   }
		   ?>
              
            
           
            
            
          </tbody>
        </table>
      </div>


    </div>

  </div>
    
    

    <script src="js/jquery-3.3.1.min.js"></script>
    <script src="js/popper.min.js"></script>
    <script src="js/bootstrap.min.js"></script>
    <script src="js/main.js"></script>
  </body>
</html>