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

package com.gis.mapper;


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

import java.util.List;

@Component
@Mapper
public interface QuestionMapper extends IBaseMapper<QuestionEntity, Long> {


    @Update("update tb_question set is_delete = 1 , update_time = NOW() where is_delete = 0 and question_group_id=#{questionGroupId} ")
    void removeByQuestionGroupId(Long questionGroupId);

    @Select("select * from tb_question where is_delete=0 and question_group_id=#{questionGroupId}")
    List<QuestionEntity> findByQuestionGroupId(Long questionGroupId);

    @Update("update tb_question set question_group_id = #{questionGroupId} , update_time = NOW() where is_delete = 0 and id in ( ${questionIds} ) ")
    void updateQuestionGroupId(Long questionGroupId, String questionIds);

    @Update("update tb_question set question_group_id = 0 , update_time = NOW() where is_delete = 0 and question_group_id=#{questionGroupId} ")
    void disableByQuestionGroupId(Long groupId);
}