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;
}
$b .= " checked";
}
$b .= " /> Yes<input type=radio name=send_attend_email value=\"N\"";
if ($myrow['send_attend_email'] == 'N') {
$b .= " checked";
}
$b .= " />No</td>";
/** Now for progress reports **/
$b .= "</tr><tr>\n\t\t\t\t\t\t\t\t<td align=right><span style=white-space:nowrap>Email weekly progress reports?</span></td>\n\t\t\t\t\t\t\t\t<td align=left bgcolor=white><input type=radio name=weekly_progress value=\"Y\"";
if ($myrow['weekly_progress'] == "Y") {
$b .= " checked";
}
$b .= "> Yes<input type=radio name=weekly_progress value=\"N\"";
if ($myrow['weekly_progress'] == "N") {
$b .= " checked";
}
$b .= ">No</td>";
}
$b .= "\n\t\t\t\t</tr><tr>\n\t\t\t\t<td colspan=2 align=center>\n\t\t\t\t<input type=submit class=submit name=submit value=Update>\n\t\t\t\t<input type=hidden name=modify_ui value=1>\n\t\t\t\t<input type=hidden name=u_id value=" . $myrow['user_id'] . ">\n\t\t\t\t<input type=hidden name=u_name value='" . $myrow['u_name'] . "'>\n\t\t\t\t\t</td>\n\t\t\t\t</tr>\n\t\t\t\t</table>\t\t\t\t\n \t\t\t</FORM></center>";
$main .= make_box($t, $b);
$t = "Change Password";
$b = "<form id=user_pass action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST> \n\t\t\t\tNew Password: <input class=\"validate[required] text-input\" id=n_pass type=password size=16 name=n_pass><br />\n\t\t\t\tConfirm New: <input class=\"validate[required,equals[n_pass]] text-input\" type=password size=16 id=c_pass name=c_pass><br />\n\t\t\t\t<center>\n\t\t\t\t<input type=submit class=submit name=submit value=Update>\n\t\t\t\t<input type=hidden name=modify_pass value=1>\n\t\t\t\t<input type=hidden name=u_id value=" . $myrow['user_id'] . ">\n\t\t\t</center>\n\t\t\t</FORM>";
$main .= make_box($t, $b, "yellow");
// add some logic so parents can receive emails about attendance and reports...
// maybe put this in a new file for parents to manage students...
}
include 'user_setSecretQuestions.php';
}
} else {
$main .= login_error();
}
} elseif ($_POST['attendValue'] == 'Unexcused-Abs' || $_POST['attendValue'] == 'Excused-Abs' || $_POST['attendValue'] == 'Suspended' || $_POST['attendValue'] == 'WBL-Abssent') {
$absRecord['ExtraHours'] = 0;
} else {
$absRecord['ExtraHours'] = $course['minutes'] - $_POST['a_minutes'];
}
if ($absRecord['ExtraHours'] < 0) {
$absRecord['ExtraHours'] = 0;
// just in case a class is shorter than the post minutes....
}
$absRecord['SectionID'] = $course['SectionID'];
//."{".$course['course_name']."}";
$result2 = get_students_for_course($course['course_id']);
//$SMSmsg .= "$ schoolID = ".$schoolID." course = ".$course['course_name']."<br>";
while ($row2 = $result2->fetch_assoc()) {
//$SMSmsg .= displayArray2($row2)."<hr>";
if ($schoolID == $row2['school_id']) {
$absRecord['STGUID'] = $row2['STGUID'];
//."{".$row2['first_name']." ".$row2['last_name']."}";
//array_push($studentList, $absRecord);
$SMSmsg .= $course['course_name'] . " - " . $row2['first_name'] . " " . $row2['last_name'] . "<br>";
$SMSmsg .= updateSMSAttend($absRecord) . "<br />";
//$sql2 = "INSERT into AbsTransactions (".implode(',', array_keys($absRecord)).") VALUES('". implode("','", $absRecord)."')";
}
}
}
}
$main .= make_box("Bulk Attend", $SMSmsg);
}
} else {
$main .= login_error();
}
$table .= "\n <tr class=\"student attendanceStudentRow\">\n <td>\n <input type=hidden name=default_" . $student['user_id'] . "_Minutes id=default_" . $student['user_id'] . "_Minutes value=\"" . $minutes . "\" />\n <input type=hidden id=\"attend_" . $student['user_id'] . "_default\" name=\"attend_" . $student['user_id'] . "_default\" value=\"t\" />\n <span style=white-space:nowrap>\n <input type=\"CHECKBOX\" id=\"attend_" . $student['user_id'] . "_student\" onClick=\"attend_" . $student['user_id'] . "_default.value='f';\"\n name=\"attend_" . $student['user_id'] . "_student\" value=\"" . $student['user_id'] . "\"";
if ($default) {
$table .= " checked=true";
}
$table .= " />";
$table .= $student['first_name'] . " " . stripslashes($student['last_name']) . " - {" . getSchoolNameForSTGUID($student['STGUID']) . "}</span></td>\n";
/** ======================== Begin CheckBox Selects ======================= */
$table .= "\n <td>" . make_attend_array($student['user_id'], $currentStatus) . "</td>";
/** ======================== End CheckBox Selects ======================= */
$table .= "\n <td colspan=2>\n Minutes: <input type=text size=3 class=\"attendMinutes validate[required,custom[integer]]\" name=\"attend_" . $student['user_id'] . "_minutes\"\n id=\"attend_" . $student['user_id'] . "_minutes\"\n onChange=\"attend_" . $student['user_id'] . "_student.checked=true; attend_" . $student['user_id'] . "_default.value='f';\"\n value=\"" . $minutes . "\" />\n </td>\n </tr>";
/** NOTE * */
if ($_SESSION[$_CONF['sess_name'] . '_isOffice'] && $_SESSION[$_CONF['sess_name'] . '_lev'] == 'office') {
$select = makeNoteSelectList($student['user_id'], $noteSelect);
$table .= "\n <tr>\n <td align=right>Note:</td>\n <td colspan=2><span style=white-space:nowrap>" . $select . "\n <input type=text size=60 id=\"attend_" . $student['user_id'] . "_note\" name=\"attend_" . $student['user_id'] . "_note\" value='" . htmlentities($note, ENT_QUOTES) . "' onkeyup=\"\">\n </td>\n </tr>";
} else {
if ($note != '') {
$table .= "\n <tr>\n <td align=right>Note:</td>\n <td colspan=2><span style=\"white-space:nowrap;color:red;\">\n " . htmlentities($note, ENT_QUOTES) . "</span>\n </td>\n </tr>";
}
}
$table .= "\n <tr>\n <td colspan=4 align=center>\n <input type=submit name=send id=send value=Send />\n <input type=hidden name=default value=" . true . " />\n </td>\n </tr>\n ";
$b .= $table;
}
$b .= "\n </table>\n </form>";
if (isset($_POST['send'])) {
include 'attendance.php';
} else {
$main .= make_box($t, $b, $c);
}
} else {
$main .= login_error();
}
$print_blank_button = "\n\t\t\t\t<CENTER>\n\t\t\t\t<FORM action=printview_blankscoresheet.php method=POST target=new name=printview>\n\t\t\t\t<input type=submit class=submit name=submit value=\"Print\" class=\"submit\" /> Blank Score Sheet\n\t\t\t\t</form>";
//$new_assignment ="<a href=teach_addAssign2Gradebook.php?lev=".$_GET['lev']."&cat=".$_GET['cat']." onclick=\"return GB_showCenter('Add Assignment to Gradebook', this.href,400,1000)\">Add Assignment</a></center>";
//$new_assignment ="<a href=teach_addAssign2Gradebook.php?lev=".$_GET['lev']."&cat=".$_GET['cat']." class=\"greybox\" title=\"New Assignment\">Add Assignment</a></center>";
$class = $_SESSION[$_CONF['sess_name'] . '_selected_class'];
$sql = "SELECT term_start_date, term_end_date from terms, classes\n WHERE terms.term_id=classes.term_id AND classes.class_id=" . $class;
$result = $db->query($sql);
$row = $result->fetch_assoc();
$term_start = $row['term_start_date'];
$term_end = $row['term_end_date'];
list($sy, $sm, $sd) = preg_split("/-/", $term_start);
list($ey, $em, $ed) = preg_split("/-/", $term_end);
$new_assignment = "\n <script type='text/javascript'>\n \$(document).ready(\n function() {\n \$('input#a_1_due_date').datepick({\n onDate: \$.datepick.noWeekends,\n dateFormat: 'yyyy-mm-dd',\n minDate: new Date(" . $sy . ", " . ($sm - 1) . ", " . $sd . "),\n maxDate: new Date(" . $ey . ", " . ($em - 1) . ", " . $ed . "),\n numberOfMonths: 1\n }),\n \$('#addAssignForm').validationEngine()\n });\n </script>\n <div id=\"greybox\" class=\"greybox\"></div>\n <div id=\"popup\" class=\"popup\">";
$today = date('Y-m-d');
$sql = "SELECT * from categories where class_id=" . $class;
$result = $db->query($sql);
if ($result) {
while ($row = $result->fetch_assoc()) {
$catList .= "\n\t\t\t\t<option value=" . $row['category_id'] . ">" . $row['category_name'] . " (" . $row['category_weight'] . "%)</option>";
}
}
$new_assignment .= "\n <div id=assignDiv name=assignDiv>\n\t\t<div style=\"text-align:center; font-weight:bold; font-size:20px;\">Term Start: " . $sm . "-" . $sd . "-" . $sy . " Term End: " . $em . "-" . $ed . "-" . $ey . "</div>\n\t\t<center>\n\t\t<form id=\"addAssignForm\" name=\"addAssignForm\" action=" . $_SERVER['PHP_SELF'] . " method=post>\n\t\t<table cellspacing=1 cellpadding=3 border=0 bgcolor=black border=0>";
$new_assignment .= "\n\t\t<tr>\n <th align=right>Name</th>\n\t\t\t<td>\n\t\t\t\t<input class=\"validate[required]\" type=text size=30 id=a_1_assignment_name name=a_1_assignment_name />\n\t\t\t</td>\n </tr>\n <tr>\n <th align=right>Category</th>\n\t\t\t<td>\n\t\t\t\t<select id=a_1_category_id name=a_1_category_id>" . $catList . "</select>\n\t\t\t</td>\n </tr>\n <tr>\n <th align=right>Due Date</th>\n\t\t\t<td>\n\t\t\t\t<input class=\"validate[required,custom[date]]\" type=text size=15 id=a_1_due_date name=a_1_due_date value=" . $today . " />\n\t\t\t</td>\n </tr>\n <tr>\n <th align=right>Max Score</th>\n\t\t\t<td>\n\t\t\t\t<input class=\"validate[required,custom[number]]\" type=text size=5 id=a_1_max_score name=a_1_max_score value=100 />\n\t\t\t</td>\n </tr>\n <tr>\n <th align=right>Weight</th>\n\t\t\t<td>\n\t\t\t\t<input class=\"validate[required,custom[number]]\" type=text size=5 id=a_1_weight name=a_1_assignment_weight value=1 />\n\t\t\t</td>\n </tr>\n <tr>\n <th align=right>Extra Credit?</th>\n <td>\n <input class=\"validate[required] radio\" type=radio id=a_1_isExtraCredit name=a_1_isExtraCredit value='Y'>Y \n <input class=\"validate[required] radio\" type=radio id=a_1_isExtraCredit name=a_1_isExtraCredit value='N' checked=\"checked\">N\n </td>\n\t\t</tr>\n\t\t<tr>\n\t\t\t<th align=right>Note</th>\n <td><input type=text size=50 name=a_1_assignment_note /></td>\n\t\t</tr>";
$new_assignment .= "\n\t\t</table>\n\t\t<input type=submit class=submit id=insertAssign name=insertAssign value=Insert />\n\t\t</center>\n </div><!-- end assignDiv -->";
$new_assignment .= "\n <input type=button id=close name=close value=Close />\n </form>\n </div><!-- end pouup div -->\n <div id=\"newAssignPopupDiv\" class=\"newAssignPopupDiv\">\n <input type=submit id=\"newAssignPopup\" name=\"newAssignPopup\" value=\"New Assignment\" />\n </div>";
$b .= "<br />" . $print_gradebook_button . $print_blank_button . $new_assignment;
$main .= make_box($t, $b);
}
/** end if class_id and term_id **/
} else {
$main .= login_error();
}
$t = "ERROR...";
$b = "That information does not match what is in out database. Please check the spelling and punctuation and try again.\n\t\t\t\t\t\t<CENTER>\n\t\t\t\t\t\t<FORM action=" . $_SERVER['PHP_SELF'] . "?lev=" . $_GET['lev'] . "&cat=" . $_GET['cat'] . " method=post>\n\t\t\t\t\t\t<input type=submit class=submit name=submit value=OK>\n\t\t\t\t\t\t</FORM>\n\t\t\t\t\t\t</CENTER>";
$main .= "<br />" . make_box($t, $b, "red");
}
} else {
$sql2 = "SELECT question from secret_question where question_id=" . $row['secret_question1'];
$result2 = mysql_query($sql2);
$row2 = mysql_fetch_assoc($result2);
$secret_question1 = $row2['question'];
$sql3 = "SELECT question from secret_question where question_id=" . $row['secret_question2'];
$result3 = mysql_query($sql3);
$row3 = mysql_fetch_assoc($result3);
$secret_question2 = $row3['quesiton'];
$t = "Forgot Password Screen";
$b = " This screen is used to reset your password.<br />\n\t\t\t\t\t A random password will be generated and sent you the email address\n\t\t\t\t\t we have on file for you.<br /> Please provide the answer to secret question.<br />\n\t\t\t\t\t\t <FORM action=" . $_SERVER['PHP_SELF'] . "?lev=" . $_GET['lev'] . "&cat=" . $_GET['cat'] . " method=POST>";
$main .= "<br />" . make_box($t, $b);
$t = "";
$b .= "\n\t\t\t\t\t\t <TABLE width=80% bgcolor=white border=0>\n\t\t\t\t\t\t <TR>\n\t\t\t\t\t\t\t <TD align=right>Username :</TD> \n\t\t\t\t\t\t\t <TD align=left><B>" . $_POST['f_username'] . "</B>\n\t\t\t\t\t\t </TD>\n\t\t\t\t\t\t </TR>\n\t\t\t\t\t\t <TR>\n\t\t\t\t\t\t\t <TD colspan=2>Your Secret Question #1 is...<br /><B>" . $secret_question1 . "</B></TD>\n\t\t\t\t\t\t </TR>\n\t\t\t\t\t\t <TR>\n\t\t\t\t\t\t\t <TD align=right>Answer # 1 : </TD>\n\t\t\t\t\t\t\t <TD align=left><INPUT type=password size=20 name=secret_answer1>\n\t\t\t\t\t\t </TD>\n\t\t\t\t\t\t </TR>\n\t\t\t\t\t\t <TR>\n\t\t\t\t\t\t\t <TD colspan=2>Your Secret Question #2 is ...<br /><B>" . $secret_question2 . "</B></TD>\n\t\t\t\t\t\t </TR>\n\t\t\t\t\t\t <TR>\n\t\t\t\t\t\t\t <TD align=right>Answer # 2 :</TD>\n\t\t\t\t\t\t\t <TD align=left><INPUT type=password size=20 name=secret_answer2></TD>\n\t\t\t\t\t\t </TR>\n\t\t\t\t\t\t <TD align=center colspan=2>\n\t\t\t\t\t\t\t<input type=submit class=submit name=reset_pass value=Submit>\n\t\t\t\t\t\t\t<INPUT type=hidden name=f_username value=" . $_POST['f_username'] . ">\n\t\t\t\t\t\t </TD>\n\t\t\t\t\t\t </TABLE>\n\t\t\t\t\t\t </FORM>";
$main .= "<br />" . make_box($t, $b, "yellow");
}
} else {
$t = "ERROR...";
$b = "Your account is not configured to allow you to request a password change.<br />\n\t\t\t\t\tYou must have selected 2 secret questions and provided the answers to those questions. Please\n\t\t\t\t\tcontact the webmaster.\n\t\t\t\t\t<CENTER>\n\t\t\t\t\t<FORM action=" . $_SERVER['PHP_SELF'] . " method=POST>\n\t\t\t\t\t<input type=submit class=submit name=submit value=OK>\n\t\t\t\t\t</FORM>\n\t\t\t\t\t</CENTER>";
$main .= "<br />" . make_box($t, $b, "red");
}
}
} else {
$t = "Reset Password Screen";
$b = "Please enter your username<br />\n\t\t\t<FORM action=" . $_SERVER['PHP_SELF'] . "?lev=" . $_GET['lev'] . "&cat=" . $_GET['cat'] . " method=POST>\n\t\t\tUsername : <INPUT type=text size=20 name=f_username>\n\t\t\t<input type=submit class=submit name=submit value=Submit>\n\t\t\t</FORM>";
$main .= "<br />" . make_box($t, $b, "yellow");
}
}
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>";
/** end page_head_separator **/
if ($_SESSION[$_CONF['sess_name'] . '_logged_in']) {
include 'user_main.php';
} else {
if (isset($_POST['login'])) {
$t = "ERROR";
$b = $loginError['error_mesg'];
$login_error = make_box($t, $b, "red");
}
include 'default_main.php';
}
$end = microtime_float();
$footer = "\t\t\r\n<div id=\"page_footer\">Copyright © 2001 - " . date('Y') . " M. Knichel & E. Maassmann<br />\r\n\tAll trademarks and copyrights on this page are owned by their respective owners.<br />\r\n\tThis page took " . round($end - $start, 4) . " seconds to create.<br>\r\n<!--a href=\"https://ssl.comodo.com\">\r\n\t<img src=\"https://ssl.comodo.com/images/comodo_secure_76x26_white.png\" alt=\"SSL\" width=\"76\" height=\"26\" style=\"border: 0px;\">\t<!--span style=\"font-weight:bold; font-size:7pt\">SSL</span-->\r\n</a-->\r\n</div>\r\n</body>\r\n</html>";
$header = $download_header . $header;
$page = $header . $main . $footer;
echo $page;
ob_end_flush();
$termName = $row['term_name'];
$teacherName = $row['first_name'] . " " . $row['last_name'];
}
$sid = -1;
if (isset($_SESSION[$_CONF['sess_name'] . '_selected_student'])) {
$sid = $_SESSION[$_CONF['sess_name'] . '_selected_student'];
$sql = "SELECT first_name, last_name FROM user WHERE user_id=" . $sid;
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);
$studentFirstName = $row['first_name'];
$studentLastName = $row['last_name'];
//print $sql."<br />".$studentFirstName.$studentLastName."<br /.";
}
$print_button = "";
$t = "Student Progress Reports";
// for : ".$fname." ".$lname;
$b = "<FORM action=" . $_SERVER['PHP_SELF'] . "?lev=" . $_GET['lev'] . "&cat=" . $_GET['cat'] . " method=POST name=classes>\n\t\t\t<center>" . teacher_class_list($_SESSION[$_CONF['sess_name'] . '_myUID'], $cid, 'class', "classes") . "</center></form>";
if ($sid != -1) {
$b .= "<FORM action=" . $_SERVER['PHP_SELF'] . "?lev=" . $_GET['lev'] . "&cat=" . $_GET['cat'] . " method=POST name=studentClasses>";
$b .= "<center>" . student_class_list($sid, $cid, 'class', "studentClasses") . "</center>";
$b .= "</form>";
}
$main .= "<br />" . make_box($t, $b);
if ($sid != -1) {
include 'progress_report.php';
}
} else {
$t = "Message...";
$b = "You do not have enogh access for this area.";
$main .= "<br />" . make_box($t, $b, "red");
}
}
$main .= make_box($t, $b, $bc);
}
if (isset($_POST['delete_year'])) {
$sql = "SELECT * from terms WHERE term_id=" . $_POST['term_id'];
$result = $db->query($sql);
$row = $result->fetch_assoc();
$t = "Warning...";
$bc = "red";
$b = "You have chosen to delete term...\n\t\t\t\t\tWeight = " . $row['term_weight'] . "<br />\n\t\t\t\t\tStart = " . $row['term_start_date'] . " <br />\n\t\t\t\t\tEnd = " . $row['term_end_date'] . "<br />\n\t\t\t\tAre you sure?<br />Deleting a term will also delete any classes and grades associated with that term!!!<br /></FONT><center>\n\t\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\t<input type=submit class=submit name=really_delete_term value=Delete>\n\t\t\t\t<input type=submit class=submit name=cancel value=Cancel>\n\t\t\t\t<INPUT type=hidden name=term_id value=" . $_POST['term_id'] . ">\n\t\t\t\t</FORM>";
$main .= make_box($t, $b, $bc);
}
/**
Now list the School Years.
**/
$sql = "SELECT * from school_years \n\t\t\t\t\tORDER by startDate asc";
$result = $db->query($sql);
$bc = "blue";
$t1 = "School Years for " . $_SESSION[$_CONF['sess_name'] . '_myfName'] . " " . $_SESSION[$_CONF['sess_name'] . '_mylName'];
$b1 = "\n\t\t\t<center>\n\t\t\t<table border=0 bgcolor=black cellspacing=1 cellpadding=3>\n\t\t\t<tr>\n\t\t\t\t\t<td colspan=4><form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST><span style=white-space:nowrap>I would like to add <input type=text size=3 name=numTerms /> terms\t\t\t \n\t\t\t\t\t<input type=submit class=submit name=addTerms value=Go />\n\t\t\t\t\t</form></span>\n\t\t\t</tr>\n\t\t\t<TR>\n\t\t\t\t<TH bgcolor=white>Year ID</TH>\n\t\t\t\t<TH bgcolor=white>Start Date</TH>\n\t\t\t\t<TH bgcolor=white>End Date</TH>\n\t\t\t\t<TH bgcolor=white valign=bottom> </TH>\n\t\t\t</TR>";
if ($result) {
while ($myrow = $result->fetch_assoc()) {
$b1 .= "\n\t\t\t\t\t<TR>\n\t\t\t\t\t\t<TD bgcolor=white><span style=white-space:nowrap>" . $myrow['school_year_id'] . "</span></TD>\n\t\t\t\t\t\t<TD bgcolor=white><span style=white-space:nowrap>" . $myrow['startDate'] . "</span></TD>\n\t\t\t\t\t\t<TD bgcolor=white><span style=white-space:nowrap>" . $myrow['endDate'] . "</span></TD>\n\t\t\t\t\t\t<TD bgcolor=white><span style=white-space:nowrap>\n\t\t\t\t\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\t\t\t\t<input type=submit class=submit name=addTerms value=Edit />\n\t\t\t\t\t\t\t<input type=submit class=submit name=delete_year value=Delete />\n\t\t\t\t\t\t\t<INPUT type=hidden name=year_id value=" . $myrow['school_year_id'] . " />\n\t\t\t\t\t\t\t</FORM></span>\n\t\t\t\t\t</TR>";
}
}
$b1 .= "</table></center>";
// $b="<center>".$b."</center>";
$main .= make_box($t1, $b1, $bc);
} else {
$main .= login_error();
}
$t = "Error";
$b = "The assignment could not be added.<br /><br />\n Please contact the site administrator.";
$bc = "red";
}
$main .= "<center><br />" . make_box($t, $b, $bc) . "</center>";
} else {
$today = date('Y-m-d');
$sql = "SELECT * from categories where class_id=" . $class;
$result = $db->query($sql);
if ($result) {
while ($row = $result->fetch_assoc()) {
$catList .= "\n <option value=" . $row['category_id'] . ">" . $row['category_name'] . " (" . $row['category_weight'] . "%)</option>";
}
}
$t = "Class Assignments";
$bc = "blue";
$b = "\n <div style=text-align:center>Term Start: " . $sm . "-" . $sd . "-" . $sy . " Term End: " . $em . "-" . $ed . "-" . $ey . "</div>\n <center>\n <form id=\"addAssign\" name=\"addAssign\" action=" . $_SERVER['PHP_SELF'] . " method=post>\n <table cellspacing=1 cellpadding=3 border=0 bgcolor=black border=0>\n <tr>\n <th>Name</th><th>Category</th><th>Due Date</th><th>Max Score</th><th>Weight</th><th>Extra Credit</th>\n </tr>";
$b .= "\n <tr>\n <td>\n <input class=\"validate[required]\" type=text size=30 id=a_1_name name=a_1_name />\n </td>\n <td>\n <select id=a_1_category_id name=a_1_category_id>" . $catList . "</select>\n </td>\n <td>\n <input class=\"validate[required,custom[date]]\" type=text size=15 id=a_1_due_date name=a_1_due_date value=" . $today . " />\n </td>\n <td>\n <input class=\"validate[required,custom[number]]\" type=text size=5 id=a_1_max_score name=a_1_max_score value=100 />\n </td>\n <td>\n <input class=\"validate[required,custom[number]]\" type=text size=5 id=a_1_weight name=a_1_weight value=1 />\n </td>\n <td>\n <input class=\"validate[required] radio\" type=radio id=a_1_isExtraCredit name=a_1_isExtraCredit value='Y'>Y \n <input class=\"validate[required] radio\" type=radio id=a_1_isExtraCredit name=a_1_isExtraCredit value='N' checked=\"checked\">N\n </td>\n </tr>\n <tr>\n <td colspan=5>Note:<input type=text size=100 name=a_1_assignment_note /></td>\n </tr>";
$b .= "\n </table>\n <input type=hidden name=numAssigns value=1 />\n <input type=submit class=submit name=insertAssign value=Insert />\n </center>\n </form>";
$main .= "<br /><center>" . make_box($t, $b, $bc) . "</center>";
}
} else {
$main .= login_error();
}
} else {
$main .= login_error();
}
$main .= "\n<br /><br /><br /><br />\n</body>\n</html>";
print $main;
?>
}
}
// end if isset class_id
$main .= make_box($t, $b);
/**
* Now lets get past commnets for BOTH interim and grading period and display them in Term Order
*/
if ($pastComments) {
$pastCommentsList = make_assoc_array_from_sql($pastComments, 'class_id', 'my');
//displayArray($pastCommentsList);exit;
$past = '';
foreach ($pastCommentsList as $classComment) {
$class = $_SESSION[$_CONF['sess_name'] . '_teacherClassList'][$classComment['class_id']];
//$past = displayArray2($class);
//$past = displayArray2($classComment);
$past .= "<span class='comment-title'>Class</span>: " . $class['course_name'] . " ~ " . $class['term_name'] . "<br>";
$past .= "<span class='comment-title'>Student</span>: " . $Quality[$classComment['interimQuality']] . "<br>";
$past .= "<span class='comment-title'>Student Needs Improvement In</span>: " . $Quality[$classComment['interimImprovement']] . "<br>";
$intImpList = explode(",", $classComment['interimImprovement']);
foreach ($intImpList as $ii) {
$past .= "   -" . $Improvement[$ii] . "<br>";
}
$past .= "<span class='comment-title'>Interim Comment</span>: " . $classComment['interimComment'] . "<br>";
$past .= "<span class='comment-title'>Grade Comment</span>: " . $classComment['gradeComment'] . "<br>";
$past .= "<hr width=70% style='margin-left:40px; margin-top:20px;margin-bottom:20px;'>";
}
$main .= make_box('Past Comments', $past);
}
} else {
$main .= login_error();
}
} elseif (isset($_POST['delete'])) {
$t = "Warning...";
$b = "You have chosen to delete the following users...<br>";
$sql = "SELECT user_id, first_name, last_name,isAdmin from users where user_id=" . $_POST['u_id'];
$result = $db->query($sql);
$row = $result->fetch_assoc();
//$main .=$row[1]." ".$row[2]."<br>";
if ($row['isAdmin'] == 'Y') {
$b .= "You are not allowed to delete someone with Admin privileges.";
} else {
$b .= $row['first_name'] . " " . $row['last_name'] . "<br />\n\t\t\t<B>This will delete all records associated with this user!</B><br>\n\t\t\tAre you sure?<center>\n\t\t<form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=post>\n\t\t<input type=submit class=submit name=really_delete value=Yes>\n\t\t\t<input type=submit class=submit name=nope value=No>\n\t\t\t<input type=hidden name=u_id value=" . $row['user_id'] . ">\n\t\t</form></center>";
}
$main .= make_box($t, $b, "yellow");
} else {
}
/** Display all users **/
$t = "User Management";
$b = "\n<center>\n<table border=0 bgcolor=white cellspacing=0 cellpadding=3>\n<tr>\n<TH>" . $user_list_title . "</TH>\n<TH> </TH>\n<TH colspan=2>\n<!--form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST name=userList-->\n<input type=submit class=submit id=\"showNewUser\" name=\"showNewUser\" value=New>\n<!--/form--></TH>\n</tr>\n<tr>\n<td colspan=4>";
$list = $ActiveUsers;
$b .= "\n<form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST name=userListA>" . make_selection_list($list, $uid, 'u_id', 'userListA', $selectWhat, 'on') . "\n</form>\n</td></tr>\n</table>\n</center>";
$main .= make_box($t, $b);
/** Display Inactive users **/
$list = $InactiveUsers;
if (sizeof($list)) {
$t = "Inactive User Management";
$b = "\n\t<center>\n\t<table border=0 bgcolor=white cellspacing=0 cellpadding=3>\n\t<tr>\n\t<TH>" . $user_list_title . "</TH>\n\t</tr>\n\t<tr>\n\t<td>\n\t<form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST name=userListI>" . make_selection_list($list, $uid, 'u_id', 'userListI', $selectWhat, 'on') . "\n\t</form>\n\t</td>\n\t</tr>\n\t</table>\n\t</center>";
$main .= make_box($t, $b, 'yellow');
}
} else {
$main .= login_error();
}
<?php
if ($_SESSION[$_CONF['sess_name'] . '_isGuidance']) {
$t = "Sync With SMS";
$body = "\n\n <center>\n <table>\n <tr>\n <td>\n <form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=post name=syncGradesForm id=syncGradesForm>\n <input type=submit name=syncGrades id=syncGrades value=\"Sync Grades Now\">\n </form>\n </td>\n </tr>\n </table>\n </center>\n ";
$main .= make_box($t, $body) . "<br>";
if (isset($_POST['syncGrades'])) {
$runByWeb = true;
include '/usr/local/q3ait/crons/pushGradesToSMS.php';
}
} else {
$main .= login_error();
}
<?php
if ($_SESSION[$_CONF['sess_name'] . '_isStudent']) {
$sid = $_SESSION[$_CONF['sess_name'] . '_myUID'];
$fname = $_SESSION[$_CONF['sess_name'] . '_myfName'];
$lname = $_SESSION[$_CONF['sess_name'] . '_mylName'];
$t = $fname . " " . $lname;
$studentFirstName = $fname;
$studentLastName = $lname;
/**
$print_button ="
<CENTER>
<FORM action=printview_progressreport.php method=POST target=new name=printview>
<input type=submit class=submit name=submit value=\"Print View\">
</form>
</CENTER>";
$b="<FORM action=index.php?lev=".$_SESSION[$_CONF['sess_name'].'_lev']."&cat=".$_SESSION[$_CONF['sess_name'].'_cat']." method=POST name=classes>
<center>".make_selection_list(get_student_class_list($sid),$cid,'class_id','classes','Class','on')."</center></form>";
$main .= make_box($t,$b);
**/
$b = "";
include 'multiClassProgress_report.php';
$report = $b;
//.$print_button;
$main .= make_box($t, $report);
} else {
$main .= login_error();
}
}
echo $err_msg;
continue;
}
# look for the page by name
# need to check behavior on alternate namespaces
$title = Title::newFromText($data['page_name']);
if (!$title->exists() || get_wiki_text($data['page_name']) == '') {
# page doesn't exist yet; add a temporary page to create a page_uid
echo "adding a page for " . $data['page_name'] . "\n";
$article = new Article($title);
if (!$title->exists()) {
$article->doEdit('placeholder', 'Added by wikibot to create page id', EDIT_NEW | EDIT_FORCE_BOT);
}
# make the table
$box_text = make_box($data['page_name'], $data['table_template'], $data);
# this adds the data too.
$new_page = str_replace("{{{" . strtoupper($data['table_template']) . "}}}", $box_text, $page_template_text);
$article->doEdit($new_page, 'Added by wikibot', EDIT_UPDATE | EDIT_FORCE_BOT);
$change_count++;
echo "{$line_count} lines processed: " . $data['page_name'] . " is item {$change_count}\n";
} else {
# page already exists. Find the desired box
echo $data['page_name'] . " already exists\n";
$box_id = get_wikibox_id($data['page_name'], $data['table_template']);
$box_uid = get_wikibox_uid($box_id);
$box = new wikiBox();
$box->box_uid = $box_uid;
$box->template = $data['table_template'];
$box->set_from_DB();
$rows = get_wikibox_rows($box, $uid, $data['metadata']);
$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 .= " />AM\n <input class=\"validate[required] radio\" radio type=radio name=session id=session value='PM' ";
if ($sess == 'PM') {
$b .= " checked=true";
}
$b .= " />PM\n <input class=\"validate[required] radio\" radio type=radio name=session id=session value='BOTH' ";
if ($sess == 'BOTH') {
$b .= " checked=true";
}
$b .= " />BOTH</td></tr>\n <tr><td colspan=2 align=center><input type=submit id=hoursBySchool name=hoursBySchool value=\"Get\" /></td></tr>\n </table>\n </div>\n </form>\n </center>\n ";
$main .= make_box($t, $b) . "<br />";
if (isset($_POST['hoursBySchool'])) {
include 'hoursReport.php';
}
} else {
$main .= login_error();
}
$lev = $_SESSION[$_CONF['sess_name'] . '_lev'] = $_POST['lev'];
unset($_POST['lev']);
$cat = $_SESSION[$_CONF['sess_name'] . '_cat'] = $_POST['cat'];
unset($_POST['cat']);
$test = array('html' => 'Cat = ' . $cat . " & Lev = " . $lev);
//echo json_encode($test); exit;
$getFile = "../" . $lev . "_" . $cat . ".php";
$debug = '';
//don't uncomment below until I add logic to allow only me to see it.
if ($_CONF['debug'] && $_SESSION[$_CONF['sess_name'] . '_myUID'] == 1) {
$sesvars = displayArray2($_SESSION);
$t = "Session Variables";
$debug .= make_box($t, $sesvars, "yellow");
$CONFvars = displayArray2($_CONF);
$t = "CONF Variables";
$debug .= make_box($t, $CONFvars, "yellow");
$postvars = displayArray2($_POST);
$t = "Post Variables";
$debug .= make_box($t, $postvars, "yellow");
//$servvars = displayArray2($_SERVER);
$svars = $_SERVER;
unset($svars['HTTP_COOKIE']);
$servvars = displayArray2($svars);
$t = "Server Variables";
$debug .= make_box($t, $servvars, "yellow");
//$main .= $debug;
}
include $getFile;
$return = array('error' => false, 'error_msg' => $vars, 'html' => $main, 'debug' => $debug);
echo json_encode($return);
}
/**
* Display error message for incorrect login and/or session timeout.
*
* @global mixed $_CONF
* @return string HTML error string.
*/
function login_error()
{
global $_CONF;
$t = "Message...";
$redirectTo = $_SERVER['HTTP_ORIGIN'] . $_SERVER['SCRIPT_NAME'];
$b1 = "You do not have enough access for this area.<br />\r\n\tClick <a href=" . $_CONF['site_url'] . "> here </a> to login.";
$b2 = "You do not have enough access for this area.<br />\r\n\tClick <a href=" . $redirectTo . "> here </a> to login.";
$ret .= "<br />" . make_box($t, $b1, "red");
return $ret;
}
$b = "\n\t\t\t\t<center>\n\t\t\t\t<TABLE border=0 bgcolor=white cellspacing=1 cellpadding=3>\n\t\t\t\t<tr>\n\t\t\t\t\t<td colspan=5>\n\t\t\t\t\t<form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST><span style=white-space:nowrap>I would like to add <input type=text size=3 name=numAssigns /> assignments to this class.</td><td>\n\t\t\t\t\t<input type=hidden class=submit id=\"class_id\" name=\"class_id\" value=" . $classID . " />\n\t\t\t\t\t<input type=submit class=submit id=\"addAssigns\" name=addAssigns value=Add />\n\t\t\t\t\t</form></span></td>\n\t\t\t\t</tr>";
if ($numAssigns > 0) {
$b .= "\n\t\t\t\t<TR>\n\t\t\t\t\t<TH bgcolor=white>Name</TH>\n\t\t\t\t\t<TH bgcolor=white>Category</TH>\n\t\t\t\t\t<TH bgcolor=white>Due Date</TH>\n\t\t\t\t\t<TH bgcolor=white>Max Score</TH>\n\t\t\t\t\t<TH bgcolor=white>Weight</TH>\n\t\t\t\t\t<th bgcolor=white> </th>\n\t\t\t\t</TR>";
while ($row = $result->fetch_assoc()) {
$b .= "\n\t\t\t\t\t<TR>\n\t\t\t\t\t\t<td bgcolor=white><span style=white-space:nowrap>" . $myrow['assignment_name'] . "</span></td>\n\t\t\t\t\t\t<td bgcolor=white><span style=white-space:nowrap>" . $myrow['category_name'] . "</span></td>\n\t\t\t\t\t\t<td bgcolor=white><span style=white-space:nowrap>" . $myrow['due_date'] . "</span></td>\n\t\t\t\t\t\t<td bgcolor=white><span style=white-space:nowrap>" . $myrow['max_score'] . "</span></td>\n\t\t\t\t\t\t<td bgcolor=white><span style=white-space:nowrap>" . $myrow['assignment_weight'] . "</span></td>\n\t\t\t\t\t\t<td bgcolor=white><span style=white-space:nowrap>\n\t\t\t\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\t\t\t<input type=submit class=submit name=edit_assign value=Edit>\n\t\t\t\t\t\t<input type=hidden name=numAssigns value=1 />\n\t\t\t\t\t\t<input type=submit class=submit name=delete_assign value=Delete>\n\t\t\t\t\t\t<INPUT type=hidden name=assignment_id value=" . $myrow['assignment_id'] . ">\n\t\t\t\t\t\t</FORM></span>\n\t\t\t\t\t</TR>";
}
$b .= $copyALL;
} else {
$t = "Warning";
$bc = "yellow";
$b .= $copyALL;
}
$b .= "</table></center>";
$main .= "<br />" . make_box($t, $b, $bc);
} else {
$bc = "red";
$t = "Error...";
$b = "You must first create categories for this class before entering assignments.";
$b .= "You have 3 options...<br />";
$b .= "<table border=0 cellspacing=0 cellpadding=3>\n\t\t\t\t\t<tr><td colspan=5>Proceed to add a category</td><td>\n\t\t\t\t\t<form action=" . $_SERVER['PHP_SELF'] . "?lev=" . $_GET['lev'] . "&cat=category method=POST>\n\t\t\t\t\t<input type=submit class=submit name=go value=OK />\n\t\t\t\t\t</form></td></tr>";
$b .= "<tr><td colspan=6 align=center>OR</td></tr>";
$b .= "<tr><td colspan=5>Copy categories from prior term</td><td>\n\t\t\t\t\t<form action=" . $_SERVER['PHP_SELF'] . "?lev=" . $_GET['lev'] . "&cat=category method=POST>\n\t\t\t\t\t<input type=submit class=submit name=copy_from value=OK />\n\t\t\t\t\t</form></td></tr>";
$b .= "<tr><td colspan=6 align=center>OR</td></tr>";
$b .= $copyALL . "</table>";
$main .= "<br />" . make_box($t, $b, $bc);
}
}
/** end if class_id and term_id **/
} else {
$main .= login_error();
}
/** 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";
$result = $db->query($sql);
$parent = "<tr><td> </td></tr>\n\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<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<td bgcolor=white valign=middle rowspan=4>\n\t\t\t\t\t\t\t<form action=teach_sendmail.php method=post target=new>\n\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<input type=hidden name=parents value=" . urlencode(serialize(array($myrow['user_id']))) . ">\n\t\t\t\t\t\t\t<input type=hidden name=teacher_id value=" . $tid . ">\n\t\t\t\t\t\t\t</form>\n\t\t\t\t\t\t\t</td></tr>\n\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<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<tr><td bgcolor=white align=right><b>Phone :</b></td><td bgcolor=white>" . $myrow['phone'] . "</td></tr>";
}
} else {
$parent .= "<tr><td> </td></tr>\n\t\t\t\t\t\t<tr><td bgcolor=white colspan=2>There is no parent information on file for this student</td></tr>";
}
$sql = "SELECT users.user_id, users.first_name, users.last_name, users.email, users.phone \n\t\t\t\t\tFROM users\n\t\t\t\t\tWHERE user_id=" . $sid;
$result = $db->query($sql);
$myrow = $result->fetch_assoc();
$student = "<tr><td> </td></tr>\n\t\t\t\t\t<tr><th colspan=2>Student Contact Info</th></tr>\n\t\t\t\t\t<tr><td bgcolor=white align=right><b>First :</b></td><td bgcolor=white>" . $myrow['first_name'] . "</td></tr>\n\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<tr><td bgcolor=white align=right><b>E-mail :</b></td><td bgcolor=white>" . $myrow['email'] . "</td></tr>\n\t\t\t\t\t<tr><td bgcolor=white align=right><b>Phone :</b></td><td bgcolor=white>" . $myrow['phone'] . "</td></tr>";
$t = "Contact Information";
$b .= "<table border=0 bgcolor=white cellspacing=1 cellpadding=3>";
$b .= $school_names . $parent . $student;
$b .= "</table>";
}
/** end if student **/
}
/** end if isset $_POST[check_by] **/
$b = "<center>" . $b . "</center>";
$main .= "<br />" . make_box($t, $b);
if (substr($queryValues, 0, 1) == ',') {
$queryValues = ltrim($queryValues, ',');
}
/**
CHANGE TO USE INSERT INTO.... ON DUPLICATE KEY UPDATE FIELD=VALUE...
IMPORTANT : when admin sending, ignore the teacher fields and visa versa...
**/
$query = "INSERT into incident_referrals (" . $queryFields . ") values(" . $queryValues . ")\n ON DUPLICATE KEY\n UPDATE ";
foreach ($q as $f => $v) {
$query .= $f . "='" . $v . "',";
}
$query = rtrim($query, ',');
print $query;
$result = $db->query($query);
$body .= "\n <center>\n <form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST name=referral>\n <input type=submit class=\"submit\" name=finished value=\"OK\" />\n </form>\n </center>";
$form = make_box($title, $body, "yellow");
} else {
/** Must be a new or open existing... **/
$form = "";
$form .= $validate . "\n <center>\n <form action=" . $_SERVER['PHP_SELF'] . "?" . $_SERVER['QUERY_STRING'] . " method=POST onSubmit=\"return validateForm(this);\">\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"2\" bgcolor=\"#000000\">";
if (isset($_POST['incident_referral_id'])) {
$sql = "SELECT * from incident_referrals where incident_referral_id=" . $_POST['incident_referral_id'];
$result = $db->query($sql);
$row = $result->fetch_assoc();
$sid = $row['student_id'];
$cid = $row['course_id'];
$tid = $row['teacher_id'];
$referral_date = $row['referral_date'];
list($referral_year, $referral_month, $referral_day) = preg_split("/-/", $row['referral_date']);
/**
Now set the values of the form elements to the values retrieved from the db
