<?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.ScanLogDao">
    <resultMap id="BaseResultMap" type="com.sy.coinage.workshop.model.ScanLog">
        <id column="id" jdbcType="INTEGER" property="id"/>
        <result column="rfid" jdbcType="VARCHAR" property="rfid"/>
        <result column="serial_number" jdbcType="VARCHAR" property="serialNumber"/>
        <result column="is_quality" jdbcType="INTEGER" property="isQuality"/>
        <result column="is_whole" jdbcType="INTEGER" property="isWhole"/>
        <result column="qty" jdbcType="INTEGER" property="qty"/>
        <result column="crown_prefix" jdbcType="VARCHAR" property="crownPrefix"/>
        <result column="created" jdbcType="TIMESTAMP" property="created"/>
        <result column="ware_id" jdbcType="VARCHAR" property="wareId"/>
        <result column="op_type" jdbcType="INTEGER" property="opType"/>
        <result column="status" jdbcType="INTEGER" property="status"/>
        <result column="securities" jdbcType="VARCHAR" property="securities"/>
        <result column="securities_id" jdbcType="INTEGER" property="securitiesId"/>
    </resultMap>
    <sql id="Base_Column_List">
        id
        , rfid, serial_number, is_quality, is_whole, qty, crown_prefix, created, ware_id, op_type, status, securities, securities_id
    </sql>

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

</mapper>

