|
Server IP : 10.128.40.6 / Your IP : 216.73.216.180 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/../MC/temp/12650/../1322/../../../mcg/.github/../pages/python/../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;
// echo "<pre>" ;
// print_r($_GET) ;
// echo "<pre>" ;
$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'];
}
// print_r($customerList) ;
// $q= dbi_query("SELECT * FROM produits") ;
$order = " c.client_nom ASC " ;
if($_SESSION["id_etab"]== 2 ){
$order = " c.reglement_id ASC " ;
}
else{
$order = " c.client_nom ASC " ;
}
$query = dbi_query("SELECT f.client_id, client_pnom, client_nom, f.num_fact, c.reglement_id,
f.fact_id, total,total-sum(if(p.montant is null, 0, p.montant))-sum(if(a.montant is null, 0, a.montant)) AS paye,
if(a.montant is null, 0, a.montant) avoir,
f.date_fact, f.relance, IF(client_genre='SERENA',1,0) as serena
FROM ".TABLE_FACT." f
LEFT JOIN ".TABLE_PAIEMENT." p ON f.fact_id=p.fact_id AND f.client_id=p.client_id
LEFT JOIN ".TABLE_AVOIR." a ON f.fact_id = a.fact_id
LEFT JOIN ".TABLE_CLIENT." c ON c.client_id = f.client_id
WHERE f.agence_id=$agence and c.reglement_id = 1
GROUP BY date_fact, f.fact_id, total
HAVING paye > 0.001
ORDER BY serena, ".(empty($order) ? 'num_fact' : $order)) ;
$total_paye=0;
$total_serena=0;
$total_clients=0;
$total_cesu=0;
$total_prelevement=0;
$total_cheque=0;
$total_virement=0;
$total_especes=0;
$serena=0;
while($f = dbi_fetch_row($query))
{
if ($f['serena']) $total_serena+=$f['paye'];
else $total_clients+=$f['paye'];
$total_paye+=$f['paye'];
switch ($f['reglement_id']) {
case 1:
$total_prelevement+=$f['paye'];
break;
case 2:
$total_cheque+=$f['paye'];
break;
case 3:
$total_cesu+=$f['paye'];
break;
case 4:
$total_virement+=$f['paye'];
break;
case 5:
$total_especes+=$f['paye'];
break;
}
}
mysqli_data_seek($query,0);
?>
<!DOCTYPE html>
<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">
<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>
</li>
</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 idbursel="";
idbureausel = document.bureau_form.client_bureau.value ;
if( idbureausel > 0 || idbureausel=="INDEFINI" )
window.location = "etat_stock.php?idbureausel="+idbureausel;
else
window.location = "etat_stock.php";
}
</script>
<section class="content">
<div class="row">
<div class="col-12">
<div class="card card-primary card-outline">
<div class="card-header">
<div class="row">
<div class="col-sm-11">
<h3 class="card-title"> <i class="nav-icon fas fa-id-card"></i> Prélèvement </h3>
</div>
</div>
</div>
<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="example1" class="table table-bordered table-striped">
<thead>
<tr>
<th>N° </th>
<th>Client</th>
<th>Net à payer</th>
<th>Date</th>
</tr>
</thead>
<tbody>
<?php
$compteur=0;
$previous=1;
$serena=0;
$c = 0 ;
$b = 1000 ;
$yas = 10000 ;
while($f = dbi_fetch_row($query))
{
if (!($compteur % 2)) $style='td_listing0';
else $style='td_listing1';
$compteur++;
$icone = '<img src="images/icones/client.png" width="16" height="16" border="0" alt="">';
$serena=$f['serena'];
if (($serena)&&!($serenap)) echo '<tr><td class="td_listing0" colspan="12" style="padding-left:10px; height=20px">
<h2>Serena</h2></td></tr>';
if ($serena) $icone = '<img src="images/icones/serena.gif" width="16" height="16" border="0" alt="">';
$serenap=$f['serena'];
?>
<tr>
<td><?=$f['num_fact']?></td>
<td><?=strtoupper($f['client_nom']).' '.ucwords(strtolower($f['client_pnom']))?></td>
<td align="right" class="<?=$style?>" style="padding:8px" ><input type="hidden" id="<?=$c?>" value="<?=number_format($f['paye'], 2, ',', '')?>"> <?=number_format($f['paye'], 2, ',', '')?>
<?=($f['avoir'] > 0) ? '<br>(avoir de '.number_format($f['avoir'], 2, ', ', ' ').' )' : ''?> </td>
<?
if($f['reglement_id']== 2)
{
// echo "--->".$f['client_id'] ;
$client_id= $f['client_id'] ;
$bnk = dbi_fetch_row(dbi_query("SELECT * FROM `paiement` WHERE client_id='$client_id' AND agence_id = '$agence' ORDER BY `paiement`.`paiement_id` DESC limit 0,1")) ;
// echo $bnk ;
}
?>
<td><?=int2date($f['date_fact'])?></td>
<?
}
?>
</tr>
<tr>
<td align="center" > Total </td>
<td align="center" > </td>
<td align="center" > <?=$total_prelevement?> </td>
<td align="center"> </td>
</tr>
</tfoot>
</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>
<!-- /.card -->
<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 src="../../plugins/bs-custom-file-input/bs-custom-file-input.min.js"></script>
<script type="text/javascript">
$(document).ready(function () {
bsCustomFileInput.init();
});
</script>
</body>
</html>