优化SQL语句，以提高查询速度

liurunyu

2025-07-29 311a9b371845bb716c182e530e015259834754ad

 pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoTmp/DeleteMapper.java

New file
@@ -0,0 +1,102 @@
package com.dy.pipIrrGlobal.daoTmp;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.dy.pipIrrGlobal.voTmp.*;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * @Author: liurunyu
 * @Date: 2024/12/11 11:15
 * @Description
 */
@Mapper
public interface DeleteMapper extends BaseMapper<Object> {

    /**
     * 查询全部漏损日统计
     *
     * @return 实体集合
     */
    List<VoStLossAmountDay> selectAllStLossDay();

    int deleteStLossDayById(Long id);

    /**
     * 查询全部漏损月统计
     *
     * @return 实体集合
     */
    List<VoStLossAmountMonth> selectAllStLossMonth();

    int deleteStLossMonthById(Long id);

    /**
     * 查询全部漏损年统计
     *
     * @return 实体集合
     */
    List<VoStLossAmountYear> selectAllStLossYear();

    int deleteStLossYearById(Long id);


    /**
     * 查询全部取水口日统计
     *
     * @return 实体集合
     */
    List<VoStIntakeAmountDay> selectAllStIntakeDay();

    int deleteStIntakeDayById(Long id);


    /**
     * 查询全部取水口月统计
     *
     * @return 实体集合
     */
    List<VoStIntakeAmountMonth> selectAllStIntakeMonth();

    int deleteStIntakeMonthById(Long id);

    /**
     * 查询全部取水口年统计
     *
     * @return 实体集合
     */
    List<VoStIntakeAmountYear> selectAllStIntakeYear();

    int deleteStIntakeYearById(Long id);


    /**
     * 查询全部农户月统计
     *
     * @return 实体集合
     */
    List<VoStClientAmountDay> selectAllStClientDay();

    int deleteStClientDayById(Long id);


    /**
     * 查询全部农户月统计
     *
     * @return 实体集合
     */
    List<VoStClientAmountMonth> selectAllStClientMonth();

    int deleteStClientMonthById(Long id);

    /**
     * 查询全部农户年统计
     *
     * @return 实体集合
     */
    List<VoStClientAmountYear> selectAllStClientYear();

    int deleteStClientYearById(Long id);

}