增加查询外送视图

zhaowenxuan

2025-03-21 5f1974fd878eb77fdfa4ecada3ae95a8b5e09831

增加查询外送视图

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

@@ -311,8 +311,8 @@
            "  NULL tdh,\n" +
            "  a.RESULT jyjg,\n" +
            "  a.UNIT jgdw,\n" +
            "  a.RANGEDOWN fwzdz,\n" +
            "  a.RANGEUP fwzgz,\n" +
            "  a.RANGEDOWN fwzgz,\n" +
            "  a.RANGEUP fwzdz,\n" +
            "  CONCAT(a.RANGEDOWN,'-',a.RANGEUP) fwz,\n" +
            "  b.CHECKDATE jysj,\n" +
            "  b.CHECKER jyys,\n" +
@@ -491,4 +491,10 @@
    @DataSource(value = DataSourceType.MASTER)
    @Select("call tj_bingzhongtongji(#{p_start,mode=IN},#{p_end,mode=IN})")
    List<Map<String ,Object>> getBingZhongInfo(@Param("p_start") String start,@Param("p_end") String end);

    @Select("SELECT * FROM v_ws_sqd WHERE tjh = #{tjh}")
    List<LtkjHysqd> getWsHySqdByView(@Param("tjh") String tjh);

    @Select("SELECT * FROM v_ws_bgd WHERE tmh = #{tjh}")
    List<LtkjHybgd> getWsHyBgdByView(@Param("tmh") String tmh);
}