src/main/resources/mapper/InOutOrderListDao.xml

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.dao.InOutOrderListDao">

    <!-- 通用查询结果列 -->
    <sql id="Base_Column_List">
        a.id as id
        ,a.in_out_order_id as inOutOrderId
        ,a.goods_id as goodsId
        ,a.order_number as orderNumber
        ,a.create_time as createTime
    </sql>
    <select id="selectListView" parameterType="map" resultType="com.entity.view.InOutOrderListView" >
        SELECT
        <include refid="Base_Column_List" />

--         级联表的字段
        ,goods.goods_name as goodsName
        ,goods.goods_types as goodsTypes
        ,goods.goods_number as goodsNumber
        ,goods.goods_photo as goodsPhoto
        ,goods.danwei as danwei
        ,goods.goods_content as goodsContent
        ,goods.flag as flag
        ,inOutOrder.order_name as orderName
        ,inOutOrder.caozuo_name as caozuoName
        ,inOutOrder.caozuo_table as caozuoTable
        ,inOutOrder.order_types as orderTypes
        ,inOutOrder.insert_time as insertTime

        FROM in_out_order_list  a
        left JOIN goods goods ON a.goods_id = goods.id
        left JOIN in_out_order inOutOrder ON a.in_out_order_id = inOutOrder.id

        <where>
            <if test="params.inOutOrderId != null">
                and a.in_out_order_id = #{params.inOutOrderId}
            </if>
            <if test="params.goodsId != null">
                and a.goods_id = #{params.goodsId}
            </if>
            <if test="params.orderNumberStart != null">
                <![CDATA[  and a.order_number >= #{params.orderNumberStart}   ]]>
            </if>
            <if test="params.orderNumberEnd != null">
                <![CDATA[  and a.order_number <= #{params.orderNumberEnd}   ]]>
            </if>

            <if test=" params.goodsName != '' and params.goodsName != null and params.goodsName != 'null' ">
                and goods.goods_name like CONCAT('%',#{params.goodsName},'%')
            </if>
            <if test="params.goodsTypes != null">
                and goods.goods_types = #{params.goodsTypes}
            </if>

            <if test="params.goodsNumberStart != null ">
                <![CDATA[  and goods.goods_number >= #{params.goodsNumberStart}   ]]>
            </if>
            <if test="params.goodsNumberEnd != null ">
                <![CDATA[  and goods.goods_number <= #{params.goodsNumberEnd}   ]]>