package com.ruoyi.system.mapper;
|
|
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 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>
|
* 租金账单 Mapper 接口
|
* </p>
|
*
|
* @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);
|
|
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();
|
|
BigDecimal statisticsNoPay();
|
|
BigDecimal statisticsPayed();
|
|
BigDecimal statisticsOverdue();
|
|
Integer batchBillCount(@Param("userId")String userId, @Param("billIds")List<String> billIds);
|
}
|
