欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

TP SQL统计查询语法

程序员文章站 2022-03-21 16:37:31
获取今日订单总数和订单总金额 //fields区分出order_type不等于1的订单,订单金额money加运费order_freight合计 $fields = [ 'COUNT(1) as order_num', 'SUM(IF(order_type != 1, money + order_fr ......

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

 //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() : [];