package com.dy.pipIrrGlobal.daoSt;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.dy.pipIrrGlobal.pojoSt.StConsumeIcDay;
|
import com.dy.pipIrrGlobal.voSt.VoIcConsumeStatistics;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
|
import java.util.List;
|
|
/**
|
* @Author: liurunyu
|
* @Date: 2024/12/25 18:07
|
* @Description
|
*/
|
@Mapper
|
public interface StConsumeIcDayMapper extends BaseMapper<StConsumeIcDay> {
|
/**
|
* delete by primary key
|
*
|
* @param id primaryKey
|
* @return deleteCount
|
*/
|
int deleteByPrimaryKey(Long id);
|
|
/**
|
* insert record to table
|
*
|
* @param record the record
|
* @return insert count
|
*/
|
int insert(StConsumeIcDay record);
|
|
/**
|
* insert record to table selective
|
*
|
* @param record the record
|
* @return insert count
|
*/
|
int insertSelective(StConsumeIcDay record);
|
|
/**
|
* select by primary key
|
*
|
* @param id primary key
|
* @return object by primary key
|
*/
|
StConsumeIcDay selectByPrimaryKey(Long id);
|
|
/**
|
* update record selective
|
*
|
* @param record the updated record
|
* @return update count
|
*/
|
int updateByPrimaryKeySelective(StConsumeIcDay record);
|
|
/**
|
* update record
|
*
|
* @param record the updated record
|
* @return update count
|
*/
|
int updateByPrimaryKey(StConsumeIcDay record);
|
|
///////////////////////////////
|
//统计相关
|
/**
|
* 指定年指定月的各农户各IC卡统计
|
* @param year
|
* @param month
|
* @return
|
*/
|
List<VoIcConsumeStatistics> statisticsByIc(@Param("year")Integer year, @Param("month")Integer month) ;
|
|
/**
|
* 查询指定农户指定IC卡指定年指定月的各日统计
|
*
|
* @param clientId
|
* @param cardId
|
* @param year
|
* @param month
|
* @return
|
*/
|
List<StConsumeIcDay> selectByClientAndCardAndYearAndMonth(@Param("clientId")Long clientId,
|
@Param("cardId")Long cardId,
|
@Param("year")Integer year,
|
@Param("month")Integer month);
|
|
|
}
|
