public function UpdateJobQueue(JobQueueEntity $oJobQueueEntity) { $iId = $oJobQueueEntity->getId(); $iUserId = $oJobQueueEntity->getUserId(); $sStatus = $oJobQueueEntity->getStatus(); $sJobStartTime = ''; $sJobEndTime = 'NULL'; if ($sStatus === 'started') { $sJobStartTime = 'job_start_time = NOW(),'; } if ($sStatus === 'completed') { $sJobEndTime = 'NOW()'; } $sSql = 'UPDATE ' . $this->sTableName . ' SET ' . $sJobStartTime . ' job_status = ? , job_end_time = ' . $sJobEndTime . ' WHERE id = ?'; $aBindArray = array($sStatus, $iId); $this->Execute($sSql, $aBindArray); }