组长接收（分科室接收）

SELECT count(1)
FROM (select t.folderservgrpid
from lims_folderservgrp t--fs表里有几个科室显示几条数据
left join lims_folders t2
on t.foldersid = t2.foldersid
and t2.pausemark = '0'
left join lims_clearanceform t3
on t2.clearanceid = t3.clearanceid
left join lims_prodgroup t5
on t5.prodgroupid = t3.inspectionitem
left join base_corp t4
on t.dept = t4.corpcode
left join (select count(*) groupcount, foldersid
from lims_folderservgrp
group by foldersid) t6
on t6.foldersid = t.foldersid
left join lims_folderstimelimit t8
on t.foldersid = t8.foldersid
and t8.dept = t.dept
and t8.operationno = '2'
left join lims_domainreport ld
on ld.reqsubtypeid = t3.reqsubtypid
and ld.dept = t3.dept
WHERE (t2.isfee = '0' or (t2.isfee = '1' and t2.pay in ('2', '3')))--是否收费 isfee '收费状态 0-退回或者检品送达,1-未收费,2-已收费,3-vip预授权,4-收费确认后退回即撤销的';
and exists (select 1
from right_rightuser r
where classficationid = '1'--不是超级管理员
and r.usercode = 'caoyu'
and t.dept = r.datacode)--登陆人的科室在fs表中存在
and exists (select 1
from lims_ordtask ot
where ot.foldersid = t.foldersid--EXISTS (sql 返回结果集为真)
and ot.wfnodecode = 'SZJS')--存在SZJS

and not exists--NOT EXISTS(sql 不返回结果集为真（或返回结果集为假）) 必须有这条，把不是J接收状态的数据去掉
(select 1
from lims_ordtask ot
where ot.foldersid = t.foldersid
and ot.wfnodecode <> 'SZJS')--不返回结果为真，就是把SZJS的留下
--综上存在SZJS并且只存在SZJS
and ld.dept = 'NJIFDC'--没啥用
and isback = '0'--退回标记
and (t2.status <> '终止检验' or t2.status is null)
order by t8.enddate asc, t2.foldersid desc)