function getUnAssMembershipCodes($eno, $typ)
{
$sql_builder = new SQLQBuilder();
$tableName = 'HS_HR_MEMBERSHIP';
$arrFieldList[0] = 'MEMBSHIP_CODE';
$arrFieldList[1] = 'MEMBSHIP_NAME';
$arrFieldList[2] = 'MEMBTYPE_CODE';
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sql_builder->field = 'MEMBSHIP_CODE';
$sql_builder->table2_name = 'HS_HR_EMP_MEMBER_DETAIL';
$arr1[0][0] = 'EMP_NUMBER';
$arr1[0][1] = $eno;
$arr2[0][0] = 'MEMBTYPE_CODE';
$arr2[0][1] = "'{$typ}'";
$sqlQString = $sql_builder->selectFilter($arr1, $arr2);
if (isset($arr2)) {
$sqlQString = str_replace("ORDER BY MEMBSHIP_CODE", "ORDER BY MEMBSHIP_NAME", $sqlQString);
}
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
$i = 0;
while ($line = mysql_fetch_row($message2)) {
$arrayDispList[$i][0] = $line[0];
$arrayDispList[$i][1] = $line[1];
$i++;
}
if (isset($arrayDispList)) {
return $arrayDispList;
} else {
//Handle Exceptions
//Create Logs
}
}
/**
* Return list of employees who are not assigned to any workshift
* @return array Array of employees
*/
public static function getEmployeesWithoutWorkshift()
{
$fields[0] = EmpInfo::EMPLOYEE_FIELD_EMP_NUMBER;
$fields[1] = EmpInfo::EMPLOYEE_FIELD_EMP_ID;
$fields[2] = EmpInfo::EMPLOYEE_FIELD_FIRST_NAME;
$fields[3] = EmpInfo::EMPLOYEE_FIELD_MIDDLE_NAME;
$fields[4] = EmpInfo::EMPLOYEE_FIELD_LAST_NAME;
$sqlBuilder = new SQLQBuilder();
$sqlBuilder->table_name = EmpInfo::EMPLOYEE_TABLE_NAME;
$sqlBuilder->flg_select = 'true';
$sqlBuilder->arr_select = $fields;
$sqlBuilder->field = EmpInfo::EMPLOYEE_FIELD_EMP_NUMBER;
$sqlBuilder->field2 = self::DB_FIELD_EMP_NUMBER;
$sqlBuilder->table2_name = self::EMPLOYEE_WORKSHIFT_TABLE;
$sql = $sqlBuilder->selectFilter();
$connection = new DMLFunctions();
$result = $connection->executeQuery($sql);
if ($result === false) {
throw new WorkshiftException("Error in db query:" . $sql, WorkshiftException::ERROR_IN_DB_QUERY);
}
return self::_getEmployeesFromResults($result);
}
function getUnAssEmpStat($jobtit)
{
$sql_builder = new SQLQBuilder();
$tableName = 'hs_hr_empstat';
$arrFieldList[0] = 'ESTAT_CODE';
$arrFieldList[1] = 'ESTAT_NAME';
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sql_builder->field = 'ESTAT_CODE';
$sql_builder->table2_name = 'HS_HR_JOBTIT_EMPSTAT';
$arr[0][0] = 'JOBTIT_CODE';
$arr[0][1] = $jobtit;
$sqlQString = $sql_builder->selectFilter($arr);
$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
}
}
function getUnAssEduCodes($id)
{
$sql_builder = new SQLQBuilder();
$tableName = 'HS_HR_EDUCATION';
$arrFieldList[0] = 'EDU_CODE';
$arrFieldList[1] = 'EDU_DEG';
$arrFieldList[2] = 'EDU_UNI';
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sql_builder->field = 'EDU_CODE';
$sql_builder->table2_name = 'HS_HR_EMP_EDUCATION';
$arr[0][0] = 'EMP_NUMBER';
$arr[0][1] = $id;
$sqlQString = $sql_builder->selectFilter($arr, 1);
//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 getUnAssLangCodes($eno)
{
$sql_builder = new SQLQBuilder();
$tableName = 'HS_HR_LANGUAGE';
$arrFieldList[0] = 'LANG_CODE';
$arrFieldList[1] = 'LANG_NAME';
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sql_builder->field = 'MEMBSHIP_CODE';
$sql_builder->table2_name = 'HS_HR_EMP_MEMBER_DETAIL';
$arr1[0][0] = 'EMP_NUMBER';
$arr1[0][1] = $eno;
$sqlQString = $sql_builder->selectFilter($arr1);
$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;
}
}
function getUnAssUserGroups($id)
{
$sql_builder = new SQLQBuilder();
$tableName = 'HS_HR_USER_GROUP';
$arrFieldList[0] = 'USERG_ID';
$arrFieldList[1] = 'USERG_NAME';
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sql_builder->field = 'USERG_ID';
$sql_builder->table2_name = 'HS_HR_EMPREP_USERGROUP';
$arr[0][0] = 'REP_CODE';
$arr[0][1] = $id;
$sqlQString = $sql_builder->selectFilter($arr);
$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
}
}
function getModuleCodes($id)
{
$tableName = 'HS_HR_MODULE';
$arrFieldList[0] = 'MOD_ID';
$arrFieldList[1] = 'NAME';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sql_builder->field = 'MOD_ID';
$sql_builder->table2_name = 'HS_HR_RIGHTS';
$arr[0][0] = 'USERG_ID';
$arr[0][1] = $id;
$sqlQString = $sql_builder->selectFilter($arr, 1);
//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 getUnAssSalCurDet($salgrd)
{
$sql_builder = new SQLQBuilder();
$tableName = 'HS_HR_CURRENCY_TYPE';
$arrFieldList[0] = 'CURRENCY_ID';
$arrFieldList[1] = 'CURRENCY_NAME';
$sql_builder->table_name = $tableName;
$sql_builder->flg_select = 'true';
$sql_builder->arr_select = $arrFieldList;
$sql_builder->field = 'CURRENCY_ID';
$sql_builder->table2_name = 'HS_PR_SALARY_CURRENCY_DETAIL';
$arr[0][0] = 'SAL_GRD_CODE';
$arr[0][1] = $salgrd;
$sqlQString = $sql_builder->selectFilter($arr, '', 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];
$i++;
}
if (isset($arrayDispList)) {
return $arrayDispList;
} else {
//Handle Exceptions
//Create Logs
}
}
