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


@@ -1,24 +1,52 @@


package com.ruoyi.system.service.impl;




import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;


import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;


import com.baomidou.mybatisplus.core.toolkit.Wrappers;


import com.ruoyi.common.basic.PageInfo;


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


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


import com.ruoyi.common.utils.DateUtils;


import com.ruoyi.system.dto.AddProcurementDto;


import com.ruoyi.system.mapper.*;


import com.ruoyi.system.model.*;


import com.ruoyi.system.query.TErpGoodsQuery;


import com.ruoyi.system.query.TErpProcurementQuery;


import com.ruoyi.system.service.TErpGoodsService;


import com.ruoyi.system.service.TErpProcurementGoodsService;


import com.ruoyi.system.service.TErpProcurementService;


import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;


import com.ruoyi.system.vo.TErpProcurementDetailNextVo;


import com.ruoyi.system.vo.TErpProcurementDetailVo;


import com.ruoyi.system.vo.TErpProcurementVo;


import com.ruoyi.system.vo.ValidityPeriodWarningVo;


import com.ruoyi.system.vo.*;


import lombok.SneakyThrows;


import org.apache.commons.io.IOUtils;


import org.apache.http.HttpResponse;


import org.apache.http.client.HttpClient;


import org.apache.http.client.methods.HttpPost;


import org.apache.http.conn.ClientConnectionManager;


import org.apache.http.conn.scheme.Scheme;


import org.apache.http.conn.scheme.SchemeRegistry;


import org.apache.http.conn.ssl.SSLSocketFactory;


import org.apache.http.entity.StringEntity;


import org.apache.http.impl.client.DefaultHttpClient;


import org.springframework.beans.factory.annotation.Autowired;


import org.springframework.stereotype.Service;


import org.springframework.transaction.annotation.Propagation;


import org.springframework.transaction.annotation.Transactional;




import javax.annotation.Resource;


import javax.net.ssl.SSLContext;


import javax.net.ssl.TrustManager;


import javax.net.ssl.X509TrustManager;


import java.io.File;


import java.io.FileInputStream;


import java.io.IOException;


import java.math.BigDecimal;


import java.math.RoundingMode;


import java.security.PrivateKey;


import java.security.cert.X509Certificate;


import java.util.ArrayList;


import java.util.List;


import java.util.Map;


import java.util.stream.Collectors;




/**


@@ -39,13 +67,49 @@


    private TSysCommissionMapper sysCommissionMapper;




    @Resource


    private TCrmClinicMapper crmClinicMapper;


    private  TCrmClinicMapper crmClinicMapper;




    @Resource


    private  TCrmSupplierMapper crmSupplierMapper;




    @Resource


    private SysUserMapper sysUserMapper;




    @Resource


    private TErpGoodsMapper erpGoodsMapper;




    @Resource


    private TErpGoodsTypeMapper erpGoodsTypeMapper;




    @Resource


    private TErpGoodsUnitMapper erpGoodsUnitMapper;




    @Autowired


    private TErpProcurementGoodsService erpProcurementGoodsService;








    @Override


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






        Integer roleType = user.getRoleType();


        String supplierClinicId = null;


        if(roleType == 4){


            // 供应商


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


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


                    .last("LIMIT 1"));


            supplierClinicId =crmSupplier.getId();


        }


        if(roleType == 5){


            // 诊所


            TCrmClinic crmClinic = crmClinicMapper.selectOne(Wrappers.lambdaQuery(TCrmClinic.class)


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


                    .last("LIMIT 1"));


            supplierClinicId =crmClinic.getId();


        }




        String sTime=null;


        String eTime =null;


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


@@ -54,12 +118,13 @@


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


        }


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


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


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


        if(list.isEmpty()){


            return pageInfo;


        }


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


        List<TErpProcurementGoods> tErpProcurementGoods = erpProcurementGoodsMapper.selectList(new LambdaQueryWrapper<TErpProcurementGoods>().in(TErpProcurementGoods::getProcurementId, ids).eq(TErpProcurementGoods::getSupplierId, user.getUserId()));


        List<TErpProcurementGoods> tErpProcurementGoods = erpProcurementGoodsMapper.selectList


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


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


        if(!tErpProcurementGoods.isEmpty()){


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


@@ -89,6 +154,24 @@




    @Override


    public TErpProcurementDetailVo detail(String id, SysUser user, String goodsName) {




        Integer roleType = user.getRoleType();


        String supplierClinicId = null;


        if(roleType == 4){


            // 供应商


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


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


                    .last("LIMIT 1"));


            supplierClinicId =crmSupplier.getId();


        }


        if(roleType == 5){


            // 诊所


            TCrmClinic crmClinic = crmClinicMapper.selectOne(Wrappers.lambdaQuery(TCrmClinic.class)


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


                    .last("LIMIT 1"));


            supplierClinicId =crmClinic.getId();


        }




        TErpProcurementDetailVo tErpProcurementVo = new TErpProcurementDetailVo();




        TErpProcurement tErpProcurement = this.getById(id);


@@ -111,7 +194,10 @@


        tErpProcurementVo.setStatus(tErpProcurement.getStatus());


        tErpProcurementVo.setSendTime(tErpProcurement.getSendTime());




        List<TErpProcurementGoods> tErpProcurementGoods = erpProcurementGoodsMapper.selectList(new LambdaQueryWrapper<TErpProcurementGoods>().eq(TErpProcurementGoods::getProcurementId, id).like(goodsName != null && !goodsName.isEmpty(), TErpProcurementGoods::getGoodsName, goodsName).eq(TErpProcurementGoods::getSupplierId, user.getUserId()));


        List<TErpProcurementGoods> tErpProcurementGoods = erpProcurementGoodsMapper.selectList


                (new LambdaQueryWrapper<TErpProcurementGoods>().eq(TErpProcurementGoods::getProcurementId, id)


                        .like(goodsName != null && !goodsName.isEmpty(), TErpProcurementGoods::getGoodsName, goodsName)


                        .eq(TErpProcurementGoods::getSupplierId, supplierClinicId));


        if(tErpProcurementGoods.isEmpty()){


            return tErpProcurementVo;


        }


@@ -139,4 +225,132 @@


        tErpProcurementVo.setList(tErpProcurementDetailNextVos);


        return tErpProcurementVo;


    }




    @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));


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




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


        if(!typeIds.isEmpty()){


            List<TErpGoodsType> typeList = erpGoodsTypeMapper.selectBatchIds(typeIds);


            for (TErpGoods tErpGoodsVO : list) {


                typeList.stream().filter(t -> t.getId().equals(tErpGoodsVO.getTypeId())).findFirst().ifPresent(t -> tErpGoodsVO.setTypeName(t.getTypeName()));


                tErpGoodsVO.setTypeName(tErpGoodsVO.getTypeName());


            }


        }


        pageInfo.setRecords( list);


        return pageInfo;


    }




    @Override


    public List<TErpGoodsVO> inventoryNotEnoughList(SysUser user) {


        List<TErpGoodsVO> list =  this.baseMapper.inventoryNotEnoughList(user);


        return list;


    }




    @Override


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


    public void addProcurement(String clinicSupplierId, SysUser user, List<AddProcurementDto> dtos) {


        List<String> goodsIds = dtos.stream().map(AddProcurementDto::getGoodsId).collect(Collectors.toList());


        List<TErpGoods> tErpGoods = erpGoodsMapper.selectBatchIds(goodsIds);


        for (AddProcurementDto dto : dtos) {


            TErpGoods tErpGoodsVO = tErpGoods.stream().filter(t -> t.getId().equals(dto.getGoodsId())).findFirst().get();


            dto.setPlatformCommissionPrice(tErpGoodsVO.getPlatformCommissionPrice());


            dto.setSupplierId(tErpGoodsVO.getSupplierClinicId());


            dto.setGoodsSalesAmount(tErpGoodsVO.getClinicPurchasePrice());


            if(dto.getSalesAmount()==null){


                dto.setSalesAmount(tErpGoodsVO.getClinicPurchasePrice());


            }


        }


        // 供应商分组


        Map<String, List<AddProcurementDto>> supplierClinicIdListMap = dtos.stream().collect(Collectors.groupingBy(AddProcurementDto::getSupplierId));


        for (Map.Entry<String, List<AddProcurementDto>> entry : supplierClinicIdListMap.entrySet()) {


            String supplierClinicId = entry.getKey();


            TCrmSupplier supplier = crmSupplierMapper.selectById(supplierClinicId);


            List<AddProcurementDto> value = entry.getValue();


            TErpProcurement tErpProcurement = new TErpProcurement();


            tErpProcurement.setClinicId(clinicSupplierId);


            tErpProcurement.setProcurementCode("C"+DateUtils.dateTimeNow());


            tErpProcurement.setSupplierId(supplierClinicId);




            tErpProcurement.setTermNo(supplier.getTermNo());


            tErpProcurement.setMerchantNo(supplier.getRecvMerchantNo());


            tErpProcurement.setPayMoney(value.stream().map(AddProcurementDto::getSalesAmount).reduce(BigDecimal.ZERO, BigDecimal::add));


            AddProcurementDto addProcurementDto = value.get(0);


            if(addProcurementDto.getState()!=null && addProcurementDto.getState()==1){


                tErpProcurement.setStatus(1);


            }else {


                tErpProcurement.setStatus(2);


            }


            ArrayList<TErpProcurementGoods> tErpProcurementGoods1 = new ArrayList<>();




            BigDecimal add =BigDecimal.ZERO;




            for (AddProcurementDto dto : value) {


                TErpProcurementGoods tErpProcurementGoods = new TErpProcurementGoods();


                tErpProcurementGoods.setProcurementId(tErpProcurement.getId());


                TErpGoods goods = tErpGoods.stream().filter(e -> e.getId().equals(dto.getGoodsId())).findFirst().get();


                tErpProcurementGoods.setGoodsId(dto.getGoodsId());


                tErpProcurementGoods.setGoodsName(goods.getGoodsName());


                tErpProcurementGoods.setSupplierName(supplier.getSupplierName());


                tErpProcurementGoods.setQuasiNumber(goods.getQuasiNumber());




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


                tErpProcurementGoods.setUnitName(tErpGoodsUnit.getUnitName());


                tErpProcurementGoods.setPurchasePrice(dto.getGoodsSalesAmount());


                tErpProcurementGoods.setSalesAmount(dto.getSalesAmount());


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




                tErpProcurementGoods.setPurchaseCount(dto.getPurchaseCount());


                tErpProcurementGoods.setSupplierId(supplierClinicId);


                tErpProcurementGoods.setRecvMerchantNo(supplier.getRecvMerchantNo());


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


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


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


                }


                add = add.add(dto.getPlatformCommissionPrice());


                tErpProcurementGoods1.add(tErpProcurementGoods);


            }


            BigDecimal bigDecimal = tErpProcurement.getPayMoney().multiply(BigDecimal.valueOf(0.0038)).setScale(2, RoundingMode.HALF_UP);




            tErpProcurement.setMoney(add.subtract(bigDecimal));


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


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


            }


            this.save(tErpProcurement);


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


            erpProcurementGoodsService.saveBatch(tErpProcurementGoods1);


        }




    }




    @Override


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


        DetailProcurementVO detailProcurementVO = new DetailProcurementVO();


        TErpProcurement tErpProcurement = this.getById(id);


        detailProcurementVO.setStatus(tErpProcurement.getStatus());


        detailProcurementVO.setCreateTime(tErpProcurement.getCreateTime());


        detailProcurementVO.setSendTime(tErpProcurement.getSendTime());


        TCrmSupplier supplier = crmSupplierMapper.selectById(tErpProcurement.getSupplierId());


        detailProcurementVO.setSupplierName(supplier.getSupplierName());


        detailProcurementVO.setUserName(sysUserMapper.selectUserById(Long.valueOf(tErpProcurement.getCreateId())).getUserName());


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


        ArrayList<DetailProcurementNextVO> detailProcurementNextVOS = new ArrayList<>();


        for (TErpProcurementGoods tErpProcurementGoods : list) {


            DetailProcurementNextVO detailProcurementNextVO = new DetailProcurementNextVO();


            detailProcurementNextVO.setGoodsName(tErpProcurementGoods.getGoodsName());


            detailProcurementNextVO.setQuasiNumber(tErpProcurementGoods.getQuasiNumber());


            detailProcurementNextVO.setPackingUnitName(tErpProcurementGoods.getUnitName());


            detailProcurementNextVO.setSalesAmount(tErpProcurementGoods.getSalesAmount());


            detailProcurementNextVO.setNum(tErpProcurementGoods.getPurchaseCount());


            detailProcurementNextVO.setTotalPrice(tErpProcurement.getPayMoney());


            detailProcurementNextVO.setId(tErpProcurementGoods.getId());


            detailProcurementNextVOS.add(detailProcurementNextVO);


        }


        detailProcurementVO.setList(detailProcurementNextVOS);


        return detailProcurementVO;


    }




}