<!--%%[
/* Selecteer de Data Extensie en de benodigde velden. */
SET @rows = LookupRows("FS NAWTE Email","email",EmailAddress)
IF RowCount(@rows) > 0 THEN
SET @row = Row(@rows,1)
SET @huisnummer = Field(@row,"housenumber")
SET @huisnummertoevoeging = Field(@row,"housenumber_suffix")
SET @postcode = Field(@row,"zipcode")
SET @stad = Field(@row,"city")
SET @land = Field(@row,"country")
SET @mobiel = Field(@row,"mobiel")
SET @telefoon = Field(@row,"phonenumber")
ENDIF
IF NOT EMPTY(@huisnummertoevoeging_fs) THEN
SET @huisnummertoevoeging=Concat("-", @huisnummertoevoeging)
EndIf
IF NOT EMPTY(@land) THEN
Set @land=Concat(", ", @land)
ENDIF
IF NOT Empty(@straat) THEN
SET @adres=Concat("Adres: ",@straat," ",@huisnummer, @huisnummertoevoeging,"<br />","Postcode / Woonplaats: ",@postcode," ", @stad,@land,"<br />")
ELSE
SET @adres=""
EndIf
/* Contact gegevens */
IF NOT Empty(@telefoon)
Set @telefoon = ""
Else
Set @telefoon=Concat("Telefoonnummer: ", @telefoon_fs,"<br />")
EndIf
Set @mobiel_fs=Lookup("FS NAWTE Email","mobilenumber","EmailAddress",EmailAddress)
If Empty(@mobile_fs) Or @mobile_fs == "" Then
Set @mobiel = ""
Else
Set @mobiel=Concat("Mobiele nummer: ", @mobiel_fs, "<br />")
EndIf
/* Geboortedatum gegevens */
SET @geboortedatum_fs=Lookup("FS NAWTE Email","birthdate","EmailAddress",EmailAddress)
If Empty(@geboortedatum_fs) Or @geboortedatum_fs == "" Then
SET @geboortedatum = ""
Else
Set @geboortedatum=CONCAT("Geboortedatum: ", FormatDate(v(@geboortedatum_fs), "DD/MM/YYYY"),"<br />")
Endif
/* NB Optin */
Set @nboptin_check=Lookup("FS NAWTE Email","nboptin","EmailAddress",EmailAddress)
If @nboptin_check == 'True' Then
SET @nboptin=Concat("Ja, u wilt de digitale nieuwsbrief ontvangen.", "<br />")
ELSE SET @nboptin=""
EndIf
/* betaalgegevens */
SET @amount=Lookup("FS Donation","amount","EmailAddress",EmailAddress)
SET @paymentmethod=Lookup("FS Donation","paymentmethod","EmailAddress",EmailAddress)
SET @frequency=Lookup("FS Donation","frequency","EmailAddress",EmailAddress)
Set @fs_donation_amount = FormatNumber(@amount,"N2","nl-NL")
Set @fs_donation_amount_converted = Concat("€ ",@fs_donation_amount)
SET @ibanDE=Lookup("FS Donation","iban","EmailAddress",EmailAddress)
If @paymentmethod == "machtiging" Then
Set @iban = Concat("IBAN (Rekeningnummer): ************", Substring(@ibanDE,15,4),"<br />")
Else
Set @iban = ""
EndIf
IF @frequency == "0" Then
Set @fs_donation_frequency_converted="eenmalig"
ElseIF @frequency == "12" Then
Set @fs_donation_frequency_converted="maandelijks"
ElseIF @frequency == "1" Then
Set @fs_donation_frequency_converted="jaarlijks"
EndIF
IF @paymentmethod == "machtiging" Then
Set @fs_donation_type_converted="Machtiging"
ElseIF @paymentmethod == "ideal" Then
Set @fs_donation_type_converted="iDeal"
ElseIF @paymentmethod == "paypal" Then
Set @fs_donation_type_converted="PayPal"
EndIF
]%%
-->