public function getLeavesListPdf($id) { $audit = AuditTrail::create(['user_id' => Auth::id(), 'role' => 'Employee Management Admin', 'action' => 'printed Leave balances of All employees.']); if ($id == "*") { $users = User::all(); } else { $users = User::where('department_id', $id)->get(); } Fpdf::AddPage(); Fpdf::Image('img/dap.jpg', 40, 0, 150); Fpdf::Ln(35); Fpdf::SetFont('Arial', 'B', 11); Fpdf::SetTextColor(0, 0, 0); Fpdf::Cell(300, 20, 'Date Generated: ' . date("F j, Y"), 0, 2, 'C', 0); Fpdf::Cell(18, 7, 'Leave List', 0, 2, 'C', 0); Fpdf::SetFont('Arial', 'B', 7); Fpdf::SetTextColor(0, 0, 0); Fpdf::Cell(18, 7, 'ID', 1); Fpdf::Cell(24, 7, 'Name', 1); Fpdf::Cell(30, 7, 'Department', 1); Fpdf::Cell(9, 7, 'VL', 1); Fpdf::Cell(9, 7, 'SL', 1); Fpdf::Cell(9, 7, 'PL', 1); Fpdf::Cell(9, 7, 'ML', 1); Fpdf::Cell(9, 7, 'BL', 1); Fpdf::Ln(); Fpdf::SetFont('Arial', '', 7); foreach ($users as $user) { Fpdf::Cell(18, 7, $user->id, 1); Fpdf::Cell(24, 7, $user->firstname, 1); Fpdf::Cell(30, 7, $user->department->name, 1); $leaves = LeaveBalance::where('user_id', $user->id)->get(); foreach ($leaves as $leave) { Fpdf::Cell(9, 7, $leave->balance, 1); } Fpdf::Ln(); } Fpdf::SetY(-35); Fpdf::AliasNbPages('{nb}'); Fpdf::SetFont('Arial', 'I', 10); Fpdf::SetTextColor(0, 0, 0); Fpdf::Cell(0, 10, 'Page ' . Fpdf::PageNo() . '/{nb}', 0, 0, 'C'); Fpdf::Output(); exit; }
public function getPerfReportsPdf() { $deptL = Session::get('deptpdf'); $sem = Session::get('sempdf'); $year = Session::get('yearpdf'); if ($deptL == 'All') { $deptL = '*'; } //------------------------------ if ($sem == 'All') { $sem = '*'; } $users = 'Performance'; $matchThese = array(); //If user chooses from dropdown if ($deptL != "*") { //If true insert this to variable $matchThese = array_add($matchThese, 'dept_id', $deptL); /***********Add Array*****************/ //If user chooses from dropdown if ($sem != "*") { //If true insert this to variable $matchThese = array_add($matchThese, 'semester', $sem); if ($year != "All") { $matchThese = array_add($matchThese, 'year', $year); $query = $users::where($matchThese)->orderBy('overall', 'desc')->get(); } else { $query = $users::where($matchThese)->orderBy('overall', 'desc')->get(); } } else { //===========Else of Semester if ($year != "All") { $matchThese = array_add($matchThese, 'year', $year); $query = $users::where($matchThese)->orderBy('overall', 'desc')->get(); } else { //===========Else of Year $query = $users::where($matchThese)->orderBy('overall', 'desc')->get(); } $query = $users::where($matchThese)->orderBy('overall', 'desc')->get(); } /***********End Add Array*****************/ } else { //===========Else of Department /*************Add Array***************/ if ($sem != "*") { //If true insert this to variable $matchThese = array_add($matchThese, 'semester', $sem); if ($year != "All") { $matchThese = array_add($matchThese, 'year', $year); $query = $users::where($matchThese)->orderBy('overall', 'desc')->get(); } else { $query = $users::where($matchThese)->orderBy('overall', 'desc')->get(); } } else { //===========Else of Semester if ($year != "All") { $matchThese = array_add($matchThese, 'year', $year); $query = $users::where($matchThese)->orderBy('overall', 'desc')->get(); } else { //===========Else of Year $query = $users::all(); } } /************End Add Array****************/ } Fpdf::AddPage(); Fpdf::PageNo(); Fpdf::AliasNbPages(); Fpdf::Image('img/dap.jpg', 10, 5, 150); Fpdf::Ln(5); Fpdf::SetFont('Arial', 'B', 8); Fpdf::Cell(300, 20, 'Date Generated: ' . date("Y/m/d"), 0, 2, 'C', 0); Fpdf::Cell(30, 10, 'Performance Results', 0, 2, 'C', 0); if ($deptL == '*') { Fpdf::Cell(22, 10, 'Department: All', 0, 2, 'C', 0); } else { $filterDepartment = Department::where('id', $deptL)->first(); Fpdf::Cell(30, 10, 'Department: ' . $filterDepartment->name, 0, 2, 'C', 0); } //------------------------------ if ($sem == '*') { Fpdf::Cell(22, 10, 'Semester: All', 0, 2, 'C', 0); } else { Fpdf::Cell(30, 10, 'Semester: ' . $sem, 0, 2, 'C', 0); } if ($year == 'All') { Fpdf::Cell(30, 10, 'Year: All', 0, 2, 'C', 0); } else { Fpdf::Cell(30, 10, 'Year: ' . $year, 0, 2, 'C', 0); } Fpdf::SetFont('Arial', 'B', 5.5); Fpdf::Cell(5, 5, 'Id', 1, 0, 'C', 0); Fpdf::Cell(24.5, 5, 'Employee Name', 1, 0, 'C', 0); Fpdf::Cell(24.5, 5, 'Department', 1, 0, 'C', 0); Fpdf::SetFillColor(51, 51, 225); Fpdf::SetTextColor(0, 0, 0); Fpdf::Cell(25, 5, 'Utilities', 1, 0, 'C', true); Fpdf::Cell(25, 5, 'Quality of Work', 1, 0, 'C', true); Fpdf::Cell(30, 5, 'Potential for future performance', 1, 0, 'C', true); Fpdf::SetFillColor(96, 96, 96); Fpdf::Cell(25, 5, 'Overall Rating', 1, 0, 'C', true); Fpdf::Cell(15, 5, 'Semester', 1, 0, 'C', 0); Fpdf::Cell(16, 5, 'Year', 1, 0, 'C', 0); Fpdf::Ln(); foreach ($query as $perf) { Fpdf::Cell(5, 5, $perf->user->id, 1, 0, 'C', 0); Fpdf::Cell(24.5, 5, $perf->user->formatName(':ln, :fn :mi'), 1, 0, 'C', 0); $department = Department::where('id', $perf->dept_id)->first(); Fpdf::Cell(24.5, 5, $department->name, 1, 0, 'C', 0); Fpdf::SetFillColor(204, 229, 225); Fpdf::Cell(5, 5, $perf->utilities, 1, 0, 'C', true); Fpdf::Cell(20, 5, $perf->equivalent('utilities')->description, 1, 0, 'C', true); Fpdf::Cell(5, 5, $perf->workQuality, 1, 0, 'C', true); Fpdf::Cell(20, 5, $perf->equivalent('workQuality')->description, 1, 0, 'C', true); Fpdf::Cell(5, 5, $perf->potential, 1, 0, 'C', true); Fpdf::Cell(25, 5, $perf->equivalent('potential')->description, 1, 0, 'C', true); $u = $perf->utilities; $qow = $perf->workQuality; $pffp = $perf->potential; $overall = number_format(($u + $qow + $pffp) / 3, 2); $rating = ParRatingsRef::where('upper_limit', '>=', $overall)->where('lower_limit', '<=', $overall)->first(); $overpercent = number_format($overall / 6 * 100, 2); Fpdf::SetFillColor(192, 192, 192); Fpdf::Cell(20, 5, $overall, 1, 0, 'C', true); Fpdf::Cell(5, 5, $rating->adjectival, 1, 0, 'C', true); Fpdf::Cell(15, 5, $perf->semester, 1, 0, 'C', 0); Fpdf::Cell(16, 5, $perf->year, 1, 0, 'C', 0); Fpdf::Ln(); } Fpdf::SetY(-30.5); Fpdf::SetFont('Arial', 'I', 6); Fpdf::SetTextColor(0, 0, 0); Fpdf::Cell(0, 10, 'Page ' . Fpdf::PageNo() . "/{nb}", 0, 0, 'C'); Fpdf::Output(); exit; Session::forget('deptpdf'); Session::forget('sempdf'); Session::forget('yearpdf'); }
public function getViewResultsPdf($id) { $result = Performance::find($id); $perf = Performance::find($id); $user = Performance::find($id); $rating = Performance::find($id); $u = $perf->utilities; $qow = $perf->workQuality; $pffp = $perf->potential; $overall = number_format(($u + $qow + $pffp) / 3, 2); $rating = ParRatingsRef::where('upper_limit', '>=', $overall)->where('lower_limit', '<=', $overall)->first(); $overpercent = number_format($overall / 6 * 100, 2); $department = Department::where('id', $perf->dept_id)->first(); Fpdf::AddPage(); Fpdf::PageNo(); Fpdf::AliasNbPages('{nb}'); Fpdf::Image('img/dap.jpg', 40, 0, 150); Fpdf::Ln(30); Fpdf::SetFont('Arial', 'B', 11); Fpdf::SetTextColor(0, 0, 0); Fpdf::Cell(300, 20, 'Date Generated: ' . date("F j, Y"), 0, 2, 'C', 0); Fpdf::SetFont('Arial', 'B', 15); Fpdf::Cell(0, 0, 'Performance Evaluation', 0, 1, 'L', 0); Fpdf::Ln(8); Fpdf::SetFont('Arial', 'B', 11); Fpdf::Cell(0, 0, 'Name: ' . $perf->user->formatName(':ln, :fn :mn'), 0, 1, 'L', 0); Fpdf::Ln(8); Fpdf::Cell(0, 0, 'Department: ' . $department->name, 0, 1, 'L', 0); Fpdf::Ln(8); Fpdf::Cell(0, 0, 'Semester: ' . $perf->semester, 0, 1, 'L', 0); Fpdf::Ln(10); Fpdf::SetFont('Arial', '', 20); Fpdf::SetDrawColor(224, 224, 224); Fpdf::SetFillColor(51, 51, 225); Fpdf::SetTextColor(255, 255, 255); Fpdf::Cell(110, 10, 'Utilities', 1, 1, 'C', true); Fpdf::SetFont('Arial', 'B', 7); Fpdf::SetFillColor(204, 229, 225); Fpdf::SetTextColor(96, 96, 96); Fpdf::Cell(50, 10, 'Intra-group Involvements', 1, 0, 'C', true); Fpdf::Cell(20, 10, $result->util1, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('util1')->adjectival, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('util1')->description, 1, 1, 'C', 0); Fpdf::Cell(50, 10, 'Inter-group Involvements', 1, 0, 'C', true); Fpdf::Cell(20, 10, $result->util2, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('util2')->adjectival, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('util2')->description, 1, 1, 'C', 0); Fpdf::Cell(50, 10, 'Committee Work', 1, 0, 'C', true); Fpdf::Cell(20, 10, $result->util3, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('util3')->adjectival, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('util3')->description, 1, 1, 'C', 0); Fpdf::SetTextColor(204, 0, 0); Fpdf::Cell(50, 10, 'Average Rating', 1, 0, 'C', true); Fpdf::Cell(20, 10, $result->util_overall, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('utilities')->adjectival, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('utilities')->description, 1, 1, 'C', 0); //Quality of work table Fpdf::Ln(10); Fpdf::SetFont('Arial', '', 20); Fpdf::SetDrawColor(224, 224, 224); Fpdf::SetFillColor(51, 51, 225); Fpdf::SetTextColor(255, 255, 255); Fpdf::Cell(110, 10, 'Quality of Work', 1, 2, 'C', true); Fpdf::SetFont('Arial', 'B', 7); Fpdf::SetFillColor(204, 229, 225); Fpdf::SetTextColor(96, 96, 96); Fpdf::Cell(50, 10, 'Relevance to Project/unit objectives', 1, 0, 'C', true); Fpdf::Cell(20, 10, $result->qow1, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('qow1')->adjectival, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('qow1')->description, 1, 1, 'C', 0); Fpdf::Cell(50, 10, 'Timeliness', 1, 0, 'C', true); Fpdf::Cell(20, 10, $result->qow2, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('qow2')->adjectival, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('qow2')->description, 1, 1, 'C', 0); Fpdf::Cell(50, 10, 'Thoroughness', 1, 0, 'C', true); Fpdf::Cell(20, 10, $result->qow3, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('qow3')->adjectival, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('qow3')->description, 1, 1, 'C', 0); Fpdf::Cell(50, 10, 'High-Rate', 1, 0, 'C', true); Fpdf::Cell(20, 10, $result->qow4, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('qow4')->adjectival, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('qow4')->description, 1, 1, 'C', 0); Fpdf::Cell(50, 10, 'Accuracy', 1, 0, 'C', true); Fpdf::Cell(20, 10, $result->qow5, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('qow5')->adjectival, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('qow5')->description, 1, 1, 'C', 0); Fpdf::Cell(50, 10, 'Foresight', 1, 0, 'C', true); Fpdf::Cell(20, 10, $result->qow6, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('qow6')->adjectival, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('qow6')->description, 1, 1, 'C', 0); Fpdf::Cell(50, 10, 'Neatness and Presentability', 1, 0, 'C', true); Fpdf::Cell(20, 10, $result->qow7, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('qow7')->adjectival, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('qow7')->description, 1, 1, 'C', 0); Fpdf::Cell(50, 10, 'Cost-effectiveness', 1, 0, 'C', true); Fpdf::Cell(20, 10, $result->qow8, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('qow8')->adjectival, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('qow8')->description, 1, 1, 'C', 0); Fpdf::SetTextColor(204, 0, 0); Fpdf::Cell(50, 10, 'Average Rating', 1, 0, 'C', true); Fpdf::Cell(20, 10, $result->qow_overall, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('qow_overall')->adjectival, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('qow_overall')->description, 1, 1, 'C', 0); //Potential for Future Performance table Fpdf::Ln(10); Fpdf::SetFont('Arial', '', 20); Fpdf::SetDrawColor(224, 224, 224); Fpdf::SetFillColor(51, 51, 225); Fpdf::SetTextColor(255, 255, 255); Fpdf::Cell(110, 10, 'Potential for Future Performance', 1, 2, 'C', true); Fpdf::SetFont('Arial', 'B', 7); Fpdf::SetFillColor(204, 229, 225); Fpdf::SetTextColor(96, 96, 96); Fpdf::Cell(50, 10, 'Appropriate Expertise', 1, 0, 'C', true); Fpdf::Cell(20, 10, $result->pffp1, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('pffp1')->adjectival, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('pffp1')->description, 1, 1, 'C', 0); Fpdf::Cell(50, 10, 'Professional Interest', 1, 0, 'C', true); Fpdf::Cell(20, 10, $result->pffp2, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('pffp2')->adjectival, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('pffp2')->description, 1, 1, 'C', 0); Fpdf::Cell(50, 10, 'Ability to Learn', 1, 0, 'C', true); Fpdf::Cell(20, 10, $result->pffp3, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('pffp3')->adjectival, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('pffp3')->description, 1, 1, 'C', 0); Fpdf::Cell(50, 10, 'Professional Integrity ', 1, 0, 'C', true); Fpdf::Cell(20, 10, $result->pffp4, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('pffp4')->adjectival, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('pffp4')->description, 1, 1, 'C', 0); Fpdf::Cell(50, 10, 'Work standards ', 1, 0, 'C', true); Fpdf::Cell(20, 10, $result->pffp5, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('pffp5')->adjectival, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('pffp5')->description, 1, 1, 'C', 0); Fpdf::Cell(50, 10, 'Innovativeness ', 1, 0, 'C', true); Fpdf::Cell(20, 10, $result->pffp6, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('pffp6')->adjectival, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('pffp6')->description, 1, 1, 'C', 0); Fpdf::Cell(50, 10, 'Maturity ', 1, 0, 'C', true); Fpdf::Cell(20, 10, $result->pffp7, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('pffp7')->adjectival, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('pffp7')->description, 1, 1, 'C', 0); Fpdf::Cell(50, 10, 'Collaboration ', 1, 0, 'C', true); Fpdf::Cell(20, 10, $result->pffp8, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('pffp8')->adjectival, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('pffp8')->description, 1, 1, 'C', 0); Fpdf::Cell(50, 10, 'Initiative', 1, 0, 'C', true); Fpdf::Cell(20, 10, $result->pffp9, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('pffp9')->adjectival, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('pffp9')->description, 1, 1, 'C', 0); Fpdf::Cell(50, 10, 'Responsiveness', 1, 0, 'C', true); Fpdf::Cell(20, 10, $result->pffp10, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('pffp10')->adjectival, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('pffp10')->description, 1, 1, 'C', 0); Fpdf::Cell(50, 10, 'Adaptability and Consistent track record ', 1, 0, 'C', true); Fpdf::Cell(20, 10, $result->pffp11, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('pffp11')->adjectival, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('pffp11')->description, 1, 1, 'C', 0); Fpdf::SetTextColor(204, 0, 0); Fpdf::Cell(50, 10, 'Average Rating', 1, 0, 'C', true); Fpdf::Cell(20, 10, $result->pffp_overall, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('pffp_overall')->adjectival, 1, 0, 'C', 0); Fpdf::Cell(20, 10, $perf->equivalent('pffp_overall')->description, 1, 1, 'C', 0); //Overall Rating table Fpdf::Ln(10); Fpdf::SetFont('Arial', '', 20); Fpdf::SetDrawColor(224, 224, 224); Fpdf::SetFillColor(51, 51, 225); Fpdf::SetTextColor(255, 255, 255); Fpdf::Cell(140, 10, 'Overall Rating', 1, 2, 'C', true); Fpdf::SetFont('Arial', 'B', 7); Fpdf::SetFillColor(204, 229, 225); Fpdf::SetTextColor(96, 96, 96); Fpdf::Cell(30, 10, 'Superior Remarks', 1, 0, 'C', true); Fpdf::Cell(110, 10, $perf->comments, 1, 1, 'C', 0); Fpdf::Cell(30, 10, 'Overall rating', 1, 0, 'C', true); Fpdf::Cell(30, 10, $result->overall, 1, 0, 'C', 0); Fpdf::Cell(30, 10, $rating->adjectival, 1, 0, 'C', 0); Fpdf::Cell(50, 10, $rating->description, 1, 0, 'C', 0); Fpdf::SetY(-35); Fpdf::AliasNbPages('{nb}'); Fpdf::SetFont('Arial', 'I', 10); Fpdf::SetTextColor(0, 0, 0); Fpdf::Cell(0, 10, 'Page ' . Fpdf::PageNo() . '/{nb}', 0, 0, 'C'); Fpdf::Output(); exit; }