PHP Course::orderBy方法代码示例

 public function all()
 {
     $breadcrumbs = array(action('HomeController@show') => 'Início', action('CourseController@all') => 'Todos os cursos');
     $previous = action('HomeController@show');
     $courses = Course::orderBy('name')->get();
     return view('all-courses', compact('breadcrumbs', 'previous', 'courses'));
 }

 /**
  * Display a listing of the resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function index()
 {
     $teacher = User::find(Auth::user()->id);
     $resourceTypes = Resource_type::all();
     $courses = $crs = Course::orderBy('affiliateId', 'DESC')->orderBy('streamId', 'DESC')->orderBy('levelId', 'DESC')->get();
     return view('teacher')->with('teacher', $teacher)->with('resourceTypes', $resourceTypes)->with('courses', $courses);
 }

 public function courses()
 {
     $courses = Course::orderBy('created_at', 'desc')->get();
     $return_data = [];
     foreach ($courses as $course) {
         $return_data[] = ["id" => $course->id, "linkId" => convert_vi_to_en($course->name), 'name' => "Khoá học " . $course->name, "icon_url" => $course->icon_url, "description" => $course->description, "avatar_url" => $course->image_url, "price" => currency_vnd_format($course->price)];
     }
     return $this->respond($return_data);
 }

 public function index(Request $request)
 {
     // 获取排序条件
     $orderColumn = $request->get('sort_up', $request->get('sort_down', 'created_at'));
     $direction = $request->get('sort_up') ? 'asc' : 'desc';
     $courses = Course::orderBy($orderColumn, $direction)->paginate(8);
     $stores = json_encode(DB::table('stores')->where('deleted_at', null)->select('id', 'name')->get());
     $coaches = json_encode(DB::table('coaches')->where('deleted_at', null)->select('id', 'name')->get());
     return view('admin.course.list', compact('courses', 'stores', 'classrooms', 'coaches', 'query'));
 }

 /**
  * Show the form for creating a new resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function create()
 {
     $student = Auth::user();
     $regs = Registration::where('student_id', '=', $student->id)->get();
     if (count($regs) > 0) {
         Flash::error('You have completed registration!.');
         return redirect()->route('registration.index');
     }
     $courses = Course::orderBy('name')->lists('name', 'id');
     return view('reg.create', compact('courses'));
 }

 /**
  * Display a listing of the resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function index()
 {
     $courses = Course::orderBy('name')->get();
     foreach ($courses as $course) {
         $user = User::where('id', '=', $course->lecturer_id)->firstOrFail();
         $course['lecturer_name'] = $user->name;
         $dept = Department::where('id', '=', $course->department_id)->firstOrFail();
         $course['department_name'] = $dept->name;
     }
     return view('course.index', compact('courses'));
 }

 public function index(Request $request)
 {
     $courses = [];
     try {
         $title = $request->all()['title'];
         $subject = $request->all()['subject'];
         $number = $request->all()['number'];
         $courses = Course::where('title', 'like', '%' . $title . '%')->where('subject_code', 'like', '%' . $subject . '%')->where('number', 'like', '%' . $number . '%')->orderBy('subject_code')->orderBy('number')->paginate(10);
     } catch (\ErrorException $e) {
         $courses = Course::orderBy('subject_code')->orderBy('number')->paginate(25);
     }
     return view('courses.index')->with('courses', $courses);
 }

 public function listAllCourses()
 {
     return Course::orderBy('name', 'asc')->lists('name', 'id');
 }

 public function index()
 {
     $courses = Course::orderBy('importance', 'desc')->get();
     return view('resume.courses', compact('courses'));
 }

 /**
  * Display the landing page of the application.
  *
  * @return \Illuminate\Http\Response
  */
 public function index()
 {
     $newCourses = Course::orderBy('created_at', 'desc')->take(2)->get();
     $poularCourses = DB::table('courses')->leftjoin('user_course', 'courses.id', '=', 'user_course.course_id')->join('users', 'user_course.user_id', '=', 'users.id')->groupBy('courses.id')->take(2)->get();
     return view('public.home')->with('newCourses', $newCourses)->with('popularCourses', $poularCourses);
 }

 public function courses()
 {
     $courses = Course::orderBy('created_at', 'desc')->get();
     return response()->json(['courses' => $courses]);
 }

 /**
  * Show the form for editing the specified resource.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function edit()
 {
     $organization = Organization::where('userId', Auth::user()->id)->first();
     $crs = Course::orderBy('affiliateId', 'DESC')->orderBy('streamId', 'DESC')->orderBy('levelId', 'DESC')->get();
     return view('organization.edit')->with('organization', $organization)->with('courses', $crs);
 }

 /**
  * Display a listing of the resource.
  *
  * @return Response
  */
 public function adminIndex()
 {
     $courses = Course::orderBy('day')->with(['manager', 'instrument', 'article', 'documents', 'users' => function ($query) {
         $query->where('level', 0)->where('validated', 1)->orderBy('last_name');
     }, 'teachers' => function ($query) {
         $query->where('level', 1)->where('validated', 1)->orderBy('last_name');
     }])->paginate(20);
     return view('admin.courses.index', compact('courses'));
 }

/*
|--------------------------------------------------------------------------
| Application Routes
|--------------------------------------------------------------------------
|
| This route group applies the "web" middleware group to every route
| it contains. The "web" middleware group is defined in your HTTP
| kernel and includes session state, CSRF protection, and more.
|
*/
Route::group(['middleware' => ['web']], function () {
    /**
     * List all courses
     */
    Route::get('/', function () {
        $courses = Course::orderBy('created_at', 'asc')->get();
        return view('courses', ['courses' => $courses]);
    });
    /**
     * Add a course
     */
    Route::post('/course', function (Request $request) {
        $validator = Validator::make($request->all(), ['name' => 'required|max:255', 'date' => 'required']);
        if ($validator->fails()) {
            return redirect('/')->withInput()->withErrors($validator);
        }
        $course = new Course();
        $course->name = $request->name;
        $course->date = $request->date;
        $course->save();
        return redirect('/');