OfflineShop.php 2.3 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970
  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. return $this->success('success',$list);
  64. }
  65. }