Creating a "match" system with days of the week and different periods between two matches

Question

When I was doing a university project, I came across a problem that proved to be an obstacle. I need to create a system whose user is required to select days of the week and periods (night, day, morning) in a way that is convenient for him. Ex: user is available on Monday morning and afternoon and Sunday night.

Selected the days and periods available (via checkboxes on the site), this user will come across "jobs and projects" that are within their profile and available days. Since projects should also have this option to select their days and periods at the time of their creation.

The big problem is in the creation of this specific part, I broke my head with some Ables and on ways to cross this information in the bank, but nothing seemed to me that would work.

Answer 1

One practice used is to use binary sequence for operations like these. In the volunteer table, you would have a property to store the available days:

• Sunday - 1000000
• Monday - 0100000
• Tuesday - 0010000
• Wednesday - 0001000
• Thursday - 0000100
• Friday - 0000010
• Saturday - 0000001

When you want to accumulate the days is to make one OR among the values. When the volunteer can second, tuesday and saturday, shall be recorded 0110001 (or 49, which is the corresponding decimal)

For the period makes the same logic:

• Morning - 100
• Afternoon - 010
• Night - 001

When the volunteer can in the morning and evening will be recorded 101