$body = displayTable(tableEtablissements(getAcademieArg(), getConstraintCollegesLycees()));
} else {
if ($action == "viewAll") {
$body = displayTable(tableEtablissements(getAcademieArg(), getConstraintAll()));
} else {
if ($action == "viewParticipColleges") {
$body = displayTable(tablePartipEtablissements(getAcademieArg(), getConstraintColleges()));
} else {
if ($action == "viewParticipLycees") {
$body = displayTable(tablePartipEtablissements(getAcademieArg(), getConstraintLycees()));
} else {
if ($action == "viewParticipBoth") {
$body = displayTable(tablePartipEtablissements(getAcademieArg(), getConstraintCollegesLycees()));
} else {
if ($action == "viewParticipAll") {
$body = displayTable(tablePartipEtablissements(getAcademieArg(), getConstraintAll()));
} else {
if ($action == "viewSchools") {
$body = displayTable(getTableSchools());
} else {
if ($action == "prepareNormalizedNamesQuery") {
$body = viewQuery(prepareNormalizedNamesQuery());
} else {
if ($action == "prepareNormalizedNamesExecute") {
$stmt = getDb()->prepare(prepareNormalizedNamesQuery());
$stmt->execute();
reportErrors($stmt);
$body = "Normalized etablissements names.";
} else {
if ($action == "viewSchoolsMatchingView") {
$body = displayTable(getTableSchoolsMatchingView());
// TODO: sendMail($sEmail, $sTitle, $sBody, $config->email->sEmailSender);
$message = "successful_email";
}
}
}
echo json_encode(array('success' => 1, 'message' => $message));
exit;
}
//--------------------------------------------------------------
// get short list of nearbySchools
if ($nearby) {
$result = getNearbySchoolResults($userID);
$userAcademieID = $result['academyID'];
$userLevel = $result['level'];
echo json_encode(array('success' => 1, 'nearbySchools' => $result['schoolNames'], 'fullListURL' => "participatingSchools.php?academyID={$userAcademieID}&level={$userLevel}"));
exit;
}
//--------------------------------------------------------------
// display full list of nearbySchools
$optionsLevel = optionsForSelect(getLevelItems(), $level);
$optionsAcademy = optionsForSelect(getAcademieItems(), $academyID);
$tableData = '';
if ($academyID != 0) {
$constraintLevel = getConstraintForLevel($level);
$tableData = tablePartipEtablissements($academyID, $constraintLevel);
}
if (!empty($tableData)) {
$tableData = "\n <div>Les établissements participants sont affichés sur fond vert. <br>\n Seuls les collèges, et lycées généraux et/ou technologiques sont listés ci-dessous. <br> \n Note : certains établissements participants peuvent manquer si leur nom a été mal saisi.</div>\n <br>" . $tableData;
}
echo "\n<!DOCTYPE html>\n<html>\n<head>\n <meta http-equiv='Content-Type' content='text/html; charset=utf-8' />\n <link rel='stylesheet' href='admin.css' />\n\n <style>\n #participating {\n border-collapse: collapse;\n }\n #participating td {\n border: 1px solid black;\n padding: 0.2em;\n }\n </style>\n</head>\n<body>\n<div id='divHeader'>\n <table style='width:100%'><tr>\n <td style='width:20%'><img src='images/castor_small.png'/></td>\n <td><p class='headerH1'>Castor Informatique France</p>\n <p class='headerH2'> Plate-forme du concours Castor - <span style='color:red;font-weight:bold'>ACCÈS COORDINATEUR</span></p>\n </td>\n <td></td>\n </tr></table>\n</div>\n\n<br>\n<form action='participatingSchools.php' method='get'>\n<div>\n<select name='academyID' onchange='this.form.submit()'>\n <option value='0'>Choisir une académie</option> \n {$optionsAcademy}\n </select>\n<select name='level' onchange='this.form.submit()'>\n {$optionsLevel}\n </select>\n</div>\n\n</form>\n\n\n\n<br>\n{$tableData}\n\n\n\n</body>\n</html>\n\n";
//
