获取未绑定轮灌组的取水口

zhubaomin

2025-04-11 a1744d0bf7f0ad8ac861d672cffd7c710dac4e7e

 pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSt/StClientAmountDayMapper.java

@@ -1,10 +1,14 @@
package com.dy.pipIrrGlobal.daoSt;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.dy.pipIrrGlobal.pojoSt.StClientAmountDay;
import com.dy.pipIrrGlobal.voSt.VoClientAmountStatistics;
import com.dy.pipIrrGlobal.voSt.VoStClientAmountDay;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 * @Author: liurunyu
@@ -12,7 +16,7 @@
 * @Description
 */
@Mapper
public interface StClientAmountDayMapper {
public interface StClientAmountDayMapper extends BaseMapper<StClientAmountDay> {
    /**
     * delete by primary key
     *
@@ -63,21 +67,42 @@


    //////////////////////////////////////
    //查询统计结果
    /**
     * 查询总数量
     * @param params
     * @return
     */
    Long selectCountDayStatistics(Map<?, ?> params) ;
    /**
     * 查询分页数据
     * @param params
     * @return
     */
    List<VoStClientAmountDay> selectDayStatistics(Map<?, ?> params) ;

    //////////////////////////////////////
    //统计相关
    /**
     * 查询用水户一个月所有日的用水量
     * @param clientId
     * @param year
     * @param month
     * @return
     */
    List<StClientAmountDay> selectByClientIdAndYearAndMonthAndDay(@Param("clientId")Long clientId,
                                                                  @Param("year")Integer year,
                                                                  @Param("month")Integer month) ;
    List<VoClientAmountStatistics> statisticsByClient(@Param("year")Integer year,
                                                      @Param("month")Integer month) ;

    /**
     * 查询用水户一个月所有日的用水量
     * @param year
     * @param month
     * @return
     */
    List<StClientAmountDay> selectByYearAndMonthAndDay(@Param("year")Integer year,
                                                       @Param("month")Integer month) ;

    //////////////////////////////////////
    //临时任务相关

    /**
     * 删除全部
     * @return