File:  [LON-CAPA] / loncom / interface / spreadsheet / assesscalc.pm
Revision 1.6: download - view: text, annotated - select for diffs
Fri May 23 14:08:40 2003 UTC (21 years, 1 month ago) by matthew
Branches: MAIN
CVS tags: HEAD
Perl does not automagically convert the string '"1"' to 1, so we must only
quote those parameters which are non-numeric.

    1: #
    2: # $Id: assesscalc.pm,v 1.6 2003/05/23 14:08:40 matthew Exp $
    3: #
    4: # Copyright Michigan State University Board of Trustees
    5: #
    6: # This file is part of the LearningOnline Network with CAPA (LON-CAPA).
    7: #
    8: # LON-CAPA is free software; you can redistribute it and/or modify
    9: # it under the terms of the GNU General Public License as published by
   10: # the Free Software Foundation; either version 2 of the License, or
   11: # (at your option) any later version.
   12: #
   13: # LON-CAPA is distributed in the hope that it will be useful,
   14: # but WITHOUT ANY WARRANTY; without even the implied warranty of
   15: # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
   16: # GNU General Public License for more details.
   17: #
   18: # You should have received a copy of the GNU General Public License
   19: # along with LON-CAPA; if not, write to the Free Software
   20: # Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
   21: #
   22: # /home/httpd/html/adm/gpl.txt
   23: #
   24: # http://www.lon-capa.org/
   25: #
   26: # The LearningOnline Network with CAPA
   27: # Spreadsheet/Grades Display Handler
   28: #
   29: # POD required stuff:
   30: 
   31: =head1 NAME
   32: 
   33: assesscalc
   34: 
   35: =head1 SYNOPSIS
   36: 
   37: =head1 DESCRIPTION
   38: 
   39: =cut
   40: 
   41: ###################################################
   42: ###                 AssessSheet                 ###
   43: ###################################################
   44: package Apache::assesscalc;
   45: 
   46: use strict;
   47: use Apache::Constants qw(:common :http);
   48: use Apache::lonnet;
   49: use Apache::loncommon;
   50: use Apache::Spreadsheet;
   51: use HTML::Entities();
   52: use Spreadsheet::WriteExcel;
   53: use GDBM_File;
   54: use Time::HiRes;
   55: 
   56: @Apache::assesscalc::ISA = ('Apache::Spreadsheet');
   57: 
   58: ########################################################
   59: ########################################################
   60: 
   61: =pod
   62: 
   63: =head2 Package Variables
   64: 
   65: =over 4
   66: 
   67: =item %Exportrows
   68: 
   69: =item $current_name
   70: 
   71: =item $current_domain
   72: 
   73: =item $current_course
   74: 
   75: =item %parmhash
   76: 
   77: =item %nice_parameter_name
   78: 
   79: =item %useropt
   80: 
   81: =item %courseopt
   82: 
   83: =back 
   84: 
   85: =cut
   86: 
   87: ########################################################
   88: ########################################################
   89: 
   90: my %Exportrows;
   91: 
   92: my $current_name;
   93: my $current_domain;
   94: my $current_course;
   95: 
   96: my %parmhash;
   97: my %nice_parameter_name;
   98: 
   99: my %useropt;
  100: my %courseopt;
  101: 
  102: ########################################################
  103: ########################################################
  104: 
  105: =pod
  106: 
  107: =head2 Package Subroutines
  108: 
  109: =item &clear_package()
  110: 
  111: Reset all package variables.  
  112: 
  113: =cut
  114: 
  115: ########################################################
  116: ########################################################
  117: sub clear_package {
  118:     undef(%Exportrows);
  119:     undef($current_name);
  120:     undef($current_domain);
  121:     undef($current_course);
  122:     undef(%useropt);
  123:     undef(%courseopt);
  124: }
  125: 
  126: ########################################################
  127: ########################################################
  128: 
  129: =pod
  130: 
  131: =item &initialize_package()
  132: 
  133: =cut
  134: 
  135: ########################################################
  136: ########################################################
  137: sub initialize_package {
  138:     my ($sname,$sdomain) = @_;
  139:     $current_course = $ENV{'request.course.id'};
  140:     $current_name   = $sname;
  141:     $current_domain = $sdomain;
  142:     undef(%courseopt);
  143:     &load_cached_export_rows();
  144:     &load_parameter_caches();
  145: }
  146: 
  147: ########################################################
  148: ########################################################
  149: 
  150: =pod
  151: 
  152: =item &load_parameter_caches()
  153: 
  154: =cut
  155: 
  156: ########################################################
  157: ########################################################
  158: sub load_parameter_caches {
  159:     my $userprefix = $current_name.':'.$current_domain.'_';
  160:     $userprefix =~ s/:/_/g;
  161:     #
  162:     # Course Parameters Cache
  163:     if (! %courseopt) {
  164:         &Apache::lonnet::logthis("loading course options");
  165:         $current_course = $ENV{'request.course.id'};
  166:         undef(%courseopt);
  167:         if (! defined($current_name) || ! defined($current_domain)) {
  168:             &Apache::lonnet::logthis('bad call to setup_parameter_caches');
  169:             return;
  170:         }
  171:         my $dom = $ENV{'course.'.$ENV{'request.course.id'}.'.domain'};
  172:         my $id  = $ENV{'course.'.$ENV{'request.course.id'}.'.num'};
  173:         my %Tmp = &Apache::lonnet::dump('resourcedata',$dom,$id);
  174:         while (my ($name,$value) = each(%Tmp)) {
  175:             $courseopt{$name}=$value;
  176:         }
  177:     }
  178:     if (! %useropt) {
  179:         my %Tmp = &Apache::lonnet::dump('resourcedata',
  180:                                         $current_domain,$current_name);
  181:         while (my ($name,$value) = each(%Tmp)) {
  182:             if ($name =~ /^error: 2/ || $name =~ /no such file/) {
  183:                 undef(%useropt);
  184:                 last;
  185:             }
  186:             $useropt{$userprefix.$name}=$value;
  187:         }
  188:     }
  189: }
  190: 
  191: ########################################################
  192: ########################################################
  193: 
  194: =pod
  195: 
  196: =head2 assesscalc object methods
  197: 
  198: =cut
  199: 
  200: ########################################################
  201: ########################################################
  202: sub ensure_current_parameter_caches {
  203:     my $self = shift;
  204:     if (! defined($current_course) || 
  205:         $current_course ne $ENV{'request.course.id'} ) {
  206:         $current_course = $ENV{'request.course.id'};
  207:         undef(%courseopt); 
  208:     }
  209:     if (! defined($current_name)   || $current_name ne $self->{'name'} ||
  210:         ! defined($current_domain) || $current_domain ne $self->{'domain'}) {
  211:         $current_domain = $self->{'domain'};
  212:         $current_name   = $self->{'name'};
  213:         undef(%useropt);
  214:     }
  215:     &load_parameter_caches();
  216: }
  217: 
  218: ##################################################
  219: ##################################################
  220: 
  221: =pod
  222: 
  223: =item &parmval()
  224: 
  225: Determine the value of a parameter.
  226: 
  227: Inputs: $what, the parameter needed, $symb, $uname, $udom, $csec 
  228: 
  229: Returns: The value of a parameter, or '' if none.
  230: 
  231: This function cascades through the possible levels searching for a value for
  232: a parameter.  The levels are checked in the following order:
  233: user, course (at section level and course level), map, and lonnet::metadata.
  234: This function uses %parmhash, which must be tied prior to calling it.
  235: This function also requires %courseopt and %useropt to be initialized for
  236: this user and course.
  237: 
  238: =cut
  239: 
  240: ##################################################
  241: ##################################################
  242: sub parmval {
  243:     my $self = shift;
  244:     my ($what,$symb,$uname,$udom,$csec)=@_;
  245:     $uname = $self->{'name'}    if (! defined($uname));
  246:     $udom  = $self->{'domain'}  if (! defined($udom));
  247:     $csec  = $self->{'section'} if (! defined($csec));
  248:     $symb  = $self->{'symb'}    if (! defined($symb));
  249:     #
  250:     my $result='';
  251:     #
  252:     # This should be a 
  253:     my ($mapname,$id,$fn)=split(/___/,$symb);
  254:     # Cascading lookup scheme
  255:     my $rwhat=$what;
  256:     $what =~ s/^parameter\_//;
  257:     $what =~ s/\_([^\_]+)$/\.$1/;
  258:     #
  259:     my $symbparm = $symb.'.'.$what;
  260:     my $mapparm  = $mapname.'___(all).'.$what;
  261:     my $courseprefix = $self->{'cid'};
  262:     my $usercourseprefix = $uname.'_'.$udom.'_'.$self->{'cid'};
  263:     #
  264:     my $seclevel  = $courseprefix.'.['.$csec.'].'.$what;
  265:     my $seclevelr = $courseprefix.'.['.$csec.'].'.$symbparm;
  266:     my $seclevelm = $courseprefix.'.['.$csec.'].'.$mapparm;
  267:     #
  268:     my $courselevel  = $courseprefix.'.'.$what;
  269:     my $courselevelr = $courseprefix.'.'.$symbparm;
  270:     my $courselevelm = $courseprefix.'.'.$mapparm;
  271:     #
  272:     my $ucourselevel  = $usercourseprefix.'.'.$what;
  273:     my $ucourselevelr = $usercourseprefix.'.'.$symbparm;
  274:     my $ucourselevelm = $usercourseprefix.'.'.$mapparm;
  275:    # check user
  276:     if (defined($uname)) {
  277:         return $useropt{$ucourselevelr} if (defined($useropt{$ucourselevelr}));
  278:         return $useropt{$ucourselevelm} if (defined($useropt{$ucourselevelm}));
  279:         return $useropt{$ucourselevel}  if (defined($useropt{$ucourselevel}));
  280:     }
  281:     # check section
  282:     if (defined($csec)) {
  283:         return $courseopt{$seclevelr} if (defined($courseopt{$seclevelr}));
  284:         return $courseopt{$seclevelm} if (defined($courseopt{$seclevelm}));
  285:         return $courseopt{$seclevel}  if (defined($courseopt{$seclevel}));
  286:     }
  287:     #
  288:     # check course
  289:     return $courseopt{$courselevelr} if (defined($courseopt{$courselevelr}));
  290:     return $courseopt{$courselevelm} if (defined($courseopt{$courselevelm}));
  291:     return $courseopt{$courselevel}  if (defined($courseopt{$courselevel}));
  292:     # check map parms
  293:     my $thisparm = $parmhash{$symbparm};
  294:     return $thisparm if (defined($thisparm));
  295:     # check default
  296:     $thisparm = &Apache::lonnet::metadata($fn,$rwhat.'.default');
  297:     return $thisparm if (defined($thisparm));
  298:     #
  299:     # Cascade Up
  300:     my $space=$what;
  301:     $space=~s/\.\w+$//;
  302:     if ($space ne '0') {
  303: 	my @parts=split(/_/,$space);
  304: 	my $id=pop(@parts);
  305: 	my $part=join('_',@parts);
  306: 	if ($part eq '') { $part='0'; }
  307: 	my $newwhat=$rwhat;
  308: 	$newwhat=~s/\Q$space\E/$part/;
  309: 	my $partgeneral=$self->parmval($newwhat,$symb,$uname,$udom,$csec);
  310: 	if (defined($partgeneral)) { return $partgeneral; }
  311:     }
  312:     #nothing defined
  313:     return '';
  314: }
  315: 
  316: sub get_title {
  317:     my $self = shift;
  318:     my $title;
  319:     if (($self->{'usymb'} eq '_feedback') ||
  320:         ($self->{'usymb'} eq '_evaluation') ||
  321:         ($self->{'usymb'} eq '_discussion') ||
  322:         ($self->{'usymb'} eq '_tutoring')) {
  323:         $title = $self->{'usymb'};
  324:         $title =~ s/^_//;
  325:         $title = '<h1>'.ucfirst($title)."</h1>\n";
  326:     } else {
  327:         $title = '<h1>'.&Apache::lonnet::gettitle($self->{'symb'})."</h1>\n";
  328:     }
  329:     # Look up the users identifying information
  330:     # Get the users information
  331:     my %userenv = &Apache::loncoursedata::GetUserName($self->{'name'},
  332:                                                       $self->{'domain'});
  333:     my $name = 
  334:         join(' ',@userenv{'firstname','middlename','lastname','generation'});
  335:     $name =~ s/\s+$//;
  336:     $title .= '<h2>'.$name.', '.
  337:         &Apache::loncommon::aboutmewrapper($self->{'name'}.'@'.$self->{'domain'},
  338:                                            $self->{'name'},$self->{'domain'}).
  339:                                            "</h2>\n";
  340:     $title .= '<h3>'.localtime(time).'</h3>';
  341:     #
  342:     return $title;
  343: }
  344: 
  345: sub parent_link {
  346:     my $self = shift;
  347:     my $link .= '<p><a href="/adm/studentcalc?'.
  348:         'sname='.$self->{'name'}.
  349:             '&sdomain='.$self->{'domain'}.'">'.
  350:                 'Student level sheet</a></p>'."\n";
  351:     return $link;
  352: }
  353: 
  354: sub outsheet_html {
  355:     my $self = shift;
  356:     my ($r) = @_;
  357:     ###################################
  358:     # Determine table structure
  359:     ###################################
  360:     my $num_uneditable = 1;
  361:     my $num_left = 52-$num_uneditable;
  362:     my $tableheader =<<"END";
  363: <table border="2">
  364: <tr>
  365:   <th colspan="2" rowspan="2"><font size="+2">Assessment</font></th>
  366:   <td bgcolor="#FFDDDD" colspan="$num_uneditable">&nbsp;</td>
  367:   <td colspan="$num_left">
  368:       <b><font size="+1">Calculations</font></b></td>
  369: </tr><tr>
  370: END
  371:     my $label_num = 0;
  372:     foreach (split(//,'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz')){
  373:         if ($label_num<$num_uneditable) { 
  374:             $tableheader .= '<td bgcolor="#FFDDDD">';
  375:         } else {
  376:             $tableheader .= '<td>';
  377:         }
  378:         $tableheader .= "<b><font size=+1>$_</font></b></td>";
  379:         $label_num++;
  380:     }
  381:     $tableheader.="</tr>\n";
  382:     #
  383:     $r->print($tableheader);
  384:     #
  385:     # Print out template row
  386:     $r->print('<tr><td>Template</td><td>&nbsp;</td>'.
  387: 	      $self->html_template_row($num_uneditable)."</tr>\n");
  388:     #
  389:     # Print out summary/export row
  390:     $r->print('<tr><td>Export</td><td>0</td>'.
  391: 	      $self->html_export_row()."</tr>\n");
  392:     #
  393:     # Prepare to output rows
  394:     $tableheader =<<"END";
  395: <table border="2">
  396: <tr><th>row</th><th>Item</th>
  397: END
  398:     foreach (split(//,'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz')){
  399: 	if ($label_num<$num_uneditable) { 
  400:             $tableheader.='<th bgcolor="#FFDDDD">';
  401:         } else {
  402:             $tableheader.='<th>';
  403:         }
  404:         $tableheader.="<b><font size=+1>$_</font></b></th>";
  405:     }
  406:     #
  407:     my $num_output = 0;
  408:     foreach my $rownum ($self->rows()) {
  409: 	if ($num_output++ % 50 == 0) {
  410: 	    $r->print("</table>\n".$tableheader);
  411: 	}
  412: 	$r->print('<tr><td>'.$rownum.'</td>'.
  413:                   $self->assess_html_row($num_uneditable,$rownum)."</tr>\n");
  414:     }
  415:     $r->print("</table>\n");
  416:     return;
  417: }
  418: 
  419: sub assess_html_row {
  420:     my $self = shift();
  421:     my ($num_uneditable,$row) = @_;
  422:     my $requester_is_student = ($ENV{'request.role'} =~ /^st\./);
  423:     my $parameter_name = $self->{'formulas'}->{'A'.$row};
  424:     my @rowdata = $self->get_row($row);
  425:     my $num_cols_output = 0;
  426:     my $row_html;
  427:     if (exists($nice_parameter_name{$parameter_name})) {
  428:         my $name = $nice_parameter_name{$parameter_name};
  429:         $name =~ s/ /\&nbsp;/g;
  430:         $row_html .= '<td>'.$name.'<br />'.$parameter_name.'</td>';
  431:     } else {
  432:         $row_html .= '<td>'.$parameter_name.'</td>';
  433:     }
  434:     foreach my $cell (@rowdata) {
  435: 	if ($requester_is_student || 
  436: 	    $num_cols_output++ < $num_uneditable) {
  437: 	    $row_html .= '<td bgcolor="#FFDDDD">';
  438: 	    $row_html .= &Apache::Spreadsheet::html_uneditable_cell($cell,'#FFDDDD');
  439: 	} else {
  440: 	    $row_html .= '<td bgcolor="#EOFFDD">';
  441: 	    $row_html .= &Apache::Spreadsheet::html_editable_cell($cell,'#E0FFDD');
  442: 	}
  443: 	$row_html .= '</td>';
  444:     }
  445:     return $row_html;
  446: }
  447: 
  448: sub outsheet_csv {
  449:     my $self = shift;
  450:     my ($r)=@_;
  451: }
  452: 
  453: sub outsheet_excel {
  454:     my $self = shift;
  455:     my ($r)=@_;
  456: }
  457: 
  458: sub display {
  459:     my $self = shift;
  460:     my ($r) = @_;
  461:     $self->compute();
  462:     $self->outsheet_html($r);
  463: }
  464: 
  465: sub compute {
  466:     my $self = shift;
  467:     $self->logthis('computing');
  468:     $self->initialize_safe_space();
  469:     #
  470:     # Definitions
  471:     undef(%nice_parameter_name);
  472:     my %parameters;   # holds underscored parameters by name
  473:     #
  474:     # Get the metadata fields and determine their proper names
  475:     my ($symap,$syid,$srcf)=split(/___/,$self->{'symb'});
  476:     my @Metadata = split(/\,/,&Apache::lonnet::metadata($srcf,'keys'));
  477:     foreach my $parm (@Metadata) {
  478:         next if ($parm !~ /^(resource\.|stores|parameter)_/);
  479:         my $cleaned_name = $parm;
  480:         $cleaned_name =~ s/^resource\./stores_/;
  481:         $cleaned_name =~ s/\./_/g;
  482:         my $display = &Apache::lonnet::metadata($srcf,
  483:                                                 $cleaned_name.'.display');
  484:         if (! $display) {
  485:             $display .= &Apache::lonnet::metadata($srcf,$cleaned_name.'.name');
  486:         }
  487:         $parameters{$cleaned_name}++;
  488:         $nice_parameter_name{$cleaned_name} = $display;
  489:     }
  490:     #
  491:     # Get the values of the metadata fields
  492:     $self->ensure_current_parameter_caches();
  493:     my $filename = $self->{'coursefilename'}.'_parms.db';
  494:     if (tie(%parmhash,'GDBM_File',
  495:             $self->{'coursefilename'}.'_parms.db',&GDBM_READER(),0640)) {
  496:         foreach my $parmname (keys(%parameters)) {
  497:             my $value = $self->parmval($parmname);
  498:             $parameters{$parmname} =$value;
  499:         }
  500:         untie(%parmhash);
  501:     } else {
  502:         $self->logthis('unable to tie '.$filename);
  503:     }
  504:     #
  505:     # Clean out unnecessary parameters
  506:     foreach (keys(%parameters)) {
  507:         delete($parameters{$_}) if (! /(resource\.|stores_|parameter_)/);
  508:     }
  509:     #
  510:     # Get the students performance data
  511:     my %student_parameters = 
  512:         &Apache::loncoursedata::get_current_state($self->{'name'},
  513:                                                   $self->{'domain'},
  514:                                                   $self->{'symb'},
  515:                                                   $self->{'cid'});
  516:     while (my ($parm,$value) = each(%student_parameters)) {
  517:         $parm =~ s/^resource\./stores_/;
  518:         $parm =~ s/\./_/g;
  519:         $parameters{$parm} = $value;
  520:     }
  521:     #
  522:     # Set up the formulas and parameter values
  523:     my %f=$self->formulas();
  524:     my %c;
  525:     #
  526:     # Check for blackout requirements
  527:     if ((!exists($ENV{'request.role.adv'}) || !$ENV{'request.role.adv'})) {
  528:         while (my ($parm,$value) = each(%parameters)) {
  529:             last if ($self->blackout());
  530:             next if ($parm !~ /^(parameter_.*)_problemstatus$/);
  531:             next if ($parameters{$1.'_answerdate'}<time);
  532:             if (lc($value) eq 'no') {
  533:                 # We must blackout this sheet
  534:                 $self->blackout(1);
  535:             }
  536:         }
  537:     }
  538:     #
  539:     # Move the parameters into the spreadsheet
  540:     while (my ($parm,$value) = each(%parameters)) {
  541:         my $cell = 'A'.$self->get_row_number_from_key($parm);
  542:         $f{$cell} = $parm;
  543:         $value = '"'.$value.'"' if ($value =~/[^0-9.]/);
  544:         $c{$parm} = $value;
  545:     }
  546:     $self->formulas(\%f);
  547:     $self->constants(\%c);
  548:     $self->calcsheet();
  549:     #
  550:     # Store export row in cache
  551:     my @exportarray = $self->exportrow();
  552:     $Exportrows{$self->{'symb'}}->{'time'} = time;
  553:     $Exportrows{$self->{'symb'}}->{$self->{'filename'}} = \@exportarray;
  554:     #
  555:     # Save the export data
  556:     $self->save_export_data();
  557:     return;
  558: }
  559: 
  560: ##
  561: ## sett overrides Spreadsheet::sett
  562: ##
  563: sub sett {
  564:     my $self = shift;
  565:     my %t=();
  566:     #
  567:     # Deal with the template row by copying the template formulas into each
  568:     # row.
  569:     foreach my $col ($self->template_cells()) {
  570:         next if ($col=~/^A/);
  571:         foreach my $row ($self->rows()) {
  572:             # Get the name of this cell
  573:             my $cell=$col.$row;
  574:             # Grab the template declaration
  575:             $t{$cell}=$self->formula('template_'.$col);
  576:             # Replace '#' with the row number
  577:             $t{$cell}=~s/\#/$row/g;
  578:             # Replace '....' with ','
  579:             $t{$cell}=~s/\.\.+/\,/g;
  580:             # Replace 'A0' with the value from 'A0'
  581:             $t{$cell}=~s/(^|[^\"\'])([A-Za-z]\d+)/$1\$sheet_values\{\'$2\'\}/g;
  582:             # Replace parameters
  583:             $t{$cell}=~s/(^|[^\"\'])\[([^\]]+)\]/$1.$self->expandnamed($2)/ge;
  584:         }
  585:     }
  586:     #
  587:     # Deal with the cells which have formulas
  588:     while (my ($cell,$formula) = each(%{$self->{'formulas'}})) {
  589: 	next if ($cell =~ /template_/);
  590:         if ($cell =~ /^A/ && $cell ne 'A0') {
  591:             if ($formula !~ /^\!/) {
  592:                 $t{$cell}=$self->{'constants'}->{$formula};
  593:             }
  594:         } else {
  595:             $t{$cell}=$formula;
  596:             $t{$cell}=~s/\.\.+/\,/g;
  597:             $t{$cell}=~s/(^|[^\"\'])([A-Za-z]\d+)/$1\$sheet_values\{\'$2\'\}/g;
  598:             $t{$cell}=~s/(^|[^\"\'])\[([^\]]+)\]/$1.$self->expandnamed($2)/ge;
  599:         }
  600:     }
  601:     # Put %t into the safe space
  602:     %{$self->{'safe'}->varglob('t')}=%t;
  603: }
  604: 
  605: 
  606: ########################################################
  607: ########################################################
  608: 
  609: =pod
  610: 
  611: =item &load_cached_export_rows()
  612: 
  613: Retrieves and parsers the export rows of the assessment spreadsheets.
  614: These rows are saved in the students directory in the format:
  615: 
  616:  sname:sdom:assesscalc:symb.time => time
  617: 
  618:  sname:sdom:assesscalc:symb => filename___=___Adata___;___Bdata___;___ ...
  619: 
  620: =cut
  621: 
  622: ########################################################
  623: ########################################################
  624: sub load_cached_export_rows {
  625:     %Exportrows = undef;
  626:     my @tmp = &Apache::lonnet::dump('nohist_calculatedsheets_'.
  627:                                     $ENV{'request.course.id'},
  628:                                     $current_domain,$current_name,undef);
  629:     if ($tmp[0]!~/^error/) {
  630:         my %tmp = @tmp;
  631:         my $default_filename =  $ENV{'course.'.$ENV{'request.course.id'}.
  632:                                          '.spreadsheet_default_assesscalc'};
  633:         # We only got one key, so we will access it directly.
  634:         while (my ($key,$sheetdata) = each(%tmp)) {
  635:             my ($sname,$sdom,$sheettype,$symb) = split(':',$key);
  636:             if ($symb =~ /\.time$/) {
  637:                 $symb =~ s/\.time$//;
  638:                 $Exportrows{$symb}->{'time'} = $sheetdata;
  639:             } else {
  640:                 $sheetdata =~ s/^(.*)___=___//;
  641:                 my $filename = $1;
  642:                 $filename = $default_filename if (! defined($filename));
  643:                 my @Data = split('___;___',$sheetdata);
  644:                 $Exportrows{$symb}->{$filename} = \@Data;
  645:             }
  646:         }
  647:     }
  648: }
  649: 
  650: #############################################
  651: #############################################
  652: 
  653: =pod
  654: 
  655: =item &export_data
  656: 
  657: Returns the export data associated with the spreadsheet.  Computes the
  658: spreadsheet only if necessary.
  659: 
  660: =cut
  661: 
  662: #############################################
  663: #############################################
  664: sub export_data {
  665:     my $self = shift;
  666:     my $symb = $self->{'symb'};
  667:     if (! exists($ENV{'request.role.adv'}) || ! $ENV{'request.role.adv'} ||
  668:         ! exists($Exportrows{$symb}) || ! defined($Exportrows{$symb})  ||
  669:         ! $self->check_expiration_time($Exportrows{$symb}->{'time'}) ||
  670:         ! exists($Exportrows{$symb}->{$self->{'filename'}}) ||
  671:         ! defined($Exportrows{$symb}->{$self->{'filename'}})) {
  672:         $self->compute();
  673:     }
  674:     my @Data = @{$Exportrows{$symb}->{$self->{'filename'}}};
  675:     if ($Data[0] =~ /^(.*)___=___/) {
  676:         $self->{'sheetname'} = $1;
  677:         $Data[0] =~ s/^(.*)___=___//;
  678:     }
  679:     for (my $i=0;$i<$#Data;$i++) {
  680:         $Data[$i]="'".$Data[$i]."'" if ($Data[$i]=~/\D/ && defined($Data[$i]));
  681:     }
  682:     return @Data;
  683: }
  684: 
  685: #############################################
  686: #############################################
  687: 
  688: =pod
  689: 
  690: =item &save_export_data()
  691: 
  692: Writes the export data for this spreadsheet to the students cache.
  693: 
  694: =cut
  695: 
  696: #############################################
  697: #############################################
  698: sub save_export_data {
  699:     my $self = shift;
  700:     my $student = $self->{'name'}.':'.$self->{'domain'};
  701:     my $symb    = $self->{'symb'};
  702:     if (! exists($Exportrows{$symb}) || 
  703:         ! exists($Exportrows{$symb}->{$self->{'filename'}})) {
  704:         return;
  705:     }
  706:     my $key = join(':',($self->{'name'},$self->{'domain'},'assesscalc',$symb));
  707:     my $timekey = $key.'.time';
  708:     my $newstore= join('___;___',@{$Exportrows{$symb}->{$self->{'filename'}}});
  709:     $newstore = $self->{'filename'}.'___=___'.$newstore;
  710:     my $result = &Apache::lonnet::put
  711:         ('nohist_calculatedsheets_'.$ENV{'request.course.id'},
  712:          { $key     => $newstore,
  713:            $timekey => $Exportrows{$symb}->{'time'} },
  714:          $self->{'domain'},
  715:          $self->{'name'});
  716: 
  717:     return;
  718: }
  719: 
  720: 1;
  721: 
  722: __END__

FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>