예제 #1
0
 public function delete_seek($id)
 {
     if (Auth::User()->role == 2) {
         $training = SeekTraining::find($id);
         if ($training == null) {
             return redirect('/');
         } else {
             $training->delete();
             return redirect('/');
         }
     } else {
         return redirect('/');
     }
 }
 public function search_statistic($field_id)
 {
     $trainings = SeekTraining::all();
     $training_array = array();
     foreach ($trainings as &$training) {
         foreach ($training->fields as $field) {
             if ($field->id == $field_id) {
                 $training->municipalities;
                 $training['region'] = Region::where('id', '=', $training->municipalities[0]->region_id)->get();
                 $training_array[] = $training;
             }
         }
     }
     $country_array = array('quantity' => 0);
     $regions_array = array();
     $regions_id_array = array();
     foreach ($training_array as $training) {
         $country_array['quantity'] += $training['quantity'];
         if (!in_array($training['region'][0]['id'], $regions_id_array)) {
             $regions_id_array[] = $training['region'][0]['id'];
             $regions_array[$training['region'][0]['id']] = array('name' => $training['region'][0]['name'], 'quantity' => $training['quantity']);
         } else {
             $regions_array[$training['region'][0]['id']]['quantity'] += $training['quantity'];
         }
     }
     $municipalities_array = array();
     $municipalities_id_array = array();
     foreach ($training_array as $training) {
         if (!in_array($training['municipalities'][0]['id'], $municipalities_id_array)) {
             $municipalities_id_array[] = $training['municipalities'][0]['id'];
             $municipalities_array[$training['municipalities'][0]['id']] = array('name' => $training['municipalities'][0]['name'], 'quantity' => $training['quantity']);
         } else {
             $municipalities_array[$training['municipalities'][0]['id']]['quantity'] += $training['quantity'];
         }
     }
     return json_encode(['regions' => $regions_array, 'municipalities' => $municipalities_array, 'country' => $country_array]);
 }
예제 #3
0
 public function save_seek_announcement(Request $request)
 {
     if (!Auth::user() || Auth::user()->role != 2) {
         return redirect('/');
     }
     $rules = array('term' => 'required', 'field' => 'required', 'region' => 'required');
     $messages = array('term.required' => 'სწავლების ფორმა სავალდებულოა', 'field.required' => 'სწავლების სფერო სავალდებულოა', 'region.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 = SeekTraining::find(input::get('id'));
     $training_to_delete->delete();
     $training = SeekTraining::create($input);
     foreach (input::get('term') as $term) {
         $training->terms()->attach($term);
     }
     $training->fields()->attach(input::get('field'));
     $training->municipalities()->attach(input::get('municipalities'));
     $training->save();
     return redirect('/');
 }
예제 #4
0
 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');
 }