From d66b806d685672f2f817986e89f69fb09d130f11 Mon Sep 17 00:00:00 2001 From: xuhy <3313886187@qq.com> Date: 星期三, 09 四月 2025 18:02:32 +0800 Subject: [PATCH] Merge branch 'xizang-changyun' of https://gitee.com/xiaochen991015/xizang into dev --- ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TContractController.java | 658 ++++++++++++++++++++++++++++++++++++++++------------------- 1 files changed, 446 insertions(+), 212 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 ba5e047..3bdf4f4 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 @@ -3,36 +3,50 @@ import cn.afterturn.easypoi.excel.ExcelExportUtil; import cn.afterturn.easypoi.excel.entity.ExportParams; +import cn.hutool.core.bean.BeanUtil; +import com.aizuda.bpm.engine.entity.FlwTask; +import com.aizuda.bpm.mybatisplus.mapper.FlwTaskMapper; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; +import com.baomidou.mybatisplus.core.toolkit.Wrappers; +import com.google.common.collect.ImmutableMap; 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.common.enums.DisabledEnum; +import com.ruoyi.common.enums.ProcessCategoryEnum; +import com.ruoyi.common.exception.ServiceException; +import com.ruoyi.common.utils.*; +import com.ruoyi.system.bo.ProcessStartBO; +import com.ruoyi.system.dto.RevokeDTO; import com.ruoyi.system.dto.SetContractDto; import com.ruoyi.system.dto.TContractDTO; -import com.ruoyi.system.dto.THouseDTO; 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.model.TBill; +import com.ruoyi.system.model.TCheckAcceptRecord; +import com.ruoyi.system.model.TContract; +import com.ruoyi.system.model.TContractRentType; +import com.ruoyi.system.model.THouse; +import com.ruoyi.system.model.TTenant; 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.*; +import com.ruoyi.system.service.StateProcessTemplateService; +import com.ruoyi.system.service.TBillService; +import com.ruoyi.system.service.TCheckAcceptRecordService; +import com.ruoyi.system.service.TContractRentTypeService; +import com.ruoyi.system.service.TContractService; +import com.ruoyi.system.service.THouseService; +import com.ruoyi.system.service.TTenantService; +import com.ruoyi.system.task.base.QuartzManager; +import com.ruoyi.system.task.base.TimeJobType; +import com.ruoyi.system.task.jobs.StateProcessJob; import com.ruoyi.system.vo.BillVO; import com.ruoyi.system.vo.CheckAcceptRecordVO; -import com.ruoyi.system.vo.HouseVO; +import com.ruoyi.system.vo.TContractVO; 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; @@ -40,17 +54,30 @@ import org.springframework.beans.factory.annotation.Autowired; import org.springframework.security.access.prepost.PreAuthorize; import org.springframework.validation.annotation.Validated; -import org.springframework.web.bind.annotation.*; +import org.springframework.web.bind.annotation.DeleteMapping; +import org.springframework.web.bind.annotation.GetMapping; +import org.springframework.web.bind.annotation.PostMapping; +import org.springframework.web.bind.annotation.RequestBody; +import org.springframework.web.bind.annotation.RequestMapping; +import org.springframework.web.bind.annotation.RequestParam; +import org.springframework.web.bind.annotation.RestController; import javax.servlet.ServletOutputStream; import javax.servlet.http.HttpServletResponse; import java.io.IOException; +import java.io.UnsupportedEncodingException; import java.math.BigDecimal; +import java.math.RoundingMode; import java.net.URLEncoder; -import java.time.LocalDate; import java.time.LocalDateTime; import java.time.temporal.ChronoUnit; -import java.util.*; +import java.util.ArrayList; +import java.util.Arrays; +import java.util.Date; +import java.util.HashMap; +import java.util.List; +import java.util.Map; +import java.util.Objects; /** * <p> @@ -74,136 +101,86 @@ private TBillService billService; @Autowired private TCheckAcceptRecordService checkAcceptRecordService; - @ApiOperation(value = "测试生成账单") - @PostMapping(value = "/testBill") + @Autowired + private StateProcessTemplateService stateProcessTemplateService; + @Autowired + private FlwTaskMapper flwTaskMapper; + @Autowired + private TTenantService tenantService; - public R testBill(String id) { - TContract contract = contractService.getById(id); - // 查询所有已签订的合同并且未生成第一笔账单的 - - List<TBill> bills = new ArrayList<>(); - List<TContractRentType> contractRentTypes = contractRentTypeService.list(); - contract.setFirstPayTime(contract.getStartTime().plusDays(10)); - // 第一次应缴费日期 - LocalDateTime firstPayTime = contract.getStartTime().plusDays(10).withHour(0).withMinute(0).withSecond(0); - LocalDate localDate = contract.getStartTime().plusDays(10).toLocalDate(); - LocalDate now = LocalDate.now(); - TBill rentBill = new TBill(); - rentBill.setContractId(contract.getId()); - rentBill.setContractNumber(contract.getContractNumber()); - LocalDateTime startPayTime = contract.getStartPayTime(); - LocalDateTime endTime1 = contract.getEndTime(); -// // 计算两个时间相差多少天 -// // 如果时间小于30天 需要计算每日租金 -// if (days<30){ -// rentBill.setPayableFeesMoney(contract.getMonthRent().divide(new BigDecimal("30"),2,BigDecimal.ROUND_DOWN).multiply(new BigDecimal(days))); -// }else{ -// rentBill.setPayableFeesMoney(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)); -// } - rentBill.setPayableFeesTime(firstPayTime); - rentBill.setPayFeesStatus("1"); - rentBill.setBillType("1"); - rentBill.setStartTime(contract.getStartPayTime()); - TContractRentType tContractRentType = contractRentTypes.stream().filter(e -> e.getContractId().equals(contract.getId())).findFirst().orElse(null); - - if (tContractRentType!=null && contract.getStartPayTime().plusMonths(contract.getPayType().equals("1")? 1:contract.getPayType().equals("2")? 3:12).isAfter(tContractRentType.getChangeTime())){ - // 计算租金变动的天数 - long moneyDays = ChronoUnit.DAYS.between(tContractRentType.getChangeTime(), contract.getStartPayTime().plusMonths(contract.getPayType().equals("1")? 1:contract.getPayType().equals("2")? 3:12))+1L; - contract.setChangeTime(LocalDateTime.now()); - // 递增递减的租金 - BigDecimal contractRentTypeMoney = new BigDecimal("0"); - // 不递增递减的租金 - BigDecimal originalMoney = new BigDecimal("0"); - // 原租金 - switch (tContractRentType.getIncreasingDecreasingType()){ - case 1: - switch (tContractRentType.getIncreasingDecreasing()){ - case 1: - contractRentTypeMoney =contractRentTypeMoney.add(contract.getChangeRent().multiply(new BigDecimal(100).add(tContractRentType.getNumericalValue())).divide(new BigDecimal(100),2,BigDecimal.ROUND_DOWN).divide(new BigDecimal(30), 2, BigDecimal.ROUND_DOWN).multiply(new BigDecimal(moneyDays))); - contract.setChangeRent(contractRentTypeMoney.add(contract.getChangeRent().multiply(new BigDecimal(100).add(tContractRentType.getNumericalValue())).divide(new BigDecimal(100),2,BigDecimal.ROUND_DOWN))); - break; - case 2: - contractRentTypeMoney = contractRentTypeMoney.add(contract.getChangeRent().multiply(new BigDecimal(100).subtract(tContractRentType.getNumericalValue())).divide(new BigDecimal(100),2,BigDecimal.ROUND_DOWN).divide(new BigDecimal(30), 2, BigDecimal.ROUND_DOWN).multiply(new BigDecimal(moneyDays))); - contract.setChangeRent(contractRentTypeMoney.add(contract.getChangeRent().multiply(new BigDecimal(100).subtract(tContractRentType.getNumericalValue())).divide(new BigDecimal(100),2,BigDecimal.ROUND_DOWN))); - break; - } - break; - case 2: - switch (tContractRentType.getIncreasingDecreasing()){ - case 1: - contractRentTypeMoney =contractRentTypeMoney.add(contract.getChangeRent().add(tContractRentType.getNumericalValue())).divide(new BigDecimal(30), 2, BigDecimal.ROUND_DOWN).multiply(new BigDecimal(moneyDays)); - contract.setChangeRent(contractRentTypeMoney.add(contract.getChangeRent().add(tContractRentType.getNumericalValue()))); - break; - case 2: - contractRentTypeMoney = contractRentTypeMoney.add(contract.getChangeRent().subtract(tContractRentType.getNumericalValue())).divide(new BigDecimal(30), 2, BigDecimal.ROUND_DOWN).multiply(new BigDecimal(moneyDays)); - contract.setChangeRent(contractRentTypeMoney.add(contract.getChangeRent().subtract(tContractRentType.getNumericalValue()))); - - break; - } - break; - } - // 不需要涨租金的时间段 - long originalDays = ChronoUnit.DAYS.between(contract.getFirstPayTime(), tContractRentType.getChangeTime()); - originalMoney=originalMoney.add(contract.getMonthRent().divide(new BigDecimal(30), 2, BigDecimal.ROUND_DOWN)) - .multiply(new BigDecimal(originalDays)); - rentBill.setPayableFeesMoney(contractRentTypeMoney.add(originalMoney)); - rentBill.setOutstandingMoney(rentBill.getPayableFeesMoney()); - if (contract.getFirstPayTime().plusMonths(contract.getPayType().equals("1")? 1:contract.getPayType().equals("2")? 3:12).isAfter(contract.getEndTime())){ - rentBill.setEndTime(contract.getFirstPayTime().plusMonths(contract.getPayType().equals("1")? 1:contract.getPayType().equals("2")? 3:12)); - }else{ - rentBill.setEndTime(contract.getEndTime()); - } - }else{ - if (contract.getFirstPayTime().plusMonths(contract.getPayType().equals("1")? 1:contract.getPayType().equals("2")? 3:12).isAfter(contract.getEndTime())){ - rentBill.setEndTime(contract.getFirstPayTime().plusMonths(contract.getPayType().equals("1")? 1:contract.getPayType().equals("2")? 3:12)); - }else{ - rentBill.setEndTime(contract.getEndTime()); - } - // 不走递增递减 - long allDays = ChronoUnit.DAYS.between(contract.getFirstPayTime(), rentBill.getEndTime()); - rentBill.setPayableFeesMoney(contract.getMonthRent().divide(new BigDecimal(30), 2, BigDecimal.ROUND_DOWN).multiply(new BigDecimal(allDays))); - rentBill.setOutstandingMoney(rentBill.getPayableFeesMoney()); - - } - // 租金账单 - bills.add(rentBill); - // 押金账单 - TBill depositBill = new TBill(); - depositBill.setContractId(contract.getId()); - depositBill.setContractNumber(contract.getContractNumber()); - depositBill.setPayableFeesMoney(contract.getDeposit()); - depositBill.setOutstandingMoney(depositBill.getPayableFeesMoney()); - - depositBill.setPayableFeesTime(firstPayTime); - depositBill.setPayFeesStatus("1"); - depositBill.setBillType("2"); - contractService.updateById(contract); - billService.save(rentBill); - billService.save(depositBill); - return R.ok(); - } @ApiOperation(value = "获取合同分页列表") @PostMapping(value = "/contractList") - @PreAuthorize("@ss.hasPermi('system:contract:list')") - + @PreAuthorize("@ss.hasPermi('contract:list')") public R<PageInfo<TContract>> contractList(@RequestBody TContractQuery query) { return R.ok(contractService.contractList(query)); } @Log(title = "合同管理-新增合同", businessType = BusinessType.INSERT) @ApiOperation(value = "新增合同") @PostMapping(value = "/addContract") - @PreAuthorize("@ss.hasPermi('system:contract:add')") + @PreAuthorize("@ss.hasPermi('contract:list:add')") public R<Boolean> addContract(@Validated @RequestBody TContractDTO dto) { + LocalDateTime changeTime = dto.getChangeTime(); + long count = contractService.count(new LambdaQueryWrapper<TContract>() + .eq(TContract::getContractNumber, dto.getContractNumber())); + if (count!=0){ + return R.fail("合同编号不可重复"); + } dto.setChangeRent(dto.getMonthRent()); + dto.setChangeTime(null); + //查询房产信息,获取所属营业部 + THouse house = houseService.getById(dto.getHouseId()); + if (Objects.isNull(house)) { + throw new ServiceException("房产信息不存在"); + } + house.setRentalReturnStatus("1"); + houseService.updateById(house); + dto.setBusinessDeptId(house.getBusinessDeptId()); + // 生成合同编号 + dto.setContractNumber(CodeGenerateUtils.generateVolumeSn(house.getBusinessDeptId())); contractService.save(dto); + if (dto.getStatus().equals("2")){ + //发起合同新增审批 + ProcessStartBO processStartBO = new ProcessStartBO(); + processStartBO.setCategory(ProcessCategoryEnum.CATEGORY1.getValue().toString()); + processStartBO.setModuleName("合同新增审批"); + processStartBO.setName(dto.getContractName()); + //需要显示发起申请人所在单位 +// String cedName = SecurityUtils.getLoginUser().getUser().getDept().getDeptName(); +// String remark = String.format("【镇/街】:%s,【征收实施单位】:%s,【申请金额】:%s万元", stateProject.getStreet(), cedName, stateApplyRecord.getAmount()); + processStartBO.setRemark(""); + Map<String, Object> variable = new HashMap<>(); + variable.put("projectId", dto.getId()); + processStartBO.setVariable(variable); + //开启工作流程 + Boolean start = stateProcessTemplateService.start(processStartBO); + if(start){ + FlwTask flwTask = flwTaskMapper.selectOne(Wrappers.lambdaQuery(FlwTask.class) + .like(FlwTask::getVariable, dto.getId()) + .orderByDesc(FlwTask::getCreateTime) + .last("LIMIT 1")); + if(Objects.nonNull(flwTask)){ + // 添加定时任务 + Map<String, ? extends Object> maps = + new ImmutableMap.Builder<String, Long>(). + put("id", flwTask.getId()) + .build(); + QuartzManager.addJob( + StateProcessJob.class, + (StateProcessJob.name+flwTask.getId()).toUpperCase(), + TimeJobType.AUTO_AUDIT, + new Date(new Date().getTime()+48*60*60*1000L), + maps + ); + } + } + } if (dto.getIsIncreasing()){ TContractRentType tContractRentType = new TContractRentType(); tContractRentType.setContractId(dto.getId()); tContractRentType.setIncreasingDecreasing(dto.getIncreasingDecreasing()); tContractRentType.setIncreasingDecreasingType(dto.getIncreasingDecreasingType()); tContractRentType.setNumericalValue(dto.getNumericalValue()); - tContractRentType.setChangeTime(dto.getChangeTime()); + tContractRentType.setChangeTime(changeTime); tContractRentType.setCycleTime(dto.getCycleTime()); contractRentTypeService.save(tContractRentType); } @@ -212,9 +189,15 @@ @Log(title = "合同管理-编辑合同", businessType = BusinessType.UPDATE) @ApiOperation(value = "编辑合同") @PostMapping(value = "/updateContract") - @PreAuthorize("@ss.hasPermi('system:contract:update')") - + @PreAuthorize("@ss.hasPermi('contract:list:edit')") public R<Boolean> updateContract(@Validated @RequestBody TContractDTO dto) { + dto.setChangeTime(null); + //查询房产信息,获取所属营业部 + THouse house = houseService.getById(dto.getHouseId()); + if (Objects.isNull(house)) { + throw new ServiceException("房产信息不存在"); + } + dto.setBusinessDeptId(house.getBusinessDeptId()); contractService.updateById(dto); contractRentTypeService.remove(new LambdaQueryWrapper<TContractRentType>() .eq(TContractRentType::getContractId,dto.getId())); @@ -228,15 +211,49 @@ tContractRentType.setCycleTime(dto.getCycleTime()); contractRentTypeService.save(tContractRentType); } + if (dto.getStatus().equals("2")){ + //发起合同新增审批 + ProcessStartBO processStartBO = new ProcessStartBO(); + processStartBO.setCategory(ProcessCategoryEnum.CATEGORY1.getValue().toString()); + processStartBO.setModuleName("合同新增审批"); + processStartBO.setName(dto.getContractName()); + //需要显示发起申请人所在单位 +// String cedName = SecurityUtils.getLoginUser().getUser().getDept().getDeptName(); +// String remark = String.format("【镇/街】:%s,【征收实施单位】:%s,【申请金额】:%s万元", stateProject.getStreet(), cedName, stateApplyRecord.getAmount()); + processStartBO.setRemark(""); + Map<String, Object> variable = new HashMap<>(); + variable.put("projectId", dto.getId()); + processStartBO.setVariable(variable); + //开启工作流程 + Boolean start = stateProcessTemplateService.start(processStartBO); + if(start){ + FlwTask flwTask = flwTaskMapper.selectOne(Wrappers.lambdaQuery(FlwTask.class) + .like(FlwTask::getVariable, dto.getId()) + .orderByDesc(FlwTask::getCreateTime) + .last("LIMIT 1")); + if(Objects.nonNull(flwTask)){ + // 添加定时任务 + Map<String, ? extends Object> maps = + new ImmutableMap.Builder<String, Long>(). + put("id", flwTask.getId()) + .build(); + QuartzManager.addJob( + StateProcessJob.class, + (StateProcessJob.name + flwTask.getId()).toUpperCase(), + TimeJobType.AUTO_AUDIT, + new Date(new Date().getTime() + 48 * 60 * 60 * 1000L), + maps + ); + } + } + } return R.ok(); } @Log(title = "合同管理-批量删除合同", businessType = BusinessType.DELETE) @ApiOperation(value = "批量删除合同") - @PreAuthorize("@ss.hasPermi('system:contract:delete')") - + @PreAuthorize("@ss.hasPermi('contract:list:delete')") @DeleteMapping(value = "/deleteContractByIds") - public R<Boolean> deleteContractByIds - (@RequestParam String ids) { + public R<Boolean> deleteContractByIds(@RequestParam String ids) { if (StringUtils.isNotEmpty(ids)){ contractService.removeBatchByIds(Arrays.asList(ids.split(","))); } @@ -245,81 +262,96 @@ @ApiOperation(value = "查询合同信息信息") @GetMapping(value = "/getContractById") - @PreAuthorize("@ss.hasPermi('system:contract:detail')") - + @PreAuthorize("@ss.hasPermi('contract:list:detail')") public R<TContractVO> getContractById(@RequestParam String id) { 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(); + TContractRentType contractRentType = contractRentTypeService.lambdaQuery() + .eq(TContractRentType::getContractId, id) + .one(); if (contractRentType!=null){ BeanUtils.copyProperties(contractRentType,res); } - TContract oldContract = contractService.getOne(new LambdaQueryWrapper<TContract>() - .eq(TContract::getHouseId,contract.getHouseId()) - .eq(TContract::getStatus, 4) - .le(TContract::getStartTime, LocalDateTime.now()) - .ge(TContract::getEndTime, LocalDateTime.now())); +// TContract oldContract = contractService.getOne(new LambdaQueryWrapper<TContract>() +// .eq(TContract::getHouseId,contract.getHouseId()) +// .eq(TContract::getStatus, 4) +// .le(TContract::getStartTime, LocalDateTime.now()) +// .ge(TContract::getEndTime, LocalDateTime.now())); THouse house = houseService.getById(contract.getHouseId()); - if (oldContract!=null){ - house.setTenantType(oldContract.getPayType()); - } + house.setTenantType(contract.getPayType()); res.setHouse(house); List<TBill> list = billService.lambdaQuery() .eq(TBill::getContractId, id) - .in(TBill::getPayFeesStatus, Arrays.asList("1,4")) + .ne(TBill::getPayFeesStatus, 3) .list(); BigDecimal payMoney = new BigDecimal("0"); for (TBill tBill : list) { - payMoney = payMoney.add(tBill.getPayFeesMoney()).add(tBill.getPayableFeesPenalty()); + payMoney = payMoney.add(tBill.getOutstandingMoney()).add(tBill.getPayableFeesPenalty()); } - TCheckAcceptRecord tCheckAcceptRecord = checkAcceptRecordService.lambdaQuery().eq(TCheckAcceptRecord::getContractId, id).one(); - res.setCheckResult(Objects.nonNull(tCheckAcceptRecord)?tCheckAcceptRecord.getCheckResult():false); + TCheckAcceptRecord tCheckAcceptRecord = checkAcceptRecordService.lambdaQuery() + .eq(TCheckAcceptRecord::getContractId, id) + .one(); + res.setCheckResult( + Objects.nonNull(tCheckAcceptRecord) + &&Objects.nonNull(tCheckAcceptRecord.getCheckResult()) + ?tCheckAcceptRecord.getCheckResult() + :null + ); res.setPayMoney(payMoney); return R.ok(res); } @Log(title = "合同管理-撤销审批", businessType = BusinessType.UPDATE) @ApiOperation(value = "撤销审批") - @PreAuthorize("@ss.hasPermi('system:contract:revoke')") - - @GetMapping(value = "/updateContractStatus") - public R<Boolean> updateContractStatus(String id) { - TContract contract = contractService.getById(id); + @PreAuthorize("@ss.hasPermi('contract:list:cancel')") + @PostMapping(value = "/updateContractStatus") + public R<Boolean> updateContractStatus(@RequestBody RevokeDTO dto) { + TContract contract = contractService.getById(dto.getContractId()); contract.setStatus("1"); contractService.updateById(contract); + // 撤销审批实例 + stateProcessTemplateService.revoke(dto.getInstanceId()); + return R.ok(); } - @PreAuthorize("@ss.hasPermi('system:contract:confirm')") - + @PreAuthorize("@ss.hasPermi('contract:list:settlement')") @Log(title = "合同管理-确认结算", businessType = BusinessType.UPDATE) @ApiOperation(value = "确认结算") @PostMapping(value = "/confirmSettlement") - public R<Boolean> confirmSettlement(String id) { TContract contract = contractService.getById(id); contract.setStatus("8"); contractService.updateById(contract); + // 将所有未缴费账单设置未已失效 + List<TBill> tBills = billService.list(new LambdaQueryWrapper<TBill>() + .ne(TBill::getPayFeesStatus, 3) + .ne(TBill::getBillType,4) + .eq(TBill::getContractId, contract.getId())); + for (TBill tBill : tBills) { + tBill.setPayFeesStatus("5"); + } + billService.updateBatchById(tBills); + // 将房屋改成待出租 + THouse house = houseService.getById(contract.getHouseId()); + house.setLeaseStatus("1"); + houseService.updateById(house); return R.ok(); } @ApiOperation(value = "终止合同剩余未缴费账单列表") @PostMapping(value = "/contractBillList") - @PreAuthorize("@ss.hasPermi('system:contract:billList')") public R<PageInfo<BillVO>> contractBillList(@RequestBody TContractBillQuery query) { return R.ok(contractService.contractBillList(query)); } @ApiOperation(value = "终止合同") @PostMapping(value = "/terminateContract") - @PreAuthorize("@ss.hasPermi('system:contract:terminate')") + @PreAuthorize("@ss.hasPermi('contract:list:break')") public R terminateContract(@RequestBody TerminateContractDTO dto) { contractService.terminateContract(dto); return R.ok(); } @ApiOperation(value = "根据合同id查看验收记录") @GetMapping(value = "/getCheckByContractId") - @PreAuthorize("@ss.hasPermi('system:contract:checkDetail')") public R<CheckAcceptRecordVO> getCheckByContractId(String id) { return R.ok(contractService.getCheckByContractId(id)); } @@ -328,87 +360,289 @@ @ApiOperation(value = "生成合同附件") @PostMapping("/set") @Log(title = "生成合同附件", businessType = BusinessType.EXPORT) - @PreAuthorize("@ss.hasPermi('system:contract:set')") + @PreAuthorize("@ss.hasPermi('contract:list:generate')") public R<List<String>> set(@RequestBody SetContractDto dto,HttpServletResponse response){ List<TContract> list = contractService.lambdaQuery().in(TContract::getId, dto.getIds()).list(); List<String> res = new ArrayList<>(); for (TContract contract : list) { - 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:\\"); + String url = generateContract(contract); res.add(url); } return R.ok(res); } + // 计算两个日期相差天数的方法实现: + public static long calculateDaysBetween(LocalDateTime start, LocalDateTime end) { + return ChronoUnit.DAYS.between(start, end); + } + + public static void main(String[] args) { + LocalDateTime start = LocalDateTime.of(2024, 1, 1, 0, 0); + LocalDateTime end = LocalDateTime.of(2024, 1, 5, 12, 0); + long days = calculateDaysBetween(start, end); // 返回4天(不满一天不计) + + } + + private String generateContract(TContract contract) { + String templateFileName = "1_yzj_租赁合同_个人.docx"; + String contractId = contract.getId(); + TBill firstBill = null; + TCheckAcceptRecord tCheckAcceptRecord = null; + + if (StringUtils.isNotEmpty(contractId)) { + firstBill = billService.lambdaQuery() + .eq(TBill::getContractId, contractId) + .eq(TBill::getBillType, 1) + .orderByAsc(TBill::getStartTime) + .ne(TBill::getManualAddition, DisabledEnum.YES.getCode()) + .last("limit 1") + .one(); + tCheckAcceptRecord = checkAcceptRecordService.lambdaQuery() + .eq(TCheckAcceptRecord::getContractId, contractId) + .last("limit 1") + .one(); + } + + TTenant tenant = null; + THouse tHouse = null; + if (StringUtils.isNotEmpty(contract.getTenantId())) { + tenant = tenantService.getById(contract.getTenantId()); + tHouse = houseService.getById(contract.getHouseId()); + } + + Map<String, Object> templateParam = new HashMap<>(5); + fill(templateParam, "contractNumber", contract.getContractNumber()); + fill(templateParam, "partyOneName", contract.getPartyOneName()); + + + if (Objects.nonNull(tenant)) { + fill(templateParam, "mailAddress", tenant.getMailAddress()); + fill(templateParam, "idCard", tenant.getIdCard()); + fill(templateParam, "residentName", tenant.getResidentName()); + fill(templateParam, "bankNumber", tenant.getBankNumber()); + fill(templateParam, "bankName", tenant.getBankName()); + fill(templateParam, "partyTwoName", tenant.getLessee()); + fill(templateParam, "email", tenant.getEmail()); + + // 企业、政府机构、国有企业 + if (Objects.nonNull(tenant.getTenantType()) + && (tenant.getTenantType().equals("2") + || tenant.getTenantType().equals("5") + || tenant.getTenantType().equals("7"))) { + fill(templateParam, "creditCode", tenant.getCreditCode()); + fill(templateParam, "legalPerson", tenant.getLegalPerson()); + templateFileName = "1_yzj_租赁合同_企业.docx"; + } + } + + + + if (Objects.nonNull(tHouse)) { + fill(templateParam, "houseAddress", tHouse.getHouseAddress()); + fill(templateParam, "houseArea", tHouse.getHouseArea() + "m²"); + } + + // 日期相关参数处理 + fill(templateParam, "remark", contract.getRemark()); + fill(templateParam, "houseUseScope", contract.getHouseUseScope()); + fill(templateParam, "days", ChronoUnit.DAYS.between( + contract.getStartTime(), contract.getEndTime())); + + long between = ChronoUnit.DAYS.between( + contract.getStartTime(), contract.getStartPayTime()) + 1; + fill(templateParam, "day", between); + + // 财务相关参数处理 + fill(templateParam, "endTimeFree", DateUtils.localDateTimeToStringYear( + contract.getStartPayTime().plusDays(1))); + fill(templateParam, "startPayTime", DateUtils.localDateTimeToStringYear( + contract.getStartPayTime())); + fill(templateParam, "startTime", DateUtils.localDateTimeToStringYear( + contract.getStartTime())); + fill(templateParam, "endTime", DateUtils.localDateTimeToStringYear( + contract.getEndTime())); + + // 金额格式化处理 + fill(templateParam, "monthRent", "¥" + contract.getMonthRent() + "元"); + fill(templateParam, "monthRentString", "人民币" + NumberToChineseUtils.numberToChinese( + contract.getMonthRent().setScale(2, RoundingMode.DOWN).doubleValue())); + + String totalYear = Objects.nonNull(contract.getTotalYear()) + ? contract.getTotalYear().toString() + : ""; + fill(templateParam, "totalYear", "¥" + totalYear + "元"); + + String totalYearString = StringUtils.isNotEmpty(totalYear) + ? NumberToChineseUtils.numberToChinese( + contract.getTotalYear().setScale(2, RoundingMode.DOWN).doubleValue()) + : ""; + fill(templateParam, "totalYearString", "人民币" + totalYearString); + + // 支付类型处理 + String payType = contract.getPayType().equals("1") ? "月" + : contract.getPayType().equals("2") ? "季" + : "年"; + fill(templateParam, "payType", payType); + + // 首期租金处理 + if (firstBill != null) { + double 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, RoundingMode.DOWN).doubleValue(); + fill(templateParam, "firstRent", "¥" + firstBill.getPayableFeesMoney() + "元"); + // 其他财务字段 + fill(templateParam, "firstRentString", "人民币" + NumberToChineseUtils.numberToChinese(firstBill.getPayableFeesMoney().doubleValue())); + } else { +// fill(templateParam, "firstRent", ""); + } + + fill(templateParam, "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, RoundingMode.DOWN)).doubleValue()+"元"); + + + fill(templateParam, "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, RoundingMode.DOWN)).doubleValue())); + + + + + fill(templateParam, "nextPayTime", payType); + fill(templateParam, "deposit", "¥" + contract.getDeposit() + "元"); + fill(templateParam, "depositString", NumberToChineseUtils.numberToChinese( + contract.getDeposit().setScale(2, RoundingMode.DOWN).doubleValue())); + + // 联系方式 + fill(templateParam, "partyOnePerson", contract.getPartyOnePerson()); + fill(templateParam, "partyOnePhone", contract.getPartyOnePhone()); + fill(templateParam, "partyTwoPerson", contract.getPartyTwoPerson()); + fill(templateParam, "partyTwoPhone", contract.getPartyTwoPhone()); + + // 验收时间处理 + if (tCheckAcceptRecord != null && tCheckAcceptRecord.getCheckTime() != null) { + fill(templateParam, "checkTime", DateUtils.localDateTimeToStringYear( + tCheckAcceptRecord.getCheckTime())); + } else { + fill(templateParam, "checkTime", ""); + } + + return wordUtil.generatePdf( + "/usr/local/project/file/", + templateFileName, + templateParam, + "租赁合同", + "/usr/local/project/file/"); + } + + + private void fill(Map<String, Object> templateParam, String key, Object value) { + if (StringUtils.isEmpty(key)){ + throw new RuntimeException("key不能为空"); + } + templateParam.put("${"+key+"}", value != null ? value : ""); + } + + /** + * 生成预览版合同附件 + */ + @ApiOperation(value = "生成预览版合同附件") + @PostMapping("/generateContractPreview") + public R<String> generateContractPreview(@RequestBody TContractDTO dto) + { + TContract contract = new TContract(); + BeanUtil.copyProperties(dto,contract); + return R.ok(generateContract(contract)); + } + /** * 导出 */ @ApiOperation(value = "导出") - @PreAuthorize("@ss.hasPermi('system:contract:export')") + @PreAuthorize("@ss.hasPermi('contract:list:export')") @Log(title = "导出", businessType = BusinessType.EXPORT) @PostMapping("/export") - public void exportOpticalInspection(@RequestBody TContractQuery query) - { + public void exportOpticalInspection(@RequestBody TContractQuery query) throws UnsupportedEncodingException { 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())); + contractExport.setCreateTime(DateUtils.localDateTimeToStringYear(contract.getCreateTime())); + contractExport.setStartTime(DateUtils.localDateTimeToStringYear(contract.getStartTime())); + contractExport.setEndTime(DateUtils.localDateTimeToStringYear(contract.getEndTime())); + contractExport.setDeposit(contract.getDeposit() + ""); + contractExports.add(contractExport); + contractExport.setPayType( + DictUtils.getDictLabel( + DictConstants.DICT_TYPE_CONTRACT_PAY_TYPE, contract.getPayType()) + ); + 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(); + response.setHeader("Content-Disposition", + "attachment;filename=" + URLEncoder.encode("合同列表.xls", "utf-8")); + response.setHeader("Pragma", "no-cache"); + response.setHeader("Cache-Control", "no-cache"); + + try (Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(), ContractExport.class, contractExports); + ServletOutputStream outputStream = response.getOutputStream()) { workbook.write(outputStream); } catch (IOException e) { e.printStackTrace(); - System.err.println("合同列表信息导出失败"); - } finally { - try { - outputStream.close(); - } catch (IOException e) { - e.printStackTrace(); - } } } + @ApiOperation("上传合同附件") + @PostMapping(value = "/upload-file") + public R<Boolean> uploadFile(@RequestBody TContractDTO dto ) { + if (Objects.isNull(dto.getId())) { + throw new ServiceException("合同id不能为空"); + } + TContract contract = contractService.getById(dto.getId()); + if (Objects.isNull(contract)) { + throw new ServiceException("合同不存在"); + } + /* if (StringUtils.isNotBlank(contract.getContractFile())) { + List<String> contractFileList = Arrays.stream(contract.getContractFile().split(",")).collect(Collectors.toList()); + List<String> memoryList = Arrays.stream(contract.getMemory().split(",")).collect(Collectors.toList()); + List<String> contractNameList = Arrays.stream(contract.getContractFileName().split(",")).collect(Collectors.toList()); + contractFileList.addAll(Arrays.asList(dto.getContractFile().split(","))); + contractNameList.addAll(Arrays.asList(dto.getContractFileName().split(","))); + memoryList.addAll(Arrays.asList(dto.getMemory().split(","))); + contract.setContractFile(String.join(",", contractFileList)); + contract.setContractFileName(String.join(",", contractNameList)); + contract.setMemory(String.join(",", memoryList)); + } else { + contract.setContractFile(dto.getContractFile()); + contract.setContractFileName(dto.getContractFileName()); + contract.setMemory(dto.getMemory()); + }*/ + contract.setContractFile(dto.getContractFile()); + contract.setContractFileName(dto.getContractFileName()); + contract.setMemory(dto.getMemory()); + return R.ok(contractService.updateById(contract)); + } + } -- Gitblit v1.7.1