// +---------------------------------------------------------------------- namespace App\Services\Api; use App\Models\MemberBankModel; use App\Services\BaseService; use App\Services\RedisService; /** * 用户银行卡管理-服务类 * @author laravel开发员 * @since 2020/11/11 * @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; } $type = isset($params['type']) ? $params['type'] : 0; if ($type > 0) { $where['a.type'] = $type; } $list = $this->model->from('member_banks as a') ->where($where) ->select(['a.*']) ->orderBy('a.create_time', 'desc') ->orderBy('a.id', 'desc') ->paginate($pageSize > 0 ? $pageSize : 9999999); $list = $list ? $list->toArray() : []; 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, $userType=1) { $cacheKey = "caches:members:banks:{$userId}_{$userType}"; $datas = RedisService::get($cacheKey); if($datas){ return $datas; } $datas = $this->model->where(['user_id'=> $userId,'user_type'=>$userType,'status'=> 1,'mark'=>1]) ->select(['id','realname','bank_name','bank_card','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; $type = isset($params['type']) && $params['type']? $params['type'] : 2; $data = [ 'user_id'=> $userId, 'type'=> $type, 'realname'=> isset($params['realname'])? $params['realname'] : '', 'account'=> isset($params['account'])? $params['account'] : '', 'account_name'=> isset($params['account_name'])? $params['account_name'] : '', 'account_remark'=> isset($params['account_remark'])? $params['account_remark'] : '', 'status'=> isset($params['status']) && $params['status']? $params['status'] : 1, 'update_time'=> time(), 'mark'=> 1, ]; 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()]); } }