/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Request $request) { if (!Auth::check()) { return redirect('/auth/login'); } $field = new Field(); $field->element_id = $request->element_id; $field->type = $request->type; $field->name = $request->name; $field->validation = $request->validation; $field->settings = $request->settings; $f = Field::orderBy('sort', 'DESC')->first(); if ($f != null) { $field->sort = $f->sort + 1; } else { $field->sort = 1; } $field->save(); return $request->element_id; }
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]); }
public function index() { $fields = Field::orderBy('name')->lists('name', 'id'); return view('statistics.statistic')->with('fields', $fields)->with('statistic_active', 'active'); }
public function add_seek_announcement() { if (!Auth::user() || Auth::user()->role != 2) { return redirect('/'); } $fields = Field::orderBy('name')->lists('name', 'id'); $terms = Term::lists('name', 'id'); $municipalities = Municipality::all(); $municipality_regions = array(); foreach ($municipalities as $m) { $municipality_regions[] = array('municipality' => $m, 'region' => $m->region); } $regions = Region::lists('name', 'id'); $type = array(0 => 'ვატარებ', 1 => 'ვეძებ'); return view('add_forms.add_seek_announcement', ['fields' => $fields, 'terms' => $terms, 'regions' => $regions, 'municipality_regions' => $municipality_regions, 'type' => $type]); }
public function render_seek_form_data() { $fields = Field::orderBy('name')->lists('name', 'id'); $terms = Term::lists('name', 'id'); $municipalities = Municipality::all(); $municipality_regions = array(); foreach ($municipalities as $m) { $municipality_regions[] = array('municipality' => $m, 'region' => $m->region); } $regions = Region::lists('name', 'id'); return view('search_forms.seek', ['fields' => $fields, 'terms' => $terms, 'regions' => $regions, 'municipality_regions' => $municipality_regions]); }
public function getUserFormEdit($id) { if (!Auth::user()) { return redirect('/'); } $decleration = Decleration::findOrNew($id); $fields = Field::orderBy('name')->lists('name', 'id'); $terms = Term::orderBy('name')->lists('name', 'id'); $listener_numbers = Listenernumber::all(); $learn_methods = Learnmethod::all(); $estimations = Estimation::all(); $ratingsystems = Ratingsystem::all(); $certificaterules = Certificaterule::all(); $learnmaterials = Learnmaterial::all(); $dec_learnmethods = []; foreach ($decleration->learnmethods as $method) { $dec_learnmethods[] = $method->id; } $dec_estimations = []; foreach ($decleration->estimations as $estimation) { $dec_estimations[$estimation->id] = ['min' => $estimation->pivot->min, 'max' => $estimation->pivot->max]; } $dec_certificaterules = []; foreach ($decleration->certificaterules as $certificaterule) { $dec_certificaterules[$certificaterule->id] = $certificaterule->pivot->percentage; } $dec_materials = []; foreach ($decleration->learnmaterials as $material) { $dec_materials[] = $material->id; } $editables = $decleration->editables->lists('field_name')->toArray(); return view('user.edit_user_form', ['decleration' => $decleration, 'fields' => $fields, 'terms' => $terms, 'listener_numbers' => $listener_numbers, 'learn_methods' => $learn_methods, 'dec_learnmethods' => $dec_learnmethods, 'estimations' => $estimations, 'dec_estimations' => $dec_estimations, 'ratingsystems' => $ratingsystems, 'certificaterules' => $certificaterules, 'dec_certificaterules' => $dec_certificaterules, 'learnmaterials' => $learnmaterials, 'dec_materials' => $dec_materials, 'editables' => $editables]); }