<!--<?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.backendsys.mapper.System.SysFileCategoryMapper">-->

<!--    <sql id="includeFileCategory">-->
<!--        id,-->
<!--        id category_id,-->
<!--        category_name,-->
<!--        suffix,-->
<!--        sort,-->
<!--        status-->
<!--    </sql>-->

<!--&lt;!&ndash;    type="java.util.LinkedHashMap"&ndash;&gt;-->
<!--    <resultMap id="resultMapFileCategory" type="com.backendsys.entity.System.SysFile.SysFileCategoryDTO">-->
<!--        <id property="id" column="id" jdbcType="BIGINT" />-->
<!--        <result property="category_id" column="category_id" javaType="java.lang.Long"/>-->
<!--        <result property="category_name" column="category_name" />-->
<!--        <result property="suffix" column="suffix" />-->
<!--        <result property="sort" column="sort" javaType="java.lang.Integer"/>-->
<!--        <result property="status" column="status" javaType="java.lang.Integer"/>-->
<!--    </resultMap>-->

<!--    &lt;!&ndash; 查询 列表 &ndash;&gt;-->
<!--    <select id="queryFileCategoryList" resultMap="resultMapFileCategory">-->
<!--        SELECT <include refid="includeFileCategory" />-->
<!--        FROM sys_file_category-->
<!--        <where>-->
<!--            <if test="category_name != null and category_name != ''">-->
<!--                AND category_name = #{category_name}-->
<!--            </if>-->
<!--            <if test="suffix != null and suffix != ''">-->
<!--                AND suffix LIKE CONCAT('%', #{suffix}, '%')-->
<!--            </if>-->
<!--            <if test="status != null and status != ''">-->
<!--                AND status = #{status}-->
<!--            </if>-->
<!--        </where>-->
<!--        ORDER BY sort DESC-->
<!--    </select>-->

<!--</mapper>-->