public function delete_announcement($id)
{
if (Auth::User()->role == 1) {
$training = Training::find($id);
if ($training == null) {
return redirect('/');
} else {
$training->delete();
return redirect('/');
}
} else {
return redirect('/');
}
}
public function addGroup(Request $request)
{
$data = array('id' => $request->input('id'), 'ziua' => $request->input('ziua'), 'ora' => $request->input('ora'));
$rules = array('id' => 'exists:trainings,id', 'ziua' => 'required', 'ora' => 'required');
$validator = Validator::make($data, $rules);
if (!$validator->fails()) {
$training = Training::find($data['id']);
$group = new Group();
$group->training_id = $data['id'];
$group->trainer_id = $training->trainer_id;
$group->area_id = $training->area_id;
$group->subarea_id = $training->subarea_id;
$group->data = $data['ziua'];
$group->ora = $data['ora'];
$group->save();
return redirect('/trainer');
}
}
public function save_announcement(Request $request)
{
if (!Auth::user() || Auth::user()->role != 1) {
return redirect('/');
}
$rules = array('term' => 'required', 'field' => 'required', 'region' => 'required', 'month' => 'required');
$messages = array('term.required' => 'სწავლების ფორმა სავალდებულოა', 'field.required' => 'სწავლების სფერო სავალდებულოა', 'region.required' => 'ჩატარების ადგილი სავალდებულოა', 'month.required' => 'ჩატარების პერიოდი სავალდებულოა');
$input = input::all();
$file = Input::file('file');
if (isset($file) && !empty($file)) {
$extension = $file->getClientOriginalExtension();
if ($extension != 'pdf') {
$rules['pdf'] = 'required';
$messages['pdf.required'] = 'დასაშვებია მხოლოდ pdf გაფართოების ფაილები';
}
}
$this->validate($request, $rules, $messages);
if (isset($file) && !empty($file)) {
$file_name = str_random(10) . '.' . $file->getClientOriginalExtension();
$destinationPath = 'training_pdf';
$file->move($destinationPath, $file_name);
$input['file'] = $file_name;
}
$training_to_delete = Training::find(input::get('id'));
$training_to_delete->delete();
$training = Training::create($input);
foreach (input::get('term') as $term) {
$training->terms()->attach($term);
}
$training->fields()->attach(input::get('field'));
$training->municipalities()->attach(input::get('municipalities'));
if (!is_null(input::get('month'))) {
foreach (input::get('month') as $month) {
$training->months()->attach($month);
}
}
$training->save();
return redirect('/');
}
public function deltr($id)
{
if (Auth::guest()) {
\Session::flash('msg', ' No Permission for that Request');
return redirect('job');
}
$trg = Training::findOrFail($id);
if (Auth::id() != $trg['Employer_id']) {
\Session::flash('msg', ' No Permission for that Request');
return redirect('job');
}
if (Training::find($id)->delete()) {
\Session::flash('msg', 'You Have Successfully Deleted Training : ' . $trg->title);
return redirect('job/training');
}
}
public function get_announcements(Request $request)
{
$rules = array('month' => 'required');
$messages = array('month.required' => 'პერიოდი სავალდებულოა');
$this->validate($request, $rules, $messages);
$field_search = input::get('field');
$term_search = input::get('term');
$region_search = input::get('region');
$municipalities_search = input::get('municipalities');
$month_search = input::get('month');
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;
}
if ($month_search[0] != '0' || !empty($month_search[0])) {
$query_month = 'AND month_training.month_id in (' . implode(',', $month_search) . ')';
} else {
$query_month = '';
}
$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 field_training.field_id in(' . implode(',', $fields) . ')
AND term_training.term_id in ( ' . implode(',', $terms) . ')
AND municipality_training.municipality_id in (' . implode(',', $municipality_id) . ')
' . $query_month . '
group by trainings.id
');
foreach ($select as $instance) {
$training_filtered = new \stdClass();
$training_instance = Training::find($instance->id);
$training_field = Field::find($instance->field_id);
$training_municipality = Municipality::find($instance->municipality_id);
$training_months = DB::select('SELECT months.name FROM month_training JOIN months ON months.id = month_training.month_id WHERE training_id = ' . $instance->id);
$training_terms = DB::select('SELECT terms.name FROM term_training JOIN terms ON terms.id = term_training.term_id WHERE training_id = ' . $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 = $training_field->name;
$training_filtered->months = implode(',', $training_months_array);
$training_filtered->terms = implode(',', $training_terms_array);
$training_filtered->municipality = $training_municipality->name;
$training_filtered->isAdmin = !(!Auth::user() || Auth::user()->role == 100);
$training_filtered_array[] = $training_filtered;
unset($training_filtered);
unset($training_months_array);
unset($training_terms_array);
}
return response(json_encode($training_filtered_array), 200)->header('Content-Type', 'application/json');
}
public function trainerSelect($id)
{
//$id is id of training.
$this->info['training'] = Training::find($id);
if ($this->info['training']->trainer_id == Auth::user()->id) {
$this->info['namespace'] = "trainerIndex";
$this->info['title'] = "Selecteaza Participanti | " . $this->info['title'];
return view('trainerPages.select', ['info' => $this->info]);
} else {
return redirect('/trainer');
}
}
/**
* Update the specified resource in storage.
*
* @param Request $request
* @param int $id
* @return Response
*/
public function update(Request $request)
{
$training_id = $request->input('training_id');
$training = Training::find($training_id);
if ($training && ($training->user_id == $request->user()->id || $request->user()->is_admin())) {
$training->name = $request->input('name');
if ($request->has('save')) {
$message = 'Training saved successfully';
$landing = 'exercise/index';
}
$training->save();
return redirect($landing)->withMessage($message);
} else {
return redirect('/exercise/index')->withErrors('You have not sufficient permissions');
}
}
