/**
* Update filed over time
*/
public function updateot()
{
// Pontiac is set to America/New_York, we'll need to set it to Asia
date_default_timezone_set("Asia/Singapore");
$this->load->model('employeelogs');
$emplogs = new Employeelogs();
$emplogs->OTReason = $this->db->escape($this->input->post('otreason'));
$emplogs->{$this->input->post('ottype')} = $this->input->post('othours') * 60;
// In the event the user changes the Overtime type, we'll need to clear the
// old column.
foreach ($this->config->item('ot_types') as $key => $val) {
if ($key != $this->input->post('ottype')) {
$emplogs->{$key} = "0";
}
}
$emplogs->AuditUser = trim($this->session->userdata('employeenumber'));
$emplogs->AuditDate = date("Y-m-d H:i:s");
$emplogs->update($this->input->post('userlogid'));
echo "Updated";
}
/**
* Insert leave details to Employeelogs
*
* @param date $leavedate
* @param Employeeleavesfiled $empleave
* @return void
*/
private function _inserttoemplogs($leavedate, Employeeleavesfiled $empleave)
{
$schedule = new Schedules();
$emplogs = new Employeelogs();
$schedule->Date = '\'' . $leavedate . ' 00:00:00\'';
$schedule->EmployeeNumber = $empleave->EmployeeNumber;
$sched = $schedule->get();
if (isset($sched) && !empty($sched)) {
$emplogs->EmployeeNumber = '\'' . $empleave->EmployeeNumber . '\'';
$emplogs->ScheduleID = $sched[0]->ScheduleID;
$emplogs->TimeIn = '\'' . $sched[0]->SchedIn . '\'';
$emplogs->Timeout = '\'' . $sched[0]->SchedOut . '\'';
$emplogs->EarlyLogin = 1;
$emplogs->AttendanceType = '\'' . $empleave->Type . '\'';
$emplogs->LeaveFiledID = $empleave->LeaveID;
$emplogs->insert();
}
}
