id | workings_days(day of the week) |
---|---|
1 | "1,5" |
2 | "2,3" |
output will be
id | workings_days(day of the week) |
---|---|
1 | 1 |
1 | 5 |
2 | 2 |
2 | 3 |
and then find close next date from current date according to working days
for example :
if working days 1(means monday) , 5(means friday)
and current day is 3 (means wednesday)
then nxt close day is 5 means friday