/** * 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(); } }