'update_attendance_report', 'id' => 'update_attendance_report', 'autocomplete' => 'off');?>
$session['user_id']);?>
'emp_id',
'id' => 'emp_id',
'value' => $session['user_id'],
'type' => 'hidden',
'class' => 'form-control',
);
echo form_input($data);
?>
| lang->line('xin_action');?> |
lang->line('xin_in_time');?> |
lang->line('xin_out_time');?> |
lang->line('dashboard_total_work');?> |
>
'xin-form', 'id' => 'xin-form', 'autocomplete' => 'off');?>
$session['user_id']);?>
| lang->line('xin_employee');?> |
'.$i.' '.$dayOfWeek.'';?> |
lang->line('xin_timesheet_workdays');?> |
first_name.' '.$r->last_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.')';$pcount=0;
?>
'.$department_designation.'
'.$this->lang->line('xin_employees_id').': '.$r->employee_id.'';?>
|
user_id;
// office shift
$office_shift = $this->Timesheet_model->read_office_shift_information($r->office_shift_id);
// 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';
}
//echo ''; print_r($holiday_arr);
// get leave/employee
$leave_date_chck = $this->Timesheet_model->leave_date_check($r->user_id,$attendance_date);
$leave_arr = array();
if($leave_date_chck->num_rows() == 1){
$leave_date = $this->Timesheet_model->leave_date($r->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';
}
$attendance_status = '';
$check = $this->Timesheet_model->attendance_first_in_check($r->user_id,$attendance_date);
if($office_shift[0]->monday_in_time == '' && $day == 'Monday') {
$status = 'H';
} else if($office_shift[0]->tuesday_in_time == '' && $day == 'Tuesday') {
$status = 'H';
} else if($office_shift[0]->wednesday_in_time == '' && $day == 'Wednesday') {
$status = 'H';
} else if($office_shift[0]->thursday_in_time == '' && $day == 'Thursday') {
$status = 'H';
} else if($office_shift[0]->friday_in_time == '' && $day == 'Friday') {
$status = 'H';
} else if($office_shift[0]->saturday_in_time == '' && $day == 'Saturday') {
$status = 'H';
} else if($office_shift[0]->sunday_in_time == '' && $day == 'Sunday') {
$status = 'H';
} else if(in_array($attendance_date,$holiday_arr)) { // holiday
$status = 'H';
} else if(in_array($attendance_date,$leave_arr)) { // on leave
$status = 'L';
} else if($check->num_rows() > 0){
$attendance = $this->Timesheet_model->attendance_first_in($r->user_id,$attendance_date);
$status = 'P';//$attendance[0]->attendance_status;
} else {
$status = 'A';
//$pcount += 0;
}
$pcount += $check->num_rows();
// set to present date
$iattendance_date = strtotime($attendance_date);
$icurrent_date = strtotime(date('Y-m-d'));
if($iattendance_date <= $icurrent_date){
$status = $status;
} else {
$status = '';
}
$idate_of_joining = strtotime($r->date_of_joining);
if($idate_of_joining < $iattendance_date){
$status = $status;
} else {
$status = '';
}
?>
|
|
session->userdata('username');
$user_info = $this->Xin_model->read_user_info($session['user_id']);
$role_user = $this->Xin_model->read_user_role_info($user_info[0]->user_role_id);
if(!is_null($role_user)){
$role_resources_ids = explode(',',$role_user[0]->role_resources);
} else {
$role_resources_ids = explode(',',0);
}
$iuser = $this->Xin_model->read_user_info($session['user_id']);
$system = $this->Xin_model->read_setting_info(1);
$get_animate = $this->Xin_model->get_content_animate();
$month_year = $this->input->post('month_year');
if($user_info[0]->user_role_id==1){
$employee_id = $this->input->post('employee_id');
$company_id = $this->input->post('company_id');
/* Set the date */
//if(isset($company_id)){
$date = strtotime(date("Y-m-d"));
/* Set the date */
if(!isset($month_year)){
$day = date('d', $date);
$month = date('m', $date);
$year = date('Y', $date);
} else {
$imonth_year = explode('-',$month_year);
$day = date('d', $date);
$month = date($imonth_year[1], $date);
$year = date($imonth_year[0], $date);
}
if($employee_id == ''){
$r = $this->Xin_model->read_user_info($session['user_id']);
} else {
$r = $this->Xin_model->read_user_info($employee_id);
}
} else {
$date = strtotime(date("Y-m-d"));
/* Set the date */
if(!isset($month_year)){
$day = date('d', $date);
$month = date('m', $date);
$year = date('Y', $date);
$month_year = date('Y-m');
} else {
$imonth_year = explode('-',$month_year);
$day = date('d', $date);
$month = date($imonth_year[1], $date);
$year = date($imonth_year[0], $date);
$month_year = $month_year;
}
$r = $this->Xin_model->read_user_info($session['user_id']);
}
?>
Designation_model->read_designation_information($r[0]->designation_id);
if(!is_null($designation)){
$designation_name = $designation[0]->designation_name;
} else {
$designation_name = '--';
}
// department
$department = $this->Department_model->read_department_information($r[0]->department_id);
if(!is_null($department)){
$department_name = $department[0]->department_name;
} else {
$department_name = '--';
}
// get company
$company = $this->Xin_model->read_company_info($r[0]->company_id);
if(!is_null($company)){
$comp_name = $company[0]->name;
} else {
$comp_name = '--';
}
// total days in month
$daysInMonth = date('t');
$imonth = date('F', $date);
$pcount = 0;
$acount = 0;
$lcount = 0;
for($i = 1; $i <= $daysInMonth; $i++):
$i = str_pad($i, 2, 0, STR_PAD_LEFT);
// get date <
$attendance_date = $year.'-'.$month.'-'.$i;
$get_day = strtotime($attendance_date);
$day = date('l', $get_day);
$user_id = $r[0]->user_id;
$office_shift_id = $r[0]->office_shift_id;
$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($user_id,$attendance_date);
$leave_arr = array();
if($leave_date_chck->num_rows() == 1){
$leave_date = $this->Timesheet_model->leave_date($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';
}
$office_shift = $this->Timesheet_model->read_office_shift_information($office_shift_id);
$check = $this->Timesheet_model->attendance_first_in_check($user_id,$attendance_date);
// get holiday>events
if($office_shift[0]->monday_in_time == '' && $day == 'Monday') {
$status = 'H';
$pcount += 0;
//$acount += 0;
} else if($office_shift[0]->tuesday_in_time == '' && $day == 'Tuesday') {
$status = 'H';
$pcount += 0;
//$acount += 0;
} else if($office_shift[0]->wednesday_in_time == '' && $day == 'Wednesday') {
$status = 'H';
$pcount += 0;
//$acount += 0;
} else if($office_shift[0]->thursday_in_time == '' && $day == 'Thursday') {
$status = 'H';
$pcount += 0;
//$acount += 0;
} else if($office_shift[0]->friday_in_time == '' && $day == 'Friday') {
$status = 'H';
$pcount += 0;
//$acount += 0;
} else if($office_shift[0]->saturday_in_time == '' && $day == 'Saturday') {
$status = 'H';
$pcount += 0;
//$acount -= 1;
} else if($office_shift[0]->sunday_in_time == '' && $day == 'Sunday') {
$status = 'H';
$pcount += 0;
//$acount -= 1;
} else if(in_array($attendance_date,$holiday_arr)) { // holiday
$status = 'H';
$pcount += 0;
//$acount += 0;
} else if(in_array($attendance_date,$leave_arr)) { // on leave
$status = 'L';
$pcount += 0;
$lcount += 1;
// $acount += 0;
} else if($check->num_rows() > 0){
$pcount += 1;
//$acount -= 1;
} else {
$status = 'A';
//$acount += 1;
$pcount += 0;
// set to present date
$iattendance_date = strtotime($attendance_date);
$icurrent_date = strtotime(date('Y-m-d'));
if($iattendance_date <= $icurrent_date){
$acount += 1;
} else {
$acount += 0;
}
}
endfor;
//}
?>
'xin-form', 'id' => 'xin-form', 'autocomplete' => 'off');?>
$session['user_id']);?>
user_role_id!=1){?>
| lang->line('left_company');?> |
|
| lang->line('left_department');?> |
|
| lang->line('left_designation');?> |
|
| lang->line('dashboard_employee_id');?> |
employee_id;?> |
| lang->line('xin_attendance_total_present');?> |
|
| lang->line('xin_attendance_total_absent');?> |
|
| lang->line('xin_attendance_total_leave');?> |
|