public function add_evaluation() { $data = array('assessee_id' => $this->input->post('txtEmpID'), 'assessor_id' => $this->session->userdata('employee_id'), 'evaluation_desc' => $this->input->post('txtEvalTitle')); $eval = count(Evaluation_model::all()) + 1; // $rate1 = array ( // 'evaluation_id' => $eval, // 'criteria_id' => 1, // 'rate' => $this->input->post('txtRate1'), // ); // $rate2 = array ( // 'evaluation_id' => $eval, // 'criteria_id' => 2, // 'rate' => $this->input->post('txtRate2'), // ); // $rate3 = array ( // 'evaluation_id' => $eval, // 'criteria_id' => 3, // 'rate' => $this->input->post('txtRate3'), // ); // $rate4 = array ( // 'evaluation_id' => $eval, // 'criteria_id' => 4, // 'rate' => $this->input->post('txtRate4'), // ); // $rate5 = array ( // 'evaluation_id' => $eval, // 'criteria_id' => 5, // 'rate' => $this->input->post('txtRate5'), // ); // $rate6 = array ( // 'evaluation_id' => $eval, // 'criteria_id' => 6, // 'rate' => $this->input->post('txtRate6'), // ); // $rate7 = array ( // 'evaluation_id' => $eval, // 'criteria_id' => 7, // 'rate' => $this->input->post('txtRate7'), // ); // $rate8 = array ( // 'evaluation_id' => $eval, // 'criteria_id' => 8, // 'rate' => $this->input->post('txtRate8'), // ); // $rate9 = array ( // 'evaluation_id' => $eval, // 'criteria_id' => 9, // 'rate' => $this->input->post('txtRate9'), // ); // $rate10 = array ( // 'evaluation_id' => $eval, // 'criteria_id' => 10, // 'rate' => $this->input->post('txtRate10'), // ); $rate = array('evaluation_id' => $eval, 'rate1' => $this->input->post('txtRate1'), 'rate2' => $this->input->post('txtRate2'), 'rate3' => $this->input->post('txtRate3'), 'rate4' => $this->input->post('txtRate4'), 'rate5' => $this->input->post('txtRate5'), 'rate6' => $this->input->post('txtRate6'), 'rate7' => $this->input->post('txtRate7'), 'rate8' => $this->input->post('txtRate8'), 'rate9' => $this->input->post('txtRate9'), 'rate10' => $this->input->post('txtRate10')); if (Performance::create($data)) { // Evaluation_rate::create($rate1); // Evaluation_rate::create($rate2); // Evaluation_rate::create($rate3); // Evaluation_rate::create($rate4); // Evaluation_rate::create($rate5); // Evaluation_rate::create($rate6); // Evaluation_rate::create($rate7); // Evaluation_rate::create($rate8); // Evaluation_rate::create($rate9); // Evaluation_rate::create($rate10); Evaluation_rate::create($rate); $this->session->set_userdata('added', 1); Audit_trail_model::auditPerformance($data); if ($this->session->userdata('user_level') == 'Administrator') { redirect('ems/view_performance'); } else { $this->session->set_userdata('added', 1); redirect('ems/emp_dashboard'); } } }
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]); } }
public function postEvaluate() { $validator = Validator::make(Input::all(), Performance::$rules); if ($validator->fails()) { return Redirect::route('selfevaluation')->withErrors($validator)->withInput(); } $user = User::find(Auth::id()); $performance = Performance::create(['user_id' => Auth::id(), 'dept_id' => $user->department_id, 'semester' => Input::get('semester'), 'util1' => Input::get('util1'), 'util2' => Input::get('util2'), 'util3' => Input::get('util3'), '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'), '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'), 'status' => 'Submitted', 'year' => Carbon::now()->year]); if ($user->gender == 'Male') { $gender = 'his'; } else { $gender = 'her'; } $audit = AuditTrail::create(['user_id' => Auth::id(), 'role' => 'User', 'action' => 'submitted ' . $gender . ' self evaluation']); $addPoints = DB::update('update evaluate_points set points = points - 1 WHERE user_id = ?', [Auth::id()]); return Redirect::route('home')->with('alert', 'success|Evaluation has been submitted to your superior.'); }