}
}
$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'] . " />";
