--�ɹ���Ŀ��

---�ڼ���ϲɹ����(�ɹ�����,����Ϸ�),����ǰ����,���۴��,���۷���,����ǰ���,���ۺ���,��ʡ���,

--�ɹ���Ŀ��
--select 
--m.FNUMBER ��ϱ���
--,ml.FNAME ������
--,ml.FSPECIFICATION ����ͺ�
--,FFROMQTY ��
--,FTOQTY �
--,FEFFECTIVEDATE �����
--,FEFFECTIVEDATE ʧЧ����
--,FTAXPRICE ��˰����
----,*
-- from t_PUR_PriceListEntry  pric
--left join T_BD_MATERIAL_L ml on ml.FMATERIALID=pric.FMATERIALID--���
--left join T_BD_MATERIAL m on pric.FMATERIALID=m.FMATERIALID --��ϱ���

declare @begdate date,@enddate date
set @begdate='2023-03-01'
set @enddate='2023-03-30'


--�ɹ�����
select 
pat.FBILLNO ���۱���

,pat.FNAME ���۱����
,CONVERT(varchar(230), pat.FDATE, 23) ����
--,FPAREASON ����ԭ��
,ass.FDATAVALUE  ����ԭ��
,pat.FDESCRIPTION ���
,m.FNUMBER ��ϱ���
,ml.FNAME ������
,ml.FSPECIFICATION ����ͺ�
,FADJUSTTYPE �������  --a
,FPRICELISTID ��Ŀ��
,FSUPPLIERID ��Ӧ��
,pate.FBEFORETAXPRICE ��ǰ��˰����
,pate.FAFTERTAXPRICE ����˰����
,(pate.FAFTERTAXPRICE-pate.FBEFORETAXPRICE) �������
,pate.FEFFECTIVEDATE �����
,pate.FEXPIRYDATE ʧЧ����
,pat.FPURCHASEORGID,pat.FUSEORGID,pate.FMATERIALID
--,pate.*
 from T_PUR_PAT  pat
left join T_PUR_PATENTRY pate on pat.fid=pate.fid
left join T_BD_MATERIAL_L ml on ml.FMATERIALID=pate.FMATERIALID--���
left join T_BD_MATERIAL m on m.FMATERIALID=pate.FMATERIALID --��ϱ���
left join T_BAS_ASSISTANTDATAENTRY_L ass on ass.FENTRYID=pat.FPAREASON --������
where pat.FDOCUMENTSTATUS='C'
and pat.FEFFECTIVESTATUS='A'

--�жϵ��۴��,���������ڷ�Χ��,
--�Ч����,�ڽ������ǰ,ʧЧ�����ڽ������


and (
         --ǰ��260
		--(
		--	pate.FEFFECTIVEDATE>=@begdate 
		--	and pate.FEFFECTIVEDATE<=@enddate 
		--)
		----���23
		--or		
		--(
		--	pate.FEXPIRYDATE>=@begdate 
		--	and pate.FEXPIRYDATE<=@enddate 
		--)
		----����0
		--or		
		--(
		--	@begdate<=pate.FEFFECTIVEDATE
		--	and pate.FEXPIRYDATE<=@enddate 
		--)
		--������,��Ҫ�����������ڼ䷶Χ��
		--or		
		(
			(pate.FEFFECTIVEDATE<=@begdate
			and @enddate <= pate.FEXPIRYDATE)
			and 
			(pat.FDATE>=@begdate and pat.FDATE<=@enddate)
		)

	)



--


--select * from T_BAS_ASSISTANTDATAENTRY_L