public function institutions() { $user = Auth::user(); $institutions = Institution::where('region_id', $user->region_id)->orderBy('name')->get(); $region = Region::find($user->region_id); return view('rtaadmin.institutions', compact('institutions', 'region')); }
/** * Display the specified resource. * * @param int $id * @return Response */ public function show($id) { $county = County::find(intval($id)); $region = Region::find(intval($county['region_id'])); $items = Municipality::where('county_id', intval($id))->get(); return view('poi.county.show')->with('county', $county)->with('region', $region)->with('items', $items); }
public function getDistricts($id) { $region = Region::find($id); echo "<option value=''>-----select----</option>"; foreach ($region->districts as $district) { echo "<option value='" . $district->id . "'>" . $district->district_name . "</option>"; } }
/** * Run the database seeds. * * @return void */ public function run() { foreach (range(1, 40) as $i) { $date = Carbon::create(2015, 5, 1, 0, 0, 0); $courier = Courier::find(rand(1, 10)); $region = Region::find(rand(1, 10)); $start_date = $date->addDays(rand(1, 210)); $end_date = Carbon::create($start_date->year, $start_date->month, $start_date->day + $region->long, 0, 0, 0); $trips = Trip::with('courier')->where('courier_id', $courier->id)->get(); $filtered = $trips->filter(function ($trip) use($start_date, $end_date) { $trip_start = Carbon::createFromFormat('Y-m-d', $trip->start)->startOfDay(); $trip_end = Carbon::createFromFormat('Y-m-d', $trip->end)->startOfDay(); $trip_in_range = $trip_start->between($start_date, $end_date) || $trip_end->between($start_date, $end_date); $trip_over_range = $start_date->lte($trip_start) && $end_date->gte($trip_end); return $trip_in_range || $trip_over_range; }); if ($filtered->isEmpty()) { Trip::create(array('courier_id' => $courier->id, 'region_id' => $region->id, 'start' => $start_date->format('Y-m-d'), 'end' => $end_date->format('Y-m-d'))); } } }
public function postCreate(Request $request) { $this->validate($request, ['start' => 'required']); $courier = Courier::find($request->get('courier_id')); $region = Region::find($request->get('region_id')); $start_date = Carbon::createFromFormat('d.m.Y', $request->get('start')); $end_date = Carbon::create($start_date->year, $start_date->month, $start_date->day + $region->long, 0, 0, 0); $trips = Trip::with('courier')->where('courier_id', $courier->id)->get(); $filtered = $trips->filter(function ($trip) use($start_date, $end_date) { $trip_start = Carbon::createFromFormat('Y-m-d', $trip->start)->startOfDay(); $trip_end = Carbon::createFromFormat('Y-m-d', $trip->end)->startOfDay(); $trip_in_range = $trip_start->between($start_date, $end_date) || $trip_end->between($start_date, $end_date); $trip_over_range = $start_date->lte($trip_start) && $end_date->gte($trip_end); return $trip_in_range || $trip_over_range; }); if ($filtered->isEmpty()) { Trip::create(array('courier_id' => $courier->id, 'region_id' => $region->id, 'start' => $start_date->format('Y-m-d'), 'end' => $end_date->format('Y-m-d'))); return $request->ajax() ? 'Поездка успешно добавлена' : redirect()->to('/'); } else { return $request->ajax() ? 'В указанный период уже есть поездки' : redirect()->back()->withInput(); } }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($id) { Region::find($id)->delete(); return redirect('regions'); }
public function get_municipalities_by_id($id) { $region = Region::find($id); $municipalities = $region->get_municipalities; return $municipalities; }
</div> </div> </fieldset> @if($question->question_type =="Location Based") <div id="locationBased"> <fieldset class="scheduler-border"> <legend class="scheduler-border" style="color:#005DAD">Location details</legend> <div class="form-group"> <div class="row"> <div class="col-lg-4"> <label for="first_name">Region</label> <select class="form-control" name="region" id="region" onchange="getDistricts(this)"> @if($question->region_id !="") <?php $reg = \App\Region::find($question->region_id); ?> <option value="{{$reg->id}}" selected>{{$reg->region_name}}</option> @else <option value="">----select----</option> @endif @foreach(\App\Region::orderBy('region_name','ASC')->get() as $region) <option value="{{$region->id}}">{{$region->region_name}}</option> @endforeach </select> </div> <div class="col-lg-4"> <label for="district">District</label> <select class="form-control" name="district" id="district"> @if($question->district_id !="") <?php
public function geo($id) { $region = Region::find(intval($id)); $parser = new Parser(); return response()->json($parser->json($region['geo'])); }
public function get_seek_announcements(Request $request) { $field_search = input::get('field'); $term_search = input::get('term'); $region_search = input::get('region'); $municipalities_search = input::get('municipalities'); if ($field_search == '0' || empty($field_search)) { $fields_all = Field::all(['id']); foreach ($fields_all as $field) { $fields[] = $field->id; } } else { $fields[] = $field_search; } if ($term_search == '0' || empty($term_search)) { $terms_all = Term::all(['id']); foreach ($terms_all as $term) { $terms[] = $term->id; } } else { $terms[] = $term_search; } if ($municipalities_search[0] == '0' || empty($municipalities_search)) { if ($region_search != '0' && !empty($region_search)) { $any_municipality = Region::find($region_search)->get_municipalities()->get(); } else { $any_municipality = Municipality::all(['id']); } foreach ($any_municipality as $instance) { $municipality_id[] = $instance->id; } } else { $municipality_id = $municipalities_search; } $select = DB::select(' SELECT seek_trainings.id, field_seek_training.field_id, municipality_seek_training.municipality_id FROM seek_trainings JOIN field_seek_training ON seek_trainings.id = field_seek_training.seek_training_id JOIN municipality_seek_training ON seek_trainings.id = municipality_seek_training.seek_training_id WHERE field_seek_training.field_id in(' . implode(',', $fields) . ') AND municipality_seek_training.municipality_id in (' . implode(',', $municipality_id) . ') group by seek_trainings.id '); foreach ($select as $instance) { $seek_training_filtered = new \stdClass(); $seek_training_instance = SeekTraining::find($instance->id); $seek_training_field = Field::find($instance->field_id); $seek_training_municipality = Municipality::find($instance->municipality_id); $training_terms = DB::select('SELECT terms.name FROM seek_training_term JOIN terms ON terms.id = seek_training_term.term_id WHERE seek_training_id = ' . $instance->id); $seek_training_terms_array = []; foreach ($training_terms as $term) { $seek_training_terms_array[] = $term->name; } $seek_training_filtered->id = $seek_training_instance->id; $seek_training_filtered->header = $seek_training_instance->name; $seek_training_filtered->description = $seek_training_instance->description; $seek_training_filtered->file = $seek_training_instance->file; $seek_training_filtered->link = $seek_training_instance->link; $seek_training_filtered->per = $seek_training_instance->per; $seek_training_filtered->terms = implode(',', $seek_training_terms_array); $seek_training_filtered->contact = $seek_training_instance->contact; $seek_training_filtered->quantity = $seek_training_instance->quantity; $seek_training_filtered->field = $seek_training_field->name; $seek_training_filtered->municipality = $seek_training_municipality->name; $seek_training_filtered->isAdmin = !(!Auth::user() || Auth::user()->role == 100); $seek_training_filtered_array[] = $seek_training_filtered; unset($seek_training_filtered); unset($seek_training_months_array); unset($seek_training_terms_array); } return response(json_encode($seek_training_filtered_array), 200)->header('Content-Type', 'application/json'); }
</div> <div class="col-lg-6"> <label for="phone">Phone</label> <input type="text" class="form-control" name="phone" value="{{$contestant->phone}}"> </div> </div> </div> <div class="form-group"> <div class="row"> <div class="col-lg-4"> <label for="first_name">Region</label> <select class="form-control" name="region" id="region"> @if($contestant->region !="") <?php $reg = \App\Region::find($contestant->region_id); ?> <option value="{{$reg->id}}" selected>{{$reg->region_name}}</option> @else <option value="">----select----</option> @endif @foreach(\App\Region::orderBy('region_name','ASC')->get() as $region) <option value="{{$region->id}}">{{$region->region_name}}</option> @endforeach </select> </div> <div class="col-lg-4"> <label for="district">District</label> <select class="form-control" name="district" id="district"> @if($contestant->district !="") <?php