TQL - atributy
Naposledy změněno Martin Mahr 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; }