Data as a toy

You now have the install, connected the payment providerthe look & feel and the modules to start your fund raising or crowd funding. Last piece of the puzzle: marketing with your data. Because you know the number you're after. And the system knows how much has been donated so far....Below some more details on 'tokens'.

[Mollie:AantalDonaties.AantalDonaties] : In the database some data is stored when the Mollie signal is flagged as 'Paid'. This token adds up all transactions.

[Mollie:AantalDonaties.BedragDonaties] : In the database some data is stored when the Mollie signal is flagged as 'Paid'. This token adds up all amounts.

[Mollie:AantalDonaties.AantalLampjes] In the database some data is stored when the Mollie signal is flagged as 'Paid'. In this scenario lamps cost 5 euro a piece. A payment can be divided by 5 (after deduction of possible compensation of transactional costs) which give the number of lamps sold.

[Mollie:AantalDonaties.AantalLampjesNogBeschikbaar] : This is the number of items that needs to be sold (number of target - number of sold items)

In My Tokens you'll find that the target is set on 10000. If you want to sell 5000 items, you need to adjust the code : 

SELECT COUNT([MP_Id]) AS AantalDonaties
,SUM(CAST([MP_Amount] as decimal(10,2))) AS BedragDonaties,
CAST(ROUND((SUM(CAST([MP_Amount] as decimal(10,2)))/5),0) as int) AS AantalLampjes,
CAST (10000 - ROUND((SUM(CAST([MP_Amount] as decimal(10,2)))/5),0) as int) AS AantalLampjesNogBeschikbaar
FROM Mollie
WHERE MP_StatusPAyment = 'paid'

[Mollie:ReturnURL] : This is that page where people return for the thankyou text