| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705 |
- package com.dk.mdm.service.ivt.outbound;
- import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
- import com.dk.common.exception.BaseBusinessException;
- import com.dk.common.infrastructure.annotaiton.Pagination;
- import com.dk.common.infrastructure.constant.Constant;
- import com.dk.common.infrastructure.enums.ErrorCodeEnum;
- import com.dk.common.mapper.BaseMapper;
- import com.dk.common.model.pojo.PageList;
- import com.dk.common.response.ResponseCodeEnum;
- import com.dk.common.response.ResponseResultUtil;
- import com.dk.common.response.ResponseResultVO;
- import com.dk.common.service.BaseService;
- import com.dk.mdm.infrastructure.convert.ivt.InboundConvert;
- import com.dk.mdm.infrastructure.convert.ivt.InboundItemConvert;
- import com.dk.mdm.infrastructure.convert.ivt.OutboundConvert;
- import com.dk.mdm.infrastructure.convert.ivt.OutboundItemConvert;
- import com.dk.mdm.mapper.common.CommonMapper;
- import com.dk.mdm.mapper.ivt.InboundItemMapper;
- import com.dk.mdm.mapper.ivt.InboundMapper;
- import com.dk.mdm.mapper.ivt.OutboundItemMapper;
- import com.dk.mdm.mapper.ivt.OutboundMapper;
- import com.dk.mdm.mapper.mst.CustomerMapper;
- import com.dk.mdm.mapper.sale.MultiOwnerMapper;
- import com.dk.mdm.mapper.sale.OrderItemMapper;
- import com.dk.mdm.mapper.sale.OrderMapper;
- import com.dk.mdm.model.pojo.ivt.Inbound;
- import com.dk.mdm.model.pojo.ivt.InboundItem;
- import com.dk.mdm.model.pojo.ivt.Outbound;
- import com.dk.mdm.model.pojo.ivt.OutboundItem;
- import com.dk.mdm.model.pojo.mst.Customer;
- import com.dk.mdm.model.pojo.pur.Purchase;
- import com.dk.mdm.model.pojo.pur.PurchaseItem;
- import com.dk.mdm.model.pojo.sale.MultiOwner;
- import com.dk.mdm.model.pojo.sale.Order;
- import com.dk.mdm.model.pojo.sale.OrderItem;
- import com.dk.mdm.model.query.ivt.OutboundItemQuery;
- import com.dk.mdm.model.query.ivt.OutboundQuery;
- import com.dk.mdm.model.query.sale.OrderQuery;
- import com.dk.mdm.model.response.ivt.InboundResponse;
- import com.dk.mdm.model.response.ivt.OutboundItemResponse;
- import com.dk.mdm.model.response.ivt.OutboundResponse;
- import com.dk.mdm.model.response.pur.PurchaseItemResponse;
- import com.dk.mdm.model.response.pur.PurchaseResponse;
- import com.dk.mdm.model.response.sale.OrderItemResponse;
- import com.dk.mdm.model.response.sale.OrderResponse;
- import com.dk.mdm.model.vo.ivt.InboundItemVO;
- import com.dk.mdm.model.vo.ivt.InboundVO;
- import com.dk.mdm.model.vo.ivt.OutboundItemVO;
- import com.dk.mdm.model.vo.ivt.OutboundVO;
- import com.dk.mdm.model.vo.mac.RecPayVO;
- import com.dk.mdm.service.common.CommonService;
- import com.dk.mdm.service.ivt.inventory.InventoryService;
- import com.dk.mdm.service.mac.AccountService;
- import com.dk.mdm.service.mac.ReceiptService;
- import org.springframework.beans.factory.annotation.Autowired;
- import org.springframework.stereotype.Service;
- import org.springframework.transaction.annotation.Transactional;
- import java.math.BigDecimal;
- import java.time.LocalDate;
- import java.util.HashMap;
- import java.util.List;
- import java.util.Map;
- import java.util.UUID;
- import java.util.stream.Collectors;
- /**
- * @author : 寇珊珊
- * @desc : 销售出库业务层
- * @date : 2024/3/18 15:33
- */
- @Service
- public class OutboundSaleOrderService extends BaseService<Outbound> {
- @Override
- public BaseMapper<Outbound> getRepository() {
- return outboundMapper;
- }
- @Autowired
- private CommonService commonService;
- @Autowired
- private OutboundMapper outboundMapper;
- @Autowired
- private OutboundConvert outboundConvert;
- @Autowired
- private OutboundItemMapper outboundItemMapper;
- @Autowired
- private OutboundItemConvert outboundItemConvert;
- @Autowired
- private OrderMapper orderMapper;
- @Autowired
- private OrderItemMapper orderItemMapper;
- @Autowired
- private CommonMapper commonMapper;
- @Autowired
- private InventoryService inventoryService;
- @Autowired
- private AccountService accountService;
- @Autowired
- private OutCommon outCommon;
- @Autowired
- private InboundMapper inboundMapper;
- @Autowired
- private InboundConvert inboundConvert;
- @Autowired
- private InboundItemMapper inboundItemMapper;
- @Autowired
- private InboundItemConvert inboundItemConvert;
- @Autowired
- private ReceiptService receiptService;
- /**
- * @desc : 删除外协品生产外协入库单
- * @date : 2024/5/10 10:31
- * @author : 寇珊珊
- */
- @Transactional(rollbackFor = {Exception.class})
- public void deleteOutsideGoodsInto(OutboundVO outboundVO, List<OutboundItemVO> outboundItemVOList) {
- if (outboundItemVOList != null && outboundItemVOList.size() > 0) {
- //根据出库单id分组
- Map<String, List<OutboundItemVO>> outboundItemVOMap = outboundItemVOList.stream().collect(Collectors.groupingBy(OutboundItemVO::getOutId));
- for (String str : outboundItemVOMap.keySet()) {
- InboundResponse inboundResponse = inboundMapper.selectByFromId(str);
- // 退账
- if (inboundResponse != null && inboundResponse.getReceivableId() != null) {
- accountService.reversePayable(inboundResponse.getIntoId(), Constant.InventoryDocCode.INTOBOUND.getTableName());
- }
- }
- //删除外协入库单
- //外协入库总单
- inboundMapper.deleteByFromId(outboundItemVOList.get(0).getOutId());
- //外协入库明细
- inboundItemMapper.deleteItemByFromId(outboundItemVOList.get(0).getOutId());
- }
- }
- /**
- * @desc : 新建外协品生产外协入库单
- * @date : 2024/5/10 10:31
- * @author : 寇珊珊
- */
- @Transactional(rollbackFor = {Exception.class})
- public void insertOutsideGoodsInto(OutboundVO outboundVO, List<OutboundItemVO> outboundItemVOList) {
- if (outboundItemVOList != null && outboundItemVOList.size() > 0) {
- Map<String, List<OutboundItemVO>> outboundItemVOMap = outboundItemVOList.stream().collect(Collectors.groupingBy(OutboundItemVO::getOutId));
- for (String str : outboundItemVOMap.keySet()) {
- //提取分组后的明细
- List<OutboundItemVO> outboundItemVOListGroup = outboundItemVOMap.get(str);
- //region 新建总单
- //已入库金额
- BigDecimal sumIntoAmt = outboundItemVOListGroup.stream().map(OutboundItemVO::getOutAmt).reduce(BigDecimal.ZERO, BigDecimal::add).setScale(2, BigDecimal.ROUND_HALF_UP);
- //已入库数量
- BigDecimal sumIntoQty = outboundItemVOListGroup.stream().map(OutboundItemVO::getOutQty).reduce(BigDecimal.ZERO, BigDecimal::add).setScale(2, BigDecimal.ROUND_HALF_UP);
- //总单实体
- InboundVO inboundVO = new InboundVO();
- //获取 id/单号
- Map<String, Object> codeMap = commonService.getUniqueNoteCode(Constant.docNameConstant.OUTSOURCED.getName(), false);
- inboundVO.setIntoId(codeMap.get("outId").toString()).
- setIntoNo(codeMap.get("outNote").toString());
- //入库类型
- inboundVO.setIntoType(Constant.IntoType.OUTSOURCED.getName());
- //已入库
- inboundVO.setIntoStatus(Constant.IntoStatus.YIRUKU.getName());
- //供应商
- inboundVO.setSupId(outboundItemVOListGroup.get(0).getSupId());
- //入库状态等于已入库
- inboundVO.setIntoQty(sumIntoAmt)
- .setIntoAmt(sumIntoQty)
- .setIntoingQty(BigDecimal.ZERO)
- .setIntoingAmt(BigDecimal.ZERO);
- //来源id
- inboundVO.setFromId(outboundItemVOListGroup.get(0).getFromId());
- //来源单号
- inboundVO.setFromNo(outboundVO.getOutNo());
- //部门
- inboundVO.setOrgId(outboundVO.getOrgId());
- //员工
- inboundVO.setStaffId(outboundVO.getStaffId());
- //入库日期
- inboundVO.setIntoDate(LocalDate.now());
- //制单人
- inboundVO.setMakeStaff(outboundVO.getMakeStaff());
- //公司
- inboundVO.setCpId(outboundVO.getCpId());
- //实体转换
- Inbound inbound = inboundConvert.convertToPo(inboundVO);
- inboundMapper.insert(inbound);
- //endregion
- //region 明细
- Integer count = 0;
- for (OutboundItemVO outboundItemVO : outboundItemVOListGroup) {
- InboundItemVO inboundItemVO = new InboundItemVO();
- //总单id
- inboundItemVO.setIntoId(inboundVO.getIntoId());
- //入库类型
- inboundItemVO.setIntoType(inboundVO.getIntoType());
- //入库状态等于已入库 更新合计入库数量/金额 = 入库中数量/入库中金额
- inboundItemVO
- .setPriceInto(outboundItemVO.getPriceOut())
- .setIntoQty(outboundItemVO.getOutQty())
- .setIntoAmt(outboundItemVO.getOutQty())
- .setIntoingQty(BigDecimal.ZERO)
- .setIntoingAmt(BigDecimal.ZERO)
- .setCostPrice(outboundItemVO.getPriceOut())
- .setCostAmt(outboundItemVO.getOutQty().multiply(outboundItemVO.getPriceOut()).setScale(2, BigDecimal.ROUND_HALF_UP))
- ;
- //入库状态
- inboundItemVO.setIntoStatus(inboundVO.getIntoStatus());
- //商品顺序
- inboundItemVO.setItemIndex(count);
- //箱(入库中)
- inboundItemVO.setIntoingBox(outboundItemVO.getOutingBox());
- //片(入库中)
- inboundItemVO.setIntoingPiece(outboundItemVO.getOutingPiece());
- //箱(已入库)
- inboundItemVO.setIntoBox(outboundItemVO.getOutBox());
- //片(已入库)
- inboundItemVO.setIntoPiece(outboundItemVO.getOutPiece());
- //入库仓库
- inboundItemVO.setWhId(outboundItemVO.getWhId());
- //企业ID
- inboundItemVO.setCpId(outboundItemVO.getCpId());
- //实体转换
- InboundItem inboundItem = inboundItemConvert.convertToPo(inboundItemVO);
- inboundItemMapper.insert(inboundItem);
- //用来填写商品顺序
- count++;
- inboundItemVO.setItemId(inboundItem.getItemId());
- }
- //endregion
- //region 入账
- accountService.accPayable(inboundVO.getIntoId(), Constant.InventoryDocCode.INTOBOUND.getTableName());
- //endregion
- }
- }
- }
- /**
- * @desc : 销售出库新建
- * @date : 2024/3/7 14:13
- * @author : 寇珊珊
- */
- @Transactional(rollbackFor = {Exception.class})
- public ResponseResultVO<?> saleOrderOutboundInsert(OutboundVO outboundVO) {
- //region 如果没有客户id,要新建
- outboundVO = outCommon.insertCustomer(outboundVO);
- //endregion
- //region 查询当前公司的系统参数 自动办理信息 并赋值
- Map<String, Object> map = new HashMap<>();
- map.put("cpId", outboundVO.getCpId());
- map.put("code", Constant.SystemConstant.IVT_001.getValue());
- //自动办理标识
- String flgHandleSetting = commonMapper.getSettingValue(map);
- //自动办理标识为1 自动办理入库
- if (Constant.FlgAutoHandleStringType.ONE.getValue().equals(flgHandleSetting)) {
- outboundVO.setFlgHandleSetting(Constant.FlgHandleSetting.TRUE.getValue());
- outboundVO.setFlgAutoHandle(Constant.FlgAutoHandle.TRUE.getValue());
- }
- //endregion
- //region 总单
- //获取 id/单号
- Map<String, Object> codeMap = commonService.getUniqueNoteCode(Constant.docNameConstant.SALEORDER.getName(), false);
- outboundVO.setOutId(codeMap.get("outId").toString()).
- setOutNo(codeMap.get("outNote").toString());
- //出库类型
- outboundVO.setOutType(Constant.OutType.SALE.getName()).setOutDate(LocalDate.now());
- //自动入库标识
- if (outboundVO.getFlgAutoHandle()) {
- //已出库
- outboundVO.setOutStatus(Constant.OutStatus.YICHUKU.getName());
- } else {
- //出库中
- outboundVO.setOutStatus(Constant.OutStatus.CHUKUZHONG.getName());
- }
- //出库状态等于已出库 更新合计出库数量/金额 = 出库中数量/出库中金额
- if (Constant.OutStatus.YICHUKU.getName().equals(outboundVO.getOutStatus())) {
- outboundVO
- .setOutQty(outboundVO.getOutingQty())
- .setOutAmt(outboundVO.getOutingAmt())
- .setOutingQty(BigDecimal.ZERO)
- .setOutingAmt(BigDecimal.ZERO)
- ;
- } else {
- outboundVO
- .setOutQty(BigDecimal.ZERO)
- .setOutAmt(BigDecimal.ZERO)
- ;
- }
- //实体转换
- Outbound outbound = outboundConvert.convertToPo(outboundVO);
- outboundMapper.insert(outbound);
- //endregion
- //region 新建多业务归属
- outCommon.insertMultiOwner(outboundVO);
- //endregion
- //region 销售订单
- if (outboundVO.getFromId() != null) {
- //赋值 (这里重写了更新方法,数量在更新方法中有数据库院士数量+本次数量)
- Order order = new Order();
- order.setOrderId(outboundVO.getFromId());
- //根据id查询
- OrderResponse orderResponse = orderMapper.selectById(outboundVO.getFromId());
- //已出库
- if (Constant.OutStatus.YICHUKU.getName().equals(outboundVO.getOutStatus())) {
- order.setOutingQty(BigDecimal.ZERO);
- order.setOutingAmt(BigDecimal.ZERO);
- order.setOutQty(outboundVO.getOutQty());
- order.setOutAmt(outboundVO.getOutAmt());
- }
- //出库中
- else {
- order.setOutingQty(outboundVO.getOutingQty());
- order.setOutingAmt(outboundVO.getOutingAmt());
- order.setOutQty(BigDecimal.ZERO);
- order.setOutAmt(BigDecimal.ZERO);
- }
- //入库状态
- String outStatus = this.setOutStatus(orderResponse.getOutingQty().add(order.getOutingQty()),
- orderResponse.getOutQty().add(order.getOutQty()), orderResponse.getSumQuantity());
- order.setOutStatus(outStatus);
- //修改
- int countRow = orderMapper.updateById(order);
- //数量超出
- if (countRow == 0) {
- throw new BaseBusinessException(ResponseCodeEnum.OPERATE_FAIL.getCode(), ErrorCodeEnum.INVENTORY_QUANTITY_EXCEEDED_OUTBOUND.getMessage());
- }
- }
- //endregion
- //region 明细
- //校验明细
- if (outboundVO.getItemList().size() == 0) {
- throw new BaseBusinessException(ErrorCodeEnum.OUTBOUND_ITEM_NOT_EXIST.getCode(),
- ErrorCodeEnum.OUTBOUND_ITEM_NOT_EXIST.getMessage());
- }
- for (OutboundItemVO outboundItemVO : outboundVO.getItemList()) {
- //region 将库存需要的参数赋值
- outboundItemVO.setInventoryType(Constant.InventoryType.OUTBOUND.getName());
- outboundItemVO.setInventoryDocCode(Constant.InventoryDocCode.SALE_ORDER.getValue());
- outboundItemVO.setAddOrEditFlag(true);
- //endregion
- //总单id
- outboundItemVO.setOutId(outboundVO.getOutId());
- //出库类型
- outboundItemVO.setOutType(outboundVO.getOutType());
- //出库状态等于已出库 更新合计出库数量/金额 = 出库中数量/出库中金额
- if (Constant.OutStatus.YICHUKU.getName().equals(outboundVO.getOutStatus())) {
- outboundItemVO
- .setOutQty(outboundItemVO.getOutingQty())
- .setOutAmt(outboundItemVO.getOutingAmt())
- .setOutingQty(BigDecimal.ZERO)
- .setOutingAmt(BigDecimal.ZERO)
- .setCostPrice(outboundItemVO.getPriceOut())
- .setCostAmt(outboundItemVO.getOutQty().multiply(outboundItemVO.getPriceOut()).setScale(2, BigDecimal.ROUND_HALF_UP))
- ;
- } else {
- outboundItemVO
- .setOutQty(BigDecimal.ZERO)
- .setOutAmt(BigDecimal.ZERO);
- }
- //入库状态
- outboundItemVO.setOutStatus(outboundVO.getOutStatus());
- //实体转换
- OutboundItem outboundItem = outboundItemConvert.convertToPo(outboundItemVO);
- outboundItemMapper.insert(outboundItem);
- //明细id
- outboundItemVO.setItemId(outboundItem.getItemId());
- //endregion
- //region 销售明细
- if (outboundItemVO.getFromItemId() != null) {
- //赋值 (这里重写了更新方法,数量在更新方法中有数据库院士数量+本次数量)
- OrderItem orderItem = new OrderItem();
- orderItem.setItemId(outboundItemVO.getFromItemId());
- //根据id查询
- OrderItemResponse orderItemResponse = orderItemMapper.selectById(outboundItemVO.getFromItemId());
- //已出库
- if (Constant.OutStatus.YICHUKU.getName().equals(outboundVO.getOutStatus())) {
- orderItem.setOutingQty(BigDecimal.ZERO);
- orderItem.setOutingAmt(BigDecimal.ZERO);
- orderItem.setOutQty(outboundItemVO.getOutQty());
- orderItem.setOutAmt(outboundItemVO.getOutAmt());
- }
- //出库中
- else {
- orderItem.setOutingQty(outboundItemVO.getOutingQty());
- orderItem.setOutingAmt(outboundItemVO.getOutingAmt());
- orderItem.setOutQty(BigDecimal.ZERO);
- orderItem.setOutAmt(BigDecimal.ZERO);
- }
- //入库状态
- String outStatus = this.setOutStatus(orderItemResponse.getOutingQty().add(orderItem.getOutingQty()),
- orderItemResponse.getOutQty().add(orderItem.getOutQty()), orderItemResponse.getItemQty());
- orderItem.setOutStatus(outStatus);
- //修改
- int countRow = orderItemMapper.updateById(orderItem);
- //数量超出
- if (countRow == 0) {
- throw new BaseBusinessException(ResponseCodeEnum.OPERATE_FAIL.getCode(), ErrorCodeEnum.INVENTORY_QUANTITY_EXCEEDED_OUTBOUND.getMessage());
- }
- }
- //endregion
- }
- //endregion
- //region 已出库 应收记账
- if (Constant.OutStatus.YICHUKU.getName().equals(outboundVO.getOutStatus())) {
- accountService.accReceivable(outboundVO.getOutId(), Constant.InventoryDocCode.OUTBOUND.getTableName());
- }
- //endregion
- //region 外协品+库存
- if (Constant.OutStatus.YICHUKU.getName().equals(outboundVO.getOutStatus())) {
- //region 外协品新建外协入库单
- //筛选出skuId为空的 走外协品逻辑
- List<OutboundItemVO> outsideGoods = outboundVO.getItemList().stream().filter(it -> it.getSkuId() == null).collect(Collectors.toList());
- //删除外协品生产外协入库单
- this.deleteOutsideGoodsInto(outboundVO, outsideGoods);
- //新建外协品生产外协入库单
- this.insertOutsideGoodsInto(outboundVO, outsideGoods);
- //endregion
- //region 库存
- //筛选出skuId不为空的 走库存
- List<OutboundItemVO> invList = outboundVO.getItemList().stream().filter(it -> it.getSkuId() != null).collect(Collectors.toList());
- if(invList!=null && invList.size() > 0){
- Map<String, Object> invMap = new HashMap<>();
- invMap.put("outDetail", invList);
- inventoryService.operatingInventoryInformation(invMap);
- }
- //endregion
- }
- //endregion
- return ResponseResultUtil.success(outboundVO);
- }
- /**
- * @desc : 销售出库新建>>>收款
- * @date : 2024/3/7 14:13
- * @author : 寇珊珊
- */
- @Transactional(rollbackFor = {Exception.class})
- public ResponseResultVO<?> saleOrderOutboundInsertCollection(OutboundVO outboundVO) {
- //新建销售出库
- saleOrderOutboundInsert(outboundVO);
- //新建退款
- RecPayVO recPayVO = new RecPayVO();
- recPayVO.setObjectId(outboundVO.getObjectId());
- recPayVO.setOrgId(outboundVO.getOrgId());
- recPayVO.setStaffId(outboundVO.getStaffId());
- recPayVO.setAccDate(outboundVO.getAccDate());
- recPayVO.setMakeStaff(outboundVO.getMakeStaff());
- recPayVO.setRpType(outboundVO.getRpType());
- recPayVO.setSumAmtRec(outboundVO.getSumAmtRec());
- recPayVO.setItemList(outboundVO.getItemListRecPayItemVO());
- receiptService.insertReceipt(recPayVO);
- return ResponseResultUtil.success();
- }
- /**
- * @desc : 销售出库编辑
- * @date : 2024/3/25 16:25
- * @author : 寇珊珊
- */
- @Transactional(rollbackFor = {Exception.class})
- public ResponseResultVO<?> saleOutboundUpdate(OutboundVO outboundVO) {
- //region 小编辑
- if (!outboundVO.getLimitEdit()) {
- Outbound outbound = new Outbound();
- outbound.setOutId(outboundVO.getOutId());
- outbound.setRemarks(outboundVO.getRemarks());
- outbound.setAnnexPaths(outboundVO.getAnnexPaths());
- outboundMapper.update(outbound,
- new UpdateWrapper<Outbound>().lambda()
- .eq(Outbound::getOutId, UUID.fromString(outbound.getOutId()))
- );
- for (OutboundItemVO outboundItemVO : outboundVO.getItemList()) {
- OutboundItem outboundItem = new OutboundItem();
- outboundItem.setItemId(outboundItemVO.getItemId());
- if (outboundItemVO.getRemarks() != null || outboundItemVO.getRemarks() != " ") {
- outboundItem.setRemarks(outboundItemVO.getRemarks());
- outboundItemMapper.update(outboundItem,
- new UpdateWrapper<OutboundItem>().lambda()
- .eq(OutboundItem::getItemId, UUID.fromString(outboundItem.getItemId()))
- );
- }
- }
- }
- //endregion
- //region 大编辑
- else {
- // region 更新客户信息
- outboundVO = outCommon.insertCustomer(outboundVO);
- // endregion
- //region 根据id查询 并且明细数量金额 求和
- OutboundResponse outboundResponse = outboundMapper.selectById(outboundVO.getOutId());
- BigDecimal sumQty = outboundVO.getItemList().stream().map(OutboundItemVO::getOutingQty).reduce(BigDecimal.ZERO, BigDecimal::add).setScale(6, BigDecimal.ROUND_HALF_UP);
- BigDecimal sumAmt = outboundVO.getItemList().stream().map(OutboundItemVO::getOutingAmt).reduce(BigDecimal.ZERO, BigDecimal::add).setScale(2, BigDecimal.ROUND_HALF_UP);
- //endregion
- //region 自动办理参数为true 已入库编辑
- //自动办理参数为true
- if (Constant.FlgHandleSetting.TRUE.getValue().equals(outboundVO.getFlgHandleSetting())) {
- //region 应收反记账
- if (outboundVO.getReceivableId() != null) {
- accountService.reverseReceivable(outboundVO.getOutId(), Constant.InventoryDocCode.OUTBOUND.getTableName());
- }
- //endregion
- //region 修改明细
- List<OutboundItemVO> itemList = outboundVO.getItemList();
- for (OutboundItemVO outboundItemVO : itemList) {
- //根据id查询
- OutboundItemResponse outboundItemResponse = outboundItemMapper.selectById(outboundItemVO.getItemId());
- //region 编辑明细
- if (outboundItemVO.getItemId() != null) {
- //region 将库存需要的参数赋值
- outboundItemVO.setInventoryType(Constant.InventoryType.OUTBOUND.getName());
- outboundItemVO.setInventoryDocCode(Constant.InventoryDocCode.SALE_ORDER.getValue());
- //编辑之前的数
- outboundItemVO.setQtyBeforeUpdate(outboundItemResponse.getOutQty());
- outboundItemVO.setAmtBeforeUpdate(outboundItemResponse.getOutAmt());
- //编辑之后的数
- outboundItemVO.setOutQty(outboundItemVO.getOutingQty());
- outboundItemVO.setOutAmt(outboundItemVO.getOutingAmt());
- outboundItemVO.setAddOrEditFlag(false);
- //endregion
- OutboundItem outboundItem = new OutboundItem();
- outboundItem.setItemId(outboundItemVO.getItemId());
- outboundItem.setOutQty(outboundItemVO.getOutingQty());
- outboundItem.setOutAmt(outboundItemVO.getOutingAmt());
- outboundItem.setCostPrice(outboundItemVO.getPriceOut());
- outboundItem.setCostAmt(outboundItemVO.getOutQty().multiply(outboundItemVO.getPriceOut()).setScale(6, BigDecimal.ROUND_HALF_UP));
- //修改
- outboundItemMapper.update(outboundItem,
- new UpdateWrapper<OutboundItem>().lambda()
- .eq(OutboundItem::getItemId, UUID.fromString(outboundItem.getItemId()))
- );
- }
- //endregion
- //region 新建明细
- else {
- outboundItemVO
- .setOutId(outboundItemVO.getOutId())
- .setOutQty(outboundItemVO.getOutingQty())
- .setOutAmt(outboundItemVO.getOutingAmt())
- .setOutingQty(BigDecimal.ZERO)
- .setOutingAmt(BigDecimal.ZERO)
- .setCostPrice(outboundItemVO.getPriceOut())
- .setCostAmt(outboundItemVO.getOutQty().multiply(outboundItemVO.getPriceOut()).setScale(2, BigDecimal.ROUND_HALF_UP))
- .setOutType(Constant.OutType.SALE.getName())
- ;
- //出库状态
- String outStatus = this.setOutStatus(outboundItemVO.getOutingQty(), outboundItemVO.getOutQty());
- outboundItemVO.setOutStatus(outStatus);
- //实体转换
- OutboundItem outboundItem = outboundItemConvert.convertToPo(outboundItemVO);
- //新建
- outboundItemMapper.insert(outboundItem);
- outboundItemVO.setItemId(outboundItem.getItemId());
- //region 将库存需要的参数赋值
- outboundItemVO.setInventoryType(Constant.InventoryType.OUTBOUND.getName());
- outboundItemVO.setInventoryDocCode(Constant.InventoryDocCode.SALE_ORDER.getValue());
- outboundItemVO.setAddOrEditFlag(true);
- //endregion
- }
- //endregion
- //region 销售明细
- if (outboundItemVO.getFromItemId() != null) {
- //根据id查询
- OrderItemResponse orderItemResponse = orderItemMapper.selectById(outboundItemVO.getFromItemId());
- OrderItem orderItem = new OrderItem();
- orderItem.setItemId(outboundItemVO.getFromItemId());
- orderItem.setOutQty(outboundItemResponse.getOutQty().negate().add(outboundItemVO.getOutingQty()));
- orderItem.setOutAmt(outboundItemResponse.getOutAmt().negate().add(outboundItemVO.getOutingAmt()));
- orderItem.setOutingQty(outboundItemVO.getOutQty());
- orderItem.setOutingAmt(outboundItemVO.getOutAmt());
- //出库状态
- String outStatus = this.setOutStatus(orderItemResponse.getOutingQty().add(orderItem.getOutingQty()),
- orderItemResponse.getOutQty().add(orderItem.getOutQty()), orderItemResponse.getItemQty());
- orderItem.setOutStatus(outStatus);
- int countRow = orderItemMapper.updateById(orderItem);
- //数量超出
- if (countRow == 0) {
- throw new BaseBusinessException(ResponseCodeEnum.OPERATE_FAIL.getCode(), ErrorCodeEnum.INVENTORY_QUANTITY_EXCEEDED_OUTBOUND.getMessage());
- }
- }
- //endregion
- }
- //endregion
- //region 删除明细
- BigDecimal delOutQty = BigDecimal.ZERO;
- BigDecimal delOutAmt = BigDecimal.ZERO;
- if (outboundVO.getDeleteItemList() != null && outboundVO.getDeleteItemList().size() > 0) {
- delOutQty = outboundVO.getDeleteItemList().stream().map(OutboundItemVO::getOutQty).reduce(BigDecimal.ZERO, BigDecimal::add).setScale(6, BigDecimal.ROUND_HALF_UP);
- delOutAmt = outboundVO.getDeleteItemList().stream().map(OutboundItemVO::getOutAmt).reduce(BigDecimal.ZERO, BigDecimal::add).setScale(2, BigDecimal.ROUND_HALF_UP);
- for (OutboundItemVO outboundItemVO : outboundVO.getDeleteItemList()) {
- if (outboundItemVO.getItemId() != null) {
- //region 将库存需要的参数赋值
- outboundItemVO.setInventoryType(Constant.InventoryType.OUTBOUND.getName());
- outboundItemVO.setInventoryDocCode(Constant.InventoryDocCode.SALE_ORDER.getValue());
- //endregion
- OutboundItem outboundItem = outboundItemConvert.convertToPo(outboundItemVO);
- outboundItem.setFlgValid(false);
- //修改
- outboundItemMapper.update(outboundItem,
- new UpdateWrapper<OutboundItem>().lambda()
- .eq(OutboundItem::getItemId, UUID.fromString(outboundItem.getItemId()))
- );
- }
- //region 销售明细
- if (outboundItemVO.getFromItemId() != null) {
- //根据id查询
- OrderItemResponse orderItemResponse = orderItemMapper.selectById(outboundItemVO.getFromItemId());
- OrderItem orderItem = new OrderItem();
- orderItem.setItemId(outboundItemVO.getFromItemId());
- orderItem.setOutQty(outboundItemVO.getOutQty().negate());
- orderItem.setOutAmt(outboundItemVO.getOutAmt().negate());
- orderItem.setOutingQty(outboundItemVO.getOutQty());
- orderItem.setOutingAmt(outboundItemVO.getOutQty());
- //出库状态
- String outStatus = this.setOutStatus(orderItemResponse.getOutingQty().add(orderItem.getOutingQty()),
- orderItemResponse.getOutQty().add(orderItem.getOutQty()), orderItemResponse.getItemQty());
- orderItem.setOutStatus(outStatus);
- int countRow = orderItemMapper.updateById(orderItem);
- //数量超出
- if (countRow == 0) {
- throw new BaseBusinessException(ResponseCodeEnum.OPERATE_FAIL.getCode(), ErrorCodeEnum.INVENTORY_QUANTITY_EXCEEDED_OUTBOUND.getMessage());
- }
- }
- //endregion
- }
- }
- //endregion
- //region 修改出库总单
- Outbound outbound = new Outbound();
- outbound.setOutId(outboundVO.getOutId());
- outbound.setOutQty(sumQty);
- outbound.setOutAmt(sumAmt);
- //修改
- outboundMapper.update(outbound,
- new UpdateWrapper<Outbound>().lambda().eq(Outbound::getOutId, UUID.fromString(outbound.getOutId()))
- );
- //endregion
- //region 修改销售总单
- if (outboundVO.getFromId() != null) {
- //根据id查询
- OrderResponse orderResponse = orderMapper.selectById(outboundVO.getFromId());
- Order order = new Order();
- order.setOrderId(outboundVO.getFromId());
- order.setOutQty(outboundResponse.getOutQty().negate().add(sumQty).subtract(delOutQty));
- order.setOutAmt(outboundResponse.getOutAmt().negate().add(sumAmt).subtract(delOutAmt));
- order.setOutingQty(delOutQty);
- order.setOutingAmt(delOutAmt);
- //出库状态
- String outStatus = this.setOutStatus(orderResponse.getOutingQty().add(order.getOutingQty()),
- orderResponse.getOutQty().add(order.getOutQty()), orderResponse.getSumQuantity());
- order.setOutStatus(outStatus);
- //修改
- int countRow = orderMapper.updateById(order);
- //数量超出
- if (countRow == 0) {
- throw new BaseBusinessException(ResponseCodeEnum.OPERATE_FAIL.getCode(), ErrorCodeEnum.INVENTORY_QUANTITY_EXCEEDED_OUTBOUND.getMessage());
- }
- }
- //endregion
- //region 应收记账
- if (outboundVO.getReceivableId() != null) {
- accountService.accReceivable(outboundResponse.getOutId(), Constant.InventoryDocCode.OUTBOUND.getTableName());
- }
- //endregion
- //region 外协品新建外协入库单
- //筛选出skuId为空的 走外协品逻辑
- List<OutboundItemVO> outsideGoods = outboundVO.getItemList().stream().filter(it -> it.getSkuId() == null).collect(Collectors.toList());
- //删除外协品生产外协入库单
- this.deleteOutsideGoodsInto(outboundVO, outsideGoods);
- //新建外协品生产外协入库单
- this.insertOutsideGoodsInto(outboundVO, outsideGoods);
- List<OutboundItemVO> delOutsideGoods = outboundVO.getDeleteItemList().stream().filter(it -> it.getSkuId() == null).collect(Collectors.toList());
- //删除外协品生产外协入库单
- this.deleteOutsideGoodsInto(outboundVO, delOutsideGoods);
- //endregion
- //region 修改库存
- //筛选出skuId不为空的 走库存
- List<OutboundItemVO> invList = outboundVO.getItemList().stream().filter(it -> it.getSkuId() != null).collect(Collectors.toList());
- List<OutboundItemVO> invDelList = outboundVO.getDeleteItemList().stream().filter(it -> it.getSkuId() != null).collect(Collectors.toList());
- if ((invList != null && invList.size() > 0) || (invDelList != null && invDelList.size() > 0)) {
- Map<String, Object> invMap = new HashMap<>();
- invMap.put("outDetail", invList);
- invMap.put("delOutDetail", invDelList);
- inventoryService.operatingInventoryInformation(invMap);
- }
- //endregion
- } else {
- throw new BaseBusinessException(ResponseCodeEnum.OPERATE_FAIL.getCode(), ErrorCodeEnum.FLG_HANDLE_SETTING_NOT_ENABLED_OUT.getMessage());
- }
- //endregion
- //region 自动办理参数false 入库中编辑
- //自动办理标识为false 并且 自动办理参数为false 入库中
- if (!outboundVO.getFlgAutoHandle() && Constant.FlgHandleSetting.FALSE.getValue().equals(outboundVO.getFlgHandleSetting())) {
- //region 修改明细
- List<OutboundItemVO> itemList = outboundVO.getItemList();
- for (OutboundItemVO outboundItemVO : itemList) {
- //根据id查询 获取到还未进行修改的数据
- OutboundItemResponse outboundItemResponse = outboundItemMapper.selectById(outboundItemVO.getItemId());
- //region 编辑明细
- if (outboundItemVO.getItemId() != null) {
- OutboundItem outboundItem = new OutboundItem();
- outboundItem.setItemId(outboundItemResponse.getItemId());
- outboundItem.setOutingQty(outboundItemResponse.getOutingQty());
- outboundItem.setOutingAmt(outboundItemResponse.getOutingAmt());
- //修改
- outboundItemMapper.update(outboundItem,
- new UpdateWrapper<OutboundItem>().lambda()
- .eq(OutboundItem::getItemId, UUID.fromString(outboundItem.getItemId()))
- );
- }
- //endregion
- //region 新建明细
- else {
- outboundItemVO
- .setOutId(outboundItemVO.getOutId())
- .setOutQty(BigDecimal.ZERO)
- .setOutAmt(BigDecimal.ZERO)
- .setCostPrice(outboundItemVO.getPriceOut())
- .setCostAmt(outboundItemVO.getOutingQty().multiply(outboundItemVO.getPriceOut()).setScale(2, BigDecimal.ROUND_HALF_UP))
- .setOutType(Constant.OutType.SALE.getName())
- ;
- //出库状态
- String outStatus = this.setOutStatus(outboundItemVO.getOutingQty(), outboundItemVO.getOutQty());
- outboundItemVO.setOutStatus(outStatus);
- //实体转换
- OutboundItem outboundItem = outboundItemConvert.convertToPo(outboundItemVO);
- //新建
- outboundItemMapper.insert(outboundItem);
- outboundItemVO.setItemId(outboundItem.getItemId());
- }
- //endregion
- //region 销售明细
- if (outboundItemVO.getFromItemId() != null) {
- //根据id查询
- OrderItemResponse orderItemResponse = orderItemMapper.selectById(outboundItemVO.getFromItemId());
- OrderItem orderItem = new OrderItem();
- orderItem.setItemId(outboundItemVO.getFromItemId());
- orderItem.setOutingQty(outboundItemResponse.getOutingQty().negate().add(outboundItemVO.getOutingQty()));
- orderItem.setOutingAmt(outboundItemResponse.getOutingAmt().negate().add(outboundItemVO.getOutingAmt()));
- //出库状态
- String outStatus = this.setOutStatus(orderItemResponse.getOutingQty().add(orderItem.getOutingQty()),
- orderItemResponse.getOutQty(), orderItemResponse.getItemQty());
- orderItem.setOutStatus(outStatus);
- int countRow = orderItemMapper.updateById(orderItem);
- //数量超出
- if (countRow == 0) {
- throw new BaseBusinessException(ResponseCodeEnum.OPERATE_FAIL.getCode(), ErrorCodeEnum.INVENTORY_QUANTITY_EXCEEDED_OUTBOUND.getMessage());
- }
- }
- //endregion
- }
- //endregion
- //region 删除明细
- BigDecimal delOutQty = BigDecimal.ZERO;
- BigDecimal delOutAmt = BigDecimal.ZERO;
- if (outboundVO.getDeleteItemList() != null && outboundVO.getDeleteItemList().size() > 0) {
- delOutQty = outboundVO.getDeleteItemList().stream().map(OutboundItemVO::getOutingQty).reduce(BigDecimal.ZERO, BigDecimal::add).setScale(6, BigDecimal.ROUND_HALF_UP);
- delOutAmt = outboundVO.getDeleteItemList().stream().map(OutboundItemVO::getOutingAmt).reduce(BigDecimal.ZERO, BigDecimal::add).setScale(2, BigDecimal.ROUND_HALF_UP);
- for (OutboundItemVO outboundItemVO : outboundVO.getDeleteItemList()) {
- if (outboundItemVO.getItemId() != null) {
- OutboundItem outboundItem = outboundItemConvert.convertToPo(outboundItemVO);
- outboundItem.setFlgValid(false);
- //修改
- outboundItemMapper.update(outboundItem,
- new UpdateWrapper<OutboundItem>().lambda()
- .eq(OutboundItem::getItemId, UUID.fromString(outboundItem.getItemId()))
- );
- }
- //region 销售明细
- if (outboundItemVO.getFromItemId() != null) {
- //根据id查询
- OrderItemResponse orderItemResponse = orderItemMapper.selectById(outboundItemVO.getFromItemId());
- OrderItem orderItem = new OrderItem();
- orderItem.setItemId(outboundItemVO.getFromItemId());
- orderItem.setOutingQty(outboundItemVO.getOutQty().negate());
- orderItem.setOutingAmt(outboundItemVO.getOutQty().negate());
- //出库状态
- String outStatus = this.setOutStatus(orderItemResponse.getOutingQty().add(orderItem.getOutingQty()),
- orderItemResponse.getOutQty(), orderItemResponse.getItemQty());
- orderItem.setOutStatus(outStatus);
- int countRow = orderItemMapper.updateById(orderItem);
- //数量超出
- if (countRow == 0) {
- throw new BaseBusinessException(ResponseCodeEnum.OPERATE_FAIL.getCode(), ErrorCodeEnum.INVENTORY_QUANTITY_EXCEEDED_OUTBOUND.getMessage());
- }
- }
- //endregion
- }
- }
- //endregion
- //region 修改入库总单
- Outbound outbound = new Outbound();
- outbound.setOutId(outboundVO.getOutId());
- outbound.setOutingQty(sumQty);
- outbound.setOutingAmt(sumAmt);
- //修改
- outboundMapper.update(outbound,
- new UpdateWrapper<Outbound>().lambda().eq(Outbound::getOutId, UUID.fromString(outbound.getOutId()))
- );
- //endregion
- //region 修改采购总单
- if (outboundVO.getFromId() != null) {
- //根据id查询
- OrderResponse orderResponse = orderMapper.selectById(outboundVO.getFromId());
- Order order = new Order();
- order.setOrderId(outboundVO.getFromId());
- order.setOutingQty(outboundResponse.getOutingQty().negate().add(sumQty).subtract(delOutQty));
- order.setOutingAmt(outboundResponse.getOutingAmt().negate().add(sumAmt).subtract(delOutAmt));
- //出库状态
- String outStatus = this.setOutStatus(orderResponse.getOutingQty().add(order.getOutingQty()),
- orderResponse.getOutQty(), orderResponse.getSumQuantity());
- order.setOutStatus(outStatus);
- //修改
- int countRow = orderMapper.updateById(order);
- //数量超出
- if (countRow == 0) {
- throw new BaseBusinessException(ResponseCodeEnum.OPERATE_FAIL.getCode(), ErrorCodeEnum.INVENTORY_QUANTITY_EXCEEDED_OUTBOUND.getMessage());
- }
- }
- //endregion
- } else {
- throw new BaseBusinessException(ResponseCodeEnum.OPERATE_FAIL.getCode(), ErrorCodeEnum.FLG_HANDLE_SETTING_NOT_ENABLED_OUT.getMessage());
- }
- //endregion
- }
- //endregion
- return ResponseResultUtil.success(outboundVO);
- }
- /**
- * @desc : 销售出库作废
- * @date : 2024/3/26 9:24
- * @author : 寇珊珊
- */
- @Transactional(rollbackFor = {Exception.class})
- public ResponseResultVO<?> saleOutboundRepeal(String outId) {
- //region 查询总单 查询明细
- //根据id查询 此条出库单的数据还未更改前的数据
- OutboundResponse outboundResponse = outboundMapper.selectById(outId);
- //根据总单id查询
- List<OutboundItemResponse> outboundItemResponseList = outboundItemMapper.selectByCond(new OutboundItemQuery().setOutId(outboundResponse.getOutId()));
- //endregion
- //region 已出库状态作废
- if (Constant.OutStatus.YICHUKU.getName().equals(outboundResponse.getOutStatus())) {
- //region 应收反记账
- if (outboundResponse.getReceivableId() != null) {
- accountService.reverseReceivable(outboundResponse.getOutId(), Constant.InventoryDocCode.OUTBOUND.getTableName());
- }
- //endregion
- //region 修改明细
- for (OutboundItemResponse outboundItemResponse : outboundItemResponseList) {
- //region 将库存需要的参数赋值
- outboundItemResponse.setInventoryType(Constant.InventoryType.OUTBOUND.getName());
- outboundItemResponse.setInventoryDocCode(Constant.InventoryDocCode.SALE_ORDER.getValue());
- outboundItemResponse.setOutQty(outboundItemResponse.getOutQty().negate());
- outboundItemResponse.setOutAmt(outboundItemResponse.getOutAmt().negate());
- //endregion
- //赋值 防止作废的单据查不到明细 故注掉下面代码
- // OutboundItem outboundItem = new OutboundItem();
- // outboundItem.setItemId(outboundItemResponse.getItemId());
- // outboundItem.setFlgValid(false);
- // //修改
- // outboundItemMapper.update(outboundItem,
- // new UpdateWrapper<OutboundItem>().lambda()
- // .eq(OutboundItem::getItemId, UUID.fromString(outboundItem.getItemId()))
- // );
- //region 销售明细
- if (outboundItemResponse.getFromItemId() != null) {
- //根据id查询
- OrderItemResponse orderItemResponse = orderItemMapper.selectById(outboundItemResponse.getFromItemId());
- OrderItem orderItem = new OrderItem();
- orderItem.setItemId(outboundItemResponse.getFromItemId());
- orderItem.setOutQty(outboundItemResponse.getOutQty().negate());
- orderItem.setOutAmt(outboundItemResponse.getOutAmt().negate());
- //出库状态
- String orderOutStatus = this.setOutStatus(orderItemResponse.getOutingQty(),
- orderItemResponse.getOutQty().add(orderItem.getOutQty()), orderItemResponse.getItemQty());
- orderItem.setOutStatus(orderOutStatus);
- int countRow = orderItemMapper.updateById(orderItem);
- //数量超出
- if (countRow == 0) {
- throw new BaseBusinessException(ResponseCodeEnum.OPERATE_FAIL.getCode(), ErrorCodeEnum.INVENTORY_QUANTITY_EXCEEDED_OUTBOUND.getMessage());
- }
- }
- //endregion
- }
- //endregion
- //region 修改入库总单
- Outbound outbound = new Outbound();
- outbound.setOutId(outboundResponse.getOutId());
- outbound.setFlgValid(false);
- //修改
- outboundMapper.update(outbound,
- new UpdateWrapper<Outbound>().lambda().eq(Outbound::getOutId, UUID.fromString(outbound.getOutId()))
- );
- //endregion
- //region 修改销售总单
- if (outboundResponse.getFromId() != null) {
- //根据id查询
- OrderResponse orderResponse = orderMapper.selectById(outboundResponse.getFromId());
- Order order = new Order();
- order.setOrderId(outboundResponse.getFromId());
- order.setOutQty(outboundResponse.getOutQty().negate());
- order.setOutAmt(outboundResponse.getOutAmt().negate());
- //出库状态
- String orderOutStatus = this.setOutStatus(orderResponse.getOutingQty(),
- orderResponse.getOutQty().add(order.getOutQty()), orderResponse.getSumQuantity());
- order.setOutStatus(orderOutStatus);
- //修改
- int countRow = orderMapper.updateById(order);
- //数量超出
- if (countRow == 0) {
- throw new BaseBusinessException(ResponseCodeEnum.OPERATE_FAIL.getCode(), ErrorCodeEnum.INVENTORY_QUANTITY_EXCEEDED_OUTBOUND.getMessage());
- }
- }
- //endregion
- //region 外协品新建外协入库单
- //筛选出skuId为空的 走外协品逻辑
- OutboundVO outboundVO = outboundConvert.convertResToVO(outboundResponse);
- List<OutboundItemResponse> outsideGoods = outboundItemResponseList.stream().filter(it -> it.getSkuId() == null).collect(Collectors.toList());
- List<OutboundItemVO> outsideGoodsVOList = outboundItemConvert.convertResListToVOList(outsideGoods);
- //删除外协品生产外协入库单
- this.deleteOutsideGoodsInto(outboundVO, outsideGoodsVOList);
- //endregion
- //region 修改库存
- //筛选出skuId不为空的 走库存
- List<OutboundItemResponse> invList = outboundItemResponseList.stream().filter(it -> it.getSkuId() != null).collect(Collectors.toList());
- if(invList!=null && invList.size()>0) {
- Map<String, Object> map = new HashMap<>();
- map.put("delOutDetail", invList);
- inventoryService.operatingInventoryInformation(map);
- }
- //endregion
- }
- //endregion
- //region 出库中、待出库状态作废
- if (Constant.OutStatus.CHUKUZHONG.getName().equals(outboundResponse.getOutStatus()) ||
- Constant.OutStatus.DAICHUKU.getName().equals(outboundResponse.getOutStatus())) {
- //region 修改明细
- for (OutboundItemResponse outboundItemResponse : outboundItemResponseList) {
- //region 修改明细
- //赋值
- OutboundItem outboundItem = new OutboundItem();
- outboundItem.setItemId(outboundItemResponse.getItemId());
- outboundItem.setOutingQty(BigDecimal.ZERO);
- outboundItem.setOutingAmt(BigDecimal.ZERO);
- // outboundItem.setFlgValid(false);
- //修改
- outboundItemMapper.update(outboundItem,
- new UpdateWrapper<OutboundItem>().lambda()
- .eq(OutboundItem::getItemId, UUID.fromString(outboundItem.getItemId()))
- );
- //endregion
- //region 销售明细
- if (outboundItemResponse.getFromItemId() != null) {
- //根据id查询
- OrderItemResponse orderItemResponse = orderItemMapper.selectById(outboundItemResponse.getFromItemId());
- OrderItem orderItem = new OrderItem();
- orderItem.setItemId(outboundItemResponse.getFromItemId());
- orderItem.setOutingQty(outboundItemResponse.getOutingQty().negate());
- orderItem.setOutingAmt(outboundItemResponse.getOutingAmt().negate());
- //出库状态
- String orderOutStatus = this.setOutStatus(orderItemResponse.getOutingQty().add(orderItem.getOutingQty()),
- orderItemResponse.getOutQty(), orderItemResponse.getItemQty());
- orderItem.setOutStatus(orderOutStatus);
- int countRow = orderItemMapper.updateById(orderItem);
- //数量超出
- if (countRow == 0) {
- throw new BaseBusinessException(ResponseCodeEnum.OPERATE_FAIL.getCode(), ErrorCodeEnum.INVENTORY_QUANTITY_EXCEEDED_OUTBOUND.getMessage());
- }
- }
- //endregion
- }
- //endregion
- //region 修改出库总单
- Outbound outbound = new Outbound();
- outbound.setOutId(outboundResponse.getOutId());
- outbound.setOutingQty(BigDecimal.ZERO);
- outbound.setOutingAmt(BigDecimal.ZERO);
- outbound.setFlgValid(false);
- //修改
- outboundMapper.update(outbound,
- new UpdateWrapper<Outbound>().lambda().eq(Outbound::getOutId, UUID.fromString(outbound.getOutId()))
- );
- //endregion
- //region 修改销售总单
- if (outboundResponse.getFromId() != null) {
- //根据id查询
- OrderResponse orderResponse = orderMapper.selectById(outboundResponse.getFromId());
- Order order = new Order();
- order.setOrderId(outboundResponse.getFromId());
- order.setOutingQty(outboundResponse.getOutingQty().negate());
- order.setOutingAmt(outboundResponse.getOutingAmt().negate());
- //出库状态
- String orderOutStatus = this.setOutStatus(orderResponse.getOutingQty().add(order.getOutingQty()),
- orderResponse.getOutQty(), orderResponse.getSumQuantity());
- order.setOutStatus(orderOutStatus);
- //修改
- int countRow = orderMapper.updateById(order);
- //数量超出
- if (countRow == 0) {
- throw new BaseBusinessException(ResponseCodeEnum.OPERATE_FAIL.getCode(), ErrorCodeEnum.INVENTORY_QUANTITY_EXCEEDED_OUTBOUND.getMessage());
- }
- }
- //endregion
- }
- //endregion
- return ResponseResultUtil.success();
- }
- /**
- * @desc : 销售出库办理
- * @date : 2024/3/7 15:47
- * @author : 寇珊珊
- */
- @Transactional(rollbackFor = {Exception.class})
- public ResponseResultVO<?> saleOrderHandleOutbound(OutboundVO outboundVO) {
- //region 根据id查询 此条入库单的数据还未更改前的数据
- OutboundResponse outboundResponse = outboundMapper.selectById(outboundVO.getOutId());
- //endregion
- //region 应收反记账
- if (outboundResponse.getReceivableId() != null) {
- accountService.reverseReceivable(outboundResponse.getOutId(), Constant.InventoryDocCode.OUTBOUND.getTableName());
- }
- //endregion
- //region 编辑明细
- //校验明细
- if (outboundVO.getItemList().size() == 0) {
- throw new BaseBusinessException(ErrorCodeEnum.OUTBOUND_ITEM_NOT_EXIST.getCode(),
- ErrorCodeEnum.OUTBOUND_ITEM_NOT_EXIST.getMessage());
- }
- for (OutboundItemVO outboundItemVO : outboundVO.getItemList()) {
- //明细根据id查询
- OutboundItemResponse outboundItemResponse = outboundItemMapper.selectById(outboundItemVO.getItemId());
- //region 校验数量是否超出
- if (outboundItemVO.getOutingQty().compareTo(outboundItemResponse.getOutingQty()) > 0) {
- throw new BaseBusinessException(ErrorCodeEnum.CANNOT_EXCEED_THE_QUANTITYIN_THE_WAREHOUSE.getCode(),
- ErrorCodeEnum.CANNOT_EXCEED_THE_QUANTITYIN_THE_WAREHOUSE.getMessage());
- }
- //endregion
- //region 编辑明细
- if (outboundItemVO.getItemId() != null) {
- outboundItemVO
- .setOutQty(outboundItemVO.getOutingQty())
- .setOutBox(outboundItemVO.getOutingBox()).setOutPiece(outboundItemVO.getOutingPiece())
- .setOutAmt(outboundItemVO.getOutingAmt())
- .setOutingQty(BigDecimal.ZERO).setOutingBox(0).setOutingPiece(BigDecimal.ZERO)
- .setOutingAmt(BigDecimal.ZERO)
- .setCostPrice(outboundItemVO.getPriceOut())
- .setCostAmt(outboundItemVO.getOutQty().multiply(outboundItemVO.getPriceOut()).setScale(2, BigDecimal.ROUND_HALF_UP))
- ;
- //出库状态
- String outStatus = this.setOutStatus(outboundItemVO.getOutingQty(), outboundItemVO.getOutQty());
- outboundItemVO.setOutStatus(outStatus);
- //实体转换
- OutboundItem outboundItem = outboundItemConvert.convertToPo(outboundItemVO);
- //修改
- outboundItemMapper.update(outboundItem,
- new UpdateWrapper<OutboundItem>().lambda()
- .eq(OutboundItem::getItemId, UUID.fromString(outboundItem.getItemId()))
- );
- //region 将库存需要的参数赋值
- outboundItemVO.setInventoryType(Constant.InventoryType.OUTBOUND.getName());
- outboundItemVO.setInventoryDocCode(Constant.InventoryDocCode.SALE_ORDER.getValue());
- //编辑之前的数
- if (outboundItemResponse.getOutQty().compareTo(BigDecimal.ZERO) > 0) {
- outboundItemVO.setQtyBeforeUpdate(outboundItemResponse.getOutQty());
- outboundItemVO.setAmtBeforeUpdate(outboundItemResponse.getOutAmt());
- }
- outboundItemVO.setAddOrEditFlag(true);
- //endregion
- }
- //endregion
- //region 新建明细
- else {
- outboundItemVO
- .setOutId(outboundItemVO.getOutId())
- .setOutQty(outboundItemVO.getOutingQty())
- .setOutBox(outboundItemVO.getOutingBox()).setOutPiece(outboundItemVO.getOutingPiece())
- .setOutAmt(outboundItemVO.getOutingAmt())
- .setCostPrice(outboundItemVO.getPriceOut())
- .setCostAmt(outboundItemVO.getOutQty().multiply(outboundItemVO.getPriceOut()).setScale(2, BigDecimal.ROUND_HALF_UP))
- .setOutType(Constant.OutType.SALE.getName())
- .setOutingQty(BigDecimal.ZERO)
- .setOutingAmt(BigDecimal.ZERO)
- ;
- //出库状态
- String outStatus = this.setOutStatus(outboundItemVO.getOutingQty(), outboundItemVO.getOutQty());
- outboundItemVO.setOutStatus(outStatus);
- //实体转换
- OutboundItem outboundItem = outboundItemConvert.convertToPo(outboundItemVO);
- //新建
- outboundItemMapper.insert(outboundItem);
- outboundItemVO.setItemId(outboundItem.getItemId());
- //region 将库存需要的参数赋值
- outboundItemVO.setInventoryType(Constant.InventoryType.OUTBOUND.getName());
- outboundItemVO.setInventoryDocCode(Constant.InventoryDocCode.SALE_ORDER.getValue());
- outboundItemVO.setAddOrEditFlag(true);
- //endregion
- }
- //endregion
- //region 销售订单明细
- if (outboundItemVO.getFromItemId() != null) {
- //根据id查询
- OrderItemResponse orderItemResponse = orderItemMapper.selectById(outboundItemVO.getFromItemId());
- //赋值(这里重写了更新方法,数量在更新方法中有数据库院士数量+本次数量)
- OrderItem orderItem = new OrderItem();
- orderItem.setItemId(outboundItemVO.getFromItemId());
- orderItem.setOutingQty(outboundItemVO.getOutQty().negate());
- orderItem.setOutingAmt(outboundItemVO.getOutAmt().negate());
- orderItem.setOutQty(outboundItemVO.getOutQty());
- orderItem.setOutAmt(outboundItemVO.getOutAmt());
- //出库状态
- String orderOutStatus = this.setOutStatus(orderItemResponse.getOutingQty().subtract(outboundItemVO.getOutQty()),
- orderItemResponse.getOutQty().add(orderItem.getOutQty()), orderItemResponse.getItemQty());
- orderItem.setOutStatus(orderOutStatus);
- //修改
- int countRow = orderItemMapper.updateById(orderItem);
- //数量超出
- if (countRow == 0) {
- throw new BaseBusinessException(ResponseCodeEnum.OPERATE_FAIL.getCode(), ErrorCodeEnum.INVENTORY_QUANTITY_EXCEEDED_OUTBOUND.getMessage());
- }
- }
- //endregion
- }
- //endregion
- //region 删除明细
- BigDecimal delOutingQty = BigDecimal.ZERO;
- BigDecimal delOutingAmt = BigDecimal.ZERO;
- BigDecimal delOutQty = BigDecimal.ZERO;
- BigDecimal delOutAmt = BigDecimal.ZERO;
- if (outboundVO.getDeleteItemList() != null && outboundVO.getDeleteItemList().size() > 0) {
- delOutingQty = outboundVO.getDeleteItemList().stream().map(OutboundItemVO::getOutingQty).reduce(BigDecimal.ZERO, BigDecimal::add).setScale(6, BigDecimal.ROUND_HALF_UP);
- delOutingAmt = outboundVO.getDeleteItemList().stream().map(OutboundItemVO::getOutingAmt).reduce(BigDecimal.ZERO, BigDecimal::add).setScale(2, BigDecimal.ROUND_HALF_UP);
- delOutQty = outboundVO.getDeleteItemList().stream().map(OutboundItemVO::getOutQty).reduce(BigDecimal.ZERO, BigDecimal::add).setScale(6, BigDecimal.ROUND_HALF_UP);
- delOutAmt = outboundVO.getDeleteItemList().stream().map(OutboundItemVO::getOutAmt).reduce(BigDecimal.ZERO, BigDecimal::add).setScale(2, BigDecimal.ROUND_HALF_UP);
- for (OutboundItemVO outboundItemVO : outboundVO.getDeleteItemList()) {
- if (outboundItemVO.getItemId() != null) {
- //region 将库存需要的参数赋值
- outboundItemVO.setInventoryType(Constant.InventoryType.OUTBOUND.getName());
- outboundItemVO.setInventoryDocCode(Constant.InventoryDocCode.SALE_ORDER.getValue());
- //endregion
- OutboundItem outboundItem = outboundItemConvert.convertToPo(outboundItemVO);
- outboundItem.setFlgValid(false);
- //修改
- outboundItemMapper.update(outboundItem,
- new UpdateWrapper<OutboundItem>().lambda()
- .eq(OutboundItem::getItemId, UUID.fromString(outboundItem.getItemId()))
- );
- }
- //region 销售订单明细
- if (outboundItemVO.getFromItemId() != null) {
- //根据id查询
- OrderItemResponse orderItemResponse = orderItemMapper.selectById(outboundItemVO.getFromItemId());
- //赋值(这里重写了更新方法,数量在更新方法中有数据库院士数量+本次数量)
- OrderItem orderItem = new OrderItem();
- orderItem.setItemId(outboundItemVO.getFromItemId());
- orderItem.setOutingQty(outboundItemVO.getOutingQty().negate());
- orderItem.setOutingAmt(outboundItemVO.getOutingAmt().negate());
- orderItem.setOutQty(outboundItemVO.getOutQty().negate());
- orderItem.setOutAmt(outboundItemVO.getOutAmt().negate());
- //出库状态
- String outStatus = this.setOutStatus(orderItemResponse.getOutingQty().subtract(orderItem.getOutingQty()),
- orderItemResponse.getOutQty().add(orderItem.getOutQty()), orderItemResponse.getItemQty());
- orderItem.setOutStatus(outStatus);
- //修改
- int countRow = orderItemMapper.updateById(orderItem);
- //数量超出
- if (countRow == 0) {
- throw new BaseBusinessException(ResponseCodeEnum.OPERATE_FAIL.getCode(), ErrorCodeEnum.INVENTORY_QUANTITY_EXCEEDED_OUTBOUND.getMessage());
- }
- }
- //endregion
- }
- }
- //endregion
- //region 编辑总单
- BigDecimal sumOutQty = outboundVO.getItemList().stream().map(OutboundItemVO::getOutQty).reduce(BigDecimal.ZERO, BigDecimal::add).setScale(6, BigDecimal.ROUND_HALF_UP);
- BigDecimal sumOutAmt = outboundVO.getItemList().stream().map(OutboundItemVO::getOutAmt).reduce(BigDecimal.ZERO, BigDecimal::add).setScale(2, BigDecimal.ROUND_HALF_UP);
- outboundVO.setOutQty(sumOutQty);
- outboundVO.setOutAmt(sumOutAmt);
- outboundVO.setOutingQty(BigDecimal.ZERO);
- outboundVO.setOutingAmt(BigDecimal.ZERO);
- //出库状态
- String outStatus = this.setOutStatus(outboundVO.getOutingQty(), outboundVO.getOutQty());
- outboundVO.setOutStatus(outStatus);
- //实体转换
- Outbound outbound = outboundConvert.convertToPo(outboundVO);
- //修改
- outboundMapper.update(outbound,
- new UpdateWrapper<Outbound>().lambda()
- .eq(Outbound::getOutId, UUID.fromString(outbound.getOutId()))
- );
- //endregion
- //region 修改销售订单订单
- if (outboundVO.getFromId() != null) {
- //根据id查询
- OrderResponse orderResponse = orderMapper.selectById(outboundVO.getFromId());
- //赋值(这里重写了更新方法,数量在更新方法中有数据库院士数量+本次数量)
- Order order = new Order();
- order.setOrderId(outboundVO.getFromId());
- order.setOutQty(sumOutQty.subtract(delOutQty));
- order.setOutAmt(sumOutAmt.subtract(delOutAmt));
- order.setOutingQty((outboundResponse.getOutingQty().add(delOutingQty)).negate());
- order.setOutingAmt((outboundResponse.getOutingAmt().add(delOutingAmt)).negate());
- //出库状态
- String orderOutStatus = this.setOutStatus(orderResponse.getOutingQty().subtract(sumOutQty).add(delOutQty),
- orderResponse.getOutQty().add(order.getOutQty()), orderResponse.getSumQuantity());
- order.setOutStatus(orderOutStatus);
- //修改
- int countRow = orderMapper.updateById(order);
- //数量超出
- if (countRow == 0) {
- throw new BaseBusinessException(ResponseCodeEnum.OPERATE_FAIL.getCode(), ErrorCodeEnum.INVENTORY_QUANTITY_EXCEEDED_OUTBOUND.getMessage());
- }
- }
- //endregion
- //region 应收记账
- accountService.accReceivable(outboundResponse.getOutId(), Constant.InventoryDocCode.OUTBOUND.getTableName());
- //endregion
- //region 库存明细处理
- if(outboundVO.getItemList()!=null && outboundVO.getItemList().size()>0){
- Map<String, Object> map = new HashMap<>(); // 定义map值 修改库存用
- // 获取外协数据
- List<OutboundItemVO> outsideGoods = outboundVO.getItemList().stream().filter(it -> it.getSkuId() == null).collect(Collectors.toList());
- //新建外协品生产外协入库单
- this.insertOutsideGoodsInto(outboundVO, outsideGoods);
- // 获取商品明细数据
- List<OutboundItemVO> invList = outboundVO.getItemList().stream().filter(it -> it.getSkuId() != null).collect(Collectors.toList());
- // 赋值修改明细
- map.put("outDetail", invList);
- // 删除的商品
- if(outboundVO.getDeleteItemList()!=null && outboundVO.getDeleteItemList().size()>0){
- // 获取外协删除数据
- List<OutboundItemVO> invsideDelList = outboundVO.getDeleteItemList().stream().filter(it -> it.getSkuId() == null).collect(Collectors.toList());
- //删除外协品生产外协入库单
- this.deleteOutsideGoodsInto(outboundVO, invsideDelList);
- // 获取删除商品数据
- List<OutboundItemVO> invDelList = outboundVO.getDeleteItemList().stream().filter(it -> it.getSkuId() != null).collect(Collectors.toList());
- // 赋值删除明细
- map.put("delOutDetail", invDelList);
- }
- // 调用修改库存信息方法
- inventoryService.operatingInventoryInformation(map);
- }
- //endregion
- return ResponseResultUtil.success(outboundVO);
- }
- /**
- * @desc : 销售出库撤销
- * @date : 2024/3/7 17:06
- * @author : 寇珊珊
- */
- @Transactional(rollbackFor = {Exception.class})
- public ResponseResultVO<?> saleOrderOutboundCancel(OutboundVO outboundVO) {
- //region 查询出库总单数据信息
- OutboundResponse outboundResponse = outboundMapper.selectById(outboundVO.getOutId());
- //endregion
- //region 应收反记账
- if (outboundResponse.getReceivableId() != null) {
- accountService.reverseReceivable(outboundResponse.getOutId(), Constant.InventoryDocCode.OUTBOUND.getTableName());
- }
- //endregion
- //region 修改订单数据信息
- if (outboundResponse.getFromId() != null) {
- //赋值 (这里重写了更新方法,数量在更新方法中有数据库院士数量+本次数量)
- Order order = new Order();
- order.setOrderId(outboundResponse.getFromId());
- order.setOutingQty(outboundResponse.getOutQty());
- order.setOutingAmt(outboundResponse.getOutAmt());
- order.setOutQty(outboundResponse.getOutQty().negate());
- order.setOutAmt(outboundResponse.getOutAmt().negate());
- //根据id查询
- OrderResponse orderResponse = orderMapper.selectById(outboundResponse.getFromId());
- //出库状态
- String outStatus = this.setOutStatus(orderResponse.getOutingQty().add(order.getOutingQty()),
- orderResponse.getOutQty().add(order.getOutQty()), orderResponse.getSumQuantity());
- order.setOutStatus(outStatus);
- //修改
- int countRow = orderMapper.updateById(order);
- //数量超出
- if (countRow == 0) {
- throw new BaseBusinessException(ResponseCodeEnum.OPERATE_FAIL.getCode(), ErrorCodeEnum.INVENTORY_QUANTITY_EXCEEDED_OUTBOUND.getMessage());
- }
- }
- //endregion
- //region 修改总单数据信息
- Outbound outbound = new Outbound();
- outbound.setOutId(outboundResponse.getOutId());
- outbound.setOutDate(null);
- outbound.setOutStatus(Constant.OutStatus.CHUKUZHONG.getName());
- outbound.setOutQty(BigDecimal.ZERO);
- outbound.setOutAmt(BigDecimal.ZERO);
- outbound.setOutingQty(outboundResponse.getOutingQty().add(outboundResponse.getOutQty()));
- outbound.setOutingAmt(outboundResponse.getOutingAmt().add(outboundResponse.getOutAmt()));
- //修改
- outboundMapper.update(outbound,
- new UpdateWrapper<Outbound>().lambda()
- .eq(Outbound::getOutId, UUID.fromString(outbound.getOutId()))
- );
- //endregion
- //region 明细数据
- //根据总单id查明细
- List<OutboundItemResponse> outboundItemResponseList = outboundItemMapper.selectByCond(new OutboundItemQuery().setOutId(outboundResponse.getOutId()));
- for (OutboundItemResponse outboundItemResponse : outboundItemResponseList) {
- //region 修改销售订单明细数据信息
- if (outboundItemResponse.getFromItemId() != null) {
- //根据id查询
- OrderItemResponse orderItemResponse = orderItemMapper.selectById(outboundItemResponse.getFromItemId());
- //赋值 (这里重写了更新方法,数量在更新方法中有数据库院士数量+本次数量)
- OrderItem orderItem = new OrderItem();
- orderItem.setItemId(outboundItemResponse.getFromItemId());
- orderItem.setOutQty(outboundItemResponse.getOutQty().negate());
- orderItem.setOutAmt(outboundItemResponse.getOutAmt().negate());
- orderItem.setOutingQty(outboundItemResponse.getOutQty());
- orderItem.setOutingAmt(outboundItemResponse.getOutAmt());
- //出库状态
- String outStatus = this.setOutStatus(orderItemResponse.getOutingQty().add(orderItem.getOutingQty()),
- orderItemResponse.getOutQty().add(orderItem.getOutQty()), orderItemResponse.getItemQty());
- orderItem.setOutStatus(outStatus);
- //修改
- int countRow = orderItemMapper.updateById(orderItem);
- //数量超出
- if (countRow == 0) {
- throw new BaseBusinessException(ResponseCodeEnum.OPERATE_FAIL.getCode(), ErrorCodeEnum.INVENTORY_QUANTITY_EXCEEDED_OUTBOUND.getMessage());
- }
- }
- //endregion
- //region修改出库明细信息
- OutboundItem outboundItem = new OutboundItem();
- //region 将库存需要的参数赋值
- outboundItemResponse.setInventoryType(Constant.InventoryType.OUTBOUND.getName());
- outboundItemResponse.setInventoryDocCode(Constant.InventoryDocCode.SALE_ORDER.getValue());
- outboundItemResponse.setOutQty(outboundItemResponse.getOutQty().negate());
- outboundItemResponse.setOutQty(outboundItemResponse.getOutQty().negate());
- //endregion
- outboundItem
- .setOutId(outboundResponse.getOutId())
- .setOutStatus(Constant.OutStatus.CHUKUZHONG.getName())
- .setOutingQty(outboundItemResponse.getOutingQty().add(outboundItemResponse.getOutQty()))
- .setOutAmt(outboundItemResponse.getOutingAmt().add(outboundItemResponse.getOutAmt()))
- .setOutQty(BigDecimal.ZERO)
- .setOutAmt(BigDecimal.ZERO)
- .setCostPrice(BigDecimal.ZERO)
- .setCostAmt(BigDecimal.ZERO)
- .setItemId(outboundItemResponse.getItemId());
- //修改
- outboundItemMapper.update(outboundItem,
- new UpdateWrapper<OutboundItem>().lambda()
- .eq(OutboundItem::getItemId, UUID.fromString(outboundItem.getItemId()))
- );
- //endregion
- }
- //endregion
- //region 外协品新建外协入库单
- //筛选出skuId为空的 走外协品逻辑
- OutboundVO outsideGoodVO = outboundConvert.convertResToVO(outboundResponse);
- List<OutboundItemResponse> outsideGoods = outboundItemResponseList.stream().filter(it -> it.getSkuId() == null).collect(Collectors.toList());
- List<OutboundItemVO> outsideGoodsVOList = outboundItemConvert.convertResListToVOList(outsideGoods);
- //删除外协品生产外协入库单
- this.deleteOutsideGoodsInto(outsideGoodVO, outsideGoodsVOList);
- //endregion
- //region 调用库存
- //筛选出skuId不为空的 走库存
- List<OutboundItemResponse> invList = outboundItemResponseList.stream().filter(it -> it.getSkuId() != null).collect(Collectors.toList());
- if(invList!=null && invList.size()>0) {
- Map<String, Object> map = new HashMap<>();
- map.put("delOutDetail", invList);
- inventoryService.operatingInventoryInformation(map);
- }
- //endregion
- return ResponseResultUtil.success();
- }
- /**
- * @desc : 出库状态通用(目前本页面)
- * @date : 2024/3/9 8:59
- * @author : 寇珊珊
- */
- @Transactional(rollbackFor = {Exception.class})
- public String setOutStatus(BigDecimal outingQty, BigDecimal outQty) {
- //出库状态
- String outStatus = null;
- //已出库数量>0 出库中数量>0
- if (outQty.compareTo(BigDecimal.ZERO) >= 0 && outingQty.compareTo(BigDecimal.ZERO) > 0) {
- //出库中
- outStatus = Constant.OutStatus.CHUKUZHONG.getName();
- }
- //出入库数量=0 出库中数量=0
- else if (outQty.compareTo(BigDecimal.ZERO) == 0 && outingQty.compareTo(BigDecimal.ZERO) == 0) {
- //待出库
- outStatus = Constant.OutStatus.DAICHUKU.getName();
- }
- //已出库数量>0 出库中数量=0
- else if (outQty.compareTo(BigDecimal.ZERO) > 0 && outingQty.compareTo(BigDecimal.ZERO) == 0) {
- //已出库
- outStatus = Constant.OutStatus.YICHUKU.getName();
- }
- return outStatus;
- }
- /**
- * @desc : 上游单据入库状态通用(目前本页面)
- * @date : 2024/4/1 17:14
- * @author : 寇珊珊
- */
- @Transactional(rollbackFor = {Exception.class})
- public String setOutStatus(BigDecimal intoingQty, BigDecimal intoQty, BigDecimal sumQty) {
- //入库状态
- String outStatus = null;
- //入库中+已入库 小于 总数
- if (intoingQty.add(intoQty).compareTo(sumQty) < 0) {
- //入库中
- outStatus = Constant.OutStatus.CHUKUZHONG.getName();
- }
- //已入库数量=0 入库中数量=0
- else if (intoQty.compareTo(BigDecimal.ZERO) == 0 && intoingQty.compareTo(BigDecimal.ZERO) == 0) {
- //待入库
- outStatus = Constant.OutStatus.DAICHUKU.getName();
- }
- //入库中+已入库 等于 总数
- else if (intoingQty.add(intoQty).compareTo(sumQty) == 0) {
- //已入库
- outStatus = Constant.OutStatus.YICHUKU.getName();
- }
- return outStatus;
- }
- /**
- * @desc : 获取单据信息(编辑用)
- * @date : 2024/3/16 16:28
- * @author : 寇珊珊
- */
- public ResponseResultVO<?> selectByUpdate(String id) {
- Map<String, Object> dataInfo = new HashMap<>();
- //总单
- OutboundResponse outboundResponse = outboundMapper.selectMessageByOtherQuery(new OutboundQuery().setOutId(id).setOutStatus(Constant.OutStatus.CHUKUZHONG.getName()));
- //单据不存在
- if (outboundResponse == null) {
- throw new BaseBusinessException(ErrorCodeEnum.THERE_ORDER_IS_NOT_CAN_OUTBOUND_QUANTITY.getCode(),
- ErrorCodeEnum.THERE_ORDER_IS_NOT_CAN_OUTBOUND_QUANTITY.getMessage());
- }
- dataInfo.put("data", outboundResponse);
- // 明细
- List<OutboundItemResponse> outboundItemResponseList = outboundItemMapper.selectByCond(new OutboundItemQuery().setOutId(outboundResponse.getOutId()));
- dataInfo.put("dataItem", outboundItemResponseList);
- return ResponseResultUtil.success(dataInfo);
- }
- /********************************************** 销售出库查询相关方法begin *************************************/
- /**
- * @desc : 一览页销售出库
- * @author : 付斌
- * @date : 2023/1/9 10:40
- */
- @Pagination
- public ResponseResultVO<PageList<OutboundResponse>> selectByCond(OutboundQuery outboundQuery) {
- outboundQuery.setOutType(Constant.OutType.SALE.getName());
- return super.mergeListWithCount(outboundQuery, outboundMapper.selectByCond(outboundQuery),
- outboundMapper.countByCond(outboundQuery));
- }
- /**
- * @desc : 一览页销售出库明细(货物、附件)
- * @author : 付斌
- * @date : 2024-02-28 13:25
- */
- @Pagination
- public ResponseResultVO<Map<String, Object>> selectOutboundInfoById(String id) {
- Map<String, Object> result = new HashMap<>();
- // 商品明细
- List<OutboundItemResponse> outboundItem = outboundItemMapper.selectByCond(new OutboundItemQuery().setOutId(id));
- result.put("outboundItem", outboundItem);
- // 附件
- return ResponseResultUtil.success(result);
- }
- /**
- * @desc : 获取销售出库信息(编辑用)
- * @author : 付斌
- * @date : 2024-03-02 17:27
- */
- public ResponseResultVO<?> getOutboundForUpdate(String id) {
- Map<String, Object> dataInfo = new HashMap<>();
- OutboundResponse outboundResponse = outboundMapper.selectById(id);
- dataInfo.put("data", outboundResponse);
- // 商品明细
- List<OutboundItemResponse> outboundItemResponseList = outboundItemMapper.selectByCondForOutEdit(id);
- dataInfo.put("dataItem", outboundItemResponseList);
- return ResponseResultUtil.success(dataInfo);
- }
- /**
- * @desc : 获取销售出库信息(编辑用,适用于直接新建的出库单)
- * @author : 付斌
- * @date : 2024-03-02 17:27
- */
- public ResponseResultVO<?> getOutboundTogetherForUpdate(String id) {
- Map<String, Object> dataInfo = new HashMap<>();
- OutboundResponse outboundResponse = outboundMapper.selectById(id);
- dataInfo.put("data", outboundResponse);
- // 商品明细
- List<OutboundItemResponse> outboundItemResponseList = outboundItemMapper.selectByCondForOutEditTogether(id);
- dataInfo.put("dataItem", outboundItemResponseList);
- return ResponseResultUtil.success(dataInfo);
- }
- /**
- * @desc : 获取出库信息(新建退货用)
- * @author : 付斌
- * @date : 2024-03-02 17:27
- */
- public ResponseResultVO<?> getOutForReturn(String id) {
- OutboundResponse outboundResponse = outboundMapper.selectByIdForReturn(id);
- List<OutboundItemResponse> outboundItemList = outboundItemMapper.selectByCondForReturn(new OutboundItemQuery().setOutId(id));
- if (outboundItemList != null && outboundItemList.size() > 0) {
- // 求和
- OutboundItemResponse sumEntity = outboundItemList.stream().reduce((x, y) -> {
- OutboundItemResponse item = new OutboundItemResponse();
- item.setOutingQty(x.getOutingQty().add(y.getOutingQty()));
- item.setOutingAmt(x.getOutingAmt().add(y.getOutingAmt()));
- return item;
- }).get();
- outboundResponse.setOutingQty(sumEntity.getOutingQty()).setOutingAmt(sumEntity.getOutingAmt());
- }
- Map<String, Object> dataInfo = new HashMap<>();
- dataInfo.put("data", outboundResponse);
- dataInfo.put("dataItem", outboundItemList);
- return ResponseResultUtil.success(dataInfo);
- }
- /**
- * @desc : 查询出库明细(货物、附件)
- * @author : 付斌
- * @date : 2024-02-28 13:25
- */
- @Pagination
- public ResponseResultVO selectById(String id) {
- OutboundResponse outboundResponse = outboundMapper.selectById(id);
- // 商品明细
- List<OutboundItemResponse> outboundItem = outboundItemMapper.selectByCond(new OutboundItemQuery().setOutId(id));
- outboundResponse.setGoodsList(outboundItem);
- // 附件
- return ResponseResultUtil.success(outboundResponse);
- }
- /********************************************** 销售出库查询相关方法end *************************************/
- // /**
- // * @desc : 条件查询
- // * @date : 2024/3/18 11:20
- // * @author : 寇珊珊
- // */
- // @Pagination
- // public ResponseResultVO<PageList<InboundResponse>> selectByCond(OutboundQuery outboundQuery) {
- // return super.mergeListWithCount(outboundQuery, outboundMapper.selectByCond(outboundQuery),
- // outboundMapper.countByCond(outboundQuery));
- // }
- //
- // /**
- // * @desc : 查询明细
- // * @date : 2024/3/15 16:43
- // * @author : 寇珊珊
- // */
- // @Pagination
- // public ResponseResultVO<Map<String, Object>> selectOutBoundSaleOrderItemInfoById(String id) {
- // Map<String, Object> result = new HashMap<>();
- // // 商品明细
- // List<OutboundItemResponse> outboundItemResponseList = outboundItemMapper.selectByCond(new OutboundItemQuery().setOutId(id));
- // result.put("itemList", outboundItemResponseList);
- // // 收款
- //
- // // 附件
- // return ResponseResultUtil.success(result);
- // }
- /**
- * @desc : 条件查询(总单带明细)
- * @author : 于继渤
- * @date : 2023/1/9 10:36
- */
- @Pagination
- public ResponseResultVO<PageList<OutboundResponse>> selectByCondDetail(OutboundQuery outboundQuery) {
- return super.mergeListWithCount(outboundQuery, outboundMapper.selectByCondDetail(outboundQuery),
- outboundMapper.countByCondDetail(outboundQuery));
- }
- }
|