From 380efb1e727d51c9080a91bd7aad6a063081bb45 Mon Sep 17 00:00:00 2001 From: yupeng <roc__yu@163.com> Date: 星期三, 09 四月 2025 12:31:25 +0800 Subject: [PATCH] feat: 1.修改统计跟随查询变化 2.修改账单分页查询排序,新增按状态排序权重表 3.新增修改账单金额接口 --- ruoyi-system/src/main/java/com/ruoyi/system/mapper/TBillMapper.java | 35 ++++++++++++++++++++++++++++++++++- 1 files changed, 34 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 ab6c3dc..2cdf39a 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 @@ -5,8 +5,12 @@ 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 org.apache.ibatis.annotations.Select; + +import java.math.BigDecimal; +import java.util.List; /** * <p> @@ -16,8 +20,37 @@ * @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(); } -- Gitblit v1.7.1