public function testBulkAssignLeaveEntitlements() { $this->fixture = sfConfig::get('sf_plugins_dir') . '/orangehrmLeavePlugin/test/fixtures/LeaveEntitlement.yml'; TestDataService::populate($this->fixture); $dao = new LeaveEntitlementDao(); $limit = 5000; $empList = array(); $employeeService = new EmployeeService(); $employeeService->setEmployeeDao(new EmployeeDao()); for ($i = 0; $i < $limit; $i++) { $employee = new Employee(); $employee->setFirstName($i); $employee = $employeeService->saveEmployee($employee); array_push($empList, $employee->getEmpNumber()); } $start_time = microtime(true); $leaveEntitlement = new LeaveEntitlement(); $leaveEntitlement->setLeaveTypeId(1); $leaveEntitlement->setCreditedDate(date('Y-m-d')); $leaveEntitlement->setEntitlementType(LeaveEntitlement::ENTITLEMENT_TYPE_ADD); $leaveEntitlement->setDeleted(0); $leaveEntitlement->setNoOfDays(2); $leaveEntitlement->setFromDate('2012-01-01'); $leaveEntitlement->setToDate('2012-08-01'); $result = $dao->bulkAssignLeaveEntitlements($empList, $leaveEntitlement); $deference = microtime(true) - $start_time; $this->assertEquals(count($empList), $result, "Time Deference - " . $deference); echo "Add Entitlement 5000 Time " . $deference; }
public function execute($request) { $loggedInEmpNum = $this->getUser()->getEmployeeNumber(); $loggedInUserName = $_SESSION['fname']; $job = $request->getParameter('job'); $empNumber = isset($job['emp_number']) ? $job['emp_number'] : $request->getParameter('empNumber'); /* * TODO: $empNumber gets empty when uploaded file size exceeds PHP max upload size. * Check for a better solution. */ if (empty($empNumber)) { $this->getUser()->setFlash('templateMessage', array('warning', __(TopLevelMessages::FILE_SIZE_SAVE_FAILURE))); $this->redirect($request->getReferer()); } $this->empNumber = $empNumber; $this->jobInformationPermission = $this->getDataGroupPermissions('job_details', $empNumber); $this->ownRecords = $loggedInEmpNum == $empNumber ? true : false; if (!$this->IsActionAccessible($empNumber)) { $this->forward(sfConfig::get('sf_secure_module'), sfConfig::get('sf_secure_action')); } if ($this->getUser()->hasFlash('templateMessage')) { list($this->messageType, $this->message) = $this->getUser()->getFlash('templateMessage'); } $employee = $this->getEmployeeService()->getEmployee($empNumber); $param = array('empNumber' => $empNumber, 'ESS' => $this->essMode, 'employee' => $employee, 'loggedInUser' => $loggedInEmpNum, 'loggedInUserName' => $loggedInUserName); $this->form = new EmployeeJobDetailsForm(array(), $param, true); $this->employeeState = $employee->getState(); if ($loggedInEmpNum == $empNumber) { $this->allowActivate = FALSE; $this->allowTerminate = FALSE; } else { $allowedActions = $this->getContext()->getUserRoleManager()->getAllowedActions(WorkflowStateMachine::FLOW_EMPLOYEE, $this->employeeState); $this->allowActivate = in_array(WorkflowStateMachine::EMPLOYEE_ACTION_REACTIVE, $allowedActions); $this->allowTerminate = in_array(WorkflowStateMachine::EMPLOYEE_ACTION_TERMINATE, $allowedActions); } $paramForTerminationForm = array('empNumber' => $empNumber, 'employee' => $employee, 'allowTerminate' => $this->allowTerminate, 'allowActivate' => $this->allowActivate); $this->employeeTerminateForm = new EmployeeTerminateForm(array(), $paramForTerminationForm, true); if ($this->getRequest()->isMethod('post')) { // Handle the form submission $this->form->bind($request->getParameter($this->form->getName()), $request->getFiles($this->form->getName())); if ($this->form->isValid()) { // save data if ($this->jobInformationPermission->canUpdate()) { $service = new EmployeeService(); $service->saveEmployee($this->form->getEmployee(), false); } $this->form->updateAttachment(); $this->getUser()->setFlash('templateMessage', array('success', __(TopLevelMessages::UPDATE_SUCCESS))); } else { $validationMsg = ''; foreach ($this->form->getWidgetSchema()->getPositions() as $widgetName) { if ($this->form[$widgetName]->hasError()) { $validationMsg .= $this->form[$widgetName]->getError()->getMessageFormat(); } } $this->getUser()->setFlash('templateMessage', array('warning', $validationMsg)); } $this->redirect('pim/viewJobDetails?empNumber=' . $empNumber); } }
protected function setUp() { TestDataService::truncateSpecificTables(array('Employee', 'Leave', 'LeaveRequest', 'LeaveType', 'EmployeeLeaveEntitlement', 'LeavePeriod')); // Save leave type $leaveTypeData = sfYaml::load(sfConfig::get('sf_plugins_dir') . '/orangehrmCoreLeavePlugin/test/fixtures/leaveType.yml'); $leaveTypeDao = new LeaveTypeDao(); $leaveType = new LeaveType(); $leaveType->setLeaveTypeName($leaveTypeData['leaveType']['LT_001']['name']); // $leaveType->setLeaveRules($leaveTypeData['leaveType']['LT_001']['rule']); $leaveTypeDao->saveLeaveType($leaveType); $this->leaveType = $leaveType; $this->leaveTypeId = $leaveType->getLeaveTypeId(); // Save leave Period $leavePeriodData = sfYaml::load(sfConfig::get('sf_plugins_dir') . '/orangehrmCoreLeavePlugin/test/fixtures/leavePeriod.yml'); $leavePeriodService = new LeavePeriodService(); $leavePeriodService->setLeavePeriodDao(new LeavePeriodDao()); $leavePeriod = new LeavePeriod(); $leavePeriod->setStartDate($leavePeriodData['leavePeriod']['1']['startDate']); $leavePeriod->setEndDate($leavePeriodData['leavePeriod']['1']['endDate']); $leavePeriodService->saveLeavePeriod($leavePeriod); $this->leavePeriod = $leavePeriod; $this->leavePeriodId = $leavePeriod->getLeavePeriodId(); // Save Employee $employeeservice = new EmployeeService(); $this->employee = new Employee(); $employeeservice->saveEmployee($this->employee); $this->empNumber = $this->employee->getEmpNumber(); // save leave quota $this->leaveEntitlement = sfYaml::load(sfConfig::get('sf_plugins_dir') . '/orangehrmCoreLeavePlugin/test/fixtures/leaveEntitlement.yml'); $this->leaveEntitlementDao = new LeaveEntitlementDao(); }
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; }
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->saveEmployee($employee); return true; }