function getAttendanceByStudentByMonth($s, $m, $c) { global $db; if ($m < 10) { $m = "0" . $m; } $syID = get_current_school_year(); $schoolYears = get_school_years_list(); $currentYear = $schoolYears[$syID]; list($startYear, $endYear) = preg_split("/-/", $currentYear); if ($m > 8) { $y = $startYear; } else { $y = $endYear; } $sql = "\n SELECT attendance.date, attendance.status, attendance.note, courses.course_name, users.first_name, users.last_name\n FROM attendance, users, courses\n WHERE attendance.date like '" . $y . "-" . $m . "%'\n AND users.user_id=attendance.student_id\n AND attendance.student_id=" . $s . "\n AND courses.course_id=attendance.course_id\n AND attendance.course_id=" . $c . "\n ORDER by users.last_name, users.first_name"; $result = $db->query($sql); return $result; }
function getClassRostersForSMS() { global $db; $currentSchoolYear = get_current_school_year(); $sql = "\r\n SELECT users.first_name, users.last_name, users.STGUID, users.user_id,\r\n courses.course_name, courses.SectionID,\r\n classes.class_id,\r\n terms.term_name, terms.term_id\r\n FROM users, courses, classes, terms, student2class\r\n WHERE courses.school_year_id=" . $currentSchoolYear . "\r\n AND classes.course_id=courses.course_id\r\n AND terms.term_id=classes.term_id\r\n AND student2class.class_id=classes.class_id\r\n AND users.user_id=student2class.user_id\r\n ORDER by users.last_name, users.first_name, terms.term_id\r\n "; $result = $db->query($sql); return $result; }
$sql2 = "INSERT INTO InterimReports (username,CLASSID, STGUID, iDate, Quality, Improvment, Comments, BuildingID)\n VALUES('" . $username . "','" . $classID . "','" . $stguid . "','" . $iDate . "','" . ms_escape_string($commentsByID[$_POST['quality']]['ItemText']) . "','" . implode(",", $smsInsertImprovement) . "','" . $iComment . "',95)"; $result = queryMSsql($sql2); } /** * ========== Grades ========== */ if (isset($_POST['addGradeComments'])) { /** * Need to insert STGUID, SectionID, Comment, SchoolYear, classid */ $q3aitStudents = make_assoc_array_from_sql(getCurrentStudentsForSMS(), 'user_id', 'my'); $stguid = $q3aitStudents[$_POST['student_id']]['STGUID']; $ci = get_class_info($_POST['class_id']); $classInfo = $ci->fetch_assoc(); $SectionID = $classInfo['SectionID']; $schoolYearID = get_current_school_year(); $schoolYearList = get_school_years_list(); $schoolYear = $schoolYearList[$schoolYearID]; $smsClassInfo = getClassInfoFromSectionID($SectionID); $classID = $smsClassInfo['CLASSID']; /** * Now for Q3AIT DB... */ /** $c = $_POST['class_id']; $s = $_POST['student_id']; $g1 = $g2 = makeSQLsafe($_POST['gradeComment']); $sql = "INSERT INTO comments (class_id, student_id, gradeComment) VALUES(".$c.",".$s.",'".$g1."') ON DUPLICATE KEY UPDATE gradeComment='".$g2."'";
$manual = true; // if running at cli by me else set to false /** * Rosters * 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) {