PHP getCoursesForSMS Examples

Example #1

File: office_perfectAttendance.php Project: knichel/AIT

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;

Example #2

File: _syncRosters.php Project: knichel/AIT

 */
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']));
                }