From 5fa6e6f8410ef9d057174bcff2a3c5038c54a551 Mon Sep 17 00:00:00 2001 From: xuhy <3313886187@qq.com> Date: 星期日, 27 四月 2025 18:41:20 +0800 Subject: [PATCH] bug修改 --- ruoyi-system/src/main/java/com/ruoyi/system/mapper/TBillMapper.java | 49 ++++++++++++++++++++++++++++++++++++++++++++++++- 1 files changed, 48 insertions(+), 1 deletions(-) diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TBillMapper.java b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TBillMapper.java index 9a7cedb..e0c85e5 100644 --- a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TBillMapper.java +++ b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TBillMapper.java @@ -1,7 +1,17 @@ package com.ruoyi.system.mapper; -import com.ruoyi.system.model.TBill; import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.ruoyi.common.basic.PageInfo; +import com.ruoyi.system.dto.TBillDto; +import com.ruoyi.system.model.TBill; +import com.ruoyi.system.query.TBillQuery; +import com.ruoyi.system.vo.ScreenRentRankVO; +import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Param; + +import java.math.BigDecimal; +import java.util.Date; +import java.util.List; /** * <p> @@ -11,6 +21,43 @@ * @author xiaochen * @since 2025-01-17 */ +@Mapper public interface TBillMapper extends BaseMapper<TBill> { + PageInfo<TBillDto> page(@Param("pageInfo") PageInfo<TBill> pageInfo, @Param("query") TBillQuery query); + + PageInfo<TBillDto> pageForApplet(@Param("pageInfo") PageInfo<TBill> pageInfo, @Param("query") TBillQuery query); + + List<TBillDto> getBillList(@Param("query")TBillQuery query); + + /** + * 获取开票列表 + * @param query + * @param pageInfo + * @return + */ + List<TBillDto> invoiceList(@Param("query")TBillQuery query, @Param("pageInfo")PageInfo<TBillDto> pageInfo); + + TBillDto selectDetailByBillId(@Param("billId") String billId); + + BigDecimal statisticsAllRent(@Param("query") TBillQuery query); + + BigDecimal statisticsNoPay(@Param("query") TBillQuery query); + + BigDecimal statisticsPayed(@Param("query") TBillQuery query); + + BigDecimal statisticsOverdue(@Param("query") TBillQuery query); + + Integer batchBillCount(@Param("userId")String userId, @Param("billIds")List<String> billIds); + /** + * 街道租金排行 + * @return + */ + List<ScreenRentRankVO> getStreetRentRank(@Param("businessDeptId") String businessDeptId); + /** + * 查询季付账单 + * @param businessDeptId + * @return + */ + List<TBill> getJiFuBillList(@Param("businessDeptId") String businessDeptId, @Param("first") Date first, @Param("last") Date last); } -- Gitblit v1.7.1