public function postReviewEvaluation($id)
 {
     $perf = Performance::find(Input::get('id'));
     $user = User::find($perf->user_id);
     if (!$perf) {
         App::abort(404);
     }
     $rules = Performance::$rules;
     unset($rules['semester']);
     $validator = Validator::make(Input::all(), $rules);
     if ($validator->fails()) {
         return Redirect::route('perf-reviewevaluation', $perf->id)->withErrors($validator)->withInput();
     }
     $u = $perf->utilities;
     $qow = $perf->workQuality;
     $pffp = $perf->potential;
     $overall = number_format(($u + $qow + $pffp) / 3, 2);
     $perf->update(['util1' => Input::get('util1'), 'util2' => Input::get('util2'), 'util3' => Input::get('util3'), 'util_overall' => $u, 'qow1' => Input::get('qow1'), 'qow2' => Input::get('qow2'), 'qow3' => Input::get('qow3'), 'qow4' => Input::get('qow4'), 'qow5' => Input::get('qow5'), 'qow6' => Input::get('qow6'), 'qow7' => Input::get('qow7'), 'qow8' => Input::get('qow8'), 'qow_overall' => $qow, 'pffp1' => Input::get('pffp1'), 'pffp2' => Input::get('pffp2'), 'pffp3' => Input::get('pffp3'), 'pffp4' => Input::get('pffp4'), 'pffp5' => Input::get('pffp5'), 'pffp6' => Input::get('pffp6'), 'pffp7' => Input::get('pffp7'), 'pffp8' => Input::get('pffp8'), 'pffp9' => Input::get('pffp9'), 'pffp10' => Input::get('pffp10'), 'pffp11' => Input::get('pffp11'), 'pffp_overall' => $pffp, 'overall' => $overall, 'comments' => Input::get('comments'), 'status' => 'Finalized']);
     $audit = AuditTrail::create(['user_id' => Auth::id(), 'role' => 'Performance System Admin', 'action' => 'finalized ' . $user->formatName(':fn :ln') . '\'s Evaluation.']);
     return Redirect::route('perf-receivedevaluation')->with('alert', 'success|Employee evaluation has been finalized');
 }
 public function run()
 {
     $faker = Faker\Factory::create();
     //=================================== For single user and no loop==================//
     /*			Performance::create([
     				'user_id'	=> 2,
     				'dept_id'=> 1,
     				'util1'	 	=> $faker->numberBetween($min = 1, $max = 5),
     				'util2'	 	=> $faker->numberBetween($min = 1, $max = 5),
     				'util3'	 	=> $faker->numberBetween($min = 1, $max = 5),
     				'qow1'	 	=> $faker->numberBetween($min = 1, $max = 5),
     				'qow2'		=> $faker->numberBetween($min = 1, $max = 5),
     				'qow3'		=> $faker->numberBetween($min = 1, $max = 5),
     				'qow4'      => $faker->numberBetween($min = 1, $max = 5),
     				'qow5'		=> $faker->numberBetween($min = 1, $max = 5),
     				'qow6'		=> $faker->numberBetween($min = 1, $max = 5),
     				'qow7'		=> $faker->numberBetween($min = 1, $max = 5),
     				'qow8'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp1'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp2'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp3'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp4'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp5'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp6'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp7'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp8'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp9'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp10'	=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp11'	=> $faker->numberBetween($min = 1, $max = 5),
     				'comments'	=> $faker->text(100),
     				'status'	=>	'Finalized',
     				'semester'	=>	'2nd',
     				'year'		=>	'2015'
     
     
     
     			]);
     
     
     			Performance::create([
     				'user_id'	=> 2,
     				'dept_id'	=> 1,
     				'util1'	 	=> $faker->numberBetween($min = 1, $max = 5),
     				'util2'	 	=> $faker->numberBetween($min = 1, $max = 5),
     				'util3'	 	=> $faker->numberBetween($min = 1, $max = 5),
     				'qow1'	 	=> $faker->numberBetween($min = 1, $max = 5),
     				'qow2'		=> $faker->numberBetween($min = 1, $max = 5),
     				'qow3'		=> $faker->numberBetween($min = 1, $max = 5),
     				'qow4'      => $faker->numberBetween($min = 1, $max = 5),
     				'qow5'		=> $faker->numberBetween($min = 1, $max = 5),
     				'qow6'		=> $faker->numberBetween($min = 1, $max = 5),
     				'qow7'		=> $faker->numberBetween($min = 1, $max = 5),
     				'qow8'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp1'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp2'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp3'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp4'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp5'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp6'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp7'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp8'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp9'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp10'	=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp11'	=> $faker->numberBetween($min = 1, $max = 5),
     				'comments'	=> $faker->text(100),
     				'status'	=>	'Finalized',
     				'semester'	=>	'1st',
     				'year'		=>	'2015'
     
     
     
     			]);
     
     
     			Performance::create([
     				'user_id'	=> 4,
     				'dept_id'	=> 2,
     				'util1'	 	=> $faker->numberBetween($min = 1, $max = 5),
     				'util2'	 	=> $faker->numberBetween($min = 1, $max = 5),
     				'util3'	 	=> $faker->numberBetween($min = 1, $max = 5),
     				'qow1'	 	=> $faker->numberBetween($min = 1, $max = 5),
     				'qow2'		=> $faker->numberBetween($min = 1, $max = 5),
     				'qow3'		=> $faker->numberBetween($min = 1, $max = 5),
     				'qow4'      => $faker->numberBetween($min = 1, $max = 5),
     				'qow5'		=> $faker->numberBetween($min = 1, $max = 5),
     				'qow6'		=> $faker->numberBetween($min = 1, $max = 5),
     				'qow7'		=> $faker->numberBetween($min = 1, $max = 5),
     				'qow8'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp1'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp2'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp3'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp4'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp5'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp6'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp7'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp8'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp9'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp10'	=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp11'	=> $faker->numberBetween($min = 1, $max = 5),
     				'comments'	=> $faker->text(100),
     				'status'	=>	'Finalized',
     				'semester'	=>	'2nd',
     				'year'		=>	'2015'
     
     
     
     			]);
     
     
     			Performance::create([
     				'user_id'	=> 4,
     				'dept_id'	=> 2,
     				'util1'	 	=> $faker->numberBetween($min = 1, $max = 5),
     				'util2'	 	=> $faker->numberBetween($min = 1, $max = 5),
     				'util3'	 	=> $faker->numberBetween($min = 1, $max = 5),
     				'qow1'	 	=> $faker->numberBetween($min = 1, $max = 5),
     				'qow2'		=> $faker->numberBetween($min = 1, $max = 5),
     				'qow3'		=> $faker->numberBetween($min = 1, $max = 5),
     				'qow4'      => $faker->numberBetween($min = 1, $max = 5),
     				'qow5'		=> $faker->numberBetween($min = 1, $max = 5),
     				'qow6'		=> $faker->numberBetween($min = 1, $max = 5),
     				'qow7'		=> $faker->numberBetween($min = 1, $max = 5),
     				'qow8'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp1'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp2'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp3'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp4'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp5'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp6'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp7'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp8'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp9'		=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp10'	=> $faker->numberBetween($min = 1, $max = 5),
     				'pffp11'	=> $faker->numberBetween($min = 1, $max = 5),
     				'comments'	=> $faker->text(100),
     				'status'	=>	'Finalized',
     				'semester'	=>	'1st',
     				'year'		=>	'2015'
     
     
     
     			]);
     */
     //================================================================================================//
     for ($id = 2; $id < 5; $id++) {
         $user = User::find($id);
         Performance::create(['user_id' => $id, 'dept_id' => $user->department_id, 'util1' => $faker->numberBetween($min = 4, $max = 6), 'util2' => $faker->numberBetween($min = 4, $max = 6), 'util3' => $faker->numberBetween($min = 4, $max = 6), 'qow1' => $faker->numberBetween($min = 4, $max = 6), 'qow2' => $faker->numberBetween($min = 4, $max = 6), 'qow3' => $faker->numberBetween($min = 4, $max = 6), 'qow4' => $faker->numberBetween($min = 4, $max = 6), 'qow5' => $faker->numberBetween($min = 4, $max = 6), 'qow6' => $faker->numberBetween($min = 4, $max = 6), 'qow7' => $faker->numberBetween($min = 4, $max = 6), 'qow8' => $faker->numberBetween($min = 4, $max = 6), 'pffp1' => $faker->numberBetween($min = 4, $max = 6), 'pffp2' => $faker->numberBetween($min = 4, $max = 6), 'pffp3' => $faker->numberBetween($min = 4, $max = 6), 'pffp4' => $faker->numberBetween($min = 4, $max = 6), 'pffp5' => $faker->numberBetween($min = 4, $max = 6), 'pffp6' => $faker->numberBetween($min = 4, $max = 6), 'pffp7' => $faker->numberBetween($min = 4, $max = 6), 'pffp8' => $faker->numberBetween($min = 4, $max = 6), 'pffp9' => $faker->numberBetween($min = 4, $max = 6), 'pffp10' => $faker->numberBetween($min = 4, $max = 6), 'pffp11' => $faker->numberBetween($min = 4, $max = 6), 'comments' => $faker->text(100), 'status' => 'Finalized', 'semester' => '1st', 'year' => '2015']);
     }
     for ($id = 2; $id < 5; $id++) {
         $user = User::find($id);
         Performance::create(['user_id' => $id, 'dept_id' => $user->department_id, 'util1' => $faker->numberBetween($min = 5, $max = 6), 'util2' => $faker->numberBetween($min = 5, $max = 6), 'util3' => $faker->numberBetween($min = 5, $max = 6), 'qow1' => $faker->numberBetween($min = 5, $max = 6), 'qow2' => $faker->numberBetween($min = 5, $max = 6), 'qow3' => $faker->numberBetween($min = 5, $max = 6), 'qow4' => $faker->numberBetween($min = 5, $max = 6), 'qow5' => $faker->numberBetween($min = 5, $max = 6), 'qow6' => $faker->numberBetween($min = 5, $max = 6), 'qow7' => $faker->numberBetween($min = 5, $max = 6), 'qow8' => $faker->numberBetween($min = 5, $max = 6), 'pffp1' => $faker->numberBetween($min = 5, $max = 6), 'pffp2' => $faker->numberBetween($min = 5, $max = 6), 'pffp3' => $faker->numberBetween($min = 5, $max = 6), 'pffp4' => $faker->numberBetween($min = 5, $max = 6), 'pffp5' => $faker->numberBetween($min = 5, $max = 6), 'pffp6' => $faker->numberBetween($min = 5, $max = 6), 'pffp7' => $faker->numberBetween($min = 5, $max = 6), 'pffp8' => $faker->numberBetween($min = 5, $max = 6), 'pffp9' => $faker->numberBetween($min = 5, $max = 6), 'pffp10' => $faker->numberBetween($min = 5, $max = 6), 'pffp11' => $faker->numberBetween($min = 5, $max = 6), 'comments' => $faker->text(100), 'status' => 'Finalized', 'semester' => '2nd', 'year' => '2015']);
     }
     for ($id = 2; $id < 5; $id++) {
         $user = User::find($id);
         Performance::create(['user_id' => $id, 'dept_id' => $user->department_id, 'util1' => $faker->numberBetween($min = 5, $max = 6), 'util2' => $faker->numberBetween($min = 5, $max = 6), 'util3' => $faker->numberBetween($min = 5, $max = 6), 'qow1' => $faker->numberBetween($min = 5, $max = 6), 'qow2' => $faker->numberBetween($min = 5, $max = 6), 'qow3' => $faker->numberBetween($min = 5, $max = 6), 'qow4' => $faker->numberBetween($min = 5, $max = 6), 'qow5' => $faker->numberBetween($min = 5, $max = 6), 'qow6' => $faker->numberBetween($min = 5, $max = 6), 'qow7' => $faker->numberBetween($min = 5, $max = 6), 'qow8' => $faker->numberBetween($min = 5, $max = 6), 'pffp1' => $faker->numberBetween($min = 5, $max = 6), 'pffp2' => $faker->numberBetween($min = 5, $max = 6), 'pffp3' => $faker->numberBetween($min = 5, $max = 6), 'pffp4' => $faker->numberBetween($min = 5, $max = 6), 'pffp5' => $faker->numberBetween($min = 5, $max = 6), 'pffp6' => $faker->numberBetween($min = 5, $max = 6), 'pffp7' => $faker->numberBetween($min = 5, $max = 6), 'pffp8' => $faker->numberBetween($min = 5, $max = 6), 'pffp9' => $faker->numberBetween($min = 5, $max = 6), 'pffp10' => $faker->numberBetween($min = 5, $max = 6), 'pffp11' => $faker->numberBetween($min = 5, $max = 6), 'comments' => $faker->text(100), 'status' => 'Finalized', 'semester' => '1st', 'year' => '2015']);
     }
     for ($id = 2; $id < 5; $id++) {
         $user = User::find($id);
         Performance::create(['user_id' => $id, 'dept_id' => $user->department_id, 'util1' => $faker->numberBetween($min = 5, $max = 6), 'util2' => $faker->numberBetween($min = 5, $max = 6), 'util3' => $faker->numberBetween($min = 5, $max = 6), 'qow1' => $faker->numberBetween($min = 5, $max = 6), 'qow2' => $faker->numberBetween($min = 5, $max = 6), 'qow3' => $faker->numberBetween($min = 5, $max = 6), 'qow4' => $faker->numberBetween($min = 5, $max = 6), 'qow5' => $faker->numberBetween($min = 5, $max = 6), 'qow6' => $faker->numberBetween($min = 5, $max = 6), 'qow7' => $faker->numberBetween($min = 5, $max = 6), 'qow8' => $faker->numberBetween($min = 5, $max = 6), 'pffp1' => $faker->numberBetween($min = 5, $max = 6), 'pffp2' => $faker->numberBetween($min = 5, $max = 6), 'pffp3' => $faker->numberBetween($min = 5, $max = 6), 'pffp4' => $faker->numberBetween($min = 5, $max = 6), 'pffp5' => $faker->numberBetween($min = 5, $max = 6), 'pffp6' => $faker->numberBetween($min = 5, $max = 6), 'pffp7' => $faker->numberBetween($min = 5, $max = 6), 'pffp8' => $faker->numberBetween($min = 5, $max = 6), 'pffp9' => $faker->numberBetween($min = 5, $max = 6), 'pffp10' => $faker->numberBetween($min = 5, $max = 6), 'pffp11' => $faker->numberBetween($min = 5, $max = 6), 'comments' => $faker->text(100), 'status' => 'Finalized', 'semester' => '2nd', 'year' => '2015']);
     }
     for ($id = 5; $id < 19; $id++) {
         $user = User::find($id);
         Performance::create(['user_id' => $id, 'dept_id' => $user->department_id, 'util1' => $faker->numberBetween($min = 1, $max = 6), 'util2' => $faker->numberBetween($min = 1, $max = 6), 'util3' => $faker->numberBetween($min = 1, $max = 6), 'qow1' => $faker->numberBetween($min = 1, $max = 6), 'qow2' => $faker->numberBetween($min = 1, $max = 6), 'qow3' => $faker->numberBetween($min = 1, $max = 4), 'qow4' => $faker->numberBetween($min = 1, $max = 4), 'qow5' => $faker->numberBetween($min = 1, $max = 4), 'qow6' => $faker->numberBetween($min = 1, $max = 4), 'qow7' => $faker->numberBetween($min = 1, $max = 4), 'qow8' => $faker->numberBetween($min = 1, $max = 2), 'pffp1' => $faker->numberBetween($min = 1, $max = 2), 'pffp2' => $faker->numberBetween($min = 1, $max = 2), 'pffp3' => $faker->numberBetween($min = 1, $max = 2), 'pffp4' => $faker->numberBetween($min = 1, $max = 2), 'pffp5' => $faker->numberBetween($min = 1, $max = 3), 'pffp6' => $faker->numberBetween($min = 1, $max = 3), 'pffp7' => $faker->numberBetween($min = 1, $max = 3), 'pffp8' => $faker->numberBetween($min = 1, $max = 3), 'pffp9' => $faker->numberBetween($min = 1, $max = 3), 'pffp10' => $faker->numberBetween($min = 1, $max = 4), 'pffp11' => $faker->numberBetween($min = 1, $max = 4), 'comments' => $faker->text(100), 'status' => 'Finalized', 'semester' => '1st', 'year' => '2015']);
     }
     for ($id = 5; $id < 19; $id++) {
         $user = User::find($id);
         Performance::create(['user_id' => $id, 'dept_id' => $user->department_id, 'util1' => $faker->numberBetween($min = 1, $max = 6), 'util2' => $faker->numberBetween($min = 1, $max = 6), 'util3' => $faker->numberBetween($min = 1, $max = 6), 'qow1' => $faker->numberBetween($min = 1, $max = 6), 'qow2' => $faker->numberBetween($min = 1, $max = 6), 'qow3' => $faker->numberBetween($min = 1, $max = 6), 'qow4' => $faker->numberBetween($min = 1, $max = 6), 'qow5' => $faker->numberBetween($min = 1, $max = 6), 'qow6' => $faker->numberBetween($min = 1, $max = 6), 'qow7' => $faker->numberBetween($min = 1, $max = 6), 'qow8' => $faker->numberBetween($min = 1, $max = 6), 'pffp1' => $faker->numberBetween($min = 1, $max = 6), 'pffp2' => $faker->numberBetween($min = 1, $max = 6), 'pffp3' => $faker->numberBetween($min = 1, $max = 6), 'pffp4' => $faker->numberBetween($min = 1, $max = 6), 'pffp5' => $faker->numberBetween($min = 1, $max = 6), 'pffp6' => $faker->numberBetween($min = 1, $max = 6), 'pffp7' => $faker->numberBetween($min = 1, $max = 6), 'pffp8' => $faker->numberBetween($min = 1, $max = 6), 'pffp9' => $faker->numberBetween($min = 1, $max = 6), 'pffp10' => $faker->numberBetween($min = 1, $max = 6), 'pffp11' => $faker->numberBetween($min = 1, $max = 6), 'comments' => $faker->text(100), 'status' => 'Finalized', 'semester' => '2nd', 'year' => '2015']);
     }
     for ($id = 2; $id < 5; $id++) {
         $user = User::find($id);
         Performance::create(['user_id' => $id, 'dept_id' => $user->department_id, 'util1' => $faker->numberBetween($min = 5, $max = 6), 'util2' => $faker->numberBetween($min = 5, $max = 6), 'util3' => $faker->numberBetween($min = 5, $max = 6), 'qow1' => $faker->numberBetween($min = 5, $max = 6), 'qow2' => $faker->numberBetween($min = 5, $max = 6), 'qow3' => $faker->numberBetween($min = 5, $max = 6), 'qow4' => $faker->numberBetween($min = 5, $max = 6), 'qow5' => $faker->numberBetween($min = 5, $max = 6), 'qow6' => $faker->numberBetween($min = 5, $max = 6), 'qow7' => $faker->numberBetween($min = 5, $max = 6), 'qow8' => $faker->numberBetween($min = 5, $max = 6), 'pffp1' => $faker->numberBetween($min = 5, $max = 6), 'pffp2' => $faker->numberBetween($min = 5, $max = 6), 'pffp3' => $faker->numberBetween($min = 5, $max = 6), 'pffp4' => $faker->numberBetween($min = 5, $max = 6), 'pffp5' => $faker->numberBetween($min = 5, $max = 6), 'pffp6' => $faker->numberBetween($min = 5, $max = 6), 'pffp7' => $faker->numberBetween($min = 5, $max = 6), 'pffp8' => $faker->numberBetween($min = 5, $max = 6), 'pffp9' => $faker->numberBetween($min = 5, $max = 6), 'pffp10' => $faker->numberBetween($min = 5, $max = 6), 'pffp11' => $faker->numberBetween($min = 5, $max = 6), 'comments' => $faker->text(100), 'status' => 'Finalized', 'semester' => '1st', 'year' => '2014']);
     }
     for ($id = 2; $id < 5; $id++) {
         $user = User::find($id);
         Performance::create(['user_id' => $id, 'dept_id' => $user->department_id, 'util1' => $faker->numberBetween($min = 5, $max = 6), 'util2' => $faker->numberBetween($min = 5, $max = 6), 'util3' => $faker->numberBetween($min = 5, $max = 6), 'qow1' => $faker->numberBetween($min = 5, $max = 6), 'qow2' => $faker->numberBetween($min = 5, $max = 6), 'qow3' => $faker->numberBetween($min = 5, $max = 6), 'qow4' => $faker->numberBetween($min = 5, $max = 6), 'qow5' => $faker->numberBetween($min = 5, $max = 6), 'qow6' => $faker->numberBetween($min = 5, $max = 6), 'qow7' => $faker->numberBetween($min = 5, $max = 6), 'qow8' => $faker->numberBetween($min = 5, $max = 6), 'pffp1' => $faker->numberBetween($min = 5, $max = 6), 'pffp2' => $faker->numberBetween($min = 5, $max = 6), 'pffp3' => $faker->numberBetween($min = 5, $max = 6), 'pffp4' => $faker->numberBetween($min = 5, $max = 6), 'pffp5' => $faker->numberBetween($min = 5, $max = 6), 'pffp6' => $faker->numberBetween($min = 5, $max = 6), 'pffp7' => $faker->numberBetween($min = 5, $max = 6), 'pffp8' => $faker->numberBetween($min = 5, $max = 6), 'pffp9' => $faker->numberBetween($min = 5, $max = 6), 'pffp10' => $faker->numberBetween($min = 5, $max = 6), 'pffp11' => $faker->numberBetween($min = 5, $max = 6), 'comments' => $faker->text(100), 'status' => 'Finalized', 'semester' => '2nd', 'year' => '2014']);
     }
     for ($id = 5; $id < 19; $id++) {
         $user = User::find($id);
         Performance::create(['user_id' => $id, 'dept_id' => $user->department_id, 'util1' => $faker->numberBetween($min = 1, $max = 6), 'util2' => $faker->numberBetween($min = 1, $max = 6), 'util3' => $faker->numberBetween($min = 1, $max = 6), 'qow1' => $faker->numberBetween($min = 1, $max = 6), 'qow2' => $faker->numberBetween($min = 1, $max = 6), 'qow3' => $faker->numberBetween($min = 1, $max = 4), 'qow4' => $faker->numberBetween($min = 1, $max = 4), 'qow5' => $faker->numberBetween($min = 1, $max = 4), 'qow6' => $faker->numberBetween($min = 1, $max = 4), 'qow7' => $faker->numberBetween($min = 1, $max = 4), 'qow8' => $faker->numberBetween($min = 1, $max = 2), 'pffp1' => $faker->numberBetween($min = 1, $max = 2), 'pffp2' => $faker->numberBetween($min = 1, $max = 2), 'pffp3' => $faker->numberBetween($min = 1, $max = 2), 'pffp4' => $faker->numberBetween($min = 1, $max = 2), 'pffp5' => $faker->numberBetween($min = 1, $max = 3), 'pffp6' => $faker->numberBetween($min = 1, $max = 3), 'pffp7' => $faker->numberBetween($min = 1, $max = 3), 'pffp8' => $faker->numberBetween($min = 1, $max = 3), 'pffp9' => $faker->numberBetween($min = 1, $max = 3), 'pffp10' => $faker->numberBetween($min = 1, $max = 4), 'pffp11' => $faker->numberBetween($min = 1, $max = 4), 'comments' => $faker->text(100), 'status' => 'Finalized', 'semester' => '1st', 'year' => '2014']);
     }
     for ($id = 5; $id < 19; $id++) {
         $user = User::find($id);
         Performance::create(['user_id' => $id, 'dept_id' => $user->department_id, 'util1' => $faker->numberBetween($min = 1, $max = 6), 'util2' => $faker->numberBetween($min = 1, $max = 6), 'util3' => $faker->numberBetween($min = 1, $max = 6), 'qow1' => $faker->numberBetween($min = 1, $max = 6), 'qow2' => $faker->numberBetween($min = 1, $max = 6), 'qow3' => $faker->numberBetween($min = 1, $max = 4), 'qow4' => $faker->numberBetween($min = 1, $max = 4), 'qow5' => $faker->numberBetween($min = 1, $max = 4), 'qow6' => $faker->numberBetween($min = 1, $max = 4), 'qow7' => $faker->numberBetween($min = 1, $max = 4), 'qow8' => $faker->numberBetween($min = 1, $max = 2), 'pffp1' => $faker->numberBetween($min = 1, $max = 2), 'pffp2' => $faker->numberBetween($min = 1, $max = 2), 'pffp3' => $faker->numberBetween($min = 1, $max = 2), 'pffp4' => $faker->numberBetween($min = 1, $max = 2), 'pffp5' => $faker->numberBetween($min = 1, $max = 3), 'pffp6' => $faker->numberBetween($min = 1, $max = 3), 'pffp7' => $faker->numberBetween($min = 1, $max = 3), 'pffp8' => $faker->numberBetween($min = 1, $max = 3), 'pffp9' => $faker->numberBetween($min = 1, $max = 3), 'pffp10' => $faker->numberBetween($min = 1, $max = 4), 'pffp11' => $faker->numberBetween($min = 1, $max = 4), 'comments' => $faker->text(100), 'status' => 'Finalized', 'semester' => '2nd', 'year' => '2014']);
     }
     for ($id = 5; $id < 19; $id++) {
         $user = User::find($id);
         Performance::create(['user_id' => $id, 'dept_id' => $user->department_id, 'util1' => $faker->numberBetween($min = 1, $max = 6), 'util2' => $faker->numberBetween($min = 1, $max = 6), 'util3' => $faker->numberBetween($min = 1, $max = 6), 'qow1' => $faker->numberBetween($min = 1, $max = 6), 'qow2' => $faker->numberBetween($min = 1, $max = 6), 'qow3' => $faker->numberBetween($min = 1, $max = 4), 'qow4' => $faker->numberBetween($min = 1, $max = 4), 'qow5' => $faker->numberBetween($min = 1, $max = 4), 'qow6' => $faker->numberBetween($min = 1, $max = 4), 'qow7' => $faker->numberBetween($min = 1, $max = 4), 'qow8' => $faker->numberBetween($min = 1, $max = 2), 'pffp1' => $faker->numberBetween($min = 1, $max = 2), 'pffp2' => $faker->numberBetween($min = 1, $max = 2), 'pffp3' => $faker->numberBetween($min = 1, $max = 2), 'pffp4' => $faker->numberBetween($min = 1, $max = 2), 'pffp5' => $faker->numberBetween($min = 1, $max = 3), 'pffp6' => $faker->numberBetween($min = 1, $max = 3), 'pffp7' => $faker->numberBetween($min = 1, $max = 3), 'pffp8' => $faker->numberBetween($min = 1, $max = 3), 'pffp9' => $faker->numberBetween($min = 1, $max = 3), 'pffp10' => $faker->numberBetween($min = 1, $max = 4), 'pffp11' => $faker->numberBetween($min = 1, $max = 4), 'comments' => $faker->text(100), 'status' => 'Finalized', 'semester' => '1st', 'year' => '2016']);
     }
     for ($id = 5; $id < 19; $id++) {
         $user = User::find($id);
         Performance::create(['user_id' => $id, 'dept_id' => $user->department_id, 'util1' => $faker->numberBetween($min = 1, $max = 6), 'util2' => $faker->numberBetween($min = 1, $max = 6), 'util3' => $faker->numberBetween($min = 1, $max = 6), 'qow1' => $faker->numberBetween($min = 1, $max = 6), 'qow2' => $faker->numberBetween($min = 1, $max = 6), 'qow3' => $faker->numberBetween($min = 1, $max = 4), 'qow4' => $faker->numberBetween($min = 1, $max = 4), 'qow5' => $faker->numberBetween($min = 1, $max = 4), 'qow6' => $faker->numberBetween($min = 1, $max = 4), 'qow7' => $faker->numberBetween($min = 1, $max = 4), 'qow8' => $faker->numberBetween($min = 1, $max = 2), 'pffp1' => $faker->numberBetween($min = 1, $max = 2), 'pffp2' => $faker->numberBetween($min = 1, $max = 2), 'pffp3' => $faker->numberBetween($min = 1, $max = 2), 'pffp4' => $faker->numberBetween($min = 1, $max = 2), 'pffp5' => $faker->numberBetween($min = 1, $max = 3), 'pffp6' => $faker->numberBetween($min = 1, $max = 3), 'pffp7' => $faker->numberBetween($min = 1, $max = 3), 'pffp8' => $faker->numberBetween($min = 1, $max = 3), 'pffp9' => $faker->numberBetween($min = 1, $max = 3), 'pffp10' => $faker->numberBetween($min = 1, $max = 4), 'pffp11' => $faker->numberBetween($min = 1, $max = 4), 'comments' => $faker->text(100), 'status' => 'Finalized', 'semester' => '2nd', 'year' => '2016']);
     }
     for ($id = 2; $id < 5; $id++) {
         $user = User::find($id);
         Performance::create(['user_id' => $id, 'dept_id' => $user->department_id, 'util1' => $faker->numberBetween($min = 6, $max = 6), 'util2' => $faker->numberBetween($min = 6, $max = 6), 'util3' => $faker->numberBetween($min = 5, $max = 6), 'qow1' => $faker->numberBetween($min = 5, $max = 6), 'qow2' => $faker->numberBetween($min = 6, $max = 6), 'qow3' => $faker->numberBetween($min = 6, $max = 6), 'qow4' => $faker->numberBetween($min = 6, $max = 6), 'qow5' => $faker->numberBetween($min = 5, $max = 6), 'qow6' => $faker->numberBetween($min = 5, $max = 6), 'qow7' => $faker->numberBetween($min = 6, $max = 6), 'qow8' => $faker->numberBetween($min = 5, $max = 6), 'pffp1' => $faker->numberBetween($min = 5, $max = 6), 'pffp2' => $faker->numberBetween($min = 5, $max = 6), 'pffp3' => $faker->numberBetween($min = 5, $max = 6), 'pffp4' => $faker->numberBetween($min = 5, $max = 6), 'pffp5' => $faker->numberBetween($min = 5, $max = 6), 'pffp6' => $faker->numberBetween($min = 5, $max = 6), 'pffp7' => $faker->numberBetween($min = 5, $max = 6), 'pffp8' => $faker->numberBetween($min = 6, $max = 6), 'pffp9' => $faker->numberBetween($min = 6, $max = 6), 'pffp10' => $faker->numberBetween($min = 6, $max = 6), 'pffp11' => $faker->numberBetween($min = 6, $max = 6), 'comments' => $faker->text(100), 'status' => 'Finalized', 'semester' => '1st', 'year' => '2016']);
     }
     $updates = Performance::all();
     foreach ($updates as $update) {
         $saveUpdate = Performance::find($update->id);
         $u = $update->utilities;
         $qow = $update->workQuality;
         $pffp = $update->potential;
         $overall = number_format(($u + $qow + $pffp) / 3, 2);
         $saveUpdate->update(['util_overall' => $u, 'qow_overall' => $qow, 'pffp_overall' => $pffp, 'overall' => $overall]);
     }
 }
示例#3
0
 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;
 }