laravel 模型经纬度距离排序

小人物之辈

已于 2024-05-24 12:05:30 修改

阅读量286

点赞数 12

文章标签： mysql laravel

于 2024-05-24 12:02:02 首次发布

本文链接：https://blog.csdn.net/u012230371/article/details/139171468

版权

$paginate=Model::with(['assortData','gradeData','frameData','userData','supplierData','pers        
          onData'])
     ->wheres($sql)
     ->select('*',DB::raw("(2 * 6371 * ASIN(SQRT(POWER(SIN((RADIANS(32.400677) - 
               RADIANS(`latitude`)) / 2), 2) + COS(RADIANS(32.400677)) * 
               COS(RADIANS(`latitude`)) * POWER(SIN((RADIANS(119.419419) - 
               RADIANS(`longitude`)) / 2), 2)))) AS distance"))
     ->orderBy('id','desc')
     ->paginate($input['size']);