function filterGenInfo()
{
$tableName = 'HS_HR_GENINFO';
$arrFieldList[0] = 'CODE';
$arrFieldList[1] = 'GENINFO_KEYS';
$arrFieldList[2] = 'GENINFO_VALUES';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->selectOneRecordFiltered('001');
//echo $sqlQString;
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
$i = 0;
while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {
$arrayDispList[$i][0] = $line[1];
$arrayDispList[$i][1] = $line[2];
$i++;
}
if (isset($arrayDispList)) {
return $arrayDispList;
} else {
$arrayDispList = '';
return $arrayDispList;
}
}
function filterUser($userName)
{
$sql_builder = new SQLQBuilder();
$dbConnection = new DMLFunctions();
$this->username = mysql_real_escape_string($userName);
$tableName = 'HS_HR_USERS a LEFT JOIN HS_HR_EMPLOYEE b ON (a.EMP_NUMBER = b.EMP_NUMBER)';
$arrFieldList[0] = 'a.USER_NAME';
$arrFieldList[1] = 'a.USER_PASSWORD';
$arrFieldList[2] = 'IFNULL(b.EMP_FIRSTNAME, a.USER_NAME)';
$arrFieldList[3] = 'a.ID';
$arrFieldList[4] = 'a.USERG_ID';
$arrFieldList[5] = 'a.STATUS';
$arrFieldList[6] = 'LPAD(a.`EMP_NUMBER`, ' . $this->employeeIdLength . ', 0)';
$arrFieldList[7] = 'a.IS_ADMIN';
$arrFieldList[8] = 'b.EMP_STATUS';
$arrFieldList[9] = 'a.EMP_NUMBER';
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->selectOneRecordFiltered($this->username);
//echo $sqlQString;
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
if ($message2 && mysql_num_rows($message2) != 0) {
$i = 0;
while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {
$arrayDispList[$i][0] = $line[0];
$arrayDispList[$i][1] = $line[1];
$arrayDispList[$i][2] = $line[2];
$arrayDispList[$i][3] = $line[3];
$arrayDispList[$i][4] = $line[4];
$arrayDispList[$i][5] = $line[5];
$arrayDispList[$i][6] = $line[6];
$arrayDispList[$i][7] = $line[7];
$arrayDispList[$i][8] = $line[8];
$arrayDispList[$i][9] = $line[9];
$i++;
}
return $arrayDispList;
} else {
return NULL;
}
}
function getAssEmpAtt($getID)
{
$this->getID = $getID;
$tableName = 'HS_HR_EMP_ATTACHMENT';
$arrFieldList[0] = 'EMP_NUMBER';
$arrFieldList[1] = 'EATTACH_ID';
$arrFieldList[2] = 'EATTACH_DESC';
$arrFieldList[3] = 'EATTACH_FILENAME';
$arrFieldList[4] = 'EATTACH_SIZE';
$arrFieldList[5] = 'EATTACH_ATTACHMENT';
$arrFieldList[6] = 'EATTACH_TYPE';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->selectOneRecordFiltered($this->getID);
//echo $sqlQString;
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
$i = 0;
while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {
for ($c = 0; count($arrFieldList) > $c; $c++) {
$arrayDispList[$i][$c] = $line[$c];
}
$i++;
}
if (isset($arrayDispList)) {
return $arrayDispList;
} else {
$arrayDispList = '';
return $arrayDispList;
}
}
function getAssEmpWorkExp($getID)
{
$this->getID = $getID;
$tableName = 'HS_HR_EMP_WORK_EXPERIENCE';
$arrFieldList[0] = 'EMP_NUMBER';
$arrFieldList[1] = 'EEXP_SEQNO';
$arrFieldList[2] = 'EEXP_EMPLOYER';
$arrFieldList[3] = 'EEXP_JOBTIT';
$arrFieldList[4] = 'EEXP_FROM_DATE';
$arrFieldList[5] = 'EEXP_TO_DATE';
$arrFieldList[6] = 'EEXP_COMMENTS';
$arrFieldList[7] = 'EEXP_INTERNAL';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->selectOneRecordFiltered($this->getID, null, 4, 'DESC');
//echo $sqlQString;
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
$i = 0;
while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {
for ($c = 0; count($arrFieldList) > $c; $c++) {
$arrayDispList[$i][$c] = $line[$c];
}
$i++;
}
if (isset($arrayDispList)) {
return $arrayDispList;
} else {
$arrayDispList = '';
return $arrayDispList;
}
}
function filterLocation($getID)
{
$this->getID = $getID;
$tableName = 'HS_HR_LOCATION';
$arrFieldList[0] = 'LOC_CODE';
$arrFieldList[1] = 'LOC_NAME';
$arrFieldList[2] = 'LOC_COUNTRY';
$arrFieldList[3] = 'LOC_STATE';
$arrFieldList[4] = 'LOC_CITY';
$arrFieldList[5] = 'LOC_ADD';
$arrFieldList[6] = 'LOC_ZIP';
$arrFieldList[7] = 'LOC_PHONE';
$arrFieldList[8] = 'LOC_FAX';
$arrFieldList[9] = 'LOC_COMMENTS';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->selectOneRecordFiltered($this->getID);
//echo $sqlQString;
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
$i = 0;
while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {
for ($c = 0; count($arrFieldList) > $c; $c++) {
$arrayDispList[$i][$c] = $line[$c];
}
$i++;
}
if (isset($arrayDispList)) {
return $arrayDispList;
} else {
$arrayDispList = '';
return $arrayDispList;
}
}
function getDistrictCodes($getID)
{
$sql_builder = new SQLQBuilder();
$this->getID = $sql_builder->quoteCorrectString($getID, false);
$tableName = 'HS_HR_DISTRICT';
$arrFieldList[0] = 'PROVINCE_CODE';
$arrFieldList[1] = 'DISTRICT_CODE';
$arrFieldList[2] = 'DISTRICT_NAME';
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->selectOneRecordFiltered($this->getID);
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
$i = 0;
while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {
for ($c = 0; count($arrFieldList) > $c; $c++) {
$arrayDispList[$i][$c] = $line[$c];
}
$i++;
}
if (isset($arrayDispList)) {
return $arrayDispList;
} else {
$arrayDispList = '';
return $arrayDispList;
}
}
function getMembershipCodes($getID)
{
$this->getID = $getID;
$tableName = 'HS_HR_MEMBERSHIP';
$arrFieldList[0] = 'MEMBTYPE_CODE';
$arrFieldList[1] = 'MEMBSHIP_CODE';
$arrFieldList[2] = 'MEMBSHIP_NAME';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->selectOneRecordFiltered($this->getID);
//echo $sqlQString;
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
$i = 0;
while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {
for ($c = 0; count($arrFieldList) > $c; $c++) {
$arrayDispList[$i][$c] = $line[$c];
}
$i++;
}
if (isset($arrayDispList)) {
return $arrayDispList;
} else {
$arrayDispList = '';
return $arrayDispList;
}
}
function filterEmpContact($getID)
{
$this->getID = $getID;
$tableName = 'HS_HR_EMPLOYEE';
$arrFieldList[0] = 'EMP_NUMBER';
$arrFieldList[1] = 'EMP_STREET1';
$arrFieldList[2] = 'EMP_STREET2';
$arrFieldList[3] = 'CITY_CODE';
$arrFieldList[4] = 'COUN_CODE';
$arrFieldList[5] = 'PROVIN_CODE';
$arrFieldList[6] = 'EMP_ZIPCODE';
$arrFieldList[7] = 'EMP_HM_TELEPHONE';
$arrFieldList[8] = 'EMP_MOBILE';
$arrFieldList[9] = 'EMP_WORK_TELEPHONE';
$arrFieldList[10] = 'EMP_WORK_EMAIL';
$arrFieldList[11] = 'EMP_OTH_EMAIL';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->selectOneRecordFiltered($this->getID);
//echo $sqlQString;
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
$i = 0;
while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {
for ($c = 0; count($arrFieldList) > $c; $c++) {
$arrayDispList[$i][$c] = $line[$c];
}
$i++;
}
if (isset($arrayDispList)) {
return $arrayDispList;
} else {
$arrayDispList = '';
return $arrayDispList;
}
}
function filterJobTitles($getID)
{
$arrFieldList[0] = 'JOBTIT_CODE';
$arrFieldList[1] = 'JOBTIT_NAME';
$arrFieldList[2] = 'JOBTIT_DESC';
$arrFieldList[3] = 'JOBTIT_COMM';
$arrFieldList[4] = 'SAL_GRD_CODE';
$arrFieldList[5] = self::DB_FIELD_JOBSPEC_ID;
$tableName = 'HS_HR_JOB_TITLE';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->selectOneRecordFiltered($getID);
//echo $sqlQString;
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
$i = 0;
while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {
$arrayDispList[$i][0] = $line[0];
$arrayDispList[$i][1] = $line[1];
$arrayDispList[$i][2] = $line[2];
$arrayDispList[$i][3] = $line[3];
$arrayDispList[$i][4] = $line[4];
$arrayDispList[$i][5] = $line[5];
$i++;
}
if (isset($arrayDispList)) {
return $arrayDispList;
} else {
$arrayDispList = '';
return $arrayDispList;
}
}
function filterGetEthnicRaceInfo($getID)
{
$this->getID = $getID;
$tableName = 'HS_HR_ETHNIC_RACE';
$arrFieldList[0] = 'ETHNIC_RACE_CODE';
$arrFieldList[1] = 'ETHNIC_RACE_DESC';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->selectOneRecordFiltered($this->getID);
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
$i = 0;
while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {
$arrayDispList[$i][0] = $line[0];
// Province Code
$arrayDispList[$i][1] = $line[1];
// Provicne Name
$i++;
}
if (isset($arrayDispList)) {
return $arrayDispList;
} else {
$arrayDispList = '';
return $arrayDispList;
}
}
/**
* Gets the tax information for the given employee
*
* @param string $empNumber The employee number
* @return array array containing employee tax information
*/
function getEmployeeTaxInfo($empNumber)
{
$this->empNumber = $empNumber;
$arrFieldList[0] = self::EMP_TAX_TABLE_EMP_NUMBER;
$arrFieldList[1] = self::EMP_TAX_FEDERAL_STATUS;
$arrFieldList[2] = self::EMP_TAX_FEDERAL_EXCEPTIONS;
$arrFieldList[3] = self::EMP_TAX_STATE;
$arrFieldList[4] = self::EMP_TAX_STATE_STATUS;
$arrFieldList[5] = self::EMP_TAX_STATE_EXCEPTIONS;
$arrFieldList[6] = self::EMP_TAX_UNEMP_STATE;
$arrFieldList[7] = self::EMP_TAX_WORK_STATE;
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = self::EMP_TAX_TABLE_NAME;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->selectOneRecordFiltered($this->empNumber);
$dbConnection = new DMLFunctions();
$results = $dbConnection->executeQuery($sqlQString);
if (mysql_num_rows($results) === 1) {
$taxInfo = mysql_fetch_array($results, MYSQL_ASSOC);
} else {
$taxInfo = array(self::EMP_TAX_TABLE_EMP_NUMBER => $empNumber, self::EMP_TAX_FEDERAL_STATUS => null, self::EMP_TAX_FEDERAL_EXCEPTIONS => null, self::EMP_TAX_STATE => null, self::EMP_TAX_STATE_STATUS => null, self::EMP_TAX_STATE_EXCEPTIONS => null, self::EMP_TAX_UNEMP_STATE => null, self::EMP_TAX_WORK_STATE => null);
}
return $taxInfo;
}
function getAssEmpQual($getID)
{
$this->getID = $getID;
$tableName = 'HS_HR_EMP_QUALIFICATION';
$arrFieldList[0] = 'EMP_NUMBER';
$arrFieldList[1] = 'QUALIFI_CODE';
$arrFieldList[2] = 'EQUALIFI_INSTITUTE';
$arrFieldList[3] = 'EQUALIFI_YEAR';
$arrFieldList[4] = 'EQUALIFI_STATUS';
$arrFieldList[5] = 'EQUALIFI_COMMENTS';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->selectOneRecordFiltered($this->getID);
echo $sqlQString;
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
$i = 0;
while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {
for ($c = 0; count($arrFieldList) > $c; $c++) {
$arrayDispList[$i][$c] = $line[$c];
}
$i++;
}
if (isset($arrayDispList)) {
return $arrayDispList;
} else {
$arrayDispList = '';
return $arrayDispList;
}
}
function filterReport($getID)
{
$tableName = 'HS_HR_EMPREPORT';
$arrFieldList[0] = 'REP_CODE';
$arrFieldList[1] = 'REP_NAME';
$arrFieldList[2] = 'REP_CRIDEF_STR';
$arrFieldList[3] = 'REP_FLDDEF_STR';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->selectOneRecordFiltered($getID);
//echo $sqlQString;
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
$i = 0;
while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {
$arrayDispList[$i][0] = $line[0];
$arrayDispList[$i][1] = $line[1];
$arrayDispList[$i][2] = $line[2];
$arrayDispList[$i][3] = $line[3];
$i++;
}
if (isset($arrayDispList)) {
return $arrayDispList;
} else {
$arrayDispList = '';
return $arrayDispList;
}
}
function filterSalCurDet($getID)
{
$this->getID = $getID;
$tableName = 'HS_PR_SALARY_CURRENCY_DETAIL';
$arrFieldList[0] = 'SAL_GRD_CODE';
$arrFieldList[1] = 'CURRENCY_ID';
$arrFieldList[2] = 'SALCURR_DTL_MINSALARY';
$arrFieldList[3] = 'SALCURR_DTL_MAXSALARY';
$arrFieldList[4] = 'SALCURR_DTL_STEPSALARY';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->selectOneRecordFiltered($this->getID, 1);
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
$i = 0;
while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {
for ($c = 0; count($arrFieldList) > $c; $c++) {
$arrayDispList[$i][$c] = $line[$c];
}
$arrayDispList[$i][5] = $this->getMinSalPg($getID);
$arrayDispList[$i][6] = $this->getMaxSalPg($getID);
$i++;
}
if (isset($arrayDispList)) {
return $arrayDispList;
} else {
$arrayDispList = '';
return $arrayDispList;
}
}
function filterSalaryGrades($getID)
{
$this->getID = $getID;
$tableName = 'HS_PR_SALARY_GRADE';
$arrFieldList[0] = 'SAL_GRD_CODE';
$arrFieldList[1] = 'SAL_GRD_NAME';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->selectOneRecordFiltered($this->getID);
//echo $sqlQString;
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
$i = 0;
while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {
$arrayDispList[$i][0] = $line[0];
$arrayDispList[$i][1] = $line[1];
$i++;
}
if (isset($arrayDispList)) {
return $arrayDispList;
} else {
$arrayDispList = '';
return $arrayDispList;
}
}
function getAssEmpDep($getID)
{
$this->getID = $getID;
$tableName = 'HS_HR_EMP_DEPENDENTS';
$arrFieldList[0] = 'EMP_NUMBER';
$arrFieldList[1] = 'ED_SEQNO';
$arrFieldList[2] = 'ED_NAME';
$arrFieldList[3] = 'ED_RELATIONSHIP';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->selectOneRecordFiltered($this->getID);
/*$exception_handler = new ExceptionHandler();
$exception_handler->logW($sqlQString);*/
//$sqlQString="SELECT EMP_NUMBER, EP_SEQNO, EP_PASSPORT_NUM, EP_PASSPORTISSUEDDATE, EP_PASSPORTEXPIREDATE, EP_COMMENTS, EP_PASSPORT_TYPE_FLG, EP_I9_STATUS, EP_I9_REVIEW_DATE, COU_CODE FROM HS_HR_EMP_DEPENDENTS WHERE EMP_NUMBER='EMP010'";
//echo $sqlQString;
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
$i = 0;
while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {
for ($c = 0; count($arrFieldList) > $c; $c++) {
$arrayDispList[$i][$c] = $line[$c];
}
$i++;
}
if (isset($arrayDispList)) {
return $arrayDispList;
} else {
$arrayDispList = '';
return $arrayDispList;
}
}
function getRights($user, $module)
{
$tableName = 'HS_HR_RIGHTS';
$arrFieldList[0] = 'USERG_ID';
$arrFieldList[1] = 'MOD_ID';
$arrFieldList[2] = 'ADDITION';
$arrFieldList[3] = 'EDITING';
$arrFieldList[4] = 'DELETION';
$arrFieldList[5] = 'VIEWING';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$arr[0] = $user;
$arr[1] = $module;
$sqlQString = $sql_builder->selectOneRecordFiltered($arr, 1);
//echo $sqlQString;
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
if (mysql_num_rows($message2) != 0) {
$i = 0;
while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {
$arrRights['add'] = $line[2] == 1 ? true : false;
$arrRights['edit'] = $line[3] == 1 ? true : false;
$arrRights['delete'] = $line[4] == 1 ? true : false;
$arrRights['view'] = $line[5] == 1 ? true : false;
$i++;
}
} else {
$arrRights['add'] = false;
$arrRights['edit'] = false;
$arrRights['delete'] = false;
$arrRights['view'] = false;
}
return $arrRights;
}
function getAssEmpBasSal($getID)
{
$this->getID = $getID;
$tableName = 'hs_hr_emp_basicsalary';
$arrFieldList[0] = 'EMP_NUMBER';
$arrFieldList[1] = 'SAL_GRD_CODE';
$arrFieldList[2] = 'CURRENCY_ID';
$arrFieldList[3] = 'EBSAL_BASIC_SALARY';
$arrFieldList[4] = 'PAYPERIOD_CODE';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->selectOneRecordFiltered($this->getID);
//echo $sqlQString;
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
$i = 0;
while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {
for ($c = 0; count($arrFieldList) > $c; $c++) {
$arrayDispList[$i][$c] = $line[$c];
}
$i++;
}
if (isset($arrayDispList)) {
return $arrayDispList;
} else {
$arrayDispList = '';
return $arrayDispList;
}
}
function getAssignedUserGroup($getID)
{
$tableName = 'HS_HR_EMPREP_USERGROUP';
$arrFieldList[0] = 'REP_CODE';
$arrFieldList[1] = 'USERG_ID';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->selectOneRecordFiltered($getID);
//echo $sqlQString;
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
$i = 0;
while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {
$arrayDispList[$i][0] = $line[0];
$arrayDispList[$i][1] = $line[1];
$i++;
}
if (isset($arrayDispList)) {
return $arrayDispList;
} else {
$arrayDispList = '';
return $arrayDispList;
}
}
function filterJobTitEmpStat($getID)
{
$arrFieldList[0] = 'JOBTIT_CODE';
$arrFieldList[1] = 'ESTAT_CODE';
$tableName = 'HS_HR_JOBTIT_EMPSTAT';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->selectOneRecordFiltered($this->getID);
//echo $sqlQString;
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
$i = 0;
while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {
$arrayDispList[$i][0] = $line[0];
$arrayDispList[$i][1] = $line[1];
$i++;
}
if (isset($arrayDispList)) {
return $arrayDispList;
} else {
$arrayDispList = '';
return $arrayDispList;
}
}
function getEmpSub($getID)
{
$this->getID = $getID;
$tableName = 'HS_HR_EMP_REPORTTO a';
$arrFieldList[0] = 'LPAD(a.`EREP_SUP_EMP_NUMBER`, ' . $this->employeeIdLength . ', 0)';
$arrFieldList[1] = 'LPAD(a.`EREP_SUB_EMP_NUMBER`, ' . $this->employeeIdLength . ', 0)';
$arrFieldList[2] = 'a.EREP_REPORTING_MODE';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->selectOneRecordFiltered($this->getID);
//echo $sqlQString."\n";
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
$i = 0;
$empInfoObj = new EmpInfo();
while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {
for ($c = 0; count($arrFieldList) > $c; $c++) {
$arrayDispList[$i][$c] = $line[$c];
}
$supervisorId = $empInfoObj->fetchEmployeeId($line[0]);
if ($supervisorId) {
$arrayDispList[$i][count($arrFieldList)] = $supervisorId;
} else {
$arrayDispList[$i][count($arrFieldList)] = $line[0];
}
$subordinateId = $empInfoObj->fetchEmployeeId($line[1]);
if ($subordinateId) {
$arrayDispList[$i][count($arrFieldList) + 1] = $subordinateId;
} else {
$arrayDispList[$i][count($arrFieldList) + 1] = $line[1];
}
$i++;
}
if (isset($arrayDispList)) {
return $arrayDispList;
} else {
$arrayDispList = '';
return $arrayDispList;
}
}
function getAssConExt($getID)
{
$this->getID = $getID;
$tableName = 'HS_HR_EMP_CONTRACT_EXTEND';
$arrFieldList[0] = 'EMP_NUMBER';
$arrFieldList[1] = 'ECON_EXTEND_ID';
$arrFieldList[2] = 'ECON_EXTEND_START_DATE';
$arrFieldList[3] = 'ECON_EXTEND_END_DATE';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->selectOneRecordFiltered($this->getID);
//echo $sqlQString;
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
$i = 0;
while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {
for ($c = 0; count($arrFieldList) > $c; $c++) {
$arrayDispList[$i][$c] = $line[$c];
}
$i++;
}
if (isset($arrayDispList)) {
return $arrayDispList;
} else {
$arrayDispList = '';
return $arrayDispList;
}
}
/**
* Get assigned direct debit instructions for the given employee
*
* @param string $empNumber Employee number
* @return array of employee direct debit instructions. Empty array if none found
*/
public function getEmployeeDirectDebit($empNumber)
{
$arrFieldList[0] = self::DB_FIELD_EMP_NUMBER;
$arrFieldList[1] = self::DB_FIELD_SEQNO;
$arrFieldList[2] = self::DB_FIELD_ROUTING_NUM;
$arrFieldList[3] = self::DB_FIELD_ACCOUNT;
$arrFieldList[4] = self::DB_FIELD_AMOUNT;
$arrFieldList[5] = self::DB_FIELD_ACCOUNT_TYPE;
$arrFieldList[6] = self::DB_FIELD_TRANSACTION_TYPE;
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = self::TABLE_NAME;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->selectOneRecordFiltered($empNumber);
$dbConnection = new DMLFunctions();
$result = $dbConnection->executeQuery($sqlQString);
$ddebit = array();
if ($result && mysql_num_rows($result) > 0) {
while ($line = mysql_fetch_assoc($result)) {
$ddebit[] = $this->_buildObject($line);
}
}
return $ddebit;
}
