1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / ilium_latest / application / controllers /
Filename : EmployeeMaster.php
back
<?php
defined('BASEPATH') or exit('No direct script access allowed');
class EmployeeMaster extends CI_Controller
{
	public function __construct(){
        parent::__construct();
        $this->load->model('user_account_master_model');
        $this->load->model('user_model');
		$this->load->model('employee_master_model');
		$this->load->model('employee_certificate_master_model');
		$this->load->model('employee_passport_master_model');
		$this->load->model('employee_rp_master_model');
		$this->load->model('employee_cpr_model');
		$this->load->model('employee_salary_model');
		$this->load->model('employee_education_master_model');
		
		$this->load->library('excel');
    }
	
	public function index(){
		validation_privilege('employee_master','view');
		
		$data['options'] 	= validation_option('employee_master');
		$data['page_title'] = "Employee Master";
		$data['content'] 	= "web/hr_module/employee_master_list";
		$this->load->view('web/template', $data);
	}
	
	public function add_employee(){
		$data['page_title'] = "Add Employee";
		$data['content'] 	= "web/hr_module/employee_master_form";
		$this->load->view('web/template', $data);
	}
	
	public function edit_employee($emp_id){
		$data['page_title'] 	= "Edit Employee";
		$data['content'] 		= "web/hr_module/employee_master_form";
		$data['emp_details'] 	= $this->db->select('*')->where('employee_id',$emp_id)->get('employee')->row();
		$this->load->view('web/template', $data);
	}
	
	public function view_employee($emp_id){
		$data['page_title'] 	= "View Employee";
		$data['content'] 		= "web/hr_module/employee_view";
		$data['emp_details'] 	= $this->db->select('*')->where('employee_id',$emp_id)->get('employee')->row();
		$this->load->view('web/template', $data);
	}
	
	public function all_employee_notification(){
		$data['page_title'] 	= "All Employee Notification";
		$data['content'] 		= "web/notification_employee_details";
		$this->load->view('web/template', $data);
	}
	
	public function list_employee_master(){
		$data = $row = array();
		$memData 	= $this->employee_master_model->getRows($_POST);
		$i 			= $_POST['start'];
		$options 	= validation_option('employee_master');
		
		foreach($memData as $member){
			$i++;	
			
			$action = '';
			if(($options->user_menu_add_edit==1) || ($options->user_menu_delete==1)){
				$action .= '<div class="btn-group" role="group">';
					$action .= '<div class="btn-group" role="group">';
						$action .= '<button id="btnGroup'.$member->employee_id.'" type="button" class="btn btn-secondary btn-sm dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Action</button>';
						$action .= '<div class="dropdown-menu" aria-labelledby="btnGroup'.$member->employee_id.'">';
							
							if($options->user_menu_add_edit==1){
								$links   = base_url().'edit_employee/'.$member->employee_id;
								$action .= '<a class="dropdown-item" href="'.$links.'" target="_blank">Edit</a>';
							}
							if($options->user_menu_delete==1){
								$action .= '<a class="dropdown-item delete_data" href="javascript:void(0)" data-id="'.$member->employee_id.'">Delete</a>';
							}
							$links   = base_url().'view_employee/'.$member->employee_id;
							$action .= '<a class="dropdown-item" href="'.$links.'" target="_blank">View</a>';
							
						$action .= '</div>';
					$action .= '</div>';
				$action .= '</div>';
			}else{
				$action = "<p class='text-center'>-</p>";
			}
			
			$data[] = array($i, $member->emp_id,$member->employeename,$member->email,$member->mobile,$member->department_name,$member->designation_name, $action);
		}
		$output = array(
			"draw" 				=> $_POST['draw'],
			"recordsTotal" 		=> $this->employee_master_model->countAll($_POST),
			"recordsFiltered" 	=> $this->employee_master_model->countFiltered($_POST),
			"data" 				=> $data,
		);
		echo json_encode($output);
	}
	
	public function delete_employee_category(){
		$row_id = $this->input->post('keys');
		
		$where = "employee_id='$row_id'";
		$result = $this->common_model->delete('employee',$where);
		
		if($result==true){
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Employee Deleted Successfully',
			);
		}else{
			$output = array(
				'status'	=> 'Warning',
				'msg'		=> 'Unable to Delete Employee Details',
			);
		}
		echo json_encode($output);
	}
	
	
	public function add_edit_employee_details(){
		$row_id			= $this->input->post('employee_row_id');
		$birth_date 	= (!empty($this->input->post('birthdate')))?date('Y-m-d',strtotime($this->input->post('birthdate'))):'';
		$employe_date 	= (!empty($this->input->post('employedDate')))?date('Y-m-d',strtotime($this->input->post('employedDate'))):'';
		$data_arr 		= array(
			'company_id' 			=> $this->input->post('company_id'),
			'emp_id' 				=> $this->input->post('emp_id'),
			'employeename' 			=> $this->input->post('employeename'),
			'employee_status' 		=> $this->input->post('employee_status'),
			'email' 				=> $this->input->post('email'),
			'mobile' 				=> $this->input->post('mobile'),
			'emergency_mobile_no' 	=> $this->input->post('emergency_mobile_no'),
			'contract_type' 		=> $this->input->post('contract_type'),
			'department' 			=> $this->input->post('department'),
			'designation' 			=> $this->input->post('designation'),
			'birthdate' 			=> $birth_date,
			'employedDate' 			=> $employe_date,
			'gender' 				=> $this->input->post('gender'),
			'blood_group' 				=> $this->input->post('blood_group'),
			'nationality'			=> $this->input->post('nationality'),
			'address' 				=> $this->input->post('address'),
			'spousename' 			=> $this->input->post('spousename'),
		);
		
		$test_con 	 = 0;
		$small_image = "";
		if(isset($_FILES["profile_image"]["name"]) && !empty($_FILES["profile_image"]["name"])){
    		$extension 	= pathinfo($_FILES["profile_image"]["name"], PATHINFO_EXTENSION);
    		$filename 	= pathinfo($_FILES['profile_image']['name'], PATHINFO_FILENAME);
    		
    		$config['upload_path']    = EMPLOYEE_PROFILE_IMG_PATH;
    		$config['allowed_types']  = 'jpg|jpeg|png|webp|JPG|JPEG|PNG|WEBP';
    		$config['file_name']      = $filename.rand() . '_' . date('YmdHis') . "." . $extension;	
    		$this->load->library('upload', $config);
    		if(!$this->upload->do_upload('profile_image')){
    			$test_con   = 1;
    			$error      = $this->upload->display_errors();
    		}else{
    			$data           = array('upload_data' => $this->upload->data());
    			$test_con       = 0;
    			$data_arr['profile_image']    = $data['upload_data']['file_name'];
    		}
        }
		
		if($test_con==0){
			if(empty($row_id)){
				$data_arr['created_at'] 	= date('Y-m-d h:i:s');
				$data_arr['created_by'] 	= $this->session->userdata('user_id');
				
				$row_id = $this->common_model->insert('employee',$data_arr);
				$output = array(
					'status'	=> 'Success',
					'msg'		=> 'Employee Details Added Successfully',
					'emp_id'	=> $row_id,
				);
			}else{
				$data_arr['updated_at'] = date('Y-m-d h:i:s');
				$data_arr['updated_by'] = $this->session->userdata('user_id');
				
				$where = "employee_id='".$row_id."'";
				$this->common_model->update('employee',$data_arr,$where);
				$output = array(
					'status'	=> 'Success',
					'msg'		=> 'Employee Details Updated Successfully',
					'emp_id'	=> $row_id,
				);
			}
		}else{
			$output = array(
				'status'	=> 'Error',
				'msg'		=> $error,
			);
		}
		echo json_encode($output);
	}
	
	// Education List Start 
	
	public function add_edit_education_details(){
		$education_row_id 	= $this->input->post('education_row_id');
		$education_emp_id 	= $this->input->post('education_emp_id');
		$year_date 	 		= (!empty($this->input->post('year_date')))?date('Y-m-d',strtotime($this->input->post('year_date'))):'';
		
		$data_arr = array(
		    'education_emp_id' 	=> $education_emp_id,
			'name' 				=> $this->input->post('name'),
			'year_date' 		=> $year_date,
		);
		
		if(empty($education_row_id)){
			$data_arr['created_at'] 	= date('Y-m-d h:i:s');
			$data_arr['created_by'] 	= $this->session->userdata('user_id');
			
			$this->common_model->insert('employee_education',$data_arr);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Education Details Added Successfully',
			);
		}else{
			$data_arr['updated_at'] 	= date('Y-m-d h:i:s');
			$data_arr['updated_by'] 	= $this->session->userdata('user_id');
			
			$where = "id='".$education_row_id."'";
			$this->common_model->update('employee_education',$data_arr,$where);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Education Details Updated Successfully',
			);
		}
		echo json_encode($output);
	}
	
	public function list_education_details(){
		$data = $row = array();
		$memData 	= $this->employee_education_master_model->getRows($_POST);
		$i 			= $_POST['start'];
		
		foreach($memData as $member){
			$i++;
			$action = '';
			
			$action .= '<div class="btn-group" role="group">';
				$action .= '<div class="btn-group" role="group">';
					$action .= '<button id="btnGroupDrop'.$member->id.'" type="button" class="btn btn-secondary btn-sm dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Action</button>';
					$action .= '<div class="dropdown-menu" aria-labelledby="btnGroupDrop'.$member->id.'">';
						$action .= '<a class="dropdown-item edit_education_details" href="javascript:void(0)" data-id="'.$member->id.'">Edit</a>';
						$action .= '<a class="dropdown-item delete_education_details" href="javascript:void(0)" data-id="'.$member->id.'">Delete</a>';
					$action .= '</div>';
				$action .= '</div>';
			$action .= '</div>';
			
			
			$data[] = array($i, $member->name, $member->year_date, $action);
		}
		$output = array(
			"draw" 				=> $_POST['draw'],
			"recordsTotal" 		=> $this->employee_education_master_model->countAll($_POST),
			"recordsFiltered" 	=> $this->employee_education_master_model->countFiltered($_POST),
			"data" 				=> $data,
		);
		echo json_encode($output);
	}
	
	public function edit_education_details(){
		$row_id 	= $this->input->post('keys');
		$details 	= $this->db->select('*')->where('id',$row_id)->get('employee_education')->row_array();
		if(!empty($details)){
			if(!empty($details['passport_issue_date'])){
				$details['passport_issue_date'] = date('d-m-Y',strtotime($details['passport_issue_date']));
			}
			if(!empty($details['passport_expiry_date'])){
				$details['passport_expiry_date'] = date('d-m-Y',strtotime($details['passport_expiry_date']));
			}
			if(!empty($details['passport_file'])){
				$link = base_url().EMPLOYEE_PASSPORT_IMG_PATH.'/'.$details['passport_file'];
				$details['passport_file'] = '<a href="'.$link.'" download="'.$link.'"><i class="fa fa-download"></i> Download</a>';
			}
			
			$output = array(
				'status'	=> 'Success',
				'details'	=> $details,
			);
		}else{
			$output = array(
				'status'	=> 'Warning',
				'info'		=> 'Invaild Records !!!',
			);
		}
		echo json_encode($output);
	}
	
	public function delete_education_details(){
		$row_id = $this->input->post('keys');
		
		$data_arr['deleted'] 	= 1;
		$data_arr['deleted_at'] = date('Y-m-d h:i:s');
		$data_arr['deleted_by'] = $this->session->userdata('user_id');
		
		$where  = "id='".$row_id."'";
		$result = $this->common_model->update('employee_education',$data_arr,$where);
		
		if($result==true){
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Education Details Deleted Successfully',
			);
		}else{
			$output = array(
				'status'	=> 'Warning',
				'msg'		=> 'Unable to Delete the Education Details',
			);
		}
		echo json_encode($output);
	}
	
	// Education List End 

	public function add_edit_passport_details(){
		
		$passport_row_id = $this->input->post('passport_row_id');
		$passport_emp_id = $this->input->post('passport_emp_id');
		$issue_date 	 = (!empty($this->input->post('passport_issue_date')))?date('Y-m-d',strtotime($this->input->post('passport_issue_date'))):'';
		$expiry_date 	 = (!empty($this->input->post('passport_expiry_date')))?date('Y-m-d',strtotime($this->input->post('passport_expiry_date'))):'';
		
		$data_arr = array(
		    'passport_emp_id' 	    => $passport_emp_id,
			'passport_name' 		=> $this->input->post('passport_name'),
			'passport_number' 		=> $this->input->post('passport_number'),
			'passport_issue_place' 	=> $this->input->post('passport_issue_place'),
			'passport_issue_date' 	=> $issue_date,
			'passport_expiry_date' 	=> $expiry_date,
		);
		
		$test_con = 0;
		if(!empty($passport_emp_id)){
			$passport_file = "";
			if(isset($_FILES["passport_file"]["name"]) && !empty($_FILES["passport_file"]["name"])){
				$extension 	= pathinfo($_FILES["passport_file"]["name"], PATHINFO_EXTENSION);
				$filename 	= pathinfo($_FILES['passport_file']['name'], PATHINFO_FILENAME);
				
				$config['upload_path']    = EMPLOYEE_PASSPORT_IMG_PATH;
				$config['allowed_types']  = 'jpg|jpeg|png|webp|JPG|JPEG|PNG|WEBP';
				$config['file_name']      = $filename.rand() . '_' . date('YmdHis') . "." . $extension;	
				$this->load->library('upload', $config);
				if(!$this->upload->do_upload('passport_file')){
					$test_con   	= 1;
					$error      	= $this->upload->display_errors();
				}else{
					$test_con       = 0;
					$data           = $this->upload->data();
					$passport_file  = $data['file_name'];
				}
			}
        }
		
		if($test_con==0){
			if(empty($passport_emp_id)){
				$output = array(
					'status'	=> 'Error',
					'msg'		=> 'Please Complete Employee Details',
				);
			}else{
				if(empty($passport_row_id)){
					$data_arr['passport_file'] 	= $passport_file;
					$data_arr['created_at'] 	= date('Y-m-d h:i:s');
					$data_arr['created_by'] 	= $this->session->userdata('user_id');
					
					$this->common_model->insert('employee_passport',$data_arr);
					$output = array(
						'status'	=> 'Success',
						'msg'		=> 'Passport Details Added Successfully',
					);
				}else{
					$data_arr['updated_at'] 	= date('Y-m-d h:i:s');
					$data_arr['updated_by'] 	= $this->session->userdata('user_id');
					
					if(!empty($passport_file)){
						$details = $this->db->select('*')->where('id',$passport_row_id)->get('employee_passport')->row();
						if(!empty($details->passport_file)){
							$files = EMPLOYEE_PASSPORT_IMG_PATH.'/'.$details->passport_file;
							if(file_exists($files)){
								unlink($files);
							}
						}
						$data_arr['passport_file'] 	= $passport_file;
					}
					
					$where = "id='".$passport_row_id."'";
					$this->common_model->update('employee_passport',$data_arr,$where);
					$output = array(
						'status'	=> 'Success',
						'msg'		=> 'Passport Details Updated Successfully',
					);
				}
			}
		}else{
			$output = array(
				'status'	=> 'Error',
				'msg'		=> $error,
			);
		}
		echo json_encode($output);
	}
	
	public function list_passport_details(){
		$data = $row = array();
		$memData 	= $this->employee_passport_master_model->getRows($_POST);
		$i 			= $_POST['start'];
		
		foreach($memData as $member){
			$i++;
			
			$link   = base_url().EMPLOYEE_PASSPORT_IMG_PATH.'/'.$member->passport_file;
			$action = '';
			
			$action .= '<div class="btn-group" role="group">';
				$action .= '<div class="btn-group" role="group">';
					$action .= '<button id="btnGroupDrop'.$member->id.'" type="button" class="btn btn-secondary btn-sm dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Action</button>';
					$action .= '<div class="dropdown-menu" aria-labelledby="btnGroupDrop'.$member->id.'">';
						$action .= '<a class="dropdown-item edit_passport_details" href="javascript:void(0)" data-id="'.$member->id.'">Edit</a>';
						$action .= '<a class="dropdown-item" href="'.$link.'" download="'.$link.'">Download</a>';
						$action .= '<a class="dropdown-item delete_passport_details" href="javascript:void(0)" data-id="'.$member->id.'">Delete</a>';
					$action .= '</div>';
				$action .= '</div>';
			$action .= '</div>';
			
			$issue_at 	= date("d-m-Y",strtotime($member->passport_issue_date));
			$expiry_at 	= date("d-m-Y",strtotime($member->passport_expiry_date));
			
			$data[] = array($i, $member->passport_name, $member->passport_number, $member->passport_issue_place, $issue_at, $expiry_at, $action);
		}
		$output = array(
			"draw" 				=> $_POST['draw'],
			"recordsTotal" 		=> $this->employee_passport_master_model->countAll($_POST),
			"recordsFiltered" 	=> $this->employee_passport_master_model->countFiltered($_POST),
			"data" 				=> $data,
		);
		echo json_encode($output);
	}
	
	public function edit_passport_details(){
		$row_id 	= $this->input->post('keys');
		$details 	= $this->db->select('*')->where('id',$row_id)->get('employee_passport')->row_array();
		if(!empty($details)){
			if(!empty($details['passport_issue_date'])){
				$details['passport_issue_date'] = date('d-m-Y',strtotime($details['passport_issue_date']));
			}
			if(!empty($details['passport_expiry_date'])){
				$details['passport_expiry_date'] = date('d-m-Y',strtotime($details['passport_expiry_date']));
			}
			if(!empty($details['passport_file'])){
				$link = base_url().EMPLOYEE_PASSPORT_IMG_PATH.'/'.$details['passport_file'];
				$details['passport_file'] = '<a href="'.$link.'" download="'.$link.'"><i class="fa fa-download"></i> Download</a>';
			}
			
			$output = array(
				'status'	=> 'Success',
				'details'	=> $details,
			);
		}else{
			$output = array(
				'status'	=> 'Warning',
				'info'		=> 'Invaild Records !!!',
			);
		}
		echo json_encode($output);
	}
	
	public function delete_passport_details(){
		$row_id = $this->input->post('keys');
		
		$data_arr['deleted'] 	= 1;
		$data_arr['deleted_at'] = date('Y-m-d h:i:s');
		$data_arr['deleted_by'] = $this->session->userdata('user_id');
		
		$where  = "id='".$row_id."'";
		$result = $this->common_model->update('employee_passport',$data_arr,$where);
		
		if($result==true){
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Passport Details Deleted Successfully',
			);
		}else{
			$output = array(
				'status'	=> 'Warning',
				'msg'		=> 'Unable to Delete the Passport Details',
			);
		}
		echo json_encode($output);
	}
	
	public function list_rp_details(){
		$data = $row = array();
		$memData 	= $this->employee_rp_master_model->getRows($_POST);
		$i 			= $_POST['start'];
		
		foreach($memData as $member){
			$i++;
			
			$link   = base_url().EMPLOYEE_PR_FILE_IMG_PATH.'/'.$member->rp_file;
			$action = '';
			
			$action .= '<div class="btn-group" role="group">';
				$action .= '<div class="btn-group" role="group">';
					$action .= '<button id="btnGroupRP'.$member->id.'" type="button" class="btn btn-secondary btn-sm dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Action</button>';
					$action .= '<div class="dropdown-menu" aria-labelledby="btnGroupRP'.$member->id.'">';
						$action .= '<a class="dropdown-item edit_rp_details" href="javascript:void(0)" data-id="'.$member->id.'">Edit</a>';
						$action .= '<a class="dropdown-item" href="'.$link.'" download="'.$link.'">Download</a>';
						$action .= '<a class="dropdown-item delete_rp_details" href="javascript:void(0)" data-id="'.$member->id.'">Delete</a>';
					$action .= '</div>';
				$action .= '</div>';
			$action .= '</div>';
			
			$issue_at 	= date("d-m-Y",strtotime($member->rp_issue_date));
			$expiry_at 	= date("d-m-Y",strtotime($member->rp_expiry_date));
			$data[] 	= array($i, $member->rp_number, $issue_at, $expiry_at, $action);
		}
		$output = array(
			"draw" 				=> $_POST['draw'],
			"recordsTotal" 		=> $this->employee_rp_master_model->countAll($_POST),
			"recordsFiltered" 	=> $this->employee_rp_master_model->countFiltered($_POST),
			"data" 				=> $data,
		);
		echo json_encode($output);
	}
	
	public function add_edit_rp_details(){
		$resident_row_id = $this->input->post('resident_row_id');
		$resident_emp_id = $this->input->post('resident_emp_id');
		
		$issue_date 	= (!empty($this->input->post('rp_issue_date')))?date('Y-m-d',strtotime($this->input->post('rp_issue_date'))):'';
		$expiry_date 	= (!empty($this->input->post('rp_expiry_date')))?date('Y-m-d',strtotime($this->input->post('rp_expiry_date'))):'';
		$data_arr 		= array(
			'resident_emp_id' 	=> $resident_emp_id,
			'rp_number' 		=> $this->input->post('rp_number'),
			'rp_issue_date' 	=> $issue_date,
			'rp_expiry_date' 	=> $expiry_date,
		);
		
		$test_con = 0;
		if(!empty($resident_emp_id)){
			$rp_file = "";
			if(isset($_FILES["rp_file"]["name"]) && !empty($_FILES["rp_file"]["name"])){
				$extension 	= pathinfo($_FILES["rp_file"]["name"], PATHINFO_EXTENSION);
				$filename 	= pathinfo($_FILES['rp_file']['name'], PATHINFO_FILENAME);
				
				$config['upload_path']    = EMPLOYEE_PR_FILE_IMG_PATH;
				$config['allowed_types']  = 'jpg|jpeg|png|webp|JPG|JPEG|PNG|WEBP';
				$config['file_name']      = $filename.rand() . '_' . date('YmdHis') . "." . $extension;	
				$this->load->library('upload', $config);
				if(!$this->upload->do_upload('rp_file')){
					$test_con   = 1;
					$error      = $this->upload->display_errors();
				}else{
					$test_con   = 0;
					$data       = array('upload_data' => $this->upload->data());
					$rp_file    = $data['upload_data']['file_name'];
				}
			}
        }
		
		if($test_con==0){
			if(empty($resident_emp_id)){
				$output = array(
					'status'	=> 'Error',
					'msg'		=> 'Please Complete Employee Details',
				);
			}else{
				if(empty($resident_row_id)){
					$data_arr['rp_file'] 	= $rp_file;
					$data_arr['created_at'] = date('Y-m-d h:i:s');
					$data_arr['created_by'] = $this->session->userdata('user_id');
					
					$this->common_model->insert('employee_resident',$data_arr);
					$output = array(
						'status'	=> 'Success',
						'msg'		=> 'RP Details Added Successfully',
					);
				}else{
					$data_arr['updated_at'] 	= date('Y-m-d h:i:s');
					$data_arr['updated_by'] 	= $this->session->userdata('user_id');
					
					if(!empty($rp_file)){
						$details = $this->db->select('*')->where('id',$resident_row_id)->get('employee_resident')->row();
						if(!empty($details->rp_file)){
							$files = EMPLOYEE_PR_FILE_IMG_PATH.'/'.$details->rp_file;
							if(file_exists($files)){
								unlink($files);
							}
						}
						$data_arr['rp_file'] 	= $rp_file;
					}
					
					$where = "id='".$resident_row_id."'";
					$this->common_model->update('employee_resident',$data_arr,$where);
					$output = array(
						'status'	=> 'Success',
						'msg'		=> 'RP Details Updated Successfully',
					);
				}
			}
		}else{
			$output = array(
				'status'	=> 'Error',
				'msg'		=> $error,
			);
		}
		echo json_encode($output);
	}
	
	public function edit_rp_details(){
		$row_id 	= $this->input->post('keys');
		$details 	= $this->db->select('*')->where('id',$row_id)->get('employee_resident')->row_array();
		if(!empty($details)){
			if(!empty($details['rp_issue_date'])){
				$details['rp_issue_date'] = date('d-m-Y',strtotime($details['rp_issue_date']));
			}
			if(!empty($details['rp_expiry_date'])){
				$details['rp_expiry_date'] = date('d-m-Y',strtotime($details['rp_expiry_date']));
			}
			if(!empty($details['rp_file'])){
				$link = base_url().EMPLOYEE_PR_FILE_IMG_PATH.'/'.$details['rp_file'];
				$details['rp_file'] = '<a href="'.$link.'" download="'.$link.'"><i class="fa fa-download"></i> Download</a>';
			}
			
			$output = array(
				'status'	=> 'Success',
				'details'	=> $details,
			);
		}else{
			$output = array(
				'status'	=> 'Warning',
				'info'		=> 'Invaild Records !!!',
			);
		}
		echo json_encode($output);
	}
	
	public function delete_rp_details(){
		$row_id = $this->input->post('keys');
		
		$data_arr['deleted'] 	= 1;
		$data_arr['deleted_at'] = date('Y-m-d h:i:s');
		$data_arr['deleted_by'] = $this->session->userdata('user_id');
		
		$where  = "id='".$row_id."'";
		$result = $this->common_model->update('employee_resident',$data_arr,$where);
		
		if($result==true){
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'RP Details Deleted Successfully',
			);
		}else{
			$output = array(
				'status'	=> 'Warning',
				'msg'		=> 'Unable to Delete the RP Details',
			);
		}
		echo json_encode($output);
	}
	
	public function submit_cpr_details(){
		$cpr_row_id	= $this->input->post('cpr_row_id');
		$cpr_emp_id	= $this->input->post('cpr_emp_id');
		$data_arr 	= array(
			'cpr_emp_id' 		=> $this->input->post('cpr_emp_id'),
			'cpr_name' 		    => $this->input->post('cpr_name'),
			'cpr_number' 		=> $this->input->post('cpr_number'),
			'cpr_issue_date' 	=> date("Y-m-d",strtotime($this->input->post('cpr_issue_date'))),
			'cpr_expiry_date' 	=> date("Y-m-d",strtotime($this->input->post('cpr_expiry_date'))),
		);
		
		$test_con = 0;
		if(!empty($cpr_emp_id)){
			$cpr_file = "";
			if(isset($_FILES["cpr_file"]["name"]) && !empty($_FILES["cpr_file"]["name"])){
				$extension 	= pathinfo($_FILES["cpr_file"]["name"], PATHINFO_EXTENSION);
				$filename 	= pathinfo($_FILES['cpr_file']['name'], PATHINFO_FILENAME);
				
				$config['upload_path']    = CRP_IMG_PATH;
				$config['allowed_types']  = 'jpg|jpeg|png|webp|JPG|JPEG|PNG|WEBP';
				$config['file_name']      = $filename.rand() . '_' . date('YmdHis') . "." . $extension;	
				$this->load->library('upload', $config);
				if(!$this->upload->do_upload('cpr_file')){
					$test_con   = 1;
					$error      = $this->upload->display_errors();
				}else{
					$test_con   = 0;
					$data       = array('upload_data' => $this->upload->data());
					$cpr_file   = $data['upload_data']['file_name'];
				}
			}
        }
		
		if($test_con==0){
			if(empty($cpr_emp_id)){
				$output = array(
					'status'	=> 'Error',
					'msg'		=> 'Please Complete Employee Details',
				);
			}else{
				if(empty($cpr_row_id)){
					$data_arr['cpr_file'] 	= $cpr_file;
					$data_arr['created_at'] = date('Y-m-d h:i:s');
					$data_arr['created_by'] = $this->session->userdata('user_id');
					
					$this->common_model->insert('employee_cpr_details',$data_arr);
					$output = array(
						'status'	=> 'Success',
						'msg'		=> 'CPR Details Added Successfully',
					);
				}else{
					$data_arr['updated_at'] 	= date('Y-m-d h:i:s');
					$data_arr['updated_by'] 	= $this->session->userdata('user_id');
					
					if(!empty($cpr_file)){
						$details = $this->db->select('*')->where('id',$cpr_row_id)->get('employee_cpr_details')->row();
						if(!empty($details->cpr_file)){
							$files = CRP_IMG_PATH.'/'.$details->cpr_file;
							if(file_exists($files)){
								unlink($files);
							}
						}
						$data_arr['cpr_file'] 	= $cpr_file;
					}
					
					$where = "id='".$cpr_row_id."'";
					$this->common_model->update('employee_cpr_details',$data_arr,$where);
					$output = array(
						'status'	=> 'Success',
						'msg'		=> 'CPR Details Updated Successfully',
					);
				}
			}
		}else{
			$output = array(
				'status'	=> 'Error',
				'msg'		=> $error,
			);
		}
		echo json_encode($output);
	}
	
	public function list_cpr_details(){
		$data = $row = array();
		$memData 	= $this->employee_cpr_model->getRows($_POST);
		$i 			= $_POST['start'];
		
		foreach($memData as $member){
			$i++;
			
			$link   = base_url().CRP_IMG_PATH.'/'.$member->cpr_file;
			$action = '';
			
			$action .= '<div class="btn-group" role="group">';
				$action .= '<div class="btn-group" role="group">';
					$action .= '<button id="btnGroupCPR'.$member->id.'" type="button" class="btn btn-secondary btn-sm dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Action</button>';
					$action .= '<div class="dropdown-menu" aria-labelledby="btnGroupCPR'.$member->id.'">';
						$action .= '<a class="dropdown-item edit_cpr_details" href="javascript:void(0)" data-id="'.$member->id.'">Edit</a>';
						$action .= '<a class="dropdown-item" href="'.$link.'" download="'.$link.'">Download</a>';
						$action .= '<a class="dropdown-item delete_cpr_details" href="javascript:void(0)" data-id="'.$member->id.'">Delete</a>';
					$action .= '</div>';
				$action .= '</div>';
			$action .= '</div>';
			
			$cpr_issue_date 	= date("d-m-Y",strtotime($member->cpr_issue_date));
			$cpr_expiry_date 	= date("d-m-Y",strtotime($member->cpr_expiry_date));
			
			$data[] = array($i,$member->cpr_name,$member->cpr_number,$cpr_issue_date,$cpr_expiry_date,$action);
		}
		$output = array(
			"draw" 				=> $_POST['draw'],
			"recordsTotal" 		=> $this->employee_cpr_model->countAll($_POST),
			"recordsFiltered" 	=> $this->employee_cpr_model->countFiltered($_POST),
			"data" 				=> $data,
		);
		echo json_encode($output);
	}
	
	public function edit_cpr_details(){
		$row_id 	= $this->input->post('keys');
		$details 	= $this->db->select('*')->where('id',$row_id)->get('employee_cpr_details')->row_array();
		if(!empty($details)){
			if(!empty($details['cpr_issue_date'])){
				$details['cpr_issue_date'] = date('d-m-Y',strtotime($details['cpr_issue_date']));
			}
			if(!empty($details['cpr_expiry_date'])){
				$details['cpr_expiry_date'] = date('d-m-Y',strtotime($details['cpr_expiry_date']));
			}
			if(!empty($details['cpr_file'])){
				$link = base_url().CRP_IMG_PATH.'/'.$details['cpr_file'];
				$details['cpr_file'] = '<a href="'.$link.'" download="'.$link.'"><i class="fa fa-download"></i> Download</a>';
			}
			
			$output = array(
				'status'	=> 'Success',
				'details'	=> $details,
			);
		}else{
			$output = array(
				'status'	=> 'Warning',
				'info'		=> 'Invaild Records !!!',
			);
		}
		echo json_encode($output);
	}
	
	public function delete_cpr_details(){
		$row_id = $this->input->post('keys');
		
		$data_arr['deleted'] 	= 1;
		$data_arr['deleted_at'] = date('Y-m-d h:i:s');
		$data_arr['deleted_by'] = $this->session->userdata('user_id');
		
		$where  = "id='".$row_id."'";
		$result = $this->common_model->update('employee_cpr_details',$data_arr,$where);
		
		if($result==true){
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'CPR Details Deleted Successfully',
			);
		}else{
			$output = array(
				'status'	=> 'Warning',
				'msg'		=> 'Unable to Delete the CPR Details',
			);
		}
		echo json_encode($output);
	}
	
	public function update_bank_details(){
		$row_id		= $this->input->post('bank_row_id');
		
		$data_arr 		= array(
			'bank_account_name' 	=> $this->input->post('bank_account_name'),
			'bank_name' 	=> $this->input->post('bank_name'),
			'bank_iban' 			=> $this->input->post('bank_iban'),
			'bank_swift_code' 		=> $this->input->post('bank_swift_code'),
		);
		if(empty($row_id)){
			$output = array(
				'status'	=> 'Error',
				'msg'		=> 'Please Complete Employee Details',
			);
		}else{
			$data_arr['updated_at'] = date('Y-m-d h:i:s');
			$data_arr['updated_by'] = $this->session->userdata('user_id');
			
			$where = "employee_id='$row_id'";
			$this->common_model->update('employee',$data_arr,$where);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Bank Details Updated Successfully',
			);
		}
		echo json_encode($output);
	}
	
	public function update_salary_details(){
		$salary_row_id	= $this->input->post('salary_row_id');
		$salary_emp_id	= $this->input->post('salary_emp_id');
		$data_arr 	= array(
			'salary_emp_id' 			=> $salary_emp_id,
			'salary_basic_amount' 		=> $this->input->post('salary_basic_amount'),
			'salary_other_allowance' 	=> $this->input->post('salary_other_allowance'),
			'salary_sio_amount' 		=> $this->input->post('salary_sio_amount'),
			'salary_limra_fee' 			=> $this->input->post('salary_limra_fee'),
		);
		if(empty($row_id)){
			$rows['salary_status'] = 0;
			$where = "salary_emp_id='".$salary_emp_id."'";
			$this->common_model->update('employee_salary_details',$rows,$where);
			
			$data_arr['salary_status'] 	= '1';
			$data_arr['created_at'] 	= date('Y-m-d h:i:s');
			$data_arr['created_by'] 	= $this->session->userdata('user_id');
			$this->common_model->insert('employee_salary_details',$data_arr);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Salary Details Added Successfully',
			);
		}else{
			$data_arr['updated_at'] = date('Y-m-d h:i:s');
			$data_arr['updated_by'] = $this->session->userdata('user_id');
			
			$where = "id='".$salary_row_id."'";
			$this->common_model->update('employee_salary_details',$data_arr,$where);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Salary Details Updated Successfully',
			);
		}
		echo json_encode($output);
	}
	
	public function list_salary_details(){
		$data = $row = array();
		$memData 	= $this->employee_salary_model->getRows($_POST);
		$i 			= $_POST['start'];
		
		foreach($memData as $member){
			$i++;
			
			$action = '';
			$action .= '<div class="btn-group" role="group">';
				$action .= '<div class="btn-group" role="group">';
					$action .= '<button id="btnGroupSalary'.$member->id.'" type="button" class="btn btn-secondary btn-sm dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Action</button>';
					$action .= '<div class="dropdown-menu" aria-labelledby="btnGroupSalary'.$member->id.'">';
						$action .= '<a class="dropdown-item delete_salary_details" href="javascript:void(0)" data-id="'.$member->id.'">Delete</a>';
					$action .= '</div>';
				$action .= '</div>';
			$action .= '</div>';
			
			$salary_basic_amount 	= display_price_details($member->salary_basic_amount);
			$salary_other_allowance = display_price_details($member->salary_other_allowance);
			$salary_sio_amount 		= display_price_details($member->salary_sio_amount);
			$salary_limra_fee 		= display_price_details($member->salary_limra_fee);
			$salary_status 			= ($member->salary_status=="1")?'<label class="badge badge-success">Active</label>':'<label class="badge badge-danger">Inactive</label>';
			$created_at 			= date("d-m-Y h:i a",strtotime($member->created_at));
			
			$data[] = array($i, $salary_basic_amount, $salary_other_allowance, $salary_sio_amount, $salary_limra_fee, $salary_status, $created_at, $action);
		}
		$output = array(
			"draw" 				=> $_POST['draw'],
			"recordsTotal" 		=> $this->employee_salary_model->countAll($_POST),
			"recordsFiltered" 	=> $this->employee_salary_model->countFiltered($_POST),
			"data" 				=> $data,
		);
		echo json_encode($output);
	}
	
	public function add_certificate_details(){
		$certificate_row_id = $this->input->post('certificate_row_id');
		$data_arr 	= array(
			'certificate_emp_id' 		=> $certificate_row_id,
			'certificate_name' 			=> $this->input->post('certificate_name'),
			'certificate_issue_date' 	=> date("Y-m-d",strtotime($this->input->post('certificate_issue_date'))),
			'certificate_expiry_date' 	=> date("Y-m-d",strtotime($this->input->post('certificate_expiry_date'))),
		);
		
		$test_con 	 = 0;
		$small_image = "";
		if(isset($_FILES["certificate_image"]["name"]) && !empty($_FILES["certificate_image"]["name"])){
    		$image_info = getimagesize($_FILES["certificate_image"]["tmp_name"]);
    		$image_width = $image_info[0];
    		$image_height = $image_info[1];
    		$imageData1['imageName']='certificate_image';
    		$imageData1['imageWidth']=$image_width;
    		$imageData1['imageHeight']=$image_height;
    		$imageData1['prefWidth']=$image_width;
		    $imageData1['prefHeight']=$image_height;
    		$extension = pathinfo($_FILES["certificate_image"]["name"], PATHINFO_EXTENSION);
    		$filename = pathinfo($_FILES['certificate_image']['name'], PATHINFO_FILENAME);
    		
    		$config['upload_path']    = EMPLOYEE_CERTIFICATE_IMG_PATH;
    		$config['allowed_types']  = 'jpg|jpeg|png|webp|JPG|JPEG|PNG|WEBP';
    		$config['file_name']      = $filename.rand() . '_' . date('YmdHis') . "." . $extension;	
    		$this->load->library('upload', $config);
    		if(!$this->upload->do_upload('certificate_image')){
    			$test_con   = 1;
    			$error      = $this->upload->display_errors();
    		}else{
    			$data           = array('upload_data' => $this->upload->data());
    			$test_con       = 0;
    			$data_arr['certificate_image']    = $data['upload_data']['file_name'];
    		}
        }
		
		if($test_con==0){
			if(empty($certificate_row_id)){
				$output = array(
					'status'	=> 'Error',
					'msg'		=> 'Please Complete Employee Details',
				);
			}else{
				$data_arr['created_at'] = date('Y-m-d h:i:s');
				$data_arr['created_by'] = $this->session->userdata('user_id');
				
				$row_id = $this->common_model->insert('employee_certificate',$data_arr);
				$output = array(
					'status'	=> 'Success',
					'msg'		=> 'Certificate Added Successfully',
				);
			}
		}else{
			$output = array(
				'status'	=> 'Error',
				'msg'		=> $error,
			);
		}
		echo json_encode($output);
	}
	
	public function list_certificate_details(){
		$data = $row = array();
		$memData 	= $this->employee_certificate_master_model->getRows($_POST);
		$i 			= $_POST['start'];
		
		foreach($memData as $member){
			$i++;
			
			$link   = base_url().EMPLOYEE_CERTIFICATE_IMG_PATH.'/'.$member->certificate_image;
			$action = "<a href='".$link."' class='btn btn-info btn-sm' download='".$link."'><i class='fa fa-download'></i></a>&nbsp;&nbsp;";
			$action.= "<button type='button' class='btn btn-danger btn-sm delete_data' data-id='".$member->certificate_emp_id."'><i class='fa fa-trash'></i></button>";
			
			$created_at = date("d-m-Y h:i a",strtotime($member->created_at));
			
			$data[] = array($i, $member->certificate_name, $member->certificate_image, $created_at, $action);
		}
		$output = array(
			"draw" 				=> $_POST['draw'],
			"recordsTotal" 		=> $this->employee_certificate_master_model->countAll($_POST),
			"recordsFiltered" 	=> $this->employee_certificate_master_model->countFiltered($_POST),
			"data" 				=> $data,
		);
		echo json_encode($output);
	}
	
	public function employee_profile(){
		$data['page_title'] 	= "Profile";
		$data['content'] 		= "web/employee/employee_profile_view";
		$data['list_leave']		= $this->db->select('*')->where('category_status','Active')->get('tbl_attendance_leave_category')->result_array();
		$data['employee_id'] 	= $this->session->userdata('user_id');
		
		$data['emp_details'] 		= $this->db->select('*')->where('employee_id',$this->session->userdata('user_id'))->get('employee')->row();
		$data['emp_department'] 	= $this->db->select('*')->where('id',$data['emp_details']->department)->get('tbl_department_category')->row();
		$data['emp_designation'] 	= $this->db->select('*')->where('id',$data['emp_details']->designation)->get('tbl_desigantion_category')->row();
		$this->load->view('web/template', $data);
	}
	
	public function delete_certificate(){
		$row_id = $this->input->post('keys');
		
		$where = "id='$row_id'";
		$result = $this->common_model->delete('employee_certificate',$where);
		
		if($result==true){
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Deductions Deleted Successfully',
			);
		}else{
			$output = array(
				'status'	=> 'Warning',
				'msg'		=> 'Unable to Delete the Deductions Details',
			);
		}
		echo json_encode($output);
	}
	
	
	  public function add_employee_master_import(){
		  
		$company_id = get_customercompanyid();
		
		if(isset($_FILES["import_excel"]["name"])){
			$extension = pathinfo($_FILES["import_excel"]["name"], PATHINFO_EXTENSION);
			if($extension=="xlsx" || $extension=="xls" || $extension=="csv"){
				$path 	= $_FILES["import_excel"]["tmp_name"];
				$object = PHPExcel_IOFactory::load($path);
				foreach($object->getWorksheetIterator() as $worksheet){
					$highestRow 	= $worksheet->getHighestRow();
					$highestColumn 	= $worksheet->getHighestColumn();
					for($row=2; $row<=$highestRow; $row++){
						
						$employee_date = PHPExcel_Style_NumberFormat::toFormattedString($worksheet->getCellByColumnAndRow(12, $row)->getValue(), 'Y-m-d');
						
						$birth_date = PHPExcel_Style_NumberFormat::toFormattedString($worksheet->getCellByColumnAndRow(10, $row)->getValue(), 'Y-m-d');
						
						$passport_issue_date = PHPExcel_Style_NumberFormat::toFormattedString($worksheet->getCellByColumnAndRow(19, $row)->getValue(), 'Y-m-d');
						
						$passport_expiry_date = PHPExcel_Style_NumberFormat::toFormattedString($worksheet->getCellByColumnAndRow(20, $row)->getValue(), 'Y-m-d');
						
						$rp_issue_date = PHPExcel_Style_NumberFormat::toFormattedString($worksheet->getCellByColumnAndRow(23, $row)->getValue(), 'Y-m-d');
						
						$rp_expiry_date = PHPExcel_Style_NumberFormat::toFormattedString($worksheet->getCellByColumnAndRow(24, $row)->getValue(), 'Y-m-d');
						
						$cpr_issue_date = PHPExcel_Style_NumberFormat::toFormattedString($worksheet->getCellByColumnAndRow(27, $row)->getValue(), 'Y-m-d');
						
						$cpr_expiry_date = PHPExcel_Style_NumberFormat::toFormattedString($worksheet->getCellByColumnAndRow(28, $row)->getValue(), 'Y-m-d');
						

								$data_arr = array(
									'emp_id'			   =>   trim($worksheet->getCellByColumnAndRow(1, $row)->getValue()),
									'company_id'		   =>   $company_id,
									'employeename'		   =>	trim($worksheet->getCellByColumnAndRow(2, $row)->getValue()),
									'contract_type'		   =>	trim($worksheet->getCellByColumnAndRow(3, $row)->getValue()),
									'employee_status'	   =>	trim($worksheet->getCellByColumnAndRow(4, $row)->getValue()),
									'department'		   =>	trim($worksheet->getCellByColumnAndRow(5, $row)->getValue()),
									'designation'		   =>	trim($worksheet->getCellByColumnAndRow(6, $row)->getValue()),
									'mobile'		       =>	trim($worksheet->getCellByColumnAndRow(7, $row)->getValue()),
									'emergency_mobile_no'  =>	trim($worksheet->getCellByColumnAndRow(8, $row)->getValue()),
									'email'		           =>	trim($worksheet->getCellByColumnAndRow(9, $row)->getValue()),
									'birthdate'		       =>	trim($birth_date),
									'gender'		       =>	trim($worksheet->getCellByColumnAndRow(11, $row)->getValue()),
									'employedDate'		   =>	trim($employee_date),
									'address'			   =>	trim($worksheet->getCellByColumnAndRow(13, $row)->getValue()),
									'spousename'		   =>	trim($worksheet->getCellByColumnAndRow(14, $row)->getValue()),
									'nationality'		   =>	trim($worksheet->getCellByColumnAndRow(15, $row)->getValue()),
									'blood_group'		   =>	trim($worksheet->getCellByColumnAndRow(16, $row)->getValue()),
									
									'bank_account_name'	   =>  trim($worksheet->getCellByColumnAndRow(29, $row)->getValue()),
									'bank_name'			   =>  trim($worksheet->getCellByColumnAndRow(30, $row)->getValue()),
									'bank_iban'		       =>  trim($worksheet->getCellByColumnAndRow(31, $row)->getValue()),
									'bank_swift_code'	   =>  trim($worksheet->getCellByColumnAndRow(32, $row)->getValue()),
									'basic_salary'	       =>  trim($worksheet->getCellByColumnAndRow(33, $row)->getValue()),
									'other_allowance'	   =>  trim($worksheet->getCellByColumnAndRow(34, $row)->getValue()),
									'sio'			       =>  trim($worksheet->getCellByColumnAndRow(35, $row)->getValue()),
									'lmra_fee'		       =>  trim($worksheet->getCellByColumnAndRow(36, $row)->getValue()),
								);
								
								$data_arr['created_at'] 		= date('Y-m-d h:i:s');
								$data_arr['created_by'] 	    = $this->session->userdata('user_id');
							    $insert_id = $this->common_model->insert('employee',$data_arr);
								
							      
										$data_passport = array( 
											'passport_emp_id'       =>  $insert_id,
											'passport_name'		    =>	trim($worksheet->getCellByColumnAndRow(17, $row)->getValue()),
											'passport_number'		=>	trim($worksheet->getCellByColumnAndRow(18, $row)->getValue()),
											'passport_issue_date'	=>	trim($passport_issue_date),
											'passport_expiry_date'	=>	trim($passport_expiry_date),
											'passport_issue_place'	=>	trim($worksheet->getCellByColumnAndRow(21, $row)->getValue()),
											
										);
										
										$data_passport['created_at'] 	= date('Y-m-d h:i:s');
										$data_passport['created_by'] 	= $this->session->userdata('user_id');
										$this->common_model->insert('employee_passport',$data_passport);
										
										
										$data_resident = array( 
											'resident_emp_id'       =>  $insert_id,
											'rp_number'			    =>	trim($worksheet->getCellByColumnAndRow(22, $row)->getValue()),
											'rp_issue_date'		    =>	trim($rp_issue_date),
											'rp_expiry_date'		=>	trim($rp_expiry_date),
											
										);
										
										$data_resident['created_at']   = date('Y-m-d h:i:s');
										$data_resident['created_by']   = $this->session->userdata('user_id');
										$this->common_model->insert('employee_resident',$data_resident);
										
										
										$data_cpr = array( 
											'cpr_emp_id'          =>  $insert_id,
											'cpr_name'		      =>  trim($worksheet->getCellByColumnAndRow(25, $row)->getValue()),
											'cpr_number'		  =>  trim($worksheet->getCellByColumnAndRow(26, $row)->getValue()),
											'cpr_issue_date'	  =>  trim($cpr_issue_date),
											'cpr_expiry_date'	  =>  trim($cpr_expiry_date),
											
										);
										
										$data_cpr['created_at']   = date('Y-m-d h:i:s');
										$data_cpr['created_by']   = $this->session->userdata('user_id');
										$this->common_model->insert('employee_cpr_details',$data_cpr);
							       
                             }
							 
					$output = array(
					'status'	=> 'Success',
					'msg'		=> 'Attendance Import Successfully Completed',
				  );
				}
			}
		}
		
		echo json_encode($output);
   } 
}
?>