From cb54e068db9d9816ae38f60f57ad0fe7ca10fca8 Mon Sep 17 00:00:00 2001
From: liukangdong <898885815@qq.com>
Date: 星期五, 06 十二月 2024 16:28:23 +0800
Subject: [PATCH] Merge branch 'master' of http://139.186.142.91:10010/r/productDev/funingyunwei

---
 server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/model/YwPatrolScheme.java                  |    3 
 server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwPatrolSchemeServiceImpl.java    |    2 
 server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/model/YwWorkorder.java                     |   39 +++----------
 server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/CompanyServiceImpl.java           |   39 +++++++++++++
 server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwAccountServiceImpl.java         |   26 ++++++++
 server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwContractRevenueServiceImpl.java |    1 
 server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwContractServiceImpl.java        |   66 ++++++++++++----------
 7 files changed, 113 insertions(+), 63 deletions(-)

diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/model/YwPatrolScheme.java b/server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/model/YwPatrolScheme.java
index 4f8b83a..a7c167c 100644
--- a/server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/model/YwPatrolScheme.java
+++ b/server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/model/YwPatrolScheme.java
@@ -56,7 +56,7 @@
     private String remark;
 
     @ApiModelProperty(value = "鐘舵�� 0鍚敤 1绂佺敤", example = "1")
-    @ExcelColumn(name="鐘舵��",index = 9,width = 6,valueMapping = "0=鍚敤;1=鍋滅敤;")
+    @ExcelColumn(name="鐘舵��",index = 8,width = 6,valueMapping = "0=鍚敤;1=鍋滅敤;")
     private Integer status;
 
     @ApiModelProperty(value = "鎺掑簭鐮�", example = "1")
@@ -121,6 +121,5 @@
 
     @ApiModelProperty(value = "瓒呮湡浠诲姟鏁�")
     @TableField(exist = false)
-    @ExcelColumn(name="瓒呮湡浠诲姟鏁�",index = 8,width = 6)
     private Integer timeOutTaskNum;
 }
diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/model/YwWorkorder.java b/server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/model/YwWorkorder.java
index e0c3601..52b009b 100644
--- a/server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/model/YwWorkorder.java
+++ b/server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/model/YwWorkorder.java
@@ -26,129 +26,103 @@
 
     @TableId(type = IdType.AUTO)
     @ApiModelProperty(value = "涓婚敭", example = "1")
-    @ExcelColumn(name="涓婚敭")
     private Integer id;
 
     @ApiModelProperty(value = "鍒涘缓浜虹紪鐮�", example = "1")
-    @ExcelColumn(name="鍒涘缓浜虹紪鐮�")
     private Integer creator;
 
     @ApiModelProperty(value = "鍒涘缓鏃堕棿")
-    @ExcelColumn(name="鍒涘缓鏃堕棿")
     @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
     private Date createDate;
 
     @ApiModelProperty(value = "鏇存柊浜虹紪鐮�", example = "1")
-    @ExcelColumn(name="鏇存柊浜虹紪鐮�")
     private Integer editor;
 
     @ApiModelProperty(value = "鏇存柊鏃堕棿")
-    @ExcelColumn(name="鏇存柊鏃堕棿")
     @JsonFormat(pattern = "yyyy-MM-dd")
     private Date editDate;
 
     @ApiModelProperty(value = "鏄惁鍒犻櫎0鍚� 1鏄�", example = "1")
-    @ExcelColumn(name="鏄惁鍒犻櫎0鍚� 1鏄�")
     private Integer isdeleted;
 
     @ApiModelProperty(value = "鏍囬")
-    @ExcelColumn(name="鏍囬")
     private String title;
 
     @ApiModelProperty(value = "澶囨敞")
-    @ExcelColumn(name="澶囨敞")
     private String remark;
 
     @ApiModelProperty(value = "鐘舵�� 0鍚敤 1绂佺敤", example = "1")
-    @ExcelColumn(name="鐘舵�� 0鍚敤 1绂佺敤")
     private Integer status;
 
     @ApiModelProperty(value = "鎺掑簭鐮�", example = "1")
-    @ExcelColumn(name="鎺掑簭鐮�")
     private Integer sortnum;
 
     @ApiModelProperty(value = "鎯呭喌璇存槑")
-    @ExcelColumn(name="鎯呭喌璇存槑")
     private String content;
 
     @ApiModelProperty(value = "涓婇棬鏃堕棿")
-    @ExcelColumn(name="涓婇棬鏃堕棿")
     @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
     private Date getDate;
 
     @ApiModelProperty(value = "鎵�灞為」鐩紪鐮侊紙鍏宠仈yw_project)", example = "1")
-    @ExcelColumn(name="鎵�灞為」鐩紪鐮侊紙鍏宠仈yw_project)")
     private Integer projectId;
 
     @ApiModelProperty(value = "鎵�灞炴ゼ瀹囩紪鐮侊紙鍏宠仈yw_building)", example = "1")
-    @ExcelColumn(name="鎵�灞炴ゼ瀹囩紪鐮侊紙鍏宠仈yw_building)")
     private Integer buildingId;
 
     @ApiModelProperty(value = "鎵�灞炴埧闂寸紪鐮侊紙鍏宠仈yw_room)", example = "1")
-    @ExcelColumn(name="鎵�灞炴埧闂寸紪鐮侊紙鍏宠仈yw_room)")
     private Integer roomId;
     @ApiModelProperty(value = "鎵�灞炴ゼ灞傜紪鐮侊紙鍏宠仈yw_floor)", example = "1")
-    @ExcelColumn(name="鎵�灞炴ゼ灞傜紪鐮侊紙鍏宠仈yw_floor)")
     private Integer floorId;
 
     @ApiModelProperty(value = "鎻愭姤浜虹紪鐮�", example = "1")
-    @ExcelColumn(name="鎻愭姤浜虹紪鐮�")
     private Integer userId;
 
     @ApiModelProperty(value = "鑱旂郴鐢佃瘽")
-    @ExcelColumn(name="鑱旂郴鐢佃瘽")
     private String phone;
 
     @ApiModelProperty(value = "鎻愭姤鏃堕棿")
-    @ExcelColumn(name="鎻愭姤鏃堕棿")
     @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    @ExcelColumn(name="涓婃姤鏃堕棿",index = 5,width = 16,dateFormat = "yyyy-MM-dd HH:mm:ss")
     private Date submitDate;
 
     @ApiModelProperty(value = "宸ュ崟鍒嗙被缂栫爜(鍏宠仈category锛�", example = "1")
-    @ExcelColumn(name="宸ュ崟鍒嗙被缂栫爜(鍏宠仈category锛�")
     private Integer cateId;
 
     @ApiModelProperty(value = "淇濅慨鍖哄煙绫诲瀷 0瀹ゅ唴缁翠慨 1鍏叡鍖哄煙", example = "1")
-    @ExcelColumn(name="淇濅慨鍖哄煙绫诲瀷 0瀹ゅ唴缁翠慨 1鍏叡鍖哄煙")
+    @ExcelColumn(name="浣嶇疆鍖哄煙",valueMapping = "0=瀹ゅ唴缁翠慨;1=鍏叡鍖哄煙;",index = 0,width = 10)
     private Integer areaType;
 
     @ApiModelProperty(value = "宸ュ崟缂栧彿")
-    @ExcelColumn(name="宸ュ崟缂栧彿")
     private String code;
 
     @ApiModelProperty(value = "澶勭悊鐘舵�� 0寰呭鐞� 1宸插垎娲� 2宸插鐞�", example = "1")
-    @ExcelColumn(name="澶勭悊鐘舵�� 0寰呭鐞� 1宸插垎娲� 2宸插鐞�")
+    @ExcelColumn(name="宸ュ崟鐘舵��",index = 7,width = 10,valueMapping = "0=寰呭鐞�;1=宸插垎娲�;1=宸插鐞�;")
     private Integer dealStatus;
 
     @ApiModelProperty(value = "鍒嗘淳浜虹紪鐮�(鍏宠仈system_user)", example = "1")
-    @ExcelColumn(name="鍒嗘淳浜虹紪鐮�(鍏宠仈system_user)")
     private Integer dispatchUserId;
 
     @ApiModelProperty(value = "鍒嗘淳鏃堕棿")
-    @ExcelColumn(name="鍒嗘淳鏃堕棿")
     @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
     private Date dispatchDate;
 
     @ApiModelProperty(value = "鍒嗘淳澶勭悊璇存槑")
-    @ExcelColumn(name="鍒嗘淳澶勭悊璇存槑")
     private String dispatchInfo;
 
     @ApiModelProperty(value = "澶勭悊浜虹紪鐮�(鍏宠仈system_user)", example = "1")
-    @ExcelColumn(name="澶勭悊浜虹紪鐮�(鍏宠仈system_user)")
     private Integer dealUserId;
 
     @ApiModelProperty(value = "澶勭悊鏃堕棿")
-    @ExcelColumn(name="澶勭悊鏃堕棿")
     @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
     private Date dealDate;
 
     @ApiModelProperty(value = "澶勭悊澶囨敞")
-    @ExcelColumn(name="澶勭悊澶囨敞")
     private String dealInfo;
 
     @ApiModelProperty(value = "澶勭悊鏂瑰紡 0鎸囨淳鍚庡鐞� 1鐩存帴鍥炲", example = "1")
-    @ExcelColumn(name="澶勭悊鏂瑰紡 0鎸囨淳鍚庡鐞� 1鐩存帴鍥炲")
     private Integer dealType;
+
     @ApiModelProperty(value = "椤圭洰鍚嶇О")
     @TableField(exist = false)
     private String projectName;
@@ -158,9 +132,11 @@
     private String queryStatus;
 
     @ApiModelProperty(value = "妤煎畤鍚嶇О")
+    @ExcelColumn(name="妤煎畤",index = 1,width = 10)
     @TableField(exist = false)
     private String buildingName;
     @ApiModelProperty(value = "鎴挎簮鍚嶇О")
+    @ExcelColumn(name="鎴挎簮",index = 2,width = 10)
     @TableField(exist = false)
     private String roomName;
     @ApiModelProperty(value = "妤煎眰鍚嶇О")
@@ -170,6 +146,7 @@
     @TableField(exist = false)
     private String roomNum;
     @ApiModelProperty(value = "鎻愭姤浜哄鍚�")
+    @ExcelColumn(name="涓婃姤浜�",index = 4,width = 10)
     @TableField(exist = false)
     private String creatorName;
     @ApiModelProperty(value = "鎻愭姤浜虹數璇�")
@@ -177,11 +154,13 @@
     private String creatorMobile;
     @ApiModelProperty(value = "澶勭悊浜哄鍚�")
     @TableField(exist = false)
+    @ExcelColumn(name="澶勭悊浜�",index = 6,width = 10)
     private String dealUserName;
     @ApiModelProperty(value = "澶勭悊浜虹粍缁�")
     @TableField(exist = false)
     private String dealUserCompany;
     @ApiModelProperty(value = "绫诲埆鍚嶇О")
+    @ExcelColumn(name="宸ュ崟鍒嗙被",index = 3,width = 10)
     @TableField(exist = false)
     private String categoryName;
     @ApiModelProperty(value = "鍒嗛厤浜哄鍚�")
diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/CompanyServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/CompanyServiceImpl.java
index d2d8aef..2108dd2 100644
--- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/CompanyServiceImpl.java
+++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/CompanyServiceImpl.java
@@ -25,10 +25,12 @@
 import com.doumee.dao.admin.request.UpdateCompanySortDTO;
 import com.doumee.dao.admin.response.CompanyDTO;
 import com.doumee.dao.business.MemberMapper;
+import com.doumee.dao.business.YwContractMapper;
 import com.doumee.dao.business.dao.CompanyMapper;
 import com.doumee.dao.business.dao.join.CompanyJoinMapper;
 import com.doumee.dao.business.model.Company;
 import com.doumee.dao.business.model.Member;
+import com.doumee.dao.business.model.YwContract;
 import com.doumee.dao.business.vo.CompanyTree;
 import com.doumee.dao.system.model.SystemUser;
 import com.doumee.service.business.CompanyService;
@@ -63,6 +65,9 @@
 
     @Autowired
     private CompanyJoinMapper companyJoinMapper;
+    @Autowired
+    private YwContractMapper ywContractMapper;
+
 
     /**
      * 鍒涘缓璐㈠姟鍏徃
@@ -77,6 +82,13 @@
                 .eq(Company::getType,company.getType())
                 .eq(Company::getIsdeleted,Constants.ZERO)) >0){
             throw new BusinessException(ResponseStatus.DATA_EXISTS.getCode(), "瀵逛笉璧凤紝鍚嶇О涓嶈兘閲嶅~");
+        }
+        if(StringUtils.isNotBlank(company.getCode())){
+            if(companyMapper.selectCount(new QueryWrapper<Company>().lambda()
+                    .eq(Company::getCode,company.getCode())
+                    .eq(Company::getIsdeleted,Constants.ZERO)) >0){
+                throw new BusinessException(ResponseStatus.DATA_EXISTS.getCode(), "瀵逛笉璧凤紝绾崇◣璇嗗埆鍙蜂笉鑳介噸澶崀");
+            }
         }
         company.setCreateDate(new Date());
         company.setCreator(company.getLoginUserInfo().getId());
@@ -105,6 +117,13 @@
                 .eq(Company::getName,company.getName())
                 .eq(Company::getIsdeleted,Constants.ZERO)) >0){
             throw new BusinessException(ResponseStatus.DATA_EXISTS.getCode(), "瀵逛笉璧凤紝缁勭粐鍚嶇О涓嶈兘閲嶅~");
+        }
+        if(StringUtils.isNotBlank(company.getCode())){
+            if(companyMapper.selectCount(new QueryWrapper<Company>().lambda()
+                    .eq(Company::getCode,company.getCode())
+                    .eq(Company::getIsdeleted,Constants.ZERO)) >0){
+                throw new BusinessException(ResponseStatus.DATA_EXISTS.getCode(), "瀵逛笉璧凤紝绾崇◣璇嗗埆鍙蜂笉鑳介噸澶崀");
+            }
         }
         LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
         if(user ==null){
@@ -260,6 +279,9 @@
                 .eq(Member::getIsdeleted,Constants.ZERO)) >0){
             throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(), "瀵逛笉璧凤紝璇ラ儴闂ㄤ笅瀛樺湪浜哄憳淇℃伅锛屼笉鑳借繘琛屽垹闄ゆ搷浣滐紒");
         }
+        if(ywContractMapper.selectCount(new QueryWrapper<YwContract>().lambda().eq(YwContract::getCompanyId,id))>Constants.ZERO){
+            throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(), "褰撳墠鍏徃宸插叧鑱斾笟鍔★紝涓嶅彲鍒犻櫎");
+        }
 
         Company company = new Company();
         company.setId(id);
@@ -308,6 +330,15 @@
                 .eq(Company::getIsdeleted,Constants.ZERO)) >0){
             throw new BusinessException(ResponseStatus.DATA_EXISTS.getCode(), "瀵逛笉璧凤紝缁勭粐鍚嶇О涓嶈兘閲嶅~");
         }
+        if(StringUtils.isNotBlank(company.getCode())){
+            if(companyMapper.selectCount(new QueryWrapper<Company>().lambda()
+                    .eq(Company::getCode,company.getCode())
+                    .ne(Company::getId,company.getId())
+                    .eq(Company::getIsdeleted,Constants.ZERO)) >0){
+                throw new BusinessException(ResponseStatus.DATA_EXISTS.getCode(), "瀵逛笉璧凤紝绾崇◣璇嗗埆鍙蜂笉鑳介噸澶崀");
+            }
+        }
+
         LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
         if(user == null){
             user = company.getLoginUserInfo();
@@ -367,6 +398,14 @@
                 .eq(Company::getIsdeleted,Constants.ZERO)) >0){
             throw new BusinessException(ResponseStatus.DATA_EXISTS.getCode(), "瀵逛笉璧凤紝鍚嶇О涓嶈兘閲嶅~");
         }
+        if(StringUtils.isNotBlank(company.getCode())){
+            if(companyMapper.selectCount(new QueryWrapper<Company>().lambda()
+                    .eq(Company::getCode,company.getCode())
+                    .ne(Company::getId,company.getId())
+                    .eq(Company::getIsdeleted,Constants.ZERO)) >0){
+                throw new BusinessException(ResponseStatus.DATA_EXISTS.getCode(), "瀵逛笉璧凤紝绾崇◣璇嗗埆鍙蜂笉鑳介噸澶崀");
+            }
+        }
         companyMapper.updateById(company);
         return company.getId();
     }
diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwAccountServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwAccountServiceImpl.java
index 0256c8f..5044c23 100644
--- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwAccountServiceImpl.java
+++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwAccountServiceImpl.java
@@ -8,9 +8,11 @@
 import com.doumee.core.utils.Constants;
 import com.doumee.core.utils.Utils;
 import com.doumee.dao.business.YwAccountMapper;
+import com.doumee.dao.business.YwContractRevenueMapper;
 import com.doumee.dao.business.dao.CompanyMapper;
 import com.doumee.dao.business.model.Company;
 import com.doumee.dao.business.model.YwAccount;
+import com.doumee.dao.business.model.YwContractRevenue;
 import com.doumee.dao.business.model.YwProject;
 import com.doumee.service.business.YwAccountService;
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
@@ -18,6 +20,7 @@
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.github.yulichang.wrapper.MPJLambdaWrapper;
+import org.apache.commons.lang3.StringUtils;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
 import org.springframework.util.CollectionUtils;
@@ -37,6 +40,8 @@
     private YwAccountMapper ywAccountMapper;
     @Autowired
     private CompanyMapper companyMapper;
+    @Autowired
+    private YwContractRevenueMapper ywContractRevenueMapper;
 
     @Override
     public Integer create(YwAccount model) {
@@ -49,6 +54,15 @@
                 || !Constants.equalsInteger(ywProject.getType(),Constants.TWO)){
             throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"瀵逛笉璧凤紝璇烽�夋嫨姝g‘鐨勫叕鍙镐俊鎭紒");
         }
+        if(StringUtils.isNotBlank(model.getTitle())){
+            if(ywAccountMapper.selectCount(new QueryWrapper<YwAccount>().lambda()
+                    .eq(YwAccount::getTitle,model.getTitle())
+                    .eq(YwAccount::getIsdeleted,Constants.ZERO)) >0){
+                throw new BusinessException(ResponseStatus.DATA_EXISTS.getCode(), "瀵逛笉璧凤紝鏀舵敮鏉$洰涓嶈兘閲嶅~");
+            }
+        }
+
+
         model.setCreator(model.getLoginUserInfo().getId());
         model.setIsdeleted(Constants.ZERO);
         model.setCreateDate(new Date());
@@ -61,6 +75,9 @@
 
     @Override
     public void deleteById(Integer id, LoginUserInfo user) {
+        if(ywContractRevenueMapper.selectCount(new QueryWrapper<YwContractRevenue>().lambda().eq(YwContractRevenue::getAccountId,id))>Constants.ZERO){
+            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"褰撳墠鏀舵敮璐︽埛宸插叧鑱斾笟鍔★紝涓嶅彲鍒犻櫎");
+        }
         YwAccount model = new YwAccount();
         model.setId(id);
         model.setIsdeleted(Constants.ONE);
@@ -95,6 +112,15 @@
                 || !Constants.equalsInteger(ywProject.getType(),Constants.TWO)){
             throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"瀵逛笉璧凤紝璇烽�夋嫨姝g‘鐨勫叕鍙镐俊鎭紒");
         }
+        if(StringUtils.isNotBlank(model.getTitle())){
+            if(ywAccountMapper.selectCount(new QueryWrapper<YwAccount>().lambda()
+                    .eq(YwAccount::getTitle,model.getTitle())
+                    .ne(YwAccount::getId,model.getId())
+                    .eq(YwAccount::getIsdeleted,Constants.ZERO)) >0){
+                throw new BusinessException(ResponseStatus.DATA_EXISTS.getCode(), "瀵逛笉璧凤紝鏀舵敮鏉$洰涓嶈兘閲嶅~");
+            }
+        }
+
         model.setEditDate(model.getCreateDate());
         model.setEditor(model.getCreator());
         ywAccountMapper.updateById(model);
diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwContractRevenueServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwContractRevenueServiceImpl.java
index 8912d5e..20da8dc 100644
--- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwContractRevenueServiceImpl.java
+++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwContractRevenueServiceImpl.java
@@ -268,6 +268,7 @@
                 new MPJLambdaWrapper<YwContractRevenue>().selectAll(YwContractRevenue.class)
                         .selectAs(YwContractBill::getCode,YwContractRevenue::getBillCode)
                         .selectAs(YwContract::getCode,YwContractRevenue::getContractCode)
+                        .selectAs(YwContract::getStatus,YwContractRevenue::getContractStatus)
                         .selectAs(YwCustomer::getName,YwContractRevenue::getCustomerName)
                         .selectAs(SystemUser::getRealname,YwContractRevenue::getRealname)
                         .selectAs(YwAccount::getTitle,YwContractRevenue::getAccountTitle)
diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwContractServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwContractServiceImpl.java
index 6e2d2d4..f72126a 100644
--- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwContractServiceImpl.java
+++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwContractServiceImpl.java
@@ -31,6 +31,7 @@
 import org.springframework.util.CollectionUtils;
 
 import java.math.BigDecimal;
+import java.math.RoundingMode;
 import java.time.temporal.ChronoUnit;
 import java.util.*;
 import java.util.stream.Collectors;
@@ -74,12 +75,20 @@
     @Transactional(rollbackFor = {BusinessException.class,Exception.class})
     public Integer create(YwContract model) {
         isParamValidCreated(model);
+
+
         model.setCreator(model.getLoginUserInfo().getId());
         model.setIsdeleted(Constants.ZERO);
         model.setCreateDate(new Date());
-        model.setStatus(Constants.ZERO);
         model.setEditDate(model.getCreateDate());
         model.setEditor(model.getCreator());
+        if(model.getStartDate().getTime() > System.currentTimeMillis()){
+            model.setStatus(Constants.ZERO);
+        }else if(model.getStartDate().getTime() <= System.currentTimeMillis() && model.getEndDate().getTime() > System.currentTimeMillis()){
+            model.setStatus(Constants.ONE);
+        }else{
+            model.setStatus(Constants.TWO);
+        }
         model.setStatus(Constants.ZERO);//寰呮墽琛�
         model.setRemark(getRemarlByParam(model));
         ywContractMapper.insert(model);
@@ -268,7 +277,7 @@
         }
         model.setTotalArea(new BigDecimal(0));
         for(YwRoom r : rooms){
-            model.setTotalArea(model.getTotalArea().add(Constants.formatBigdecimal(r.getArea())));
+            model.setTotalArea(model.getTotalArea().add(Constants.formatBigdecimal(r.getRentArea())));
         }
         model.setRoomList(rooms);
     }
@@ -353,9 +362,6 @@
         update.setBtFee(param.getBtFee());
         update.setBtRemark(getbackRentRemarkByParam(param));
         ywContractMapper.updateById(update);
-//        if(1==1){
-//            throw new BusinessException(ResponseStatus.NOT_ALLOWED);
-//        }
         dealLogBiz(param,Constants.YwLogType.CONTRACT_BACK, param.getLoginUserInfo().getRealname(),getbackRentLogByParam(param));
         return param.getId();
     }
@@ -417,16 +423,8 @@
                         closeBills.add(bill);
                         noBills.add(bill);
                     }
-//                    if(bill.getStartDate().getTime()>param.getEditDate().getTime()){
-//                        //濡傛灉杩樻病寮�濮嬶紝璐﹀崟鐩存帴鍏抽棴
-//                        closeBills.add(bill);
-//                        noBills.add(bill);
-//                    }else{
-//                        canBills.add(bill);
-//                    }
                 }else  if(Constants.equalsInteger(bill.getPayStatus(),Constants.ONE) ){
                     if(bill.getStartDate().getTime()>param.getBtDate().getTime()){
-//                    if(bill.getEndDate().getTime()<param.getEditDate().getTime()){
                         //濡傛灉宸茬粨娓咃紝璐﹀崟鐩存帴鍏抽棴
                         noBills.add(bill);
                     }else{
@@ -489,6 +487,7 @@
                 addBill.setContractId(param.getId());
                 addBill.setType(Constants.ONE);
                 addBill.setStatus(Constants.ZERO);
+                addBill.setTotleFee(addBill.getReceivableFee());
                 if(Constants.equalsInteger(addBill.getFeeType(),Constants.ONE)){
                     addBill.setStartDate(addBill.getPlanPayDate());
                     addBill.setEndDate(addBill.getPlanPayDate());
@@ -698,12 +697,16 @@
         }
         int num =1;
         for(int i=0;i<billList1.size();i++){
-            billList1.get(i).setSortnum(num);
-            num++;
+            if(Constants.equalsInteger(billList1.get(i).getCostType(),Constants.ZERO)){
+                billList1.get(i).setSortnum(num);
+                num++;
+            }
         }
         for(int i=0;i<billList2.size();i++){
-            billList2.get(i).setSortnum(num);
-            num++;
+            if(Constants.equalsInteger(billList1.get(i).getCostType(),Constants.ONE)) {
+                billList2.get(i).setSortnum(num);
+                num++;
+            }
         }
         if(model.getId()!=null){
             ywContractBillMapper.insert(billList1);
@@ -849,34 +852,37 @@
         BigDecimal totalFee = new BigDecimal(0);
         DateCompare dateCompare =   DateCompare.dayCompare(bill.getStartDate(),bill.getEndDate(),freeStart, freeEnd);
         if(Constants.equalsInteger(d.getCircleType(),Constants.ZERO)){
-            //0=鍏冩瘡骞崇背澶�
+            //0=鍏冩瘡骞崇背澶� 璐﹀崟閲戦=璐﹀崟鍛ㄦ湡鐨勫ぉ鏁�*绉熻祦闈㈢Н*鍗曚环锛�
             int days = dateCompare.getDay() ;
             BigDecimal areas = getAreasNumBYRooms(model.getRoomList());
             totalFee = new BigDecimal(days).multiply(areas).multiply(Constants.formatBigdecimal(d.getPrice()));//鎬讳环鏍�
         }else  if(Constants.equalsInteger(d.getCircleType(),Constants.ONE)){
-            //1=鍏冩瘡骞崇背鏈�
+            //1=鍏冩瘡骞崇背鏈� 璐﹀崟閲戦=璐﹀崟鍛ㄦ湡鐨勬湀鏁帮紙寮�濮嬫棩鏈熻绠楄嚜鐒舵湀锛�*绉熻祦闈㈢Н*鍗曚环+涓嶆弧涓�涓湀鐨勫ぉ鏁�*绉熻祦闈㈢Н*鍗曚环*12/365锛�
             BigDecimal areas = getAreasNumBYRooms(model.getRoomList());
             BigDecimal month =dateCompare.getMonthFloat();
             totalFee = month.multiply(areas).multiply(Constants.formatBigdecimal(d.getPrice()));//鎬讳环鏍�
         }else  if(Constants.equalsInteger(d.getCircleType(),Constants.TWO)){
-            //2=鍏冩瘡骞崇背骞�
+            //2=鍏冩瘡骞崇背骞� 璐﹀崟閲戦=璐﹀崟鍛ㄦ湡鐨勬湀鏁帮紙寮�濮嬫棩鏈熻绠楄嚜鐒舵湀锛�*鍗曚环*闈㈢Н/12+涓嶆弧涓�涓湀鐨勫ぉ鏁�*绉熻祦闈㈢Н*鍗曚环/365锛�
             BigDecimal areas = getAreasNumBYRooms(model.getRoomList());
-            BigDecimal year =  dateCompare.getYearFloat();
-            totalFee = year.multiply(areas).multiply(Constants.formatBigdecimal(d.getPrice()));//鎬讳环鏍�
+            BigDecimal month = new BigDecimal(dateCompare.getMonth());
+            totalFee = ((month.multiply(Constants.formatBigdecimal(d.getPrice())).divide(new BigDecimal(12),2, RoundingMode.HALF_UP))
+                    .add(new BigDecimal(dateCompare.getMonthDays()).multiply(Constants.formatBigdecimal(d.getPrice())).divide(new BigDecimal(365),2, RoundingMode.HALF_UP)))
+                    .multiply(areas);//鎬讳环鏍�
         }else  if(Constants.equalsInteger(d.getCircleType(),Constants.THREE)){
-            //3=鍏冩瘡澶�
+            //3=鍏冩瘡澶� 璐﹀崟閲戦=璐﹀崟鍛ㄦ湡鐨勫ぉ鏁�*鍗曚环锛�
             int days = dateCompare.getDay() ;
             totalFee = new BigDecimal(days).multiply(Constants.formatBigdecimal(d.getPrice()));//鎬讳环鏍�
         }else  if(Constants.equalsInteger(d.getCircleType(),Constants.FOUR)){
-            //4=鍏冩瘡鏈�
+            //4=鍏冩瘡鏈� 璐﹀崟閲戦=璐﹀崟鍛ㄦ湡鐨勬湀鏁帮紙寮�濮嬫棩鏈熻绠楄嚜鐒舵湀锛�*鍗曚环+涓嶆弧涓�涓湀鐨勫ぉ鏁�*鍗曚环*12/365
             BigDecimal month = dateCompare.getMonthFloat();
             totalFee = month.multiply(Constants.formatBigdecimal(d.getPrice()));//鎬讳环鏍�
         }else  if(Constants.equalsInteger(d.getCircleType(),Constants.FIVE)){
-            //5=鍏冩瘡骞�
-            BigDecimal year =  dateCompare.getYearFloat();
-            totalFee = year.multiply(Constants.formatBigdecimal(d.getPrice()));//鎬讳环鏍�
+            //5=鍏冩瘡骞� 璐﹀崟閲戦=璐﹀崟鍛ㄦ湡鐨勬湀鏁帮紙寮�濮嬫棩鏈熻绠楄嚜鐒舵湀锛�*鍗曚环*闈㈢Н/12+涓嶆弧涓�涓湀鐨勫ぉ鏁�*绉熻祦闈㈢Н*鍗曚环/365锛�
+            BigDecimal month = new BigDecimal(dateCompare.getMonth());
+            totalFee =( month.multiply(Constants.formatBigdecimal(d.getPrice())).divide(new BigDecimal(12),2, RoundingMode.HALF_UP))
+                    .add(new BigDecimal(dateCompare.getMonthDays()).multiply(Constants.formatBigdecimal(d.getPrice())).divide(new BigDecimal(365),2, RoundingMode.HALF_UP));//鎬讳环鏍�
         }else  if(Constants.equalsInteger(d.getCircleType(),Constants.SIX)){
-            //6=鍏冩瘡鍦�
+            //6=鍏冩瘡鍦� 璐﹀崟閲戦=鍗曚环锛涘彧鏈夐�夋嫨涓�娆℃�т粯娆炬椂锛屾墠鑳介�夋嫨璇ュ崟浠风淮搴︼紱
             totalFee =Constants.formatBigdecimal(d.getPrice());
         }
         if(Constants.equalsInteger(model.getRoundedUp(),Constants.ONE)){
@@ -947,7 +953,7 @@
         BigDecimal data= new BigDecimal(0);
         if(roomList!=null){
             for(YwRoom r :roomList){
-                data = data.add(Constants.formatBigdecimal(r.getArea()));
+                data = data.add(Constants.formatBigdecimal(r.getRentArea()));
             }
         }
 
@@ -1141,7 +1147,7 @@
         }
         model.setTotalArea(new BigDecimal(0));
         for(YwRoom r : rooms){
-            model.setTotalArea(model.getTotalArea().add(Constants.formatBigdecimal(r.getArea())));
+            model.setTotalArea(model.getTotalArea().add(Constants.formatBigdecimal(r.getRentArea())));
         }
         model.setRoomList(rooms);
         YwCustomer customer = customerMapper.selectById(model.getRenterId());
diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwPatrolSchemeServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwPatrolSchemeServiceImpl.java
index 3ac66ba..171745d 100644
--- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwPatrolSchemeServiceImpl.java
+++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwPatrolSchemeServiceImpl.java
@@ -287,7 +287,7 @@
                 .like(StringUtils.isNotBlank(model.getTitle()),YwPatrolScheme::getTitle,model.getTitle())
                 //鏌ヨ鏈夋椂娈典氦闆嗙殑鏁版嵁
                 .apply(Objects.nonNull(model.getStartDate())&&Objects.nonNull(model.getEndDate()),
-                        " t.START_DATE <= '"+Utils.Date.getStart(pageWrap.getModel().getEndDate())+"' and t.END_DATE >= '"+Utils.Date.getStart(pageWrap.getModel().getStartDate())+"' "
+                        " t.START_DATE <= '"+pageWrap.getModel().getEndDate()+"' and t.END_DATE >= '"+pageWrap.getModel().getStartDate()+"' "
                 )
 //                .ge(Objects.nonNull(model.getStartDate()),YwDeviceRecord::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getStartDate()))
 //                .le(Objects.nonNull(model.getEndDate()),YwDeviceRecord::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getEndDate()))

--
Gitblit v1.9.3