|
Server IP : 10.128.40.6 / Your IP : 216.73.216.233 Web Server : Apache System : Linux webd006.cluster128.gra.hosting.ovh.net 5.15.206-ovh-vps-grsec-zfs-classid #1 SMP Fri May 15 02:41:25 UTC 2026 x86_64 User : logmcpe ( 111175) PHP Version : 7.3.33 Disable Function : _dyuweyrj4,_dyuweyrj4r,dl MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0705) : /home/logmcpe/www/TEST/../MCPRO/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
require_once 'config.php';
$no=1;
$message = false;
$edit = '';
$check_in = '';
$produit_arr = array();
$fournisseur = array();
$counter = 0;
if(isset($_GET["edit"])){
$edit = $_GET["edit"];
$select = "SELECT * FROM check_in where id='$edit'";
$result = mysqli_query($conn,$select);
$check_in = mysqli_fetch_row($result);
}
//where status ='pending'
$select = "SELECT * FROM fournisseur";
$fournisseur = mysqli_query($conn,$select);
$select = "SELECT * FROM produits";
$produit = mysqli_query($conn,$select);
while ($row = mysqli_fetch_array($produit)) {
$produit_arr[] = $row;
}
if(isset($_POST["submit"])){
$products = array();
$quantity = "";
$edit = $_POST["edit"];
$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 = "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'";
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: check_in.php");
}
if(isset($_GET['delete'])){
$del = $_GET['delete'];
$query = "DELETE FROM booking WHERE id = '$del'";
mysqli_query($conn,$query);
}
if(isset($_GET['approve'])){
$app = $_GET['approve'];
$query = "UPDATE booking SET status = '1' WHERE id = '$app'";
mysqli_query($conn,$query);
}
?>
<!DOCTYPE html>
<html>
<head>
<?php require_once '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" />
</head>
<body class="hold-transition skin-blue sidebar-mini">
<div class="wrapper">
<header class="main-header">
<!-- Logo -->
<a href="../index.php" class="logo">
<span class="logo-mini"><b>A</b>LT</span>
<span class="logo-lg"><b>Admin</b></span>
</a>
<nav class="navbar navbar-static-top">
<a href="#" class="sidebar-toggle" data-toggle="offcanvas" role="button">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</a>
<div class="navbar-custom-menu">
<ul class="nav navbar-nav">
<li class="dropdown user user-menu">
<a href="#" class="dropdown-toggle" data-toggle="dropdown">
<span class="hidden-xs"> <?php echo "User"; ?></span>
</a>
</li>
</ul>
</div>
</nav>
</header>
<aside class="main-sidebar">
<?php require_once 'sidebar.php'; ?>
<!-- /.sidebar -->
</aside>
<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<section class="content-header">
<h1>
Add Check In
<small>Preview</small>
</h1>
</section>
<!-- Main content -->
<section class="content">
<div class="row">
<!-- left column -->
<div class="col-md-12">
<!-- general form elements -->
<div class="box box-primary">
<?php if($message){ ?>
<div class="alert alert-success">
<a class="close" data-dismiss="alert" href="#">×</a>Record Inserted Successfully!
</div>
<?php } ?>
<div class="box-header with-border">
<h3 class="box-title"></h3>
</div>
<!-- /.box-header -->
<!-- form start -->
<form role="form" id="add" name="add" method="post" enctype="multipart/form-data" action="<?php $_SERVER['PHP_SELF']; ?>">
<input type="hidden" name="edit" id="edit" value="<?php echo $check_in[0] ?>">
<div class="box-body">
<div class="row">
<div class="col-md-6">
<div class="form-group">
<label for="Date">Date: <?php echo $check_in[1]; ?></label>
<input type="date" class="form-control" id="date" value="<?php echo $check_in[1]; ?>" placeholder="Enter title" name="date" required>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label for="Reference">Reference</label>
<input type="text" class="form-control" value="<?php echo $check_in[2] ?>" id="reference" placeholder="Enter reference" name="reference" required>
</div>
</div>
</div>
<div class="row">
<div class="col-md-6">
<div class="form-group">
<label for="Supplier">Supplier</label>
<select class="form-control" id="supplier" name="supplier">
<option value="null">Select Supplier</option>
<?php
while ($row = mysqli_fetch_array($fournisseur)) {
if($check_in[3] == $row["Fournisseur_ID"]){
echo "<option value='".$row["Fournisseur_ID"]."' selected>".$row["Fournisseur_Nom"]."</option>";
}else{
echo "<option value='".$row["Fournisseur_ID"]."'>".$row["Fournisseur_Nom"]."</option>";
}
}
?>
</select>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label for="local">Local Storage</label>
<select class="form-control" id="local-storage" name="local-storage">
<option value="null">Select Local</option>
<?php
if($check_in[4] == "local1"){
?>
<option value="local1" selected>Local1 Linen</option>
<option value="local2">Local2 Linen</option>
<?php
}else if($check_in[4] == "local2"){
?>
<option value="local1">Local1 Linen</option>
<option value="local2" selected>Local2 Linen</option>
<?php
}
?>
</select>
</div>
</div>
</div>
<div class="row">
<div class="col-md-12">
<div class="form-group">
<label for="add-item">Add Item</label>
<select onchange="selectChange()" class="form-control js-example-basic-single" id="product" placeholder="Add Item" name="product" required>
<option value="null">Select Local</option>
<?php
foreach ($produit_arr as $k => $val) {
echo "<option value='".$produit_arr[$k]["Produit_ID"]."'>".$produit_arr[$k]["Produit_Designation"]."</option>";
}
?>
</select>
</div>
<table id="myTable" class="table order-list table-bordered table-striped">
<thead>
<tr>
<td>Description</td>
<td>Quantity</td>
<td><i class="fa fa-trash"></i></td>
</tr>
</thead>
<tbody>
</tbody>
<tfoot>
<?php
$c_id = $check_in[0];
$query = "SELECT * FROM product_command WHERE check_in_id='$c_id'";
$resu = mysqli_query($conn,$query);
while($row2 = mysqli_fetch_array($resu)){
?>
<tr>
<td>
<input type="hidden" class="form-control" value="<?php echo $row2[0]; ?>" readonly name="product[]<?php echo $counter; ?>"/><p>
<?php
foreach ($produit_arr as $k => $val) {
if($row2[2] == $produit_arr[$k]["Produit_ID"]){
echo $produit_arr[$k]["Produit_Designation"];
}
}
?>
</p>
</td>
<td>
<input type="number" class="form-control" value="<?php echo $row2[3]; ?>" name="quantity[]<?php echo $counter; ?>"/>
</td>
<td>
<span style="cursor:pointer;"><i id="ibtnDel" name="ibtnDel" class="ibtnDel fa fa-trash"></i></span>
</td>
</tr>
<?php
$counter++;
}
?>
<tr>
</tr>
</tfoot>
</table>
</div>
</div>
<div class="row">
<div class="col-md-12">
<div class="form-group">
<label for="note">Note</label>
<textarea id="note" name="note"><?php echo $check_in[5]; ?></textarea>
</div>
</div>
</div>
<div class="box-footer">
<button type="submit" class="btn btn-primary" name="submit">Edit Check In</button>
</div>
</form>
</div>
<!-- /.box -->
</div>
</div>
<!-- /.row -->
</section>
<!-- /.content -->
</div>
<!-- /.content-wrapper -->
<footer class="main-footer">
<strong>Copyright © 2019 .</strong> All rights
reserved.
</footer>
</div>
<!-- ./wrapper -->
<script src="plugins/select2/select2.min.js"></script>
<!-- page script -->
<script>
// In your Javascript (external .js resource or <script> tag)
$(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[]' + counter + '"/><p>'+name+'</p></td>';
cols += '<td><input type="number" class="form-control" value="1" name="quantity[]' + counter + '"/></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>
</body>
</html>