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;
}
/**
* 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);
}
//print_r($completeQuery);
//print_r($bindParams);
$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()) {
//print_r();
$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']);
$employee->setEmpHmTelephone($row['emp_hm_telephone']);
$employee->setEmpMobile($row['emp_mobile']);
$employee->setEmpWorkTelephone($row['emp_work_telephone']);
$employee->setEmpWorkEmail($row['emp_work_email']);
$employee->setEmpOthEmail($row['emp_oth_email']);
$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;
}
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;
}
