function getListofDistrictInfo($pageNO, $schStr, $mode)
{
$tableName = 'HS_HR_DISTRICT';
$arrFieldList[0] = 'DISTRICT_CODE';
$arrFieldList[1] = 'DISTRICT_NAME';
$arrFieldList[2] = 'PROVINCE_CODE';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->passResultSetMessage($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;
}
}
function getAllMembershipCodes()
{
$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->passResultSetMessage();
//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 getCountryCodes()
{
$sql_builder = new SQLQBuilder();
$tableName = 'HS_HR_COUNTRY';
$arrFieldList[0] = 'COU_CODE';
$arrFieldList[1] = 'COU_NAME';
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->passResultSetMessage(0, '', -1, 1);
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
$common_func = new CommonFunctions();
$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 {
//Handle Exceptions
//Create Logs
}
}
function getListofRepEmployee($pageNO = 0, $schStr = '', $mode = 0)
{
$tableName = 'HS_HR_EMPLOYEE';
$arrFieldList[0] = 'EMP_NUMBER';
$arrFieldList[1] = 'EMP_LASTNAME';
$arrFieldList[2] = 'EMPLOYEE_ID';
$arrFieldList[3] = 'EMP_FIRSTNAME';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->passResultSetMessage($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];
$arrayDispList[$i][3] = $line[3];
$i++;
}
if (isset($arrayDispList)) {
return $arrayDispList;
} else {
$arrayDispList = '';
return $arrayDispList;
}
}
/**
* Get list of defined Custom Exports in format suitable for view.php
* @return Array 2D array representing custom export objects defined in database.
*/
public static function getCustomExportListForView($pageNO, $schStr, $mode, $sortField = 0, $sortOrder = 'ASC')
{
$tableName = self::TABLE_NAME;
$arrFieldList[0] = self::DB_FIELDS_ID;
$arrFieldList[1] = self::DB_FIELDS_NAME;
$arrFieldList[2] = self::DB_FIELDS_FIELDS;
$arrFieldList[3] = self::DB_FIELDS_HEADINGS;
$sqlBuilder = new SQLQBuilder();
$sqlBuilder->table_name = $tableName;
$sqlBuilder->flg_select = 'true';
$sqlBuilder->arr_select = $arrFieldList;
$sqlQString = $sqlBuilder->passResultSetMessage($pageNO, $schStr, $mode, $sortField, $sortOrder);
$dbConnection = new DMLFunctions();
$result = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
$i = 0;
while ($line = mysql_fetch_array($result, 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 getJobTit()
{
$sql_builder = new SQLQBuilder();
$tableName = 'HS_HR_JOB_TITLE';
$arrFieldList[0] = 'JOBTIT_CODE';
$arrFieldList[1] = 'JOBTIT_NAME';
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$specialSearch = "`" . self::DB_FIELD_IS_ACTIVE . "` = " . self::ACTIVE_JOB_TITLE;
$sqlQString = $sql_builder->passResultSetMessage(0, '', -1, 1, 'ASC', false, $specialSearch);
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
$common_func = new CommonFunctions();
$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 {
//Handle Exceptions
//Create Logs
}
}
/**
* Get list of job specs in a format suitable for view.php
*/
public static function getListForView($pageNO = 0, $schStr = '', $mode = -1, $sortField = 0, $sortOrder = 'ASC')
{
$arrFieldList[0] = self::DB_FIELD_ID;
$arrFieldList[1] = self::DB_FIELD_NAME;
$arrFieldList[2] = self::DB_FIELD_DESC;
$sqlBuilder = new SQLQBuilder();
$sqlBuilder->table_name = self::TABLE_NAME;
$sqlBuilder->flg_select = 'true';
$sqlBuilder->arr_select = $arrFieldList;
$sqlQString = $sqlBuilder->passResultSetMessage($pageNO, $schStr, $mode, $sortField, $sortOrder);
$dbConnection = new DMLFunctions();
$result = $dbConnection->executeQuery($sqlQString);
$i = 0;
$arrayDispList = null;
while ($line = mysql_fetch_assoc($result)) {
$arrayDispList[$i][0] = $line[self::DB_FIELD_ID];
$arrayDispList[$i][1] = $line[self::DB_FIELD_NAME];
$arrayDispList[$i][2] = $line[self::DB_FIELD_DESC];
$i++;
}
return $arrayDispList;
}
function getNationCodes()
{
$sql_builder = new SQLQBuilder();
$tableName = 'HS_HR_NATIONALITY';
$arrFieldList[0] = 'NAT_CODE';
$arrFieldList[1] = 'NAT_NAME';
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->passResultSetMessage();
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
$common_func = new CommonFunctions();
$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;
}
}
public function getSalGrdCodes()
{
$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->passResultSetMessage(0, '', -1, 1);
$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 getAllEducation()
{
$tableName = 'HS_HR_EDUCATION';
$arrFieldList[0] = 'EDU_CODE';
$arrFieldList[1] = 'EDU_UNI';
$arrFieldList[2] = 'EDU_DEG';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->passResultSetMessage(0, '', -1, 2);
//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 getEmployeeCodes()
{
$tableName = 'HS_HR_EMPLOYEE';
$arrFieldList[0] = 'LPAD(`EMP_NUMBER`, ' . $this->employeeIdLength . ', 0)';
$arrFieldList[1] = 'EMP_FIRSTNAME';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sqlQString = $sql_builder->passResultSetMessage();
//echo $sqlQString;
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
//echo mysql_error();
$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;
}
}
