A set of employees (less then 2000) need to select their availability (pick multiple dates) during the year. I need to save that availability and after select the employees available for a specific event (filter by start date and end date). I want those who are fully available and partially available.
一组员工(少于2000人)需要在一年中选择他们的可用性(选择多个日期)。我需要保存该可用性,然后选择可用于特定事件的员工(按开始日期和结束日期过滤)。我想要那些完全可用且部分可用的人。
When the employees select their availability the most efficient way is to save day by day or by date blocks?
当员工选择他们的可用性时,最有效的方法是每天或按日期块保存?
The table should be rather simple: DATE & Person_ID .
该表应该相当简单:DATE和Person_ID。
Did someone created something similar? What do you think it's the best approach?
有人创造了类似的东西吗?您认为这是最好的方法吗?
1 个解决方案
#1
0
SQL is the least flexible language; your task needs flexibility.
SQL是最不灵活的语言;你的任务需要灵活性。
Use SQL to do some filtering, but then use PHP or JavaScript to do the real work.
使用SQL进行一些过滤,然后使用PHP或JavaScript来完成实际工作。
#1
0
SQL is the least flexible language; your task needs flexibility.
SQL是最不灵活的语言;你的任务需要灵活性。
Use SQL to do some filtering, but then use PHP or JavaScript to do the real work.
使用SQL进行一些过滤,然后使用PHP或JavaScript来完成实际工作。