<?php
include_once 'code/init.php';
$order = 'client_nom' ;
// echo "kkk <br/>" ; 


function payerFactureC ($fId, $montant, $mode, $cId,$datep,$idC)
{ 
// echo 'ffff <br/>' ;
// exit() ;  
	global $agence ;
	list($client_id, $fId) = dbi_fetch_row(dbi_query("select client_id, num_fact FROM ".TABLE_FACT." Where fact_id = $fId"));
	if(!$client_id) $client_id=$cId;
	if(empty( $client_id))
		 $client_id=0;
	$montant = str_replace(',', '.', $montant) ;
	$cpt=0;
	dbi_query("INSERT INTO reglementt (montant, reglement_id, date, ` client_id` , num_cheque, banque ) VALUES ($montant, $mode, $datep, $client_id".($cheque!=NULL ? ", '$cheque'" : ", NULL")." ".($bank!=NULL ? ", '$bank'": ", NULL" ).")" );
     	 list($reg) = dbi_fetch_row(dbi_query("SELECT max(reg_id) FROM reglementt")) ;
		 
	while($fId != 0 && $montant > 0.001 && $cpt<100)
	{ 
		$cpt++;
		$q = dbi_fetch_row(dbi_query("SELECT f.fact_id, total-if(p.montant is null, 0, p.montant)-if(a.montant is null, 0, a.montant) AS paye 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))) montant, fact_id
	FROM ".TABLE_PAIEMENT." where client_id = $client_id and agence_id = $agence group by fact_id) p using (fact_id)
LEFT JOIN (select if(sum(if(montant is null, 0, montant)) is null, 0, sum(if(montant is null, 0, montant))) montant, fact_id
	FROM ".TABLE_AVOIR." where agence_id = $agence group by fact_id) a using (fact_id)
WHERE f.client_id=$client_id AND f.agence_id=$agence AND num_fact = $fId GROUP BY f.fact_id, total")) ;

		if($q['paye']) { 
			dbi_query("INSERT INTO ".TABLE_PAIEMENT." (montant, reglement_id, fact_id, date,Remisechq_ID, agence_id, client_id, reg_id ) VALUES (".min($montant, $q['paye']).", $mode, ".$q['fact_id'].", $datep,$idC, $agence, $client_id ,$reg)" );
		}
			
		$montant = round(($montant-$q['paye']),2);
		//$montant -= $q['paye'] ;
		
		list($fId) = dbi_fetch_row(dbi_query("SELECT MIN(num_fact) 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))) montant, fact_id
	FROM ".TABLE_PAIEMENT." where client_id = $client_id and agence_id = $agence group by fact_id) p using (fact_id)
LEFT JOIN (select if(sum(if(montant is null, 0, montant)) is null, 0, sum(if(montant is null, 0, montant))) montant, fact_id
	FROM ".TABLE_AVOIR." where agence_id = $agence group by fact_id) a using (fact_id)
 WHERE f.client_id=$client_id AND f.agence_id=$agence and total-if(p.montant is null, 0, p.montant)-if(a.montant is null, 0, a.montant) > 0.001")) ;
	}
	if($montant > 0.001) {
		dbi_query("INSERT INTO ".TABLE_PAIEMENT." (montant, reglement_id, fact_id, date, agence_id, client_id,reg_id) VALUES ('".$montant."', '".$mode."', 0, '".$datep."',  '".$agence."', '".$client_id."', $reg)") ;
	}
}

// echo "<pre>" ;

// print_r($_GET) ; 
// echo "</pre>" ; 



// echo "=== <br/>" ;
// echo "<pre>" ;

// print_r($_POST) ; 
// echo "</pre>" ;  
// exit() ; 
if(isset($_POST['fact']) && isset($_POST['save']))
{
	foreach($_POST['fact'] as $id => $montant){
		if($montant) {
			//payerFacture($id, $montant, $_POST['mode'][$id]) ;
			payerFactureC($id, $montant, $_POST['mode'][$id],NULL,$_POST['datee'],$_GET['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;
	}
}
mysql_data_seek($query,0);
print_header ();
?>

<form action="<?=$_SERVER['REQUEST_URI']?>" method="post">
<table align="center" width="100%" >
  <tr>
    <td width="50%"></td>
    <td width="50%">
      </div>
    </td>
  </tr>

  <tr>
    <td colspan="2"><table align="left" class="td_normal" width="100%">
        <tr>
          <td width="3%" class="td_listing1b"></td>
          <td width="6%" class="td_listing1b" align="center">N°</td>
          <td width="18%" class="td_listing1b" align="center">Client</td>
          <td width="10%" class="td_listing1b" align="center">Net &agrave; payer</td>
          <td width="10%" class="td_listing1b" align="center">Reçu</td>
          <td width="15%" class="td_listing1b" align="center">Type de réglement</td>
          <td width="10%" class="td_listing1b" align="center">Date</td>
          <td width="5%" class="td_listing1b" align="center">PDF</td>
        </tr>
        <?php


$compteur=0;
$previous=1;
$serena=0;
		
	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&amp;page=aaa&amp;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"><?=number_format($f['paye'], 2, ', ', ' ')?>
            &euro;
            <?=($f['avoir'] > 0) ? '<br>(avoir de '.number_format($f['avoir'], 2, ', ', ' ').' &euro;)' : ''?></td>
          <td align="center" class="<?=$style?>" style="padding:8px"><input type="text" name="fact[<?=$f['fact_id']?>]" value="" size="6"></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"><?=int2date($f['date_fact'])?></td>
          <input type="hidden" name="datee" value="<?=$f['date_fact']?>" >
          <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&ordm;%d</a>', $a['avoir_id'], $a['num_avoir']);
	}
?></td>
        </tr>
        <?php
	}
	?>
      </table>
      <?php    
    
    

?>
    </td>
  </tr>
  <tr>
    <td colspan="2" align="center"><input type="submit" name="save" value="Enregistrer les réglements saisis" class="bigbutton">
      &nbsp;&nbsp;&nbsp;
  </tr>
</table>