MyBatis Bind标签

<select id="countByParams" parameterType="map" resultType="int">
<bind name="item_endStatus" value="@com.mediacross.iforce.common.consts.ItemStatus@ITEM_END.value"/>
<bind name="item_overStatus" value="@com.mediacross.iforce.common.consts.ItemStatus@ITEM_OVER.value"/>
 select count(1)
from 
  rv_client c,
 
(
select f.can_audit_contactname,i.itemid,i.clientid,i.userid,i.itemname,
i.workno,i.starttime,i.endtime,i.totalbudget,i.created ,
i.updated,i.status,i.step,i.nextstep  FROM
(

select r.itemid ,r.step,us.contact_name as can_audit_contactname from erp_item r ,erp_users us where r.userid= us.user_id  and r.status in (

#{item_endStatus},#{item_overStatus})

) f,rv_item  i
where f.itemid = i.itemid and f.step = i.step 
) p
where c.clientid = p.clientid 

</select>