I have a table containing some date for dates:
___BillableDatas:
|----------|------------|---------------|
|BIL_Id | BIL_Date | BIL_BookingID |
|----------|------------|---------------|
| 1 | 2017-01-01 | 10 |
| 2 | 2017-01-02 | 10 |
| 3 | 2017-01-06 | 11 |
| 4 | 2017-01-07 | 11 |
| 5 | 2017-01-08 | 11 |
| 6 | 2017-01-12 | 14 |
|----------|------------|---------------|
And I have this array giving me all the dates between two dates:
$dates = getDatesFromRange('2017-01-01', '2017-01-15');
Array ( [0] => 2017-01-01 [1] => 2017-01-02 [2] => 2017-01-03 [3] => 2017-01-04 [4] => 2017-01-05 [5] => 2017-01-06 [6] => 2017-01-07 [7] => 2017-01-08 [8] => 2017-01-09 [9] => 2017-01-10 [10] => 2017-01-11 [11] => 2017-01-12 [12] => 2017-01-13 [13] => 2017-01-14 )
I want to be able to loop into this table to get all the days between a period (from 2017-01-01
to 2017-01-15
for example).
For example, the desired output should be the following Json or array:
"datas": {
"2017-01-01": {
"bookingId": "10"
},
"2017-01-02": {
"bookingId": "10"
},
"2017-01-03": {
"bookingId": "0"
},
"2017-01-04": {
"bookingId": "0"
},
"2017-01-05": {
"bookingId": "0"
},
"2017-01-06": {
"bookingId": "11"
},
"2017-01-07": {
"bookingId": "11"
},
"2017-01-08": {
"bookingId": "11"
},
"2017-01-09": {
"bookingId": "0"
},
"2017-01-10": {
"bookingId": "0"
},
"2017-01-11": {
"bookingId": "0"
},
"2017-01-12": {
"bookingId": "14"
},
"2017-01-13": {
"bookingId": "0"
},
"2017-01-14": {
"bookingId": "0"
},
"2017-01-15": {
"bookingId": "0"
}
}
Any help please.
Thanks.