$wblArray = array('error' => $error, 'message' => $msg, 'updateWBL' => $wbl);
echo json_encode($wblArray);
}
// end updateWBL
if (isset($_POST['student2wbl'])) {
$sql = "SELECT job from wbl where wbl_id=" . $_POST['jobID'];
$result = $db->query($sql);
$row = $result->fetch_assoc();
$error = false;
$courseID = $_SESSION[$_CONF['sess_name'] . '_selected_course'];
// get the list of students for the current course...
$myStudents_ID = make_assoc_array_from_sql(get_students_for_course($courseID), 'user_id', 'my');
// get students already assigned to the job
$sql2 = "SELECT * from student2wbl where wbl_id=" . $_POST['jobID'];
$result2 = $db->query($sql2);
$students = make_assoc_array_from_sql($result2, 'student_id', 'my');
$ret .= "<center>" . "<table>";
foreach ($myStudents_ID as $id => $info) {
$ret .= "\n <tr>\n <td>\n <input type=checkbox id=\"student_" . $id . "\" name=\"student_" . $id . "\"";
if (array_key_exists($id, $students)) {
$ret .= " checked";
}
$ret .= " />" . $info['first_name'] . " " . $info['last_name'] . "</td>\n </tr>\n ";
}
$ret .= "\n </table>\n <input type=hidden name=jobID value=" . $_POST['jobID'] . " id=\"jobID\" />\n </center>";
$wbl = $ret;
$wblArray = array('error' => $error, 'message' => $msg, 'students2WBL' => $wbl);
echo json_encode($wblArray);
}
if (isset($_POST['s2jWBL'])) {
$msg = "<h2>Adding Students</h2>";
require 'fpdf.php';
include '_includeSessionConfig.php';
$loginError = check_auth($_SESSION[$_CONF['sess_name'] . '_username'], $_SESSION[$_CONF['sess_name'] . '_password']);
$today = date('Y-m-d');
if (!$loginError['error_value']) {
$cid = $_SESSION[$_CONF['sess_name'] . '_selected_course'];
$tid = $_POST['teacherID'];
$row = get_teacher_info($tid);
$teaacherName = $row['first_name'] . " " . $row['last_name'];
$yid = $_SESSION[$_CONF['sess_name'] . '_current_school_year'];
$sid = $_SESSION[$_CONF['sess_name'] . '_myCenter'];
$terms = get_terms($yid, $sid);
$termsArray = make_assoc_array_from_sql($terms, 'term_id', 'my');
if ($cid != -1) {
$result = get_students_for_course($cid);
$students = make_assoc_array_from_sql(get_students_for_course($cid), 'user_id', 'my');
$result = get_course_info($cid);
$row = $result->fetch_assoc();
$courseName = $row['course_name'];
/** NOW FOR THE PDF STUFF **/
$lm = 0.5;
/** left marging**/
$tm = 0.5;
/** top margin**/
$ph = 11 - 2 * $tm;
/** page width - margins**/
$pw = 8.5 - 2 * $lm;
/** page height - margins**/
$rh = 0.25;
/** height for attendance row **/
$hh = 0.4;
$courses = get_student_core_class_list($sid);
$courseSelect = make_selection_list($courses, $cid, 'course_id', 'attendByStudent', 'Course', 'on');
$b .= "\n <tr>\n <td align=right>Course:</td>\n <td>" . $courseSelect . "</td>\n <td align=left>Date:<input id=\"a_date\" name=\"a_date\" type=text size=15 value=" . $today . " /></td>\n </tr>\n ";
}
$b .= "\n <tr>\n <td colspan=3 align=center>\n <!-- input type=submit name=submit value=\"Get\" / -->\n </td>\n </tr>";
if ($sid != -1 && $cid != -1) {
$today = date('Y-m-d');
/** Get User Info from Q3 * */
$sql = "SELECT users.user_id, users.first_name, users.last_name, LOWER(users.STGUID) as STGUID, schools.school_name, schools.school_id\n FROM users, schools\n WHERE users.user_id=" . $sid . "\n AND schools.school_id=users.school_id";
$result = $db->query($sql);
$student = $result->fetch_assoc();
/** Get any attendance info from SMS **/
//$myStudents_GUID = make_assoc_array_from_sql($result, 'STGUID', 'my');
/** Get Attendance info from SMS * */
$result2 = getSMSattendanceForStudent($student['STGUID'], $today);
$SMSresults = make_assoc_array_from_sql($result2, 'STGUID', 'ms');
/** now for the attendance form for selected student * */
$note = '';
if (array_key_exists($student['STGUID'], $SMSresults)) {
$default = false;
$currentStatus = $SMSresults[$student['STGUID']]['status'];
$minutes = $SMSresults[$student['STGUID']]['minutes'];
/** Need to figure out which class student is in... */
$note = $SMSresults[$student['STGUID']]['note'];
$noteSelect = $noteText = "";
if (strpos($note, " => ")) {
list($noteSelect, $noteText) = preg_split("/ => /", $note);
} elseif (in_array($note, $smsAttendReasons)) {
$noteSelect = $note;
} else {
$noteText = $note;
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'] != '') {
if (!array_key_exists($SectionID, $q3aitCourses)) {
$course = array('teacher_id' => $teacher_id, 'course_name' => $courseInfo['tsn'], 'school_year_id' => array_search($courseInfo['SchoolYear'], $schoolYears), 'isCore' => $courseInfo['TakesAttendance'], 'ed_center' => $edCenters[$courseInfo['BuildingID']]['center_id'], 'SectionID' => $courseInfo['SectionID']);
foreach ($course as &$cell) {
$msg .= "Copying Assignments";
$today = date('Y-m-d');
$t = "Class Assignments";
$bc = "blue";
$copyAssigns .= "\n\t\t\t\t<div style=text-align:center>Term Start: " . $sm . "-" . $sd . "-" . $sy . " Term End: " . $em . "-" . $ed . "-" . $ey . "</div>\n\t\t\t\t<center>\n\t\t\t\t<table cellspacing=1 cellpadding=3 border=0 bgcolor=black border=0>\n\t\t\t\t<tr>\n\t\t\t\t<th>Name</th><th>Category</th><th>Due Date</th><th>Max Score</th><th>Weight</th><th>Extra Credit</th>\n\t\t\t\t</tr>";
/*
* Need to figure out how to deal with the assignment ID's. Since I am copying, I don;t want to copy them
* but I do need to extract the info from the result1 query.
* Also need to figure out how to pre-select the category if it exists...
*/
$sql1 = "SELECT assignment_id, assignment_name, assignments.category_id, due_date, max_score, assignment_weight, assignment_note, isExtraCredit, categories.category_name\n FROM assignments, categories\n WHERE assignment_id IN (" . $ids . ")" . "AND categories.category_id=assignments.category_id";
$result1 = $db->query($sql1);
$sql = "SELECT * from categories where class_id=" . $toClassID;
//.$_SESSION[$_CONF['sess_name'].'_selected_class'];
$result = $db->query($sql);
$categoriesArray = make_assoc_array_from_sql($result, 'category_name', 'my');
function makeCatSelect($s)
{
global $categoriesArray;
foreach ($categoriesArray as $catName => $catArray) {
$catList .= "\n <option value=" . $catArray['category_id'];
if ($catName == $s) {
$catList .= " selected style=\"background-color:green\"";
} else {
$catList .= " style=\"background-color:pink\"";
}
$catList .= ">" . $catName . " (" . $catArray['category_weight'] . "%)</option>";
}
return $catList;
}
for ($i = 1; $i <= $numAssigns; $i++) {
/**
* Create Parent Account : createUser takes care of multiple centers now....
*/
srand((double) microtime() * 1000000);
$u_passwd = '';
$passwd = rand();
$passwd = md5($passwd);
$u_passwd = substr($passwd, 1, 8);
$user = array('first_name' => $_POST['parentFirstName'], 'last_name' => $_POST['parentLastName'], 'u_name' => $_POST['u_name'], 'email' => $_POST['parentEmail'], 'passwd' => md5($u_passwd));
$where_clause = 'isParent';
$centers = array_keys(get_center_for_user($studentID));
/**
* If u_name already exits, then this is a paarent adding a child....
* Look up info by u_name to get the user_id etc...
*/
$parentInfo = make_assoc_array_from_sql(get_user_info_by_username($_POST['u_name']), 'u_name', 'my');
if (count($parentInfo[$_POST['u_name']])) {
$parentID = $parentInfo[$_POST['u_name']]['user_id'];
} else {
$msg = createUser($user, $where_clause, $centers);
if ($msg['error']) {
$b .= "<span style=\"color:red;\">There was a problem creating your user account.<br> \n Please contact the system administrator {" . $_CONF['admin_name'] . " @ " . $_CONF['admin_email'] . "}.<br>\n The error was " . $msg['message'] . "</span>";
} else {
$email_results = email_user_login_info($_POST['parentFirstName'], $_POST['parentLastName'], $_POST['parentEmail'], $_POST['u_name'], $u_passwd, '2');
$parentID = $msg['user_id'];
}
}
/**
* Link Parent to Student
*
*/
function get_center_for_user($uid)
{
global $db;
$centers = array();
$sql = "SELECT * from user2center where user_id=" . $uid;
$result = $db->query($sql);
$centers = make_assoc_array_from_sql($result, 'center_id', 'my');
foreach ($centers as $id => $info) {
$centers[$id] = $info['short_name'];
}
return $centers;
}
$center_ids = array_keys($centers);
reset($centers);
$center_id = key($centers);
//$center_id = $center_ids[0]; // the first center ID
$_SESSION[$_CONF['sess_name'] . '_myCenter'] = $center_id;
$_SESSION[$_CONF['sess_name'] . '_myCenters'] = $centers;
$_SESSION[$_CONF['sess_name'] . '_isTeacher'] = $centers[$center_id]['isTeacher'] == 'Y';
$_SESSION[$_CONF['sess_name'] . '_isParent'] = $centers[$center_id]['isParent'] == 'Y';
$_SESSION[$_CONF['sess_name'] . '_isStudent'] = $centers[$center_id]['isStudent'] == 'Y';
$_SESSION[$_CONF['sess_name'] . '_isAdmin'] = $centers[$center_id]['isAdmin'] == 'Y';
$_SESSION[$_CONF['sess_name'] . '_isGuidance'] = $centers[$center_id]['isGuidance'] == 'Y';
$_SESSION[$_CONF['sess_name'] . '_isOffice'] = $centers[$center_id]['isOffice'] == 'Y';
$_SESSION[$_CONF['sess_name'] . '_logged_in'] = true;
$termsql = get_terms($_SESSION[$_CONF['sess_name'] . '_current_school_year'], $_SESSION[$_CONF['sess_name'] . '_myCenter']);
//$_SESSION[$_CONF['sess_name'].'_terms'] = make_assoc_array_from_mysql($termsql, 'term_id', array('term_name'), '');
$_SESSION[$_CONF['sess_name'] . '_terms'] = make_assoc_array_from_sql($termsql, 'term_id', 'my');
/**
* Now get the classes for the current teacher
*/
$res = get_teacher_classes_for_current_year($_SESSION[$_CONF['sess_name'] . '_myUID']);
$teacherClassesArray = array();
while ($row = $res->fetch_assoc()) {
$teacherClassesArray[$row['class_id']] = $row;
}
$_SESSION[$_CONF['sess_name'] . '_teacherClassList'] = $teacherClassesArray;
/**
if user is admin, then set adminCenterID so admin may work
in other schools...
**/
if ($_SESSION[$_CONF['sess_name'] . '_isAdmin']) {
/** default to my school **/
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
*/
foreach ($smsTeachers as $email => $row) {
$BuildingID = $row['buildingID'];
}
// end if $sid != -1
} else {
$eb = "<H2 align=center>You may not enter comments for this class.</h1>";
$et = "Error...";
$ec = "red";
$b .= make_box($et, $eb, $ec);
}
}
// end if isset class_id
$main .= make_box($t, $b);
/**
* Now lets get past commnets for BOTH interim and grading period and display them in Term Order
*/
if ($pastComments) {
$pastCommentsList = make_assoc_array_from_sql($pastComments, 'class_id', 'my');
//displayArray($pastCommentsList);exit;
$past = '';
foreach ($pastCommentsList as $classComment) {
$class = $_SESSION[$_CONF['sess_name'] . '_teacherClassList'][$classComment['class_id']];
//$past = displayArray2($class);
//$past = displayArray2($classComment);
$past .= "<span class='comment-title'>Class</span>: " . $class['course_name'] . " ~ " . $class['term_name'] . "<br>";
$past .= "<span class='comment-title'>Student</span>: " . $Quality[$classComment['interimQuality']] . "<br>";
$past .= "<span class='comment-title'>Student Needs Improvement In</span>: " . $Quality[$classComment['interimImprovement']] . "<br>";
$intImpList = explode(",", $classComment['interimImprovement']);
foreach ($intImpList as $ii) {
$past .= "   -" . $Improvement[$ii] . "<br>";
}
$past .= "<span class='comment-title'>Interim Comment</span>: " . $classComment['interimComment'] . "<br>";
$past .= "<span class='comment-title'>Grade Comment</span>: " . $classComment['gradeComment'] . "<br>";
// used to create query for SMS system...
if ($_SESSION[$_CONF['sess_name'] . '_isTeacher']) {
/**
* SMS Attendace values differ from mine, so create an array for translating...
*/
$myStudents_GUID = "";
$myStudents_ID = "";
$ait2smsAttend = array('absent' => 'Unexcused-Abs', 'excused' => 'Excused-Abs', 'tardy' => 'Tardy', 'present' => 'Present');
$sms2aitAttend = array('Unexcused-Abs' => 'absent', 'Excused-Abs' => 'excused', 'Tardy' => 'tardy', 'Present' => 'present');
/** create js function to deal with attend_".$row['user_id']."_student.checked=true from the notes ...**/
/** Display the list of classes **/
$cid = -1;
if (isset($_SESSION[$_CONF['sess_name'] . '_selected_course']) && $_SESSION[$_CONF['sess_name'] . '_selected_course'] != -1) {
$cid = $_SESSION[$_CONF['sess_name'] . '_selected_course'];
$myStudents_ID = make_assoc_array_from_sql(get_students_for_course($cid), 'user_id', 'my');
$myStudents_GUID = make_assoc_array_from_sql(get_students_for_course($cid), 'STGUID', 'my');
$result = get_course_info($cid);
$row = $result->fetch_assoc();
$cname = $row['course_name'];
$classMinutes = $row['minutes'];
$SectionID = $row['SectionID'];
}
$core_classes = get_teacher_course_list($_SESSION[$_CONF['sess_name'] . '_myUID'], $_SESSION[$_CONF['sess_name'] . '_current_school_year'], $_SESSION[$_CONF['sess_name'] . '_myCenter'], 'Y');
$displayForm = false;
if (array_key_exists($cid, $core_classes)) {
$displayForm = true;
} else {
$cid = $_SESSION[$_CONF['sess_name'] . '_selected_course'] = -1;
}
$t = "Teacher Attendance";
$b = "\n\t\t<form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=\"post\" name=courses>\n\t\t<center>" . make_selection_list($core_classes, $cid, 'course_id', 'courses', 'Course', 'on') . "</center>\n\t\t</form>\n";
echo json_encode($ret);
}
if (isset($_POST['deleteScores'])) {
$ids = array();
foreach ($_POST as $k => $v) {
if (substr($k, 0, 2) == "s_") {
array_push($ids, $v);
}
}
$msg = "<h2>Deleting Scores</h2>";
$error = false;
$deleteScores = array();
$resCodes = get_teacher_custom_scores($_SESSION[$_CONF['sess_name'] . '_myUID'], $_SESSION[$_CONF['sess_name'] . '_current_school_year']);
$score_codes = make_assoc_array_from_sql($resCodes, 'score_id', array('code'), '');
$resCodes->data_seek(0);
$score_names = make_assoc_array_from_sql($resCodes, 'score_id', array('long_name'), '');
$count = 0;
foreach ($ids as $id) {
$msg .= "<h3>Deleting " . $score_names[$id]['long_name'] . " - " . $score_codes[$id]['code'] . ".<br />";
$sql1 = "SELECT count(*) as count\n\t\t\t\tFROM grades\n\t\t\t\tJOIN assignments USING (assignment_id)\n\t\t\t\tJOIN categories USING (category_id)\n\t\t\t\tJOIN classes USING (class_id)\n\t\t\t\tJOIN courses USING (course_id)\n\t\t\t\tJOIN users ON courses.teacher_id = users.user_id\n\t\t\t\tWHERE users.user_id=" . $_SESSION[$_CONF['sess_name'] . '_myUID'] . "\n\t\t\t\tAND courses.school_year_id=" . $_SESSION[$_CONF['sess_name'] . '_current_school_year'] . "\n\t\t\t\tAND grades.raw_score='" . $score_codes[$id]['code'] . "'";
$result1 = $db->query($sql1);
$row1 = $result1->fetch_assoc();
$grades = $row1['count'];
if ($grades) {
$msg .= "<h2>You cannot delete custom score {" . $score_names[$id] . "}, It is used in your gradebook this year.</h2>";
} else {
$sql = "DELETE from custom_scores where score_id=" . $id;
$result = $db->query($sql);
if ($result) {
array_push($deleteScores, $id);
$count++;
*/
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']));
}
<?php
require '_configPath.php';
require $configPath . 'config.php';
require $_CONF['webRoot'] . 'functionLib.php';
/**
* MySQL
*/
$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());
}
/**
* MSSQL
*/
$host = '192.168.8.3';
$dbname = 'SMS';
$user = '******';
$pass = '******';
$conn = mssql_connect($host, $user, $pass);
mssql_select_db("SMS", $conn);
if (!$conn) {
die("Error connecting to mssql server\n");
}
$smsStudents = make_assoc_array_from_sql(getCurrentStudentsFromSMS(), 'STGUID', 'ms');
displayArray($smsStudents);
mssql_close($conn);
$pdf->Cell($studentw, 2 * $termh, 'Student Names', 0, 0, 'C', 1);
$x_coord += $studentw;
$classes = get_teacher_classes_by_course($courseID);
foreach ($terms as $termID => $termInfo) {
$pdf->Cell($termw, $termh, $termInfo['term_name'], 0, 2, 'C', 1);
$page .= $termInfo['term_name'] . " ";
$pdf->Cell($termw, $termh, $termInfo['term_weight'] . "%", 0, 0, 'C', 1);
$x_coord += $termw;
$pdf->SetXY($x_coord, $y_coord);
}
$pdf->Cell($overallavw, 2 * $termh, 'Overall Avg.', 0, 1, 'C', 1);
$pdf->SetFillColor(255, 255, 255);
$x_coord = $lm;
$y_coord += 2 * $termh;
$result = get_students_for_course($courseID);
$students = make_assoc_array_from_sql($result, 'user_id', 'my');
foreach ($students as $sid => $studentInfoArray) {
$avgSum = $percentSum = $termCount = 0;
$pdf->SetFont('Times', '', $studentfs);
$pdf->Cell($studentw, $studenth, $studentInfoArray['first_name'] . " " . $studentInfoArray['last_name'], 0, 0, 'C', 1);
$page .= $studentInfoArray['first_name'] . " " . $studentInfoArray['last_name'] . " ";
foreach ($classes as $class_id => $classTitle) {
$reports = getReportForStudent($sid, $courseInfo['user_id'], $class_id);
if (!empty($reports)) {
$termID = $reports[$sid]['classInfo']['term_id'];
if ($reports[$sid]['overallCalculatedAverage'] > 0) {
$termWeight = $terms[$termID]['term_weight'];
$avgSum += $reports[$sid]['overallCalculatedAverage'] * ($termWeight / 100);
$percentSum += $termWeight;
$termCount++;
}
$key = 'user_id';
$result = get_students_for_course($cid);
$results = make_assoc_array_from_sql($result, $key, 'my');
//displayArray($results);
} else {
/**
* What if gale already did a set by district? Then only a few
* students will have marks...
*/
//$default = true;
//$key = 'STGUID';
$key = 'user_id';
//$result = getSMSattendanceForToday($SectionID, $selectedDate);
//$SMSresults = make_assoc_array_from_sql($result, $key, 'ms');
$result = get_attendance_for_today($cid, $selectedDate);
$results = make_assoc_array_from_sql($result, $key, 'my');
//displayArray($results);
}
$table = "\n <center><div style=\"color:red; font-weight:bold;\">NOTE : You must enter an attendance mark for every student now when taking attendance for the first time. <br />\n After that you only change a student that comes in late etc...<br />\n The minutes are the # of minutes a student spends in your classroom.</div></center><br />";
$table .= "\n <form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST id=\"attendForm\">";
$table .= "\n <input type=hidden name=default_course_minutes id=default_course_minutes value=\"" . $courseInfo['minutes'] . "\" />\n <center>\n\n <table cellspacing=0 cellpadding=3 border=0 bgcolor=white>\n <tbody class=attendanceRows>";
if ($_SESSION[$_CONF['sess_name'] . '_isOffice'] && $_SESSION[$_CONF['sess_name'] . '_lev'] == 'office' || $_SESSION[$_CONF['sess_name'] . '_isTeacher'] && $_SESSION[$_CONF['sess_name'] . '_lev'] == 'teach') {
$result = get_course_info_from_classID($_SESSION[$_CONF['sess_name'] . '_selected_course']);
$courseInfo = $result->fetch_assoc();
/** ############################## Tarek's Way ################################# */
foreach ($myStudents_ID as $id => $row) {
$note = '';
$noteSelect = $noteText = "";
//if(array_key_exists($id, $results)){
if ($default == false) {
$currentStatus = $results[$id]['status'];
$fname = $_SESSION[$_CONF['sess_name'] . '_myfName'];
$lname = $_SESSION[$_CONF['sess_name'] . '_mylName'];
$tid = $_SESSION[$_CONF['sess_name'] . '_myUID'];
$result = get_students_for_teacher($tid, 'B');
// get active && inactive
$values = array("first_name", "last_name");
$key = "user_id";
$los = make_array_from_mysql($result, $key, $values, " ");
$sid = -1;
if (isset($_SESSION[$_CONF['sess_name'] . '_selected_student'])) {
$sid = $_SESSION[$_CONF['sess_name'] . '_selected_student'];
if (!array_key_exists($sid, $los)) {
$sid = -1;
}
}
$t = "Multi-Class Progress Reports";
$b = "";
$b .= "<center><FORM action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST name=students>" . make_selection_list($los, $sid, 'student_id', 'students', 'Student', 'on') . "\n\t\t\t</form></center>";
$main .= make_box($t, $b);
if ($sid != -1) {
$classes = get_classes_for_student($sid, $tid);
$cid = make_assoc_array_from_sql($classes, "class_id", "my");
//include('multiClassProgress_report.php');
include 'classSummary.php';
$report = $b;
//.$print_button;
$main .= make_box($t, $report);
}
} else {
$main .= login_error();
}
<?php
define('FPDF_FONTPATH', 'fpdf_fonts/');
require 'fpdf.php';
include '_includeSessionConfig.php';
$loginError = check_auth($_SESSION[$_CONF['sess_name'] . '_username'], $_SESSION[$_CONF['sess_name'] . '_password']);
if (!$loginError['error_value']) {
$cid = $_SESSION[$_CONF['sess_name'] . '_selected_course'];
$tid = $_SESSION[$_CONF['sess_name'] . '_myUID'];
$yid = $_SESSION[$_CONF['sess_name'] . '_current_school_year'];
$sid = $_SESSION[$_CONF['sess_name'] . '_myCenter'];
$terms = get_terms($yid, $sid);
$termsArray = make_assoc_array_from_sql($terms, 'term_id', 'my');
if ($cid != -1) {
$result = get_students_for_course($cid);
$students = make_array_from_mysql($result, "user_id", array('first_name', 'last_name'), " ");
/** NOW FOR THE PDF STUFF **/
$lm = 0.5;
/** left marging**/
$tm = 0.5;
/** top margin**/
$ph = 11 - 2 * $tm;
/** page width - margins**/
$pw = 8.5 - 2 * $lm;
/** page height - margins**/
$rh = 0.285;
/** height for attendance row **/
$hh = 0.4;
/** height for header (student and class) **/
$th = 0.2;
/** height for term heading **/
if ($rcv % 2) {
$rowclass = "row_odd";
$rcv++;
} else {
$rowclass = "row_even";
$rcv++;
}
$tbody .= "<tr class=" . $rowclass . "><td class=\"student_name\"><span style=white-space:nowrap>" . $sname . "</span></td>\n";
/** classes_title = $termName-$className **/
$termCount = 0;
$avgSum = 0;
// holds proportional value of term average for final average
$percentSum = 0;
foreach ($classes as $class_id => $class_title) {
$reports = getReportForStudent($sid, $tid, $class_id);
$classInfo = make_assoc_array_from_sql(get_class_info($class_id), "class_id", "my");
$termID = $classInfo[$class_id]['term_id'];
if (!empty($reports)) {
$termCount++;
if ($reports[$sid]['overallCalculatedAverage'] > 0) {
$termWeight = $terms[$termID]['term_weight'];
$avgSum += $reports[$sid]['overallCalculatedAverage'] * ($termWeight / 100);
$percentSum += $termWeight;
}
if ($reports[$sid]['locked']['hasLocked']) {
$tbody .= "<td class=\"cat_info\"><span style=\"color:red\">" . $reports[$sid]['locked']['lockedGrade'] . "</span></td>\n";
} else {
$tbody .= "<td class=\"cat_info\">" . $reports[$sid]['overallCalculatedAverage'] . "</td>\n";
}
}
}
$b .= "\n <center>\n <form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST id=\"attendForm\" name=\"attendForm\">\n <table>\n <tr>\n <td align=right>School:</td>\n <td>" . $schoolSelect . "</td>\n </tr>\n <tr>\n <td align=right>Session:</td>\n <td>\n <input class=\"validate[required] radio\" type=radio name=session id=session value='AM' ";
if ($sess == 'AM') {
$b .= " checked=true";
}
$b .= " />AM\n <input class=\"validate[required] radio\" type=radio name=session id=session value='PM' ";
if ($sess == 'PM') {
$b .= " checked=true";
}
$b .= " />PM\n <input class=\"validate[required] radio\" type=radio name=session id=session value='BOTH' ";
if ($sess == 'BOTH') {
$b .= " checked=true";
}
$b .= " />BOTH\n </td>\n </tr>\n <tr>\n <td colspan=2 align=center>\n <input type=submit name=getRoster id=getRoster value=Get />\n </td>\n </tr>\n </table>\n </form>\n </center>\n ";
if (isset($_POST['getRoster'])) {
$roster = array();
$courses = make_assoc_array_from_sql(get_courses_for_bulkAttend($_SESSION[$_CONF['sess_name'] . '_myCenter'], $sess, $today), 'course_id', 'my,');
foreach ($courses as $cid => $courseInfo) {
$result2 = get_students_for_course($cid);
while ($row2 = $result2->fetch_assoc()) {
if ($sid == $row2['school_id']) {
$roster[$row2['last_name'] . $row2['first_name']] = "<tr><td>" . $row2['first_name'] . " " . $row2['last_name'] . "</td><td>" . $courseInfo['course_name'] . "</td></tr>";
}
}
}
ksort($roster);
$table = "\n <table cellpadding=3 cellspacing=5>\n ";
foreach ($roster as $k => $v) {
$table .= $v;
}
$table .= "</table>";
$b .= "<center>" . $table . "</center>";
}
//displayArray($att);exit;
foreach ($att as $a => $i) {
foreach ($i as $d => $info) {
$minutes += $info['minutes'];
}
}
$b .= "<td> " . (int) ($minutes / 60) . ":" . sprintf("%02d", $minutes % 60) . "</td></tr>";
}
}
$b .= "</table>\n </center>";
$main .= make_box($t, $b);
} elseif (isset($_POST['hoursBySchool'])) {
/** Hours By School **/
$result = get_students_for_district($_POST['school_id']);
$students = make_assoc_array_from_sql($result, "user_id", "my");
$t = "Student WBL Hours Report";
$b = "\n <center>\n <table>\n ";
foreach ($students as $sid => $student) {
$sname = $uname;
$loc = get_student_core_class_list($sid);
foreach ($loc as $cid => $cname) {
$minutes = 0;
$att = array();
if (isset($_POST['year'])) {
//$att = array_merge($att,getSMSStudentAttendance($sid,$cid, $_POST['year'],$_SESSION[$_CONF['sess_name'].'_myCenter']));
$att = array_merge($att, get_student_attendance($sid, $cid, $_POST['year'], $_SESSION[$_CONF['sess_name'] . '_myCenter']));
} else {
//$att = array_merge($att,getSMSStudentAttendance($sid,$cid, $_SESSION[$_CONF['sess_name'].'_current_school_year'],$_SESSION[$_CONF['sess_name'].'_myCenter']));
$att = array_merge($att, get_student_attendance($sid, $cid, $_SESSION[$_CONF['sess_name'] . '_current_school_year'], $_SESSION[$_CONF['sess_name'] . '_myCenter']));
}
$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');
//displayArray($smsTeachers);exit;
//displayArray($smsStudents);exit;
//displayArray($q3aitTeachers);exit;
//displayArray($smsCourses);exit;
//displayArray($q3aitStudents);exit;
//get_school_year_info(6, 1);
//getSMSStudentAttendance(171,6,1);
$msg = '';
// set to blank for courses
$error = false;
$schoolYears = get_school_years_list();
$currentSchoolYear = get_current_school_year();
$schoolYear = $schoolYears[$currentSchoolYear];
$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');
$courses = make_assoc_array_from_sql(get_courses_for_bulkAttend('1', "AM", $today), 'course_id', 'my,');
//displayArray($courses);exit;
foreach ($courses as $cid => $courseInfo) {
$result2 = get_students_for_course($cid);
while ($row2 = $result2->fetch_assoc()) {
if ('25' == $row2['school_id']) {
print $courseInfo['course_name'] . " - " . $row2['first_name'] . " " . $row2['last_name'] . "<br>";
}
}
}
