$b .= "\n <center>\n <form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST id=\"attendForm\" name=\"attendForm\">\n <table>\n <tr>\n <td align=right>School:</td>\n <td>" . $schoolSelect . "</td>\n </tr>\n <tr>\n <td align=right>Session:</td>\n <td>\n <input class=\"validate[required] radio\" type=radio name=session id=session value='AM' ";
if ($sess == 'AM') {
$b .= " checked=true";
}
$b .= " />AM\n <input class=\"validate[required] radio\" type=radio name=session id=session value='PM' ";
if ($sess == 'PM') {
$b .= " checked=true";
}
$b .= " />PM\n <input class=\"validate[required] radio\" type=radio name=session id=session value='BOTH' ";
if ($sess == 'BOTH') {
$b .= " checked=true";
}
$b .= " />BOTH\n </td>\n </tr>\n <tr>\n <td colspan=2 align=center>\n <input type=submit name=getRoster id=getRoster value=Get />\n </td>\n </tr>\n </table>\n </form>\n </center>\n ";
if (isset($_POST['getRoster'])) {
$roster = array();
$courses = make_assoc_array_from_sql(get_courses_for_bulkAttend($_SESSION[$_CONF['sess_name'] . '_myCenter'], $sess, $today), 'course_id', 'my,');
foreach ($courses as $cid => $courseInfo) {
$result2 = get_students_for_course($cid);
while ($row2 = $result2->fetch_assoc()) {
if ($sid == $row2['school_id']) {
$roster[$row2['last_name'] . $row2['first_name']] = "<tr><td>" . $row2['first_name'] . " " . $row2['last_name'] . "</td><td>" . $courseInfo['course_name'] . "</td></tr>";
}
}
}
ksort($roster);
$table = "\n <table cellpadding=3 cellspacing=5>\n ";
foreach ($roster as $k => $v) {
$table .= $v;
}
$table .= "</table>";
$b .= "<center>" . $table . "</center>";
$note2 = makeSQLsafe($_POST['attendNote']);
if ($_POST['attendReason'] != 'none') {
if ($_POST['attendNote'] != '') {
$note = $note1 . " => " . $note2;
} else {
$note = $note1;
}
} else {
$note = $note2;
}
}
$SMSmsg = '';
foreach ($schoolsForBulkAttend as $schoolID => $schoolName) {
$SMSmsg .= "Bulk Attendance for School {" . $schoolName . "} for session {" . $_POST['session'] . "}<BR>";
$studentList = array();
$result1 = get_courses_for_bulkAttend($_SESSION[$_CONF['sess_name'] . '_myCenter'], $_POST['session'], $_POST['dateSelector']);
$coursesArray = make_array_from_sql($result1, 'my');
$absRecord = array('AbsType' => $_POST['attendValue'], 'AbsDate' => $_POST['dateSelector'], 'ExtraHours' => '', 'Comment' => $note, 'SectionID' => '', 'STGUID' => '');
foreach ($coursesArray as $course) {
if ($_POST['attendValue'] == 0) {
$absRecord['ExtraHours'] = 0;
} elseif ($_POST['attendValue'] == 'Unexcused-Abs' || $_POST['attendValue'] == 'Excused-Abs' || $_POST['attendValue'] == 'Suspended' || $_POST['attendValue'] == 'WBL-Abssent') {
$absRecord['ExtraHours'] = 0;
} else {
$absRecord['ExtraHours'] = $course['minutes'] - $_POST['a_minutes'];
}
if ($absRecord['ExtraHours'] < 0) {
$absRecord['ExtraHours'] = 0;
// just in case a class is shorter than the post minutes....
}
$absRecord['SectionID'] = $course['SectionID'];
$q3aitClassRosters = make_assoc_array_from_sql(getClassRostersForSMS(), 'SectionID', 'my');
$q3aitUsers = make_assoc_array_from_sql(getCurrentStudentsForSMS(), 'STGUID', 'my');
$q3aitCourses = make_assoc_array_from_sql(getCoursesForSMS(), 'SectionID', 'my');
//displayArray($smsTeachers);exit;
//displayArray($smsStudents);exit;
//displayArray($q3aitTeachers);exit;
//displayArray($smsCourses);exit;
//displayArray($q3aitStudents);exit;
//get_school_year_info(6, 1);
//getSMSStudentAttendance(171,6,1);
$msg = '';
// set to blank for courses
$error = false;
$schoolYears = get_school_years_list();
$currentSchoolYear = get_current_school_year();
$schoolYear = $schoolYears[$currentSchoolYear];
$q3aitTeachers = make_assoc_array_from_sql(getCurrentTeachersForSMS(), 'email', 'my');
$smsTeachers = make_assoc_array_from_sql(getCurrentTeachersFromSMS(), 'username', 'ms');
$edCenters = make_assoc_array_from_sql(get_edCenters(), 'smsBuildingID', 'my');
$q3aitCourses = make_assoc_array_from_sql(getCoursesForSMS(), 'SectionID', 'my');
$smsCourses = make_assoc_array_from_sql(getCoursesFromSMS(), 'SectionID', 'ms');
$courses = make_assoc_array_from_sql(get_courses_for_bulkAttend('1', "AM", $today), 'course_id', 'my,');
//displayArray($courses);exit;
foreach ($courses as $cid => $courseInfo) {
$result2 = get_students_for_course($cid);
while ($row2 = $result2->fetch_assoc()) {
if ('25' == $row2['school_id']) {
print $courseInfo['course_name'] . " - " . $row2['first_name'] . " " . $row2['last_name'] . "<br>";
}
}
}
