PHP City::orderBy方法代码示例

 public function add()
 {
     $data = [];
     $url['back_url'] = 'city';
     $data['city'] = City::orderBy('created_at', 'DESC')->paginate(10);
     return View('city/add', $data)->nest('panel', 'sections.panel', $url);
 }

 public function getSearch()
 {
     // get all the cities from cities table in alphabetical order
     $city = City::orderBy('name')->get();
     //make the insert view with cities
     return View::make('search')->with('cities', $city);
 }

 /**
  * Display a listing of the resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function index()
 {
     $cities = City::orderBy('name')->get();
     $selector = array();
     foreach ($cities as $city) {
         $selector[$city->id] = $city->name;
     }
     return view('admin.investiments', ['cities' => $selector]);
 }

 /**
  * Display a listing of the resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function index()
 {
     $cities = City::orderBy('name')->get();
     foreach ($cities as $city) {
         $day = substr($city->founded, 8);
         $month = substr($city->founded, 5, -3);
         $year = substr($city->founded, 0, -6);
         $city->founded = $day . "/" . $month . "/" . $year;
     }
     return view('admin.cities', ['cities' => $cities]);
 }

 public function getInsert()
 {
     //Use to insert data to the cities table for time being
     /*$city = new City;
     
     		 $city->name = 'Colombo';
     
     		 $city->save();*/
     // get all the cities from cities table in alphabetical order
     $city = City::orderBy('name')->get();
     //make the insert view with cities
     return View::make('insert')->with('cities', $city);
 }

 /**
  * Run the database seeds.
  *
  * @return void
  */
 public function run()
 {
     $toronto_districts = array("Alexandra Park", "The Annex", "Baldwin Village", "Cabbagetown", "CityPlace", "Chinatown", "Church and Wellesley", "Corktown", "Discovery District", "Distillery District");
     $paris_districts = array("Louvre", "Bourse", "Temple", "Hôtel-de-Ville", "Panthéon", "Luxembourg", "Palais-Bourbon", "Élysée", "Opéra");
     $nyc_districts = array("Downtown Manhattan", "Little Germany (historic)", "Alphabet City and Loisaida", "East Village", "Greenwich Village", "NoHo", "Bowery", "West Village", "Lower East Side");
     $cities = City::orderBy('id', 'asc')->get();
     foreach ($cities as $city) {
         if (strcmp("New York City", $city->name) == 0) {
             foreach ($nyc_districts as $district) {
                 DB::table('districts')->insert(['name' => $district, 'description' => '', 'city_id' => $city->id]);
             }
         } elseif (strcmp("Toronto", $city->name) == 0) {
             foreach ($toronto_districts as $district) {
                 DB::table('districts')->insert(['name' => $district, 'description' => '', 'city_id' => $city->id]);
             }
         } elseif (strcmp("Paris", $city->name) == 0) {
             foreach ($paris_districts as $district) {
                 DB::table('districts')->insert(['name' => $district, 'description' => '', 'city_id' => $city->id]);
             }
         }
     }
 }

     $data = $request->all();
     $validator = Validator::make($request->all(), ['property_id' => 'required|numeric|integer|min:0']);
     if ($validator->fails()) {
         return redirect(url('/admin'))->withInput()->withErrors($validator);
     }
     $user = Property::find($data['property_id'])->delete();
     return redirect(url('/admin'));
 });
 Route::delete('/property/photo/{picture}', function (Picture $picture) {
     \Cloudinary\Uploader::destroy($picture->cloudinary_public_id);
     $property_id = PropertyPictureBridge::where('picture_id', $picture->id)->get()[0]->property_id;
     $picture->delete();
     return redirect(url('/property/edit/photos/' . $property_id));
 });
 Route::get('/property/edit/{property_id}', function ($property_id) {
     $cities = City::orderBy('name', 'asc')->get();
     $property = Property::find($property_id);
     $property->district_name = District::find($property->district_id)->name;
     $property->city_name = City::find($property->city_id)->name;
     $amenities = PropertyFeatures::where('property_id', $property->id)->get()[0];
     return view('edit_property', ['property' => $property, 'cities' => $cities, 'amenities' => $amenities]);
 });
 Route::get('/property/edit/photos/{property_id}', function ($property_id) {
     $property = Property::find($property_id);
     $images = get_all_images_from_property_id_without_placeholder($property_id);
     return view('edit_images', ['property' => $property, 'images' => $images]);
 });
 Route::post('/property/edit', function (Request $request) {
     $data = $request->all();
     $validator = Validator::make($request->all(), ['title' => 'required|max:255', 'city' => 'required', 'district' => 'required', 'address' => 'required|max:255', 'type' => 'required|in:private_room,shared_room,entire_place', 'max_occupancy' => 'required|numeric|min:0|integer', 'price_per_night' => 'required|numeric|min:0|max:9999.99', 'description' => 'required', 'property_id' => 'required|numeric|integer|min:0']);
     if ($validator->fails()) {

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