Display LOCATION in the Registrants UI

  • Alain Mitry
  • Topic Author
  • Offline
  • New Member
  • New Member
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,

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

More
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

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

  • Alain Mitry
  • Topic Author
  • Offline
  • New Member
  • New Member
More
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

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

More
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:
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
  • New Member
More
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

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

More
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