package com.ltkj.hosp.mapper;
|
|
import java.util.List;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.ltkj.hosp.domain.TjOrderDetail;
|
import com.ltkj.hosp.domain.TjOrderDetailRules;
|
import com.ltkj.hosp.vodomain.TjRulesStatisticsVo;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
/**
|
* 结果结论数据记录Mapper接口
|
*
|
* @author ltkj_赵佳豪&李格
|
* @date 2023-08-30
|
*/
|
@Mapper
|
public interface TjOrderDetailRulesMapper extends BaseMapper<TjOrderDetailRules> {
|
|
|
@Select({"<script>",
|
"SELECT aa.bingzhong name,COUNT(DISTINCT bb.tj_number) value FROM (SELECT a.Aid, a.bingzhong FROM tj_rules a WHERE a.deleted=0 AND a.Aid IN ",
|
"<foreach collection='aids' item='id' open='(' separator=',' close=')'>",
|
"#{id}",
|
"</foreach>) aa LEFT JOIN" +
|
"(SELECT b.Aid,b.tj_number FROM tj_order_detail_rules b WHERE b.deleted=0 AND b.tj_number IN ",
|
"<foreach collection='tjNums' item='id' open='(' separator=',' close=')'>",
|
"#{id}",
|
"</foreach>) bb ON aa.Aid=bb.Aid GROUP BY aa.Aid",
|
"</script>"})
|
List<TjRulesStatisticsVo> getTjRulesStatisticsByTjNumAndAid(@Param(value = "tjNums") List<String> tjNums,@Param(value = "aids") List<String> aids);
|
}
|
