protected function setUp()
{
TestDataService::truncateSpecificTables(array('Employee', 'LeaveType'));
// 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->addEmployee($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)
{
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;
}
