zjh202412013

zjh

2024-12-13 0ded4eb80a80ffd4f29aab8a7b6c02a269d72d2c

 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java

@@ -113,6 +113,7 @@
            "SELECT\n" +
            "            pro.pro_id,\n" +
            "            dep.dept_name,\n" +
            "            dep.dept_id,\n" +
            "            pro.pro_name,\n" +
            "            re.type,\n" +
            "            us.nick_name doctor_name,\n" +
@@ -186,4 +187,11 @@


    void tjYishengjianchajianyi(Map<String,Object> map);


    @Select("SELECT COUNT(*) a FROM tj_order_remark a WHERE a.deleted=0 AND a.tj_number=#{tjNum} AND a.type =1;")
    int panduaniscunzaiweijian(String tjNum);

    @Select("SELECT COUNT(*) a FROM tj_order_remark a WHERE a.deleted=0 AND a.tj_number=#{tjNum} AND a.type in(0,3);")
    int panduaniswancheng(String tjNum);
}