/**
* Test saving EmployeePassport without sequence number
*/
public function testSaveEmployeePassport1()
{
$empPassport = new EmployeeImmigrationRecord();
$empPassport->setEmpNumber(1);
$empPassport->setCountryCode('LK');
$result = $this->employeeDao->saveEmployeeImmigrationRecord($empPassport);
$this->assertTrue($result instanceof EmployeeImmigrationRecord);
$this->assertEquals(1, $empPassport->getRecordId());
}
/**
* 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
}
public function import($data)
{
set_time_limit(90);
if ($data[0] == "" || strlen($data[0]) > 30) {
return false;
}
$createUser = false;
$empService = new EmployeeService();
$employee = $empService->getEmployeeByEmployeeId($data[0]);
if (empty($employee)) {
$employee = new Employee();
$createUser = true;
}
if (strlen($data[0]) <= 50) {
$employee->setEmployeeId($data[0]);
}
$employee->setFirstName($data[1]);
if (strlen($data[2]) <= 30) {
$employee->setMiddleName($data[2]);
}
$employee->setLastName($data[3]);
if (strlen($data[4]) <= 30) {
$employee->setOtherId($data[4]);
}
if (strlen($data[5]) <= 30) {
$employee->setBloodGroup($data[5]);
}
if ($data[6] != "") {
$dob = $this->formatDate($data[6]);
$employee->setEmpBirthday($dob);
}
if (strtolower($data[7]) == 'male') {
$employee->setEmpGender('1');
} else {
if (strtolower($data[7]) == 'female') {
$employee->setEmpGender('2');
}
}
if (strtolower($data[8]) == 'single') {
$employee->setEmpMaritalStatus('Single');
} else {
if (strtolower($data[8]) == 'married') {
$employee->setEmpMaritalStatus('Married');
} else {
if (strtolower($data[8]) == 'other') {
$employee->setEmpMaritalStatus('Other');
}
}
}
$nationality = $this->isValidNationality($data[9]);
if (!empty($nationality)) {
$employee->setNationality($nationality);
}
if (strlen($data[10]) <= 70) {
$employee->setFatherName($data[10]);
}
if (strlen($data[11]) <= 70) {
$employee->setHusbandName($data[11]);
}
if (strlen($data[12]) <= 70) {
$employee->setStreet1($data[12]);
}
if (strlen($data[13]) <= 70) {
$employee->setStreet2($data[13]);
}
if (strlen($data[14]) <= 70) {
$employee->setCity($data[14]);
}
if (strlen($data[16]) <= 10) {
$employee->setEmpZipcode($data[16]);
}
$code = $this->isValidCountry($data[17]);
if (!empty($code)) {
$employee->setCountry($code);
if (strtolower($data[17]) == 'united states') {
$code = $this->isValidProvince($data[15]);
if (!empty($code)) {
$employee->setProvince($code);
}
} else {
if (strlen($data[15]) <= 70) {
$employee->setProvince($data[15]);
}
}
}
if (strlen($data[18]) <= 100) {
$employee->setPermanentAddress($data[18]);
}
if ($this->isValidEmail($data[19]) && strlen($data[19]) <= 50 && $this->isUniqueEmail($data[19])) {
$employee->setEmpWorkEmail($data[19]);
}
if ($this->isValidEmail($data[20]) && strlen($data[20]) <= 50) {
$employee->setEmpOthEmail($data[20]);
}
if ($this->isValidEmail($data[21]) && strlen($data[21]) <= 50) {
$employee->setEmpPersonalEmail($data[21]);
}
if (strlen($data[22]) <= 25 && $this->isValidPhoneNumber($data[22])) {
$employee->setEmpMobile($data[22]);
}
if (strlen($data[23]) <= 25 && $this->isValidPhoneNumber($data[23])) {
$employee->setEmpWorkTelephone($data[23]);
}
if (strlen($data[24]) <= 25 && $this->isValidPhoneNumber($data[24])) {
$employee->setEmpHmTelephone($data[24]);
}
if (strlen($data[25]) <= 50) {
$employee->setEmpPhoneAccesscode($data[25]);
}
if (strlen($data[26]) <= 50) {
$employee->setEmpSkypeId($data[26]);
}
if ($data[27] != "") {
$joinedDate = $this->formatDate($data[27]);
$employee->setJoinedDate($joinedDate);
}
$jobTitle = $this->isValidJobTitle($data[28]);
if (!empty($jobTitle)) {
$employee->setJobTitleCode($jobTitle);
}
if ($data[29] != "" && is_numeric($data[29])) {
$employee->setTotalExperience($data[29]);
}
if ($data[30] != "" && is_numeric($data[30])) {
$employee->setCurrentExperience($data[30]);
}
if ($data[31] != "" && is_numeric($data[31])) {
$employee->setNoticePeriod($data[31]);
}
if (strlen($data[32]) <= 50) {
$employee->setProject($data[32]);
}
if (strlen($data[33]) <= 50) {
$employee->setReferredBy($data[33]);
}
if (strlen($data[34]) <= 50) {
$employee->setCustom4($data[34]);
}
if (strlen($data[38]) <= 50) {
$employee->setCustom2($data[38]);
}
if (strlen($data[39]) <= 50) {
$employee->setCustom3($data[39]);
}
if (strlen($data[40]) <= 50) {
$employee->setCustom1($data[40]);
}
$employee = $empService->saveEmployee($employee);
if ($data[35] != "" && $data[36] != "") {
$employeeSalary = new EmployeeSalary();
$employeeSalary->setSalaryName("CTC");
$employeeSalary->setPayPeriodId("4");
$employeeSalary->setCurrencyCode($data[36]);
$employeeSalary->setAmount($data[35]);
$employeeSalary->setEmpNumber($employee);
$empDirectDebit = new EmpDirectdebit();
$empDirectDebit->setAccount($data[37]);
$empDirectDebit->setAccountType("SAVINGS");
$employeeSalary->setDirectDebit($empDirectDebit);
$empService->saveEmployeeSalary($employeeSalary);
}
if ($data[41] != "" && strlen($data[41]) <= 50) {
$empPassport = new EmployeeImmigrationRecord();
$empPassport->setEmployee($employee);
$empPassport->setNumber($data[41]);
$empPassport->setCountryCode($data[42]);
if ($data[43] != "") {
$expiryDate = $this->formatDate($data[43]);
$empPassport->setExpiryDate($expiryDate);
}
$empPassport->setType(1);
$empService->saveEmployeeImmigrationRecord($empPassport);
}
if ($data[44] != "" && strlen($data[44]) <= 50) {
$empVisaDetails = new EmployeeImmigrationRecord();
$empVisaDetails->setEmployee($employee);
$empVisaDetails->setNumber($data[44]);
if ($data[45] != "") {
$visaExpiryDate = $this->formatDate($data[45]);
$empVisaDetails->setExpiryDate($visaExpiryDate);
}
$empVisaDetails->setType(2);
$empService->saveEmployeeImmigrationRecord($empVisaDetails);
}
if ($data[46] != "" && $data[46] != '0' && strlen($data[46]) <= 50) {
$sequence1 = 1;
//$this->getDependentSeqNo($employee->getEmpNumber());
$dependent1 = $this->getEmployeeDependent($employee->getEmpNumber(), $sequence1);
$dependent1->setEmployee($employee);
$dependent1->setSeqno($sequence1);
$dependent1->setName($data[46]);
if ($data[47] != "") {
$dependent1->setDateOfBirth($this->formatDate($data[47]));
}
$dependent1->setRelationshipType($data[48]);
$dependent1->setRelationship($data[49]);
$dependent1->save();
}
if ($data[50] != "" && $data[50] != '0' && strlen($data[50]) <= 50) {
$sequence2 = 2;
//$this->getDependentSeqNo($employee->getEmpNumber());
$dependent2 = $this->getEmployeeDependent($employee->getEmpNumber(), $sequence2);
$dependent2->setEmployee($employee);
$dependent2->setSeqno($sequence2);
$dependent2->setName($data[50]);
if ($data[51] != "") {
$dependent2->setDateOfBirth($this->formatDate($data[51]));
}
$dependent2->setRelationshipType($data[52]);
$dependent2->setRelationship($data[53]);
$dependent2->save();
}
if ($data[54] != "" && $data[54] != '0' && strlen($data[54]) <= 50) {
$sequence3 = 3;
//$this->getDependentSeqNo($employee->getEmpNumber());
$dependent3 = $this->getEmployeeDependent($employee->getEmpNumber(), $sequence3);
$dependent3->setEmployee($employee);
$dependent3->setSeqno($sequence3);
$dependent3->setName($data[54]);
if ($data[55] != "") {
$dependent3->setDateOfBirth($this->formatDate($data[55]));
}
$dependent3->setRelationshipType($data[56]);
$dependent3->setRelationship($data[57]);
$dependent3->save();
}
if ($createUser && $data[58] != "" && $data[59] != "") {
$user = new SystemUser();
$user->setDateEntered(date('Y-m-d H:i:s'));
//$user->setCreatedBy($sfUser->getAttribute('user')->getUserId());
$user->setUserName($data[58]);
$user->setUserPassword(md5($data[59]));
$user->setEmployee($employee);
$user->setUserRoleId(2);
$this->getUserService()->saveSystemUser($user);
}
return true;
}
/**
* Test SaveEmployeePassport
*/
public function testSaveEmployeePassport()
{
$empPassport = new EmployeeImmigrationRecord();
$empPassport->setEmpNumber(1);
$employeeDao = $this->getMock('EmployeeDao');
$employeeDao->expects($this->once())->method('saveEmployeeImmigrationRecord')->with($empPassport)->will($this->returnValue($empPassport));
$this->employeeService->setEmployeeDao($employeeDao);
$result = $this->employeeService->saveEmployeeImmigrationRecord($empPassport);
$this->assertTrue($result === $empPassport);
}
