'Element Entry', 'number' => '3120', 'description' => 'Compensation Element Entry', 'version' => '0.1.1', 'db_version' => '1001', 'mod_version' => '1.1.1', 'dependent_class' => array('hr_element_entry_line'), 'primary_entity_cb' => '', 'module_name' => 'hr', 'weight' => 6 ]; public $field_a = [ 'hr_element_entry_header_id', 'hr_employee_id', 'created_by', 'creation_date', 'last_update_by', 'last_update_date', ]; //variables used for showing data public $initial_search = [ 'hr_employee_id', ]; public $requiredField = [ 'hr_employee_id', ]; public $fields_inForm_notInDataBase = [ "employee_name", 'identification_id', 'multi_action_class_pc', 'multi_action_class_pc_value', 'action', 'archive_data_cb' ]; public $pageTitle = " Element Entry "; //page Title public $search = [ '_show_update_path' => 1, '_show_view_path' => 1, ]; public $prg_update_compensation_parameters = [ 'Enterprise' => 'search_enterprise_org', 'Grade Name' => 'search_grade', ]; public $prg_update_compensation_details = [ 'name' => 'Import Expense Claim', 'description' => 'Import Expense Claim', ]; public $hr_element_entry_header_id; public $hr_employee_id; public $created_by; public $creation_date; public $last_update_by; public $last_update_date; public $employee_name; public $identification_id; public $multi_action_class_pc; public $multi_action_class_pc_value; public $action; public $archive_data_cb; public function _before_save() { global $dbc; if (($this->action == 'multi_element_entry')) { echo "
Assigning elements to employees."; $this->_save_element_entry(); return 10; } if (!empty($this->archive_data_cb) && $this->archive_data_cb == 1) { try { $this->_archive_data(); } catch (Exception $e) { $dbc->rollback = true; echo "
Unable to save _archive_data data. Error @ " . __FILE__ . ' @@ line ' . __LINE__ . " : " . $e->getMessage(); return -90; } } } private function _archive_data() { global $dbc; $hr_elm_hist_h = new hr_element_history_header(); foreach ($hr_elm_hist_h->field_a as $k => $v) { if (property_exists($this, $v)) { $hr_elm_hist_h->$v = $this->$v; } } $hr_elm_hist_h->archive_date = current_time(); try { $hr_elm_hist_h->save(); } Catch (Exception $e) { $dbc->rollback = true; echo "
Unable to save hr_element_history_header data. Error @ " . __FILE__ . ' @@ line ' . __LINE__ . " : " . $e->getMessage(); } if (empty($hr_elm_hist_h->hr_element_history_header_id)) { $msg = 'No hr_element_history_header_id found' . __FILE__ . ' @@ line ' . __LINE__; throw new Exception($msg); } $hr_elem_l = hr_element_entry_line::find_by_parent_id($this->hr_element_entry_header_id); if (empty($hr_elem_l)) { throw new Exception("No hr_element_entry_line lines found "); } else { foreach ($hr_elem_l as $line) { $hr_elm_hist_l = new hr_element_history_line(); foreach ($hr_elm_hist_l->field_a as $k => $v) { if (property_exists($line, $v)) { $hr_elm_hist_l->$v = $line->$v; } } $hr_elm_hist_l->hr_element_history_header_id = $hr_elm_hist_h->hr_element_history_header_id; try { $hr_elm_hist_l->save(); } Catch (Exception $e) { echo "
Unable to save hr_element_history_line data. Error @ " . __FILE__ . ' @@ line ' . __LINE__ . " : " . $e->getMessage(); } } } } private function _save_element_entry() { if (!empty($_POST['hr_employee_id'])) { foreach ($_POST['hr_employee_id'] as $k => $v) { $this->_createUpdate_element($v, $_POST['hr_element_entry_tpl_header_id'][$k]); }//end of for each } } private function _createUpdate_element($employee_id, $hr_element_entry_tpl_header_id) { $ee_h = new hr_element_entry_header(); $ee_h->hr_employee_id = $employee_id; //check if header record exists $ee_h_i = $ee_h->findBy_employeeId($employee_id); if ($ee_h_i) { $ee_h->findBy_id($ee_h_i->hr_element_entry_header_id); //archieve the record $ee_h->_archive_data(); } else { $ee_h->save(); } //find all the lines from the template $tmp_headerID = $hr_element_entry_tpl_header_id; $all_template_lines = hr_element_entry_tpl_line::find_by_parent_id($tmp_headerID); foreach ($all_template_lines as $rec) { $ee_l = new hr_element_entry_line(); $ee_l->hr_element_entry_header_id = $ee_h->hr_element_entry_header_id; $ee_l->element_id = $rec->element_id; $ee_l->element_value = $rec->element_value; $ee_l->end_date = $rec->end_date; $exiting_eel = hr_element_entry_line::find_by_parentId_elementId($ee_l->hr_element_entry_header_id, $ee_l->element_id); if ($exiting_eel) { $ee_l->hr_element_entry_line_id = $exiting_eel->hr_element_entry_line_id; } try { $ee_l->save(); } catch (Exception $e) { echo "
Erorr @ class_element_entry_header @@ " . __LINE__ . $e->getMessage(); } } } Public static function find_all_lines_by_category($hr_element_entry_header_id, $category = 'E_REGULAR') { if (empty($hr_element_entry_header_id)) { return null; } $sql = " SELECT * FROM hr_element_entry_header eeh, hr_element_entry_line eel, hr_compensation_element hce WHERE eel.hr_element_entry_header_id = eeh.hr_element_entry_header_id AND eeh.hr_element_entry_header_id = :hr_element_entry_header_id AND hce.hr_compensation_element_id = eel.element_id "; global $db; $value_a = ['hr_element_entry_header_id' => $hr_element_entry_header_id]; if (is_array($category)) { $sql .= " AND hce.category IN " . "( '" . implode("','", $category) . "' )"; } else { $sql .= " AND hce.category = :category "; $value_a ['category'] = $category; } $result = $db->findBySql($sql, $value_a); return !empty($result) ? $result : false; } Public static function find_all_regular_lines($hr_element_entry_header_id) { return self::find_all_lines_by_category($hr_element_entry_header_id, 'E_REGULAR'); } Public static function find_all_basic_lines($hr_element_entry_header_id) { return self::find_all_lines_by_category($hr_element_entry_header_id, 'E_BASIC'); } Public static function find_all_basic_regular_lines($hr_element_entry_header_id) { return self::find_all_lines_by_category($hr_element_entry_header_id, array('E_BASIC', 'E_REGULAR')); } public static function find_by_employeeId($employee_id) { $sql = " SELECT * FROM hr_element_entry_header eeh WHERE eeh.hr_employee_id = :hr_employee_id "; $sql = ino_perPageSql_i($sql, 1); global $db; $value_a = ['hr_employee_id' => $employee_id]; $result = $db->findBySql($sql, $value_a); return !empty($result) ? array_pop($result) : false; } public function findBy_employeeId($employee_id) { $sql = " SELECT * FROM hr_element_entry_header eeh WHERE eeh.hr_employee_id = :hr_employee_id "; $sql = ino_perPageSql_i($sql, 1); global $db; $value_a = ['hr_employee_id' => $employee_id]; $result = $db->findBySql($sql, $value_a); return !empty($result) ? array_pop($result) : false; } public function prg_update_compensation($seralized_parameters) { /* * 1. Find all the employees as per the Job/BU Org id * 2. For each employee find the job id and corresponding * 3. Call _createUpdate_element progtam $hr_element_entry_tpl_header_id */ $parameters = unserialize($seralized_parameters); $this->message = '
Starting import_expense_claim program....
'; $all_employees = []; if (!empty($parameters['org_id'][0])) { $org_id = $parameters['org_id'][0]; $this->message .= '
Entered Enterprise org Id is : ' . $org_id; } else { $this->message .= '
Error! : No Enterprise org id found @ file ' . __FILE__ . ' @@ line' . __LINE__; return $this->message; } if (!empty($parameters['hr_grade_id'][0])) { $hr_grade_id = $parameters['hr_grade_id'][0]; $all_employees = hr_employee::find_by_fieldVal(['grade_id' => $hr_grade_id]); $this->message .= '
Entered hr_grade_id is : ' . $hr_grade_id; } else { $this->message .= '
No grade ID entered. Starting the program for all employees in BU ' . $org_id; $all_employees = hr_employee::find_by_orgId($org_id); } if (empty($all_employees)) { $this->message .= '
No employee found as per the entered criteria Error @ file ' . __FILE__ . ' @@ line' . __LINE__; } else { $hr_eh = new hr_element_entry_header(); foreach ($all_employees as $emp) { if (empty($emp->grade_id)) { continue; } else { $grade_i = hr_grade::find_by_id($emp->grade_id); } $hr_eh->_createUpdate_element($emp->hr_employee_id, $grade_i->hr_element_entry_tpl_header_id); $this->message .= '
Compensation is sucessfully created/updated for employee id ' . $emp->hr_employee_id; } } return $this->message; } public function multi_select_input_fields() { $multi_select_input = [ 'template_name' ]; return $multi_select_input; } public function multi_select_hidden_fields() { $multi_select_hidden = [ 'action_class_name', 'mode', 'action', 'show_block', ]; return $multi_select_hidden; } } //end of bom class ?>