| | |
| | | " AND sr.create_at <![CDATA[<=]]> #{pageComShopOrderSearchDTO.createAtEnd} " + |
| | | " </if> " + |
| | | "<if test='pageComShopOrderSearchDTO.orderNo != null '>" + |
| | | " AND sr.order_no = #{pageComShopOrderSearchDTO.orderNo} " + |
| | | " AND sr.order_no like concat('%', #{pageComShopOrderSearchDTO.orderNo}, '%') " + |
| | | " </if> " + |
| | | "<if test='pageComShopOrderSearchDTO.userAccount != null '>" + |
| | | " AND su.phone = #{pageComShopOrderSearchDTO.userAccount} " + |
| | | " AND su.phone like concat('%', #{pageComShopOrderSearchDTO.userAccount}, '%') " + |
| | | " </if> " + |
| | | "<if test='pageComShopOrderSearchDTO.receiverAccount != null '>" + |
| | | " AND uad.name like concat('%', #{pageComShopOrderSearchDTO.receiverAccount}, '%') " + |
| | | " </if> " + |
| | | "<if test='pageComShopOrderSearchDTO.receiverPhone != null '>" + |
| | | " AND uad.phone = #{pageComShopOrderSearchDTO.receiverPhone} " + |
| | | " AND uad.phone like concat('%',#{pageComShopOrderSearchDTO.receiverPhone}, '%') " + |
| | | " </if> " + |
| | | "<if test='pageComShopOrderSearchDTO.goodsName != null'>" + |
| | | " AND og.goods_name like concat('%', #{pageComShopOrderSearchDTO.goodsName}, '%') " + |