public function edit_announcement($id) { $fields = Field::orderBy('name')->lists('name', 'id'); $terms = Term::lists('name', 'id'); $municipalities = Municipality::lists('name', 'id'); $regions = Region::lists('name', 'id'); $type = array(0 => 'ვატარებ', 1 => 'ვეძებ'); $quarter = Quarter::all()->lists('name', 'id'); $months = Month::all()->lists('name', 'id'); $select = DB::select(' SELECT trainings.id, field_training.field_id, term_training.term_id, municipality_training.municipality_id, month_training.month_id FROM trainings JOIN field_training ON trainings.id = field_training.training_id JOIN term_training ON trainings.id = term_training.training_id JOIN municipality_training ON trainings.id = municipality_training.training_id JOIN month_training ON trainings.id = month_training.training_id where trainings.id = ' . $id . ' group by trainings.id '); $select = $select[0]; $training_filtered = new \stdClass(); $training_instance = Training::find($select->id); $training_field = Field::find($select->field_id); $training_municipality = Municipality::find($select->municipality_id); $training_months = DB::select('SELECT months.name FROM month_training JOIN months ON months.id = month_training.month_id WHERE training_id = ' . $training_instance->id); $training_terms = DB::select('SELECT terms.name FROM term_training JOIN terms ON terms.id = term_training.term_id WHERE training_id = ' . $training_instance->id); foreach ($training_months as $month) { $training_months_array[] = $month->name; } foreach ($training_terms as $term) { $training_terms_array[] = $term->name; } $training_filtered->id = $training_instance->id; $training_filtered->header = $training_instance->name; $training_filtered->description = $training_instance->description; $training_filtered->file = $training_instance->file; $training_filtered->link = $training_instance->link; $training_filtered->field['name'] = $training_field->name; $training_filtered->field['id'] = $training_field->id; $training_filtered->months = $training_months_array; $training_filtered->terms = $training_terms_array; $training_filtered->municipality['name'] = $training_municipality->name; $training_filtered->municipality['id'] = $training_municipality->id; $training_filtered->region = $training_municipality->region_id; $training_filtered->isAdmin = Auth::check(); return view('edit.edit_announcement', ['fields' => $fields, 'terms' => $terms, 'regions' => $regions, 'municipalities' => $municipalities, 'quarter' => $quarter, 'month' => $months, 'type' => $type, 'training' => $training_filtered]); }
Route::post('updateMunicipality', ['middleware' => 'auth', 'uses' => 'MunicipalitiesController@update']); Route::post('addMunicipality', ['middleware' => 'auth', 'uses' => 'MunicipalitiesController@store']); /* |-------------------------------------------------------------------------- | END MUNICIPALITIES ROUTING |-------------------------------------------------------------------------- | */ /* |-------------------------------------------------------------------------- | WARDS ROUTING |-------------------------------------------------------------------------- | */ Route::get('list-wards/{municipality}', ['middleware' => 'auth', function ($municipality) { $municipalityObj = Municipality::find($municipality); $districtObj = District::find($municipalityObj->district); $provinceObj = Province::find($districtObj->province); return view('wards.list', compact('districtObj', 'municipalityObj', 'provinceObj')); }]); Route::get('wards-list/{id}', ['middleware' => 'auth', 'uses' => 'WardsController@index']); Route::get('wards/{id}', ['middleware' => 'auth', 'uses' => 'WardsController@edit']); Route::post('updateWard', ['middleware' => 'auth', 'uses' => 'WardsController@update']); Route::post('addWard', ['middleware' => 'auth', 'uses' => 'WardsController@store']); /* |-------------------------------------------------------------------------- | END WARDS ROUTING |-------------------------------------------------------------------------- | */ /*
$ReporterMobile = $userObj->cellphone; } else { $userObj = user::find($case->reporter); $ReporterName = $userObj->name . ' ' . $userObj->surname; $RepPos = Position::find($userObj->position); $ReporterPosition = $RepPos->name; $ReporterMobile = $userObj->email; } $user = User::find($case->user); $position = Position::find($user->position); $ID = $case->id; $GPS = $case->gps_lat . ',' . $case->gps_lng; $Province = 'KZN'; $Port = Municipality::find($case->precinct); $Port = $Port->name; $precinctObj = Municipality::find($case->precinct); $Precinct = $precinctObj->name; $Submitted = $case->created_at; $Status = $case->status; $catObjCat = Category::find($case->category); $Category = $catObjCat->name; \Log::info($Category); $PhotoURL = "http://41.216.130.6:8080/siyaleader-dbnports-mobileApp-api/port_backend/public/" . $case->img_url; $LastActivity = $case->updated_at; $Reporter = $ReporterName; $Position = $ReporterPosition; $Mobile = $ReporterMobile; $Priority = $case->priority; $Description = $case->description; if ($case->id) { $noteResult = CaseNote::where('caseId', '=', $case->id)->first();
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'); }
/** * Display the specified resource. * * @param int $id * @return Response */ public function show($id) { $village = Village::find(intval($id)); $municipality = Municipality::find(intval($village['municipality_id'])); return view('poi.village.show')->with('village', $village)->with('municipality', $municipality); }
public function geo($id) { $municipality = Municipality::find(intval($id)); $parser = new Parser(); return response()->json($parser->json($municipality['geo'])); }