zjh 2024/05/23-1

zjh

2024-05-23 d89bdcd93aff8d94d3b3b50dbf866eafc1f58bac

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

@@ -55,6 +55,11 @@
     */
    public int deleteTjOrderDetailByOrderDetailId(String orderDetailId);

    @Delete("    delete\n" +
            "        from tj_order_detail\n" +
            "        where order_id = #{orderId}")
    int deleteTjOrderDetailByOrderId(String orderId);

    /**
     * 批量删除体检项目明细
     *
@@ -68,14 +73,14 @@
     * 查询已缴费项目
     */
    @Select("SELECT * FROM tj_project p WHERE p.pro_parent_id =0 AND p.pro_id IN (\n" +
            "  SELECT a.pro_id FROM tj_order_detail a WHERE !ISNULL(flowing_water_id) AND order_id=#{orderId})")
            "  SELECT a.pro_id FROM tj_order_detail a WHERE !ISNULL(flowing_water_id) AND order_id=#{orderId} and a.deleted=0 )")
    public List<TjProject> selectTjOrderDetailListByFlowingWaterIdIsNotNull(String orderId);

    /**
     * 查询未缴费项目
     */
    @Select("SELECT * FROM tj_project p WHERE p.pro_parent_id =0 AND p.pro_id IN (\n" +
            "  SELECT a.pro_id FROM tj_order_detail a WHERE ISNULL(flowing_water_id) AND order_id=#{orderId})")
            "  SELECT a.pro_id FROM tj_order_detail a WHERE ISNULL(flowing_water_id) AND order_id=#{orderId} and a.deleted=0 )")
    public List<TjProject> selectTjOrderDetailListByFlowingWaterIdIsNull(String orderId);