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

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

if(isset($_POST['debutmonth']) and ($_POST['type_entete'])) {
$dated = sprintf("%02d%02d00", $_POST['debutyear'], $_POST['debutmonth']);
$datef = sprintf("%02d%02d31", $_POST['debutyear'], $_POST['debutmonth']);
$factures=array();


		if($_POST['type_entete']=="nouveau")
		{
		include 'includes/absence_pdf.php' ;
		}
$N++;
// echo 
$client_id= $_POST['nom'];
$fact_id= $_POST['nom'];
$chemFact="temp/$client_id/";
// echo " $N --->  $client_id / $fact_id !!! <br/>";
if (!is_dir("temp"))
			{
				mkdir("temp", 0755) ;
				chmod("temp", 0755) ;
			}
$dossier="temp";			
			if (!is_dir("temp/$client_id"))
			{
				mkdir("temp/$client_id", 0755) ;
				chmod("temp/$client_id", 0755) ;
			}
			// include 'includes/factureV3entet.php' ;
$f = new Facture ($fact_id ) ;
$f->Output($chemFact.$fact_id.".pdf", 'F') ;
							$factures[] = $chemFact.$fact_id.".pdf" ;


$fichier_pdf = "temp/$agence-".date('d-m-Y-H:i').".pdf";
pdf_concatene($factures, $fichier_pdf) ;
	
	
	}
	
	
	
	print_header ('', '', $BodyX );
	
	
?>

<style>


#newspaper-a
{
	/*font-family: "Lucida Sans Unicode", "Lucida Grande", Sans-Serif;*/

	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;	
	text-align: left;
	border-collapse: collapse;	
	/* width: 95%; */
	 padding: 0px; 

}
#newspaper-a th
{
    padding: 0px 20px 0px 20px;
    background:rgb(63,39,27);
    color:#FFFFFF;
	font-weight: normal;
	font-size: 14px;
	/* border-bottom: 2px solid #6678b1; 
	 border-right: 20px solid #fff;
	/*border-left: 20px solid #fff; */
}
#newspaper-a tr
{
font-weight:normal;
font-size:13px;color:#FFFFFF;
border-solid:1px dashed #69c;
padding:12px 17px;
}
#newspaper-a td
{
    color:#34495E;
	padding:7px 17px;
	padding: 12px 0px 0px 2px;

	color: #669;
}
#newspaper-a tbody tr:hover td
{
    color:#FFFFFF;
	background:rgb(63,39,27);
}
#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;}
A.couleur
{
color:#FFFFFF;
}
A.couleur_ktba
{
color: #669;
}

aside
{
     position: fixed;
    top: 30px;
    left: 400px;
    vertical-align: top;
    text-align: justify;
	
	    position: relative;
    width: 235px;
    background-color:rgb(63,39,27);
    box-shadow: 0px 2px 5px #1c1a19;
    border-radius: 10px 10px 10px 10px;
    padding: 10px;
    color: white;
    font-size: 0.9em;
}


</style>




	<fieldset>
	<legend> Les dates Absences  </legend>	
		<?
$from = date("Ymd");  

if(!empty($_POST))
{
	$from = getPostDate('debut') ;
	$to = getPostDate('fin') ;
} 

		?>
		<table>
		
		<form action="" name="stat" method="post">
		<tr>
		<td align="center"> Date debut </td> <td><?=date_selection_html("debut", $fact_du)?><br> </td>
		</tr>
		<tr>
		<td align="center"> Date fin </td> <td><?=date_selection_html("fin", $fact_au)?></td>
		</tr>
		<tr>
		<td colspan="2" align="center"> <input type="submit" value="Consulter" class="bigbutton"> </td>
		</tr>
		</table>
		
		
		</form>

</fieldset>


<section>
<aside>
<p><div align="center"   style="height:35px;width:190px;font-size:large; float:center; margin-top:8px; margin-left:17px;"> Les absences injustiifi&eacute;e </div> </p>
</aside>
</section>
<br/><br/> <br/>


<?

if(empty($to))
{
$re = dbi_query("SELECT * FROM absence WHERE agence_id = $agence and  date_debut > $from   AND cause = 18");
}
else
{
$re = dbi_query("SELECT * FROM absence WHERE agence_id = $agence and  date_debut between $from and $to  AND cause = 18");
}


?>
<TABLE id="newspaper-a">

<TR>
  <th align="center">Nom et pr&#233;nom<SPAN class="sort"></SPAN></th>
  <th align="center" >DATE DEBUT</th>
  <th align="center" >DATE fIN</th>
  <th align="center">AFFICHER</th>

</TR>

    <tbody>	
<?

while ($lig=dbi_fetch_row($re))
{

$intrid= $lig['inter_id'] ; 
$req =dbi_fetch_row(dbi_query("SELECT inter_nom ,date_debut,date_fin ,  inter_pnom FROM ".TABLE_INTERV." intr ,absence a WHERE a.inter_id= intr.inter_id and intr.agence_id = $agence and intr.inter_id = $intrid  ")); 

	$id = $lig['inter_id'];
	$nom = $req['inter_nom'];
	$pnom = $req['inter_pnom'];
     $r = (1 == $v) ? 'Yes' : 'No'; 
	// $a
?>

<TR>

  <TD align="center"><?=$nom." ".$pnom?></TD>
  <TD align="center"><?=int2date($lig['date_debut'])?></TD>

   <TD align="center"><?=(empty($lig['date_fin']))? "Pas du date fin" : int2date($lig['date_fin']) ;  ?></TD>

  <form action="" method="post">
  <input type="hidden" name="action" value="recherche" />
   <input name="tab1" type="hidden" value="1">
   <input name="debutmonth" type="hidden" value="2">
   <input name="debutyear" type="hidden" value="2015">
    <input name="type_entete" type="hidden" value="nouveau">
	<input type="hidden" name="fact_email" value="immediat-papier" />
  
   <TD align="center"><input type="submit" name="affiche" value="PDF"></TD>
   
   <input type="hidden" name="tmp" value="<?="A"?>"> 
   <input type="hidden" name="interv_id" value="<?=$intrid?>">
   <input type="hidden" name="dat_db" value="<?=$from?>">
   <input type="hidden" name="ville" value="<?=$req['inter_ville']?>">
   <input type="hidden" name="nom" value="<?=$req['nom']?>">
  
    
   
  
	

  </form>

</TR>
<?

} ?>

</table>