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	;;RecipientId;SenderId;ControlRef;MandataireId;SenderDate;VersionTech;Test;
T2	;AgentRepr;DecNumber;
T3	;IntraListing;
T4	;SequenceNumber;DeclarantReference;ClientsNbr;AmountSum;
T5	;Declarant;
T6	;VATNumber;Name;Street;PostCode;CountryCode;City;EmailAddress;
T7	;Period;Month;Quarter;Year;
T8	;IntraClient;
T9	;SequenceNum;
T10	;CompanyInfo;CompanyVATNumber;Country;issuedBy;
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.;
T17	;IntraConsignment;IntraListingsNbr;
T18	;http://www.minfin.fgov.be/InputCommon;
T19	;E-mail ondertekenaar werd niet ingevuld.;
T20	;Representative;RepresentativeID;issuedBy;identificationType;Phone;
T21	;Telefoon ondertekenaar werd niet ingevuld.;
	;
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.;
T19F	;E-mail signataire n'est pas rempli.;
T21F	;Telephone signataire n'est pas rempli.;
	;
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.;
T19E	;E-mail Signer was not filled in.;
T21E	;Telephone Signer was not filled in.;
	;
1	N XMLFILE,BTWNR,MAND,CTRLREF,SEQNR,NBRCLIENT,TOTCLIENT,I3,I4,NODE,TEST,XMLPATH,B,UI1,POSTCODE
	;
	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) S:$G(SWVB) OK="0\"_K 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) S:$G(SWVB) OK="0\"_K G YZ
	; KU : 08.01.08 ; niet nodig aangezien Woonpl
	I $G(SWVB) S POSTCODE=$$SIG^cAFA1("Q",Q,302)
	I '$G(SWVB) 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) S:$G(SWVB) OK="0\"_K G YZ
	;
25	I '$G(SWVB) S B(1)=$G(@("^"_Q_"BTW(0,0)"))
	I $G(SWVB) S B(1)=TABGEG(1)
	;
	; Nakijken of telefoon is ingevuld
	I $P(B(1),D,13)="" S K=$P($T(@("T21"_QT)),U,2),TEMPOK=0 D:'$G(SWVB) TXT^cAFA1(250) S:$G(SWVB) OK="0\"_K G YZ
	; Nakijken of e-mail adres is ingevuld
	I $P(B(1),D,14)="" S K=$P($T(@("T19"_QT)),U,2),TEMPOK=0 D:'$G(SWVB) TXT^cAFA1(250) S:$G(SWVB) OK="0\"_K G YZ
	;
	; 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:'$G(SWVB) TXT^cAFA1(250) S:$G(SWVB) OK="0\"_K 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:'$G(SWVB) TXT^cAFA1(250) S:$G(SWVB) OK="0\"_K 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))
	. S SC=XMLWRITER.RootElement($P($T(@("T17")),U,2))
	. S SC=XMLWRITER.WriteAttribute($P($T(@("T17")),U,3),"1")
	. S SC=XMLWRITER.WriteAttribute("xmlns","http://www.minfin.fgov.be/IntraConsignment")
	. ; SenderId
	. S BTWNR=$P(B(1),D,7),BTWNR=$$BTW^cAFO1(BTWNR),BTWNR=$$DP^cAFA1(BTWNR)
	. ; ControlRef
	. S CTRLREF=$TR($J(SENDREF,4)," ","0")
	. ; MandataireId
	. S MAND=$P(B(1),D,9)
	. D ENDLN 
	. ;
	. ; Representative
	. S SC=XMLWRITER.Element($P($T(@("T20")),U,2)) D ENDLN
	. D
	.. 
	.. ; VATNum
	.. S SC=XMLWRITER.Element($P($T(@("T20")),U,3)),SC=XMLWRITER.WriteAttribute($P($T(@("T20")),U,4),"BE"),SC=XMLWRITER.WriteAttribute($P($T(@("T20")),U,5),"NVAT"),SC=XMLWRITER.WriteAttribute("xmlns",$P($T(@("T18")),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.WriteAttribute("xmlns",$P($T(@("T18")),U,2)),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.WriteAttribute("xmlns",$P($T(@("T18")),U,2)),SC=XMLWRITER.WriteChars($E($P(B(1),D,3),1,24)),SC=XMLWRITER.EndElement() D ENDLN
	.. ; Postcode
	.. S SC=XMLWRITER.Element($P($T(@("T6")),U,5)),SC=XMLWRITER.WriteAttribute("xmlns",$P($T(@("T18")),U,2)),SC=XMLWRITER.WriteChars(POSTCODE),SC=XMLWRITER.EndElement() D ENDLN
	.. ; City
	.. ; CityAndZipCode
	.. S SC=XMLWRITER.Element($P($T(@("T6")),U,7)),SC=XMLWRITER.WriteAttribute("xmlns",$P($T(@("T18")),U,2)),SC=XMLWRITER.WriteChars($P($P(B(1),D,IDINDEX)," ",2,99)),SC=XMLWRITER.EndElement() D ENDLN
	.. ; Country
	.. S SC=XMLWRITER.Element($P($T(@("T6")),U,6)),SC=XMLWRITER.WriteAttribute("xmlns",$P($T(@("T18")),U,2)),SC=XMLWRITER.WriteChars($E(BTWNR,1,2)),SC=XMLWRITER.EndElement() D ENDLN
	.. ; E-mail
	.. S SC=XMLWRITER.Element($P($T(@("T6")),U,8)),SC=XMLWRITER.WriteAttribute("xmlns",$P($T(@("T18")),U,2)),SC=XMLWRITER.WriteChars($P(B(1),D,14)),SC=XMLWRITER.EndElement() D ENDLN
	.. ; Phone
	.. S SC=XMLWRITER.Element($P($T(@("T20")),U,6)),SC=XMLWRITER.WriteAttribute("xmlns",$P($T(@("T18")),U,2)),SC=XMLWRITER.WriteChars($$DP^cAFA1($P(B(1),D,13))),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="1"
	.. S SC=XMLWRITER.WriteAttribute($P($T(@("T4")),U,2),SEQNR)
	.. ; ClientNbr
	.. S SC=XMLWRITER.WriteAttribute($P($T(@("T4")),U,4),NBRCLIENT)
	.. ; DeclarantNum
	.. ; S SC=XMLWRITER.WriteAttribute($P($T(@("T4")),U,3),$E(BTWNR,3,999)_CTRLREF_SEQNR)
	.. S SC=XMLWRITER.WriteAttribute($P($T(@("T4")),U,3),$E(BTWNR,3,999)_CTRLREF)
	.. ; AmountSum
	.. S SC=XMLWRITER.WriteAttribute($P($T(@("T4")),U,5),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.WriteAttribute("xmlns",$P($T(@("T18")),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.WriteAttribute("xmlns",$P($T(@("T18")),U,2)),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.WriteAttribute("xmlns",$P($T(@("T18")),U,2)),SC=XMLWRITER.WriteChars($E($P(B(1),D,3),1,24)),SC=XMLWRITER.EndElement() D ENDLN
	... ; Postcode
	... S SC=XMLWRITER.Element($P($T(@("T6")),U,5)),SC=XMLWRITER.WriteAttribute("xmlns",$P($T(@("T18")),U,2)),SC=XMLWRITER.WriteChars(POSTCODE),SC=XMLWRITER.EndElement() D ENDLN
	... ; City
	... ; CityAndZipCode
	... S SC=XMLWRITER.Element($P($T(@("T6")),U,7)),SC=XMLWRITER.WriteAttribute("xmlns",$P($T(@("T18")),U,2)),SC=XMLWRITER.WriteChars($P($P(B(1),D,IDINDEX)," ",2,99)),SC=XMLWRITER.EndElement() D ENDLN
	... ; Country
	... S SC=XMLWRITER.Element($P($T(@("T6")),U,6)),SC=XMLWRITER.WriteAttribute("xmlns",$P($T(@("T18")),U,2)),SC=XMLWRITER.WriteChars($E(BTWNR,1,2)),SC=XMLWRITER.EndElement() D ENDLN
	... ; E-mail
	... S SC=XMLWRITER.Element($P($T(@("T6")),U,8)),SC=XMLWRITER.WriteAttribute("xmlns",$P($T(@("T18")),U,2)),SC=XMLWRITER.WriteChars($P(B(1),D,14)),SC=XMLWRITER.EndElement() D ENDLN
	... ; Phone
	... S SC=XMLWRITER.Element($P($T(@("T20")),U,6)),SC=XMLWRITER.WriteAttribute("xmlns",$P($T(@("T18")),U,2)),SC=XMLWRITER.WriteChars($$DP^cAFA1($P(B(1),D,13))),SC=XMLWRITER.EndElement() D ENDLN
	.. S SC=XMLWRITER.EndElement() D ENDLN
	.. ;
	.. ; PERIOD
	.. S SC=XMLWRITER.Element($P($T(@("T7")),U,2)) D ENDLN
	.. I $L(MND) D
	... S SC=XMLWRITER.Element($P($T(@("T7")),U,3))
	... S SC=XMLWRITER.WriteChars($P(BP1,".",2)),SC=XMLWRITER.EndElement() D ENDLN
	... S SC=XMLWRITER.Element($P($T(@("T7")),U,5))
	... S SC=XMLWRITER.WriteChars($P(BP1,".")),SC=XMLWRITER.EndElement() D ENDLN
	... ; S SC=XMLWRITER.WriteChars($S($L(MND):$P(BP1,".",2)_$P(BP1,"."),1:$S($$DC^cAFD1(DT)'<20100205:"3",1:"")_KW_$P(BP1,".")))
	.. I '$L(MND) D
	... S SC=XMLWRITER.Element($P($T(@("T7")),U,4))
	... S SC=XMLWRITER.WriteChars(KW),SC=XMLWRITER.EndElement() D ENDLN
	... S SC=XMLWRITER.Element($P($T(@("T7")),U,5))
	... S SC=XMLWRITER.WriteChars($P(BP1,".")),SC=XMLWRITER.EndElement() D ENDLN
	.. S 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
	; VATNum
	S SC=XMLWRITER.Element($P($T(@("T10")),U,3)),SC=XMLWRITER.WriteAttribute($P($T(@("T10")),U,5),$E(I3,1,2)),SC=XMLWRITER.WriteChars(BTW),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
	; Amount
	S SC=XMLWRITER.Element($P($T(@("T11")),U,3)),SC=XMLWRITER.WriteChars(BE),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))
ENDLNZ	Q
	;
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	; 02.02.10 - 14 u 30 * V9.06