<!--查找某用户绑定的药物不良反应报告列表-->
<select id="selectSurveyListByUserProId" resultType="java.util.HashMap">
SELECT id AS `id`,time AS `time`,
usr_no AS `id_card_num`,
creat_usr_no AS `creat_usr_no`
FROM xy_survey
<where>
<foreach collection="list" index="index" item="userProIdmap" open="(" separator="," close=")">
<if test="userProIdmap != null">
<if test="userProIdmap.SerialNum != null and userProIdmap.SerialNum != ''"><!-- 注意and不能大写 -->
SerialNum = #{userProIdmap.SerialNum}
</if>
<if test="userProIdmap.company_id != null and userProIdmap.company_id != ''">
and company_id = #{userProIdmap.company_id}
</if>
<if test="userProIdmap.usr_no != null and userProIdmap.usr_no != ''">
and creat_usr_no = #{userProIdmap.usr_no}
</if>
</if>
</foreach>

</where>

GROUP BY id, time, usr_no, creat_usr_no
UNION
SELECT id AS `id`,
time AS `time`,
id_card_num AS `id_card_num`,
creat_usr_no AS `creat_usr_no`
FROM xy_survey_temp
<where>
<foreach collection="list" index="index" item="userProIdmap" open="(" separator="," close=")">
<if test="userProIdmap != null">
<if test="userProIdmap.SerialNum != null and userProIdmap.SerialNum != ''"><!-- 注意and不能大写 -->
SerialNum = #{userProIdmap.SerialNum}
</if>
<if test="userProIdmap.company_id != null and userProIdmap.company_id != ''">
and company_id = #{userProIdmap.company_id}
</if>
<if test="userProIdmap.usr_no != null and userProIdmap.usr_no != ''">
and creat_usr_no = #{userProIdmap.usr_no}
</if>
</if>
</foreach>

</where>
GROUP BY id, time, id_card_num, creat_usr_no
ORDER BY `time` DESC
</select>

<!-- 查询临时表获取主用户上传报告的患者数量，根据身份证号去除重复,参数 产品编号，公司id -->
<select id="findCountPersonNumXySurveyTemp" resultType="java.util.Map">
select id_card_num,SerialNum,company_id from xy_survey_temp where SerialNum in

<foreach collection="list" index="index" item="temps" open="(" separator="," close=")">
<if test="temps != null">
<if test="temps.SerialNum != null and temps.SerialNum !=''">
#{temps.SerialNum}
</if>

</if>
</foreach>
and company_id in
<foreach collection="list" index="index" item="temps" open="(" separator="," close=")">
<if test="temps != null">
<if test="temps.company_id != null and temps.company_id !=''">
#{temps.company_id}
</if>
</if>
</foreach>
group by id_card_num,SerialNum,company_id

</select>

最新文章

1. oracle11gR2静默安装
2. 救援linux
3. Oracle 物理备份--rman
4. [Cocoa设计模式] 动态创建
5. zoj 3888 线段树 ***
6. ArcGIS Server 10.1 错误 service failed to start,
7. iOS之 PJSIP静态库编译（三）
8. background-size background-positon合并的写法
9. js之动态加载等待图像地址汇总
10. ubuntu查看安装的cuda toolkit自带的工具及其他安装文件
11. 阻止form空表单提交----JavaScript
12. JavaScript树(一) 简介
13. 【JAVA】pdf转图片
14. API创建员工地址
15. 【Unity Shaders】Using Textures for Effects —— 实现Photoshop的色阶效果
16. java字符串对象存储机制
17. c/c++ 标准库 bind 函数 详解
18. 0005-20180422-自动化第六章-python基础学习笔记
19. [转]MySQL函数大全 及用法示例
20. openwrt MT7620 固件编译记录

热门文章

1. 冲刺随笔——Day_One
2. 小样本元学习综述：A Concise Review of Recent Few-shot Meta-learning Methods
3. 20190626_二次开发BarTender打印机_C#代码_一边读取TID_一边打印_打印机POSTEK
4. MySQL索引（二）：建索引的原则
5. PyQt学习随笔：Model/View架构中多个视图之间选择数据项同步
6. PyQt(Python+Qt)学习随笔：Qt Designer中部件的三个属性sizeHint缺省尺寸、minimumSizeHint建议最小尺寸和minimumSize最小尺寸
7. Flask学习 url和视图
8. 揭秘 VMAF 视频质量评测标准
9. css外边距重叠及避免方法
10. 【译】为什么Rust中的BTreeMap没有with_capacity()方法？