<?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.WorkshopLogDao">
    <resultMap id="BaseResultMap" type="com.sy.coinage.workshop.model.WorkshopLog">
        <id column="id" jdbcType="INTEGER" property="id"/>
        <result column="rfid" jdbcType="VARCHAR" property="rfid"/>
        <result column="serial_number" jdbcType="VARCHAR" property="serialNumber"/>
        <result column="dept" jdbcType="VARCHAR" property="dept"/>
        <result column="dept_id" jdbcType="INTEGER" property="deptId"/>
        <result column="securities_id" jdbcType="INTEGER" property="securitiesId"/>
        <result column="securities" jdbcType="VARCHAR" property="securities"/>
        <result column="crown_between_str" jdbcType="VARCHAR" property="crownBetweenStr"/>
        <result column="crown_between" jdbcType="VARCHAR" property="crownBetween"/>
        <result column="tare_weight" jdbcType="DOUBLE" property="tareWeight"/>
        <result column="gross_weight" jdbcType="DOUBLE" property="grossWeight"/>
        <result column="weightor_id" jdbcType="INTEGER" property="weightorId"/>
        <result column="weightor" jdbcType="VARCHAR" property="weightor"/>
        <result column="weight_time" jdbcType="TIMESTAMP" property="weightTime"/>
        <result column="loc_from" jdbcType="INTEGER" property="locFrom"/>
    <result column="loc_to" jdbcType="INTEGER" property="locTo"/>
    <result column="pieces_total" jdbcType="INTEGER" property="piecesTotal"/>
    <result column="operator_id" jdbcType="INTEGER" property="operatorId"/>
        <result column="operator_cn" jdbcType="VARCHAR" property="operatorCn"/>
        <result column="check_id" jdbcType="INTEGER" property="checkId"/>
        <result column="checker" jdbcType="VARCHAR" property="checker"/>
        <result column="create_time" jdbcType="TIMESTAMP" property="createTime"/>
        <result column="op_type" jdbcType="INTEGER" property="opType"/>
    </resultMap>
    <sql id="Base_Column_List">
        id
        , rfid, serial_number, res_dept, res_dept_id, dept_id, dept, securities_id, securities, crown_between_str, crown_between, tare_weight, gross_weight, weightor_id, weightor, weight_time, loc_from, loc_to, pieces_total, operator_id, operator_cn, check_id, checker, create_time, op_type
    </sql>

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

</mapper>

