Query query = em.createQuery("from ShippingType where siteId = :siteId order by shippingTypeName");
query.setParameter("siteId", form.getSiteId());
Iterator<?> iterator = query.getResultList().iterator();
while (iterator.hasNext()) {
ShippingType shippingType = (ShippingType) iterator.next();
LabelValueBean bean = new LabelValueBean();
bean.setLabel(shippingType.getShippingTypeName());
bean.setValue(shippingType.getShippingTypeId().toString());
vector.add(bean);
}
LabelValueBean shippingTypes[] = new LabelValueBean[vector.size()];
vector.copyInto(shippingTypes);
form.setShippingTypes(shippingTypes);
vector = new Vector<LabelValueBean>();
query = em.createQuery("from CustomerClass where siteId = :siteId order by custClassId");
query.setParameter("siteId", form.getSiteId());
iterator = query.getResultList().iterator();
vector.add(new LabelValueBean("", ""));
while (iterator.hasNext()) {
CustomerClass customerClass = (CustomerClass) iterator.next();
LabelValueBean bean = new LabelValueBean();
bean.setLabel(customerClass.getCustClassName());
bean.setValue(customerClass.getCustClassId().toString());
vector.add(bean);
}
LabelValueBean customerClasses[] = new LabelValueBean[vector.size()];
vector.copyInto(customerClasses);
form.setCustomerClasses(customerClasses);
vector = new Vector<LabelValueBean>();
query = em.createQuery("from Template where siteId = :siteId and templateName = :templateName order by templateId");
query.setParameter("siteId", form.getSiteId());
query.setParameter("templateName", Constants.TEMPLATE_BASIC);
iterator = query.getResultList().iterator();
while (iterator.hasNext()) {
Template template = (Template) iterator.next();
LabelValueBean bean = new LabelValueBean(template.getTemplateName(),Format.getLong(template.getTemplateId()));
vector.add(bean);
}
query = em.createQuery("from Template where siteId = :siteId and templateName != :templateName order by templateId");
query.setParameter("siteId", form.getSiteId());
query.setParameter("templateName", Constants.TEMPLATE_BASIC);
iterator = query.getResultList().iterator();
while (iterator.hasNext()) {
Template template = (Template) iterator.next();
LabelValueBean bean = new LabelValueBean(template.getTemplateName(),Format.getLong(template.getTemplateId()));
vector.add(bean);
}
LabelValueBean templates[] = new LabelValueBean[vector.size()];
vector.copyInto(templates);
form.setTemplates(templates);
String sql = "";
sql = "from State state " +
"left join fetch state.country country " +
"where country.siteId = :siteId " +
"order by country.countryId, state.stateName";
query = em.createQuery(sql);
query.setParameter("siteId", form.getSiteId());
iterator = query.getResultList().iterator();
vector = new Vector<LabelValueBean>();
while (iterator.hasNext()) {
State state = (State) iterator.next();
LabelValueBean bean = new LabelValueBean(state.getStateName(), state.getStateCode());
vector.add(bean);
}
LabelValueBean states[] = new LabelValueBean[vector.size()];
vector.copyInto(states);
form.setStates(states);
vector = new Vector<LabelValueBean>();
query = em.createQuery("from Country where siteId = :siteId order by countryName");
query.setParameter("siteId", form.getSiteId());
iterator = query.getResultList().iterator();
while (iterator.hasNext()) {
Country country = (Country) iterator.next();
LabelValueBean bean = new LabelValueBean();
bean.setLabel(country.getCountryName());
bean.setValue(country.getCountryCode());
vector.add(bean);
}
LabelValueBean countries[] = new LabelValueBean[vector.size()];
vector.copyInto(countries);
form.setCountries(countries);
if (Format.isNullOrEmpty(form.getTabIndex())) {
form.setTabIndex("0");
}
vector = new Vector<LabelValueBean>();
vector.add(new LabelValueBean("", ""));
query = em.createQuery("from PaymentGateway where siteId = :siteId order by paymentGatewayName");
query.setParameter("siteId", form.getSiteId());
iterator = query.getResultList().iterator();
while (iterator.hasNext()) {
PaymentGateway paymentGateway = (PaymentGateway) iterator.next();
LabelValueBean bean = new LabelValueBean(paymentGateway.getPaymentGatewayName(), Format.getLong(paymentGateway.getPaymentGatewayId()));
vector.add(bean);
}
LabelValueBean paymentGateways[] = new LabelValueBean[vector.size()];
vector.copyInto(paymentGateways);
form.setPaymentGateways(paymentGateways);
vector = new Vector<LabelValueBean>();
vector.add(new LabelValueBean("", ""));
query = em.createQuery("from PaymentGateway where siteId = :siteId and paymentGatewayProvider = :paymentGatewayProvider order by paymentGatewayName");
query.setParameter("siteId", form.getSiteId());
query.setParameter("paymentGatewayProvider", PaymentExpressEngine.class.getSimpleName());
iterator = query.getResultList().iterator();
while (iterator.hasNext()) {
PaymentGateway paymentGateway = (PaymentGateway) iterator.next();
LabelValueBean bean = new LabelValueBean(paymentGateway.getPaymentGatewayName(), Format.getLong(paymentGateway.getPaymentGatewayId()));
vector.add(bean);
}
LabelValueBean payPalPaymentGateways[] = new LabelValueBean[vector.size()];
vector.copyInto(payPalPaymentGateways);
form.setPayPalPaymentGateways(payPalPaymentGateways);
vector = new Vector<LabelValueBean>();
query = em.createQuery("from SiteProfileClass siteProfileClass where siteProfileClass.site.siteId = :siteId order by siteProfileClassName");
query.setParameter("siteId", form.getSiteId());
iterator = query.getResultList().iterator();
while (iterator.hasNext()) {
SiteProfileClass siteProfileClass = (SiteProfileClass) iterator.next();
LabelValueBean bean = new LabelValueBean(siteProfileClass.getSiteProfileClassName(), Format.getLong(siteProfileClass.getSiteProfileClassId()));
vector.add(bean);
}
LabelValueBean siteProfileClasses[] = new LabelValueBean[vector.size()];
vector.copyInto(siteProfileClasses);
form.setSiteProfileClasses(siteProfileClasses);
vector = new Vector<LabelValueBean>();
query = em.createQuery("from SiteCurrencyClass siteCurrencyClass where siteCurrencyClass.site.siteId = :siteId order by siteCurrencyClassName");
query.setParameter("siteId", form.getSiteId());
iterator = query.getResultList().iterator();
while (iterator.hasNext()) {
SiteCurrencyClass siteCurrencyClass = (SiteCurrencyClass) iterator.next();
LabelValueBean bean = new LabelValueBean(siteCurrencyClass.getSiteCurrencyClassName(), Format.getLong(siteCurrencyClass.getSiteCurrencyClassId()));
vector.add(bean);
}
LabelValueBean siteCurrencyClasses[] = new LabelValueBean[vector.size()];
vector.copyInto(siteCurrencyClasses);
form.setSiteCurrencyClasses(siteCurrencyClasses);
/*
form.getSiteProfiles()[0].setActive(true);
form.getSiteCurrencies()[0].setActive(true);
*/
long time = (new Date()).getTime();
form.setRandom(String.valueOf(time));
Locale locales[] = Locale.getAvailableLocales();
Arrays.sort(locales, new LocaleComparator());
LabelValueBean beans[] = new LabelValueBean[locales.length];
for (int i = 0; i < locales.length; i++) {
String value = locales[i].getLanguage();
if (!Format.isNullOrEmpty(locales[i].getCountry())) {
value += "-" + locales[i].getCountry();
}
beans[i] = new LabelValueBean(locales[i].getDisplayName(), value);
}
form.setLocales(beans);
}