function parseData($postArr)
{
$dd = new EmpDirectDebit();
$dd->setEmpNumber($postArr['txtEmpID']);
$dd->setDDSeqNo($postArr['DDSeqNo']);
$dd->setRoutingNumber($postArr['DDRoutingNumber']);
$dd->setAccount($postArr['DDAccount']);
$dd->setAmount($postArr['DDAmount']);
$dd->setAccountType($postArr['DDAccountType']);
$dd->setTransactionType($postArr['cmbTransactionType']);
return $dd;
}
/**
* Sets up the fixture, for example, open a network connection.
* This method is called before a test is executed.
*
* @access protected
*/
protected function setUp()
{
$conf = new Conf();
$this->connection = mysql_connect($conf->dbhost . ":" . $conf->dbport, $conf->dbuser, $conf->dbpass);
mysql_select_db($conf->dbname);
$this->_truncateTables();
// insert some test data
$this->_runQuery("INSERT INTO hs_hr_custom_export(export_id, name, fields, headings) VALUES (1, 'Export 1', 'empId,lastName,firstName,middleName,street1,street2,city', '')");
$this->_runQuery("INSERT INTO hs_hr_custom_export(export_id, name, fields, headings) VALUES (2, 'Export 2', 'empId,lastName,firstName,city', 'Employee Id,Last Name,First Name,City')");
$this->_runQuery("INSERT INTO hs_hr_custom_export(export_id, name, fields, headings) VALUES (3, 'Export 3', 'empId,street1,street2,city', 'Employee Id,Address1, Address2, City')");
// insert some employee data
$sql = "INSERT INTO hs_hr_employee" . "(emp_number, employee_id, emp_lastname, emp_firstname, emp_middle_name, " . "emp_nick_name, emp_smoker, ethnic_race_code, emp_birthday, nation_code, " . "emp_gender, emp_marital_status, emp_ssn_num, emp_sin_num, emp_other_id, " . "emp_dri_lice_num, emp_dri_lice_exp_date, emp_military_service, emp_status, " . "job_title_code, eeo_cat_code, work_station, " . "emp_street1, emp_street2, city_code, coun_code, provin_code, emp_zipcode, " . "emp_hm_telephone, emp_mobile, emp_work_telephone, emp_work_email, " . "sal_grd_code, joined_date,\temp_oth_email, " . "custom1, custom2, custom3, custom4, custom5, " . "custom6, custom7, custom8, custom9, custom10) VALUES (" . "'10', 'E1921A', 'Karunadasa', 'Kamal', 'K', " . "NULL, NULL, NULL, '1974-11-20', NULL, " . "1, NULL, '987654320', '', '', " . "null, NULL, NULL, 'EST001', " . "NULL, NULL, NULL, " . "'111 Main Street', 'SUITE A29', 'Houston', 'US', 'TX', '77845', " . "'', '', '', NULL, " . "NULL, '1997-12-11', NULL, " . "'c1', 'c2', 'c3', 'c4', 'c5'," . "'c6', 'c7', 'c8', 'c9', 'c10'" . ")";
if (KeyHandlerOld::keyExists()) {
$key = KeyHandlerOld::readKey();
$sql = str_replace("'987654320'", "AES_ENCRYPT('987654320', '{$key}')", $sql);
}
$this->_runQuery($sql);
$sql = "INSERT into hs_hr_emp_us_tax(emp_number, tax_federal_status, tax_federal_exceptions, " . "tax_state, tax_state_status, tax_state_exceptions, tax_unemp_state,tax_work_state) VALUES (" . "10, 'NRA', 2, 'MD', 'NA', 3, 'VA', 'AZ')";
$this->_runQuery($sql);
// Add direct debit information
$dd = new EmpDirectDebit();
$dd->setEmpNumber(10);
$dd->setRoutingNumber(11111);
$dd->setAccount('AC 1');
$dd->setAmount(121);
$dd->setAccountType('CHECKING');
$dd->setTransactionType('BLANK');
$this->assertTrue($dd->add(), mysql_error());
$dd = new EmpDirectDebit();
$dd->setEmpNumber(10);
$dd->setRoutingNumber(22222);
$dd->setAccount('AC #2');
$dd->setAmount(23);
$dd->setAccountType('SAVINGS');
$dd->setTransactionType('FLATMINUS');
$this->assertTrue($dd->add(), mysql_error());
}
/**
* Get CSV row from data retrieved from the database
*
* @param array $row Data row from database
*/
private function _getCSVRow($row)
{
$genderValues = array(1 => "M", 2 => "F");
$empStatuses = array("EST000" => "T", "EST001" => "A", "EST002" => "T");
$payPeriods = array(1 => "W", 2 => "B", 3 => "S", 4 => "M", 5 => "M1");
$transactionTypes = array(EmpDirectDebit::TRANSACTION_TYPE_BLANK => 'Blank', EmpDirectDebit::TRANSACTION_TYPE_PERCENTAGE => '%', EmpDirectDebit::TRANSACTION_TYPE_FLAT => 'Flat', EmpDirectDebit::TRANSACTION_TYPE_FLAT_MINUS => 'Flat-');
$accountTypes = array(EmpDirectDebit::ACCOUNT_TYPE_CHECKING => "Y", EmpDirectDebit::ACCOUNT_TYPE_SAVINGS => "");
$id = $this->_escape($row['employee_id']);
// required
$lastName = $this->_escape($row['emp_lastname']);
// required
$firstName = $this->_escape($row['emp_firstname']);
// required
$middleName = $this->_escape($row['emp_middle_name']);
// optional
$address1 = $this->_escape($row['emp_street1']);
// optional
$address2 = $this->_escape($row['emp_street2']);
// optional
$city = $this->_escape($row['city_code']);
// optional
$state = $this->_escape($row['provin_code']);
// optional
$zip = $this->_escape($row['emp_zipcode']);
// required
$gender = $this->_escape($this->_getValueFromMap($genderValues, $row['emp_gender']));
// optional
$birthDate = $this->_escape($this->_convertDate($row['emp_birthday']));
// optional
$ssn = $this->_escape($row['emp_ssn_num']);
// required
$status = $this->_escape($this->_getValueFromMap($empStatuses, $row['emp_status']));
//required
$hireDate = $this->_escape($this->_convertDate($row['joined_date']));
//required
$cc1 = $this->_escape($row['title']);
//required (if set up in company)
$cc2 = $this->_escape($row['loc_name']);
//required (if set up in company)
$cc3 = $this->_escape($row['custom1']);
//required (if set up in company)
$cc4 = $this->_escape($row['custom2']);
//required (if set up in company)
$cc5 = $this->_escape($row['custom3']);
//required (if set up in company)
$taxForm = "";
//optional
$workState = $this->_escape($row['tax_work_state']);
//required
$empType = "";
//optional
$clockNumber = "";
//optional
$homePhone = "";
//optional
$ethnicity = "";
//optional
$baseRate = "";
//optional
$defaultHours = "";
//optional
$salary = $this->_escape($row['ebsal_basic_salary']);
// required (if salary and not hourly)
$payFrequency = $this->_escape($this->_getValueFromMap($payPeriods, $row['payperiod_code']));
// required
$autoPay = "";
//optional
$FITWStatus = $this->_escape($row['tax_federal_status']);
//required
$FITWExemptions = $this->_escape($row['tax_federal_exceptions']);
//required
$SITWState = $this->_escape($row['tax_state']);
//required
$SITWStatus = $this->_escape($row['tax_state_status']);
//required
$SITWExemptions = $this->_escape($row['tax_state_exceptions']);
//required
$SITWExemptions2 = "";
//optional
$SUIState = $this->_escape($row['tax_unemp_state']);
//required
$transit1 = "";
//required if defined
$DD1Account = "";
//required if defined
$DD1Amount = "";
//required if defined
$DD1AmountCode = "";
//required if defined
$DD1Checking = "";
//required if defined
$transit2 = "";
//required if defined
$DD2Account = "";
//required if defined
$DD2Amount = "";
//required if defined
$DD2AmountCode = "";
//required if defined
$DD2Checking = "";
//required if defined
// Get direct debit information
$dd = new EmpDirectDebit();
$ddList = $dd->getEmployeeDirectDebit($row['emp_number']);
if (count($ddList) > 0) {
$transit1 = $this->_escape($ddList[0]->getRoutingNumber());
$DD1Account = $this->_escape($ddList[0]->getAccount());
$DD1Amount = $this->_escape($ddList[0]->getAmount());
$DD1AmountCode = $this->_escape($this->_getValueFromMap($transactionTypes, $ddList[0]->getTransactionType()));
$DD1Checking = $this->_escape($this->_getValueFromMap($accountTypes, $ddList[0]->getAccountType()));
}
if (count($ddList) > 1) {
$transit2 = $this->_escape($ddList[1]->getRoutingNumber());
$DD2Account = $this->_escape($ddList[1]->getAccount());
$DD2Amount = $this->_escape($ddList[1]->getAmount());
$DD2AmountCode = $this->_escape($this->_getValueFromMap($transactionTypes, $ddList[1]->getTransactionType()));
$DD2Checking = $this->_escape($this->_getValueFromMap($accountTypes, $ddList[1]->getAccountType()));
}
$csvRow = "{$id},{$lastName},{$firstName},{$middleName},{$address1},{$address2},{$city},{$state},{$zip},{$gender},{$birthDate}," . "{$ssn},{$status},{$hireDate},{$cc1},{$cc2},{$cc3},{$cc4},{$cc5},{$taxForm},{$workState},{$empType},{$clockNumber}," . "{$homePhone},{$ethnicity},{$baseRate},{$defaultHours},{$salary},{$payFrequency},{$autoPay}," . "{$FITWStatus},{$FITWExemptions},{$SITWState},{$SITWStatus},{$SITWExemptions},{$SITWExemptions2}," . "{$SUIState},{$transit1},{$DD1Account},{$DD1Amount},{$DD1AmountCode},{$DD1Checking},{$transit2}," . "{$DD2Account},{$DD2Amount},{$DD2AmountCode},{$DD2Checking}";
return $csvRow;
}
function reDirect($getArr, $postArr, $object = null)
{
$form_creator = new FormCreator($getArr, $postArr);
switch ($getArr['reqcode']) {
case 'JSP':
$form_creator->formPath = '/templates/hrfunct/hrempjobspec.php';
$ejobsp = new EmpJobSpec();
$empinfo = new EmpInfo();
$jdcat = new JDCategory();
$form_creator->popArr['empdet'] = $empinfo->filterEmpMain($getArr['id']);
$form_creator->popArr['catlist'] = $jdcat->getJDCatCodes();
if (isset($getArr['editID'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID'];
$form_creator->popArr['editArr'] = $ejobsp->filterEmpJobSpec($arr);
} else {
$form_creator->popArr['unasscatlist'] = $jdcat->getUnAssJDCatCodes($getArr['id']);
}
$form_creator->popArr['rset'] = $ejobsp->getAssEmpJobSpec($getArr['id']);
//$form_creator ->popArr['catlist']=$ejobsp->getJDCatCodes();
break;
case 'CXT':
$form_creator->formPath = '/templates/hrfunct/hrempconext.php';
$empconext = new EmpConExt();
$empinfo = new EmpInfo();
$form_creator->popArr['empdet'] = $empinfo->filterEmpMain($getArr['id']);
$form_creator->popArr['empstat'] = $empinfo->filterEmpJobStat($getArr['id']);
if (isset($getArr['editID'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID'];
$form_creator->popArr['editArr'] = $empconext->filterConExt($arr);
$form_creator->popArr['lastrec'] = $empconext->getLastRecord($getArr['id']);
} else {
$form_creator->popArr['lastrec'] = $empconext->getLastRecord($getArr['id']);
}
$form_creator->popArr['rset'] = $empconext->getAssConExt($getArr['id']);
break;
case 'SAL':
$form_creator->formPath = '/templates/hrfunct/hrempbassal.php';
$empinfo = new EmpInfo();
$empbassal = new EmpBasSalary();
$currTyp = new CurrencyTypes();
$form_creator->popArr['einfo'] = $empinfo->filterEmpMain($getArr['id']);
$form_creator->popArr['empdet'] = $empdet = $empinfo->filterEmpJobInfo($getArr['id']);
$salGrd = $empdet[0][5];
if (isset($getArr['editID1'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID1'];
$arr[2] = $getArr['editID2'];
$form_creator->popArr['editArr'] = $edit = $empbassal->filterEmpBasSal($arr);
$form_creator->popArr['currlist'] = $empbassal->getCurrCodes($edit[0][1]);
} else {
$form_creator->popArr['curlist'] = $empbassal->getUnAssCurrCodes($salGrd, $getArr['id']);
if ($object != null) {
$form_creator->popArr['cmbCurrCode'] = $object->cmbCurrCode;
}
}
$form_creator->popArr['rset'] = $empbassal->getAssEmpBasSal($getArr['id']);
$form_creator->popArr['currAlllist'] = $currTyp->getAllCurrencyCodes();
break;
case 'LAN':
$form_creator->formPath = '/templates/hrfunct/hremplan.php';
$empinf = new EmpInfo();
$emplan = new EmpLanguage();
$laninfo = new LanguageInfo();
$form_creator->popArr['empDet'] = $empinf->filterEmpMain($getArr['id']);
$form_creator->popArr['lanlist'] = $lanlist = $laninfo->getLang();
if (isset($getArr['editID1'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID1'];
$arr[2] = $getArr['editID2'];
$form_creator->popArr['editArr'] = $emplan->filterEmpLang($arr);
for ($c = 0; count($lanlist) > $c; $c++) {
if ($getArr['editID1'] == $lanlist[$c][0]) {
$ratSel = $lanlist[$c][2];
}
}
} else {
if ($object != null) {
$form_creator->popArr['cmbLanCode'] = $object->cmbLanCode;
for ($c = 0; $lanlist && count($lanlist) > $c; $c++) {
if ($lanlist[$c][0] == $object->cmbLanCode) {
$ratSel = $lanlist[$c][2];
}
}
$form_creator->popArr['ratSel'] = $ratSel;
}
$form_creator->popArr['lanlist'] = $laninfo->getLang();
}
$form_creator->popArr['rsets'] = $emplan->getAssEmpLang($getArr['id']);
break;
case 'MEM':
$form_creator->formPath = '/templates/hrfunct/hrempmemship.php';
$empinf = new EmpInfo();
$empmem = new EmpMembership();
$memtype = new MembershipType();
$memshipinfo = new MembershipInfo();
$form_creator->popArr['empDet'] = $empinf->filterEmpMain($getArr['id']);
$form_creator->popArr['typlist'] = $typlist = $memtype->getMembershipTypeCodes();
if (isset($getArr['editID1'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID1'];
$arr[2] = $getArr['editID2'];
$form_creator->popArr['editArr'] = $edit = $empmem->filterEmpMembership($arr);
$form_creator->popArr['mship'] = $memshipinfo->getMembershipCodes($edit[0][2]);
} else {
if ($object != null) {
$form_creator->popArr['cmbMemTypeCode'] = $object->cmbMemTypeCode;
$form_creator->popArr['mship'] = $memshipinfo->getUnAssMembershipCodes($getArr['id'], $object->cmbMemTypeCode);
}
$form_creator->popArr['typlist'] = $typlist = $memtype->getMembershipTypeCodes();
}
$form_creator->popArr['rset'] = $empmem->getAssEmpMembership($getArr['id']);
$form_creator->popArr['mshipAll'] = $memshipinfo->getAllMembershipCodes();
break;
case 'EXC':
$form_creator->formPath = '/templates/hrfunct/hrempextcur.php';
$empinfo = new EmpInfo();
$empextcur = new EmpExCur();
$extracurr = new ExtraCurrActCat();
$extrainfo = new ExtraCurActInfo();
$form_creator->popArr['empdet'] = $empinfo->filterEmpMain($getArr['id']);
$form_creator->popArr['catlist'] = $extracurr->getExCurCatCodes();
if (isset($getArr['editID'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID'];
$form_creator->popArr['editArr'] = $edit = $empextcur->filterEmpExCur($arr);
$form_creator->popArr['typelist'] = $extrainfo->getExCurTypeCodes($edit[0][2]);
} else {
$form_creator->popArr['lastrec'] = $empextcur->getLastRecord($getArr['id']);
if ($object != null) {
$form_creator->popArr['cmbExtCurCat'] = $catcode = $object->cmbExtCurCat;
$form_creator->popArr['typeunasslist'] = $extrainfo->getUnAssExCurTypeCodes($getArr['id'], $catcode);
}
}
$form_creator->popArr['rset'] = $empextcur->getAssExCur($getArr['id']);
$form_creator->popArr['allcatlist'] = $extracurr->getExCurCatCodes();
$form_creator->popArr['alltypelist'] = $extrainfo->getAllExtraCurActInfo();
break;
case 'EXP':
$form_creator->formPath = '/templates/hrfunct/hrempwrkexp.php';
$empinfo = new EmpInfo();
$empworkex = new EmpWorkExp();
$countryinfo = new CountryInfo();
$proinfo = new ProvinceInfo();
$form_creator->popArr['empDet'] = $empinfo->filterEmpMain($getArr['id']);
if ($object != null) {
$form_creator->popArr['txtEmpExpCompany'] = $object->txtEmpExpCompany;
$form_creator->popArr['txtEmpExpToDat'] = $object->txtEmpExpToDat;
$form_creator->popArr['txtEmpExpDesOnLev'] = $object->txtEmpExpDesOnLev;
$form_creator->popArr['txtEmpExpYears'] = $object->txtEmpExpYears;
$form_creator->popArr['chkEmpExpWorkRelFlag'] = $object->chkEmpExpWorkRelFlag;
$form_creator->popArr['txtEmpExpMonths'] = $object->txtEmpExpMonths;
$form_creator->popArr['txtEmpExpAdd1'] = $object->txtEmpExpAdd1;
$form_creator->popArr['txtEmpExpAcc'] = $object->txtEmpExpAcc;
$form_creator->popArr['txtEmpExpAdd2'] = $object->txtEmpExpAdd2;
}
if (isset($getArr['editID'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID'];
$form_creator->popArr['editArr'] = $edit = $empworkex->filterEmpWorkExp($arr);
$form_creator->popArr['list'] = $countryinfo->getCountryCodes();
if ($object != null) {
$form_creator->popArr['txtEmpExpAdd2'] = $pli = $object->txtEmpExpAdd2;
$form_creator->popArr['txtEmpExpConPers'] = $object->txtEmpExpConPers;
$form_creator->popArr['txtEmpExpAdd3'] = $object->txtEmpExpAdd3;
$form_creator->popArr['txtEmpExpTelep'] = $object->txtEmpExpTelep;
$form_creator->popArr['txtEmpResLev'] = $object->txtEmpResLev;
$form_creator->popArr['txtEmpExpAchmnt'] = $object->txtEmpExpAchmnt;
$form_creator->popArr['txtEmpExpFromDat'] = $object->txtEmpExpFromDat;
$form_creator->popArr['txtEmpExpEmail'] = $object->txtEmpExpEmail;
$form_creator->popArr['plist'] = $empinfo->getProvinceCodes($pli);
} else {
$form_creator->popArr['plist1'] = $proinfo->getProvinceCodes($edit[0][4]);
}
} else {
$form_creator->popArr['newID'] = $empworkex->getLastRecord($getArr['id']);
$form_creator->popArr['list'] = $countryinfo->getCountryCodes();
if ($object != null) {
$form_creator->popArr['txtEmpExpCompany'] = $object->txtEmpExpCompany;
$form_creator->popArr['txtEmpExpToDat'] = $object->txtEmpExpToDat;
$form_creator->popArr['txtEmpExpDesOnLev'] = $object->txtEmpExpDesOnLev;
$form_creator->popArr['txtEmpExpYears'] = $object->txtEmpExpYears;
$form_creator->popArr['chkEmpExpWorkRelFlag'] = $object->chkEmpExpWorkRelFlag;
$form_creator->popArr['txtEmpExpMonths'] = $object->txtEmpExpMonths;
$form_creator->popArr['txtEmpExpAdd1'] = $object->txtEmpExpAdd1;
$form_creator->popArr['txtEmpExpAcc'] = $object->txtEmpExpAcc;
$form_creator->popArr['txtEmpExpTelep'] = $object->txtEmpExpTelep;
$form_creator->popArr['txtEmpResLev'] = $object->txtEmpResLev;
$form_creator->popArr['txtEmpExpAchmnt'] = $object->txtEmpExpAchmnt;
$form_creator->popArr['txtEmpExpFromDat'] = $object->txtEmpExpFromDat;
$form_creator->popArr['txtEmpExpEmail'] = $object->txtEmpExpEmail;
$form_creator->popArr['txtEmpExpAdd2'] = $plis = $object->txtEmpExpAdd2;
$form_creator->popArr['txtEmpExpAdd3'] = $object->txtEmpExpAdd3;
$form_creator->popArr['txtEmpExpConPers'] = $object->txtEmpExpConPers;
$form_creator->popArr['plist2'] = $empinfo->getProvinceCodes($plis);
}
}
$form_creator->popArr['rset'] = $empworkex->getAssEmpWorkExp($getArr['id']);
break;
case 'QUA':
$form_creator->formPath = '/templates/hrfunct/hrempqual.php';
$empinfo = new EmpInfo();
$empqual = new EmpQualification();
$qualtyp = new QualificationType();
$qual = new Qualifications();
$form_creator->popArr['statlist'] = array('First Class', 'Second Class Upr.', 'Second Class Lwr.');
$form_creator->popArr['empdet'] = $empinfo->filterEmpMain($getArr['id']);
$form_creator->popArr['typlist'] = $qualtyp->getQualificationTypeCodes();
if (isset($getArr['editID'])) {
$arr[0] = $getArr['editID'];
$arr[1] = $getArr['id'];
$form_creator->popArr['editArr'] = $empqual->filterEmpQual($arr);
$form_creator->popArr['quallist'] = $qual->getAllQualifications();
} else {
if ($object != null) {
$form_creator->popArr['TypeCode'] = $object->TypeCode;
$form_creator->popArr['mship'] = $qual->getUnAssQualifications($getArr['id'], $object->TypeCode);
}
}
$form_creator->popArr['rset'] = $empqual->getAssEmpQual($getArr['id']);
$form_creator->popArr['allquallist'] = $qual->getAllQualifications();
break;
case 'QAS':
$form_creator->formPath = '/templates/hrfunct/hrempqualsub.php';
$empinfo = new EmpInfo();
$qual = new Qualifications();
$empqualsub = new EmpQualSubject();
$subinfo = new SubjectInfo();
$form_creator->popArr['empdet'] = $empinfo->filterEmpMain($getArr['id']);
$form_creator->popArr['qualDet'] = $qual->filterQualifications($getArr['QUA']);
$form_creator->popArr['sublistAll'] = $subinfo->getSubjectCodes($getArr['QUA']);
$form_creator->popArr['ratlist'] = $empqualsub->getRatGrds($getArr['QUA']);
if (isset($getArr['editID'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['QUA'];
$arr[2] = $getArr['editID'];
$form_creator->popArr['editArr'] = $empqualsub->filterEmpQualSub($arr);
} else {
$form_creator->popArr['sublistUnAss'] = $subinfo->getUnAssSubjects($getArr['id'], $getArr['QUA']);
}
$arr[0] = $getArr['id'];
$arr[1] = $getArr['QUA'];
$form_creator->popArr['sublistAss'] = $empqualsub->getAssEmpQualSub($arr);
break;
case 'CBN':
$form_creator->formPath = '/templates/hrfunct/hrempcashben.php';
$empinfo = new EmpInfo();
$empcashben = new EmpCashBen();
$cashben = new CashBen();
$form_creator->popArr['empdet'] = $empinfo->filterEmpMain($getArr['id']);
$form_creator->popArr['bfilter'] = array('Salary Point' => 1, 'Designation' => 2, 'Employee' => 3);
$form_creator->popArr['benlist'] = $cashben->getBenCodes();
if (isset($getArr['editID'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID'];
$form_creator->popArr['editArr'] = $empcashben->filterEmpCashBen($arr);
}
$form_creator->popArr['cashbenAss'] = $empcashben->getAssEmpCashBen($getArr['id']);
$form_creator->popArr['cashbenUnAss'] = $empcashben->getUnAssEmpCashBen($getArr['id']);
if (isset($getArr['OBEN'])) {
$form_creator->popArr['cashbenOther'] = $cashben->getOthEmpCashBen($getArr['id']);
}
break;
case 'NBN':
$form_creator->formPath = '/templates/hrfunct/hrempnoncashben.php';
$empinfo = new EmpInfo();
$empnoncashben = new EmpNonCashBen();
$noncashben = new NonCashBen();
$form_creator->popArr['empdet'] = $empinfo->filterEmpMain($getArr['id']);
$form_creator->popArr['bfilter'] = array('Salary Point' => 1, 'Designation' => 2, 'Employee' => 3);
$form_creator->popArr['benlist'] = $noncashben->getBenCodes();
if (isset($getArr['editID'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID'];
$form_creator->popArr['editArr'] = $empnoncashben->filterEmpNonCashBen($arr);
}
$form_creator->popArr['cashbenAss'] = $empnoncashben->getAssEmpNonCashBen($getArr['id']);
$form_creator->popArr['cashbenUnAss'] = $empnoncashben->getUnAssEmpNonCashBen($getArr['id']);
if (isset($getArr['OBEN'])) {
$form_creator->popArr['cashbenOther'] = $noncashben->getOthEmpNonCashBen($getArr['id']);
}
break;
case 'ESS':
case 'EMP':
$form_creator->formPath = '/templates/hrfunct/hrEmpMain.php';
//hremp.php';
$form_creator->popArr['arrMStat'] = array('Unmarried', 'Married', 'Divorced', 'Others');
$empinfo = new EmpInfo();
$pport = new EmpPassPort();
$ddebit = new EmpDirectDebit();
$dep = new EmpDependents();
$econ = new EmpEmergencyCon();
$chi = new EmpChildren();
$attachment = new EmpAttach();
$countryinfo = new CountryInfo();
$porinfo = new ProvinceInfo();
$nationinfo = new NationalityInfo();
$location = new models_eimadmin_Location();
$distric = new DistrictInfo();
$jobtit = new JobTitle();
$depen = new EmpDependents();
$ethnicrace = new EthnicRace();
$eeojobcat = new EEOJobCat();
$emplan = new EmpLanguage();
$laninfo = new LanguageInfo();
$emplicen = new EmpLicenses();
$licen = new Licenses();
$empmem = new EmpMembership();
$memtype = new MembershipType();
$memshipinfo = new MembershipInfo();
$emprepto = new EmpRepTo();
$empskill = new EmpSkill();
$skill = new Skills();
$empworkex = new EmpWorkExp();
$empeducation = new EmpEducation();
$education = new Education();
$empTax = new EmpTax();
$form_creator->popArr['nation'] = $nationinfo->getNationCodes();
$form_creator->popArr['loc'] = $location->getLocCodes();
$form_creator->popArr['cntlist'] = $countryinfo->getCountryCodes();
$form_creator->popArr['ethRace'] = $ethnicrace->getEthnicRaceCodes();
$form_creator->popArr['eeojobcat'] = $eeojobcat->getEEOJobCatCodes();
$form_creator->popArr['jobtit'] = $jobtit->getJobTit();
$form_creator->popArr['hier'] = isset($res) ? $res : false;
$form_creator->popArr['cntlist'] = $countrylist = $countryinfo->getCountryCodes();
$form_creator->popArr['ppcntlist'] = $countrylist;
$form_creator->popArr['customFieldList'] = CustomFields::getCustomFieldList();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $empinfo->getLastId();
if ($object != null) {
$form_creator->popArr['ctlist'] = $corptit->getCorpTitlesEmpInfo($object->cmbSalGrd);
$form_creator->popArr['deslist'] = $des->getDesEmpInfo($object->cmbCorpTit);
$form_creator->popArr['plist'] = $porinfo->getProvinceCodes($object->cmbTaxCountry);
$form_creator->popArr['resplist'] = $porinfo->getProvinceCodes($object->cmbPermCountry);
$form_creator->popArr['resdlist'] = $distric->getDistrictCodes($object->cmbPermProvince);
if (isset($postArr['cmbJobTitle'])) {
$form_creator->popArr['empstatlist'] = $view_controller->xajaxObjCall($postArr['cmbJobTitle'], 'JOB', 'allEmpStat');
}
$form_creator->popArr['ethRace'] = $ethnicrace->getEthnicRaceCodes($object->cmbEthnicRace);
}
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editTaxInfo'] = $empTax->getEmployeeTaxInfo($getArr['id']);
$form_creator->popArr['usStateList'] = $porinfo->getProvinceCodes('US');
$form_creator->popArr['empDDAss'] = $ddebit->getEmployeeDirectDebit($getArr['id']);
if (isset($getArr['DDSEQ'])) {
$form_creator->popArr['editDDForm'] = $ddebit->getDirectDebit($getArr['id'], $getArr['DDSEQ']);
}
$form_creator->popArr['editMainArr'] = $empinfo->filterEmpMain($getArr['id']);
$form_creator->popArr['editPersArr'] = $empinfo->filterEmpPers($getArr['id']);
$form_creator->popArr['editJobInfoArr'] = $empJobInfo = $empinfo->filterEmpJobInfo($getArr['id']);
$form_creator->popArr['editCustomInfoArr'] = $empCustomInfo = $empinfo->filterEmpCustomInfo($getArr['id']);
$view_controller = new ViewController();
$form_creator->popArr['empstatlist'] = $view_controller->xajaxObjCall($empJobInfo[0][2], 'JOB', 'allEmpStat');
$empJobTitle = $empJobInfo[0][2];
if (isset($postArr['cmbJobTitle'])) {
$form_creator->popArr['empstatlist'] = $view_controller->xajaxObjCall($postArr['cmbJobTitle'], 'JOB', 'allEmpStat');
$empJobTitle = $postArr['cmbJobTitle'];
}
if (CommonFunctions::isValidId($empJobTitle, 'JOB')) {
$empJobSpec = $view_controller->getJobSpecForJob($empJobTitle);
} else {
$empJobSpec = null;
}
$form_creator->popArr['jobSpec'] = $empJobSpec;
$jobTitleHistory = new JobTitleHistory();
$form_creator->popArr['jobTitleHistory'] = $jobTitleHistory->getHistory($getArr['id']);
$empDivisionHistory = new SubDivisionHistory();
$form_creator->popArr['subDivisionHistory'] = $empDivisionHistory->getHistory($getArr['id']);
$locationHistory = new LocationHistory();
$form_creator->popArr['locationHistory'] = $locationHistory->getHistory($getArr['id']);
$form_creator->popArr['assignedlocationList'] = EmpLocation::getEmpLocations($getArr['id']);
$form_creator->popArr['availablelocationList'] = EmpLocation::getUnassignedLocations($getArr['id']);
$form_creator->popArr['editPermResArr'] = $edit = $editPermRes = $empinfo->filterEmpContact($getArr['id']);
$form_creator->popArr['provlist'] = $porinfo->getProvinceCodes($edit[0][4]);
$form_creator->popArr['citylist'] = $distric->getDistrictCodes($edit[0][5]);
$form_creator->popArr['empPPAss'] = $pport->getAssEmpPP($getArr['id']);
$form_creator->popArr['empDepAss'] = $dep->getAssEmpDep($getArr['id']);
$form_creator->popArr['empECAss'] = $econ->getAssEmpEC($getArr['id']);
$form_creator->popArr['empChiAss'] = $chi->getAssEmpChi($getArr['id']);
$form_creator->popArr['empAttAss'] = $attachment->getAssEmpAtt($getArr['id']);
$form_creator->popArr['empDpAss'] = $depen->getAssEmpDep($getArr['id']);
$form_creator->popArr['newPPID'] = $pport->getLastRecord($getArr['id']);
if (isset($getArr['PPSEQ'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['PPSEQ'];
$form_creator->popArr['editPPForm'] = $pport->filterEmpPP($arr);
}
$form_creator->popArr['newECID'] = $econ->getLastRecord($getArr['id']);
if (isset($getArr['ECSEQ'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['ECSEQ'];
$form_creator->popArr['editECForm'] = $econ->filterEmpEC($arr);
}
$form_creator->popArr['newDepID'] = $dep->getLastRecord($getArr['id']);
if (isset($getArr['depSEQ'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['depSEQ'];
$form_creator->popArr['editDepForm'] = $dep->filterEmpDep($arr);
}
$form_creator->popArr['newCID'] = $chi->getLastRecord($getArr['id']);
if (isset($getArr['CHSEQ'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['CHSEQ'];
$form_creator->popArr['editChiForm'] = $chi->filterEmpChi($arr);
}
if (isset($getArr['ATTACH'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['ATTACH'];
$form_creator->popArr['editAttForm'] = $attachment->filterEmpAtt($arr);
}
$form_creator->popArr['lantype'] = array('Writing' => 1, 'Speaking' => 2, 'Reading' => 3);
$form_creator->popArr['grdcodes'] = array('Poor' => 1, 'Basic' => 2, 'Good' => 3, 'Mother Tongue' => 4);
$form_creator->popArr['lanlist'] = $lanlist = $laninfo->getLang();
if (isset($getArr['lanSEQ'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['lanSEQ'];
$arr[2] = $getArr['lanFLU'];
$form_creator->popArr['editLanArr'] = $emplan->filterEmpLang($arr);
}
$form_creator->popArr['rsetLang'] = $emplan->getAssEmpLang($getArr['id']);
$form_creator->popArr['allLicenlist'] = $licenlist = $licen->getLicensesCodes();
$form_creator->popArr['unassLicenlist'] = $licen->getUnAssLicensesCodes($getArr['id']);
if (isset($getArr['LIC'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['LIC'];
$form_creator->popArr['editLicenseArr'] = $emplicen->filterEmpLicenses($arr);
}
$form_creator->popArr['rsetLicense'] = $emplicen->getAssEmpLicenses($getArr['id']);
$form_creator->popArr['typlist'] = $typlist = $memtype->getMembershipTypeCodes();
if (isset($getArr['MEM'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['MEM'];
$arr[2] = $getArr['MTP'];
$form_creator->popArr['editMembershipArr'] = $edit = $empmem->filterEmpMembership($arr);
$form_creator->popArr['mship'] = $memshipinfo->getMembershipCodes($edit[0][2]);
}
$form_creator->popArr['rsetMembership'] = $empmem->getAssEmpMembership($getArr['id']);
$form_creator->popArr['mshipAll'] = $memshipinfo->getAllMembershipCodes();
$empbassal = new EmpBasSalary();
$currTyp = new CurrencyTypes();
$jobtit = new JobTitle();
$salgradelist = new SalaryGrades();
$form_creator->popArr['salgradelist'] = $salgradelist->getSalGrades(true);
$empdet = $empinfo->filterEmpJobInfo($getArr['id']);
$jt = $jobtit->filterJobTitles($empdet[0][2]);
$form_creator->popArr['payPeriodList'] = PayPeriod::getPayPeriodList();
$form_creator->popArr['salGrd'] = $salGrd = $empbassal->getEmpSalGrade($getArr['id']);
if (isset($getArr['PAY'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['PAY'];
$arr[2] = $getArr['CUR'];
$form_creator->popArr['editPaymentArr'] = $edit = $empbassal->filterEmpBasSal($arr);
$form_creator->popArr['salGrd'] = $salGrd = $edit[0][1];
$form_creator->popArr['currlist'] = $empbassal->getCurrCodes($edit[0][1]);
}
$form_creator->popArr['unAssCurrList'] = $empbassal->getUnAssCurrCodes($salGrd, $getArr['id']);
$form_creator->popArr['rsetPayment'] = $empbassal->getAssEmpBasSal($getArr['id']);
$form_creator->popArr['currAlllist'] = $currTyp->getAllCurrencyCodes();
$form_creator->popArr['suprset'] = $emprepto->getEmpSup($getArr['id']);
$form_creator->popArr['empname'] = $empinfo->getEmpInfo();
$form_creator->popArr['subrset'] = $emprepto->getEmpSub($getArr['id']);
if (isset($getArr['editIDSup'])) {
$arr[0] = $getArr['editIDSup'];
$arr[1] = $getArr['id'];
$arr[2] = $getArr['RepMethod'];
$form_creator->popArr['editIDSupInfo'] = $emprepto->filterEmpRepTo($arr);
}
if (isset($getArr['editIDSub'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editIDSub'];
$arr[2] = $getArr['RepMethod'];
$form_creator->popArr['editIDSubInfo'] = $emprepto->filterEmpRepTo($arr);
}
$form_creator->popArr['allSkilllist'] = $skill->getSkillCodes();
$form_creator->popArr['uskilllist'] = $skill->getUnAssSkillCodes($getArr['id']);
if (isset($getArr['SKILL'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['SKILL'];
$form_creator->popArr['editSkillArr'] = $empskill->filterEmpSkill($arr);
}
$form_creator->popArr['rsetSkill'] = $empskill->getAssEmpSkill($getArr['id']);
$form_creator->popArr['newWrkExpID'] = $empworkex->getLastRecord($getArr['id']);
if (isset($getArr['WRKEXP'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['WRKEXP'];
$form_creator->popArr['editWrkExpArr'] = $edit = $empworkex->filterEmpWorkExp($arr);
}
$form_creator->popArr['rsetWrkExp'] = $empworkex->getAssEmpWorkExp($getArr['id']);
$form_creator->popArr['allEduCodes'] = $education->getListofEducation(0, '', 0);
$form_creator->popArr['unAssEduCodes'] = $empeducation->getUnAssEduCodes($getArr['id']);
if (isset($getArr['EDU'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['EDU'];
$form_creator->popArr['editEducationArr'] = $empeducation->filterEmpEducation($arr);
}
$form_creator->popArr['rsetEducation'] = $empeducation->getAssEmpEducation($getArr['id']);
if ($object != null) {
$form_creator->popArr['ctlist'] = $corptit->getCorpTitlesEmpInfo($object->cmbSalGrd);
$form_creator->popArr['deslist'] = $des->getDesEmpInfo($object->cmbCorpTit);
$form_creator->popArr['resplist'] = $porinfo->getProvinceCodes($object->cmbPermCountry);
$form_creator->popArr['resdlist'] = $distric->getDistrictCodes($object->cmbPermProvince);
$form_creator->popArr['brchlist'] = $brch->getUnAssBranchCodes($getArr['id'], $object->cmbBank);
$form_creator->popArr['ctlist'] = $empinfo->getCorpTitles($object->cmbSalGrd);
$form_creator->popArr['deslist'] = $empinfo->getDes($object->cmbCorpTit);
$form_creator->popArr['resplist'] = $empinfo->getProvinceCodes($object->cmbPermCountry);
$form_creator->popArr['resdlist'] = $empinfo->getDistrictCodes($object->cmbPermProvince);
$form_creator->popArr['brchlist'] = $brch->getUnAssBranchCodes($getArr['id'], $object->cmbBank);
} else {
$form_creator->popArr['resplist'] = $porinfo->getProvinceCodes($editPermRes[0][10]);
$form_creator->popArr['resdlist'] = $distric->getDistrictCodes($editPermRes[0][11]);
}
$empconext = new EmpConExt();
$form_creator->popArr['newConExtID'] = $empconext->getLastRecord($getArr['id']);
if (isset($getArr['CONEXT'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['CONEXT'];
$form_creator->popArr['editConExtArr'] = $empconext->filterConExt($arr);
}
$form_creator->popArr['rsetConExt'] = $empconext->getAssConExt($getArr['id']);
}
break;
case 'REP':
$form_creator->formPath = '/templates/hrfunct/hremprepto.php';
$empinfo = new EmpInfo();
$emprepto = new EmpRepTo();
$form_creator->popArr['empdet'] = $empinfo->filterEmpMain($getArr['id']);
$form_creator->popArr['suprset'] = $emprepto->getEmpSup($getArr['id']);
$form_creator->popArr['empname'] = $empinfo->getEmpInfo();
$form_creator->popArr['subrset'] = $emprepto->getEmpSub($getArr['id']);
if (isset($getArr['editIDSup'])) {
$arr[0] = $getArr['editIDSup'];
$arr[1] = $getArr['id'];
$arr[2] = $getArr['repmethod'];
$form_creator->popArr['editIDSupInfo'] = $emprepto->filterEmpRepTo($arr);
}
if (isset($getArr['editIDSub'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editIDSub'];
$arr[2] = $getArr['repmethod'];
$form_creator->popArr['editIDSubInfo'] = $emprepto->filterEmpRepTo($arr);
}
break;
case 'SKI':
$form_creator->formPath = '/templates/hrfunct/hrempskill.php';
$empinf = new EmpInfo();
$empskill = new EmpSkill();
$skill = new Skills();
$form_creator->popArr['empDet'] = $empinf->filterEmpMain($getArr['id']);
$form_creator->popArr['allSkilllist'] = $skill->getSkillCodes();
if (isset($getArr['editID1'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID1'];
$arr[2] = $getArr['editID2'];
$form_creator->popArr['editArr'] = $empskill->filterEmpSkill($arr);
} else {
$form_creator->popArr['uskilllist'] = $skill->getUnAssSkillCodes($getArr['id']);
}
$form_creator->popArr['rsets'] = $empskill->getAssEmpSkill($getArr['id']);
break;
case 'LIC':
$form_creator->formPath = '/templates/hrfunct/hremplicenses.php';
$empinf = new EmpInfo();
$emplicen = new EmpLicenses();
$licen = new Licenses();
$form_creator->popArr['empDet'] = $empinf->filterEmpMain($getArr['id']);
$form_creator->popArr['allLicenlist'] = $licenlist = $licen->getLicensesCodes();
$form_creator->popArr['unassLicenlist'] = $licen->getUnAssLicensesCodes($getArr['id']);
if (isset($getArr['editID1'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID1'];
$arr[2] = $getArr['editID2'];
$form_creator->popArr['editArr'] = $emplicen->filterEmpLicenses($arr);
}
$form_creator->popArr['rsets'] = $emplicen->getAssEmpLicenses($getArr['id']);
break;
}
$form_creator->display();
}
/**
* Get CSV row from data retrieved from the database
*
* @param array $row Data row from database
*/
private function _getCSVRow($row)
{
// Get direct debit information
$dd = new EmpDirectDebit();
$ddList = $dd->getEmployeeDirectDebit($row['emp_number']);
$csvRow = "";
$firstField = true;
$assignedFields = $this->customExport->getAssignedFields();
foreach ($assignedFields as $field) {
$csvField = $this->fieldMap[$field];
$value = $csvField->getValue($row, $ddList);
if ($firstField) {
$firstField = false;
$csvRow = $value;
} else {
$csvRow .= ',' . $value;
}
}
return $csvRow;
}
/**
* @todo Implement testGetValue().
*/
public function testGetValue()
{
// Direct
$field = new CSVField('name', CSVField::FIELD_TYPE_DIRECT);
$row = array('id' => '1', 'name' => 'Ranasinghe', 'age' => 39);
$ddList = array();
$this->assertEquals('Ranasinghe', $field->getValue($row, $ddList));
// invalid (unavailable) name
$field = new CSVField('middle_name', CSVField::FIELD_TYPE_DIRECT);
$this->assertEquals('', $field->getValue($row, $ddList));
// Date
$field = new CSVField('joined_date', CSVField::FIELD_TYPE_DATE);
$row = array('id' => '1', 'name' => 'Ranasinghe', 'joined_date' => '2003-01-20');
$ddList = array();
$expected = LocaleUtil::getInstance()->formatDate($row['joined_date']);
$this->assertEquals($expected, $field->getValue($row, $ddList));
// invalid (unavailable) name
$field = new CSVField('birth_date', CSVField::FIELD_TYPE_DATE);
$this->assertEquals('', $field->getValue($row, $ddList));
// From Map
$genderMap = array(1 => "M", 2 => "F");
$field = new CSVField('sex', CSVField::FIELD_TYPE_FROMMAP, $genderMap);
$row = array('id' => '1', 'name' => 'Ranasinghe', 'sex' => 1, 'joined_date' => '2003-01-20');
$ddList = array();
$this->assertEquals('M', $field->getValue($row, $ddList));
// invalid (unavailable) name
$field = new CSVField('gender', CSVField::FIELD_TYPE_FROMMAP, $genderMap);
$this->assertEquals('', $field->getValue($row, $ddList));
// direct debit
$dd1 = new EmpDirectDebit();
$dd1->setEmpNumber(1);
$dd1->setDDSeqNo(1);
$dd1->setRoutingNumber(121212);
$dd1->setAccount('An account');
$dd1->setAmount(100);
$dd1->setAccountType('CHECKING');
$dd1->setTransactionType('BLANK');
$dd2 = new EmpDirectDebit();
$dd2->setEmpNumber(222);
$dd2->setDDSeqNo(2);
$dd2->setRoutingNumber(444444);
$dd2->setAccount('My Account');
$dd2->setAmount(200);
$dd2->setAccountType('SAVINGS');
$dd2->setTransactionType('PERC');
$ddList = array($dd1);
$field = new CSVField('DD1_Amount', CSVField::FIELD_TYPE_DIRECT_DEBIT);
$this->assertEquals(100, $field->getValue($row, $ddList));
$field = new CSVField('DD1_Routing', CSVField::FIELD_TYPE_DIRECT_DEBIT);
$this->assertEquals(121212, $field->getValue($row, $ddList));
$field = new CSVField('DD1_Account', CSVField::FIELD_TYPE_DIRECT_DEBIT);
$this->assertEquals('An account', $field->getValue($row, $ddList));
$field = new CSVField('DD1_AmountCode', CSVField::FIELD_TYPE_DIRECT_DEBIT);
$this->assertEquals('Blank', $field->getValue($row, $ddList));
$field = new CSVField('DD1_Checking', CSVField::FIELD_TYPE_DIRECT_DEBIT);
$this->assertEquals('Y', $field->getValue($row, $ddList));
// Second direct debit settings
$ddList = array($dd1, $dd2);
$field = new CSVField('DD2_Checking', CSVField::FIELD_TYPE_DIRECT_DEBIT);
$this->assertEquals('', $field->getValue($row, $ddList));
$field = new CSVField('DD2_AmountCode', CSVField::FIELD_TYPE_DIRECT_DEBIT);
$this->assertEquals('%', $field->getValue($row, $ddList));
// invalid (unavailable) name
$field = new CSVField('DD1_AAAmount', CSVField::FIELD_TYPE_DIRECT_DEBIT);
try {
$field->getValue($row, $ddList);
$this->fail("Exception expected");
} catch (Exception $e) {
}
}
/**
* Get a DirectDeposit object after validating input
* Throws an error on invalid input data
*
* @return DirectDeposit object or null if none of the data is available.
*/
private function _getDirectDeposit($routing, $account, $amount, $accountType, $transactionType)
{
// If all empty, return null
if (empty($routing) && empty($account) && empty($amount) && empty($accountType) && empty($transactionType)) {
return null;
}
$transactionTypes = array(EmpDirectDebit::TRANSACTION_TYPE_BLANK => 'Blank', EmpDirectDebit::TRANSACTION_TYPE_PERCENTAGE => '%', EmpDirectDebit::TRANSACTION_TYPE_FLAT => 'Flat', EmpDirectDebit::TRANSACTION_TYPE_FLAT_MINUS => 'Flat-');
$accountTypes = array(EmpDirectDebit::ACCOUNT_TYPE_CHECKING => "Y", EmpDirectDebit::ACCOUNT_TYPE_SAVINGS => "");
$accountType = self::_getKeyFromMap($accountTypes, $accountType);
$transactionType = self::_getKeyFromMap($transactionTypes, $transactionType);
if (empty($routing) || empty($account) || empty($amount) || empty($accountType) || empty($transactionType)) {
$invalid = array();
if (empty($routing)) {
$invalid[] = "Routing Number";
}
if (empty($account)) {
$invalid[] = "Account";
}
if (empty($amount)) {
$invalid[] = "Amount";
}
if (empty($accountType)) {
$invalid[] = "AccountType";
}
if (empty($transactionType)) {
$invalid[] = "TransactionType";
}
$msg = implode(',', $invalid);
// If at least one parameter is specifiec, all the rest should be specified as well.
throw new CSVImportException("Direct Debit data not complete invalid. Check following fields: {$msg}", CSVImportException::DD_DATA_INCOMPLETE);
} else {
// Validate routing number and amount
if (!CommonFunctions::isInt($routing)) {
throw new CSVImportException("Routing number not an integer: {$routing}", CSVImportException::INVALID_TYPE);
}
if (!is_numeric($amount)) {
throw new CSVImportException("Amount not a number: {$amount}", CSVImportException::INVALID_TYPE);
}
$dd = new EmpDirectDebit();
$dd->setRoutingNumber($routing);
$dd->setAccount($account);
$dd->setAmount($amount);
$dd->setAccountType($accountType);
$dd->setTransactionType($transactionType);
return $dd;
}
}
/**
* Build a EmpDirectDebit object from the database results row
*
* @param array $row associative array containing database data
*
* @return EmpDirectDebit object
*/
private function _buildObject($row)
{
$dd = new EmpDirectDebit();
$dd->setEmpNumber($row[self::DB_FIELD_EMP_NUMBER]);
$dd->setDDSeqNo($row[self::DB_FIELD_SEQNO]);
$dd->setRoutingNumber($row[self::DB_FIELD_ROUTING_NUM]);
$dd->setAccount($row[self::DB_FIELD_ACCOUNT]);
$dd->setAmount($row[self::DB_FIELD_AMOUNT]);
$dd->setAccountType($row[self::DB_FIELD_ACCOUNT_TYPE]);
$dd->setTransactionType($row[self::DB_FIELD_TRANSACTION_TYPE]);
return $dd;
}
