1
2
3
4 package de.tivsource.page.dao.menuentry;
5
6 import java.util.List;
7
8 import javax.ejb.Stateless;
9 import javax.persistence.EntityManager;
10 import javax.persistence.PersistenceContext;
11 import javax.persistence.Query;
12
13 import org.apache.logging.log4j.LogManager;
14 import org.apache.logging.log4j.Logger;
15
16 import de.tivsource.page.common.menuentry.MenuEntry;
17
18
19
20
21
22 @Stateless
23 public class MenuEntryDao implements MenuEntryDaoLocal {
24
25
26
27 private static final Logger LOGGER = LogManager.getLogger(MenuEntryDao.class);
28
29
30
31
32 @PersistenceContext
33 private EntityManager entityManager;
34
35
36
37
38 @SuppressWarnings("unchecked")
39 @Override
40 public List<MenuEntry> findAllTopNavigation() {
41 LOGGER.info("findAllTopNavigation() aufgerufen");
42 Query query = entityManager.createQuery(
43 "from MenuEntry me where me.topNavigation = 'Y' "
44 + "and me.visible = 'Y' "
45 + "order by me.topNavigationOrder asc"
46 );
47 return query.getResultList();
48 }
49
50
51
52
53 @SuppressWarnings("unchecked")
54 @Override
55 public List<MenuEntry> findAllNavigation() {
56 LOGGER.info("findAllNavigation() aufgerufen");
57 Query query = entityManager.createQuery(
58 "from MenuEntry me where me.navigation = 'Y' "
59 + "and me.visible = 'Y' "
60 + "order by me.navigationOrder asc"
61 );
62 return query.getResultList();
63 }
64
65
66
67
68 @SuppressWarnings("unchecked")
69 @Override
70 public List<MenuEntry> findAllBottomNavigation() {
71 LOGGER.info("findAllBottomNavigation() aufgerufen");
72 Query query = entityManager.createQuery(
73 "from MenuEntry me where me.bottomNavigation = 'Y' "
74 + "and me.visible = 'Y' "
75 + "order by me.bottomNavigationOrder asc"
76 );
77 return query.getResultList();
78 }
79
80
81
82
83 @SuppressWarnings("unchecked")
84 @Override
85 public List<MenuEntry> findAllResponsiveNavigation() {
86 LOGGER.info("findAllResponsiveNavigation() aufgerufen");
87 Query query = entityManager.createQuery(
88 "from MenuEntry me where me.responsiveNavigation = 'Y' "
89 + "and me.visible = 'Y' "
90 + "order by me.responsiveNavigationOrder asc"
91 );
92 return query.getResultList();
93 }
94
95 }