cTN80401	;Exporteren IC-opgave van de vrijgestelde intracommunautaire leveringen naar XML    ;cAT116	;                     [ 26/01/10  12:18:47 ]
	;
	G 1
	;
VB(UI1KW,UREF,BP1,KW,FILEVB,TABGEG,MND)	; Exporteren IC-kwartaalopgave vanuit VB
	S $ZT="TRAP^cAN000"
	S SWVB=1
	G 1
VBZ	Q
	;
T0	;IC-opgave ;
T1	;VatIntra;RecipientId;SenderId;ControlRef;MandataireId;SenderDate;VersionTech;Test;
T2	;AgentRepr;DecNumber;
T3	;DeclarantList;
T4	;SequenceNum;DeclarantNum;ClientNbr;AmountSum;
T5	;CompanyInfo;
T6	;VATNum;Name;Street;CityAndZipCode;Country;
T7	;Period;
T8	;ClientList;
T9	;SequenceNum;
T10	;CompanyInfo;VATNum;Country;
T11	;Period;Amount;Code;
T12	;Het pad voor de IC-kwartaalopgave is niet correct ingevuld.;
T13	;Kan het uniek nummer voor de opgave niet bepalen.;
T15	;De I.C.-kwartaalopgave is leeg;
T16	;Postcode niet gevonden, gelieve in te vullen bij parameters boekhouding.;
	;
T0F	;Relevé IC ;
T12F	;Le chemin d’exportation du relevé IC électronique est incorrect.;
T13F	;Impossible de définir le numéro unique du relevé IC.;
T15F 	;Le relevé IC est vide;
T16F	;Code postal pas trouvé, s.v.p. le remplir dans param. comptables.;
	;
T0E	;IC Statement ;
T12E 	;The path for the electronic IC Statement is not correct.;
T13E	;Could not get unique number for the IC Statement.;
T15E 	;The IC Statement is empty;
T16E	;Could not find the postal code. Please fill in at accounting param.;
	;
1	N XMLFILE,BTWNR,MAND,CTRLREF,SEQNR,NBRCLIENT,TOTCLIENT,I3,I4,NODE,TEST,XMLPATH,B,UI1
	;
	S $ZT="TRAP^cAN000"
2	;------------------------------------------------------------------------------
	; Tijdelijke bestand aflopen
	;------------------------------------------------------------------------------
	S I3="",NBRCLIENT=0,TOTCLIENT=0
	I $G(SWVB) G 22
21	S I3=$O(^TEMP(boot,$J,I3)) G 23:I3=""
	S BE=^(I3,0),KC=$O(^(0)),BTW=$E(I3,3,999)
	; I BTW?1."0" S BE=$P(^(KC),D)
	I BTW?1."0" G 21   ; KU : BTW-nrs "NB" mogen niet mee.
210	S NBRCLIENT=NBRCLIENT+1
	S TOTCLIENT=TOTCLIENT+BE
	; I BTW?1."0" S KC=$O(^TEMP(boot,$J,I3,KC)) I KC S BE=$P(^(KC),D) G 210
	G 21
	;
22	S UI1=UI1KW_" "
220	S UI1=$O(@UREF)
	I $P(UI1," ")'=UI1KW G 23
	S BE=$P(^(UI1,0),D,6),BTW=$P(^(0),D,2)
	I 'BE G 220
	I BTW?1."0" G 220
	S NBRCLIENT=NBRCLIENT+1
	S TOTCLIENT=TOTCLIENT+BE
	G 220
	;
	; Nakijk of er klanten gevonden zijn
23	I 'NBRCLIENT S K=$P($T(@("T15"_QT)),U,2) D:'$G(SWVB) TXT^cAFA1(250) G YZ
	;
	;------------------------------------------------------------------------------
	; Test listing
	;------------------------------------------------------------------------------
230	; S TEST=$G(@("^"_Q_"BA(""%T"",13,""K"",""TEST"")")) ; ophalen uit @("^"_Q_"BA(""%T"",13,""K"",""TEST"")")	
	S TEST=$G(SWTEST)
	;
24	S SENDREF=$$SENDREF($P(BP1,"."),KW,MND)
	I SENDREF="" S K=$P($T(@("T13"_QT)),U,2) D:'$G(SWVB) TXT^cAFA1(250) G YZ
	; KU : 08.01.08 ; niet nodig aangezien Woonpl
	; S POSTCODE=$P($G(@("^"_Q_"BA(""%T"",13,""E"",1)")),D,2)
	; I POSTCODE'?4N S K=$P($T(@("T16"_QT)),U,2),TEMPOK=0 D TXT^cAFA1(250) G YZ
	;
25	I '$G(SWVB) S B(1)=$G(@("^"_Q_"BTW(0,0)"))
	I $G(SWVB) S B(1)=TABGEG(1)
	; opzoeken adresgegevens
	I $G(SWVB) S IDINDEX=5 G 3
	S IDINDEX=4
27	S TEMP=$P(B(1),D,IDINDEX)
	I '$L(TEMP),IDINDEX=4 S IDINDEX=5 G 27	
	S TEMP=$P(TEMP," ") I TEMP'?4N,IDINDEX=4 S IDINDEX=5 G 27
	;
3	;------------------------------------------------------------------------------
	; XML instantie maken
	;------------------------------------------------------------------------------
	S XMLWRITER=##class(%XML.Writer).%New()
	S XMLWRITER.Charset="UTF-8"
	; Output file
31	I '$G(SWVB) S XMLFILE=@("^"_Q_"BA(""%T"",13,""K"")")
	I $G(SWVB) S XMLFILE=FILEVB
	; Parameter niet ingevuld
	I XMLFILE="" S K=$P($T(@("T12"_QT)),U,2) D TXT^cAFA1(250) G Y
	; Nakijken of het pad bestaat - 26.06.07
	S XMLPATH=$P(XMLFILE,D,1,$L(XMLFILE,D)-1)
	I $$TST^cA710(XMLPATH)'=0 S K=$P($T(@("T12"_QT)),U,2) D TXT^cAFA1(250) G Y
	; Bestandsnaam samenstellen
	S XMLFILE=XMLFILE_$P(BP1,".")
	I '$G(SWTEST),'$L(MND) S XMLFILE=XMLFILE_"Q"_KW_".xml"
	I $G(SWTEST),'$L(MND) S XMLFILE=XMLFILE_"Q"_KW_"TEST.xml"
	I '$G(SWTEST),$L(MND) S XMLFILE=XMLFILE_"M"_$P(BP1,".",2)_".xml"
	I $G(SWTEST),$L(MND) S XMLFILE=XMLFILE_"M"_$P(BP1,".",2)_"TEST.xml"
	;
33	S SC=XMLWRITER.OutputToFile(XMLFILE)
	; Document starten
	S SC=XMLWRITER.StartDocument() D ENDLN
	D
	. ; Root element
	. S SC=XMLWRITER.RootElement($P($T(@("T1")),U,2))
	. ; RecipientId
	. S SC=XMLWRITER.WriteAttribute($P($T(@("T1")),U,3),"VAT-ADMIN")
	. ; SenderId
	. S BTWNR=$P(B(1),D,7),BTWNR=$$BTW^cAFO1(BTWNR),BTWNR=$$DP^cAFA1(BTWNR)
	. S SC=XMLWRITER.WriteAttribute($P($T(@("T1")),U,4),$E(BTWNR,3,999))
	. ; ControlRef
	. S CTRLREF=$TR($J(SENDREF,4)," ","0")
	. S SC=XMLWRITER.WriteAttribute($P($T(@("T1")),U,5),$E(BTWNR,3,999)_CTRLREF)
	. ; MandataireId
	. S MAND=$P(B(1),D,9)
	. S SC=XMLWRITER.WriteAttribute($P($T(@("T1")),U,6),$E(MAND,1,14))
	. ; SenderDate
	. S SC=XMLWRITER.WriteAttribute($P($T(@("T1")),U,7),$ZDATE($H,3))
	. ; VersionTech
	. ; S SC=XMLWRITER.WriteAttribute($P($T(@("T1")),U,8),"1.2")
	. ; Test
	. I TEST S SC=XMLWRITER.WriteAttribute($P($T(@("T1")),U,9),TEST)
	. ; Xml definities
	. S SC=XMLWRITER.WriteAttribute("xmlns","http://www.minfin.fgov.be/VatIntra")
	. S SC=XMLWRITER.WriteAttribute("xmlns:xsi","http://www.w3.org/2001/XMLSchema-instance")
	. ; S SC=XMLWRITER.WriteAttribute("xsi:noNamespaceSchemaLocation","http://minfin.fgov.be/portail1/nl/vatintra/VatIntra.xsd")
	. ; S SC=XMLWRITER.WriteAttribute("xsi:schemaLocation","http://www.minfin.fgov.be/VatIntra file:http://minfin.fgov.be/portail1/fr/vatintra/VatIntra.xsd")
	. ; S SC=XMLWRITER.WriteAttribute("xsi:schemaLocation","http://www.minfin.fgov.be/VatIntra \\data-m.be\dfs\mappen\Documenten\Klanten\TERBEK~1\Boekhouding\AANGIF~1\VatIntra.xsd")
	. D ENDLN 
	. ;
	. ; AGENTREPR
	. S SC=XMLWRITER.Element($P($T(@("T2")),U,2))
	. D
	.. ; DecNumber
	.. S SC=XMLWRITER.WriteAttribute($P($T(@("T2")),U,3),"1")
	.. ;
	.. ; COMPANY INFO
	.. S SC=XMLWRITER.Element($P($T(@("T5")),U,2)) D ENDLN
	.. D
	... ; VATNum
	... I $$DC^cAFD1(DT)<20100205 S SC=XMLWRITER.Element($P($T(@("T6")),U,2)),SC=XMLWRITER.WriteChars($E(BTWNR,3,999)),SC=XMLWRITER.EndElement() D ENDLN
	... I $$DC^cAFD1(DT)'<20100205 S SC=XMLWRITER.Element($P($T(@("T6")),U,2)),SC=XMLWRITER.WriteChars(BTWNR),SC=XMLWRITER.EndElement() D ENDLN
	... ; Name
	... S SC=XMLWRITER.Element($P($T(@("T6")),U,3)),SC=XMLWRITER.WriteChars($E($P(B(1),D,2),1,32)),SC=XMLWRITER.EndElement() D ENDLN
	... ; Street
	... S SC=XMLWRITER.Element($P($T(@("T6")),U,4)),SC=XMLWRITER.WriteChars($E($P(B(1),D,3),1,24)),SC=XMLWRITER.EndElement() D ENDLN
	... ; CityAndZipCode
	... S SC=XMLWRITER.Element($P($T(@("T6")),U,5)),SC=XMLWRITER.WriteChars($E($P(B(1),D,IDINDEX),1,30)),SC=XMLWRITER.EndElement() D ENDLN
	... ; Country
	... S SC=XMLWRITER.Element($P($T(@("T6")),U,6)),SC=XMLWRITER.WriteChars($E(BTWNR,1,2)),SC=XMLWRITER.EndElement() D ENDLN
	.. S SC=XMLWRITER.EndElement() D ENDLN
	. S SC=XMLWRITER.EndElement() D ENDLN
	. ;
	. ; DECLARANTLIST
	. S SC=XMLWRITER.Element($P($T(@("T3")),U,2))
	. D
	.. ; SequenceNum
	.. S SEQNR="00001"
	.. S SC=XMLWRITER.WriteAttribute($P($T(@("T4")),U,2),SEQNR)
	.. ; DeclarantNum
	.. S SC=XMLWRITER.WriteAttribute($P($T(@("T4")),U,3),$E(BTWNR,3,999)_CTRLREF_SEQNR)
	.. ; ClientNbr
	.. S SC=XMLWRITER.WriteAttribute($P($T(@("T4")),U,4),NBRCLIENT)
	.. ; AmountSum
	.. S SC=XMLWRITER.WriteAttribute($P($T(@("T4")),U,5),$$CENT(TOTCLIENT))
	.. D ENDLN 
	.. ;
	.. ; COMPANY INFO
	.. S SC=XMLWRITER.Element($P($T(@("T5")),U,2)) D ENDLN
	.. D
	... ; VATNum
	... S SC=XMLWRITER.Element($P($T(@("T6")),U,2)),SC=XMLWRITER.WriteChars($E(BTWNR,3,999)),SC=XMLWRITER.EndElement() D ENDLN
	... ; Name
	... S SC=XMLWRITER.Element($P($T(@("T6")),U,3)),SC=XMLWRITER.WriteChars($E($P(B(1),D,2),1,32)),SC=XMLWRITER.EndElement() D ENDLN
	... ; Street
	... S SC=XMLWRITER.Element($P($T(@("T6")),U,4)),SC=XMLWRITER.WriteChars($E($P(B(1),D,3),1,24)),SC=XMLWRITER.EndElement() D ENDLN
	... ; CityAndZipCode
	... S SC=XMLWRITER.Element($P($T(@("T6")),U,5)),SC=XMLWRITER.WriteChars($E($P(B(1),D,IDINDEX),1,30)),SC=XMLWRITER.EndElement() D ENDLN
	... ; Country
	... S SC=XMLWRITER.Element($P($T(@("T6")),U,6)),SC=XMLWRITER.WriteChars($E(BTWNR,1,2)),SC=XMLWRITER.EndElement() D ENDLN
	.. S SC=XMLWRITER.EndElement() D ENDLN
	.. ;
	.. ; PERIOD
	.. S SC=XMLWRITER.Element($P($T(@("T7")),U,2)),SC=XMLWRITER.WriteChars($S($L(MND):$P(BP1,".",2)_$P(BP1,"."),1:$S($$DC^cAFD1(DT)'<20100205:"3",1:"")_KW_$P(BP1,"."))),SC=XMLWRITER.EndElement() D ENDLN
	.. ;
	.. D CLIENT
	. S SC=XMLWRITER.EndElement() D ENDLN
	. S SC=XMLWRITER.EndRootElement() D ENDLN 
	;
	S SC=XMLWRITER.EndDocument()
	;
Y	S SC=XMLWRITER.%Close()
YZ	Q OK
	;
CLIENT	; Tijdelijk bestand doorlopen met klanten
	I $G(SWVB) G CLIENTAA
	S I3="",TEL=0
CLIENTA	S I3=$O(^TEMP(boot,$J,I3)) Q:I3=""  D
	S BE=^(I3,0),KC=$O(^(0)),BTW=$E(I3,3,999)
	; I BTW?1."0" S BE=$P(^(KC),D)
	I 'BE G CLIENTA
	I BTW?1."0" G CLIENTA   ; KU : BTW-nrs "NB" mogen niet mee.
	S TEL=TEL+1
	G CLIENTB
CLIENTAA	S UI1=UI1KW_" ",TEL=0
CLIENTAB	S UI1=$O(@UREF)
	I $P(UI1," ")'=UI1KW G CLIENTZ
	S BE=$P(^(UI1,0),D,6),I3=$P(^(0),D,2),CODE=$P(^(0),D,8),BTW=$E(I3,3,999)
	I 'BE G CLIENTAB
	I BTW?1."0" G CLIENTAB
	S TEL=TEL+1
	; CLIENTLIST
CLIENTB	S SC=XMLWRITER.Element($P($T(@("T8")),U,2))
	S SC=XMLWRITER.WriteAttribute($P($T(@("T4")),U,2),TEL) D ENDLN
	; COMPANYINFO
	S SC=XMLWRITER.Element($P($T(@("T10")),U,2)) D ENDLN
	; VATNum
	S SC=XMLWRITER.Element($P($T(@("T10")),U,3)),SC=XMLWRITER.WriteChars(BTW),SC=XMLWRITER.EndElement() D ENDLN
	; Country
	S SC=XMLWRITER.Element($P($T(@("T10")),U,4)),SC=XMLWRITER.WriteChars($E(I3,1,2)),SC=XMLWRITER.EndElement() D ENDLN
	S SC=XMLWRITER.EndElement() D ENDLN
	; Amount
	S SC=XMLWRITER.Element($P($T(@("T11")),U,3)),SC=XMLWRITER.WriteChars($$CENT(BE)),SC=XMLWRITER.EndElement() D ENDLN
	; Code
	; I $$DC^cAFD1(DT)'<20100205 S SC=XMLWRITER.Element($P($T(@("T11")),U,4)),SC=XMLWRITER.WriteChars(CODE),SC=XMLWRITER.EndElement() D ENDLN
	I BP1>2010 S SC=XMLWRITER.Element($P($T(@("T11")),U,4)),SC=XMLWRITER.WriteChars(CODE),SC=XMLWRITER.EndElement() D ENDLN
	S SC=XMLWRITER.EndElement() D ENDLN
	; I BTW?1."0" S KC=$O(^TEMP(boot,$J,I3,KC)) I KC S BE=$P(^(KC),D) G CLIENTB
	I '$G(SWVB) G CLIENTA
	I $G(SWVB) G CLIENTAB
CLIENTZ	Q
	;
	;---------------------------------------------------------------------------------------------------------------------------
	;
ENDLN	S SC=XMLWRITER.WriteChars($C(13,10))
	;
CENT(EURO)	; Omzetten euro's naar eurocenten
	N OUT,DEL
	S EURO=$TR(EURO,",",".")
	S OUT=EURO*100
CENTZ	Q OUT
	;
R0	S $P(R,D,12)=$T(+0) D ^cAN1000 Q  ; v12 23.01.95
	;
SENDREF(JAAR,KW,MAAND)	
	N OUT,I2,SJAAR
	S OUT=""
	S I2="Q"_KW
	I $L(MAAND) S I2="M"_$P(MAAND,".",2)
	; Nakijken of er al een nr is voor dit kwartaal of maand
	S OUT=$G(@("^"_Q_"BA(""%T"",13,""K"","_JAAR_","""_I2_""")"))	
	I $L(OUT) G SENDREFZ
	; Nog geen nummer beschikbaar
	I '$$LOCK^cANLOCK("^"_Q_"BA(""%T"",13,""K"")","","",1) G SENDREFZ
	S @("^"_Q_"BA(""%T"",13,""K"",1)")=$G(@("^"_Q_"BA(""%T"",13,""K"",1)"))+1,@("^"_Q_"BA(""%T"",13,""K"","_JAAR_","""_I2_""")")=@("^"_Q_"BA(""%T"",13,""K"",1)")
	S OUT=@("^"_Q_"BA(""%T"",13,""K"","_JAAR_","""_I2_""")")
	L -@("^"_Q_"BA(""%T"",13,""K"")")
SENDREFZ	Q OUT
	;
ZZ	; 16.10.08 - 14 u 11 * V9.04