MemberBankService.php 4.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160
  1. <?php
  2. // +----------------------------------------------------------------------
  3. // | LARAVEL8.0 框架 [ LARAVEL ][ RXThinkCMF ]
  4. // +----------------------------------------------------------------------
  5. // | 版权所有 2017~2021 LARAVEL研发中心
  6. // +----------------------------------------------------------------------
  7. // | 官方网站: http://www.laravel.cn
  8. // +----------------------------------------------------------------------
  9. // | Author: laravel开发员 <laravel.qq.com>
  10. // +----------------------------------------------------------------------
  11. namespace App\Services\Common;
  12. use App\Models\MemberAddressModel;
  13. use App\Models\MemberBankModel;
  14. use App\Services\BaseService;
  15. use App\Services\RedisService;
  16. /**
  17. * 用户银行卡管理-服务类
  18. * @author laravel开发员
  19. * @since 2020/11/11
  20. * Class MemberBankService
  21. * @package App\Services\Common
  22. */
  23. class MemberBankService extends BaseService
  24. {
  25. // 静态对象
  26. protected static $instance = null;
  27. /**
  28. * 构造函数
  29. * @author laravel开发员
  30. * @since 2020/11/11
  31. * MemberBankService constructor.
  32. */
  33. public function __construct()
  34. {
  35. $this->model = new MemberBankModel();
  36. }
  37. /**
  38. * 静态入口
  39. * @return static|null
  40. */
  41. public static function make()
  42. {
  43. if (!self::$instance) {
  44. self::$instance = (new static());
  45. }
  46. return self::$instance;
  47. }
  48. /**
  49. * 列表数据
  50. * @param $params
  51. * @param int $pageSize
  52. * @return array
  53. */
  54. public function getDataList($params, $pageSize = 15)
  55. {
  56. $where = ['a.mark' => 1];
  57. $status = isset($params['status']) ? $params['status'] : 0;
  58. if ($status > 0) {
  59. $where['a.status'] = $status;
  60. }
  61. $list = $this->model->from('member_bank as a')
  62. ->where($where)
  63. ->select(['a.*'])
  64. ->orderBy('a.is_default', 'asc')
  65. ->orderBy('a.id', 'desc')
  66. ->paginate($pageSize > 0 ? $pageSize : 9999999);
  67. $list = $list ? $list->toArray() : [];
  68. if ($list) {
  69. foreach ($list['data'] as &$item) {
  70. $item['create_time'] = $item['create_time'] ? datetime($item['create_time'], 'Y-m-d H.i.s') : '';
  71. }
  72. }
  73. return [
  74. 'pageSize' => $pageSize,
  75. 'total' => isset($list['total']) ? $list['total'] : 0,
  76. 'list' => isset($list['data']) ? $list['data'] : []
  77. ];
  78. }
  79. /**
  80. * 添加编辑
  81. * @return array
  82. * @since 2020/11/11
  83. * @author laravel开发员
  84. */
  85. public function edit()
  86. {
  87. // 请求参数
  88. $data = request()->all();
  89. return parent::edit($data); // TODO: Change the autogenerated stub
  90. }
  91. /**
  92. * 保存数据
  93. * @param $userId
  94. * @return mixed
  95. */
  96. public function saveData($userId)
  97. {
  98. $params = request()->all();
  99. $id = isset($params['id']) ? $params['id'] : 0;
  100. $isDefault = isset($params['is_default']) ? $params['is_default'] : 2;
  101. $data = [
  102. 'user_id' => $userId,
  103. 'realname' => isset($params['realname']) ? $params['realname'] : '',
  104. 'bank_name' => isset($params['bank_name']) ? $params['bank_name'] : '',
  105. 'bank_num' => isset($params['bank_num']) ? $params['bank_num'] : '',
  106. 'remark' => isset($params['remark']) ? $params['remark'] : '',
  107. 'is_default' => $isDefault,
  108. 'status' => isset($params['status']) ? $params['status'] : 1,
  109. 'update_time' => time(),
  110. 'mark' => 1,
  111. ];
  112. if($isDefault==1){
  113. $this->model->where(['user_id'=> $userId])->update(['is_default'=> 2,'update_time'=> time()]);
  114. }
  115. RedisService::keyDel("caches:banks:{$userId}");
  116. if(!$id){
  117. $data['create_time'] = time();
  118. return $this->model->insertGetId($data);
  119. }else{
  120. return $this->model->where(['id'=> $id])->update($data);
  121. }
  122. }
  123. /**
  124. * @param $userId
  125. * @return array|mixed
  126. */
  127. public function getBindInfo($userId)
  128. {
  129. $cacheKey = "caches:banks:{$userId}";
  130. $info = RedisService::get($cacheKey);
  131. if($info){
  132. return $info;
  133. }
  134. $info = $this->model->where(['user_id'=> $userId,'mark'=>1,'status'=>1])
  135. ->orderBy('is_default','asc')
  136. ->orderBy('id','desc')
  137. ->first();
  138. $info = $info? $info->toArray() : [];
  139. if($info){
  140. RedisService::set($cacheKey, $info, rand(5, 10));
  141. }
  142. return $info;
  143. }
  144. }