Initial revision

[moodle.git] / mod / choice / report.php

<?PHP  // $Id$

    require("../../config.php");

    require_variable($id);   // course module

    if (! $cm = get_record("course_modules", "id", $id)) {
        error("Course Module ID was incorrect");
    }

    if (! $course = get_record("course", "id", $cm->course)) {
        error("Course module is misconfigured");
    }

    require_login($course->id);

    if (!isteacher($course->id)) {
        error("Only teachers can look at this page");
    }

    if (! $choice = get_record("choice", "id", $cm->instance)) {
        error("Course module is incorrect");
    }

    add_to_log("View choices report", $course->id);

    print_header("$course->shortname: $choice->name: Responses", "$course->fullname",
                 "<A HREF=/course/view.php?id=$course->id>$course->shortname</A> ->
                  <A HREF=index.php?id=$course->id>Choices</A> ->
                  <A HREF=view.php?id=$cm->id>$choice->name</A> -> Responses", "");


    if (! $participants = get_records_sql("SELECT u.* FROM user u, user_students s, user_teachers t
                                       WHERE (s.course = '$course->id' AND s.user = u.id) 
                                          OR (t.course = '$course->id' AND t.user = u.id)
                                       ORDER BY u.lastaccess DESC")) {

        notify("No participants (strange)", "/course/view.php?id=$course->id");
        die;
    }

    if ( $allanswers = get_records_sql("SELECT * FROM choice_answers WHERE choice='$choice->id'")) {
        foreach ($allanswers as $aa) {
            $answers[$aa->user] = $aa;
        }
        
    } else {
        $answers = array () ;
    }
    


    $timenow = time();

    echo "<TABLE BORDER=1 CELLSPACING=0 valign=top align=center cellpadding=10>";
    foreach ($participants as $user) {
        $answer = $answers[$user->id];

        echo "<TR>";

        echo "<TD BGCOLOR=\"$THEME->body\" WIDTH=35 VALIGN=TOP>";
        print_user_picture($user->id, $course->id, $user->picture);
        echo "</TD>";

        echo "<TD NOWRAP BGCOLOR=\"$THEME->cellheading\">$user->firstname $user->lastname</TD>";
        echo "<TD><P>&nbsp;";
        if ($answer->timemodified) {
            echo moodledate($answer->timemodified);
        } 
        
        echo "</P> </TD>";

        echo "<TD ALIGN=CENTER BGCOLOR=\"$THEME->cellcontent\"><P>";
        switch ($answer->answer) {
            case 1:
                echo "$choice->answer1";
                break;
            case 2:
                echo "$choice->answer2";
                break;
            default:
                echo "Undecided";
                break;
                
        }
        echo "</P></TD></TR>";
    }
    echo "</TABLE>";

    print_footer($course);

 
?>