$b .= "\n <center><table border=0 cellspacing=0 cellpadding=3>";
$b .= "\n <th>\n <form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST name=searchByTeacher>";
$b .= make_selection_list($lot, $tid, "teacher_id", "searchByTeacher", "Teacher", "on");
$b .= " \n <input type=hidden name=searchByTeacher />\n </form>\n </th>\n </tr>";
$b .= "\n </table></center>";
$main .= make_box($t, $b . $teacherReferrals);
/** Search by Student **/
$t = "Search By Student";
$b = "";
$sid = -1;
if (isset($_POST['student_id'])) {
$sid = $_POST['student_id'];
}
$b .= "\n <center><table border=0 cellspacing=0 cellpadding=3>";
$b .= "\n <th>\n <form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST name=searchByStudent>";
$b .= make_selection_list($los, $sid, "student_id", "searchByStudent", "Student", "on");
$b .= " \n <input type=hidden name=searchByStudent />\n </form>\n </th>\n </tr>";
$b .= "\n </table></center>";
$main .= make_box($t, $b . $studentReferrals);
/** display a list of OPEN referrals **/
$result = get_referrals('', 'N');
$t = "OPEN Referrals";
$b = display_referrals($result, $_SERVER['PHP_SELF'] . "?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'], 'N', 'N');
$main .= make_box($t, $b);
/** display a list of CLOSED referrals **/
$result = get_referrals('', 'Y');
$t = "CLOSED Referrals";
$b = display_referrals($result, $_SERVER['PHP_SELF'] . "?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'], 'Y', 'N');
$main .= make_box($t, $b);
} else {
$main .= login_error();
$courseName = "";
$courses = get_teacher_course_list($_SESSION[$_CONF['sess_name'] . '_myUID'], $_SESSION[$_CONF['sess_name'] . '_current_school_year'], $_SESSION[$_CONF['sess_name'] . '_myCenter']);
if (isset($_SESSION[$_CONF['sess_name'] . '_selected_course'])) {
$cid = $_SESSION[$_CONF['sess_name'] . '_selected_course'];
if (array_key_exists($cid, $courses)) {
$result = get_course_info($cid);
$row = $result->fetch_assoc();
$courseName = $row['course_name'];
$teacherName = $row['first_name'] . " " . $row['last_name'];
$tid = $_SESSION[$_CONF['sess_name'] . '_myUID'];
} else {
$cid = -1;
}
}
$t = "Yearly Class Summary";
$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(get_teacher_course_list($_SESSION[$_CONF['sess_name'] . '_myUID'], $_SESSION[$_CONF['sess_name'] . '_current_school_year'], $_SESSION[$_CONF['sess_name'] . '_myCenter']), $cid, 'course_id', "courses", "Course", 'on') . "</center></form><br />";
if ($cid != -1) {
// classes = array(classID=>Term # - Course Name)
$classes = get_teacher_classes_by_course($cid);
/** Get the student list for the class **/
$result = get_students_for_course($cid);
$students = make_array_from_mysql($result, "user_id", array('first_name', 'last_name'), " ");
$terms = $_SESSION[$_CONF['sess_name'] . '_terms'];
// Array(termID=>termInfo)
$numTerms = count($terms);
/** foreach student process the multi-class report**/
$out = "\n <center>You have selected course " . $cid . "<br>\n <span style=color:red>NOTE: Red grades mean they are locked bt the teacher to that value rather than the calculated grade.</span>\n <table>";
$theader = "<tr><td class=\"term_title\">Student</td>\n";
foreach ($terms as $termID => $termInfo) {
$theader .= "<td class=\"term_title\">" . $termInfo['term_name'] . "<br>" . $termInfo['term_weight'] . "%</td>";
}
$b .= make_multi_select_list($los, "los");
$b .= "\n\t\t\t\t<input type=hidden name=send />\n\t\t\t\t<input type=hidden name=fid value=" . $_POST['fid'] . " />\n\t\t\t\t<input type=submit name=deliver value=Send />\n\t\t\t\t</form></center>";
$main .= make_box($t, $b);
} else {
$t = "Send File";
$b = "<center><form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=\"post\" name=\"dropBox_Send\" >";
/** Get a list of files in MY save dir to select from **/
$sql = "SELECT * from dropbox \n\t\t\t\tWHERE file_owner=" . $myID . " AND file_recipient=" . $myID;
if ($result = $db->query($sql)) {
$lof = array();
while ($row = $result->fetch_assoc()) {
$lof[$row['id']] = $row['file_name'];
}
/** make_selection_list($list,$selected=-1,$select_name,$form, $what, $change="off")**/
$b .= "Select a file :";
$b .= make_selection_list($lof, -1, "fid", "dropBox_Send", "file", "on");
}
$b .= "<input type=hidden name=send />\n";
$b .= "<input type=hidden name=select_students />\n";
$b .= "</form></center>";
$main .= make_box($t, $b);
}
} elseif (isset($_REQUEST['confirm']) && $_REQUEST['confirm'] == "REMOVE") {
$t = "Removing File...";
$c = "yellow";
/** get file info to see who owns file **/
$sql = "SELECT * from dropbox where id=" . $_POST['db_id'];
$result = $db->query($sql);
$row = $result->fetch_assoc();
$name = $row['file_name'];
/** if I OWN FILE **/
$bc = "blue";
$t = "Parent Homework Site";
$b = "<FORM action=" . $_SERVER['PHP_SELF'] . "?lev=" . $_GET['lev'] . "&cat=" . $_GET['cat'] . " method=POST name=studentHomework>";
if (isset($_REQUEST['student'])) {
$sid = $_REQUEST['student'];
} else {
$sid = -1;
}
if (isset($_REQUEST['class_id'])) {
$cid = $_REQUEST['class_id'];
} else {
$cid = -1;
}
$b .= "<center>" . get_students_for_parent($pid, 'student', "studentHomework", $_REQUEST['student']) . "</center>";
if ($_POST['student'] && check_parent2student($pid, $sid)) {
$b .= "<center>" . make_selection_list(student_class_list($sid), $cid, 'class_id', 'studentHomework', 'Class', 'on') . "</center>";
if ($_REQUEST['class_id']) {
if (isset($_REQUEST['view'])) {
// retrieve and display the assignment
$sql = "SELECT assignment,date from homework where homework_id=" . $_REQUEST['assignment_num'];
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);
list($y, $m, $d) = split("-", $row['date']);
$b .= "<hr width=80%>";
$b .= "HW for <b>" . date("l, F j, Y", mktime(0, 0, 0, $m, $d, $y)) . "</b>";
$b .= "<table border=0 cellspacing=1 cellpadding=3 width=70%>";
$b .= "<tr><td>";
$b .= nl2br($row['assignment']);
$b .= "</td></tr>";
$b .= "</table>";
} else {
<?php
/** TEACHER CAN BEGIN EDITING FROM HERE, ALL OTHERS ONLY VIEW **/
$teacher_display .= "\n <tr bgcolor=\"#FFFFFF\">\n <td>\n <table width=\"100%\" border=\"0\" cellspacing=0 cellpadding=0 bgcolor=\"#FFFFFF\">\n <tr>\n <td align=\"left\" valign=top>\n <span style=\"font-size:14px;font-weight:bold\">Teacher:</span> " . $tfName . " " . $tlName . "<br />\n <span style=\"font-size:14px;font-weight:bold\">Student:</span> " . $sfName . " " . $slName . "<br />\n <span style=\"font-size:14px;font-weight:bold\">District:</span> " . $sDistrict . "<br />\n </td>\n <td align=\"left\" valign=top>\n <span style=\"font-size:14px;font-weight:bold\">Course: " . $course . "</span><br />\n <span style=\"font-size:14px;font-weight:bold\">Date: {$referral_date}</span><br />\n <span style=\"font-size:14px;font-weight:bold\">Time: {$referral_time}</span><br />\n </td>\n \n </tr>\n <tr>\n <td colspan=2><div class=\"displayTextHeading\">Description:</div>\n <div class=\"displayTextArea\" style=\"height:20px;\">" . $teach_refer_desc . "</div>\n </td>\n </tr>\n </table>\n </td>\n </tr>\n <tr bgcolor=\"#FFFFFF\">\n <td><div class=\"displayTextHeading\">Nature of Incident:</div>\n <div class=\"displayTextArea\">" . $teach_incident_notes . "</div></td>\n </tr>\n <tr bgcolor=\"#FFFFFF\">\n <td>\n <table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" bgcolor=\"#FFFFFF\">\n <tr>\n <td colspan=\"2\" class=\"blue-title\"><div class=\"displayTextHeading\">Action Taken By Teacher Preceding Referral:</div></td>\n </tr>\n <tr>\n <td><div class=\"displayTextHeading\">Warning Issued/Verbal:</div></td>\n <td><div>" . $teach_refer_warn_date . "</div></td>\n </tr>\n <tr>\n <td><div class=\"displayTextHeading\">Conference With Student:</div></td>\n <td><div>" . $teach_refer_conf_date . "</div></td>\n </tr>\n <tr>\n <td><div class=\"displayTextHeading\">Phone Call to Parent:</div></td>\n <td><div>" . $teach_refer_phone_date . "</div></td>\n </tr>\n <tr>\n <td colspan=\"2\"><div class=\"displayTextHeading\">Comments:</div>\n <div class=\"displayTextArea\">" . $teach_action_notes . "</div></td>\n </tr>\n <tr>\n <td><div class=\"displayTextHeading\">Refferred For Administrative Action:</div></td>\n <td><div>" . $teach_refer_action_date . "</div></td>\n </tr>\n</table>\n </td>\n </tr>";
/** Teacher Form Elements **/
$teacher_form .= "\n <tr bgcolor=\"#FFFFFF\">\n <td>\n <table width=\"100%\" border=\"0\" cellspacing=0 cellpadding=0 bgcolor=\"#FFFFFF\">\n <tr>\n <td align=\"left\" valign=top>\n <span style=\"font-size:14px;font-weight:bold\">Teacher:</span> " . $tfName . " " . $tlName . "<br />\n <span style=\"font-size:14px;font-weight:bold\">Student:</span> " . $sfName . " " . $slName . "<br />\n <span style=\"font-size:14px;font-weight:bold\">District:</span> " . $sDistrict . "<br />\n </td>\n <td align=\"left\" valign=top>\n <span style=\"font-size:14px;font-weight:bold\">Course: </span>\n " . make_selection_list(get_student_core_class_list($sid), $cid, 'course_id', 'courses', 'Course', 'off') . "<br />";
$date = make_LOM('referral_month', $referral_month, '1', '12') . " " . make_LOD('referral_day', $referral_day) . " " . make_LOY('referral_year', $referral_year, $referral_year - 1, $referral_year);
$teacher_form .= "<span style=\"font-size:14px;font-weight:bold\">Date: </span> " . $date . "<br />\n <span style=\"font-size:14px;font-weight:bold\">Time: </span><input type=text size=25 name=referral_time style=\"background-color:#FFFACD\" value='" . $referral_time . "'/><br />\n </td>\n </tr>\n <tr>\n <td colspan=2>\n <span style=\"font-size:12px;font-weight:bold\">Description (100 chars max):<br /></span>\n <input name=\"teach_refer_desc\" style=\"background-color:#FFFACD\" type=text size=100 value=\"" . $teach_refer_desc . "\" />\n </td>\n </tr>\n </table>\n </td>\n </tr>\n <tr bgcolor=\"#FFFFFF\">\n <td class=\"blue-title\">Nature of Incident<br />\n <textarea name=\"teach_incident_notes\" cols=\"90\" rows=\"5\" value=\"" . $teach_incident_notes . "\">" . $teach_incident_notes . "</textarea></td>\n </tr>\n <tr bgcolor=\"#FFFFFF\">\n <td>\n <table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" bgcolor=\"#FFFFFF\">\n <tr>\n <td colspan=\"2\" class=\"blue-title\">Action Taken By Teacher Preceding Referral:</td>\n </tr>\n <tr>\n <td><input name=\"teach_refer_warn\" type=\"checkbox\" onClick=\"showHide('teach_refer_warn_date');\"";
$visible = "hidden";
if ($teach_refer_warn == 'on') {
$teacher_form .= " checked";
$visible = "visible";
}
$teacher_form .= " /> Warning Issued/Verbal on " . $teach_refer_warn_year . "-" . $teach_refer_warn_month . "-" . $teach_refer_warn_day . "</td>\n <td>";
$date = make_LOM('teach_refer_warn_month', $teach_refer_warn_month, '1', '12') . " " . make_LOD('teach_refer_warn_day', $teach_refer_warn_day) . " " . make_LOY('teach_refer_warn_year', $teach_refer_warn_year, $teach_refer_warn_year - 1, $teach_refer_warn_year);
$teacher_form .= "\n <div id=\"teach_refer_warn_date\" style=\"visibility:" . $visible . "\">" . $date . "</div>\n </td>\n </tr>\n <tr>\n <td><input name=\"teach_refer_conf\" type=\"checkbox\" onClick=\"showHide('teach_refer_conf_date');\"";
$visible = "hidden";
if ($teach_refer_conf == 'on') {
$teacher_form .= " checked";
$visible = "visible";
}
$teacher_form .= " /> Conference With Student</td>\n <td>";
$date = make_LOM('teach_refer_conf_month', $teach_refer_conf_month, '1', '12') . " " . make_LOD('teach_refer_conf_day', $teach_refer_conf_day) . " " . make_LOY('teach_refer_conf_year', $teach_refer_conf_year, $teach_refer_conf_year - 1, $teach_refer_conf_year);
$teacher_form .= "<div id=\"teach_refer_conf_date\" style=\"visibility:" . $visible . "\">" . $date . "</div>\n </td>\n </tr>\n <tr>\n <td><input name=\"teach_refer_phone\" type=\"checkbox\" onClick=\"showHide('teach_refer_phone_date');\"";
$visible = "hidden";
if ($teach_refer_phone == 'on') {
$teacher_form .= " checked";
$visible = "visible";
}
$teacher_form .= " /> Phone Call to Parent</td>\n <td>";
$date = make_LOM('teach_refer_phone_month', $teach_refer_phone_month, '1', '12') . " " . make_LOD('teach_refer_phone_day', $teach_refer_phone_day) . " " . make_LOY('teach_refer_phone_year', $teach_refer_phone_year, $teach_refer_phone_year - 1, $teach_refer_phone_year);
if ($sid != -1) {
$header .= "\n \$('#a_date').datepick({\n dateFormat: 'yyyy-mm-dd',\n maxDate: new Date(" . $ey . ", " . ($em - 1) . ", " . $ed . "),\n minDate: new Date(" . $sy . ", " . ($sm - 1) . ", " . $sd . "),\n monthsToShow: 3,monthsToStep: 3, monthsOffset: 1,\n multiSelect:25,\n onDate: \$.datepick.noWeekends,\n showTrigger: '#callImg'\n });";
}
$header .= "\n });\n </script>";
$b .= "\n <center>\n <form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST name=\"attendByStudent\" id=\"attendByStudent\">\n <table border=0>\n <tr>\n <td colspan=3>" . make_selection_list($students, $sid, 'student_id', 'attendByStudent', 'Student', 'on') . "Sort users by:\n <select name=users_sortBy onChange=\"document.forms['attendByStudent'].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";
}
$b .= ">School Name, last Name, First Name</option>\n </select>\n </td>\n </tr>";
if ($sid != -1) {
$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 * */
<?php
if ($_SESSION[$_CONF['sess_name'] . '_isParent']) {
$pid = $_SESSION[$_CONF['sess_name'] . '_myUID'];
$bc = "blue";
// default box color
$print_button = "";
$t = "Student List";
$los = get_students_for_parent($pid);
$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;
}
}
$b = "<FORM action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST name=students>";
$b .= "<center>" . make_selection_list($los, $sid, 'student_id', 'students', 'Student', 'on') . "</center></form>";
$b .= "<br /></form>";
$body = "<center>" . $b . "</center>";
$main .= make_box($t, $body, $bc);
if ($sid != -1) {
include 'multiClassProgress_report.php';
$report = $b;
//.$print_button;
$main .= make_box($t, $report);
}
} else {
$main .= login_error();
}
}
$order_by = $_SESSION[$_CONF['sess_name'] . '_progress_sortBy'];
$t = "Student List";
$b = "<center>\n\t\t\t<FORM action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST name=studentList>" . 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";
}
$b .= ">School Name, last Name, First Name</option>\n </select>\n </FORM>";
if ($sid != -1) {
//make_selection_list($classes,$class_id,$select_name,$form,"Class","on")
$b .= "<FORM action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST name=studentClasses>";
$b .= "<center>" . make_selection_list($loc, $cid, 'class_id', 'studentClasses', 'Class', 'on') . "\n <br />\n Sort Assignments by : \n <select name=progress_sortBy onChange=document.forms['studentClasses'].submit();>\n <option value=\"assignments.due_date desc\"";
if ($_SESSION[$_CONF['sess_name'] . '_progress_sortBy'] == "assignments.due_date desc") {
$b .= " selected";
}
$b .= ">Date (descending)</option>\n <option value=\"assignments.due_date asc\"";
if ($_SESSION[$_CONF['sess_name'] . '_progress_sortBy'] == "assignments.due_date asc") {
$b .= " selected";
}
$b .= ">Date (ascending)</option>\n <option value=category.category_name";
if ($_SESSION[$_CONF['sess_name'] . '_progress_sortBy'] == "category.category_name") {
$b .= " selected";
}
$b .= ">Category Name</option>\n </select> \n </center>\n </form>";
}
$main .= make_box($t, $b);
$print_button = "\t\n <CENTER>\n <FORM action=printview_progressreport.php method=POST target=new name=printview>\n <input type=submit class=submit name=submit value=\"Print PDF\" />\n </form>\n <FORM action=printview_progressreport.php method=POST target=new name=printview>\n <input type=submit class=submit name=submit value=\"Print All Students for this Class\" />\n <input type=hidden name=all value=all />\n </form>\n </CENTER>";
}
/** the following is used for sorting the grades on this page only... **/
if (!isset($_SESSION[$_CONF['sess_name'] . '_progress_sortBy'])) {
//session_register($_CONF['sess_name'].'_progress_sortBy');
$_SESSION[$_CONF['sess_name'] . '_progress_sortBy'] = "assignments.due_date asc";
}
if (isset($_POST['progress_sortBy'])) {
$_SESSION[$_CONF['sess_name'] . '_progress_sortBy'] = $_POST['progress_sortBy'];
}
$order_by = $_SESSION[$_CONF['sess_name'] . '_progress_sortBy'];
$print_button = "\t\n\t\t\t<CENTER>\n\t\t\t<FORM action=printview_progressreport.php method=POST target=new name=printview>\n\t\t\tPrint/View <input type=submit class=submit name=submit value=\"Current\" /> Student Report.\n\t\t\t</form>\n <FORM action=printview_progressreport.php method=POST target=new name=printview>\n Download <input type=submit class=submit name=all value=\"All\" /> Current Class Reports (Sinlge File).\n <input type=hidden name=all value=all />\n </form>\n </CENTER>";
$t = "Student Progress Reports";
/** Function get_teacher_class_list($teacher_id,$class_id=-1,$select_name='class_id',$form, $change="on") **/
$b = "<center><FORM action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST id=classes naame=classes>\n\t\t\t<center>" . get_teacher_class_list($_SESSION[$_CONF['sess_name'] . '_myUID'], $cid, 'class_id', 'classes', 'on') . "\n </form><br />";
if ($cid != -1) {
$b .= "<FORM action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST name=students>\n\t\t<center>" . make_selection_list($los, $sid, 'student_id', 'students', 'Student', 'on') . "<br>\n\t\t\tSort Assignments by : \n <select name=progress_sortBy onChange=document.forms['students'].submit();>\n <option value=\"assignments.due_date desc\"";
if ($_SESSION[$_CONF['sess_name'] . '_progress_sortBy'] == "assignments.due_date desc") {
$b .= " selected";
}
$b .= ">Date (descending)</option>\n <option value=\"assignments.due_date asc\"";
if ($_SESSION[$_CONF['sess_name'] . '_progress_sortBy'] == "assignments.due_date asc") {
$b .= " selected";
}
$b .= ">Date (ascending)</option>\n <option value=categories.category_name";
if ($_SESSION[$_CONF['sess_name'] . '_progress_sortBy'] == "categories.category_name") {
$b .= " selected";
}
$b .= ">Category Name</option>\n </select> \n </form>\n </center>";
}
$main .= make_box($t, $b);
if ($sid != -1) {
$result = get_students_for_teacher($tid);
$values = array("first_name", "last_name");
$key = "user_id";
$los = make_array_from_mysql($result, $key, $values, " ");
$cid = -1;
$sid = -1;
if (isset($_POST['student_id'])) {
$sid = $_POST['student_id'];
}
$b = "";
$t = "Incident Referral";
if (isset($_POST['new_referral'])) {
$t = "New Referral";
$b = "";
if ($sid == -1) {
$b .= "<center>\n <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 <input type=hidden name=\"new_referral\" value=\"New\" />\n </form></center>";
} else {
$sql = "SELECT users.first_name, users.last_name, schools.school_name\n FROM users, schools\n WHERE schools.school_id=users.school_id\n AND users.user_id=" . $sid;
$result = $db->query($sql);
$row = $result->fetch_assoc();
$sfName = $row['first_name'];
$slName = $row['last_name'];
$sDistrict = $row['school_name'];
include 'referral_form.php';
$b .= $form;
}
$main .= make_box($t, $b);
} elseif (isset($_POST['incident_referral_id']) || isset($_POST['send_referral'])) {
include 'referral_form.php';
$b .= $form;
$main .= make_box($t, $b);
$termName = $row['term_name'];
$teacherName = $row['first_name'] . " " . $row['last_name'];
}
if ($tid != -1) {
$custom_scores = array();
$custom_scores = get_custom_scores($tid, $_SESSION[$_CONF['sess_name'] . '_current_school_year']);
$classList = get_teacher_class_list($tid, $cid, 'class_id', "classes");
}
if (isset($_POST['teacher_id'])) {
$tid = $_SESSION[$_CONF['sess_name'] . '_selected_teacher'] = $_POST['teacher_id'];
$cid = $_SESSION[$_CONF['sess_name'] . '_selected_class'] = -1;
$classList = get_teacher_class_list($tid, $cid, 'class_id', "classes");
}
$t = "Class Score Summary";
$b = "<FORM action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST name=teachers>";
$b .= "<center>" . make_selection_list($teacherList, $tid, 'teacher_id', 'teachers', 'Teacher', 'on') . "</center>";
$b .= "</form>";
if ($tid > -1) {
$b .= "<FORM action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST name=classes>";
$b .= "<center>" . $classList . "</center>";
$b .= "</form>";
}
if ($cid > -1) {
include 'classSummary.php';
$b .= $summary_table . "<br />" . $print_button;
}
// end if isset class_id
$main .= make_box($t, $b);
} else {
$main .= login_error();
}
<?php
$curdatetime = date("F j, Y @ g:i a", time() - 18000);
if ($_SESSION[$_CONF['sess_name'] . '_isTeacher']) {
//$main .= "lev=".$lev."&cat=".$cat;
$tid = $_SESSION[$_CONF['sess_name'] . '_myUID'];
$yid = $_SESSION[$_CONF['sess_name'] . '_current_school_year'];
/** Display the list of classes **/
$t = "Class Selection";
$b = "<form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=\"post\" name=courses>\n";
$sid = -1;
if (isset($_SESSION[$_CONF['sess_name'] . '_selected_student'])) {
$sid = $_SESSION[$_CONF['sess_name'] . '_selected_student'];
}
$cid = -1;
if (isset($_SESSION[$_CONF['sess_name'] . '_selected_course'])) {
$cid = $_SESSION[$_CONF['sess_name'] . '_selected_course'];
}
$result = get_teacher_course_list($tid, $_SESSION[$_CONF['sess_name'] . '_current_school_year'], $_SESSION[$_CONF['sess_name'] . '_myCenter'], 'Y');
$courseSelectList = make_selection_list($result, $cid, 'course_id', 'courses', 'Course', 'on');
$b .= "<center>" . $courseSelectList . "\n <input type=hidden name=hoursByClass id=hoursByClass />\n </form></center>\n";
$main .= make_box($t, $b);
if ($sid != -1 || $cid != -1) {
include 'hoursReport.php';
}
} else {
$main .= login_error();
}
$t = "Admins";
$b = "";
if (isset($_SESSION[$_CONF['sess_name'] . '_adminCenterID'])) {
$sql = "SELECT * from ed_centers";
$result = $db->query($sql);
$loc = array();
while ($row = $result->fetch_assoc()) {
$loc[$row['center_id']] = $row['short_name'];
}
$b .= "\n\t\t\t\t<form action=index.php";
if (isset($_SESSION[$_CONF['sess_name'] . '_lev'])) {
$b .= "?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'];
}
$b .= " method=POST name=adminCenter>\n";
/** make_selection_list($list,$selected=-1,$select_name,$form, $what, $change="off")**/
$b .= make_selection_list($loc, $_SESSION[$_CONF['sess_name'] . '_adminCenterID'], 'adminCenterID', 'adminCenter', 'School', 'on');
$b .= "\n\t\t\t\t</form>\n";
}
$b .= $adminlinks . "<A HREF=" . $_SERVER['PHP_SELF'] . "?logout>Logout</A>";
$main .= make_box($t, $b);
/** now for the ssl seal **/
}
$main .= "\n <!--/div-->\n </td>\n <td bgcolor=white valign=top style=\"margin:10px\"><br />\n\n ";
/** Message Dialog Box **/
$t = "Messages";
$b = "<div id=\"messages\"></div>";
$main .= "\n <!-- Begin User Main -->\n <!--div id=userMain style=\"overflow-y:auto; width:100%; height:800px;\"-->\n <div id=\"messageDiv\">" . make_box($t, $b, 'yellow') . "</div>\n <div id=\"siteInfoDiv\">";
if (!$_SESSION[$_CONF['sess_name'] . '_hasSecretQuestions']) {
include 'user_setSecretQuestions.php';
} elseif (isset($_SESSION[$_CONF['sess_name'] . '_lev'])) {
include $_SESSION[$_CONF['sess_name'] . '_lev'] . '_' . $_SESSION[$_CONF['sess_name'] . '_cat'] . '.php';
$myStudents_ID = make_assoc_array_from_sql(get_students_for_course($cid), 'user_id', 'my');
$result = get_course_info($cid);
$row = $result->fetch_assoc();
$cname = $row['course_name'];
*
*/
}
$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 = "WBL";
$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";
$main .= make_box($t, $b) . "<br>";
$newDialog = "\n\t\t<div id=\"newDialog\">\n\t\t\t<form id=\"newWBLForm\" name=\"newWBLForm\" action=\"\" method=POST>\n\t\t\t<div id=\"newWBLDiv\"></div>\n\t\t\t<center>\n\t\t\t<input type=submit id=\"insertWBL\" name=\"insertWBL\" value=\"Insert\" />\n\t\t\t<input type=reset id=\"cancelNewWBL\" name=\"cancelNewWBL\" value=\"Cancel\" />\n\t\t\t</center>\n\t\t\t</form>\n\t\t</div>";
$t = "New WBL";
$main .= "<div id=\"newWBLDialog\">" . make_box($t, $newDialog) . "</div>";
$editDialog = "\n\t\t<div id=\"editDialog\">\n\t\t\t<form id=editWBLForm name=editWBLForm action=\"\" method=POST>\n\t\t\t<div id=editWBLDiv></div>\n\t\t\t<center>\n\t\t\t<input type=submit id=\"updateWBL\" name=\"updateWBL\" value=\"Update\" />\n\t\t\t<input type=reset id=\"cancelUpdateWBL\" name=\"cancelUpdateWBL\" value=\"Cancel\" />\n\t\t\t</center>\n\t\t\t</form>\n\t\t</div>";
$t = "Edit Jobs";
$main .= "<div id=\"editWBLDialog\">" . make_box($t, $editDialog, 'blue') . "</div>";
$s2jDialog = "\n\t\t<div id=\"s2jDialog\">\n\t\t\t<form id=s2jWBLForm name=s2jWBLForm action=\"\" method=POST>\n\t\t\t<div id=s2jWBLDiv></div>\n\t\t\t<center>\n\t\t\t<input type=submit id=\"s2jWBL\" name=\"s2jWBL\" value=\"Update\" />\n\t\t\t<input type=reset id=\"cancels2jWBL\" name=\"cancels2jWBL\" value=\"Cancel\" />\n\t\t\t</center>\n\t\t\t</form>\n\t\t</div>";
$t = "Assign Students to Job";
$main .= "<div id=\"s2jWBLDialog\">" . make_box($t, $s2jDialog, 'blue') . "</div>";
if ($cid != -1) {
// Display current WBL jobs for current course
$cresult = get_course_info($cid);
$courseInfo = $cresult->fetch_assoc();
$sql = "SELECT * from wbl where course_id=" . $cid . " AND school_year=" . $_SESSION[$_CONF['sess_name'] . '_current_school_year'] . " ORDER by date, job";
}
$term_select = make_selection_list($terms, $selected_term, "term_id", "restoreForm", "term", "on");
$b .= "Term : " . $term_select . "<br />";
if (isset($_POST['term_id'])) {
// read the list of available files for this teacher for this class for this term from file system
if (is_dir($start_path . $center . "/" . $uname . "/" . $courses[$selected_course] . "/" . $terms[$selected_term])) {
$dh = opendir($start_path . $center . "/" . $uname . "/" . $courses[$selected_course] . "/" . $terms[$selected_term]);
$files = array();
while ($file = readdir($dh)) {
if ($file != '.' && $file != '..') {
array_push($files, $file);
}
}
closedir($dh);
asort($files);
$file_select = make_selection_list($files, $selected_file, "file_id", "restoreForm", "file", "on");
$b .= "File : " . $file_select . "<br />";
if (isset($_POST['file_id'])) {
$b .= "\n\t\t\t\t\t\t<input type=submit name=restore value=Restore /><br />";
if (isset($_POST['restore'])) {
$file = "/usr/local/q3ait/teacher_backups/" . $center . "/" . $uname . "/" . $courses[$selected_course] . "/" . $terms[$selected_term] . "/" . $files[$selected_file];
$lines = file($file);
//displayArray($lines);exit;
asort($lines);
$fd = fopen($file, "r");
$contents = fread($fd, filesize($file));
fclose($fd);
$delimiter = "EofL\n";
$records = explode($delimiter, $contents);
$s2c = array();
$sql = "SELECT class_id FROM classes \n\t\t\t\t\t\t\tWHERE course_id =" . $selected_course . " AND term_id =" . $selected_term;
//$main .= make_box($t,$b);
} else {
$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;
$_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=students>\n\t\t\t\t\t\t<center>" . make_selection_list($los, $sid, 'student_id', 'students', 'Student', 'on') . "</center>\n\t\t\t\t\t\t<input type=hidden name=check_by value=parent />\n\t\t\t\t\t\t</form>";
if ($sid != -1) {
/** Get the Home School Info then Parent Info **/
$sql = "SELECT users.first_name, users.last_name, schools.attend_officer, schools.attend_email, schools.school_name,schools.phone \n\t\t\t\t\t\t\tFROM users, schools \n\t\t\t\t\t\t\tWHERE users.user_id=" . $sid . " and schools.school_id=users.school_id";
$result = $db->query($sql);
$row = $result->fetch_assoc();
$school_name .= "\n\t\t\t\t\t\t\t<tr><th colspan=2>School Contact Info</th></tr>\n\t\t\t\t\t\t\t<tr><td bgcolor=white align=right><b>School Name:</b></td>\n\t\t\t\t\t\t\t<td bgcolor=white>" . $row['school_name'] . "</td></tr>\n\t\t\t\t\t\t\t<tr><td bgcolor=white align=right><b>Attendance Offcier(s):</b></td>\n\t\t\t\t\t\t\t<td bgcolor=white>" . $row['attend_officer'] . "</td></tr>\n\t\t\t\t\t\t\t<tr><td bgcolor=white align=right><b>Attendance e-mail(s):</b></td>\n\t\t\t\t\t\t\t<td bgcolor=white>" . $row['attend_email'] . "</td></tr>\n\t\t\t\t\t\t\t<tr><td bgcolor=white align=right><b>School Phone:</b></td>\n\t\t\t\t\t\t\t<td bgcolor=white>" . $row['phone'] . "</td></tr>";
$sql = "SELECT users.user_id, users.first_name, users.last_name, users.email, users.phone \n\t\t\t\t\t\t\tFROM parent2student, users\n\t\t\t\t\t\t\tWHERE parent2student.student_id=" . $sid . " \n\t\t\t\t\t\t\t\tAND users.user_id=parent2student.parent_id";
$result = $db->query($sql);
$parent = "<tr><td> </td></tr>\n\t\t\t\t\t\t\t<tr><th colspan=2>Parent Contact Info</th></tr>";
$num_rows = $result->num_rows;
if ($num_rows > 0) {
while ($myrow = $result->fetch_assoc()) {
$parent .= "\n\t\t\t\t\t\t\t\t\t<tr><td bgcolor=white align=right><b>First :</b></td><td bgcolor=white>" . $myrow['first_name'] . "</td>\n\t\t\t\t\t\t\t\t\t<td bgcolor=white valign=middle rowspan=4>\n\t\t\t\t\t\t\t\t\t\t<form action=teach_sendmail.php method=post target=new>\n\t\t\t\t\t\t\t\t\t\t<input type=submit class=submit name=compose value=\"Send email\">\n\t\t\t\t\t\t\t\t\t\t<input type=hidden name=parents value=" . urlencode(serialize(array($myrow['user_id']))) . ">\n\t\t\t\t\t\t\t\t\t\t<input type=hidden name=teacher_id value=" . $tid . ">\n\t\t\t\t\t\t\t\t\t\t</form>\n\t\t\t\t\t\t\t\t\t</td></tr>\n\t\t\t\t\t\t\t\t\t<tr><td bgcolor=white align=right><b>Last :</b></td><td bgcolor=white>" . $myrow['last_name'] . "</td></tr>\n\t\t\t\t\t\t\t\t\t<tr><td bgcolor=white align=right><b>E-mail :</b></td><td bgcolor=white>" . $myrow['email'] . "</td></tr>\n\t\t\t\t\t\t\t\t\t<tr><td bgcolor=white align=right><b>Phone :</b></td><td bgcolor=white>" . $myrow['phone'] . "</td></tr>";
}
} else {
/** default value ie none selected **/
if (isset($_SESSION[$_CONF['sess_name'] . '_selected_class'])) {
$classID = $_SESSION[$_CONF['sess_name'] . '_selected_class'];
}
$teach_backup_folder = $_CONF['configPath'] . "teacher_backups/" . $_SESSION[$_CONF['sess_name'] . '_myCenters'][$_SESSION[$_CONF['sess_name'] . '_myCenter']]['short_name'] . "/" . $_SESSION[$_CONF['sess_name'] . '_myUname'] . "/";
$terms = $_SESSION[$_CONF['sess_name'] . '_terms'];
/** ================ New Class =================== **/
$t = "New Class";
$b = "<center>\n\t<div style=\"color:red\">NOTE: Do not create a new class for each marking period. Create the class once and select the marking periods this class will be enrolled in. <br />If this is the CORE class (ie not an integrated credit class), please select the box netx to \"This is a core class.\"</div>\n\t<form action=\"\" method=\"post\" id=\"newClassForm\" name=\"newClassForm\">";
$b .= "\n\t<table border=0 cellspacing=0 cellpadding=3>\n\t<tr>\n\t\t<td align=right>Class name :</td>\n\t\t<td align=left> <input class=\"validate[required]\" type=text id=\"course_nmae\" name=\"course_name\" size=20 /></td>\n\t</tr>\n\t<tr><td align=center colspan=2>This is a core class.<input type=checkbox name=coreClass /></td></tr>\n <tr><td align=center colspan=2>AM<input class=\"validate[required]\" type=radio id=period name=period value=\"AM\"/> or PM<input type=radio id=period name=period value=\"PM\"/></td></tr>\n\t<tr><td align=center colspan=2>Minutes of Instruction:<input type=text name=minutes id=minutes value=150 /></td></tr>\n\t<tr><td align=center colspan=2>Please Select Terms for This Class</td></tr>";
foreach ($terms as $tid => $tarray) {
$b .= "\n\t\t<tr><td align=right><input type=checkbox name=t_" . $tid . " value=" . $tid . " /></td><td>" . $tarray['term_name'] . "</td></tr>";
}
$loc = get_centers_for_teacher($_SESSION[$_CONF['sess_name'] . '_myUID']);
$b .= "\n\t<tr>\n\t<td colspan=2 align=center>This class for ";
$b .= make_selection_list($loc, $_SESSION[$_CONF['sess_name'] . '_myCenter'], 'center_id', 'newClass', 'Center', 'off');
$b .= "\n\t</td>\n\t</tr>\n\t<tr><td colspan=2 align=center>\n\t<input type=\"submit\" class=\"submit\" id=\"insertNewClass\" name=\"insertNewClass\" value=\"Insert\" />\n\t<input type=\"button\" id=\"cancelNewClass\" name=\"cancelNewClass\" value=\"Cancel\" />\n\t<input type=hidden name=teacher_id value=" . $_SESSION[$_CONF['sess_name'] . '_myUID'] . " />\n\t</td>\n\t</tr>\n\t</table>\n\t</form>\n\t</center>";
$main .= "<div id=\"newClassDialog\">" . make_box($t, $b) . "</div>";
$editDialog = "\n\t\t<div id=editDialog>\n\t\t<form id=editClassForm name=editClassForm action=\"\" method=POST>\n\t\t<div id=editClassDiv></div>\n\t\t<center>\n\t\t<input type=submit id=\"updateCourse\" name=\"updateCourse\" value=\"Update\" />\n\t\t<input type=reset id=\"cancelUpdateCourse\" name=\"cancelUpdateCourse\" value=\"Cancel\" />\n\t\t</center>\n\t\t</form>\n\t\t</div>";
$t = "Update Class";
$main .= "<div id=\"editClassDialog\">" . make_box($t, $editDialog, 'blue') . "</div>";
/** Now list current classes for teacher **/
$b = "";
$bc = "blue";
$t = "Class Management";
$b .= "<input type=\"button\" class=\"submit\" id=\"showNewClass\" name=\"showNewClass\" value=\"New Class\">";
$list = $_SESSION[$_CONF['sess_name'] . '_myCourses'];
//if(count($list)){
$b .= "\n\t\t<center>\n\t\t<form id=\"classListForm\" action=\"\" method=POST>\n\t\t<table id=\"classTable\" border=0 bgcolor=white cellspacing=1 cellpadding=3>\n\t\t<thead>\n\t\t<tr>\n\t\t\t<th bgcolor=white colspan=2>Name</th>\n\t\t</tr>\n\t\t</thead>\n\t\t<tbody id=\"classList\">";
foreach ($list as $cid => $cname) {
$cresult = get_course_info($cid);
$size = $row['size'];
$type = $row['file_type'];
$file = $downloads_path . $name;
$fp = fopen($file, 'r');
//$dl = fread($fp, $size);
header("Content-length: " . $size);
header("Content-type: " . $type);
header("Content-Disposition: attachment; filename=" . $name);
fpassthru($fp);
//echo $dl;
fclose($fp);
exit;
}
/** now for the download **/
/** select a class **/
$b = "\n\t\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\t<center><table border=0 cellspacing=2 cellpadding=2>\n\t\t\t<tr>\n\t\t\t<!--td align=right>Please Select a Class :</td-->\n\t\t\t<td align=left>" . make_selection_list(get_student_core_class_list($_SESSION[$_CONF['sess_name'] . '_myUID']), $cid, 'course_id', 'courses', 'Course', 'on') . "</td>\n\t\t\t</tr>\n\t\t\t</table>\n\t\t\t</center>\n\t\t\t</form>";
$t = "Get Downloads";
if ($cid != -1) {
$result = get_downloads_for_course($cid);
$t = "Files Available for Download";
if ($result->num_rows != 0) {
$b .= "<center><table border=0 cellspacing=2 cellpadding=2>";
while ($row = $result->fetch_assoc()) {
$b .= "<tr>";
$b .= "<td valign=top nowrap><b>" . $row['title'] . " :</b></td>";
$b .= "<td valign=top>" . $row['description'] . "</td>";
$b .= "<td>";
$b .= "<form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=\"post\">";
$b .= "<input type=submit class=submit name=download value=Download />";
$b .= "<input type=hidden name=f_id value=" . $row['download_id'] . " />";
$b .= "<input type=hidden name=t_id value=" . $row['teacher_id'] . " />";
$result = $db->query($sql);
return $result;
}
function GetMonthString($n)
{
$timestamp = mktime(0, 0, 0, $n, 1, 2005);
return date("F", $timestamp);
}
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=
*/
} else {
$_SESSION[$_CONF['sess_name'] . '_selected_school'] = -1;
}
if (isset($_POST['school_id'])) {
$sid = $_SESSION[$_CONF['sess_name'] . '_selected_school'] = $_POST['school_id'];
}
$sess = '';
if (isset($_POST['session'])) {
$sess = $_POST['session'];
}
$c = "blue";
$t = "Single District Attendance";
$b = "";
$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, $sid, 'school_id', 'schoolForm', 'School', 'on');
$attendVals = makeAttendPullDownList($av);
/** get dates for date picker... */
$today = date('Y-m-d');
$schoolYears = get_school_years_list();
$currentYear = $schoolYears[$_SESSION[$_CONF['sess_name'] . "_current_school_year"]];
$header .= "\n <script type=\"text/javascript\">\n \$(document).ready(function() {\n \$('#school_id').addClass(\"validate[required]\");\n \$('#attendForm').validationEngine({inlineValidation: true, scroll:false});\n });\n </script>";
$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' ";
*/
//$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);
}
<?php
if ($_SESSION[$_CONF['sess_name'] . '_isStudent']) {
// display list of classes (used for all routines)
// that I am enrolled in...
$t = "Student Homework";
$bc = "blue";
// default box color
$b = "<form action=" . $_SERVER['PHP_SELF'] . "?lev=" . $_REQUEST['lev'] . "&cat=" . $_REQUEST['cat'] . " method=\"post\" name=studentHomework>\n";
if (isset($_REQUEST['class_id'])) {
$b .= "<center>" . make_selection_list(student_class_list($_SESSION[$_CONF['sess_name'] . '_myUID']), $cid, 'class_id', 'studentHomework', 'Class', 'on') . "</center>\n";
} else {
$b .= "<center>" . make_selection_list(student_class_list($_SESSION[$_CONF['sess_name'] . '_myUID']), -1, 'class_id', 'studentHomework', 'Class', 'on') . "</center>\n";
}
$b .= "<center></center>\n";
if (isset($_REQUEST['class_id'])) {
if (isset($_REQUEST['view'])) {
// retrieve and display the assignment
$sql = "SELECT assignment,date from homework where homework_id=" . $_REQUEST['assignment_num'];
$result = mysql_query($sql);
$row = mysql_fetch_row($result);
list($y, $m, $d) = split("-", $row[1]);
$b .= "<hr width=80%>";
$b .= "HW for <b>" . date("l, F j, Y", mktime(0, 0, 0, $m, $d, $y)) . "</b>";
$b .= "<table border=0 cellspacing=1 cellpadding=3 width=70%>";
$b .= "<tr><td>";
$b .= nl2br($row[0]);
$b .= "</td></tr>";
$b .= "</table>";
} else {
// retrieve the assignments for the class
$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();
}
$note = '';
if (isset($_POST['attendNote'])) {
$note = $_POST['attendNote'];
}
$min = '';
if (isset($_POST['a_minutes'])) {
$min = $_POST['a_minutes'];
}
$c = "blue";
$t = "Single District Attendance";
$b = "";
$schools = get_schools_for_center($_SESSION[$_CONF['sess_name'] . "_myCenter"]);
$schoolList = make_array_from_mysql($schools, 'school_id', array('school_name'), "");
$allSchoolsForCenter = $schoolList;
$schoolList['999'] = "-- ALL SCHOOLS --";
$schoolSelect = make_selection_list($schoolList, $sid, 'school_id', 'attendForm', 'School', 'off');
$schoolsForBulkAttend = array();
if (isset($_POST['school_id'])) {
if ($_POST['school_id'] == 999) {
$schoolsForBulkAttend = $allSchoolsForCenter;
} else {
$schoolsForBulkAttend[$_POST['school_id']] = $schoolList[$_POST['school_id']];
}
}
$attendVals = makeAttendPullDownList($av);
/** get dates for date picker... */
if (isset($_POST['setAttend'])) {
$today = $_POST['dateSelector'];
} else {
$today = date('Y-m-d');
}
$studSelection = make_selection_list($sList, $sid, 'a_s_id', "active_students", "Student", "on");
$t = "Hours By Student (Active)";
$b = "<center><br />";
$b .= "<form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST name=active_students>";
$b .= $studSelection;
$b .= "<input type=hidden name=hoursByStudent id=hoursByStudent />";
$b .= "</form>";
$b .= "</center>";
$main .= make_box($t, $b);
if (isset($_POST['a_s_id'])) {
include 'hoursReport.php';
}
/** now take care of the inactive students... **/
$result = get_users_for_attendance($_SESSION[$_CONF['sess_name'] . '_myCenter'], 'isStudent', 'N', $orderBy = "users.last_name, users.first_name");
$sList = make_array_from_mysql($result, "user_id", array("first_name", "last_name"), " ");
$studSelection = make_selection_list($sList, $sid, 'ia_s_id', "inactive_students", "Student", "on");
$t = "Attendance By Student (Inactive)";
$b = "<center><br />";
$b .= "<form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST name=inactive_students>";
$b .= $studSelection;
$b .= "</form>";
if (isset($_POST['ia_s_id'])) {
include 'hoursReport.php';
}
$b .= "</center>";
$t = "Attenance by School District";
$b = "";
$b .= "\n <center>\n <form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST id=\"hoursBySchoolForm\" name=\"hoursBySchoolForm\">\n <table><tr><th>School</th><td>" . $schoolSelect . "</td></tr></table>\n <div id=\"attendBySchoolDialog\">\n <table>\n <tr><th>Session</th><td><input class=\"validate[required] session\" radio type=radio name=session id=session value='AM' ";
if ($sess == 'AM') {
$b .= " checked=true";
}
$b = "";
$t = "Custom Pages";
$sid = $_SESSION[$_CONF['sess_name'] . '_myUID'];
$fname = $_SESSION[$_CONF['sess_name'] . '_myfName'];
$lname = $_SESSION[$_CONF['sess_name'] . '_mylName'];
$cid = -1;
if (isset($_SESSION[$_CONF['sess_name'] . '_selected_course'])) {
$cid = $_SESSION[$_CONF['sess_name'] . '_selected_course'];
$result = get_class_info($cid);
$row = $result->fetch_assoc();
$className = $row['class_name'];
$termName = $row['term_name'];
$teacherName = $row['first_name'] . " " . $row['last_name'];
}
$b .= $QUERY_STRING;
$b .= "<FORM action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST name=courses>\n <center>" . make_selection_list($classes, $cid, 'course_id', 'courses', 'Course', 'on') . "\n </center></form>";
/** NOW get the custom pages for selected class **/
$sql = "SELECT teacher_pages.page_id,teacher_pages.teacher_id, teacher_pages.link_name, teacher_pages.description, users.u_name \n FROM teacher_page2course, teacher_pages, users\n WHERE teacher_page2course.course_id=" . $cid . "\n AND teacher_pages.page_id=teacher_page2course.page_id\n AND users.user_id=teacher_pages.teacher_id";
$result = $db->query($sql);
$b .= "<table>";
while ($row = $result->fetch_assoc()) {
$b .= "<tr>\n <!--td>" . $row['page_id'] . "</td-->\n <td>" . $row['link_name'] . "</td>\n <td>" . $row['description'] . "</td>\n <td>\n <form action=" . $_SERVER['REQUEST_URI'] . " method=POST>\n <input type=submit name=viewPage value=View />\n <input type=hidden name=page_id value=" . $row['page_id'] . " />\n <input type=hidden name=teacher_id value=" . $row['teacher_id'] . " />\n <input type=hidden name=tu_name value='" . $row['u_name'] . "' />\n </form>\n </td>\n </tr>";
}
$b .= "</table>";
$main .= make_box($t, $b);
if (isset($_POST['viewPage'])) {
include $SAVE_PATH . $_POST['tu_name'] . "/" . $_POST['page_id'] . ".php";
$b = $my_out;
$t = "";
$main .= make_box($t, $b);
}
<?php
if ($_SESSION[$_CONF['sess_name'] . '_isParent']) {
$pid = $_SESSION[$_CONF['sess_name'] . '_myUID'];
$t = "Student Attendance";
$b = "<FORM action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST name=studentClasses>";
//$b="";
$sid = -1;
if (isset($_SESSION[$_CONF['sess_name'] . '_selected_student'])) {
$sid = $_SESSION[$_CONF['sess_name'] . '_selected_student'];
}
$b .= "<center>" . make_selection_list(get_students_for_parent($pid), $sid, 'student_id', 'studentClasses', 'Student', 'on') . "</center>";
if ($sid != -1) {
$sql2 = "SELECT user_id,first_name,last_name from users where user_id=" . $sid;
$result2 = $db->query($sql2);
$colcount = 0;
$row2 = $result2->fetch_assoc();
$sname = $row2['first_name'] . " " . $row2['last_name'];
$b .= "<div style=\"text-align:center\"><a href=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . "&s_id=" . $sid . ">" . $sname . "</a></div><br />";
$loc = get_student_classes_for_attendance($sid);
foreach ($loc as $cname => $info) {
$att = array();
$b .= "<div style=\"text-align:center;font-weight:bold\">" . $cname . "</div><br />";
foreach ($info as $cid => $name_term) {
if (isset($_POST['year'])) {
$att = array_merge($att, get_student_attendance($sid, $cid, $_POST['year']));
//$att = array_merge($att,get_student_attendance($sid,$cid, $name, $_POST['year']));
//$att = array_merge($att,getSMSStudentAttendance($sid,$cid, $_POST['year'],$_SESSION[$_CONF['sess_name'].'_myCenter']));
} else {
$att = array_merge($att, get_student_attendance($sid, $cid, $_SESSION[$_CONF['sess_name'] . '_current_school_year']));
//$att = array_merge($att,get_student_attendance($sid,$cid,$name, $_SESSION[$_CONF['sess_name'].'_current_school_year']));
get_students_for_teacher($tid)
if a student is here, then get the list of classes/teachers to send to
**/
if ($_SESSION[$_CONF['sess_name'] . '_isTeacher']) {
$result = get_students_for_teacher($myID);
$values = array("first_name", "last_name");
$key = "user_id";
$los = make_array_from_mysql($result, $key, $values, " ");
$t = "Send a file";
$b = "<form enctype=\"multipart/form-data\" action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=\"post\" onSubmit=\"return validateForm(this);\">\n\t\t\t<center>\n\t\t\t<table border=0 cellspacin=2 cellpadding=2>\n\t\t\t<tr>\n\t\t\t<td align=right>Please Select Recipients<br />\n\t\t\t\t<div style=\"font-size:2px; color:red;\">Control-Click to select multiple recipients.</div>\n\t\t\t</td>\n\t\t\t<td align=left>" . make_multi_select_list($los, 'recipients') . "</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t<td align=right>Please select the file to upload :</td>\n\t\t\t<td align=left><input name=\"upload_file\" type=\"file\"></td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t<td align=right>Please provide a Title :</td>\n\t\t\t<td align=left><input name=\"title\" type=text size=20></td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t<td align=right valign=top>Description :</td> \n\t\t\t<td align=left><textarea name=description rows=6 cols=30></textarea></td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t<td colspan=2 align=center>\n\t\t\t<input type=\"submit\" name=\"upload\" value=\"Upload\">\n\t\t\t<input type=hidden name=upload-send />\n\t\t\t</td>\n\t\t\t</tr>\n\t\t\t</table>\n\t\t\t</center>\n\t\t\t</FORM>";
}
if ($_SESSION[$_CONF['sess_name'] . '_isStudent']) {
$lot = get_teachers_for_student($myID);
$t = "Send a file";
$b = "<form enctype=\"multipart/form-data\" action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=\"post\" onSubmit=\"return validateForm(this);\">\n\t\t\t<center>\n\t\t\t<table border=0 cellspacin=2 cellpadding=2>\n\t\t\t<tr>\n\t\t\t<td align=right>Please Select a Teacher</td>\n\t\t\t<td align=left>" . make_selection_list($lot, $tid, 'recipients', 'teachers', 'Teacher') . "</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t<td align=right>Please select the file to upload :</td>\n\t\t\t<td align=left><input name=\"upload_file\" type=\"file\"></td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t<td align=right>Please provide a Title :</td>\n\t\t\t<td align=left><input name=\"title\" type=text size=20></td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t<td align=right valign=top>Description :</td> \n\t\t\t<td align=left><textarea name=description rows=6 cols=30></textarea></td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t<td colspan=2 align=center>\n\t\t\t<input type=\"submit\" name=\"upload\" value=\"Upload\">\n\t\t\t<input type=hidden name=upload-send />\n\t\t\t</td>\n\t\t\t</tr>\n\t\t\t</table>\n\t\t\t</center>\n\t\t\t</FORM>";
}
$main .= "<br />" . make_box($t, $b);
} elseif (isset($_POST['upload'])) {
/**
place the recipient(s) ID's/usernames into an array and process the array so that
if teacher hands out to several students, this will work same as 1 student
Trying to deal with a teacher handing out to several students or adding to his save
and same for students...
Now $recipients is an array of ID's that are to receive the file being uploaded...
**/
$recipients = array();
while (list($var, $value) = each($_POST)) {
if ($var == "recipients") {
if (is_array($value)) {
$recipients = $value;
$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";
}
$b .= ">School Name, last Name, First Name</option>\n </select></center>\n\t\t\t\t<input type=hidden name=check_by value=student />\n\t\t\t\t</form>";
if ($sid != -1) {
/** Get the Home School Info then Parent Info **/
$sql = "SELECT users.first_name, users.last_name, schools.attend_officer, schools.attend_email, schools.school_name, schools.phone \n\t\t\t\t\tFROM users, schools \n\t\t\t\t\tWHERE users.user_id=" . $sid . " and schools.school_id=users.school_id";
$result = $db->query($sql);
$row = $result->fetch_assoc();
$school_name .= "\n\t\t\t\t\t<tr><th colspan=2>School Contact Info</th></tr>\n\t\t\t\t\t<tr><td bgcolor=white align=right><b>School Name :</b></td>\n\t\t\t\t\t<td bgcolor=white>" . $row['school_name'] . "</td></tr>\n\t\t\t\t\t<tr><td bgcolor=white align=right><b>Attendance Offcier(s):</b></td>\n\t\t\t\t\t<td bgcolor=white>" . $row['attend_officer'] . "</td></tr>\n\t\t\t\t\t<tr><td bgcolor=white align=right><b>Attendance e-mail(s) :</b></td>\n\t\t\t\t\t<td bgcolor=white>" . $row['attend_email'] . "</td></tr>\n\t\t\t\t\t<tr><td bgcolor=white align=right><b>School Phone :</b></td>\n\t\t\t\t\t<td bgcolor=white>" . $row['phone'] . "</td></tr>";
$sql = "SELECT users.user_id, users.first_name, users.last_name, users.email, users.phone \n\t\t\t\t\tFROM parent2student, users\n\t\t\t\t\tWHERE parent2student.student_id=" . $sid . " \n\t\t\t\t\tAND users.user_id=parent2student.parent_id";
$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();
}
