0x1998 - MANAGER

Edit File: aj_planning.php

<?php
include "config/auth-config.php";
include "config/authcheck.php";
include "config/garde.php";

//entete();
$annee=isset($_GET['annee'])? $_GET['annee']: date('Y');
$mois=isset($_GET['mois'])? $_GET['mois']: date('m');
$semaine=isset($_GET['semaine'])? $_GET['semaine']: 1;
$start=isset($_GET['start'])? $_GET['start']: 1;
$end=isset($_GET['end'])? $_GET['end']: "";
$js=isset($_GET['js'])? $_GET['js']: date('N');

$libelle_jour=array(1=>'Lun',2=>'Mar',3=>'Mer',4=>'Jeu',5=>'Ven',6=>'Sam',7=>'Dim');

//------on charge les valeurs
// users
$sql="select nom, user_type.id from user_type inner join user_skill on user_id=user_type.id
		where user_skill=3 and niveau>=3 order by nom";
$result=mysqli_query($link,$sql) or die($sql);
while ($info=mysqli_fetch_array($result))
	{
		$user[$info[1]]=$info[0];
	}
mysqli_free_result($result);	
//------------------
// ----------- activites
$sql="select day(activite_date) as 'day', activite_user, activite_type, list_activite_abrege, list_activite_label from activite inner join user_skill on user_id=activite_user
			inner join list_activite on activite_activite=list_activite_id
		where year(activite_date)=".$annee." and month(activite_date)=".$mois." 
		and day(activite_date)>=".$start." and day(activite_date)<=".$end." and user_skill=3";
$result=mysqli_query($link,$sql) or die($sql);
while ($info=mysqli_fetch_array($result))
	{
		$activite[$info['activite_user']][$info['day']][$info['activite_type']]['value']=$info['list_activite_abrege'];
		$activite[$info['activite_user']][$info['day']][$info['activite_type']]['label']=$info['list_activite_label'];
	}
mysqli_free_result($result);	
//-----------------------------------	
	
echo "
	<table class=\"table table-bordered\" cellpadding=\"0\" cellspacing=\"0\" align=\"center\" >";
// --- PREMIERE LIGNE
echo "<tr>"; // ouverture de la ligne
echo "<td class=\"calendar\" width=\"30%\">Nom</td>";
for ($i=1;$i<=7;$i++)
	{
		echo "<td class=\"calendar\" style=\"text-align:center;\" width=\"10%\">".$libelle_jour[$i];
		if ($i>=$js && ($start+$i-$js)<=$end) echo "  <span class=\"badge\">".($start+$i-$js)."</span>";
		echo"</td>";
	}
echo "</tr>"; // fermeture première ligne

foreach($user as $key => $value)
	{
		echo "<tr>"; // ouverture ligne
		echo "<td class=\"calendar\">".$value."</td>";
			for ($i=1;$i<=7;$i++)
				{
				$jour=($start+$i-$js);	
				$valeur_M=isset($activite[$key][$jour]['M']['value']) ? $activite[$key][$jour]['M']['value'] :"";
				$label_M=isset($activite[$key][$jour]['M']['label']) ? $activite[$key][$jour]['M']['label'] : "";
				$valeur_AM=isset($activite[$key][$jour]['AM']['value']) ? $activite[$key][$jour]['AM']['value']:"";
				$label_AM=isset($activite[$key][$jour]['AM']['label']) ? $activite[$key][$jour]['AM']['label'] :"";
				$valeur_S=isset($activite[$key][$jour]['S']['value']) ? $activite[$key][$jour]['S']['value'] : "";
				$label_S=isset($activite[$key][$jour]['S']['label']) ? $activite[$key][$jour]['S']['label'] : "";
				$valeur_N=isset($activite[$key][$jour]['N']['value']) ? $activite[$key][$jour]['N']['value'] : "";
				$label_N=isset($activite[$key][$jour]['N']['label']) ? $activite[$key][$jour]['N']['label'] : "";
				
				if ($valeur_M==$valeur_AM && $valeur_M!="") $valeur_jour="<div class=\"col-md-12\" align=\"center\"><span class=\"label label-".$label_M."\">".$valeur_M. " jour</span></div>";
				elseif ($valeur_M==$valeur_AM && $valeur_M=="") $valeur_jour="<div class=\"col-md-12\" align=\"center\"><p></div>";
				else $valeur_jour="<div class=\"col-md-6\" align=\"center\"><span class=\"label label-".$label_M."\">".$valeur_M."</span></div><div class=\"col-md-6\" align=\"center\"><span class=\"label label-".$label_AM."\">".$valeur_AM."</span></div>";
				
				if ($valeur_S==$valeur_N && $valeur_S!="") $valeur_nuit="<div class=\"col-md-12\" align=\"center\"><span class=\"label label-".$label_S."\">".$valeur_S. " nuit</span></div>";
				elseif ($valeur_S==$valeur_N && $valeur_S=="") $valeur_nuit="<div class=\"col-md-12\" align=\"center\"><p></div>";
				else $valeur_nuit="<div class=\"col-md-6\" align=\"center\"><span class=\"label label-".$label_S."\">".$valeur_S."</span></div><div class=\"col-md-6\" align=\"center\"><span class=\"label label-".$label_N."\">".$valeur_N."</span></div>";		
				
				echo "
				<td valign=\"top\" bgcolor=\"#FFFFFF\" class=\"calendar\" width=\"10%\">
				<div class=\"row\">".
				$valeur_jour."
				</div>
				<div><p></div>
				<div class=\"row\">".
				$valeur_nuit."
				</div>
				
				</td>";
				}
		echo" </tr>";
	}
echo "</table>";	
?>