load->model('Company_model');
$this->load->model('Xin_model');
$this->load->model('Exin_model');
$this->load->model('Department_model');
$this->load->model('Payroll_model');
$this->load->model('Reports_model');
$this->load->model('Timesheet_model');
$this->load->model('Training_model');
$this->load->model('Trainers_model');
$this->load->model("Project_model");
$this->load->model("Roles_model");
$this->load->model("Employees_model");
$this->load->model("Designation_model");
}
// reports
public function index() {
$session = $this->session->userdata('username');
if(empty($session)){
redirect('admin/');
}
$data['title'] = $this->lang->line('xin_hr_report_title').' | '.$this->Xin_model->site_title();
$data['breadcrumbs'] = $this->lang->line('xin_hr_report_title');
$data['path_url'] = 'hrsale_reports';
$data['all_companies'] = $this->Xin_model->get_companies();
$role_resources_ids = $this->Xin_model->user_role_resource();
if(in_array('110',$role_resources_ids) || in_array('111',$role_resources_ids) || in_array('112',$role_resources_ids) || in_array('113',$role_resources_ids) || in_array('114',$role_resources_ids) || in_array('115',$role_resources_ids) || in_array('116',$role_resources_ids) || in_array('117',$role_resources_ids) || in_array('409',$role_resources_ids) || in_array('83',$role_resources_ids) || in_array('84',$role_resources_ids) || in_array('85',$role_resources_ids) || in_array('86',$role_resources_ids)) {
$data['subview'] = $this->load->view("admin/layout/hrsale_reports", $data, TRUE);
$this->load->view('admin/layout/layout_main', $data); //page load
} else {
redirect('admin/dashboard');
}
}
// payslip reports > employees and company
public function payslip() {
$session = $this->session->userdata('username');
if(empty($session)){
redirect('admin/');
}
$data['title'] = $this->lang->line('xin_hr_reports_payslip').' | '.$this->Xin_model->site_title();
$data['breadcrumbs'] = $this->lang->line('xin_hr_reports_payslip');
$data['path_url'] = 'reports_payslip';
$data['all_companies'] = $this->Xin_model->get_companies();
$role_resources_ids = $this->Xin_model->user_role_resource();
if(in_array('111',$role_resources_ids)) {
$data['subview'] = $this->load->view("admin/reports/payslip", $data, TRUE);
$this->load->view('admin/layout/layout_main', $data); //page load
} else {
redirect('admin/dashboard');
}
}
// projects report
public function projects() {
$session = $this->session->userdata('username');
if(empty($session)){
redirect('admin/');
}
$data['title'] = $this->lang->line('xin_hr_reports_projects').' | '.$this->Xin_model->site_title();
$data['breadcrumbs'] = $this->lang->line('xin_hr_reports_projects');
$data['path_url'] = 'reports_project';
$data['all_companies'] = $this->Xin_model->get_companies();
$role_resources_ids = $this->Xin_model->user_role_resource();
if(in_array('114',$role_resources_ids)) {
$data['subview'] = $this->load->view("admin/reports/projects", $data, TRUE);
$this->load->view('admin/layout/layout_main', $data); //page load
} else {
redirect('admin/dashboard');
}
}
// tasks report
public function tasks() {
$session = $this->session->userdata('username');
if(empty($session)){
redirect('admin/');
}
$data['title'] = $this->lang->line('xin_hr_reports_tasks').' | '.$this->Xin_model->site_title();
$data['breadcrumbs'] = $this->lang->line('xin_hr_reports_tasks');
$data['path_url'] = 'reports_task';
$data['all_companies'] = $this->Xin_model->get_companies();
$role_resources_ids = $this->Xin_model->user_role_resource();
if(in_array('115',$role_resources_ids)) {
$data['subview'] = $this->load->view("admin/reports/tasks", $data, TRUE);
$this->load->view('admin/layout/layout_main', $data); //page load
} else {
redirect('admin/dashboard');
}
}
// roles/privileges report
public function roles() {
$session = $this->session->userdata('username');
if(empty($session)){
redirect('admin/');
}
$data['title'] = $this->lang->line('xin_hr_report_user_roles_report').' | '.$this->Xin_model->site_title();
$data['breadcrumbs'] = $this->lang->line('xin_hr_report_user_roles_report');
$data['path_url'] = 'reports_roles';
$data['all_companies'] = $this->Xin_model->get_companies();
$data['all_user_roles'] = $this->Roles_model->all_user_roles();
$role_resources_ids = $this->Xin_model->user_role_resource();
if(in_array('116',$role_resources_ids)) {
$data['subview'] = $this->load->view("admin/reports/roles", $data, TRUE);
$this->load->view('admin/layout/layout_main', $data); //page load
} else {
redirect('admin/dashboard');
}
}
// employees report
public function employees() {
$session = $this->session->userdata('username');
if(empty($session)){
redirect('admin/');
}
$data['title'] = $this->lang->line('xin_hr_report_employees').' | '.$this->Xin_model->site_title();
$data['breadcrumbs'] = $this->lang->line('xin_hr_report_employees');
$data['path_url'] = 'reports_employees';
$data['all_companies'] = $this->Xin_model->get_companies();
$data['all_departments'] = $this->Department_model->all_departments();
$data['all_designations'] = $this->Designation_model->all_designations();
$role_resources_ids = $this->Xin_model->user_role_resource();
if(in_array('117',$role_resources_ids)) {
$data['subview'] = $this->load->view("admin/reports/employees", $data, TRUE);
$this->load->view('admin/layout/layout_main', $data); //page load
} else {
redirect('admin/dashboard');
}
}
// 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/reports/report_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"));
}
// 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/reports/report_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"));
}
// reports > employee attendance
public function employee_attendance() {
$session = $this->session->userdata('username');
if(empty($session)){
redirect('admin/');
}
$data['title'] = $this->lang->line('xin_hr_reports_attendance_employee').' | '.$this->Xin_model->site_title();
$data['breadcrumbs'] = $this->lang->line('xin_hr_reports_attendance_employee');
$data['path_url'] = 'reports_employee_attendance';
$data['get_all_companies'] = $this->Xin_model->get_companies();
$role_resources_ids = $this->Xin_model->user_role_resource();
if(in_array('112',$role_resources_ids)) {
$data['subview'] = $this->load->view("admin/reports/employee_attendance", $data, TRUE);
$this->load->view('admin/layout/layout_main', $data); //page load
} else {
redirect('admin/dashboard');
}
}
// reports > employee leave
public function employee_leave() {
$session = $this->session->userdata('username');
if(empty($session)){
redirect('admin/');
}
$data['title'] = $this->lang->line('xin_leave_status').' | '.$this->Xin_model->site_title();
$data['breadcrumbs'] = $this->lang->line('xin_leave_status');
$data['path_url'] = 'reports_employee_leave';
$data['get_all_companies'] = $this->Xin_model->get_companies();
$role_resources_ids = $this->Xin_model->user_role_resource();
if(in_array('31',$role_resources_ids)) {
$data['subview'] = $this->load->view("admin/reports/employee_leave", $data, TRUE);
$this->load->view('admin/layout/layout_main', $data); //page load
} else {
redirect('admin/dashboard');
}
}
// reports > employee training
public function employee_training() {
$session = $this->session->userdata('username');
if(empty($session)){
redirect('admin/');
}
$data['title'] = $this->lang->line('xin_hr_reports_training').' | '.$this->Xin_model->site_title();
$data['breadcrumbs'] = $this->lang->line('xin_hr_reports_training');
$data['path_url'] = 'reports_employee_training';
$data['get_all_companies'] = $this->Xin_model->get_companies();
$role_resources_ids = $this->Xin_model->user_role_resource();
if(in_array('113',$role_resources_ids)) {
$data['subview'] = $this->load->view("admin/reports/employee_training", $data, TRUE);
$this->load->view('admin/layout/layout_main', $data); //page load
} else {
redirect('admin/dashboard');
}
}
// Validate and add info in database
public function payslip_report() {
if($this->input->post('type')=='payslip_report') {
/* 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('company_id')==='') {
$Return['error'] = $this->lang->line('error_company_field');
} else if($this->input->post('employee_id')==='') {
$Return['error'] = $this->lang->line('xin_error_employee_id');
} else if($this->input->post('month_year')==='') {
$Return['error'] = $this->lang->line('xin_hr_report_error_month_field');
}
if($Return['error']!=''){
$this->output($Return);
}
$Return['result'] = $this->lang->line('xin_hr_request_submitted');
$this->output($Return);
}
}
public function role_employees_list() {
$data['title'] = $this->Xin_model->site_title();
$session = $this->session->userdata('username');
if(!empty($session)){
$this->load->view("admin/reports/roles", $data);
} else {
redirect('admin/');
}
// Datatables Variables
$draw = intval($this->input->get("draw"));
$start = intval($this->input->get("start"));
$length = intval($this->input->get("length"));
$roleId = $this->uri->segment(4);
$employee = $this->Reports_model->get_roles_employees($roleId);
$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.')';
$data[] = array(
$r->employee_id,
$full_name,
$comp_name,
$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 report_employees_list()
{
$data['title'] = $this->Xin_model->site_title();
$session = $this->session->userdata('username');
if(!empty($session)){
$this->load->view("admin/reports/employees", $data);
} else {
redirect('admin/');
}
// Datatables Variables
$draw = intval($this->input->get("draw"));
$start = intval($this->input->get("start"));
$length = intval($this->input->get("length"));
$company_id = $this->uri->segment(4);
$department_id = $this->uri->segment(5);
$designation_id = $this->uri->segment(6);
$employee = $this->Reports_model->get_employees_reports($company_id,$department_id,$designation_id);
$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;
// 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 = '--';
}
$data[] = array(
$r->employee_id,
$full_name,
$comp_name,
$r->email,
$department_name,
$designation_name,
$status
);
}
$output = array(
"draw" => $draw,
"recordsTotal" => $employee->num_rows(),
"recordsFiltered" => $employee->num_rows(),
"data" => $data
);
echo json_encode($output);
exit();
}
public function task_list()
{
$data['title'] = $this->Xin_model->site_title();
$session = $this->session->userdata('username');
if(!empty($session)){
$this->load->view("admin/reports/tasks", $data);
} else {
redirect('admin/');
}
// Datatables Variables
$draw = intval($this->input->get("draw"));
$start = intval($this->input->get("start"));
$length = intval($this->input->get("length"));
$taskId = $this->uri->segment(4);
$taskStatus = $this->uri->segment(5);
$user_info = $this->Xin_model->read_user_info($session['user_id']);
if($user_info[0]->user_role_id==1){
$tasks = $this->Reports_model->get_task_list($taskId,$taskStatus);
} else {
$tasks = $this->Timesheet_model->get_employee_tasks($session['user_id']);
}
$data = array();
foreach($tasks->result() as $r) {
// get start date
$start_date = $this->Xin_model->set_date_format($r->start_date);
// get end date
$end_date = $this->Xin_model->set_date_format($r->end_date);
//status
if($r->task_status == 0) {
$status = $this->lang->line('xin_not_started');
} else if($r->task_status ==1){
$status = $this->lang->line('xin_in_progress');
} else if($r->task_status ==2){
$status = $this->lang->line('xin_completed');
} else {
$status = $this->lang->line('xin_deffered');
}
//assigned user
if($r->assigned_to == '') {
$ol = $this->lang->line('xin_not_assigned');
} else {
$ol = '';
foreach(explode(',',$r->assigned_to) as $desig_id) {
$assigned_to = $this->Xin_model->read_user_info($desig_id);
if(!is_null($assigned_to)){
$assigned_name = $assigned_to[0]->first_name.' '.$assigned_to[0]->last_name;
$ol .= '- '.$assigned_name.'
';
}
}
$ol .= '
';
}
// task category
$task_catname = $r->task_name;
$data[] = array(
$task_catname,$start_date,$end_date,$ol,$status,
);
}
$output = array(
"draw" => $draw,
"recordsTotal" => $tasks->num_rows(),
"recordsFiltered" => $tasks->num_rows(),
"data" => $data
);
echo json_encode($output);
exit();
}
public function project_list() {
$data['title'] = $this->Xin_model->site_title();
$session = $this->session->userdata('username');
if(!empty($session)){
$this->load->view("admin/reports/projects", $data);
} else {
redirect('admin/');
}
// Datatables Variables
$draw = intval($this->input->get("draw"));
$start = intval($this->input->get("start"));
$length = intval($this->input->get("length"));
$projId = $this->uri->segment(4);
$projStatus = $this->uri->segment(5);
$role_resources_ids = $this->Xin_model->user_role_resource();
$user_info = $this->Xin_model->read_user_info($session['user_id']);
if($user_info[0]->user_role_id==1){
$project = $this->Reports_model->get_project_list($projId,$projStatus);
} else {
$project = $this->Project_model->get_employee_projects($session['user_id']);
}
$data = array();
foreach($project->result() as $r) {
// get start date
$start_date = $this->Xin_model->set_date_format($r->start_date);
// get end date
$end_date = $this->Xin_model->set_date_format($r->end_date);
$pbar = ''.$this->lang->line('xin_completed').' '.$r->project_progress.'%
';
//status
if($r->status == 0) {
$status = $this->lang->line('xin_not_started');
} else if($r->status ==1){
$status = $this->lang->line('xin_in_progress');
} else if($r->status ==2){
$status = $this->lang->line('xin_completed');
} else {
$status = $this->lang->line('xin_deffered');
}
// priority
if($r->priority == 1) {
$priority = ''.$this->lang->line('xin_highest').'';
} else if($r->priority ==2){
$priority = ''.$this->lang->line('xin_high').'';
} else if($r->priority ==3){
$priority = ''.$this->lang->line('xin_normal').'';
} else {
$priority = ''.$this->lang->line('xin_low').'';
}
//assigned user
if($r->assigned_to == '') {
$ol = $this->lang->line('xin_not_assigned');
} else {
$ol = '';
foreach(explode(',',$r->assigned_to) as $desig_id) {
$assigned_to = $this->Xin_model->read_user_info($desig_id);
if(!is_null($assigned_to)){
$assigned_name = $assigned_to[0]->first_name.' '.$assigned_to[0]->last_name;
$ol .= $assigned_name."
";
}
}
$ol .= '';
}
$new_time = $this->Xin_model->actual_hours_timelog($r->project_id);
//echo $new_time;
$project_summary = '';
$data[] = array(
$project_summary,
$priority,
$start_date,
$end_date,
$status,
$pbar,
$ol,
$r->budget_hours,
$new_time,
);
}
$output = array(
"draw" => $draw,
"recordsTotal" => $project->num_rows(),
"recordsFiltered" => $project->num_rows(),
"data" => $data
);
echo json_encode($output);
exit();
}
public function training_list()
{
$data['title'] = $this->Xin_model->site_title();
$session = $this->session->userdata('username');
if(!empty($session)){
$this->load->view("admin/reports/employee_training", $data);
} else {
redirect('admin/');
}
// Datatables Variables
$draw = intval($this->input->get("draw"));
$start = intval($this->input->get("start"));
$length = intval($this->input->get("length"));
$start_date = $this->uri->segment(4);
$end_date = $this->uri->segment(5);
$uid = $this->uri->segment(6);
$cid = $this->uri->segment(7);
$training = $this->Reports_model->get_training_list($cid,$start_date,$end_date);
$data = array();
foreach($training->result() as $r) {
$aim = explode(',',$r->employee_id);
foreach($aim as $dIds) {
if($uid == $dIds) {
// get training type
$type = $this->Training_model->read_training_type_information($r->training_type_id);
if(!is_null($type)){
$itype = $type[0]->type;
} else {
$itype = '--';
}
// get trainer
/*$trainer = $this->Trainers_model->read_trainer_information($r->trainer_id);
// trainer full name
if(!is_null($trainer)){
$trainer_name = $trainer[0]->first_name.' '.$trainer[0]->last_name;
} else {
$trainer_name = '--';
}*/
// get trainer
if($r->trainer_option == 2){
$trainer = $this->Trainers_model->read_trainer_information($r->trainer_id);
// trainer full name
if(!is_null($trainer)){
$trainer_name = $trainer[0]->first_name.' '.$trainer[0]->last_name;
} else {
$trainer_name = '--';
}
} elseif($r->trainer_option == 1){
// get user > employee_
$trainer = $this->Xin_model->read_user_info($r->trainer_id);
// employee full name
if(!is_null($trainer)){
$trainer_name = $trainer[0]->first_name.' '.$trainer[0]->last_name;
} else {
$trainer_name = '--';
}
} else {
$trainer_name = '--';
}
// get start date
$start_date = $this->Xin_model->set_date_format($r->start_date);
// get end date
$finish_date = $this->Xin_model->set_date_format($r->finish_date);
// training date
$training_date = $start_date.' '.$this->lang->line('dashboard_to').' '.$finish_date;
// set currency
$training_cost = $this->Xin_model->currency_sign($r->training_cost);
/* get Employee info*/
if($uid == '') {
$ol = '--';
} else {
$user = $this->Exin_model->read_user_info($uid);
$fname = $user[0]->first_name.' '.$user[0]->last_name;
}
// status
if($r->training_status==0): $status = $this->lang->line('xin_pending');
elseif($r->training_status==1): $status = $this->lang->line('xin_started'); elseif($r->training_status==2): $status = $this->lang->line('xin_completed');
else: $status = $this->lang->line('xin_terminated'); endif;
// get company
$company = $this->Xin_model->read_company_info($r->company_id);
if(!is_null($company)){
$comp_name = $company[0]->name;
} else {
$comp_name = '--';
}
$data[] = array(
$comp_name,
$fname,
$itype,
$trainer_name,
$training_date,
$training_cost,
$status
);
}
} } // e- training
$output = array(
"draw" => $draw,
"recordsTotal" => $training->num_rows(),
"recordsFiltered" => $training->num_rows(),
"data" => $data
);
echo json_encode($output);
exit();
}
// hourly_list > templates
public function payslip_report_list()
{
$data['title'] = $this->Xin_model->site_title();
$session = $this->session->userdata('username');
if(!empty($session)){
$this->load->view("admin/reports/payslip", $data);
} else {
redirect('admin/');
}
// Datatables Variables
$draw = intval($this->input->get("draw"));
$start = intval($this->input->get("start"));
$length = intval($this->input->get("length"));
$cid = $this->uri->segment(4);
$eid = $this->uri->segment(5);
$re_date = $this->uri->segment(6);
$payslip_re = $this->Reports_model->get_payslip_list($cid,$eid,$re_date);
$data = array();
foreach($payslip_re->result() as $r) {
// get addd by > template
$user = $this->Xin_model->read_user_info($r->employee_id);
// user full name
if(!is_null($user)){
$full_name = $user[0]->first_name.' '.$user[0]->last_name;
$emp_link = $user[0]->employee_id;
$month_payment = date("F, Y", strtotime($r->salary_month));
$p_amount = $this->Xin_model->currency_sign($r->net_salary);
if($r->wages_type==1){
$payroll_type = $this->lang->line('xin_payroll_basic_salary');
} else {
$payroll_type = $this->lang->line('xin_employee_daily_wages');
}
// get date > created at > and format
$created_at = $this->Xin_model->set_date_format($r->created_at);
$data[] = array(
$emp_link,
$full_name,
$p_amount,
$month_payment,
$created_at,
$payroll_type
);
}
} // if employee available
$output = array(
"draw" => $draw,
"recordsTotal" => $payslip_re->num_rows(),
"recordsFiltered" => $payslip_re->num_rows(),
"data" => $data
);
echo json_encode($output);
exit();
}
// get company > employees
public function get_employees() {
$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/reports/get_employees", $data);
} else {
redirect('admin/');
}
// Datatables Variables
$draw = intval($this->input->get("draw"));
$start = intval($this->input->get("start"));
$length = intval($this->input->get("length"));
}
// get company > employees
public function get_employees_att() {
$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/reports/get_employees_att", $data);
} else {
redirect('admin/');
}
// Datatables Variables
$draw = intval($this->input->get("draw"));
$start = intval($this->input->get("start"));
$length = intval($this->input->get("length"));
}
// daily attendance list > timesheet
public function empdtwise_attendance_list()
{
$data['title'] = $this->Xin_model->site_title();
$session = $this->session->userdata('username');
if(!empty($session)){
$this->load->view("admin/reports/employee_attendance", $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->Xin_model->read_user_attendance_info();
$data = array();
foreach($employee->result() as $r) {
$data[] = array('','','','','','','','');
}
$output = array(
"draw" => $draw,
"recordsTotal" => $employee->num_rows(),
"recordsFiltered" => $employee->num_rows(),
"data" => $data
);
echo json_encode($output);
exit();
}
// date wise attendance list > timesheet
public function employee_date_wise_list()
{
$data['title'] = $this->Xin_model->site_title();
$session = $this->session->userdata('username');
$user_info = $this->Xin_model->read_user_info($session['user_id']);
if(!empty($session)){
$this->load->view("admin/reports/employee_attendance", $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_id = $this->input->get("user_id");
//$employee = $this->Xin_model->read_user_info($employee_id);
$employee = $this->Xin_model->read_user_info($employee_id);
$start_date = new DateTime( $this->input->get("start_date"));
$end_date = new DateTime( $this->input->get("end_date") );
$end_date = $end_date->modify( '+1 day' );
$interval_re = new DateInterval('P1D');
$date_range = new DatePeriod($start_date, $interval_re ,$end_date);
$attendance_arr = array();
$data = array();
foreach($date_range as $date) {
$attendance_date = $date->format("Y-m-d");
// foreach($employee->result() as $r) {
// user full name
// $full_name = $r->first_name.' '.$r->last_name;
// get office shift for employee
$get_day = strtotime($attendance_date);
$day = date('l', $get_day);
// office shift
$office_shift = $this->Timesheet_model->read_office_shift_information($employee[0]->office_shift_id);
// get clock in/clock out of each employee
if($day == 'Monday') {
if($office_shift[0]->monday_in_time==''){
$in_time = '00:00:00';
$out_time = '00:00:00';
} else {
$in_time = $office_shift[0]->monday_in_time;
$out_time = $office_shift[0]->monday_out_time;
}
} else if($day == 'Tuesday') {
if($office_shift[0]->tuesday_in_time==''){
$in_time = '00:00:00';
$out_time = '00:00:00';
} else {
$in_time = $office_shift[0]->tuesday_in_time;
$out_time = $office_shift[0]->tuesday_out_time;
}
} else if($day == 'Wednesday') {
if($office_shift[0]->wednesday_in_time==''){
$in_time = '00:00:00';
$out_time = '00:00:00';
} else {
$in_time = $office_shift[0]->wednesday_in_time;
$out_time = $office_shift[0]->wednesday_out_time;
}
} else if($day == 'Thursday') {
if($office_shift[0]->thursday_in_time==''){
$in_time = '00:00:00';
$out_time = '00:00:00';
} else {
$in_time = $office_shift[0]->thursday_in_time;
$out_time = $office_shift[0]->thursday_out_time;
}
} else if($day == 'Friday') {
if($office_shift[0]->friday_in_time==''){
$in_time = '00:00:00';
$out_time = '00:00:00';
} else {
$in_time = $office_shift[0]->friday_in_time;
$out_time = $office_shift[0]->friday_out_time;
}
} else if($day == 'Saturday') {
if($office_shift[0]->saturday_in_time==''){
$in_time = '00:00:00';
$out_time = '00:00:00';
} else {
$in_time = $office_shift[0]->saturday_in_time;
$out_time = $office_shift[0]->saturday_out_time;
}
} else if($day == 'Sunday') {
if($office_shift[0]->sunday_in_time==''){
$in_time = '00:00:00';
$out_time = '00:00:00';
} else {
$in_time = $office_shift[0]->sunday_in_time;
$out_time = $office_shift[0]->sunday_out_time;
}
}
// check if clock-in for date
$attendance_status = '';
$check = $this->Timesheet_model->attendance_first_in_check($employee[0]->user_id,$attendance_date);
if($check->num_rows() > 0){
// check clock in time
$attendance = $this->Timesheet_model->attendance_first_in($employee[0]->user_id,$attendance_date);
// clock in
$clock_in = new DateTime($attendance[0]->clock_in);
$clock_in2 = $clock_in->format('h:i a');
$clkInIp = $clock_in2.'
';
$office_time = new DateTime($in_time.' '.$attendance_date);
//time diff > total time late
$office_time_new = strtotime($in_time.' '.$attendance_date);
$clock_in_time_new = strtotime($attendance[0]->clock_in);
if($clock_in_time_new <= $office_time_new) {
$total_time_l = '00:00';
} else {
$interval_late = $clock_in->diff($office_time);
$hours_l = $interval_late->format('%h');
$minutes_l = $interval_late->format('%i');
$total_time_l = $hours_l ."h ".$minutes_l."m";
}
// total hours work/ed
$total_hrs = $this->Timesheet_model->total_hours_worked_attendance($employee[0]->user_id,$attendance_date);
$hrs_old_int1 = 0;
$Total = '';
$Trest = '';
$hrs_old_seconds = 0;
$hrs_old_seconds_rs = 0;
$total_time_rs = '';
$hrs_old_int_res1 = 0;
foreach ($total_hrs->result() as $hour_work){
// total work
$timee = $hour_work->total_work.':00';
$str_time =$timee;
$str_time = preg_replace("/^([\d]{1,2})\:([\d]{2})$/", "00:$1:$2", $str_time);
sscanf($str_time, "%d:%d:%d", $hours, $minutes, $seconds);
$hrs_old_seconds = $hours * 3600 + $minutes * 60 + $seconds;
$hrs_old_int1 += $hrs_old_seconds;
$Total = gmdate("H:i", $hrs_old_int1);
}
if($Total=='') {
$total_work = '00:00';
} else {
$total_work = $Total;
}
// total rest >
$total_rest = $this->Timesheet_model->total_rest_attendance($employee[0]->user_id,$attendance_date);
foreach ($total_rest->result() as $rest){
// total rest
$str_time_rs = $rest->total_rest.':00';
//$str_time_rs =$timee_rs;
$str_time_rs = preg_replace("/^([\d]{1,2})\:([\d]{2})$/", "00:$1:$2", $str_time_rs);
sscanf($str_time_rs, "%d:%d:%d", $hours_rs, $minutes_rs, $seconds_rs);
$hrs_old_seconds_rs = $hours_rs * 3600 + $minutes_rs * 60 + $seconds_rs;
$hrs_old_int_res1 += $hrs_old_seconds_rs;
$total_time_rs = gmdate("H:i", $hrs_old_int_res1);
}
// check attendance status
$status = $attendance[0]->attendance_status;
if($total_time_rs=='') {
$Trest = '00:00';
} else {
$Trest = $total_time_rs;
}
} else {
$clock_in2 = '-';
$total_time_l = '00:00';
$total_work = '00:00';
$Trest = '00:00';
$clkInIp = $clock_in2;
// get holiday/leave or absent
/* attendance status */
// get holiday
$h_date_chck = $this->Timesheet_model->holiday_date_check($attendance_date);
$holiday_arr = array();
if($h_date_chck->num_rows() == 1){
$h_date = $this->Timesheet_model->holiday_date($attendance_date);
$begin = new DateTime( $h_date[0]->start_date );
$end = new DateTime( $h_date[0]->end_date);
$end = $end->modify( '+1 day' );
$interval = new DateInterval('P1D');
$daterange = new DatePeriod($begin, $interval ,$end);
foreach($daterange as $date){
$holiday_arr[] = $date->format("Y-m-d");
}
} else {
$holiday_arr[] = '99-99-99';
}
// get leave/employee
$leave_date_chck = $this->Timesheet_model->leave_date_check($employee[0]->user_id,$attendance_date);
$leave_arr = array();
if($leave_date_chck->num_rows() == 1){
$leave_date = $this->Timesheet_model->leave_date($employee[0]->user_id,$attendance_date);
$begin1 = new DateTime( $leave_date[0]->from_date );
$end1 = new DateTime( $leave_date[0]->to_date);
$end1 = $end1->modify( '+1 day' );
$interval1 = new DateInterval('P1D');
$daterange1 = new DatePeriod($begin1, $interval1 ,$end1);
foreach($daterange1 as $date1){
$leave_arr[] = $date1->format("Y-m-d");
}
} else {
$leave_arr[] = '99-99-99';
}
if($office_shift[0]->monday_in_time == '' && $day == 'Monday') {
$status = $this->lang->line('xin_holiday');
} else if($office_shift[0]->tuesday_in_time == '' && $day == 'Tuesday') {
$status = $this->lang->line('xin_holiday');
} else if($office_shift[0]->wednesday_in_time == '' && $day == 'Wednesday') {
$status = $this->lang->line('xin_holiday');
} else if($office_shift[0]->thursday_in_time == '' && $day == 'Thursday') {
$status = $this->lang->line('xin_holiday');
} else if($office_shift[0]->friday_in_time == '' && $day == 'Friday') {
$status = $this->lang->line('xin_holiday');
} else if($office_shift[0]->saturday_in_time == '' && $day == 'Saturday') {
$status = $this->lang->line('xin_holiday');
} else if($office_shift[0]->sunday_in_time == '' && $day == 'Sunday') {
$status = $this->lang->line('xin_holiday');
} else if(in_array($attendance_date,$holiday_arr)) { // holiday
$status = $this->lang->line('xin_holiday');
} else if(in_array($attendance_date,$leave_arr)) { // on leave
$status = $this->lang->line('xin_on_leave');
}
else {
$status = $this->lang->line('xin_absent');
}
}
// check if clock-out for date
$check_out = $this->Timesheet_model->attendance_first_out_check($employee[0]->user_id,$attendance_date);
if($check_out->num_rows() == 1){
/* early time */
$early_time = new DateTime($out_time.' '.$attendance_date);
// check clock in time
$first_out = $this->Timesheet_model->attendance_first_out($employee[0]->user_id,$attendance_date);
// clock out
$clock_out = new DateTime($first_out[0]->clock_out);
if ($first_out[0]->clock_out!='') {
$clock_out2 = $clock_out->format('h:i a');
$clkOutIp = $clock_out2.'
';
// early leaving
$early_new_time = strtotime($out_time.' '.$attendance_date);
$clock_out_time_new = strtotime($first_out[0]->clock_out);
if($early_new_time <= $clock_out_time_new) {
$total_time_e = '00:00';
} else {
$interval_lateo = $clock_out->diff($early_time);
$hours_e = $interval_lateo->format('%h');
$minutes_e = $interval_lateo->format('%i');
$total_time_e = $hours_e ."h ".$minutes_e."m";
}
/* over time */
$over_time = new DateTime($out_time.' '.$attendance_date);
$overtime2 = $over_time->format('h:i a');
// over time
$over_time_new = strtotime($out_time.' '.$attendance_date);
$clock_out_time_new1 = strtotime($first_out[0]->clock_out);
if($clock_out_time_new1 <= $over_time_new) {
$overtime2 = '00:00';
} else {
$interval_lateov = $clock_out->diff($over_time);
$hours_ov = $interval_lateov->format('%h');
$minutes_ov = $interval_lateov->format('%i');
$overtime2 = $hours_ov ."h ".$minutes_ov."m";
}
} else {
$clock_out2 = '-';
$total_time_e = '00:00';
$overtime2 = '00:00';
$clkOutIp = $clock_out2;
}
} else {
$clock_out2 = '-';
$total_time_e = '00:00';
$overtime2 = '00:00';
$clkOutIp = $clock_out2;
}
// user full name
$full_name = $employee[0]->first_name.' '.$employee[0]->last_name;
// get company
$company = $this->Xin_model->read_company_info($employee[0]->company_id);
if(!is_null($company)){
$comp_name = $company[0]->name;
} else {
$comp_name = '--';
}
// attendance date
$tdate = $this->Xin_model->set_date_format($attendance_date);
/*if($user_info[0]->user_role_id==1){
$fclckIn = $clkInIp;
$fclckOut = $clkOutIp;
} else {
$fclckIn = $clock_in2;
$fclckOut = $clock_out2;
}*/
// attendance date
//$tdate = $this->Xin_model->set_date_format($attendance_date);
$data[] = array(
$full_name,
$comp_name,
$status,
$tdate,
$clock_in2,
$clock_out2,
$total_work
);
}
$output = array(
"draw" => $draw,
//"recordsTotal" => count($date_range),
//"recordsFiltered" => count($date_range),
"data" => $data
);
echo json_encode($output);
exit();
}
public function employee_leave_list() {
$data['title'] = $this->Xin_model->site_title();
$session = $this->session->userdata('username');
if(!empty($session)){
$this->load->view("admin/reports/employee_leave", $data);
} else {
redirect('admin/');
}
// Datatables Variables
$draw = intval($this->input->get("draw"));
$start = intval($this->input->get("start"));
$length = intval($this->input->get("length"));
$sd = $this->uri->segment(4);
$ed = $this->uri->segment(5);
$user_id = $this->uri->segment(6);
$company_id = $this->uri->segment(7);
if($user_id == '') {
$employee = $this->Reports_model->get_leave_application_list();
} else {
$employee = $this->Reports_model->get_leave_application_filter_list($sd,$ed,$user_id,$company_id);
}
$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 = '--';
}
$employee = $this->Xin_model->read_user_info($r->employee_id);
// user full name
if(!is_null($employee)){
$full_name = $employee[0]->first_name.' '.$employee[0]->last_name;
} else {
$full_name = '--';
}
//approved leave
$rapproved = $this->Reports_model->get_approved_leave_application_list($r->employee_id);
$approved = ''.$rapproved.' '.$this->lang->line('xin_view').'';
// pending leave
$rpending = $this->Reports_model->get_pending_leave_application_list($r->employee_id);
$pending = ''.$rpending.' '.$this->lang->line('xin_view').'';
//upcoming leave
$rupcoming = $this->Reports_model->get_upcoming_leave_application_list($r->employee_id);
$upcoming = ''.$rupcoming.' '.$this->lang->line('xin_view').'';
//rejected leave
$rrejected = $this->Reports_model->get_rejected_leave_application_list($r->employee_id);
$rejected = ''.$rrejected.' '.$this->lang->line('xin_view').'';
$data[] = array(
$comp_name,
$full_name,
$approved,
$pending,
$upcoming,
$rejected,
);
}
$output = array(
"draw" => $draw,
//"recordsTotal" => $employee->num_rows(),
//"recordsFiltered" => $employee->num_rows(),
"data" => $data
);
echo json_encode($output);
exit();
}
public function read_leave_details() {
$session = $this->session->userdata('username');
if(empty($session)){
redirect('admin/');
}
$data['title'] = $this->Xin_model->site_title();
$id = $this->input->get('employee_id');
//$result = $this->Job_post_model->read_job_application_info($id);
$data = 'A';
if(!empty($session)){
$this->load->view('admin/reports/dialog_leave_details', $data);
} else {
redirect('admin/');
}
}
}
?>