lachang/app/store/model/member/MemberCardOrder.php

<?php

declare (strict_types=1);

namespace app\store\model\member;

use app\common\service\store\User as StoreUserService;
use app\common\model\member\MemberCardOrder as MemberCardOrderModel;
use think\facade\Db;

/**
 * 会员卡
 * Class MemberCards
 * @package app\common\model
 */
class MemberCardOrder extends MemberCardOrderModel
{
   
    protected $append = [];

    public function getOrdersList($params){
        $filter[] = ['is_del','=',0];
        if (!empty($params['orderNo'])){
            $filter[] = [$this->name.'.order_no','like','%'.$params['orderNo'].'%'];
        }

        if (!empty($params['mobile'])){
            $filter[] = ['us.mobile','like','%'.$params['mobile'].'%'];
        }

        if (isset($params['payStatus']) && $params['payStatus']>=0){
            $filter[] = [$this->name.'.pay_status','=',$params['payStatus']];
        }

        if (!empty($params['createTime'])){
            $times = between_date($params['createTime']);
            $filter[] = [$this->name.'.create_time','>=',$times['start_date']];
            $filter[] = [$this->name.'.create_time','<=',$times['end_date']];
        }

        $query =  $this->alias($this->name)->leftJoin('user us',$this->name.'.user_id=us.user_id')
            ->where($filter);
        if (!empty($params['nickname'])){
            $query = $query->where('us.nick_name|us.user_id','like','%'.$params['nickname'].'%');
        }
         return $query->field('id,order_no,'.$this->name.'.user_id,member_cards_origin_price,member_cards_sale_price,'
             .$this->name.'.create_time,pay_status,us.nick_name,us.mobile')
            ->order('id desc')
            ->paginate(15);
    }
}