public function generateAttendanceEmployee($empID, $month, $year)
{
$attendance = array();
$start_date = new DateTime("{$year}-{$month}-01");
$end_date = new DateTime($start_date->format('Y-m-t'));
$attendance = Attendance_model::getAttendance($empID, $start_date->format('Y-m-d'), $end_date->format('Y-m-d'));
/*
$end_date = $end_date->modify('+1 day');
$period = new DatePeriod($start_date, new DateInterval('P1D'), $end_date);
foreach($period as $date){
//$row = $this->view_attendance($empID, $date->format("m/d/Y"));
$this->db->select('time_in, time_out, man_hours, tardiness, overtime');
$this->db->where('emp_id',$empID);
$this->db->where('logdate',$date->format("m/d/Y"));
$this->db->order_by('logdate');
$result = $this->db->get('view_attendance');
$row = $result->row();
$time_in = "";
$time_out = "";
$man_hours = 0;
$tardiness = 0;
$overtime = 0;
if(count($row)!=0){
$time_in = $row->time_in;
$time_out = $row->time_out;
$man_hours = $row->man_hours;
$tardiness = $row->tardiness;
$overtime = $row->overtime;
}
array_push($attendance, array(
"emp_id"=>$empID,
"datevalue"=>$date->format("Y-m-d"),
"datelog"=>$date->format("M d, Y"),
"weekday"=>$date->format("D"),
"time_in"=>$time_in,
"time_out"=>$time_out,
"man_hours"=>$man_hours,
"tardiness"=>$tardiness,
"overtime"=>$overtime));
}*/
return $attendance;
}
public function attendance_upload()
{
$config = array('allowed_types' => 'csv', 'upload_path' => 'assets/csv/', 'overwrite' => TRUE);
$this->load->library('csvreader');
$this->load->library('upload', $config);
$data['post'] = $this->input->post();
if ($data['post']) {
if (isset($data['post']['btnUpload'])) {
if (!$this->upload->do_upload()) {
$data['error'] = $this->upload->display_errors();
}
$data['csv'] = $this->upload->data();
$result = $this->csvreader->parse_file($data['csv']['full_path']);
$data['csvData'] = $result;
} else {
if (isset($data['post']['btnSave'])) {
$result = $this->csvreader->parse_file($data['post']['hidPath']);
Attendance_model::upload_attendance($result);
$this->session->set_userdata('added', 1);
redirect('payroll/attendance');
}
}
}
$data['pageTitle'] = 'Upload Attendance - MSInc.';
$data['content'] = 'attendance/attendance_upload';
$this->load->view($this->master_layout, $data);
$this->display_notif();
}
