<?php
include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;
$Mpage = basename($_SERVER['PHP_SELF']);
$user_id  =  $_SESSION['MCPRO']['user_id'] ; 

// echo "tttttttttttt<br/>" ; 
    $no=1;
    
    $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 AND user_id = $user_id order by  id  desc ";
   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: livraison.php");
	  header('Location:livraison.php?msg=  livraison  bien Supprimer   &color=success');
    }
  }
 }
 
 
 if($_POST['ajout']== "ajout")
 {
	 
	 
	 $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_arr[0]."".$date_arr[1]."".$date_arr[2];

      $reference = $_POST["reference"];

      

     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 = "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: livraison.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:livraison.php?msg=  Commande bien modifier   &color=success');
     // header("location: livraison.php");
    }
	



?>
<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <title>MC PRO MOBILE | ACCUEIL </title>
  <!-- Tell the browser to be responsive to screen width -->
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <!-- Font Awesome -->
  <link rel="stylesheet" href="plugins/fontawesome-free/css/all.min.css">
  <!-- Ionicons -->
  <link rel="stylesheet" href="https://code.ionicframework.com/ionicons/2.0.1/css/ionicons.min.css">
  <!-- Tempusdominus Bbootstrap 4 -->
  <link rel="stylesheet" href="plugins/tempusdominus-bootstrap-4/css/tempusdominus-bootstrap-4.min.css">
  <!-- iCheck -->
  <link rel="stylesheet" href="plugins/icheck-bootstrap/icheck-bootstrap.min.css">
  <!-- JQVMap -->
  <link rel="stylesheet" href="plugins/jqvmap/jqvmap.min.css">
  <!-- Theme style -->
  <link rel="stylesheet" href="dist/css/adminlte.min.css">
  <!-- overlayScrollbars -->
  <link rel="stylesheet" href="plugins/overlayScrollbars/css/OverlayScrollbars.min.css">
  <!-- Daterange picker -->
  <link rel="stylesheet" href="plugins/daterangepicker/daterangepicker.css">
  <!-- summernote -->
  <link rel="stylesheet" href="plugins/summernote/summernote-bs4.css">
  <!-- Google Font: Source Sans Pro -->
  <link href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700" rel="stylesheet">
</head>
<body class="hold-transition sidebar-mini layout-fixed">
<div class="wrapper">

  <!-- Navbar -->
  <nav class="main-header navbar navbar-expand navbar-white navbar-light">
  
    <!-- Left navbar links -->
    <ul class="navbar-nav ml-auto">
		<li class="nav-item">
			<a class="nav-link" data-widget="pushmenu" href="#"><i class="fas fa-bars"></i></a>
		</li>
		<li class="nav-item  d-sm-inline-block">
			<a href="index.php" class="nav-link">ACCUEIL</a>
		</li>
		<li class="nav-item d-sm-inline-block">
			<a href="livraison.php" class="nav-link">LIVRAISON</a>
		</li>
		<li class="nav-item d-sm-inline-block">
			<a href="controle.php" class="nav-link">CONTROLE</a>
		</li>
    </ul>

  </nav>
  <!-- /.navbar -->


 <?php  ?>
 <aside class="main-sidebar sidebar-dark-primary elevation-4">
    <a href="index.php" 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 MOBILE</span>
    </a>
    <!-- Sidebar / ne pas toucher -->
    <div class="sidebar">
 
 <!-- IDENTIFICATION DE L'UTILISATEUR -->
      <div class="user-panel mt-3 pb-3 mb-3 d-flex">
        <div class="info">
          <a href="#" class="d-block"><?php echo $_SESSION['MCPRO']['login'][0] ;?></a>
        </div>
      </div>

<!-- LIENS DE LA BARRE DE NAVIGATION-->
      <nav class="mt-2">
        <ul class="nav nav-pills nav-sidebar flex-column" data-widget="treeview" role="menu" data-accordion="false">
          <!-- Ne pas toucher les 2 lignes pr飩dentes-->
			<li class="nav-item">
				<a href="login.php?dec=1" class="nav-link">
				  <i class="nav-icon far fa-address-book"></i>
				  <p>Déconnexion </p>
				</a>
			 </li>
        </ul>
      </nav>
      <!-- /.sidebar-menu -->
    </div>
    <!-- /.sidebar -->
  </aside>
  
  
  
  
  
  
  
  

  
  
  
  
  
  
  
  
  

  <!-- Content Wrapper. Contains page content -->
  <div class="content-wrapper">
  
  
  

  
  
  
  
  
  
  
  

  
    <!-- Content Header (Page header) -->
    <div class="content-header">
      <div class="container-fluid">
        <div class="row mb-2">
          <div class="col-sm-6">
            <h1 class="m-0 text-dark">LIVRAISON</h1>
          </div><!-- /.col -->
        </div><!-- /.row -->
      </div><!-- /.container-fluid -->
    </div>
    <!-- /.content-header -->

    <!-- Main content -->
    <section class="content">
      <div class="container-fluid">

        <!-- Main row -->
        <div class="row">
			<div class="col-lg-12 col-12">
						<!-- TABLE: LATEST ORDERS -->
				<div class="card">


					<div class="card-header border-transparent">
						<div class="col-12 float-right">
							<a href="addcontrole.php" class="btn btn-info float-right" style="margin-right: 5px;"> <i class="fas fa-plus"></i> CONTROLE </a>
							<a href="addlivraison.php" class="btn btn-info float-right " style="margin-right: 5px;"> <i class="fas fa-plus"></i> LIVRAISION </a>
						</div>
					</div>
				
				
				  <!-- /.card-header -->
				  <div class="card-body p-0">
					<div class="table-responsive">
					  <table  id="tables" class="table m-0">
						<thead>
							<tr>
							  <th>#</th>
							  <th>Date</th>
							  <th>Référence</th>
							  <th>Client</th>
							  <th>Note</th>
							</tr>
						</thead>
														<tbody>
													   <?php if(!$count<=0){ while($row = mysqli_fetch_array($res)) {  

														$check_out[] = $row;
														 $check_out[] = int2date($row['date']);
														// echo "<pre>" ; 
														// print_r($check_out) ; 
														// echo "</pre>" ; 
														$rowid = $row['id'];
															?>
															<tr>
																
																
														  <td><?php echo $no++;  ?></td>
														  <td><span class="badge badge-success"><?php echo int2date($row['date']); ?></span></td>
														   <td><?php echo $row['reference'];  ?></td>
															<td>
															  <?php
															 list($nom) =  dbi_fetch_row(dbi_query( " SELECT client_nom FROM  client where `client_id` = ".$row['client'])) ; 
																 // echo "=====>".$row['client'] ; 
															   
															   echo $nom  ; 
															   ?>
																
															  </td>
															<td><?php echo $row['note'];  ?></td>
															</tr>	 
															<?php  } } else echo "<tr><td colspan='5' style=' text-align: center'>aucune information trouvée</td></tr>" ; ?> 
													 
													  

						</tbody>
					  </table>
					  
					</div>
					<!-- /.table-responsive -->
				  </div>
				</div>
				<!-- /.card -->
			</div>
        </div>
        <!-- /.row -->
		
		
		
		
      </div><!-- /.container-fluid -->
    </section>
    <!-- /.content -->
				
				
				
				
    <!-- /.content -->
  </div>
  <!-- /.content-wrapper -->
<?php include('footerr.php'); ?>
  <!-- Control Sidebar -->
  <aside class="control-sidebar control-sidebar-dark">
    <!-- Control sidebar content goes here -->
  </aside>
  <!-- /.control-sidebar -->
</div>
<!-- ./wrapper -->

<!-- jQuery -->
<script src="plugins/jquery/jquery.min.js"></script>
<!-- jQuery UI 1.11.4 -->
<script src="plugins/jquery-ui/jquery-ui.min.js"></script>
<!-- Resolve conflict in jQuery UI tooltip with Bootstrap tooltip -->
<script>
  $.widget.bridge('uibutton', $.ui.button)
</script>
<!-- Bootstrap 4 -->
<script src="plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- ChartJS -->
<script src="plugins/chart.js/Chart.min.js"></script>
<!-- Sparkline -->
<script src="plugins/sparklines/sparkline.js"></script>
<!-- JQVMap -->
<script src="plugins/jqvmap/jquery.vmap.min.js"></script>
<script src="plugins/jqvmap/maps/jquery.vmap.usa.js"></script>
<!-- jQuery Knob Chart -->
<script src="plugins/jquery-knob/jquery.knob.min.js"></script>
<!-- daterangepicker -->
<script src="plugins/moment/moment.min.js"></script>
<script src="plugins/daterangepicker/daterangepicker.js"></script>
<!-- Tempusdominus Bootstrap 4 -->
<script src="plugins/tempusdominus-bootstrap-4/js/tempusdominus-bootstrap-4.min.js"></script>
<!-- Summernote -->
<script src="plugins/summernote/summernote-bs4.min.js"></script>
<!-- overlayScrollbars -->
<script src="plugins/overlayScrollbars/js/jquery.overlayScrollbars.min.js"></script>
<!-- AdminLTE App -->
<script src="dist/js/adminlte.js"></script>
<!-- AdminLTE dashboard demo (This is only for demo purposes) -->
<script src="dist/js/pages/dashboard.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="dist/js/demo.js"></script>

<!-- page 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 : 'ajaxModifierLivraison.php', //Here you will fetch records 
            data :  'rowid='+ rowid, //Pass $id
            success : function(data){
            $('#fetch').html(data);//Show fetched data from database
            }
        });
     });
});

    
</script>

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

    
</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>
</body>
</html>