Calendar Rewrite Plan

[ncovercash]

This is for both ui-calendar and mod-calendar; there is no built-in way to replicate this issue on both so it's going here.

These will probably be broken down into sub-issues so their progress can be tracked more easily and put onto the kanban

Requiring Investigation

• Determine preferred testing frameworks
  • FOLIO has gone through many testing frameworks over the years (biggest, cypress, jest, karma, nightmare, etc) and I would like to ensure we write tests with the preferred one
  • Various places of documentation all say each of these is the current preferred one, and I'm not sure which is the most recent/correct.
  • [x] FE testing should be done with rtl and jest. (#5)
  • [x] BE testing TBD; dependent upon Spring/RMB and other factors TBD first (ualibweb/mod-calendar#3)
• [x] ualibweb/mod-calendar#4
• [x] ualibweb/mod-calendar#5
• [x] ualibweb/mod-calendar#6
• [x] ualibweb/mod-calendar#7
• [x] ualibweb/mod-calendar#19 (none is currently performed; as long as it looks like a UUID, legacy mod-calendar will accept it)
• [x] ualibweb/mod-calendar#22

Determining Specifications

• [x] Create database schema (ualibweb/mod-calendar#1)
• [x] Determine new API schema (subject to modification) (blocked by ualibweb/mod-calendar#4)

New Backend

• [x] Lay foundation for new backend (ualibweb/mod-calendar#2)
  • [x] ualibweb/mod-calendar#9
• [x] ualibweb/mod-calendar#14
  • [x] ualibweb/mod-calendar#11
  • [x] ualibweb/mod-calendar#16
  • [x] ualibweb/mod-calendar#24
  • [x] ualibweb/mod-calendar#17
  • [x] ualibweb/mod-calendar#25
  • [x] ualibweb/mod-calendar#26
  • [x] ualibweb/mod-calendar#27
  • [x] ualibweb/mod-calendar#28
  • [x] ualibweb/mod-calendar#29

Backend Migration

• [x] ualibweb/mod-calendar#33
  • [x] SQL to construct new schema
  • [x] Java to parse old data and transform it into the new style
  • [x] SQL to remove old schema
  • [x] https://github.com/folio-org/folio-spring-base/pull/39
  • [x] ualibweb/mod-calendar#37

Backend Tests

• [x] Ensure each API route works properly
• [x] Ensure that data conversion works correctly
• [x] Fully document all new APIs and schema model

Other

• [x] ualibweb/mod-calendar#41

UI Rewrite

Admin Work

• [x] Create updated mockups based on meeting discussions and improved UX ideas (slideshow)
  • [x] Separated service point and calendar listings separate on the first pane
  • [x] Get approval (by SIGs/Cheryl?) before major development
• [x] Update user stories
• [x] ualibweb/ui-calendar#16
• [x] Potential additional feature ideas (talk to Steven):
  • [x] Preview calendar

New Backend Infastructure

• [x] ualibweb/mod-calendar#18
• [x] ualibweb/mod-calendar#49
• [x] ualibweb/mod-calendar#50
• [x] ualibweb/mod-calendar#54
• [x] ualibweb/mod-calendar#56
• [x] ualibweb/mod-calendar#53
• [x] ualibweb/mod-calendar#55
• [x] ualibweb/mod-calendar#57
• [x] ualibweb/mod-calendar#58
• [x] ualibweb/mod-calendar#59
• [x] ualibweb/mod-calendar#60
• [x] Update mod-circulation to work with these new and improved endpoints

UI Features/Stories

• [x] As a user, I would like to easily view all currently assigned calendars and the current opening hours for each service point, with sorting of each column.
• [x] As a user, I would like to be able to create new calendars and apply them to multiple service points.
• [x] As a user, I would like to be able to create new calendars with opening hours that can span multiple days
• [x] As a user, I would like to be able to edit existing calendars
• [x] As a user, I would like to be able to add exceptions to calendars to override their openings for some certain day(s).
• [x] As a user, I would like to be able to add exceptions to calendars to close them when they would normally be open.
• [x] As a user, I would like to be able to view all of the information for an existing calendar, including hours, exceptions, and assignments.
• [x] As a user, I would like to be able to preview a monthly calendar of openings for a service point.
• [x] As a user, I would like to be able to delete existing calendars.
• [x] As a user, I would like to be able to duplicate an existing calendar to make a new one without manually copying the information over.
• [x] As a user, I would like to be able to view all calendars, not just those that are currently in effect, with sorting in each column.
• [x] As a user, I would like to be able to purge old calendars with a selectable date (3 months, 6 months, 1 year, 2 years, etc).
• [x] As a user, I would like to be able to purge calendars that are not assigned to any service points.
• [x] As a user, I would like to be able to create calendars that are 24/7 (never close).
• [x] As a user, I would like to be able to sort headings on MCL tables
• [x] As an administrator, I would like to be able to add and control permissions for viewing, editing, and deleting opening hour information.
• [x] As a user, I would like the preference of weekdays starting on anything but Sunday to be properly respected.
• [x] As a user, I would like to view the interface in any language of my choice.

UI Testing

• [x] Jest/RTL unit tests
• [ ] Cypress?

Documentation

• [x] Add tutorials to https://docs.folio.com/ for:
  • [x] Explaining new calendar/service point model
  • [x] Creating a simple calendar
  • [x] Creating complex calendars
  • [x] Creating overnight, 24/5, and 24/7 calendars
  • [x] Applying a calendar to service points
  • [x] Adding exceptions
  • [x] Editing/deleting calendars
  • [x] Viewing previous/historic calendars
  • [x] Importance of purging calendars

[ncovercash]

Information from today's meeting with Cheryl: https://github.com/ualibweb/ui-calendar/wiki/2021-10-21-Meeting-with-Cheryl

[ualib-deploy]

Boy, that translation of JSON to sql DB seems like it will be really difficult. We need to find out how standardized the JSON is (schema anywhere to look at?), and then find some code to take the component parts of the JSON file, and shove them in to the appropriate corresponding SQL DB fields / table cells. Right?

[ualib-deploy]

And then we will need to provide the same API output that is expected from any call. I am hoping that this will be relatively easy.

[ncovercash]

It certainly does. I have not investigated that part too in-depth, however, there may be some special API endpoints we can hook to ensure this works properly.

[sjturner-ua]

Should we update these items?

[ncovercash]

They're pretty up to date: currently working on the UI testing category