PHP app Country::whereNull示例

 /**
  * Show the application registration form.
  *
  * @return \Illuminate\Http\Response
  */
 public function getRegister()
 {
     $location = GeoIPFacade::getLocation();
     $countries = Country::whereNull('countries.deleted_at')->select(array('countries.id', 'countries.name', 'countries.country_code', 'countries.icon as icon'))->get('countries');
     return view('auth.register', compact('location', 'countries'));
 }

示例#2

显示文件

文件： CountryController.php 项目： alex311982/laravel5_online_support

 /**
  * Show a list of all the countries posts formatted for Datatables.
  *
  * @return Datatables JSON
  */
 public function data()
 {
     $country = Country::whereNull('countries.deleted_at')->select(array('countries.id', 'countries.name', 'countries.country_code', 'countries.icon as icon'));
     //        "<span class='flag flag-$country_code' alt='flag'></span>"
     return Datatables::of($country)->edit_column('icon', '{!! ($icon!="")? "<span class=\\"flag $icon\\" alt=\\"flag\\">&nbsp</span>":""; !!}')->add_column('actions', '<a href="{{{ URL::to(\'admin/country/\' . $id . \'/edit\' ) }}}" class="btn btn-success btn-sm iframe" ><span class="glyphicon glyphicon-pencil"></span> {{ trans("admin/modal.edit") }}</a>
                 <a href="{{{ URL::to(\'admin/country/\' . $id . \'/delete\' ) }}}" class="btn btn-sm btn-danger iframe"><span class="glyphicon glyphicon-trash"></span> {{ trans("admin/modal.delete") }}</a>
                 <input type="hidden" name="row" value="{{$id}}" id="row">')->remove_column('id')->make();
 }