src/main/resources/mapper/EntrustInOutOrderDao.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.EntrustInOutOrderDao">

    <!-- 通用查询结果列 -->
    <sql id="Base_Column_List">
        a.id as id
        ,a.yonghu_id as yonghuId
        ,a.order_name as orderName
        ,a.order_types as orderTypes
        ,a.insert_time as insertTime
        ,a.caozuo_name as caozuoName
        ,a.caozuo_table as caozuoTable
        ,a.caozuo_types as caozuoTypes
        ,a.update_time as updateTime
        ,a.create_time as createTime
    </sql>
    <select id="selectListView" parameterType="map" resultType="com.entity.view.EntrustInOutOrderView" >
        SELECT
        <include refid="Base_Column_List" />

--         级联表的字段
        ,yonghu.username as username
        ,yonghu.password as password
        ,yonghu.name as name
        ,yonghu.phone as phone
        ,yonghu.id_number as idNumber
        ,yonghu.sex_types as sexTypes
        ,yonghu.my_photo as myPhoto
        ,yonghu.nation as nation
        ,yonghu.politics_types as politicsTypes
        ,yonghu.birthplace as birthplace

        FROM entrust_in_out_order  a
        left JOIN yonghu yonghu ON a.yonghu_id = yonghu.id

        <where>
            <if test="params.yonghuId != null">
                and a.yonghu_id = #{params.yonghuId}
            </if>
            <if test=" params.orderName != '' and params.orderName != null and params.orderName != 'null' ">
                and a.order_name like CONCAT('%',#{params.orderName},'%')
            </if>
            <if test="params.orderTypes != null">
                and a.order_types = #{params.orderTypes}
            </if>
            <if test=" params.insertTimeStart != '' and params.insertTimeStart != null ">
                <![CDATA[  and DATE_FORMAT(a.insert_time, '%Y-%m-%d %H:%T:%s') >=
                DATE_FORMAT(#{params.insertTimeStart}, '%Y-%m-%d %H:%T:%s')   ]]>
            </if>
            <if test=" params.insertTimeEnd != '' and params.insertTimeEnd != null ">
                <![CDATA[  and DATE_FORMAT(a.insert_time, '%Y-%m-%d %H:%T:%s') <=
                DATE_FORMAT(#{params.insertTimeEnd} , '%Y-%m-%d %H:%T:%s')    ]]>
            </if>
            <if test=" params.caozuoName != '' and params.caozuoName != null and params.caozuoName != 'null' ">
                and a.caozuo_name like CONCAT('%',#{params.caozuoName},'%')
            </if>
            <if test=" params.caozuoTable != '' and params.caozuoTable != null and params.caozuoTable != 'null' ">
                and a.caozuo_table like CONCAT('%',#{params.caozuoTable},'%')
            </if>