|
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/MC/lesCheques/../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include_once 'code/init.php';
$add=2;
// ini_set('display_errors','on');
// error_reporting(E_ALL);
// echo '<pre>';
// print_r($_POST);
// echo '</pre>';
// echo "yassin <br/>" ;
// echo "test ---jj-- reglement <br/>" ;
// if($agence==9)
// {
// while($add!=2)
// {
// $bk++ ;
// }
// }
header('Content-Type: text/html; charset=utf-8');
if(isset($_POST['fact']) && isset($_POST['save']))
{
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]) ;
}
}
}
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);
}
}
$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
GROUP BY date_fact, f.fact_id, total
HAVING paye > 0.001
ORDER BY serena, ".(empty($order) ? 'num_fact' : $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;
}
}
mysqli_data_seek($query,0);
print_header ();
?>
<form name ="formhatim"action="<?=$_SERVER['REQUEST_URI']?>" method="post">
<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">Soldeee :
<?=$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>
<tr>
<style>
#newspaper-a
{
font-family:"Lucida Sans Unicode", "Lucida Grande", Sans-Serif;font-size:12px;width:1080px;text-align:left;border-collapse:collapse;border:2px solid #C0C0C0;margin:20px;}
#newspaper-a tr{font-weight:normal;background-color: #1ABC9C;font-size:13px;color:#FFFFFF;border-solid:1px dashed #69c;padding:12px 17px;}
.newspaper-a td{color:#34495E;padding:7px 17px;}
#newspaper-a th{color:#FFFFFF;background:#1ABC9C;}
#newspaper-a tbody tr:hover td{color:#FFFFFF;background:#1ABC9C;}
#newspaper-b{font-family:"Lucida Sans Unicode", "Lucida Grande", Sans-Serif;font-size:12px;width:1080px;text-align:left;border-collapse:collapse;border:1px solid #34495E;margin:20px;}
</style>
<td colspan="2"><table id="newspaper-a" align="left" class="td_normal" width="100%">
<tr>
<td width="3%" class="td_listingb"></td>
<td width="6%" class="td_listin1b" align="center">N°</td>
<td width="18%" class="td_listig1b" align="center">Client</td>
<td width="10%" class="td_listig1b" align="center">Net à payer</td>
<td width="15%" class="td_listig1b" align="center">Reçu</td>
<td width="15%" class="td_listig1b" align="center">Type de réglement</td>
<td width="10%" class="td_listin1b" align="center">N° cheque</td>
<td width="10%" class="td_listng1b" align="center">Banque</td>
<td width="10%" class="td_lising1b" align="center">Date</td>
<td width="3%" class="td_listig1b" align="center">R</td>
<td width="5%" class="td_listng1b" align="center">PDF</td>
</tr>
<?php
$compteur=0;
$previous=1;
$serena=0;
$c = 0 ;
$b = 1000 ;
$yas = 10000 ;
while($f = dbi_fetch_row($query))
{
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 class="td_listing0" 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>
<TD class="<?=$style?>"><?=$icone?></TD>
<td align="right" class="<?=$style?>" style="padding:8px">FA-
<?=$f['num_fact']?></td>
<td align="left" class="<?=$style?>" style="padding:8px"><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="right" class="<?=$style?>" style="padding:8px" ><input type="hidden" id="<?=$c?>" value="<?=number_format($f['paye'], 2, ', ', '')?>"> <?=number_format($f['paye'], 2, ', ', '')?>
€
<?=($f['avoir'] > 0) ? '<br>(avoir de '.number_format($f['avoir'], 2, ', ', ' ').' €)' : ''?> </td>
<script>
function afficher(id,id1,id3) {
if(document.getElementById(id3).checked)
{
var testin =document.getElementById(id).value;
document.getElementById(id1).value=testin;
}
else
{
document.getElementById(id1).value="";
}
}
</script>
<td align="center" class="<?=$style?>" style="padding:8px"><input type="text" id="<?=$b?>" name="fact[<?=$f['fact_id']?>]" value="" size="6"> <input type="checkbox" id="<?=$yas?>" onclick="afficher(<?=$c?>,<?=$b?>,<?=$yas?>)"></td>
<td align="center" class="<?=$style?>" style="padding:8px"><?=get_drop_down_reglement("mode[".$f['fact_id']."]", '', $f['client_reglement'])?></td>
<td align="center" class="<?=$style?>" style="padding:8px"><input type="text" name="chek[<?=$f['fact_id']?>]" value="" size="8"></td>
<?
if($f['client_reglement']== 2)
{
// echo "--->".$f['client_id'] ;
$client_id= $f['client_id'] ;
$bnk = dbi_fetch_row(dbi_query("SELECT * FROM `paiement` WHERE client_id='$client_id' AND agence_id = '$agence' ORDER BY `paiement`.`paiement_id` DESC limit 0,1")) ;
// echo $bnk ;
// echo "kkk-".$bnk['banque'] ;
?>
<td align="center" class="<?=$style?>" style="padding:8px"><input type="text" name="bank[<?=$f['fact_id']?>]" value="<?=$bnk['banque']?>" size="8"></td>
<?
}
else
{
?>
<td align="center" class="<?=$style?>" style="padding:8px"><input type="text" name="bank[<?=$f['fact_id']?>]" value="" size="8"></td>
<?
}
?>
<td align="center" class="<?=$style?>" style="padding:8px"><?=int2date($f['date_fact'])?></td>
<td align="right" class="<?=$style?>" style="padding:8px"><?=$f['relance']>0?$f['relance']:'-'?>
<?=$f['relance'] ? ' <a href="factures/'.$f['client_id'].'/'.$f['fact_id'].'-'.$f['relance'].'.pdf" target="_blank"><img src="images/icones/pdf.gif" width="16" height="16" border="0" alt="Voir la dernière relance"></a>' : ''?></td>
<td align="center" class="<?=$style?>" style="padding:8px"><a href="facture.php?fid=<?=$f['fact_id']?>" target="_blank"><img src="images/icones/pdf.gif" width="16" height="16" border="0" alt="Voir la facture"></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><a href="avoir.php?aid=%d" target="_blank">Avoir nº%d</a>', $a['avoir_id'], $a['num_avoir']);
}
?></td>
</tr>
<?php
$b ++ ;$c ++ ; $yas ++ ;
}
?>
</table>
<?php
// <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>