PHP Country::orderBy方法代码示例

 /**
  * Display a listing of the resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function index()
 {
     $countries = Cache::remember('countries', 15, function () {
         return Country::orderBy('name')->get();
     });
     return response()->json(['data' => $countries], 200);
 }

 public function edit($id)
 {
     $countries = Country::orderBy('name', 'asc')->lists('name', 'id')->all();
     $categories = Category::lists('category', 'category')->all();
     $competition = Competition::whereId($id)->firstOrFail();
     return view('backend.competitions.edit', compact('competition', 'countries', 'categories'));
 }

 public function edit($id)
 {
     $countries = Country::orderBy('name', 'asc')->lists('name', 'id')->all();
     $clubs = Club::orderBy('name', 'asc')->get()->lists('name_town', 'id')->all();
     $competitor = Competitor::whereId($id)->firstOrFail();
     return view('backend.competitors.edit', compact('competitor', 'countries', 'clubs'));
 }

 public function create(ApplicationRequest $request)
 {
     $services = Service::join('service_visas', 'services.id', '=', 'service_visas.service_id')->select('services.id', 'services.name', 'min_process', 'max_process')->orderBy('min_process')->orderBy('max_process')->where('country_id', '=', $request->get('country'))->groupBy('services.id')->get();
     $service = $services->first();
     $states = DB::table('states')->orderBy('name', 'asc')->lists('name', 'id');
     $countries = Country::orderBy('name')->lists('name', 'id');
     $country = Country::find($request->get('country'));
     return View('apply', ['services' => $services->lists('title', 'id'), 'service' => $service, 'country' => $country, 'countries' => $countries, 'states' => $states]);
 }

 public function populateDropdowns()
 {
     $populatecountry = Country::orderBy('created_at', 'asc')->paginate(100);
     $populatemunicipality = Municipality::orderBy('created_at', 'asc')->paginate(100);
     $populateregion = Region::orderBy('created_at', 'asc')->paginate(100);
     $populateschool_level = School_level::orderBy('created_at', 'asc')->paginate(100);
     $populateschool_type = School_type::orderBy('created_at', 'asc')->paginate(100);
     $populateacademic_year = Academic_year::orderBy('created_at', 'asc')->paginate(100);
     $populatetemplate = Template::orderBy('created_at', 'asc')->paginate(100);
     $site_code = Settings::first()->site_code;
     $site_title = Settings::first()->site_title;
     $owner = Settings::first()->owner;
     $street = Settings::first()->street;
     $barangay = Settings::first()->barangay;
     $zip_code = Settings::first()->zip_code;
     $contact = Settings::first()->contact;
     $fax = Settings::first()->fax;
     $tin = Settings::first()->tin;
     //$posts=Post::orderBy('created_at','desc')->paginate(15);
     //return view('general-settings',['populatecountry' => $populatecountry]);
     return view('general-settings')->with('populatecountry', $populatecountry)->with('populatemunicipality', $populatemunicipality)->with('populateregion', $populateregion)->with('populateschool_level', $populateschool_level)->with('populateschool_type', $populateschool_type)->with('populateacademic_year', $populateacademic_year)->with('populatetemplate', $populatetemplate)->with('site_code', $site_code)->with('site_title', $site_title)->with('owner', $owner)->with('street', $street)->with('barangay', $barangay)->with('zip_code', $zip_code)->with('contact', $contact)->with('fax', $fax)->with('tin', $tin);
 }

 public function getBackground(Request $request)
 {
     $num = $request->has("rows") ? Input::get("rows") : 25;
     $sort = $request->has("sort") ? Input::get("sort") : 'id';
     $order = $request->has("order") ? Input::get("order") : 'asc';
     $filterRules = $request->has("filterRules") ? Input::get("filterRules") : null;
     $filterRules = json_decode($filterRules, 1);
     $pages = Country::orderBy($sort, $order);
     if (!is_null($filterRules)) {
         foreach ($filterRules as $item) {
             if ($item['op'] == 'contains') {
                 $pages = $pages->where($item['field'], 'like', '%' . $item['value'] . '%', "and");
             }
         }
     }
     $pages = $pages->paginate($num);
     //var_dump($pages->toArray());
     $data = $pages->toArray();
     $result = array();
     $result["total"] = $data['total'];
     $result["rows"] = $data['data'];
     return json_encode($result);
 }

 /**
  * Returns a collection with all countries.
  *
  * @return Collection
  */
 public function all()
 {
     return Country::orderBy('name')->get();
 }

 public function getCountry()
 {
     $country = Country::orderBy('created_at', 'desc')->paginate(10);
     //$posts=Post::orderBy('created_at','desc')->paginate(15);
     return view('country', ['country' => $country]);
 }

 public function settings()
 {
     $platforms = \App\Platform::all();
     $countries = \App\Country::orderBy('name', 'asc')->get();
     return view('user/settings', compact('platforms', 'countries'));
 }

 public function getAllCountries()
 {
     return Country::orderBy('country_name')->get();
 }

 /**
  * Show the form for editing the specified resource.
  *
  * @param  int  $id
  * @return Response
  */
 public function edit()
 {
     //
     $gender = Gender::lists('gender', 'id');
     $age = Age::lists('age', 'id');
     $occupation = Occupation::lists('occupation', 'id');
     $country = Country::orderBy('country')->lists('country', 'id');
     //for alphabetic order
     $education = Education::lists('education', 'id');
     //return Auth::User()->profile;
     return view('user.edit', compact('gender', 'age', 'occupation', 'country', 'education'));
 }

 /**
  * Display the specified resource.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function show(Request $request, $id)
 {
     $visa = Visa::findOrFail($id);
     $countries = Country::orderBy('name')->get();
     return view("admin.visa_show", ["visa" => $visa, "countries" => $countries]);
 }

 public function countries()
 {
     $countries = Country::orderBy('country_code', 'asc')->get();
     return view('scrapers.countries')->with(['countries' => $countries]);
 }