$meeting = retreiveAttendanceMeetingId($formData['id']);
updateAttendance($formData['id'], $formData['position'], $formData['status']);
$smarty->assign("url", "./index.php?page=listAttendance&meeting=" . $meeting);
$smarty->display('redirect.tpl');
break;
case 'deleteAttendance':
//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++//
$formData['id'] = db_clean_int($_POST['id']);
//Verify form
if (!secureform_test_pk($verify_key, $verify_action, $formData['id'])) {
$smarty->assign("url", "./index.php?page=updateAttendance&attendance=" . $formData['id']);
$smarty->display('redirectError.tpl');
exit;
}
$meeting = retreiveAttendanceMeetingId($formData['id']);
deleteAttendance($formData['id']);
$smarty->assign("url", "./index.php?page=listAttendance&meeting=" . $meeting);
$smarty->display('redirect.tpl');
break;
case 'fillAttendanceList':
//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++//
$meeting = db_clean_int($_POST['id']);
//Verify form
if (!secureform_test_pk($verify_key, $verify_action, $meeting)) {
$smarty->assign("url", "./index.php?page=listAttendance&meeting=" . $meeting);
$smarty->display('redirectError.tpl');
exit;
}
addMembersToAttendance($meeting);
$smarty->assign("url", "./index.php?page=listAttendance&meeting=" . $meeting);
$smarty->display('redirect.tpl');
// Add the attendance record if the user is adding one //
if ($_POST["addattendance"] == 1) {
require_once "DBFunctions.php";
// Get the termid from the semester //
$query = mysql_query('SELECT termid FROM semesters WHERE semesterid = ' . $_POST["semester"]);
$id = mysql_result($query, 0);
// Insert the attendance record //
$query = mysql_query("INSERT INTO schoolattendance VALUES('', '{$_POST['student']}', '" . converttodb($_POST["attdate"]) . "', '{$_POST['semester']}', {$id}, '{$_POST['type']}')") or die("ManageAttendance.php: Unable to insert new attendance record - " . mysql_error());
}
// Delete the selected attendance record //
if ($_POST["deletereg"] == 1) {
require_once "DeleteFunctions.php";
$delete = $_POST["delete"];
for ($i = 0; $i < sizeof($delete); $i++) {
deleteAttendance($delete[$i]);
}
}
print "<script language='JavaScript'>\n\n // Function to make sure the student wants to delete the registration(s) //\n function validate()\n {\n if( document.registration.selectreg.value > 0 )\n {\n\tvar confirmed = confirm(\"Are you sure you want to delete this attendance record?\");\n\n\tif( confirmed == true )\n\t{\n\t document.registration.submit();\n\t}\n }\n else\n {\n\talert('You must select an attendance record to delete.');\n }\n }\n\n\n // Function to make sure only one checkbox has been selected //\n function checkboxes()\n {\n if( document.registration.selectreg.value == 1 )\n {\n\tdocument.registration.submit();\n }\n else\n {\n\tif( document.registration.selectreg.value > 1 )\n\t{\n\t alert('You can only edit one student at a time.');\n\t}\n\telse\n\t{\n\t alert('You must select a registration to edit.');\n\t}\n }\n }\n\n\n // Function to keep track of how many checkboxes are checked //\n function updateboxes(row)\n {\n row = row + 1;\n if(document.registration.elements[row].checked)\n {\n\tdocument.registration.selectreg.value = Math.round(document.registration.selectreg.value) + 1;\n }\n else\n {\n\tdocument.registration.selectreg.value = Math.round(document.registration.selectreg.value) - 1;\n }\n //alert(document.registration.selectreg.value);\n }\n </script>\n <h1>Attendance</h1>\n <br>\n <table align='center' width='400' cellspacing='0' cellpadding='0' border='0'>\n <tr>\n <td>\n <form name='registration' action='./index.php' method='POST'>\n <b>Semester: </b> <select name='semester' onChange='document.registration.addattend.value=0;document.registration.deletereg.value=0;document.registration.submit();'>\n ";
// Get a list of semesters //
$query = mysql_query("SELECT semesterid, title FROM semesters") or die("Registration.php: Unable to get a list of semesters for drop-down - " . mysql_error());
if ($_POST['semester'] == NULL) {
$q = mysql_query("SELECT semesterid, title FROM semesters WHERE startdate < CURDATE() < enddate");
$temp = mysql_fetch_row($q);
$_POST['semester'] = $temp[0];
if ($_POST['semester'] == NULL) {
$_POST['semester'] = '';
}
}
while ($semester = mysql_fetch_row($query)) {
print "<option value='{$semester['0']}' " . ($_POST['semester'] == $semester[0] && $_POST['semester'] != NULL ? "SELECTED" : "") . ">{$semester['1']}</option>";
