1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54
|
$sql_conges="SELECT id_rhp, debut_conges, fin_conges,id_rhpcv FROM `rh_personnel_conges`
WHERE `id_rhp`='".$list["id_rhp"]."'
AND (month(`debut_conges`)='".$_POST["mois"]."' OR month(`fin_conges`)=".$_POST["mois"].")
AND (year(`debut_conges`)='".$_POST["annee"]."' OR year(`fin_conges`)='".$_POST["annee"]."')
and conges_annule='0'
ORDER BY debut_conges";
//echo '<br/>'.$sql_conges;
$query_conges= mysql_query($sql_conges) or die('erreursql_conges');
$nbconges=mysql_num_rows($query_conges);
if ($nbconges == null)
{
for ($i = 1; $i <= $count; $i++) {
echo '<td class="travail" >-</td>';
}
}
else
{
$listedateperiodeconges = array();
while ( $listc = mysql_fetch_array( $query_conges ) ){
echo '<br/>'.$listc["id_rhpcv"];
$id=$listc["id_rhpcv"];
$startperiodeconges = DateTime::createFromFormat('Y-m-d',$listc["debut_conges"]);
$endperiodeconges = DateTime::createFromFormat('Y-m-d',$listc["fin_conges"]);
$endperiodeconges = $endperiodeconges->add(new DateInterval('P1D'));
$intervalperiodeconges = new DateInterval('P1D');
//objet qui représente la période avec l'intervalle choisit
$daterangeperiodeconges = new DatePeriod($startperiodeconges, $intervalperiodeconges ,$endperiodeconges);
foreach($daterangeperiodeconges as $dateperiodeconges)
{
$listedateperiodeconges[$dateperiodeconges->format('d-m-Y')]= array("date" => $dateperiodeconges->format('Y-m-d'),"id" =>$id );
//echo'<th>', $date->format("d") ,'</th>';
echo $id;
}
}
$daterange2 = new DatePeriod($start, $interval ,$end);
foreach($daterange2 as $data){
echo '<td ';
if(isset($listedateperiodeconges[$data->format("d-m-Y")]))
{
if($listedateperiodeconges[$data->format("d-m-Y")]['id']=2)
{
..
. |
Partager