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

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

Request diff between arbitrary revisions

Keyword substitution: kv
Default branch: MAIN

- Internationalization: Added missing &mt() call
- XHTML
- Standard styles

Bug 6455 - Progress Indicator now jQuery. Still need to test across browsers.

Work-in-progress: Grading

Optimized status display:
- Set text box for display purposes only to readonly
- Use standard nobreak style
- Same paragraph structure for similar pages

Bug 4954.  Filter title changed from "Enrollment Status" to "Access Status".  Access Status selections in lonhtmlcommon set to:
Currently Has Access
Will Have Future Access
Previously Had Access
Any Access Status
See comment appended to bug 4954 for more information.
Documentation updated to include ability to selectively display students with future access.

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 4556 by introducing the ability to just view the source of the
spreadsheet, without any computation at all.

- ENV -> env

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

Modified to use inline progress window.

Initialize student spreadsheet package before creating progress window.

Bug 2945: Give DCs links to expire spreadsheet caches.

Commit of commented out code for my convenience.  May need this on data
later.

Output a count of the students when we present a page of links to student
spreadsheets.

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

Added new output mode at the course level.  It just displays the
students with a link to their spreadsheet.  Reworked how output options
are handled to be able to vary them by spreadsheet.  Reworked some confusing
(to me) localization code.

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 student id to excel and csv output.  Fixed bug with new parameters being
passed in to csv_rows and excel_rows methods.

Clear package variables on both normal completion and on interruption.

Minor modifications brought about due to making warnings fatal.

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.

More useful progress window messages.  Bug 1046.

Not every student has a name filled in, so use the students username
as a link instead.

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.

Use lonstatistics to retrieve the list of students.   Added output of
the section selector dialog.  Seems to work.

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.

Cosmetic html changes.

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.