public function create(Request $req) { $record = new Record(); $record->location_id = $req->get("location_id"); $staff = Staff::where("staff_nr", "=", $req->get("staff_id"))->first(); if ($staff == null) { return "oh fuk"; } $record->staff_id = $staff->id; $record->particularities = $req->get("particularities"); $record->save(); }
/** * Handles registration process of new volunteer. * * @param \Illuminate\Http\Request $request * @return JSON array of status */ public function addUserAccount(Request $request) { Volunteer::create(['nric' => $request->get('nric'), 'name' => $request->get('name'), 'email' => $request->get('email'), 'password' => $request->get('password'), 'gender' => $request->get('gender'), 'date_of_birth' => $request->get('dob'), 'contact_no' => $request->get('phone'), 'occupation' => $request->get('occupation'), 'has_car' => $request->get('haveCar'), 'minutes_volunteered' => '0', 'area_of_preference_1' => $request->get('preferences1'), 'area_of_preference_2' => $request->get('preferences2'), 'image_nric_front' => $request->get('frontIC'), 'image_nric_back' => $request->get('backIC'), 'rank_id' => Rank::where('min', 0)->first()->rank_id]); $volunteer = Volunteer::where('email', $request->get('email'))->first(); $mailingList = Staff::where('is_admin', 'TRUE')->lists('email')->toArray(); if ($volunteer == null) { $status = ["error"]; return response()->json(compact('status')); } else { Mail::send('emails.volunteer_registration', compact('volunteer'), function ($message) use($mailingList) { $message->subject('New Volunteer Registration'); $message->bcc($mailingList); }); $status = ["Created successfully"]; return response()->json(compact('status')); } }
public function postReset(Request $request) { $this->validate($request, ['token' => 'required', 'email' => 'required|email', 'password' => 'required|confirmed|min:6']); $flag = Staff::where('email', $request->email)->get()->first(); if ($flag->active == 0) { return redirect()->back()->with('message', 'Account is not active!'); } $credentials = $request->only('email', 'password', 'password_confirmation', 'token'); $response = Password::reset($credentials, function ($user, $password) { $this->resetPassword($user, $password); }); switch ($response) { case Password::PASSWORD_RESET: return redirect($this->redirectPath())->with('status', trans($response)); default: return redirect()->back()->withInput($request->only('email'))->withErrors(['email' => trans($response)]); } }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index(Request $request) { $sort = $request->get('sort'); $sort = max($sort, 1); $qty = $request->get('show'); $qty = max($qty, 10); $dep = (int) $request->get('dep'); $sorts = array(1 => ['name' => 'asc'], ['name' => 'desc']); $department = ''; // is manager // show all staff if (Gate::allows('check-manager')) { $staff = Staff::where('level_id', '!=', 6)->orderBy(key($sorts[$sort]), current($sorts[$sort]))->paginate($qty); if (isset($dep) && !empty($dep)) { $staff = Staff::where('level_id', '!=', 6)->where('department_id', $dep)->orderBy(key($sorts[$sort]), current($sorts[$sort]))->paginate($qty); } $department = Department::where('active', 1)->get(); } // is leader // show staff in department if (Gate::allows('check-leader')) { $staff = Staff::where('level_id', '!=', 6)->where('department_id', Auth::user()->department_id)->orderBy(key($sorts[$sort]), current($sorts[$sort]))->paginate($qty); } // is admin // show all staff if (Gate::allows('check-admin')) { $staff = Level::where('active', 1)->where('role_id', 2)->orWhere('role_id', 3)->get(); } // is developer // denied if (Gate::allows('check-developer')) { return redirect()->route('admin.department.index'); } if (Auth::user()->level->role_id == 2 || Auth::user()->level->role_id == 3) { $staff->setPath('staff'); $staff->appends('show', $qty); if (!empty($dep)) { $staff->appends('dep', $dep); } } return view('admin.staff.list', compact('staff', 'department')); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $staff_team = ''; $leader = ''; $pie_leader = ''; $department = ''; $department = Department::leftJoin('staff', 'department.id', '=', 'staff.department_id')->join('level', 'staff.level_id', '=', 'level.id')->join('role', 'level.role_id', '=', 'role.id')->select(DB::raw('department.name as name_dep,role.name,count(*) as num'))->groupBy('department.name', 'role.name')->get()->toArray(); $num_staff = $department; $pie = array(); foreach ($department as $value) { $pie[$value['name_dep']][] = array($value['name'], (int) $value['num']); } // is Leader if (Gate::allows('check-leader')) { $department = Department::leftJoin('staff', 'department.id', '=', 'staff.department_id')->join('level', 'staff.level_id', '=', 'level.id')->join('role', 'level.role_id', '=', 'role.id')->select(DB::raw('department.name as name_dep,role.name,count(*) as num'))->where(['department.id' => Auth::user()->department_id, 'department.active' => 1])->groupBy('department.name', 'role.name')->get()->toArray(); $num_staff = $department; $pie = array(); foreach ($department as $value) { $pie[$value['name_dep']][] = array($value['name'], (int) $value['num']); } } // is Developer // if is manager / != department / yourself // denied if (Gate::allows('check-developer')) { // get team of staff $staff = StaffTeam::where('staff_id', Auth::user()->id)->get()->first(); if (isset($staff) && !empty($staff)) { $staff_team = StaffTeam::where('team_id', $staff->team_id)->where('staff_id', '!=', Auth::user()->id)->get(); $team = Team::where('id', $staff->team_id)->get()->first(); $leader = Staff::find($team->creator); } // staff in department $staff_department = Staff::where(['active' => 1, 'department_id' => Auth::user()->department_id])->get(); } return view('admin.department.home', compact('pie', 'staff_team', 'leader', 'num_staff', 'staff_department')); }
/** * Update the specified resource in storage. * * @param Request $request * @param int $id * @return Response */ public function update(Request $request, $slug) { // Validation $this->validate($request, ['first_name' => 'required|min:2|max:20', 'last_name' => 'required|min:2|max:30', 'age' => 'required|integer|between:0,130', 'profile_image' => 'image|between:0,2000']); // Find the user or staff member to edit $staffMember = Staff::where('slug', $slug)->firstOrFail(); $staffMember->first_name = $request->first_name; $staffMember->last_name = $request->last_name; $staffMember->age = $request->age; // Insert a slug into the request $staffMember->slug = str_slug($request->first_name . ' ' . $request->last_name); // If the user provided a new image if ($request->hasFile('profile_image')) { // Generare a new file name $fileExtension = $request->file('profile_image')->getClientOriginalExtension(); $fileName = 'staff-' . uniqid() . '.' . $fileExtension; $request->file('profile_image')->move('img/staff', $fileName); \Image::make('img/staff/' . $fileName)->resize(240, null, function ($constraint) { $constraint->aspectRatio(); })->save('img/staff/' . $fileName); // Delete the old image \File::Delete('img/staff/' . $staffMember->profile_image); // Tell database $staffMember->profile_image = $fileName; } // Update the database $staffMember->save(); return redirect('about/' . $staffMember->slug); }
public function exists(Request $req) { return ['exists' => Staff::where('staff_nr', '=', $req->get('staff_nr'))->get()->count() > 0]; }
/** * 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!'); }
/** * Update the specified resource in storage. * * @param Request $request * @param int $id * @return Response */ public function update(Request $request, $slug) { // Validation $this->validate($request, ['first_name' => 'required|min:2|max:20', 'last_name' => 'required|min:2|max:30', 'age' => 'required|between:0,130|integer', 'profile_image' => 'image|between:0,2000']); // Find the user or staff member to edit where slug is equal to whatever came back from the form $staffMember = Staff::where('slug', $slug)->firstOrFail(); // Makes changes to the database $staffMember->first_name = $request->first_name; $staffMember->last_name = $request->last_name; $staffMember->age = $request->age; // Referencing the existing slug and assigning to it the new slug based on changes made to the staff members name $staffMember->slug = str_slug($request->first_name . ' ' . $request->last_name); // If the user provided a new image then save that image if ($request->hasFile('profile_image')) { // Change the image file name, move the image file and resize the image // Grab the file extension of the image $fileExtension = $request->file('profile_image')->getClientOriginalExtension(); // Generate a new profile image name to avoid duplication and join the two together // ^ ^ $fileName = 'staff-' . uniqid() . '.' . $fileExtension; // - $request->file('profile_image')->move('img/staff', $fileName); // Grabbed the profile image and resized it \Image::make('img/staff/' . $fileName)->resize(240, null, function ($constrait) { $constrait->aspectRatio(); })->save('img/staff/' . $fileName); // Delete the old image \File::Delete('img/staff/' . $staffMember->profile_image); // Tell the database of the new image $staffMember->profile_image = $fileName; } // Save the changes to the database $staffMember->save(); // Redirect user to the staff members page with the updated changes return redirect('about/' . $staffMember->slug); }
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request, $type, $id) { if ($type == 'event' || $type == 'page') { try { $event = Event::where('slug', $id)->where('type', $type)->firstOrFail(); } catch (\Illuminate\Database\Eloquent\ModelNotFoundException $e) { return view('errors.pageNotFound'); } if ($type == 'event') { $this->validate($request, ['title' => 'required|max:50', 'content' => 'required|max:10000', 'start_date' => 'required|date|before:end_date', 'end_date' => 'required|date|after:start_date', 'start_time' => 'date_format:H:i|before:end_time', 'end_time' => 'date_format:H:i|after:start_time', 'number' => 'max:12', 'street' => 'max:40', 'suburb' => 'max:40', 'area' => 'max:40', 'country' => 'max:30', 'image[]' => 'image']); if ($request->status == 0 || $request->status == 1) { $event->status = $request->status; } elseif ($request->status == 2) { foreach ($event->images as $image) { $original = 'img/site/original/'; $sliderPath = 'img/site/slider/'; $galleryThumbPath = 'img/site/gallery/thumbnail/'; $galleryPrevPath = 'img/site/gallery/preview/'; $thumbnail = 'img/site/thumbnail/'; $imagedb = Image::where('id', $image->id)->first(); \File::delete([$sliderPath . $imagedb->image, $galleryPrevPath . $imagedb->image, $galleryThumbPath . $imagedb->image, $thumbnail . $imagedb->image, $original . $imagedb->image]); EventImage::where('event_id', $event->id)->where('image_id', $image->id)->delete(); $imagedb->delete(); } $event->delete(); return redirect('/admin/' . $type . '/'); } $event->title = $request->title; $event->content = $request->content; $event->start_date = str_replace('-', '/', $request->start_date); $event->end_date = str_replace('-', '/', $request->end_date); $event->start_time = $request->start_time; $event->end_time = $request->end_time; $event->save(); $event->locations->number = $request->number; $event->locations->street = $request->street; $event->locations->suburb = $request->suburb; $event->locations->area = $request->area; $event->locations->country = $request->country; $event->locations->location_map = $request->number . '+' . $request->street . ',+' . $request->suburb . ',+' . $request->area . ',+' . $request->country; $event->locations->location_map = str_replace(' ', '+', $event->locations->location_map); $event->locations->save(); $original = 'img/site/original/'; $sliderPath = 'img/site/slider/'; $galleryThumbPath = 'img/site/gallery/thumbnail/'; $galleryPrevPath = 'img/site/gallery/preview/'; $thumbnail = 'img/site/thumbnail/'; if ($request->hasFile('image')) { $counter = 0; foreach ($request->file('image') as $image) { $fileName = uniqid() . '.' . $request->file('image')[$counter]->getClientOriginalName(); $imageSource = \Image::make($request->file('image')[$counter]); $imageSource->save($original . $fileName); \Image::make($request->file('image')[$counter])->resize(1000, null, function ($constraint) { $constraint->aspectRatio(); })->save($galleryPrevPath . $fileName, 80); \Image::make($request->file('image')[$counter])->resize(1000, null, function ($constraint) { $constraint->aspectRatio(); })->crop(1000, 400, 0, 0)->save($sliderPath . $fileName, 80); \Image::make($request->file('image')[$counter])->fit(100, 100)->save($galleryThumbPath . $fileName, 80); \Image::make($request->file('image')[$counter])->fit(250, 150)->save($thumbnail . $fileName, 80); $imagedb = new Image(); $eventImage = new EventImage(); $imagedb->image = $fileName; $imagedb->save(); $eventImage->image_id = $imagedb->id; $eventImage->event_id = $event->id; $eventImage->save(); $counter++; } } if (count($request->currentImage) > 0) { foreach ($request->currentImage as $checked) { $imagedb = Image::where('id', $checked)->first(); \File::delete([$sliderPath . $imagedb->image, $galleryPrevPath . $imagedb->image, $galleryThumbPath . $imagedb->image, $thumbnail . $imagedb->image, $original . $imagedb->image]); EventImage::where('event_id', $event->id)->where('image_id', $checked)->delete(); $imagedb->delete(); } } } elseif ($type == 'page') { $event->content = $request->content; $event->save(); } } elseif ($type == 'staff') { try { $event = Staff::where('slug', $id)->firstOrFail(); } catch (\Illuminate\Database\Eloquent\ModelNotFoundException $e) { return view('errors.pageNotFound'); } $event->title = $request->title; $event->name = $request->name; $event->slug = strtolower(trim(preg_replace('/[^A-Za-z0-9-]+/', '-', $event->name))); $original = 'img/site/original/'; $staff = 'img/site/staff/'; if ($request->hasFile('photo')) { if ($event->image != 'default.png') { \File::delete([$original . $event->image, $staff . $event->image]); } $fileName = uniqid() . '.' . $request->file('photo')->getClientOriginalName(); $imageSource = \Image::make($request->file('photo')); $imageSource->save($original . $fileName); \Image::make($request->file('photo'))->fit(190, 190)->save($staff . $fileName, 80); $event->image = $fileName; } $event->save(); return redirect('/admin/' . $type . '/'); } elseif ($type == 'video') { try { $event = Video::where('slug', $id)->firstOrFail(); } catch (\Illuminate\Database\Eloquent\ModelNotFoundException $e) { return view('errors.pageNotFound'); } $event->title = $request->title; $event->description = $request->description; $event->player = $request->player; if ($request->player == 'youtube') { $event->video = substr($request->video, -11); } elseif ($request->player == 'vimeo') { $event->video = substr($request->video, -9); } $event->slug = strtolower(trim(preg_replace('/[^A-Za-z0-9-]+/', '-', $event->title))); $event->save(); return redirect('/admin/' . $type . '/'); } else { return view('errors.404'); } if (isset($request->preview)) { return redirect('/' . $type . '/' . $event->slug); } else { return redirect('/admin/' . $type . '/' . $event->slug . '/edit'); } }
public function getuserinfodelete($uid) { $deleteUserInfo = Staff::where('institute_code', '=', Auth::user()->institute_id)->Where('id', '=', $uid)->delete(); //$deleteUserInfo=Staff::where('institute_code', '=', Auth::user()->institute_id)->Where('id', '=', $uid)->delete(); return Redirect::to('user/index'); }
/** * Update the specified resource in storage. * * @param Request $request * @param int $id * @return Response */ public function update(Request $request, $slug) { //validation $this->validate($request, ['first_name' => 'required|min:2|max:20', 'last_name' => 'required|min:2|max:30', 'age' => 'required|between:0,130|integer', 'profile_image' => 'image|between:1,2000']); //Find the staff member to edit $staffMember = \App\Staff::where('slug', $slug)->firstOrFail(); $staffMember->first_name = $request->first_name; $staffMember->last_name = $request->last_name; $staffMember->age = $request->age; $staffMember->slug = str_slug($request->first_name . ' ' . $request->last_name); //if the user provided the new image if ($request->hasFile('profile_image')) { //generate a new file name and extention $fileExtension = $request->file('profile_image')->getClientOriginalExtension(); $fileName = 'staff-' . uniqid() . '.' . $fileExtension; //move file in to its destination $request->file('profile_image')->move('img/staff/', $fileName); \Image::make('img/staff/' . $fileName)->resize(240, null, function ($constraint) { $constraint->aspectRatio(); })->save('img/staff/' . $fileName); //delete the old image \File::Delete('img/staff/' . $staffMember->profile_image); //tell the database of the new image $staffMember->profile_image = $fileName; } $staffMember->save(); return redirect('about/' . $staffMember->slug); }
/** * Handles the withdrawal of activity from user. * * @param \Illuminate\Http\Request $request * @return JSON array with Status */ public function withdraw(Request $request) { if ($request->get('volunteer_id') == null || $request->get('activity_id') == null) { $status = ["Missing parameter"]; return response()->json(compact('status')); } else { $volunteer_id = $request->get('volunteer_id'); $activity_id = $request->get('activity_id'); $volunteer = Volunteer::findOrFail($volunteer_id); $withdrawnActivity = Activity::findOrFail($activity_id); $task = Task::where('volunteer_id', $volunteer_id)->where('activity_id', $activity_id)->update(['approval' => 'withdrawn']); $mailingList = Staff::where('is_admin', 'TRUE')->lists('email')->toArray(); $status = ["Withdrawn from activity"]; Mail::send('emails.volunteer_withdraw', compact('volunteer', 'withdrawnActivity'), function ($message) use($mailingList) { $message->subject('A volunteer has withdrawn from an activity'); $message->to($mailingList); }); return response()->json(compact('status')); } }
/** * Display the specified resource. * * @param int $id * @return Response */ public function show($id) { $staff = Staff::where('user_id', '=', $id)->firstOrFail(); $title = $staff->firstname . "" . $staff->lastname; return view('admin.show')->with('staff', $staff)->with('title', $title); }