public void extract(AdminListingActionForm actionForm, HttpServletRequest request)
throws Throwable {
EntityManager em = JpaConnection.getInstance().getCurrentEntityManager();
SiteCurrencyClassListingActionForm form = (SiteCurrencyClassListingActionForm) actionForm;
Site site = getAdminBean(request).getSite();
Query query = null;
String sql =
"select siteCurrencyClass "
+ "from SiteCurrencyClass siteCurrencyClass "
+ "where siteCurrencyClass.site.siteId = :siteId ";
if (!Format.isNullOrEmpty(form.getSrSiteCurrencyClassName())) {
sql += "and siteCurrencyClassName like :siteCurrencyClassName ";
}
query = em.createQuery(sql);
query.setParameter("siteId", site.getSiteId());
if (!Format.isNullOrEmpty(form.getSrSiteCurrencyClassName())) {
query.setParameter("siteCurrencyClassName", form.getSrSiteCurrencyClassName());
}
Iterator<?> iterator = query.getResultList().iterator();
Vector<SiteCurrencyClassDisplayForm> vector = new Vector<SiteCurrencyClassDisplayForm>();
while (iterator.hasNext()) {
SiteCurrencyClass siteCurrencyClass = (SiteCurrencyClass) iterator.next();
SiteCurrencyClassDisplayForm siteCurrencyClassDisplay = new SiteCurrencyClassDisplayForm();
siteCurrencyClassDisplay.setSiteCurrencyClassId(
siteCurrencyClass.getSiteCurrencyClassId().toString());
siteCurrencyClassDisplay.setSiteCurrencyClassName(
siteCurrencyClass.getSiteCurrencyClassName());
String localeName =
getLocaleName(
siteCurrencyClass.getCurrencyLocaleLanguage(),
siteCurrencyClass.getCurrencyLocaleCountry());
siteCurrencyClassDisplay.setLocaleName(localeName);
siteCurrencyClassDisplay.setSystemRecord(String.valueOf(siteCurrencyClass.getSystemRecord()));
vector.add(siteCurrencyClassDisplay);
}
SiteCurrencyClassDisplayForm siteCurrencyClasses[] =
new SiteCurrencyClassDisplayForm[vector.size()];
vector.copyInto(siteCurrencyClasses);
form.setSiteCurrencyClasses(siteCurrencyClasses);
}
