wms / hhwms · Files

package com.huaheng.pc.receipt.receiptContainerHeader.service;

import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONObject;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.huaheng.common.utils.Wrappers;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.huaheng.common.constant.QuantityConstant;
import com.huaheng.common.exception.service.ServiceException;
import com.huaheng.common.utils.StringUtils;
import com.huaheng.common.utils.http.HttpUtils;
import com.huaheng.common.utils.security.ShiroUtils;
import com.huaheng.framework.web.domain.AjaxResult;
import com.huaheng.framework.web.service.ConfigService;
import com.huaheng.mobile.receipt.ReceiptBill;
import com.huaheng.pc.config.address.domain.Address;
import com.huaheng.pc.config.address.service.AddressService;
import com.huaheng.pc.config.company.domain.CompanyU8;
import com.huaheng.pc.config.company.service.CompanyU8Service;
import com.huaheng.pc.config.configValue.domain.ConfigValue;
import com.huaheng.pc.config.configValue.mapper.ConfigValueMapper;
import com.huaheng.pc.config.configValue.service.ConfigValueService;
import com.huaheng.pc.config.container.domain.Container;
import com.huaheng.pc.config.container.service.ContainerService;
import com.huaheng.pc.config.location.domain.Location;
import com.huaheng.pc.config.location.service.LocationService;
import com.huaheng.pc.config.material.domain.Material;
import com.huaheng.pc.config.material.service.MaterialService;
import com.huaheng.pc.config.receiptPreference.domain.ReceiptPreference;
import com.huaheng.pc.config.receiptPreference.mapper.ReceiptPreferenceMapper;
import com.huaheng.pc.inventory.inventoryDetail.domain.InventoryDetail;
import com.huaheng.pc.inventory.inventoryDetail.service.InventoryDetailService;
import com.huaheng.pc.receipt.receiptContainerDetail.domain.ReceiptContainerDetail;
import com.huaheng.pc.receipt.receiptContainerDetail.service.ReceiptContainerDetailService;
import com.huaheng.pc.receipt.receiptContainerHeader.domain.ReceiptContainerHeader;
import com.huaheng.pc.receipt.receiptContainerHeader.domain.ReceiptContainerView;
import com.huaheng.pc.receipt.receiptContainerHeader.mapper.ReceiptContainerHeaderMapper;
import com.huaheng.pc.receipt.receiptDetail.domain.ReceiptDetail;
import com.huaheng.pc.receipt.receiptDetail.service.ReceiptDetailService;
import com.huaheng.pc.receipt.receiptHeader.domain.ReceiptHeader;
import com.huaheng.pc.receipt.receiptHeader.service.ReceiptHeaderService;
import com.huaheng.pc.receipt.receiving.domain.ReceivingDamain;
import com.huaheng.pc.shipment.shipmentContainerHeader.domain.ShipmentContainerHeader;
import com.huaheng.pc.shipment.shipmentContainerHeader.service.ShipmentContainerHeaderService;
import com.huaheng.pc.srm.service.FinishedProductService;
import com.huaheng.pc.task.taskHeader.domain.TaskHeader;
import com.huaheng.pc.task.taskHeader.service.TaskHeaderService;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import javax.annotation.Resource;
import java.math.BigDecimal;
import java.text.MessageFormat;
import java.util.*;

/**
 * @author huaheng
 */
@Service
public class ReceiptContainerHeaderServiceImpl extends ServiceImpl<ReceiptContainerHeaderMapper, ReceiptContainerHeader> implements ReceiptContainerHeaderService{

    @Resource
    private TaskHeaderService taskHeaderService;
    @Resource
    private LocationService locationService;
    @Resource
    private ReceiptDetailService receiptDetailService;
    @Resource
    private ReceiptContainerDetailService receiptContainerDetailService;
    @Resource
    private MaterialService materialService;
    @Resource
    private ContainerService containerService;
    @Resource
    private ReceiptHeaderService receiptHeaderService;
    @Resource
    private InventoryDetailService inventoryDetailService;
    @Resource
    private ReceiptPreferenceMapper receiptPreferenceMapper;
    @Resource
    private ConfigValueMapper configValueMapper;
    @Resource
    private ConfigService configService;
    @Resource
    private ShipmentContainerHeaderService shipmentContainerHeaderService;
    @Resource
    private CompanyU8Service companyU8Service;
    @Resource
    private FinishedProductService finishedProductService;


    /**
     * 保存入库组盘
     * param receiptCode 入库单编码
     * param containerCode 容器编码
     * param receiptDetailId 入库单详情id
     * param locationCode 库位编码
     * param qty 收货数量
     * param locatingRule 定位规则
     * @return 是否保存成功
     */
    @Override
    @Transactional(rollbackFor = Exception.class)
    public AjaxResult saveContainer(ReceiptContainerView receivingDamain) {
        String receiptCode=receivingDamain.getReceiptCode();
        String containerCode=receivingDamain.getContainerCode();
        Integer receiptDetailId=receivingDamain.getReceiptDetailId();
        String locationCode=receivingDamain.getLocationCode();
        BigDecimal qty=receivingDamain.getQty();
        String locatingRule=receivingDamain.getLocatingRule();
        ReceiptDetail detail = receiptDetailService.getById(receiptDetailId);

        BigDecimal receiptQty = detail.getQty().subtract(detail.getTaskQty());
        if(receiptQty.compareTo(qty) < 0) {
            return AjaxResult.error("入库明细可用数量"+receiptQty+",收货数量"+qty+"；不允许超收");
        }

        //检查容器编码合法性
        Integer taskType = checkContainer(containerCode, detail.getMaterialCode());
        switch (taskType){
            case 1:
                //创建临时容器
//            containerCode = createContainer();
//            taskType = QuantityConstant.TASK_TYPE_WHOLERECEIPT;
                throw new ServiceException("没有容器");
            case 2:
                throw new ServiceException("该物料不能放在这个容器上，请检查该物料是否可以混放");
            default:
                if (taskType == 0){ throw new ServiceException("容器状态未知"); }
                break;
        }

        /*if (taskType == 1) {
            throw new ServiceException("没有容器");
        } else if (taskType == 2) {
            throw new ServiceException("该物料不能放在这个容器上，请检查该物料是否可以混放");
        } else {
            if (taskType == 0){ throw new ServiceException("容器状态未知"); }
        }*/
        if (QuantityConstant.TASK_TYPE_SUPPLEMENTRECEIPT == taskType.intValue()) {
            Container container = containerService.getContainerByCode(containerCode);
            if (StringUtils.isNotNull(container) && StringUtils.isNotEmpty(container.getLocationCode())) {
                locationCode = container.getLocationCode();
            }
        }
        //检查库位编码合法性
        checkLocationCode(locationCode, containerCode, taskType);

        int unCompleteCombineNumber = shipmentContainerHeaderService.getUnCompleteCombineNumber(containerCode);
        if(unCompleteCombineNumber > 0) {
            throw new ServiceException("该托盘已经用于出库组盘");
        }
        /* 新建保存组盘头表记录*/
        //根据容器编码查询组盘表头记录
        LambdaQueryWrapper<ReceiptContainerHeader> lambda = Wrappers.lambdaQuery();
        lambda.eq(ReceiptContainerHeader::getContainerCode, containerCode)
            .eq(ReceiptContainerHeader::getStatus, QuantityConstant.RECEIPT_CONTAINER_BUILD);
        lambda.last("limit 1");
        ReceiptContainerHeader receiptContainerHeader = this.getOne(lambda);

//        ReceiptContainerHeader receiptContainerHeader = new ReceiptContainerHeader();
        //当size大于等于1表示容器已经有组盘了
        if (receiptContainerHeader==null){
            ReceiptDetail receiptDetail = receiptDetailService.getById(receiptDetailId);
            // 创建组盘头表
            receiptContainerHeader=createReceiptContainerHeader(receiptContainerHeader,containerCode,locationCode,receiptDetail,taskType,locatingRule);
            if (!this.save(receiptContainerHeader)){
                throw new ServiceException("入库组盘头表保存失败");
            }
        } else {
//            receiptContainerHeader = list.get(0);
            if (receiptContainerHeader.getStatus() >= QuantityConstant.RECEIPT_CONTAINER_TASK && receiptContainerHeader.getStatus() < QuantityConstant.RECEIPT_CONTAINER_FINISHED){
                throw new ServiceException("容器已经生成任务，不能放物料了！");
            }
        }
        List<ReceiptContainerHeader> receiptContainerHeaders = this.list(lambda);
        /* 更新入库单详情的收货数量*/
        //根据入库单详情id查询入库详情
        ReceiptDetail receiptDetail = receiptDetailService.getById(receiptDetailId);
        receiptDetail.setId(receiptDetailId);
        receiptDetail.setTaskQty(qty.add(receiptDetail.getTaskQty()));
        //更新入库单详情的收货数量
        if (!receiptDetailService.updateById(receiptDetail)){
            throw new ServiceException("更新入库单详情失败");
        }

        receiptDetail = receiptDetailService.getById(receiptDetailId);
        //save组盘明细
        receiptContainerDetailAdd(receiptContainerHeaders.get(0), receiptDetail, qty, containerCode, locationCode);
        //如果单据数量等于已收数量，更新入库详情状态和入库单状态
        if (receiptDetail.getQty().compareTo(receiptDetail.getTaskQty()) == 0){
            if (StringUtils.isNotEmpty(locationCode)){
                receiptDetail.setProcessStamp(QuantityConstant.RECEIPT_HEADER_POSITION.toString());
            } else {
                receiptDetail.setProcessStamp(QuantityConstant.RECEIPT_HEADER_RECEIVING.toString());
            }
            if (!receiptDetailService.updateById(receiptDetail)){
                throw new ServiceException("更新入库详情处理标记失败");
            }

            ReceiptDetail receiptDetail1 = receiptDetailService.queryflow(receiptDetail);
            if (!receiptDetailService.updateById(receiptDetail1)){
                throw new ServiceException("更新入库详情下一流程失败");
            }
        }
        receiptDetailService.updateReceiptHeaderLastStatus(receiptDetail.getReceiptId());
        return AjaxResult.success("组盘成功");
    }

    public ReceiptContainerHeader createReceiptContainerHeader(ReceiptContainerHeader receiptContainerHeader
    ,String containerCode,String locationCode,ReceiptDetail receiptDetail,Integer taskType,String locatingRule){
        receiptContainerHeader=new ReceiptContainerHeader();
        receiptContainerHeader.setWarehouseCode(ShiroUtils.getWarehouseCode());
        receiptContainerHeader.setCompanyCode(receiptDetail.getCompanyCode());
        receiptContainerHeader.setContainerCode(containerCode);
        Container container = containerService.getContainerByCode(containerCode);
        receiptContainerHeader.setContainerType(container.getContainerType());
        receiptContainerHeader.setTaskType(taskType);

        if(ShiroUtils.getWarehouseCode().equals(QuantityConstant.WAREHOUSE_KS)){
            //U8工单领料齐套验证
            ksCheckMesReceipt(receiptDetail);
        }

        if (taskType.equals(QuantityConstant.TASK_TYPE_SUPPLEMENTRECEIPT)) {
            receiptContainerHeader.setFromLocation(container.getLocationCode());
            String value = configService.getKey(QuantityConstant.RULE_TASK_LOCATION);
            int taskLocationRule = Integer.parseInt(value);
            if (taskLocationRule == QuantityConstant.RULE_TASK_SET_LOCATION) {
                receiptContainerHeader.setToLocation(container.getLocationCode());
            }
        } else {
            receiptContainerHeader.setToLocation(locationCode);
        }
        receiptContainerHeader.setProjectNo(receiptDetail.getProjectNo());
        receiptContainerHeader.setCreatedBy(ShiroUtils.getLoginName());
        receiptContainerHeader.setLastUpdatedBy(ShiroUtils.getLoginName());
        receiptContainerHeader.setLocatingRule(locatingRule);
        return receiptContainerHeader;
    }
    //U8工单领料齐套验证
    public void ksCheckMesReceipt(ReceiptDetail receiptDetail){
        ReceiptHeader receiptHeader=receiptHeaderService.getById(receiptDetail.getReceiptId());
        if(receiptHeader.getReceiptType().equals("SI")&&StringUtils.isNotEmpty(receiptDetail.getReferLineNum())){
            CompanyU8 companyWu = new CompanyU8();
            companyWu.setCompanyCode(receiptHeader.getCompanyCode());
            companyWu = companyU8Service.getByCode(companyWu);
            if(companyWu == null){
                throw new ServiceException("入库单对应的U8账套不存在");
            }
            Map detailMap = new HashMap();
            detailMap.put("MODID",receiptDetail.getReferLineNum());
            detailMap.put("iQuantity",receiptDetail.getQty());
            detailMap.put("itemcode",receiptDetail.getMaterialCode());

            List<Map> maps = new ArrayList<>();
            maps.add(detailMap);

            Map<String,Object> map = new HashMap();
            map.put("CompanyCode",companyWu.getUCompanyCode());
            map.put("details",maps);
            AjaxResult ajaxResult = finishedProductService.checkMesReceipt(map);
            if(ajaxResult.hasErr()){
                throw new ServiceException(ajaxResult.getMsg());
            }
        }
    }

    /**
     * 超收检查
     * @param detail
     * @param qty
     */
    private void checkOverReceiving(ReceiptDetail detail, BigDecimal qty){
        BigDecimal _total = detail.getTaskQty().add(qty);
        if(_total.compareTo(detail.getQty()) <= 0){
            //收货量<=明细总量
            return;
        }

        ConfigValue configValue = configValueMapper.getConfigValue(ShiroUtils.getWarehouseCode(), "receipt");
        ReceiptPreference preference = receiptPreferenceMapper.getReceiptPreference(ShiroUtils.getWarehouseCode(),configValue.getValue());
        if(!preference.getAllowOverReceiving()){
            //入库首选项配置为不允许超收
            throw new ServiceException(String.format("不允许超收"));
        }

        //超收比例
        BigDecimal _over_rate = new BigDecimal(String.valueOf(1 + preference.getAllowOverReceivingQty() / 100.0));
        //超收量上限
        BigDecimal _total_over = detail.getQty().multiply (_over_rate);
        if(_total_over.compareTo(_total) >= 0){
            //在入库首选项的超收范围内
            return;
        }

        //超过了入库首选项配置的超收比例
        throw new ServiceException(String.format("超收上限是: %s％",
                _over_rate.multiply(new BigDecimal(100)) ));
    }

    /**
     * 批量撤销入库组盘
     * @param ids 容器头表标识列表
     * @return true 全部取消成功
     */
    @Override
    @Transactional(rollbackFor = Exception.class)
    public Boolean cancelByIds(List<Integer> ids) {
        for (Integer id : ids) {
            //如果已生成任务则不允许取消组盘
            if (this.getById(id).getStatus() < QuantityConstant.RECEIPT_CONTAINER_TASK){
                //根据组盘头表id查询组盘明细表
                LambdaQueryWrapper<ReceiptContainerDetail> containerDetailLambda = Wrappers.lambdaQuery();
                containerDetailLambda.eq(ReceiptContainerDetail::getReceiptContainerId, id);
                List<ReceiptContainerDetail> receiptContainerDetails = receiptContainerDetailService.list(containerDetailLambda);

                //查询入库单明细,减去已收数量，更新单据
                for (ReceiptContainerDetail receiptContainerDetail: receiptContainerDetails){
                    ReceiptDetail receiptDetail = receiptDetailService.getById(receiptContainerDetail.getReceiptDetailId());
                    receiptDetail.setTaskQty(receiptDetail.getTaskQty().subtract(receiptContainerDetail.getQty()));
                    if (!receiptDetailService.updateById(receiptDetail)){throw new ServiceException("回滚入库明细失败"); }

                    containerDetailLambda = Wrappers.lambdaQuery();
                    containerDetailLambda.eq(ReceiptContainerDetail::getReceiptId, receiptContainerDetail.getReceiptId());
                    List<ReceiptContainerDetail> containerDetailList = receiptContainerDetailService.list(containerDetailLambda);

                    //如果是临时容器，取消组盘时删除容器表
                    containerService.removeContainer(receiptContainerDetail.getContainerType(), receiptContainerDetail.getContainerCode());

                    //如果入库组盘没有该入库单的组盘信息，回滚入库单状态
                    if (containerDetailList == null){
                        ReceiptHeader receiptHeader = new ReceiptHeader();
                        receiptHeader.setId(receiptContainerDetail.getReceiptId());
                        receiptHeader.setFirstStatus(QuantityConstant.RECEIPT_HEADER_RECEIVING);
                        receiptHeader.setLastStatus(QuantityConstant.RECEIPT_HEADER_RECEIVING);
                        receiptHeader.setLastUpdatedBy(ShiroUtils.getLoginName());

                        if (!receiptHeaderService.updateById(receiptHeader)){ throw new ServiceException("回滚头表状态失败"); }
                    }

                    if (!receiptContainerDetailService.removeById(receiptContainerDetail.getId())){
                        throw new ServiceException("删除入库组盘明细表失败，id是"+receiptContainerDetail.getId());
                    }
                }
                //删除入库组盘头表
                if (!this.removeById(id)){
                    throw new ServiceException("删除入库组盘头表失败");
                }
            } else {
                throw new ServiceException("已生成任务不允许取消");
            }
        }
        return true;
    }

    /**
     * 检查容器状态
     *
     * @param record 容器实列
     * @return 成功 ；可以使用容器
     */
    @Override
    public AjaxResult checkContainer(ReceiptContainerView record) {
        //容器都是单据SN码，每个入库单都是新增容器

        if (com.huaheng.common.utils.StringUtils.isEmpty(record.getContainerCode())) {
            throw new ServiceException("容器不能为空");
        }

        if (taskHeaderService.UncompleteCount(record.getContainerCode()).intValue() > 0) {
            throw new ServiceException("容器已经存在任务，请更换容器");
        }
        return AjaxResult.success("");
    }


    @Override
    public AjaxResult batchSave(List<ReceiptContainerView> list) {
        if (list.size() < 1) {
            throw new ServiceException("收货明细是空！");
        }
        checkContainer(list.get(0));

        AjaxResult ajaxResult = null;
        for (ReceiptContainerView receiptContainerView : list) {
           /* ReceivingDamain receivingDamain=new ReceivingDamain();
            com.huaheng.common.utils.bean.BeanUtils.copyBeanProp(receivingDamain, receiptContainerView);
            receivingDamain.setContainerCode(receiptContainerView.getReceiptContainerCode());*/

            ajaxResult = saveContainer(receiptContainerView);
        }
        return ajaxResult;
    }

    /**
     * 移动端校验库位
     * @param record
     * @return
     */
    @Override
    public Boolean mobileCheckLocationCode(ReceiptContainerView record) {
        return checkLocationCode(record.getLocationCode(), record.getContainerCode(), Integer.valueOf(record.getTaskType()));
    }

    /**
     * 检查容器编码合法性
     * @param containerCode 容器编码
     * @param materialCode 物料编码
     * @return 返回容器状态，如果需自动生成容器编码返回1
     */
    @Transactional
    public Integer checkContainer(String containerCode, String materialCode) {
        Material material = materialService.getMaterialByCode(materialCode);
        if (StringUtils.isEmpty(containerCode)){
            if (material.getAutoGenSerialNum() == 0){
               return 1;
               //需自动生成容器编码
            } else {
                throw new ServiceException("容器不能为空");
            }
        }
        /**
         * 判断物料是否可以放在当前容器
         */
        if (!material.getIsMix()) {
            LambdaQueryWrapper<InventoryDetail> queryWrapper = Wrappers.lambdaQuery();
            queryWrapper.eq(InventoryDetail::getContainerCode, containerCode);
            /* 该容器已存物料数*/
            int inventoryDetailCount = inventoryDetailService.count(queryWrapper);
            LambdaQueryWrapper<InventoryDetail> lambdaQueryWrapper = Wrappers.lambdaQuery();
            lambdaQueryWrapper.eq(InventoryDetail::getContainerCode, containerCode)
                    .eq(InventoryDetail::getMaterialCode, materialCode);
            /* 该容器存放该物料的记录数*/
            int inventoryDetailMaterialCount = inventoryDetailService.count(lambdaQueryWrapper);
            /* 存放多种物料时返回*/
            if (inventoryDetailCount != inventoryDetailMaterialCount) {
                return 2;
            }
        }
        LambdaQueryWrapper<Container> lambda = Wrappers.lambdaQuery();
        lambda.eq(Container::getCode, containerCode);
        lambda.eq(Container::getWarehouseCode, ShiroUtils.getWarehouseCode());
        Container container = containerService.getOne(lambda);
        if (container == null){
            throw new ServiceException("该容器编号不存在");
        }

        if (container.getStatus().equals(QuantityConstant.STATUS_CONTAINER_LOCK)){
            throw new ServiceException("容器已经锁定，不能再组盘");
        }
        //检查该容器编码是否已存任务
        LambdaQueryWrapper<TaskHeader> lambdaQueryWrapper = Wrappers.lambdaQuery();
        lambdaQueryWrapper.eq(TaskHeader::getContainerCode, containerCode)
                .lt(TaskHeader::getStatus, QuantityConstant.TASK_STATUS_COMPLETED)
                .eq(TaskHeader::getWarehouseCode, ShiroUtils.getWarehouseCode());
        if (taskHeaderService.count(lambdaQueryWrapper) > 0){
            throw new ServiceException("容器已经存在任务，请更换容器");
        }
        if (StringUtils.isEmpty(container.getLocationCode())){
            return QuantityConstant.TASK_TYPE_WHOLERECEIPT;
        }else if (StringUtils.isNotEmpty(container.getStatus())
                &&(container.getStatus().equals(QuantityConstant.STATUS_CONTAINER_EMPTY)
                ||container.getStatus().equals(QuantityConstant.STATUS_CONTAINER_SOME))) {
            return QuantityConstant.TASK_TYPE_SUPPLEMENTRECEIPT;
        } else if (QuantityConstant.STATUS_CONTAINER_FULL.equals(container.getStatus())) {
            throw new ServiceException("该容器已满，请更换容器");
        }
        return 0;
    }

    /**
     * 检查库位是否合法
     * @param locationCode 库位编码
     * @param containerCode 容器编码
     * @param taskType 任务类型
     * @return
     */
    @Transactional
    Boolean checkLocationCode(String locationCode, String containerCode, Integer taskType) {
        //如果选了库位，就要校验库位和已经组盘的库位是否一致，避免重入库
        if (StringUtils.isEmpty(locationCode)) {
            if  (QuantityConstant.TASK_TYPE_SUPPLEMENTRECEIPT  == taskType.intValue()) {
                throw new ServiceException("补充入库，必须填写库位");
            } else {
                return true;
            }
        }

        Location location = locationService.getLocationByCode(locationCode, ShiroUtils.getWarehouseCode());
        if (location == null) {
            throw new ServiceException("库位不存在！");
        }
        if (!QuantityConstant.STATUS_LOCATION_EMPTY.equals(location.getStatus()) ) {
            throw new ServiceException("库位不是空闲状态！");
        }
        if (QuantityConstant.TASK_TYPE_WHOLERECEIPT == taskType.intValue()) {
            if (StringUtils.isNotEmpty(location.getContainerCode())) {
                throw new ServiceException("库位(" + locationCode + ")有容器(" + location.getContainerCode() + ")，不能整盘入库！");
            }
        }
        if(QuantityConstant.TASK_TYPE_SUPPLEMENTRECEIPT== taskType.intValue())  {
            if (StringUtils.isEmpty(location.getContainerCode())){
                throw new ServiceException("库位(" + locationCode + ")没有容器，不能补充入库！");
            } else if (!location.getContainerCode().equals(containerCode)) {
                throw new ServiceException("库位(" + containerCode + ")对应的容器是：" + location.getContainerCode()+ "，请重选库位！");
            }
        }
        return true;
    }

    /**
     * 增加组盘明细记录
     * @param
     * @param receiptDetail 入库详情
     * @param qty 收货数量
     * @param containerCode 容器编码
     */
    @Transactional
    public void receiptContainerDetailAdd(ReceiptContainerHeader receiptContainerHeader, ReceiptDetail receiptDetail, BigDecimal qty, String containerCode, String locationCode){
        int receiptContainerHeaderId = receiptContainerHeader.getId();
        LambdaQueryWrapper<ReceiptContainerDetail> lambda = Wrappers.lambdaQuery();
        lambda.eq(ReceiptContainerDetail::getReceiptContainerId, receiptContainerHeaderId)
                .eq(ReceiptContainerDetail::getReceiptId, receiptDetail.getReceiptId())
                .eq(ReceiptContainerDetail::getReceiptDetailId, receiptDetail.getId())
                .last("Limit 1");
        ReceiptContainerDetail receiptContainerDetail = receiptContainerDetailService.getOne(lambda);

        if (receiptContainerDetail == null){
            //查询入库头表
            LambdaQueryWrapper<ReceiptHeader> receiptHeaderLambda = Wrappers.lambdaQuery();
            receiptHeaderLambda.eq(ReceiptHeader::getId, receiptDetail.getReceiptId())
                    .eq(ReceiptHeader::getCode, receiptDetail.getReceiptCode());
            ReceiptHeader receiptHeader = receiptHeaderService.getOne(receiptHeaderLambda);

            //查询容器
            LambdaQueryWrapper<Container> containerLambda = Wrappers.lambdaQuery();
            containerLambda.eq(Container::getCode, containerCode)
                    .eq(Container::getWarehouseCode, ShiroUtils.getWarehouseCode());
            Container container = containerService.getOne(containerLambda);

            receiptContainerDetail = new ReceiptContainerDetail();
            receiptContainerDetail.setReceiptContainerId(receiptContainerHeaderId);
            receiptContainerDetail.setWarehouseCode(ShiroUtils.getWarehouseCode());
            receiptContainerDetail.setReceiptId(receiptDetail.getReceiptId());
            receiptContainerDetail.setReceiptDetailId(receiptDetail.getId());
            receiptContainerDetail.setTaskType(receiptContainerHeader.getTaskType());
            receiptContainerDetail.setReceiptCode(receiptDetail.getReceiptCode());
            receiptContainerDetail.setReceiptType(receiptHeader.getReceiptType());
            receiptContainerDetail.setLocationCode(locationCode);
            receiptContainerDetail.setContainerCode(container.getCode());
            receiptContainerDetail.setContainerType(container.getContainerType());
            receiptContainerDetail.setCompanyCode(receiptDetail.getCompanyCode());
            receiptContainerDetail.setMaterialCode(receiptDetail.getMaterialCode());
            receiptContainerDetail.setMaterialName(receiptDetail.getMaterialName());
            receiptContainerDetail.setMaterialSpec(receiptDetail.getMaterialSpec());
            receiptContainerDetail.setMaterialUnit(receiptDetail.getMaterialUnit());
            receiptContainerDetail.setQty(qty);
            receiptContainerDetail.setSupplierCode(receiptDetail.getSupplierCode());
            receiptContainerDetail.setBatch(receiptDetail.getBatch());
            receiptContainerDetail.setLot(receiptDetail.getLot());
            receiptContainerDetail.setProjectNo(receiptDetail.getProjectNo());
            receiptContainerDetail.setManufactureDate(receiptDetail.getManufactureDate());
            receiptContainerDetail.setExpirationDate(receiptDetail.getExpirationDate());
            receiptContainerDetail.setAgingDate(receiptDetail.getAgingDate());
            receiptContainerDetail.setInventorySts(receiptDetail.getInventorySts());
            receiptContainerDetail.setCreatedBy(ShiroUtils.getLoginName());
            receiptContainerDetail.setLastUpdatedBy(ShiroUtils.getLoginName());
            receiptContainerDetail.setSyncMms(0);
            receiptContainerDetail.setZoneCode(container.getZoneCode());
            if (!receiptContainerDetailService.save(receiptContainerDetail)){
                throw new ServiceException("保存入库组盘详情失败");
            }
        } else {
            receiptContainerDetail.setQty(receiptContainerDetail.getQty().add(qty));
            if (!receiptContainerDetailService.updateById(receiptContainerDetail)){
                throw new ServiceException("更新入库组盘详情失败");
            }
        }

    }


    /**
     * 自动生成容器编码
     * @return 容器编码
     */
    @Transactional
    public String createContainer(){
        String code = MessageFormat.format("{0}{1}",
                "LS",
                String.format("%d", Calendar.getInstance().getTimeInMillis()));
        Container container = new Container();
        container.setCode(code);
        container.setWarehouseCode(ShiroUtils.getWarehouseCode());
        container.setCompanyCode(ShiroUtils.getCompanyCodeList().get(0));
        container.setContainerType("LS");
        container.setCreatedBy(ShiroUtils.getLoginName());
        container.setLastUpdated(new Date());
        container.setLastUpdatedBy(ShiroUtils.getLoginName());
        container.setEnable(true);
        container.setStatus(QuantityConstant.STATUS_CONTAINER_EMPTY);
        if (!containerService.save(container)){
            throw new ServiceException("新增容器失败");
        }
        return code;
    }

    @Override
    @Transactional
    public int insertTodayReceiptContainerHeader(ReceiptBill receiptBill, String receiptCode) {
        String receiptContainerCode = receiptBill.getReceiptContainerCode();
        String locationCode = receiptBill.getLocationCode();
        String companyCode = receiptBill.getCompanyCode();
        ReceiptContainerHeader recorder = new ReceiptContainerHeader();
        recorder.setContainerCode(receiptContainerCode);
        recorder.setToLocation(locationCode);
        recorder.setWarehouseCode(ShiroUtils.getWarehouseCode());
        recorder.setCompanyCode(companyCode);
        recorder.setTaskType(QuantityConstant.TASK_TYPE_WHOLERECEIPT);
        recorder.setStatus(QuantityConstant.RECEIPT_CONTAINER_BUILD);
        recorder.setCreatedBy(ShiroUtils.getLoginName());
        recorder.setLastUpdatedBy(ShiroUtils.getLoginName());

        LambdaQueryWrapper<ReceiptContainerHeader> receiptContainerHeaderLambada = Wrappers.lambdaQuery();
        receiptContainerHeaderLambada.eq(ReceiptContainerHeader::getContainerCode, receiptContainerCode)
                .eq(ReceiptContainerHeader::getCompanyCode, companyCode)
                .eq(ReceiptContainerHeader::getTaskType, String.valueOf(QuantityConstant.TASK_TYPE_WHOLERECEIPT))
                .eq(ReceiptContainerHeader::getStatus, 0);

        ReceiptContainerHeader receiptContainerHeader = getOne(receiptContainerHeaderLambada);
        if(receiptContainerHeader == null) {
            save(recorder);
        } else {
            return receiptContainerHeader.getId();
        }

        locationService.updateStatus(locationCode, QuantityConstant.STATUS_LOCATION_LOCK);
        containerService.updateLocationCodeAndStatus(receiptContainerCode,
                locationCode, QuantityConstant.STATUS_CONTAINER_SOME);
        return recorder.getId();
    }

    /**
     * 取消入库任务
     * @param id 入库组盘头id
     * @return
     */
    @Override
    @Transactional
    public AjaxResult cancelReceipt(Integer id) {
        /**
         * 回滚组盘主表状态
         */
        ReceiptContainerHeader receiptContainerHeader = new ReceiptContainerHeader();
        receiptContainerHeader.setStatus(QuantityConstant.RECEIPT_CONTAINER_BUILD);
        receiptContainerHeader.setId(id);
        if (!updateById(receiptContainerHeader)){
            throw new ServiceException("回滚入库组盘头表失败");
        }

        /**
         * 回滚组盘明细状态
         */
        LambdaQueryWrapper<ReceiptContainerDetail> lambdaQueryWrapper = Wrappers.lambdaQuery();
        lambdaQueryWrapper.eq(ReceiptContainerDetail::getReceiptContainerId, id);
        List<ReceiptContainerDetail> containerDetailList = receiptContainerDetailService.list(lambdaQueryWrapper);
        for (ReceiptContainerDetail containerDetail : containerDetailList) {
            containerDetail.setStatus(QuantityConstant.RECEIPT_CONTAINER_BUILD);
        }
        if (!receiptContainerDetailService.updateBatchById(containerDetailList)) {
            throw new ServiceException("回滚入库组盘明细失败");
        }

        /**
         * 回滚入库单头表、入库单明细状态
         */
        for (ReceiptContainerDetail containerDetail : containerDetailList) {
            ReceiptHeader receiptHeader = receiptHeaderService.getById(containerDetail.getReceiptId());
            receiptHeader.setLastStatus(QuantityConstant.RECEIPT_HEADER_WAIT);
            ReceiptDetail receiptDetail = receiptDetailService.getById(containerDetail.getReceiptDetailId());
            receiptDetail.setProcessStamp(String.valueOf(QuantityConstant.RECEIPT_HEADER_WAIT));
            if (!receiptHeaderService.updateById(receiptHeader)) {
                throw new ServiceException("回滚入库单头表失败");
            }
            if (!receiptDetailService.updateById(receiptDetail)) {
                throw new ServiceException("回滚入库单明细失败");
            }
        }
        return AjaxResult.success("成功");
    }

    @Override
    public int getUnCompleteCombineNumber(String containerCode) {
        LambdaQueryWrapper<ReceiptContainerHeader> receiptContainerHeaderLambdaQueryWrapper = Wrappers.lambdaQuery();
        receiptContainerHeaderLambdaQueryWrapper.eq(ReceiptContainerHeader::getContainerCode, containerCode)
                .lt(ReceiptContainerHeader::getStatus, QuantityConstant.RECEIPT_CONTAINER_FINISHED);
        int number = 0;
        List<ReceiptContainerHeader> receiptContainerHeaderList = list(receiptContainerHeaderLambdaQueryWrapper);
        if(receiptContainerHeaderList != null && receiptContainerHeaderList.size() > 0) {
            number = receiptContainerHeaderList.size();
        }
        return number;
    }

    @Override
    public List<ReceiptContainerHeader> getUnCompleteCombineList() {
        LambdaQueryWrapper<ReceiptContainerHeader> receiptContainerHeaderLambdaQueryWrapper = Wrappers.lambdaQuery();
        receiptContainerHeaderLambdaQueryWrapper
                .lt(ReceiptContainerHeader::getStatus, QuantityConstant.RECEIPT_CONTAINER_FINISHED);
        List<ReceiptContainerHeader> receiptContainerHeaderList = list(receiptContainerHeaderLambdaQueryWrapper);
        return receiptContainerHeaderList;
    }

    @Override
    public AjaxResult clearContainerHeader(){
        LambdaQueryWrapper<ReceiptContainerHeader> receiptContainerHeaderLambdaQueryWrapper = Wrappers.lambdaQuery();
        receiptContainerHeaderLambdaQueryWrapper.eq(ReceiptContainerHeader::getStatus,
                QuantityConstant.RECEIPT_CONTAINER_BUILD);
        List<ReceiptContainerHeader> receiptContainerHeaderList =
                this.list(receiptContainerHeaderLambdaQueryWrapper);
        for(ReceiptContainerHeader receiptContainerHeader : receiptContainerHeaderList) {
            Date date = receiptContainerHeader.getCreated();
            Date now = new Date();
            int fore = date.getDay();
            int day = now.getDay();
            if(fore != day) {
                this.removeById(receiptContainerHeader);
            }
        }

        LambdaQueryWrapper<ReceiptContainerHeader> receiptContainerHeaderLambdaQueryWrapper1 = Wrappers.lambdaQuery();
        receiptContainerHeaderLambdaQueryWrapper1.eq(ReceiptContainerHeader::getStatus,
                QuantityConstant.RECEIPT_CONTAINER_TASK);
        List<ReceiptContainerHeader> receiptContainerHeaderList1 =
                this.list(receiptContainerHeaderLambdaQueryWrapper1);
        for(ReceiptContainerHeader receiptContainerHeader : receiptContainerHeaderList1) {
            String containerCode = receiptContainerHeader.getContainerCode();
            LambdaQueryWrapper<TaskHeader> taskHeaderLambdaQueryWrapper = Wrappers.lambdaQuery();
            taskHeaderLambdaQueryWrapper.lt(TaskHeader::getStatus, QuantityConstant.TASK_STATUS_COMPLETED)
                    .in(TaskHeader::getTaskType, QuantityConstant.TASK_TYPE_WHOLERECEIPT,
                            QuantityConstant.TASK_TYPE_SUPPLEMENTRECEIPT)
                    .eq(TaskHeader::getContainerCode, containerCode);
            List<TaskHeader> taskHeaderList = taskHeaderService.list(taskHeaderLambdaQueryWrapper);
            if(taskHeaderList.size() == 0) {
                receiptContainerHeader.setStatus(QuantityConstant.RECEIPT_CONTAINER_FINISHED);
                this.updateById(receiptContainerHeader);
            }
        }

        LambdaQueryWrapper<ShipmentContainerHeader> shipmentContainerHeaderLambdaQueryWrapper = Wrappers.lambdaQuery();
        shipmentContainerHeaderLambdaQueryWrapper.eq(ShipmentContainerHeader::getStatus,
                QuantityConstant.SHIPMENT_CONTAINER_BUILD);
        List<ShipmentContainerHeader> shipmentContainerHeaderList =
                shipmentContainerHeaderService.list(shipmentContainerHeaderLambdaQueryWrapper);
        for(ShipmentContainerHeader shipmentContainerHeader : shipmentContainerHeaderList) {
            Date date = shipmentContainerHeader.getCreated();
            Date now = new Date();
            int fore = date.getDay();
            int day = now.getDay();
            if(fore != day) {
                shipmentContainerHeaderService.removeById(shipmentContainerHeader);
            }
        }

        LambdaQueryWrapper<ShipmentContainerHeader> shipmentContainerHeaderLambdaQueryWrapper1 = Wrappers.lambdaQuery();
        shipmentContainerHeaderLambdaQueryWrapper1.eq(ShipmentContainerHeader::getStatus,
                QuantityConstant.SHIPMENT_CONTAINER_TASK);
        List<ShipmentContainerHeader> shipmentContainerHeaderList1 =
                shipmentContainerHeaderService.list(shipmentContainerHeaderLambdaQueryWrapper1);
        for(ShipmentContainerHeader shipmentContainerHeader : shipmentContainerHeaderList1) {
            String containerCode = shipmentContainerHeader.getContainerCode();
            LambdaQueryWrapper<TaskHeader> taskHeaderLambdaQueryWrapper = Wrappers.lambdaQuery();
            taskHeaderLambdaQueryWrapper.lt(TaskHeader::getStatus, QuantityConstant.TASK_STATUS_COMPLETED)
                    .in(TaskHeader::getTaskType, QuantityConstant.TASK_TYPE_WHOLESHIPMENT,
                            QuantityConstant.TASK_TYPE_SORTINGSHIPMENT)
                    .eq(TaskHeader::getContainerCode, containerCode);
            List<TaskHeader> taskHeaderList = taskHeaderService.list(taskHeaderLambdaQueryWrapper);
            if(taskHeaderList.size() == 0) {
                shipmentContainerHeader.setStatus(QuantityConstant.SHIPMENT_CONTAINER_FINISHED);
                shipmentContainerHeaderService.updateById(shipmentContainerHeader);
            }
        }
        return AjaxResult.success();
    }



}