Opened 12 years ago

Closed 12 years ago

#428 closed enhancement (fixed)

Reports should have sites in alphabetic order and a column with latest item dates

Reported by: olle Owned by: olle
Priority: major Milestone: Reggie v2.9
Component: net.sf.basedb.reggie Keywords:
Cc:

Description

General update for all reports:

  • All reports should show sites in alphabetic order.
  • Reports for items having a date should include a column with latest item dates for each site.

Change History (6)

comment:1 by olle, 12 years ago

Status: newassigned

Ticket accepted.

comment:2 by olle, 12 years ago

Traceability note:

Currently two reports are available, a sample count report and a consent count report.

  • The report generator was introduced in Ticket #339 (Report generator). This included the sample count report.
  • The sample count report was updated in Ticket #419 (Allow user to select resolution in sample count report), Ticket #420 (Sample count report should have two columns for summed data), and Ticket #421 (Sample count report does not always handle all views correctly).
  • The consent count report was introduced in Ticket #426 (Consent count report generator).

comment:3 by olle, 12 years ago

Design discussion of site display order:

  • In order to simplify alternative site orderings, servlet SampleReportServlet in reggie/src/net/sf/basedb/reggie/servlet/ should be extended with two new private methods, JSONObject createJSONSiteOrderList(String order) and List<String> createSiteOrderedList(String order). The former method calls the latter to perform the sorting based on the value of input string "order", that indicates supported sorts, after which a JSONObject is created with order index as key and site prefix as value. The default is alphabetical order of site names. Methods creating reports call createJSONSiteOrderList(...) and add the returned JSONObject to the report data.
  • Functions creating the report table in JSP script samplereportgenerator.jsp in reggie/resources/ will obtain the site order JSONObject from the HTTP request, and list the sites in the stated order.

comment:4 by olle, 12 years ago

(In [1735]) Refs #428. Refs #420. Refs #426. Sample count report and consent count report updated to show sites in alphabetical order of site names.

comment:5 by olle, 12 years ago

Design discussion of column for latest item date for site:

  • Servlet SampleReportServlet in reggie/src/net/sf/basedb/reggie/servlet/ should be updated to keep track of latest item date for each site. Affected methods will store this data in a HashMap<String, Date> sitePrefixDateHashMap, that stores the latest item date with site prefix as key. The latest date for each site will then be stored in the site JSONObject.
  • JSP script samplereportgenerator.jsp in reggie/resources/ will obtain the latest date for each site from the site JSONObject from the HTTP request, and add the dates in a table column. The column for latest date will be placed to the right of the column for start date for the site.

comment:6 by olle, 12 years ago

Resolution: fixed
Status: assignedclosed

(In [1737]) Fixes #428. Refs #420. Refs #426. Sample count report and consent count report updated to show a table column with latest item dates for each site.

Note: See TracTickets for help on using tickets.