<select id="findInfo" resultType="BizInfoBar" parameterType="map">
select v1.ID as id,v1.NAME as name,v1.STATE as states ,v1.PID as pid,v1.CREATE_DATE as createDate,v1.TYPE as type from BIZ_INFO_BAR v1
<trim prefix="where" prefixOverrides="and">
<if test="id != null and id !=''">
and v1.PID=#{id}
</if>
<if test="name != null and name != ''">
and v1.NAME like concat(#{name},'%')
</if>
<if test="pid != null and pid !=''">
and v1.PID=#{pid}
</if>
</trim>
and v1.type <![CDATA[ <> ]]> '2'
order by v1.CREATE_DATE desc
</select>
and o.create_time <= #{endTime,jdbcType=TIMESTAMP}//小于
and o.create_time >= #{startTime,jdbcType=TIMESTAMP}//大于
and i.status_flag <![CDATA[ <> ]]> 'F'//不等于
<if test="dutyGroupName != null and dutyGroupName != '' " >
AND DUTY_GROUP_NAME like '%'||#{dutyGroupName}||'%' //模糊查询
</if>