TQL - atributy
Last modified by Martin Mahr on 2024/10/21 22:21
public String workTypeId() {
return workAlias + ".work_type";
}
public String workTitleShow() {
return workAlias + ".title_show";
}
public String workPublisherPlaceShow() {
return workAlias + ".publisher_place_show";
}
public String workExternalVersion() {
return workAlias + ".external_version";
}
public String workMedium() {
return workAlias + ".medium";
}
public String workMediumNumeric() {
return workAlias + ".medium";
}
public String workAuthorShow() {
return workAlias + ".author_show";
}
public String workLocMark() {
return workAlias + ".loc_mark";
}
public String workSpecialString1() {
return workAlias + ".special_s_1";
}
public String workSpecialString2() {
return workAlias + ".special_s_2";
}
public String workSpecialString3() {
return workAlias + ".special_s_3";
}
public String workHarvestedSourceId() {
return workAlias + ".harvested_source";
}
public String workSpecialString4() {
return workAlias + ".special_s_4";
}
public String workSpecialString5() {
return workAlias + ".special_s_5";
}
public String workSpecialString6() {
return workAlias + ".special_s_6";
}
public String workId() {
return workAlias + ".id";
}
public String workDateCreated() {
return workAlias + ".date_created ";
}
public String workDateModified() {
return workAlias + ".date_modified ";
}
public String itemDateCreated() {
return itemAlias + ".date_created ";
}
public String itemIncrementalNumberValueShow() {
return itemIncrementalNumberAlias + ".value_show";
}
public String itemIncrementalNumberRoot() {
return itemIncrementalNumberAlias + ".root";
}
public String itemIncrementalNumberValue() {
return itemIncrementalNumberAlias + ".value";
}
public String itemLocMarkValueShow() {
return itemLocMarkAlias + ".value_show";
}
public String itemStoreMarkValueShow() {
return itemStoreMarkAlias + ".value_show";
}
public String itemBarcode() {
return itemAlias + ".barcode";
}
public String itemAcquisitionTypeId() {
return itemAlias + ".acquisition_type";
}
public String itemId() {
return itemAlias + ".id";
}
public String itemLocationId() {
return itemAlias + ".location";
}
@Deprecated
public String itemLocationCode() {
return null;
}
@Deprecated
public String userIsLibrary() {
return null;
}
@Deprecated
public String itemLocationExternalId() {
return null;
}
@Deprecated
public String itemLocationOwnerExternalId() {
return null;
}
public String itemSublocationId() {
return itemAlias + ".sublocation";
}
public String itemWriteOffListId() {
return itemAlias + ".write_off_list";
}
public String itemWriteOffReasonId() {
return itemAlias + ".write_off_reason";
}
public String itemBorrowCategoryId() {
return itemAlias + ".borrow_category";
}
public String itemBorrowCategoryExternalId() {
return itemAlias + ".external_id";
}
public String itemBookBindingId() {
return itemAlias + ".book_binding";
}
public String itemLocationName() {
return null;
}
public String itemType() {
return itemAlias + ".type";
}
public String itemLocationOwnerId() {
return itemAlias + ".location_owner";
}
public String itemThematicGroupId() {
return itemAlias + ".thematic_group";
}
public String itemActive() {
return itemAlias + ".active";
}
public String itemLibraryId() {
return itemAlias + ".library";
}
public String itemLibraryOwnerId() {
return itemAlias + ".library_owner";
}
public String itemCompound() {
return itemAlias + ".compound";
}
public String itemImportId() {
return itemAlias + ".import_id";
}
public String itemReceiptNumber() {
return itemAlias + ".receipt_number";
}
public String itemPeriodicalYear() {
return itemAlias + ".periodical_year";
}
public String itemPeriodicalRow() {
return itemAlias + ".periodical_row";
}
public String authorityHeadingType() {
return authorityHeadingAlias + ".heading_type";
}
@Deprecated
public String itemProposalToWriteOff() {
return null;
}
@Deprecated
public String workIsPeriodical() {
return null;
}
@Deprecated
public String userCategoryId() {
return null;
}
@Deprecated
public String userEducationLevelCode() {
return null;
}
@Deprecated
public String currentTime() {
return null;
}
@Deprecated
public String workTypeName() {
return null;
}
public String userId() {
return userAlias + ".id";
}
public String userLastname() {
return userAlias + ".lastname";
}
public String userFirstname() {
return userAlias + ".firstname";
}
public String userUsername() {
return userAlias + ".username";
}
public String userFullname() {
return userAlias + ".fullname";
}
public String userBeforeAddressPermanent() {
return userAlias + ".before_address_permanent";
}
public String userStreetNumberPermanent() {
return userAlias + ".street_number_permanent";
}
public String userCityPermanent() {
return userAlias + ".city_permanent";
}
public String userPostNumberPermanent() {
return userAlias + ".post_number_permanent";
}
public String userLocationForExchangesId() {
return userAlias + ".location_for_exchanges";
}
@Deprecated
public String currentDate() {
return null;
}
@Deprecated
public String userAge() {
return null;
}
@Deprecated
public String userDefaultDepartmentId() {
return null;
}
@Deprecated
public String userDefaultDepartmentShortcut() {
return null;
}
@Deprecated
public String userCategoryCode() {
return null;
}
@Deprecated
public String userIsSingle() {
return null;
}
@Deprecated
public String userIsPartnerWithValidRegistration() {
return null;
}
@Deprecated
public String userIsFamily() {
return null;
}
@Deprecated
public String userIsPartner() {
return null;
}
@Deprecated
public String userIsFamilyWithValidRegistration() {
return null;
}
@Deprecated
public String userElectronicBorrowingsCurrentMonthCount() {
return null;
}
@Deprecated
public String workHasSubfieldNameWithValue() {
return null;
}
public String nowAddMonths(int count) {
return "NOW() " + (count > 0 ? "+" : "-") + " '" + Math.abs(count) + " MONTHS'::INTERVAL";
}
public String workHasSubfieldValueInSubfieldIds(String value, Integer... ids) {
String idsStr = Arrays.stream(ids)
.map(id -> id.toString())
.collect(Collectors.joining(", "));
return workDataAlias + ".subfield_definition IN (" + idsStr + ") AND " + workDataAlias + ".value_root = '" + value + "'";
}
public String userHasSubfieldValueInSubfieldId(String value, int id) {
return userDataAlias + ".subfield_definition = " + id + " AND " + userDataAlias + ".value_root = '" + value + "'";
}
@Deprecated
public String userElectronicBorrowingsCount() {
return null;
}
@Deprecated
public String itemHasSubfieldNameWithValue() {
return null;
}
@Deprecated
public String userReaderNumberValue() {
return null;
}
public String linkageRelationId() {
return linkageRelationAlias + "." + "id";
}
public String periodicalSheetId() {
return periodicalSheetAlias + "." + "id";
}
public String invoiceItemId() {
return invoiceItemAlias + "." + "id";
}
public String invoiceItemDefinitionId() {
return invoiceItemDefinitionAlias + "." + "id";
}
public String orderItemThematicGroupId() {
return orderItemAlias + "." + "thematic_group";
}
public String orderItemAcquisitionTypeId() {
return orderItemAlias + "." + "acquisition_type";
}
public String orderItemInLocationLocationId() {
return orderItemInLocationAlias + "." + "location";
}
public String userProfessionId() {
return userAlias + ".profession";
}
public String itemPrice() {
return itemAlias + ".price";
}
@Deprecated
public String userProfessionKey() {
return null;
}
@Deprecated
public String itemBorrowCategoryName() {
return null;
}
public String userSchoolId() {
return userAlias + ".school";
}
public String userEmail() {
return userAlias + ".email";
}
public String userPhone() {
return userAlias + ".phone";
}
public String userNote() {
return null;
}
public String workLanguage() {
return workAlias + ".language_work";
}
public String userDefaultGroupId() {
return userAlias + ".default_group";
}
public String itemNote() {
return itemAlias + ".note";
}
public String userCategoryType() {
return null;
}
public String userCautionNote() {
return userAlias + ".caution_note";
}
public String userIdentityCardNumber() {
return userAlias + ".identity_card_number";
}
public String workSpecialInt1() {
return workAlias + ".special_i_1";
}
public String workSpecialInt2() {
return workAlias + ".special_i_2";
}
public String workSpecialInt3() {
return workAlias + ".special_i_3";
}
public String itemWorkId() {
return itemAlias + ".work";
}
@Deprecated
public String userProfessionCode() {
return null;
}
@Deprecated
public String itemThematicGroupExternalId() {
return null;
}
public String itemUserDeletedId() {
return itemAlias + ".user_deleted";
}
@Deprecated
public String isUserVisitCountLimitExceed() {
return null;
}
@Deprecated
public String isShowUserVisitCountWarning() {
return null;
}
@Deprecated
public String loggedUserId() {
return null;
}
@Deprecated
public String existsReservation() {
return null;
}
@Deprecated
public String isFamilyOrPartnerOfSizeWithChildCount() {
return null;
}
@Deprecated
public String isAfterInCurrentYear() {
return null;
}
@Deprecated
public String isBeforeInCurrentYear() {
return null;
}
@Deprecated
public String hasUserNoActiveRegistrationInHisDefaultDepartment() {
return null;
}
@Deprecated
public String isAfter() {
return null;
}
@Deprecated
public String isBefore() {
return null;
}
@Deprecated
public String userAgeInCurrentYear() {
return null;
}
@Deprecated
public String hasUserActiveRegistrationInCurrentDepartment() {
return null;
}
@Deprecated
public String userDebt() {
return null;
}