package com.mindskip.xzs.repository;

import com.mindskip.xzs.domain.other.KeyValue;
import com.mindskip.xzs.domain.Question;
import com.mindskip.xzs.domain.other.QuestionRandom;
import com.mindskip.xzs.viewmodel.admin.question.QuestionPageRequestVM;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.Date;
import java.util.List;

/**
 * @version 2.2.0
 * @description: 题目
 * Copyright (C), 2020-2021, 武汉思维跳跃科技有限公司
 * @date 2021 /9/7 9:45
 */
@Mapper
public interface QuestionMapper extends BaseMapper<Question> {
    int deleteByPrimaryKey(Integer id);

    int insert(Question record);

    int insertSelective(Question record);

    Question selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(Question record);

    int updateByPrimaryKey(Question record);

    /**
     * 题目分页
     *
     * @param requestVM the request vm
     * @return the list
     */
    List<Question> page(QuestionPageRequestVM requestVM);

    /**
     * 根据id获取题目
     *
     * @param ids the ids
     * @return the list
     */
    List<Question> selectByIds(@Param("ids") List<Integer> ids);

    /**
     * 获取所有题目数量
     *
     * @return the integer
     */
    Integer selectAllCount();

    /**
     * 获取时间段内题目数量
     *
     * @param startTime the start time
     * @param endTime   the end time
     * @return the list
     */
    List<KeyValue> selectCountByDate(@Param("startTime") Date startTime, @Param("endTime") Date endTime);

    /**
     * 获取用户创建的题目数量
     *
     * @param userId the user id
     * @return the integer
     */
    Integer selectAllCountByCreate(@Param("userId") Integer userId);

    /**
     * 随机获取题目数量
     *
     * @param questionRandom the question random
     * @return the list
     */
    List<Integer> randomQuestion(QuestionRandom questionRandom);

}