From dbf671285d9217f6ca84ee1e795aa9af386955e3 Mon Sep 17 00:00:00 2001
From: luofl <1442745593@qq.com>
Date: 星期四, 03 四月 2025 21:06:02 +0800
Subject: [PATCH] 1.租户数量趋势统计

---
 ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TBillServiceImpl.java |   75 +++++++++++++++++++++++++++++++------
 1 files changed, 63 insertions(+), 12 deletions(-)

diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TBillServiceImpl.java b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TBillServiceImpl.java
index adb9fe4..42adf5f 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TBillServiceImpl.java
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TBillServiceImpl.java
@@ -1,21 +1,42 @@
 package com.ruoyi.system.service.impl;
 
-import cn.hutool.core.date.DateUtil;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
 import com.ruoyi.common.basic.PageInfo;
-import com.ruoyi.common.config.SmsProperties;
 import com.ruoyi.common.constant.AmountConstant;
 import com.ruoyi.common.constant.CacheConstants;
 import com.ruoyi.common.core.redis.RedisCache;
 import com.ruoyi.common.exception.ServiceException;
-import com.ruoyi.common.utils.*;
+import com.ruoyi.common.utils.DateUtils;
+import com.ruoyi.common.utils.OrderNos;
+import com.ruoyi.common.utils.SmsUtil;
+import com.ruoyi.common.utils.StringUtils;
+import com.ruoyi.common.utils.TencentMailUtil;
 import com.ruoyi.common.utils.uuid.UUID;
-import com.ruoyi.system.dto.*;
+import com.ruoyi.system.dto.BillStatisticsDto;
+import com.ruoyi.system.dto.CachPayDto;
+import com.ruoyi.system.dto.OfflinePayCheckDto;
+import com.ruoyi.system.dto.SmsByBillDto;
+import com.ruoyi.system.dto.TBillDto;
+import com.ruoyi.system.dto.TbillSaveDto;
 import com.ruoyi.system.mapper.TBillMapper;
-import com.ruoyi.system.model.*;
+import com.ruoyi.system.model.TBankFlow;
+import com.ruoyi.system.model.TBill;
+import com.ruoyi.system.model.TBillDetail;
+import com.ruoyi.system.model.TFlowManagement;
+import com.ruoyi.system.model.TInvoiceToBill;
+import com.ruoyi.system.model.TOrderBill;
+import com.ruoyi.system.model.TPayOrder;
 import com.ruoyi.system.query.TBillQuery;
 import com.ruoyi.system.query.TInvoiceToBillQuery;
-import com.ruoyi.system.service.*;
+import com.ruoyi.system.service.TBankFlowService;
+import com.ruoyi.system.service.TBillConfirmService;
+import com.ruoyi.system.service.TBillDetailService;
+import com.ruoyi.system.service.TBillService;
+import com.ruoyi.system.service.TFlowManagementService;
+import com.ruoyi.system.service.TInvoiceToBillService;
+import com.ruoyi.system.service.TOrderBillService;
+import com.ruoyi.system.service.TPayOrderService;
+import com.ruoyi.system.vo.ScreenRentRankVO;
 import com.taxi591.bankapi.dto.ChargeBillRequest;
 import lombok.extern.slf4j.Slf4j;
 import org.jetbrains.annotations.NotNull;
@@ -28,7 +49,6 @@
 import javax.validation.constraints.NotEmpty;
 import java.math.BigDecimal;
 import java.text.ParseException;
-import java.time.LocalDateTime;
 import java.util.ArrayList;
 import java.util.Comparator;
 import java.util.Date;
@@ -281,6 +301,7 @@
             TFlowManagement save = new TFlowManagement();
             save.setPayType(3);
             save.setPayer(dto.getPayer());
+            save.setBusinessDeptId(bill.getBusinessDeptId());
             save.setPayTime(bankflow.getPayTime());
             save.setSysSerialNumber(OrderNos.getDid(30));
             save.setBankSerialNumber(bankflow.getBankSerialNumber());
@@ -362,6 +383,7 @@
                     TFlowManagement saveFlow = new TFlowManagement();
                     saveFlow.setPayType(1);
                     saveFlow.setPayer(order.getUserId());
+                    saveFlow.setBusinessDeptId(bill.getBusinessDeptId());
                     saveFlow.setPayTime(DateUtils.dateToLocalDateTime(save.getPayTime()));
                     saveFlow.setSysSerialNumber(OrderNos.getDid(30));
                     saveFlow.setBankSerialNumber(save.getPayNo());
@@ -529,6 +551,7 @@
         TFlowManagement save = new TFlowManagement();
         save.setPayType(3);
         save.setPayer(dto.getPayer());
+        save.setBusinessDeptId(bill.getBusinessDeptId());
         save.setPayTime(bankflow!=null?bankflow.getPayTime():DateUtils.dateToLocalDateTime(new Date()));
         save.setSysSerialNumber(OrderNos.getDid());
         save.setBankSerialNumber(bankflow!=null?bankflow.getBankSerialNumber():null);
@@ -543,12 +566,12 @@
     }
 
     @Override
-    public BillStatisticsDto statistics() {
+    public BillStatisticsDto statistics(String busDeptId) {
         BillStatisticsDto dto = new BillStatisticsDto();
-        dto.setRent(getBaseMapper().statisticsAllRent());
-        dto.setNopay(getBaseMapper().statisticsNoPay());
-        dto.setPayed(getBaseMapper().statisticsPayed());
-        dto.setOverdue(getBaseMapper().statisticsOverdue());
+        dto.setRent(getBaseMapper().statisticsAllRent(busDeptId));
+        dto.setNopay(getBaseMapper().statisticsNoPay(busDeptId));
+        dto.setPayed(getBaseMapper().statisticsPayed(busDeptId));
+        dto.setOverdue(getBaseMapper().statisticsOverdue(busDeptId));
         return dto;
     }
 
@@ -557,5 +580,33 @@
         return this.baseMapper.batchBillCount(userId,billIds);
     }
 
+    /**
+     * 街道租金排行
+     * @return
+     */
+    @Override
+    public List<ScreenRentRankVO> getStreetRentRank(String businessDeptId) {
+        return baseMapper.getStreetRentRank(businessDeptId);
+    }
+    /**
+     * 查询季付账单
+     * @param businessDeptId
+     * @return
+     */
+    @Override
+    public List<TBill> getJiFuBillList(String businessDeptId) {
+        return baseMapper.getJiFuBillList(businessDeptId,null,null);
+    }
 
+    /**
+     * 查询当前季度的季付账单
+     * @param businessDeptId
+     * @param first
+     * @param last
+     * @return
+     */
+    @Override
+    public List<TBill> getJiFuBillListByTime(String businessDeptId, Date first, Date last) {
+        return baseMapper.getJiFuBillList(businessDeptId,first,last);
+    }
 }

--
Gitblit v1.7.1