<?php
// exit() ; 
include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;



// echo "<pre>" ; 
// print_r($_SESSION) ;
// echo "<pre>" ; 


   list($Lieu_de_stockage_ID) =  dbi_fetch_row( dbi_query("SELECT Lieu_de_stockage_ID	 FROM `users` WHERE `user_id` =  ".$_SESSION['MCPRO']['user_id'])) ; 
   
   // echo "===> $Lieu_de_stockage_ID <br/>" ; 


   $no=1;
    
	
	
    $message = false;
    //where status ='pending'
   $select = "SELECT * FROM client where client_statut = '1' order by client_nom";
   $client = mysqli_query($conn,$select);

   $select = "SELECT * FROM produits";
   $produit = mysqli_query($conn,$select);
    
    $message = false;
    $suppliers = array();
    $products = array();
    $check_out = array();
    $customerList = array();
    //where status ='pending'
   $select = "SELECT id , date , reference , client ,note ,local, client_nom FROM `check_out` ch  , client c  where ch.client = c.client_id  order by  date ";
   if($res = mysqli_query($conn,$select)){
   $count = mysqli_num_rows($res);
   
   }else{
       $count=0;
   }
   
   
  

   $select = "SELECT * FROM `check_out_produit`";
   $resu = mysqli_query($conn,$select);
   while ($ro = mysqli_fetch_array($resu)) {
     $products[] = $ro;
   }
    


    $select = "SELECT * FROM `produits`";
   $resu = mysqli_query($conn,$select);
   while ($pro = mysqli_fetch_array($resu)) {
     $productsList[] = $pro;
   }
   
   
   
   



   $resu = dbi_query("SELECT * FROM client where 1 ")  ; 
   // $select = "SELECT * FROM `client`";
   // $resu = mysqli_query($conn,$select);
   while($cus = dbi_fetch_row($resu)) {
   $customerList[] = $cus['client_id'];
   }

   
   // echo "<pre>" ; 
   // print_r($customerList) ; 
   // echo "</pre>" ; 
      	
	 // echo "testdddddddddd3333333333eeeddddt <br/>" ; 

// exit() ; 
   
 if(isset($_GET['delete'])){
  $del = $_GET['delete'];
  $query = "DELETE FROM check_out WHERE id='$del'";
  if(mysqli_query($conn,$query)){
    $query = "DELETE FROM check_out_produit WHERE check_out_id='$del'";
    if(mysqli_query($conn,$query)){
      // header("location: check_out.php");
	  header('Location:check_out.php?msg=  livraison  bien Supprimer   &color=success');
    }
  }
 }
 
 
 if($_POST['ajout']== "ajout")
 {
	 
	 
	  $date_livraison = date('Ymd') ; 
	  

	 
	 
	 $client = $_POST["client"];
	 
	 
	list($demliv_id)=  dbi_fetch_row(dbi_query("SELECT demliv_id FROM `demliv` WHERE  demliv_statut = '0' and `client_id` = $client")) ; 
	
	// echo "========> $demliv_id <br/>" ; 
		// echo "yyyyyy <br/>" ; 
	
	
	if($demliv_id != "")
	{
		// echo "========> $demliv_id <br/>" ; 
		// echo "ggggggg <br/>" ; 
		
		dbi_query("UPDATE `demliv` SET `demliv_statut` = '1' WHERE `demliv`.`demliv_id` = '".$demliv_id."'  ") ;
	}
	
	// exit() ; 

      $products = array();
      $quantity = "";
      // $date_arr = explode("-",$_POST["date"]);
      $date = $date_livraison ; 

      $reference = $_POST["reference"];

      

     foreach ($_POST["product"] as $key => $value) {
        $products[$key]["item"] = $_POST["product"][$key];
        $products[$key]["quantity"] = $_POST["quantity"][$key];
     }
     $note = $_POST["note"];
	 
	 if($Lieu_de_stockage_ID == 20)
	 {
	 $local  = 'PARIS';
	 }
	 
	  if($Lieu_de_stockage_ID == 21)
	 {
	 $local  = 'TOULON';
	 }
	 
	 // echo "<pre>" ; 
	// print_r($_POST) ; 
	// echo "</pre>" ; 
	
	// exit() ; 
     $query = "INSERT INTO `check_out`(`date`, `reference`, `client`, `note` , `local`) VALUES ('$date','$reference','$client','$note','$local')";

     if(mysqli_query($conn,$query)){
        $query = "SELECT * FROM check_out WHERE date='$date' && reference='$reference' && client='$client' && note='$note'";
        $resu = mysqli_query($conn,$query);
        $fetch_row = mysqli_fetch_row($resu);
        $new_id = $fetch_row[0];
        foreach ($products as $key => $value) {
          $prod = $products[$key]["item"];
          $quan = $products[$key]["quantity"];
          $query = "INSERT INTO `check_out_produit`(`check_out_id`, `product_Id`, `quantity`) VALUES ('$new_id','$prod','$quan')";
          mysqli_query($conn,$query);
        }
     }
     header("location: check_out.php");
    }



	
 
 if($_POST['modifier']== "modifier")
 {
      $products = array();
      $quantity = "";
      $edit = $_POST["edit"];
      $select = "SELECT * FROM check_out where id='$edit'";
      $result = mysqli_query($conn,$select);
      $check_out = mysqli_fetch_row($result);
	  
      if(is_null($_POST["date"]) || empty($_POST["date"]) || !isset($_POST["date"])){
        $date = $check_out[1];
		 $date_arr  = explode("/", $check_out[1]);
		  $date = $date_arr[0]."".$date_arr[1]."".$date_arr[1];
      }else{
        $date_arr = explode("-",$_POST["date"]);
        $date = $date_arr[0]."".$date_arr[1]."".$date_arr[2];
      }
      

     $reference = $_POST["reference"];

     $client = $_POST["client"];

     foreach ($_POST["product"] as $key => $value) {
        $products[$key]["item"] = $_POST["product"][$key];
        $products[$key]["quantity"] = $_POST["quantity"][$key];
     }
     $note = $_POST["note"];
	 $local = $_POST["local-storage"];
	 
	 	// echo "<pre>" ; 
// print_r($_POST); 
// echo "</pre>" ; 

// exit() ; 
     $query = "UPDATE `check_out` SET `date`='$date',`reference`='$reference',`client`='$client',`note`='$note',`local`='$local' WHERE id='$edit'";
     if(mysqli_query($conn,$query)){
        $query = "DELETE FROM `check_out_produit` WHERE check_out_id ='$edit'";
        mysqli_query($conn,$query);
          foreach ($products as $key => $value) {
          $prod = $products[$key]["item"];
          $quan = $products[$key]["quantity"];
          $query = "INSERT INTO `check_out_produit`(`check_out_id`, `product_Id`, `quantity`) VALUES ('$edit','$prod','$quan')";
          mysqli_query($conn,$query);
        }
        
     }
	 header('Location:check_out.php?msg=  Commande bien modifier   &color=success');
     // header("location: check_out.php");
    }
	


			 
			
		
			 
?>




<!DOCTYPE html>
<html>

			<head>

			<?php include('header.php'); ?>

      <link rel="stylesheet" href="../../plugins/summernote/summernote-bs4.css">
			</head> 
			
<body class="hold-transition sidebar-mini">	


												<!-- Site wrapper -->
<div class="wrapper">

<!-- TOP MENU -->
  <nav class="main-header navbar navbar-expand navbar-white navbar-light">
 <!-- Menu extensible -->
    <ul class="navbar-nav">
      <li class="nav-item">
        <a class="nav-link" data-widget="pushmenu" href="#"><i class="fas fa-bars"></i></a>
      </li>
<!-- liens TOP MENU GAUCHE-->
      <li class="nav-item d-none d-sm-inline-block">
        
      </li>
      <li class="nav-item d-none d-sm-inline-block">
        
      </li>
	   <li class="nav-item d-none d-sm-inline-block">
       
      </li>
    </ul>

 <!-- liens TOP MENU DROITE -->
    <ul class="navbar-nav ml-auto">
     <!-- Placer ici l'élément à positionner à droite du TOP MENU -->
    </ul>
  
  </nav>  <!-- fin du TOP MENU -->
  
  
<!-- BARRE DE NAVIGATION -->


 <?php include('menu.php'); ?>
  


 <!-- DEMARRAGE DE LA PAGE PRINCIPALE -->
  <div class="content-wrapper">
   
  <!-- TITRE DE LA PAGE PRINCIPALE A PLACE ENTRE LES BALISES H1 & ARBORESCENCE SUR LA DROITE-->
    <section class="content-header">
      <div class="container-fluid">
        <div class="row mb-2">
          <div class="col-sm-6">
            <h6></h6>
          </div>
          <div class="col-sm-6">
            <ol class="breadcrumb float-sm-right">
              
            </ol>
          </div>
        </div>
      </div><!-- /.container-fluid -->
    </section>
  <!-- FIN DU TITRE DE LA PAGE PRINCIPALE A PLACE ENTRE LES BALISES H1 & ARBORESCENCE SUR LA DROITE-->
   

 <!-- CONTENU DE LA PAGE PRINCIPALE -->
    <section class="content"> <!-- Ne pas toucher cette ligne -->

 <!-- Card Principale -->
      <div class="card">
	   
	   
	   <!--  Titre de la Card Principale -->
        <div class="card-header">
          <h3 class="card-title"> <i class="nav-icon fas fa-user-plus"></i> NOUVELLE LIVRAISON</h3>
		</div>
       <!--  Fin du Titre de la Card Principale -->
		 
		 
	   <!-- Contenu de la Card Principale -->
		<div class="card-body">
 
       <form role="form" id="add" name="add" method="post" enctype="multipart/form-data" action="">
              <input type="hidden" name="edit" id="edit" value="<?php echo $check_out[0] ?>">
            <div class="card-body">        
<?php
  echo'<input type="hidden" name="ajout" value="ajout">';?>

<div class="form-row"> 
			
	 
	

	<div class="form-group col-md-3">
                 <label for="client">Client</label>
                  <select class="form-control js-example-basic-single" id="client" name="client">
                    <option value="null">Selectionner Client</option>
                    <?php 
                    while ($row = mysqli_fetch_array($client)) {
                      if($check_out[3] == $row["client_id"]){
                        echo "<option value='".$row["client_id"]."' selected>".$row["client_nom"]."</option>";
                      }else{
                        echo "<option value='".$row["client_id"]."'>".$row["client_nom"]."</option>";
                      }
                      
                    }
                    ?>
                  </select>
            </div>
				
			
			
 	    <div class="form-group col-md-12">
                <label for="add-item">Ajouter Produit</label>
                  <select onchange="selectChange()" class="form-control js-example-basic-single" id="product" placeholder="Add Item" name="product"  required>
                    <option value="null">Selectionner Produit</option>
                    <?php 
                    while ($row = mysqli_fetch_array($produit)) {
                      echo "<option value='".$row["Produit_ID"]."'>".$row["Produit_Designation"]."</option>";
                    }
                    ?>
                  </select>
		 </div> 


		<div class="form-group col-md-12">
                 <table id="myTable" class="table order-list table-bordered table-striped">
                <thead>
                    <tr>
                        <td>Description</td>
                        <td>Quantité</td>
                        <td><i class="fa fa-trash"></i></td>
                    </tr>
                </thead>
                <tbody>
                </tbody>
                <tfoot>
                    <tr>
                    </tr>
                </tfoot>
              </table>
        </div>			
						
	
		
		<div class="form-group col-md-12">
			  
					<label for="inputAddresse">Note</label>
                <textarea   id="note" name="note" class="textarea" placeholder="Place some text here"
                          style="width: 200px; height: 200px; font-size: 20px; line-height: 20px; border: 1px solid #dddddd; padding: 10px;"> <?php echo $check_out[4]; ?></textarea>
        </div>


	

  </div>  
  		
				
               
              </div>
			  
			     <div class="modal-footer justify-content-between">
								
								  <button type="submit" name="submitbtn" class="btn btn-primary">Enregistrer</button>
								  </div>
          

			  
			  </form>
			  
           </div>
	  
	  </div>
	</section>
  </div>
  <!-- NE PAS TOUCHER AU DESSUS DESSOUS -->	 




<!-- DEBUT DU PIED DE PAGE -->
  
<?php include('footerr.php'); ?>


 <script src="../../plugins/bs-custom-file-input/bs-custom-file-input.min.js"></script>

<script type="text/javascript">
$(document).ready(function () {
  bsCustomFileInput.init();
});
</script>
<script src="../../plugins/summernote/summernote-bs4.min.js"></script>
<script>
  $(function () {
    // Summernote
    $('.textarea').summernote()
  })
</script>
			
<script>
  $(document).ready(function() {
      $('.js-example-basic-single').select2();
  });

  $(function () {
    $("#tables").DataTable();
    $('#example').DataTable({
      "paging": true,
      "lengthChange": false,
      "searching": false,
      "ordering": false,
      "info": true,
      "autoWidth": false
    });
  });

//   $("#product").change( function() {
//      alert($("#product").val());
// });

  $(document).ready(function () {
    var counter = 0;

    $("#product").on("change", function (e) {
        var id = $("#product").val()
        var name = $('#product').find(":selected").text();
        var newRow = $("<tr>");
        var cols = "";

         cols += '<td><input type="hidden" class="form-control" value="'+id+'"" readonly name="product[]"/><p>'+name+'</p></td>';

        cols += '<td><input type="number" class="form-control" value="1" name="quantity[]"/></td>';
        cols += '<td><span style="cursor:pointer;"><i id="ibtnDel" name="ibtnDel"  class="ibtnDel fa fa-trash"></i></span></td>';

        
        newRow.append(cols);
        $("table.order-list").append(newRow);
        counter++;
        $("#product").select2("close");
    });



    $("table.order-list").on("click", ".ibtnDel", function (event) {
        $(this).closest("tr").remove();       
        counter -= 1
    });


});



function calculateRow(row) {
    var price = +row.find('input[name^="price"]').val();

}

function calculateGrandTotal() {
    var grandTotal = 0;
    $("table.order-list").find('input[name^="price"]').each(function () {
        grandTotal += +$(this).val();
    });
    $("#grandtotal").text(grandTotal.toFixed(2));
}

//$('#product').selectize('option');
</script>
    





<!-- page script -->
<script>
  $(function () {
    $("#tables").DataTable();
    $('#example').DataTable({
      "paging": true,
      "lengthChange": false,
      "searching": false,
      "ordering": false,
      "info": true,
      "autoWidth": false
    });
  });

$(document).ready(function() {
    $('#tables tr').click(function(e) {
      $("#productTable").empty();
      $('#productTable').append('<thead><td>#</td><td>Produit</td><td>Quantité</td></thead>');
      var table = $('#tables').DataTable();
      var data = table.row(this).data();
      var tempId = data[5].split("?edit=");
      var tempId = tempId[1].split('"');
      // var table = $('#tables').DataTable();
      // var data = table.row( this ).data();
      // var tempId = data.pop().split("?edit=");
      // var rowEdit = document.getElementById("rowValue");
      // var rowHref = rowEdit.getAttribute('href');
      // var splitHref = rowHref.split("=");
      var rowId =tempId[0];
      var te = 1;
        var arr = <?php echo json_encode($check_out); ?>;
        var prod = <?php echo json_encode($products); ?>;
        var prodList = <?php echo json_encode($productsList); ?>;
        var custList = <?php echo json_encode($customerList); ?>;
        var customer = "";
        for(var i=0; i < arr.length; i++){
         if(rowId == arr[i][0]){
          document.getElementById('exampleModalLongTitle').innerHTML = "<b>  Livraison Client ID: "+arr[i][0]+"</b>";
          document.getElementById('checkOutDate').innerHTML = "<b>"+arr[i+1]+"</b>";
          document.getElementById('checkOutReference').innerHTML = "<b>"+arr[i][2]+"</b>";
          document.getElementById("productNote").innerHTML = "<b style='color: red;'>Note</b><b>"+arr[i][4]+"</b>";
          for(var n=0; n < custList.length; n++){
            if(custList[n][0] == arr[i][3]){
              customer = custList[n][1];
            }
          }
          document.getElementById('checkOutCustomer').innerHTML = "<b>"+arr[i][6]+"</b>";
          for(var l=0; l<prod.length; l++){
            if(prod[l][1] == arr[i][0]){
              for(var p = 0; p < prodList.length; p++){
                if(prodList[p][0]==prod[l][2]){
                  $('#productTable').append('<tr><td>'+te+'</td><td>'+prodList[p][3]+'</td><td>'+prod[l][3]+'</td></tr>');
                }
              }
              te++;
            }
          }
         }
        }
        $('#exampleModalLong').modal('show');
    });
});

$('#myModal').on('shown.bs.modal', function () {
  $('#myInput').trigger('focus')
});


</script>
<script src="../../plugins/summernote/summernote-bs4.min.js"></script>
<script>
  $(function () {
    // Summernote
    $('.textarea').summernote()
  })
</script>


</body>
</html>