declare @begdate date,@enddate date
set @begdate='2023-08-01'
set @enddate='2023-08-30'
--set @begdate='{1}'
--set @enddate='{2}'

--�ɹ���Ա�����ͳ��(��ȡ����ȡ��£�
--�û���
select 
s_u.FUSERID as FID
,s_u.FNAME �û��
,(select count(distinct FNUMBER) from T_BD_MATERIAL m
	where 1=1
	--and m.FDOCUMENTSTATUS='C'
	and m.FFORBIDSTATUS='A'
	and m.FCREATEDATE between @begdate and @enddate
	and m.FCREATORID=s_u.FUSERID
) as ��������

,(select count(distinct FNUMBER) from T_BD_MATERIAL m
	where m.FDOCUMENTSTATUS='C'
	and m.FFORBIDSTATUS='A'
	and m.FAPPROVEDATE between @begdate and @enddate
	and m.FAPPROVERID=s_u.FUSERID
) as �������

,(select count(distinct FNUMBER) from t_BD_Supplier sup
	where 1=1 
	--and sup.FDOCUMENTSTATUS='C'
	and sup.FFORBIDSTATUS='A'
	and sup.FCREATEDATE between @begdate and @enddate
	and sup.FCREATORID=s_u.FUSERID
) as ������Ӧ���

,(select count(distinct FNUMBER) from t_BD_Supplier sup
	where sup.FDOCUMENTSTATUS='C'
	and sup.FFORBIDSTATUS='A'
	and sup.FAUDITDATE between @begdate and @enddate
	and sup.FAUDITORID=s_u.FUSERID
) as ��˹�Ӧ���



--,(select count(FID) from t_PUR_POOrder PO
--	where PO.FDOCUMENTSTATUS='C'
--	and po.FCANCELSTATUS='A' --��
--	and PO.FCREATEDATE between @begdate and @enddate
--	and PO.FCREATORID=s_u.FUSERID
--) as �ɹ������

--�ɹ���Ʊ����Ʊ��
,(select count(FID) from T_IV_PURCHASEIC iv
	where iv.FDOCUMENTSTATUS='C'
	and iv.FCANCELSTATUS='A'
	and iv.FCREATEDATE between @begdate and @enddate
	and iv.FCREATORID=s_u.FUSERID
) as �ɹ���Ʊ�

----Ӧ����
--,(select count(ap.FID) from T_AP_PAYABLE ap 
--	left join T_AP_PAYABLE_L ap_L on ap.FID=ap_L.FID
--	where ap.FDOCUMENTSTATUS='C'
--	and ap.FCANCELSTATUS='A'
--	and ap_L.F_QZYN_MULLANGTEXT is not null
--	and ap.FCREATORID=s_u.FUSERID
--	and ap.FCREATEDATE between @begdate and @enddate
--	) as �ɹ���Ʊ�
	   
 from T_SEC_USER s_u
 where FFORBIDSTATUS='A'