load->model("Employees_model"); $this->load->model("Xin_model"); $this->load->model("Department_model"); $this->load->model("Designation_model"); $this->load->model("Roles_model"); $this->load->model("Location_model"); $this->load->model("Company_model"); $this->load->model("Timesheet_model"); $this->load->library("pagination"); } /*Function to set JSON output*/ public function output($Return=array()){ /*Set response header*/ header("Access-Control-Allow-Origin: *"); header("Content-Type: application/json; charset=UTF-8"); /*Final JSON response*/ exit(json_encode($Return)); } public function index() { $session = $this->session->userdata('username'); if(empty($session)){ redirect('admin/'); } $data['title'] = $this->lang->line('xin_employees').' | '.$this->Xin_model->site_title(); $data['all_departments'] = $this->Department_model->all_departments(); $data['all_designations'] = $this->Designation_model->all_designations(); $data['all_user_roles'] = $this->Roles_model->all_user_roles(); $data['all_office_shifts'] = $this->Employees_model->all_office_shifts(); $data['get_all_companies'] = $this->Xin_model->get_companies(); $data['all_leave_types'] = $this->Timesheet_model->all_leave_types(); $data['breadcrumbs'] = $this->lang->line('xin_employees'); $data['path_url'] = 'employees'; $role_resources_ids = $this->Xin_model->user_role_resource(); if(in_array('13',$role_resources_ids)) { if(!empty($session)){ $data['subview'] = $this->load->view("admin/employees/employees_list", $data, TRUE); $this->load->view('admin/layout/layout_main', $data); //page load } else { redirect('admin/'); } } else { redirect('admin/dashboard'); } } // employees directory/hr public function hr() { $session = $this->session->userdata('username'); if(empty($session)){ redirect('admin/'); } $data['title'] = $this->lang->line('xin_employees_directory').' | '.$this->Xin_model->site_title(); $data['all_departments'] = $this->Department_model->all_departments(); $data['all_designations'] = $this->Designation_model->all_designations(); $data['all_user_roles'] = $this->Roles_model->all_user_roles(); $data['all_employees'] = $this->Xin_model->all_employees(); $data['breadcrumbs'] = $this->lang->line('xin_employees_directory'); $data['path_url'] = 'employees_directory'; // init params $config = array(); $limit_per_page = 20; $page = ($this->uri->segment(4)) ? ($this->uri->segment(4) - 1) : 0; $total_records = $this->Employees_model->record_count(); // get current page records $data["results"] = $this->Employees_model->fetch_all_employees($limit_per_page, $page*$limit_per_page); $config['base_url'] = site_url() . "admin/employees/hr"; $config['total_rows'] = $total_records; $config['per_page'] = $limit_per_page; $config["uri_segment"] = 4; // custom paging configuration // $config['num_links'] = 2; $config['use_page_numbers'] = TRUE; $config['reuse_query_string'] = FALSE; //$config['page_query_string'] = TRUE; //$config['use_page_numbers'] = TRUE; $config['num_links'] = $total_records; $config['cur_tag_open'] = ' '; $config['cur_tag_close'] = ''; $config['next_link'] = '»'; $config['prev_link'] = '«'; $this->pagination->initialize($config); // build paging links //$data["links"] = $this->pagination->create_links(); $str_links = $this->pagination->create_links(); $data["links"] = explode(' ',$str_links ); // View data according to array. $role_resources_ids = $this->Xin_model->user_role_resource(); if(in_array('88',$role_resources_ids)) { $data['subview'] = $this->load->view("admin/employees/directory", $data, TRUE); $this->load->view('admin/layout/layout_main', $data); //page load } else { redirect('admin/dashboard'); } } public function employees_list() { $data['title'] = $this->Xin_model->site_title(); $session = $this->session->userdata('username'); if(!empty($session)){ $this->load->view("admin/employees/employees_list", $data); } else { redirect('admin/'); } // Datatables Variables $draw = intval($this->input->get("draw")); $start = intval($this->input->get("start")); $length = intval($this->input->get("length")); $role_resources_ids = $this->Xin_model->user_role_resource(); $employee = $this->Employees_model->get_employees(); $data = array(); foreach($employee->result() as $r) { // get company $company = $this->Xin_model->read_company_info($r->company_id); if(!is_null($company)){ $comp_name = $company[0]->name; } else { $comp_name = '--'; } // user full name $full_name = $r->first_name.' '.$r->last_name; // get status if($r->is_active==0): $status = $this->lang->line('xin_employees_inactive'); elseif($r->is_active==1): $status = $this->lang->line('xin_employees_active'); endif; // user role $role = $this->Xin_model->read_user_role_info($r->user_role_id); if(!is_null($role)){ $role_name = $role[0]->role_name; } else { $role_name = '--'; } // get designation $designation = $this->Designation_model->read_designation_information($r->designation_id); if(!is_null($designation)){ $designation_name = $designation[0]->designation_name; } else { $designation_name = '--'; } // department $department = $this->Department_model->read_department_information($r->department_id); if(!is_null($department)){ $department_name = $department[0]->department_name; } else { $department_name = '--'; } $department_designation = $designation_name.' ('.$department_name.')'; if($r->user_id != '1') { if(in_array('203',$role_resources_ids)) { $del_opt = ''; } else { $del_opt = ''; } } else { $del_opt = ''; } if(in_array('202',$role_resources_ids)) { $view_opt = ' '; } else { $view_opt = ''; } $function = $view_opt.$del_opt.''; $data[] = array( $function, $r->employee_id, $full_name, $comp_name, $r->username, $r->email, $role_name, $department_designation, $status ); } $output = array( "draw" => $draw, "recordsTotal" => $employee->num_rows(), "recordsFiltered" => $employee->num_rows(), "data" => $data ); echo json_encode($output); exit(); } public function employees_cards_list() { $data['title'] = $this->Xin_model->site_title(); $session = $this->session->userdata('username'); if(!empty($session)){ $this->load->view("admin/employees/employees_list", $data); } else { redirect('admin/'); } // Datatables Variables $draw = intval($this->input->get("draw")); $start = intval($this->input->get("start")); $length = intval($this->input->get("length")); $employee = $this->Employees_model->get_employees(); $countries = $this->Xin_model->get_countries(); $data = array(); $function = ''; foreach (array_chunk($countries, 4) as $row) { $function .= ''; foreach ($row as $value) { $function .=''; $function .=''; } $data[] = array( $function ); } $output = array( "draw" => $draw, "recordsTotal" => $employee->num_rows(), "recordsFiltered" => $employee->num_rows(), "data" => $data ); echo json_encode($output); exit(); } public function detail() { $session = $this->session->userdata('username'); if(empty($session)){ redirect('admin/'); } $id = $this->uri->segment(4); $result = $this->Employees_model->read_employee_information($id); if(is_null($result)){ redirect('admin/employees'); } $role_resources_ids = $this->Xin_model->user_role_resource(); $check_role = $this->Employees_model->read_employee_information($session['user_id']); if(!in_array('202',$role_resources_ids)) { redirect('admin/employees'); } /*if($check_role[0]->user_id!=$result[0]->user_id) { redirect('admin/employees'); }*/ $role_resources_ids = $this->Xin_model->user_role_resource(); $data['breadcrumbs'] = $this->lang->line('xin_employee_details'); $data['path_url'] = 'employees_detail'; $data = array( 'breadcrumbs' => $this->lang->line('xin_employee_detail'), 'path_url' => 'employees_detail', 'first_name' => $result[0]->first_name, 'last_name' => $result[0]->last_name, 'user_id' => $result[0]->user_id, 'employee_id' => $result[0]->employee_id, 'company_id' => $result[0]->company_id, 'office_shift_id' => $result[0]->office_shift_id, 'username' => $result[0]->username, 'email' => $result[0]->email, 'department_id' => $result[0]->department_id, 'designation_id' => $result[0]->designation_id, 'user_role_id' => $result[0]->user_role_id, 'date_of_birth' => $result[0]->date_of_birth, 'date_of_leaving' => $result[0]->date_of_leaving, 'gender' => $result[0]->gender, 'marital_status' => $result[0]->marital_status, 'contact_no' => $result[0]->contact_no, 'address' => $result[0]->address, 'wages_type' => $result[0]->wages_type, 'basic_salary' => $result[0]->basic_salary, 'daily_wages' => $result[0]->daily_wages, 'salary_ssempee' => $result[0]->salary_ssempee, 'salary_ssempeer' => $result[0]->salary_ssempeer, 'salary_income_tax' => $result[0]->salary_income_tax, 'salary_overtime' => $result[0]->salary_overtime, 'salary_commission' => $result[0]->salary_commission, 'salary_claims' => $result[0]->salary_claims, 'salary_paid_leave' => $result[0]->salary_paid_leave, 'salary_director_fees' => $result[0]->salary_director_fees, 'salary_bonus' => $result[0]->salary_bonus, 'salary_advance_paid' => $result[0]->salary_advance_paid, 'is_active' => $result[0]->is_active, 'date_of_joining' => $result[0]->date_of_joining, 'all_departments' => $this->Department_model->all_departments(), 'all_designations' => $this->Designation_model->all_designations(), 'all_user_roles' => $this->Roles_model->all_user_roles(), 'title' => $this->lang->line('xin_employee_detail').' | '.$this->Xin_model->site_title(), 'profile_picture' => $result[0]->profile_picture, 'facebook_link' => $result[0]->facebook_link, 'twitter_link' => $result[0]->twitter_link, 'blogger_link' => $result[0]->blogger_link, 'linkdedin_link' => $result[0]->linkdedin_link, 'google_plus_link' => $result[0]->google_plus_link, 'instagram_link' => $result[0]->instagram_link, 'pinterest_link' => $result[0]->pinterest_link, 'youtube_link' => $result[0]->youtube_link, 'leave_categories' => $result[0]->leave_categories, 'all_countries' => $this->Xin_model->get_countries(), 'all_document_types' => $this->Employees_model->all_document_types(), 'all_education_level' => $this->Employees_model->all_education_level(), 'all_qualification_language' => $this->Employees_model->all_qualification_language(), 'all_qualification_skill' => $this->Employees_model->all_qualification_skill(), 'all_contract_types' => $this->Employees_model->all_contract_types(), 'all_contracts' => $this->Employees_model->all_contracts(), 'all_office_shifts' => $this->Employees_model->all_office_shifts(), 'get_all_companies' => $this->Xin_model->get_companies(), 'all_office_locations' => $this->Location_model->all_office_locations(), 'all_leave_types' => $this->Timesheet_model->all_leave_types(), ); $data['subview'] = $this->load->view("admin/employees/employee_detail", $data, TRUE); $this->load->view('admin/layout/layout_main', $data); //page load // Datatables Variables $draw = intval($this->input->get("draw")); $start = intval($this->input->get("start")); $length = intval($this->input->get("length")); } // get company > departments public function get_departments() { $data['title'] = $this->Xin_model->site_title(); $id = $this->uri->segment(4); $data = array( 'company_id' => $id ); $session = $this->session->userdata('username'); if(!empty($session)){ $this->load->view("admin/employees/get_departments", $data); } else { redirect('admin/'); } // Datatables Variables $draw = intval($this->input->get("draw")); $start = intval($this->input->get("start")); $length = intval($this->input->get("length")); } public function dialog_contact() { $session = $this->session->userdata('username'); if(empty($session)){ redirect('admin/'); } $data['title'] = $this->Xin_model->site_title(); $id = $this->input->get('field_id'); $result = $this->Employees_model->read_contact_information($id); $data = array( 'contact_id' => $result[0]->contact_id, 'employee_id' => $result[0]->employee_id, 'relation' => $result[0]->relation, 'is_primary' => $result[0]->is_primary, 'is_dependent' => $result[0]->is_dependent, 'contact_name' => $result[0]->contact_name, 'work_phone' => $result[0]->work_phone, 'work_phone_extension' => $result[0]->work_phone_extension, 'mobile_phone' => $result[0]->mobile_phone, 'home_phone' => $result[0]->home_phone, 'work_email' => $result[0]->work_email, 'personal_email' => $result[0]->personal_email, 'address_1' => $result[0]->address_1, 'address_2' => $result[0]->address_2, 'city' => $result[0]->city, 'state' => $result[0]->state, 'zipcode' => $result[0]->zipcode, 'icountry' => $result[0]->country, 'all_countries' => $this->Xin_model->get_countries() ); if(!empty($session)){ $this->load->view('admin/employees/dialog_employee_details', $data); } else { redirect('admin/'); } } public function dialog_document() { $session = $this->session->userdata('username'); if(empty($session)){ redirect('admin/'); } $data['title'] = $this->Xin_model->site_title(); $id = $this->input->get('field_id'); $document = $this->Employees_model->read_document_information($id); $data = array( 'document_id' => $document[0]->document_id, 'document_type_id' => $document[0]->document_type_id, 'd_employee_id' => $document[0]->employee_id, 'all_document_types' => $this->Employees_model->all_document_types(), 'date_of_expiry' => $document[0]->date_of_expiry, 'title' => $document[0]->title, 'is_alert' => $document[0]->is_alert, 'description' => $document[0]->description, 'notification_email' => $document[0]->notification_email, 'document_file' => $document[0]->document_file ); if(!empty($session)){ $this->load->view('admin/employees/dialog_employee_details', $data); } else { redirect('admin/'); } } public function dialog_imgdocument() { $session = $this->session->userdata('username'); if(empty($session)){ redirect('admin/'); } $data['title'] = $this->Xin_model->site_title(); $id = $this->input->get('field_id'); $document = $this->Employees_model->read_imgdocument_information($id); $data = array( 'immigration_id' => $document[0]->immigration_id, 'document_type_id' => $document[0]->document_type_id, 'd_employee_id' => $document[0]->employee_id, 'all_document_types' => $this->Employees_model->all_document_types(), 'all_countries' => $this->Xin_model->get_countries(), 'document_number' => $document[0]->document_number, 'document_file' => $document[0]->document_file, 'issue_date' => $document[0]->issue_date, 'expiry_date' => $document[0]->expiry_date, 'country_id' => $document[0]->country_id, 'eligible_review_date' => $document[0]->eligible_review_date, ); if(!empty($session)){ $this->load->view('admin/employees/dialog_employee_details', $data); } else { redirect('admin/'); } } public function dialog_qualification() { $session = $this->session->userdata('username'); if(empty($session)){ redirect('admin/'); } $data['title'] = $this->Xin_model->site_title(); $id = $this->input->get('field_id'); $result = $this->Employees_model->read_qualification_information($id); $data = array( 'qualification_id' => $result[0]->qualification_id, 'employee_id' => $result[0]->employee_id, 'name' => $result[0]->name, 'education_level_id' => $result[0]->education_level_id, 'from_year' => $result[0]->from_year, 'language_id' => $result[0]->language_id, 'to_year' => $result[0]->to_year, 'skill_id' => $result[0]->skill_id, 'description' => $result[0]->description, 'all_education_level' => $this->Employees_model->all_education_level(), 'all_qualification_language' => $this->Employees_model->all_qualification_language(), 'all_qualification_skill' => $this->Employees_model->all_qualification_skill() ); if(!empty($session)){ $this->load->view('admin/employees/dialog_employee_details', $data); } else { redirect('admin/'); } } public function dialog_work_experience() { $session = $this->session->userdata('username'); if(empty($session)){ redirect('admin/'); } $data['title'] = $this->Xin_model->site_title(); $id = $this->input->get('field_id'); $result = $this->Employees_model->read_work_experience_information($id); $data = array( 'work_experience_id' => $result[0]->work_experience_id, 'employee_id' => $result[0]->employee_id, 'company_name' => $result[0]->company_name, 'from_date' => $result[0]->from_date, 'to_date' => $result[0]->to_date, 'post' => $result[0]->post, 'description' => $result[0]->description ); if(!empty($session)){ $this->load->view('admin/employees/dialog_employee_details', $data); } else { redirect('admin/'); } } public function dialog_bank_account() { $session = $this->session->userdata('username'); if(empty($session)){ redirect('admin/'); } $data['title'] = $this->Xin_model->site_title(); $id = $this->input->get('field_id'); $result = $this->Employees_model->read_bank_account_information($id); $data = array( 'bankaccount_id' => $result[0]->bankaccount_id, 'employee_id' => $result[0]->employee_id, 'is_primary' => $result[0]->is_primary, 'account_title' => $result[0]->account_title, 'account_number' => $result[0]->account_number, 'bank_name' => $result[0]->bank_name, 'bank_code' => $result[0]->bank_code, 'bank_branch' => $result[0]->bank_branch ); if(!empty($session)){ $this->load->view('admin/employees/dialog_employee_details', $data); } else { redirect('admin/'); } } public function dialog_contract() { $session = $this->session->userdata('username'); if(empty($session)){ redirect('admin/'); } $data['title'] = $this->Xin_model->site_title(); $id = $this->input->get('field_id'); $result = $this->Employees_model->read_contract_information($id); $data = array( 'contract_id' => $result[0]->contract_id, 'employee_id' => $result[0]->employee_id, 'contract_type_id' => $result[0]->contract_type_id, 'from_date' => $result[0]->from_date, 'designation_id' => $result[0]->designation_id, 'title' => $result[0]->title, 'to_date' => $result[0]->to_date, 'description' => $result[0]->description, 'all_contract_types' => $this->Employees_model->all_contract_types(), 'all_designations' => $this->Designation_model->all_designations(), ); if(!empty($session)){ $this->load->view('admin/employees/dialog_employee_details', $data); } else { redirect('admin/'); } } public function dialog_leave() { $session = $this->session->userdata('username'); if(empty($session)){ redirect('admin/'); } $data['title'] = $this->Xin_model->site_title(); $id = $this->input->get('field_id'); $result = $this->Employees_model->read_leave_information($id); $data = array( 'leave_id' => $result[0]->leave_id, 'employee_id' => $result[0]->employee_id, 'contract_id' => $result[0]->contract_id, 'casual_leave' => $result[0]->casual_leave, 'medical_leave' => $result[0]->medical_leave ); if(!empty($session)){ $this->load->view('admin/employees/dialog_employee_details', $data); } else { redirect('admin/'); } } public function dialog_shift() { $session = $this->session->userdata('username'); if(empty($session)){ redirect('admin/'); } $data['title'] = $this->Xin_model->site_title(); $id = $this->input->get('field_id'); $result = $this->Employees_model->read_emp_shift_information($id); $data = array( 'emp_shift_id' => $result[0]->emp_shift_id, 'employee_id' => $result[0]->employee_id, 'shift_id' => $result[0]->shift_id, 'from_date' => $result[0]->from_date, 'to_date' => $result[0]->to_date ); if(!empty($session)){ $this->load->view('admin/employees/dialog_employee_details', $data); } else { redirect('admin/'); } } public function dialog_location() { $session = $this->session->userdata('username'); if(empty($session)){ redirect('admin/'); } $data['title'] = $this->Xin_model->site_title(); $id = $this->input->get('field_id'); $result = $this->Employees_model->read_location_information($id); $data = array( 'office_location_id' => $result[0]->office_location_id, 'employee_id' => $result[0]->employee_id, 'location_id' => $result[0]->location_id, 'from_date' => $result[0]->from_date, 'to_date' => $result[0]->to_date ); if(!empty($session)){ $this->load->view('admin/employees/dialog_employee_details', $data); } else { redirect('admin/'); } } public function dialog_salary_allowance() { $session = $this->session->userdata('username'); if(empty($session)){ redirect('admin/'); } $data['title'] = $this->Xin_model->site_title(); $id = $this->input->get('field_id'); $result = $this->Employees_model->read_single_salary_allowance($id); $data = array( 'allowance_id' => $result[0]->allowance_id, 'employee_id' => $result[0]->employee_id, 'allowance_title' => $result[0]->allowance_title, 'allowance_amount' => $result[0]->allowance_amount ); if(!empty($session)){ $this->load->view('admin/employees/dialog_employee_details', $data); } else { redirect('admin/'); } } public function dialog_salary_loan() { $session = $this->session->userdata('username'); if(empty($session)){ redirect('admin/'); } $data['title'] = $this->Xin_model->site_title(); $id = $this->input->get('field_id'); $result = $this->Employees_model->read_single_loan_deductions($id); $data = array( 'loan_deduction_id' => $result[0]->loan_deduction_id, 'employee_id' => $result[0]->employee_id, 'loan_deduction_title' => $result[0]->loan_deduction_title, 'start_date' => $result[0]->start_date, 'end_date' => $result[0]->end_date, 'monthly_installment' => $result[0]->monthly_installment, 'reason' => $result[0]->reason, 'created_at' => $result[0]->created_at ); if(!empty($session)){ $this->load->view('admin/employees/dialog_employee_details', $data); } else { redirect('admin/'); } } public function dialog_emp_overtime() { $session = $this->session->userdata('username'); if(empty($session)){ redirect('admin/'); } $data['title'] = $this->Xin_model->site_title(); $id = $this->input->get('field_id'); $result = $this->Employees_model->read_salary_overtime_record($id); $data = array( 'salary_overtime_id' => $result[0]->salary_overtime_id, 'employee_id' => $result[0]->employee_id, 'overtime_type' => $result[0]->overtime_type, 'no_of_days' => $result[0]->no_of_days, 'overtime_hours' => $result[0]->overtime_hours, 'overtime_rate' => $result[0]->overtime_rate ); if(!empty($session)){ $this->load->view('admin/employees/dialog_employee_details', $data); } else { redirect('admin/'); } } // get departmens > designations public function designation() { $data['title'] = $this->Xin_model->site_title(); $id = $this->uri->segment(4); $data = array( 'department_id' => $id, 'all_designations' => $this->Designation_model->all_designations(), ); $session = $this->session->userdata('username'); if(!empty($session)){ $this->load->view("admin/employees/get_designations", $data); } else { redirect('admin/'); } // Datatables Variables $draw = intval($this->input->get("draw")); $start = intval($this->input->get("start")); $length = intval($this->input->get("length")); } public function read() { $session = $this->session->userdata('username'); if(empty($session)){ redirect('admin/'); } $data['title'] = $this->Xin_model->site_title(); $id = $this->input->get('warning_id'); $result = $this->Warning_model->read_warning_information($id); $data = array( 'warning_id' => $result[0]->warning_id, 'warning_to' => $result[0]->warning_to, 'warning_by' => $result[0]->warning_by, 'warning_date' => $result[0]->warning_date, 'warning_type_id' => $result[0]->warning_type_id, 'subject' => $result[0]->subject, 'description' => $result[0]->description, 'status' => $result[0]->status, 'all_employees' => $this->Xin_model->all_employees(), 'all_warning_types' => $this->Warning_model->all_warning_types(), ); if(!empty($session)){ $this->load->view('admin/warning/dialog_warning', $data); } else { redirect('admin/'); } } // Validate and add info in database public function add_employee() { if($this->input->post('add_type')=='employee') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); /* Server side PHP input validation */ if($this->input->post('first_name')==='') { $Return['error'] = $this->lang->line('xin_employee_error_first_name'); } else if(preg_match("/^(\pL{1,}[ ]?)+$/u",$this->input->post('first_name'))!=1) { $Return['error'] = $this->lang->line('xin_hr_string_error'); } else if($this->input->post('last_name')==='') { $Return['error'] = $this->lang->line('xin_employee_error_last_name'); } else if(preg_match("/^(\pL{1,}[ ]?)+$/u",$this->input->post('last_name'))!=1) { $Return['error'] = $this->lang->line('xin_hr_string_error'); }else if($this->input->post('employee_id')==='') { $Return['error'] = $this->lang->line('xin_employee_error_employee_id'); } else if($this->input->post('date_of_joining')==='') { $Return['error'] = $this->lang->line('xin_employee_error_joining_date'); } else if($this->Xin_model->validate_date($this->input->post('date_of_joining'),'Y-m-d') == false) { $Return['error'] = $this->lang->line('xin_hr_date_format_error'); } else if($this->input->post('company_id')==='') { $Return['error'] = $this->lang->line('error_company_field'); } else if($this->input->post('department_id')==='') { $Return['error'] = $this->lang->line('xin_employee_error_department'); } else if($this->input->post('designation_id')==='') { $Return['error'] = $this->lang->line('xin_employee_error_designation'); } else if($this->input->post('role')==='') { $Return['error'] = $this->lang->line('xin_employee_error_user_role'); } else if($this->input->post('username')==='') { $Return['error'] = $this->lang->line('xin_employee_error_username'); } else if($this->input->post('email')==='') { $Return['error'] = $this->lang->line('xin_employee_error_email'); } else if (!filter_var($this->input->post('email'), FILTER_VALIDATE_EMAIL)) { $Return['error'] = $this->lang->line('xin_employee_error_invalid_email'); } else if($this->input->post('date_of_birth')==='') { $Return['error'] = $this->lang->line('xin_employee_error_date_of_birth'); } else if($this->Xin_model->validate_date($this->input->post('date_of_birth'),'Y-m-d') == false) { $Return['error'] = $this->lang->line('xin_hr_date_format_error'); } else if($this->input->post('contact_no')==='') { $Return['error'] = $this->lang->line('xin_employee_error_contact_number'); } else if(!preg_match('/^([0-9]*)$/', $this->input->post('contact_no'))) { $Return['error'] = $this->lang->line('xin_hr_numeric_error'); } else if($this->input->post('password')==='') { $Return['error'] = $this->lang->line('xin_employee_error_password'); } else if(strlen($this->input->post('password')) < 6) { $Return['error'] = $this->lang->line('xin_employee_error_password_least'); } else if($this->input->post('password')!==$this->input->post('confirm_password')) { $Return['error'] = $this->lang->line('xin_employee_error_password_not_match'); } if($Return['error']!=''){ $this->output($Return); } $first_name = $this->Xin_model->clean_post($this->input->post('first_name')); $last_name = $this->Xin_model->clean_post($this->input->post('last_name')); $employee_id = $this->Xin_model->clean_post($this->input->post('employee_id')); $date_of_joining = $this->Xin_model->clean_date_post($this->input->post('date_of_joining')); $username = $this->Xin_model->clean_post($this->input->post('username')); $date_of_birth = $this->Xin_model->clean_date_post($this->input->post('date_of_birth')); $contact_no = $this->Xin_model->clean_post($this->input->post('contact_no')); $address = $this->Xin_model->clean_post($this->input->post('address')); $options = array('cost' => 12); $password_hash = password_hash($this->input->post('password'), PASSWORD_BCRYPT, $options); $leave_categories = array($this->input->post('leave_categories')); $cat_ids = implode(',',$this->input->post('leave_categories')); $Return['error'] = $cat_ids; $data = array( 'employee_id' => $employee_id, 'office_shift_id' => $this->input->post('office_shift_id'), 'first_name' => $first_name, 'last_name' => $last_name, 'username' => $username, 'company_id' => $this->input->post('company_id'), 'email' => $this->input->post('email'), 'password' => $password_hash, 'date_of_birth' => $date_of_birth, 'gender' => $this->input->post('gender'), 'user_role_id' => $this->input->post('role'), 'department_id' => $this->input->post('department_id'), 'designation_id' => $this->input->post('designation_id'), 'date_of_joining' => $date_of_joining, 'contact_no' => $contact_no, 'address' => $address, 'is_active' => 1, 'leave_categories' => $cat_ids, 'created_at' => date('Y-m-d h:i:s') ); $result = $this->Employees_model->add($data); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_success_add_employee'); //get setting info $setting = $this->Xin_model->read_setting_info(1); $company = $this->Xin_model->read_company_setting_info(1); if($setting[0]->enable_email_notification == 'yes') { // load email library $this->load->library('email'); $this->email->set_mailtype("html"); //get company info $cinfo = $this->Xin_model->read_company_setting_info(1); //get email template $template = $this->Xin_model->read_email_template(8); $subject = $template[0]->subject.' - '.$cinfo[0]->company_name; $logo = base_url().'uploads/logo/signin/'.$company[0]->sign_in_logo; // get user full name $full_name = $this->input->post('first_name').' '.$this->input->post('last_name'); $message = '

'.str_replace(array("{var site_name}","{var site_url}","{var username}","{var employee_id}","{var employee_name}","{var email}","{var password}"),array($cinfo[0]->company_name,site_url(),$this->input->post('username'),$this->input->post('employee_id'),$full_name,$this->input->post('email'),$this->input->post('password')),htmlspecialchars_decode(stripslashes($template[0]->message))).'
'; $this->email->from($cinfo[0]->email, $cinfo[0]->company_name); $this->email->to($this->input->post('email')); $this->email->subject($subject); $this->email->message($message); $this->email->send(); } } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } } /* add and update employee details info */ // Validate and update info in database // basic info public function basic_info() { if($this->input->post('type')=='basic_info') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); /* Server side PHP input validation */ if($this->input->post('first_name')==='') { $Return['error'] = $this->lang->line('xin_employee_error_first_name'); } else if(preg_match("/^(\pL{1,}[ ]?)+$/u",$this->input->post('first_name'))!=1) { $Return['error'] = $this->lang->line('xin_hr_string_error'); } else if($this->input->post('last_name')==='') { $Return['error'] = $this->lang->line('xin_employee_error_last_name'); } else if(preg_match("/^(\pL{1,}[ ]?)+$/u",$this->input->post('last_name'))!=1) { $Return['error'] = $this->lang->line('xin_hr_string_error'); } else if($this->input->post('employee_id')==='') { $Return['error'] = $this->lang->line('xin_employee_error_employee_id'); } else if($this->input->post('username')==='') { $Return['error'] = $this->lang->line('xin_employee_error_username'); } else if($this->input->post('email')==='') { $Return['error'] = $this->lang->line('xin_employee_error_email'); } else if (!filter_var($this->input->post('email'), FILTER_VALIDATE_EMAIL)) { $Return['error'] = $this->lang->line('xin_employee_error_invalid_email'); } else if($this->input->post('company_id')==='') { $Return['error'] = $this->lang->line('error_company_field'); } else if($this->input->post('department_id')==='') { $Return['error'] = $this->lang->line('xin_employee_error_department'); } else if($this->input->post('designation_id')==='') { $Return['error'] = $this->lang->line('xin_employee_error_designation'); } else if($this->input->post('date_of_birth')==='') { $Return['error'] = $this->lang->line('xin_employee_error_date_of_birth'); } else if($this->Xin_model->validate_date($this->input->post('date_of_birth'),'Y-m-d') == false) { $Return['error'] = $this->lang->line('xin_hr_date_format_error'); } else if($this->input->post('date_of_joining')==='') { $Return['error'] = $this->lang->line('xin_employee_error_joining_date'); } else if($this->Xin_model->validate_date($this->input->post('date_of_joining'),'Y-m-d') == false) { $Return['error'] = $this->lang->line('xin_hr_date_format_error'); } else if($this->input->post('role')==='') { $Return['error'] = $this->lang->line('xin_employee_error_user_role'); } else if($this->input->post('contact_no')==='') { $Return['error'] = $this->lang->line('xin_employee_error_contact_number'); } else if(!preg_match('/^([0-9]*)$/', $this->input->post('contact_no'))) { $Return['error'] = $this->lang->line('xin_hr_numeric_error'); } if($Return['error']!=''){ $this->output($Return); } $first_name = $this->Xin_model->clean_post($this->input->post('first_name')); $last_name = $this->Xin_model->clean_post($this->input->post('last_name')); $employee_id = $this->input->post('employee_id'); $date_of_joining = $this->Xin_model->clean_date_post($this->input->post('date_of_joining')); //$username = $this->Xin_model->clean_post($this->input->post('username')); $username = $this->input->post('username'); $date_of_birth = $this->Xin_model->clean_date_post($this->input->post('date_of_birth')); $contact_no = $this->Xin_model->clean_post($this->input->post('contact_no')); $address = $this->Xin_model->clean_post($this->input->post('address')); $leave_categories = array($this->input->post('leave_categories')); $cat_ids = implode(',',$this->input->post('leave_categories')); $data = array( 'employee_id' => $employee_id, 'office_shift_id' => $this->input->post('office_shift_id'), 'first_name' => $first_name, 'last_name' => $last_name, 'username' => $username, 'company_id' => $this->input->post('company_id'), 'email' => $this->input->post('email'), 'date_of_birth' => $date_of_birth, 'gender' => $this->input->post('gender'), 'user_role_id' => $this->input->post('role'), 'department_id' => $this->input->post('department_id'), 'designation_id' => $this->input->post('designation_id'), 'date_of_joining' => $date_of_joining, 'contact_no' => $contact_no, 'address' => $address, 'leave_categories' => $cat_ids, 'date_of_leaving' => $this->input->post('date_of_leaving'), 'marital_status' => $this->input->post('marital_status'), 'is_active' => $this->input->post('status'), ); $id = $this->input->post('user_id'); $result = $this->Employees_model->basic_info($data,$id); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_basic_info_updated'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } } // Validate and update info in database // social info public function profile_picture() { if($this->input->post('type')=='profile_picture') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); $id = $this->input->post('user_id'); /* Check if file uploaded..*/ if($_FILES['p_file']['size'] == 0 && null ==$this->input->post('remove_profile_picture')) { $Return['error'] = $this->lang->line('xin_employee_select_picture'); } else { if(is_uploaded_file($_FILES['p_file']['tmp_name'])) { //checking image type $allowed = array('png','jpg','jpeg','pdf','gif'); $filename = $_FILES['p_file']['name']; $ext = pathinfo($filename, PATHINFO_EXTENSION); if(in_array($ext,$allowed)){ $tmp_name = $_FILES["p_file"]["tmp_name"]; $profile = "uploads/profile/"; $set_img = base_url()."uploads/profile/"; // basename() may prevent filesystem traversal attacks; // further validation/sanitation of the filename may be appropriate $name = basename($_FILES["p_file"]["name"]); $newfilename = 'profile_'.round(microtime(true)).'.'.$ext; move_uploaded_file($tmp_name, $profile.$newfilename); $fname = $newfilename; //UPDATE Employee info in DB $data = array('profile_picture' => $fname); $result = $this->Employees_model->profile_picture($data,$id); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_picture_updated'); $Return['img'] = $set_img.$fname; } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } else { $Return['error'] = $this->lang->line('xin_employee_picture_type'); } } } if(null!=$this->input->post('remove_profile_picture')) { //UPDATE Employee info in DB $data = array('profile_picture' => 'no file'); $row = $this->Employees_model->read_employee_information($id); $profile = base_url()."uploads/profile/"; $result = $this->Employees_model->profile_picture($data,$id); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_picture_updated'); if($row[0]->gender=='Male') { $Return['img'] = $profile.'default_male.jpg'; } else { $Return['img'] = $profile.'default_female.jpg'; } } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } if($Return['error']!=''){ $this->output($Return); } } } // Validate and update info in database // basic info public function social_info() { if($this->input->post('type')=='social_info') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); if ($this->input->post('facebook_link')!=='' && !filter_var($this->input->post('facebook_link'), FILTER_VALIDATE_URL)) { $Return['error'] = $this->lang->line('xin_hr_fb_field_error'); } else if ($this->input->post('twitter_link')!=='' && !filter_var($this->input->post('twitter_link'), FILTER_VALIDATE_URL)) { $Return['error'] = $this->lang->line('xin_hr_twitter_field_error'); } else if ($this->input->post('blogger_link')!=='' && !filter_var($this->input->post('blogger_link'), FILTER_VALIDATE_URL)) { $Return['error'] = $this->lang->line('xin_hr_blogger_field_error'); } else if ($this->input->post('linkdedin_link')!=='' && !filter_var($this->input->post('linkdedin_link'), FILTER_VALIDATE_URL)) { $Return['error'] = $this->lang->line('xin_hr_linkedin_field_error'); } else if ($this->input->post('google_plus_link')!=='' && !filter_var($this->input->post('google_plus_link'), FILTER_VALIDATE_URL)) { $Return['error'] = $this->lang->line('xin_hr_gplus_field_error'); } else if ($this->input->post('instagram_link')!=='' && !filter_var($this->input->post('instagram_link'), FILTER_VALIDATE_URL)) { $Return['error'] = $this->lang->line('xin_hr_instagram_field_error'); } else if ($this->input->post('pinterest_link')!=='' && !filter_var($this->input->post('pinterest_link'), FILTER_VALIDATE_URL)) { $Return['error'] = $this->lang->line('xin_hr_pinterest_field_error'); } else if ($this->input->post('youtube_link')!=='' && !filter_var($this->input->post('youtube_link'), FILTER_VALIDATE_URL)) { $Return['error'] = $this->lang->line('xin_hr_youtube_field_error'); } if($Return['error']!=''){ $this->output($Return); } $data = array( 'facebook_link' => $this->input->post('facebook_link'), 'twitter_link' => $this->input->post('twitter_link'), 'blogger_link' => $this->input->post('blogger_link'), 'linkdedin_link' => $this->input->post('linkdedin_link'), 'google_plus_link' => $this->input->post('google_plus_link'), 'instagram_link' => $this->input->post('instagram_link'), 'pinterest_link' => $this->input->post('pinterest_link'), 'youtube_link' => $this->input->post('youtube_link') ); $id = $this->input->post('user_id'); $result = $this->Employees_model->social_info($data,$id); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_success_update_social_info'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } } // Validate and update info in database // contact info public function update_contacts_info() { if($this->input->post('type')=='contact_info') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); /* Server side PHP input validation */ /* Server side PHP input validation */ if($this->input->post('salutation')==='') { $Return['error'] = $this->lang->line('xin_employee_error_salutation'); } else if($this->input->post('contact_name')==='') { $Return['error'] = $this->lang->line('xin_employee_error_contact_name'); } else if($this->input->post('relation')==='') { $Return['error'] = $this->lang->line('xin_employee_error_grp'); } else if($this->input->post('primary_email')==='') { $Return['error'] = $this->lang->line('xin_employee_error_pemail'); } else if($this->input->post('mobile_phone')==='') { $Return['error'] = $this->lang->line('xin_employee_error_mobile'); } else if($this->input->post('city')==='') { $Return['error'] = $this->lang->line('xin_error_city_field'); } else if($this->input->post('country')==='') { $Return['error'] = $this->lang->line('xin_error_country_field'); } if($Return['error']!=''){ $this->output($Return); } $data = array( 'salutation' => $this->input->post('salutation'), 'contact_name' => $this->input->post('contact_name'), 'relation' => $this->input->post('relation'), 'company' => $this->input->post('company'), 'job_title' => $this->input->post('job_title'), 'primary_email' => $this->input->post('primary_email'), 'mobile_phone' => $this->input->post('mobile_phone'), 'address' => $this->input->post('address'), 'city' => $this->input->post('city'), 'state' => $this->input->post('state'), 'zipcode' => $this->input->post('zipcode'), 'country' => $this->input->post('country'), 'employee_id' => $this->input->post('user_id'), 'contact_type' => 'permanent' ); $query = $this->Employees_model->check_employee_contact_permanent($this->input->post('user_id')); if ($query->num_rows() > 0 ) { $res = $query->result(); $e_field_id = $res[0]->contact_id; $result = $this->Employees_model->contact_info_update($data,$e_field_id); } else { $result = $this->Employees_model->contact_info_add($data); } if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_contact_info_updated'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } } // Validate and update info in database // econtact info public function update_contact_info() { if($this->input->post('type')=='contact_info') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); /* Server side PHP input validation */ /* Server side PHP input validation */ if($this->input->post('salutation')==='') { $Return['error'] = $this->lang->line('xin_employee_error_salutation'); } else if($this->input->post('contact_name')==='') { $Return['error'] = $this->lang->line('xin_employee_error_contact_name'); } else if($this->input->post('relation')==='') { $Return['error'] = $this->lang->line('xin_employee_error_grp'); } else if($this->input->post('primary_email')==='') { $Return['error'] = $this->lang->line('xin_employee_error_pemail'); } else if($this->input->post('mobile_phone')==='') { $Return['error'] = $this->lang->line('xin_employee_error_mobile'); } else if($this->input->post('city')==='') { $Return['error'] = $this->lang->line('xin_error_city_field'); } else if($this->input->post('country')==='') { $Return['error'] = $this->lang->line('xin_error_country_field'); } if($Return['error']!=''){ $this->output($Return); } $data = array( 'salutation' => $this->input->post('salutation'), 'contact_name' => $this->input->post('contact_name'), 'relation' => $this->input->post('relation'), 'company' => $this->input->post('company'), 'job_title' => $this->input->post('job_title'), 'primary_email' => $this->input->post('primary_email'), 'mobile_phone' => $this->input->post('mobile_phone'), 'address' => $this->input->post('address'), 'city' => $this->input->post('city'), 'state' => $this->input->post('state'), 'zipcode' => $this->input->post('zipcode'), 'country' => $this->input->post('country'), 'employee_id' => $this->input->post('user_id'), 'contact_type' => 'current' ); $query = $this->Employees_model->check_employee_contact_current($this->input->post('user_id')); if ($query->num_rows() > 0 ) { $res = $query->result(); $e_field_id = $res[0]->contact_id; $result = $this->Employees_model->contact_info_update($data,$e_field_id); } else { $result = $this->Employees_model->contact_info_add($data); } //$e_field_id = 1; if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_contact_info_updated'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } } // Validate and update info in database // contact info public function contact_info() { if($this->input->post('type')=='contact_info') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); /* Server side PHP input validation */ if($this->input->post('relation')==='') { $Return['error'] = $this->lang->line('xin_employee_error_relation'); } else if($this->input->post('contact_name')==='') { $Return['error'] = $this->lang->line('xin_employee_error_contact_name'); } else if(!preg_match("/^(\pL{1,}[ ]?)+$/u",$this->input->post('contact_name'))) { $Return['error'] = $this->lang->line('xin_hr_string_error'); } else if($this->input->post('contact_no')!=='' && !preg_match('/^([0-9]*)$/', $this->input->post('contact_no'))) { $Return['error'] = $this->lang->line('xin_hr_numeric_error'); } else if($this->input->post('work_phone')!=='' && !preg_match('/^([0-9]*)$/', $this->input->post('work_phone'))) { $Return['error'] = $this->lang->line('xin_hr_numeric_error'); } else if($this->input->post('work_phone_extension')!=='' && !preg_match('/^([0-9]*)$/', $this->input->post('work_phone_extension'))) { $Return['error'] = $this->lang->line('xin_hr_numeric_error'); } else if($this->input->post('mobile_phone')==='') { $Return['error'] = $this->lang->line('xin_employee_error_mobile'); } else if(!preg_match('/^([0-9]*)$/', $this->input->post('mobile_phone'))) { $Return['error'] = $this->lang->line('xin_hr_numeric_error'); } else if($this->input->post('home_phone')!=='' && !preg_match('/^([0-9]*)$/', $this->input->post('home_phone'))) { $Return['error'] = $this->lang->line('xin_hr_numeric_error'); } else if($this->input->post('work_email')==='') { $Return['error'] = $this->lang->line('xin_employee_error_email'); } else if (!filter_var($this->input->post('work_email'), FILTER_VALIDATE_EMAIL)) { $Return['error'] = $this->lang->line('xin_employee_error_invalid_email'); } else if ($this->input->post('personal_email')!=='' && !filter_var($this->input->post('personal_email'), FILTER_VALIDATE_EMAIL)) { $Return['error'] = $this->lang->line('xin_employee_error_invalid_email'); } else if($this->input->post('zipcode')!=='' && !preg_match('/^([0-9]*)$/', $this->input->post('zipcode'))) { $Return['error'] = $this->lang->line('xin_hr_numeric_error'); } if(null!=$this->input->post('is_primary')) { $is_primary = $this->input->post('is_primary'); } else { $is_primary = ''; } if(null!=$this->input->post('is_dependent')) { $is_dependent = $this->input->post('is_dependent'); } else { $is_dependent = ''; } if($Return['error']!=''){ $this->output($Return); } $contact_name = $this->Xin_model->clean_post($this->input->post('contact_name')); $address_1 = $this->Xin_model->clean_post($this->input->post('address_1')); $address_2 = $this->Xin_model->clean_post($this->input->post('address_2')); $city = $this->Xin_model->clean_post($this->input->post('city')); $state = $this->Xin_model->clean_post($this->input->post('state')); $data = array( 'relation' => $this->input->post('relation'), 'work_email' => $this->input->post('work_email'), 'is_primary' => $is_primary, 'is_dependent' => $is_dependent, 'personal_email' => $this->input->post('personal_email'), 'contact_name' => $contact_name, 'address_1' => $address_1, 'work_phone' => $this->input->post('work_phone'), 'work_phone_extension' => $this->input->post('work_phone_extension'), 'address_2' => $address_2, 'mobile_phone' => $this->input->post('mobile_phone'), 'city' => $city, 'state' => $state, 'zipcode' => $this->input->post('zipcode'), 'home_phone' => $this->input->post('home_phone'), 'country' => $this->input->post('country'), 'employee_id' => $this->input->post('user_id'), 'created_at' => date('d-m-Y'), ); $result = $this->Employees_model->contact_info_add($data); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_contact_info_added'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } } // Validate and update info in database // econtact info public function e_contact_info() { if($this->input->post('type')=='e_contact_info') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); /* Server side PHP input validation */ if($this->input->post('relation')==='') { $Return['error'] = $this->lang->line('xin_employee_error_relation'); } else if($this->input->post('contact_name')==='') { $Return['error'] = $this->lang->line('xin_employee_error_contact_name'); } else if($this->input->post('mobile_phone')==='') { $Return['error'] = $this->lang->line('xin_employee_error_mobile'); } if(null!=$this->input->post('is_primary')) { $is_primary = $this->input->post('is_primary'); } else { $is_primary = ''; } if(null!=$this->input->post('is_dependent')) { $is_dependent = $this->input->post('is_dependent'); } else { $is_dependent = ''; } if($Return['error']!=''){ $this->output($Return); } $data = array( 'relation' => $this->input->post('relation'), 'work_email' => $this->input->post('work_email'), 'is_primary' => $is_primary, 'is_dependent' => $is_dependent, 'personal_email' => $this->input->post('personal_email'), 'contact_name' => $this->input->post('contact_name'), 'address_1' => $this->input->post('address_1'), 'work_phone' => $this->input->post('work_phone'), 'work_phone_extension' => $this->input->post('work_phone_extension'), 'address_2' => $this->input->post('address_2'), 'mobile_phone' => $this->input->post('mobile_phone'), 'city' => $this->input->post('city'), 'state' => $this->input->post('state'), 'zipcode' => $this->input->post('zipcode'), 'home_phone' => $this->input->post('home_phone'), 'country' => $this->input->post('country') ); $e_field_id = $this->input->post('e_field_id'); $result = $this->Employees_model->contact_info_update($data,$e_field_id); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_contact_info_updated'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } } // Validate and add info in database // document info public function document_info() { if($this->input->post('type')=='document_info' && $this->input->post('data')=='document_info') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); /* Server side PHP input validation */ if($this->input->post('document_type_id')==='') { $Return['error'] = $this->lang->line('xin_employee_error_d_type'); } else if($this->Xin_model->validate_date($this->input->post('date_of_expiry'),'Y-m-d') == false) { $Return['error'] = $this->lang->line('xin_hr_date_format_error'); } else if($this->input->post('title')==='') { $Return['error'] = $this->lang->line('xin_employee_error_document_title'); } else if(preg_match("/^(\pL{1,}[ ]?)+$/u",$this->input->post('title')) != 1) { $Return['error'] = $this->lang->line('xin_hr_string_error'); } else if($this->input->post('email')==='') { $Return['error'] = $this->lang->line('xin_error_notify_email_field'); } else if(!filter_var($this->input->post('email'), FILTER_VALIDATE_EMAIL)) { $Return['error'] = $this->lang->line('xin_employee_error_invalid_email'); } /* Check if file uploaded..*/ else if($_FILES['document_file']['size'] == 0) { $Return['error'] = $this->lang->line('xin_employee_select_d_file'); } else { if(is_uploaded_file($_FILES['document_file']['tmp_name'])) { //checking image type $allowed = array('png','jpg','jpeg','pdf','gif','txt','pdf','xls','xlsx','doc','docx'); $filename = $_FILES['document_file']['name']; $ext = pathinfo($filename, PATHINFO_EXTENSION); if(in_array($ext,$allowed)){ $tmp_name = $_FILES["document_file"]["tmp_name"]; $documentd = "uploads/document/"; // basename() may prevent filesystem traversal attacks; // further validation/sanitation of the filename may be appropriate $name = basename($_FILES["document_file"]["name"]); $newfilename = 'document_'.round(microtime(true)).'.'.$ext; move_uploaded_file($tmp_name, $documentd.$newfilename); $fname = $newfilename; } else { $Return['error'] = $this->lang->line('xin_employee_document_file_type'); } } } if($Return['error']!=''){ $this->output($Return); } //clean simple fields $title = $this->Xin_model->clean_post($this->input->post('title')); $description = $this->Xin_model->clean_post($this->input->post('description')); // clean date fields $date_of_expiry = $this->Xin_model->clean_date_post($this->input->post('date_of_expiry')); $data = array( 'document_type_id' => $this->input->post('document_type_id'), 'date_of_expiry' => $date_of_expiry, 'document_file' => $fname, 'title' => $title, 'notification_email' => $this->input->post('email'), 'is_alert' => $this->input->post('send_mail'), 'description' => $description, 'employee_id' => $this->input->post('user_id'), 'created_at' => date('d-m-Y'), ); $result = $this->Employees_model->document_info_add($data); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_d_info_added'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } } // Validate and add info in database // document info public function immigration_info() { if($this->input->post('type')=='immigration_info' && $this->input->post('data')=='immigration_info') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); //preg_match("/^(\pL{1,}[ ]?)+$/u", /* Server side PHP input validation */ if($this->input->post('document_type_id')==='') { $Return['error'] = $this->lang->line('xin_employee_error_d_type'); } else if($this->input->post('document_number')==='') { $Return['error'] = $this->lang->line('xin_employee_error_d_number'); } else if($this->input->post('issue_date')==='') { $Return['error'] = $this->lang->line('xin_employee_error_d_issue'); } else if($this->Xin_model->validate_date($this->input->post('issue_date'),'Y-m-d') == false) { $Return['error'] = $this->lang->line('xin_hr_date_format_error'); } else if($this->input->post('expiry_date')==='') { $Return['error'] = $this->lang->line('xin_employee_error_expiry_date'); } else if($this->Xin_model->validate_date($this->input->post('expiry_date'),'Y-m-d') == false) { $Return['error'] = $this->lang->line('xin_hr_date_format_error'); } /* Check if file uploaded..*/ else if($_FILES['document_file']['size'] == 0) { $Return['error'] = $this->lang->line('xin_employee_select_d_file'); } else { if(is_uploaded_file($_FILES['document_file']['tmp_name'])) { //checking image type $allowed = array('png','jpg','jpeg','pdf','gif','txt','pdf','xls','xlsx','doc','docx'); $filename = $_FILES['document_file']['name']; $ext = pathinfo($filename, PATHINFO_EXTENSION); if(in_array($ext,$allowed)){ $tmp_name = $_FILES["document_file"]["tmp_name"]; $documentd = "uploads/document/immigration/"; // basename() may prevent filesystem traversal attacks; // further validation/sanitation of the filename may be appropriate $name = basename($_FILES["document_file"]["name"]); $newfilename = 'document_'.round(microtime(true)).'.'.$ext; move_uploaded_file($tmp_name, $documentd.$newfilename); $fname = $newfilename; } else { $Return['error'] = $this->lang->line('xin_employee_document_file_type'); } } } if($Return['error']!=''){ $this->output($Return); } $document_number = $this->Xin_model->clean_post($this->input->post('document_number')); $issue_date = $this->Xin_model->clean_date_post($this->input->post('issue_date')); $expiry_date = $this->Xin_model->clean_date_post($this->input->post('expiry_date')); $eligible_review_date = $this->Xin_model->clean_date_post($this->input->post('eligible_review_date')); $data = array( 'document_type_id' => $this->input->post('document_type_id'), 'document_number' => $document_number, 'document_file' => $fname, 'issue_date' => $issue_date, 'expiry_date' => $expiry_date, 'country_id' => $this->input->post('country'), 'eligible_review_date' => $eligible_review_date, 'employee_id' => $this->input->post('user_id'), 'created_at' => date('d-m-Y h:i:s'), ); $result = $this->Employees_model->immigration_info_add($data); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_img_info_added'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } } // Validate and add info in database // document info public function e_immigration_info() { if($this->input->post('type')=='e_immigration_info' && $this->input->post('data')=='e_immigration_info') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); /* Server side PHP input validation */ if($this->input->post('document_type_id')==='') { $Return['error'] = $this->lang->line('xin_employee_error_d_type'); } else if($this->input->post('document_number')==='') { $Return['error'] = $this->lang->line('xin_employee_error_d_number'); } else if($this->input->post('issue_date')==='') { $Return['error'] = $this->lang->line('xin_employee_error_d_issue'); } else if($this->input->post('expiry_date')==='') { $Return['error'] = $this->lang->line('xin_employee_error_expiry_date'); } /* Check if file uploaded..*/ else if($_FILES['document_file']['size'] == 0) { $data = array( 'document_type_id' => $this->input->post('document_type_id'), 'document_number' => $this->input->post('document_number'), 'issue_date' => $this->input->post('issue_date'), 'expiry_date' => $this->input->post('expiry_date'), 'country_id' => $this->input->post('country'), 'eligible_review_date' => $this->input->post('eligible_review_date'), ); $e_field_id = $this->input->post('e_field_id'); $result = $this->Employees_model->img_document_info_update($data,$e_field_id); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_img_info_updated'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } else { if(is_uploaded_file($_FILES['document_file']['tmp_name'])) { //checking image type $allowed = array('png','jpg','jpeg','pdf','gif','txt','pdf','xls','xlsx','doc','docx'); $filename = $_FILES['document_file']['name']; $ext = pathinfo($filename, PATHINFO_EXTENSION); if(in_array($ext,$allowed)){ $tmp_name = $_FILES["document_file"]["tmp_name"]; $documentd = "uploads/document/immigration/"; // basename() may prevent filesystem traversal attacks; // further validation/sanitation of the filename may be appropriate $name = basename($_FILES["document_file"]["name"]); $newfilename = 'document_'.round(microtime(true)).'.'.$ext; move_uploaded_file($tmp_name, $documentd.$newfilename); $fname = $newfilename; $data = array( 'document_type_id' => $this->input->post('document_type_id'), 'document_number' => $this->input->post('document_number'), 'document_file' => $fname, 'issue_date' => $this->input->post('issue_date'), 'expiry_date' => $this->input->post('expiry_date'), 'country_id' => $this->input->post('country'), 'eligible_review_date' => $this->input->post('eligible_review_date'), ); $e_field_id = $this->input->post('e_field_id'); $result = $this->Employees_model->img_document_info_update($data,$e_field_id); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_d_info_updated'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } else { $Return['error'] = $this->lang->line('xin_employee_document_file_type'); } } } if($Return['error']!=''){ $this->output($Return); } if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_img_info_added'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } } // Validate and add info in database // e_document info public function e_document_info() { if($this->input->post('type')=='e_document_info') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); /* Server side PHP input validation */ if($this->input->post('document_type_id')==='') { $Return['error'] = $this->lang->line('xin_employee_error_d_type'); } else if($this->input->post('title')==='') { $Return['error'] = $this->lang->line('xin_employee_error_document_title'); } else if($this->input->post('email')==='') { $Return['error'] = $this->lang->line('xin_error_notify_email_field'); } /* Check if file uploaded..*/ else if($_FILES['document_file']['size'] == 0) { $data = array( 'document_type_id' => $this->input->post('document_type_id'), 'date_of_expiry' => $this->input->post('date_of_expiry'), 'title' => $this->input->post('title'), 'notification_email' => $this->input->post('email'), 'is_alert' => $this->input->post('send_mail'), 'description' => $this->input->post('description') ); $e_field_id = $this->input->post('e_field_id'); $result = $this->Employees_model->document_info_update($data,$e_field_id); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_d_info_updated'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } else { if(is_uploaded_file($_FILES['document_file']['tmp_name'])) { //checking image type $allowed = array('png','jpg','jpeg','pdf','gif','txt','pdf','xls','xlsx','doc','docx'); $filename = $_FILES['document_file']['name']; $ext = pathinfo($filename, PATHINFO_EXTENSION); if(in_array($ext,$allowed)){ $tmp_name = $_FILES["document_file"]["tmp_name"]; $documentd = "uploads/document/"; // basename() may prevent filesystem traversal attacks; // further validation/sanitation of the filename may be appropriate $name = basename($_FILES["document_file"]["name"]); $newfilename = 'document_'.round(microtime(true)).'.'.$ext; move_uploaded_file($tmp_name, $documentd.$newfilename); $fname = $newfilename; $data = array( 'document_type_id' => $this->input->post('document_type_id'), 'date_of_expiry' => $this->input->post('date_of_expiry'), 'document_file' => $fname, 'title' => $this->input->post('title'), 'notification_email' => $this->input->post('email'), 'is_alert' => $this->input->post('send_mail'), 'description' => $this->input->post('description') ); $e_field_id = $this->input->post('e_field_id'); $result = $this->Employees_model->document_info_update($data,$e_field_id); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_d_info_updated'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } else { $Return['error'] = $this->lang->line('xin_employee_document_file_type'); } } } if($Return['error']!=''){ $this->output($Return); } } } // Validate and add info in database // qualification info public function qualification_info() { if($this->input->post('type')=='qualification_info') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); /* Server side PHP input validation */ $from_year = $this->input->post('from_year'); $to_year = $this->input->post('to_year'); $st_date = strtotime($from_year); $ed_date = strtotime($to_year); if($this->input->post('name')==='') { $Return['error'] = $this->lang->line('xin_employee_error_sch_uni'); } else if(preg_match("/^(\pL{1,}[ ]?)+$/u",$this->input->post('name'))!=1) { $Return['error'] = $this->lang->line('xin_hr_string_error'); } else if($this->input->post('from_year')==='') { $Return['error'] = $this->lang->line('xin_employee_error_frm_date'); } else if($this->Xin_model->validate_date($this->input->post('from_year'),'Y-m-d') == false) { $Return['error'] = $this->lang->line('xin_hr_date_format_error'); } else if($this->input->post('to_year')==='') { $Return['error'] = $this->lang->line('xin_employee_error_to_date'); } else if($this->Xin_model->validate_date($this->input->post('to_year'),'Y-m-d') == false) { $Return['error'] = $this->lang->line('xin_hr_date_format_error'); } else if($st_date > $ed_date) { $Return['error'] = $this->lang->line('xin_employee_error_date_shouldbe'); } if($Return['error']!=''){ $this->output($Return); } $name = $this->Xin_model->clean_post($this->input->post('name')); $from_year = $this->Xin_model->clean_date_post($this->input->post('from_year')); $to_year = $this->Xin_model->clean_date_post($this->input->post('to_year')); $description = $this->Xin_model->clean_post($this->input->post('description')); $data = array( 'name' => $name, 'education_level_id' => $this->input->post('education_level'), 'from_year' => $from_year, 'language_id' => $this->input->post('language'), 'to_year' => $this->input->post('to_year'), 'skill_id' => $this->input->post('skill'), 'description' => $description, 'employee_id' => $this->input->post('user_id'), 'created_at' => date('d-m-Y'), ); $result = $this->Employees_model->qualification_info_add($data); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_error_q_info_added'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } } // Validate and add info in database // qualification info public function e_qualification_info() { if($this->input->post('type')=='e_qualification_info') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); /* Server side PHP input validation */ $from_year = $this->input->post('from_year'); $to_year = $this->input->post('to_year'); $st_date = strtotime($from_year); $ed_date = strtotime($to_year); if($this->input->post('name')==='') { $Return['error'] = $this->lang->line('xin_employee_error_sch_uni'); } else if($this->input->post('from_year')==='') { $Return['error'] = $this->lang->line('xin_employee_error_frm_date'); } else if($this->input->post('to_year')==='') { $Return['error'] = $this->lang->line('xin_employee_error_to_date'); } else if($st_date > $ed_date) { $Return['error'] = $this->lang->line('xin_employee_error_date_shouldbe'); } if($Return['error']!=''){ $this->output($Return); } $data = array( 'name' => $this->input->post('name'), 'education_level_id' => $this->input->post('education_level'), 'from_year' => $this->input->post('from_year'), 'language_id' => $this->input->post('language'), 'to_year' => $this->input->post('to_year'), 'skill_id' => $this->input->post('skill'), 'description' => $this->input->post('description') ); $e_field_id = $this->input->post('e_field_id'); $result = $this->Employees_model->qualification_info_update($data,$e_field_id); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_error_q_info_updated'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } } // Validate and add info in database // work experience info public function work_experience_info() { if($this->input->post('type')=='work_experience_info') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); $frm_date = strtotime($this->input->post('from_date')); $to_date = strtotime($this->input->post('to_date')); /* Server side PHP input validation */ if($this->input->post('company_name')==='') { $Return['error'] = $this->lang->line('xin_employee_error_company_name'); } else if($this->input->post('post')==='') { $Return['error'] = $this->lang->line('xin_employee_error_post'); } else if($this->input->post('from_date')==='') { $Return['error'] = $this->lang->line('xin_employee_error_frm_date'); } else if($this->input->post('to_date')==='') { $Return['error'] = $this->lang->line('xin_employee_error_to_date'); } else if($frm_date > $to_date) { $Return['error'] = $this->lang->line('xin_employee_error_date_shouldbe'); } if($Return['error']!=''){ $this->output($Return); } $data = array( 'company_name' => $this->input->post('company_name'), 'from_date' => $this->input->post('from_date'), 'to_date' => $this->input->post('to_date'), 'post' => $this->input->post('post'), 'description' => $this->input->post('description'), 'employee_id' => $this->input->post('user_id'), 'created_at' => date('d-m-Y'), ); $result = $this->Employees_model->work_experience_info_add($data); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_error_w_exp_added'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } } public function e_work_experience_info() { if($this->input->post('type')=='e_work_experience_info') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); $frm_date = strtotime($this->input->post('from_date')); $to_date = strtotime($this->input->post('to_date')); /* Server side PHP input validation */ if($this->input->post('company_name')==='') { $Return['error'] = $this->lang->line('xin_employee_error_company_name'); } else if($this->input->post('from_date')==='') { $Return['error'] = $this->lang->line('xin_employee_error_frm_date'); } else if($this->input->post('to_date')==='') { $Return['error'] = $this->lang->line('xin_employee_error_to_date'); } else if($frm_date > $to_date) { $Return['error'] = $this->lang->line('xin_employee_error_date_shouldbe'); } else if($this->input->post('post')==='') { $Return['error'] = $this->lang->line('xin_employee_error_post'); } if($Return['error']!=''){ $this->output($Return); } $data = array( 'company_name' => $this->input->post('company_name'), 'from_date' => $this->input->post('from_date'), 'to_date' => $this->input->post('to_date'), 'post' => $this->input->post('post'), 'description' => $this->input->post('description') ); $e_field_id = $this->input->post('e_field_id'); $result = $this->Employees_model->work_experience_info_update($data,$e_field_id); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_error_w_exp_updated'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } } // Validate and add info in database // bank account info public function bank_account_info() { if($this->input->post('type')=='bank_account_info') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); /* Server side PHP input validation */ if($this->input->post('account_title')==='') { $Return['error'] = $this->lang->line('xin_employee_error_acc_title'); } else if(preg_match("/^(\pL{1,}[ ]?)+$/u",$this->input->post('account_title'))!=1) { $Return['error'] = $this->lang->line('xin_hr_string_error'); } else if($this->input->post('account_number')==='') { $Return['error'] = $this->lang->line('xin_employee_error_acc_number'); } else if($this->input->post('bank_name')==='') { $Return['error'] = $this->lang->line('xin_employee_error_bank_name'); } else if($this->input->post('bank_code')==='') { $Return['error'] = $this->lang->line('xin_employee_error_bank_code'); } if($Return['error']!=''){ $this->output($Return); } $data = array( 'account_title' => $this->input->post('account_title'), 'account_number' => $this->input->post('account_number'), 'bank_name' => $this->input->post('bank_name'), 'bank_code' => $this->input->post('bank_code'), 'bank_branch' => $this->input->post('bank_branch'), 'employee_id' => $this->input->post('user_id'), 'created_at' => date('d-m-Y'), ); $result = $this->Employees_model->bank_account_info_add($data); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_error_bank_info_added'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } } // Validate and add info in database // ebank account info public function e_bank_account_info() { if($this->input->post('type')=='e_bank_account_info') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); /* Server side PHP input validation */ if($this->input->post('account_title')==='') { $Return['error'] = $this->lang->line('xin_employee_error_acc_title'); } else if($this->input->post('account_number')==='') { $Return['error'] = $this->lang->line('xin_employee_error_acc_number'); } else if($this->input->post('bank_name')==='') { $Return['error'] = $this->lang->line('xin_employee_error_bank_name'); } else if($this->input->post('bank_code')==='') { $Return['error'] = $this->lang->line('xin_employee_error_bank_code'); } if($Return['error']!=''){ $this->output($Return); } $data = array( 'account_title' => $this->input->post('account_title'), 'account_number' => $this->input->post('account_number'), 'bank_name' => $this->input->post('bank_name'), 'bank_code' => $this->input->post('bank_code'), 'bank_branch' => $this->input->post('bank_branch') ); $e_field_id = $this->input->post('e_field_id'); $result = $this->Employees_model->bank_account_info_update($data,$e_field_id); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_error_bank_info_updated'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } } // Validate and add info in database //contract info public function contract_info() { if($this->input->post('type')=='contract_info') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); $frm_date = strtotime($this->input->post('from_date')); $to_date = strtotime($this->input->post('to_date')); /* Server side PHP input validation */ if($this->input->post('contract_type_id')==='') { $Return['error'] = $this->lang->line('xin_employee_error_contract_type'); } else if($this->input->post('title')==='') { $Return['error'] = $this->lang->line('xin_employee_error_contract_title'); } else if($this->input->post('from_date')==='') { $Return['error'] = $this->lang->line('xin_employee_error_frm_date'); } else if($this->input->post('to_date')==='') { $Return['error'] = $this->lang->line('xin_employee_error_to_date'); } else if($frm_date > $to_date) { $Return['error'] = $this->lang->line('xin_employee_error_frm_to_date'); } else if($this->input->post('designation_id')==='') { $Return['error'] = $this->lang->line('xin_employee_error_designation'); } if($Return['error']!=''){ $this->output($Return); } $data = array( 'contract_type_id' => $this->input->post('contract_type_id'), 'title' => $this->input->post('title'), 'from_date' => $this->input->post('from_date'), 'to_date' => $this->input->post('to_date'), 'designation_id' => $this->input->post('designation_id'), 'description' => $this->input->post('description'), 'employee_id' => $this->input->post('user_id'), 'created_at' => date('d-m-Y'), ); $result = $this->Employees_model->contract_info_add($data); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_contract_info_added'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } } // Validate and add info in database //e contract info public function e_contract_info() { if($this->input->post('type')=='e_contract_info') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); $frm_date = strtotime($this->input->post('from_date')); $to_date = strtotime($this->input->post('to_date')); /* Server side PHP input validation */ if($this->input->post('contract_type_id')==='') { $Return['error'] = $this->lang->line('xin_employee_error_contract_type'); } else if($this->input->post('title')==='') { $Return['error'] = $this->lang->line('xin_employee_error_contract_title'); } else if($this->input->post('from_date')==='') { $Return['error'] = $this->lang->line('xin_employee_error_frm_date'); } else if($this->input->post('to_date')==='') { $Return['error'] = $this->lang->line('xin_employee_error_to_date'); } else if($frm_date > $to_date) { $Return['error'] = $this->lang->line('xin_employee_error_frm_to_date'); } else if($this->input->post('designation_id')==='') { $Return['error'] = $this->lang->line('xin_employee_error_designation'); } if($Return['error']!=''){ $this->output($Return); } $data = array( 'contract_type_id' => $this->input->post('contract_type_id'), 'title' => $this->input->post('title'), 'from_date' => $this->input->post('from_date'), 'to_date' => $this->input->post('to_date'), 'designation_id' => $this->input->post('designation_id'), 'description' => $this->input->post('description') ); $e_field_id = $this->input->post('e_field_id'); $result = $this->Employees_model->contract_info_update($data,$e_field_id); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_contract_info_updated'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } } // Validate and add info in database //leave_info public function leave_info() { if($this->input->post('type')=='leave_info') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); /* Server side PHP input validation */ if($this->input->post('contract_id')==='') { $Return['error'] = $this->lang->line('xin_employee_error_contract_f'); } if($Return['error']!=''){ $this->output($Return); } $data = array( 'contract_id' => $this->input->post('contract_id'), 'casual_leave' => $this->input->post('casual_leave'), 'medical_leave' => $this->input->post('medical_leave'), 'employee_id' => $this->input->post('user_id'), 'created_at' => date('d-m-Y'), ); $result = $this->Employees_model->leave_info_add($data); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_leave_info_added'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } } // Validate and add info in database //Eleave_info public function e_leave_info() { if($this->input->post('type')=='e_leave_info') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); if($Return['error']!=''){ $this->output($Return); } $data = array( 'casual_leave' => $this->input->post('casual_leave'), 'medical_leave' => $this->input->post('medical_leave') ); $e_field_id = $this->input->post('e_field_id'); $result = $this->Employees_model->leave_info_update($data,$e_field_id); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_leave_info_updated'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } } // Validate and add info in database // shift info public function shift_info() { if($this->input->post('type')=='shift_info') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); /* Server side PHP input validation */ if($this->input->post('from_date')==='') { $Return['error'] = $this->lang->line('xin_employee_error_frm_date'); } else if($this->input->post('shift_id')==='') { $Return['error'] = $this->lang->line('xin_employee_error_shift_field'); } if($Return['error']!=''){ $this->output($Return); } $data = array( 'from_date' => $this->input->post('from_date'), 'to_date' => $this->input->post('to_date'), 'shift_id' => $this->input->post('shift_id'), 'employee_id' => $this->input->post('user_id'), 'created_at' => date('d-m-Y'), ); $result = $this->Employees_model->shift_info_add($data); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_shift_info_added'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } } // Validate and add info in database // eshift info public function e_shift_info() { if($this->input->post('type')=='e_shift_info') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); if($this->input->post('from_date')==='') { $Return['error'] = $this->lang->line('xin_employee_error_frm_date'); } $data = array( 'from_date' => $this->input->post('from_date'), 'to_date' => $this->input->post('to_date') ); $e_field_id = $this->input->post('e_field_id'); $result = $this->Employees_model->shift_info_update($data,$e_field_id); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_shift_info_updated'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } } // Validate and add info in database // location info public function location_info() { if($this->input->post('type')=='location_info') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); /* Server side PHP input validation */ if($this->input->post('from_date')==='') { $Return['error'] = $this->lang->line('xin_employee_error_frm_date'); } else if($this->input->post('location_id')==='') { $Return['error'] = $this->lang->line('error_location_dept_field'); } if($Return['error']!=''){ $this->output($Return); } $data = array( 'from_date' => $this->input->post('from_date'), 'to_date' => $this->input->post('to_date'), 'location_id' => $this->input->post('location_id'), 'employee_id' => $this->input->post('user_id'), 'created_at' => date('d-m-Y'), ); $result = $this->Employees_model->location_info_add($data); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_location_info_added'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } } // Validate and add info in database // elocation info public function e_location_info() { if($this->input->post('type')=='e_location_info') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); /* Server side PHP input validation */ if($this->input->post('from_date')==='') { $Return['error'] = $this->lang->line('xin_employee_error_frm_date'); } else if($this->input->post('location_id')==='') { $Return['error'] = $this->lang->line('error_location_dept_field'); } if($Return['error']!=''){ $this->output($Return); } $data = array( 'from_date' => $this->input->post('from_date'), 'to_date' => $this->input->post('to_date') ); $e_field_id = $this->input->post('e_field_id'); $result = $this->Employees_model->location_info_update($data,$e_field_id); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_location_info_updated'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } } // Validate and add info in database // update_allowance_info public function update_allowance_info() { if($this->input->post('type')=='e_allowance_info') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); /* Server side PHP input validation */ if($this->input->post('allowance_title')==='') { $Return['error'] = $this->lang->line('xin_employee_set_allowance_title_error'); } else if($this->input->post('allowance_amount')==='') { $Return['error'] = $this->lang->line('xin_employee_set_allowance_amount_error'); } if($Return['error']!=''){ $this->output($Return); } $data = array( 'allowance_title' => $this->input->post('allowance_title'), 'allowance_amount' => $this->input->post('allowance_amount') ); $e_field_id = $this->input->post('e_field_id'); $result = $this->Employees_model->salary_allowance_update_record($data,$e_field_id); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_updated_allowance_success'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } } // Validate and update info in database // change password public function change_password() { if($this->input->post('type')=='change_password') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); /* Server side PHP input validation */ if(trim($this->input->post('new_password'))==='') { $Return['error'] = $this->lang->line('xin_employee_error_newpassword'); } else if(strlen($this->input->post('new_password')) < 6) { $Return['error'] = $this->lang->line('xin_employee_error_password_least'); } else if(trim($this->input->post('new_password_confirm'))==='') { $Return['error'] = $this->lang->line('xin_employee_error_new_cpassword'); } else if($this->input->post('new_password')!=$this->input->post('new_password_confirm')) { $Return['error'] = $this->lang->line('xin_employee_error_old_new_cpassword'); } if($Return['error']!=''){ $this->output($Return); } $options = array('cost' => 12); $password_hash = password_hash($this->input->post('new_password'), PASSWORD_BCRYPT, $options); $data = array( 'password' => $password_hash ); $id = $this->input->post('user_id'); $result = $this->Employees_model->change_password($data,$id); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_password_update'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } } /* get all employee details lisitng *////////////////// // employee contacts - listing public function contacts() { $data['title'] = $this->Xin_model->site_title(); $session = $this->session->userdata('username'); if(!empty($session)){ $this->load->view("admin/employees/profile", $data); } else { redirect('admin/'); } // Datatables Variables $draw = intval($this->input->get("draw")); $start = intval($this->input->get("start")); $length = intval($this->input->get("length")); $id = $this->uri->segment(4); $contacts = $this->Employees_model->set_employee_contacts($id); $data = array(); foreach($contacts->result() as $r) { if($r->is_primary==1){ $primary = ''.$this->lang->line('xin_employee_primary').''; } else { $primary = ''; } if($r->is_dependent==2){ $dependent = ''.$this->lang->line('xin_employee_dependent').''; } else { $dependent = ''; } $data[] = array( '', $r->contact_name . ' ' .$primary . ' '.$dependent, $r->relation, $r->work_email, $r->mobile_phone ); } $output = array( "draw" => $draw, "recordsTotal" => $contacts->num_rows(), "recordsFiltered" => $contacts->num_rows(), "data" => $data ); echo json_encode($output); exit(); } // employee documents - listing public function documents() { //set data $data['title'] = $this->Xin_model->site_title(); $session = $this->session->userdata('username'); if(!empty($session)){ $this->load->view("admin/employees/employee_detail", $data); } else { redirect('admin/'); } // Datatables Variables $draw = intval($this->input->get("draw")); $start = intval($this->input->get("start")); $length = intval($this->input->get("length")); $id = $this->uri->segment(4); $documents = $this->Employees_model->set_employee_documents($id); $data = array(); foreach($documents->result() as $r) { $d_type = $this->Employees_model->read_document_type_information($r->document_type_id); if(!is_null($d_type)){ $document_d = $d_type[0]->document_type; } else { $document_d = '--'; } $date_of_expiry = $this->Xin_model->set_date_format($r->date_of_expiry); if($r->document_file!='' && $r->document_file!='no file') { $functions = ''; } else { $functions =''; } if($r->is_alert==1){ $alert = ''; } else { $alert = ''; } $data[] = array( $alert.$functions.'', $document_d, $r->title, $r->notification_email, $date_of_expiry ); } $output = array( "draw" => $draw, "recordsTotal" => $documents->num_rows(), "recordsFiltered" => $documents->num_rows(), "data" => $data ); echo json_encode($output); exit(); } // employee immigration - listing public function immigration() { //set data $data['title'] = $this->Xin_model->site_title(); $session = $this->session->userdata('username'); if(!empty($session)){ $this->load->view("admin/employees/employee_detail", $data); } else { redirect('admin/'); } // Datatables Variables $draw = intval($this->input->get("draw")); $start = intval($this->input->get("start")); $length = intval($this->input->get("length")); $id = $this->uri->segment(4); $immigration = $this->Employees_model->set_employee_immigration($id); $data = array(); foreach($immigration->result() as $r) { $issue_date = $this->Xin_model->set_date_format($r->issue_date); $expiry_date = $this->Xin_model->set_date_format($r->expiry_date); $eligible_review_date = $this->Xin_model->set_date_format($r->eligible_review_date); $d_type = $this->Employees_model->read_document_type_information($r->document_type_id); if(!is_null($d_type)){ $document_d = $d_type[0]->document_type.'
'.$r->document_number; } else { $document_d = $r->document_number; } $country = $this->Xin_model->read_country_info($r->country_id); if(!is_null($country)){ $c_name = $country[0]->country_name; } else { $c_name = '--'; } $data[] = array( '', $document_d, $issue_date, $expiry_date, $c_name, $eligible_review_date, ); } $output = array( "draw" => $draw, "recordsTotal" => $immigration->num_rows(), "recordsFiltered" => $immigration->num_rows(), "data" => $data ); echo json_encode($output); exit(); } // employee qualification - listing public function qualification() { //set data $data['title'] = $this->Xin_model->site_title(); $session = $this->session->userdata('username'); if(!empty($session)){ $this->load->view("admin/employees/employee_detail", $data); } else { redirect('admin/'); } // Datatables Variables $draw = intval($this->input->get("draw")); $start = intval($this->input->get("start")); $length = intval($this->input->get("length")); $id = $this->uri->segment(4); $qualification = $this->Employees_model->set_employee_qualification($id); $data = array(); foreach($qualification->result() as $r) { $education = $this->Employees_model->read_education_information($r->education_level_id); if(!is_null($education)){ $edu_name = $education[0]->name; } else { $edu_name = '--'; } // $language = $this->Employees_model->read_qualification_language_information($r->language_id); /*if($r->skill_id == 'no course') { $ol = 'No Course'; } else { $ol = '
    '; foreach(explode(',',$r->skill_id) as $desig_id) { $skill = $this->Employees_model->read_qualification_skill_information($desig_id); $ol .= '
  1. '.$skill[0]->name.'
    2. '; } $ol .= '
'; }*/ $sdate = $this->Xin_model->set_date_format($r->from_year); $edate = $this->Xin_model->set_date_format($r->to_year); $time_period = $sdate.' - '.$edate; // get date $pdate = $time_period; $data[] = array( '', $r->name, $pdate, $edu_name ); } $output = array( "draw" => $draw, "recordsTotal" => $qualification->num_rows(), "recordsFiltered" => $qualification->num_rows(), "data" => $data ); echo json_encode($output); exit(); } // employee work experience - listing public function experience() { //set data $data['title'] = $this->Xin_model->site_title(); $session = $this->session->userdata('username'); if(!empty($session)){ $this->load->view("admin/employees/employee_detail", $data); } else { redirect('admin/'); } // Datatables Variables $draw = intval($this->input->get("draw")); $start = intval($this->input->get("start")); $length = intval($this->input->get("length")); $id = $this->uri->segment(4); $experience = $this->Employees_model->set_employee_experience($id); $data = array(); foreach($experience->result() as $r) { $from_date = $this->Xin_model->set_date_format($r->from_date); $to_date = $this->Xin_model->set_date_format($r->to_date); $data[] = array( '', $r->company_name, $from_date, $to_date, $r->post, $r->description ); } $output = array( "draw" => $draw, "recordsTotal" => $experience->num_rows(), "recordsFiltered" => $experience->num_rows(), "data" => $data ); echo json_encode($output); exit(); } // employee bank account - listing public function bank_account() { //set data $data['title'] = $this->Xin_model->site_title(); $session = $this->session->userdata('username'); if(!empty($session)){ $this->load->view("admin/employees/employee_detail", $data); } else { redirect('admin/'); } // Datatables Variables $draw = intval($this->input->get("draw")); $start = intval($this->input->get("start")); $length = intval($this->input->get("length")); $id = $this->uri->segment(4); $bank_account = $this->Employees_model->set_employee_bank_account($id); $data = array(); foreach($bank_account->result() as $r) { $data[] = array( '', $r->account_title, $r->account_number, $r->bank_name, $r->bank_code, $r->bank_branch ); } $output = array( "draw" => $draw, "recordsTotal" => $bank_account->num_rows(), "recordsFiltered" => $bank_account->num_rows(), "data" => $data ); echo json_encode($output); exit(); } // employee contract - listing public function contract() { //set data $data['title'] = $this->Xin_model->site_title(); $session = $this->session->userdata('username'); if(!empty($session)){ $this->load->view("admin/employees/employee_detail", $data); } else { redirect('admin/'); } // Datatables Variables $draw = intval($this->input->get("draw")); $start = intval($this->input->get("start")); $length = intval($this->input->get("length")); $id = $this->uri->segment(4); $contract = $this->Employees_model->set_employee_contract($id); $data = array(); foreach($contract->result() as $r) { // designation $designation = $this->Designation_model->read_designation_information($r->designation_id); if(!is_null($designation)){ $designation_name = $designation[0]->designation_name; } else { $designation_name = '--'; } //contract type $contract_type = $this->Employees_model->read_contract_type_information($r->contract_type_id); if(!is_null($contract_type)){ $ctype = $contract_type[0]->name; } else { $ctype = '--'; } // date $duration = $this->Xin_model->set_date_format($r->from_date).' '.$this->lang->line('dashboard_to').' '.$this->Xin_model->set_date_format($r->to_date); $data[] = array( '', $duration, $designation_name, $ctype, $r->title ); } $output = array( "draw" => $draw, "recordsTotal" => $contract->num_rows(), "recordsFiltered" => $contract->num_rows(), "data" => $data ); echo json_encode($output); exit(); } // employee leave - listing public function leave() { //set data $data['title'] = $this->Xin_model->site_title(); $session = $this->session->userdata('username'); if(!empty($session)){ $this->load->view("admin/employees/employee_detail", $data); } else { redirect('admin/'); } // Datatables Variables $draw = intval($this->input->get("draw")); $start = intval($this->input->get("start")); $length = intval($this->input->get("length")); $id = $this->uri->segment(4); $leave = $this->Employees_model->set_employee_leave($id); $data = array(); foreach($leave->result() as $r) { // contract $contract = $this->Employees_model->read_contract_information($r->contract_id); if(!is_null($contract)){ // contract duration $duration = $this->Xin_model->set_date_format($contract[0]->from_date).' '.$this->lang->line('dashboard_to').' '.$this->Xin_model->set_date_format($contract[0]->to_date); $ctitle = $contract[0]->title.' '.$duration; } else { $ctitle = '--'; } $contracti = $ctitle; $data[] = array( '', $contracti, $r->casual_leave, $r->medical_leave ); } $output = array( "draw" => $draw, "recordsTotal" => $leave->num_rows(), "recordsFiltered" => $leave->num_rows(), "data" => $data ); echo json_encode($output); exit(); } // employee office shift - listing public function shift() { //set data $data['title'] = $this->Xin_model->site_title(); $session = $this->session->userdata('username'); if(!empty($session)){ $this->load->view("admin/employees/employee_detail", $data); } else { redirect('admin/'); } // Datatables Variables $draw = intval($this->input->get("draw")); $start = intval($this->input->get("start")); $length = intval($this->input->get("length")); $id = $this->uri->segment(4); $shift = $this->Employees_model->set_employee_shift($id); $data = array(); foreach($shift->result() as $r) { // contract $shift_info = $this->Employees_model->read_shift_information($r->shift_id); // contract duration $duration = $this->Xin_model->set_date_format($r->from_date).' '.$this->lang->line('dashboard_to').' '.$this->Xin_model->set_date_format($r->to_date); if(!is_null($shift_info)){ $shift_name = $shift_info[0]->shift_name; } else { $shift_name = '--'; } $data[] = array( '', $duration, $shift_name ); } $output = array( "draw" => $draw, "recordsTotal" => $shift->num_rows(), "recordsFiltered" => $shift->num_rows(), "data" => $data ); echo json_encode($output); exit(); } // employee location - listing public function location() { //set data $data['title'] = $this->Xin_model->site_title(); $session = $this->session->userdata('username'); if(!empty($session)){ $this->load->view("admin/employees/employee_detail", $data); } else { redirect('admin/'); } // Datatables Variables $draw = intval($this->input->get("draw")); $start = intval($this->input->get("start")); $length = intval($this->input->get("length")); $id = $this->uri->segment(4); $location = $this->Employees_model->set_employee_location($id); $data = array(); foreach($location->result() as $r) { // contract $of_location = $this->Location_model->read_location_information($r->location_id); // contract duration $duration = $this->Xin_model->set_date_format($r->from_date).' '.$this->lang->line('dashboard_to').' '.$this->Xin_model->set_date_format($r->to_date); if(!is_null($of_location)){ $location_name = $of_location[0]->location_name; } else { $location_name = '--'; } $data[] = array( '', $duration, $location_name ); } $output = array( "draw" => $draw, "recordsTotal" => $location->num_rows(), "recordsFiltered" => $location->num_rows(), "data" => $data ); echo json_encode($output); exit(); } // Validate and update info in database public function update() { if($this->input->post('edit_type')=='warning') { $id = $this->uri->segment(4); /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); /* Server side PHP input validation */ $description = $this->input->post('description'); $qt_description = htmlspecialchars(addslashes($description), ENT_QUOTES); if($this->input->post('warning_to')==='') { $Return['error'] = $this->lang->line('xin_employee_error_warning'); } else if($this->input->post('type')==='') { $Return['error'] = $this->lang->line('xin_employee_error_warning_type'); } else if($this->input->post('subject')==='') { $Return['error'] = $this->lang->line('xin_employee_error_subject'); } else if($this->input->post('warning_by')==='') { $Return['error'] = $this->lang->line('xin_employee_error_warning_by'); } else if($this->input->post('warning_date')==='') { $Return['error'] = $this->lang->line('xin_employee_error_warning_date'); } if($Return['error']!=''){ $this->output($Return); } $data = array( 'warning_to' => $this->input->post('warning_to'), 'warning_type_id' => $this->input->post('type'), 'description' => $qt_description, 'subject' => $this->input->post('subject'), 'warning_by' => $this->input->post('warning_by'), 'warning_date' => $this->input->post('warning_date'), 'status' => $this->input->post('status'), ); $result = $this->Warning_model->update_record($data,$id); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_warning_updated'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } } // import > timesheet public function import() { $session = $this->session->userdata('username'); if(empty($session)){ redirect('admin/'); } $data['title'] = $this->lang->line('xin_import_employees').' | '.$this->Xin_model->site_title(); $data['breadcrumbs'] = $this->lang->line('xin_import_employees'); $data['path_url'] = 'import_employees'; $data['all_employees'] = $this->Xin_model->all_employees(); $data['all_departments'] = $this->Department_model->all_departments(); $data['all_designations'] = $this->Designation_model->all_designations(); $data['all_user_roles'] = $this->Roles_model->all_user_roles(); $data['all_office_shifts'] = $this->Employees_model->all_office_shifts(); $data['get_all_companies'] = $this->Xin_model->get_companies(); $role_resources_ids = $this->Xin_model->user_role_resource(); if(in_array('92',$role_resources_ids)) { if(!empty($session)){ $data['subview'] = $this->load->view("admin/employees/employes_import", $data, TRUE); $this->load->view('admin/layout/layout_main', $data); //page load } else { redirect('admin/'); } } else { redirect('admin/dashboard'); } } // Validate and add info in database public function import_employees() { if($this->input->post('is_ajax')=='3') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); //validate whether uploaded file is a csv file $csvMimes = array('text/x-comma-separated-values', 'text/comma-separated-values', 'application/octet-stream', 'application/vnd.ms-excel', 'application/x-csv', 'text/x-csv', 'text/csv', 'application/csv', 'application/excel', 'application/vnd.msexcel', 'text/plain'); if($this->input->post('company_id')==='') { $Return['error'] = $this->lang->line('error_company_field'); } else if($this->input->post('department_id')==='') { $Return['error'] = $this->lang->line('xin_employee_error_department'); } else if($this->input->post('designation_id')==='') { $Return['error'] = $this->lang->line('xin_employee_error_designation'); } else if($this->input->post('role')==='') { $Return['error'] = $this->lang->line('xin_employee_error_user_role'); } else if($_FILES['file']['name']==='') { $Return['error'] = $this->lang->line('xin_employee_imp_allowed_size'); } else { if(in_array($_FILES['file']['type'],$csvMimes)){ if(is_uploaded_file($_FILES['file']['tmp_name'])){ // check file size if(filesize($_FILES['file']['tmp_name']) > 2000000) { $Return['error'] = $this->lang->line('xin_error_employees_import_size'); } else { //open uploaded csv file with read only mode $csvFile = fopen($_FILES['file']['tmp_name'], 'r'); //skip first line fgetcsv($csvFile); //parse data from csv file line by line while(($line = fgetcsv($csvFile)) !== FALSE){ $data = array( 'company_id' => $this->input->post('company_id'), 'department_id' =>$this->input->post('department_id'), 'designation_id' => $this->input->post('designation_id'), 'user_role_id' => $this->input->post('role'), 'office_shift_id' => 1, 'is_active' => 1, 'first_name' => $line[0], 'last_name' => $line[1], 'username' => $line[2], 'email' => $line[3], 'password' => $line[4], 'employee_id' => $line[5], 'date_of_joining' => $line[6], 'gender' => $line[7], 'date_of_birth' => $line[8], 'contact_no' => $line[9], 'address' => $line[10], 'created_at' => date('Y-m-d h:i:s') ); $result = $this->Employees_model->add($data); } //close opened csv file fclose($csvFile); $Return['result'] = $this->lang->line('xin_success_attendance_import'); } }else{ $Return['error'] = $this->lang->line('xin_error_not_employee_import'); } }else{ $Return['error'] = $this->lang->line('xin_error_invalid_file'); } } // file empty if($Return['error']!=''){ $this->output($Return); } $this->output($Return); exit; } } // delete contact record public function delete_contact() { if($this->input->post('data')=='delete_record') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $id = $this->uri->segment(4); $result = $this->Employees_model->delete_contact_record($id); $Return['csrf_hash'] = $this->security->get_csrf_hash(); if(isset($id)) { $Return['result'] = $this->lang->line('xin_employee_contact_deleted'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); } } // delete document record public function delete_document() { if($this->input->post('data')=='delete_record') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $id = $this->uri->segment(4); $Return['csrf_hash'] = $this->security->get_csrf_hash(); $result = $this->Employees_model->delete_document_record($id); if(isset($id)) { $Return['result'] = $this->lang->line('xin_employee_document_deleted'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); } } // delete document record public function delete_imgdocument() { if($this->input->post('data')=='delete_record') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $id = $this->uri->segment(4); $result = $this->Employees_model->delete_imgdocument_record($id); $Return['csrf_hash'] = $this->security->get_csrf_hash(); if(isset($id)) { $Return['result'] = $this->lang->line('xin_employee_img_document_deleted'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); } } // delete qualification record public function delete_qualification() { if($this->input->post('data')=='delete_record') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); $id = $this->uri->segment(4); $result = $this->Employees_model->delete_qualification_record($id); if(isset($id)) { $Return['result'] = $this->lang->line('xin_employee_qualification_deleted'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); } } // delete work_experience record public function delete_work_experience() { if($this->input->post('data')=='delete_record') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); $id = $this->uri->segment(4); $result = $this->Employees_model->delete_work_experience_record($id); if(isset($id)) { $Return['result'] = $this->lang->line('xin_employee_work_deleted'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); } } // delete bank_account record public function delete_bank_account() { if($this->input->post('data')=='delete_record') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); $id = $this->uri->segment(4); $result = $this->Employees_model->delete_bank_account_record($id); if(isset($id)) { $Return['result'] = $this->lang->line('xin_employee_bankaccount_deleted'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); } } // delete contract record public function delete_contract() { if($this->input->post('data')=='delete_record') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); $id = $this->uri->segment(4); $result = $this->Employees_model->delete_contract_record($id); if(isset($id)) { $Return['result'] = $this->lang->line('xin_employee_contract_deleted'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); } } // delete leave record public function delete_leave() { if($this->input->post('data')=='delete_record') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); $id = $this->uri->segment(4); $result = $this->Employees_model->delete_leave_record($id); if(isset($id)) { $Return['result'] = $this->lang->line('xin_employee_leave_deleted'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); } } // delete shift record public function delete_shift() { if($this->input->post('data')=='delete_record') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); $id = $this->uri->segment(4); $result = $this->Employees_model->delete_shift_record($id); if(isset($id)) { $Return['result'] = $this->lang->line('xin_employee_shift_deleted'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); } } // delete location record public function delete_location() { if($this->input->post('data')=='delete_record') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); $id = $this->uri->segment(4); $result = $this->Employees_model->delete_location_record($id); if(isset($id)) { $Return['result'] = $this->lang->line('xin_employee_location_deleted'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); } } // delete employee record public function delete() { if($this->input->post('is_ajax')=='2') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); $id = $this->uri->segment(4); $result = $this->Employees_model->delete_record($id); if(isset($id)) { $Return['result'] = $this->lang->line('xin_employee_current_deleted'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); } } // Validate and update info in database // basic info public function update_salary_option() { if($this->input->post('type')=='employee_update_salary') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); if($this->input->post('wages_type')=='1') { if($this->input->post('basic_salary')==='') { $Return['error'] = $this->lang->line('xin_employee_salary_error_basic'); } } else if($this->input->post('wages_type')=='2') { if($this->input->post('daily_wages')==='') { $Return['error'] = $this->lang->line('xin_employee_salary_error_daily'); } } if($Return['error']!=''){ $this->output($Return); } $data = array( 'wages_type' => $this->input->post('wages_type'), 'basic_salary' => $this->input->post('basic_salary'), 'daily_wages' => $this->input->post('daily_wages') ); $id = $this->input->post('user_id'); $result = $this->Employees_model->basic_info($data,$id); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_updated_salary_success'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } } // Validate and update info in database // basic info public function set_overtime() { if($this->input->post('type')=='emp_overtime') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); if($this->input->post('overtime_type')==='') { $Return['error'] = $this->lang->line('xin_employee_set_overtime_title_error'); } else if($this->input->post('no_of_days')==='') { $Return['error'] = $this->lang->line('xin_employee_set_overtime_no_of_days_error'); } else if($this->input->post('overtime_hours')==='') { $Return['error'] = $this->lang->line('xin_employee_set_overtime_hours_error'); } else if($this->input->post('overtime_rate')==='') { $Return['error'] = $this->lang->line('xin_employee_set_overtime_rate_error'); } if($Return['error']!=''){ $this->output($Return); } $data = array( 'employee_id' => $this->input->post('user_id'), 'overtime_type' => $this->input->post('overtime_type'), 'no_of_days' => $this->input->post('no_of_days'), 'overtime_hours' => $this->input->post('overtime_hours'), 'overtime_rate' => $this->input->post('overtime_rate') ); $id = $this->input->post('user_id'); $result = $this->Employees_model->add_salary_overtime($data); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_added_overtime_success'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } } // Validate and update info in database // basic info public function update_overtime_info() { if($this->input->post('type')=='e_overtime_info') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); if($this->input->post('overtime_type')==='') { $Return['error'] = $this->lang->line('xin_employee_set_overtime_title_error'); } else if($this->input->post('no_of_days')==='') { $Return['error'] = $this->lang->line('xin_employee_set_overtime_no_of_days_error'); } else if($this->input->post('overtime_hours')==='') { $Return['error'] = $this->lang->line('xin_employee_set_overtime_hours_error'); } else if($this->input->post('overtime_rate')==='') { $Return['error'] = $this->lang->line('xin_employee_set_overtime_rate_error'); } if($Return['error']!=''){ $this->output($Return); } $id = $this->input->post('e_field_id'); $data = array( 'overtime_type' => $this->input->post('overtime_type'), 'no_of_days' => $this->input->post('no_of_days'), 'overtime_hours' => $this->input->post('overtime_hours'), 'overtime_rate' => $this->input->post('overtime_rate') ); //$id = $this->input->post('user_id'); $result = $this->Employees_model->salary_overtime_update_record($data,$id); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_updated_overtime_success'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } } // Validate and update info in database // basic info public function employee_allowance_option() { if($this->input->post('type')=='employee_update_allowance') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); if($this->input->post('allowance_title')==='') { $Return['error'] = $this->lang->line('xin_employee_set_allowance_title_error'); } else if($this->input->post('allowance_amount')==='') { $Return['error'] = $this->lang->line('xin_employee_set_allowance_amount_error'); } if($Return['error']!=''){ $this->output($Return); } $data = array( 'allowance_title' => $this->input->post('allowance_title'), 'allowance_amount' => $this->input->post('allowance_amount'), 'employee_id' => $this->input->post('user_id') ); $result = $this->Employees_model->add_alary_allowances($data); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_set_allowance_success'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } } // delete location record public function delete_all_allowances() { if($this->input->post('data')=='delete_record') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); $id = $this->uri->segment(4); $result = $this->Employees_model->delete_allowance_record($id); if(isset($id)) { $Return['result'] = $this->lang->line('xin_employee_delete_allowance_success'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); } } // delete location record public function delete_all_deductions() { if($this->input->post('data')=='delete_record') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); $id = $this->uri->segment(4); $result = $this->Employees_model->delete_loan_record($id); if(isset($id)) { $Return['result'] = $this->lang->line('xin_employee_delete_loan_success'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); } } // delete location record public function delete_emp_overtime() { if($this->input->post('data')=='delete_record') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); $id = $this->uri->segment(4); $result = $this->Employees_model->delete_overtime_record($id); if(isset($id)) { $Return['result'] = $this->lang->line('xin_employee_delete_overtime_success'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); } } // employee all_allowances public function salary_all_allowances() { //set data $data['title'] = $this->Xin_model->site_title(); $session = $this->session->userdata('username'); if(!empty($session)){ $this->load->view("admin/employees/employee_detail", $data); } else { redirect('admin/'); } // Datatables Variables $draw = intval($this->input->get("draw")); $start = intval($this->input->get("start")); $length = intval($this->input->get("length")); $id = $this->uri->segment(4); $allowances = $this->Employees_model->set_employee_allowances($id); $data = array(); /*$system = $this->Xin_model->read_setting_info(1); $default_currency = $this->Xin_model->read_currency_con_info($system[0]->default_currency_id); if(!is_null($default_currency)) { $current_rate = $default_currency[0]->to_currency_rate; $current_title = $default_currency[0]->to_currency_title; } else { $current_rate = 1; $current_title = 'USD'; }*/ foreach($allowances->result() as $r) { //$current_amount = $r->allowance_amount * $current_rate; $data[] = array( '', $r->allowance_title, $r->allowance_amount ); } $output = array( "draw" => $draw, "recordsTotal" => $allowances->num_rows(), "recordsFiltered" => $allowances->num_rows(), "data" => $data ); echo json_encode($output); exit(); } // employee overtime public function salary_overtime() { //set data $data['title'] = $this->Xin_model->site_title(); $session = $this->session->userdata('username'); if(!empty($session)){ $this->load->view("admin/employees/employee_detail", $data); } else { redirect('admin/'); } // Datatables Variables $draw = intval($this->input->get("draw")); $start = intval($this->input->get("start")); $length = intval($this->input->get("length")); $id = $this->uri->segment(4); $overtime = $this->Employees_model->set_employee_overtime($id); $system = $this->Xin_model->read_setting_info(1); $data = array(); foreach($overtime->result() as $r) { $current_amount = $r->overtime_rate; $data[] = array( '', $r->overtime_type, $r->no_of_days, $r->overtime_hours, $current_amount ); } $output = array( "draw" => $draw, "recordsTotal" => $overtime->num_rows(), "recordsFiltered" => $overtime->num_rows(), "data" => $data ); echo json_encode($output); exit(); } // employee salary_all_deductions public function salary_all_deductions() { //set data $data['title'] = $this->Xin_model->site_title(); $session = $this->session->userdata('username'); if(!empty($session)){ $this->load->view("admin/employees/employee_detail", $data); } else { redirect('admin/'); } // Datatables Variables $draw = intval($this->input->get("draw")); $start = intval($this->input->get("start")); $length = intval($this->input->get("length")); $id = $this->uri->segment(4); $deductions = $this->Employees_model->set_employee_deductions($id); /*$system = $this->Xin_model->read_setting_info(1); $default_currency = $this->Xin_model->read_currency_con_info($system[0]->default_currency_id); if(!is_null($default_currency)) { $current_rate = $default_currency[0]->to_currency_rate; $current_title = $default_currency[0]->to_currency_title; } else { $current_rate = 1; $current_title = 'USD'; }*/ $data = array(); foreach($deductions->result() as $r) { $sdate = $this->Xin_model->set_date_format($r->start_date); $edate = $this->Xin_model->set_date_format($r->end_date); // loan time if($r->loan_time < 2) { $loan_time = $r->loan_time. ' '.$this->lang->line('xin_employee_loan_time_single_month'); } else { $loan_time = $r->loan_time. ' '.$this->lang->line('xin_employee_loan_time_more_months'); } //$current_amount = $r->monthly_installment * $current_rate; //$eoption_removed = ''; $data[] = array( '', $r->loan_deduction_title, $r->monthly_installment, $sdate, $edate, $loan_time ); } $output = array( "draw" => $draw, "recordsTotal" => $deductions->num_rows(), "recordsFiltered" => $deductions->num_rows(), "data" => $data ); echo json_encode($output); exit(); } // Validate and add info in database public function update_loan_info() { if($this->input->post('type')=='loan_info') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); $reason = $this->input->post('reason'); $qt_reason = htmlspecialchars(addslashes($reason), ENT_QUOTES); $start_date = $this->input->post('start_date'); $end_date = $this->input->post('end_date'); $st_date = strtotime($start_date); $ed_date = strtotime($end_date); $id = $this->input->post('e_field_id'); /* Server side PHP input validation */ if($this->input->post('loan_deduction_title')==='') { $Return['error'] = $this->lang->line('xin_employee_set_loan_title_error'); } else if($this->input->post('monthly_installment')==='') { $Return['error'] = $this->lang->line('xin_employee_set_mins_title_error'); } else if($this->input->post('start_date')==='') { $Return['error'] = $this->lang->line('xin_error_start_date'); } else if($this->input->post('end_date')==='') { $Return['error'] = $this->lang->line('xin_error_end_date'); } else if($st_date > $ed_date) { $Return['error'] = $this->lang->line('xin_error_start_end_date'); } if($Return['error']!=''){ $this->output($Return); } $data = array( 'loan_deduction_title' => $this->input->post('loan_deduction_title'), 'reason' => $qt_reason, 'monthly_installment' => $this->input->post('monthly_installment'), 'start_date' => $this->input->post('start_date'), 'end_date' => $this->input->post('end_date') ); $result = $this->Employees_model->salary_loan_update_record($data,$id); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_update_loan_success'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } } // Validate and add info in database public function employee_loan_info() { if($this->input->post('type')=='loan_info') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); $reason = $this->input->post('reason'); $qt_reason = htmlspecialchars(addslashes($reason), ENT_QUOTES); $start_date = $this->input->post('start_date'); $end_date = $this->input->post('end_date'); $st_date = strtotime($start_date); $ed_date = strtotime($end_date); $user_id = $this->input->post('user_id'); /* Server side PHP input validation */ if($this->input->post('loan_deduction_title')==='') { $Return['error'] = $this->lang->line('xin_employee_set_loan_title_error'); } else if($this->input->post('monthly_installment')==='') { $Return['error'] = $this->lang->line('xin_employee_set_mins_title_error'); } else if($this->input->post('start_date')==='') { $Return['error'] = $this->lang->line('xin_error_start_date'); } else if($this->input->post('end_date')==='') { $Return['error'] = $this->lang->line('xin_error_end_date'); } else if($st_date > $ed_date) { $Return['error'] = $this->lang->line('xin_error_start_end_date'); } if($Return['error']!=''){ $this->output($Return); } $tm = $this->Employees_model->get_month_diff($this->input->post('start_date'),$this->input->post('end_date')); if($tm < 1) { $m_ins = $this->input->post('monthly_installment'); } else { $m_ins = $this->input->post('monthly_installment')/$tm; } $data = array( 'loan_deduction_title' => $this->input->post('loan_deduction_title'), 'reason' => $qt_reason, 'monthly_installment' => $this->input->post('monthly_installment'), 'start_date' => $this->input->post('start_date'), 'end_date' => $this->input->post('end_date'), 'loan_time' => $tm, 'loan_deduction_amount' => $m_ins, 'employee_id' => $user_id ); $result = $this->Employees_model->add_salary_loan($data); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_add_loan_success'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } } // Validate and update info in database // basic info public function set_statutory_deductions() { if($this->input->post('type')=='statutory_info') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); $data = array( 'salary_ssempee' => $this->input->post('salary_ssempee'), 'salary_ssempeer' => $this->input->post('salary_ssempeer'), 'salary_income_tax' => $this->input->post('salary_income_tax') ); $id = $this->input->post('user_id'); $result = $this->Employees_model->basic_info($data,$id); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_updated_statutory_deductions'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } } // Validate and update info in database // basic info public function set_other_payments() { if($this->input->post('type')=='other_payments') { /* Define return | here result is used to return user data and error for error message */ $Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>''); $Return['csrf_hash'] = $this->security->get_csrf_hash(); $data = array( 'salary_commission' => $this->input->post('salary_commission'), 'salary_claims' => $this->input->post('salary_claims'), 'salary_paid_leave' => $this->input->post('salary_paid_leave'), 'salary_director_fees' => $this->input->post('salary_director_fees'), 'salary_advance_paid' => $this->input->post('salary_advance_paid') ); $id = $this->input->post('user_id'); $result = $this->Employees_model->basic_info($data,$id); if ($result == TRUE) { $Return['result'] = $this->lang->line('xin_employee_updated_other_pay'); } else { $Return['error'] = $this->lang->line('xin_error_msg'); } $this->output($Return); exit; } } }
Card image

asddd

asddd