API 动态查询参数—— spatie/laravel-query-builder

2020-10-30 15:09:00 阅读:1 编辑

https://learnku.com/courses/laravel-package/2019/spatielaravel-query-builder/2509

Route::get('/user', function (Request $request) {
  // $menus = \Linson\ShenAdmin\Models\Menu::withoutGlobalScopes()->get();
    //http://demo.test/api/user?sort=id
    //http://demo.test/api/user?sort=-id

    //menus为数据库的表名
    //http://demo.test/api/user?sort=-id&fields[menus]=id,title

    $menus = \Spatie\QueryBuilder\QueryBuilder::for( \Linson\ShenAdmin\Models\Menu::class)
        ->withoutGlobalScopes()
        ->allowedFields(['id', 'title'])
        ->allowedSorts('id','order')
        ->get();
   return response()->json($menus);
});