package com.ltkj.hosp.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ltkj.hosp.domain.TjAdvice;
import com.ltkj.hosp.domain.TjAskHistorys;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @Company: 西安路泰科技有限公司
 * @Author: lige
 * @Date: 2023/4/11 17:53
 */
@Mapper
public interface TjAskHistorysMapper extends BaseMapper<TjAskHistorys> {


    @Select({"<script>", "select", "GROUP_CONCAT(pro_name ORDER BY pro_name) AS names", "from dict_zhengzhuang", "where id in",
            "<foreach collection='ids' item='id' open='(' separator=',' close=')'>",
            "#{id}",
            "</foreach>",
            "</script>" })
    String getZhengZhuangStr(@Param("ids")List<String> ids);
}