Essentially a query can be fulfilled here, probably following structure
Id | 2020-11-1 | 2020-11-1 | 2020-11-3 | 2020-11-3 | | 2020-11-5...
001 | 1 | | 1 | | 1 |
002 | | | | 0 0 1 | 1 |
003 | | | | 0 0 1 | 1 |


Dynamic generation date header according to the query time, according to the existing date field in judgment, there is zero, there is no 1

, genuflect is begged