| | |
| | | package com.consum.base.core; |
| | | |
| | | import com.consum.base.core.po.WhFormInventory; |
| | | import com.consum.base.core.po.WhFormProcure; |
| | | import com.consum.base.core.po.WhFormTransfer; |
| | | import com.consum.base.core.tools.SqlParameter; |
| | | import com.consum.base.core.tools.SuperMap; |
| | | import com.consum.model.po.WhFormProcureModel; |
| | | import com.consum.model.po.*; |
| | | import com.walker.infrastructure.utils.NumberGenerator; |
| | | import com.walker.jdbc.service.BaseServiceImpl; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | /** |
| | | * 进出库 业务处 类 |
| | |
| | | param.setFirstInputCode(model.getId().toString()); |
| | | param.setFirst_input_type(1); |
| | | param.setModelId(model.getBaseGoodsModelsId()); |
| | | CheckWarehouseResult result = coreService.unifyCheck(param); |
| | | CheckWarehouseResult result = coreService.unifyCheck(param)[0]; |
| | | |
| | | |
| | | WhGoodsDetails details = new WhGoodsDetails(); |
| | | details.setId(result.getWhGoods().getFirstInputHisId()); |
| | | details.setBusinessFormId(procure.getId()); |
| | | details.setBusinessFormCode(procure.getBusinessFormCode()); |
| | | details.setBusinessFormName(procure.getWarehouseName() + "采购入库单:" + details.getBusinessFormCode()); |
| | | details.setInitialCount(result.getInitial_count()); |
| | | details.setThisType(1); |
| | | details.setEndCount(result.getEnd_count()); |
| | | details.setWarehouseId(param.getWarehouseId()); |
| | | details.setWarehouseName(procure.getWarehouseName()); |
| | | details.setClassification(1); |
| | | details.setOperatorId(procure.getOperatorId2()); |
| | | details.setOperatorName(procure.getOperatorName2()); |
| | | details.setDealTime(procure.getIncomeTime()); |
| | | details.setWhGoodsId(result.getWhGoods().getId()); |
| | | |
| | | this.insert(details); |
| | | |
| | | |
| | | model.setInWhGoodsDetailsId(details.getId()); |
| | | update(model); |
| | | |
| | | procure.setStates(2); |
| | | update(procure); |
| | | } |
| | | |
| | | |
| | | |
| | | } |
| | | |
| | | /** |
| | |
| | | * @param transfer |
| | | */ |
| | | public void doTransferOutPut(WhFormTransfer transfer){ |
| | | String sql = "SELECT\n" + |
| | | " * \n" + |
| | | "FROM\n" + |
| | | " WH_FORM_TRANSFER_GOODS A \n" + |
| | | "WHERE\n" + |
| | | " A.WH_FORM_TRANSFER_ID = : TRANSFER_ID"; |
| | | |
| | | List<WhFormTransferGoods> goodsList = this.select(sql,new SqlParameter() |
| | | .put("TRANSFER_ID",transfer.getId()),new WhFormTransferGoods()); |
| | | |
| | | for (WhFormTransferGoods goods : goodsList){ |
| | | CheckWarehouseParam param = new CheckWarehouseParam(); |
| | | param.setIsCheckIn(false); |
| | | param.setWarehouseId(transfer.getOutWarehouseId()); |
| | | param.setCount(goods.getCounts()); |
| | | CheckWarehouseResult[] results = coreService.unifyCheck(param); |
| | | for (CheckWarehouseResult result : results){ |
| | | WhFormTransferModel model = new WhFormTransferModel(); |
| | | model.setId(NumberGenerator.getLongSequenceNumber()); |
| | | model.setWhFormTransferId(transfer.getId()); |
| | | model.setWorehouseCount(result.getInitial_count()); |
| | | model.setCounts(result.getInitial_count() - result.getInitial_count()); |
| | | model.setOutWhGoodsDetailsId(result.getWhGoods().getId()); |
| | | model.setWhFormTransferGoodsId(goods.getId()); |
| | | insert(model); |
| | | |
| | | WhGoodsDetails details = new WhGoodsDetails(); |
| | | details.setBusinessFormId(transfer.getId()); |
| | | details.setBusinessFormCode(transfer.getBusinessFormCode()); |
| | | details.setBusinessFormName("调拨出库单:" + transfer.getBusinessFormCode()); |
| | | details.setInitialCount(result.getInitial_count()); |
| | | details.setThisType(2); |
| | | details.setThisCount(result.getInitial_count() - result.getEnd_count()); |
| | | details.setEndCount(result.getEnd_count()); |
| | | details.setWarehouseId(result.getWhGoods().getWarehouseId()); |
| | | details.setWarehouseName(result.getWhGoods().getWarehouseName()); |
| | | details.setClassification(5); |
| | | details.setOperatorId(transfer.getOperatorId()); |
| | | details.setOperatorName(transfer.getOperatorName()); |
| | | details.setDealTime(transfer.getOutputTime()); |
| | | details.setWhGoodsId(result.getWhGoods().getId()); |
| | | this.insert(details); |
| | | } |
| | | } |
| | | } |
| | | |
| | | /** |
| | |
| | | */ |
| | | public void doTransferInPut(WhFormTransfer transfer){ |
| | | |
| | | String sql = "SELECT\n" + |
| | | " * \n" + |
| | | "FROM\n" + |
| | | " WH_FORM_TRANSFER_GOODS A \n" + |
| | | "WHERE\n" + |
| | | " A.WH_FORM_TRANSFER_ID = : TRANSFER_ID"; |
| | | |
| | | List<WhFormTransferGoods> goodsList = this.select(sql,new SqlParameter() |
| | | .put("TRANSFER_ID",transfer.getId()),new WhFormTransferGoods()); |
| | | |
| | | } |
| | | |
| | | /** |