1.租户数量趋势统计

luofl

2025-04-02 2abe2f03e1633ddcb71083c58c88e4d79595f0eb

1.租户数量趋势统计

 ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/ScreenController.java

@@ -1,5 +1,6 @@
package com.ruoyi.web.controller.api;

import cn.hutool.core.collection.CollectionUtil;
import com.alibaba.fastjson2.JSONArray;
import com.alibaba.fastjson2.JSONObject;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
@@ -31,6 +32,8 @@
import java.time.temporal.ChronoUnit;
import java.util.*;
import java.util.stream.Collectors;

import static org.checkerframework.checker.units.qual.Prefix.one;

/**
 * @author mitao
@@ -81,8 +84,7 @@
                .between(TContract::getSignTime, startQuarterDate.get("first"), endQuarterDate.get("last"))
                .orderByAsc(TContract::getSignTime));

        // 创建季度格式化工具（示例：2025-Q1）
        DateTimeFormatter quarterFormatter = DateTimeFormatter.ofPattern("yyyy-'Q'Q");
        DateTimeFormatter quarterFormatter = DateTimeFormatter.ofPattern("yyyy-MM");

        List<TenantCountTrendVO> trendData = contracts.stream()
                .collect(Collectors.groupingBy(contract -> {
@@ -110,6 +112,9 @@
        List<THouse> houses = houseService.list(new LambdaQueryWrapper<THouse>()
                .last("ORDER BY RAND() LIMIT 10"));

        if (CollectionUtil.isEmpty(houses)){
            return R.ok(new ArrayList<>());
        }

        // 提取streetIds
        List<String> streetIds = houses.stream()
@@ -174,23 +179,33 @@
                houseMapDistributionVO.setRentStatus(rentStatus);


                TBill one = billService.getOne(new LambdaQueryWrapper<TBill>()
//                TBill one = billService.getOne(new LambdaQueryWrapper<TBill>()
//                        .le(TBill::getStartTime, LocalDate.now())
//                        .ge(TBill::getEndTime, LocalDate.now())
//                        .eq(TBill::getBillType, 1)
//                        .eq(TBill::getContractId, contract.getId()));

                List<TBill> ones = billService.list(new LambdaQueryWrapper<TBill>()
                        .le(TBill::getStartTime, LocalDate.now())
                        .ge(TBill::getEndTime, LocalDate.now())
                        .eq(TBill::getBillType, 1)
                        .eq(TBill::getContractId, contract.getId()));

                if (one != null && "4".equals(one.getPayFeesStatus())){
                    houseMapDistributionVO.setHouseStatus("4");
                TBill one = null;
                if (!ones.isEmpty()){
                     one = ones.get(0);
                }



                BigDecimal payFeesMoney = one.getPayFeesMoney();
                BigDecimal payableFeesMoney1 = one.getPayableFeesMoney();
                String rent = String.format("%.2f/%.2f", payFeesMoney, payableFeesMoney1);

                houseMapDistributionVO.setRent(rent);
                if (one != null){
                    if ("4".equals(one.getPayFeesStatus())){
                        houseMapDistributionVO.setHouseStatus("4");
                    }
                    BigDecimal payFeesMoney = one.getPayFeesMoney();
                    BigDecimal payableFeesMoney1 = one.getPayableFeesMoney();
                    String rent = String.format("%.2f/%.2f", payFeesMoney, payableFeesMoney1);
                    houseMapDistributionVO.setRent(rent);
                }else {
                    houseMapDistributionVO.setRent("暂无");
                }
            }else {
                houseMapDistributionVO.setTenant("暂无");
                houseMapDistributionVO.setRentStatus("暂无");

 ruoyi-applet/src/main/resources/application.yml

@@ -1,4 +1,4 @@
# 项目相关配置
spring:
  profiles:
    active: prod
    active: test