海政通
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
xuhy
4 天以前 1ec94c00e5c312818c9e1e3742ca838e60b7e5e7 
 ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TErpProcurementServiceImpl.java


@@ -7,9 +7,16 @@


import com.ruoyi.common.core.domain.BaseModel;


import com.ruoyi.common.core.domain.entity.SysUser;


import com.ruoyi.common.utils.DateUtils;


import com.ruoyi.common.utils.StringUtils;


import com.ruoyi.system.dto.AddProcurementDto;


import com.ruoyi.system.export.PlatformLedgerReportExport;


import com.ruoyi.system.export.ProcurementReportClinicExport;


import com.ruoyi.system.export.ProcurementReportPlatformExport;


import com.ruoyi.system.export.ProcurementReportSupplierExport;


import com.ruoyi.system.mapper.*;


import com.ruoyi.system.model.*;


import com.ruoyi.system.query.ClinicProcurementReportQuery;


import com.ruoyi.system.query.PerformanceReportQuery;


import com.ruoyi.system.query.TErpGoodsQuery;


import com.ruoyi.system.query.TErpProcurementQuery;


import com.ruoyi.system.service.TErpGoodsService;


@@ -32,6 +39,7 @@


import org.springframework.stereotype.Service;


import org.springframework.transaction.annotation.Propagation;


import org.springframework.transaction.annotation.Transactional;


import org.springframework.util.CollectionUtils;




import javax.annotation.Resource;


import javax.net.ssl.SSLContext;


@@ -44,9 +52,13 @@


import java.math.RoundingMode;


import java.security.PrivateKey;


import java.security.cert.X509Certificate;


import java.text.SimpleDateFormat;


import java.time.LocalDateTime;


import java.util.ArrayList;


import java.util.Collections;


import java.util.List;


import java.util.Map;


import java.util.Objects;


import java.util.stream.Collectors;




/**


@@ -87,6 +99,29 @@


    @Autowired


    private TErpProcurementGoodsService erpProcurementGoodsService;




    @Resource


    private TErpSupplierWarehousingMapper erpSupplierWarehousingMapper;




    @Resource


    private TErpSupplierWarehousingBatchMapper erpSupplierWarehousingBatchMapper;




    @Resource


    private TErpSupplierOutboundMapper erpSupplierOutboundMapper;




    @Resource


    private TErpSupplierOutboundGoodsMapper erpSupplierOutboundGoodsMapper;




    @Resource


    private TCrmWarehouseMapper crmWarehouseMapper;


    @Resource


    private TCrmBranchMapper crmBranchMapper;


    @Resource


    private TCrmSalespersonMapper crmSalespersonMapper;


    @Resource


    private TCrmChangePointsMapper crmChangePointsMapper;


    @Resource


    private TErpProcurementCommissionMapper erpProcurementCommissionMapper;






    @Override


    public PageInfo<TErpProcurementVo> pageList(TErpProcurementQuery query, SysUser user) {


@@ -124,25 +159,25 @@


        List<String> ids = list.stream().map(TErpProcurementVo::getId).collect(Collectors.toList());


        List<TErpProcurementGoods> tErpProcurementGoods = erpProcurementGoodsMapper.selectList


                (new LambdaQueryWrapper<TErpProcurementGoods>().in(TErpProcurementGoods::getProcurementId, ids));


        List<TSysCommission> tSysCommissions = new ArrayList<>();


        if (!tErpProcurementGoods.isEmpty()) {


            List<String> collect = tErpProcurementGoods.stream().map(TErpProcurementGoods::getId).collect(Collectors.toList());


            tSysCommissions = sysCommissionMapper.selectList(new LambdaQueryWrapper<TSysCommission>().in(TSysCommission::getTErpProcurementGoodsId, collect));


        }


////        List<TSysCommission> tSysCommissions = new ArrayList<>();


//        if (!tErpProcurementGoods.isEmpty()) {


////            List<String> collect = tErpProcurementGoods.stream().map(TErpProcurementGoods::getId).collect(Collectors.toList());


////            tSysCommissions = sysCommissionMapper.selectList(new LambdaQueryWrapper<TSysCommission>().in(TSysCommission::getTErpProcurementGoodsId, collect));


//        }


        for (TErpProcurementVo tErpProcurementVo : list) {


            List<TErpProcurementGoods> collect = tErpProcurementGoods.stream().filter(e -> e.getProcurementId().equals(tErpProcurementVo.getId())).collect(Collectors.toList());


            int size = collect.stream().map(TErpProcurementGoods::getGoodsId).collect(Collectors.toSet()).size();


            tErpProcurementVo.setTypeNum(size);


            BigDecimal reduce = collect.stream().map(TErpProcurementGoods::getTotalPrice).reduce(BigDecimal.ZERO, BigDecimal::add);


            tErpProcurementVo.setTotalPrice(reduce);


            if (!collect.isEmpty()) {


                List<String> collect1 = collect.stream().map(TErpProcurementGoods::getId).collect(Collectors.toList());


                List<TSysCommission> collect2 = tSysCommissions.stream().filter(e -> collect1.contains(e.getTErpProcurementGoodsId())).collect(Collectors.toList());


                BigDecimal reduce1 = collect2.stream().filter(e -> e.getType() == 1).map(TSysCommission::getMoney).reduce(BigDecimal.ZERO, BigDecimal::add);


                BigDecimal reduce2 = collect2.stream().filter(e -> e.getType() == 2).map(TSysCommission::getMoney).reduce(BigDecimal.ZERO, BigDecimal::add);


                tErpProcurementVo.setPlatformMoney(reduce1);


                tErpProcurementVo.setSupplierMoney(reduce2);


            }


//            if (!collect.isEmpty()) {


////                List<String> collect1 = collect.stream().map(TErpProcurementGoods::getId).collect(Collectors.toList());


////                List<TSysCommission> collect2 = tSysCommissions.stream().filter(e -> collect1.contains(e.getTErpProcurementGoodsId())).collect(Collectors.toList());


////                BigDecimal reduce1 = collect2.stream().filter(e -> e.getType() == 1).map(TSysCommission::getMoney).reduce(BigDecimal.ZERO, BigDecimal::add);


////                BigDecimal reduce2 = collect2.stream().filter(e -> e.getType() == 2).map(TSysCommission::getMoney).reduce(BigDecimal.ZERO, BigDecimal::add);


////                tErpProcurementVo.setPlatformMoney(reduce1);


////                tErpProcurementVo.setSupplierMoney(reduce2);


//            }




        }




@@ -156,15 +191,15 @@






        Integer roleType = user.getRoleType();


        String supplierClinicId = null;


        List<String> supplierClinicId = null;


        if (roleType == 6) {


            // 供应商


            TCrmSupplier crmSupplier = crmSupplierMapper.selectOne(Wrappers.lambdaQuery(TCrmSupplier.class)


                    .eq(TCrmSupplier::getUserId, user.getUserId())




            TCrmWarehouse warehouse = crmWarehouseMapper.selectOne(Wrappers.lambdaQuery(TCrmWarehouse.class)


                    .eq(TCrmWarehouse::getUserId, user.getUserId())


                    .last("LIMIT 1"));


            supplierClinicId = crmSupplier.getId();






            // 供应商


            supplierClinicId = crmSupplierMapper.selectList(Wrappers.lambdaQuery(TCrmSupplier.class)


                    .eq(TCrmSupplier::getWarehouseId, warehouse.getId())).stream().map(TCrmSupplier::getId).collect(Collectors.toList());


            String sTime = null;


            String eTime = null;


            if (query.getTime() != null && !query.getTime().isEmpty()) {


@@ -172,7 +207,11 @@


                sTime = split[0] + " 00:00:00";


                eTime = split[1] + " 23:59:59";


            }




            PageInfo<TErpProcurementVo> pageInfo = new PageInfo<>(query.getPageNum(), query.getPageSize());


            if(CollectionUtils.isEmpty(supplierClinicId)){


                return pageInfo;


            }


            List<TErpProcurementVo> list = this.baseMapper.pageListWarehouse(query, pageInfo, user, sTime, eTime, supplierClinicId);


//            if (list.isEmpty()) {


//                return pageInfo;


@@ -290,7 +329,7 @@


    @Override


    public PageInfo<TErpGoods> pageGoodsPageList(TErpGoodsQuery query, SysUser user) {


        PageInfo<TErpGoods> pageInfo = new PageInfo<>(query.getPageNum(), query.getPageSize());


        PageInfo<TErpGoods> p = erpGoodsMapper.selectPage(pageInfo, new LambdaQueryWrapper<TErpGoods>().eq(TErpGoods::getGoodsSource, 1).isNotNull(TErpGoods::getClinicPurchasePrice).orderByDesc(BaseModel::getCreateTime));


        PageInfo<TErpGoods> p = erpGoodsMapper.selectPage(pageInfo, new LambdaQueryWrapper<TErpGoods>().eq(TErpGoods::getState,1).eq(TErpGoods::getGoodsSource, 1).isNotNull(TErpGoods::getClinicPurchasePrice).orderByDesc(BaseModel::getCreateTime));


        List<TErpGoods> list = p.getRecords();




        List<String> typeIds = list.stream().map(TErpGoods::getTypeId).collect(Collectors.toList());


@@ -365,7 +404,7 @@


            BigDecimal all = BigDecimal.ZERO;




            for (AddProcurementDto addProcurementDto : value) {


                BigDecimal multiply = addProcurementDto.getSalesAmount().multiply(BigDecimal.valueOf(addProcurementDto.getPurchaseCount()));


                BigDecimal multiply = addProcurementDto.getGoodsSalesAmount().multiply(BigDecimal.valueOf(addProcurementDto.getPurchaseCount()));


                all = all.add(multiply);


            }


            tErpProcurement.setPayMoney(all);


@@ -379,6 +418,9 @@




            BigDecimal add = BigDecimal.ZERO;






            BigDecimal supplierCommissionPrice = BigDecimal.ZERO;




            for (AddProcurementDto dto : value) {


                TErpProcurementGoods tErpProcurementGoods = new TErpProcurementGoods();


                tErpProcurementGoods.setProcurementId(tErpProcurement.getId());


@@ -389,7 +431,9 @@


                tErpProcurementGoods.setQuasiNumber(goods.getQuasiNumber());




                TErpGoodsUnit tErpGoodsUnit = erpGoodsUnitMapper.selectById(goods.getPackingUnitId());


                tErpProcurementGoods.setUnitName(tErpGoodsUnit.getUnitName());


                if(tErpGoodsUnit!=null){


                    tErpProcurementGoods.setUnitName(tErpGoodsUnit.getUnitName());


                }


                tErpProcurementGoods.setPurchasePrice(dto.getGoodsSalesAmount());


                tErpProcurementGoods.setSalesAmount(dto.getSalesAmount());


                tErpProcurementGoods.setTotalPrice(dto.getGoodsSalesAmount().multiply(new BigDecimal(dto.getPurchaseCount())));


@@ -398,6 +442,7 @@


                tErpProcurementGoods.setSupplierId(supplierClinicId);


                tErpProcurementGoods.setRecvMerchantNo(supplier.getRecvMerchantNo());


                tErpProcurementGoods.setSupplierMoney(dto.getSalesAmount().subtract(dto.getPlatformCommissionPrice()));


                supplierCommissionPrice = supplierCommissionPrice.add(tErpProcurementGoods.getSupplierMoney().multiply(BigDecimal.valueOf(dto.getPurchaseCount())));


                if (tErpProcurementGoods.getSupplierMoney().doubleValue() < 0) {


                    throw new RuntimeException("平台抽成不能大于售卖价格");


                }


@@ -410,6 +455,7 @@


            if (tErpProcurement.getMoney().doubleValue() < 0) {


                throw new RuntimeException("金额设置错误，请联系平台管理员");


            }


            tErpProcurement.setSupplierMoney(supplierCommissionPrice);


            this.save(tErpProcurement);


            tErpProcurementGoods1.forEach(e -> e.setProcurementId(tErpProcurement.getId()));


            erpProcurementGoodsService.saveBatch(tErpProcurementGoods1);


@@ -421,6 +467,13 @@


    public DetailProcurementVO detailProcurement(String clinicSupplierId, SysUser user, String id) {


        DetailProcurementVO detailProcurementVO = new DetailProcurementVO();


        TErpProcurement tErpProcurement = this.getById(id);


        if (tErpProcurement.getWarehousingUserId()!=null && !tErpProcurement.getWarehousingUserId().isEmpty()) {


            SysUser sysUser = sysUserMapper.selectUserById(Long.valueOf(tErpProcurement.getWarehousingUserId()));


            detailProcurementVO.setWarehousingUserName(sysUser.getUserName());


        }


        detailProcurementVO.setWarehousingTime(tErpProcurement.getWarehousingTime());






        detailProcurementVO.setStatus(tErpProcurement.getStatus());


        detailProcurementVO.setCreateTime(tErpProcurement.getCreateTime());


        detailProcurementVO.setSendTime(tErpProcurement.getSendTime());


@@ -443,10 +496,533 @@


            detailProcurementNextVO.setTotalPrice(tErpProcurement.getPayMoney());


            detailProcurementNextVO.setId(tErpProcurementGoods.getId());


            detailProcurementNextVO.setPurchasePrice(tErpProcurementGoods.getPurchasePrice());




            List<TErpSupplierOutboundGoods> tErpSupplierOutboundGoods = erpSupplierOutboundGoodsMapper.selectList(new LambdaQueryWrapper<TErpSupplierOutboundGoods>().eq(TErpSupplierOutboundGoods::getProcurementGoodsId, tErpProcurementGoods.getId()));


            if(!tErpSupplierOutboundGoods.isEmpty()){


                ArrayList<DetailProcurementNextThreeVO> detailProcurementNextThreeVOS = new ArrayList<>();


                List<String> collect = tErpSupplierOutboundGoods.stream().map(TErpSupplierOutboundGoods::getWarehousingBatchId).collect(Collectors.toList());


                List<TErpSupplierWarehousingBatch> tErpSupplierWarehousingBatches = erpSupplierWarehousingBatchMapper.selectBatchIds(collect);


                for (TErpSupplierOutboundGoods tErpSupplierOutboundGood : tErpSupplierOutboundGoods) {


                    List<TErpSupplierWarehousingBatch> collect1 = tErpSupplierWarehousingBatches.stream().filter(e -> e.getId().equals(tErpSupplierOutboundGood.getWarehousingBatchId())).collect(Collectors.toList());


                    for (TErpSupplierWarehousingBatch tErpSupplierWarehousingBatch : collect1) {


                        DetailProcurementNextThreeVO detailProcurementNextThreeVO = new DetailProcurementNextThreeVO();


                        detailProcurementNextThreeVO.setBatchNumber(tErpSupplierWarehousingBatch.getBatchNumber());


                        detailProcurementNextThreeVO.setProductionDate(tErpSupplierWarehousingBatch.getProductionDate());


                        detailProcurementNextThreeVO.setExpirationDate(tErpSupplierWarehousingBatch.getExpiryDate());


                        detailProcurementNextThreeVO.setNum(tErpSupplierOutboundGood.getOutboundCount());


                        detailProcurementNextThreeVOS.add(detailProcurementNextThreeVO);


                    }


                }


                detailProcurementNextVO.setDetailProcurementNextThreeVOS(detailProcurementNextThreeVOS);


            }


            detailProcurementNextVOS.add(detailProcurementNextVO);


        }


        detailProcurementVO.setList(detailProcurementNextVOS);


        return detailProcurementVO;


    }




    @Override


    @Transactional(rollbackFor = Exception.class, propagation = Propagation.REQUIRED)


    public void detailProcurementSend(List<String> clinicSupplierId, SysUser user, String id,String logisticsNumber) {


        // 查出这个采购的下级商品


        List<TErpProcurementGoods> list = erpProcurementGoodsService.list(new QueryWrapper<TErpProcurementGoods>().eq("procurement_id", id));


        List<TErpSupplierWarehousing> tErpSupplierWarehousings = erpSupplierWarehousingMapper.selectList(new LambdaQueryWrapper<TErpSupplierWarehousing>()


                .in(TErpSupplierWarehousing::getSupplierId, clinicSupplierId).in(TErpSupplierWarehousing::getGoodsId, list.stream().map(TErpProcurementGoods::getGoodsId).collect(Collectors.toList()))


                .orderByAsc(BaseModel::getCreateTime));




        if(tErpSupplierWarehousings.isEmpty()){


            throw new RuntimeException("商品供应商未入库，请先入库");


        }




        List<TErpSupplierWarehousingBatch> tErpSupplierWarehousingBatches = erpSupplierWarehousingBatchMapper.selectList(new LambdaQueryWrapper<TErpSupplierWarehousingBatch>().in(TErpSupplierWarehousingBatch::getWarehousingId, tErpSupplierWarehousings.stream().map(TErpSupplierWarehousing::getId).collect(Collectors.toList())));


        // 获取所有的出库记录


        List<TErpSupplierOutboundGoods> tErpSupplierOutboundGoodsLists = erpSupplierOutboundGoodsMapper.selectList(new LambdaQueryWrapper<TErpSupplierOutboundGoods>().in(TErpSupplierOutboundGoods::getWarehousingBatchId, tErpSupplierWarehousingBatches.stream().map(TErpSupplierWarehousingBatch::getId).collect(Collectors.toList())));






        outer:for (TErpProcurementGoods tErpProcurementGoods : list) {


            // 分别入库


            String goodsId = tErpProcurementGoods.getGoodsId();


            // 查询这个供应商的 该商品是否入过库 未入库提示  出库判断库存 先找先入库的


            List<TErpSupplierWarehousing> collect = tErpSupplierWarehousings.stream().filter(e -> e.getGoodsId().equals(goodsId)).collect(Collectors.toList());


            if(collect.isEmpty()){


                throw new RuntimeException("商品供应商未入库，请先入库");


            }


            // 需要出库的数量


            Integer purchaseCount = tErpProcurementGoods.getPurchaseCount();






            if(purchaseCount==0){


                continue;


            }




            for (TErpSupplierWarehousing tErpSupplierWarehousing : collect) {


                List<TErpSupplierWarehousingBatch> warehousingBatches = tErpSupplierWarehousingBatches.stream().filter(e -> e.getWarehousingId().equals(tErpSupplierWarehousing.getId())).collect(Collectors.toList());


                for (TErpSupplierWarehousingBatch warehousingBatch : warehousingBatches) {


                    // 已出库数量


                    int sum = tErpSupplierOutboundGoodsLists.stream().filter(e -> e.getWarehousingBatchId().equals(warehousingBatch.getId())).mapToInt(TErpSupplierOutboundGoods::getOutboundCount).sum();


                    // 该批次剩余的数量


                    int count = warehousingBatch.getWarehousingNumber() - sum;




                    // 该批次没有数量 找下个批次


                    if(count==0 ){


                        continue;


                    }


                    // 如果大于这个数量 则使用这个批次


                    if(count>=purchaseCount){


                        // 添加出库记录


                        TErpSupplierOutbound tErpSupplierOutbound= new TErpSupplierOutbound();


                        tErpSupplierOutbound.setSupplierId(tErpSupplierWarehousing.getSupplierId());


                        tErpSupplierOutbound.setWarehouseId(tErpSupplierWarehousing.getWarehouseId());


                        tErpSupplierOutbound.setOutboundType(7);


                        //TODO 确定这个是采购价还是销售价格


                        tErpSupplierOutbound.setTotalMoney(tErpProcurementGoods.getPurchasePrice().multiply(new BigDecimal(purchaseCount)));


                        tErpSupplierOutbound.setOutboundNumber("G" + DateUtils.dateTimeNow());


                        erpSupplierOutboundMapper.insert(tErpSupplierOutbound);




                        TErpSupplierOutboundGoods tErpSupplierOutboundGoods = new TErpSupplierOutboundGoods();


                        tErpSupplierOutboundGoods.setOutboundId(tErpSupplierOutbound.getId());


                        tErpSupplierOutboundGoods.setWarehousingId(tErpSupplierWarehousing.getId());


                        tErpSupplierOutboundGoods.setWarehousingBatchId(warehousingBatch.getId());


                        tErpSupplierOutboundGoods.setOutboundCount(purchaseCount);


                        tErpSupplierOutboundGoods.setTotalPrice(tErpProcurementGoods.getPurchasePrice().multiply(new BigDecimal(purchaseCount)));


                        tErpSupplierOutboundGoods.setProcurementGoodsId(tErpProcurementGoods.getId());


                        erpSupplierOutboundGoodsMapper.insert(tErpSupplierOutboundGoods);


                        continue outer;


                    }




                    if(count<purchaseCount){


                        purchaseCount = purchaseCount - count;


                        // 添加出库记录


                        TErpSupplierOutbound tErpSupplierOutbound= new TErpSupplierOutbound();


                        tErpSupplierOutbound.setSupplierId(tErpSupplierWarehousing.getSupplierId());


                        tErpSupplierOutbound.setWarehouseId(tErpSupplierWarehousing.getWarehouseId());


                        tErpSupplierOutbound.setOutboundType(7);


                        //TODO 确定这个是采购价还是销售价格


                        tErpSupplierOutbound.setTotalMoney(tErpProcurementGoods.getPurchasePrice().multiply(new BigDecimal(purchaseCount)));


                        tErpSupplierOutbound.setOutboundNumber("G" + DateUtils.dateTimeNow());


                        erpSupplierOutboundMapper.insert(tErpSupplierOutbound);




                        TErpSupplierOutboundGoods tErpSupplierOutboundGoods = new TErpSupplierOutboundGoods();


                        tErpSupplierOutboundGoods.setOutboundId(tErpSupplierOutbound.getId());


                        tErpSupplierOutboundGoods.setWarehousingId(tErpSupplierWarehousing.getId());


                        tErpSupplierOutboundGoods.setWarehousingBatchId(warehousingBatch.getId());


                        tErpSupplierOutboundGoods.setOutboundCount(purchaseCount);


                        tErpSupplierOutboundGoods.setTotalPrice(tErpProcurementGoods.getPurchasePrice().multiply(new BigDecimal(purchaseCount)));


                        tErpSupplierOutboundGoods.setProcurementGoodsId(tErpProcurementGoods.getId());


                        erpSupplierOutboundGoodsMapper.insert(tErpSupplierOutboundGoods);


                    }




                }




            }


            if(purchaseCount>0){


                throw new RuntimeException("商品供应商库存不足，请先入库");


            }






        }


        TErpProcurement byId = this.getById(id);


        byId.setStatus(4);


        byId.setSendTime(LocalDateTime.now());


        byId.setLogisticsNumber(logisticsNumber);


        this.updateById(byId);




    }




    @Override


    public List<SupplierThirtyProcurementStatisticsVO> supplierThirtyProcurementStatistics(String supplierAndClinicId, String startTime, String endTime,Integer roleType) {


        return this.baseMapper.supplierThirtyProcurementStatistics(supplierAndClinicId, startTime, endTime, roleType);


    }




    @Override


    public List<SupplierThirtyMoneyProcurementStatisticsVO> supplierThirtyMoneyProcurementStatistics(String supplierAndClinicId, String startTime, String endTime,Integer roleType) {


        return this.baseMapper.supplierThirtyMoneyProcurementStatistics(supplierAndClinicId, startTime, endTime, roleType);


    }




    @Override


    public Integer supplierSalesStatisticsTypeCount(String supplierId) {


        return this.baseMapper.supplierSalesStatisticsTypeCount(supplierId);


    }




    @Override


    public Integer supplierSalesStatisticsCount(String supplierId) {


        return this.baseMapper.supplierSalesStatisticsCount(supplierId);


    }




    @Override


    public BigDecimal supplierSalesStatisticsMoney(String supplierId, String startTime, String endTime) {


        return this.baseMapper.supplierSalesStatisticsMoney(supplierId,startTime, endTime);


    }




    @Override


    public List<SupplierSalesStatisticsGoodsTypeVO> supplierSalesStatisticsGoodsType(String supplierId, String startTime, String endTime) {


        return this.baseMapper.supplierSalesStatisticsGoodsType(supplierId,startTime, endTime);


    }




    @Override


    public List<SupplierSalesStatisticsGoodsCountVO> supplierSalesStatisticsGoodsCount(String supplierId, String startTime, String endTime, String goodsName) {


        return this.baseMapper.supplierSalesStatisticsGoodsCount(supplierId,startTime, endTime,goodsName);


    }




    @Override


    public List<SupplierSalesStatisticsGoodsCountVO> supplierSalesStatisticsGoodsCountMonth(String supplierId, String startTime, String endTime, String goodsName) {


        return this.baseMapper.supplierSalesStatisticsGoodsCountMonth(supplierId,startTime, endTime,goodsName);


    }




    @Override


    public List<TErpProcurementGoods> branchAdminStatisticsThree(List<String> clinicIds) {


        return this.baseMapper.branchAdminStatisticsThree(clinicIds);


    }




    @Override


    public PageInfo<ClinicProcurementReportVO> clinicProcurementReport(ClinicProcurementReportQuery query) {


        PageInfo<ClinicProcurementReportVO> pageInfo = new PageInfo<>(query.getPageNum(), query.getPageSize());


        List<ClinicProcurementReportVO> list = this.baseMapper.clinicProcurementReport(query, pageInfo);


        if(CollectionUtils.isEmpty(list)){


            return pageInfo;


        }


        List<String> procurementIds = list.stream().map(TErpProcurement::getId).collect(Collectors.toList());


        List<TErpProcurementGoods> erpProcurementGoods = erpProcurementGoodsMapper.selectList(new QueryWrapper<TErpProcurementGoods>().lambda().in(TErpProcurementGoods::getProcurementId, procurementIds));


        for (ClinicProcurementReportVO clinicProcurementReportVO : list) {


            List<TErpProcurementGoods> procurementGoods = erpProcurementGoods.stream().filter(tErpProcurementGoods -> tErpProcurementGoods.getProcurementId().equals(clinicProcurementReportVO.getId())).collect(Collectors.toList());


            if(!CollectionUtils.isEmpty(procurementGoods)){


                int sum = procurementGoods.stream().mapToInt(TErpProcurementGoods::getPurchaseCount).sum();


                clinicProcurementReportVO.setProcurementGoodsNum(sum);


            }


        }


        pageInfo.setRecords(list);


        return pageInfo;


    }




    @Override


    public List<ProcurementReportClinicExport> exportProcurementReportClinic(ClinicProcurementReportQuery query) {


        List<ProcurementReportClinicExport> list = this.baseMapper.exportProcurementReportClinic(query);


        if(CollectionUtils.isEmpty(list)){


            return new ArrayList<>();


        }


        List<String> procurementIds = list.stream().map(ProcurementReportClinicExport::getId).collect(Collectors.toList());


        List<TErpProcurementGoods> erpProcurementGoods = erpProcurementGoodsMapper.selectList(new QueryWrapper<TErpProcurementGoods>().lambda().in(TErpProcurementGoods::getProcurementId, procurementIds));


        for (ProcurementReportClinicExport procurementReportClinicExport : list) {


            List<TErpProcurementGoods> procurementGoods = erpProcurementGoods.stream().filter(tErpProcurementGoods -> tErpProcurementGoods.getProcurementId().equals(procurementReportClinicExport.getId())).collect(Collectors.toList());


            if(!CollectionUtils.isEmpty(procurementGoods)){


                int sum = procurementGoods.stream().mapToInt(TErpProcurementGoods::getPurchaseCount).sum();


                procurementReportClinicExport.setProcurementGoodsNum(sum);


            }


            if(Objects.nonNull(procurementReportClinicExport.getPayTime())){


                String payTimeStr = new SimpleDateFormat("yyyy-MM-dd").format(DateUtils.localDateTimeToDate(procurementReportClinicExport.getPayTime()));


                procurementReportClinicExport.setPayTimeStr(payTimeStr);


            }


        }


        return list;


    }




    @Override


    public List<ProcurementReportSupplierExport> exportProcurementReportSupplier(ClinicProcurementReportQuery query) {


        List<ProcurementReportSupplierExport> list = this.baseMapper.exportProcurementReportSupplier(query);


        if(CollectionUtils.isEmpty(list)){


            return new ArrayList<>();


        }


        for (ProcurementReportSupplierExport procurementReportSupplierExport : list) {


            if(Objects.nonNull(procurementReportSupplierExport.getPayTime())){


                String payTimeStr = new SimpleDateFormat("yyyy-MM-dd").format(DateUtils.localDateTimeToDate(procurementReportSupplierExport.getPayTime()));


                procurementReportSupplierExport.setPayTimeStr(payTimeStr);


            }


        }


        return list;


    }




    @Override


    public List<ProcurementReportPlatformExport> exportProcurementReportPlatform(ClinicProcurementReportQuery query) {


        List<ProcurementReportPlatformExport> list = this.baseMapper.exportProcurementReportPlatform(query);


        if(CollectionUtils.isEmpty(list)){


            return new ArrayList<>();


        }


        for (ProcurementReportPlatformExport procurementReportPlatformExport : list) {


            if(Objects.nonNull(procurementReportPlatformExport.getPayTime())){


                String payTimeStr = new SimpleDateFormat("yyyy-MM-dd").format(DateUtils.localDateTimeToDate(procurementReportPlatformExport.getPayTime()));


                procurementReportPlatformExport.setPayTimeStr(payTimeStr);


            }


        }


        return list;


    }




    @Override


    public PageInfo<ClinicProcurementReportVO> platformLedgerReport(ClinicProcurementReportQuery query) {


        PageInfo<ClinicProcurementReportVO> pageInfo = new PageInfo<>(query.getPageNum(), query.getPageSize());


        List<ClinicProcurementReportVO> list = this.baseMapper.platformLedgerReport(query, pageInfo);


        pageInfo.setRecords(list);


        return pageInfo;


    }




    @Override


    public List<PlatformLedgerReportExport> exportPlatformLedgerReport(ClinicProcurementReportQuery query) {


        List<PlatformLedgerReportExport> list = this.baseMapper.exportPlatformLedgerReport(query);


        if(CollectionUtils.isEmpty(list)){


            return new ArrayList<>();


        }


        for (PlatformLedgerReportExport platformLedgerReportExport : list) {


            if(Objects.nonNull(platformLedgerReportExport.getPayTime())){


                String payTimeStr = new SimpleDateFormat("yyyy-MM-dd").format(DateUtils.localDateTimeToDate(platformLedgerReportExport.getPayTime()));


                platformLedgerReportExport.setPayTimeStr(payTimeStr);


            }


        }


        return list;


    }




    @Override


    public PageInfo<BranchPerformanceReportVO> branchPerformanceReport(PerformanceReportQuery query) {




        List<String> clinicIds = new ArrayList<>();




        if(StringUtils.isNotBlank(query.getBranchName())){


            // 查询分公司名称


            List<TCrmBranch> crmBranches = crmBranchMapper.selectList(Wrappers.lambdaQuery(TCrmBranch.class)


                    .like(TCrmBranch::getBranchName, query.getBranchName()));


            if(CollectionUtils.isEmpty(crmBranches)){


                return new PageInfo<>();


            }


            List<String> branchIds = crmBranches.stream().map(TCrmBranch::getId).collect(Collectors.toList());


            List<TCrmClinic> crmClinics = crmClinicMapper.selectList(Wrappers.lambdaQuery(TCrmClinic.class)


                    .in(TCrmClinic::getBranchId, branchIds));


            if(CollectionUtils.isEmpty(crmClinics)){


                return new PageInfo<>();


            }


            List<String> ids = crmClinics.stream().map(TCrmClinic::getId).collect(Collectors.toList());


            clinicIds.addAll(ids);


        }


        query.setClinicIds(clinicIds);


        PageInfo<BranchPerformanceReportVO> pageInfo = new PageInfo<>(query.getPageNum(), query.getPageSize());




        List<BranchPerformanceReportVO> list = this.baseMapper.branchPerformanceReport(query, pageInfo);


        if(CollectionUtils.isEmpty(list)){


            return pageInfo;


        }


        List<String> procurementIds = list.stream().map(BranchPerformanceReportVO::getId).collect(Collectors.toList());




        // 查询可获得积分


        List<TCrmChangePoints> crmChangePoints = crmChangePointsMapper.selectList(Wrappers.lambdaQuery(TCrmChangePoints.class)


                .in(TCrmChangePoints::getProcurementId, procurementIds)


                .eq(TCrmChangePoints::getUserType, 1)


                .eq(TCrmChangePoints::getChangeType, 1)


                .eq(TCrmChangePoints::getChangeReason, 1));


        // 查询业绩


        List<TErpProcurementCommission> erpProcurementCommissions = erpProcurementCommissionMapper.selectList(Wrappers.lambdaQuery(TErpProcurementCommission.class)


                .in(TErpProcurementCommission::getProcurementId, procurementIds)


                .eq(TErpProcurementCommission::getCommissionType, 1));


        for (BranchPerformanceReportVO branchPerformanceReportVO : list) {


            // 查询可获得积分


            List<TCrmChangePoints> changePoints = crmChangePoints.stream().filter(tCrmChangePoints -> branchPerformanceReportVO.getId().equals(tCrmChangePoints.getProcurementId())).collect(Collectors.toList());


            if(!CollectionUtils.isEmpty(changePoints)){


                branchPerformanceReportVO.setAvailablePoints(changePoints.stream().mapToInt(TCrmChangePoints::getChangeValue).sum());


            }


            // 查询业绩


            List<TErpProcurementCommission> commissions = erpProcurementCommissions.stream().filter(tErpProcurementCommission -> branchPerformanceReportVO.getId().equals(tErpProcurementCommission.getProcurementId())).collect(Collectors.toList());


            if(!CollectionUtils.isEmpty(commissions)){


                branchPerformanceReportVO.setPerformance(commissions.stream().map(TErpProcurementCommission::getMoney).reduce(BigDecimal.ZERO, BigDecimal::add));


            }


        }


        pageInfo.setRecords(list);


        return pageInfo;


    }




    @Override


    public PageInfo<SalespersonPerformanceReportVO> salespersonPerformanceReport(PerformanceReportQuery query) {


        List<String> clinicIds = new ArrayList<>();




        if(StringUtils.isNotBlank(query.getBranchName())){


            // 查询分公司名称


            List<TCrmBranch> crmBranches = crmBranchMapper.selectList(Wrappers.lambdaQuery(TCrmBranch.class)


                    .like(TCrmBranch::getBranchName, query.getBranchName()));


            if(CollectionUtils.isEmpty(crmBranches)){


                return new PageInfo<>();


            }


            List<String> branchIds = crmBranches.stream().map(TCrmBranch::getId).collect(Collectors.toList());


            List<TCrmClinic> crmClinics = crmClinicMapper.selectList(Wrappers.lambdaQuery(TCrmClinic.class)


                    .in(TCrmClinic::getBranchId, branchIds));


            if(CollectionUtils.isEmpty(crmClinics)){


                return new PageInfo<>();


            }


            List<String> ids = crmClinics.stream().map(TCrmClinic::getId).collect(Collectors.toList());


            clinicIds.addAll(ids);


        }


        if(StringUtils.isNotBlank(query.getSalespersonName())){


            // 查询业务员名称


            List<TCrmSalesperson> crmSalespeopleList = crmSalespersonMapper.selectList(Wrappers.lambdaQuery(TCrmSalesperson.class)


                    .like(TCrmSalesperson::getSalespersonName, query.getSalespersonName()));


            if(CollectionUtils.isEmpty(crmSalespeopleList)){


                return new PageInfo<>();


            }


            List<String> salespersonIds = crmSalespeopleList.stream().map(TCrmSalesperson::getId).collect(Collectors.toList());


            List<TCrmClinic> crmClinics = crmClinicMapper.selectList(Wrappers.lambdaQuery(TCrmClinic.class)


                    .in(TCrmClinic::getSalespersonId, salespersonIds));


            if(CollectionUtils.isEmpty(crmClinics)){


                return new PageInfo<>();


            }


            List<String> ids = crmClinics.stream().map(TCrmClinic::getId).collect(Collectors.toList());


            clinicIds.addAll(ids);


        }


        clinicIds = clinicIds.stream().distinct().collect(Collectors.toList());


        query.setClinicIds(clinicIds);


        PageInfo<SalespersonPerformanceReportVO> pageInfo = new PageInfo<>(query.getPageNum(), query.getPageSize());


        List<SalespersonPerformanceReportVO> list = this.baseMapper.salespersonPerformanceReport(query, pageInfo);


        if(CollectionUtils.isEmpty(list)){


            return pageInfo;


        }


        List<String> procurementIds = list.stream().map(SalespersonPerformanceReportVO::getId).collect(Collectors.toList());




        // 查询可获得积分


        List<TCrmChangePoints> crmChangePoints = crmChangePointsMapper.selectList(Wrappers.lambdaQuery(TCrmChangePoints.class)


                .in(TCrmChangePoints::getProcurementId, procurementIds)


                .eq(TCrmChangePoints::getUserType, 2)


                .eq(TCrmChangePoints::getChangeType, 1)


                .eq(TCrmChangePoints::getChangeReason, 1));


        // 查询业绩


        List<TErpProcurementCommission> erpProcurementCommissions = erpProcurementCommissionMapper.selectList(Wrappers.lambdaQuery(TErpProcurementCommission.class)


                .in(TErpProcurementCommission::getProcurementId, procurementIds)


                .eq(TErpProcurementCommission::getCommissionType, 2));


        for (SalespersonPerformanceReportVO salespersonPerformanceReportVO : list) {


            // 查询可获得积分


            List<TCrmChangePoints> changePoints = crmChangePoints.stream().filter(tCrmChangePoints -> salespersonPerformanceReportVO.getId().equals(tCrmChangePoints.getProcurementId())).collect(Collectors.toList());


            if(!CollectionUtils.isEmpty(changePoints)){


                salespersonPerformanceReportVO.setAvailablePoints(changePoints.stream().mapToInt(TCrmChangePoints::getChangeValue).sum());


            }


            // 查询业绩


            List<TErpProcurementCommission> commissions = erpProcurementCommissions.stream().filter(tErpProcurementCommission -> salespersonPerformanceReportVO.getId().equals(tErpProcurementCommission.getProcurementId())).collect(Collectors.toList());


            if(!CollectionUtils.isEmpty(commissions)){


                salespersonPerformanceReportVO.setPerformance(commissions.stream().map(TErpProcurementCommission::getMoney).reduce(BigDecimal.ZERO, BigDecimal::add));


            }


        }


        pageInfo.setRecords(list);


        return pageInfo;


    }




    @Override


    public List<BranchPerformanceReportVO> exportBranchPerformanceReport(PerformanceReportQuery query) {


        List<String> clinicIds = new ArrayList<>();




        if(StringUtils.isNotBlank(query.getBranchName())){


            // 查询分公司名称


            List<TCrmBranch> crmBranches = crmBranchMapper.selectList(Wrappers.lambdaQuery(TCrmBranch.class)


                    .like(TCrmBranch::getBranchName, query.getBranchName()));


            if(CollectionUtils.isEmpty(crmBranches)){


                return new ArrayList<>();


            }


            List<String> branchIds = crmBranches.stream().map(TCrmBranch::getId).collect(Collectors.toList());


            List<TCrmClinic> crmClinics = crmClinicMapper.selectList(Wrappers.lambdaQuery(TCrmClinic.class)


                    .in(TCrmClinic::getBranchId, branchIds));


            if(CollectionUtils.isEmpty(crmClinics)){


                return new ArrayList<>();


            }


            List<String> ids = crmClinics.stream().map(TCrmClinic::getId).collect(Collectors.toList());


            clinicIds.addAll(ids);


        }


        query.setClinicIds(clinicIds);


        List<BranchPerformanceReportVO> list = this.baseMapper.exportBranchPerformanceReport(query);


        if(CollectionUtils.isEmpty(list)){


            return new ArrayList<>();


        }


        List<String> procurementIds = list.stream().map(BranchPerformanceReportVO::getId).collect(Collectors.toList());




        // 查询可获得积分


        List<TCrmChangePoints> crmChangePoints = crmChangePointsMapper.selectList(Wrappers.lambdaQuery(TCrmChangePoints.class)


                .in(TCrmChangePoints::getProcurementId, procurementIds)


                .eq(TCrmChangePoints::getUserType, 1)


                .eq(TCrmChangePoints::getChangeType, 1)


                .eq(TCrmChangePoints::getChangeReason, 1));


        // 查询业绩


        List<TErpProcurementCommission> erpProcurementCommissions = erpProcurementCommissionMapper.selectList(Wrappers.lambdaQuery(TErpProcurementCommission.class)


                .in(TErpProcurementCommission::getProcurementId, procurementIds)


                .eq(TErpProcurementCommission::getCommissionType, 1));


        for (BranchPerformanceReportVO branchPerformanceReportVO : list) {


            // 查询可获得积分


            List<TCrmChangePoints> changePoints = crmChangePoints.stream().filter(tCrmChangePoints -> branchPerformanceReportVO.getId().equals(tCrmChangePoints.getProcurementId())).collect(Collectors.toList());


            if(!CollectionUtils.isEmpty(changePoints)){


                branchPerformanceReportVO.setAvailablePoints(changePoints.stream().mapToInt(TCrmChangePoints::getChangeValue).sum());


            }


            // 查询业绩


            List<TErpProcurementCommission> commissions = erpProcurementCommissions.stream().filter(tErpProcurementCommission -> branchPerformanceReportVO.getId().equals(tErpProcurementCommission.getProcurementId())).collect(Collectors.toList());


            if(!CollectionUtils.isEmpty(commissions)){


                branchPerformanceReportVO.setPerformance(commissions.stream().map(TErpProcurementCommission::getMoney).reduce(BigDecimal.ZERO, BigDecimal::add));


            }


            if(Objects.nonNull(branchPerformanceReportVO.getPayTime())){


                String payTimeStr = new SimpleDateFormat("yyyy-MM-dd").format(DateUtils.localDateTimeToDate(branchPerformanceReportVO.getPayTime()));


                branchPerformanceReportVO.setPayTimeStr(payTimeStr);


            }


        }


        return list;


    }




    @Override


    public List<SalespersonPerformanceReportVO> exportSalespersonPerformanceReport(PerformanceReportQuery query) {


        List<String> clinicIds = new ArrayList<>();




        if(StringUtils.isNotBlank(query.getBranchName())){


            // 查询分公司名称


            List<TCrmBranch> crmBranches = crmBranchMapper.selectList(Wrappers.lambdaQuery(TCrmBranch.class)


                    .like(TCrmBranch::getBranchName, query.getBranchName()));


            if(CollectionUtils.isEmpty(crmBranches)){


                return new ArrayList<>();


            }


            List<String> branchIds = crmBranches.stream().map(TCrmBranch::getId).collect(Collectors.toList());


            List<TCrmClinic> crmClinics = crmClinicMapper.selectList(Wrappers.lambdaQuery(TCrmClinic.class)


                    .in(TCrmClinic::getBranchId, branchIds));


            if(CollectionUtils.isEmpty(crmClinics)){


                return new ArrayList<>();


            }


            List<String> ids = crmClinics.stream().map(TCrmClinic::getId).collect(Collectors.toList());


            clinicIds.addAll(ids);


        }


        if(StringUtils.isNotBlank(query.getSalespersonName())){


            // 查询业务员名称


            List<TCrmSalesperson> crmSalespeopleList = crmSalespersonMapper.selectList(Wrappers.lambdaQuery(TCrmSalesperson.class)


                    .like(TCrmSalesperson::getSalespersonName, query.getSalespersonName()));


            if(CollectionUtils.isEmpty(crmSalespeopleList)){


                return new ArrayList<>();


            }


            List<String> salespersonIds = crmSalespeopleList.stream().map(TCrmSalesperson::getId).collect(Collectors.toList());


            List<TCrmClinic> crmClinics = crmClinicMapper.selectList(Wrappers.lambdaQuery(TCrmClinic.class)


                    .in(TCrmClinic::getSalespersonId, salespersonIds));


            if(CollectionUtils.isEmpty(crmClinics)){


                return new ArrayList<>();


            }


            List<String> ids = crmClinics.stream().map(TCrmClinic::getId).collect(Collectors.toList());


            clinicIds.addAll(ids);


        }


        clinicIds = clinicIds.stream().distinct().collect(Collectors.toList());


        query.setClinicIds(clinicIds);


        List<SalespersonPerformanceReportVO> list = this.baseMapper.exportSalespersonPerformanceReport(query);


        if(CollectionUtils.isEmpty(list)){


            return new ArrayList<>();


        }


        List<String> procurementIds = list.stream().map(SalespersonPerformanceReportVO::getId).collect(Collectors.toList());




        // 查询可获得积分


        List<TCrmChangePoints> crmChangePoints = crmChangePointsMapper.selectList(Wrappers.lambdaQuery(TCrmChangePoints.class)


                .in(TCrmChangePoints::getProcurementId, procurementIds)


                .eq(TCrmChangePoints::getUserType, 2)


                .eq(TCrmChangePoints::getChangeType, 1)


                .eq(TCrmChangePoints::getChangeReason, 1));


        // 查询业绩


        List<TErpProcurementCommission> erpProcurementCommissions = erpProcurementCommissionMapper.selectList(Wrappers.lambdaQuery(TErpProcurementCommission.class)


                .in(TErpProcurementCommission::getProcurementId, procurementIds)


                .eq(TErpProcurementCommission::getCommissionType, 2));


        for (SalespersonPerformanceReportVO salespersonPerformanceReportVO : list) {


            // 查询可获得积分


            List<TCrmChangePoints> changePoints = crmChangePoints.stream().filter(tCrmChangePoints -> salespersonPerformanceReportVO.getId().equals(tCrmChangePoints.getProcurementId())).collect(Collectors.toList());


            if(!CollectionUtils.isEmpty(changePoints)){


                salespersonPerformanceReportVO.setAvailablePoints(changePoints.stream().mapToInt(TCrmChangePoints::getChangeValue).sum());


            }


            // 查询业绩


            List<TErpProcurementCommission> commissions = erpProcurementCommissions.stream().filter(tErpProcurementCommission -> salespersonPerformanceReportVO.getId().equals(tErpProcurementCommission.getProcurementId())).collect(Collectors.toList());


            if(!CollectionUtils.isEmpty(commissions)){


                salespersonPerformanceReportVO.setPerformance(commissions.stream().map(TErpProcurementCommission::getMoney).reduce(BigDecimal.ZERO, BigDecimal::add));


            }


            if(Objects.nonNull(salespersonPerformanceReportVO.getPayTime())){


                String payTimeStr = new SimpleDateFormat("yyyy-MM-dd").format(DateUtils.localDateTimeToDate(salespersonPerformanceReportVO.getPayTime()));


                salespersonPerformanceReportVO.setPayTimeStr(payTimeStr);


            }


        }


        return list;


    }




}