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'];
//."{".$course['course_name']."}";
$result = $db->query($sql);
$row = $result->fetch_assoc();
$current_term_id = $row['term_id'];
$current_term_name = $row['term_name'];
/** Get Ed Centers **/
$centers = get_edCenters();
foreach ($centers as $center_id => $short_name) {
/** Get Teachers **/
$teachers = get_users_for_center($center_id, 'isTeacher', 'Y', "users.last_name, users.first_name");
foreach ($teachers as $teacher_id => $teacher_name) {
$tinfo = get_teacher_info($teacher_id);
$tuname = $tinfo['u_name'];
/** Get Courses **/
$sql = "\n SELECT courses.course_id, courses.course_name\n FROM courses\n WHERE courses.teacher_id=" . $teacher_id . "\n AND courses.school_year_id=" . $yid . "\n AND courses.ed_center=" . $center_id;
$result = $db->query($sql);
$courses = make_array_from_sql($result, 'course_id', array('course_name'), '');
foreach ($courses as $course_id => $course_name) {
/** Get Classes **/
/** class_id=>term_name course_name **/
$classes = get_teacher_classes_by_course($course_id);
foreach ($classes as $class_id => $class_name) {
list($term, $course) = preg_split("/ - /", $class_name);
if ($term == $current_term_name) {
$save_path = $start_path . $short_name . "/" . $tuname . "/" . $course_name . "/" . $term . "/";
$save_file = $today . ".sql";
if (!is_dir($save_path)) {
mkdir($save_path);
chgrp($save_path, "AIT_Grades");
chmod($save_path, 0774);
}
/** check to see if there are more than 7 files and remove to 7 **/
* Here I think I will set ALL current rosters in q3ait to inactive then run the query to set all active.
*
* NO NO NO
* Dont set to inactive for ALL rosters, only the ones where the course is a CORE class
* Otherwise teacher created classes (ie integrated) will get disabled....
*/
if ($manual) {
print "Working on Rosters\n";
}
$msg = '';
$error = false;
$currentSchoolYear = get_current_school_year();
$sql = "UPDATE student2class SET isActive='N' where class_id IN (\n SELECT class_id FROM classes, courses\n WHERE classes.course_id=courses.course_id\n AND courses.school_year_id = " . $currentSchoolYear . "\n AND courses.isCore='Y')";
//$err = $db->query($sql);
$regi = array();
$smsClassRosters = make_array_from_sql(getClassRostersFromSMS(), 'ms');
displayArray($smsClassRosters);
exit;
$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');
$register = array();
// user_id, class_id
//displayArray($smsClassRosters);exit;
//displayArray($q3aitCourses);
//displayArray($q3aitUsers);
foreach ($smsClassRosters as $row) {
if (array_key_exists($row['SectionID'], $q3aitCourses)) {
if (array_key_exists($row['STGUID'], $q3aitUsers)) {
if ($row['DateExited'] == NULL) {
$student_id = $regi['student_id'] = $q3aitUsers[$row['STGUID']]['user_id'];
