zjh
2023-12-29 beca2c01d4f104ef145bbee9fa91aac2957ef360
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
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);
}