A way to view "additional options" purchased

[Doug Hunt]

Hi Everyone,

Love Alf.io so far. Thanks for all the great work.

We're using the additional options feature to add a physical extra to those attendees that want a souvenir. Is there a way to generate a report of how many have been sold so we can prepare the correct number in advance?

The same goes for the donation option, Is there a way to generate a report so we can send the right amount of money to the charity we've chosen?

Dx

[Celestino Bellone]

Hi!

Thank you for using alf.io!

At the moment there is no report/statistics available for additional options and donations. 

The good news (I think) is that we're going to release a new version very soon, so we could add some basic reporting/statistics (i.e. downoad XLS report) to it, just to make sure you have the information you need.

Can you please create an issue on GitHub (https://github.com/alfio-event/alf.io/issues) so that we can keep track of it?

FYI we will completely redesign/rewrite the admin in the near future, and the "additional options" / "donations" functionality will be improved with more statistics, search, and so on. Any feedback would be highly appreciated. 

Thanks!

Celestino 

--
You received this message because you are subscribed to the Google Groups "alfio" group.
To unsubscribe from this group and stop receiving emails from it, send an email to alfio+un...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/alfio/3871da57-a578-4734-8fd1-0276c4554092n%40googlegroups.com.

[Doug Hunt]

Ok, thanks. I'll create a GitHub issue.

If this work is in progress, would someone be able to help me with the SQL I'd need to list out all the purchases so far, just so we can have the right number of souvenirs made?

I'm pretty good with php/mysql but java/PostgreSQL is new to me!

Thanks all!

Dx

[Celestino Bellone]

Hi!

You can use the following query:

select
    ai.uuid ai_uuid, ai.creation ai_creation, ai.last_modified ai_last_modified, ai.final_price_cts ai_final_price_cts, ai.currency_code ai_currency_code, ai.vat_cts ai_vat_cts, ai.discount_cts ai_discount_cts,
    tr.id tr_uuid, tr.first_name tr_first_name, tr.last_name tr_last_name, tr.email_address tr_email_address,
    asv.service_type as_type, asd.value as_title
 from additional_service_item ai
    join additional_service asv on ai.additional_service_id_fk = asv.id
    join tickets_reservation tr on ai.tickets_reservation_uuid = tr.id
    join additional_service_description asd on ai.additional_service_id_fk = asd.additional_service_id_fk
 where ai.event_id_fk = :eventId
  and asv.service_type = :additionalServiceType
  and asd.type = 'TITLE'
  and asd.locale = :locale

where:

- :eventId is the id of your event, as found in the event table

- :additionalServiceType is 'DONATION' if you want to extract donations, 'SUPPLEMENT' for other additional options

-  :locale is the event's language code ('en', 'it', 'de', 'fr' and so on)

Please note that all the prices are persisted as integers, for maximum flexibility.

If your currency supports fractions (most of the currencies support 2 decimal digits) you have to divide by 10^number_of_digits in order to have the amount paid by the customer.

In other words, if your currency is USD and the ai_final_price_cts is 1000, the amount paid by the customer would be 1000 / 100 => USD 10.00

Thanks for creating the issue. The new version will be released asap, stay tuned!

Celestino

To view this discussion on the web, visit https://groups.google.com/d/msgid/alfio/4a16c433-da31-487d-878d-74d1b4296294n%40googlegroups.com.

[Doug Hunt]

Many thanks bud!