/** * 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); }
/** * 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(); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $request = request(); $name = $request->has('name') ? $request->get('name') : ''; $positions = Position::where(function ($query) use($name) { if (!empty($name)) { $query->where('name', 'LIKE', "%{$name}%"); } })->paginate(env('LIMIT', 15)); return view('positions.index', compact('positions', 'name')); }
/** * 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; }
/** * 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 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'); }
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]); } }
/** * 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')); }
public function getCityArmyIsIn($army) { $position = Position::where('y', $army->position->y)->where('x', $army->position->x)->get()->lists('id'); $city = City::whereIn('position_id', $position)->get(); return $city[0]; }
public function departmentMonthlyPosition(Request $request) { $this->date_start = $request->month && $request->year ? new Carbon('first Monday of ' . $request->month . ' ' . $request->year) : new Carbon('first Monday of this month'); // first Monday of the month $this->date_end = $request->month && $request->year ? new Carbon('last Monday of ' . $request->month . ' ' . $request->year) : new Carbon('last Monday of this month'); // last Monday of the month $project = Project::with('positions')->where('department_id', $request->id)->first(); $first_report = Report::where('project_id', $project->id)->whereBetween('date_start', [$this->date_start, $this->date_end])->orderBy('date_start')->first(); $project->reports = Report::with('project')->where('project_id', $project->id)->whereBetween('date_start', [$this->date_start, $this->date_end])->where('daily_work_hours', 'like', $first_report->daily_work_hours . '%')->get(); $project->members = Experience::with(['member' => function ($query) { $query->withTrashed(); }])->where('project_id', $project->id)->get(); foreach ($project->members as $member_key => $member) { $member->total_output = 0; $member->total_output_error = 0; $member->total_hours_worked = 0; $member->average_output = 0; $member->monthly_productivity = 0; $member->monthly_quality = 0; } foreach ($project->reports as $report_key => $report) { $project->position = Position::where('id', $request->input('position.id'))->first(); $report->members = Experience::with('member')->where('project_id', $report->project_id)->get(); foreach ($report->members as $member_key => $member) { $member->performance = Performance::with('position')->with(['target' => function ($query) { $query->withTrashed(); }])->where('member_id', $member->member_id)->where('report_id', $report->id)->where('position_id', $request->input('position.id'))->first(); if ($member->performance) { $project->members[$member_key]->total_output += $member->performance->output; $project->members[$member_key]->total_output_error += $member->performance->output_error; $project->members[$member_key]->total_hours_worked += $member->performance->hours_worked; } } $report->date_start = Carbon::parse($report->date_start)->toFormattedDateString(); $report->date_end = Carbon::parse($report->date_end)->toFormattedDateString(); } if (count($project->reports)) { foreach ($project->members as $member_key => $member) { for ($i = 0; $i < count($project->reports); $i++) { if ($project->reports[$i]->members[$member_key]->performance) { $target = $project->reports[$i]->members[$member_key]->performance->target; $member->average_output = round($member->total_output / $member->total_hours_worked * $first_report->daily_work_hours, 2); $member->monthly_productivity = round($member->average_output / $target->productivity * 100, 2); $member->monthly_quality = round((1 - $member->total_output_error / $member->total_output) * 100, 2); if ($member->monthly_productivity < 100 && $member->monthly_quality >= $target->quality) { $member->quadrant = 'Quadrant 1'; } else { if ($member->monthly_productivity >= 100 && $member->monthly_quality >= $target->quality) { $member->quadrant = 'Quadrant 2'; } else { if ($member->monthly_productivity >= 100 && $member->monthly_quality < $target->quality) { $member->quadrant = 'Quadrant 3'; } else { if ($member->monthly_productivity < 100 && $member->monthly_quality < $target->quality) { $member->quadrant = 'Quadrant 4'; } } } } } } } } $project->date_cover_start = $this->date_start->toFormattedDateString(); $project->date_cover_end = $this->date_end->toFormattedDateString(); return $project; }
public function getPositionToMoveTo() { $x = $this->army->move_to_x; $y = $this->army->move_to_y; $position = Position::where('x', $x)->where('y', $y)->first(); if ($position == null) { $position = new Position(); $position->x = $x; $position->y = $y; } return $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) { $this->validate($request, ['name' => 'required|string']); $duplicate = Position::whereNotIn('id', [$request->id])->where('name', $request->name)->where('department_id', $request->department_id)->where('project_id', $request->project_id)->first(); if ($duplicate) { return response()->json(true); } $position = Position::where('id', $id)->first(); $position->name = $request->name; // $position->department_id = $request->department_id; // $position->project_id = $request->project_id; $position->save(); return $position; }
/** * Store a newly created resource in storage. * * @param Request $request * @return Response */ public function store(UserRequest $request, User $user) { $role = UserRole::where('slug', '=', $request['role'])->first(); $user->role = $role->id; $title = Title::where('slug', '=', $request['title'])->first(); $user->title = $title->id; $language = Language::where('slug', '=', $request['language'])->first(); $user->language = $language->id; $user->name = $request['name']; $user->surname = $request['surname']; $user->cellphone = $request['cellphone']; $user->alt_cellphone = $request['alt_cellphone']; $user->email = $request['email']; $user->alt_email = $request['alt_email']; $province = Province::where('slug', '=', $request['province'])->first(); $user->province = $province->id; $district = District::where('slug', '=', $request['district'])->first(); $user->district = $district->id; $municipality = Municipality::where('slug', '=', $request['municipality'])->first(); $user->municipality = $municipality->id; $ward = Ward::where('slug', '=', $request['ward'])->first(); $user->ward = $ward->id; $department = Department::where('slug', '=', $request['department'])->first(); $user->department = $department->id; $position = Position::where('slug', '=', $request['position'])->first(); $user->position = $position->id; $password = rand(1000, 99999); $user->password = \Hash::make($password); $user->api_key = uniqid(); $user->created_by = \Auth::user()->id; $user->save(); \Session::flash('success', $request['name'] . ' ' . $request['surname'] . ' user 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->email)->subject("Siyaleader Notification - User Registration Confirmation: " . $user->name); }); return redirect('list-users'); }
public function apply($position) { $countries = $this->getCountries(); $position = str_replace('-', ' ', $position); $position = Position::where('position', 'LIKE', '%' . $position . '%')->first(); return view('pages.apply', compact('position', 'countries')); }