<?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.deer.wms.base.system.dao.DelayWorkerOrderMapper">
  <resultMap id="BaseResultMap" type="com.deer.wms.base.system.model.DelayWorkerOrder">
    <!--
      WARNING - @mbg.generated
    -->
    <id column="delay_id" jdbcType="INTEGER" property="delayId" />
    <result column="worker_order_id" jdbcType="VARCHAR" property="workerOrderId" />
    <result column="item_code" jdbcType="VARCHAR" property="itemCode" />
    <result column="batch" jdbcType="VARCHAR" property="batch" />
    <result column="exp" jdbcType="VARCHAR" property="exp" />
    <result column="operator_no" jdbcType="VARCHAR" property="operatorNo" />
  </resultMap>

  <select id="findList" parameterType="com.deer.wms.base.system.model.DelayWorkerOrderCriteria" resultMap="BaseResultMap">
    select
    *
    from delay_worker_order
    where 1=1
    <if test="workerOrderId != null and workerOrderId != ''">
      and worker_order_id = #{workerOrderId}
    </if>
  </select>
</mapper>