- Posts: 23
- Thank you received: 1
modify [EVENTS_LIST] for invoice?
- Wolfgang Fentler
- Topic Author
- Offline
- Junior Member
Less
More
5 years 10 months ago #114614
by Wolfgang Fentler
modify [EVENTS_LIST] for invoice? was created by Wolfgang Fentler
hi,
if have cart enabled and want to modify the [EVENTS_LIST] setup, because there are some missing fields (number of registrants) in this listing, is that possible and where to do that?
thx wolfgang
if have cart enabled and want to modify the [EVENTS_LIST] setup, because there are some missing fields (number of registrants) in this listing, is that possible and where to do that?
thx wolfgang
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
5 years 10 months ago #114615
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic modify [EVENTS_LIST] for invoice?
Hi
Yes. You can modify code in the file components/com_eventbooking/view/emailtemplates/tmpl/invoice_items.php to include the information you want
Regards,
Tuan
Yes. You can modify code in the file components/com_eventbooking/view/emailtemplates/tmpl/invoice_items.php to include the information you want
Regards,
Tuan
Please Log in or Create an account to join the conversation.
- Wolfgang Fentler
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 23
- Thank you received: 1
5 years 10 months ago #114618
by Wolfgang Fentler
Replied by Wolfgang Fentler on topic modify [EVENTS_LIST] for invoice?
thx, working fine!
but how to get the number of registrants for each item?
but how to get the number of registrants for each item?
Please Log in or Create an account to join the conversation.
- Wolfgang Fentler
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 23
- Thank you received: 1
5 years 10 months ago #114626
by Wolfgang Fentler
Replied by Wolfgang Fentler on topic modify [EVENTS_LIST] for invoice?
ok, find that for myself:
$rowEvent->number_registrants is the number of registrants for each event
and
$rowEvent->event_date is the event date
now searching for an individual field (shipping costs) to be displayed on the invoice, any ideas?
thx
$rowEvent->number_registrants is the number of registrants for each event
and
$rowEvent->event_date is the event date
now searching for an individual field (shipping costs) to be displayed on the invoice, any ideas?
thx
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
5 years 10 months ago #114635
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic modify [EVENTS_LIST] for invoice?
Hi
Unfortunately, there is no simple way to get that data. You will have to write code to query data directly from database (in #__eb_field_values base on id of registration record and id of that custom field)
Assume ID of that custom field is 100, you can use this PHP code (put it above for loop block)
Hope it give you a bit help
Tuan
Unfortunately, there is no simple way to get that data. You will have to write code to query data directly from database (in #__eb_field_values base on id of registration record and id of that custom field)
Assume ID of that custom field is 100, you can use this PHP code (put it above for loop block)
Code:
$row = $rowEvents[0];
$registrantId = $row->cart_id ?: $row->id;
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('field_value')
->from('#__eb_field_values')
->where('registrant_id = '.$registrantId)
->where('field_id = 100');
$db->setQuery($query);
$fieldValue = $db->loadResult();
Hope it give you a bit help
Tuan
The following user(s) said Thank You: Wolfgang Fentler
Please Log in or Create an account to join the conversation.
- Wolfgang Fentler
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 23
- Thank you received: 1
5 years 10 months ago #114714
by Wolfgang Fentler
Replied by Wolfgang Fentler on topic modify [EVENTS_LIST] for invoice?
ok,
i was able to include that, but now another problem occured in that case: the custom field does not include tax, in the cart it is calculated as the tickets (13% Tax), how can i fix this?
thx
i was able to include that, but now another problem occured in that case: the custom field does not include tax, in the cart it is calculated as the tickets (13% Tax), how can i fix this?
thx
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
5 years 10 months ago #114718
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic modify [EVENTS_LIST] for invoice?
Hi
This is not very clear to me. Maybe you can make a screenshot showing us how it's displayed at the moment and how you want to change it so that we can look at it and guide you?
If you want to show additional 13%, maybe just write some code to calculate that tax value?
Tuan
This is not very clear to me. Maybe you can make a screenshot showing us how it's displayed at the moment and how you want to change it so that we can look at it and guide you?
If you want to show additional 13%, maybe just write some code to calculate that tax value?
Tuan
Please Log in or Create an account to join the conversation.
- Wolfgang Fentler
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 23
- Thank you received: 1
5 years 9 months ago #114739
by Wolfgang Fentler
Replied by Wolfgang Fentler on topic modify [EVENTS_LIST] for invoice?
hi,
ok i will try to explain:
in pic1 you can see the normal calculation without the custom field "Versand", here the calculation is ok!
in pic2 you can see the custom field "Versand" has a value of + 6,-
in pic3 you see the calculation, the field "Betrag" shows the amount without tax, "Steuerbetrag" is the tax and "Gesamtsumme" is the ammount including tax, so far so good,
BUT the custom field has no tax included, so the calculation should be "Betrag" calculated as the amount without tax PLUS the custom field, "Steuerbetrag" as the tax without the value of tax of custom field and the "Gesamtsumme" as the total of "Betrag" and "Steuerbetrag".
the rigth ammount are:
"Betrag" = 23,70
"Steuerbetrag" = 2,30
"Gesamtsumme" = 26,00
i hope this was understanable?
regards wolfgang
ok i will try to explain:
in pic1 you can see the normal calculation without the custom field "Versand", here the calculation is ok!
in pic2 you can see the custom field "Versand" has a value of + 6,-
in pic3 you see the calculation, the field "Betrag" shows the amount without tax, "Steuerbetrag" is the tax and "Gesamtsumme" is the ammount including tax, so far so good,
BUT the custom field has no tax included, so the calculation should be "Betrag" calculated as the amount without tax PLUS the custom field, "Steuerbetrag" as the tax without the value of tax of custom field and the "Gesamtsumme" as the total of "Betrag" and "Steuerbetrag".
the rigth ammount are:
"Betrag" = 23,70
"Steuerbetrag" = 2,30
"Gesamtsumme" = 26,00
i hope this was understanable?
regards wolfgang
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
5 years 9 months ago #114740
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic modify [EVENTS_LIST] for invoice?
Honestly. it's not easy to understand, mostly because the text is not in English and I don't know how you setup the system
So in this case, you should submit a support ticket sending us:
1. Super admin account
2. Link to registration form
I will take a look at it, try to understand your issue before answering you further
Tuan
So in this case, you should submit a support ticket sending us:
1. Super admin account
2. Link to registration form
I will take a look at it, try to understand your issue before answering you further
Tuan
Please Log in or Create an account to join the conversation.
Moderators: Tuan Pham Ngoc
Support
Documentation
Information
Copyright © 2024 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.