我目前被困在这个地方 . 我需要一些帮助 .
Say for example this is the scenario input.
输入:Mo-Fr 06:00-22:00,Sa 07:00-22:00,08:00-22:00
Formetet到数据库表:
Table name : (Opening)
-
Day | DayNumber | Number | Open | Close
-
星期一,1:0:00,22:00
-
星期二,2:0:00,22:00
-
周三,3:0:00,22:00
-
周四,4:0:00,22:00
-
星期五,5:0:00,22:00
-
周六,6,7:00,24:00
-
太阳,0,8:00,24:00
I would like to group by day range from this table
预期的输出将如下:
"periods": [
{
"open": {
"day": 1,
"time": "06:00"
},
"close": {
"day": 5,
"time": "22:00"
}
},
{
"open": {
"day": 6,
"time": "07:00"
},
"close": {
"day": 6,
"time": "24:00"
}
},
{
"open": {
"day": 0,
"time": "08:00"
},
"close": {
"day": 0,
"time": "24:00"
}
}
]
2 回答
试试这个:
要做到这一点,我正在使用这样的东西 . 但我认为它无法满足我的确切输出: