/** * save immigration * @param EmployeeImmigrationRecord $employeeImmigrationRecord * @return EmployeeImmigrationRecord */ public function saveEmployeeImmigrationRecord(EmployeeImmigrationRecord $employeeImmigrationRecord) { try { $recordId = 1; if (trim($employeeImmigrationRecord->getRecordId()) == "") { $q = Doctrine_Query::create()->select('MAX(p.recordId)')->from('EmployeeImmigrationRecord p')->where('p.empNumber = ?', $employeeImmigrationRecord->getEmpNumber()); $result = $q->execute(array(), Doctrine::HYDRATE_ARRAY); $recordId = $result[0]['MAX'] + 1; $employeeImmigrationRecord->setRecordId($recordId); } $employeeImmigrationRecord->save(); return $employeeImmigrationRecord; // @codeCoverageIgnoreStart } catch (Exception $e) { throw new DaoException($e->getMessage(), $e->getCode(), $e); } // @codeCoverageIgnoreEnd }