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'];