<?php
include_once 'code/init.php';

session_start();
 
// On s'amuse à créer quelques variables de session dans $_SESSION



?>

	<script src="jquery-1.12.0.min.js"></script>

<SCRIPT LANGUAGE="Javascript">

function afficher(id) {
	
	
document.write(id);


 //$query = "DELETE FROM  facture_test WHERE fact_id = "+id;
	//	$result = mysql_query($query);
	
		
		
	 $.ajax({
  type: 'GET',
  url: 'delete_fact.php',
  data: 'id=' +id,
  done:  test
}).done(function (response) {
        console.log(response);
  });

}




function test(){
	alert('ddddd') ; 
}

</script>



<?



// echo "$agence" ; 
$total_somme = 0 ; 
$total_dure = 0 ;

  if($_POST['sup']=="supprimer")
  {
	 echo "<pre>" ;
     print_r($_POST);	 
	 echo "<pre>" ;
	 
	 
	 	 // echo ""
	 for($i=1;$i<500;$i++)
	 {  
         if(!empty($_POST[$i]))
		{
		
		 $fidd[]=$_POST[$i] ;
		}
	 }

for($i=0;$i<sizeof($fidd);$i++)
	 {  

		 dbi_query("DELETE FROM  facture_test WHERE fact_id = ".$fidd[$i] ) ;		
	 }
	 

  }




	  $tc = unserialize( base64_decode( $_POST["str"] ) );
	
	 
	 
	 
	 // if($_POST['val'] == "Tout Valider")
	 // {
	 
	 
	 	 // list($num_fact)=dbi_fetch_row(dbi_query("SELECT max(num_fact) FROM  facture WHERE agence_id =$agence "  ));
	

// for($i=0;$i<sizeof($tc);$i++)
	 // {  
// list($total,$date_debut,$date_fin,$date_fact,$relance,$client_id,$agence_id,$data,$textf,$type)=dbi_fetch_row(dbi_query("SELECT  total ,date_debut,date_fin,date_fact,relance,client_id,agence_id,data,textf,type FROM  facture_test WHERE  fact_id = ".$tc[$i]));	
	  // $num_fact = $num_fact + 1 ;
	
	 // dbi_query("INSERT INTO facture_valide VALUES ('','$total', '$date_debut','$date_fin','$date_fact','$relance','$client_id','$agence_id','$num_fact','$data','$textf','$type')"); 
				
	 // }
	 
	 // }
	 
	   if($_POST['Prev'] == "valider" )
  {
	 
	 
	 //echo "hhhhhhhhh" ; 
	 for($i=1;$i<500;$i++)
	 {  
 // echo"zzzzz <br/> " ; 
         if(!empty($_POST[$i]))
		{
			// echo"ggggg <br/> " ; 
		 $clID[]=$_POST[$i] ;
		}
	 }
	 
	 list($num_fact)=dbi_fetch_row(dbi_query("SELECT max(num_fact) FROM  facture WHERE agence_id =$agence "  ));
	
	// echo" ff---$num_fact" ; 
for($i=0;$i<sizeof($clID);$i++)
	 {  
list($fact_id, $total,$date_debut,$date_fin,$date_fact,$relance,$client_id,$agence_id,$data,$textf,$email_envoye,$type)=dbi_fetch_row(dbi_query("SELECT fact_id, total ,date_debut,date_fin,date_fact,relance,client_id,agence_id,data,textf,email_envoye,type FROM  facture_test WHERE  client_id = ".$clID[$i]));	
	  $num_fact = $num_fact + 1 ;
	  // echo" tt---$num_fact" ; 
	 dbi_query("INSERT INTO facture_valide VALUES ('','$total', '$date_debut','$date_fin','$date_fact','$relance','$client_id','$agence_id','$num_fact','$data','$textf','$email_envoye,','$type')"); 
		

      dbi_query("DELETE FROM facture_test WHERE fact_id = ".$fact_id) ; 		
	 }
	 
	 
  }
  // echo "------" ;
  // echo "<pre>" ;
     // print_r($clID);	 
	 // echo "<pre>" ;
	 
	 
						$eq= dbi_query("SELECT * FROM ".TABLE_CLIENT." WHERE client_actif ='0' AND client_prospect='0' AND client_genre !='FORMATION' AND agence_id = '$agence' ORDER BY  `client`.`client_nom` ASC ");

   
   
   
   
print_header ();


$j = 0 ;
?>
<table border="1px">
	<tr>
		
		<th > CLIENT </th>
		<th > DATE DE FACTURE  </th>
		<th > DUREE </th>
		<th >MONTANT   </th>
		<th > VALIDATION </th>
		<th > SUPPRIMER </th>
		<th > VISUALISER  </th>
	</tr>
<?
unset($fid) ; 
while($mm=dbi_fetch_row($eq))
{	
$j++ ; 
	// list($mnt,$date,$data)=  dbi_fetch_row(dbi_query("SELECT total,date_fact,data FROM  facture_test WHERE  client_id = 9772"));
	 // list($mnt,$date,$data)=  dbi_fetch_row(dbi_query("SELECT total,date_fact,data FROM  facture_test WHERE  client_id = ".$mm['client_id']));
	 // list($dataa, $factures, $acompte, $attdataa, $option) = unserialize($data) ;
	  
	
	        
	 		$f= dbi_query("SELECT * FROM  facture_test WHERE  client_id = ".$mm['client_id'] );
           $ttj = dbi_fetch_row($f) ; 
		    
		  if(!empty($ttj))
		  { 
         $f= dbi_query("SELECT * FROM  facture_test WHERE  client_id = ".$mm['client_id']." and  agence_id = $agence ");

      list($totl)= dbi_fetch_row(dbi_query("SELECT sum(total) FROM  facture_test WHERE    agence_id = $agence "));			 
 // $f= dbi_query("SELECT * FROM  facture_test WHERE  client_id = ".$mm['client_id']);	  		 
		    // echo "--".$mm['client_id']." ---- $ttj <br/>" ; 
       while($tt = dbi_fetch_row($f))	
{   
$total_somme =  $tt['total'] + $total_somme ; 
// echo "-- ".$tt['total']."<br/>" ; 
// echo "--------------------$total_somme <br/> " ; 

	 $fid[] = $tt ['fact_id'] ; 
	 $_SESSION['fid'][] = $tt ['fact_id'];
list($dataa, $factures, $acompte, $attdataa, $option) = unserialize($tt['data']) ;
	 $nbr= 0 ; 
	 for($i=0;$i<sizeof($attdataa['H']);$i++ )
	 {
		$nbr = $attdataa['H'] + $nbr ; 
	 }
?>


<form name="genirale" action="factu3.php" method="post">

	<tr>
	<?
		
		$total_dure= $total_dure + $nbr ; 
	?>
		<td > <?=$mm['client_nom']." ".$mm['client_pnom']?></td>
<td > <?=int2date($tt['date_fact'])?></td>
		<td > <?=$nbr?></td>
		<td > <?=$tt['total']?></td>
						 <?
		  if($_POST['val'] == "Tout Valider")
	    {
		?>
		<td > <input type="checkbox" name="<?=$j?>" value="<?=$mm['client_id']?>" checked ></td>
					 <?
	    }
		else
		{
		?>	
		<td > <input type="checkbox" name="<?=$j?>" value="<?=$mm['client_id']?>"></td>	
		<?
		}
		?>
		<td > <input type="checkbox" name="<?=$j?>" value="<?=$tt['fact_id']?>"></td>
		
		<td align="center" class="td_listing<?=($compteur % 2); ?>" style="padding:8px"><a href="facture3.php?fid=<?=$tt['fact_id']?>" target="_blank">Voir la facture</a>
	</tr>

<?
// exit() ;
} 
		  }
		  else
		  {
			  ?>



	<tr>
		
		<td > <?=$mm['client_nom']." ".$mm['client_pnom']?></td>
<td > <?=int2date($tt['date_fact'])?></td>
		<td > <?=0?></td>
		<td > <?=$tt['total']?></td>
		<td > <input type="checkbox" name="<?=$j?>" value="<?=$mm['client_id']?>"></td>
	  <td >  ***** </td>
	  <td align="center" class="td_listing<?=($compteur % 2); ?>" style="padding:8px"><a href="facture2.php?fid=<?=$f['fact_id']?>" target="_blank">Voir la facture</a>
	</tr>

<?
		  }
?>

<?	
}

	 // echo "<pre>" ;
     // print_r($fid);	 
	 // echo "<pre>" ;
	 $fidd = serialize($fid)
?>
<tr> 
<td></td><td></td> <td  >    <?=$total_dure?>  </td> <td colspan="2" >    <?=$totl?>  </td>
</tr>

<tr> 



<td colspan="2" align="right">
<input type="submit" name="Prev" value="valider" class="bigbutton">
</td>


<td colspan="2" align="right">
<input type="hidden"  name="vall"  value="<?=$fid?>">
<input type = "hidden" name = "str" value = "<?php echo base64_encode( serialize( $fid ) ); ?>">
<input type="submit" name="val" value="Tout Valider" class="bigbutton">
<input type="submit" name="sup" value="supprimer" class="bigbutton">
</td>
</table>
</form>

</body>
</html>