function messageForm($data)
{
global $startYr, $endYr;
$t = "Message to Parents/Students";
$b = "";
$b .= "\n <center>\n\t<FORM action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST onSubmit=\"return validateForm(this);\">\n\t<table cellspacing=1 cellpadding=3 border=0 bgcolor=black border=0>\n\t\t<tr>\n\t\t<th>Start Date</th><th>End Date</th>\t\n\t\t</tr><tr>\n\t\t<td><span style=white-space:nowrap>" . make_LOM("startMonth", $data['startMonth']) . make_LOD("startDay", $data['startDay']) . make_LOY("startYear", $data['startYear'], $startYr, $endYr) . "</span></td>\n\t\t<td><span style=white-space:nowrap>" . make_LOM("endMonth", $data['endMonth']) . make_LOD("endDay", $data['endDay']) . make_LOY("endYear", $data['endYear'], $startYr, $endYr) . "</span></td>\n\t\t</tr>";
if ($data['lev'] == 3) {
/** get_teacher_course_list($tid,$core="") **/
$courses = get_teacher_course_list($data['u_id'], $_SESSION[$_CONF['sess_name'] . '_current_school_year'], $_SESSION[$_CONF['sess_name'] . '_myCenter'], 'Y');
$b .= "\n\t\t\t<tr>\n\t\t\t<td colspan=2>\n\t\t\tThis Message is for :";
foreach ($courses as $id => $name) {
$b .= "\n\t\t\t\t<input type=checkbox name=cid_" . $id . " value=" . $id;
if (in_array($id, $data['forCourses'])) {
$b .= " checked";
}
$b .= " />" . $name;
}
$b .= "\n\t\t\t</td>\n\t\t\t</tr>";
}
$b .= "\n\t\t<tr>\n\t\t<th width=200 colspan=2>Message</th>\n\t\t</tr><tr>\n\t\t<td colspan=2><textarea rows=10 cols=70 name=message id=message>" . $data['message'] . "</textarea></td>\n\t\t</tr><tr>\n\t\t<td colspan=2>\n\t\t<center>\n\t\t\t<input type=submit class=" . $data['button']['class'] . " name=update_message value='" . $data['button']['value'] . "'>\n\t\t\t<input type=hidden name=message_id value=" . $data['messageID'] . " />\n\t\t</center>\n\t\t</td>\n\t\t</tr>\n\t</table>\n\t</form>\n\t</center>";
$ret .= make_box($t, $b, "blue");
return $ret;
}
$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>";
}
$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;
}
/** Display the list of classes **/
$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";
$b .= "\n\t\t<center>" . make_selection_list($core_classes, $cid, 'course_id', 'courses', 'Course', 'on') . "\n\t\t<input type=hidden name=teacher_id value=" . $tid . " />\n <input type=hidden name=hoursByClass id=hoursByClass />\n\t\t</center>\n\t\t</form>\n";
}
/** end if isset teacher_id **/
$main .= make_box($t, $b);
if (isset($_POST['course_id'])) {
include 'hoursReport.php';
}
}
$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
$dh = opendir($start_path . $center . "/" . $uname . "/" . $courses[$selected_course]);
$terms = array();
$result = get_terms($yid, $_SESSION[$_CONF['sess_name'] . "_myCenter"]);
while ($row = $result->fetch_assoc()) {
$terms[$row['term_id']] = $row['term_name'];
}
$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
$parents = get_parentinfo($uid);
$b .= "\n\t\t\t\t<tr>\n\t\t\t\t\t<td bgcolor=white><font size=2>" . $uname . "</font></td>\n\t\t\t\t\t<td bgcolor=white><font size=2>";
while ($row2 = $parents->fetch_assoc()) {
// if none, then print?
$b .= $row2['first_name'] . " " . $row2['last_name'] . " : " . $row2['email'] . "<br />";
if (!in_array($row2['user_id'], $lop)) {
array_push($lop, $row2['user_id']);
}
}
$b .= "\n\t\t\t\t\t</font></td>\n\t\t\t\t</tr>";
}
$b .= "\n\t\t\t\t<tr>\n\t\t\t\t\t<td bgcolor=white colspan=2 align=center>\n\t\t\t\t\t\t<form action=teach_sendmail.php method=post target=new>\n\t\t\t\t\t\t<input type=submit class=submit name=compose value=\"Send email\" />\n\t\t\t\t\t\t<input type=hidden name=parents value=\"" . urlencode(serialize($lop)) . "\" />\n\t\t\t\t\t\t<input type=hidden name=teacher_id value=" . $tid . " />\n\t\t\t\t\t\t</form>\t\n\t\t\t\t\t</td>\n\t\t\t\t</tr>\n\t\t\t\t</table></center>";
//$main .= make_box($t,$b);
} elseif ($_POST['check_by'] == "class") {
//$result = make_selection_list(teacher_core_class_list($tid),$cid,'class_id','classes','Class','on');
$result = make_selection_list(get_teacher_course_list($tid, $_SESSION[$_CONF['sess_name'] . '_current_school_year'], $_SESSION[$_CONF['sess_name'] . '_myCenter'], 'Y'), $cid, 'course_id', 'courses', 'Course', 'on');
$t = "Courses for : " . $fname . " " . $lname;
$b .= "<center>\n <table border=0 bgcolor=white cellspacing=1 cellpadding=3>\n <tr>\n <td bgcolor=white>\n <form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST name=courses>" . $result . "\n <input type=hidden name=check_by value=" . $_POST['check_by'] . " />\n </form></td>\n\t\t\t</tr>\n\t\t\t</table></center>";
if ($cid != -1) {
$result = get_students_for_course($cid);
$students = make_array_from_mysql($result, "user_id", array('first_name', 'last_name'), " ");
$t = "Contact Information";
$b .= "<center>\n\t\t\t\t\t<table border=0 bgcolor=white cellspacing=1 cellpadding=3>\n\t\t\t\t\t<tr> \n\t\t\t\t\t\t<th>Student</th><th>Parent</th>\n\t\t\t\t\t</tr> ";
foreach ($students as $uid => $uname) {
$student = $uid;
$parents = get_parentinfo($student);
$sql = "SELECT users.user_id, users.first_name, users.last_name, users.email, users.phone \n FROM users\n WHERE user_id=" . $uid;
$result = $db->query($sql);
$myrow = $result->fetch_assoc();
$b .= "\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td bgcolor=white>" . $uname . "<br />" . $myrow['email'] . "</td>\n\t\t\t\t\t\t<td bgcolor=white>";
while ($row2 = $parents->fetch_assoc()) {
}
// Error checking...
//ini_set('display_errors', 1); error_reporting(E_ALL);
//displayArray($_SESSION);
$header = " \r\n<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01//EN\" \"http://www.w3.org/TR/html4/strict.dtd\">\r\n<! --!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\" -->\r\n<html style=\"height:100%;\" xmlns=\"http://www.w3.org/1999/xhtml\">\r\n<head>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html;charset=utf-8\" />\r\n<title>Academy for Information Technology - Student Information Management System</title> \r\n<link href=\"ait.css\" rel=\"stylesheet\" type=\"text/css\" />\r\n<!--[if IE 6]>\r\n<link type='text/css' href='ait.IE6.css' rel='stylesheet' />\r\n<![endif]-->\r\n<link rel=\"shortcut icon\" href=\"images/smlogo.jpg\" type=\"ciscologo\" />\r\n\r\n<!-- Use this one since there is a problem with current and Validation-Engine... -->\r\n<script src=\"js/jQuery/jquery-1.6.3.min.js\" type=\"text/javascript\"></script>\r\n<!--script src=\"js/jQuery/jquery-1.11.1.min.js\" type=\"text/javascript\"></script-->\r\n\r\n<script type=\"text/javascript\" src=\"js/index.js\"></script>\r\n\r\n<!-- NEED TO USE THE ABOVE DUE TO A PROBLEM WITH VALIDATION -->\r\n<!--script type=\"text/javascript\" src=\"http://code.jquery.com/jquery-latest.pack.js\"></script-->\r\n<!--script type=\"text/javascript\" src=\"js/jQuery/jQuery.js\"></script-->\r\n<!--script type=\"text/javascript\" src=\"js/jQuery/jQueryUI.js\"></script-->\r\n\r\n<script type=\"text/javascript\" src=\"js/jalerts/jquery.alerts.js\"></script>\r\n<link type=\"text/css\" rel=\"stylesheet\" media=\"screen\" href=\"js/jalerts/jquery.alerts.css\">\r\n\r\n<style type=\"text/css\">@import \"js/datepick/redmond.datepick.css\";</style>\r\n<script type=\"text/javascript\" src=\"js/datepick/jquery.datepick.js\"></script>\r\n<script type=\"text/javascript\" src=\"js/datepick/jquery.datepick.ext.js\"></script>\r\n\r\n<link rel=\"stylesheet\" href=\"js/jQuery-Validation-Engine-2/css/validationEngine.jquery.css\" type=\"text/css\"/>\r\n<script src=\"js/jQuery-Validation-Engine-2/js/languages/jquery.validationEngine-en.js\" type=\"text/javascript\" charset=\"utf-8\"></script>\r\n<script src=\"js/jQuery-Validation-Engine-2/js/jquery.validationEngine.js\" type=\"text/javascript\" charset=\"utf-8\"></script>\r\n\r\n<!-- Validation OLD WAY -->\r\n<!--script src=\"js/jQuery-Validation-Engine/js/jquery.validationEngine-en.js\" type=\"text/javascript\"></script>\r\n<script src=\"js/jQuery-Validation-Engine/js/jquery.validationEngine.js\" type=\"text/javascript\"></script>\r\n<link rel=\"stylesheet\" href=\"js/jQuery-Validation-Engine/css/validationEngine.jquery.css\" type=\"text/css\" media=\"screen\" charset=\"utf-8\" /-->\r\n";
if (isset($_SESSION[$_CONF['sess_name'] . '_lev'])) {
$jsFile = "js/" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "_" . $_SESSION[$_CONF['sess_name'] . '_cat'] . ".js";
if (file_exists($jsFile)) {
$header .= "\r\n<script type=\"text/javascript\" src=\"" . $jsFile . "\"></script>\r\n";
}
}
if (!$_SESSION[$_CONF['sess_name'] . '_logged_in']) {
$header .= "\r\n\t\t<script type=\"text/javascript\">\r\n\t\t\tfunction formfocus() {\r\n\t\t\t\tdocument.getElementById('login_focus').focus();\r\n\t\t\t}\r\n\t\t\twindow.onload = formfocus;\r\n\t\t</script>";
}
if ($_SESSION[$_CONF['sess_name'] . '_isTeacher']) {
$_SESSION[$_CONF['sess_name'] . '_myCourses'] = get_teacher_course_list($_SESSION[$_CONF['sess_name'] . '_myUID'], $_SESSION[$_CONF['sess_name'] . '_current_school_year'], $_SESSION[$_CONF['sess_name'] . '_myCenter']);
$header .= "\r\n\t<script src=\"js/jquery.form.js\" type=\"text/javascript\"></script>\r\n\t<script src=\"js/jquery.protect-data.js\" type=\"text/javascript\"></script>\r\n ";
}
list($d, $t) = preg_split("/ /", $_SESSION[$_CONF['sess_name'] . '_lastLogin']);
list($yr, $mon, $day) = preg_split("/-/", $d);
list($h, $m, $s) = preg_split("/:/", $t);
$lastLogin = date('l, M j, Y @ g:i A', mktime((int) $h, (int) $m, (int) $s, (int) $mon, (int) $day, (int) $yr));
$main = "\r\n</head>\r\n<body style=\"height:100%;\">\r\n <script type=\"text/javascript\" src=\"tooltip/wz_tooltip.js\"></script>\r\n\t<div id=\"page_header\">\r\n\t\t<div id=\"page_title\" style=\"padding-top:10px;\">Student Information System</div>\r\n\t\t<div id=\"page_logo\"><img src=\"images/build/q3logo.gif\" height=\"75\" alt=\"\" /></div>\r\n\t\t<div id=\"page_seal\">\r\n <a href=\"https://ssl.comodo.com\">\r\n <!--img src=\"https://ssl.comodo.com/images/comodo_secure_76x26_white.png\" alt=\"SSL\" width=\"76\" height=\"26\" style=\"border: 0px;\"-->\t\r\n <img src=\"https://ssl.comodo.com/images/comodo_secure_52x63_white.png\" alt=\"SSL\" width=\"52\" height=\"63\" style=\"border: 0px;\">\r\n </a>\r\n</div>\r\n </div>\r\n<div id=\"page_head_seperator\">\r\n\t<div id=\"page_date\">Today is " . $curdatetime . "</div>\r\n\t<div id=\"page_lastLogin\">";
if ($_SESSION[$_CONF['sess_name'] . '_logged_in'] && $yr > 2000) {
$main .= "You last logged in on " . $lastLogin;
}
$main .= "\r\n </div>\r\n\t<div id=\"page_user\">";
if ($_SESSION[$_CONF['sess_name'] . '_logged_in']) {
$main .= "Welcome " . $_SESSION[$_CONF['sess_name'] . '_myName'];
}
$main .= "\r\n\t</div>\r\n</div>";
$tid = $_SESSION[$_CONF['sess_name'] . '_myUID'];
$yid = $_SESSION[$_CONF['sess_name'] . '_current_school_year'];
$sid = $_SESSION[$_CONF['sess_name'] . '_myCenter'];
$termList = get_terms($yid, $sid);
/** 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($_REQUEST['s_id'])) {
$sid = $_REQUEST['s_id'];
}
$cid = -1;
if (isset($_SESSION[$_CONF['sess_name'] . '_selected_course'])) {
$cid = $_SESSION[$_CONF['sess_name'] . '_selected_course'];
}
$b .= "<center>" . make_selection_list(get_teacher_course_list($tid, $_SESSION[$_CONF['sess_name'] . '_current_school_year'], $_SESSION[$_CONF['sess_name'] . '_myCenter'], 'Y'), $cid, 'course_id', 'courses', 'Course', 'on') . "</form></center>\n";
$main .= make_box($t, $b);
/** Display the attendance for selected student **/
if ($sid != -1) {
$schoolName = getSchoolNameForID($sid);
$result = get_user_info($sid);
$row = $result->fetch_assoc();
$name = $row['first_name'] . " " . $row['last_name'];
$colcount = 0;
$t = "Attendance Report";
$b = "";
$b .= "<div style=\"text-align:center;font-weight:bold\">" . $name . " ~ " . $schoolName . "</div><br />";
if (isset($_POST['type'])) {
$att = array();
//$att = getSMSStudentAttendanceDetail($sid, $_SESSION[$_CONF['sess_name'].'_current_school_year'], $_SESSION[$_CONF['sess_name'].'_myCenter']);
$att = get_student_attendance($sid, $cid, $_SESSION[$_CONF['sess_name'] . '_current_school_year']);
