SignReportMappper.java 969 Bytes
package com.ruoyi.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.domain.dss.app.entity.SignReportGroupByDay;
import com.ruoyi.domain.dss.app.vo.SignReportGroupByVo;
import com.ruoyi.domain.dss.app.vo.SignReportVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.Collection;
import java.util.List;

@Mapper
public interface SignReportMappper extends BaseMapper<SignReportVo> {
    SignReportVo querySignReport(@Param("dateStr") String dateStr);

    List<SignReportGroupByDay> querySignReportGroupByDayOfError(@Param("dateStr") String dateStr, @Param("startVal") Integer startVal, @Param("endVal") Integer endVal,@Param("alcoholVal")  Integer alcoholVal);

    List<SignReportGroupByDay> querySignReportAlcoholGroupByDay(@Param("dateStr") String dateStr);

    List<SignReportGroupByVo> querySignReportAlcoholMonthGroupByDay(@Param("dateStrs") Collection<String> dateStrs);
}