TQL - atributy

Last modified by Jan Šimeček on 2024/07/16 13:10

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