<?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.sy.coinage.workshop.dao.ProductDao">
  <resultMap id="BaseResultMap" type="com.sy.coinage.workshop.model.Product">
    <id column="id" jdbcType="INTEGER" property="id"/>
    <result column="securities" jdbcType="VARCHAR" property="securities"/>
    <result column="spec" jdbcType="VARCHAR" property="spec"/>
    <result column="crown_prefix" jdbcType="VARCHAR" property="crownPrefix"/>
    <result column="box_amount" jdbcType="INTEGER" property="boxAmount"/>
    <result column="amount_per_box" jdbcType="INTEGER" property="amountPerBox"/>
    <result column="status" jdbcType="INTEGER" property="status"/>
    <result column="create_time" jdbcType="TIMESTAMP" property="createTime"/>
  </resultMap>
  <sql id="Base_Column_List">
      id
      , securities, spec, crown_prefix, box_amount, amount_per_box, status, create_time
  </sql>
    <select id="queryOptList" resultType="com.sy.coinage.core.vo.OptVO">
        select id, securities as name
        from rfid_product
        <if test="ew.emptyOfWhere == false">
            ${ew.customSqlSegment}
        </if>
    </select>

    <!--  <select id="queryPageList" resultType="com.sy.coinage.workshop.vo.ProductVO">-->
    <!--    SELECT-->
    <!--    rfid_product.*-->
    <!--    FROM-->
    <!--    rfid_product-->
    <!--    LEFT JOIN-->
    <!--    rfid_product-->
    <!--    ON-->
    <!--    rfid_product.id = rfid_product.id-->
    <!--    <if test="ew.emptyOfWhere == false">-->
    <!--      ${ew.customSqlSegment}-->
    <!--    </if>-->
    <!--  </select>-->

</mapper>

