| Etablissement | Coordonnées | Inscriptions | Sollicitations/Rendez-vous | Classes/Elèves | Date dernière connexion |
|---|---|---|---|---|---|
| ".decrypter($maCleDeCryptage,$val['nom_eta'])." | "; echo "".decrypter($maCleDeCryptage,$val['adresse1'])." ".decrypter($maCleDeCryptage,$val['cp'])." ".decrypter($maCleDeCryptage,$val['ville'])." | ";
//Inscrit OUI / NON
$query="select * from capitaines,equipes where id_cap=num_capitaine and capitaines.num_eta=:id_eta and nom_eleve!='' and prenom_eleve!='' and nom_pro!='' and prenom_pro!=''";
$db2 = connect_base();
$queryRequest2 = $db2->prepare( $query );
$queryRequest2->bindParam( ':id_eta', $val['id_eta'], PDO::PARAM_INT );
$queryRequest2->execute();
$count=$queryRequest2->rowCount();
//NB Trinômes Validées / Total
// $query="select * from capitaines,equipes where id_cap=num_capitaine and capitaines.num_eta=:id_eta";
// $db2 = connect_base();
// $queryRequest2 = $db2->prepare( $query );
// $queryRequest2->bindParam( ':id_eta', $val['id_eta'], PDO::PARAM_INT );
// $queryRequest2->execute();
// $count2=$queryRequest2->rowCount();
if($count == 0 ){
$count = "Non inscrit";
} else {
if ($count == 1 ) $count = ''.$count.' trinôme';
else $count = ''.$count.' trinômes';
}
//NB de RDV, de classes et d'élèves
$query3="SELECT count(*) as rdvs, sum(nbClasses) as classes, sum(nbEleves) as eleves
FROM agenda
INNER JOIN collegelycee ON idCoLy=numCoLy
WHERE statut= 'reserve' AND numEta=:numEta";
$db3 = connect_base();
$queryRequest3 = $db3->prepare( $query3 );
$queryRequest3->bindParam( ':numEta', $val['id_eta'], PDO::PARAM_INT );
$queryRequest3->execute();
$data3=$queryRequest3->fetchAll();
if(isset($data3[0]['rdvs'])) $countRDV = $data3[0]['rdvs']; else $countRDV = 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;
//NB total de sollicitations (sollicitations (en attente + refusée) + RDV ), nb total de classes et nb total d'élèves
$query4="SELECT count(*) as sollicitations, sum(nbClasses) as classes, sum(nbEleves) as eleves
FROM sollicitations
WHERE traitement<>1 AND chxNumEta=:chxNumEta";
$db4 = connect_base();
$queryRequest4 = $db4->prepare( $query4 );
$queryRequest4->bindParam( ':chxNumEta', $val['id_eta'], PDO::PARAM_INT );
$queryRequest4->execute();
$data4=$queryRequest4->fetchAll();
if(isset($data4[0]['sollicitations'])) $countSol = $data4[0]['sollicitations'] + $countRDV; else $countSol = 0;
if(isset($data4[0]['classes'])) $classes = $classes + $data4[0]['classes'];
if(isset($data4[0]['eleves'])) $eleves = $eleves + $data4[0]['eleves'];
if($countSol <> $countRDV ){
$countRDV = "$countRDV";
}
// Date de dernière connexion
$derniereCo = MysqlToDateFr($val['date_co']);
if($derniereCo == "01/01/1970") $derniereCo = "";
echo "".$count." | "; echo "".$countSol.'/'.$countRDV." | "; echo "".$classes.'/'.$eleves." | "; echo "".$derniereCo." | "; echo "