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']));
}
