PHP app\models Type::orderBy Exemples

Exemple #1

Fichier : TypeController.php Projet : Jokeramc/amc

 /**
  * type list
  * @return view
  */
 public function index()
 {
     //DB::enableQueryLog();
     $list = Type::orderBy('id', 'desc')->leftJoin('attributes', 'types.id', '=', 'attributes.type_id')->select('types.*', DB::raw('count(it_attributes.id) as total'))->groupBy('types.id')->paginate(config('shop.pagesize'));
     //分页显示
     //$query = DB::getQueryLog();
     //$lastQuery = end($query);
     //p($lastQuery);die;
     return view('admin.type.index', compact('list'));
 }

Exemple #2

Fichier : helpers.php Projet : berkapavel/Laravel5-Time-Tracker-Project-manager

function retrieveAllTypes()
{
    return $queries = \App\models\Type::orderBy('id', 'asc')->get();
}