# The LearningOnline Network with CAPA
# Quick Student Grades Display
#
# $Id: lonquickgrades.pm,v 1.104 2014/05/20 20:32:16 musolffc Exp $
#
# Copyright Michigan State University Board of Trustees
#
# This file is part of the LearningOnline Network with CAPA (LON-CAPA).
#
# LON-CAPA is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License, or
# (at your option) any later version.
#
# LON-CAPA is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with LON-CAPA; if not, write to the Free Software
# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
#
# /home/httpd/html/adm/gpl.txt
#
# http://www.lon-capa.org/
#
package Apache::lonquickgrades;
use strict;
use Apache::Constants qw(:common :http REDIRECT);
use POSIX;
use Apache::loncommon;
use Apache::lonlocal;
use Apache::lonnet;
use Apache::grades;
use Apache::loncoursedata;
use Apache::lonstudentassessment;
use Time::HiRes;
use Spreadsheet::WriteExcel;
use Spreadsheet::WriteExcel::Utility();
#
# Excel data
#
my $excel_sheet;
my $excel_workbook;
my $filename;
my $format;
my $request_aborted;
my $header_row;
my $cols_output;
my %prog_state;
sub handler {
my $r = shift;
return real_handler($r);
}
sub real_handler {
my $r = shift;
# Check for critical messages and redirect if present.
my ($redirect,$url) = &Apache::loncommon::critical_redirect(300);
if ($redirect) {
&Apache::loncommon::content_type($r,'text/html');
$r->header_out(Location => $url);
return REDIRECT;
}
&Apache::loncommon::get_unprocessed_cgi($ENV{QUERY_STRING});
# Handle header-only request
if ($env{'browser.mathml'}) {
&Apache::loncommon::content_type($r,'text/xml');
} else {
&Apache::loncommon::content_type($r,'text/html');
}
if ($r->header_only) {
$r->send_http_header;
return OK;
}
# Send header, don't cache this page
&Apache::loncommon::no_cache($r);
$r->send_http_header;
my $showPoints =
(($env{'course.'.$env{'request.course.id'}.'.grading'} eq 'standard')
|| ($env{'course.'.$env{'request.course.id'}.'.grading'} eq 'categories'));
my $notshowSPRSlink =
(($env{'course.'.$env{'request.course.id'}.'.grading'} eq 'external')
|| ($env{'course.'.$env{'request.course.id'}.'.grading'} eq 'externalnototals'));
my $notshowTotals=
$env{'course.'.$env{'request.course.id'}.'.grading'} eq 'externalnototals';
my $showCategories=
$env{'course.'.$env{'request.course.id'}.'.grading'} eq 'categories';
my $title = "Grading and Statistics";#$showPoints ? "Points Display" : "Completed Problems Display";
my $brcrum = [{href=>"/adm/quickgrades",text => "Points Display"}];
$r->print(&Apache::loncommon::start_page($title,undef,
{'bread_crumbs' => $brcrum})
);
&startGradeScreen($r,'quick');
my $cangrade=&Apache::lonnet::allowed('mgr');
#
# Pick student
#
my $uname;
my $udom;
my $stdid;
if ($cangrade) {
$r->print("<h2>".&mt("Download Multiple")."</h2>".
'<table cellspacing="5">'."\n".
'<tr>'.
'<td align="center"><b>'.&mt('Sections').'</b>'.
&Apache::loncommon::help_open_topic("Chart_Sections").
'</td>'.
'<td align="center"><b>'.&mt('Groups').'</b>'.
'</td>'.
'<td align="center"><b>'.&mt('Student Data').'</b>'.
&Apache::loncommon::help_open_topic("Chart_Student_Data").
'</td>'.
'<td align="center"><b>'.&mt('Access Status').'</b>'.
&Apache::loncommon::help_open_topic("Chart_Enrollment_Status").
'</td>'.
'<td align="center"><b>'.&mt('Output Format').'</b>'.
&Apache::loncommon::help_open_topic("Chart_Output_Formats").
'</td><td> </td></tr>'."\n".
'<tr><td align="center">'."\n".
&Apache::lonstatistics::SectionSelect('Section','multiple',5).
'</td><td align="center">'.
&Apache::lonstatistics::GroupSelect('Group','multiple',5).
'</td><td align="center">'.
&Apache::lonstatistics::StudentDataSelect('StudentData','multiple',5,undef).
'</td><td>'."\n".
&Apache::lonhtmlcommon::StatusOptions(undef,undef,5).
'</td><td>'."\n".
&Apache::lonstudentassessment::CreateAndParseOutputSelector().
'</td><td>'.
'<input type="submit" name="download" value="'.&mt('Display/Download Multiple Students').'" />'.
'</td></tr>'."\n".
'</table>'."\n"
);
$r->print("<hr /><h2>".&mt("Display Individual")."</h2>");
if ($env{'form.uname'}) { $uname=$env{'form.uname'}; }
if ($env{'form.udom'}) { $udom=$env{'form.udom'}; }
if ($env{'form.id'}) { $stdid=$env{'form.id'}; }
if (($stdid) && ($udom)) {
$uname=(&Apache::lonnet::idget($udom,$stdid))[1];
}
if (($stdid) && (!$uname)) {
$r->print('<p><span class="LC_warning">'.&mt("Unknown Student/Employee ID: [_1]",$stdid).'</span></p>');
$stdid='';
}
$r->print('<form method="post" name="quickform" action="/adm/quickgrades">');
my $chooseopt=&Apache::loncommon::select_dom_form($udom,'udom').' '.
&Apache::loncommon::selectstudent_link('quickform','uname','udom');
$r->print("<p>\n".&Apache::loncommon::studentbrowser_javascript()."\n");
$r->print(&mt('For User [_1] or Student/Employee ID [_2] at Domain [_3]'
,'<input type="text" value="'.$uname.'" size="12" name="uname" />'
,'<input type="text" value="'.$stdid.'" size="12" name="id" /> '
,$chooseopt).
' <input type="submit" name="display" value="'.&mt('Display Individual Student').'" /></p>');
if (($uname) && ($udom)) {
$r->print('<p>'.&mt('Full Name: [_1]',&Apache::loncommon::plainname($uname,$udom)).'</p>');
}
}
$r->rflush();
my ($navmap,$totalParts,$totalPossible,$totalRight,$totalAttempted,$topLevelParts,$topLevelRight,$topLevelAttempted)=
&getData($showPoints,$uname,$udom);
if ($showCategories) {
&outputCategories($r,$showPoints,$notshowTotals,
$navmap,$totalParts,$totalPossible,$totalRight,$totalAttempted,$topLevelParts,$topLevelRight,$topLevelAttempted);
} else {
&outputTable($r,$showPoints,$notshowTotals,
$navmap,$totalParts,$totalPossible,$totalRight,$totalAttempted,$topLevelParts,$topLevelRight,$topLevelAttempted);
}
if ($cangrade) { $r->print("\n</form>\n"); }
&endGradeScreen($r);
return OK;
}
sub getStudentCatGrade {
my ($uname,$udom,%categories)=@_;
my ($navmap,$totalParts,$totalPossible,$totalRight,$totalAttempted,$topLevelParts,$topLevelRight,$topLevelAttempted)=
&getData(1,$uname,$udom);
return &output_category_table(undef,0,$navmap,0,%categories);
}
sub getAllStudentData {
my $cdom = $env{'course.'.$env{'request.course.id'}.'.domain'};
my $cnum = $env{'course.'.$env{'request.course.id'}.'.num'};
my %categories=&Apache::lonnet::dump('grading_categories',$cdom,$cnum);
my $classlist = &Apache::loncoursedata::get_classlist();
my $statusidx = &Apache::loncoursedata::CL_STATUS();
my $usernameidx = &Apache::loncoursedata::CL_SNAME();
my $domainidx = &Apache::loncoursedata::CL_SDOM();
my $fullnameidx = &Apache::loncoursedata::CL_FULLNAME();
foreach my $key (keys(%{$classlist})) {
my $student = $classlist->{$key};
my $perc=&getStudentCatGrade($classlist->{$student}->[$usernameidx],
$classlist->{$student}->[$domainidx],
%categories);
}
}
sub startGradeScreen {
my ($r,$mode)=@_;
my $showPoints =
$env{'course.'.$env{'request.course.id'}.'.grading'} eq 'standard';
my $notshowSPRSlink =
(($env{'course.'.$env{'request.course.id'}.'.grading'} eq 'external')
|| ($env{'course.'.$env{'request.course.id'}.'.grading'} eq 'externalnototals')
|| ($env{'course.'.$env{'request.course.id'}.'.grading'} eq 'categories'));
my $notshowTotals=
$env{'course.'.$env{'request.course.id'}.'.grading'} eq 'externalnototals';
my $showCategories=
$env{'course.'.$env{'request.course.id'}.'.grading'} eq 'categories';
my $allowed_to_view = &Apache::lonnet::allowed('vgr',$env{'request.course.id'});
my $allowed_to_edit = &Apache::lonnet::allowed('mgr',$env{'request.course.id'});
if ($allowed_to_view) {
my @notes;
push(@notes,&mt('Students do not see total points.')) if ($notshowTotals);
push(@notes,&mt('Students do not see link to spreadsheet.')) if ($notshowSPRSlink);
push(@notes,&mt('Students will see points based on problem weights.')) if ($showPoints);
push(@notes,&mt('Students will see points based on categories.')) if ($showCategories);
push(@notes, &Apache::lonhtmlcommon::coursepreflink(&mt('Grade display settings'),'grading'));
$r->print(&Apache::loncommon::head_subbox(join(' ',@notes)));
}
$r->print("\n".'<ul class="LC_TabContentBigger" id="main">');
$r->print("\n".'<li'.($mode eq 'quick'?' class="active"':'').'><a href="/adm/quickgrades"><b> '.
($showPoints?&mt('Individual Points Overview'):($showCategories?&mt('Grades Overview'):&mt('Completion Overview'))).
' </b></a></li>');
if (!($showPoints || $notshowSPRSlink) || ($allowed_to_view)) {
$r->print("\n".'<li'.($mode eq 'spreadsheet'?' class="active"':'').'><a href="/adm/'.($allowed_to_view?'classcalc':'studentcalc').'"><b>'.
&mt('Spreadsheet (Detailed)').'</b></a></li>');
}
if ($allowed_to_view) {
$r->print("\n".'<li'.($mode eq 'statistics'?' class="active"':'').'><a href="/adm/statistics"><b>'.
&mt('Statistics and Reports').'</b></a></li>');
$r->print("\n".'<li'.($mode eq 'chart'?' class="active"':'').'><a href="/adm/statistics?reportSelected=student_assessment"><b>'.
&mt('Assessment Overview Chart').'</b></a></li>');
}
if ($allowed_to_edit) {
$r->print("\n".'<li'.($mode eq 'grading'?' class="active"':'').'><a href="/adm/grades"><b> '.
&mt('Content Grading').' </b></a></li>');
if ($env{'form.symb'}) {
$r->print("\n".'<li'.($mode eq 'probgrading'?' class="active"':'').'><a href="/adm/grades?symb='.
&Apache::lonhtmlcommon::entity_encode($env{'form.symb'}).
'&command=gradingmenu"><b> '.
&mt('Problem Grading').' </b></a></li>');
}
}
$r->print("\n".'</ul>'."\n");
$r->print('<div class="LC_Box" style="clear:both;margin:0;"><div id="maincoursedoc" style="margin:0 0;padding:0 0;"><div class="LC_ContentBox" id="mainCourseDocuments" style="display: block;">');
}
sub endGradeScreen {
my ($r)=@_;
$r->print('</div></div></div>'.&Apache::loncommon::end_page());
}
# -----------
sub excel_cleanup {
undef ($excel_sheet);
undef ($excel_workbook);
undef ($filename);
undef ($format);
}
sub excel_initialize {
my ($r) = @_;
&excel_cleanup();
# Create sheet
($excel_workbook,$filename,$format)=
&Apache::loncommon::create_workbook($r);
return if (! defined($excel_workbook));
#
# Add a worksheet
my $sheetname = $env{'course.'.$env{'request.course.id'}.'.description'};
$sheetname = &Apache::loncommon::clean_excel_name($sheetname);
$excel_sheet = $excel_workbook->addworksheet($sheetname);
#
# Put the course description in the header
$excel_sheet->write($header_row,$cols_output++,
$env{'course.'.$env{'request.course.id'}.'.description'},
$format->{'h1'});
}
sub excel_finish {
my ($r) = @_;
if ($request_aborted || ! defined($excel_sheet)) {
&excel_cleanup();
return;
}
#
# Write the excel file
$excel_workbook->close();
#
# Close the progress window
&Apache::lonhtmlcommon::Close_PrgWin($r,\%prog_state);
#
# Tell the user where to get their excel file
$r->print('<br />'.
'<a href="'.$filename.'">'.&mt('Your Excel spreadsheet').'</a>'."\n");
$r->rflush();
&excel_cleanup();
return;
}
#
# CSV data
#
# -----------
#
# Go through the complete course and collect data
#
sub getData {
my ($showPoints,$uname,$udom)=@_;
# Create the nav map
my $navmap = Apache::lonnavmaps::navmap->new($uname,$udom);
my $res = $navmap->firstResource(); # temp resource to access constants
my $iterator = $navmap->getIterator(undef, undef, undef, 1);
my $depth = 1;
$iterator->next(); # ignore first BEGIN_MAP
my $curRes = $iterator->next();
# General overview of the following: Walk along the course resources.
# For every problem in the resource, tell its parent maps how many
# parts and how many parts correct it has. After that, each map will
# have a count of the total parts underneath it, correct and otherwise.
# After that, we will walk through the course again and read off
# maps in order, with their data.
# (If in the future people decide not to be cumulative, only add
# the counts to the parent map.)
# For convenience, "totalParts" is also "totalPoints" when we're looking
# at points; I can't come up with a variable name that makes sense
# equally for both cases.
my $totalParts = 0; my $totalPossible = 0; my $totalRight = 0;
my $totalAttempted = 0;
my $now = time();
my $topLevelParts = 0; my $topLevelRight = 0; my $topLevelAttempted = 0;
# Pre-run: Count parts correct
while ( $depth > 0 ) {
if ($curRes == $iterator->BEGIN_MAP()) {$depth++;}
if ($curRes == $iterator->END_MAP()) { $depth--; }
if (ref($curRes) && $curRes->is_problem() && !$curRes->randomout)
{
# Get number of correct, incorrect parts
my $parts = $curRes->parts();
my $partsRight = 0;
my $partsCount = 0;
my $partsAttempted = 0;
my $stack = $iterator->getStack();
for my $part (@{$parts}) {
my $dateStatus = $curRes->getDateStatus($part);
my $weight = $curRes->weight($part);
my $problemstatus = $curRes->problemstatus($part);
if ($curRes->solved($part) eq 'excused') {
next;
}
if ($showPoints) {
my $score = 0;
# If we're not telling status and the answer date isn't passed yet,
# it's an "attempted" point
if ((($problemstatus eq 'no') ||
($problemstatus eq 'no_feedback_ever')) &&
($dateStatus != $curRes->ANSWER_OPEN)) {
my $status = $curRes->simpleStatus($part);
if ($status == $curRes->ATTEMPTED) {
$partsAttempted += $weight;
$totalAttempted += $partsAttempted;
}
} else {
$score = &Apache::grades::compute_points($weight, $curRes->awarded($part));
}
$partsRight += $score;
$totalRight += $score;
$partsCount += $weight;
$curRes->{DATA}->{PROB_SCORE} += $score;
$curRes->{DATA}->{PROB_WEIGHT} += $weight;
if ($curRes->opendate($part) < $now) {
$totalPossible += $weight;
$curRes->{DATA}->{PROB_POSSIBLE} += $weight;
}
$totalParts += $weight;
} else {
my $status = $curRes->simpleStatus($part);
my $thisright = 0;
$partsCount++;
if ($status == $curRes->CORRECT ||
$status == $curRes->PARTIALLY_CORRECT ) {
$partsRight++;
$totalRight++;
$thisright = 1;
}
if ($status == $curRes->ATTEMPTED) {
$partsAttempted++;
$totalAttempted++;
}
$totalParts++;
if ($curRes->opendate($part) < $now) {
$totalPossible++;
}
}
}
if ($depth == 1) { # in top-level only
$topLevelParts += $partsCount;
$topLevelRight += $partsRight;
$topLevelAttempted += $partsAttempted;
}
# Crawl down stack and record parts correct and total
for my $res (@{$stack}) {
if (ref($res) && $res->is_map()) {
if (!defined($res->{DATA}->{CHILD_PARTS})) {
$res->{DATA}->{CHILD_PARTS} = 0;
$res->{DATA}->{CHILD_CORRECT} = 0;
$res->{DATA}->{CHILD_ATTEMPTED} = 0;
}
$res->{DATA}->{CHILD_PARTS} += $partsCount;
$res->{DATA}->{CHILD_CORRECT} += $partsRight;
$res->{DATA}->{CHILD_ATTEMPTED} += $partsAttempted;
}
}
}
$curRes = $iterator->next();
}
return ($navmap,$totalParts,$totalPossible,$totalRight,$totalAttempted,$topLevelParts,$topLevelRight,$topLevelAttempted);
}
#
# Outputting everything.
#
sub outputTable {
my ($r,$showPoints,$notshowTotals,
$navmap,$totalParts,$totalPossible,$totalRight,$totalAttempted,$topLevelParts,$topLevelRight,$topLevelAttempted)=@_;
my @start = (255, 255, 192);
my @end = (0, 192, 0);
my $indentString = ' ';
# Second pass: Print the maps.
$r->print(&Apache::loncommon::start_data_table()
.&Apache::loncommon::start_data_table_header_row()
.'<th>'.&mt('Folder').'</th>');
my $title = &mt($showPoints ? "Points Scored" : "Done");
if ($totalAttempted) {
$title .= " / " . &mt("Attempted");
}
$r->print("<th>$title".($notshowTotals?'':" / ".&mt('Total')).'</th>'
.&Apache::loncommon::end_data_table_header_row());
#
# Output of folder scores
#
my $iterator = $navmap->getIterator(undef, undef, undef, 1);
my $depth = 1;
$iterator->next(); # ignore first BEGIN_MAP
my $curRes = $iterator->next();
while ($depth > 0) {
if ($curRes == $iterator->BEGIN_MAP()) {$depth++;}
if ($curRes == $iterator->END_MAP()) { $depth--; }
if (ref($curRes) && $curRes->is_map()) {
my $title = $curRes->compTitle();
my $correct = $curRes->{DATA}->{CHILD_CORRECT};
my $total = $curRes->{DATA}->{CHILD_PARTS};
my $attempted = $curRes->{DATA}->{CHILD_ATTEMPTED};
if ($total > 0) {
my $ratio;
$ratio = $correct / $total;
my $color = &mixColors(\@start, \@end, $ratio);
$r->print(&Apache::loncommon::start_data_table_row()
.'<td style="background-color:'.$color.';">');
my $thisIndent = '';
for (my $i = 1; $i < $depth; $i++) { $thisIndent .= $indentString; }
$r->print("$thisIndent$title</td>");
if ($totalAttempted) {
$r->print('<td valign="top">'
.$thisIndent
.'<span class="LC_nobreak">'
.$correct.' / '.$attempted.($notshowTotals?'':' / '.$total)
.'</span></td>'
.&Apache::loncommon::end_data_table_row()
);
} else {
$r->print('<td valign="top">'
.$thisIndent
.'<span class="LC_nobreak">'
.$correct.($notshowTotals?'':' / '.$total)
.'</span></td>'
.&Apache::loncommon::end_data_table_row());
}
}
}
$curRes = $iterator->next();
}
# If there were any problems at the top level, print an extra "catchall"
if ($topLevelParts > 0) {
my $ratio = $topLevelRight / $topLevelParts;
my $color = &mixColors(\@start, \@end, $ratio);
$r->print(&Apache::loncommon::start_data_table_row()
.'<td style="background-color:'.$color.';">');
$r->print(&mt("Problems Not Contained In A Folder")."</td><td>");
$r->print("$topLevelRight / $topLevelParts</td>"
.&Apache::loncommon::end_data_table_row());
}
#
# show totals (if applicable), close table
#
if ($showPoints) {
my $maxHelpLink = &Apache::loncommon::help_open_topic("Quick_Grades_Possibly_Correct");
$title = $showPoints ? "Points" : "Parts Done";
my $totaltitle = $showPoints ? &mt("Awarded Total Points") : &mt("Total Parts Done");
$r->print(&Apache::loncommon::start_data_table_row()
.'<td colspan="2" align="right">'.$totaltitle.': <b>'.$totalRight.'</b><br />');
$r->print(&mt('Max Possible To Date')." $maxHelpLink: <b>$totalPossible</b><br />");
$title = $showPoints ? "Points" : "Parts";
$r->print(&mt("Total $title In Course").': <b>'.$totalParts.'</b></td>'
.&Apache::loncommon::end_data_table_row());
}
$r->print(&Apache::loncommon::end_data_table());
}
#
# === Outputting category-based grades.
#
# $category{'order'}: output order of categories by id
# $category{'all'}: complete list of all categories
# $category{$id.'_name'}: display-name of category
#
sub outputCategories {
my ($r,$showPoints,$notshowTotals,
$navmap,$totalParts,$totalPossible,$totalRight,$totalAttempted,$topLevelParts,$topLevelRight,$topLevelAttempted)=@_;
# Take care of storing and retrieving categories
my $cangrade=&Apache::lonnet::allowed('mgr');
my $cdom = $env{'course.'.$env{'request.course.id'}.'.domain'};
my $cnum = $env{'course.'.$env{'request.course.id'}.'.num'};
my %categories=();
# Loading old categories
%categories=&Apache::lonnet::dump('grading_categories',$cdom,$cnum);
# Storing
if (($cangrade) && (($env{'form.storechanges'}) || ($env{'form.storemove'} ne '') || ($env{'form.cmd'} ne ''))) {
# Process the changes
%categories=&process_category_edits($r,$cangrade,%categories);
# Actually store
&Apache::lonnet::put('grading_categories',\%categories,$cdom,$cnum);
}
# new categories loaded now
&output_category_table($r,$cangrade,$navmap,1,%categories);
#
if ($cangrade) {
$r->print(&Apache::loncommon::resourcebrowser_javascript().
'<input type="hidden" name="storemove" value="" />'.
'<input type="hidden" name="cmd" value="" />'.
'<input type="hidden" name="resourcesymb" value="" />'.
'<input type="submit" name="storechanges" value="'.&mt("Save changes to grading categories").'" />'.
'<script>function storecmd (cmd) { document.quickform.cmd.value=cmd; document.quickform.submit(); }</script>');
}
}
#
# Get data for all symbs
#
sub dumpdata {
my ($navmap)=@_;
my %returndata=();
# Run through the map and get all data
my $iterator = $navmap->getIterator(undef, undef, undef, 1);
my $depth = 1;
$iterator->next(); # ignore first BEGIN_MAP
my $curRes = $iterator->next();
while ($depth > 0) {
if ($curRes == $iterator->BEGIN_MAP()) {$depth++;}
if ($curRes == $iterator->END_MAP()) { $depth--; }
if (ref($curRes)) {
if ($curRes->is_map()) {
$returndata{$curRes->symb()}='folder:'.$curRes->{DATA}->{CHILD_PARTS}.':'.$curRes->{DATA}->{CHILD_ATTEMPTED}.':'.$curRes->{DATA}->{CHILD_CORRECT};
} else {
$returndata{$curRes->symb()}='res:'.$curRes->{DATA}->{PROB_WEIGHT}.':'.$curRes->{DATA}->{PROB_POSSIBLE}.':'.$curRes->{DATA}->{PROB_SCORE};
}
}
$curRes = $iterator->next();
}
return %returndata;
}
#
# Process editing commands, update category hash
#
sub process_category_edits {
my ($r,$cangrade,%categories)=@_;
unless ($cangrade) { return %categories; }
# First store everything
foreach my $id (split(/\,/,$categories{'order'})) {
# Set names, types, and weight (there is only one of each per category)
%categories=&set_category_name($cangrade,$id,$env{'form.name_'.$id},%categories);
%categories=&set_category_total($cangrade,$id,$env{'form.totaltype_'.$id},$env{'form.total_'.$id},%categories);
%categories=&set_category_weight($cangrade,$id,$env{'form.weight_'.$id},%categories);
%categories=&set_category_displayachieved($cangrade,$id,$env{'form.displayachieved_'.$id},%categories);
# Set values for category rules (before names may change)
%categories=&set_category_rules($cangrade,$id,%categories);
}
# Now deal with commands
my $cmd=$env{'form.cmd'};
if ($cmd eq 'createnewcat') {
%categories=&make_new_category($r,$cangrade,undef,%categories);
} elsif ($cmd=~/^up\_(.+)$/) {
%categories=&move_up_category($1,$cangrade,%categories);
} elsif ($cmd=~/^down\_(.+)$/) {
%categories=&move_down_category($1,$cangrade,%categories);
} elsif ($cmd=~/^delcat\_(.+)$/) {
%categories=&del_category($1,$cangrade,%categories);
} elsif ($cmd=~/^addcont\_(.+)$/) {
%categories=&add_category_content($1,$cangrade,$env{'form.resourcesymb'},%categories);
} elsif ($cmd=~/^delcont\_(.+)\_\_\_\_\_\_(.+)$/) {
%categories=&del_category_content($1,$cangrade,$2,%categories);
} elsif ($cmd=~/^newrule\_(.+)$/) {
%categories=&add_calculation_rule($1,$cangrade,':',%categories);
} elsif ($cmd=~/^delrule\_(.+)\_\_\_\_\_\_(.*)$/) {
%categories=&del_calculation_rule($1,$cangrade,$2,%categories);
}
# Move to a new position
my $moveid=$env{'form.storemove'};
if ($moveid) {
%categories=&move_category($moveid,$cangrade,$env{'form.newpos_'.$moveid},%categories);
}
return %categories;
}
#
# Output the table
#
sub output_category_table {
my ($r,$cangrade,$navmaps,$output,%categories)=@_;
my $totalweight=0;
my $totalpoints=0;
if ($output) {
$r->print(&Apache::loncommon::start_data_table());
#
&output_category_table_header($r,$cangrade);
}
#
my @order=split(/\,/,$categories{'order'});
#
my %performance=&dumpdata($navmaps);
my $maxpos=$#order;
for (my $i=0;$i<=$maxpos;$i++) {
my ($correct,$possible,$type,$weight)=&output_and_calc_category($r,$cangrade,$navmaps,$order[$i],$i,$maxpos,\%performance,$output,%categories);
unless ($possible) { next; }
$totalpoints+=$weight*$correct/$possible;
$totalweight+=$weight;
}
#
my $perc=0;
if ($totalweight) { $perc=100.*$totalpoints/$totalweight; }
if ($output) {
&bottom_line_category($r,$cangrade,$perc);
$r->print(&Apache::loncommon::end_data_table());
}
return $perc;
}
sub output_category_table_header {
my ($r,$cangrade)=@_;
$r->print(&Apache::loncommon::start_data_table_header_row());
if ($cangrade) {
$r->print('<th colspan="2">'.&mt("Move").'</th><th>'.&mt('Action').'</th>');
}
$r->print('<th>'.&mt('Category').'</th>'.
'<th>'.&mt('Contents').'</th>'.
'<th>'.&mt('Total Points').'</th>'.
'<th>'.&mt('Calculation').'</th>'.
'<th>'.&mt('Relative Weight').'</th>'.
'<th>'.&mt('Achieved').'</th>');
$r->print(&Apache::loncommon::end_data_table_header_row());
}
#
# Output one category to table
#
sub output_and_calc_category {
my ($r,$cangrade,$navmaps,$id,$currentpos,$maxpos,$performance,$output,%categories)=@_;
if ($output) { $r->print("\n".&Apache::loncommon::start_data_table_row()); }
if ($output && $cangrade) {
my $iconpath = &Apache::loncommon::lonhttpdurl($r->dir_config('lonIconsURL') . "/");
my %lt=&Apache::lonlocal::texthash(
'up' => 'Move Up',
'dw' => 'Move Down');
$r->print(<<ENDMOVE);
<td>
<div class="LC_docs_entry_move">
<a href='javascript:storecmd("up_$id");'>
<img src="${iconpath}move_up.gif" alt='$lt{'up'}' class="LC_icon" />
</a>
</div>
<div class="LC_docs_entry_move">
<a href='javascript:storecmd("down_$id");'>
<img src="${iconpath}move_down.gif" alt='$lt{'dw'}' class="LC_icon" />
</a>
</div>
</td>
ENDMOVE
$r->print("\n<td>\n<select name='newpos_$id' onchange='this.form.storemove.value=\"$id\";this.form.submit()'>");
for (my $i=0;$i<=$maxpos;$i++) {
if ($i==$currentpos) {
$r->print('<option value="" selected="selected">('.$i.')</option>');
} else {
$r->print('<option value="'.$i.'">'.$i.'</option>');
}
}
$r->print("\n</select>\n</td>\n");
$r->print('<td><a href="javascript:storecmd(\'delcat_'.$id.'\');">'.&mt('Delete').'</a></td>');
$r->print('<td><input type="text" name="name_'.$id.
'" value="'.&Apache::lonhtmlcommon::entity_encode($categories{$id.'_name'}).'" /></td>');
} elsif ($output) {
$r->print('<td>'.$categories{$id.'_name'}.'</td>');
}
# Content display and summing up of points
my $totalpossible=0;
my $totalcorrect=0;
my @individual=();
if ($output) { $r->print('<td><ul>'); }
foreach my $contentid (split(/\,/,$categories{$id.'_content'})) {
my ($type,$possible,$attempted,$correct)=split(/\:/,$$performance{$contentid});
$totalpossible+=$possible;
$totalcorrect+=$correct;
if ($possible>0) { push(@individual,"$possible:$correct"); }
if ($output) {
$r->print('<li>');
$r->print(&Apache::lonnet::gettitle($contentid).' ('.&numberout($correct).'/'.&numberout($possible).')');
if ($cangrade) {
$r->print(' <a href="javascript:storecmd(\'delcont_'.$id.'______'.$contentid.'\');">'.&mt('Delete').'</a>');
}
$r->print('</li>');
}
}
if ($output) {
$r->print('</ul>');
if ($cangrade) {
$r->print('<br />'.&Apache::loncommon::selectresource_link('quickform','addcont_'.$id,&mt('Add Problem or Folder')).'<br />');
}
$r->print('<p><b>'.&mt('Total raw points: [_1]/[_2]',&numberout($totalcorrect),&numberout($totalpossible)).'</b></p>');
$r->print('</td>');
}
# Total
if ($output) { $r->print('<td>'); }
if ($cangrade) {
if ($output) {
$r->print(
'<select name="totaltype_'.$id.'">'.
'<option value="default"'.($categories{$id.'_totaltype'} eq 'default'?' selected="selected"':'').'>'.&mt('default').'</option>'.
'<option value="typein"'.($categories{$id.'_totaltype'} eq 'typein'?' selected="selected"':'').'>'.&mt('Type-in value').'</option>'.
'</select>'.
'<input type="text" size="4" name="total_'.$id.
'" value="'.&Apache::lonhtmlcommon::entity_encode($categories{$id.'_total'}).'" />');
}
} else {
if ($output) {
$r->print('<td>'.($categories{$id.'_totaltype'} eq 'default'?&mt('default'):$categories{$id.'_total'}));
}
}
# Adjust total points
if ($categories{$id.'_totaltype'} eq 'typein') {
$totalpossible=1.*$categories{$id.'_total'};
}
if ($output) {
$r->print('<p><b>'.&mt('Adjusted raw points: [_1]/[_2]',&numberout($totalcorrect),&numberout($totalpossible)).'</b></p>');
}
# Calculation
if ($output) { $r->print('<td><ul>'); }
foreach my $calcrule (split(/\,/,$categories{$id.'_calculations'})) {
if ($output) { $r->print('<li>'); }
my ($code,$value)=split(/\:/,$calcrule);
if ($output) { $r->print(&pretty_prt_rule($cangrade,$id,$code,$value)); }
if ($cangrade) {
if ($output) { $r->print(' <a href="javascript:storecmd(\'delrule_'.$id.'______'.$code.'\');">'.&mt('Delete').'</a>'); }
}
if ($code eq 'capabove') {
if ($totalpossible>0) {
if ($totalcorrect/$totalpossible>$value/100.) {
$totalcorrect=$totalpossible*$value/100.;
}
}
} elsif ($code eq 'capbelow') {
if ($totalpossible>0) {
if ($totalcorrect/$totalpossible<$value/100.) {
$totalcorrect=$totalpossible*$value/100.;
}
}
} elsif ($code eq 'droplow') {
($totalpossible,$totalcorrect,@individual)=&drop(0,0,$value,@individual);
} elsif ($code eq 'drophigh') {
($totalpossible,$totalcorrect,@individual)=&drop(1,0,$value,@individual);
} elsif ($code eq 'droplowperc') {
($totalpossible,$totalcorrect,@individual)=&drop(0,1,$value,@individual);
} elsif ($code eq 'drophighperc') {
($totalpossible,$totalcorrect,@individual)=&drop(1,1,$value,@individual);
}
if ($output) { $r->print('</li>'); }
}
# Re-adjust total points if force total
if ($categories{$id.'_totaltype'} eq 'typein') {
$totalpossible=1.*$categories{$id.'_total'};
}
if ($output) {
$r->print('</ul>');
if ($cangrade) { $r->print('<br />'.&new_calc_rule_form($id)); }
$r->print('<p><b>'.&mt('Calculated points: [_1]/[_2]',&numberout($totalcorrect),&numberout($totalpossible)).'</b></p>');
$r->print('</td>');
}
#
# Prepare for export
#
# Weight
my $weight=$categories{$id.'_weight'};
unless (1.*$weight>0) { $weight=0; }
if ($cangrade) {
if ($output) {
$r->print('<td>'.
'<input type="text" size="4" name="weight_'.$id.
'" value="'.&Apache::lonhtmlcommon::entity_encode($weight).'" /></td>');
}
} else {
if ($output) {
$r->print('<td>'.$weight.'</td>');
}
}
# Achieved
my $type=$categories{$id.'_displayachieved'};
unless (($type eq 'percent') || ($type eq 'points')) { $type='points'; }
if ($output) { $r->print('<td>'); }
if ($cangrade) {
if ($output) {
$r->print('<select name="displayachieved_'.$id.'">'.
'<option value="percent"'.($type eq 'percent'?' selected="selected"':'').'>'.&mt('percent').'</option>'.
'<option value="points"'.($type eq 'points'?' selected="selected"':'').'>'.&mt('points').'</option>'.
'</select>');
}
}
if ($output) {
$r->print('<p><b>');
if ($type eq 'percent') {
my $perc='---';
if ($totalpossible) {
$perc=100.*$totalcorrect/$totalpossible;
}
$r->print(&mt('[_1] percent',&numberout($perc)));
} else {
$r->print(&mt('[_1]/[_2] points',&numberout($totalcorrect),&numberout($totalpossible)));
}
$r->print('</b></p>');
}
if ($output) { $r->print('</td>'); }
return ($totalcorrect,$totalpossible,$type,$weight);
}
#
# Drop folders and problems
#
sub drop {
my ($high,$percent,$n,@individual)=@_;
# Sort assignments by points or percent
my @newindividual=sort {
my ($pa,$ca)=split(/\:/,$a);
my ($pb,$cb)=split(/\:/,$b);
if ($percent) {
my $perca=0;
if ($pa>0) { $perca=$ca/$pa; }
my $percb=0;
if ($pb>0) { $percb=$cb/$pb; }
$perca<=>$percb;
} else {
$ca<=>$cb;
}
} @individual;
# Drop the ones we don't want
if ($#newindividual>=$n) {
if ($high) {
splice(@newindividual,$#newindividual+1-$n,$n);
} else {
splice(@newindividual,0,$n);
}
} else {
@newindividual=();
}
# Re-calculate how many points possible and achieved
my $newpossible=0;
my $newcorrect=0;
for my $score (@newindividual) {
my ($thispossible,$thiscorrect)=(split(/\:/,$score));
$newpossible+=$thispossible;
$newcorrect+=$thiscorrect;
}
return ($newpossible,$newcorrect,@newindividual);
}
#
# Bottom line with grades
#
sub bottom_line_category {
my ($r,$cangrade,$perc)=@_;
$r->print(&Apache::loncommon::start_data_table_row());
if ($cangrade) {
$r->print('<td colspan="3"><a href="javascript:storecmd(\'createnewcat\');">'.&mt('Create New Category').'</a></td>');
}
$r->print('<td colspan="6"><b>'.&mt('Total: [_1] percent',&numberout($perc)).'</b></td>');
}
sub numberout {
my ($number)=@_;
my $printout=sprintf("%.3f", $number);
$printout=~s/0+$//;
$printout=~s/\.$//;
return $printout;
}
#
# Make one new category
#
sub make_new_category {
my ($r,$cangrade,$ordernum,%categories)=@_;
unless ($cangrade) { return %categories; }
# Generate new ID
my $id=time.'_'.$$.'_'.rand(10000);
# Add new ID to list of all IDs ever created in this course
$categories{'all'}.=','.$id;
$categories{'all'}=~s/^\,//;
# Add new ID to ordered list of displayed and evaluated categories
$categories{'order'}.=','.$id;
$categories{'order'}=~s/^\,//;
# Move it into desired space
if (defined($ordernum)) {
%categories=&move_category($id,$cangrade,$ordernum,%categories);
}
$categories{$id.'_weight'}=0;
$categories{$id.'_totaltype'}='default';
$categories{$id.'_displayachieved'}='percent';
return %categories;
}
# === Calculation Rule Editing
sub category_rule_codes {
return &Apache::lonlocal::texthash(
'droplowperc' => 'Drop N lowest grade percentage problems/folders',
'drophighperc' => 'Drop N highest grade percentage problems/folderss',
'droplow' => 'Drop N lowest point problems/folders',
'drophigh' => 'Drop N highest point problems/folders',
'capabove' => 'Cap percentage above N percent',
'capbelow' => 'Cap percentage below N percent');
}
sub pretty_prt_rule {
my ($cangrade,$id,$code,$value)=@_;
my $cid=$id.'_'.$code;
my %lt=&category_rule_codes();
my $ret='<span class="LC_nobreak">';
if ($cangrade) {
$ret.='<select name="sel_'.$cid.'">';
foreach my $calc (''=>'',sort(keys(%lt))) {
$ret.='<option value="'.$calc.'"'.($calc eq $code?' selected="selected"':'').' />'.$lt{$calc}.'</input>';
}
$ret.='</select> N=<input type="text" size="5" name="val_'.$cid.'" value="'.$value.'" /></span>';
} else {
$ret.=$lt{$code}.'; N='.$value;
}
$ret.='</span>';
return $ret;
}
sub new_calc_rule_form {
my ($id)=@_;
return '<a href="javascript:storecmd(\'newrule_'.$id.'\');">'.&mt('New Calculation Rule').'</a>';
}
#
# Add a calculation rule
#
sub add_calculation_rule {
my ($id,$cangrade,$newcontent,%categories)=@_;
unless ($cangrade) { return %categories; }
my %newcontent=($newcontent => 1);
foreach my $current (split(/\,/,$categories{$id.'_calculations'})) {
$newcontent{$current}=1;
}
$categories{$id.'_calculations'}=join(',',sort(keys(%newcontent)));
return %categories;
}
#
# Delete a calculation rule
#
sub del_calculation_rule {
my ($id,$cangrade,$delcontent,%categories)=@_;
unless ($cangrade) { return %categories; }
my @newcontent=();
foreach my $current (split(/\,/,$categories{$id.'_calculations'})) {
unless ($current=~/^\Q$delcontent\E\:/) {
push(@newcontent,$current);
}
}
$categories{$id.'_calculations'}=join(',',@newcontent);
return %categories;
}
sub set_category_rules {
my ($cangrade,$id,%categories)=@_;
unless ($cangrade) { return %categories; }
my %lt=&category_rule_codes();
my @newrules=();
foreach my $code ('',(keys(%lt))) {
if ($env{'form.sel_'.$id.'_'.$code}) {
push(@newrules,$env{'form.sel_'.$id.'_'.$code}.':'.$env{'form.val_'.$id.'_'.$code});
}
}
$categories{$id.'_calculations'}=join(',',sort(@newrules));
return %categories;
}
# === Category Editing
#
# Add to category content
#
sub add_category_content {
my ($id,$cangrade,$newcontent,%categories)=@_;
unless ($cangrade) { return %categories; }
&Apache::lonnet::logthis("In here $newcontent");
my %newcontent=($newcontent => 1);
foreach my $current (split(/\,/,$categories{$id.'_content'})) {
$newcontent{$current}=1;
}
$categories{$id.'_content'}=join(',',sort(keys(%newcontent)));
return %categories;
}
#
# Delete from category content
#
sub del_category_content {
my ($id,$cangrade,$delcontent,%categories)=@_;
unless ($cangrade) { return %categories; }
my @newcontent=();
foreach my $current (split(/\,/,$categories{$id.'_content'})) {
unless ($current eq $delcontent) {
push(@newcontent,$current);
}
}
$categories{$id.'_content'}=join(',',@newcontent);
return %categories;
}
#
# Delete category
#
sub del_category {
my ($id,$cangrade,%categories)=@_;
unless ($cangrade) { return %categories; }
my @neworder=();
foreach my $currentid (split(/\,/,$categories{'order'})) {
unless ($currentid eq $id) {
push(@neworder,$currentid);
}
}
$categories{'order'}=join(',',@neworder);
return %categories;
}
#
# Move category up
#
sub move_up_category {
my ($id,$cangrade,%categories)=@_;
my $currentpos=¤t_pos_category($id,%categories);
if ($currentpos<1) { return %categories; }
return &move_category($id,$cangrade,$currentpos-1,%categories);
}
#
# Move category down
#
sub move_down_category {
my ($id,$cangrade,%categories)=@_;
my $currentpos=¤t_pos_category($id,%categories);
my @order=split(/\,/,$categories{'order'});
if ($currentpos>=$#order) { return %categories; }
return &move_category($id,$cangrade,$currentpos+1,%categories);
}
#
# Move a category to a desired position n the display order
#
sub move_category {
my ($id,$cangrade,$ordernum,%categories)=@_;
unless ($cangrade) { return %categories; }
my @order=split(/\,/,$categories{'order'});
# Where is the index currently?
my $currentpos=¤t_pos_category($id,%categories);
if (defined($currentpos)) {
if ($currentpos<$ordernum) {
# This is moving to a higher index
# ....X1234....
# ....1234X....
for (my $i=$currentpos;$i<$ordernum;$i++) {
$order[$i]=$order[$i+1];
}
$order[$ordernum]=$id;
}
if ($currentpos>$ordernum) {
# This is moving to a lower index
# ....1234X....
# ....X1234....
for (my $i=$currentpos;$i>$ordernum;$i--) {
$order[$i]=$order[$i-1];
}
$order[$ordernum]=$id;
}
}
$categories{'order'}=join(',',@order);
return %categories;
}
#
# Find current postion of a category in the order
#
sub current_pos_category {
my ($id,%categories)=@_;
my @order=split(/\,/,$categories{'order'});
for (my $i=0;$i<=$#order;$i++) {
if ($order[$i] eq $id) { return $i; }
}
# not found
return undef;
}
#
# Set name of a category
#
sub set_category_name {
my ($cangrade,$id,$name,%categories)=@_;
unless ($cangrade) { return %categories; }
$categories{$id.'_name'}=$name;
return %categories;
}
#
# Set total of a category
#
sub set_category_total {
my ($cangrade,$id,$totaltype,$total,%categories)=@_;
unless ($cangrade) { return %categories; }
if (($categories{$id.'_total'} eq '') && ($total=~/\d/)) {
$totaltype='typein';
}
$categories{$id.'_totaltype'}=$totaltype;
if ($totaltype eq 'default') {
$categories{$id.'_total'}='';
} else {
$total=~s/\D//gs;
unless ($total) { $total=0; }
$categories{$id.'_total'}=$total;
}
return %categories;
}
sub set_category_weight {
my ($cangrade,$id,$weight,%categories)=@_;
unless ($cangrade) { return %categories; }
$weight=~s/\D//gs;
unless ($weight) { $weight=0; }
$categories{$id.'_weight'}=$weight;
return %categories;
}
sub set_category_displayachieved {
my ($cangrade,$id,$value,%categories)=@_;
unless ($cangrade) { return %categories; }
unless (($value eq 'percent') || ($value eq 'points')) { $value='percent'; }
$categories{$id.'_displayachieved'}=$value;
return %categories;
}
#
# === end category-related
#
#
# Pass this two refs to arrays for the start and end color, and a number
# from 0 to 1 for how much of the latter you want to mix in. It will
# return a string ready to show ("#FFC309");
sub mixColors {
my $start = shift;
my $end = shift;
my $ratio = shift;
my ($a,$b);
my $final = "";
$a = $start->[0]; $b = $end->[0];
my $mix1 = POSIX::floor((1-$ratio)*$a + $ratio*$b);
$a = $start->[1]; $b = $end->[1];
my $mix2 = POSIX::floor((1-$ratio)*$a + $ratio*$b);
$a = $start->[2]; $b = $end->[2];
my $mix3 = POSIX::floor((1-$ratio)*$a + $ratio*$b);
$final = sprintf "%02x%02x%02x", $mix1, $mix2, $mix3;
return "#" . $final;
}
1;
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>
![[BACK]](/icons/back.gif){kind=icon}
Return to lonquickgrades.pm CVS log ![[TXT]](/icons/text.gif){kind=icon}
![[DIR]](/icons/dir.gif){kind=icon}
Up to [LON-CAPA] / loncom / interface