package com.panzhihua.service_community.dao;
|
|
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.vos.community.ComActActEvaluateExcelVO;
|
import com.panzhihua.common.model.vos.community.ComActActRegistExcelVO;
|
import com.panzhihua.common.model.vos.community.ComActActRegistVO;
|
import com.panzhihua.service_community.entity.JinhuiCoinGeneralTable;
|
import com.panzhihua.service_community.model.dos.ComActActRegistDO;
|
import com.panzhihua.service_community.model.dos.ComActActivityDO;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
|
import java.util.Date;
|
import java.util.List;
|
|
/**
|
* title: ComActActRegistDAO 社区》活动》活动签到表mapper类
|
* projectName 成都呐喊信息技术有限公司-智慧社区项目
|
* description: 社区》活动》活动签到表mapper类
|
*
|
* @author txb
|
* @date 2021/8/24 10:21
|
*/
|
@Mapper
|
public interface ComActActRegistDAO extends BaseMapper<ComActActRegistDO> {
|
|
|
IPage<ComActActRegistVO> pageActivityRegists(Page page, @Param("comActActRegistVO") ComActActRegistVO comActActRegistVO);
|
|
List<ComActActRegistExcelVO> getRegistLists(@Param("comActActRegistVO") ComActActRegistVO comActActRegistVO);
|
|
List<ComActActRegistExcelVO> getNoRegistLists(@Param("comActActRegistVO") ComActActRegistVO comActActRegistVO);
|
|
/**
|
* 活动签到记录
|
* @param id 活动主键
|
* @param userId 用户id
|
* @return
|
*/
|
List<ComActActRegistVO> listRegistRecord(@Param("id") Long id, @Param("userId") Long userId);
|
|
/**
|
* 获取总积分奖励
|
* @param activityId
|
* @param userId
|
* @return
|
*/
|
Integer selectTotalAwardWithRegist(@Param("activityId") Long activityId, @Param("userId") Long userId);
|
|
JinhuiCoinGeneralTable getDetails(@Param("userId") String userIdv);
|
|
|
/**
|
* 获取未签退的活动id
|
* @return
|
*/
|
List<String> getNotTimeActivityList();
|
|
/**
|
* 根据活动id获取没有签退的人员记录
|
* @param activityId
|
* @return
|
*/
|
List<ComActActRegistVO> getNotTimeUser(@Param("activityId") String activityId);
|
|
/**
|
* 根据活动id获取活动结束时间
|
* @param activityId
|
* @return
|
*/
|
ComActActivityDO getActivityEndTime(@Param("activityId") String activityId);
|
|
/**
|
* 更新签退时间
|
* @param id
|
* @param data
|
* @return
|
*/
|
int updateEndTime(@Param("id") String id, @Param("data") Date data);
|
|
|
}
|
