MerchantService.php 4.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120
  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\AcceptorModel;
  13. use App\Models\MerchantModel;
  14. use App\Services\BaseService;
  15. /**
  16. * 商圈商家管理-服务类
  17. * @author laravel开发员
  18. * @since 2020/11/11
  19. * @package App\Services\Common
  20. */
  21. class MerchantService extends BaseService
  22. {
  23. /**
  24. * 构造函数
  25. * @author laravel开发员
  26. * @since 2020/11/11
  27. */
  28. public function __construct()
  29. {
  30. $this->model = new MerchantModel();
  31. }
  32. /**
  33. * 获取列表
  34. * @param $params 参数
  35. * @param int $pageSize 分页大小:默认 15
  36. * @return array
  37. */
  38. public function getDataList($params, $pageSize = 10, $field=[])
  39. {
  40. $where = ['a.mark' => 1];
  41. $status = isset($params['status'])? $params['status'] : 0;
  42. if($status>0){
  43. $where['a.status'] = $status;
  44. }
  45. $list = $this->model->with(['member'])
  46. ->from('merchant as a')
  47. ->leftJoin('member as b','b.id','a.user_id')
  48. ->where($where)
  49. ->where(function($query) use($params){
  50. $account = isset($params['account'])? trim($params['account']) : '';
  51. if($account){
  52. $query->where('b.username','like',"%{$account}%")->orWhere('b.trc_url','like',"%{$account}%")->orWhere('b.id','like',"%{$account}%");
  53. }
  54. })
  55. ->where(function($query) use($params){
  56. $kw = isset($params['kw'])? trim($params['kw']) : '';
  57. if($kw){
  58. $query->where('a.name','like',"%{$kw}%")->orWhere('a.mobile','like',"%{$kw}%");
  59. }
  60. })
  61. ->select($field? $field : ['a.*','b.username','b.trc_url','b.login_time'])
  62. ->paginate($pageSize > 0 ? $pageSize : 9999999);
  63. $list = $list? $list->toArray() :[];
  64. if($list){
  65. foreach($list['data'] as &$item){
  66. $item['create_time_text'] = $item['create_time']? datetime($item['create_time']):'';
  67. $item['logo'] = $item['logo']? get_image_url($item['logo']):get_image_url('/images/member/logo.png');
  68. $item['business_img'] = $item['business_img']? get_image_url($item['business_img']):'';
  69. $item['albums'] = $item['albums']? get_images_preview($item['albums']):[];
  70. }
  71. }
  72. return [
  73. 'pageSize'=> $pageSize,
  74. 'total'=>isset($list['total'])? $list['total'] : 0,
  75. 'list'=> isset($list['data'])? $list['data'] : []
  76. ];
  77. }
  78. /**
  79. * 添加会编辑会员
  80. * @return array
  81. * @since 2020/11/11
  82. * @author laravel开发员
  83. */
  84. public function edit()
  85. {
  86. // 请求参数
  87. $data = request()->all();
  88. // 头像处理
  89. $avatar = trim($data['avatar']);
  90. if (strpos($avatar, "temp")) {
  91. $data['avatar'] = save_image($avatar, 'member');
  92. } else {
  93. $data['avatar'] = str_replace(IMG_URL, "", $data['avatar']);
  94. }
  95. // 出生日期
  96. if ($data['birthday']) {
  97. $data['birthday'] = strtotime($data['birthday']);
  98. }
  99. // 城市处理
  100. $city = isset($data['city']) ? $data['city'] : [3];
  101. if (!empty($data['city'])) {
  102. // 省份
  103. $data['province_id'] = $city[0];
  104. // 城市
  105. $data['city_id'] = $city[1];
  106. // 县区
  107. $data['district_id'] = $city[2];
  108. }
  109. unset($data['city']);
  110. return parent::edit($data); // TODO: Change the autogenerated stub
  111. }
  112. }