package com.ruoyi.system.service.impl;
|
|
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
|
import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;
|
import com.ruoyi.common.basic.PageInfo;
|
import com.ruoyi.common.constant.DictConstants;
|
import com.ruoyi.common.core.domain.R;
|
import com.ruoyi.common.utils.DictUtils;
|
import com.ruoyi.common.utils.bean.BeanUtils;
|
import com.ruoyi.system.dto.SignContractDTO;
|
import com.ruoyi.system.dto.TerminateContractDTO;
|
import com.ruoyi.system.mapper.TBillMapper;
|
import com.ruoyi.system.mapper.TCheckAcceptRecordMapper;
|
import com.ruoyi.system.mapper.TContractMapper;
|
import com.ruoyi.system.mapper.THouseMapper;
|
import com.ruoyi.system.model.*;
|
import com.ruoyi.system.query.TContractAppletQuery;
|
import com.ruoyi.system.query.TContractBillQuery;
|
import com.ruoyi.system.query.TContractQuery;
|
import com.ruoyi.system.service.TBillService;
|
import com.ruoyi.system.service.TContractRentTypeService;
|
import com.ruoyi.system.service.TContractService;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.ruoyi.system.vo.BillVO;
|
import com.ruoyi.system.vo.CheckAcceptRecordVO;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import javax.annotation.Resource;
|
import java.math.BigDecimal;
|
import java.time.LocalDate;
|
import java.time.LocalDateTime;
|
import java.time.temporal.ChronoUnit;
|
import java.time.temporal.TemporalAdjusters;
|
import java.util.ArrayList;
|
import java.util.Arrays;
|
import java.util.List;
|
|
/**
|
* <p>
|
* 合同管理 服务实现类
|
* </p>
|
*
|
* @author xiaochen
|
* @since 2025-01-17
|
*/
|
@Service
|
public class TContractServiceImpl extends ServiceImpl<TContractMapper, TContract> implements TContractService {
|
@Resource
|
private TCheckAcceptRecordMapper checkAcceptRecordMapper;
|
@Resource
|
private THouseMapper houseMapper;
|
@Resource
|
private TBillMapper billMapper;
|
@Resource
|
private TBillService billService;
|
@Resource
|
private TContractMapper contractMapper;
|
|
@Override
|
public PageInfo<TContract> contractList(TContractQuery query) {
|
PageInfo<TContract> pageInfo = new PageInfo<>(query.getPageNum(), query.getPageSize());
|
List<TContract> list = this.baseMapper.contractList(query,pageInfo);
|
for (TContract tContract : list) {
|
tContract.setPayType(DictUtils.getDictLabel(DictConstants.DICT_TYPE_CONTRACT_PAY_TYPE,tContract.getPayType()));
|
tContract.setStatus(DictUtils.getDictLabel(DictConstants.DICT_TYPE_CONTRACT_STATUS,tContract.getStatus()));
|
}
|
pageInfo.setRecords(list);
|
return pageInfo;
|
|
}
|
|
@Override
|
public PageInfo<TContract> contractAppletList(TContractAppletQuery query) {
|
PageInfo<TContract> pageInfo = new PageInfo<>(query.getPageNum(), query.getPageSize());
|
List<TContract> list = this.baseMapper.contractAppletList(query,pageInfo);
|
for (TContract tContract : list) {
|
tContract.setPayType(DictUtils.getDictLabel(DictConstants.DICT_TYPE_CONTRACT_PAY_TYPE,tContract.getPayType()));
|
tContract.setStatus(DictUtils.getDictLabel(DictConstants.DICT_TYPE_CONTRACT_STATUS,tContract.getStatus()));
|
}
|
pageInfo.setRecords(list);
|
return pageInfo;
|
}
|
|
@Override
|
public PageInfo<BillVO> contractBillList(TContractBillQuery query) {
|
PageInfo<BillVO> pageInfo = new PageInfo<>(query.getPageNum(), query.getPageSize());
|
List<BillVO> list = this.baseMapper.contractBillList(query,pageInfo);
|
for (BillVO billVO : list) {
|
if (billVO.getPayFeesStatus().equals("4")){
|
billVO.setPayFeesMoneyString((billVO.getPayFeesMoney().add(billVO.getPayableFeesPenalty()))+"【"+billVO.getPayFeesMoney()+"+"+billVO.getPayableFeesPenalty()+"】");
|
}
|
billVO.setPayFeesStatus(DictUtils.getDictLabel(DictConstants.DICT_TYPE_PAY_FEES_STATUS,billVO.getPayFeesStatus()));
|
}
|
pageInfo.setRecords(list);
|
return pageInfo;
|
}
|
@Override
|
public void terminateContract(TerminateContractDTO dto) {
|
TContract contract = this.baseMapper.selectById(dto.getId());
|
contract.setTerminateRemark(dto.getTerminateRemark());
|
contract.setStatus("4");
|
this.baseMapper.updateById(contract);
|
// 生成验收记录
|
TCheckAcceptRecord tCheckAcceptRecord = new TCheckAcceptRecord();
|
tCheckAcceptRecord.setContractId(dto.getId());
|
tCheckAcceptRecord.setHouseId(contract.getHouseId());
|
tCheckAcceptRecord.setLeaseReason("后台终止合同");
|
tCheckAcceptRecord.setStatus(false);
|
tCheckAcceptRecord.setAcceptanceTime(LocalDateTime.now());
|
LocalDate now = LocalDate.now();
|
String replace = (now + "").replace("-", "");
|
int size = checkAcceptRecordMapper.selectList(new LambdaQueryWrapper<TCheckAcceptRecord>()
|
.likeRight(TCheckAcceptRecord::getAcceptanceTime, LocalDate.now())).size();
|
tCheckAcceptRecord.setCode(replace.substring(2)+String.format("%03d", size+1));
|
|
|
checkAcceptRecordMapper.insert(tCheckAcceptRecord);
|
// 将所有未缴费账单设置未已失效
|
List<TBill> tBills = billMapper.selectList(new LambdaQueryWrapper<TBill>()
|
.in(TBill::getPayFeesStatus, Arrays.asList("1,4"))
|
.eq(TBill::getContractId, dto.getId()));
|
for (TBill tBill : tBills) {
|
tBill.setPayFeesStatus("5");
|
}
|
billService.updateBatchById(tBills);
|
}
|
|
public static void main(String[] args) {
|
// LocalDate now = LocalDate.now();
|
// String replace = (now + "").replace("-", "");
|
// System.err.println(replace.substring(2));
|
//
|
// System.err.println(String.format("%03d",1));
|
}
|
@Override
|
public CheckAcceptRecordVO getCheckByContractId(String id) {
|
CheckAcceptRecordVO checkAcceptRecordVO = new CheckAcceptRecordVO();
|
TCheckAcceptRecord tCheckAcceptRecord = checkAcceptRecordMapper.selectOne(new LambdaQueryWrapper<TCheckAcceptRecord>()
|
.eq(TCheckAcceptRecord::getContractId, id));
|
if (tCheckAcceptRecord==null)return checkAcceptRecordVO;
|
BeanUtils.copyProperties(tCheckAcceptRecord,checkAcceptRecordVO);
|
THouse tHouse = houseMapper.selectById(tCheckAcceptRecord.getHouseId());
|
tHouse.setLeaseStatus(DictUtils.getDictLabel(DictConstants.DICT_TYPE_LEASE_STATUS,tHouse.getLeaseStatus()));
|
tHouse.setBusinessAttributes(DictUtils.getDictLabel(DictConstants.DICT_TYPE_BUSINESS_ATTRIBUTES,tHouse.getBusinessAttributes()));
|
checkAcceptRecordVO.setHouse(tHouse);
|
return checkAcceptRecordVO;
|
}
|
@Autowired
|
private TContractRentTypeService contractRentTypeService;
|
@Override
|
public R signContract(SignContractDTO dto) {
|
TContract contract = contractMapper.selectById(dto.getId());
|
if (contract==null)return R.fail("合同不存在");
|
if (contract.getStatus().equals("4"))return R.fail("该合同已签订");
|
contract.setSignature(dto.getSignature());
|
contract.setStatus("4");
|
contractMapper.updateById(contract);
|
contract.setFirstPayTime(contract.getStartTime().plusDays(10));
|
List<TBill> bills = new ArrayList<>();
|
List<TContractRentType> contractRentTypes = contractRentTypeService.list();
|
// 生成第一笔账单
|
// 第一次应缴费日期
|
LocalDateTime firstPayTime = contract.getStartTime().plusDays(10).withHour(0).withMinute(0).withSecond(0);
|
TBill rentBill = new TBill();
|
rentBill.setContractId(contract.getId());
|
rentBill.setContractNumber(contract.getContractNumber());
|
rentBill.setPayableFeesTime(firstPayTime.toLocalDate());
|
if (firstPayTime.toLocalDate().equals(LocalDate.now())){
|
rentBill.setPayFeesStatus("1");
|
}else {
|
rentBill.setPayFeesStatus("2");
|
}
|
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);
|
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)).divide(new BigDecimal(contract.getPayType().equals("1")? 1:contract.getPayType().equals("2")? 3:12),2,BigDecimal.ROUND_DOWN));
|
contract.setChangeRent(contractRentTypeMoney);
|
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);
|
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);
|
|
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());
|
|
}
|
// 押金账单
|
TBill depositBill = new TBill();
|
depositBill.setContractId(contract.getId());
|
depositBill.setContractNumber(contract.getContractNumber());
|
depositBill.setPayableFeesMoney(contract.getDeposit());
|
depositBill.setOutstandingMoney(depositBill.getPayableFeesMoney());
|
depositBill.setStartTime(contract.getStartPayTime());
|
depositBill.setEndTime(contract.getEndTime());
|
depositBill.setPayableFeesTime(firstPayTime.toLocalDate());
|
if (firstPayTime.toLocalDate().equals(LocalDate.now())){
|
depositBill.setPayFeesStatus("1");
|
|
}else {
|
depositBill.setPayFeesStatus("2");
|
|
}
|
depositBill.setBillType("2");
|
this.updateById(contract);
|
billService.save(rentBill);
|
billService.save(depositBill);
|
// 生成后续账单
|
try {
|
TBill beforeBill = billService.lambdaQuery().eq(TBill::getContractId, contract.getId()).eq(TBill::getBillType, 1).orderByDesc(TBill::getCreateTime)
|
.last("limit 1").one();
|
if (!beforeBill.getEndTime().toLocalDate().equals(contract.getEndTime().toLocalDate())){
|
|
|
while(beforeBill.getEndTime().plusMonths(contract.getPayType().equals("1")? 1:contract.getPayType().equals("2")? 3:12).isBefore(contract.getEndTime())){
|
|
TBill tBill = new TBill();
|
tBill.setContractId(contract.getId());
|
tBill.setContractNumber(contract.getContractNumber());
|
// 根据支付方式判断需不需要生成订单
|
if (!(beforeBill.getEndTime().toLocalDate().equals(contract.getEndTime().toLocalDate()))
|
&&
|
(contract.getPayType().equals("1")?
|
beforeBill.getEndTime().plusMonths(1):contract.getPayType().equals("2")?
|
beforeBill.getEndTime().plusMonths(3):beforeBill.getEndTime().plusMonths(12))
|
.with(TemporalAdjusters.lastDayOfMonth()).isBefore(contract.getEndTime())
|
&& beforeBill.getEndTime().isBefore(contract.getEndTime())
|
){
|
tBill.setContractId(contract.getId());
|
if (contract.getIsIncreasing()){
|
if (tContractRentType!=null
|
&& beforeBill.getEndTime().isBefore(tContractRentType.getChangeTime())
|
&& beforeBill.getEndTime().plusMonths(contract.getPayType().equals("1")? 1:contract.getPayType().equals("2")? 3:12).with(TemporalAdjusters.lastDayOfMonth()).isAfter(tContractRentType.getChangeTime())){
|
// 如果没变过
|
if (contract.getChangeTime()==null){
|
contract.setChangeTime(LocalDateTime.now());
|
// 租金递增递减的时长 天
|
long moneyDays = ChronoUnit.DAYS.between(tContractRentType.getChangeTime(), contract.getEndTime());
|
// 递增递减的租金
|
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);
|
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)).divide(new BigDecimal(contract.getPayType().equals("1")? 1:contract.getPayType().equals("2")? 3:12),2,BigDecimal.ROUND_DOWN));
|
contract.setChangeRent(contractRentTypeMoney);
|
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);
|
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);
|
|
break;
|
}
|
break;
|
}
|
// 不需要涨租金的时间段
|
long originalDays = ChronoUnit.DAYS.between(beforeBill.getEndTime(), tContractRentType.getChangeTime());
|
originalMoney=originalMoney.add(contract.getMonthRent().divide(new BigDecimal(30), 2, BigDecimal.ROUND_DOWN))
|
.multiply(new BigDecimal(originalDays));
|
tBill.setPayableFeesMoney(contractRentTypeMoney.add(originalMoney));
|
tBill.setOutstandingMoney(tBill.getPayableFeesMoney());
|
|
}else{
|
// 之前已经涨、跌过租金了 需要判断周期是否还需要再涨、跌
|
if ((LocalDateTime.now().getYear() - contract.getChangeTime().getYear())%tContractRentType.getCycleTime()==0){
|
contract.setChangeTime(LocalDateTime.now());
|
// 租金递增递减的时长 天
|
long moneyDays = ChronoUnit.DAYS.between(tContractRentType.getChangeTime(), contract.getEndTime());
|
// 递增递减的租金
|
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);
|
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)).divide(new BigDecimal(contract.getPayType().equals("1")? 1:contract.getPayType().equals("2")? 3:12),2,BigDecimal.ROUND_DOWN));
|
contract.setChangeRent(contractRentTypeMoney);
|
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);
|
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);
|
|
break;
|
}
|
break;
|
}
|
// 不需要涨租金的时间段
|
long originalDays = ChronoUnit.DAYS.between(beforeBill.getEndTime(), tContractRentType.getChangeTime());
|
originalMoney=originalMoney.add(contract.getMonthRent().divide(new BigDecimal(30), 2, BigDecimal.ROUND_DOWN))
|
.multiply(new BigDecimal(originalDays));
|
tBill.setPayableFeesMoney(contractRentTypeMoney.add(originalMoney));
|
tBill.setOutstandingMoney(tBill.getPayableFeesMoney());
|
|
}else{
|
// 不涨租金 用上次的
|
// 租金递增递减的时长 天
|
long moneyDays = ChronoUnit.DAYS.between(tContractRentType.getChangeTime(), contract.getEndTime());
|
// 递增递减的租金
|
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);
|
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)).divide(new BigDecimal(contract.getPayType().equals("1")? 1:contract.getPayType().equals("2")? 3:12),2,BigDecimal.ROUND_DOWN));
|
contract.setChangeRent(contractRentTypeMoney);
|
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);
|
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);
|
|
break;
|
}
|
break;
|
}
|
// 不需要涨租金的时间段
|
long originalDays = ChronoUnit.DAYS.between(beforeBill.getEndTime(), tContractRentType.getChangeTime());
|
originalMoney=originalMoney.add(contract.getMonthRent().divide(new BigDecimal(30), 2, BigDecimal.ROUND_DOWN))
|
.multiply(new BigDecimal(originalDays));
|
tBill.setPayableFeesMoney(contractRentTypeMoney.add(originalMoney));
|
tBill.setOutstandingMoney(tBill.getPayableFeesMoney());
|
|
}
|
}
|
|
}
|
}else{
|
long allDays = ChronoUnit.DAYS.between(beforeBill.getEndTime(), (contract.getPayType().equals("1")?
|
beforeBill.getEndTime().plusMonths(1):contract.getPayType().equals("2")?
|
beforeBill.getEndTime().plusMonths(3):beforeBill.getEndTime().plusMonths(12)).with(TemporalAdjusters.lastDayOfMonth()));
|
tBill.setPayableFeesMoney(contract.getMonthRent().divide(new BigDecimal(30), 2, BigDecimal.ROUND_DOWN).multiply(new BigDecimal(allDays)));
|
tBill.setOutstandingMoney(tBill.getPayableFeesMoney());
|
|
}
|
tBill.setContractNumber(contract.getContractNumber());
|
if (beforeBill.getEndTime().plusMonths(contract.getPayType().equals("1")? 1:contract.getPayType().equals("2")? 3:12).getDayOfMonth()<=15){
|
tBill.setPayableFeesTime(contract.getEndTime().toLocalDate());
|
}else{
|
tBill.setPayableFeesTime((contract.getPayType().equals("1")?
|
beforeBill.getEndTime().plusMonths(1).withDayOfMonth(15).toLocalDate():contract.getPayType().equals("2")?
|
beforeBill.getEndTime().plusMonths(3).withDayOfMonth(15).toLocalDate():beforeBill.getEndTime().withDayOfMonth(15).plusMonths(12).toLocalDate()));
|
}
|
tBill.setPayFeesStatus("2");
|
tBill.setBillType("1");
|
tBill.setStartTime(beforeBill.getEndTime().plusDays(1));
|
tBill.setEndTime(contract.getEndTime());
|
}
|
billMapper.insert(tBill);
|
}
|
}
|
|
} catch (Exception e) {
|
e.printStackTrace();
|
}
|
TBill beforeBill = billService.lambdaQuery().eq(TBill::getContractId, contract.getId()).eq(TBill::getBillType, 1).orderByDesc(TBill::getCreateTime)
|
.last("limit 1").one();
|
// 生成最后一笔账单
|
if (!(beforeBill.getEndTime().toLocalDate().equals(contract.getEndTime().toLocalDate()))
|
&&
|
(contract.getPayType().equals("1")?
|
beforeBill.getEndTime().plusMonths(1):contract.getPayType().equals("2")?
|
beforeBill.getEndTime().plusMonths(3):beforeBill.getEndTime().plusMonths(12))
|
.with(TemporalAdjusters.lastDayOfMonth()).isAfter(contract.getEndTime())
|
&& beforeBill.getEndTime().isBefore(contract.getEndTime())
|
){
|
TBill tBill = new TBill();
|
tBill.setContractId(contract.getId());
|
|
if (contract.getIsIncreasing()){
|
if (tContractRentType!=null
|
&& beforeBill.getEndTime().isBefore(tContractRentType.getChangeTime())
|
&& beforeBill.getEndTime().plusMonths(contract.getPayType().equals("1")? 1:contract.getPayType().equals("2")? 3:12).with(TemporalAdjusters.lastDayOfMonth()).isAfter(tContractRentType.getChangeTime())){
|
// 如果没变过
|
if (contract.getChangeTime()==null){
|
contract.setChangeTime(LocalDateTime.now());
|
// 租金递增递减的时长 天
|
long moneyDays = ChronoUnit.DAYS.between(tContractRentType.getChangeTime(), contract.getEndTime());
|
// 递增递减的租金
|
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);
|
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)).divide(new BigDecimal(contract.getPayType().equals("1")? 1:contract.getPayType().equals("2")? 3:12),2,BigDecimal.ROUND_DOWN));
|
contract.setChangeRent(contractRentTypeMoney);
|
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);
|
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);
|
|
break;
|
}
|
break;
|
}
|
// 不需要涨租金的时间段
|
long originalDays = ChronoUnit.DAYS.between(beforeBill.getEndTime(), tContractRentType.getChangeTime());
|
|
// 不需要涨租金的时间段
|
if (contract.getFirstPayTime().isBefore(tContractRentType.getChangeTime())){
|
originalMoney=originalMoney.add(contract.getMonthRent().divide(new BigDecimal(30), 2, BigDecimal.ROUND_DOWN))
|
.multiply(new BigDecimal(originalDays));
|
tBill.setPayableFeesMoney(contractRentTypeMoney.add(originalMoney));
|
tBill.setOutstandingMoney(tBill.getPayableFeesMoney());
|
}else{
|
tBill.setPayableFeesMoney(contractRentTypeMoney);
|
tBill.setOutstandingMoney(tBill.getPayableFeesMoney());
|
}
|
|
}else{
|
// 之前已经涨、跌过租金了 需要判断周期是否还需要再涨、跌
|
if ((LocalDateTime.now().getYear() - contract.getChangeTime().getYear())%tContractRentType.getCycleTime()==0){
|
contract.setChangeTime(LocalDateTime.now());
|
// 租金递增递减的时长 天
|
long moneyDays = ChronoUnit.DAYS.between(tContractRentType.getChangeTime(), contract.getEndTime());
|
// 递增递减的租金
|
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);
|
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)).divide(new BigDecimal(contract.getPayType().equals("1")? 1:contract.getPayType().equals("2")? 3:12),2,BigDecimal.ROUND_DOWN));
|
contract.setChangeRent(contractRentTypeMoney);
|
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);
|
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);
|
|
break;
|
}
|
break;
|
}
|
// 不需要涨租金的时间段
|
long originalDays = ChronoUnit.DAYS.between(beforeBill.getEndTime(), tContractRentType.getChangeTime());
|
originalMoney=originalMoney.add(contract.getMonthRent().divide(new BigDecimal(30), 2, BigDecimal.ROUND_DOWN))
|
.multiply(new BigDecimal(originalDays));
|
tBill.setPayableFeesMoney(contractRentTypeMoney.add(originalMoney));
|
tBill.setOutstandingMoney(tBill.getPayableFeesMoney());
|
|
}else{
|
// 不涨租金 用上次的
|
// 租金递增递减的时长 天
|
long moneyDays = ChronoUnit.DAYS.between(tContractRentType.getChangeTime(), contract.getEndTime());
|
// 递增递减的租金
|
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);
|
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)).divide(new BigDecimal(contract.getPayType().equals("1")? 1:contract.getPayType().equals("2")? 3:12),2,BigDecimal.ROUND_DOWN));
|
contract.setChangeRent(contractRentTypeMoney);
|
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);
|
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);
|
|
break;
|
}
|
break;
|
}
|
// 不需要涨租金的时间段
|
long originalDays = ChronoUnit.DAYS.between(beforeBill.getEndTime(), tContractRentType.getChangeTime());
|
originalMoney=originalMoney.add(contract.getMonthRent().divide(new BigDecimal(30), 2, BigDecimal.ROUND_DOWN))
|
.multiply(new BigDecimal(originalDays));
|
tBill.setPayableFeesMoney(contractRentTypeMoney.add(originalMoney));
|
tBill.setOutstandingMoney(tBill.getPayableFeesMoney());
|
|
}
|
}
|
|
}
|
}else{
|
long allDays = ChronoUnit.DAYS.between(beforeBill.getEndTime(), contract.getEndTime());
|
tBill.setPayableFeesMoney(contract.getMonthRent().divide(new BigDecimal(30), 2, BigDecimal.ROUND_DOWN).multiply(new BigDecimal(allDays)));
|
tBill.setOutstandingMoney(tBill.getPayableFeesMoney());
|
|
}
|
tBill.setContractNumber(contract.getContractNumber());
|
if (beforeBill.getEndTime().plusMonths(contract.getPayType().equals("1")? 1:contract.getPayType().equals("2")? 3:12).getDayOfMonth()<=15){
|
tBill.setPayableFeesTime(contract.getEndTime().withHour(0).withMinute(0).withSecond(0).toLocalDate());
|
}else{
|
tBill.setPayableFeesTime((contract.getPayType().equals("1")?
|
beforeBill.getEndTime().plusMonths(1).withDayOfMonth(15).toLocalDate():contract.getPayType().equals("2")?
|
beforeBill.getEndTime().plusMonths(3).withDayOfMonth(15).toLocalDate():beforeBill.getEndTime().withDayOfMonth(15).plusMonths(12).withHour(0).withMinute(0).withSecond(0).toLocalDate()));
|
}
|
tBill.setPayFeesStatus("1");
|
tBill.setBillType("1");
|
tBill.setStartTime(beforeBill.getEndTime().plusDays(1));
|
tBill.setEndTime(beforeBill.getEndTime().plusMonths(contract.getPayType().equals("1")? 1:contract.getPayType().equals("2")? 3:12));
|
billService.save(tBill);
|
}
|
|
return R.ok();
|
}
|
|
@Override
|
public void export(TContractQuery query) {
|
|
}
|
|
@Override
|
public List<TContract> contractExportList(TContractQuery query) {
|
List<TContract> list = this.baseMapper.contractExportList(query);
|
|
return list;
|
}
|
|
@Override
|
public Boolean updateContractAuditStatus(String projectId, Integer status) {
|
LambdaUpdateWrapper<TContract> contractLambdaUpdateWrapper = new LambdaUpdateWrapper<>();
|
contractLambdaUpdateWrapper.eq(TContract::getId, projectId).set(TContract::getStatus, status);
|
return this.update(contractLambdaUpdateWrapper);
|
}
|
}
|
