|
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/mcg/pages/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;
$pagemenu = basename($_SERVER["PHP_SELF"]) ;
$TOTALREG = 0;
?>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<!--kkk Enregistrer le titre de la page --><title> LogMCPRO | Client</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">
<!-- Google Font: Source Sans Pro -->
<link href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700" rel="stylesheet">
<!-- DataTables -->
<link rel="stylesheet" href="../plugins/datatables-bs4/css/dataTables.bootstrap4.css">
<!-- overlayScrollbars -->
<link rel="stylesheet" href="../dist/css/adminlte.min.css">
<style>
.myCollapse {
display: none;
}
.myCollapse.in {
display: block;
}
.modal-header {
padding: 15px;
border-bottom: 1px solid #e5e5e5;
}
.modal-header {
background: #226faa;
background: -webkit-gradient(linear,left top,right top,from(#226faa),color-stop(37%,#2989d8),to(#72c0d3));
background: linear-gradient(to right,#226faa 0,#2989d8 37%,#72c0d3 100%);
border-radius: 6px;
color: #fff;
padding: 18px;
border-bottom-left-radius: 0;
border-bottom-right-radius: 0;
border-color: transparent;
}
.modal-header .close {
margin-top: -3px;
font-size: 24px;
font-weight: 400;
color: #fff;
opacity: .9;
width: 28px;
height: 28px;
padding-bottom: 0;
padding-left: 1px;
}
button.close {
padding: 0;
cursor: pointer;
background: 0 0;
border: 0;
-webkit-appearance: none;
-moz-appearance: none;
appearance: none;
}
</style>
</head>
<body class="hold-transition sidebar-mini">
<!-- Site wrapper -->
<div class="wrapper">
<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>
</ul>
<!-- liens TOP MENU DROITE -->
<ul class="navbar-nav ml-auto">
<!-- Placer ici l'élément à positionner à droite du TOP MENU -->
</ul>
</nav> <!-- fin du TOP MENU -->
<?php include('menu.php'); ?>
<!-- Ne pas toucher au dessus / fin de la BARRE DE NAVIGATION-->
<!-- 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="col-sm-6">
<h1 class="m-0 text-dark"></h1>
</div><!-- /.col -->
<div class="col-sm-6">
</div><!-- /.col -->
</div><!-- /.row -->
</div><!-- /.container-fluid -->
</div>
<!-- /.content-header -->
<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>
<!-- PAGE PRINCIPALE -->
<div class="content">
<div class="container-fluid">
<div class="row">
<!-- DEFINITION DES COLONNES -->
<div class="col-lg-3">
<!-- WIDGET AVEC LE NOM DU CLIENT -->
<div class="info-box mb-3 bg-info">
<div class="info-box-content">
<span class="info-box-text"><b> <h1><div id='TOTALREG'><?php echo number_format( $TOTALREG, 2, ',', ' ').'<sup style="font-size: 20px">€ </sup>';?></div></h1></b></span>
</div>
</div>
<!-- BARRE DE NAVIGATION DU CLIENT -->
<?php include('menu_recouvrement.php'); ?>
</div>
<!-- PASSAGE A LA COLONNE DE DROITE-->
<div class="col-lg-9">
<div class="row">
<div class="col-lg-12">
<!-- CARD DE DROITE-->
<div class="card">
<div class="card-header"><h5 class="m-0"><i class="nav-icon far fas fa-chart-line"></i> <?php echo strtoupper ("Encours en Retard +20 ") ; ?> </h5></div>
<div class="card-body">
<div class="box-body">
<table id="example1" class="table table-bordered table-striped">
<thead>
<tr>
<TH align="center" >Clientéé</TH>
<TH align="center" >Encours</TH>
<TH align="center" >Nombre de Pieces </TH>
<TH align="center" > </TH>
</tr>
</thead>
<tbody>
<?php
$Client=array();
$order=' ASC ';
$query = dbi_query("SELECT f.client_id, client_nom, reglement_delai , f.num_fact,
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
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
GROUP BY date_fact, f.fact_id, total
HAVING paye > 0.001
ORDER BY client_nom $order , f.date_fact ASC ") ;
$today = date('Ymd');
$todayform = date('Y-m-d');
while($f = dbi_fetch_row($query))
{
$a = int2date($f['date_fact'],'Y-m-d') ;
$date_fact_plus_reglement_delai = date("Y-m-d", strtotime("$a +".$f['reglement_delai']." days"));
$date1 = new DateTime($date_fact_plus_reglement_delai);
$date2 = new DateTime($todayform);
$diff = $date2->diff($date1)->format("%a");
$tabloTest = explode('-', $date_fact_plus_reglement_delai);
$date_fact_plus_reglement_delai = $tabloTest[0].''.$tabloTest[1].''.$tabloTest[2];
if($date_fact_plus_reglement_delai <= $today )
{
$Client[$f['client_id']][]=$f;
}
}
$nonlitige = dbi_query("SELECT * FROM client where client_id in (SELECT client_id FROM `client_suivi` where `suivi_id` = 21 and client_suivi_clos = '0') and client_statut = '1' ORDER BY client_nom ") ;
while($non_litige = dbi_fetch_row($nonlitige))
{
$tab_non_litige[] = $non_litige['client_id'] ;
}
$R=dbi_query("SELECT reglement_delai regday ,client_id id, client_nom civ FROM ".TABLE_CLIENT." ORDER BY civ");
while($cl = dbi_fetch_row($R))
{
$client_id=$cl['id'];
$a=$client_id ;
$nb=count($Client[$client_id]);
$soldaa = 0 ;
for($i=0 ; $i<$nb ;$i++ )
{
$soldaa=$Client[$client_id][$i]['paye'] + $soldaa ;
}
if($soldaa != 0)
{
$suiva = dbi_query("SELECT * FROM `client_suivi` WHERE client_id = $a and client_suivi_clos = '0' ") ;
$recouvrement = "" ;
$litige = "" ;
$Compta = "" ;
while($ss = dbi_fetch_row($suiva))
{
if($ss['suivi_id']== 10)
{
$recouvrement = "<i class='fa fa-fw fa-check' ></i>" ;
}
if($ss['suivi_id']== 21)
{
$litige = "<i class='fa fa-fw fa-check' ></i>" ;
}
if($ss['suivi_id']== 25)
{
$Compta = "<i class='fa fa-fw fa-check' ></i>" ;
}
}
$suiv = dbi_query("SELECT * FROM `client_suivi`,`suivi` , suivi_biais WHERE client_id = $a and client_suivi.suivi_id = `suivi`.suivi_id and suivi_parent_id != 0 and client_suivi.client_suivi_clos = '0' and ( suivi.suivi_id = 21 or suivi.suivi_id = 25 or suivi.suivi_id = 10 ) ORDER BY suivi_date DESC") ;
list($suivdate) = dbi_fetch_row (dbi_query("SELECT UNIX_TIMESTAMP(suivi_date) FROM `client_suivi`,`suivi` , suivi_biais WHERE client_id = $a and client_suivi.suivi_id = `suivi`.suivi_id and suivi_parent_id != 0 and client_suivi.client_suivi_clos = '0' and ( suivi.suivi_id = 21 or suivi.suivi_id = 25 or suivi.suivi_id = 10 ) ORDER BY suivi_date DESC")) ;
$suivRoucv = dbi_query("SELECT * FROM `client_suivi`,`suivi` , suivi_biais WHERE client_id = $a and client_suivi.suivi_id = `suivi`.suivi_id and client_suivi.client_suivi_clos = '0' and suivi.suivi_id = 10 ORDER BY suivi_date DESC") ;
$suivlitge = dbi_query("SELECT * FROM `client_suivi`,`suivi` , suivi_biais WHERE client_id = $a and client_suivi.suivi_id = `suivi`.suivi_id and client_suivi.client_suivi_clos = '0' and ( suivi.suivi_id = 21 or suivi.suivi_id = 25 or suivi.suivi_id = 10 ) ORDER BY suivi_date DESC") ;
$suivcompta = dbi_query("SELECT * FROM `client_suivi`,`suivi` , suivi_biais WHERE client_id = $a and client_suivi.suivi_id = `suivi`.suivi_id and client_suivi.client_suivi_clos = '0' and ( suivi.suivi_id = 21 or suivi.suivi_id = 25 or suivi.suivi_id = 10 ) ORDER BY suivi_date DESC") ;
$sRoucv = dbi_fetch_row($suivRoucv) ;
$slitige = dbi_fetch_row($suivlitge) ;
$scompta = dbi_fetch_row($suivcompta) ;
if($sRoucv['suivi_parent_id']== 0)
{
$rec= $sRoucv['client_suivi_id'] ;
// echo "yasss $rec <br/>" ;
}
else
{
$rec= $sRoucv['suivi_parent_id'] ;
// echo "aa $rec <br/>" ;
}
if($slitige['suivi_parent_id']== 0)
{
$litg= $slitige['client_suivi_id'] ;
}
else
{
$litg= $slitige['suivi_parent_id'] ;
}
if($scompta['suivi_parent_id']== 0)
{
$comp= $scompta['client_suivi_id'] ;
}
else
{
$comp= $scompta['suivi_parent_id'] ;
}
$s = dbi_fetch_row($suiv) ;
if(!empty($s['client_suivi_id']))
{
$suiva = dbi_query("SELECT suivi_biais_id FROM `client_suivi` WHERE client_id = $a and client_suivi_id = ".$s['client_suivi_id']) ;
}
$ssv = dbi_fetch_row($suiva) ;
if(!empty($ssv['suivi_biais_id']))
{
$suiva2 = dbi_query(" SELECT * FROM `suivi_biais` WHERE suivi_biais_id = ".$ssv['suivi_biais_id']) ;
}
$ssv_bia = dbi_fetch_row($suiva2) ;
$action = '';
if($s['suivi_programme']=='1')
{
if ($ssv['suivi_biais_id']=='4')
$action = ' '.$ssv_bia['suivi_biais_intitule'].' effectué';
else if ($s['suivi_programme']=='1')
$action = ' Prévoir un '.strtolower($ssv_bia['suivi_biais_intitule']);
else $action = $s['suivi_biais_intitule'].' effectué';
if ($ssv['suivi_biais_id']=='6')
$action = ' Prévoir une '.strtolower($ssv_bia['suivi_biais_intitule']);
$total+= $l['montant_devis'];
// if($s['suivi_date'])
// $action = mysql_datefrrr($s['suivi_date'],'-','Djma').' <b>'.$action;
// else
// $action = "";
}
else
{
$action = '';
}
if($action != "")
{
list($n , $p) = dbi_fetch_row(dbi_query(" SELECT Admin_nom,Admin_pnom FROM `administratif` where Admin_ID = ".$s['Admin_ID'] )) ;
$salarier_admin = $n." ".$p ;
}
else
{
$salarier_admin = "" ;
}
$get = 'client_id='.$a;
$date_fact_plus_reglement_delai = date("Y-m-d", strtotime($Client[$client_id][0]['date_fact']."+".$cl['regday']." days"));
$date1 = new DateTime($date_fact_plus_reglement_delai);
$date2 = new DateTime($todayform);
$diff = $date2->diff($date1)->format("%a");
$query = dbi_query("SELECT f.client_id, client_nom, reglement_delai , f.num_fact,
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
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.client_id = $client_id
GROUP BY date_fact, f.fact_id, total
HAVING paye > 0.001 ") ;
$tabnumfact = array();
while($acd = dbi_fetch_row($query))
{
$tabnumfact[] =$acd['num_fact'] ;
}
$ab =count($tabnumfact); ;
if($diff>=20)
{
$depasse = mktime(0,0,0,date("m"), date("d")+1, date("Y"));
$de= mktime($s['suivi_date'] );
if( $suivdate< $depasse )
{
$color= "rouge" ;
}
else
{
$color= "normale" ;
}
$indice=0 ;
for($k=0 ; $k<=count($tab_non_litige) ; $k++)
{
if($tab_non_litige[$k] == $client_id )
{
$indice= 1 ;
break ;
}
}
if( $indice != 1)
{
$CA+=$soldaa;
if(!empty($solde))
$solde=number_format($solde, 2, ', ', '');
echo '<tr>';
echo "<td>".$cl['civ']."</td>";
echo "<td>$soldaa</td>";
echo "<td>$nb</td>";
?>
<td style="text-align:center;vertical-align: middle;white-space: nowrap;"><?php echo '<a class="btn btn-info btn-sm" href="#myModal" id="custId" data-toggle="modal" data-id="'.$client_id.'">Recouvrement
</a>';?></td>
<?php
echo '</tr>';
}
}
}
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- /.row -->
</div><!-- /.container-fluid -->
</div>
<!-- Control Sidebar -->
<aside class="control-sidebar control-sidebar-dark">
<!-- Control sidebar content goes here -->
<div class="p-3">
<h5>Title</h5>
<p>Sidebar content</p>
</div>
</aside>
<!-- /.control-sidebar -->
<footer class="main-footer">
<div class="float-right d-none d-sm-block">
<b>Version</b> 3.0.1
</div>
<strong>Copyright © 2014-2019 <a href="http://adminlte.io">AdminLTE.io</a>.</strong> All rights
reserved.
</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>
<!-- DataTables -->
<script src="../plugins/datatables/jquery.dataTables.js"></script>
<script src="../plugins/datatables-bs4/js/dataTables.bootstrap4.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 () {
var TOTALREG ="<?php echo number_format( $CA, 2, ',', ' ').' € ';?>";
$('#TOTALREG').html(TOTALREG);
})
</script>
<script>
// $(function () {
// Summernote
// $('.textarea').summernote()
// }) ;
$(document).ready(function(){
$('#myModal').on('show.bs.modal', function (e) {
var rowid = $(e.relatedTarget).data('id');
$.ajax({
type : 'post',
url : 'voir_recouvrement.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 () {
$("#example1").DataTable();
$('#example2').DataTable({
"paging": true,
"lengthChange": false,
"searching": false,
"ordering": true,
"info": true,
"autoWidth": false,
});
});
</script>
</body>
</html>