多条件模糊查询,list作为查询条件

最新推荐文章于 2023-10-06 14:16:46 发布

魏帅奇

最新推荐文章于 2023-10-06 14:16:46 发布

阅读量496

点赞数 2

分类专栏： sql 文章标签： mybatis

本文链接：https://blog.csdn.net/weixin_44279146/article/details/125634901

版权

sql 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

sql

    <select id="selectSellingOrder2" resultType="com.yf.platform.order.bean.orderEntity.SellingOrderPara">
        SELECT
        oob.order_id,
        date_format( oob.order_shipping_time, '%Y-%m-%d %H:%i:%s' ) AS orderShippingTime,
        oob.order_from,
        oob.pay_from,
        oob.order_receiver_name,
        oob.payment_other_number,
        oob.order_create_time,
        oob.order_payment_amount,
        oob.order_status,
        oob.order_refund_status,
        oob.order_return_status,
        oob.payment_number,
        oob.payment_name,
        oob.pay_code,
        oob.payment_time,
        oob.order_shipping_code,
        oob.order_refund_amount,
        oob.order_finished_time,
        oob.order_buyer_evaluation_status,
        oob.shop_id,
        oob.shop_name AS shopNameId,
        oob.buyer_user_id,
        oob.buyer_user_name,
        oob.order_receiver_address,
        oob.order_receiver_contact,
        oob.groupbuy_status,
        oob.order_message,
        oob.call_waiter_remark,
        oob.songda_time AS songdaTime,
        opv.review_status,
        b.trade_third_party_amount,
        b.trade_payment_recharge_card,
        b.trade_payment_amount,
        ( oob.order_goods_amount + oob.order_shipping_fee - oob.voucher_price ) AS orderAmount
        FROM
        odb_order_base oob
        LEFT JOIN java_pay.pdb_pay_consume_trade b ON b.order_id = oob.order_id
        LEFT JOIN odb_payment_vocher opv ON oob.order_id = opv.order_id
        <where>
            <if test="param.orderId != null and param.orderId != '' ">
                and oob.oob.order_id = #{param.orderId}
            </if>
            <if test="param.buyerUserName != null and param.buyerUserName != ''">
                and oob.buyer_user_name= #{param.buyerUserName}
            </if>
            <if test="param.shopName != null and param.shopName != '' ">
                and oob.shop_name LIKE CONCAT('%',#{param.shopName},'%')
            </if>
            <if test="param.finishTime != null and param.finishTime != '' ">
                and oob.order_create_time <![CDATA[<]]> #{param.finishTime}
            </if>
            <if test="param.airTime != null and param.airTime != '' ">
                and oob.order_create_time <![CDATA[>=]]> #{param.airTime}
            </if>
            <if test="param.shopNameIdList != null and param.shopNameIdList.size>0 ">
                and
                <foreach collection="param.shopNameIdList" open="("  separator="or"  close=")"  item="shopNameId">
                    oob.shop_name  LIKE  CONCAT('%',trim(#{shopNameId}),'%')
                </foreach>
            </if>
        </where>
        order by order_create_time desc limit #{param.cp},#{param.pageSize}
    </select>