zhaojs
2023-06-07 086e556b94d79269b2124c78a7740a16050f603c
application/api/logic/commission/Dy.php
@@ -27,7 +27,7 @@
     */
    public function getEstimateCommission($user_id,$time_type,$is_own)
    {
        $info = Db::name('douyin_order_commission')->field("COUNT(id) as order_num,COALESCE(SUM(pub_share_pre_fee),0) as money,COALESCE(SUM(alipay_total_price),0) as sales_volume,'抖音' as name")->where(['member_id'=>$user_id,'is_own'=>$is_own])->whereTime('tb_paid_time', $time_type)->find();
        $info = Db::name('douyin_order_commission')->field("COUNT(id) as order_num,COALESCE(SUM(pub_share_pre_fee),0) as money,COALESCE(SUM(alipay_total_price),0) as sales_volume,'抖音' as name")->where(['member_id'=>$user_id,'is_own'=>$is_own])->whereTime('tb_paid_time', $time_type)->whereIn('tk_status',[1,2])->find();
        return $info;
    }