@Override
public void addNamedQuery(String name, Query query) {
validateNotClosed();
// NOTE : we use Query#unwrap here (rather than direct type checking) to account for possibly
// wrapped
// query implementations
// first, handle StoredProcedureQuery
try {
final StoredProcedureQueryImpl unwrapped = query.unwrap(StoredProcedureQueryImpl.class);
if (unwrapped != null) {
addNamedStoredProcedureQuery(name, unwrapped);
return;
}
} catch (PersistenceException ignore) {
// this means 'query' is not a StoredProcedureQueryImpl
}
// then try as a native-SQL or JPQL query
try {
final HibernateQuery unwrapped = query.unwrap(HibernateQuery.class);
if (unwrapped != null) {
// create and register the proper NamedQueryDefinition...
final org.hibernate.Query hibernateQuery = ((HibernateQuery) query).getHibernateQuery();
if (org.hibernate.SQLQuery.class.isInstance(hibernateQuery)) {
sessionFactory.registerNamedSQLQueryDefinition(
name, extractSqlQueryDefinition((org.hibernate.SQLQuery) hibernateQuery, name));
} else {
sessionFactory.registerNamedQueryDefinition(
name, extractHqlQueryDefinition(hibernateQuery, name));
}
return;
}
} catch (PersistenceException ignore) {
// this means 'query' is not a native-SQL or JPQL query
}
// if we get here, we are unsure how to properly unwrap the incoming query to extract the needed
// information
throw new PersistenceException(
String.format(
"Unsure how to how to properly unwrap given Query [%s] as basis for named query",
query));
}
@SuppressWarnings("unchecked")
public List<EventDto> findAllEvent(
UserInfo userInfo,
Boolean publicFlag,
Boolean partyCodeFlag,
Boolean roleFlag,
boolean past) {
logger.infoCode("I0001");
String partyCode = null;
String roleCode = null;
StringBuilder sb = new StringBuilder();
sb.append("SELECT");
sb.append(" A.EVENT_KEY");
sb.append(" , A.EVENT_TITLE");
sb.append(" , A.EVENT_SEND_DATE");
sb.append(" , A.EVENT_RECRUIT");
sb.append(" , A.EVENT_TELNO");
sb.append(" , A.PARTY_CODE");
sb.append(" , A.PARTY_NAME");
sb.append(" , A.EVENT_START_DATE");
sb.append(" , A.EVENT_PLACE");
sb.append(" , A.EVENT_MEMO");
sb.append(" , A.EVENT_UNIT");
sb.append(" , A.SUBJECT_INS_KBN");
sb.append(" , A.PUBLIC_FLAG");
sb.append(" , A.UPD_DATE");
sb.append(" , A.UPD_USER_KEY");
sb.append(" , ARRAY_TO_STRING(ARRAY_AGG(C.PARTY_NAME), ',') AS PARTY_NAME");
sb.append(" , ARRAY_TO_STRING(ARRAY_AGG(C.PARTY_NAME_EN), ',') AS PARTY_NAME_EN");
sb.append(" FROM");
sb.append(" EV_EVENT_TBL A ");
sb.append(" INNER JOIN EV_EVENT_PUBLIC_TBL B ");
sb.append(" ON A.EVENT_KEY = B.EVENT_KEY ");
sb.append(" INNER JOIN MS_PARTY_TBL C ");
sb.append(" ON B.PARTY_CODE = C.PARTY_CODE ");
sb.append(" WHERE");
if (past) {
sb.append(" CURRENT_DATE < A.EVENT_START_DATE ");
} else {
sb.append(" CURRENT_DATE >= A.EVENT_START_DATE ");
sb.append(" AND CURRENT_DATE <= A.EVENT_SEND_DATE ");
}
if (publicFlag) {
sb.append(" AND A.PUBLIC_FLAG = '1' ");
}
if (partyCodeFlag) {
sb.append(" AND (B.PARTY_CODE = :partyCode ");
sb.append(" OR");
sb.append(" A.PARTY_CODE = :partyCode )");
}
if (roleFlag) {
sb.append(" AND (B.ROLE = :role ");
sb.append(" OR");
sb.append(" A.PARTY_CODE = :partyCode )");
}
sb.append(" GROUP BY");
sb.append(" A.EVENT_KEY");
sb.append(" , A.EVENT_TITLE");
sb.append(" , A.EVENT_SEND_DATE");
sb.append(" , A.EVENT_RECRUIT");
sb.append(" , A.EVENT_TELNO");
sb.append(" , A.PARTY_CODE");
sb.append(" , A.PARTY_NAME");
sb.append(" , A.EVENT_START_DATE");
sb.append(" , A.EVENT_PLACE");
sb.append(" , A.EVENT_MEMO");
sb.append(" , A.EVENT_UNIT");
sb.append(" , A.SUBJECT_INS_KBN");
sb.append(" , A.PUBLIC_FLAG");
sb.append(" , A.UPD_DATE");
sb.append(" , A.UPD_USER_KEY");
sb.append(" ORDER BY");
sb.append(" A.EVENT_SEND_DATE DESC");
String sql = sb.toString();
Query query = entityManager.createNativeQuery(sql);
query.unwrap(SQLQuery.class).setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP);
if (partyCodeFlag) {
query.setParameter("partyCode", userInfo.getTargetPartyCode());
}
if (roleFlag) {
query.setParameter("partyCode", userInfo.getTargetPartyCode());
query.setParameter("role", userInfo.getTargetRole());
}
List<EventDto> list = new ArrayList<>();
List<Map> resultList = new ArrayList<>();
resultList = query.getResultList();
for (int i = 0; i < resultList.size(); i++) {
EventDto dto = new EventDto();
dto = (EventDto) objectUtil.setMapCopyValue(dto, resultList.get(i));
list.add(dto);
}
logger.infoCode("I0002");
return list;
}
