Пример #1
0
 if (isset($_POST['file_id'])) {
     $selected_file = $_POST['file_id'];
 }
 $t = "Teacher Gradebook Restore";
 $b = "\n\t<div style=\"color:red; font-size:12px;\">\n\tThis routine will allow you to restore a single class' gradebook.  That means it will restore the roster and the grades back to the date you select.  Keep in mind that the file name is the date.  Your gradebooks are backed up at midnight on the date you select.<br><br>THIS WILL REMOVE ALL CURRENT DATA!!!\n\t</div>\n\t<form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=post name=restoreForm id=restoreForm>";
 /** Get Teachers for center array{id=>name} **/
 if ($_SESSION[$_CONF['sess_name'] . "_isAdmin"]) {
     $teachers = get_users_for_center($_SESSION[$_CONF['sess_name'] . '_myCenter'], 'isTeacher', 'Y', "users.last_name, users.first_name");
 } else {
     $teachers[$_SESSION[$_CONF['sess_name'] . "_myUID"]] = $_SESSION[$_CONF['sess_name'] . "_myName"];
 }
 asort($teachers);
 $teacher_select = make_selection_list($teachers, $selected_teacher, "teacher_id", "restoreForm", "teacher", "on");
 $b .= "Teacher : " . $teacher_select . "<br />";
 if (isset($_POST['teacher_id'])) {
     $row = get_teacher_info($selected_teacher);
     $uname = $row['u_name'];
     $courses = get_teacher_course_list($selected_teacher);
     asort($courses);
     $course_select = make_selection_list($courses, $selected_course, "class_id", "restoreForm", "class", "on");
     $b .= "Course : " . $course_select . "<br />";
     if (isset($_POST['class_id'])) {
         // read the list of available terms for this teacher for this class from file system
         $dh = opendir($start_path . $center . "/" . $uname . "/" . $courses[$selected_course]);
         $terms = array();
         $result = get_terms($yid, $_SESSION[$_CONF['sess_name'] . "_myCenter"]);
         while ($row = $result->fetch_assoc()) {
             $terms[$row['term_id']] = $row['term_name'];
         }
         $term_select = make_selection_list($terms, $selected_term, "term_id", "restoreForm", "term", "on");
         $b .= "Term : " . $term_select . "<br />";
Пример #2
0
/** get the current term for this year in this center
 * Returns an sql result set including
 * term_id, term_name, term_weight, term_start_date, term_end_date, term_ord
 */
$sql = "SELECT * from terms\n    WHERE terms.term_start_date <= '" . $today . "'\n    AND terms.term_end_date >= '" . $today . "'";
$result = $db->query($sql);
$row = $result->fetch_assoc();
$current_term_id = $row['term_id'];
$current_term_name = $row['term_name'];
/** Get Ed Centers **/
$centers = get_edCenters();
foreach ($centers as $center_id => $short_name) {
    /** Get Teachers **/
    $teachers = get_users_for_center($center_id, 'isTeacher', 'Y', "users.last_name, users.first_name");
    foreach ($teachers as $teacher_id => $teacher_name) {
        $tinfo = get_teacher_info($teacher_id);
        $tuname = $tinfo['u_name'];
        /** Get Courses **/
        $sql = "\n        SELECT courses.course_id, courses.course_name\n        FROM courses\n        WHERE courses.teacher_id=" . $teacher_id . "\n        AND courses.school_year_id=" . $yid . "\n        AND courses.ed_center=" . $center_id;
        $result = $db->query($sql);
        $courses = make_array_from_sql($result, 'course_id', array('course_name'), '');
        foreach ($courses as $course_id => $course_name) {
            /** Get Classes **/
            /** class_id=>term_name course_name **/
            $classes = get_teacher_classes_by_course($course_id);
            foreach ($classes as $class_id => $class_name) {
                list($term, $course) = preg_split("/ - /", $class_name);
                if ($term == $current_term_name) {
                    $save_path = $start_path . $short_name . "/" . $tuname . "/" . $course_name . "/" . $term . "/";
                    $save_file = $today . ".sql";
                    if (!is_dir($save_path)) {
<?php

define('FPDF_FONTPATH', 'fpdf_fonts/');
require 'fpdf.php';
include '_includeSessionConfig.php';
$loginError = check_auth($_SESSION[$_CONF['sess_name'] . '_username'], $_SESSION[$_CONF['sess_name'] . '_password']);
$today = date('Y-m-d');
if (!$loginError['error_value']) {
    $cid = $_SESSION[$_CONF['sess_name'] . '_selected_course'];
    $tid = $_POST['teacherID'];
    $row = get_teacher_info($tid);
    $teaacherName = $row['first_name'] . " " . $row['last_name'];
    $yid = $_SESSION[$_CONF['sess_name'] . '_current_school_year'];
    $sid = $_SESSION[$_CONF['sess_name'] . '_myCenter'];
    $terms = get_terms($yid, $sid);
    $termsArray = make_assoc_array_from_sql($terms, 'term_id', 'my');
    if ($cid != -1) {
        $result = get_students_for_course($cid);
        $students = make_assoc_array_from_sql(get_students_for_course($cid), 'user_id', 'my');
        $result = get_course_info($cid);
        $row = $result->fetch_assoc();
        $courseName = $row['course_name'];
        /** NOW FOR THE PDF STUFF **/
        $lm = 0.5;
        /** left marging**/
        $tm = 0.5;
        /** top margin**/
        $ph = 11 - 2 * $tm;
        /** page width - margins**/
        $pw = 8.5 - 2 * $lm;
        /** page height - margins**/