NN2023021801/app/common/service/YsBankService.php

<?php

namespace app\common\service;

use app\common\model\YsBankListModel;
use utils\RedisCache;

/**
 * 银盛银行卡服务 by wes
 * Class YsBankService
 * @package app\common\service
 */
class YsBankService
{
    protected static $instance = null;
    protected $model = null;

    public function __construct()
    {
        $this->model = new YsBankListModel();
    }

    /**
     * 静态化入口
     * @return static|null
     */
    public static function make()
    {
        if (!self::$instance) {
            self::$instance = new static();
        }

        return self::$instance;
    }

    /**
     * 获取银行卡列表
     * @param $params 查询参数
     * @param int $pageSize
     * @param string $field
     * @param string $cache
     * @return array|mixed
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     */
    public function getList($params, $pageSize = 10, $field = '', $cache=true)
    {
        $page = request()->post('page', 1);
        $cacheKey = "caches:temp:ysBankList:{$page}_{$pageSize}_" . md5(json_encode($params));
        $data = RedisCache::get($cacheKey);
        if ($data && $cache) {
            return $data;
        }

        $field = $field ? $field : 'id,bank_no,bank_name,bank_sub,bank_type,bank_value,status';
        $data = $this->model->where(['status' => 1])->where(function ($query) use ($params) {
                    $keyword = isset($params['keyword']) ? trim($params['keyword']) : '';
                    if ($keyword) {
                        $query->where('bank_name|bank_sub', 'like', "%{$keyword}%");
                    }
                })
                ->field($field)
                ->order('id asc')
                ->page($page, $pageSize)->select();
        $data = $data? $data->toArray() : [];
        if($data && $cache){
            RedisCache::set($cacheKey, $data, 3600);
        }

        return $data;
    }

}