Break Schedule Web App

I hope this is the right place to ask.

So my employer has a break schedule for who is relieving who on each break. Currently they do this by updating an excel spreadsheet and saving it as a PDF, with this there are caching issues which some get the updated schedule and others don't. I would like to change this to be a web app. I am formulating my idea on how I want it to look and function but I can't seems to come up with how to store the data for archiving purposes.

When speaking with a supervisor they requested that it have the ability to recall older schedules from any given day. Each line has 3 breaks which all needs to be stored which could have any number of names(usually 1 - 3 names) and a count 1x,2x,3x (for the number of break relieves the given person will have.

Any ideas on how I could go about storing this data? I will be using Laravel of course.

aurawindsurfing

7 years ago

Best Answer

Level 50

Hi,

You can simply store that in a database. Seems like a perfect place for this type of thing.

Define migration for Department (id, name etc)
Define migration for brakes (id, start_date_time, end_date_time)
Define lines (id, brake_id, [users])

This way Department has many brakes. Brake has many lines. Line has many names.

Something like that.

Then define models and rest is just fun with laravel ;-)

Hope it helps!

CarbonNanotubes

7 years ago

Level 19

My question was how to handle the archive of data but after reading your post I thought if there is a date attached to them I can call on that to produce break schedules for previous days.

Thanks for the assistance!

aurawindsurfing

7 years ago

Level 50

Hi Yes indeed!

Please or to participate in this conversation.