$gibbonRollGroupID = $_GET["gibbonRollGroupID"];
$URL = $_SESSION[$guid]["absoluteURL"] . "/index.php";
try {
$data = array("gibbonPersonIDTutor" => $_SESSION[$guid]["gibbonPersonID"], "gibbonPersonIDTutor2" => $_SESSION[$guid]["gibbonPersonID"], "gibbonPersonIDTutor3" => $_SESSION[$guid]["gibbonPersonID"]);
$sql = "SELECT * FROM gibbonRollGroup WHERE (gibbonPersonIDTutor=:gibbonPersonIDTutor OR gibbonPersonIDTutor2=:gibbonPersonIDTutor2 OR gibbonPersonIDTutor3=:gibbonPersonIDTutor3)";
$result = $connection2->prepare($sql);
$result->execute($data);
} catch (PDOException $e) {
//Fail 0
$URL .= "?exportReturn=fail0";
header("Location: {$URL}");
}
if ($result) {
if ($gibbonRollGroupID == "") {
//Fail 1
$URL .= "?exportReturn=fail1";
header("Location: {$URL}");
} else {
if ($result->rowCount() < 1) {
//Fail 3
$URL .= "?exportReturn=fail3";
header("Location: {$URL}");
} else {
//Proceed!
$exp = new ExportToExcel();
$sql = "SELECT surname, preferredName, email FROM gibbonStudentEnrolment INNER JOIN gibbonPerson ON gibbonStudentEnrolment.gibbonPersonID=gibbonPerson.gibbonPersonID WHERE gibbonRollGroupID=" . $gibbonRollGroupID . " AND status='Full' AND (dateStart IS NULL OR dateStart<='" . date("Y-m-d") . "') AND (dateEnd IS NULL OR dateEnd>='" . date("Y-m-d") . "') ORDER BY surname, preferredName";
$exp = new ExportToExcel();
$exp->exportWithQuery($sql, "classList.xls", $connection2);
}
}
}
