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);
}