<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
(
where f.itemid = i.itemid and f.step = i.step
) p
where c.clientid = p.clientid
<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 iwhere f.itemid = i.itemid and f.step = i.step
) p
where c.clientid = p.clientid
</select>