public InfoPermission findById(ScrollableSettings settings) { InfoPermission item = em.find(InfoPermission.class, settings.getId()); if (item != null) { if (settings.getList().size() > 0) { item.customInit(item, settings.getList()); } if (settings.getInitDicts()) { item.initDicts(); } if (settings.getInitLists()) { item.initList(); } try { item.specialInit(); } catch (Exception e) { e.printStackTrace(); } } return item; }
public ShopRoomTarriffCorporateRateView findById(ScrollableSettings settings) { ShopRoomTarriffCorporateRateView item = em.find(ShopRoomTarriffCorporateRateView.class, settings.getId()); if (item != null) { if (settings.getList().size() > 0) { item.customInit(item, settings.getList()); } if (settings.getInitDicts()) { item.initDicts(); } if (settings.getInitLists()) { item.initList(); } try { item.specialInit(); } catch (Exception e) { e.printStackTrace(); } } return item; }
@SuppressWarnings("unchecked") public List<ShopRoomTarriffCorporateRateView> findAllScrollable(ScrollableSettings settings) { List<ShopRoomTarriffCorporateRateView> shoproomtarriffcorporaterateviews = DaoUtil.sasQuery(selectClause, settings, ShopRoomTarriffCorporateRateView.class, em) .setFirstResult((settings.getPageNumber() - 1) * settings.getPageSize()) .setMaxResults(settings.getPageSize()) .getResultList(); if (settings.getList().size() > 0) { for (ShopRoomTarriffCorporateRateView item : shoproomtarriffcorporaterateviews) { item.customInit(item, settings.getList()); } } if (settings.getInitLists() || settings.getInitDicts()) { for (ShopRoomTarriffCorporateRateView item : shoproomtarriffcorporaterateviews) { if (settings.getInitDicts()) { item.initDicts(); } if (settings.getInitLists()) { item.initList(); } } } return shoproomtarriffcorporaterateviews; }
@SuppressWarnings("unchecked") public List<InfoPermission> findAllScrollable(ScrollableSettings settings) { List<InfoPermission> infopermissions = DaoUtil.sasQuery(selectClause, settings, InfoPermission.class, em) .setFirstResult((settings.getPageNumber() - 1) * settings.getPageSize()) .setMaxResults(settings.getPageSize()) .getResultList(); if (settings.getList().size() > 0) { for (InfoPermission item : infopermissions) { item.customInit(item, settings.getList()); } } if (settings.getInitLists() || settings.getInitDicts()) { for (InfoPermission item : infopermissions) { if (settings.getInitDicts()) { item.initDicts(); } if (settings.getInitLists()) { item.initList(); } } } return infopermissions; }
@SuppressWarnings("unchecked") public List<ShopRoomTarriffCorporateRateView> search(ScrollableSettings settings) { if (settings.getFilter() == null || settings.getFilter().replaceAll("\\s+", "").length() == 0) { return new ArrayList<ShopRoomTarriffCorporateRateView>(); } FindByExample findByExample = DaoUtil.search( new ShopRoomTarriffCorporateRateView(), settings.getFilter(), ShopRoomTarriffCorporateRateView.class, em); Query query = null; if (findByExample.getIsNativeQuery()) { String queryString = DaoUtil.sasQueryRaw( findByExample.getSelectClause(), settings, ShopRoomTarriffCorporateRateView.class, em); query = em.createNativeQuery( queryString .replace("SELECT " + shortName, "SELECT *") .replace( className, DaoUtil.readTableName(ShopRoomTarriffCorporateRateView.class)), ShopRoomTarriffCorporateRateView.class); if (queryString.contains(":firmid")) { query.setParameter("firmid", settings.getSasUser().getUser().getFirmid()); } else if (queryString.contains(":firm")) { query.setParameter("firm", settings.getSasUser().getUser().getFirmid()); } } else { query = DaoUtil.sasQuery( findByExample.getSelectClause(), settings, ShopRoomTarriffCorporateRateView.class, em); } query.setParameter("filter", findByExample.getFilter()); if (findByExample.getSelectClause().contains("filterForInteger")) { query.setParameter("filterForInteger", findByExample.getFilterForInteger()); } return query.setMaxResults(100).getResultList(); }
public Integer todayNumber(ScrollableSettings settings) throws Exception { String today = new SimpleDateFormat("YYYY-MM-dd").format(new Date()); Query query = em.createNativeQuery( String.format( "SELECT count(*) from %s %s WHERE %s.firmid = %s and CAST(%s.createon as DATE) = CAST('%s' as DATE)", tableName, shortName, shortName, settings.getSasUser().getUser().getFirmid(), shortName, today)); return ((BigInteger) query.getSingleResult()).intValue(); }
public List<InfoPermission> namedFilter(ScrollableSettings settings) { List<InfoPermission> infopermissions = new ArrayList<InfoPermission>(); try { infopermissions = DaoUtil.sasQueryByNamedFilter( NamedFilter.Items.byName(settings.getNamedfilter(), InfoPermission.class), settings, InfoPermission.class, em) .getResultList(); } catch (Exception e) { e.printStackTrace(); } return infopermissions; }
public List<ShopRoomTarriffCorporateRateView> namedFilter(ScrollableSettings settings) { List<ShopRoomTarriffCorporateRateView> shoproomtarriffcorporaterateviews = new ArrayList<ShopRoomTarriffCorporateRateView>(); try { shoproomtarriffcorporaterateviews = DaoUtil.sasQueryByNamedFilter( NamedFilter.Items.byName( settings.getNamedfilter(), ShopRoomTarriffCorporateRateView.class), settings, ShopRoomTarriffCorporateRateView.class, em) .getResultList(); } catch (Exception e) { e.printStackTrace(); } return shoproomtarriffcorporaterateviews; }