modify [EVENTS_LIST] for invoice?

  • Wolfgang Fentler
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
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

Please Log in or Create an account to join the conversation.

More
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

Please Log in or Create an account to join the conversation.

  • Wolfgang Fentler
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
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?

Please Log in or Create an account to join the conversation.

  • Wolfgang Fentler
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
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

Please Log in or Create an account to join the conversation.

More
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)
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
  • Junior Member
More
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

Please Log in or Create an account to join the conversation.

More
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

Please Log in or Create an account to join the conversation.

  • Wolfgang Fentler
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
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
Attachments:

Please Log in or Create an account to join the conversation.

More
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

Please Log in or Create an account to join the conversation.

Moderators: Tuan Pham Ngoc