指派

SELECT count(1)
FROM (select t2.mainuser
from lims_folderservgrp t1
left join lims_folders t2
on t1.foldersid = t2.foldersid
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 t1.dept = t4.corpcode
left join lims_domain t5
on t5.domainname = t3.type
left join lims_sample_programs lsp
on lsp.sampleprogramsid = t2.sampleprogramsid
left join lims_folderstimelimit t8
on t1.foldersid = t8.foldersid
and t8.dept = t1.dept
and t8.operationno = '2'
left join lims_domainreport ld
on ld.reqsubtypeid = t3.reqsubtypid
WHERE exists
(select 1
from lims_ordtask ot
where ot.foldersid = t2.foldersid
and ot.wfnodecode = 'RWFP' )--存在 SZFP或者RWFPXJ
and exists (select 1
from right_rightuser r
where classficationid = '1'
and r.usercode = 'caoyu'
and T1.dept = r.datacode)--并且存在 fs表存在登陆人的科室 保证具有组长分配菜单的人能看到自己科室
--这样就排除了fs其他科室的数据
and exists (select 1
from lims_ordtask a
where t1.foldersid = a.foldersid
and t1.dept = a.dept)--并且 lo表里有这个科室的数据 这不是一定的吗
and t1.auditflag = '1'--审核标志   查到的都是检品送达状态的，没有往下分的

and (t2.status <> '终止检验' or t2.status is null)--排除终止检验
order by t1.sorter,
t1.recordtime desc,
substr(t2.folderno, -9) desc
)