Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /**
- *
- */
- package org.jleaf.erp.inv.bo.returnnote;
- import java.util.Iterator;
- import java.util.List;
- import java.util.Map.Entry;
- import javax.persistence.Query;
- import org.jleaf.erp.inv.InventoryConstants;
- import org.jleaf.erp.inv.InventoryExceptionConstants;
- import org.jleaf.erp.inv.dao.BalanceDeliveryOrderItemDao;
- import org.jleaf.erp.inv.dao.InventoryDao;
- import org.jleaf.erp.inv.dao.InventoryItemDao;
- import org.jleaf.erp.inv.dao.ProductBalanceStockDao;
- import org.jleaf.erp.inv.entity.BalanceDeliveryOrderItem;
- import org.jleaf.erp.inv.entity.Inventory;
- import org.jleaf.erp.inv.entity.InventoryItem;
- import org.jleaf.erp.inv.entity.ProductBalanceStock;
- import org.jleaf.erp.purch.dao.PoBalanceItemConsignmentSoldManualDao;
- import org.jleaf.erp.purch.entity.PoBalanceItemConsignmentSoldManual;
- import org.jleaf.common.CommonExceptionConstants;
- import org.jleaf.core.BusinessFunction;
- import org.jleaf.core.BusinessTransaction;
- import org.jleaf.core.CoreException;
- import org.jleaf.core.DefaultBusinessTransaction;
- import org.jleaf.core.Dto;
- import org.jleaf.core.annotation.ErrorList;
- import org.jleaf.core.annotation.Info;
- import org.jleaf.core.annotation.InfoIn;
- import org.jleaf.core.annotation.InfoOut;
- import org.jleaf.core.dao.QueryBuilder;
- import org.jleaf.util.Calc;
- import org.jleaf.util.GsonUtil;
- import org.slf4j.Logger;
- import org.slf4j.LoggerFactory;
- import org.springframework.beans.factory.annotation.Autowired;
- import org.springframework.beans.factory.annotation.Qualifier;
- import org.springframework.stereotype.Service;
- //@formatter:off
- @Service("removeReturnNote")
- @InfoIn(value = {
- @Info(name = "id", description = "inventory id", type = Long.class),
- @Info(name = "tenantLoginId", description = "tenant login id", type = Long.class),
- @Info(name = "userLoginId", description = "user login id", type = Long.class),
- @Info(name = "roleLoginId", description = "role login id", type = Long.class),
- @Info(name = "datetime", description = "datetime", type = String.class)
- })
- @InfoOut(value = {
- })
- @ErrorList(errorKeys = {
- InventoryExceptionConstants.INVENTORY_ID_NOT_FOUND,
- InventoryExceptionConstants.DOC_ALREADY_SUBMITTED,
- CommonExceptionConstants.DATA_CANT_DELETE_CAUSE_TENANT,
- CommonExceptionConstants.TENANT_LOGIN_CANT_USED
- })
- //@formatter:on
- public class RemoveReturnNoteForCland extends DefaultBusinessTransaction implements BusinessTransaction {
- private static Logger log = LoggerFactory.getLogger(RemoveReturnNoteForCland.class);
- @Autowired
- private InventoryDao inventoryDao;
- @Autowired
- private InventoryItemDao inventoryItemDao;
- @Autowired
- private BalanceDeliveryOrderItemDao balanceDeliveryOrderItemDao;
- @Autowired
- private ProductBalanceStockDao productBalanceStockDao;
- @Autowired
- private PoBalanceItemConsignmentSoldManualDao poBalanceItemConsignmentSoldManualDao;
- @Autowired
- @Qualifier("getInventoryItemListByInventory")
- private BusinessFunction getInventoryItemListByInventory;
- @Autowired
- @Qualifier("findInventoryById")
- private BusinessFunction findInventoryById;
- @Autowired
- @Qualifier("findBalanceDeliveryOrderItemById")
- private BusinessFunction findBalanceDeliveryOrderItemById;
- @Autowired
- @Qualifier("findProductBalanceStockByIndex")
- private BusinessFunction findProductBalanceStockByIndex;
- @Autowired
- @Qualifier("valTenantLoginCanUse")
- private BusinessFunction valTenantLoginCanUse;
- @SuppressWarnings("unchecked")
- @Override
- public Dto prepare(Dto inputDto, Dto originalDto) throws Exception {
- // Validation tenant login id can be use
- Dto loginDto = new Dto();
- loginDto.put("tenantLoginId", inputDto.getLong("tenantLoginId"));
- loginDto.put("userLoginId", inputDto.getLong("userLoginId"));
- loginDto.put("roleLoginId", inputDto.getLong("roleLoginId"));
- valTenantLoginCanUse.execute(loginDto);
- // Get data header
- Dto inventoryDto = findInventoryById.execute(new Dto().put("id", inputDto.getLong("id")));
- // Check TenantId in return note must be equal with tenantLoginId
- if (!inventoryDto.getLong("tenantId").equals(inputDto.getLong("tenantLoginId"))) {
- throw new CoreException(CommonExceptionConstants.DATA_CANT_DELETE_CAUSE_TENANT, "Return Note");
- }
- if (!InventoryConstants.DRAFT_TRANSACTION.equals(inventoryDto.getString("statusDoc"))) {
- throw new CoreException(InventoryExceptionConstants.DOC_ALREADY_SUBMITTED);
- }
- inputDto.put("inventoryDto", inventoryDto);
- Dto itemListDto = getInventoryItemListByInventory.execute(new Dto().put("tenantId", inputDto.getLong("tenantLoginId")).put("inventoryId", inputDto.getLong("id")));
- List<Dto> inventoryItemList = itemListDto.getList("inventoryItemList");
- Dto balanceDeliveryOrderItemMap = new Dto();
- if (inventoryItemList != null && !inventoryItemList.isEmpty()) {
- for (Dto inventoryItemDto : inventoryItemList) {
- // Get data balance delivery order item, update status item
- Dto balanceDeliveryOrderItemDto = findBalanceDeliveryOrderItemById.execute(new Dto().put("deliveryOrderItemId", Long.valueOf(inventoryItemDto.get("refItemId").toString())));
- if (!balanceDeliveryOrderItemMap.containsKey(balanceDeliveryOrderItemDto.get("deliveryOrderItemId").toString())) {
- Calc qtyIntReturnAfterReturn = new Calc(balanceDeliveryOrderItemDto.getDouble("qtyIntReturn")).subtract(Double.valueOf(inventoryItemDto.getString("qtyRealization")));
- Calc ratio = new Calc(balanceDeliveryOrderItemDto.getDouble("qtyIntDlv")).divide(balanceDeliveryOrderItemDto.getDouble("qtyDlv"));
- Calc qtyReturnAfterReturn = qtyIntReturnAfterReturn.multiply(ratio);
- balanceDeliveryOrderItemDto.put("qtyIntReturn", qtyIntReturnAfterReturn.doubleValue());
- balanceDeliveryOrderItemDto.put("qtyReturn", qtyReturnAfterReturn.doubleValue());
- balanceDeliveryOrderItemDto.put("statusItem", InventoryConstants.RELEASED_TRANSACTION);
- this.prepareUpdateAudit(balanceDeliveryOrderItemDto, inputDto.getLong("userLoginId"), inputDto.getString("datetime"));
- balanceDeliveryOrderItemMap.put(balanceDeliveryOrderItemDto.get("deliveryOrderItemId").toString(), balanceDeliveryOrderItemDto);
- }
- }
- }
- inputDto.put("balanceDeliveryOrderItemMap", balanceDeliveryOrderItemMap);
- inputDto.put("inventoryItemList", inventoryItemList);
- return null;
- }
- @SuppressWarnings({ "rawtypes", "unchecked" })
- @Override
- public Dto process(Dto inputDto, Dto originalDto) throws Exception {
- Dto inventoryDto = inputDto.getDto("inventoryDto");
- List<Dto> inventoryItemList = inputDto.getList("inventoryItemList");
- QueryBuilder updatePurchaseOrderConsigmentSoldManual = new QueryBuilder();
- updatePurchaseOrderConsigmentSoldManual.add(" UPDATE ")
- .add(PoBalanceItemConsignmentSoldManual.TABLE_NAME).add(" A ")
- .add(" SET status_item = :RELEASED ")
- .add(" FROM ").add(InventoryItem.TABLE_NAME).add(" B ")
- .add(" JOIN ").add(Inventory.TABLE_NAME).add(" C ON B.inventory_id = C.inventory_id ")
- .add(" WHERE C.inventory_id = :inventoryId ")
- .add(" AND C.doc_type_id = :returnNoteDocumentId ")
- .add(" AND B.ref_doc_type_id = :deliveryDocumentId ")
- .add(" AND B.ref_id = A.do_id ")
- .add(" AND B.ref_item_id = A.do_item_id ");
- Query queryUpdatePurchaseOrderConsigmentSoldManual = poBalanceItemConsignmentSoldManualDao.createNativeQuery(updatePurchaseOrderConsigmentSoldManual.toString());
- queryUpdatePurchaseOrderConsigmentSoldManual.setParameter("inventoryId",inventoryDto.getLong("id"));
- queryUpdatePurchaseOrderConsigmentSoldManual.setParameter("returnNoteDocumentId", InventoryConstants.DOCUMENT_DELIVERY_ORDER);
- queryUpdatePurchaseOrderConsigmentSoldManual.setParameter("deliveryDocumentId", InventoryConstants.DOCUMENT_RETURN_NOTE);
- queryUpdatePurchaseOrderConsigmentSoldManual.setParameter("RELEASED", InventoryConstants.RELEASED_TRANSACTION);
- queryUpdatePurchaseOrderConsigmentSoldManual.executeUpdate();
- poBalanceItemConsignmentSoldManualDao.flush();
- inventoryDao.remove(inventoryDto.getLong("id"));
- for (Dto inventoryItemDto : inventoryItemList) {
- inventoryItemDao.remove(Long.valueOf(inventoryItemDto.get("id").toString()));
- }
- Dto balanceDeliveryOrderItemMap = inputDto.getDto("balanceDeliveryOrderItemMap");
- Iterator iteratorBalanceDeliveryOrderItem = balanceDeliveryOrderItemMap.entrySet().iterator();
- while (iteratorBalanceDeliveryOrderItem.hasNext()) {
- Entry entry = (Entry)iteratorBalanceDeliveryOrderItem.next();
- Dto balanceDeliveryOrderItemToUpdateDto = (Dto)entry.getValue();
- BalanceDeliveryOrderItem balanceDeliveryOrderItem = GsonUtil.fromDto(balanceDeliveryOrderItemToUpdateDto, BalanceDeliveryOrderItem.class);
- balanceDeliveryOrderItem = balanceDeliveryOrderItemDao.merge(balanceDeliveryOrderItemToUpdateDto.getLong("deliveryOrderItemId"), balanceDeliveryOrderItem);
- }
- return null;
- }
- public String getDescription() {
- return "remove return note";
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment