<?php
include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;

$no=1;

 if($_POST['modifier']== "modifier")
 {
  $edit = $_POST["edit"];
      $select = "SELECT * FROM check_in where id='$edit'";
      $result = mysqli_query($conn,$select);
      $check_in = mysqli_fetch_row($result);


      $products = array();
      $quantity = "";
      $edit = $_POST["edit"];
      if(is_null($_POST['date']) || !isset($_POST["date"]) || empty($_POST["date"])){

		  // print_r() ;
        $date = $check_in[1];
      }else{
        $date_arr = explode("-",$_POST["date"]);
        $date = $date_arr[2]."-".$date_arr[1]."-".$date_arr[0];
      }

     $reference = $_POST["reference"];

     $supplier = $_POST["supplier"];

     $local = $_POST["local-storage"];
     if(isset($_POST["product"])){
       foreach ($_POST["product"] as $key => $value) {
          echo $products[$key]["item"] = $_POST["product"][$key];
          echo "<br>";
          echo $products[$key]["quantity"] = $_POST["quantity"][$key];
          echo "<br>";

       }
     }
     $note = $_POST["note"];
     $query = "UPDATE `check_in` SET `date`='$date',`reference`='$reference',`supplier`='$supplier',`local`='$local',`note`='$note' WHERE id='$edit'";
     if(mysqli_query($conn,$query)){
        $query = "DELETE FROM `product_command` WHERE check_in_id='$edit'";
        mysqli_query($conn,$query);
          foreach ($products as $key => $value) {
          $prod = $products[$key]["item"];
          $quan = $products[$key]["quantity"];
          $query = "INSERT INTO `product_command`(`check_in_id`, `product_Id`, `quantity`) VALUES ('$edit','$prod','$quan')";
          mysqli_query($conn,$query);
        }

     }
     header('Location:Livraison_f.php?msg=  Commande bien modifier   &color=success');
    }



 if($_POST['ajout']== "ajout")
 {

      $products = array();
      $quantity = "";
      $date_arr = explode("-",$_POST["date"]);
      $date = $date_arr[2]."-".$date_arr[1]."-".$date_arr[0];

      $reference = $_POST["reference"];

      $supplier = $_POST["supplier"];

      $local = $_POST["local-storage"];

     foreach ($_POST["product"] as $key => $value) {
        $products[$key]["item"] = $_POST["product"][$key];
        $products[$key]["quantity"] = $_POST["quantity"][$key];
     }
     $note = $_POST["note"];
     $query = "INSERT INTO `check_in`(`date`, `reference`, `supplier`, `local`, `note`) VALUES ('$date','$reference','$supplier','$local','$note')";
     if(mysqli_query($conn,$query)){
        $query = "SELECT * FROM check_in WHERE date='$date' && reference='$reference' && supplier='$supplier' && local='$local' && 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 `product_command`(`check_in_id`, `product_Id`, `quantity`) VALUES ('$new_id','$prod','$quan')";
          mysqli_query($conn,$query);
        }
     }
	  header('Location:Livraison_f.php?msg=  Commande bien ajouter   &color=success');
 }





    $message = false;
    $suppliers = array();
    $suppliersList = array();
    $products = array();
    $productsList = array();
    $check_in = array();




    //where status ='pending'
   $select = "SELECT * FROM `check_in` ";
   if($res = mysqli_query($conn,$select)){
   $count = mysqli_num_rows($res);
   }else{
       $count=0;
   }

   $select = "SELECT * FROM `product_command`";
   $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;
   }

   $select = "SELECT * FROM `fournisseur`";
   $resu = mysqli_query($conn,$select);
   while ($sup = mysqli_fetch_array($resu)) {
     $suppliersList[] = $sup;
   }

 if(isset($_GET['delete'])){
  $del = $_GET['delete'];
  $query = "DELETE FROM check_in WHERE id='$del'";
  if(mysqli_query($conn,$query)){
    $query = "DELETE FROM product_command WHERE check_in_id='$del'";
    if(mysqli_query($conn,$query)){
      // header("location: Livraison_f.php");
	   header('Location:Livraison_f.php?msg=  Commande bien supprimer   &color=success');
    }
  }
 }




?>


<!DOCTYPE html>
<html>

			<head>

			<?php include('header.php'); ?>
	  <script type="text/javascript" src="plugins/selectize/selectize.js"></script>
	<link rel="stylesheet" type="text/css" href="plugins/selectize/selectize.css" />
	<script type="text/javascript" src="plugins/selectize/selectize.min.js"></script>
	<link rel="stylesheet" type="text/css" href="plugins/selectize/selectize.default.css" />
	<link rel="stylesheet" href="../../plugins/summernote/summernote-bs4.css">







  <!-- jQuery 2.2.3 -->
<script src="plugins/jQuery/jquery-2.2.3.min.js"></script>
<!-- Bootstrap 3.3.6 -->
<script src="bootstrap/js/bootstrap.min.js"></script>
<!-- DataTables -->
<script src="plugins/datatables/jquery.dataTables.min.js"></script>
<script src="plugins/datatables/dataTables.bootstrap.min.js"></script>
<!-- SlimScroll -->
<script src="plugins/slimScroll/jquery.slimscroll.min.js"></script>

  <style type="text/css">
  .modal-backdrop {
    /* bug fix - no overlay */
    display: none;
}
</style>


<!-- SlimScroll -->



			</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">
													<ul class="navbar-nav">
															<li class="nav-item">
																	<a class="nav-link" data-widget="pushmenu" href="#"><i class="fas fa-bars"></i></a>
															</li>

															<li>
															<?php echo '<a href="#myModal2"  id="custId" data-toggle="modal" data-id="'.$c['Fournisseur_ID'].'"><h3><button type="button"   class="btn btn-primary" ><i class="fas fa-plus"></i> RECEPTION LIVRAISON</button></h3></a>';?>
															</li>
													</ul>
												</nav>


<!-- BARRE DE NAVIGATION -->


<aside class="main-sidebar sidebar-dark-primary elevation-4">

	<!-- Brand Logo -->
	<a href="index3.html" class="brand-link">
		<img src="dist/img/logomcpro.png" alt="AdminLTE Logo" class="brand-image img-circle elevation-3"
				 style="opacity: .8">
		<span class="brand-text font-weight-light">MC PRO</span>
	</a>

	<!-- Sidebar -->
	<div class="sidebar">
		<!-- Sidebar user panel (optional) -->
		<div class="user-panel mt-3 pb-3 mb-3 d-flex">
			<div class="image">
				<img src="dist/img/user2-160x160.jpg" class="img-circle elevation-2" alt="User Image">
			</div>
			<div class="info">
				<a href="#" class="d-block">Steeven ROBLOT</a>
			</div>
		</div>

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

		<!-- Sidebar Menu -->

	</div>
	<!-- /.sidebar -->
</aside>

												  <div  class="modal fade" id="myModal" role="dialog" class="modal fade task-modal-single in" tabindex="-1"  aria-labelledby="myLargeModalLabel" >
												  <div class="modal-dialog modal-lg">
													<div class="modal-content data">
														<div id="fetch" ></div>


														</div>
													</div>
												</div>



												  <div  class="modal fade" id="myModal2" role="dialog" class="modal fade task-modal-single in" tabindex="-1"  aria-labelledby="myLargeModalLabel" >
													  <div class="modal-dialog modal-lg">
														<div class="modal-content data">
															<div id="fetch2" ></div>


															</div>
														</div>
												  </div>




 <!-- DEMARRAGE DE LA PAGE PRINCIPALE -->
  <div class="content-wrapper">
    <section class="content-header">
   <div class="container-fluid">
     <div class="row mb-2">
       <div class="col-sm-6">
         <h1>Réception Livraison Fournisseur</h1>
       </div>
       <div class="col-sm-6">
         <ol class="breadcrumb float-sm-right">
           <li class="breadcrumb-item"><a href="index.php">Accueil</a></li>
           <li class="breadcrumb-item"><a href="indexstock.php">Gestion du Stock</a></li>
           <li class="breadcrumb-item active">Réception Livraison Fournisseur</li>
         </ol>
       </div>
     </div>
   </div><!-- /.container-fluid -->
  </section>


    <!-- Content Header (Page header) -->


	 <div class="modal fade" id="exampleModalLong" tabindex="-1" role="dialog" aria-labelledby="exampleModalLongTitle" aria-hidden="true">
  <div class="modal-dialog" role="document">
    <div class="modal-content">
      <div class="modal-header">
        <h5 class="modal-title" id="exampleModalLongTitle"></h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
      <div class="modal-body">
        <table class="table table-bordered table-striped">
          <tr >
            <td>
              Référence:
            </td>
            <td id="checkOutReference">
              Reference:
            </td>
          </tr>

          <tr>
            <td>
              Date
            </td>
            <td id="checkOutDate">
              Date
            </td>
          </tr>

          <tr>
            <td >
              Fournisseur
            </td>
            <td id="checkOutSupplier">
              Fournisseur
            </td>
          </tr>
        </table>
        <br>

        <table id="productTable" class="table table-bordered table-striped">
          <thead>
            <td>#
            </td>
            <td>Produit
            </td>
            <td>Quantité
            </td>
          </thead>
          <tbody><tr></tr></tbody>
          <tr></tr>
        </table>

        <table id="productTable" class="table table-bordered table-striped">
          <thead>
            <td>Local Stockage
            </td>
            <td>Note
            </td>
          </thead>
          <tbody><tr>
            <td id="productLocal"></td>
            <td id="productNote"></td>
          </tr></tbody>
          <tr></tr>
        </table>


      </div>
      <div class="modal-footer">
        <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
        <!-- <button type="button" class="btn btn-primary">Save changes</button> -->
      </div>
    </div>
  </div>
</div>




													<div class="row mb-2">
																			<div  class="modal fade" id="myModal" role="dialog" class="modal fade task-modal-single in" tabindex="-1"  aria-labelledby="myLargeModalLabel" >
																			  <div class="modal-dialog modal-lg">
																				<div class="modal-content data">
																					<div id="fetch" >
																					</div>

																					</div>
																				</div>
																			</div>

												</div>
												<!-- /.content-header -->

    <!-- PAGE PRINCIPALE -->





				<section class="content">
					<div class="row">
						<div class="col-12">
							<div class="card">



															    	  <?php
																					  if(isset($_GET["msg"])){
																			?>
																			<div class="alert alert-<?php echo $_GET["color"]; ?>  alert-dismissible col-12" role="alert">
																			  <strong><?php echo $_GET["color"].': '; ?></strong><?php echo $_GET["msg"]; ?>.
																			  <button type="button" class="close" data-dismiss="alert" aria-label="Close">
																				<span aria-hidden="true">&times;</span>
																			  </button>
																			</div>
																			<?php
																			}
																		   ?>

									<div class="card-body">
										<div class="onglet_dotted">
											<div style="width:100%; float:left; vertical-align:top" class="header_ray">
												<div id="tab">
													<div class="box-body">
														<table id="tables" class="table table-bordered table-striped">
																<thead>
																<tr>
																  <th>Sr.no</th>
																  <th>Date</th>
																  <th>Référence</th>
																  <th>Fournisseur</th>
																   <th>Lieu</th>
																   <th>Note</th>
																   <th></th>

																</tr>
																</thead>
                                                            <tbody>
															   <?php if(!$count<=0){ while($row = mysqli_fetch_array($res)) {
																$in = 0;
															   $check_in[] = $row;
																$rowid = $row['id'];
																	?>
																	<tr>


																  <td><?php echo $no++;  ?></td>
																  <td><?php echo $row['date'];  ?></td>
																   <td><?php echo $row['reference'];  ?></td>
																	<td>
																	  <?php
																	foreach ($suppliersList as $key => $value) {
																	  if($suppliersList[$key]["Fournisseur_ID"] == $row['supplier']){
																		echo $suppliersList[$key]["Fournisseur_Nom"];
																	  }
																	}?>

																	 </td>
																	<td><?php echo $row['local'];  ?></td>
																	<td><?php echo $row['note'];  ?></td>
																	<td>
																	  <a id="rowlue" href="<?php echo "edit_check_in.php".'?edit='.$rowid; ?>"style="color:#000000;"><i class="fa fa-fw fa-pencil-square-o"></i></a>


																	 <?php echo '<a class="btn btn-info btn-sm" href="#myModal"  id="custId" data-toggle="modal" data-id="'.$rowid.'"><i class="fas fa-pencil-alt">Editer</i></a>';?>

																	<a class="btn btn-danger btn-sm" href="Livraison_f.php?delete=<?=$rowid?>&action=sup"  onclick="return confirm('Voulez-vous vraiment supprimer cet Commande  ?');">

																			<i class="fas fa-trash">Supprimer
																		  </i>
																		</a>


																	</td>


																	<?php

// echo $_SERVER['PHP_SELF']."<br/>" ;
																	} }?>


															</tbody>
														</table><!-- /.table -->
													</div><!-- /.box-body -->
												</div><!-- /.tab -->
											</div><!-- /.header_ray -->
										</div><!-- /.onglet_dotted -->
								    </div><!-- /.card-body -->
							    </div><!-- /.card card-primary card-outline -->
							</div> <!-- /.col-12 -->
						</div>  <!-- /.row -->
				</section> <!-- /.section -->




	</div>


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


<script type="text/javascript">
$(document).ready(function(){
    $('#myModal2').on('show.bs.modal', function (e) {
        var rowid = $(e.relatedTarget).data('id');
        $.ajax({
            type : 'post',
            url : 'ajaxNouvelleReception.php', //Here you will fetch records
            data :  'rowid='+ rowid, //Pass $id
            success : function(data){
            $('#fetch2').html(data);//Show fetched data from database
            }
        });
     });
});


</script>


<script type="text/javascript">
$(document).ready(function(){
    $('#myModal').on('show.bs.modal', function (e) {
        var rowid = $(e.relatedTarget).data('id');
        $.ajax({
            type : 'post',
            url : 'ajaxModifierReception.php', //Here you will fetch records
            data :  'rowid='+ rowid, //Pass $id
            success : function(data){
            $('#fetch').html(data);//Show fetched data from database
            }
        });
     });
});


</script>



<script src="../../plugins/summernote/summernote-bs4.min.js"></script>
<script>
  $(function () {
    // Summernote
    $('.textarea').summernote()
  })
</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 = "";
      var data = "";
      var tempId = "";

      var table = $('#tables').DataTable();
      var data = table.row(this).data();
      var tempId = data[6].split("?edit=");
      var tempId = tempId[1].split('"');
      // var rowEdit = document.getElementById("rowValue");
      // var rowHref = rowEdit.getAttribute('href');
      // var splitHref = rowHref.split("=");
      //var rowId =tempId[0];
      // var rowEdit = document.getElementById("rowValue");
      // var rowHref = rowEdit.getAttribute('href');
      // var splitHref = rowHref.split("=");
      var rowId =tempId[0];
      // alert(rowId);
      var te = 1;
        var arr = <?php echo json_encode($check_in); ?>;
        var prod = <?php echo json_encode($products); ?>;
        var prodList = <?php echo json_encode($productsList); ?>;
        var suplList = <?php echo json_encode($suppliersList); ?>;
        var supplier = "";

        for(var i=0; i < arr.length; i++){
         if(rowId == arr[i][0]){
          document.getElementById('exampleModalLongTitle').innerHTML = "<b>Réception 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>"+arr[i][7]+"</b>";
          document.getElementById("productLocal").innerHTML = "<b>"+arr[i][4]+"</b>";
          for(var s=0; s<suplList.length; s++){
            if(suplList[s][0]==arr[i][3]){
              supplier = suplList[s][1];
            }
          }
          document.getElementById('checkOutSupplier').innerHTML = "<b>"+supplier+"</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');
    });
});
</script>

</body>
</html>