public Map<String, List> fetchHoldingItem(boolean cursor) throws SQLException {
String holdingId = "";
String tempHoldingId = "";
List itemIds = new ArrayList();
Map<String, List> map = null;
if (cursor) {
while (holdingItemResultSet.next()) {
holdingId = "who-" + holdingItemResultSet.getString("HOLDINGS_ID");
if (StringUtils.isNotEmpty(tempHoldingId) && !tempHoldingId.equals(holdingId)) {
if (itemIds.size() > 0) {
map = new HashMap<>();
map.put(tempHoldingId, itemIds);
return map;
}
}
itemIds.add("wio-" + holdingItemResultSet.getString("ITEM_ID"));
tempHoldingId = holdingId;
}
} else {
holdingItemResultSet.previous();
// while(holdingItemResultSet.previous()) {
// break;
// }
while (holdingItemResultSet.next()) {
holdingId = "who-" + holdingItemResultSet.getString("HOLDINGS_ID");
if (StringUtils.isNotEmpty(tempHoldingId) && !tempHoldingId.equals(holdingId)) {
if (itemIds.size() > 0) {
map = new HashMap<>();
map.put(tempHoldingId, itemIds);
return map;
}
}
itemIds.add("wio-" + holdingItemResultSet.getString("ITEM_ID"));
tempHoldingId = holdingId;
}
}
if (itemIds.size() > 0) {
map = new HashMap<>();
map.put(tempHoldingId, itemIds);
return map;
} else {
map = null;
}
holdingItemResultSet.close();
return map;
}
public Map<String, List> fetchBibHolding(boolean cursor) throws SQLException {
String holdingId = "";
String tempHoldingId = "";
List bibIds = new ArrayList();
Map<String, List> map = null;
if (cursor) {
while (bibHoldingsResultSet.next()) {
holdingId = "who-" + bibHoldingsResultSet.getString("HOLDINGS_ID");
if (StringUtils.isNotEmpty(tempHoldingId) && !tempHoldingId.equals(holdingId)) {
if (bibIds.size() > 0) {
map = new HashMap<>();
bibIds.remove(0);
map.put(tempHoldingId, bibIds);
return map;
}
}
bibIds.add("wbm-" + bibHoldingsResultSet.getString("BIB_ID"));
tempHoldingId = holdingId;
}
} else {
while (bibHoldingsResultSet.next()) {
holdingId = "who-" + bibHoldingsResultSet.getString("HOLDINGS_ID");
if (StringUtils.isNotEmpty(tempHoldingId) && !tempHoldingId.equals(holdingId)) {
map = new HashMap<>();
map.put(tempHoldingId, bibIds);
return map;
}
bibIds.add("wbm-" + bibHoldingsResultSet.getString("BIB_ID"));
tempHoldingId = holdingId;
}
}
if (bibIds.size() > 0) {
map = new HashMap<>();
bibIds.remove(0);
map.put(tempHoldingId, bibIds);
return map;
} else {
map = null;
}
bibHoldingsResultSet.close();
return map;
}
private void fetchAuthenticationType() throws SQLException {
Statement statement = connection.createStatement();
ResultSet resultSet =
statement.executeQuery("SELECT CODE,NAME from OLE_DS_AUTHENTICATION_TYPE_T");
while (resultSet.next()) {
authenticationType.put(resultSet.getString("CODE"), resultSet.getString("NAME"));
}
resultSet.close();
}
private void fetchReceiptStatus() throws SQLException {
Statement statement = connection.createStatement();
ResultSet resultSet =
statement.executeQuery("SELECT RCPT_STAT_CD,RCPT_STAT_NM from OLE_CAT_RCPT_STAT_T");
while (resultSet.next()) {
receiptStatus.put(resultSet.getString("RCPT_STAT_CD"), resultSet.getString("RCPT_STAT_NM"));
}
resultSet.close();
}
private void fetchStatisticalSearchCode() throws SQLException {
Statement statement = connection.createStatement();
ResultSet resultSet =
statement.executeQuery(
"SELECT STAT_SRCH_CD_ID, STAT_SRCH_CD, STAT_SRCH_NM from OLE_CAT_STAT_SRCH_CD_T");
while (resultSet.next()) {
statisticalSearchCodeMap.put(
resultSet.getString("STAT_SRCH_CD_ID"),
resultSet.getString("STAT_SRCH_CD") + "|" + resultSet.getString("STAT_SRCH_NM"));
}
resultSet.close();
}
private void fetchItemType() throws SQLException {
Statement statement = connection.createStatement();
ResultSet resultSet =
statement.executeQuery("SELECT ITM_TYP_CD_ID,ITM_TYP_CD,ITM_TYP_NM from OLE_CAT_ITM_TYP_T");
while (resultSet.next()) {
itemTypeMap.put(
resultSet.getString("ITM_TYP_CD_ID"),
resultSet.getString("ITM_TYP_CD") + "|" + resultSet.getString("ITM_TYP_NM"));
}
resultSet.close();
}
private void fetchCallNumberType() throws SQLException {
Statement statement = connection.createStatement();
ResultSet resultSet =
statement.executeQuery(
"SELECT SHVLG_SCHM_ID,SHVLG_SCHM_CD,SHVLG_SCHM_NM from OLE_CAT_SHVLG_SCHM_T");
while (resultSet.next()) {
callNumberType.put(
resultSet.getString("SHVLG_SCHM_ID"),
resultSet.getString("SHVLG_SCHM_CD") + "|" + resultSet.getString("SHVLG_SCHM_NM"));
}
resultSet.close();
}
private void fetchExtentOfOwnershipType() throws SQLException {
Statement statement = connection.createStatement();
ResultSet resultSet =
statement.executeQuery(
"SELECT TYPE_OWNERSHIP_ID, TYPE_OWNERSHIP_CD,TYPE_OWNERSHIP_NM from OLE_CAT_TYPE_OWNERSHIP_T");
while (resultSet.next()) {
extentOfOwnershipTypeMap.put(
resultSet.getString("TYPE_OWNERSHIP_ID"),
resultSet.getString("TYPE_OWNERSHIP_CD")
+ "|"
+ resultSet.getString("TYPE_OWNERSHIP_NM"));
}
resultSet.close();
}
private void fetchItemStatus() throws SQLException {
Statement statement = connection.createStatement();
ResultSet resultSet =
statement.executeQuery(
"SELECT ITEM_AVAIL_STAT_ID,ITEM_AVAIL_STAT_CD,ITEM_AVAIL_STAT_NM from OLE_DLVR_ITEM_AVAIL_STAT_T");
while (resultSet.next()) {
itemStatusMap.put(
resultSet.getString("ITEM_AVAIL_STAT_ID"),
resultSet.getString("ITEM_AVAIL_STAT_CD")
+ "|"
+ resultSet.getString("ITEM_AVAIL_STAT_NM"));
}
resultSet.close();
}
public List<HoldingsTree> fetchHoldingsTreeForBib(int bibId) throws Exception {
List<HoldingsTree> holdingsTrees = new ArrayList<HoldingsTree>();
holdingsPreparedStatement.setInt(1, bibId);
ResultSet resultSet = holdingsPreparedStatement.executeQuery();
Map<String, HoldingsTree> map = new HashMap<>();
Map<String, ExtentOfOwnership> extentOfOwnershipMap = new HashMap<>();
Set<String> uriSet = null;
Set<String> noteSet = null;
Set<String> donorSet = null;
Set<String> coverageSet = null;
Set<String> perpetualSet = null;
Set<String> extentOfOwnershipNoteSet = null;
Set<String> linkSet = null;
while (resultSet.next()) {
String holdingsType = resultSet.getString("HOLDINGS_TYPE");
String id = resultSet.getString("HOLDINGS_ID");
OleHoldings oleHoldings = null;
if (map.containsKey(id)) {
oleHoldings = map.get(id).getHoldings().getContentObject();
} else {
oleHoldings = new OleHoldings();
Location location =
getLocationDetails(
resultSet.getString("LOCATION"), resultSet.getString("LOCATION_LEVEL"));
oleHoldings.setLocation(location);
oleHoldings.setHoldingsType(holdingsType);
CallNumber callNumber = new CallNumber();
callNumber.setNumber(resultSet.getString("CALL_NUMBER"));
callNumber.setPrefix(resultSet.getString("CALL_NUMBER_PREFIX"));
ShelvingOrder shelvingOrder = new ShelvingOrder();
if (resultSet.getString("SHELVING_ORDER") != null
&& !"null".equals(resultSet.getString("SHELVING_ORDER"))) {
shelvingOrder.setCodeValue(resultSet.getString("SHELVING_ORDER"));
shelvingOrder.setFullValue(resultSet.getString("SHELVING_ORDER"));
}
callNumber.setShelvingOrder(shelvingOrder);
ShelvingScheme shelvingScheme = new ShelvingScheme();
if (resultSet.getString("CALL_NUMBER_TYPE_ID") != null) {
String[] strings =
callNumberType.get(resultSet.getString("CALL_NUMBER_TYPE_ID")).split("[|]");
shelvingScheme.setCodeValue(strings[0]);
shelvingScheme.setFullValue(strings[1]);
}
callNumber.setShelvingScheme(shelvingScheme);
oleHoldings.setCallNumber(callNumber);
oleHoldings.setCopyNumber(resultSet.getString("COPY_NUMBER"));
HoldingsTree holdingsTree = new HoldingsTree();
Holdings holdings = null;
if (holdingsType.equalsIgnoreCase(PHoldings.PRINT)) {
holdings = new PHoldings();
if (resultSet.getString("RECEIPT_STATUS_ID") != null) {
oleHoldings.setReceiptStatus(resultSet.getString("RECEIPT_STATUS_ID"));
}
extentOfOwnershipNoteSet = new HashSet<>();
donorSet = coverageSet = perpetualSet = null;
} else {
holdings = new EHoldings();
oleHoldings.setAccessStatus(resultSet.getString("ACCESS_STATUS"));
oleHoldings.setImprint(resultSet.getString("IMPRINT"));
Platform platform = new Platform();
platform.setPlatformName(resultSet.getString("PLATFORM"));
platform.setAdminUrl(resultSet.getString("ADMIN_URL"));
platform.setAdminUserName(resultSet.getString("ADMIN_USERNAME"));
platform.setAdminPassword(resultSet.getString("ADMIN_PASSWORD"));
oleHoldings.setPlatform(platform);
oleHoldings.setPublisher(resultSet.getString("PUBLISHER"));
HoldingsAccessInformation holdingsAccessInformation = new HoldingsAccessInformation();
holdingsAccessInformation.setProxiedResource(resultSet.getString("PROXIED_RESOURCE"));
holdingsAccessInformation.setAccessUsername(resultSet.getString("ACCESS_USERNAME"));
holdingsAccessInformation.setAccessPassword(resultSet.getString("ACCESS_PASSWORD"));
holdingsAccessInformation.setNumberOfSimultaneousUser(
resultSet.getString("NUMBER_SIMULT_USERS"));
holdingsAccessInformation.setAccessLocation(resultSet.getString("CODE"));
holdingsAccessInformation.setAuthenticationType(
resultSet.getString("AUTHENTICATION_TYPE_ID"));
oleHoldings.setHoldingsAccessInformation(holdingsAccessInformation);
String statisticalSearchId = resultSet.getString("STAT_SEARCH_CODE_ID");
if (StringUtils.isNotEmpty(statisticalSearchId)) {
String[] strings = statisticalSearchCodeMap.get(statisticalSearchId).split("[|]");
StatisticalSearchingCode statisticalSearchingCode = new StatisticalSearchingCode();
statisticalSearchingCode.setCodeValue(strings[0]);
statisticalSearchingCode.setFullValue(strings[1]);
oleHoldings.setStatisticalSearchingCode(statisticalSearchingCode);
}
oleHoldings.setLocalPersistentLink(resultSet.getString("LOCAL_PERSISTENT_URI"));
oleHoldings.setSubscriptionStatus(resultSet.getString("SUBSCRIPTION_STATUS"));
oleHoldings.setInterLibraryLoanAllowed(Boolean.valueOf(resultSet.getString("ALLOW_ILL")));
coverageSet = new HashSet<>();
perpetualSet = new HashSet<>();
donorSet = new HashSet<>();
ExtentOfOwnership extentOfOwnership = new ExtentOfOwnership();
Coverages coverages = new Coverages();
PerpetualAccesses perpetualAccesses = new PerpetualAccesses();
extentOfOwnership.setCoverages(coverages);
extentOfOwnership.setPerpetualAccesses(perpetualAccesses);
oleHoldings.getExtentOfOwnership().add(extentOfOwnership);
}
holdings.setHoldingsType(holdingsType);
holdings.setId("who-" + id);
holdings.setContentObject(oleHoldings);
holdings.setCreatedBy(resultSet.getString("CREATED_BY"));
holdings.setCreatedOn(resultSet.getString("DATE_CREATED"));
if (resultSet.getString("STAFF_ONLY") != null) {
holdings.setStaffOnly(
(resultSet.getString("STAFF_ONLY").equalsIgnoreCase("Y")
? Boolean.TRUE
: Boolean.FALSE));
}
holdings.setUpdatedBy(resultSet.getString("UPDATED_BY"));
holdings.setUpdatedOn(resultSet.getString("DATE_UPDATED"));
holdings.setLastUpdated(resultSet.getString("DATE_UPDATED"));
uriSet = new HashSet<>();
noteSet = new HashSet<>();
linkSet = new HashSet<>();
List<Item> itemList = fetchItemForHoldings(Integer.parseInt(id));
holdingsTree.setHoldings(holdings);
holdingsTree.getItems().addAll(itemList);
map.put(id, holdingsTree);
holdingsTrees.add(holdingsTree);
}
if (StringUtils.isNotEmpty(holdingsType) && holdingsType.equalsIgnoreCase(PHoldings.PRINT)) {
if (uriSet.add(resultSet.getString("HOLDINGS_URI_ID"))) {
Uri uri = new Uri();
uri.setValue(resultSet.getString("TEXT"));
oleHoldings.getUri().add(uri);
}
ExtentOfOwnership extentOfOwnership = null;
if (extentOfOwnershipMap.containsKey(resultSet.getString("EXT_OWNERSHIP_ID"))) {
extentOfOwnership = extentOfOwnershipMap.get(resultSet.getString("EXT_OWNERSHIP_ID"));
} else {
extentOfOwnership = new ExtentOfOwnership();
if (StringUtils.isNotEmpty(resultSet.getString("EXT_OWNERSHIP_TYPE_ID"))) {
String[] strings =
extentOfOwnershipTypeMap
.get(resultSet.getString("EXT_OWNERSHIP_TYPE_ID"))
.split("[|]");
extentOfOwnership.setType(strings[1]);
}
extentOfOwnershipMap.put(resultSet.getString("EXT_OWNERSHIP_ID"), extentOfOwnership);
oleHoldings.getExtentOfOwnership().add(extentOfOwnership);
}
String extOwnershipNoteId = resultSet.getString("EXT_OWNERSHIP_NOTE_ID");
if (extentOfOwnershipNoteSet != null
&& StringUtils.isNotEmpty(extOwnershipNoteId)
&& extentOfOwnershipNoteSet.add(resultSet.getString("EXT_OWNERSHIP_NOTE_ID"))) {
Note note = new Note();
note.setValue(resultSet.getString(83));
note.setType(resultSet.getString(82));
extentOfOwnership.getNote().add(note);
}
} else {
if (linkSet.add(resultSet.getString("HOLDINGS_URI_ID"))) {
Link link = new Link();
link.setUrl(resultSet.getString("URI"));
link.setText(resultSet.getString("TEXT"));
oleHoldings.getLink().add(link);
}
if (oleHoldings.getExtentOfOwnership() != null
&& oleHoldings.getExtentOfOwnership().size() > 0) {
if (coverageSet != null && coverageSet.add(resultSet.getString("HOLDINGS_COVERAGE_ID"))) {
Coverage coverage = new Coverage();
coverage.setCoverageStartIssue(resultSet.getString("COVERAGE_START_ISSUE"));
coverage.setCoverageStartDate(resultSet.getString("COVERAGE_START_DATE"));
coverage.setCoverageStartVolume(resultSet.getString("COVERAGE_START_VOLUME"));
coverage.setCoverageEndIssue(resultSet.getString("HOLDINGS_COVERAGE_ID"));
coverage.setCoverageEndDate(resultSet.getString("COVERAGE_END_DATE"));
coverage.setCoverageEndVolume(resultSet.getString("COVERAGE_END_VOLUME"));
oleHoldings.getExtentOfOwnership().get(0).getCoverages().getCoverage().add(coverage);
}
if (perpetualSet != null
&& perpetualSet.add(resultSet.getString("HOLDINGS_PERPETUAL_ACCESS_ID"))) {
PerpetualAccess perpetualAccess = new PerpetualAccess();
perpetualAccess.setPerpetualAccessStartDate(
resultSet.getString("PERPETUAL_ACCESS_START_DATE"));
perpetualAccess.setPerpetualAccessStartIssue(
resultSet.getString("PERPETUAL_ACCESS_START_ISSUE"));
perpetualAccess.setPerpetualAccessStartVolume(
resultSet.getString("PERPETUAL_ACCESS_START_VOLUME"));
perpetualAccess.setPerpetualAccessEndDate(
resultSet.getString("PERPETUAL_ACCESS_END_DATE"));
perpetualAccess.setPerpetualAccessEndVolume(
resultSet.getString("PERPETUAL_ACCESS_END_VOLUME"));
perpetualAccess.setPerpetualAccessEndIssue(
resultSet.getString("PERPETUAL_ACCESS_END_ISSUE"));
oleHoldings
.getExtentOfOwnership()
.get(0)
.getPerpetualAccesses()
.getPerpetualAccess()
.add(perpetualAccess);
}
}
if (donorSet != null && donorSet.add(resultSet.getString("HOLDINGS_DONOR_ID"))) {
DonorInfo donorInfo = new DonorInfo();
donorInfo.setDonorCode(resultSet.getString("DONOR_CODE"));
donorInfo.setDonorNote(resultSet.getString("DONOR_NOTE"));
donorInfo.setDonorPublicDisplay(resultSet.getString("DONOR_DISPLAY_NOTE"));
oleHoldings.getDonorInfo().add(donorInfo);
}
}
if (noteSet.add(resultSet.getString("HOLDINGS_NOTE_ID"))) {
Note note = new Note();
note.setValue(resultSet.getString("NOTE"));
note.setType(resultSet.getString("TYPE"));
oleHoldings.getNote().add(note);
}
}
resultSet.close();
return holdingsTrees;
}