$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"; //