|
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/feuillesroute/../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;
include('file_tache.php');
// if(!empty($_POST)){
// echo '<pre>';
// print_r($_POST);
// echo '</pre>';
// exit() ;
// }
// error_reporting(E_ALL)l;
// ini_set("display_errors", 1);
ini_set('display_errors','Off');
ini_set('error_reporting', E_ALL );
define('WP_DEBUG', false);
define('WP_DEBUG_DISPLAY', false);
ini_set('memory_limit', '1000M');
$pagemenu = basename($_SERVER["PHP_SELF"]) ;
$now = time();
function dateDiff($date1, $date2){
$diff = abs($date1 - $date2); // abs pousr avoir sla valeur absolute, ainsi éviter d'avoir une différence négative
$retour = array();
$tmp = $diff;
$retour['second'] = $tmp % 60;
$tmp = floor( ($tmp - $retour['second']) /60 );
$retour['minute'] = $tmp % 60;
$tmp = floor( ($tmp - $retour['minute'])/60 );
$retour['hour'] = $tmp % 24;
$tmp = floor( ($tmp - $retour['hour']) /24 );
$retour['day'] = $tmp;
return $retour;
}
// echo '<pre>';jjj
// print_r($_POST);
// echo '</pre>';
// ini_set('display_errors','on');
// error_reporting(E_ALL);
///////////variable session de client ///////////////////////////////
if(!empty($_GET['client_id']))
{
$_SESSION["client_id"]=$_GET['client_id'];
}
$client_id =$_SESSION["client_id"] ;
//////////////////////////function////////////////////////////////////
function get_drop_down_reglement2 ($name='', $param = '', $value='')
{
$q = dbi_query("SELECT * FROM reglementt") ;
$res = "<select class='form-control' name=\"$name\" $param>" ;
while($r = dbi_fetch_row($q))
$res .= "<option value=\"{$r['reglement_id']}\"".($r['reglement_id'] == $value ? ' selected' : (($value==''&&$r['reglement_id'] == 2) ? ' selected' : '')).">".utf8_encode($r['reglement_desc'])."</option>" ;
return "$res</select>" ;
}
// /////////////////////saisir infos de facturations ///////////////////////////////////
if( isset($_POST['reglement_delai']) && isset($_POST['client_id']) )
{
$Client_ID=$_POST['client_id'];
$client_nom=$_POST['client_nom'];
$client_facture_mail='';
$client_env_mail = $_POST['client_env_mail'];
$litige='';
$client_facture_mail = $_POST['client_facture_mail'];
$litige = $_POST['litige'];
$reglement_id = $_POST['reglement_id'];
$reglement_delai = $_POST['reglement_delai'] ;
$sqlupdate1 = "UPDATE ".TABLE_CLIENT." SET reglement_id="."'$reglement_id'"." , reglement_delai="."'$reglement_delai'"." ,client_env_mail="."'$client_env_mail'".", client_facture_mail="."'$client_facture_mail'".", litige="."'$litige'"." WHERE client_id = $Client_ID" ;
dbi_query ( $sqlupdate1 );
header('Location:fcreglement.php?msg=bien Modifié&color=success');
}
$client = $client_id ? dbi_fetch_row(dbi_query("SELECT * FROM ".TABLE_CLIENT." a WHERE client_id = $client_id")) : array() ;
if (isset($_GET['action'])&&($_GET['action']=='sup')&&isset($_GET['paiement_id']))
{
dbi_query("DELETE FROM ".TABLE_PAIEMENT." WHERE paiement_id='".$_GET['paiement_id']."' LIMIT 1") ;
header('Location:fcreglement.php?msg=reglement bien supprimé&color=success');
}
if(isset($_POST['reg']) && !empty($_POST['fact']) )
{
// $id
$dater = sprintf("%04d%02d%02d", $_POST["dateryear"], $_POST["datermonth"], $_POST["daterday"]) ;
if(isset($_POST['montant'])) {
// echo '<pre>';
// print_r($_POST);
// echo '</pre>';
$dater =date2int_DSI($_POST[datefacture]) ;
// echo "==>".$dater."<br/>" ;
// exit() ;
//payerFacture($id, $montant, $_POST['mode'][$id]) ;
payerFacture($_POST['fact'],$_POST['montant'], $_POST['mode'],NULL, $_POST['chek'], $_POST['bank'],$dater) ;
header('Location:fcreglement.php?msg=reglement bien ajouté&color=success');
}
}
?>
<!DOCTYPE html>
<html>
<head>
<?php include('header.php'); ?>
<!-- jQuery 2.2.3
<script type="text/javascript" src="plugins/selectize/selectize.js"></script>
<link rel="stylesheet" type="text/css" href="plugins/selectize/selectize.css" />
<script type="text/javascript" src="plugins/selectize/selectize.min.js"></script>
<link rel="stylesheet" type="text/css" href="plugins/selectize/selectize.default.css" />
<link rel="stylesheet" href="../../plugins/summernote/summernote-bs4.css">
<script src="plugins/jQuery/jquery-2.2.3.min.js"></script>
<script src="bootstrap/js/bootstrap.min.js"></script>
<script src="plugins/datatables/jquery.dataTables.min.js"></script>
<script src="plugins/slimScroll/jquery.slimscroll.min.js"></script>
-->
<style type="text/css">
.modal-backdrop {
/* bug fix - no overlay */
display: none;
}
</style>
<!-- SlimScroll -->
</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>
<li><button href="#myModal" id="custId" data-toggle="modal" type="button" class="btn btn-info" > NOUVEAU REGLEMENT </button></h3> </li>
  <li> <h3><a href="#myModal_tache_all" id="custId" data-toggle="modal" > <button type="button" class="btn btn-primary" > <i class="fas fa-plus"></i> NOUVELLE TACHE</button> </a></h3></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'); ?>
<div class="modal fade" id="myModal_tache_all" 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_tache_all" ></div>
</div>
</div>
</div>
<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">
<!-- 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 -->
<!-- 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 -->
<?php include('widget_client.php'); ?>
<!-- BARRE DE NAVIGATION DU CLIENT -->
<?php include('menu_client.php'); ?>
</div>
<!-- PASSAGE A LA COLONNE DE DROITE-->
<div class="col-lg-9">
<?php
// die('');
$query = "SELECT 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 ".TABLE_FACT." 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 ".TABLE_PAIEMENT." where client_id = $client_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 ".TABLE_AVOIR." group by fact_id) a ON f.fact_id = a.fact_id
WHERE f.client_id=$client_id
AND f.agence_id=$agence
AND if(p.paye is null, 0, p.paye)+if(a.avoir is null, 0, a.avoir) %s total
GROUP BY date_fact, f.fact_id, total
order by num_fact DESC" ;
$q = dbi_query(sprintf($query, '>=')) ;
$query2 = "SELECT 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 ".TABLE_FACT." 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 ".TABLE_PAIEMENT." where client_id = $client_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 ".TABLE_AVOIR." group by fact_id) a ON f.fact_id = a.fact_id
WHERE f.client_id=$client_id
AND f.agence_id=$agence
AND if(p.paye is null, 0, p.paye)+if(a.avoir is null, 0, a.avoir) %s total
GROUP BY date_fact, f.fact_id, total
order by num_fact DESC" ;
$q = dbi_query("SELECT sum(f.total)
FROM (
(select -montant total from ".TABLE_PAIEMENT." where client_id='$client_id' AND agence_id='$agence')
union all
(
SELECT total-sum(if(a.montant is null, 0, a.montant)) AS total
FROM ".TABLE_FACT." f
LEFT JOIN ".TABLE_AVOIR." a ON f.fact_id = a.fact_id
WHERE f.client_id='$client_id'
AND f.agence_id='$agence'
GROUP BY f.fact_id, f.total
)
) f") ;
list($solde) = dbi_fetch_row($q) ;
// echo "==>"
list($regl) = dbi_fetch_row(dbi_query("select date from ".TABLE_PAIEMENT." where client_id=$client_id AND agence_id=$agence order by date DESC limit 1")) ;
// echo "select date from ".TABLE_PAIEMENT." where client_id=$client_id AND agence_id=$agence order by date DESC limit 1" ;
// echo " solde ===> ".number_format($solde, 2, ', ', ' ')."<br/>";
// echo " DERNIER REGLEMENT ===> ".int2date($regl) ;
?>
<div class="row">
<div class="col-lg-6 col-6">
</div>
<div class="col-lg-3 col-6">
<div class="small-box bg-info">
<a href="#" class="small-box-footer">SOLDE :
<h3><div id='TOTALCAHT'><?php echo number_format( $solde, 2, ',', ' ').'<sup style="font-size: 20px">€ </sup>';?></div></h3>
</a>
</div>
</div>
<div class="col-lg-3 col-6">
<div class="small-box bg-info">
<a href="#" class="small-box-footer">DERNIER REGLEMENT :
<h3><div id='TOTALCA'><?php echo int2date($regl).'<sup style="font-size: 16px"></sup>';?></div></h3>
</a>
</div>
</div>
</div>
<div class="row">
<div class="col-lg-12">
<!-- CARD DE DROITE-->
<div class="card">
<div class="card-body">
<!-- ><section class="content"> CARD DE DROITE-->
<?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 }
$q = dbi_query("SELECT * FROM ".TABLE_PAIEMENT." p LEFT JOIN ".TABLE_FACT." f USING(fact_id) LEFT JOIN reglementt r USING(reg_id) where p.client_id = '$client_id' AND p.agence_id='$agence' order by num_fact DESC") ;
// echo "SELECT * FROM ".TABLE_PAIEMENT." p LEFT JOIN ".TABLE_FACT." f USING(fact_id) LEFT JOIN reglementt r USING(reg_id) where p.client_id = '$client_id' AND p.agence_id='$agence' order by num_fact DESC <br/>" ;
if(mysqli_num_rows($q))
{
?><br clear="all" />
<div id="tab">
<div class="box-body">
<table id="" class="table table-hover">
<thead>
<tr>
<th style="text-align:center;">Numéro de Facture</th>
<th style="text-align:center;">Date du règlement</th>
<th style="text-align:center;">Mode de règlement</th>
<th style="text-align:center;">Montant réglé</th>
<th style="text-align:center;"></th>
</tr>
</thead>
<tbody>
<?php
while($f = dbi_fetch_row($q))
{
list($montant)=dbi_fetch_row(dbi_query("SELECT montant FROM `paiement` WHERE `paiement_id` = ".$f['paiement_id'])) ;
// echo "<pre>" ;
// print_r($f) ;
// echo "</pre>" ;
list($reglement_iddd, $dateee)=dbi_fetch_row(dbi_query(" SELECT reglement_id , date FROM `paiement` WHERE `paiement_id` = ".$f['paiement_id'])) ;
list($f['reglement_desc']) = dbi_fetch_row(dbi_query(" SELECT reglement_desc FROM `reglement` WHERE `reglement_id` = ".$reglement_iddd )) ; // ancien code
// list($f['reglement_desc']) = dbi_fetch_row(dbi_query(" SELECT reglement_desc FROM `reglement` WHERE `reglement_id` = ".$f['reglement_id'] )) ; // ancien code
?>
<tr>
<td style="text-align:center;"><?=$f['num_fact']?></td>
<td style="text-align:center;"><?=int2date($dateee)?></td>
<td style="text-align:center;"><?=$f['reglement_desc']?><?=($f['reglement_desc']=='Chèque'?' N°'.$f['num_cheque']." (".$f['banque'].")":'')?></td>
<td style="text-align:center;"><?=number_format($montant, 2, ', ', ' ')?> €</td>
<td style="text-align:center;"> <a href="<?="?client_id=$client_id&agence_id=$agence&action=sup&paiement_id=".$f['paiement_id']?>" onclick="return confirm('Voulez-vous vraiment supprimer ce règlement ?');" class="btn btn-danger btn-sm"> </i> <i class="fas fa-trash"></i> </a> </td>
</tr>
<?php
}
echo '
</tbody>
</table>
</div></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 -->
<?php include('footerr.php'); ?>
<!-- Control Sidebar -->
<aside class="control-sidebar control-sidebar-dark">
<!-- Control sidebar content goes here -->
</aside>
<!-- /.control-sidebar -->
</div>
<!-- ./wrapper -->
<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 : 'ajaxModifierReglement.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>
<script type="text/javascript">
$(document).ready(function(){
$('#myModal_tache_all').on('show.bs.modal', function (e) {
var rowid = $(e.relatedTarget).data('id');
$.ajax({
type : 'post',
url : 'tache_ajax_nv_all.php', //Here you will fetch records
data : 'rowid='+ rowid, //Pass $id
success : function(data){
$('#fetch_tache_all').html(data);//Show fetched data from database
}
});
});
});
</script>
</body>
</html>