AddressService.php 7.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203
  1. <?php
  2. // +----------------------------------------------------------------------
  3. // | Laravel框架 [ Laravel ]
  4. // +----------------------------------------------------------------------
  5. // | 版权所有 2017~2021 Laravel研发中心
  6. // +----------------------------------------------------------------------
  7. // | 官方网站: http://www.laravel.cn
  8. // +----------------------------------------------------------------------
  9. // | Author: wesmiler <12345678@qq.com>
  10. // +----------------------------------------------------------------------
  11. namespace App\Services;
  12. use App\Models\AddressModel;
  13. /**
  14. * 收货地址管理-服务类
  15. * @author wesmiler
  16. * @since 2020/11/11
  17. * Class AddressService
  18. * @package App\Services
  19. */
  20. class AddressService extends BaseService
  21. {
  22. protected static $instance = null;
  23. /**
  24. * 构造函数
  25. * @author wesmiler
  26. * @since 2020/11/11
  27. * AddressService constructor.
  28. */
  29. public function __construct()
  30. {
  31. $this->model = new AddressModel();
  32. }
  33. /**
  34. * 静态入口
  35. * @return ArticleService|null
  36. */
  37. public static function make(){
  38. if(!self::$instance){
  39. self::$instance = new ArticleService();
  40. }
  41. return self::$instance;
  42. }
  43. /**
  44. * 获取列表
  45. * @return array
  46. * @since 2020/11/11
  47. * @author wesmiler
  48. */
  49. public function getDataList($params)
  50. {
  51. $page = isset($params['pageSize']) ? intval($params['pageSize']) : PAGE;
  52. $pageSize = isset($params['pageSize']) ? intval($params['pageSize']) : PERPAGE;
  53. $dataList = $this->model::from('member_address as a')
  54. ->leftJoin('city as c1', 'c1.citycode', '=', 'a.province_id')
  55. ->leftJoin('city as c2', 'c2.citycode', '=', 'a.city_id')
  56. ->leftJoin('city as c3', 'c3.citycode', '=', 'a.district_id')
  57. ->where(function ($query) use ($params) {
  58. $query->where(['a.mark'=> 1,'a.status'=> 1]);
  59. $userId = isset($params['user_id']) ? $params['user_id'] : 0;
  60. if ($userId > 0) {
  61. $query->where('a.user_id', $userId);
  62. }
  63. })
  64. ->select(['a.id', 'a.user_id', 'c1.name as province_name','c2.name as city_name','c3.name as district_name', 'a.realname', 'a.mobile', 'a.is_default', 'a.status', 'a.create_time', 'a.update_time', 'a.address'])
  65. ->orderBy('a.is_default', 'asc')
  66. ->orderBy('a.create_time', 'desc')
  67. ->paginate($pageSize);
  68. $dataList = $dataList ? $dataList->toArray() : [];
  69. if ($dataList) {
  70. foreach ($dataList['data'] as &$item) {
  71. $item['create_time'] = $item['create_time'] ? datetime($item['create_time'],'Y-m-d H:i:s') : '';
  72. $item['address_text'] = $item['province_name'].$item['city_name'].$item['district_name'];
  73. }
  74. unset($item);
  75. }
  76. return [
  77. 'code' => 0,
  78. 'success'=> true,
  79. 'msg' => '操作成功',
  80. 'count' => isset($dataList['total']) ? $dataList['total'] : 0,
  81. 'data' => isset($dataList['data']) ? $dataList['data'] : 0,
  82. ];
  83. }
  84. /**
  85. * 添加或编辑
  86. * @return array
  87. * @since 2020/11/11
  88. * @author wesmiler
  89. */
  90. public function edit()
  91. {
  92. $data = request()->all();
  93. $data['update_time'] = time();
  94. $data['publish_at'] = isset($data['publish_at']) && $data['publish_at']? $data['publish_at'] : date('Y-m-d H:i:s');
  95. return parent::edit($data); // TODO: Change the autogenerated stub
  96. }
  97. /**
  98. * 信息
  99. * @return array|void
  100. */
  101. public function info(){
  102. $id = request()->input("id", 0);
  103. $info = [];
  104. if ($id) {
  105. $info = $this->model::from('member_address as a')
  106. ->leftJoin('city as c1', 'c1.citycode', '=', 'a.province_id')
  107. ->leftJoin('city as c2', 'c2.citycode', '=', 'a.city_id')
  108. ->leftJoin('city as c3', 'c3.citycode', '=', 'a.district_id')
  109. ->where(['a.id'=> $id,'a.mark'=> 1,'a.status'=> 1])
  110. ->select(['a.id', 'a.user_id', 'c1.name as province_name','c2.name as city_name','c3.name as district_name', 'a.realname','a.province_id','a.city_id','a.district_id', 'a.mobile', 'a.is_default', 'a.status', 'a.create_time', 'a.update_time', 'a.address'])
  111. ->first();
  112. }
  113. if($info){
  114. $province = isset($info['province_name']) && $info['province_name']? trim($info['province_name']) : '';
  115. $city = isset($info['city_name']) && $info['city_name']? trim($info['city_name']) : '';
  116. $district = isset($info['district_name']) && $info['district_name']? trim($info['district_name']) : '';
  117. $info['cityText'] = $province.' '.$city.' '.$district;
  118. $data = [intval($info['province_id']),intval($info['city_id']), intval($info['district_id'])];
  119. $info['cityCodes'] = $data;
  120. $info['cityData'] = $data;
  121. }
  122. return message(1005, true, $info);
  123. }
  124. /**
  125. * 保存添加数据
  126. * @param $params
  127. * @return array
  128. */
  129. public function save($params){
  130. $cityCodes = isset($params['cityCodes'])? $params['cityCodes'] : [];
  131. $cityCodes = $cityCodes? array_filter($cityCodes) : [];
  132. if(empty($cityCodes)){
  133. return message('请选择省市', false);
  134. }
  135. $isDefault = isset($params['is_default'])? intval($params['is_default']) : 2;
  136. $data = [
  137. 'id'=> isset($params['id'])? $params['id'] : 0,
  138. 'user_id' => isset($params['user_id'])? $params['user_id'] : 0,
  139. 'realname' => isset($params['realname'])? $params['realname'] : '',
  140. 'mobile' => isset($params['mobile'])? $params['mobile'] : '',
  141. 'province_id' => isset($cityCodes[0])? $cityCodes[0] : '',
  142. 'city_id' => isset($cityCodes[1])? $cityCodes[1] : '',
  143. 'district_id' => isset($cityCodes[2])? $cityCodes[2] : '',
  144. 'address' => isset($params['address'])? trim($params['address']) : '',
  145. 'is_default'=> $isDefault==1? $isDefault : 2,
  146. 'create_time'=> time()
  147. ];
  148. if($data['id']<=0){
  149. unset($data['id']);
  150. }
  151. if($data['is_default']==1){
  152. $this->model::where(['user_id'=> $data['user_id']])->update(['is_default'=> 2]);
  153. }
  154. $data['update_time'] = time();
  155. return parent::edit($data); // TODO: Change the autogenerated stub
  156. }
  157. /**
  158. * 获取默认地址
  159. * @param $userId
  160. * @return array
  161. */
  162. public function getDefault($userId){
  163. $info = $this->model::from('member_address as a')
  164. ->leftJoin('city as c1', 'c1.citycode', '=', 'a.province_id')
  165. ->leftJoin('city as c2', 'c2.citycode', '=', 'a.city_id')
  166. ->leftJoin('city as c3', 'c3.citycode', '=', 'a.district_id')
  167. ->where(['a.user_id'=> $userId,'a.mark'=> 1,'a.status'=> 1])
  168. ->select(['a.id', 'a.user_id', 'c1.name as province_name','c2.name as city_name','c3.name as district_name', 'a.realname', 'a.mobile', 'a.is_default', 'a.status', 'a.create_time', 'a.update_time', 'a.address'])
  169. ->orderBy('a.is_default', 'asc')
  170. ->orderBy('a.create_time', 'desc')
  171. ->first();
  172. $info = $info? $info->toArray() : [];
  173. if($info){
  174. $info['create_time'] = $info['create_time'] ? datetime($info['create_time'],'Y-m-d H:i:s') : '';
  175. $info['address_text'] = $info['province_name'].$info['city_name'].$info['district_name'];
  176. }
  177. return $info;
  178. }
  179. }