TP SQL统计查询语法
时间：2021-07-01 10:21:17
帮助过：50人阅读
fields区分出order_type不等于1的订单，订单金额money加运费order_freight合计
$fields =
[
‘COUNT(1) as order_num‘,
‘SUM(IF(order_type != 1, money + order_freight, 0)) as order_price‘
];
//where区分统计今日订单，已付款pay_status状态
$where =
[
[
‘create_time‘,
‘between‘,
strtotime(
date(‘Y-m-d‘)).‘,‘.
strtotime(
date(‘Y-m-d 23:59:59‘)),
],
[
‘pay_status‘,‘=‘,1,
]
];
$static =
$this->field(
$field)->where(
$where)->where(‘is_deleted‘, 0)->
find();
return $static ?
$static->toArray() : [];
TP SQL统计查询语法
标签：count class 查询 语法 HERE 订单 pre 统计 between
