Ejemplo n.º 1
0
 /**
  * Get employee list after sorting and filtering using given parameters.
  *
  * @param EmployeeSearchParameterHolder $parameterHolder
  */
 public function searchEmployees(EmployeeSearchParameterHolder $parameterHolder)
 {
     $sortField = $parameterHolder->getOrderField();
     $sortOrder = $parameterHolder->getOrderBy();
     $offset = $parameterHolder->getOffset();
     $limit = $parameterHolder->getLimit();
     $filters = $parameterHolder->getFilters();
     $returnType = $parameterHolder->getReturnType();
     $select = '';
     $query = '';
     $bindParams = array();
     $orderBy = '';
     $this->_getEmployeeListQuery($select, $query, $bindParams, $orderBy, $sortField, $sortOrder, $filters);
     $completeQuery = $select . ' ' . $query . ' ' . $orderBy;
     if (!is_null($offset) && !is_null($limit)) {
         $completeQuery .= ' LIMIT ' . $offset . ', ' . $limit;
     }
     if (sfConfig::get('sf_logging_enabled')) {
         $msg = $completeQuery;
         if (count($bindParams) > 0) {
             $msg .= ' (' . implode(',', $bindParams) . ')';
         }
         sfContext::getInstance()->getLogger()->info($msg);
     }
     $conn = Doctrine_Manager::connection();
     $statement = $conn->prepare($completeQuery);
     $result = $statement->execute($bindParams);
     if ($returnType == EmployeeSearchParameterHolder::RETURN_TYPE_OBJECT) {
         $employees = new Doctrine_Collection(Doctrine::getTable('Employee'));
         if ($result) {
             while ($row = $statement->fetch()) {
                 $employee = new Employee();
                 $employee->setEmpNumber($row['empNumber']);
                 $employee->setEmployeeId($row['employeeId']);
                 $employee->setFirstName($row['firstName']);
                 $employee->setMiddleName($row['middleName']);
                 $employee->setLastName($row['lastName']);
                 $employee->setTerminationId($row['terminationId']);
                 $jobTitle = new JobTitle();
                 $jobTitle->setId($row['jobTitleId']);
                 $jobTitle->setJobTitleName($row['jobTitle']);
                 $jobTitle->setIsDeleted($row['isDeleted']);
                 $employee->setJobTitle($jobTitle);
                 $employeeStatus = new EmploymentStatus();
                 $employeeStatus->setId($row['employeeStatusId']);
                 $employeeStatus->setName($row['employeeStatus']);
                 $employee->setEmployeeStatus($employeeStatus);
                 $workStation = new SubUnit();
                 $workStation->setName($row['subDivision']);
                 $workStation->setId($row['subDivisionId']);
                 $employee->setSubDivision($workStation);
                 $supervisorList = isset($row['supervisors']) ? $row['supervisors'] : '';
                 if (!empty($supervisorList)) {
                     $supervisors = new Doctrine_Collection(Doctrine::getTable('Employee'));
                     $supervisorArray = explode(',', $supervisorList);
                     foreach ($supervisorArray as $supervisor) {
                         list($first, $middle, $last) = explode('##', $supervisor);
                         $supervisor = new Employee();
                         $supervisor->setFirstName($first);
                         $supervisor->setMiddleName($middle);
                         $supervisor->setLastName($last);
                         $employee->supervisors[] = $supervisor;
                     }
                 }
                 $locationList = $row['locationIds'];
                 if (!empty($locationList)) {
                     //                    $locations = new Doctrine_Collection(Doctrine::getTable('EmpLocations'));
                     $locationArray = explode(',', $locationList);
                     foreach ($locationArray as $location) {
                         list($id, $name) = explode('##', $location);
                         $empLocation = new Location();
                         $empLocation->setId($id);
                         $empLocation->setName($name);
                         $employee->locations[] = $empLocation;
                     }
                 }
                 $employees[] = $employee;
             }
         }
     } else {
         return $statement->fetchAll();
     }
     return $employees;
 }
Ejemplo n.º 2
0
 public function import($data)
 {
     if ($data[0] == "" || $data[2] == "" || strlen($data[0]) > 30 || strlen($data[2]) > 30) {
         return false;
     }
     $employee = new Employee();
     $employee->setFirstName($data[0]);
     if (strlen($data[1]) <= 30) {
         $employee->setMiddleName($data[1]);
     }
     $employee->setLastName($data[2]);
     if (strlen($data[3]) <= 50) {
         $employee->setEmployeeId($data[3]);
     }
     if (strlen($data[4]) <= 30) {
         $employee->setOtherId($data[4]);
     }
     if (strlen($data[5]) <= 30) {
         $employee->setLicenseNo($data[5]);
     }
     if ($this->isValidDate($data[6])) {
         $employee->setEmpDriLiceExpDate($data[6]);
     }
     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 ($this->isValidDate($data[10])) {
         $employee->setEmpBirthday($data[10]);
     }
     if (strlen($data[11]) <= 70) {
         $employee->setStreet1($data[11]);
     }
     if (strlen($data[12]) <= 70) {
         $employee->setStreet2($data[12]);
     }
     if (strlen($data[13]) <= 70) {
         $employee->setCity($data[13]);
     }
     if (strlen($data[15]) <= 10) {
         $employee->setEmpZipcode($data[15]);
     }
     $code = $this->isValidCountry($data[16]);
     if (!empty($code)) {
         $employee->setCountry($code);
         if (strtolower($data[16]) == 'united states') {
             $code = $this->isValidProvince($data[14]);
             if (!empty($code)) {
                 $employee->setProvince($code);
             }
         } else {
             if (strlen($data[14]) <= 70) {
                 $employee->setProvince($data[14]);
             }
         }
     }
     if (strlen($data[17]) <= 25 && $this->isValidPhoneNumber($data[17])) {
         $employee->setEmpHmTelephone($data[17]);
     }
     if (strlen($data[18]) <= 25 && $this->isValidPhoneNumber($data[18])) {
         $employee->setEmpMobile($data[18]);
     }
     if (strlen($data[19]) <= 25 && $this->isValidPhoneNumber($data[19])) {
         $employee->setEmpWorkTelephone($data[19]);
     }
     if ($this->isValidEmail($data[20]) && strlen($data[20]) <= 50 && $this->isUniqueEmail($data[20])) {
         $employee->setEmpWorkEmail($data[20]);
     }
     if ($this->isValidEmail($data[21]) && strlen($data[21]) <= 50 && $this->isUniqueEmail($data[21])) {
         $employee->setEmpOthEmail($data[21]);
     }
     $empService = new EmployeeService();
     $empService->addEmployee($employee);
     return true;
 }
Ejemplo n.º 3
0
 /**
  * Testing savePersonalDetails
  */
 public function testSavePersonalDetails()
 {
     $empNumber = 121;
     $employee = new Employee();
     $employee->setLastName('Last Name');
     $employee->setFirstName('First Name');
     $employee->setMiddleName('M');
     $employee->setEmpNumber($empNumber);
     $employee->setNickName('AB');
     $employee->setOtherId('e2192');
     $isEss = true;
     $mockDao = $this->getMock('EmployeeDao');
     $mockDao->expects($this->once())->method('savePersonalDetails')->with($employee, $isEss)->will($this->returnValue(true));
     $this->employeeService->setEmployeeDao($mockDao);
     $result = $this->employeeService->savePersonalDetails($employee, $isEss);
     $this->assertTrue($result);
     $mockDao = $this->getMock('EmployeeDao');
     $mockDao->expects($this->once())->method('savePersonalDetails')->with($employee, $isEss)->will($this->throwException(new DaoException()));
     $this->employeeService->setEmployeeDao($mockDao);
     try {
         $result = $this->employeeService->savePersonalDetails($employee, $isEss);
         $this->fail("Exception expected");
     } catch (Exception $e) {
         $this->assertTrue($e instanceof PIMServiceException);
     }
 }
Ejemplo n.º 4
0
 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;
 }