$sid = -1;
if ($_SESSION[$_CONF['sess_name'] . '_selected_student'] != -1) {
$sid = $_SESSION[$_CONF['sess_name'] . '_selected_student'];
}
$c_by = "none";
if (isset($_POST['check_by'])) {
$c_by = $_POST['check_by'];
}
$fname = $_SESSION[$_CONF['sess_name'] . '_myfName'];
$lname = $_SESSION[$_CONF['sess_name'] . '_mylName'];
$lop = array();
// list of parents
$t = "Options...";
$b = "<table border=0 bgcolor=white cellspacing=1 cellpadding=3>\n\t<tr>\n\t\t<td colspan=2 bgcolor=white>\n\t\t\tI would like to send email to parents of...<br />\n\t\t</td>\n\t</tr>\n\t<tr>\n\t\t<td bgcolor=white>\n\t\t\t<form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=sendmail method=POST>\n\t\t\t<input type=submit class=submit name=submit value=\"All Students\" />\n\t\t\t</form>\n\t\t</td>\n\t\t<td bgcolor=white>\t\t\t\t\t\n\t\t\t<form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST>\n\t\t\t<input type=submit class=submit name=check_by value=\"Single Student\" />\n\t\t\t</form>\n\t\t</td>\n\t</tr>\n\t</table>";
if (isset($_POST['check_by'])) {
$los = get_users_for_center($_SESSION[$_CONF['sess_name'] . '_myCenter'], 'isStudent', 'Y', $users_order_by);
$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;
$_SESSION[$_CONF['sess_name'] . '_selected_student'] = -1;
}
}
$b .= "<FORM action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST name=studentList>\n\t\t\t\t<center>" . make_selection_list($los, $sid, 'student_id', 'studentList', 'Student', 'on') . "Sort users by:\n <select name=users_sortBy onChange=document.forms['studentList'].submit();>\n <option value=\"users.last_name, users.first_name\"";
if ($_SESSION[$_CONF['sess_name'] . '_users_sortBy'] == "users.last_name, users.first_name") {
$b .= " selected";
}
$b .= ">Last Name, First Name</option>\n <option value=\"schools.school_name, users.last_name\"";
if ($_SESSION[$_CONF['sess_name'] . '_users_sortBy'] == "schools.school_name, users.last_name") {
$b .= " selected";
$row = $result->fetch_assoc();
$yid = $row['currentYearId'];
/** get the current term for this year in this center
* Returns an sql result set including
* term_id, term_name, term_weight, term_start_date, term_end_date, term_ord
*/
$sql = "SELECT * from terms\n WHERE terms.term_start_date <= '" . $today . "'\n AND terms.term_end_date >= '" . $today . "'";
$result = $db->query($sql);
$row = $result->fetch_assoc();
$current_term_id = $row['term_id'];
$current_term_name = $row['term_name'];
/** Get Ed Centers **/
$centers = get_edCenters();
foreach ($centers as $center_id => $short_name) {
/** Get Teachers **/
$teachers = get_users_for_center($center_id, 'isTeacher', 'Y', "users.last_name, users.first_name");
foreach ($teachers as $teacher_id => $teacher_name) {
$tinfo = get_teacher_info($teacher_id);
$tuname = $tinfo['u_name'];
/** Get Courses **/
$sql = "\n SELECT courses.course_id, courses.course_name\n FROM courses\n WHERE courses.teacher_id=" . $teacher_id . "\n AND courses.school_year_id=" . $yid . "\n AND courses.ed_center=" . $center_id;
$result = $db->query($sql);
$courses = make_array_from_sql($result, 'course_id', array('course_name'), '');
foreach ($courses as $course_id => $course_name) {
/** Get Classes **/
/** class_id=>term_name course_name **/
$classes = get_teacher_classes_by_course($course_id);
foreach ($classes as $class_id => $class_name) {
list($term, $course) = preg_split("/ - /", $class_name);
if ($term == $current_term_name) {
$save_path = $start_path . $short_name . "/" . $tuname . "/" . $course_name . "/" . $term . "/";
} else {
$_SESSION[$_CONF['sess_name'] . '_selected_school'] = -1;
}
if (isset($_POST['school_id'])) {
$schoolID = $_SESSION[$_CONF['sess_name'] . '_selected_school'] = $_POST['school_id'];
}
$schools = get_schools_for_center($_SESSION[$_CONF['sess_name'] . "_myCenter"]);
$schoolList = make_array_from_mysql($schools, 'school_id', array('school_name'), "");
$schoolSelect = make_selection_list($schoolList, $schoolID, 'school_id', 'hoursBySchoolForm', 'School', 'off');
$schoolYears = get_school_years_list();
$currentYear = $schoolYears[$_SESSION[$_CONF['sess_name'] . "_current_school_year"]];
/** Attendance by class **/
$t = "Hours By Class";
$b = "\n\t\t<center>\n\t\t<form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=\"post\" name=teachers>";
$teachers = array();
$teachers = get_users_for_center($_SESSION[$_CONF['sess_name'] . '_myCenter'], 'isTeacher', 'Y');
$b .= make_selection_list($teachers, $tid, "teacher_id", "teachers", "Teacher", "on");
$b .= "</form></center>";
/** end of teacher list form **/
$cid = -1;
if (isset($_SESSION[$_CONF['sess_name'] . '_selected_course']) && $_SESSION[$_CONF['sess_name'] . '_selected_course'] != -1) {
$cid = $_SESSION[$_CONF['sess_name'] . '_selected_course'];
}
if (isset($_SESSION[$_CONF['sess_name'] . '_selected_teacher'])) {
$core_classes = get_teacher_course_list($tid, $_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;
}
<?php
/**
* This utility will get all current users in Q3AIT and look them up in SMS
* and find their STGUID to be added to Q3AIT.
*/
$found = array();
// array for my users found in SMS
$missing = array();
// array for my users no in SMS
/**
* get current active students store in array id=>first last
*/
$myUsers = get_users_for_center(1, 'isStudent', 'Y', 'users.last_name, users.first_name');
foreach ($myUsers as $id => $user) {
list($name, $s) = preg_split("/ {/", $user);
//print $name." {".$id."}<br />";
$info = getSMSStudentInfo($name);
if ($info['student']['name'] == '') {
$missing[$id] = $name;
} else {
$found[$id] = $info;
}
}
$b = "";
foreach ($found as $id => $studINFO) {
$STGUID = $studINFO['student']['STGUID'];
$sql = "UPDATE users set STGUID=UPPER('" . $STGUID . "') WHERE user_id=" . $id;
$result = $db->query($sql);
$b .= $sql . "<br />";
}
<?php $new_account_title = " New Parent Account"; $user_list_title = "Parent Accounts"; $where_clause = "isParent"; $selectWhat = "Parent"; $userMode = "parent"; // used to select fields for input $usr_lev = 2; $ActiveUsers = get_users_for_center($_SESSION[$_CONF['sess_name'] . '_myCenter'], $where_clause, 'Y'); $InactiveUsers = get_users_for_center($_SESSION[$_CONF['sess_name'] . '_myCenter'], $where_clause, 'N'); include 'admin_anyuser.php';
*
*/
//$main .= make_box($tt,$bt,"yellow");
}
if ($classID != -1 || isset($_POST['update_s2c'])) {
$t = "Class Roster";
$b = "<font color=red><center>If you remove a student here and he/she has grades in the database for this class, the grades are removed also.</center></font>";
$b .= "\n\t\t<br />\n\t\t<center>\n\t\t<TABLE width=350 border=0 cellspacing=0 cellpadding=2 bgcolor=white>\n\t\t<tr><th colspan=2>Schedule Students</th></tr>";
// get class name, term_name...
$sql = "SELECT course_name, term_name\n\t\t\t\tFROM classes, terms, courses\n\t\t\t\tWHERE class_id=" . $classID . "\n\t\t\t\t\tAND courses.course_id=classes.course_id\n\t\t\t\t\tAND terms.term_id=classes.term_id";
$result = $db->query($sql);
$row = $result->fetch_assoc();
$className = $row['course_name'] . " : " . $row['term_name'];
$b .= $hiddenTerm . "\n\t\t<tr><th colspan=2>Scheduling Class : " . $className . "</th></tr>";
/** display the list of students... **/
$students = get_users_for_center($_SESSION[$_CONF['sess_name'] . '_myCenter'], 'isStudent', 'Y', "users.last_name, users.first_name");
$studentList = make_selection_list($students, -1, 'student_id', 'studentList', 'Student', "off");
/** need to get students that ONLY go to my school **/
$b .= "\n\t\t<tr>\n\t\t\t<td bgcolor=white align=center>\n\t\t\t\t<form action=\"\" id=studentListForm name=studentListForm method=post>" . $studentList . "\n\t\t\t</td>\n\t\t\t<td>\n\t\t\t\t<input id=addToRoster type=submit class=submit name=addToRoster value=Add />\n\t\t\t\t<input type=hidden name=class_id id=class_id value=" . $classID . " />\n\t\t\t\t</form>\n\t\t\t</td>\n\t\t</tr>\n\t\t<tr>\n\t\t\t<td colspan=2 bgcolor=white align=center>\n\t\t\t\t<form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " name=studentList method=post>\n\t\t\t\t<input id=copyFrom type=submit class=submit name=copy_from value=\"Copy From Another Class\" />\n\t\t\t\t</form>\n\t\t\t</td>\n\t\t</tr>\n\t\t</form>\n\t\t</table>";
/**
now for the new way of adding/removing students. Use a selection list with "Add" button
Then use checkboxes next to names and a remove button. Keep the copy from
**/
$registered = get_students_for_class($classID);
$b .= "\n\t\t<div id=enrolledStudentsDiv><h2>Current Enrollment</h2>\n\t\t<form id=enrolledStudentsForm name=enrolledStudentsForm action=\"\" method=post>\n\t\t<table id=\"enrollmentTable\" background=white cellspacing=1 cellpadding=3>\n\t\t<thead><tr><th colspan=2></th></tr></thead>\n\t\t<tbody id=\"enrollmentTableBody\">";
foreach ($registered as $id => $name) {
$b .= "\n\t\t\t<tr><td><input type=checkbox id=s_" . $id . " name=s_" . $id . " class=studentCheckbox></td><td>" . $name . "</td></tr>";
}
$b .= "\n\t\t</tbody>\n\t\t<tfoot>\n\t\t<tr>\n\t\t\t<td colspan=2>\n\t\t\t\t<input type=submit id=removeFromRoster name=removeFromRoster value=Remove />\n\t\t\t\t<input type=hidden name=class_id id=class_id value=" . $classID . " />\n\t\t\t</td>\n\t\t</tr>\n\t\t</tfoot>\n\t\t</table>\n\t\t</form>\n\t\t</div>\n\t\t";
$b .= "\n\t\t</center>";
$main .= make_box($t, $b);
$selected_teacher = $_POST['teacher_id'];
}
if (isset($_POST['class_id'])) {
$selected_course = $_POST['class_id'];
}
if (isset($_POST['term_id'])) {
$selected_term = $_POST['term_id'];
}
if (isset($_POST['file_id'])) {
$selected_file = $_POST['file_id'];
}
$t = "Teacher Gradebook Restore";
$b = "\n\t<div style=\"color:red; font-size:12px;\">\n\tThis routine will allow you to restore a single class' gradebook. That means it will restore the roster and the grades back to the date you select. Keep in mind that the file name is the date. Your gradebooks are backed up at midnight on the date you select.<br><br>THIS WILL REMOVE ALL CURRENT DATA!!!\n\t</div>\n\t<form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=post name=restoreForm id=restoreForm>";
/** Get Teachers for center array{id=>name} **/
if ($_SESSION[$_CONF['sess_name'] . "_isAdmin"]) {
$teachers = get_users_for_center($_SESSION[$_CONF['sess_name'] . '_myCenter'], 'isTeacher', 'Y', "users.last_name, users.first_name");
} else {
$teachers[$_SESSION[$_CONF['sess_name'] . "_myUID"]] = $_SESSION[$_CONF['sess_name'] . "_myName"];
}
asort($teachers);
$teacher_select = make_selection_list($teachers, $selected_teacher, "teacher_id", "restoreForm", "teacher", "on");
$b .= "Teacher : " . $teacher_select . "<br />";
if (isset($_POST['teacher_id'])) {
$row = get_teacher_info($selected_teacher);
$uname = $row['u_name'];
$courses = get_teacher_course_list($selected_teacher);
asort($courses);
$course_select = make_selection_list($courses, $selected_course, "class_id", "restoreForm", "class", "on");
$b .= "Course : " . $course_select . "<br />";
if (isset($_POST['class_id'])) {
// read the list of available terms for this teacher for this class from file system
$sql2 = "SELECT student_id from parent2student where parent_id=" . $_POST['parentid'];
$result2 = $db->query($sql2);
$stud_array = array();
while ($row2 = $result2->fetch_assoc()) {
array_push($stud_array, $row2['student_id']);
}
$t = "Parent -> Students";
$b .= "\n\t\t\t<br />\n\t\t\t<center>\n\t\t\t<TABLE width=350 border=0 cellspacing=0 cellpadding=2 bgcolor=white>\n\t\t\t<TR><TH colspan=2>Parent to Student Link</TH></TR>";
// get parents name...
$sql = "SELECT first_name, last_name from users where user_id=" . $_POST['parentid'];
$result = $db->query($sql);
$row = $result->fetch_assoc();
$b .= "\n <TR><TH colspan=2>Linking to Parent : " . $row['first_name'] . " " . $row['last_name'] . "</TH></TR>\n </table>";
/**
now for the new way of adding/removing students. Use a selection list with "Add" button
Then use checkboxes next to names and a remove button. Keep the copy from
**/
$paired = get_students_for_parent($_POST['parentid']);
$list = get_users_for_center($_SESSION[$_CONF['sess_name'] . '_adminCenterID'], 'isStudent', 'Y', 'users.last_name, users.first_name');
$studentList = make_selection_list($list, $selected, 'student_id', 'studentSelectList', 'Student', 'off');
$b .= "\n <div id=pairedStudentsDiv><h2>Current List</h2>\n <table id=\"pairedTable\" background=white cellspacing=1 cellpadding=3>\n <thead>\n <tr>\n <th colspan=2>\n <form id=studentSelectList name=studentSelectList action\"\" method=post>" . $studentList . "<input type=submit name=pairStudent id=pairStudent value=Add />\n <input type=hidden name=parentid id=parentid value=" . $_POST['parentid'] . " />\n </form>\n </th>\n </tr>\n </thead>\n <tbody id=\"pairedTableBody\">\n <form id=studentListForm name=studentListForm action=\"\" method=post>";
foreach ($paired as $id => $name) {
$b .= "\n <tr><td><input type=checkbox id=s_" . $id . " name=s_" . $id . " class=studentCheckbox></td><td>" . $name . "</td></tr>";
}
$b .= "\n </tbody>\n <tfoot>\n <tr>\n <td colspan=2>\n <input type=submit id=unPairStudent name=unPairStudent value=Remove />\n <input type=hidden name=parentid id=parentid value=" . $_POST['parentid'] . " />\n </td>\n </tr>\n </tfoot>\n </table>\n </form>\n </div>\n ";
$b .= "\n </center>";
}
$main .= make_box($t, $b);
} else {
$main .= login_error();
}
if ($_SESSION[$_CONF['sess_name'] . '_isOffice']) {
$centerID = $_SESSION[$_CONF['sess_name'] . '_myCenter'];
$yearID = $_SESSION[$_CONF['sess_name'] . '_current_school_year'];
/** get Commnets info **/
$centers = $_SESSION[$_CONF['sess_name'] . '_myCenters'];
$myCenter = $centers[$_SESSION[$_CONF['sess_name'] . '_myCenter']];
$smsBuildingID = $myCenter['smsBuildingID'];
$commentsResult = getSMSinterimComments($smsBuildingID);
$comments = makeSMSCommentsArray($commentsResult);
$Quality = $comments['Quality'];
$Improvement = $comments['Improvement'];
/** term_id, term_name, term_weight, term_start_date, term_end_date, term_ord, interimsDueDate, gradesDueDate, smsName **/
$terms = get_terms($yearID, $centerID);
$termsList = make_array_from_mysql($terms, 'term_id', array('term_name'), " ");
$studentList = get_users_for_center($centerID, 'isStudent', 'Y');
$sid = $cid = -1;
if (isset($_SESSION[$_CONF['sess_name'] . '_selected_student'])) {
$sid = $_SESSION[$_CONF['sess_name'] . '_selected_student'];
if (!array_key_exists($sid, $studentList)) {
$sid = -1;
$_SESSION[$_CONF['sess_name'] . '_selected_student'] = -1;
}
}
$termID = -1;
if (isset($_POST['term_id'])) {
$_SESSION[$_CONF['sess_name'] . '_selected_term'] = $_POST['term_id'];
}
if (isset($_SESSION[$_CONF['sess_name'] . '_selected_term'])) {
$termID = $_SESSION[$_CONF['sess_name'] . '_selected_term'];
}
