Soldato
i'm creating a part of my web app where staff times are created dynamically each month based on the date they started at a site, the frequency of which they work (e.g. mon, wed, fri) and the hours they do, e.g. 2.5 mon, 3 hours wed, 2.5 fri etc.
at the moment i go to each staffs times this month and it's displayed as follows,
Michelle May 2015.
- Total Hours - 34.5 over 13 days
- Friday 01/05 : 6pm - 8.30pm : 2.5 hours
- Monday 04/05 : 6pm - 8.30pm : 2.5 hours
- Wednesday 06/05 : 6pm - 8pm : 3 hours
- Friday 08/05 : 6pm - 8.30pm : 2.5 hours
- Monday 11/05 : 6pm - 8.30pm : 2.5 hours
- Wednesday 13/05 : 6pm - 8pm : 3 hours
- Friday 15/05 : 6pm - 8.30pm : 2.5 hours
- Monday 18/05 : 6pm - 8.30pm : 2.5 hours
- Wednesday 20/05 : 6pm - 8pm : 3 hours
- Friday 22/05 : 6pm - 8.30pm : 2.5 hours
- Monday 25/05 : 6pm - 8.30pm : 2.5 hours
- Wednesday 27/05 : 6pm - 8pm : 3 hours
- Friday 29/05 : 6pm - 8.30pm : 2.5 hours
this is just for one site and the staff may have 2/3 sites per month.
what i'd like to do is have the info stored in different fields for the following: staffId, month, year, total hours, total days, and then the days they've worked in one field, which i can break up with php at a later point if needed, but saving me having a massive load of fields. how best would it be to store it so that it can easily be taken apart, e.g.
[date][starttime][endtime]
unless with that said, would it be better to have the above stored on another table which is linked to this one?
at the moment i go to each staffs times this month and it's displayed as follows,
Michelle May 2015.
- Total Hours - 34.5 over 13 days
- Friday 01/05 : 6pm - 8.30pm : 2.5 hours
- Monday 04/05 : 6pm - 8.30pm : 2.5 hours
- Wednesday 06/05 : 6pm - 8pm : 3 hours
- Friday 08/05 : 6pm - 8.30pm : 2.5 hours
- Monday 11/05 : 6pm - 8.30pm : 2.5 hours
- Wednesday 13/05 : 6pm - 8pm : 3 hours
- Friday 15/05 : 6pm - 8.30pm : 2.5 hours
- Monday 18/05 : 6pm - 8.30pm : 2.5 hours
- Wednesday 20/05 : 6pm - 8pm : 3 hours
- Friday 22/05 : 6pm - 8.30pm : 2.5 hours
- Monday 25/05 : 6pm - 8.30pm : 2.5 hours
- Wednesday 27/05 : 6pm - 8pm : 3 hours
- Friday 29/05 : 6pm - 8.30pm : 2.5 hours
this is just for one site and the staff may have 2/3 sites per month.
what i'd like to do is have the info stored in different fields for the following: staffId, month, year, total hours, total days, and then the days they've worked in one field, which i can break up with php at a later point if needed, but saving me having a massive load of fields. how best would it be to store it so that it can easily be taken apart, e.g.
[date][starttime][endtime]
unless with that said, would it be better to have the above stored on another table which is linked to this one?