gc-user/src/main/resources/mapper/user/JhyInfoMapper.xml

@@ -19,13 +19,13 @@
    </select>

    <select id="selectJhyInfoList" resultType="com.xzx.gc.user.vo.JhyInfoListVo">
        select * from xzx_jhy_info
        select *,CREATED_TIME createTime from xzx_jhy_info
        <where>
            1=1
            <if test="record.name != null and record.name != ''">
                and (username like CONCAT(CONCAT(#{record.name}, '%'), '%') or phone=#{record.phone})
            </if>
            <if test="record.isJhy != null and record.name != ''">
            <if test="record.isJhy != null and record.isJhy != ''">
                and is_jhy=#{record.isJhy}
            </if>
            <if test="record.status != null">