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 } }