|
- $order = array(
- array('cooperator_id' => 1001, 'app_id' => 100, 'amount' => 4800),
- array('cooperator_id' => 1001, 'app_id' => 'qn_100', 'amount' => 9000)
- );
- $pay = array(
- array('cooperator_id' => 1001, 'app_id' => 100, 'amount' => 3600),
- array('cooperator_id' => 1001, 'app_id' => 'qn_100', 'amount' => 8400)
- );
- $trade = array(
- array('cooperator_id' => 1001, 'app_id' => 100, 'amount' => 3600),
- array('cooperator_id' => 1001, 'app_id' => 'qn_100', 'amount' => 6400)
- );
复制代码
这是三个数据要生成下面的结果请问要怎么做?我觉得sql语句好写,但要的是,提前先把数据遍历一下,做$data = array();把数据在$data中把数据组好,请问要怎么组?
结果:
report_date cooperator_id app_id order_amount pay_amount trade_amount
2016-12-05 1001 100 4800 3600 3600
2016-12-05 1001 100 9000 8400 6400
|
|