From 078ce36a32bc6679f32e42fd18a9cbb454ff7b7d Mon Sep 17 00:00:00 2001
From: xuhy <3313886187@qq.com>
Date: 星期一, 10 二月 2025 11:38:13 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master'

---
 ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TContractController.java |  161 ++++++++++++++++++++++++++++++++++++++++++++++++++---
 1 files changed, 150 insertions(+), 11 deletions(-)

diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TContractController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TContractController.java
index 4476610..6bc7ae8 100644
--- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TContractController.java
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TContractController.java
@@ -1,37 +1,52 @@
 package com.ruoyi.web.controller.api;
 
 
+import cn.afterturn.easypoi.excel.ExcelExportUtil;
+import cn.afterturn.easypoi.excel.entity.ExportParams;
 import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
 import com.ruoyi.common.annotation.Log;
 import com.ruoyi.common.basic.PageInfo;
+import com.ruoyi.common.constant.DictConstants;
 import com.ruoyi.common.core.domain.AjaxResult;
 import com.ruoyi.common.core.domain.R;
 import com.ruoyi.common.enums.BusinessType;
+import com.ruoyi.common.utils.DateUtils;
+import com.ruoyi.common.utils.DictUtils;
 import com.ruoyi.common.utils.StringUtils;
+import com.ruoyi.common.utils.WebUtils;
 import com.ruoyi.system.dto.TContractDTO;
 import com.ruoyi.system.dto.THouseDTO;
-import com.ruoyi.system.model.TContract;
-import com.ruoyi.system.model.TContractRentType;
-import com.ruoyi.system.model.THouse;
+import com.ruoyi.system.dto.TerminateContractDTO;
+import com.ruoyi.system.export.ContractExport;
+import com.ruoyi.system.export.OpticalInspectionExport;
+import com.ruoyi.system.model.*;
+import com.ruoyi.system.query.TContractBillQuery;
 import com.ruoyi.system.query.TContractQuery;
 import com.ruoyi.system.query.THouseQuery;
 import com.ruoyi.system.query.TUserHistoryQuery;
-import com.ruoyi.system.service.TContractRentTypeService;
-import com.ruoyi.system.service.TContractService;
-import com.ruoyi.system.service.THouseService;
+import com.ruoyi.system.service.*;
+import com.ruoyi.system.vo.BillVO;
+import com.ruoyi.system.vo.CheckAcceptRecordVO;
 import com.ruoyi.system.vo.HouseVO;
+import com.ruoyi.web.controller.tool.NumberToChineseUtils;
+import com.ruoyi.web.controller.tool.WordUtil;
 import io.swagger.annotations.Api;
 import com.ruoyi.system.vo.TContractVO;
 import io.swagger.annotations.Api;
 import io.swagger.annotations.ApiOperation;
+import org.apache.poi.ss.usermodel.Workbook;
 import org.springframework.beans.BeanUtils;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.validation.annotation.Validated;
 import org.springframework.web.bind.annotation.*;
 
+import javax.servlet.ServletOutputStream;
+import javax.servlet.http.HttpServletResponse;
+import java.io.IOException;
+import java.math.BigDecimal;
+import java.net.URLEncoder;
 import java.time.LocalDateTime;
-import java.util.Arrays;
-import java.util.List;
+import java.util.*;
 
 /**
  * <p>
@@ -51,6 +66,10 @@
     private TContractRentTypeService contractRentTypeService;
     @Autowired
     private THouseService houseService;
+    @Autowired
+    private TBillService billService;
+    @Autowired
+    private TCheckAcceptRecordService checkAcceptRecordService;
     @ApiOperation(value = "获取合同分页列表")
     @PostMapping(value = "/contractList")
     public R<PageInfo<TContract>> contractList(@RequestBody TContractQuery query) {
@@ -61,7 +80,7 @@
     @PostMapping(value = "/addContract")
     public R<Boolean> addContract(@Validated @RequestBody TContractDTO dto) {
         contractService.save(dto);
-        if (dto.getIsIncreasing()==1){
+        if (dto.getIsIncreasing()){
             TContractRentType tContractRentType = new TContractRentType();
             tContractRentType.setContractId(dto.getId());
             tContractRentType.setIncreasingDecreasing(dto.getIncreasingDecreasing());
@@ -79,7 +98,7 @@
         contractService.updateById(dto);
         contractRentTypeService.remove(new LambdaQueryWrapper<TContractRentType>()
                 .eq(TContractRentType::getContractId,dto.getId()));
-        if (dto.getIsIncreasing()==1){
+        if (dto.getIsIncreasing()){
             TContractRentType tContractRentType = new TContractRentType();
             tContractRentType.setContractId(dto.getId());
             tContractRentType.setIncreasingDecreasing(dto.getIncreasingDecreasing());
@@ -93,7 +112,7 @@
     @Log(title = "合同管理-批量删除合同", businessType = BusinessType.DELETE)
     @ApiOperation(value = "批量删除合同")
     @DeleteMapping(value = "/deleteContractByIds")
-    public R<Boolean> deleteContractByIds3
+    public R<Boolean> deleteContractByIds
             (@RequestParam String ids) {
         if (StringUtils.isNotEmpty(ids)){
             contractService.removeBatchByIds(Arrays.asList(ids.split(",")));
@@ -107,6 +126,8 @@
         TContractVO res = new TContractVO();
         TContract contract = contractService.getById(id);
         BeanUtils.copyProperties(contract,res);
+        res.setPayType(DictUtils.getDictLabel(DictConstants.DICT_TYPE_CONTRACT_PAY_TYPE,res.getPayType()));
+        res.setStatus(DictUtils.getDictLabel(DictConstants.DICT_TYPE_CONTRACT_STATUS,res.getStatus()));
         TContractRentType contractRentType = contractRentTypeService.lambdaQuery().eq(TContractRentType::getContractId, id).one();
         if (contractRentType!=null){
             BeanUtils.copyProperties(contractRentType,res);
@@ -121,8 +142,126 @@
             house.setTenantType(oldContract.getPayType());
         }
         res.setHouse(house);
+        List<TBill> list = billService.lambdaQuery()
+                .eq(TBill::getContractId, id)
+                .in(TBill::getPayFeesStatus, Arrays.asList("1,4"))
+                .list();
+        BigDecimal payMoney = new BigDecimal("0");
+        for (TBill tBill : list) {
+            payMoney = payMoney.add(tBill.getPayFeesMoney()).add(tBill.getPayableFeesPenalty());
+        }
+        TCheckAcceptRecord tCheckAcceptRecord = checkAcceptRecordService.lambdaQuery().eq(TCheckAcceptRecord::getContractId, id).one();
+        res.setCheckResult(tCheckAcceptRecord.getCheckResult());
+        res.setPayMoney(payMoney);
         return R.ok(res);
     }
+    @Log(title = "合同管理-撤销审批", businessType =  BusinessType.UPDATE)
+    @ApiOperation(value = "撤销审批")
+    @GetMapping(value = "/updateContractStatus")
+    public R<Boolean> updateContractStatus(String id) {
+        TContract contract = contractService.getById(id);
+        contract.setStatus("1");
+        return R.ok();
+    }
+    @ApiOperation(value = "终止合同剩余未缴费账单列表")
+    @PostMapping(value = "/contractBillList")
+    public R<PageInfo<BillVO>> contractBillList(@RequestBody TContractBillQuery query) {
+        return R.ok(contractService.contractBillList(query));
+    }
+    @ApiOperation(value = "终止合同")
+    @PostMapping(value = "/terminateContract")
+    public R terminateContract(@RequestBody TerminateContractDTO dto) {
+        contractService.terminateContract(dto);
+        return R.ok();
+    }
+    @ApiOperation(value = "根据合同id查看验收记录")
+    @GetMapping(value = "/getCheckByContractId")
+    public R<CheckAcceptRecordVO> getCheckByContractId(String id) {
+        return R.ok(contractService.getCheckByContractId(id));
+    }
+    @Autowired
+    private WordUtil wordUtil;
+    @ApiOperation(value = "生成合同附件")
+    @PostMapping("/set")
+    public R set(Integer id, HttpServletResponse response){
+        TContract contract = contractService.getById(id);
+        THouse tHouse = houseService.getById(contract.getHouseId());
+        Map<String, Object> templateParam = new HashMap<>(5);
+        templateParam.put("partyOneName", contract.getPartyOneName());
+        templateParam.put("partyTwoName", contract.getPartyTwoName());
+        templateParam.put("houseAddress", tHouse.getHouseAddress());
+        templateParam.put("houseArea", tHouse.getHouseArea()+"m²");
+        templateParam.put("startTime", DateUtils.localDateTimeToStringYear(contract.getStartTime()));
+        templateParam.put("endTime", DateUtils.localDateTimeToStringYear(contract.getEndTime()));
+        templateParam.put("monthRent", "¥¥"+contract.getMonthRent()+"元");
+        templateParam.put("monthRentString", "人民币"+NumberToChineseUtils.numberToChinese(contract.getMonthRent().setScale(2, BigDecimal.ROUND_DOWN).doubleValue()));
+        templateParam.put("totalYear", "¥¥"+contract.getTotalYear()+"元");
+        templateParam.put("totalYearString", "人民币"+NumberToChineseUtils.numberToChinese(contract.getTotalYear().setScale(2, BigDecimal.ROUND_DOWN).doubleValue()));
+        templateParam.put("payType", contract.getPayType().equals("1")?"月":contract.getPayType().equals("2")?"季":"年");
+        templateParam.put("firstRent", "¥"+(contract.getPayType().equals("1")?contract.getMonthRent():contract.getPayType().equals("2")?contract.getMonthRent().multiply(new BigDecimal("3")):contract.getMonthRent().multiply(new BigDecimal("12"))).setScale(2,BigDecimal.ROUND_DOWN)+"元");
+        templateParam.put("firstRentString", "人民币"+NumberToChineseUtils.numberToChinese((contract.getPayType().equals("1")?contract.getMonthRent():contract.getPayType().equals("2")?contract.getMonthRent().multiply(new BigDecimal("3")):contract.getMonthRent().multiply(new BigDecimal("12")).setScale(2,BigDecimal.ROUND_DOWN)).doubleValue()));
+        templateParam.put("nextPayTime", contract.getPayType().equals("1")?"月":contract.getPayType().equals("2")?"季":"年");
+        templateParam.put("deposit", "¥"+contract.getDeposit()+"元");
+        templateParam.put("depositString", NumberToChineseUtils.numberToChinese(contract.getDeposit().setScale(2, BigDecimal.ROUND_DOWN).doubleValue()));
+        templateParam.put("partyOnePerson", contract.getPartyOnePerson());
+        templateParam.put("partyOnePhone", contract.getPartyOnePhone());
+        templateParam.put("partyTwoPerson", contract.getPartyTwoPerson());
+        templateParam.put("partyTwoPhone", contract.getPartyTwoPhone());
+        String url = wordUtil.generatePdf("/templates", "1_yzj_租赁合同.xml", templateParam, "租赁合同", "E:\\");
+        return R.ok(url);
+    }
+    @ApiOperation(value = "导出")
+    @PostMapping("/export")
+    public void export(@RequestBody TContractQuery query){
+        contractService.export(query);
+    }
+    /**
+     * 光缆巡检列表导出
+     */
+    @ApiOperation(value = "光缆巡检列表导出")
+    @Log(title = "现场作业-光缆巡检列表导出", businessType = BusinessType.EXPORT)
+    @PostMapping("/exportOpticalInspection")
+    public void exportOpticalInspection(@RequestBody TContractQuery query)
+    {
+        List<ContractExport> contractExports = new ArrayList<>();
 
+        List<TContract> exportList = contractService.contractExportList(query);
+        for (TContract contract : exportList) {
+            ContractExport contractExport = new ContractExport();
+            contractExport.setContractNumber(contract.getContractNumber());
+            contractExport.setContractName(contract.getContractName());
+            contractExport.setPartyOneName(contract.getPartyOneName());
+            contractExport.setPartyTwoName(contract.getPartyTwoName());
+            contractExport.setCreate_time(contract.getCreateTime());
+            contractExport.setStartTime(contract.getStartTime());
+            contractExport.setEndTime(contract.getEndTime());
+            contractExport.setPayType(DictUtils.getDictLabel(DictConstants.DICT_TYPE_CONTRACT_PAY_TYPE,contract.getPayType()));
+            contractExport.setDeposit(contract.getDeposit()+"");
+            contractExport.setStatus(DictUtils.getDictLabel(DictConstants.DICT_TYPE_CONTRACT_STATUS,contract.getStatus()));
+        }
+        Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(), ContractExport.class, contractExports);
+        HttpServletResponse response = WebUtils.response();
+        response.setContentType("application/vnd.ms-excel");
+        response.setCharacterEncoding("utf-8");
+        ServletOutputStream outputStream = null;
+        try {
+            String fileName = URLEncoder.encode("合同列表.xls", "utf-8");
+            response.setHeader("Content-Disposition", "attachment;filename=" + fileName);
+            response.setContentType("application/vnd.ms-excel;charset=UTF-8");
+            response.setHeader("Pragma", "no-cache");
+            response.setHeader("Cache-Control", "no-cache");
+            outputStream = response.getOutputStream();
+            workbook.write(outputStream);
+        } catch (IOException e) {
+            e.printStackTrace();
+            System.err.println("合同列表信息导出失败");
+        } finally {
+            try {
+                outputStream.close();
+            } catch (IOException e) {
+                e.printStackTrace();
+            }
+        }
+    }
 }
 

--
Gitblit v1.7.1