<?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.LogisticsDao">
  <resultMap id="BaseResultMap" type="com.sy.coinage.workshop.model.Logistics">
    <id column="id" jdbcType="INTEGER" property="id"/>
    <result column="serial_number" jdbcType="VARCHAR" property="serialNumber"/>
    <result column="rfid" jdbcType="VARCHAR" property="rfid"/>
    <result column="rfid_src" jdbcType="VARCHAR" property="rfidSrc"/>
    <result column="crown_between" jdbcType="VARCHAR" property="crownBetween"/>
    <result column="status" jdbcType="INTEGER" property="status"/>
    <result column="ware_id" jdbcType="INTEGER" property="wareId"/>
    <result column="ware_cn" jdbcType="VARCHAR" property="wareCn"/>
    <result column="create_time" jdbcType="TIMESTAMP" property="createTime"/>
      <result column="address_cn" jdbcType="VARCHAR" property="addressCn"/>
      <result column="operator_id" jdbcType="INTEGER" property="operatorId"/>
      <result column="operator" jdbcType="VARCHAR" property="operator"/>
      <result column="check_id" jdbcType="INTEGER" property="checkId"/>
      <result column="checker" jdbcType="VARCHAR" property="checker"/>
  </resultMap>
    <sql id="Base_Column_List">
        id
        , serial_number, rfid, rfid_src, crown_between, status, ware_id, ware_cn, create_time, address_cn, operator_id, operator, check_id, checker
    </sql>

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

</mapper>

