@PostConstruct
public void populate() {
orderList.clear();
list.clear();
employeeId = 0;
orderList =
em.createNamedQuery("EOrder.findByType&Status")
.setParameter("orderType", "Purchase")
.setParameter("status", "QC_Waiting")
.getResultList();
for (int i = 0; i < orderList.size(); i++) {
String prodCode = orderList.get(i).getEIntent().getProductCode();
int prodCatId = Integer.parseInt(prodCode.substring(0, prodCode.indexOf(".")));
int prodId = Integer.parseInt(prodCode.substring(prodCode.indexOf(".") + 1));
orderListClass = new OrderListClass();
orderListClass.setSiteId(orderList.get(i).getEIntent().getESites().getId());
orderListClass.setSiteName(eSitesFacade.find(orderListClass.getSiteId()).getName());
orderListClass.setProductCategoryId(prodCatId);
orderListClass.setProductCategoryName(eProductCategoryFacade.find(prodCatId).getName());
orderListClass.setProductId(prodId);
orderListClass.setProductName(eProductFacade.find(prodId).getName());
orderListClass.setOrderId(orderList.get(i).getId());
orderListClass.setOrderDate(dateFormat.format(orderList.get(i).getDate()));
orderListClass.setOrderQuantity(orderList.get(i).getProdQuantity());
orderListClass.setQuotationId(orderList.get(i).getSelectQuotationId());
orderListClass.setUnitPrice(
eQuotationFacade.find(orderListClass.getQuotationId()).getUnitPrice());
orderListClass.setVendorId(
eQuotationFacade.find(orderListClass.getQuotationId()).getEVendors().getId());
orderListClass.setVendorName(eVendorsFacade.find(orderListClass.getVendorId()).getVenName());
list.add(orderListClass);
}
}
