@Repository public interface MenuRepository extends org.springframework.data.jpa.repository.JpaRepository<Menu,java.lang.Integer>, VersionedContentRepository<Menu>
| Modifier and Type | Method and Description |
|---|---|
default void |
deleteByDocId(java.lang.Integer docId) |
void |
deleteByVersion(Version version) |
java.util.List<Menu> |
findByDocId(java.lang.Integer docId) |
Menu |
findByNoAndVersionAndFetchMenuItemsEagerly(java.lang.Integer menuNo,
Version version) |
java.util.List<Menu> |
findByVersion(Version version) |
java.util.List<Menu> |
getDocIdsByLinkedDocIdAndVersionNo(java.lang.Integer linkedDocId,
java.lang.Integer versionNo) |
deleteAllInBatch, deleteInBatch, findAll, findAll, findAll, findAll, findAll, flush, getOne, save, saveAndFlushfindAll@Query(value="select menu from Menu menu left join fetch menu.menuItems where menu.no = ?1 and menu.version = ?2") Menu findByNoAndVersionAndFetchMenuItemsEagerly(java.lang.Integer menuNo, Version version)
@Query(value="SELECT DISTINCT m FROM Menu m left join fetch m.menuItems WHERE m.version = ?1 GROUP BY m.id") java.util.List<Menu> findByVersion(Version version)
findByVersion in interface VersionedContentRepository<Menu>@Query(value="SELECT m.* FROM imcms_menu m WHERE doc_id = ?1",
nativeQuery=true)
java.util.List<Menu> findByDocId(java.lang.Integer docId)
default void deleteByDocId(java.lang.Integer docId)
@Modifying @Query(value="DELETE FROM Menu m WHERE m.version = ?1") void deleteByVersion(Version version)
@Query(value="SELECT menu FROM Menu menu INNER JOIN menu.menuItems item WHERE item.documentId = ?1 AND menu.version.no = ?2") java.util.List<Menu> getDocIdsByLinkedDocIdAndVersionNo(java.lang.Integer linkedDocId, java.lang.Integer versionNo)