function getAllAttendanceRecord($month,$year,$emp) { $this->db->select('ATTND_EMP_ID, EMP_NM, REF_EMP_CD, REF_EMP_ID'); if($this->session->userdata('is_admin') == 1) { $this->db->where('OA_BRAND_ID', $this->session->userdata('oaBrandID')); } elseif($this->session->userdata('is_admin') == 0) { $this->db->where('USER_ID', $this->session->userdata('user_id')); } $length = 1; if($emp == null) { $data = $employees = $this->db->get('attendance_employee')->result_array(); $length = count($employees); } for($i = 0; $i < $length; $i++) { $sql = "SELECT ATTND_EMP_ID,EMPLOYEE_NM,REF_EMP_CD,REF_EMP_ID,PUNCH_IN_USER_TIME, PUNCH_OUT_USER_TIME, TIMEDIFF(PUNCH_OUT_USER_TIME, PUNCH_IN_USER_TIME) AS DURATION, DAY(PUNCH_IN_USER_TIME) AS DAY FROM emp_attendance_record_vw WHERE"; if($emp != null) { $sql .=" ATTND_EMP_ID = '".$emp."'"; } else { $sql .=" ATTND_EMP_ID = '{$employees[$i]['ATTND_EMP_ID']}'"; } if($year != 0 && $month != 0) { $sql .=" AND PUNCH_IN_USER_TIME BETWEEN '". date(''.$year.'-'.$month.'-01') ." 0:0:0' AND '". date(''.$year.'-'.$month.'-d') ." 23:59:59'"; } $sql .="GROUP BY DATE(PUNCH_IN_USER_TIME) ORDER BY ATTND_ID DESC"; echo "
",var_dump($sql),"
"; $temp_query = $this->db->query($sql)->result(); $maxDays = date('t'); $i = 0; foreach( $temp_query as $row ) { if($emp != null) { $new_data[$i]["DAY{$row->DAY}"] = 1; } else { $data[$i]["DAY{$row->DAY}"] = 1; } } } if($emp != null) { return $new_data; } else { return $data; } }