parent: 54e2adf7 | patch | commit | ignore whitespace
xin
2025-09-12 062031e137b3077bd0bacaaccbb5b9e54cc3b75a 
订单退单sql
2 files modified
5 ■■■■■ changed files
oying-system/src/main/resources/mapper/sh/OrderMapper.xml 2 ●●●●● patch | view | raw | blame | history
oying-system/src/main/resources/mapper/sh/OrderReturnMapper.xml 3 ●●●●● patch | view | raw | blame | history 
 oying-system/src/main/resources/mapper/sh/OrderMapper.xml


@@ -127,7 +127,7 @@


                or p.product_name like concat('%',#{blurry},'%')


                or p.product_title like concat('%',#{blurry},'%')


                or p.product_description like concat('%',#{blurry},'%')


                or o.orderNum like concat('%',#{blurry},'%')


                or o.order_num like concat('%',#{blurry},'%')


                or o.order_describe like concat('%',#{blurry},'%')


                or o.username like concat('%',#{blurry},'%'))


            </if>




 oying-system/src/main/resources/mapper/sh/OrderReturnMapper.xml


@@ -124,8 +124,7 @@


                or p.product_name like concat('%',#{blurry},'%')


                or p.product_title like concat('%',#{blurry},'%')


                or p.product_description like concat('%',#{blurry},'%')


                or o.orderNum like concat('%',#{blurry},'%')


                or o.order_describe like concat('%',#{blurry},'%')


                or o.return_num like concat('%',#{blurry},'%')


                or o.username like concat('%',#{blurry},'%')


                or o.order_num like concat('%',#{blurry},'%'))


            </if>