lachang/app/store/model/card/UserRiceCardConsume.php

<?php

namespace app\store\model\card;

use app\common\model\card\UserRiceCardConsume as UserRiceCardConsumedModel;

/**
 * 我的米卡模型 
 * @package app\common\model
 */
class UserRiceCardConsume extends UserRiceCardConsumedModel
{

    public function getList(array $param = [])
    {
        // 检索查询条件
        $query = $this->getQueryFilter($param);
        // 查询列表数据
        return self::alias('card')
            ->leftJoin('user','card.user_id=user.user_id')
            ->leftJoin('user_rice_card','card.user_rice_card_id=user_rice_card.id')
            ->leftJoin('rice_card','rice_card.id=user_rice_card.card_id')
            ->leftJoin('order','card.order_no=order.order_no')
            ->field('card.id,card.user_rice_card_id,rice_card.name as card_name,card.user_id,card.pay_time,user.nick_name,user.mobile,card.order_no,card.order_amount,card.disaccount_amount,card.trans_type,card.remark,order.order_id')
            ->where($query)
            ->order(["card.id" => 'desc'])
            ->paginate(15)->toArray();
    }

    /**
     * 设置检索查询条件
     * @param array $param
     * @return array
     */
    private function getQueryFilter(array $param): array
    {
        // 默认参数
        $params = $this->setQueryDefaultValue($param);
        // 检索查询条件
        $filter = [];

        // 米卡ID
        if (isset($params['userRiceCardId']) && $params['userRiceCardId']>0) {
            $filter[] = ['card.user_rice_card_id', '=', $params['userRiceCardId']];
        }

        // 米卡ID
        if (isset($params['cardId']) && $params['cardId']>0) {
            $filter[] = ['rice_card.id', '=', $params['cardId']];
        }

        // 卡名
        if (!empty($params['cardName'])) {
            $filter[] = ['rice_card.card_name', 'like', "%{$params['cardName']}%"];
        }

        // 持有人
        if (!empty($params['nickName'])) {
            $filter[] = ['user.nick_name', 'like', "%{$params['nickName']}%"];
        }

        // 持有人手机号
        if (!empty($params['mobile'])) {
            $filter[] = ['user.mobile', 'like', "%{$params['mobile']}%"];
        }

        // 订单号
        if (!empty($params['orderNo'])) {
            $filter[] = ['card.order_no', 'like', "%{$params['orderNo']}%"];
        }

        //激活时间
        if (isset($params['betweenTime']) && $params['betweenTime']){
            if (isset($params['betweenTime'][0]) && $params['betweenTime'][0] && isset($params['betweenTime'][1]) && $params['betweenTime'][1]){
                $times = between_date($params['betweenTime']);
                $filter[] = ['card.pay_time','between',[$times['start_date'],$times['end_date']]];
            }
        }

        return $filter;
    }

}