TP SQL统计查询语法

获取今日订单总数和订单总金额

 //fields区分出order_type不等于1的订单，订单金额money加运费order_freight合计 $fields = [     'count(1) as orde婆婆照顾植物儿媳r_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_stat创意糖果us','=',1,意大利首都     ] ]; $static = $this->field($field)->where($where)->where('is_deleted', 0)->find(); return $st我家的春节作文atic ? $static->toarray() : [];