// +---------------------------------------------------------------------- namespace App\Services\Api; use App\Models\MemberBankModel; use App\Services\BaseService; use App\Services\RedisService; /** * 用户银行卡管理-服务类 * @author laravel开发员 * @since 2020/11/11 * Class MemberBankService * @package App\Services\Common */ class MemberBankService extends BaseService { // 静态对象 protected static $instance = null; /** * 构造函数 * @author laravel开发员 * @since 2020/11/11 * MemberBankService constructor. */ public function __construct() { $this->model = new MemberBankModel(); } /** * 静态入口 * @return static|null */ public static function make() { if (!self::$instance) { self::$instance = (new static()); } return self::$instance; } /** * 列表数据 * @param $params * @param int $pageSize * @return array */ public function getDataList($params, $pageSize = 15) { $where = ['a.mark' => 1,'a.status'=>1]; $status = isset($params['status']) ? $params['status'] : 0; if ($status > 0) { $where['a.status'] = $status; } $userId = isset($params['user_id']) ? $params['user_id'] : 0; if ($userId > 0) { $where['a.user_id'] = $userId; } $list = $this->model->from('member_banks as a') ->where($where) ->select(['a.*']) ->orderBy('a.is_default', 'asc') ->orderBy('a.create_time', 'desc') ->orderBy('a.id', 'desc') ->paginate($pageSize > 0 ? $pageSize : 9999999); $list = $list ? $list->toArray() : []; if ($list) { foreach ($list['data'] as &$item) { $item['create_time'] = $item['create_time'] ? datetime($item['create_time'], 'Y-m-d H.i.s') : ''; $item['bank_card_text'] = $item['bank_card'] ? format_bank_card($item['bank_card']) : ''; $item['name_text'] = $item['bank_name'] ? mb_substr($item['bank_name'],0,1,'utf-8') : ''; $item['icon'] = $item['bank_code'] ? get_image_url('/images/icons/banks/icon-'.$item['bank_code'].'.png') : ''; $item['qrcode'] = $item['qrcode'] ? get_image_url($item['qrcode']) : ''; } } return [ 'pageSize' => $pageSize, 'total' => isset($list['total']) ? $list['total'] : 0, 'list' => isset($list['data']) ? $list['data'] : [] ]; } /** * 选项列表 * @param $userId * @return array|mixed */ public function options($userId) { $cacheKey = "caches:members:banks:{$userId}"; $datas = RedisService::get($cacheKey); if($datas){ return $datas; } $datas = $this->model->where(['user_id'=> $userId,'status'=> 1,'mark'=>1]) ->select(['id','realname','bank_name','bank_card','type','status']) ->get(); $datas = $datas? $datas->toArrayu() :[]; if($datas){ RedisService::set($cacheKey, $datas, 7200); } return $datas; } /** * 保存数据 * @param $userId * @param $params * @return mixed */ public function saveData($userId, $params) { $id = isset($params['id']) ? $params['id'] : 0; $isDefault = isset($params['is_default'])? $params['is_default'] : 2; $data = [ 'user_id'=> $userId, 'realname'=> isset($params['realname'])? trim($params['realname']) : '', 'type'=> isset($params['type'])? intval($params['type']) : 3, 'bank_name'=> isset($params['bank_name'])? trim($params['bank_name']) : '', 'branch_name'=> isset($params['branch_name'])? trim($params['branch_name']) : '', 'bank_card'=> isset($params['bank_card'])? trim($params['bank_card']) : '', 'bank_code'=> isset($params['bank_code'])? $params['bank_code'] : '', 'qrcode'=> isset($params['qrcode']) && $params['qrcode']? get_image_path($params['qrcode']) : '', 'is_default'=> $isDefault, 'status'=> isset($params['status'])? $params['status'] : 1, 'update_time'=> time(), 'mark'=> 1, ]; // 默认处理 if($isDefault == 1){ $this->model->where(['user_id'=> $userId,'mark'=>1])->update(['is_default'=>2,'update_time'=>time()]); } if($id && $this->model->where(['id'=> $id])->value('id')){ $this->model->where(['id'=> $id])->update($data); $this->error = $id? 1008 : 1027; return true; }else{ $data['create_time'] = time(); $this->error = 1027; return $this->model->insertGetId($data); } } /** * @return array|false */ public function delete() { // 参数 $id = request()->post('id'); if (empty($id)) { $this->error = 2014; return false; } $this->error = 1002; $this->model->where(['mark'=>0])->where('update_time','<=', time() - 3*86400)->delete(); return $this->model->where(['id'=> $id])->update(['mark'=> 0, 'update_time'=> time()]); } }