lachang/app/api/model/user/Withdraw.php

<?php
declare (strict_types=1);

namespace app\api\model\user;

use app\common\model\user\Withdraw as WithdrawModel;
use app\api\service\User as UserService;

/**
 * 用户提现模型
 * Class Withdraw
 * @package app\store\model\user
 */
class Withdraw extends WithdrawModel
{

    public function getList($query = [])
    {
        $userId = UserService::getCurrentLoginUserId();
        // 检索查询条件
        $filter = $this->getFilter($query);
        return $this->alias('t')->field('t.*')
            ->where($filter)
            ->where('t.user_id', $userId)
            ->leftJoin('user', 'user.user_id = t.user_id')
            ->order("t.create_time","desc")
            ->paginate(20);
    }

    private function getFilter($query = []) {
        $filter =[];
        
        if (!empty($query['date'])) { // 按日期筛选 2021-10
            $timestamp = strtotime($query['date']);
            $start_time = date('Y-m-1 00:00:00', $timestamp);
            $mdays = date('t', $timestamp);
            $end_time = date('Y-m-'.$mdays.' 23:59:59', $timestamp);
            $filter[] = ['t.create_time', '>=', $start_time];
            $filter[] = ['t.create_time', '<', $end_time];
        }

        return $filter;
    }

}