From 50fb58286ed3b718c39a97e0987ee7561a295651 Mon Sep 17 00:00:00 2001
From: k94314517 <8417338+k94314517@user.noreply.gitee.com>
Date: 星期五, 04 七月 2025 17:56:41 +0800
Subject: [PATCH] git ch

---
 server/service/src/main/java/com/doumee/service/business/impl/TaxesServiceImpl.java |  339 +++++++++++++++++++++++++++++++++++++++++++++++++++++---
 1 files changed, 318 insertions(+), 21 deletions(-)

diff --git a/server/service/src/main/java/com/doumee/service/business/impl/TaxesServiceImpl.java b/server/service/src/main/java/com/doumee/service/business/impl/TaxesServiceImpl.java
index 27ae00a..5090c9d 100644
--- a/server/service/src/main/java/com/doumee/service/business/impl/TaxesServiceImpl.java
+++ b/server/service/src/main/java/com/doumee/service/business/impl/TaxesServiceImpl.java
@@ -8,28 +8,31 @@
 import com.doumee.core.model.PageWrap;
 import com.doumee.core.utils.Constants;
 import com.doumee.core.utils.Utils;
-import com.doumee.dao.business.CompanyMapper;
-import com.doumee.dao.business.TaxDetialMapper;
-import com.doumee.dao.business.TaxesMapper;
+import com.doumee.dao.business.*;
+import com.doumee.dao.business.dto.DirectInvoicingDTO;
+import com.doumee.dao.business.dto.DirectInvoicingDetailDTO;
 import com.doumee.dao.business.dto.EntrustInvoicingDTO;
+import com.doumee.dao.business.join.ApplyChangeJoinMapper;
 import com.doumee.dao.business.join.InsuranceApplyJoinMapper;
 import com.doumee.dao.business.join.TaxDetailJoinMapper;
 import com.doumee.dao.business.join.TaxesJoinMapper;
 import com.doumee.dao.business.model.*;
+import com.doumee.dao.business.vo.TaxesInvoicingVO;
 import com.doumee.dao.system.model.SystemUser;
 import com.doumee.service.business.TaxesService;
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
 import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.github.xiaoymin.knife4j.core.util.CollectionUtils;
 import com.github.yulichang.wrapper.MPJLambdaWrapper;
 import org.apache.commons.lang3.StringUtils;
 import org.apache.shiro.SecurityUtils;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
 import org.springframework.transaction.annotation.Transactional;
-import org.springframework.util.CollectionUtils;
 
+import java.math.BigDecimal;
 import java.util.ArrayList;
 import java.util.Date;
 import java.util.List;
@@ -57,7 +60,12 @@
     private CompanyMapper companyMapper;
     @Autowired
     private InsuranceApplyJoinMapper insuranceApplyJoinMapper;
-
+    @Autowired
+    private ApplyChangeJoinMapper applyChangeJoinMapper;
+    @Autowired
+    private SolutionsMapper solutionsMapper;
+    @Autowired
+    private NoticesMapper noticesMapper;
     @Override
     public Integer create(Taxes taxes) {
         taxesMapper.insert(taxes);
@@ -108,6 +116,10 @@
                 }
             }
         }
+        //瀛樺偍寰呭姙淇℃伅
+        Constants.NoticeObjectType noticeObjectType = Constants.NoticeObjectType.TAXES;
+        //鍒犻櫎鍏朵粬寰呭姙
+        noticesMapper.delete(new QueryWrapper<Notices>().lambda().eq(Notices::getObjType,noticeObjectType.getKey()).eq(Notices::getObjId,model.getId()));
     }
 
     private List<TaxDetial> getDetailListById(Integer id) {
@@ -117,11 +129,12 @@
     private List<TaxDetial> getJoinDetailListById(Integer id) {
         MPJLambdaWrapper<TaxDetial> queryWrapper = new MPJLambdaWrapper<>();
         queryWrapper.selectAll(TaxDetial.class);
+        queryWrapper.selectAs(Solutions::getName,TaxDetial::getSolutionName);
         queryWrapper.selectAs(Taxes::getDoneCode,TaxDetial::getTaxDoneCode);
         queryWrapper.selectAs(Taxes::getCreateDate,TaxDetial::getTaxCreateDate);
         queryWrapper.selectAs(InsuranceApply::getCode,TaxDetial::getApplyCode);
-        queryWrapper.selectAs(ApplyChange::getCode,TaxDetial::getChangApplyCode);
-        queryWrapper.select("(CASE t.type\n" +
+        queryWrapper.selectAs(ApplyChange::getValidCode,TaxDetial::getChangApplyCode);
+/*        queryWrapper.select("(CASE t.type\n" +
                 "WHEN 0 THEN (select count(1) from apply_detail c where c.APPLY_ID=t.INSURANCE_APPLY_ID) \n" +
                 "ELSE 0  \n" +
                 "END) as applyNum,\n" +
@@ -132,11 +145,15 @@
                 "(CASE t.type \n" +
                 "WHEN 1 THEN  (select count(1) from apply_chagne_detail c where c.APPLY_CHANGE_ID=t.APPLY_CHANGE_ID)  \n" +
                 "ELSE 0  \n" +
-                "END) as applyChangeAddNum");
+                "END) as applyChangeAddNum");*/
         queryWrapper.leftJoin(InsuranceApply.class,InsuranceApply::getId,TaxDetial::getInsuranceApplyId);
+        queryWrapper.leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId);
         queryWrapper.leftJoin(ApplyChange.class,ApplyChange::getId,TaxDetial::getApplyChangeId);
         queryWrapper.leftJoin(Taxes.class,Taxes::getId,TaxDetial::getDelTaxId);
+        queryWrapper.eq(  TaxDetial::getTaxId,id);
         List<TaxDetial> detialList =  taxDetailJoinMapper.selectJoinList(TaxDetial.class,queryWrapper.orderByAsc(TaxDetial::getType));
+
+
         return detialList;
     }
 
@@ -171,6 +188,26 @@
         update.setDoneDate(update.getEditDate());
         update.setImgurl(taxes.getImgurl());
         taxesMapper.updateById(update);
+
+        //鏌ヨ寮�绁ㄦ槑缁嗚褰�
+        List<TaxDetial> taxDetialList = taxDetialMapper.selectList(new QueryWrapper<TaxDetial>().lambda()
+                .eq(TaxDetial::getTaxId,taxes.getId())
+                .eq(TaxDetial::getType,Constants.TWO));
+        if(CollectionUtils.isNotEmpty(taxDetialList)){
+            for (TaxDetial taxDetial:taxDetialList) {
+                taxesMapper.update(null,new UpdateWrapper<Taxes>().lambda()
+                                .set(Taxes::getEditDate,new Date())
+                                .set(Taxes::getEditor,user.getId())
+                        .set(Taxes::getStatus,3).eq(Taxes::getId,taxDetial.getDelTaxId()));
+            }
+        }
+
+
+        //瀛樺偍寰呭姙淇℃伅
+        Constants.NoticeObjectType noticeObjectType = Constants.NoticeObjectType.TAXES;
+        //鍒犻櫎鍏朵粬寰呭姙
+        noticesMapper.delete(new QueryWrapper<Notices>().lambda().eq(Notices::getObjType,noticeObjectType.getKey()).eq(Notices::getObjId,taxes.getId()));
+
     }
 
     @Override
@@ -212,12 +249,14 @@
         MPJLambdaWrapper<Taxes> queryWrapper = new MPJLambdaWrapper<>();
         queryWrapper.selectAll(Taxes.class);
         queryWrapper.selectAs(Solutions::getName,Taxes::getSolutionName);
+        queryWrapper.selectAs(SystemUser::getRealname,Taxes::getCancelUserName);
         queryWrapper.leftJoin(Solutions.class,Solutions::getId,Taxes::getSolutionId);
+        queryWrapper.leftJoin(SystemUser.class,SystemUser::getId,Taxes::getCancelUserId);
         Taxes model =taxesJoinMapper.selectById(id);
         if(model==null || !Constants.equalsInteger(model.getIsdeleted(),Constants.ZERO)){
             throw  new BusinessException(ResponseStatus.DATA_EMPTY);
         }
-        if(Constants.equalsInteger(model.getType(),Constants.ZERO)){
+        if(Constants.equalsInteger(model.getApplyType(),Constants.ZERO)){
             List<TaxDetial> detialList = getDetailsApplysListById(id);
             model.setApplyList(detialList);
         }else{
@@ -226,11 +265,12 @@
             List<TaxDetial> applyList = new ArrayList<>();//鎶曚繚鍜屽姞鍑忎繚
             List<TaxDetial> delList = new ArrayList<>();//鍐茬孩鍗�
             if(detialList!=null){
-                for(TaxDetial d :delList){
-                    d.setSolutionName(model.getSolutionName());
+                for(TaxDetial d :detialList){
+//                    d.setSolutionName(model.getSolutionName());
                     d.setFee(Constants.formatBigdecimal(d.getFee()));
                     d.setTotalFee(Constants.formatBigdecimal(d.getTotalFee()));
-                    if(Constants.equalsInteger(d.getType(),Constants.ZERO) || Constants.equalsInteger(d.getType(),Constants.ONE)){
+                    if(Constants.equalsInteger(d.getType(),Constants.ZERO)
+                            || Constants.equalsInteger(d.getType(),Constants.ONE)){
                         applyList.add(d);
                     }else  if(Constants.equalsInteger(d.getType(),Constants.TWO)){
                         delList.add(d);
@@ -248,8 +288,12 @@
             queryWrapper.selectAll(TaxDetial.class);
             queryWrapper.selectAs(InsuranceApply::getCode,TaxDetial::getApplyCode);
             queryWrapper.selectAs(Solutions::getName,TaxDetial::getSolutionName);
+            queryWrapper.selectAs(ApplyChange::getValidCode,TaxDetial::getChangApplyCode);
             queryWrapper.leftJoin(InsuranceApply.class,InsuranceApply::getId,TaxDetial::getInsuranceApplyId);
             queryWrapper.leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId);
+            queryWrapper.leftJoin(ApplyChange.class,ApplyChange::getId,TaxDetial::getApplyChangeId);
+            queryWrapper.in(TaxDetial::getType,Constants.ZERO,Constants.ONE);
+            queryWrapper.eq(TaxDetial::getTaxId,id);
             List<TaxDetial> detialList =  taxDetailJoinMapper.selectJoinList(TaxDetial.class,queryWrapper.orderByAsc(TaxDetial::getType));
             return detialList;
     }
@@ -280,8 +324,8 @@
             queryWrapper.eq(Taxes::getCompanyId,-1);//璁剧疆鏃犳晥璁块棶
         }else{
             queryWrapper.in(Taxes::getCompanyId,user.getCompanyIdList());
-            queryWrapper.ge(pageWrap.getModel().getStartDate() != null,Taxes::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getStartDate()));
-            queryWrapper.le(SignRecord::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getEndDate()));
+            queryWrapper.ge(pageWrap.getModel().getStartDate() != null,Taxes::getCreateDate, pageWrap.getModel().getStartDate());
+            queryWrapper.le(pageWrap.getModel().getEndDate() != null,Taxes::getCreateDate, pageWrap.getModel().getEndDate());
             queryWrapper.eq(pageWrap.getModel().getTaxBank() != null,Taxes::getTaxBank, pageWrap.getModel().getTaxBank());
             queryWrapper.eq(pageWrap.getModel().getTaxBank() != null,Taxes::getTaxBank, pageWrap.getModel().getTaxBank());
             queryWrapper.eq(pageWrap.getModel().getRemark() != null,Taxes::getRemark, pageWrap.getModel().getRemark());
@@ -323,15 +367,18 @@
         queryWrapper.selectAll(Taxes.class);
         queryWrapper.selectAs(SystemUser::getRealname,Taxes::getCreatorName);
         queryWrapper.leftJoin(SystemUser.class,SystemUser::getId,Taxes::getCreator);
+
         Utils.MP.blankToNull(pageWrap.getModel());
         queryWrapper.eq(Taxes::getIsdeleted, Constants.ZERO);
         Taxes queryModel = pageWrap.getModel();
         if(!user.getType().equals(Constants.ONE)){
             throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"闈炰紒涓氱敤鎴锋棤娉曡繘琛岃涓氬姟鏌ヨ");
+        }else{
+            queryWrapper.eq(Taxes::getCompanyId,user.getCompanyId());
         }
         if(!Objects.isNull(queryModel)){
-            queryWrapper.ge(pageWrap.getModel().getStartDate() != null,Taxes::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getStartDate()));
-            queryWrapper.le(SignRecord::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getEndDate()));
+            queryWrapper.ge(pageWrap.getModel().getStartDate() != null,Taxes::getCreateDate, (pageWrap.getModel().getStartDate()));
+            queryWrapper.le(pageWrap.getModel().getEndDate() != null,Taxes::getCreateDate,  (pageWrap.getModel().getEndDate()));
             queryWrapper.eq(!Objects.isNull(queryModel.getInsuranceApplyId()),Taxes::getInsuranceApplyId,queryModel.getInsuranceApplyId());
             queryWrapper.eq(!Objects.isNull(queryModel.getStatus()),Taxes::getStatus,queryModel.getStatus());
         }
@@ -351,6 +398,38 @@
 
 
 
+    @Override
+    public List<Taxes> findListForCompany(Taxes queryModel) {
+        LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
+        MPJLambdaWrapper<Taxes> queryWrapper = new MPJLambdaWrapper<>();
+        queryWrapper.selectAll(Taxes.class);
+        queryWrapper.selectAs(SystemUser::getRealname,Taxes::getCreatorName);
+        queryWrapper.leftJoin(SystemUser.class,SystemUser::getId,Taxes::getCreator);
+
+        queryWrapper.eq(Taxes::getIsdeleted, Constants.ZERO);
+        if(!user.getType().equals(Constants.ONE)){
+            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"闈炰紒涓氱敤鎴锋棤娉曡繘琛岃涓氬姟鏌ヨ");
+        }
+        if(!Objects.isNull(queryModel)){
+            queryWrapper.ge(queryModel.getStartDate() != null,Taxes::getCreateDate, (queryModel.getStartDate()));
+            queryWrapper.le(queryModel.getEndDate() != null,Taxes::getCreateDate,  (queryModel.getEndDate()));
+            queryWrapper.eq(!Objects.isNull(queryModel.getInsuranceApplyId()),Taxes::getInsuranceApplyId,queryModel.getInsuranceApplyId());
+            queryWrapper.eq(!Objects.isNull(queryModel.getStatus()),Taxes::getStatus,queryModel.getStatus());
+            queryWrapper.exists(!Objects.isNull(queryModel.getApplyId())," select 1 from tax_detial td where td.insurance_apply_id = "+queryModel.getApplyId()+" and t.id = td.tax_id ");
+        }
+        queryWrapper.orderByAsc(Taxes::getCreateDate);
+
+        List<Taxes> result = taxesJoinMapper.selectJoinList(Taxes.class, queryWrapper);
+        String path =systemDictDataBiz.queryByCode(Constants.OSS,Constants.RESOURCE_PATH).getCode()+systemDictDataBiz.queryByCode(Constants.OSS,Constants.TAXES_FILE).getCode();
+        for(Taxes t : result){
+            if(StringUtils.isNotBlank(t.getImgurl())){
+                t.setImgurlFull(path + t.getImgurl());
+            }
+        }
+        return result;
+    }
+
+
 
 
     @Override
@@ -361,7 +440,7 @@
             || Objects.isNull(entrustInvoicingDTO.getInvoicingMoney())
             || Objects.isNull(entrustInvoicingDTO.getType())
             || Objects.isNull(entrustInvoicingDTO.getTaxDetialList())
-            || StringUtils.isNotBlank(entrustInvoicingDTO.getAddress())
+            || StringUtils.isBlank(entrustInvoicingDTO.getAddress())
         ){
             throw new BusinessException(ResponseStatus.BAD_REQUEST);
         }
@@ -386,6 +465,7 @@
         taxes.setAddr(entrustInvoicingDTO.getAddress());
         taxes.setCompanyName(company.getName());
         taxes.setApplyType(Constants.ZERO);
+        taxes.setTaxBank(company.getTaxBank());
         taxesMapper.insert(taxes);
 
         List<TaxDetial> taxDetialList = entrustInvoicingDTO.getTaxDetialList();
@@ -396,17 +476,19 @@
             ){
                 throw new BusinessException(ResponseStatus.BAD_REQUEST);
             }
-            //鏌ヨ姣忎釜淇濆崟涓嬪彲浠ユ姇淇濈殑閲戦
+            //鏌ヨ姣忎釜淇濆崟涓嬪彲浠ユ姤閿�鐨勯噾棰�
             InsuranceApply insuranceApply = insuranceApplyJoinMapper.selectJoinOne(InsuranceApply.class,new MPJLambdaWrapper<InsuranceApply>()
                     .selectAll(InsuranceApply.class)
-                    .select(" ( select sum(td.fee) from taxes ts inner join tax_detial td on ts.TAX_ID = ts.id  where ts.status != 2 and td.INSURANCE_APPLY_ID = t.id ) as taxesMoney ")
+//                    .select(" ifnull(( select sum(td.fee) from taxes ts inner join tax_detial td on td.TAX_ID = ts.id  where ts.status  = 1 and td.INSURANCE_APPLY_ID = t.id ),0) as taxesMoney")
+                    .select(" ifnull(( select sum(td.fee) from taxes ts inner join tax_detial td on td.TAX_ID = ts.id  where ts.status != 2 and td.INSURANCE_APPLY_ID = t.id ),0) as taxesMoney ")
                     .eq(InsuranceApply::getId,taxDetial.getInsuranceApplyId())
             );
             if(Objects.isNull(insuranceApply)){
                 throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"淇濆崟鍙枫��"+taxDetial.getApplyCode()+"銆戞湭鏌ヨ鍒颁繚鍗曚俊鎭�");
             }
             if(insuranceApply.getCurrentFee().subtract(insuranceApply.getTaxesMoney()).compareTo(taxDetial.getFee())!=Constants.ZERO){
-                throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"淇濆崟鍙枫��"+taxDetial.getApplyCode()+"銆戝彲鎶ラ攢閲戦閿欒銆�"+insuranceApply.getCurrentFee().subtract(insuranceApply.getTaxesMoney())+"銆�");
+                //throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"淇濆崟鍙枫��"+taxDetial.getApplyCode()+"銆戝彲鎶ラ攢閲戦閿欒銆�"+insuranceApply.getCurrentFee().subtract(insuranceApply.getTaxesMoney())+"銆�");
+                throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"淇濆崟鍙枫��"+taxDetial.getApplyCode()+"銆戜笉婊¤冻寮�绁ㄦ潯浠�");
             }
             taxDetial.setCreator(user.getId());
             taxDetial.setCreateDate(new Date());
@@ -415,9 +497,224 @@
             taxDetial.setTotalFee(insuranceApply.getCurrentFee());
             taxDetial.setType(Constants.ZERO);
         }
-        taxDetailJoinMapper.insertBatchSomeColumn(taxDetialList);
+        taxDetailJoinMapper.insert(taxDetialList);
+
+
+        //瀛樺偍寰呭姙淇℃伅
+        Constants.NoticeObjectType noticeObjectType = Constants.NoticeObjectType.TAXES;
+        //鍒犻櫎鍏朵粬寰呭姙
+        noticesMapper.delete(new QueryWrapper<Notices>().lambda().eq(Notices::getObjType,noticeObjectType.getKey()).eq(Notices::getObjId,taxes.getId()));
+        Notices notices = new Notices(noticeObjectType,Constants.ZERO,taxes.getId(),taxes.getPrice().toString(),
+                taxes.getCompanyId(), Constants.NoticeType.ZERO);
+        noticesMapper.insert(notices);
+
+
     }
 
 
 
+
+    @Override
+    public List<TaxesInvoicingVO> getDirectTaxes(Integer id){
+        InsuranceApply queryInsuranceApply = insuranceApplyJoinMapper.selectById(id);
+        if(Objects.isNull(queryInsuranceApply)){
+            throw new BusinessException(ResponseStatus.DATA_EMPTY);
+        }
+        Solutions solutions = solutionsMapper.selectById(queryInsuranceApply.getSolutionId());
+        if(Objects.isNull(solutions)){
+            throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"鏈煡璇㈠埌鏂规淇℃伅");
+        }
+        if(!solutions.getType().equals(Constants.ZERO)){
+            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"闈炵洿淇濇柟妗堜繚鍗曪紝鏃犳硶杩涜璇ユ搷浣�");
+        }
+        List<TaxesInvoicingVO>  taxesInvoicingVOList = new ArrayList<>();
+        this.dealTaxesData(id,taxesInvoicingVOList);
+        List<Taxes> taxesList = taxesJoinMapper.selectJoinList(Taxes.class,new MPJLambdaWrapper<Taxes>()
+                .selectAll(Taxes.class)
+                .selectAs(Solutions::getName,Taxes::getSolutionName)
+                .selectAs(InsuranceApply::getCode,Taxes::getInsuranceCode)
+                .leftJoin(Solutions.class,Solutions::getId,Taxes::getSolutionId)
+                .leftJoin(InsuranceApply.class,InsuranceApply::getId,Taxes::getInsuranceApplyId)
+                .eq(Taxes::getStatus,Constants.ONE)
+                .eq(Taxes::getInsuranceApplyId,id)
+        );
+        if(CollectionUtils.isNotEmpty(taxesList)){
+            for (Taxes taxes:taxesList) {
+                TaxesInvoicingVO taxesInvoicingVO = taxes.getTaxesInvoicingVO();
+                taxesInvoicingVOList.add(taxesInvoicingVO);
+            }
+        }
+        return taxesInvoicingVOList;
+
+    }
+
+
+    public void dealTaxesData(Integer id,List<TaxesInvoicingVO>  taxesInvoicingVOList){
+        InsuranceApply insuranceApply =  insuranceApplyJoinMapper.selectJoinOne(InsuranceApply.class,
+                new MPJLambdaWrapper<InsuranceApply>()
+                        .selectAll(InsuranceApply.class)
+                        .selectAs(Solutions::getName,InsuranceApply::getSolutionsName)
+                        .select(" ( select count(1) from apply_detail ad  where ad.apply_id = t.id ) as insureNum")
+                        .leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId)
+                        .notExists(" select 1 from taxes t1 inner join tax_detial t2 on t1.id  = t2.tax_id where t2.type = 0 and t1.status != 2 and t.id = t2.INSURANCE_APPLY_ID  ")
+                        .eq(InsuranceApply::getStatus,Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey())
+                        .eq(InsuranceApply::getId,id)
+        );
+
+
+        List<ApplyChange> applyChangeList = applyChangeJoinMapper.selectJoinList(ApplyChange.class,new MPJLambdaWrapper<ApplyChange>()
+                .selectAll(ApplyChange.class)
+                .selectAs(InsuranceApply::getCode,ApplyChange::getApplyCode)
+                .selectAs(Solutions::getName,ApplyChange::getSolutionsName)
+                .select("( select count(1) from apply_chagne_detail ad where t.id = ad.APPLY_CHANGE_ID and ad.TYPE = 0  ) as addNum ")
+                .select("( select count(1) from apply_chagne_detail ad where t.id = ad.APPLY_CHANGE_ID and ad.TYPE = 1  ) as delNum ")
+                .select("( select ifnull(sum(ad.FEE),0) from apply_chagne_detail ad where t.id = ad.APPLY_CHANGE_ID  ) as changeMoney" )
+                .notExists(" select 1 from taxes t1 inner join tax_detial t2 on t1.id  = t2.tax_id where t2.type = 1 and t1.status != 2 and t.id = t2.APPLY_CHANGE_ID  ")
+                .leftJoin(InsuranceApply.class,InsuranceApply::getId,ApplyChange::getApplyId)
+                .leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId)
+                .eq(ApplyChange::getStatus,Constants.ApplyChangeStatus.APPROVE.getKey())
+                .eq(ApplyChange::getType,Constants.ZERO)
+                .eq(InsuranceApply::getId,id)
+        );
+
+        if(CollectionUtils.isNotEmpty(applyChangeList)){
+            for (ApplyChange applyChange:applyChangeList) {
+                if(!Objects.isNull(insuranceApply)){
+                    insuranceApply.setFee(insuranceApply.getFee().subtract(applyChange.getFee()));
+                }
+                TaxesInvoicingVO taxesInvoicingVO = applyChange.toTaxesInvoicingVO();
+//                if(!Objects.isNull(insuranceApply)){
+//                    taxesInvoicingVO.setAmount(BigDecimal.ZERO);
+//                }
+                taxesInvoicingVOList.add(taxesInvoicingVO);
+            }
+        }
+        if(!Objects.isNull(insuranceApply)){
+            TaxesInvoicingVO taxesInvoicingVO = insuranceApply.toTaxesInvoicingVO();
+            taxesInvoicingVOList.add(taxesInvoicingVO);
+        }
+    }
+
+
+    /**
+     * 鐩翠繚鏁版嵁鎻愪氦
+     * @param directInvoicingDTO
+     */
+    @Override
+    @Transactional(rollbackFor = {BusinessException.class,Exception.class})
+    public void directInvoicing(DirectInvoicingDTO directInvoicingDTO){
+        LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
+        if(Objects.isNull(directInvoicingDTO)
+                || Objects.isNull(directInvoicingDTO.getInvoicingMoney())
+                || Objects.isNull(directInvoicingDTO.getType())
+                || Objects.isNull(directInvoicingDTO.getInvoicingDetailDTOList())
+                || StringUtils.isBlank(directInvoicingDTO.getAddress())
+        ){
+            throw new BusinessException(ResponseStatus.BAD_REQUEST);
+        }
+        if(!user.getType().equals(Constants.ONE)){
+            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"闈炰紒涓氱敤鎴锋棤娉曡繘琛岃涓氬姟鏌ヨ");
+        }
+        Company company = companyMapper.selectById(user.getCompanyId());
+        if(Objects.isNull(company)){
+            throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"鏈煡璇㈠埌浼佷笟淇℃伅");
+        }
+        InsuranceApply queryInsuranceApply = insuranceApplyJoinMapper.selectById(directInvoicingDTO.getId());
+        if(Objects.isNull(queryInsuranceApply)){
+            throw new BusinessException(ResponseStatus.DATA_EMPTY);
+        }
+        Solutions solutions = solutionsMapper.selectById(queryInsuranceApply.getSolutionId());
+        if(Objects.isNull(solutions)){
+            throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"鏈煡璇㈠埌鏂规淇℃伅");
+        }
+        if(!solutions.getType().equals(Constants.ZERO)){
+            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"闈炵洿淇濇柟妗堜繚鍗曪紝鏃犳硶杩涜璇ユ搷浣�");
+        }
+
+        Taxes taxes = new Taxes();
+        taxes.setCreator(user.getId());
+        taxes.setCreateDate(new Date());
+        taxes.setIsdeleted(Constants.ZERO);
+        taxes.setStatus(Constants.ZERO);
+        taxes.setCompanyId(company.getId());
+        taxes.setPrice(directInvoicingDTO.getInvoicingMoney());
+        taxes.setType(directInvoicingDTO.getType());
+        taxes.setTaxCode(company.getTaxCode());
+        taxes.setTaxAccount(company.getTaxAccount());
+        taxes.setTaxBank(company.getTaxBank());
+        taxes.setTaxAddr(company.getTaxAddr());
+        taxes.setAddr(directInvoicingDTO.getAddress());
+        taxes.setCompanyName(company.getName());
+        taxes.setApplyType(Constants.ONE);
+        taxes.setSolutionId(solutions.getId());
+        taxes.setInsuranceApplyId(queryInsuranceApply.getId());
+        taxesMapper.insert(taxes);
+
+        List<TaxesInvoicingVO>  taxesInvoicingVOList = new ArrayList<>();
+        this.dealTaxesData(queryInsuranceApply.getId(),taxesInvoicingVOList);
+        List<TaxDetial> taxDetailList = new ArrayList<>();
+        for (TaxesInvoicingVO taxesInvoicingVO:taxesInvoicingVOList) {
+            if(Objects.isNull(taxesInvoicingVO)
+                    || Objects.isNull(taxesInvoicingVO.getAmount())
+                    || Objects.isNull(taxesInvoicingVO.getId())
+                    || Objects.isNull(taxesInvoicingVO.getType())
+            ){
+                throw new BusinessException(ResponseStatus.BAD_REQUEST);
+            }
+            TaxDetial taxDetial = new TaxDetial();
+            taxDetial.setCreator(user.getId());
+            taxDetial.setCreateDate(new Date());
+            taxDetial.setIsdeleted(Constants.ZERO);
+            taxDetial.setTaxId(taxes.getId());
+            taxDetial.setTotalFee(taxesInvoicingVO.getAmount());
+            taxDetial.setFee(taxesInvoicingVO.getAmount());
+            taxDetial.setInsuranceApplyId(taxes.getInsuranceApplyId());
+            if(taxesInvoicingVO.getType().equals(Constants.ZERO)){
+                taxDetial.setType(taxesInvoicingVO.getType());
+            }else if(taxesInvoicingVO.getType().equals(Constants.ONE)){
+                taxDetial.setApplyChangeId(taxesInvoicingVO.getId());
+                taxDetial.setType(taxesInvoicingVO.getType());
+            }
+            taxDetailList.add(taxDetial);
+        }
+        List<Integer> chIdList = directInvoicingDTO.getInvoicingDetailDTOList();
+        if(CollectionUtils.isNotEmpty(chIdList)){
+            for (Integer id:chIdList) {
+                Taxes chTaxes = taxesMapper.selectById(id);
+                if(Objects.isNull(chTaxes)){
+                    throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"鏈煡璇㈠埌閫夋嫨鍐茬孩鏁版嵁");
+                }
+                if(!(chTaxes.getStatus().equals(Constants.ZERO)||chTaxes.getStatus().equals(Constants.ONE))){
+                    throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"鍐茬孩鏁版嵁鐘舵�侀敊璇�");
+                }
+                TaxDetial taxDetial = new TaxDetial();
+                taxDetial.setCreator(user.getId());
+                taxDetial.setCreateDate(new Date());
+                taxDetial.setIsdeleted(Constants.ZERO);
+                taxDetial.setTaxId(taxes.getId());
+                taxDetial.setTotalFee(chTaxes.getPrice());
+                taxDetial.setFee(chTaxes.getPrice());
+                taxDetial.setDelTaxId(chTaxes.getId());
+                taxDetial.setInsuranceApplyId(taxes.getInsuranceApplyId());
+                taxDetial.setType(Constants.TWO);
+                taxDetailList.add(taxDetial);
+            }
+        }
+        if(CollectionUtils.isNotEmpty(taxDetailList)){
+            taxDetailJoinMapper.insert(taxDetailList);
+        }else{
+            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"鏃犲彲寮�绁ㄦ暟鎹紝鎿嶄綔澶辫触");
+        }
+
+        //瀛樺偍寰呭姙淇℃伅
+        Constants.NoticeObjectType noticeObjectType = Constants.NoticeObjectType.TAXES;
+        //鍒犻櫎鍏朵粬寰呭姙
+        noticesMapper.delete(new QueryWrapper<Notices>().lambda().eq(Notices::getObjType,noticeObjectType.getKey()).eq(Notices::getObjId,taxes.getId()));
+        Notices notices = new Notices(noticeObjectType,Constants.ZERO,taxes.getId(),taxes.getPrice().toString(),
+                taxes.getCompanyId(), Constants.NoticeType.ZERO);
+        noticesMapper.insert(notices);
+
+    }
+
+
 }

--
Gitblit v1.9.3