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
