From 41f24b362a02e4a8a2cfffb7e81884659edfbf98 Mon Sep 17 00:00:00 2001
From: k94314517 <8417338+k94314517@user.noreply.gitee.com>
Date: 星期日, 04 二月 2024 14:55:51 +0800
Subject: [PATCH] 111

---
 server/service/src/main/java/com/doumee/service/business/impl/ApplyChangeServiceImpl.java    |    4 +-
 server/service/src/main/java/com/doumee/core/utils/Constants.java                            |   10 ++--
 server/service/src/main/java/com/doumee/service/business/impl/InsuranceApplyServiceImpl.java |   43 +++++++++------------
 server/service/src/main/java/com/doumee/service/business/impl/TaxesServiceImpl.java          |   10 ++++
 server/company/src/main/java/com/doumee/api/business/MemberController.java                   |   10 -----
 server/service/src/main/java/com/doumee/service/business/impl/NoticesServiceImpl.java        |    2 
 server/service/src/main/java/com/doumee/dao/business/model/ApplyDetail.java                  |   22 +++++-----
 server/service/src/main/java/com/doumee/dao/business/vo/TaxesInvoicingVO.java                |    3 +
 8 files changed, 50 insertions(+), 54 deletions(-)

diff --git a/server/company/src/main/java/com/doumee/api/business/MemberController.java b/server/company/src/main/java/com/doumee/api/business/MemberController.java
index fafd693..74eea2e 100644
--- a/server/company/src/main/java/com/doumee/api/business/MemberController.java
+++ b/server/company/src/main/java/com/doumee/api/business/MemberController.java
@@ -80,8 +80,6 @@
     @PostMapping("/page")
     @RequiresPermissions("business:member:query")
     public ApiResponse<PageData<Member>> findPage (@RequestBody PageWrap<MemberQueryDTO> pageWrap) {
-//        LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
-//        pageWrap.getModel().setCompanyId(user.getCompanyId());
         return ApiResponse.success(memberService.findPageForCompany(pageWrap));
     }
 
@@ -89,14 +87,6 @@
     @PostMapping("/exportExcel")
     @RequiresPermissions("business:member:exportExcel")
     public void exportExcel (@RequestBody PageWrap<MemberQueryDTO> pageWrap, HttpServletResponse response) {
-     /*   LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
-        pageWrap.getModel().setCompanyId(user.getCompanyId());
-        List<Member> list = memberService.findPageForCompany(pageWrap).getRecords();
-        for (int i = 0; i < list.size(); i++) {
-            Member member = list.get(i);
-            member.setSn(i+1);
-            member.setAge(Constants.getAgeByIdCard(member.getIdcardNo()));
-        }*/
         ExcelExporter.build(Member.class).exportWithFirstAndEnd( memberService.findPageForCompany(pageWrap).getRecords(), "鍛樺伐鍒楄〃璇﹀崟","鍛樺伐鍒楄〃璇﹀崟",null, response);
     }
 
diff --git a/server/service/src/main/java/com/doumee/core/utils/Constants.java b/server/service/src/main/java/com/doumee/core/utils/Constants.java
index 6ce57c2..b00e2c2 100644
--- a/server/service/src/main/java/com/doumee/core/utils/Constants.java
+++ b/server/service/src/main/java/com/doumee/core/utils/Constants.java
@@ -168,7 +168,7 @@
         if(solutions.getInsureCycleUnit().equals(Constants.ZERO)){
             countCyclePriceVO.setEndDate(
                     DateUtil.getMontageDate(
-                        DateUtil.afterDateByType(startDate,0,solutions.getInsureCycle())
+                        DateUtil.afterDateByType(startDate,0,solutions.getInsureCycle()-1)
                     ,2)
             );
         }else if(solutions.getInsureCycleUnit().equals(Constants.TWO)){
@@ -177,7 +177,7 @@
             //鑾峰彇澶╂暟鍚庣殑鏃ユ湡
             Date afterDate = DateUtil.afterDateByType(startDate,0,monthDays);
             //璧嬪�� 姣忔棩缁撴潫鏃跺垎绉�
-            countCyclePriceVO.setEndDate(DateUtil.getMontageDate(afterDate,2));
+            countCyclePriceVO.setEndDate(DateUtil.getMontageDate(afterDate,3));
         }else if(solutions.getInsureCycleUnit().equals(Constants.THREE)){
             //鑾峰彇X骞村悗鏃ユ湡 澶氫簡涓�澶�
             Date afterDate = DateUtil.afterDateByType(startDate,2,solutions.getInsureCycle());
@@ -191,13 +191,13 @@
     public static Integer getSexByIdCard(String idCard){
         Pattern pattern = Pattern.compile("\\d{17}[\\d|x]"); // 瀹氫箟韬唤璇佸彿鐮佹牸寮忕殑姝e垯琛ㄨ揪寮�
         Matcher matcher = pattern.matcher(idCard);
-        Integer sex = 1;
+        Integer sex = 0;
         if (matcher.matches()) {
             int genderCode = Integer.parseInt(idCard.substring(16, 17)); // 浠庣17浣嶅紑濮嬫彁鍙栨�у埆缂栫爜锛堝鏁颁负鐢锋�э紝鍋舵暟涓哄コ鎬э級
             if ((genderCode % 2 == 1) ) {
-                sex = 1;
+                sex = 0;
             } else {
-                sex = 2;
+                sex = 1;
             }
         } else {
            sex = -1;
diff --git a/server/service/src/main/java/com/doumee/dao/business/model/ApplyDetail.java b/server/service/src/main/java/com/doumee/dao/business/model/ApplyDetail.java
index 2b55812..ac38edf 100644
--- a/server/service/src/main/java/com/doumee/dao/business/model/ApplyDetail.java
+++ b/server/service/src/main/java/com/doumee/dao/business/model/ApplyDetail.java
@@ -54,7 +54,7 @@
     private String remark;
 
     @ApiModelProperty(value = "鎺掑簭鐮�", example = "1")
-    @ExcelColumn(name="搴忓彿",index = 1)
+    @ExcelColumn(name="搴忓彿",index = 1,width = 3)
     private Integer sortnum;
 
     @ApiModelProperty(value = "鎶曚繚鐢宠缂栫爜锛堝叧鑱攊nsurance_apply", example = "1")
@@ -66,15 +66,15 @@
     private Integer memberId;
 
     @ApiModelProperty(value = "瀹為檯淇濋櫓鐢熸晥姝㈡湡")
-    @ExcelColumn(name="淇濋櫓鐢熸晥姝㈡湡",index = 9)
+    @ExcelColumn(name="淇濋櫓鐢熸晥姝㈡湡",index = 9,width = 12,dateFormat="yyyy-MM-dd HH:mm:ss")
     private Date endTime;
 
     @ApiModelProperty(value = "瀹為檯淇濋櫓鐢熸晥璧锋湡")
-    @ExcelColumn(name="淇濋櫓鐢熸晥璧锋湡",index =8)
+    @ExcelColumn(name="淇濋櫓鐢熸晥璧锋湡",index =8,width = 12,dateFormat="yyyy-MM-dd HH:mm:ss")
     private Date startTime;
 
     @ApiModelProperty(value = "韬唤璇佸彿鐮�")
-    @ExcelColumn(name="韬唤璇佸彿鐮�",index = 5)
+    @ExcelColumn(name="韬唤璇佸彿鐮�",index = 5,width = 12)
     private String idcardNo;
 
     @ApiModelProperty(value = "娲鹃仯鍗曚綅缂栫爜锛堝叧鑱攄ispatch_unit)", example = "1")
@@ -86,11 +86,11 @@
     private Integer worktypeId;
 
     @ApiModelProperty(value = "璐圭敤", example = "1")
-    @ExcelColumn(name="璐圭敤",index = 10)
+    @ExcelColumn(name="璐圭敤",index = 10,width = 5)
     private BigDecimal fee;
 
-    @ApiModelProperty(value = "鎬у埆 0鐢� 1濂�", example = "1")
-    @ExcelColumn(name="鎬у埆",index =4,valueMapping = "0=鐢�;1=濂�;")
+    @ApiModelProperty(value = "鎬у埆 0=鐢�;1=濂�", example = "1")
+    @ExcelColumn(name="鎬у埆",index =4,valueMapping = "0=鐢�;1=濂�;",width = 3)
     private Integer sex;
 
     @ApiModelProperty(value = "褰撳墠璐圭敤")
@@ -107,7 +107,7 @@
 
     @ApiModelProperty(value = "鏂规鍚嶇О")
     @TableField(exist = false)
-    @ExcelColumn(name="淇濋櫓鏂规",index =2)
+    @ExcelColumn(name="淇濋櫓鏂规",index =2,width = 10)
     private String solutionName;
 
     @ApiModelProperty(value = "鏂规涓婚敭")
@@ -120,15 +120,15 @@
 
     @ApiModelProperty(value = "娲鹃仯鍗曚綅鍚嶇О")
     @TableField(exist = false)
-    @ExcelColumn(name="娲鹃仯鍗曚綅",index = 6)
+    @ExcelColumn(name="娲鹃仯鍗曚綅",index = 6,width = 10)
     private String duName;
 
     @ApiModelProperty(value = "鍛樺伐鍚嶇О")
-    @ExcelColumn(name="鍛樺伐濮撳悕",index =3)
+    @ExcelColumn(name="鍛樺伐濮撳悕",index =3,width = 5)
     private String memberName;
 
     @ApiModelProperty(value = "宸ョ鍚嶇О")
-    @ExcelColumn(name="鎵�灞炲伐绉�",index = 7)
+    @ExcelColumn(name="鎵�灞炲伐绉�",index = 7,width = 10)
     @TableField(exist = false)
     private String workTypeName;
 
diff --git a/server/service/src/main/java/com/doumee/dao/business/vo/TaxesInvoicingVO.java b/server/service/src/main/java/com/doumee/dao/business/vo/TaxesInvoicingVO.java
index 5b0ff41..ebed466 100644
--- a/server/service/src/main/java/com/doumee/dao/business/vo/TaxesInvoicingVO.java
+++ b/server/service/src/main/java/com/doumee/dao/business/vo/TaxesInvoicingVO.java
@@ -40,6 +40,9 @@
     @ApiModelProperty(value = "鍑忎繚浜烘暟")
     private Integer delNum;
 
+    @ApiModelProperty(value = "鍒涘缓鏃堕棿")
+    private Date createTime;
+
     @ApiModelProperty(value = "淇濆崟鐢熸晥璧锋湡")
     private Date startTime;
 
diff --git a/server/service/src/main/java/com/doumee/service/business/impl/ApplyChangeServiceImpl.java b/server/service/src/main/java/com/doumee/service/business/impl/ApplyChangeServiceImpl.java
index 9eb88b1..1eaf8e0 100644
--- a/server/service/src/main/java/com/doumee/service/business/impl/ApplyChangeServiceImpl.java
+++ b/server/service/src/main/java/com/doumee/service/business/impl/ApplyChangeServiceImpl.java
@@ -859,7 +859,7 @@
             applyChagneDetail.setApplyChangeId(applyChange.getId());
             applyChagneDetail.setType(Constants.ONE);
 
-            applyChagneDetail.setStartTime(DateUtil.getMontageDate(applyDetail.getStartTime(),1));
+            applyChagneDetail.setStartTime(DateUtil.getMontageDate(applyChange.getApplyStartTime(),1));
             applyChagneDetail.setEndTime(DateUtil.getMontageDate(applyChange.getApplyStartTime(),3));
 
             applyChagneDetail.setFee( detailFee.multiply(new BigDecimal(-1)));
@@ -958,7 +958,7 @@
             applyChagneDetail.setCreator(loginUserInfo.getId());
             applyChagneDetail.setIsdeleted(Constants.ZERO);
             applyChagneDetail.setApplyChangeId(applyChange.getId());
-            applyChagneDetail.setStartTime(DateUtil.getMontageDate(applyChange.getStartTime(),1));
+            applyChagneDetail.setStartTime(DateUtil.getMontageDate(applyChange.getApplyStartTime(),1));
             applyChagneDetail.setEndTime(DateUtil.getMontageDate(insuranceApply.getEndTime(),2));
             applyChagneDetail.setType(Constants.ZERO);
             applyChagneDetail.setFee(detailFee);
diff --git a/server/service/src/main/java/com/doumee/service/business/impl/InsuranceApplyServiceImpl.java b/server/service/src/main/java/com/doumee/service/business/impl/InsuranceApplyServiceImpl.java
index d8911d9..4e3fc27 100644
--- a/server/service/src/main/java/com/doumee/service/business/impl/InsuranceApplyServiceImpl.java
+++ b/server/service/src/main/java/com/doumee/service/business/impl/InsuranceApplyServiceImpl.java
@@ -369,7 +369,7 @@
         LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
         Constants.ApplyLogType applyLogType = null;
         String info = "";
-            //濡傛灉鏄┏鍥�,鍙兘鍙┏鍥炲凡绛剧珷鐘舵�佷笅鐨勯��鍥炵敵璇风姸鎬佽繘琛屾搷浣�
+        //濡傛灉鏄┏鍥�,鍙兘鍙┏鍥炲凡绛剧珷鐘舵�佷笅鐨勯��鍥炵敵璇风姸鎬佽繘琛屾搷浣�
         if(!Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.WAIT_SIGNATURE.getKey())){
             throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝璇ョ敵璇风姸鎬佸凡娴佽浆锛屽綋鍓嶄笉鏀寔璇ユ搷浣渵");
         }
@@ -1081,7 +1081,7 @@
         queryWrapper.selectAll(InsuranceApply.class);
         queryWrapper.selectAs(Company::getName,InsuranceApply::getCompanyName);
         queryWrapper.selectAs(Solutions::getName,InsuranceApply::getSolutionsName);
-        queryWrapper.select(" DATEDIFF( t.END_TIME ,now()  ) AS loseEfficacyDays ");
+        queryWrapper.select(" DATEDIFF( t.END_TIME ,now()  ) AS loseEfficacyDays  ");
         queryWrapper.select(" ( select count(1) from apply_detail ad  where ad.apply_id = t.id ) as insureNum");
         if(!Objects.isNull(pageWrap.getModel())&&!Objects.isNull(pageWrap.getModel().getType())){
             queryWrapper.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");
@@ -1262,13 +1262,9 @@
         if(insuranceApply.getStartTime().compareTo(new Date())<0  && insuranceApply.getEndTime().compareTo(new Date()) > 0 ){
             insuranceApply.setLoseEfficacyDays(DateUtil.daysBetweenDates(insuranceApply.getEndTime(),new Date()));
         }
-
-
         initApplyStatus(insuranceApply);
-
         //鏌ヨ闄勪欢鏁版嵁
         initImgData(insuranceApply);
-
         //鏌ヨ鎿嶄綔璁板綍
         List<ApplyLog> applyLogList = applyLogJoinMapper.selectJoinList(ApplyLog.class,
                 new MPJLambdaWrapper<ApplyLog>()
@@ -1291,12 +1287,14 @@
         if(insuranceApply.getStatus().equals(Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey())){
             //濡傛灉褰撳墠鏃堕棿澶т簬缁撴潫鏃ユ湡 鍒欎娇鐢ㄧ粨鏉熸棩鏈熷姣斿紑濮嬫棩鏈�
             if(DateUtil.compareDate(new Date(),insuranceApply.getEndTime())>=Constants.ZERO){
-                insuranceApply.setServiceDays(DateUtil.daysBetweenDates(insuranceApply.getEndTime(),insuranceApply.getStartTime()));
+                insuranceApply.setServiceDays(
+                        DateUtil.daysBetweenDates(insuranceApply.getEndTime(),insuranceApply.getStartTime())+1
+                );
             }else if(DateUtil.compareDate(insuranceApply.getStartTime(),new Date())>=Constants.ZERO){
                 //鏈紑濮�
                 insuranceApply.setServiceDays(Constants.ZERO);
             }else{
-                insuranceApply.setServiceDays(DateUtil.daysBetweenDates(new Date(),insuranceApply.getStartTime()));
+                insuranceApply.setServiceDays(DateUtil.daysBetweenDates(new Date(),insuranceApply.getStartTime())+1);
             }
         }
     }
@@ -1327,17 +1325,17 @@
                     model.setBaoxiandanFile(f);
                 }
 
-                if(model.getStatus().equals(Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey())){
-                    //濡傛灉褰撳墠鏃堕棿澶т簬缁撴潫鏃ユ湡 鍒欎娇鐢ㄧ粨鏉熸棩鏈熷姣斿紑濮嬫棩鏈�
-                    if(DateUtil.compareDate(new Date(),model.getEndTime())>=Constants.ZERO){
-                        model.setServiceDays(DateUtil.daysBetweenDates(model.getEndTime(),model.getStartTime()));
-                    }else if(DateUtil.compareDate(model.getStartTime(),new Date())>=Constants.ZERO){
-                        //鏈紑濮�
-                        model.setServiceDays(Constants.ZERO);
-                    }else{
-                        model.setServiceDays(DateUtil.daysBetweenDates(new Date(),model.getStartTime()));
-                    }
-                }
+//                if(model.getStatus().equals(Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey())){
+//                    //濡傛灉褰撳墠鏃堕棿澶т簬缁撴潫鏃ユ湡 鍒欎娇鐢ㄧ粨鏉熸棩鏈熷姣斿紑濮嬫棩鏈�
+//                    if(DateUtil.compareDate(new Date(),model.getEndTime())>=Constants.ZERO){
+//                        model.setServiceDays(DateUtil.daysBetweenDates(model.getEndTime(),model.getStartTime()));
+//                    }else if(DateUtil.compareDate(model.getStartTime(),new Date())>=Constants.ZERO){
+//                        //鏈紑濮�
+//                        model.setServiceDays(Constants.ZERO);
+//                    }else{
+//                        model.setServiceDays(DateUtil.daysBetweenDates(new Date(),model.getStartTime()));
+//                    }
+//                }
             }
         }
     }
@@ -1476,16 +1474,13 @@
                 if(CollectionUtils.isNotEmpty(applyDetailList)){
                     for (ApplyDetail applyDetail: applyDetailList) {
                         //2024-1-30 10:04:24 淇敼 鏍规嵁瀹為檯澶╂暟杩涜璁$畻 褰撳墠璐圭敤  鎬婚噾棰�/鎬诲ぉ鏁�*瀹為檯澶╂暟
-                        Integer maxDays = DateUtil.calculateBetween(applyDetail.getStartTime(),applyDetail.getEndTime(),0) + 1 ;
+                        Integer maxDays = DateUtil.calculateBetween(applyDetail.getStartTime(),applyDetail.getEndTime(),0);
                         BigDecimal fee = applyDetail.getFee();
                         if(applyDetail.getStartTime().compareTo(new Date()) <= 0 && applyDetail.getEndTime().compareTo(new Date()) >= 0 ){
-                            Integer days =  DateUtil.calculateBetween(applyDetail.getStartTime(),new Date(),0) + 1 ;
+                            Integer days =  DateUtil.calculateBetween(applyDetail.getStartTime(),new Date(),0);
                             applyDetail.setCurrentFee(fee.divide(BigDecimal.valueOf(maxDays),2, BigDecimal.ROUND_HALF_UP).multiply(BigDecimal.valueOf(days)));
                             applyDetailMapper.updateById(applyDetail);
                         }
-//                        DateUtil.daysBetweenDates(applyDetail.getEndTime(),applyDetail.getStartTime());
-//                        applyDetail.setCurrentFee(Constants.countDetailFee(solutions,new Date(),applyDetail.getStartTime()));
-//                        applyDetailMapper.updateById(applyDetail);
                         sumAmount = sumAmount.add(applyDetail.getCurrentFee());
                     }
                 }
diff --git a/server/service/src/main/java/com/doumee/service/business/impl/NoticesServiceImpl.java b/server/service/src/main/java/com/doumee/service/business/impl/NoticesServiceImpl.java
index 7cda6d4..a351fd9 100644
--- a/server/service/src/main/java/com/doumee/service/business/impl/NoticesServiceImpl.java
+++ b/server/service/src/main/java/com/doumee/service/business/impl/NoticesServiceImpl.java
@@ -161,7 +161,7 @@
         PageData<Notices> pageData = PageData.from(noticesMapper.selectJoinPage(page,Notices.class, queryWrapper));
         pageData.getRecords().forEach(i->{
             i.setTypeDetail(
-                    Constants.NoticeType.getDetail(i.getObjType(),i.getType())
+                    Constants.NoticeType.getDetail(i.getType(),i.getObjType())
             );
         });
         return pageData;
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 f9c781b..a3dee36 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
@@ -395,7 +395,15 @@
             queryWrapper.eq(!Objects.isNull(queryModel.getStatus()),Taxes::getStatus,queryModel.getStatus());
         }
         queryWrapper.orderByAsc(Taxes::getCreateDate);
-        return taxesJoinMapper.selectJoinList(Taxes.class, queryWrapper);
+
+        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;
     }
 
 

--
Gitblit v1.9.3