manailin
2022-09-21 d6aabd981bf80cd57c09819f42b1c4e79f1904f9
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComEventMapper.java
@@ -3,11 +3,17 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.panzhihua.common.model.dtos.community.sanshuo.IndexDateDTO;
import com.panzhihua.common.model.vos.IndexDataVO;
import com.panzhihua.common.model.vos.sanshuo.ComEventCalculateVO;
import com.panzhihua.common.model.vos.sanshuo.EventRateVO;
import com.panzhihua.common.model.vos.sanshuo.IndexDateVO;
import com.panzhihua.common.model.vos.sanshuo.MediateTypeVO;
import com.panzhihua.service_community.entity.ComEvent;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import java.util.Date;
import java.util.List;
/**
 * 三说会堂事件表Mapper
@@ -39,4 +45,45 @@
   List<ComEvent> listByComEvent(@Param("comEvent") ComEvent comEvent);
    List<ComEventCalculateVO> calculate();
    /**
     * 大屏事件统计
     * @param indexDateDTO
     * @return 处理结果
     * @author zhangtiansen
     * */
    IndexDateVO dateAnalysis(@Param("dto") IndexDateDTO indexDateDTO,@Param("beginDate") Date beginDate, @Param("endDate")Date endDate);
    /**
     * 大屏事件统计-月新增
     * @param beginDate 开始时间
     * @param endDate 结束时间
     * @author zhangtiansen
     * */
    Integer dateAnalysisY(@Param("beginDate") Date beginDate, @Param("endDate")Date endDate, @Param("dto") IndexDateDTO indexDateDTO);
    /**
     * 大屏事件统计-月办结
     * @param beginDate 开始时间
     *  @param endDate 结束时间
     * @author zhangtiansen
     * */
    Integer dateAnalysisYTwo(@Param("beginDate")Date beginDate,@Param("endDate")Date endDate,@Param("dto") IndexDateDTO indexDateDTO);
    /**
     * 大屏事件级别统计
     * */
    List<EventRateVO> eventRate();
    /**
     * 大屏统计-专家级别占比
     * */
    List<EventRateVO> expertRate();
    /**
     * 大屏统计-事件类型占比
     * */
    List<EventRateVO> mediateTypeRate();
}