如何求和值并向数组codeigniter添加行

8e2ybdfx 于 2021-06-18 发布在 Mysql

关注(0)|答案(1)|浏览(321)

模型中的mysql

public function dailymovedate($datee,$dateee)
{
  header("Content-Type: application/json");
    $this->db->select("dailymovement.id_order,dailymovement.item_code,currency.currency_name as totalamountbuy,dailymovement.totalamountsale,CONCAT(dailymovement.detials_daily,' qyt',ordersale.totalqyt) AS detials_daily ", false);

    $this->db->from('dailymovement');
    $this->db->join('ordersale', 'ordersale.idorder= dailymovement.id_order','left outer');
    $this->db->join('currency', 'currency.currency_number = ordersale.currency_number','left outer');

    $this->db->where('dailymovement.data_daily>=', $datee);
    $this->db->where('dailymovement.data_daily<=', $dateee);
    $this->db->where('dailymovement.totalamountsale!=' ,null,FALSE);
    $this->db->order_by("dailymovement.id_order", "desc");
    $query = $this->db->get();

    return json_encode($query->result(),JSON_UNESCAPED_UNICODE);
}

数组json

[{"id_order":"21","item_code":"SALE","totalamountbuy":"$","totalamountsale":"48790","detials_daily":" 153"},
{"id_order":"23","item_code":"SALE","totalamountbuy":"$","totalamountsale":"20790","detials_daily":" 5"}
{"id_order":"20","item_code":"SALE","totalamountbuy":"ERUO","totalamountsale":"22200","detials_daily":" 40"},
{"id_order":"19","item_code":"SALE","totalamountbuy":"TL","totalamountsale":"4500","detials_daily":" 45"}]

sum values并添加行例如sum values totalamountsale if totalamountbuy==$
我想添加一个额外的字段`

{"item_code":"TOTAL","totalamountbuy":"$","totalamountsale":"69580","detials_daily":" 158"}

现在结果

[{"id_order":"21","item_code":"SALE","totalamountbuy":"$","totalamountsale":"48790","detials_daily":" 153"},
{"id_order":"23","item_code":"SALE","totalamountbuy":"$","totalamountsale":"20790","detials_daily":" 5"}
{"id_order":"20","item_code":"SALE","totalamountbuy":"ERUO","totalamountsale":"22200","detials_daily":" 40"},
{"id_order":"19","item_code":"SALE","totalamountbuy":"TL","totalamountsale":"4500","detials_daily":" 45"},
{"id_order":"0","item_code":"TOTAL","totalamountbuy":"$","totalamountsale":"69580","detials_daily":" 158"}]

mysql JSON Arrays php codeigniter

来源：https://stackoverflow.com/questions/53557171/how-to-sum-values-and-add-row-to-array-codeigniter

1条答案

按热度按时间

rm5edbpk1#

// for demonstration purposes, using json_decode to get an array matching your sample data
$querydata = json_decode('[{"id_order":"21","item_code":"SALE","totalamountbuy":"$","totalamountsale":"48790","detials_daily":" 153"},
{"id_order":"23","item_code":"SALE","totalamountbuy":"$","totalamountsale":"20790","detials_daily":" 5"},
{"id_order":"20","item_code":"SALE","totalamountbuy":"ERUO","totalamountsale":"22200","detials_daily":" 40"},
{"id_order":"19","item_code":"SALE","totalamountbuy":"TL","totalamountsale":"4500","detials_daily":" 45"}]');

// initialize total array with 0 as starting value for the fields to sum up
$total = [ 'id_order' => '0', 'item_code' => 'TOTAL', 'totalamountbuy' => '$',
           'totalamountsale' => 0, 'detials_daily' => 0 ];

foreach($querydata as $row) {
  if($row->totalamountbuy == '$') { // if $, add up values
    $total['totalamountsale'] += $row->totalamountsale;
    $total['detials_daily'] += $row->detials_daily;
  }
}

// append total to existing array
$querydata[] = $total;

echo json_encode($querydata);

赞(0）回复(0）举报 2021-06-18

我来回答

如何求和值并向数组codeigniter添加行

1条答案

相关问题

热门标签

最新问答