From c474556f44163526700fd7c99a88e37e4297e23f Mon Sep 17 00:00:00 2001
From: xuhy <3313886187@qq.com>
Date: 星期四, 27 二月 2025 19:14:23 +0800
Subject: [PATCH] 审批流定时任务

---
 ruoyi-admin/src/main/java/com/ruoyi/web/controller/task/TaskUtil.java |  159 ++++++++++++++--------------------------------------
 1 files changed, 43 insertions(+), 116 deletions(-)

diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/task/TaskUtil.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/task/TaskUtil.java
index 34d7837..6db2c4f 100644
--- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/task/TaskUtil.java
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/task/TaskUtil.java
@@ -3,7 +3,9 @@
 
 import com.ruoyi.system.model.TBill;
 import com.ruoyi.system.model.TContract;
+import com.ruoyi.system.model.TContractRentType;
 import com.ruoyi.system.service.TBillService;
+import com.ruoyi.system.service.TContractRentTypeService;
 import com.ruoyi.system.service.TContractService;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.scheduling.annotation.Scheduled;
@@ -32,148 +34,73 @@
     private TContractService contractService;
     @Autowired
     private TBillService billService;
+    @Autowired
+    private TContractRentTypeService contractRentTypeService;
 
-
-
-
-    // 每天凌晨00点执行的定时任务 用于合同生成第一笔账单
+    // 每天凌晨00点执行的定时任务 用于生成违约金
     @Scheduled(cron = "0 0 0 * * ?")
-    public void dayOfFirstBill() {
+    public void dayOfProportionBill() {
         try {
-            // 查询所有已签订的合同并且未生成第一笔账单的
-            List<TContract> list = contractService.lambdaQuery().eq(TContract::getStatus, 4).isNull(TContract::getFirstPayTime).list();
-            List<TBill> bills = new ArrayList<>();
-            for (TContract contract : list) {
-                contract.setFirstPayTime(contract.getStartTime().plusDays(10));
-                // 第一次应缴费日期
-                LocalDateTime firstPayTime = contract.getStartTime().plusDays(10);
-                LocalDate localDate = contract.getStartTime().plusDays(10).toLocalDate();
-                LocalDate now = LocalDate.now();
-                // 如果应缴费日期和当前时间不相同 跳过
-                if (!localDate.equals(now)) {
-                    continue;
+            // 查询所有未缴费账单
+            List<TBill> list = billService.lambdaQuery().eq(TBill::getPayFeesStatus, 1).list();
+            for (TBill tBill : list) {
+                TContract contract = contractService.getById(tBill.getContractId());
+                LocalDate payableFeesTime = tBill.getPayableFeesTime();
+                LocalDateTime now = LocalDateTime.now();
+                // 计算两个时间相差多少个小时
+                long hours = ChronoUnit.HOURS.between(payableFeesTime, now);
+                long l = hours / 72;
+                if (l>0){
+                    // 违约金比例
+                    BigDecimal proportion = contract.getProportion();
+                    // 应缴违约金
+                    BigDecimal money = tBill.getOutstandingMoney().multiply(proportion);
+                    TBill changeBill = new TBill();
+                    changeBill.setId(tBill.getId());
+                    changeBill.setPayableFeesPenalty(money);
+                    billService.lockAndUpdateInfo(changeBill,2);
                 }
-                TBill rentBill = new TBill();
-                rentBill.setContractId(contract.getId());
-                rentBill.setContractNumber(contract.getContractNumber());
-                LocalDateTime startPayTime = contract.getStartPayTime();
-                LocalDateTime endTime1 = contract.getEndTime();
-                // 计算两个时间相差多少天
-                long days = ChronoUnit.DAYS.between(startPayTime, endTime1)+1L;
-                // 如果时间小于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());
-                if ((contract.getEndTime().getYear() == contract.getStartTime().getYear()) && (contract.getEndTime().getMonth() == contract.getStartTime().getMonth())) {
-                    // 如果同年同月 那么账单周期为合同结束时间
-                    rentBill.setEndTime(contract.getEndTime());
-                } else {
-                    // 否则 取当月最后一天
-                    LocalDateTime endTime = contract.getStartTime().with(TemporalAdjusters.lastDayOfMonth()).withSecond(59).withHour(23).withMinute(59);
-                    rentBill.setEndTime(endTime);
-                }
-                // 租金账单
-                bills.add(rentBill);
-                // 押金账单
-                TBill depositBill = new TBill();
-                depositBill.setContractId(contract.getId());
-                depositBill.setContractNumber(contract.getContractNumber());
-                depositBill.setPayableFeesMoney(contract.getDeposit());
-                depositBill.setPayableFeesTime(firstPayTime);
-                depositBill.setPayFeesStatus("1");
-                depositBill.setBillType("2");
-                bills.add(depositBill);
             }
-            contractService.updateBatchById(list);
-            billService.saveBatch(bills);
+
         } catch (Exception e) {
             e.printStackTrace();
         }
     }
 
-    // 每天凌晨00点执行的定时任务 用于生成合同期最后一笔账单
+
+
+    // 每天凌晨00点执行的定时任务 根据应缴费日期修改账单状态
     @Scheduled(cron = "0 0 0 * * ?")
     public void dayOfEndBill() {
         try {
-            // 查询所有已签订的合同并且已经生成第一笔账单的
-            List<TContract> list = contractService.lambdaQuery().eq(TContract::getStatus, 4).isNotNull(TContract::getFirstPayTime).list();
-            List<TBill> bills = new ArrayList<>();
-            for (TContract contract : list) {
-                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()))&&beforeBill.getEndTime().plusMonths(1).with(TemporalAdjusters.lastDayOfMonth()).isAfter(contract.getEndTime())){
-                    TBill tBill = new TBill();
-                    tBill.setContractId(contract.getId());
-                    tBill.setContractNumber(contract.getContractNumber());
-                    tBill.setPayableFeesMoney(contract.getMonthRent());
-                    tBill.setPayableFeesTime(LocalDateTime.now());
+            List<TBill> list = billService.lambdaQuery().eq(TBill::getPayFeesStatus, "2").list();
+            for (TBill tBill : list) {
+                if (tBill.getPayableFeesTime().equals(LocalDate.now())){
                     tBill.setPayFeesStatus("1");
-                    tBill.setBillType("1");
-                    tBill.setStartTime(beforeBill.getEndTime().plusMonths(1).with(TemporalAdjusters.firstDayOfMonth()));
-                    tBill.setEndTime(contract.getEndTime());
-                    bills.add(tBill);
                 }
             }
-            billService.saveBatch(bills);
+            billService.updateBatchById(list);
         } catch (Exception e) {
             e.printStackTrace();
         }
     }
 
-    // 每月15号凌晨执行的定时任务 用于生成租金账单
-    @Scheduled(cron = "0 0 0 15 * ?")
-    public void monthOfBill() {
-        try {
-            // 查询所有已签订的合同 且合同时间大于15号
-            List<TContract> list = contractService.lambdaQuery().eq(TContract::getStatus, 4)
-                    .isNotNull(TContract::getFirstPayTime)
-                    .ge(TContract::getEndTime, LocalDateTime.now())
-                    .list();
-            List<TBill> bills = new ArrayList<>();
-            for (TContract contract : list) {
-                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()))continue;
-                if (beforeBill.getEndTime().plusMonths(1).with(TemporalAdjusters.lastDayOfMonth()).isBefore(contract.getEndTime())){
-                    TBill tBill = new TBill();
-                    tBill.setContractId(contract.getId());
-                    tBill.setContractNumber(contract.getContractNumber());
-                    tBill.setPayableFeesMoney(contract.getMonthRent());
-                    tBill.setPayableFeesTime(LocalDateTime.now());
-                    tBill.setPayFeesStatus("1");
-                    tBill.setBillType("1");
-                    tBill.setStartTime(beforeBill.getEndTime().plusMonths(1).with(TemporalAdjusters.firstDayOfMonth()));
-                    tBill.setEndTime(beforeBill.getEndTime().plusMonths(1).with(TemporalAdjusters.lastDayOfMonth()));
-                    bills.add(tBill);
 
-                }
-            }
-            billService.saveBatch(bills);
-        } catch (Exception e) {
-            e.printStackTrace();
-        }
-    }
 
 
     public static void main(String[] args) {
-        LocalDateTime now = LocalDateTime.now().minusMonths(1).withDayOfMonth(31);
-        System.err.println(now);
-        LocalDateTime now2 = now.plusMonths(1);
-        System.err.println(now2);
 
-        LocalDateTime now1 = LocalDateTime.now();
-        long days = ChronoUnit.DAYS.between(now, now1);
-        long days2 = ChronoUnit.DAYS.between(now.plusDays(1), now1);
-
-        System.err.println(days);
-        System.err.println(days2);
+//        LocalDateTime now = LocalDateTime.now().minusMonths(1).withDayOfMonth(31);
+//        System.err.println(now);
+//        LocalDateTime now2 = now.plusMonths(1);
+//        System.err.println(now2);
+//
+//        LocalDateTime now1 = LocalDateTime.now();
+//        long days = ChronoUnit.DAYS.between(now, now1);
+//        long days2 = ChronoUnit.DAYS.between(now.plusDays(1), now1);
+//
+//        System.err.println(days);
+//        System.err.println(days2);
 //        LocalDateTime endTime = now.with(TemporalAdjusters.lastDayOfMonth()).withSecond(59).withHour(23).withMinute(59);
 //
 //        System.err.println(endTime);

--
Gitblit v1.7.1