} } $b .= "<td> " . (int) ($minutes / 60) . ":" . sprintf("%02d", $minutes % 60) . "</td></tr>"; } } $b .= "</table>\n </center>"; $main .= make_box($t, $b); } elseif (isset($_POST['hoursBySchool'])) { /** Hours By School **/ $result = get_students_for_district($_POST['school_id']); $students = make_assoc_array_from_sql($result, "user_id", "my"); $t = "Student WBL Hours Report"; $b = "\n <center>\n <table>\n "; foreach ($students as $sid => $student) { $sname = $uname; $loc = get_student_core_class_list($sid); foreach ($loc as $cid => $cname) { $minutes = 0; $att = array(); if (isset($_POST['year'])) { //$att = array_merge($att,getSMSStudentAttendance($sid,$cid, $_POST['year'],$_SESSION[$_CONF['sess_name'].'_myCenter'])); $att = array_merge($att, get_student_attendance($sid, $cid, $_POST['year'], $_SESSION[$_CONF['sess_name'] . '_myCenter'])); } else { //$att = array_merge($att,getSMSStudentAttendance($sid,$cid, $_SESSION[$_CONF['sess_name'].'_current_school_year'],$_SESSION[$_CONF['sess_name'].'_myCenter'])); $att = array_merge($att, get_student_attendance($sid, $cid, $_SESSION[$_CONF['sess_name'] . '_current_school_year'], $_SESSION[$_CONF['sess_name'] . '_myCenter'])); } foreach ($att as $a => $i) { foreach ($i as $d => $info) { $minutes += $info['minutes']; } }
/** * This Function is used for parents and students to print the attendance so they can see different courses. * * @global mixed $_CONF * @param int $sid * @param int $tid * @return Array {course_name => array{course_id=>course_name-term_id}} */ function get_student_classes_for_attendance($sid, $tid = -1) { global $_CONF; global $db; $core = get_student_core_class_list($sid, $tid); $ret = array(); foreach ($core as $cid => $cname) { ${$cname} = array(); $sql = "SELECT courses.course_id, courses.course_name, classes.term_id\r\n\t\tFROM courses , classes\r\n WHERE courses.school_year_id=" . $_SESSION[$_CONF['sess_name'] . '_current_school_year'] . "\r\n AND courses.course_id ='" . $cid . "'\r\n\t\tAND courses.isCore='Y'"; $result = $db->query($sql); while ($row = $result->fetch_assoc()) { ${$cname}[$row['course_id']] = $row['course_name'] . "::" . $row['term_id']; } $ret[$cname] = ${$cname}; } return $ret; }
<?php /** TEACHER CAN BEGIN EDITING FROM HERE, ALL OTHERS ONLY VIEW **/ $teacher_display .= "\n <tr bgcolor=\"#FFFFFF\">\n <td>\n <table width=\"100%\" border=\"0\" cellspacing=0 cellpadding=0 bgcolor=\"#FFFFFF\">\n <tr>\n <td align=\"left\" valign=top>\n <span style=\"font-size:14px;font-weight:bold\">Teacher:</span> " . $tfName . " " . $tlName . "<br />\n <span style=\"font-size:14px;font-weight:bold\">Student:</span> " . $sfName . " " . $slName . "<br />\n <span style=\"font-size:14px;font-weight:bold\">District:</span> " . $sDistrict . "<br />\n </td>\n <td align=\"left\" valign=top>\n <span style=\"font-size:14px;font-weight:bold\">Course: " . $course . "</span><br />\n <span style=\"font-size:14px;font-weight:bold\">Date: {$referral_date}</span><br />\n <span style=\"font-size:14px;font-weight:bold\">Time: {$referral_time}</span><br />\n </td>\n \n </tr>\n <tr>\n <td colspan=2><div class=\"displayTextHeading\">Description:</div>\n <div class=\"displayTextArea\" style=\"height:20px;\">" . $teach_refer_desc . "</div>\n </td>\n </tr>\n </table>\n </td>\n </tr>\n <tr bgcolor=\"#FFFFFF\">\n <td><div class=\"displayTextHeading\">Nature of Incident:</div>\n <div class=\"displayTextArea\">" . $teach_incident_notes . "</div></td>\n </tr>\n <tr bgcolor=\"#FFFFFF\">\n <td>\n <table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" bgcolor=\"#FFFFFF\">\n <tr>\n <td colspan=\"2\" class=\"blue-title\"><div class=\"displayTextHeading\">Action Taken By Teacher Preceding Referral:</div></td>\n </tr>\n <tr>\n <td><div class=\"displayTextHeading\">Warning Issued/Verbal:</div></td>\n <td><div>" . $teach_refer_warn_date . "</div></td>\n </tr>\n <tr>\n <td><div class=\"displayTextHeading\">Conference With Student:</div></td>\n <td><div>" . $teach_refer_conf_date . "</div></td>\n </tr>\n <tr>\n <td><div class=\"displayTextHeading\">Phone Call to Parent:</div></td>\n <td><div>" . $teach_refer_phone_date . "</div></td>\n </tr>\n <tr>\n <td colspan=\"2\"><div class=\"displayTextHeading\">Comments:</div>\n <div class=\"displayTextArea\">" . $teach_action_notes . "</div></td>\n </tr>\n <tr>\n <td><div class=\"displayTextHeading\">Refferred For Administrative Action:</div></td>\n <td><div>" . $teach_refer_action_date . "</div></td>\n </tr>\n</table>\n </td>\n </tr>"; /** Teacher Form Elements **/ $teacher_form .= "\n <tr bgcolor=\"#FFFFFF\">\n <td>\n <table width=\"100%\" border=\"0\" cellspacing=0 cellpadding=0 bgcolor=\"#FFFFFF\">\n <tr>\n <td align=\"left\" valign=top>\n <span style=\"font-size:14px;font-weight:bold\">Teacher:</span> " . $tfName . " " . $tlName . "<br />\n <span style=\"font-size:14px;font-weight:bold\">Student:</span> " . $sfName . " " . $slName . "<br />\n <span style=\"font-size:14px;font-weight:bold\">District:</span> " . $sDistrict . "<br />\n </td>\n <td align=\"left\" valign=top>\n <span style=\"font-size:14px;font-weight:bold\">Course: </span>\n " . make_selection_list(get_student_core_class_list($sid), $cid, 'course_id', 'courses', 'Course', 'off') . "<br />"; $date = make_LOM('referral_month', $referral_month, '1', '12') . " " . make_LOD('referral_day', $referral_day) . " " . make_LOY('referral_year', $referral_year, $referral_year - 1, $referral_year); $teacher_form .= "<span style=\"font-size:14px;font-weight:bold\">Date: </span> " . $date . "<br />\n <span style=\"font-size:14px;font-weight:bold\">Time: </span><input type=text size=25 name=referral_time style=\"background-color:#FFFACD\" value='" . $referral_time . "'/><br />\n </td>\n </tr>\n <tr>\n <td colspan=2>\n <span style=\"font-size:12px;font-weight:bold\">Description (100 chars max):<br /></span>\n <input name=\"teach_refer_desc\" style=\"background-color:#FFFACD\" type=text size=100 value=\"" . $teach_refer_desc . "\" />\n </td>\n </tr>\n </table>\n </td>\n </tr>\n <tr bgcolor=\"#FFFFFF\">\n <td class=\"blue-title\">Nature of Incident<br />\n <textarea name=\"teach_incident_notes\" cols=\"90\" rows=\"5\" value=\"" . $teach_incident_notes . "\">" . $teach_incident_notes . "</textarea></td>\n </tr>\n <tr bgcolor=\"#FFFFFF\">\n <td>\n <table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" bgcolor=\"#FFFFFF\">\n <tr>\n <td colspan=\"2\" class=\"blue-title\">Action Taken By Teacher Preceding Referral:</td>\n </tr>\n <tr>\n <td><input name=\"teach_refer_warn\" type=\"checkbox\" onClick=\"showHide('teach_refer_warn_date');\""; $visible = "hidden"; if ($teach_refer_warn == 'on') { $teacher_form .= " checked"; $visible = "visible"; } $teacher_form .= " /> Warning Issued/Verbal on " . $teach_refer_warn_year . "-" . $teach_refer_warn_month . "-" . $teach_refer_warn_day . "</td>\n <td>"; $date = make_LOM('teach_refer_warn_month', $teach_refer_warn_month, '1', '12') . " " . make_LOD('teach_refer_warn_day', $teach_refer_warn_day) . " " . make_LOY('teach_refer_warn_year', $teach_refer_warn_year, $teach_refer_warn_year - 1, $teach_refer_warn_year); $teacher_form .= "\n <div id=\"teach_refer_warn_date\" style=\"visibility:" . $visible . "\">" . $date . "</div>\n </td>\n </tr>\n <tr>\n <td><input name=\"teach_refer_conf\" type=\"checkbox\" onClick=\"showHide('teach_refer_conf_date');\""; $visible = "hidden"; if ($teach_refer_conf == 'on') { $teacher_form .= " checked"; $visible = "visible"; } $teacher_form .= " /> Conference With Student</td>\n <td>"; $date = make_LOM('teach_refer_conf_month', $teach_refer_conf_month, '1', '12') . " " . make_LOD('teach_refer_conf_day', $teach_refer_conf_day) . " " . make_LOY('teach_refer_conf_year', $teach_refer_conf_year, $teach_refer_conf_year - 1, $teach_refer_conf_year); $teacher_form .= "<div id=\"teach_refer_conf_date\" style=\"visibility:" . $visible . "\">" . $date . "</div>\n </td>\n </tr>\n <tr>\n <td><input name=\"teach_refer_phone\" type=\"checkbox\" onClick=\"showHide('teach_refer_phone_date');\""; $visible = "hidden"; if ($teach_refer_phone == 'on') { $teacher_form .= " checked"; $visible = "visible"; } $teacher_form .= " /> Phone Call to Parent</td>\n <td>"; $date = make_LOM('teach_refer_phone_month', $teach_refer_phone_month, '1', '12') . " " . make_LOD('teach_refer_phone_day', $teach_refer_phone_day) . " " . make_LOY('teach_refer_phone_year', $teach_refer_phone_year, $teach_refer_phone_year - 1, $teach_refer_phone_year);
$header .= "\n <script type=\"text/javascript\">\n \$(document).ready(function() {\n\n \$('#school_id').addClass(\"validate[required]\");\n \$('#attendValue').addClass(\"validate[required]\");\n \$('#attendByStudent').validationEngine({inlineValidation: true, scroll:false});\n\n \$(\".attendValue\").change(function(){\n var n=\$(this).attr(\"id\");\n var parts = n.split(/_/);\n var id=parts[1];\n var s=\$(this).attr(\"value\");\n var v=\$(\"#default_\"+id+\"_Minutes\").attr(\"value\");\n if((s == \"Unexcused-Abs\") || (s == \"Excused-Abs\") || (s == \"WBL-Absent\") || (s == \"Suspended\")){\n \$(\"#attend_\"+id+\"_minutes\").val(0);\n \$(\"#attend_\"+id+\"_note\").focus();\n }else if((s == \"Present\") || (s == \"WBL-Present\")){\n \$(\"#attend_\"+id+\"_minutes\").val(v);\n }else{\n \$(\"#attend_\"+id+\"_minutes\").focus();\n }\n });\n "; if ($sid != -1) { $header .= "\n \$('#a_date').datepick({\n dateFormat: 'yyyy-mm-dd',\n maxDate: new Date(" . $ey . ", " . ($em - 1) . ", " . $ed . "),\n minDate: new Date(" . $sy . ", " . ($sm - 1) . ", " . $sd . "),\n monthsToShow: 3,monthsToStep: 3, monthsOffset: 1,\n multiSelect:25,\n onDate: \$.datepick.noWeekends,\n showTrigger: '#callImg'\n });"; } $header .= "\n });\n </script>"; $b .= "\n <center>\n <form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST name=\"attendByStudent\" id=\"attendByStudent\">\n <table border=0>\n <tr>\n <td colspan=3>" . make_selection_list($students, $sid, 'student_id', 'attendByStudent', 'Student', 'on') . "Sort users by:\n <select name=users_sortBy onChange=\"document.forms['attendByStudent'].submit();\">\n <option value=\"users.last_name, users.first_name\""; if ($_SESSION[$_CONF['sess_name'] . '_users_sortBy'] == "users.last_name, users.first_name") { $b .= " selected"; } $b .= ">Last Name, First Name</option>\n <option value=\"schools.school_name, users.last_name\""; if ($_SESSION[$_CONF['sess_name'] . '_users_sortBy'] == "schools.school_name, users.last_name") { $b .= " selected"; } $b .= ">School Name, last Name, First Name</option>\n </select>\n </td>\n </tr>"; if ($sid != -1) { $courses = get_student_core_class_list($sid); $courseSelect = make_selection_list($courses, $cid, 'course_id', 'attendByStudent', 'Course', 'on'); $b .= "\n <tr>\n <td align=right>Course:</td>\n <td>" . $courseSelect . "</td>\n <td align=left>Date:<input id=\"a_date\" name=\"a_date\" type=text size=15 value=" . $today . " /></td>\n </tr>\n "; } $b .= "\n <tr>\n <td colspan=3 align=center>\n <!-- input type=submit name=submit value=\"Get\" / -->\n </td>\n </tr>"; if ($sid != -1 && $cid != -1) { $today = date('Y-m-d'); /** Get User Info from Q3 * */ $sql = "SELECT users.user_id, users.first_name, users.last_name, LOWER(users.STGUID) as STGUID, schools.school_name, schools.school_id\n FROM users, schools\n WHERE users.user_id=" . $sid . "\n AND schools.school_id=users.school_id"; $result = $db->query($sql); $student = $result->fetch_assoc(); /** Get any attendance info from SMS **/ //$myStudents_GUID = make_assoc_array_from_sql($result, 'STGUID', 'my'); /** Get Attendance info from SMS * */ $result2 = getSMSattendanceForStudent($student['STGUID'], $today); $SMSresults = make_assoc_array_from_sql($result2, 'STGUID', 'ms');
Fields: page_id, teacher_id, link_name, description The pages should be stored in $configPath.teacher_pages/{teacher_id}/{page_id}.php The include() process should allow for php and/or html code just fine. If using php, surround php(or entire page) with <?php ?> or just the php code If using html, no need to include the <?php ... ?> stuff just the html code **/ $cid = $_SESSION[$_CONF['sess_name'] . '_myCenter']; $sql = "SELECT short_name from ed_centers where center_id=" . $cid; $result = $db->query($sql); $row = $result->fetch_assoc(); $center = $row['short_name']; $my_out = ""; $SAVE_PATH = $configPath . "teacher_pages/" . $center . "/"; $UID = $_SESSION[$_CONF['sess_name'] . '_myUID']; $classes = get_student_core_class_list($UID); $b = ""; $t = "Custom Pages"; $sid = $_SESSION[$_CONF['sess_name'] . '_myUID']; $fname = $_SESSION[$_CONF['sess_name'] . '_myfName']; $lname = $_SESSION[$_CONF['sess_name'] . '_mylName']; $cid = -1; if (isset($_SESSION[$_CONF['sess_name'] . '_selected_course'])) { $cid = $_SESSION[$_CONF['sess_name'] . '_selected_course']; $result = get_class_info($cid); $row = $result->fetch_assoc(); $className = $row['class_name']; $termName = $row['term_name']; $teacherName = $row['first_name'] . " " . $row['last_name']; } $b .= $QUERY_STRING;
$size = $row['size']; $type = $row['file_type']; $file = $downloads_path . $name; $fp = fopen($file, 'r'); //$dl = fread($fp, $size); header("Content-length: " . $size); header("Content-type: " . $type); header("Content-Disposition: attachment; filename=" . $name); fpassthru($fp); //echo $dl; fclose($fp); exit; } /** now for the download **/ /** select a class **/ $b = "\n\t\t\t<form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=\"post\", name=\"courses\">\n\t\t\t<center><table border=0 cellspacing=2 cellpadding=2>\n\t\t\t<tr>\n\t\t\t<!--td align=right>Please Select a Class :</td-->\n\t\t\t<td align=left>" . make_selection_list(get_student_core_class_list($_SESSION[$_CONF['sess_name'] . '_myUID']), $cid, 'course_id', 'courses', 'Course', 'on') . "</td>\n\t\t\t</tr>\n\t\t\t</table>\n\t\t\t</center>\n\t\t\t</form>"; $t = "Get Downloads"; if ($cid != -1) { $result = get_downloads_for_course($cid); $t = "Files Available for Download"; if ($result->num_rows != 0) { $b .= "<center><table border=0 cellspacing=2 cellpadding=2>"; while ($row = $result->fetch_assoc()) { $b .= "<tr>"; $b .= "<td valign=top nowrap><b>" . $row['title'] . " :</b></td>"; $b .= "<td valign=top>" . $row['description'] . "</td>"; $b .= "<td>"; $b .= "<form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=\"post\">"; $b .= "<input type=submit class=submit name=download value=Download />"; $b .= "<input type=hidden name=f_id value=" . $row['download_id'] . " />"; $b .= "<input type=hidden name=t_id value=" . $row['teacher_id'] . " />";