PNE-2189

• Update Whiteboard Line query output to accept date format and show in utc, url parameters

• Update Whiteboard view to properly show:

  • Show less hours for shift when hour is non-existent at Daylight Savings start

  • Extra Hour at Daylight Savings end

PNE-1548

Currently shift data resides in a series of monthly xml files. This information needs to be moved in to the database.

Copied from

• Create 3 database tables to migrate information from files to DB (Shift Mapping, Shift Pattern and Shift Schedule) - 1-2 days

• Write a utility to migrate existing data from files to Database, figure out how to handle missing files like ShiftPattern on some machines - 4 days

• Change the loading of shift information from database instead of files for reporting - 3 days

• Change the Shift Calendar saving to database (currently files are generated on front end and sent back via fupload) - 8 days

• Change the API for copying shift calendar from one machine to another - 3 days

• Change how schedule is autogenerated from pattern file once the existing schedule runs out (2 years apply forward) - 3-4 days

• The ability to copy shifts from machine to machine available from PEConfig’s clone machine/copy settings

Details

• Build new SqlShiftRepository class similar to: SqlJobRepository.cs, SqlAlertsRepository.cs

• Add error checking to Shift storage facility to avoid:

  • Overlapping shifts

• Modify ApiCalendarService.cs to store shift data received from Shift Calendar app (example from qa here: odniprovskyi_TestMachine Shift Calendar )

• The souce for Shift Reqport will have to be modified found here: ShiftModule.cs#L51

Design

Database

https://dbdiagram.io/d/61684ced940c4c4eec95e3d3

Demo

https://www.db-fiddle.com/f/5j1zjMq8atqMy4wLwx3yZs/38