Organisez l’agenda de votre capitaine :
- Sélectionnez jusqu’à 4 créneaux de disponibilité par jour
- Suivez les sollicitations des collèges et lycées
';
echo '
';
echo '
Les sollicitations refusées
';
echo '
';
echo '
';
$query="SELECT * FROM sollicitations WHERE idCapitaine=0 AND chxNumEta=:chxNumEta AND traitement=0 ORDER BY chxJour, chxCreneau, dateCreate";
$db = connect_base();
$queryRequest = $db->prepare( $query );
$queryRequest->bindParam( ':chxNumEta', $_SESSION['cfa_num'], PDO::PARAM_INT );
$queryRequest->execute();
$countSol = $queryRequest->rowCount();
$dataSol = $queryRequest->fetchAll();
if($countSol==0){
echo '
Vous n\'avez aucune sollicitation refusée.
';
}else{
echo '
';
echo '| Etablissement | Contact | Localisation | Jour | Creneau | Actions |
|---|
';
foreach($dataSol as $k => $v){
$myjourSol = MysqlToDateFr($v['chxJour']);
$mycreneauSol = getCreneauSol($v['chxCreneau']);
echo '';
echo '| '.decrypter($maCleDeCryptage,$v['etaCoLy']).' | ';
echo ''.decrypter($maCleDeCryptage,$v['nomCoLy']).' '.decrypter($maCleDeCryptage,$v['prenomCoLy']).' | ';
echo ''.decrypter($maCleDeCryptage,$v['cpCoLy']).' '.decrypter($maCleDeCryptage,$v['villeCoLy']).' | ';
echo ''.$myjourSol.' | ';
echo ''.$mycreneauSol.' | ';
echo 'Voir | ';
//echo 'Refuser | ';
echo '
';
}
echo '';
}
echo '
';
//SOLLICITATIONS CAPITAINE
echo '';
echo 'Les sollicitations en attente
';
echo '';
echo '';
$query="SELECT * FROM sollicitations WHERE idCapitaine=:id_cap AND traitement=0 ORDER BY chxJour, chxCreneau, dateCreate";
$db = connect_base();
$queryRequest = $db->prepare( $query );
$queryRequest->bindParam( ':id_cap', $myIdCap, PDO::PARAM_INT );
$queryRequest->execute();
$countSol = $queryRequest->rowCount();
$dataSol = $queryRequest->fetchAll();
if($countSol==0){
echo 'Aucune sollicitation en attente.
';
}else{
echo '';
echo '| Etablissement | Contact | Localisation | Jour | Creneau | Actions |
|---|
';
foreach($dataSol as $k => $v){
$myjourSol = MysqlToDateFr($v['chxJour']);
$mycreneauSol = getCreneauSol($v['chxCreneau']);
echo '';
echo '| '.decrypter($maCleDeCryptage,$v['etaCoLy']).' | ';
echo ''.decrypter($maCleDeCryptage,$v['nomCoLy']).' '.decrypter($maCleDeCryptage,$v['prenomCoLy']).' | ';
echo ''.decrypter($maCleDeCryptage,$v['cpCoLy']).' '.decrypter($maCleDeCryptage,$v['villeCoLy']).' | ';
echo ''.$myjourSol.' | ';
echo ''.$mycreneauSol.' | ';
echo 'Voir | ';
//echo 'Refuser | ';
echo '
';
}
echo '';
}
echo '
';
//AGENDA CAPITAINE
/*
$arrWeek = array();
$arrWeek[3] = array('','','','2019-01-17','2019-01-18');
$arrWeek[4] = array('2019-01-21','2019-01-22','2019-01-23','2019-01-24','2019-01-25');
$arrWeek[5] = array('2019-01-28','2019-01-29','2019-01-30','2019-01-31','2019-02-01');
$arrWeek[6] = array('2019-02-04','2019-02-05','2019-02-06','2019-02-07','2019-02-08');
$arrDaysWeek = array('lundi','mardi','mercredi','jeudi','vendredi');
$arrCreneaux = array('am1','am2','pm1','pm2');
$arrCreneauxTitle = array('Matin 1','Matin 2','Après-midi 1','Après-midi 2');
$theGreatDay = '2019-01-17';
*/
echo '';
echo 'Agenda de votre capitaine
';
echo '';
echo '';
include('include/agenda.inc.php');
foreach($arrWeek as $kw=>$vw){
echo ''."\r\n";
echo 'Semaine '.$kw.'';
$idDay = 0;
echo ''."\r\n";
echo '| | ';
foreach($vw as $vDay){
if(!empty($vDay)) $th = ''.$arrDaysWeek[$idDay].'
'.MysqlToDateFr($vDay).' | '; else $th = ' | ';
echo $th."\r\n";
$idDay++;
}
echo '
'."\r\n";
foreach($arrCreneaux as $kCr => $vCr){
if($arrCreneaux[$kCr]=="pm1") $isMidDay = ' class="isMidDay"'; else $isMidDay = '';
echo ''."\r\n";
echo ''.$arrCreneauxTitle[$kCr].' | ';
foreach($vw as $vDay){
if(!empty($vDay)){
//Un enregistrement existe t'il pour le créneau ?
$query="SELECT * FROM agenda LEFT JOIN collegelycee ON idCoLy=numCoLy WHERE numCap=:numCap AND jour=:jour AND creneau=:creneau
";
$queryRequest = $db->prepare( $query );
$queryRequest->bindParam( ':numCap', $myIdCap, PDO::PARAM_INT );
$queryRequest->bindParam( ':jour', $vDay, PDO::PARAM_STR );
$queryRequest->bindParam( ':creneau', $arrCreneaux[$kCr], PDO::PARAM_STR );
$queryRequest->execute();
$countD = $queryRequest->rowCount();
$dataD=$queryRequest->fetchAll();
if($countD>1){ //Erreur Pas possible
$td = 'Erreur recontrée sur ce créneau | ';
}elseif($countD==1){
if($dataD[0]['statut']=="bloque"){
$td = 'Indisponible
Rendre disponible | ';
}
if($dataD[0]['statut']=="libre"){
$td = 'Disponible
Identifier un rendez-vous
Rendre indisponible
Affecter une sollicitation | ';
}
if($dataD[0]['statut']=="reserve"){
$reserve = decrypter($maCleDeCryptage,$dataD[0]['etaCoLy'])."
(".decrypter($maCleDeCryptage,$dataD[0]['cpCoLy'])." ".decrypter($maCleDeCryptage,$dataD[0]['villeCoLy']).") ";
$td = ''.$reserve.'
Modifier
Rendre indisponible | ';
}
}/*else{ //Créneau vide
if($vDay==$theGreatDay) $td = 'Libre
Réserver
Bloquer | '; else $td = 'Bloqué
Débloquer | ';
}*/
}else $td = ' | ';
echo $td."\r\n";
}
echo ''."\r\n";
}
echo '
'."\r\n";
}
//}
?>