<?php
$Todaysales = array(
array("sale_time"=>"2017-09-10","payment_amount"=>1311.45),
array("sale_time"=>"2017-09-10","payment_amount"=>1311.46),
array("sale_time"=>"2017-09-10","payment_amount"=>175000.00),
array("sale_time"=>"2017-09-11","payment_amount"=>175500.00),
);
foreach($Todaysales as $d)
{
if(isset($data[$d['sale_time']]))
$data[$d['sale_time']] += $d['payment_amount'];
else
$data[$d['sale_time']] = $d['payment_amount'];
}
$new_data["cols"] ="'".implode("','",array_keys($data))."'";
$new_data["rows"] =implode(",",array_values($data));
print_r($new_data);
- Output for 7.0.0 - 7.0.23, 7.1.0 - 7.1.20, 7.2.6 - 7.2.33, 7.3.16 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.30, 8.2.0 - 8.2.25, 8.3.0 - 8.3.13
- Array
(
[cols] => '2017-09-10','2017-09-11'
[rows] => 177622.91,175500
)
preferences:
62.49 ms | 407 KiB | 5 Q