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) {
