zjh20250110

zjh

2025-01-10 308589effc0fe60876a5794571ede0c211cc828c

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

@@ -144,6 +144,7 @@
            "   parent_pro_id,\n" +
            "   parent_pro_name,\n" +
            "   ord_price,\n" +
            "   discount,\n" +
            "   now_price,\n" +
            "   create_time,\n" +
            "   pro_check_method,\n" +
@@ -158,9 +159,9 @@
            "\tc.pro_name,\n" +
            "\tb.pro_id,\n" +
            "\tb.pro_name,\n" +
            "\tTRUNCATE(c.pro_price,2),\n" +
            "\tTRUNCATE(c.pro_price,2),\n" +
//            " IFNULL(TRUNCATE(c.pro_price * (TRUNCATE ( a.price_now / b.pro_price, 5 )),2),0), " +
            "\t(c.pro_price * c.sl),\n" +
            "\ta.limits,\n" +
            "\t((c.pro_price * c.sl) * (a.limits/10)),\n" +
            "\tSYSDATE(),\n" +
            "\tc.pro_check_method,\n" +
            "\tIFNULL(c.pro_type,''),\n" +
@@ -179,7 +180,7 @@
            "(cus_id, pro_id, pro_name, parent_pro_id, parent_pro_name, ord_price, now_price, create_time, pro_check_method, pro_type,card_id ) \n" +
            "SELECT\n" +
            "#{cusId},\n" +
            "a.pro_id,a.pro_name,b.pro_id,b.pro_name,a.pro_price,a.pro_price,SYSDATE(),a.pro_check_method,\n" +
            "a.pro_id,a.pro_name,b.pro_id,b.pro_name,a.pro_price * a.sl,a.pro_price * a.sl,SYSDATE(),a.pro_check_method,\n" +
            "IFNULL ( a.pro_type, '' ), \n" +
            "#{cardId}\n" +
            "FROM\n" +
@@ -211,9 +212,9 @@
            "c.pro_name,\n" +
            "b.pro_id,\n" +
            "b.pro_name,\n" +
            "c.pro_price,\n" +
            "(c.pro_price * c.sl),\n" +
            "a.limits,\n" +
            "c.pro_price * (a.limits/10),\n" +
            "((c.pro_price * c.sl) * (a.limits/10)),\n" +
            "SYSDATE(),\n" +
            "c.pro_check_method,\n" +
            "c.pro_type\n" +
@@ -249,9 +250,9 @@
            "c.pro_name,\n" +
            "b.pro_id,\n" +
            "b.pro_name,\n" +
            "c.pro_price,\n" +
            "(c.pro_price * c.sl),\n" +
            "a.limits,\n" +
            "(c.pro_price * (a.limits/10)),\n" +
            "((c.pro_price * c.sl) * (a.limits/10)),\n" +
            "SYSDATE(),\n" +
            "c.pro_check_method,\n" +
            "c.pro_type,\n" +