修改查询为父项

zhaowenxuan

2024-10-16 ccd9b262d4e1949ab2456cda9326ead93362c14d

修改查询为父项

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

@@ -237,6 +237,6 @@

    @Select("SELECT a.* FROM tj_order_detail a LEFT JOIN tj_project b ON a.pro_id=b.pro_id\n" +
            "LEFT JOIN sys_dept c ON c.dept_id=b.dept_id AND c.org_type=1\n" +
            " WHERE a.deleted=0 AND !ISNULL(a.flowing_water_id) AND a.order_id=#{orderId}")
            " WHERE a.deleted=0 AND !ISNULL(a.flowing_water_id) AND a.order_id=#{orderId} and b.pro_parent_id = 0")
    List<TjOrderDetail> getCaiYangDengJi(Long orderId);
}