@ 2017-11-23T19:04:52Z <?php
$dates = ['01.01.18', '02.01.18', '03.01.18']; //Dates are getting from daterange datepicker and preparing dates using php and stored in array.
foreach($dates as $date) {
// fetching data from table where date is matching with "$date".
$bookings = [
['date' => '01.01.18', 'beds' => '2'],
['date' => '01.01.18', 'beds' => '3'],
['date' => '01.01.18', 'beds' => '5'],
['date' => '02.01.18', 'beds' => '7'],
['date' => '02.01.18', 'beds' => '6'],
['date' => '02.01.18', 'beds' => '5'],
['date' => '03.01.18', 'beds' => '2'],
['date' => '03.01.18', 'beds' => '5'],
];
}
$arr = array();
foreach($bookings as $booking) {
$date = $booking['date'];
if(array_key_exists($date, $arr))
$arr[$date][] = $booking['beds'];
else
$arr[$date] = array($booking['beds']);
}
foreach($arr as $key => $value)
{
$count = count($value);
$sum = array_sum($value);
echo "on {$key} I have {$count} bookings and sum of beds is {$sum}\r\n";
}
Enable javascript to submit You have javascript disabled. You will not be able to edit any code.
Output for 7.0.0 - 7.0.25 , 7.1.0 - 7.1.33 , 7.2.5 - 7.2.33 , 7.3.0 - 7.3.33 , 7.4.0 - 7.4.33 , 8.0.0 - 8.0.30 , 8.1.0 - 8.1.33 , 8.2.0 - 8.2.29 , 8.3.0 - 8.3.25 , 8.4.1 - 8.4.13 on 01.01.18 I have 3 bookings and sum of beds is 10
on 02.01.18 I have 3 bookings and sum of beds is 18
on 03.01.18 I have 2 bookings and sum of beds is 7
preferences:dark mode live preview ace vim emacs key bindings
202.61 ms | 408 KiB | 5 Q