foreach

最新推荐文章于 2024-03-29 17:56:08 发布

wang_xiaozao

最新推荐文章于 2024-03-29 17:56:08 发布

阅读量235

点赞数

分类专栏： 20171012-20181220 mybatis

本文链接：https://blog.csdn.net/u010343544/article/details/80926839

版权

20171012-20181220 同时被 2 个专栏收录

22 篇文章 0 订阅

订阅专栏

mybatis

5 篇文章 0 订阅

订阅专栏

  <select id="getStatDetail" parameterType="com.huaxia.cai.center.collection.api.stub.dto.QueueStatDto" resultType="com.huaxia.cai.center.collection.api.stub.vo.QueueStatDetailVo">
    select
      c.queue_no queueNo,  c.business_category businessCategory, c.input_orgid inputOrgid, 
      c.user_id userId,c.user_name userName, c.follow_up_time followUpTime,
      c.contract_no contractNo
    from clt_collection_info c 
    where c.status = 0 and c.queue_no is not null and c.queue_no != ''
    <foreach collection="mainList" separator="or" item="item" open="and (" close=")">
      <trim prefix="(" suffix=")" prefixOverrides="and">
        <if test="item.inputOrgid != null and item.inputOrgid != ''">
          and c.input_orgid = #{item.inputOrgid,jdbcType=VARCHAR}
        </if>
        <if test="item.userId != null and item.userId != ''">
          and c.user_id = #{item.userId,jdbcType=VARCHAR}
        </if>
        <if test="item.queueNo != null and item.queueNo != ''">
          and c.queue_no = #{item.queueNo,jdbcType=VARCHAR}
        </if>
        <if test="item.businessCategory != null and item.businessCategory != ''">
          and c.business_category = #{item.businessCategory,jdbcType=VARCHAR}
        </if>
      </trim>
    </foreach>
  </select>