zjh 2023/10/26--1

zjh

2023-10-26 cdadbb79336316018fb890d0e7121ae99ea2be4f

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

@@ -69,4 +69,16 @@
            "\n" +
            "    tj_flowing_water b ON a.order_id = b.order_id WHERE a.tj_number =#{tjNum} AND a.deleted='0' AND b.deleted='0'")
    List<String> getFlowingWaterIds(String tjNum);

    @Select("\tSELECT a.discount/10 FROM tj_flowing_water a WHERE 1=1 AND a.deleted =0 AND  a.order_id=#{orderId} AND a.discount !='/'")
    String getDiscount(String orderId);


//    @Select("\tSELECT GROUP_CONCAT(b.pro_name ) proname FROM tj_order_detail a \n" +
//            "    LEFT JOIN tj_project b ON a.pro_id=b.pro_id \n" +
//            "\t WHERE a.order_id=#{orderId}")
//    String getproNameByOrderId(String orderId);

    @Select("SELECT GROUP_CONCAT(a.pro_name ) proname FROM tj_charging_standard a WHERE a.tj_num=#{orderId}")
    String getproNameByOrderId(String orderId);
}