if ($_SESSION[$_CONF['sess_name'] . '_isOffice'] || $_SESSION[$_CONF['sess_name'] . '_isGuidance']) { $termID = -1; if (isset($_POST['termID'])) { $termID = $_POST['termID']; } $terms = get_terms($_SESSION[$_CONF['sess_name'] . "_current_school_year"], $_SESSION[$_CONF['sess_name'] . "_myCenter"]); $termsList = make_array_from_mysql($terms, 'term_id', array('term_name'), ''); $termsSelect = make_selection_list($termsList, $termID, 'termID', 'termForm', 'Term', 'on'); $b = ''; $b .= "\n <center>\n <form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=post name=termForm>"; $b .= $termsSelect; $b .= "\n </center>"; $t = "Perfect Attendance report"; if ($termID != -1) { $report = array(); $result = getCoursesForSMS($_SESSION[$_CONF['sess_name'] . "_myCenter"]); $centerCourses = make_assoc_array_from_sql($result, 'course_id', 'my'); $unexcused = array("Unexcused-Abs", "Suspended", "WBL-Absent"); $excused = array("Present", "Tardy", "Community Service", "Additional Work", "Home School Closed/Delayed", "Questar Closed/Delayed"); $questionable = array("Excused-Abs"); /** *Testing knichel course_id= */ //$centerCourses = array('171'=>array("CourseName"=>"AIT1")); foreach ($centerCourses as $cid => $c) { $result2 = get_students_for_course($cid); $students = make_assoc_array_from_sql($result2, 'user_id', 'my'); $courseHead = "<div style=\"font-size:18px;font-weight:bold;color:#000000;\">" . $c['course_name'] . "</div>"; array_push($report, $courseHead); foreach ($students as $sid => $student) { $perfect = true;
*/ 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']; $course_id = $regi['course_id'] = $q3aitCourses[$row['SectionID']]['course_id']; $classes = get_classes_for_course($course_id); while ($row2 = $classes->fetch_assoc()) { array_push($register, array('user_id' => $student_id, 'class_id' => $row2['class_id'])); }