museum_dali/gis_mapper/src/main/java/com/gis/mapper/QuestionGroupMapper.java

package com.gis.mapper;


import com.gis.domain.po.QuestionGroupEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.springframework.stereotype.Component;

@Component
@Mapper
public interface QuestionGroupMapper extends IBaseMapper<QuestionGroupEntity, Long> {


    @Update("update tb_question_group set display = 0 , update_time = NOW() where is_delete = 0")
    void disableAll();

    @Update("update tb_question_group set display = 1 , update_time = NOW() where is_delete = 0 and id=#{id}")
    void enabledById(Long id);

    @Select("select id from tb_question_group where is_delete=0 and display=1")
    Long findByIndex();
}