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