I have the following 2 tables:
- table Guide which includes the guide's name and work day.
- table Activity which has a date and the guide id who created the activity
Given a guide id and 1 date range, I would like to automatically create activities on the work days in which the guide can work.
for example: Joe works on Mondays. Chloe works on Thursdays
given Joe, from date January 1st 2017 and February 1st 2017 -> 5 Activities will be created
given Chloe, from date January 1st 2017 and February 1st 2017 -> 4 Activities will be created