OfflineShop.php 3.1 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192
  1. <?php
  2. namespace app\api\controller;
  3. use app\common\controller\Api;
  4. use app\common\model\OfflineShopModel;
  5. use app\common\model\OfflineTypeModel;
  6. use app\utils\DataUtil;
  7. use think\Db;
  8. /**
  9. * 示例接口
  10. */
  11. class OfflineShop extends Api
  12. {
  13. protected $noNeedLogin = [''];
  14. protected $noNeedRight = ['*'];
  15. // 商圈分类
  16. public function type()
  17. {
  18. $params = $this->request->param();
  19. $model = new OfflineTypeModel();
  20. $model->setSelect(['id','pid','name','image']);
  21. $list = $model->getList(params: $params,orderBy: ['weigh' => 'desc','id' => 'desc']);
  22. return $this->success('success',DataUtil::recursion($list,'id','pid'));
  23. }
  24. // 商铺列表
  25. public function list()
  26. {
  27. $params = $this->request->param();
  28. $userLng = $this->auth->lng;
  29. $userLat = $this->auth->lat;
  30. $model = new OfflineShopModel();
  31. $select = ['id', 'type_id', 'type_ids', 'name', 'image', 'lng', 'lat', 'address', 'telephone', 'star', 'sales'];
  32. $orderBy = [];
  33. if (!empty($userLng) && !empty($userLat)) {
  34. $select[] = Db::raw("(st_distance(point ({$userLng}, {$userLat}),point(lng,lat))*111195) as distance");
  35. !empty($params['distance']) && $params['distance'] = $params['distance'] * 1000;
  36. }
  37. if (!empty($this->auth->city)) {
  38. $params['city'] = $this->auth->city;
  39. }
  40. if (isset($params['rank_type'])) {
  41. switch ($params['rank_type']) {
  42. case 1:
  43. $orderBy['star'] = 'desc';
  44. break;
  45. case 2:
  46. $orderBy['sales'] = 'desc';
  47. break;
  48. case 3:
  49. if (!empty($userLng) && !empty($userLat)) {
  50. $orderBy['distance'] = 'asc';
  51. }
  52. break;
  53. default:
  54. if (!empty($userLng) && !empty($userLat)) {
  55. $orderBy['distance'] = 'asc';
  56. }
  57. $orderBy['star'] = 'desc';
  58. $orderBy['sales'] = 'desc';
  59. break;
  60. }
  61. }
  62. $list = $model->getList(params: $params,orderBy: array_merge($orderBy,['weigh' => 'desc']),select: $select);
  63. foreach ($list as &$item) {
  64. [$distance,$unit] = \app\utils\Common::distanceTo($item['distance']);
  65. $item['distance'] = "{$distance}{$unit}";
  66. }
  67. return $this->success('success',$list);
  68. }
  69. // 商铺列表
  70. public function info()
  71. {
  72. $params = $this->request->param();
  73. $userLng = $this->auth->lng;
  74. $userLat = $this->auth->lat;
  75. $model = new OfflineShopModel();
  76. $select = ['*'];
  77. if (!empty($userLng) && !empty($userLat)) {
  78. $select[] = Db::raw("(st_distance(point ({$userLng}, {$userLat}),point(lng,lat))*111195) as distance");
  79. }
  80. $info = $model->getDetail(params: $params,select: $select);
  81. if (!empty($info)) {
  82. $info['images'] = explode(',',$info['image']);
  83. }
  84. return $this->success('success',$info);
  85. }
  86. }