PHP Region::all方法代码示例

 public function create()
 {
     $paises = Pais::all();
     $estados = Region::all();
     $categorias = CategoriasNegocio::lists('nombre', 'id');
     return View::make('negocios.create')->with('paises', $paises)->with('estados', $estados)->with('categorias', $categorias);
 }

 public function getMyprofile()
 {
     $id = Auth::user()->id;
     $alumni_id = null;
     $sql = "SELECT * FROM alumni WHERE account_id = ?";
     $prof = DB::select($sql, array($id));
     if ($prof != null) {
         $alumni_id = $prof[0]->id;
     }
     $sql2 = "SELECT * FROM degree WHERE alumni_id = ?";
     $deg = DB::select($sql2, array($alumni_id));
     $sql3 = "SELECT * FROM work_experience WHERE alumni_id = ?";
     $wrk_exp = DB::select($sql3, array($alumni_id));
     $sql4 = "SELECT * FROM certificate WHERE alumni_id = ?";
     $certificate = DB::select($sql4, array($alumni_id));
     // $sql5 = "SELECT * FROM alumni_tracer WHERE alumni_id = ?";
     $sql5 = "SELECT at.*, sq.question, sc.choice\n\t\t\t\tFROM alumni_tracer AS at\n\t\t\t\tINNER JOIN survey_questions AS sq\n\t\t\t\tON sq.id = at.question_id\n\t\t\t\tINNER JOIN survey_choices AS sc\n\t\t\t\tON sc.id = at.choice_id\n\t\t\t\tWHERE at.alumni_id = ?\n\t\t\t\tORDER BY at.question_id";
     $a_tracer = DB::select($sql5, array($alumni_id));
     $dept = Department::all();
     $region = Region::all();
     $province = Province::all();
     $occupation = Occupation::all();
     $company = Company::all();
     $deg_title = DegreeTitle::all();
     $school = School::all();
     $jobs = Job::all();
     $field = Field::all();
     $questions = DB::select("SELECT * FROM survey_questions");
     $civil_status = DB::select("SELECT * FROM civil_status");
     return View::make('user.profile')->with('company', $company)->with('field', $field)->with('occupation', $occupation)->with('work_exp', $wrk_exp)->with('degree', $deg)->with('a_tracer', $a_tracer)->with('certificate', $certificate)->with('school', $school)->with('deg_title', $deg_title)->with('profile', $prof)->with('dept', $dept)->with('region', $region)->with('province', $province)->with('civil_status', $civil_status)->with('questions', $questions)->with('jobs', $jobs);
 }

 /**
  * Show the form for creating a new resource.
  *
  * @return Response
  */
 public function create()
 {
     //
     $newId = Warehouse::generateId();
     $areas = Area::all();
     $regions = Region::all();
     return View::make('warehouse.new', ['id' => $newId, 'areas' => $areas, 'regions' => $regions]);
 }

 /**
  * Show the form for creating a new resource.
  *
  * @return Response
  */
 public function create()
 {
     //
     $newId = Supplier::generateId();
     $areas = Area::all();
     $regions = Region::all();
     return View::make('supplier.new', ['id' => $newId, 'areas' => $areas, 'regions' => $regions]);
 }

 public function getRegion()
 {
     $regions = Region::all();
     $ret = array();
     $ret["incomplete_results"] = false;
     $items = array();
     foreach ($regions as $region) {
         if (strpos(strtolower($region->regionName), strtolower($_GET['q'])) !== false) {
             $row = array();
             $row["id"] = $region->regionID;
             $row["label"] = $region->regionName;
             array_push($items, $row);
         }
     }
     $ret["items"] = $items;
     $ret["total_count"] = count($items);
     echo json_encode($ret);
 }

 /**
  * Show the form for creating a new resource.
  *
  * @return Response
  */
 public function create()
 {
     $regions = Region::all();
     return View::make('numerical_models.create', ['regions' => $regions]);
 }

 private function regions()
 {
     $class = get_class(new Region());
     $this->log($this->verb . ' Regions');
     $url = $this->baseUrl . "region?c:limit=1000";
     $data = $this->getCensusData($url);
     if (!$data) {
         return false;
     }
     // Collection of Eloquent objects from API
     $apiCollection = new Collection();
     foreach ($data->region_list as $region) {
         $values = [];
         $values['id'] = isset($region->region_id) ? $region->region_id : null;
         $values['name'] = isset($region->name->en) ? $region->name->en : null;
         $values['continent_id'] = isset($region->zone_id) ? $region->zone_id : null;
         $apiCollection->add(new Region($values));
     }
     $regions = Region::all();
     $this->addModels($class, $regions, $apiCollection);
     $this->deleteModels($class, $regions, $apiCollection);
     $this->updateModels($class, Region::all(), $apiCollection, ['name', 'continent_id']);
 }

 public function getTracer()
 {
     $regions = Region::all();
     $departments = Department::all();
     return View::make('home.tracer_form')->with('regions', $regions)->with('departments', $departments);
 }