PHP app Pessoa::orderBy示例

示例#1

文件： Pessoas.php 项目： gildeoncarvalho/exerciciostep

 /**
  * Display a listing of the resource.
  *
  * @return Response
  */
 public function index($id = null)
 {
     if ($id == null) {
         return Pessoa::orderBy('id', 'asc')->get();
     } else {
         return $this->show($id);
     }
 }

示例#2

文件： EmpresaController.php 项目： basalbr/fvm

 public function indexAdmin()
 {
     $empresas = \App\Pessoa::orderBy('nome_fantasia')->get();
     return view('admin.empresa.index', ['empresas' => $empresas]);
 }

示例#3

文件： routes.php 项目： jansenfelipe/laravel-angular-material

<?php

/*
|--------------------------------------------------------------------------
| Application Routes
|--------------------------------------------------------------------------
|
| Here is where you can register all of the routes for an application.
| It's a breeze. Simply tell Laravel the URIs it should respond to
| and give it the controller to call when that URI is requested.
|
*/
use Illuminate\Http\Request;
Route::get('/pessoas', ['middleware' => 'cors', function (Request $request) {
    //Filtro
    $limit = $request->get('limit', 15);
    //Order
    $order = $request->get('order', 'nome');
    $by = $request->get('by', $order[0] == '-' ? 'DESC' : 'ASC');
    return \App\Pessoa::orderBy(str_replace('-', '', $order), $by)->paginate($limit);
}]);