$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']);
laravel 模型 经纬度 距离排序
于 2024-05-24 12:02:02 首次发布