Example #1
0
 public static function get_employee($id)
 {
     $query = DB::select('employees.*', 'users.username', 'users.last_login', 'users.fb_login')->from('employees')->join('users', 'inner')->on('employees.user_id', '=', 'users.id')->where('employees.id', '=', $id)->execute()->as_array();
     if (count($query)) {
         $result = $query[0];
         $result['custom'] = Model_EmployeeCustom::get_employee_custom($id);
         $result['expect'] = Model_Expect::get_expects($id);
         $result['experience'] = Model_Experience::get_experience($id);
         $result['school'] = Model_School::get_schools($id);
         $result['comp_skills'] = Model_Skill::get_computer_skills($id);
         $result['lang_skills'] = Model_Skill::get_language_skills($id);
         $result['other_skills'] = Model_Skill::get_other_skills($id);
         return $result;
     } else {
         return null;
     }
 }
Example #2
0
 public function action_addStaffPick($id)
 {
     is_null($id) and Response::redirect('employee');
     $employee = Model_Employee::find($id);
     if (Input::method() == "POST") {
         try {
             $file = Input::file('pick_photo_file');
             $config = array('path' => "/var/www/html/uploads/staffpick_cover/", 'ext_whitelist' => array('jpg', 'jpeg', 'png'), 'file_chmod' => 0777, 'auto_rename' => true, 'overwrite' => true, 'randomize' => true, 'create_path' => true);
             Upload::process($config);
             if (Upload::is_valid()) {
                 Upload::save();
                 $pick_photo = Upload::get_files()[0];
                 $pick = Model_EmployeePick::forge(array('employee_id' => Input::post('employee_id'), 'pick_type' => Input::post('pick_type'), 'pick_date' => Input::post('pick_date'), 'pick_photo' => $pick_photo ? $pick_photo['saved_as'] : "", 'pick_is_active' => Input::post('pick_is_active'), 'created_at' => time()));
                 if ($pick && $pick->save()) {
                     $titles = Input::post('skill_title');
                     $levels = Input::post('skill_level');
                     foreach ($titles as $key => $val) {
                         if (!strlen($val)) {
                             continue;
                         }
                         $skill = Model_EmployeePickSkill::forge(array('pick_id' => $pick->id, 'skill_title' => $val, 'skill_level' => $levels[$key], 'created_at' => time()));
                         $skill->save();
                     }
                     Session::set_flash('success', 'Added employee #' . $id . ' to Staff Picks.');
                     Response::redirect('employee/staffPicks');
                 } else {
                     Session::set_flash('error', 'Could not save employee pick.');
                 }
             }
         } catch (Exception $e) {
             die($e->getMessage());
         }
     }
     $data['employee'] = $employee;
     $skills = Model_Skill::get_computer_skills($id);
     $data['skills'] = $skills;
     $this->theme->set_template('edit');
     $this->theme->get_template()->set_global('employee', $employee, false);
     $this->theme->get_template()->set_global('skills', $skills, false);
     $this->theme->get_template()->set_global('provinces', Model_Province::get_provinces('th'));
     $this->theme->get_template()->set_global('current_menu', "Employees");
     $this->theme->get_template()->set_global('current_menu_desc', "จัดการผู้ใช้งานที่เป็นผู้หางานทั้งหมดในระบบ");
     $this->theme->get_template()->set('breadcrumb', array(array('title' => "Home", 'icon' => "fa-home", 'link' => Uri::create('home'), 'active' => false), array('title' => "Employees", 'icon' => "fa-users", 'link' => Uri::create('employee'), 'active' => false), array('title' => "Add Staff Pick", 'icon' => "fa-plus", 'link' => "", 'active' => true)));
     $this->theme->set_partial('sidebar', 'common/sidebar');
     $this->theme->set_partial('left', 'employee/add_staff_pick')->set($data);
 }