后端 sql mapper接口自己想吧,这个只要会写,不难
service:
List<Integer> getInquiryIdList(String question);
List<String> getInquiryNameList(String question);
serviceImpl:
private final InquiryTypeInfoMapper inquiryTypeInfoMapper;
@Override
public List<String> getInquiryNameList(String question) {
List<InquiryTypeInfo> inquiryList = inquiryTypeInfoMapper.getFaqByHelpId(question);
return inquiryList.stream().map(inquiry -> inquiry.getInquiryTypeNm()).collect(Collectors.toList());
}
@Override
public List<Integer> getInquiryIdList(String question) {
List<InquiryTypeInfo> inquiryList = inquiryTypeInfoMapper.getFaqByHelpId(question);
return inquiryList.stream().map(inquiry -> inquiry.getInquiryTypeCd()).collect(Collectors.toList());
}
collectorl:在检索当前页面方法里
page.getRecords().stream().map(h -> {
h.setQuestionType((inquiryTypeInfoService.getInquiryIdList(h.getQuestion()).get(0)).toString());
h.setInquirys(inquiryTypeInfoService.getInquiryNameList(h.getQuestion()));
return h;
}).collect(Collectors.toList());
vue:
el-table-column :
<template slot-scope="{row}">
{{ row.inquirys | questionTypeVal}}
</template>
filters:
questionTypeVal(inquirys) {
return inquirys.join(', ')
}