<?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.lframework.xingyun.template.inner.mappers.system.SysDataDicMapper">

  <resultMap id="SysDataDic" type="com.lframework.xingyun.template.inner.entity.SysDataDic">
    <id column="id" property="id"/>
    <result column="code" property="code"/>
    <result column="name" property="name"/>
    <result column="category_id" property="categoryId"/>
    <result column="create_by" property="createBy"/>
    <result column="create_time" property="createTime"/>
    <result column="update_by" property="updateBy"/>
    <result column="update_time" property="updateTime"/>
  </resultMap>

  <sql id="SysDataDic_sql">
      SELECT
        tb.id,
        tb.code,
        tb.name,
        tb.category_id,
        tb.create_by,
        tb.create_time,
        tb.update_by,
        tb.update_time
      FROM sys_data_dic AS tb
    </sql>

  <select id="query" resultMap="SysDataDic">
    <include refid="SysDataDic_sql"/>
    <where>
      <if test="vo != null">
        <if test="vo.code != null and vo.code != ''">
          AND tb.code = #{vo.code}
        </if>
        <if test="vo.name != null and vo.name != ''">
          AND tb.name LIKE CONCAT('%', #{vo.name}, '%')
        </if>
        <if test="vo.categoryId != null and vo.categoryId != ''">
          AND tb.category_id = #{vo.categoryId}
        </if>
      </if>
    </where>
    ORDER BY tb.code ASC
  </select>
  <select id="selector" resultMap="SysDataDic">
      <include refid="SysDataDic_sql"/>
      <where>
        <if test="vo != null">
          <if test="vo.code != null and vo.code != ''">
            AND tb.code = #{vo.code}
          </if>
          <if test="vo.name != null and vo.name != ''">
            AND tb.name LIKE CONCAT('%', #{vo.name}, '%')
          </if>
          <if test="vo.categoryId != null and vo.categoryId != ''">
            AND tb.category_id = #{vo.categoryId}
          </if>
        </if>
      </where>
      ORDER BY tb.code ASC
    </select>
</mapper>
