@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); } }
public void setTransaction() throws IOException { Query query = em.createNamedQuery("EOrderQc.findByMaxId"); int eOrderId = (Integer) query.getResultList().get(0); long currentStock = 0; System.out.println("orderQcId++++++++ " + eOrderId); EOrderQc eOrderNew = eOrderQcFacade.find(eOrderId); transactionList = eTransactionFacade.findAll(); for (int k = 0; k < transactionList.size(); k++) { if ((transactionList.get(k).getEProduct().getId() == requestorder.getProductId()) && (transactionList.get(k).getESites().getId() == requestorder.getSiteId())) { currentStock = currentStock + transactionList.get(k).getStockDelta(); } } long updateStock = currentStock + eOrderNew.getQcQuantityAccepted(); long delta = updateStock - currentStock; ETransaction eTransaction = new ETransaction(); eTransaction.setReasonOfUpdate(eOrderNew.getEOrder().getOrderType()); eTransaction.setDateOfUpdate(eOrderNew.getDate()); eTransaction.setESites(eSitesFacade.find(requestorder.getSiteId())); eTransaction.setEProduct(eProductFacade.find(requestorder.getProductId())); eTransaction.setStockDelta(delta); eTransaction.setEOrder(eOrderNew.getEOrder()); eTransactionFacade.create(eTransaction); EOrder eOrder = new EOrder(); eOrder = eOrderNew.getEOrder(); eOrder.setStatus("QC_Respond"); eOrderFacade.edit(eOrder); // populate(); }