$db = new mysqli($_CONF['DB_host'], $_CONF['DB_user'], $_CONF['DB_pass'], $_CONF['DB_name']); if (mysqli_connect_errno()) { die("There was an error connecting to the database: " . mysqli_connect_error()); } /** * Get the list of student from SMS. * Foreach teacher see if they exist in my SIS * If so, then update ? maybe not.... ??? * What about teachers in multiple buildings?????? * If not, then insert * Think about what to do about inactive teachers...? Need to work on that... * The buildingID in USERS is a center_id in my sis. For SchoolID, maybe use * 33 = BOCES Questar III for teachers...? Not sure that teachers need a school_id * */ $smsTeachers = make_assoc_array_from_sql(getCurrentTeachersFromSMS(), 'email', 'ms'); $q3aitTeachers = make_assoc_array_from_sql(getCurrentTeachersForSMS(), 'email', 'my'); $edCenters = make_assoc_array_from_sql(get_edCenters(), 'smsBuildingID', 'my'); $result = getSMSusers2center(); $u2c = array(); while ($row = $result->fetch_assoc()) { array_push($u2c, $row['user_id'] . $row['center_id']); } $msg = ''; // used to email admin if an error. $error = false; /** * NOTE: Teachers in multiple buildings still have the same email address. So, * Look up the teachers based on email rather than TGUID, then look for them in the * user2center table by user_id */
* This requires that the teachers from SMS exist in my sms. * */ require '/usr/local/q3ait/config.php'; require $_CONF['webRoot'] . 'functionLib.php'; // Connect to DB $db = new mysqli($_CONF['DB_host'], $_CONF['DB_user'], $_CONF['DB_pass'], $_CONF['DB_name']); if (mysqli_connect_errno()) { die("There was an error connecting to the database: " . mysqli_connect_error()); } $schoolYears = get_school_years_list(); $currentSchoolYear = get_current_school_year(); $schoolYear = $schoolYears[$currentSchoolYear]; $msg = ''; $q3aitTeachers = make_assoc_array_from_sql(getCurrentTeachersForSMS(), 'email', 'my'); $smsTeachers = make_assoc_array_from_sql(getCurrentTeachersFromSMS(), 'username', 'ms'); $edCenters = make_assoc_array_from_sql(get_edCenters(), 'smsBuildingID', 'my'); $q3aitCourses = make_assoc_array_from_sql(getCoursesForSMS(), 'SectionID', 'my'); $smsCourses = make_assoc_array_from_sql(getCoursesFromSMS(), 'SectionID', 'ms'); $course = array('teacher_id' => '', 'course_name' => '', 'school_year_id' => '', 'isCore' => '', 'ed_center' => '', 'SectionID' => ''); foreach ($smsCourses as $SectionID => $courseInfo) { if ($courseInfo['TakesAttendance'] != 1) { continue; } $teacher_id = $q3aitTeachers[$smsTeachers[$courseInfo['username']]['email']]['user_id']; if (!$teacher_id) { continue; } $teacher_fname = $q3aitTeachers[$smsTeachers[$courseInfo['username']]['email']]['first_name']; $teacher_lname = $q3aitTeachers[$smsTeachers[$courseInfo['username']]['email']]['last_name']; if ($SectionID != '' && $courseInfo['username'] != '' && $courseInfo['BuildingID'] != '') {