php 获取半年内每个月的订单数量, 总价, 月份

最新推荐文章于 2022-12-01 14:21:03 发布

原创最新推荐文章于 2022-12-01 14:21:03 发布 · 1.3k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

本文介绍了一段PHP代码，用于统计过去六个月内支付成功的订单数量及总金额，并按月份进行分组。

$time = time();
$endtime = strtotime(date('Y-m', strtotime('-6 month')));

$store_id = $_SESSION['admin_user']['store_id'];
$where['pay_state'] = 2; //支付成功
$where['print_state'] = 4; //打印状态: 打印完成
$where['store_id'] = $store_id;
$where['create_time'] = ['between', [$endtime, $time]];

$model = D('Order');
$list = $model->field("sum(pay_price) as price, count(1) as cnt,FROM_UNIXTIME(create_time, '%Y-%m') as create_time")->where($where)->group("FROM_UNIXTIME(create_time, '%Y-%m')")->order("create_time asc")->select();
var_dump($list);