function getUnAssEmployeeWorkExp($pageNO, $schStr, $mode) { $tableName = 'HS_HR_EMPLOYEE'; $arrFieldList[0] = 'EMP_NUMBER'; $arrFieldList[1] = 'EMP_LASTNAME'; $arrFieldList[2] = 'EMP_FIRSTNAME'; $sql_builder = new SQLQBuilder(); $sql_builder->table_name = $tableName; $sql_builder->table2_name = 'HS_HR_EMP_WORK_EXPERIENCE'; $sql_builder->field = 'EMP_NUMBER'; $sql_builder->flg_select = 'true'; $sql_builder->arr_select = $arrFieldList; $sqlQString = $sql_builder->passResultFilter($pageNO, $schStr, $mode); //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]; $i++; } if (isset($arrayDispList)) { return $arrayDispList; } else { $arrayDispList = ''; return $arrayDispList; } }
function getUnAssNonCashBenefits($pageNO, $schStr, $mode) { $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->table2_name = 'HS_HR_NONCASH_BEN_SALGRADE'; $sql_builder->field = 'SAL_GRD_CODE'; $sql_builder->flg_select = 'true'; $sql_builder->arr_select = $arrFieldList; $sqlQString = $sql_builder->passResultFilter($pageNO, $schStr, $mode); //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; } }