- Posts: 8
- Thank you received: 0
Display LOCATION in the Registrants UI
- Alain Mitry
- Topic Author
- Offline
- New Member
Less
More
3 years 10 months ago #134682
by Alain Mitry
Display LOCATION in the Registrants UI was created by Alain Mitry
Hello,
In the REGISTRANTs table, I can add custom fields.... but I do not see how to add LOCATION of the events.
First Name Last Name Event Event Date Location Email #Registrants Registration Date Amount Status Invoice Number
Is it possible to add the LOCATION in the table out-of-the-box? or which code(s) shall I modify?
Cheers,
In the REGISTRANTs table, I can add custom fields.... but I do not see how to add LOCATION of the events.
First Name Last Name Event Event Date Location Email #Registrants Registration Date Amount Status Invoice Number
Is it possible to add the LOCATION in the table out-of-the-box? or which code(s) shall I modify?
Cheers,
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
3 years 10 months ago #134691
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Display LOCATION in the Registrants UI
Hi Alain
We do not support display location in the table, so you will have to write code to query database to get location information from database to have it displayed
There are many Registrants table in the extension. Could you please show me a screenshot of the page you want to modify so that I can know exactly the table and guide you further?
Regards,
Tuan
We do not support display location in the table, so you will have to write code to query database to get location information from database to have it displayed
There are many Registrants table in the extension. Could you please show me a screenshot of the page you want to modify so that I can know exactly the table and guide you further?
Regards,
Tuan
Please Log in or Create an account to join the conversation.
- Alain Mitry
- Topic Author
- Offline
- New Member
Less
More
- Posts: 8
- Thank you received: 0
3 years 10 months ago #134699
by Alain Mitry
Replied by Alain Mitry on topic Display LOCATION in the Registrants UI
Technically, I'm interested to add location in 2 UIs either.
1) the main admin UI "Registrant Manager: Registrants"
2) the 'menu type Item': com_eventbooking » Manage Registrants
cf. Link= index.php?option=com_eventbooking&view=registrants
1) the main admin UI "Registrant Manager: Registrants"
2) the 'menu type Item': com_eventbooking » Manage Registrants
cf. Link= index.php?option=com_eventbooking&view=registrants
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
3 years 10 months ago #134707
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Display LOCATION in the Registrants UI
Hello Alain
You can only do this modification if you know Joomla programming:
1. The file you need to modify are:
- components/com_eventbooking/themes/default/registrants/default.php (once the modification is done, move the file to PATH_TO_TEMPLATE/html/com_eventbooking/registrants folder so that it won't be lost on update)
-administrator/components/com_eventbooking/view/registrants/tmpl/default.php (once the modification is done, move the file to administrator/templates/isis/html/com_eventbooking/registrants folder)
For each event, you need to write code to query data from database, something like this:
Hope this helps
Tuan
You can only do this modification if you know Joomla programming:
1. The file you need to modify are:
- components/com_eventbooking/themes/default/registrants/default.php (once the modification is done, move the file to PATH_TO_TEMPLATE/html/com_eventbooking/registrants folder so that it won't be lost on update)
-administrator/components/com_eventbooking/view/registrants/tmpl/default.php (once the modification is done, move the file to administrator/templates/isis/html/com_eventbooking/registrants folder)
For each event, you need to write code to query data from database, something like this:
Code:
$db = JFactory::getDbo();
$query = $db->getQuery(true)
->select('a.name')
->from('#__eb_locations AS a')
->innerJoin('#__eb_events AS b ON a.id = b.location_id')
->where('b.id = '.$row->event_id);
$db->setQuery($query);
$locationName = $db->loadResult();
echo $locationName;
Hope this helps
Tuan
Please Log in or Create an account to join the conversation.
- Alain Mitry
- Topic Author
- Offline
- New Member
Less
More
- Posts: 8
- Thank you received: 0
3 years 10 months ago #134718
by Alain Mitry
Replied by Alain Mitry on topic Display LOCATION in the Registrants UI
Thanks. I already modified the UI for the "administrator" (will do the second one later) and it works as expected.
Thanks again for your help. You're a star!!
Alain
Thanks again for your help. You're a star!!
Alain
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
3 years 10 months ago #134719
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Display LOCATION in the Registrants UI
Great. Thanks for the update Alain
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.