/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Request $request) { $this->validate($request, ['position' => 'required', 'description' => 'required']); Position::create($request->all()); flash()->success('Successfully Added!'); return redirect('/admin/careers'); }
/** * Remove position * * @param int $id * @return string */ public function destroy() { $position = Position::find(Request::input('id')); $position->delete(); $item = array("id" => $position->id, "name" => $position->name, "description" => $position->description); echo json_encode($item); }
public function edit($id) { $user = User::find($id); // список должностей для передачи в select формы $positions = Position::all(); return view('user.edit', ['user' => $user, 'positions' => $positions]); }
/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { $player = Player::find($id); $seasons = Season::all(); $positions = Position::all(); $countries = Country::all(); return view('admin.players.edit', compact('player', $player, 'seasons', $seasons, 'positions', $positions, 'countries', $countries)); }
/** * Update the specified resource in storage. * * @param Request $request * @param int $id * @return Response */ public function update(PositionsRequest $request) { $position = Position::where('id', $request['positionID'])->first(); $position->name = $request['name']; $position->save(); \Session::flash('success', $request['name'] . ' has been successfully updated!'); return redirect()->back(); }
/** * Run the database seeds. * * @return void */ public function run() { $positions = [['latitud' => '4.65599032', 'longitud' => '-74.09680434', 'icon' => 'canotaje.png', 'title' => 'Lago', 'description' => 'Es uno de los principales atractivos del parque; cuenta con 10 hectáreas y es protagonista de muestras acuáticas,competencias deportivas y con servicio de lanchas y remos. Su profundidad oscila entre los 1.00 y los 12.00 metros.Extensión del lago: 11 hectáreas.'], ['latitud' => '4.65835891', 'longitud' => '-74.09512997', 'icon' => 'canotaje.png', 'title' => 'Lago', 'description' => 'Es uno de los principales atractivos del parque; cuenta con 10 hectáreas y es protagonista de muestras acuáticas,competencias deportivas y con servicio de lanchas y remos. Su profundidad oscila entre los 1.00 y los 12.00 metros.Extensión del lago: 11 hectáreas.'], ['latitud' => '4.65599677', 'longitud' => '-74.096598', 'icon' => 'canotaje.png', 'title' => 'Isla', 'description' => 'Isla. Punto de biodiversidad ecológica dentro del parque.'], ['latitud' => '4.65694694', 'longitud' => '-74.09748263', 'icon' => 'canotaje.png', 'title' => 'Isla', 'description' => 'Isla. Punto de biodiversidad ecológica dentro del parque.'], ['latitud' => '4.65682922', 'longitud' => '-74.09762685', 'icon' => 'cafeteria.png', 'title' => 'Restaurante', 'description' => 'Unidad de servicio: 6 cafeterías y baños.'], ['latitud' => '4.6578631', 'longitud' => '-74.09192626', 'icon' => 'cafeteria.png', 'title' => 'Restaurante', 'description' => 'Unidad de servicio: 6 cafeterías y baños.'], ['latitud' => '4.65535941', 'longitud' => '-74.09649521', 'icon' => 'parque.png', 'title' => 'parque infantil', 'description' => 'zonas de juegos infantiles.'], ['latitud' => '4.65612933', 'longitud' => '-74.097206', 'icon' => 'parque.png', 'title' => 'parque infantil', 'description' => 'zonas de juegos infantiles.'], ['latitud' => '4.65624429', 'longitud' => '-74.0974313', 'icon' => 'parque.png', 'title' => 'parque infantil', 'description' => 'zonas de juegos infantiles.'], ['latitud' => '4.65572412', 'longitud' => '-74.09664784', 'icon' => 'parque.png', 'title' => 'parque infantil', 'description' => 'zonas de juegos infantiles.'], ['latitud' => '4.66249212', 'longitud' => '-74.09353387', 'icon' => 'parque.png', 'title' => 'parque infantil', 'description' => 'zonas de juegos infantiles.'], ['latitud' => '4.65773506', 'longitud' => '-74.09392531', 'icon' => 'parque.png', 'title' => 'parque infantil', 'description' => 'zonas de juegos infantiles.'], ['latitud' => '4.65777738', 'longitud' => '-74.09282847', 'icon' => 'parque.png', 'title' => 'parque infantil', 'description' => 'zonas de juegos infantiles.'], ['latitud' => '4.65749819', 'longitud' => '-74.09737781', 'icon' => 'kiosco.png', 'title' => 'Esferico', 'description' => 'Puntos de encuentro.'], ['latitud' => '4.66006311', 'longitud' => '-74.09494751', 'icon' => 'kiosco.png', 'title' => 'Esferico', 'description' => 'Puntos de encuentro: 11 kioscos.'], ['latitud' => '4.65989612', 'longitud' => '-74.0929542', 'icon' => 'kiosco.png', 'title' => 'kiosco', 'description' => 'Puntos de encuentro: 11 kioscos.'], ['latitud' => '4.65838714', 'longitud' => '-74.09401676', 'icon' => 'kiosco.png', 'title' => 'kiosco', 'description' => 'Puntos de encuentro: 11 kioscos.'], ['latitud' => '4.66071444', 'longitud' => '-74.09073194', 'icon' => 'concierto.png', 'title' => 'Plaza de Eventos', 'description' => 'Programas masivos públicos y privados, festivales como el famoso Festival de Verano; encuentros culturales, conciertos o Lunadas.'], ['latitud' => '4.65832792', 'longitud' => '-74.09072412', 'icon' => 'monumento.png', 'title' => 'Monumento', 'description' => 'Monumento Bolivariano.']]; DB::table('positions')->delete(); foreach ($positions as $position) { \App\Position::create($position); } }
/** * Display a listing of the resource. * * @return Response */ public function index() { $this->data['user'] = User::where('deleted_at', null)->count(); $this->data['user_disabled'] = User::where('deleted_at', !null)->count(); $this->data['department'] = Department::where('enabled', 1)->count(); $this->data['position'] = Position::where('enabled', 1)->count(); return view('pages.admin.dashboard', $this->data); }
public function sync() { $timecard_data = Input::get('timecard_data'); $inventory_data = Input::get('inventory_data'); $positions_modified = Input::get('positions_modified'); $users_modified = Input::get('users_modified'); $timecard_modified = Input::get('timecard_modified'); $checklists_modified = Input::get('checklists_modified'); $inventory_modified = Input::get('inventory_modified'); foreach ($inventory_data as $entry) { $record = \App\Inventory::findOrFail($entry["guid"]); $record->quantity_on_hand = $entry["quantity_on_hand"]; $record->updated_at = Carbon::createFromTimestamp($entry["last_modified"], 'America/Chicago'); $record->save(); $adj = new \App\InventoryAdjustment(); $adj->inventory_id = $record->id; $adj->quantity_on_hand = $record->quantity_on_hand; $adj->save(); } $stamp = ""; foreach ($timecard_data as $entry) { $stamp = date_default_timezone_get(); $record = \App\Timecard::where('guid', $entry["guid"])->first(); if ($record) { $record->guid = $entry["guid"]; $record->clock_in = Carbon::createFromTimestamp($entry["clock_in"], 'America/Chicago'); if ($entry["clock_out"] == '0') { $record->clock_out = null; } else { $record->clock_out = Carbon::createFromTimestamp($entry["clock_out"], 'America/Chicago'); } $record->save(); } else { $record = new \App\Timecard(); $record->guid = $entry["guid"]; $record->clock_in = Carbon::createFromTimestamp($entry["clock_in"], 'America/Chicago'); if ($entry["clock_out"] == '0') { $record->clock_out = null; } else { $record->clock_out = Carbon::createFromTimestamp($entry["clock_out"], 'America/Chicago'); } $record->user_id = $entry["user_id"]; $record->position_id = $entry["position_id"]; $record->save(); } } $users_last_modified = Carbon::createFromTimestamp($users_modified)->toDateTimeString(); $users = \App\User::where('updated_at', '>', $users_last_modified)->get(); $timecard_last_modified = Carbon::createFromTimestamp($timecard_modified)->toDateTimeString(); $timecards = \App\Timecard::where('updated_at', '>', $timecard_last_modified)->get(); $positions_last_modified = Carbon::createFromTimestamp($positions_modified)->toDateTimeString(); $positions = \App\Position::withTrashed()->where('updated_at', '>', $positions_last_modified)->get(); $checklists_last_modified = Carbon::createFromTimestamp($checklists_modified)->toDateTimeString(); $checklist = \App\Checklist::withTrashed()->where('updated_at', '>', $checklists_last_modified)->get(); $inventory_last_modified = Carbon::createFromTimestamp($inventory_modified)->toDateTimeString(); $inventory = \App\Inventory::withTrashed()->where('updated_at', '>', $inventory_last_modified)->get(); return Response::json(["users" => $users, "checklist" => $checklist, "inventory" => $inventory, "timecards" => $timecards, "positions" => $positions]); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $positions = \App\Position::all(); $response = array(); foreach ($positions as $position) { $response[] = array('lat' => $position->latitud, 'lon' => $position->longitud, 'title' => $position->title, 'icon' => $position->icon, 'description' => $position->description); } return response()->json($response); }
/** * Display list devices * * @return Response */ public function index() { $devices = Device::all(); $position = Position::all(); foreach ($devices as $key => $value) { $value->device_name = $value->kind_device->device_name; $value->contract_number = $value->infomation_device->contract_number; $value->os_name = $value->operating_system->os_name; } return view('devices.listdevice', compact('devices', 'position')); }
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request, $id) { $position = Position::find($id); $position_title = $request->get('position_title'); $position_shortcode = $request->get('position_shortcode'); $position->title = $position_title; $position->shortcode = $position_shortcode; $position->save(); flash()->success('', 'Pakeista pozicija!'); return redirect()->back(); }
/** * Show Cv information * * @param int $id * @return Response */ public function show($id) { $positions = Position::all(); $employee = Employee::find($id); $educations = Education::where('employee_id', '=', $employee->id)->get(); $employee_skills = EmployeeSkill::where('employee_id', '=', $employee->id)->get(); $experiences = WorkingExperience::where('employee_id', '=', $employee->id)->get(); $taken_projects = TakenProject::where('employee_id', '=', $employee->id)->get(); $nationalities = Nationality::all(); $category_skill = CategorySkill::all(); return view('printpreview.printpreview', compact('taken_projects', 'position', 'employee_skills', 'nationalities', 'employee', 'educations', 'experiences', 'category_skill')); }
/** * Update the specified resource in storage. * * @param PositionRequest $request * @param int $id * @return \Illuminate\Http\Response */ public function update(PositionRequest $request, $id) { try { $position = Position::findOrFail($id); $position->fill($request->all())->save(); } catch (ModelNotFoundException $ex) { Flash::error('No position available' . $ex); return redirect()->route('positions.index'); } Flash::success('Position updated successfully'); return redirect()->route('positions.index'); }
public function delete($id) { $position = Position::find($id); // находим хотя бы одного пользователя по данной должности $user = Position::find($id)->users->first(); // если должность не используется ни у одного из пользователей, удаляем её if (!$user) { $position->delete(); return redirect()->back()->withSuccess('Запись удалена'); } else { return redirect()->back()->with('message', 'Должность используется'); } }
/** * Update the specified resource in storage. * * @param int $id * @return Response */ public function update($id) { if (Request::isMethod('get')) { $this->data['positions'] = Position::where('enabled', 1)->get(); $this->data['departments'] = Department::where('enabled', 1)->get(); $this->data['item'] = User::find($id); if ($this->data['item']) { return view('pages.user.update', $this->data); } else { return redirect('user'); } } elseif (Request::isMethod('post')) { $user = User::find($id); $user->update(Input::all()); return redirect('user'); } }
/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * * @return \Illuminate\Http\Response */ public function store(Request $request) { $validator = \Validator::make($request->all(), ['body' => 'required', 'translation_id' => 'sometimes|exists:translations,id', 'via_dictionary' => 'sometimes|boolean']); if ($validator->passes()) { if ($request->input('via_dictionary')) { $definitions = \YaDictionary::lookup($request->input('body')); if ($definitions) { foreach ($definitions as $definition) { $partOfSpeech = $definition->getPartOfSpeech(); if (!($position = Position::where('body', $partOfSpeech)->first())) { $position = Position::create(['body' => $partOfSpeech]); } if (!Word::where('body', $definition->getText())->where('position_id', $position->id)->first()) { $word = new Word(); $word->body = $definition->getText(); $word->ts = $definition->getTranscription(); $word->position()->associate($position); $word->save(); $translationIds = []; foreach ($definition->getTranslations() as $yaTranslation) { if (!($translation = Translation::where('body', $yaTranslation->getText())->first())) { $translation = Translation::create(['body' => $yaTranslation->getText()]); } $translationIds[] = $translation->id; } $word->translations()->attach($translationIds); } } $response = response('This word has created from the dictionary', 201); } else { $response = response()->json(['errors' => ['This word has not found in the dictionary.']], 404); } } else { if ($translationId = $request->input('translation_id')) { $word = Word::create(['body' => $request->input('body')]); $word->translations()->attach($translationId); $response = response()->json(['id' => $word->getId()], 201); } else { $response = response()->json(['errors' => ['It needs a translation.']], 400); } } } else { $response = response()->json(['errors' => $validator->messages()->all()], 400); } return $response; }
/** * Show and Export CV information * * @param [int] $id * @return Response */ public function show($id) { $positions = Position::all(); $employee = Employee::find($id); $educations = Education::where('employee_id', '=', $employee->id)->get(); $employee_skills = EmployeeSkill::where('employee_id', '=', $employee->id)->get(); $experiences = WorkingExperience::where('employee_id', '=', $employee->id)->get(); $taken_projects = TakenProject::where('employee_id', '=', $employee->id)->get(); $nationalities = Nationality::all(); $category_skill = CategorySkill::all(); $parameterr = array(); $parameter['employee'] = $employee; $parameter['educations'] = $educations; $parameter['category_skill'] = $category_skill; $parameter['employee_skills'] = $employee_skills; $parameter['taken_projects'] = $taken_projects; $parameter['experiences'] = $experiences; $parameter['nationalities'] = $nationalities; $pdf = \PDF::loadView('welcome', $parameter)->setPaper('a4')->setOrientation('landscape')->setWarnings(false); return $pdf->download('cv.pdf'); }
/** * Store a newly created resource in storage. * * @param Request $request * @return Response */ public function store(UserRequest $request, User $user) { /* New User Table */ $user->name = $request['Fname']; $user->surname = $request['Sname']; $user->cellphone = $request['Cell1']; $user->username = $request['Email']; $user->email = $request['Cell1']; $position = Position::where('slug', '=', $request['Position'])->first(); $user->position = $position->id; $province = Province::where('slug', '=', $request['Province'])->first(); $user->province = $province->id; $district = District::where('slug', '=', $request['District'])->first(); $user->district = $district->id; $municipalityIds = array(); foreach ($request['Municipality'] as $municipalityName) { $municipality = Municipality::where('slug', '=', $municipalityName)->first(); $municipalityIds[] = $municipality->id; } $user->municipality = implode(",", $municipalityIds); $department = Department::where('slug', '=', $request['Department'])->first(); $user->department = $department->id; $password = rand(1000, 99999); $user->password = \Hash::make($password); $user->api_key = uniqid(); $user->status = 1; $user->role = 2; $user->save(); \Session::flash('success', $request['Fname'] . ' ' . $request['Sname'] . ' has been added successfully!'); $data = array('name' => $user->name, 'username' => $user->email, 'password' => $password); \Mail::send('emails.registrationConfirmation', $data, function ($message) use($user) { $message->from('*****@*****.**', 'Siyaleader'); $message->to($user->username)->subject("Siyaleader User Registration Confirmation: " . $user->name); }); return redirect('list-users'); }
/** * Bootstrap any application services. * * @return void */ public function boot() { if (\Schema::hasTable('positions')) { $positions = Position::all(); $selectPositions = array(); $selectPositions[0] = "Select / All"; foreach ($positions as $position) { $selectPositions[$position->slug] = $position->name; } \View::share('selectPositions', $selectPositions); } if (\Schema::hasTable('cases_priorities')) { $priorities = CasePriority::all(); $selectPriorities = array(); $selectPriorities[0] = "Select / All"; foreach ($priorities as $priority) { $selectPriorities[$priority->slug] = $priority->name; } \View::share('selectPriorities', $selectPriorities); } if (\Schema::hasTable('titles')) { $titles = Title::all(); $selectTitles = array(); $selectTitles[0] = "Select / All"; foreach ($titles as $title) { $selectTitles[$title->slug] = $title->name; } \View::share('selectTitles', $selectTitles); } if (\Schema::hasTable('languages')) { $languages = Language::all(); $selectLanguages = array(); $selectLanguages[0] = "Select / All"; foreach ($languages as $language) { $selectLanguages[$language->slug] = $language->name; } \View::share('selectLanguages', $selectLanguages); } if (\Schema::hasTable('departments')) { $departments = Department::all(); $selectDepartments = array(); $selectDepartments[0] = "Select / All"; foreach ($departments as $department) { $selectDepartments[$department->slug] = $department->name; } \View::share('selectDepartments', $selectDepartments); } if (\Schema::hasTable('users_roles')) { $roles = UserRole::all(); $selectRoles = array(); $selectRoles[0] = "Select / All"; foreach ($roles as $role) { $selectRoles[$role->slug] = $role->name; } \View::share('selectRoles', $selectRoles); } if (\Schema::hasTable('provinces')) { $provinces = Province::all(); $selectProvinces = array(); $selectProvinces[0] = "Select / All"; foreach ($provinces as $Province) { $selectProvinces[$Province->slug] = $Province->name; } \View::share('selectProvinces', $selectProvinces); } if (\Schema::hasTable('districts')) { $districts = District::all(); $selectDistrict = array(); $selectDistricts[0] = "Select / All"; foreach ($districts as $district) { $selectDistricts[$district->slug] = $district->name; } \View::share('selectDistricts', $selectDistricts); } if (\Schema::hasTable('municipalities')) { $municipalities = Municipality::all(); $selectMunicipalities = array(); $selectMunicipalities[0] = "Select / All"; foreach ($municipalities as $municipality) { $selectMunicipalities[$municipality->slug] = $municipality->name; } \View::share('selectMunicipalities', $selectMunicipalities); } if (\Schema::hasTable('wards')) { $wards = Ward::all(); $selectWards = array(); $selectWards[0] = "Select / All"; foreach ($wards as $ward) { $selectWards[$ward->slug] = $ward->name; } \View::share('selectWards', $selectWards); } if (\Schema::hasTable('categories')) { $categories = Category::all(); $selectCategories = array(); $selectCategories[0] = "Select / All"; foreach ($categories as $category) { $selectCategories[$category->slug] = $category->name; } \View::share('selectCategories', $selectCategories); } if (\Schema::hasTable('sub_categories')) { $subCategories = SubCategory::all(); $selectSubCategories = array(); $selectSubCategories[0] = "Select / All"; foreach ($subCategories as $subCategory) { $selectSubCategories[$subCategory->slug] = $subCategory->name; } \View::share('selectSubCategories', $selectSubCategories); } if (\Schema::hasTable('sub_sub_categories')) { $subSubCategories = SubSubCategory::all(); $selectSubSubCategories = array(); $selectSubSubCategories[0] = "Select / All"; foreach ($subSubCategories as $subSubCategory) { $selectSubSubCategories[$subSubCategory->slug] = $subSubCategory->name; } \View::share('selectSubSubCategories', $selectSubSubCategories); } if (\Schema::hasTable('relationships')) { $relationships = Relationship::all(); $selectRelationships = array(); $selectRelationships[0] = "Select / All"; foreach ($relationships as $relationship) { $selectRelationships[$relationship->id] = $relationship->name; } \View::share('selectRelationships', $selectRelationships); } if (\Schema::hasTable('cases')) { $cases = \DB::table('cases')->join('users', 'cases.reporter', '=', 'users.id')->select(\DB::raw("\n IF(`cases`.`addressbook` = 1,(SELECT CONCAT(`first_name`, ' ', `surname`) FROM `addressbook` WHERE `addressbook`.`id`= `cases`.`reporter`), (SELECT CONCAT(users.`name`, ' ', users.`surname`) FROM `users` WHERE `users`.`id`= `cases`.`reporter`)) as reporterName\n\n "))->get(); $reporters = array(); $reporters[0] = "Select / All"; foreach ($cases as $case) { $reporters[$case->reporterName] = $case->reporterName; } \View::share('selectReporters', $reporters); } View()->composer('master', function ($view) { $view->with('addressBookNumber', addressbook::all()); if (\Auth::check()) { $number = addressbook::where('user', '=', \Auth::user()->id)->get(); $view->with('addressBookNumber', $number); $allUsers = User::where('id', '<>', \Auth::user()->id)->get(); $view->with('loggedInUsers', $allUsers); $noPrivateMessages = Message::where('to', '=', \Auth::user()->id)->where('read', '=', 0)->where('message_type', '=', 0)->get(); $view->with('noPrivateMessages', $noPrivateMessages); $noInboxMessages = Message::where('to', '=', \Auth::user()->id)->where('message_type', '=', 0)->get(); $view->with('noInboxMessages', $noInboxMessages); $noDepartments = Department::all(); $view->with('noDepartments', $noDepartments); $noUsers = User::all(); $view->with('noUsers', $noUsers); $noRoles = UserRole::all(); $view->with('noRoles', $noRoles); $noPositions = Position::all(); $view->with('noPositions', $noPositions); $noRelationships = Relationship::all(); $view->with('noRelationships', $noRelationships); $noProvinces = Province::all(); $view->with('noProvinces', $noProvinces); $noCaseStatuses = CaseStatus::all(); $view->with('noCaseStatuses', $noCaseStatuses); $userRole = UserRole::where('id', '=', \Auth::user()->role)->first(); $view->with('systemRole', $userRole); $noCasesPriorities = CasePriority::all(); $view->with('noCasesPriorities', $noCasesPriorities); } }); }
} foreach ($cases as $case) { if ($case->addressbook == 1) { $userObj = addressbook::find($case->reporter); $ReporterName = $userObj->FirstName . ' ' . $userObj->Surname; $ReporterPosition = ""; $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;
/** * Show the form for creating a new resource. * * @return \Illuminate\Http\Response */ public function create() { $position_list = Position::all()->lists('position', 'id')->toArray(); return view('pages.add-duty', compact('position_list')); }
/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { $position = Position::where('active', 1)->get(); // if is Leader // if staff edit != dev or yourself => denied if (Gate::allows('check-leader')) { $staff = Staff::find($id)->level->role; if ($staff->name != "Developer" && $id != Auth::user()->id) { return redirect()->route('admin.staff.index')->with('message', 'Access is denied'); } else { $level = Level::where('role_id', 4)->get(); $department = Department::where('id', Auth::user()->department_id)->where('active', 1)->get()->first(); } } else { if (Gate::allows('check-admin')) { $staff = Staff::find($id)->level->role; if ($staff->name == "Developer" && $id != Auth::user()->id) { return redirect()->route('admin.staff.index')->with('message', 'Access is denied'); } else { $department = Department::where('active', 1)->get(); $level = Level::where(['role_id' => 2, 'active' => 1])->orWhere(['role_id' => 3, 'active' => 1])->get(); } } else { if (Gate::allows('check-manager')) { $staff = Staff::find($id)->level->role; if ($staff->name == "Manager" && $id != Auth::user()->id) { return redirect()->route('admin.staff.index')->with('message', 'Access is denied'); } else { $level = Level::where('role_id', 3)->orWhere('role_id', 4)->get(); if ($id == Auth::user()->id) { $department = ''; } $department = Department::where('active', 1)->get(); } } else { $staff_id = Auth::user()->id; if ($staff_id != $id) { return redirect()->route('admin.staff.index')->with('message', 'Access is denied'); } else { $position = Position::where('id', Auth::user()->position_id)->where('active', 1)->get(); $level = Level::where('id', Auth::user()->level_id)->where('active', 1)->get(); $department = Department::where('id', Auth::user()->department_id)->where('active', 1)->get()->first(); } } } } if ($id == Auth::user()->id) { $check_account = 1; } else { $check_account = 0; } $staff = Staff::find($id); return view('admin.staff.update', compact('id', 'staff', 'position', 'level', 'department', 'check_account')); }
protected function leagueData() { $committees = Committee::where('active', 1)->orderBy('name')->get(); $positions = Position::all(); $requirements = $this->currentYearBaseReqs(); $teams = Team::where('active', 1)->orderBy('name')->get(); $groups = Group::orderBy('name')->get(); $roles = Role::orderBy('name')->get(); return array('committees' => $committees, 'positions' => $positions, 'requirements' => $requirements, 'teams' => $teams, 'groups' => $groups, 'roles' => $roles); }
/** * Bootstrap any application services. * * @return void */ public function boot() { if (\Schema::hasTable('positions')) { $positions = Position::orderBy('name', 'ASC')->get(); $selectPositions = array(); $selectPositions[0] = "Select / All"; foreach ($positions as $position) { $selectPositions[$position->slug] = $position->name; } \View::share('selectPositions', $selectPositions); } if (\Schema::hasTable('departments')) { $departments = Department::orderBy('name', 'ASC')->get(); $selectDepartments = array(); $selectDepartments[0] = "Select / All"; foreach ($departments as $department) { $selectDepartments[$department->slug] = $department->name; } \View::share('selectDepartments', $selectDepartments); } if (\Schema::hasTable('provinces')) { $provinces = Province::all(); $selectProvinces = array(); $selectProvinces[0] = "Select / All"; foreach ($provinces as $Province) { $selectProvinces[$Province->slug] = $Province->name; } \View::share('selectProvinces', $selectProvinces); } if (\Schema::hasTable('districts')) { $districts = District::all(); $selectDistrict = array(); $selectDistricts[0] = "Select / All"; foreach ($districts as $district) { $selectDistricts[$district->slug] = $district->name; } \View::share('selectDistricts', $selectDistricts); } if (\Schema::hasTable('municipalities')) { $municipalities = Municipality::all(); $selectMunicipalities = array(); $selectMunicipalities[0] = "Select / All"; foreach ($municipalities as $municipality) { $selectMunicipalities[$municipality->slug] = $municipality->name; } \View::share('selectMunicipalities', $selectMunicipalities); } if (\Schema::hasTable('categories')) { $categories = Category::all(); $selectCategories = array(); $selectCategories[0] = "Select / All"; foreach ($categories as $category) { $selectCategories[$category->slug] = $category->name; } \View::share('selectCategories', $selectCategories); } if (\Schema::hasTable('sub-categories')) { $subCategories = SubCategory::all(); $selectSubCategories = array(); $selectSubCategories[0] = "Select / All"; foreach ($subCategories as $subCategory) { $selectSubCategories[$subCategory->slug] = $subCategory->name; } \View::share('selectSubCategories', $selectSubCategories); } if (\Schema::hasTable('sub-sub-categories')) { $subSubCategories = SubSubCategory::all(); $selectSubSubCategories = array(); $selectSubSubCategories[0] = "Select / All"; foreach ($subSubCategories as $subSubCategory) { $selectSubSubCategories[$subSubCategory->slug] = $subSubCategory->name; } \View::share('selectSubSubCategories', $selectSubSubCategories); } if (\Schema::hasTable('relationships')) { $relationships = Relationship::all(); $selectRelationships = array(); $selectRelationships[0] = "Select / All"; foreach ($relationships as $relationship) { $selectRelationships[$relationship->id] = $relationship->name; } \View::share('selectRelationships', $selectRelationships); } if (\Schema::hasTable('cases')) { $cases = \DB::table('cases')->join('users', 'cases.reporter', '=', 'users.id')->select(\DB::raw("\n IF(`cases`.`addressbook` = 1,(SELECT CONCAT(`FirstName`, ' ', `Surname`) FROM `addressbook` WHERE `addressbook`.`id`= `cases`.`reporter`), (SELECT CONCAT(users.`name`, ' ', users.`surname`) FROM `users` WHERE `users`.`id`= `cases`.`reporter`)) as reporterName\n\n "))->get(); $reporters = array(); $reporters[0] = "Select / All"; foreach ($cases as $case) { $reporters[$case->reporterName] = $case->reporterName; } \View::share('selectReporters', $reporters); } View()->composer('master', function ($view) { $view->with('addressBookNumber', addressbook::all()); if (\Auth::check()) { $number = addressbook::where('user', '=', \Auth::user()->id)->get(); $view->with('addressBookNumber', $number); $allUsers = User::where('id', '<>', \Auth::user()->id)->get(); $view->with('loggedInUsers', $allUsers); $noPrivateMessages = Message::where('to', '=', \Auth::user()->id)->where('read', '=', 0)->where('online', '=', 0)->get(); $view->with('noPrivateMessages', $noPrivateMessages); $noInboxMessages = Message::where('to', '=', \Auth::user()->id)->where('online', '=', 0)->get(); $view->with('noInboxMessages', $noInboxMessages); } }); }
/** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy($id) { $findPosition = Staff::where('position_id', $id)->get()->toArray(); if (!empty($findPosition)) { return redirect()->route('admin.position.index')->with('message', 'Can\'t delete position !'); } $position = Position::find($id); $position->delete(); return redirect()->route('admin.position.index')->with('message', 'Delete position success!'); }
/** * Display candidate's information * * @param int $id * @return Response */ public function show($id) { $candidate = Candidate::find($id); $candidate->date_of_birth = $this->convert_datetimesql_to_datepicker($candidate->date_of_birth); $candidate->date_submit = $this->convert_datetimesql_to_datepicker($candidate->date_submit); $f1 = FileCandidate::lists('id'); $f2 = $candidate->filecandidates()->get(); $status_records = StatusRecord::whereIn('id', array(1, 3, 4))->get(); $res_status = array(); foreach ($status_records as $k_sta => $v_sta) { $res_status += array($v_sta->id => $v_sta->name); } $status_records = $res_status; $positions = Position::lists('name', 'id'); return view('candidates.editcandidate', compact('positions', 'status_records', 'candidate', 'f1', 'f2')); }
/** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy($id) { $checklistItem = \App\Position::find($id); $checklistItem->delete(); }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function delete($id) { $department = Position::find($id); $department->enabled = 0; $department->delete(); return redirect('position'); }
public function getAvailableUnits($id) { $file = file_get_contents("units.txt"); $units = json_decode($file, true); $position = Position::find($id); $x = $position->x; $y = $position->y; $position = Position::where('y', $y)->where('x', $x)->get()->lists('id'); $city = City::whereIn('position_id', $position)->get(); if (count($city) == 0) { return $city; } else { switch ($city[0]->tier) { case 1: $txt = 'tier1'; break; case 2: $txt = 'tier2'; break; } $units = Unit::whereIn('Id', $units[$txt])->with('resource')->get(); return \App\CityEffectApplier::modifyUnitPricesByCity($units, $city[0]); } }
/** * Filter info in overview device * @return void */ public function filter() { $type_id = Input::get('type_device'); $model_id = Input::get('model_device'); $kind_id = Input::get('kind_device'); $status_id = Input::get('status_device'); $os_id = Input::get('os_device'); $contract_id = Input::get('contract_number'); $position = Position::all(); $types = TypeDevice::all(); $models = ModelDevice::all(); $kinds = KindDevice::all(); $statuses = StatusDevice::all(); $os = OperatingSystem::all(); $contract = InformationDevice::all(); /*Thuc hien cau truy van de lay du lieu sau khi filter*/ $devices = Device::whereHas('kind_device', function ($query) use($type_id) { if ($type_id) { $query->whereHas('model_device', function ($query) use($type_id) { $query->whereHas('type_devices', function ($query) use($type_id) { $query->where('id', '=', $type_id); }); }); } })->whereHas('kind_device', function ($query) use($model_id) { if ($model_id) { $query->whereHas('model_device', function ($query) use($model_id) { $query->where('id', '=', $model_id); }); } })->whereHas('kind_device', function ($query) use($kind_id) { if ($kind_id) { $query->where('id', '=', $kind_id); } })->whereHas('status_devices', function ($query) use($status_id) { if ($status_id) { $query->where('id', '=', $status_id); } })->whereHas('operating_system', function ($query) use($os_id) { if ($os_id) { $query->where('id', '=', $os_id); } })->whereHas('infomation_device', function ($query) use($contract_id) { if ($contract_id) { $query->where('id', '=', $contract_id); } })->get(); foreach ($devices as $key => $value) { $value->device_name = $value->kind_device->device_name; $value->status = $value->status_devices->status; $employee = $value->employee; if ($employee) { $value->employee_code = $employee->employee_code; $value->fullname = $employee->lastname . " " . $employee->firstname; $value->employee_position = $employee->departments['name']; } else { $value->employee_code = ""; $value->fullname = ""; $value->employee_position = ""; } } echo json_encode($devices); }