just a single find method in hs-office-membership repo

Michael Hoennig

2022-10-18 0232ff078d6274dbe10dccd82dfeea92d1f992b4

just a single find method in hs-office-membership repo

 src/main/java/net/hostsharing/hsadminng/hs/office/membership/HsOfficeMembershipRepository.java

@@ -13,13 +13,12 @@

    @Query("""
            SELECT membership FROM HsOfficeMembershipEntity membership
                WHERE :memberNumber is null
                    OR membership.memberNumber = :memberNumber
                WHERE (:memberNumber is null OR membership.memberNumber = :memberNumber)
                    AND ( CAST(:partnerUuid as org.hibernate.type.UUIDCharType) IS NULL
                         OR membership.partner.uuid = :partnerUuid )
                ORDER BY membership.memberNumber
               """)
    List<HsOfficeMembershipEntity> findMembershipByOptionalMemberNumber(Integer memberNumber);

    List<HsOfficeMembershipEntity> findMembershipsByPartnerUuid(UUID partnerUuid);
    List<HsOfficeMembershipEntity> findMembershipsByOptionalPartnerUuidAndOptionalMemberNumber(UUID partnerUuid, Integer memberNumber);

    HsOfficeMembershipEntity save(final HsOfficeMembershipEntity entity);