| | |
|---|
| | | |
|---|
| | | //存储过程专用接口(初审) |
|---|
| | | List<List<?>> getCsCunChuGuoChengCustomerList(Map<String,Object> map); |
|---|
| | | |
|---|
| | | |
|---|
| | | @Select("SELECT count(*) FROM tj_order a WHERE a.deleted=0 and a.card_id=#{cardId}") |
|---|
| | | int selectTjOrderByCardId(String cardId); |
|---|
| | | |
|---|
| | | |
|---|
| | | @Select("SELECT a.card_id FROM tj_order a WHERE a.deleted=0") |
|---|
| | | List<String> selectTjOrderByCardId1(); |
|---|
| | | |
|---|
| | | |
|---|
| | | @Select("SELECT a.order_id FROM tj_order_detail a WHERE a.order_id=#{orderId} AND !ISNULL(a.flowing_water_id) GROUP BY a.order_id ") |
|---|
| | | String isPayByTjNum(String orderId); |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 查询导检单详情 |
|---|
| | | * @param tjNumber 体检单号 |
|---|
| | | * @return |
|---|
| | | */ |
|---|
| | | @Select("SELECT @num := @num + 1 AS xh, d.dept_name ksmc, d.official_web ksdz, e.tjxm FROM sys_dept d JOIN ( select aa.ksmc,GROUP_CONCAT( DISTINCT aa.pro_name ORDER BY aa.pro_name DESC SEPARATOR ';' ) tjxm from ( SELECT (case when f.ksmc in ('临检室','化验室','','') or c.pro_name like '%测定%' then '检验科' when c.pro_name like '%心电图%' then '心电图室' when f.ksmc='x光室' or c.pro_name like '%X线摄影%' then '放射科' when c.pro_name like '%色觉%' then '眼科' \t\t\t\twhen c.pro_name like '%超%' or c.pro_name like '%多普勒%' then 'B超室' when (replace(f.ksmc,' ','')='' or f.ksmc is null) and c.dept_id<>'100' then d.dept_name when c.pro_name like '%CT%' then 'CT室' else '体检中心' end ) ksmc, c.pro_name FROM tj_order a JOIN tj_order_detail b ON b.order_id = a.order_id JOIN tj_project c ON c.pro_id = b.pro_id left join his_mxfyxm e on e.mxfyxmbm=c.his_xmbm left join ltkj_his_dept f on f.ksbm = CONCAT('00',(case when e.hsks is null then '' else e.hsks end)) join sys_dept d on d.dept_id=c.dept_id WHERE a.tj_number = #{tjNumber} ) aa GROUP BY ksmc ) e ON e.ksmc = d.dept_name , (SELECT @num := 0) a WHERE d.parent_id = '100' ORDER BY xh") |
|---|
| | | List<Map<String ,String >> selectDjdInfo(@Param("tjNumber")String tjNumber); |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 查询导检单用户信息 |
|---|
| | | * @param tjNumber |
|---|
| | | * @return |
|---|
| | | */ |
|---|
| | | @Select("select c.tj_number tjh,a.cus_name tjname, b.dict_label sex,a.create_time tjsj,ifnull(d.cn_name,'') dwmc,a.cus_phone lxdh\n" + |
|---|
| | | "from tj_order c \n" + |
|---|
| | | " join tj_customer a on a.cus_id= c.user_id \n" + |
|---|
| | | " join (select dict_value,dict_label from sys_dict_data where dict_type='sys_user_sex') b on b.dict_value = a.cus_sex\n" + |
|---|
| | | " left join dict_comp d on d.drug_manufacturer_id = c.firm_id\n" + |
|---|
| | | "where c.tj_number=#{tjNumber}") |
|---|
| | | Map<String ,Object > selectDjdUserInfo(@Param("tjNumber")String tjNumber); |
|---|
| | | } |
|---|
