prepare( $querySolRef );
$queryRequestSolRef->bindParam( ':chxNumEta', $id, PDO::PARAM_INT );
$queryRequestSolRef->execute();
$countSolRef=$queryRequestSolRef->rowcount();
$dataSolRef = $queryRequestSolRef->fetchAll();
if($countSolRef==0) echo $nomEta .' n\'a aucune sollicitation refusée.
';
elseif($countSolRef==1) echo '
'.$nomEta .' a '.$countSolRef.' sollicitation refusée.';
elseif($countSolRef>1) echo '
'.$nomEta .' a '.$countSolRef.' sollicitations refusées.';
// SOLLICITATIONS REFERENT
if($countSolRef >= 1){
if($countSolRef == 1) echo '
La sollicitation refusée
';
else echo '
Les sollicitations refusées
';
echo '
';
echo '| Etablissement | Contact | Localisation | Jour | Creneau |
|---|
';
foreach($dataSolRef 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 '
';
}
echo '';
}
echo '
';
?>
prepare( $query );
$queryRequest->bindParam( ':num_eta', $id, PDO::PARAM_INT );
$queryRequest->execute();
include_once('include/agenda.inc.php');
if($queryRequest->rowCount()>0){
$data=$queryRequest->fetchAll();
$index = 1;
$capitaine = "";
$apprenant = "";
$professionnel = "";
foreach($data as $val){
//Affichage noms apprenant et pro
$query2="select * from equipes where num_capitaine=:num_cap";
$db2 = connect_base();
$queryRequest2 = $db2->prepare( $query2 );
$queryRequest2->bindParam( ':num_cap', $val['id_cap'], PDO::PARAM_INT );
$queryRequest2->execute();
$data2=$queryRequest2->fetchAll();
$capitaine = decrypter($maCleDeCryptage,$val['prenom_cap']).' '.decrypter($maCleDeCryptage,$val['nom_cap']);
if(!empty($data2[0]['nom_eleve']) && !empty($data2[0]['prenom_eleve'])) $apprenant = decrypter($maCleDeCryptage,$data2[0]['nom_eleve']).' '.decrypter($maCleDeCryptage,$data2[0]['prenom_eleve']);
if(!empty($data2[0]['nom_pro']) && !empty($data2[0]['prenom_pro'])) $professionnel = decrypter($maCleDeCryptage,$data2[0]['nom_pro']).' '.decrypter($maCleDeCryptage,$data2[0]['prenom_pro']);
//Affichage rendez-vous capitaines
$query3="select count(*) as rdv, sum(nbClasses) as classes, sum(nbEleves) as eleves FROM agenda INNER JOIN collegelycee ON idCoLy=numCoLy WHERE numCap=:num_cap AND statut= 'reserve' AND numEta=:numEta";
$db3 = connect_base();
$queryRequest3 = $db3->prepare( $query3 );
$queryRequest3->bindParam( ':numEta', $id, PDO::PARAM_INT );
$queryRequest3->bindParam( ':num_cap', $val['id_cap'], PDO::PARAM_INT );
$queryRequest3->execute();
//$countRdv=$queryRequest3->rowcount();
$data3=$queryRequest3->fetchAll();
if(isset($data3[0]['rdv'])) $rdv = $data3[0]['rdv']; else $rdv = 0;
if(isset($data3[0]['classes'])) $classes = $data3[0]['classes']; else $classes = 0;
if(isset($data3[0]['eleves'])) $eleves = $data3[0]['eleves']; else $eleves = 0;
//Affichage sollicitations capitaines
$query4="select * FROM sollicitations WHERE idCapitaine=:num_cap AND traitement=0 AND chxNumEta=:chxNumEta";
$db4 = connect_base();
$queryRequest4 = $db4->prepare( $query4 );
$queryRequest4->bindParam( ':chxNumEta', $id, PDO::PARAM_INT );
$queryRequest4->bindParam( ':num_cap', $val['id_cap'], PDO::PARAM_INT );
$queryRequest4->execute();
$countSol=$queryRequest4->rowcount();
?>
Détail de l'équipe n°
Capitaine
Prénom Nom |
Apprenant
Prénom Nom |
Professionnel
Prénom Nom |
Rendez-vous
(Nb de classes/d'élèves) |
Sollicitations
En attente |
|
|
|
(/) |
|
Agenda de l'équipe n°
$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', $val['id_cap'], 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]['provenance']>0) $provenance = "Origine : Site"; else $provenance = "Origine : Directe";
if($dataD[0]['statut']=="bloque"){
$td = 'Indisponible | ';
}
if($dataD[0]['statut']=="libre"){
$td = 'Disponible | ';
}
if($dataD[0]['statut']=="reserve"){
$reserve = decrypter($maCleDeCryptage,$dataD[0]['etaCoLy'])."
(".decrypter($maCleDeCryptage,$dataD[0]['cpCoLy'])." ".decrypter($maCleDeCryptage,$dataD[0]['villeCoLy']).") ";
$td = ''.$reserve.'
'.$provenance.' | ';
}
}
}else $td = ' | ';
echo $td."\r\n";
}
echo ''."\r\n";
}
echo '
'."\r\n";
}
?>
Aucun trinôme pour ce CFA/LP pour l\'instant';
?>