target/classes/mapper/EntrustInOutOrderListDao.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.EntrustInOutOrderListDao">

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

--         级联表的字段
        ,entrustInOutOrder.yonghu_id as yonghuId
        ,entrustInOutOrder.order_name as orderName
        ,entrustInOutOrder.order_types as orderTypes
        ,entrustInOutOrder.insert_time as insertTime
        ,entrustInOutOrder.caozuo_name as caozuoName
        ,entrustInOutOrder.caozuo_table as caozuoTable
        ,entrustInOutOrder.caozuo_types as caozuoTypes
        ,entrustInOutOrder.update_time as updateTime
        ,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

        FROM entrust_in_out_order_list  a
        left JOIN entrust_in_out_order entrustInOutOrder ON a.entrust_in_out_order_id = entrustInOutOrder.id
        left JOIN goods goods ON a.goods_id = goods.id

        <where>
            <if test="params.entrustInOutOrderId != null">
                and a.entrust_in_out_order_id = #{params.entrustInOutOrderId}
            </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.entrustTypes != null">
                and a.entrust_types = #{params.entrustTypes}
            </if>

            <if test="params.yonghuId != null">
                and entrustInOutOrder.yonghu_id = #{params.yonghuId}
            </if>
            <if test=" params.orderName != '' and params.orderName != null and params.orderName != 'null' ">
                and entrustInOutOrder.order_name like CONCAT('%',#{params.orderName},'%')