|
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/MCPRO/temp/../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include_once 'code/init.php';
?>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<?php
function get_drop_down_reglement2 ($name='', $param = '', $value='')
{
$q = dbi_query("SELECT * FROM ".TABLE_REGLEMENT."") ;
$res = "<select 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>" ;
}
$tval='';
$zero=' AND f.client_id =0 ';
// echo " ! $tval ! ";
// print_r($_GET);
/*
if(isset($_POST['valider']))
{
// print_r($_POST['v']." kkkkkkkkkk ");
$datep=$au = sprintf("%04d%02d%02d", $_POST['datepyear'], $_POST['datepmonth'], $_POST['datepday']) ;
// print_r($_POST);
// $client_id = $_POST['client_id'];
// echo " !!!! $datep";
foreach($_POST['fact'] as $id => $montant){
if($montant) {
//payerFacture($id, $montant, $_POST['mode'][$id]) ;
// payerFacture($id, $montant, $_POST['mode'][$id],NULL, $_POST['chek'][$id], $_POST['bank'][$id],$datep) ;
}
// payerFacture($_POST['fact'], $_POST['montant'], $_POST['mode'], $_POST['client_id'],$_POST['chek'],$_POST['bank']);
}
} */
if(isset($_POST['fact']) && (isset($_POST['save'] )|| isset($_GET['idf'])) )
{
if (isset($_GET['idf']))
{
// echo " +++++ ";
foreach($_POST['fact'] as $id => $montant){
if($id==$_GET['idf']){
// echo ' !! '.$_POST["datepyear$id"];
$datep = sprintf("%04d%02d%02d", $_POST["datep".$id."year"], $_POST["datep".$id."month"], $_POST["datep".$id."day"]) ;
if($montant) {
//payerFacture($id, $montant, $_POST['mode'][$id]) ;
payerFacture($id, $montant, $_POST['mode'][$id],NULL, $_POST['chek'][$id], $_POST['bank'][$id],$datep) ;
}
}
}
}
else
{
foreach($_POST['fact'] as $id => $montant){
// echo ' !! '.$_POST["datepyear$id"];
$datep = sprintf("%04d%02d%02d", $_POST["datep".$id."year"], $_POST["datep".$id."month"], $_POST["datep".$id."day"]) ;
if($montant) {
//payerFacture($id, $montant, $_POST['mode'][$id]) ;
payerFacture($id, $montant, $_POST['mode'][$id],NULL, $_POST['chek'][$id], $_POST['bank'][$id],$datep) ;
}
}
// echo "ok";
// print_r($_POST);
// echo " !! ".$datep." // ";
/*
if($montant) {
//payerFacture($id, $montant, $_POST['mode'][$id]) ;
payerFacture($id, $montant, $_POST['mode'][$id],NULL, $_POST['chek'][$id], $_POST['bank'][$id]) ;
}*/
}
}
elseif(isset($_POST['relance']) )
{
include 'includes/factureV3.php';
$clients_relances = array();
foreach($_POST['fact'] as $id => $montant)
{
// on relance pour chaque facture
$f = new Facture ($id, true);
list($relance, $fact_id, $client_id) = dbi_fetch_row(dbi_query("SELECT relance, fact_id, client_id FROM ".TABLE_FACT." WHERE fact_id = ".$id));
$relance++;
if (!is_dir("factures/$client_id"))
{
mkdir("factures/$client_id", 0755) ;
chmod("factures/$client_id", 0755) ;
}
$f->Output("factures/$client_id/$id-$relance.pdf", 'F');
dbi_query("UPDATE ".TABLE_FACT." SET relance = $relance WHERE fact_id = ".$fact_id) ;
if(!in_array($client_id,$clients_relances)) $clients_relances[]=$client_id;
}
foreach($clients_relances as $client_id)
{
$email = dbi_fetch_row(dbi_query("SELECT client_email, client_fmail FROM ".TABLE_CLIENT." WHERE client_id='$client_id' AND agence_id = '$agence'")) ;
if($email['client_email']!='' && $email['client_fmail']=='1') envoyer_email('relance',$client_id);
}
}
$order=' ASC ';
$query = dbi_query("SELECT f.client_id, client_pnom, client_nom, f.num_fact, c.client_reglement,
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 $tval $zero
GROUP BY date_fact, f.fact_id, total
HAVING paye > 0.001
ORDER BY client_nom $order , client_pnom $order , f.date_fact ASC ") ;
// echo "SELECT f.client_id, client_pnom, client_nom, f.num_fact, c.client_reglement,
// 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
// GROUP BY date_fact, f.fact_id, total
// HAVING paye > 0.001
// ORDER BY client_nom $order ,f.date_fact ASC ";
// echo "SELECT f.client_id, client_pnom, client_nom, f.num_fact, c.client_reglement,
// 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
// GROUP BY date_fact, f.fact_id, total
// HAVING paye > 0.001
// ORDER BY serena, ".(empty($order) ? 'num_fact' : $order)." ,client_pnom $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['client_reglement']) {
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;
}
}
if ( mysql_num_rows ( $query ) > 0 )
mysql_data_seek($query,0);
print_header ();
?>
<form action="?val=<?=$_GET['val']?>" method="post" name='ok'>
<table align="center" width="100%" >
<tr>
<td width="50%"><div align="center">
<div class="rbroundbox_g_s" align="center" valign="middle" style="width:220px;font-size:large; float:center; margin-top:15px">
<div align="center" valign="middle" class="rbtop_g_s">
<div></div>
</div>
<div align="center" class="rbcontent_g_s" valign="middle">
<div style="font-size:18px">Solde :
<?=$total_paye?>
€</div>
</div>
<div style=" font-size:12px">Clients :
<?=$total_clients?>
€<br />
Serena :
<?=$total_serena?>
€</div>
<div align="center" valign="middle" class="rbbot_g_s">
<div></div>
</div>
</div>
</div></td>
<td width="50%"><div align="center">
<div class="rbroundbox_g_s" align="center" valign="middle" style="width:220px;font-size:large; float:center; margin-top:15px">
<div align="center" valign="middle" class="rbtop_g_s">
<div></div>
</div>
<div align="center" class="rbcontent_g_s" valign="middle">
<div style=" font-size:12px"> Prélèvement :
<?=$total_prelevement?>
€<br />
Chèque :
<?=$total_cheque?>
€<br />
CESU :
<?=$total_cesu?>
€<br />
Virement :
<?=$total_virement?>
€<br />
Espèces :
<?=$total_especes?>
€<br />
</div>
<div align="center" valign="middle" class="rbbot_g_s">
<div></div>
</div>
</div>
</div>
</div>
</div>
</td>
</tr>
<tr>
<td colspan="2" align="center"><input type="submit" name="save" value="Enregistrer les règlements saisis" class="bigbutton">
<input type="submit" name="relance" value="Relancer les factures non-réglées" class="bigbutton"></td>
</tr>
<?php
while($f = dbi_fetch_row($query))
{
$Client[$f['client_id']][]=$f;
}
?>
<tr>
<td colspan="2">
<div id="tab" >
<table align="left" width="100%">
<tr>
<th align="center">Client</th>
<th align="center">Solde</th>
<th align="center">Nombre de factures</th>
<th align="center">N°</th>
<th align="center">Date</th>
<th align="center">Net à payer</th>
<th align="center">Reçu</th>
<th align="center">Reglememt ID</th>
<th align="center">N° cheque</th>
<th align="center">Date Reglememt</th>
<th align="center"></th>
</tr>
<?php
$compteur=0;
$previous=1;
$serena=0;
// $Data =array();
// $client= array();
foreach($Client as $id=>$ff)
{
// $Data=$ff;
// for($j=0;$j<count($ff);$j++)
// {
// echo '<pre>';
// print_r($ff[$j]);
// echo '</pre>';
// }
// $Data=$ff;
$nb=count($ff);
// rowspan="<?=$nb
for($j=0;$j<count($ff);$j++)
{
$f=$ff[$j];
if($j==0 ) {
$q = dbi_query("SELECT sum(f.total)
FROM (
(select -montant total from ".TABLE_PAIEMENT." where client_id= '".$f['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= '".$f['client_id']."'
AND f.agence_id='$agence'
GROUP BY f.fact_id, f.total
)
) f") ;
list($solde) = dbi_fetch_row($q) ;
}
// $Client[$f['client_id']][]=$f;
// $Client[$f['client_id']][]=array(
// fact_id=>$f['fact_id'],num_fact=>$f['num_fact'],avoir=>$f['avoir'];client_id=>$f['client_id'],serena=>$f['serena']
// );
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 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>
<?php $idf=$f['fact_id'];?>
<?php if($j==0 ) { ?><td align="left" rowspan="<?=$nb?>" style="padding:8px;vertical-align:top;"><a href="top.php?link=client&page=aaa&id=<?=$f['client_id']?>" target="ident">
<?=strtoupper($f['client_nom']).' '.ucwords(strtolower($f['client_pnom']))?>
</a></td>
<td align="center" rowspan="<?=$nb?>" class="<?=$style?>" style="padding:8px;vertical-align:top;"><b><?=number_format($solde, 2, ', ', ' ').' €'?></b></td>
<td align="center" rowspan="<?=$nb?>" class="<?=$style?>" style="padding:8px;vertical-align:top;"><b><?=$nb?></b></td><?php } ?>
<td align="right" style="padding:8px">FA-
<?=$f['num_fact']?></td>
<td align="center" style="padding:8px"><?=int2date($f['date_fact'])?></td>
<td align="right" style="padding:8px"><?=number_format($f['paye'], 2, ', ', ' ')?>
€
<?=($f['avoir'] > 0) ? '<br>(avoir de '.number_format($f['avoir'], 2, ', ', ' ').' €)' : ''?></td>
<td align="center" style="padding:8px"><input type="text" name="fact[<?=$f['fact_id']?>]" value="" size="6"></td>
<td align="center" style="padding:8px"><?=get_drop_down_reglement2("mode[".$f['fact_id']."]", '', $f['client_reglement'])?></td>
<td align="center" style="padding:8px"><input type="text" name="chek[<?=$f['fact_id']?>]" value="" size="8"></td>
<td align="center" style="padding:8px"><?=date_selection_html("datep$idf",'')?></td>
<td align="center" style="padding:8px"><input type="submit" class="bigbutton" value="Valider" onclick='this.form.action="zero.php?val=<?=$_GET['val']?>&idf=<?=$idf?>"' /> </td>
</tr>
<?php
}
}
?>
</table>
</div>
<?php
// echo '<pre>';
// print_r($Client);
// echo '</pre>';
// <TABLE class="td_normal" cellpadding="0" cellspacing="0" style="margin-top:10px" >
// <tr>
// <td class="td_listing1b"><a href='#'>Numéro de facture</a></td>
// <td class="td_listing1b"><a href='#'>Client</a></td>
// <td class="td_listing1b"><a href='#'>Net à payer</a></td>
// <td class="td_listing1b"><a href='#'>Montant reçu</a></td>
// <td class="td_listing1b"><a href='#'>Type de réglement</a></td>
// <td class="td_listing1b"><a href='#'>N° de cheque</a></td>
// <td class="td_listing1b"><a href='#'>Banque</a></td>
// </tr>
//
//$q = dbi_query("SELECT f.num_fact,date_debut, f.fact_id, total-sum(if(p.montant is null, 0, p.montant))-sum(if(a.montant is null, 0, a.montant)) AS paye,
//concat(client_nom, ' ', client_pnom) AS client, c.client_reglement
//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,
//".TABLE_CLIENT." c
//WHERE f.client_id = c.client_id AND f.agence_id = $agence
//GROUP BY f.num_fact, f.fact_id, date_fact
//HAVING paye > 0
//ORDER BY ".(empty($order) ? 'num_fact' : $order)) ;
//while ($f = dbi_fetch_row($q))
//{
//$a=substr($f['date_debut'],0,4);
//$b=substr($f['date_debut'],4,2);
//$c=substr($f['date_debut'],6,2);
//$datedebutfact=$c."/".$b."/".$a;
// <tr>
// <td >Facture nº
// $f['num_fact']
// du
// $datedebutfact
// </td>
// <td><b>$f['client']</b></td>
// <td><b>$f['paye']</b></td>
// <td><input type="text" name="fact[$f['fact_id']]" value="" size="8"></td>
// <td>get_drop_down_reglement("mode[".$f['fact_id']."]", '', $f['client_reglement'])</td>
//
// // En plus pour les infos cheques
// <td><input type="text" name="chek[$f['fact_id']]" value="" size="10"></td>
// <td><input type="text" name="bank[$f['fact_id']]" value="" size="10"></td>
// </tr>
//
//}
//</table><br />
?>
</td>
</tr>
<tr>
<td colspan="2" align="center"><input type="submit" name="save" value="Enregistrer les règlements saisis" class="bigbutton">
<input type="submit" name="relance" value="Relancer les factures non-réglées" class="bigbutton"></td>
</tr>
</table>