獲取今日訂單總數和訂單總金額
//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() : [];
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/84978.html
標籤：PHP
上一篇：php 使用 CURL 獲取資料