CVS log for loncom/interface/spreadsheet/studentcalc.pm

Up to [LON-CAPA] / loncom / interface / spreadsheet

Request diff between arbitrary revisions

Keyword substitution: kv
Default branch: MAIN

- Bug 6754 LON-CAPA as LTI Consumer
  - Spreadsheet includes external tools set to be "gradable".

Internationalization: Added missing &mt() call

- Top level sequence was being included twice.

- Localization: Added &mt call
- Replaced hardcoded font color by appropriate warning style

- BUG#5306, turn off navmaps folder eliding for SPRS

- notice and announce when errors occur trying to calculate spreadsheets

Bug 4296.  Values entered in cells in student sheet were not being stored in tmp file.

&Apache::lonnet::unescape -> &unescape
&Apache::lonnet::escape -> &escape

Determination of parameters for spreadsheet now correctly cascades for cases where a user has multiple active groups. Also groups are passed in argument list for Spreadsheet object as array reference. Lastly lonnet::get_users_groups function modified to only return user's active groups, except in case when user status has expired (and default end access date for students has also passed), in which case user's groups which were still active less than 24 hours before default end date are also included in user's groups. [For consistency with students groups returned by loncoursedata::get_students_groups()].

Making group-based parameters apply in spreadsheet, using same cascading precedence scheme as used for parmset.

- #self->{'section'} never got set

Fix bug 3622, ability to change assessment spreadsheet for entire
sequence at once.

- fixes bug #4296 spreadsheet can't be edited

- BUG# 4248, SUMSEQ wsn't fetching titles correctly

- need to undef $navmap so that the hashes are untied

- remving superflouous connection abort checks

- shave another 0.5 seconds per student

- ENV -> env

Updated to use loncommon::create_workbook.  Spreadsheets were slightly
modified to use formats.

Changed to use navmaps.

- BUG #2207, the SUBM,PGRD,PPRM links on the SPRS now go to the correct place.

consolidate some of the multitude of functions out there that try to format and display the student's 'fullname'

Fix parameters passed in to excel_rows and csv_rows.  Should go in 1.1

Backport of changes to make spreadsheet report calculation errors and not
save bogus data.

Fix bug in error reporting where errors in computation of the spreadsheet
were not reported and bad cache values were stored away.
Added in Spreadsheet: &set_badcalc, &badcalc, &set_calcerror, &calcerror,
and &html_report_error.  These are used to keep track of computation errors
and to report them to the user.  The &save_export_data routines were all
modified to not store data when an error has occured.

Internationalize/localize

Added &SUMSEQ(), a new function available in the student level spreadsheet
to sum over sequences.

Cleanup of parent_link subroutine - there is no need to include the
students name and domain when requesting the course level spreadsheet.

Cache student performance data (only make 1 call to get_current_state)
Cache export rows and write them only when asked to or when the computations
are done.

Trivial html cleanup.

Clear package variables on both normal completion and on interruption.

Minor modifications brought about due to making warnings fatal.

Extra paranoia about decision to compute spreadsheet.  Removed some
excess logging.  Please put in 1.0.

Added paranoia about when to recalculate the student level sheet.

Bug 1584: pgrd button for each resource in the student level sheet.

Paler yellow.

Bug 1729 - color hints on export/import rows.  The color of the export
row of the assessment sheet is the same as the import row of the
student sheet.  The export row of the student sheet is the same color
as the import rows of the course level sheet.

Handle course data caching properly.

Trivial change to header row of excel spreadsheet export to make it match
the values used by chart.

Fixes bugs 1513 and 1516. Every time a new row is added to a spreadsheet
the spreadsheet will be saved.
&set_row_numbers now actually keeps track of the maximum row found, which
can be useful if you need to add a new row...
Also fixed bug in caching of spreadsheets - was storing the 'join'd version
of the formulas when I expected a hash reference.

Added $spreadsheet->initialize() subroutine to take care of specific
initialization needed for each sheet.  assesscalc now has a list of
mandatory parameters (Bug 1514) but is running in to problems with
bug 1513.

CSV output implemented.

Added output selector and implemented excel output.

Moved $spreadsheet->display() to Spreadsheet.pm instead of having it reside
    three times in the descendents of the spreadsheet object.
Moved $spreadsheet->outsheet_excel() to Spreadsheet.pm for the same reason.
Created Spreadsheet::output_selector, which allows the user to select the
    output mode they desire.
Created $spreadsheet->excel_output_row which takes care of writing a row
    to an excel worksheet.
classcalc.pm, studentcalc.pm, and assesscalc.pm each had the same work done
on them:
  Created &excel_rows(), which writes the body of the spreadsheets to
     an excel file.
  Rewrote &get_title to return an array of title lines.
  Created &get_html_title to return an HTML version of the results of
     &get_title.

classcalc.pm and Spreadsheet.pm each have the following change:
    Created &html_header to return appropriate HTML for the spreadsheet.

No longer save the results of computation of temporary spreadsheets.
Added Spreadsheet->temporary() to handle the getting and setting of the flag
which indicates a spreadsheet is temporary.  studentcalc.pm and assesscalc.pm
check this flag before saving their export rows.

Added 'blackout' support.  A blackout occurs when an assessment has a part
flagged with 'problemstatus' equal to 'no'.  This prevents the display of
the students performance on the part until the answerdate has passed.

Spreadsheet.pm contains &blackout, which returns the blackout status of
the current spreadsheet.

assesscalc.pm contains code which
    a) causes the computation of the spreadsheet to determine the
       blackout status
    b) forces the recomputation of the spreadsheet if the user is a student.
  Obviously (b) is less than ideal and a new approach should be found.

studentcalc.pm's outsheet_html subroutine now supresses the display of the
export (aka 'summary') row, as well as the rows of any assessments which
are under blackout.

Modified $spreadsheet->title() subroutines to look prettier, link to the
students 'aboutme' page, and call &Apache::loncoursedata::GetUserName.

Cosmetic HTML changes.
If the user does not have 'mgr' privileges the student spreadsheet will display
a link to the resource for each assessment instead of a link to the assessment
spreadsheet.

Nearly complete reworking of spreadsheet.

lonspreadsheet.pm holds a few utility functions and the handler, which
creates a spreadsheet and tells it to display itself.

Spreadsheet.pm is the base definition of the spreadsheet object.
classcalc.pm, studentcalc.pm, and assesscalc.pm are implementations of the
spreadsheets.

There are missing pieces - excel and csv output, limiting by section
permissions, the ability to add extra 'header' rows to the student and
course level sheets, and students are still allowed to view the assessment
level sheets (will disable this soon).

Computing and editing of the spreadsheet have been tested and have been
given a preliminary seal of approval.