Konu: Aylara Göre Toplam İzin
Selamlar.
Özetler aşağıdaki datadan aylara göre toplam kullanılan izin raporu almak istiyorum.
Burada aşamadığım konu 2 den fazla ayı içeren izin kayıtlarında aylara nasıl bölebilirim?
Şimdiden teşekkürler.
CreateCursor_CRSONUC()
Procedure CreateCursor_CRSONUC
LOCAL lcData, lcTemp
lcTemp = SYS(2015)+'.tmp'
TEXT TO m.lcData noshow
18,"Vizite",10/02/2012 00:00:00,10/02/2012 00:00:00,0,0,"KAYIP"
18,"Vizite",31/01/2012 00:00:00,01/02/2012 00:00:00,1,1,"KAYIP"
18,"İzin",02/01/2012 00:00:00,16/01/2012 00:00:00,12,12,"İZİN"
31,"Üsİzin",03/01/2012 00:00:00,06/02/2012 00:00:00,29,29,"KAYIP"
31,"Üsİzin",03/01/2012 00:00:00,06/02/2012 00:00:00,29,29,"KAYIP"
37,"Vizite",27/03/2012 00:00:00,28/03/2012 00:00:00,1,1,"KAYIP"
37,"Vizite",20/03/2012 00:00:00,21/03/2012 00:00:00,1,1,"KAYIP"
37,"Vizite",27/02/2012 00:00:00,28/02/2012 00:00:00,1,1,"KAYIP"
46,"Vizite",02/03/2012 00:00:00,03/03/2012 00:00:00,1,1,"KAYIP"
49,"İzin",30/01/2012 00:00:00,03/02/2012 00:00:00,4,4,"İZİN"
49,"İzin",09/04/2012 00:00:00,16/04/2012 00:00:00,6,6,"İZİN"
49,"Vizite",24/02/2012 00:00:00,25/02/2012 00:00:00,1,1,"KAYIP"
61,"İzin",10/01/2012 00:00:00,16/01/2012 00:00:00,5,5,"İZİN"
70,"Üsİzin",30/03/2012 00:00:00,02/04/2012 00:00:00,2,2,"KAYIP"
70,"Vizite",19/03/2012 00:00:00,20/03/2012 00:00:00,1,1,"KAYIP"
70,"İzin",06/01/2012 00:00:00,13/01/2012 00:00:00,6,6,"İZİN"
70,"Vizite",09/04/2012 00:00:00,10/04/2012 00:00:00,1,1,"KAYIP"
70,"Vizite",05/03/2012 00:00:00,06/03/2012 00:00:00,1,1,"KAYIP"
70,"Üsİzin",02/04/2012 00:00:00,04/04/2012 00:00:00,2,2,"KAYIP"
70,"Vizite",02/05/2012 00:00:00,03/05/2012 00:00:00,1,1,"KAYIP"
70,"Vizite",30/04/2012 00:00:00,01/05/2012 00:00:00,0,0,"KAYIP"
79,"İzin",23/04/2012 00:00:00,30/04/2012 00:00:00,5,5,"İZİN"
97,"İzin",31/01/2012 00:00:00,03/02/2012 00:00:00,3,3,"İZİN"
97,"İzin",23/02/2012 00:00:00,24/02/2012 00:00:00,1,1,"İZİN"
100,"Vizite",20/02/2012 00:00:00,21/02/2012 00:00:00,1,1,"KAYIP"
106,"Vefat",16/01/2012 00:00:00,19/01/2012 00:00:00,3,3,"KAYIP"
106,"İzin",19/01/2012 00:00:00,23/01/2012 00:00:00,3,3,"İZİN"
122,"Vizite",02/01/2012 00:00:00,03/01/2012 00:00:00,1,1,"KAYIP"
130,"Vizite",03/04/2012 00:00:00,04/04/2012 00:00:00,1,1,"KAYIP"
130,"Vizite",21/03/2012 00:00:00,22/03/2012 00:00:00,1,1,"KAYIP"
130,"Üsİzin",13/04/2012 00:00:00,16/04/2012 00:00:00,2,2,"KAYIP"
130,"İzin",02/01/2012 00:00:00,09/01/2012 00:00:00,6,6,"İZİN"
130,"Vizite",17/02/2012 00:00:00,18/02/2012 00:00:00,1,1,"KAYIP"
139,"Vizite",07/02/2012 00:00:00,08/02/2012 00:00:00,1,1,"KAYIP"
139,"İzin",24/04/2012 00:00:00,02/05/2012 00:00:00,7,7,"İZİN"
139,"Vizite",16/01/2012 00:00:00,17/01/2012 00:00:00,1,1,"KAYIP"
139,"İzin",22/02/2012 00:00:00,29/02/2012 00:00:00,6,6,"İZİN"
139,"Vizite",04/04/2012 00:00:00,05/04/2012 00:00:00,1,1,"KAYIP"
139,"Vizite",09/03/2012 00:00:00,10/03/2012 00:00:00,1,1,"KAYIP"
145,"Vizite",23/01/2012 00:00:00,24/01/2012 00:00:00,1,1,"KAYIP"
145,"İzin",16/04/2012 00:00:00,02/05/2012 00:00:00,13,13,"İZİN"
145,"Vizite",03/02/2012 00:00:00,04/02/2012 00:00:00,1,1,"KAYIP"
145,"Vizite",10/01/2012 00:00:00,11/01/2012 00:00:00,1,1,"KAYIP"
153,"Rapor",02/05/2012 00:00:00,03/05/2012 00:00:00,1,1,"KAYIP"
153,"Vizite",10/02/2012 00:00:00,11/02/2012 00:00:00,1,1,"KAYIP"
153,"Rapor",16/04/2012 00:00:00,21/04/2012 00:00:00,5,5,"KAYIP"
153,"İzin",23/01/2012 00:00:00,30/01/2012 00:00:00,6,6,"İZİN"
153,"Vizite",12/03/2012 00:00:00,13/03/2012 00:00:00,1,1,"KAYIP"
153,"Vizite",24/04/2012 00:00:00,24/04/2012 00:00:00,0,0,"KAYIP"
155,"Vizite",13/01/2012 00:00:00,14/01/2012 00:00:00,1,1,"KAYIP"
159,"Vizite",30/01/2012 00:00:00,31/01/2012 00:00:00,1,1,"KAYIP"
163,"İzin",24/04/2012 00:00:00,02/05/2012 00:00:00,7,7,"İZİN"
163,"Üsİzin",09/01/2012 00:00:00,10/01/2012 00:00:00,1,1,"KAYIP"
179,"Vizite",06/04/2012 00:00:00,07/04/2012 00:00:00,1,1,"KAYIP"
179,"Vizite",20/04/2012 00:00:00,20/04/2012 00:00:00,0,0,"KAYIP"
179,"Vizite",13/04/2012 00:00:00,13/04/2012 00:00:00,0,0,"KAYIP"
182,"İzin",16/04/2012 00:00:00,24/04/2012 00:00:00,6,6,"İZİN"
190,"Vizite",20/02/2012 00:00:00,21/02/2012 00:00:00,1,1,"KAYIP"
190,"Vizite",17/02/2012 00:00:00,18/02/2012 00:00:00,1,1,"KAYIP"
190,"Vizite",01/02/2012 00:00:00,02/02/2012 00:00:00,1,1,"KAYIP"
190,"Vizite",05/04/2012 00:00:00,06/04/2012 00:00:00,1,1,"KAYIP"
190,"Üsİzin",02/01/2012 00:00:00,10/01/2012 00:00:00,7,7,"KAYIP"
190,"Vizite",05/03/2012 00:00:00,06/03/2012 00:00:00,1,1,"KAYIP"
190,"Üsİzin",12/01/2012 00:00:00,13/01/2012 00:00:00,1,1,"KAYIP"
190,"Vizite",13/01/2012 00:00:00,14/01/2012 00:00:00,1,1,"KAYIP"
190,"Rapor",28/03/2012 00:00:00,31/03/2012 00:00:00,3,3,"KAYIP"
190,"Üsİzin",14/01/2012 00:00:00,24/01/2012 00:00:00,8,8,"KAYIP"
190,"Üsİzin",07/02/2012 00:00:00,08/02/2012 00:00:00,1,1,"KAYIP"
190,"Vizite",13/03/2012 00:00:00,14/03/2012 00:00:00,1,1,"KAYIP"
190,"Vizite",09/02/2012 00:00:00,10/02/2012 00:00:00,1,1,"KAYIP"
190,"Rapor",06/03/2012 00:00:00,09/03/2012 00:00:00,3,3,"KAYIP"
190,"Rapor",30/04/2012 00:00:00,05/05/2012 00:00:00,5,5,"KAYIP"
190,"Vizite",16/03/2012 00:00:00,17/03/2012 00:00:00,1,1,"KAYIP"
190,"Üsİzin",27/03/2012 00:00:00,28/03/2012 00:00:00,1,1,"KAYIP"
190,"İzin",10/04/2012 00:00:00,30/04/2012 00:00:00,16,16,"İZİN"
190,"Vizite",12/03/2012 00:00:00,13/03/2012 00:00:00,1,1,"KAYIP"
190,"Rapor",22/03/2012 00:00:00,24/03/2012 00:00:00,2,2,"KAYIP"
190,"Vizite",09/04/2012 00:00:00,10/04/2012 00:00:00,1,1,"KAYIP"
190,"Rapor",19/03/2012 00:00:00,22/03/2012 00:00:00,3,3,"KAYIP"
190,"Vizite",09/03/2012 00:00:00,10/03/2012 00:00:00,1,1,"KAYIP"
190,"Üsİzin",26/01/2012 00:00:00,27/01/2012 00:00:00,1,1,"KAYIP"
191,"İzin",30/01/2012 00:00:00,06/02/2012 00:00:00,6,6,"İZİN"
191,"Üsİzin",05/03/2012 00:00:00,06/03/2012 00:00:00,1,1,"KAYIP"
205,"Vizite",27/01/2012 00:00:00,27/01/2012 00:00:00,0,0,"KAYIP"
210,"İzin",02/01/2012 00:00:00,06/01/2012 00:00:00,4,4,"İZİN"
210,"Vizite",20/04/2012 00:00:00,21/04/2012 00:00:00,1,1,"KAYIP"
210,"Üsİzin",26/03/2012 00:00:00,27/03/2012 00:00:00,1,1,"KAYIP"
215,"İzin",18/01/2012 00:00:00,27/01/2012 00:00:00,8,8,"İZİN"
215,"Vizite",19/03/2012 00:00:00,19/03/2012 00:00:00,0,0,"KAYIP"
215,"Vizite",05/04/2012 00:00:00,06/04/2012 00:00:00,1,1,"KAYIP"
215,"Vizite",27/03/2012 00:00:00,27/03/2012 00:00:00,0,0,"KAYIP"
215,"Vizite",09/03/2012 00:00:00,09/03/2012 00:00:00,0,0,"KAYIP"
215,"Vizite",26/03/2012 00:00:00,27/03/2012 00:00:00,1,1,"KAYIP"
215,"Vizite",14/03/2012 00:00:00,16/03/2012 00:00:00,2,2,"KAYIP"
230,"Vizite",21/03/2012 00:00:00,22/03/2012 00:00:00,1,1,"KAYIP"
230,"Vizite",03/02/2012 00:00:00,04/02/2012 00:00:00,1,1,"KAYIP"
230,"Vizite",13/04/2012 00:00:00,14/04/2012 00:00:00,1,1,"KAYIP"
236,"İzin",06/01/2012 00:00:00,23/01/2012 00:00:00,14,14,"İZİN"
236,"İzin",05/03/2012 00:00:00,26/03/2012 00:00:00,18,18,"İZİN"
236,"Rapor",26/03/2012 00:00:00,16/04/2012 00:00:00,21,21,"KAYIP"
ENDTEXT
STRTOFILE(m.lcData,m.lcTemp)
create CURSOR CRSONUC ;
( ;
SICILNO N(12,0) NULL ;
,ITUR C(10,0) NULL ;
,IBASTAR T(8,0) NULL ;
,IBITTAR T(8,0) NULL ;
,KIZIN N(7,0) NULL ;
,TOPLAM N(7,0) NULL ;
,SONITUR C(5,0) NOT NULL ;
)
APPEND FROM (m.lcTemp) TYPE delimited
ERASE (m.lcTemp)
endproc