Annotation of loncom/interface/lonstatistics.pm, revision 1.75
1.1 albertel 1: # The LearningOnline Network with CAPA
2: #
1.75 ! matthew 3: # $Id: lonstatistics.pm,v 1.74 2003/06/03 18:10:33 matthew Exp $
1.1 albertel 4: #
5: # Copyright Michigan State University Board of Trustees
6: #
7: # This file is part of the LearningOnline Network with CAPA (LON-CAPA).
8: #
9: # LON-CAPA is free software; you can redistribute it and/or modify
10: # it under the terms of the GNU General Public License as published by
11: # the Free Software Foundation; either version 2 of the License, or
12: # (at your option) any later version.
13: #
14: # LON-CAPA is distributed in the hope that it will be useful,
15: # but WITHOUT ANY WARRANTY; without even the implied warranty of
16: # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
17: # GNU General Public License for more details.
18: #
19: # You should have received a copy of the GNU General Public License
20: # along with LON-CAPA; if not, write to the Free Software
21: # Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
22: #
23: # /home/httpd/html/adm/gpl.txt
24: #
25: # http://www.lon-capa.org/
26: #
27: # (Navigate problems for statistical reports
1.14 minaeibi 28: #
1.1 albertel 29: ###
30:
1.59 matthew 31: =pod
32:
33: =head1 NAME
34:
35: lonstatistics
36:
37: =head1 SYNOPSIS
38:
39: Main handler for statistics and chart.
40:
41: =head1 PACKAGES USED
42:
1.60 matthew 43: use strict;
44: use Apache::Constants qw(:common :http);
45: use Apache::lonnet();
46: use Apache::lonhomework;
47: use Apache::loncommon;
48: use Apache::loncoursedata;
49: use Apache::lonhtmlcommon;
50: use Apache::lonproblemanalysis;
51: use Apache::lonproblemstatistics;
52: use Apache::lonstudentassessment;
53: use Apache::lonpercentage;
1.66 matthew 54: use Apache::lonmysql;
1.59 matthew 55: =over 4
56:
57: =cut
58:
1.55 minaeibi 59: package Apache::lonstatistics;
1.1 albertel 60:
1.30 stredwic 61: use strict;
1.1 albertel 62: use Apache::Constants qw(:common :http);
1.61 matthew 63: use vars qw(
64: @FullClasslist
65: @Students
66: @Sections
67: @SelectedSections
68: %StudentData
69: @StudentDataOrder
70: @SelectedStudentData
71: $top_map
72: @Sequences
73: @SelectedMaps
74: @Assessments);
75:
1.1 albertel 76: use Apache::lonnet();
77: use Apache::lonhomework;
1.12 minaeibi 78: use Apache::loncommon;
1.29 stredwic 79: use Apache::loncoursedata;
80: use Apache::lonhtmlcommon;
1.61 matthew 81: use Apache::lonproblemanalysis();
82: use Apache::lonproblemstatistics();
83: use Apache::lonstudentassessment();
1.49 stredwic 84: use Apache::lonpercentage;
1.66 matthew 85: use Apache::lonmysql;
1.65 matthew 86: use Time::HiRes;
1.60 matthew 87:
88: #######################################################
89: #######################################################
90:
91: =pod
92:
93: =item Package Variables
94:
95: =item @FullClasslist The full classlist
96:
97: =item @Students The students we are concerned with for this invocation
98:
99: =item @Sections The sections available in this class
100:
101: =item $curr_student The student currently being examined
102:
103: =item $prev_student The student previous in the classlist
104:
105: =item $next_student The student next in the classlist
106:
107: =over
108:
109: =cut
110:
111: #######################################################
112: #######################################################
113: #
114: # Classlist variables
115: #
1.59 matthew 116: my $curr_student;
117: my $prev_student;
118: my $next_student;
119:
120: #######################################################
121: #######################################################
122:
123: =pod
124:
125: =item &clear_classlist_variables()
126:
127: undef the following package variables:
128:
129: =over
130:
1.60 matthew 131: =item @FullClasslist
132:
133: =item @Students
1.59 matthew 134:
1.60 matthew 135: =item @Sections
1.59 matthew 136:
1.60 matthew 137: =item @SelectedSections
1.59 matthew 138:
1.61 matthew 139: =item %StudentData
140:
141: =item @StudentDataOrder
142:
143: =item @SelectedStudentData
144:
1.60 matthew 145: =item $curr_student
1.59 matthew 146:
1.60 matthew 147: =item $prev_student
1.59 matthew 148:
1.60 matthew 149: =item $next_student
1.59 matthew 150:
151: =back
152:
153: =cut
154:
155: #######################################################
156: #######################################################
157: sub clear_classlist_variables {
158: undef(@FullClasslist);
159: undef(@Students);
160: undef(@Sections);
1.60 matthew 161: undef(@SelectedSections);
1.61 matthew 162: undef(%StudentData);
163: undef(@SelectedStudentData);
1.59 matthew 164: undef($curr_student);
165: undef($prev_student);
166: undef($next_student);
167: }
168:
169: #######################################################
170: #######################################################
171:
172: =pod
173:
174: =item &PrepareClasslist()
175:
176: Build up the classlist information. The classlist information is kept in
177: the following package variables:
178:
179: =over
180:
1.60 matthew 181: =item @FullClasslist
182:
183: =item @Students
1.59 matthew 184:
1.60 matthew 185: =item @Sections
1.59 matthew 186:
1.60 matthew 187: =item @SelectedSections
1.59 matthew 188:
1.61 matthew 189: =item %StudentData
190:
191: =item @SelectedStudentData
192:
1.60 matthew 193: =item $curr_student
1.59 matthew 194:
1.60 matthew 195: =item $prev_student
1.59 matthew 196:
1.60 matthew 197: =item $next_student
1.59 matthew 198:
199: =back
200:
201: $curr_student, $prev_student, and $next_student may not be defined, depending
202: upon the calling context.
203:
204: =cut
205:
206: #######################################################
207: #######################################################
208: sub PrepareClasslist {
209: my %Sections;
210: &clear_classlist_variables();
211: #
212: # Retrieve the classlist
213: my $cid = $ENV{'request.course.id'};
214: my $cdom = $ENV{'course.'.$cid.'.domain'};
215: my $cnum = $ENV{'course.'.$cid.'.num'};
216: my ($classlist,$field_names) = &Apache::loncoursedata::get_classlist($cid,
217: $cdom,$cnum);
1.60 matthew 218: if (exists($ENV{'form.Section'})) {
1.59 matthew 219: if (ref($ENV{'form.Section'})) {
1.61 matthew 220: @SelectedSections = @{$ENV{'form.Section'}};
221: } elsif ($ENV{'form.Section'} !~ /^\s*$/) {
222: @SelectedSections = ($ENV{'form.Section'});
223: }
224: }
225: @SelectedSections = ('all') if (! @SelectedSections);
226: foreach (@SelectedSections) {
227: if ($_ eq 'all') {
228: @SelectedSections = ('all');
1.59 matthew 229: }
230: }
1.61 matthew 231: #
1.69 matthew 232: # Deal with instructors with restricted section access
1.70 matthew 233: if ($ENV{'request.course.sec'} !~ /^\s*$/) {
1.69 matthew 234: @SelectedSections = ($ENV{'request.course.sec'});
235: }
236: #
1.61 matthew 237: # Set up %StudentData
238: @StudentDataOrder = qw/fullname username domain id section status/;
239: foreach my $field (@StudentDataOrder) {
240: $StudentData{$field}->{'title'} = $field;
1.63 matthew 241: $StudentData{$field}->{'base_width'} = length($field);
1.61 matthew 242: $StudentData{$field}->{'width'} =
243: $StudentData{$field}->{'base_width'};
244: }
1.59 matthew 245: #
1.68 matthew 246: # get the status requested
247: my $requested_status = 'Active';
248: $requested_status = $ENV{'form.Status'} if (exists($ENV{'form.Status'}));
249: #
1.59 matthew 250: # Process the classlist
251: while (my ($student,$student_data) = each (%$classlist)) {
252: my $studenthash = ();
253: for (my $i=0; $i< scalar(@$field_names);$i++) {
1.61 matthew 254: my $field = $field_names->[$i];
255: # Store the data
256: $studenthash->{$field}=$student_data->[$i];
257: # Keep track of the width of the fields
258: next if (! exists($StudentData{$field}));
1.63 matthew 259: my $length = length($student_data->[$i]);
1.61 matthew 260: if ($StudentData{$field}->{'width'} < $length) {
261: $StudentData{$field}->{'width'} = $length;
262: }
1.59 matthew 263: }
264: push (@FullClasslist,$studenthash);
265: #
266: # Build up a list of sections
267: my $section = $studenthash->{'section'};
1.60 matthew 268: if (! defined($section) || $section =~/^\s*$/ || $section == -1) {
269: $studenthash->{'section'} = 'none';
270: $section = $studenthash->{'section'};
271: }
1.59 matthew 272: $Sections{$section}++;
273: #
274: # Only put in the list those students we are interested in
1.60 matthew 275: foreach my $sect (@SelectedSections) {
1.68 matthew 276: if ( (($sect eq 'all') ||
277: ($section eq $sect)) &&
278: (($studenthash->{'status'} eq $requested_status) ||
279: ($requested_status eq 'Any'))
280: ){
1.60 matthew 281: push (@Students,$studenthash);
282: last;
283: }
1.59 matthew 284: }
285: }
286: #
287: # Put the consolidated section data in the right place
1.70 matthew 288: if ($ENV{'request.course.sec'} !~ /^\s*$/) {
1.69 matthew 289: @Sections = ($ENV{'request.course.sec'});
290: } else {
291: @Sections = sort {$a cmp $b} keys(%Sections);
292: unshift(@Sections,'all'); # Put 'all' at the front of the list
293: }
1.59 matthew 294: #
295: # Sort the Students
296: my $sortby = 'fullname';
1.60 matthew 297: $sortby = $ENV{'form.sort'} if (exists($ENV{'form.sort'}));
298: my @TmpStudents = sort { $a->{$sortby} cmp $b->{$sortby} ||
299: $a->{'fullname'} cmp $b->{'fullname'} } @Students;
300: @Students = @TmpStudents;
1.59 matthew 301: #
302: # Now deal with that current student thing....
1.72 matthew 303: $curr_student = undef;
304: if (exists($ENV{'form.SelectedStudent'})) {
1.59 matthew 305: my ($current_uname,$current_dom) =
1.72 matthew 306: split(':',$ENV{'form.SelectedStudent'});
1.59 matthew 307: my $i;
308: for ($i = 0; $i<=$#Students; $i++) {
309: next if (($Students[$i]->{'username'} ne $current_uname) ||
310: ($Students[$i]->{'domain'} ne $current_dom));
1.60 matthew 311: $curr_student = $Students[$i];
1.59 matthew 312: last; # If we get here, we have our student.
313: }
1.72 matthew 314: if (defined($curr_student)) {
315: if ($i == 0) {
316: $prev_student = undef;
317: } else {
318: $prev_student = $Students[$i-1];
319: }
320: if ($i == $#Students) {
321: $next_student = undef;
322: } else {
323: $next_student = $Students[$i+1];
324: }
1.59 matthew 325: }
326: }
1.61 matthew 327: #
328: if (exists($ENV{'form.StudentData'})) {
329: if (ref($ENV{'form.StudentData'}) eq 'ARRAY') {
330: @SelectedStudentData = @{$ENV{'form.StudentData'}};
331: } else {
332: @SelectedStudentData = ($ENV{'form.StudentData'});
333: }
334: } else {
1.72 matthew 335: @SelectedStudentData = ('username');
1.61 matthew 336: }
337: foreach (@SelectedStudentData) {
338: if ($_ eq 'all') {
339: @SelectedStudentData = ('all');
340: last;
341: }
342: }
343: #
344: return;
345: }
346:
1.71 matthew 347:
348: #######################################################
349: #######################################################
350:
351: =pod
352:
353: =item get_students
354:
355: Returns a list of the selected students
356:
357: =cut
358:
359: #######################################################
360: #######################################################
361: sub get_students {
362: if (! @Students) {
363: &PrepareClasslist()
364: }
365: return @Students;
366: }
367:
1.61 matthew 368: #######################################################
369: #######################################################
370:
371: =pod
372:
373: =item ¤t_student()
374:
375: Returns a pointer to a hash containing data about the currently
376: selected student.
377:
378: =cut
379:
380: #######################################################
381: #######################################################
382: sub current_student {
1.72 matthew 383: return $curr_student;
1.61 matthew 384: }
385:
386: #######################################################
387: #######################################################
388:
389: =pod
390:
391: =item &previous_student()
392:
393: Returns a pointer to a hash containing data about the student prior
394: in the list of students. Or something.
395:
396: =cut
397:
398: #######################################################
399: #######################################################
400: sub previous_student {
1.72 matthew 401: return $prev_student;
1.59 matthew 402: }
403:
404: #######################################################
405: #######################################################
1.61 matthew 406:
407: =pod
408:
409: =item &next_student()
410:
411: Returns a pointer to a hash containing data about the next student
412: to be viewed.
413:
414: =cut
415:
416: #######################################################
417: #######################################################
418: sub next_student {
1.72 matthew 419: return $next_student;
1.61 matthew 420: }
1.60 matthew 421:
422: #######################################################
423: #######################################################
424:
425: =pod
426:
427: =item &clear_sequence_variables()
428:
429: =cut
430:
431: #######################################################
432: #######################################################
433: sub clear_sequence_variables {
434: undef($top_map);
435: undef(@Sequences);
436: undef(@Assessments);
437: }
438:
439: #######################################################
440: #######################################################
441:
442: =pod
443:
1.61 matthew 444: =item &SetSelectedMaps($elementname)
445:
446: Sets the @SelectedMaps array from $ENV{'form.'.$elementname};
447:
448: =cut
449:
450: #######################################################
451: #######################################################
452: sub SetSelectedMaps {
453: my $elementname = shift;
454: if (exists($ENV{'form.'.$elementname})) {
455: if (ref($ENV{'form.'.$elementname})) {
456: @SelectedMaps = @{$ENV{'form.'.$elementname}};
457: } else {
458: @SelectedMaps = ($ENV{'form.'.$elementname});
459: }
460: } else {
461: @SelectedMaps = ('all');
462: }
1.64 matthew 463: }
464:
465:
466: #######################################################
467: #######################################################
468:
469: =pod
470:
471: =item &Sequences_with_Assess()
472:
473: Returns an array containing the subset of @Sequences which contain
474: assessments.
475:
476: =cut
477:
478: #######################################################
479: #######################################################
480: sub Sequences_with_Assess {
481: my @Sequences_to_Show;
482: foreach my $map_symb (@SelectedMaps) {
483: foreach my $sequence (@Sequences) {
484: next if ($sequence->{'symb'} ne $map_symb && $map_symb ne 'all');
485: next if ($sequence->{'num_assess'} < 1);
486: push (@Sequences_to_Show,$sequence);
487: }
488: }
489: return @Sequences_to_Show;
1.61 matthew 490: }
491:
492: #######################################################
493: #######################################################
494:
495: =pod
496:
1.60 matthew 497: =item &PrepareCourseData($r)
498:
499: =cut
500:
501: #######################################################
502: #######################################################
503: sub PrepareCourseData {
504: my ($r) = @_;
505: &clear_sequence_variables();
1.61 matthew 506: my ($top,$sequences,$assessments) =
507: &Apache::loncoursedata::get_sequence_assessment_data();
1.60 matthew 508: if (! defined($top) || ! ref($top)) {
509: # There has been an error, better report it
510: &Apache::lonnet::logthis('top is undefined');
511: return;
512: }
513: $top_map = $top if (ref($top));
514: @Sequences = @{$sequences} if (ref($sequences) eq 'ARRAY');
1.61 matthew 515: @Assessments = @{$assessments} if (ref($assessments) eq 'ARRAY');
516: #
517: # Compute column widths
518: foreach my $seq (@Sequences) {
1.63 matthew 519: my $name_length = length($seq->{'title'});
1.61 matthew 520: my $num_parts = $seq->{'num_assess_parts'};
521: #
1.75 ! matthew 522: # Use 3 digits for each the sum and total, which means 7 total...
! 523: my $num_col = $num_parts+7;
1.61 matthew 524: if ($num_col < $name_length) {
525: $num_col = $name_length;
526: }
527: $seq->{'base_width'} = $name_length;
528: $seq->{'width'} = $num_col;
529: }
530: return;
531: }
532:
533: #######################################################
534: #######################################################
1.60 matthew 535:
536: =pod
537:
1.61 matthew 538: =item &log_sequence($sequence,$recursive,$padding)
539:
540: Write data about the sequence to a logfile. If $recursive is not
541: undef the data is written recursively. $padding is used for recursive
542: calls.
543:
544: =cut
545:
546: #######################################################
547: #######################################################
548: sub log_sequence {
549: my ($seq,$recursive,$padding) = @_;
550: $padding = '' if (! defined($padding));
551: if (ref($seq) ne 'HASH') {
552: &Apache::lonnet::logthis('log_sequence passed bad sequnce');
553: return;
554: }
555: &Apache::lonnet::logthis($padding.'sequence '.$seq->{'title'});
556: while (my($key,$value) = each(%$seq)) {
557: next if ($key eq 'contents');
558: if (ref($value) eq 'ARRAY') {
559: for (my $i=0;$i< scalar(@$value);$i++) {
560: &Apache::lonnet::logthis($padding.$key.'['.$i.']='.
561: $value->[$i]);
562: }
563: } else {
564: &Apache::lonnet::logthis($padding.$key.'='.$value);
565: }
566: }
567: if (defined($recursive)) {
568: &Apache::lonnet::logthis($padding.'-'x20);
569: &Apache::lonnet::logthis($padding.'contains:');
570: foreach my $item (@{$seq->{'contents'}}) {
571: if ($item->{'type'} eq 'container') {
572: &log_sequence($item,$recursive,$padding.' ');
573: } else {
574: &Apache::lonnet::logthis($padding.'title = '.$item->{'title'});
575: while (my($key,$value) = each(%$item)) {
576: next if ($key eq 'title');
577: if (ref($value) eq 'ARRAY') {
578: for (my $i=0;$i< scalar(@$value);$i++) {
579: &Apache::lonnet::logthis($padding.$key.'['.$i.']='.
580: $value->[$i]);
581: }
582: } else {
583: &Apache::lonnet::logthis($padding.$key.'='.$value);
584: }
585: }
586: }
1.60 matthew 587: }
1.61 matthew 588: &Apache::lonnet::logthis($padding.'end contents of '.$seq->{'title'});
589: &Apache::lonnet::logthis($padding.'-'x20);
1.60 matthew 590: }
1.61 matthew 591: return;
592: }
593:
594: ##############################################
595: ##############################################
596:
597: =pod
598:
599: =item &StudentDataSelect($elementname,$status,$numvisible,$selected)
600:
601: Returns html for a selection box allowing the user to choose one (or more)
602: of the fields of student data available (fullname, username, id, section, etc)
603:
604: =over 4
605:
606: =item $elementname The name of the HTML form element
607:
608: =item $status 'multiple' or 'single' selection box
609:
610: =item $numvisible The number of options to be visible
611:
612: =back
1.60 matthew 613:
614: =cut
615:
1.61 matthew 616: ##############################################
617: ##############################################
618: sub StudentDataSelect {
619: my ($elementname,$status,$numvisible)=@_;
620: if ($numvisible < 1) {
621: return;
622: }
623: #
624: # Build the form element
625: my $Str = "\n";
626: $Str .= '<select name="'.$elementname.'" ';
627: if ($status ne 'single') {
628: $Str .= 'multiple="true" ';
629: }
630: $Str .= 'size="'.$numvisible.'" >'."\n";
631: #
632: # Deal with 'all'
633: $Str .= ' <option value="all" ';
634: foreach (@SelectedStudentData) {
635: if ($_ eq 'all') {
636: $Str .= 'selected ';
637: last;
638: }
639: }
640: $Str .= ">all</option>\n";
641: #
642: # Loop through the student data fields
643: foreach my $item (@StudentDataOrder) {
644: $Str .= ' <option value="'.$item.'" ';
645: foreach (@SelectedStudentData) {
646: if ($item eq $_ ) {
647: $Str .= 'selected ';
648: last;
649: }
650: }
651: $Str .= '>'.$item."</option>\n";
652: }
653: $Str .= "</select>\n";
654: return $Str;
1.60 matthew 655: }
656:
657: ##############################################
658: ##############################################
659:
660: =pod
661:
1.61 matthew 662: =item &MapSelect($elementname,$status,$numvisible,$restriction)
1.60 matthew 663:
664: Returns html for a selection box allowing the user to choose one (or more)
665: of the sequences in the course. The values of the sequences are the symbs.
666: If the top sequence is selected, the value 'top' will result.
667:
668: =over 4
669:
670: =item $elementname The name of the HTML form element
671:
672: =item $status 'multiple' or 'single' selection box
673:
674: =item $numvisible The number of options to be visible
675:
676: =item $restriction Code reference to subroutine which returns true or
677: false. The code must expect a reference to a sequence data structure.
678:
679: =back
680:
681: =cut
682:
683: ##############################################
684: ##############################################
685: sub MapSelect {
1.61 matthew 686: my ($elementname,$status,$numvisible,$restriction)=@_;
1.60 matthew 687: if ($numvisible < 1) {
688: return;
689: }
690: #
691: # Set up array of selected items
1.61 matthew 692: &SetSelectedMaps($elementname);
1.60 matthew 693: #
694: # Set up the restriction call
695: if (! defined($restriction)) {
696: $restriction = sub { 1; };
697: }
698: #
699: # Build the form element
700: my $Str = "\n";
701: $Str .= '<select name="'.$elementname.'" ';
702: if ($status ne 'single') {
703: $Str .= 'multiple="true" ';
704: }
705: $Str .= 'size="'.$numvisible.'" >'."\n";
706: #
1.61 matthew 707: # Deal with 'all'
708: foreach (@SelectedMaps) {
709: if ($_ eq 'all') {
710: @SelectedMaps = ('all');
711: last;
712: }
713: }
714: #
715: # Put in option for 'all'
716: $Str .= ' <option value="all" ';
717: foreach (@SelectedMaps) {
718: if ($_ eq 'all') {
719: $Str .= 'selected ';
720: last;
721: }
722: }
723: $Str .= ">all</option>\n";
724: #
1.60 matthew 725: # Loop through the sequences
1.61 matthew 726: foreach my $seq (@Sequences) {
727: next if (! $restriction->($seq));
728: $Str .= ' <option value="'.$seq->{'symb'}.'" ';
729: foreach (@SelectedMaps) {
730: if ($seq->{'symb'} eq $_) {
1.60 matthew 731: $Str .= 'selected ';
732: last;
733: }
734: }
1.61 matthew 735: $Str .= '>'.$seq->{'title'}."</option>\n";
1.60 matthew 736: }
737: $Str .= "</select>\n";
738: return $Str;
739: }
740:
741: ##############################################
742: ##############################################
743:
744: =pod
745:
746: =item &SectionSelect($elementname,$status,$numvisible)
747:
748: Returns html for a selection box allowing the user to choose one (or more)
749: of the sections in the course.
750:
1.71 matthew 751: Uses the package variables @Sections and @SelectedSections
1.60 matthew 752: =over 4
753:
754: =item $elementname The name of the HTML form element
755:
756: =item $status 'multiple' or 'single' selection box
757:
758: =item $numvisible The number of options to be visible
759:
760: =back
761:
762: =cut
763:
764: ##############################################
765: ##############################################
766: sub SectionSelect {
767: my ($elementname,$status,$numvisible)=@_;
768: if ($numvisible < 1) {
769: return;
770: }
771: #
1.71 matthew 772: # Make sure we have the data we need to continue
773: if (! @Sections) {
774: &PrepareClasslist()
775: }
776: #
1.60 matthew 777: # Build the form element
778: my $Str = "\n";
779: $Str .= '<select name="'.$elementname.'" ';
780: if ($status ne 'single') {
781: $Str .= 'multiple="true" ';
782: }
783: $Str .= 'size="'.$numvisible.'" >'."\n";
784: #
785: # Loop through the sequences
786: foreach my $s (@Sections) {
787: $Str .= ' <option value="'.$s.'" ';
788: foreach (@SelectedSections) {
1.61 matthew 789: if ($s eq $_) {
1.60 matthew 790: $Str .= 'selected ';
791: last;
792: }
793: }
794: $Str .= '>'.$s."</option>\n";
795: }
796: $Str .= "</select>\n";
797: return $Str;
798: }
799:
1.61 matthew 800: ##################################################
801: ##################################################
1.60 matthew 802: sub DisplayClasslist {
803: my ($r)=@_;
804: #
805: my @Fields = ('fullname','username','domain','id','section');
806: #
807: my $Str='';
808: $Str .= '<table border="0"><tr><td bgcolor="#777777">'."\n";
809: $Str .= '<table border="0" cellpadding="3"><tr bgcolor="#e6ffff">'."\n";
810: foreach my $field (@Fields) {
1.65 matthew 811: $Str .= '<th><a href="/adm/statistics?reportSelected=classlist&sort='.$field.'">'.$field.
1.60 matthew 812: '</a></th>';
813: }
814: $Str .= '</tr>'."\n";
815: #
816: my $alternate = 0;
1.65 matthew 817: foreach my $student (@Students) { # @Students is a package variable
1.60 matthew 818: my $sname = $student->{'username'}.':'.$student->{'domain'};
819: if($alternate) {
820: $Str .= '<tr bgcolor="#ffffe6">';
821: } else {
822: $Str .= '<tr bgcolor="#ffffc6">';
823: }
824: $alternate = ($alternate + 1) % 2;
825: #
826: foreach my $field (@Fields) {
827: $Str .= '<td>';
828: if ($field eq 'fullname') {
829: $Str .= '<a href="/adm/statistics?reportSelected=';
1.65 matthew 830: $Str .= &Apache::lonnet::escape('student_assessment');
1.72 matthew 831: $Str .= '&sort='.&Apache::lonnet::escape($ENV{'form.sort'});
832: $Str .= '&SelectedStudent=';
1.61 matthew 833: $Str .= &Apache::lonnet::escape($sname).'">';
1.60 matthew 834: $Str .= $student->{$field}.' ';
835: $Str .= '</a>';
836: } else {
837: $Str .= $student->{$field};
838: }
839: $Str .= '</td>';
840: }
841: $Str .= "</tr>\n";
842: }
843: $Str .= '</table></td></tr></table>'."\n";
844: #
845: $r->print($Str);
846: $r->rflush();
847: #
848: return;
849: }
850:
1.65 matthew 851: ##############################################
852: ##############################################
1.33 stredwic 853: sub CreateMainMenu {
1.65 matthew 854: my ($status,$reports,$current)=@_;
855: #
1.33 stredwic 856: my $Str = '';
1.65 matthew 857: #
1.33 stredwic 858: $Str .= '<table border="0"><tbody><tr>'."\n";
1.63 matthew 859: $Str .= '<td></td>'."\n";
1.73 matthew 860: $Str .= '<td align="center"><b>Select a Report</b></td>'."\n";
861: $Str .= '<td></td>'."\n";
1.67 matthew 862: $Str .= '<td></td>'."\n";
1.33 stredwic 863: $Str .= '<tr>'."\n";
1.65 matthew 864: #
1.67 matthew 865: $Str .= '<td align="center">'.
866: '<input type="submit" name="Refresh" value="Update Display" />'.
867: "</td>\n";
1.65 matthew 868: #
1.33 stredwic 869: $Str .= '<td align="center">';
1.65 matthew 870: $Str .= '<select name="reportSelected" >'."\n";
1.33 stredwic 871: foreach (sort(keys(%$reports))) {
1.65 matthew 872: $Str .= '<option value="'.$_.'"';
873: if($current eq $_) {
874: $Str .= ' selected';
1.33 stredwic 875: }
876: $Str .= '>'.$reports->{$_}.'</option>'."\n";
877: }
878: $Str .= '</select></td>'."\n";
1.65 matthew 879: #
1.73 matthew 880: $Str .= '<td>'.(' 'x30).'</td>';
881: $Str .= '<td align="center">'.
882: '<input type="submit" name="ClearCache" value="Clear Caches" />'.
883: "</td>\n";
1.33 stredwic 884: $Str .= '</tr></tbody></table>'."\n";
885: $Str .= '<hr>'."\n";
1.65 matthew 886: #
1.33 stredwic 887: return $Str;
888: }
889:
1.65 matthew 890: ##############################################
891: ##############################################
1.1 albertel 892: sub handler {
1.31 minaeibi 893: my $r=shift;
1.65 matthew 894: my $c = $r->connection();
895: #
896: # Check for overloading
1.51 www 897: my $loaderror=&Apache::lonnet::overloaderror($r);
898: if ($loaderror) { return $loaderror; }
899: $loaderror=
900: &Apache::lonnet::overloaderror($r,
901: $ENV{'course.'.$ENV{'request.course.id'}.'.home'});
902: if ($loaderror) { return $loaderror; }
1.65 matthew 903: #
904: # Check for access
1.69 matthew 905: if (! &Apache::lonnet::allowed('vgr',$ENV{'request.course.id'})) {
1.27 stredwic 906: $ENV{'user.error.msg'}=
1.69 matthew 907: $r->uri.":vgr:0:0:Cannot view grades for complete course";
908: if (! &Apache::lonnet::allowed('vgr',
909: $ENV{'request.course.id'}.'/'.$ENV{'request.course.sec'})) {
910: $ENV{'user.error.msg'}=
911: $r->uri.":vgr:0:0:Cannot view grades with given role";
912: return HTTP_NOT_ACCEPTABLE;
913: }
1.27 stredwic 914: }
1.65 matthew 915: #
1.27 stredwic 916: # Set document type for header only
917: if($r->header_only) {
918: if ($ENV{'browser.mathml'}) {
919: $r->content_type('text/xml');
920: } else {
921: $r->content_type('text/html');
922: }
923: &Apache::loncommon::no_cache($r);
924: $r->send_http_header;
925: return OK;
926: }
1.65 matthew 927: #
928: # Send the header
1.27 stredwic 929: $r->content_type('text/html');
930: $r->send_http_header;
1.65 matthew 931: #
932: # Extract form elements from query string
1.60 matthew 933: &Apache::loncommon::get_unprocessed_cgi($ENV{'QUERY_STRING'},
1.65 matthew 934: ['sort','reportSelected',
1.72 matthew 935: 'SelectedStudent']);
1.65 matthew 936: if (! exists($ENV{'form.reportSelected'})) {
937: $ENV{'form.reportSelected'} = 'student_assessment';
938: }
939: #
940: # Give the LON-CAPA page header
941: $r->print(&Apache::lonhtmlcommon::Title('Course Statistics and Charts'));
942: $r->rflush();
943: #
1.66 matthew 944: if (! &Apache::lonmysql::verify_sql_connection()) {
945: my $serveradmin = $r->dir_config('lonAdmEMail');
946: $r->print(<<END);
947: <h2><font color="Red">Unable to connect to database!</font></h2>
948: <p>
949: Please notify the server administrator <b>$serveradmin</b>.
950: </p><p>
951: Course Statistics and Charts cannot be retrieved until the database is
952: restarted. Your data is intact but cannot be displayed at this time.
953: </p>
954: </body>
955: </html>
956: END
957: return;
1.67 matthew 958: }
959: #
960: # Clean out the caches
961: if (exists($ENV{'form.ClearCache'})) {
962: &Apache::loncoursedata::delete_caches($ENV{'requres.course.id'});
1.66 matthew 963: }
964: #
1.65 matthew 965: # Set up the statistics and chart environment
1.71 matthew 966: &PrepareClasslist();
1.60 matthew 967: &PrepareCourseData($r);
1.65 matthew 968: #
969: # Begin form output
970: $r->print('<form name="Statistics" ');
971: $r->print('method="post" action="/adm/statistics">');
972: #
973: # Print main menu
974: my %reports = ('classlist' => 'Class list',
975: 'problem_statistics' => 'Problem Statistics',
1.66 matthew 976: 'student_assessment' => 'Problem Status Chart',
1.74 matthew 977: # 'percentage' => 'Correct-problems Plot',
978: # 'option_response' => 'Option Response Analysis',
1.65 matthew 979: # 'activitylog' => 'Activity Log',
980: );
981: $r->print(&CreateMainMenu($ENV{'form.status'},
982: \%reports,$ENV{'form.reportSelected'}));
983: $r->rflush();
984: #
985: my $GoToPage = $ENV{'form.reportSelected'};
986: if($GoToPage eq 'activitylog') {
987: # &Apache::lonproblemstatistics::Activity();
988: } elsif($GoToPage eq 'problem_statistics') {
989: &Apache::lonproblemstatistics::BuildProblemStatisticsPage($r,$c);
990: } elsif($GoToPage eq 'option_response') {
991: # &Apache::lonproblemanalysis::BuildProblemAnalysisPage($r,$c);
992: } elsif($GoToPage eq 'student_assessment') {
993: &Apache::lonstudentassessment::BuildStudentAssessmentPage($r,$c);
994: } elsif($GoToPage eq 'DoDiffGraph' || $GoToPage eq 'PercentWrongGraph') {
995: # &Apache::lonproblemstatistics::BuildGraphicChart($r,$c);
996: } elsif($GoToPage eq 'classlist') {
997: &DisplayClasslist($r);
998: } elsif($GoToPage eq 'Correct-problems Plot') {
999: # &Apache::lonpercentage::BuildPercentageGraph($r,$c);
1000: }
1001: #
1002: $r->print("</form>\n");
1003: $r->print("</body>\n</html>\n");
1004: $r->rflush();
1005: #
1.27 stredwic 1006: return OK;
1.1 albertel 1007: }
1.65 matthew 1008:
1.1 albertel 1009: 1;
1.59 matthew 1010:
1.65 matthew 1011: #######################################################
1012: #######################################################
1013:
1.59 matthew 1014: =pod
1015:
1016: =back
1017:
1018: =cut
1.65 matthew 1019:
1020: #######################################################
1021: #######################################################
1.59 matthew 1022:
1.1 albertel 1023: __END__
1.31 minaeibi 1024:
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>
![[BACK]](/icons/back.gif){kind=icon}
Return to lonstatistics.pm CVS log ![[TXT]](/icons/text.gif){kind=icon}
![[DIR]](/icons/dir.gif){kind=icon}
Up to [LON-CAPA] / loncom / interface