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