- Posts: 13
- Thank you received: 0
View list - ordering?
- jvh
- Topic Author
- Offline
- New Member
-
Less
More
11 years 8 months ago - 11 years 8 months ago #47179
by jvh
View list - ordering? was created by jvh
Hi Tuan,
I have a group event that people sign up for. This event has 2 extra fields that i have added (teamname and centre)
When the user looks at the registrant list at frontend it is very un-organized. Fex: all the registrants for one event is not listet after each other before registrants from another team is listed.
Can you tell me in wich file i can change the order of the view list at frontend?
I am using version 1.6.2
I have a group event that people sign up for. This event has 2 extra fields that i have added (teamname and centre)
When the user looks at the registrant list at frontend it is very un-organized. Fex: all the registrants for one event is not listet after each other before registrants from another team is listed.
Can you tell me in wich file i can change the order of the view list at frontend?
I am using version 1.6.2
Last edit: 11 years 8 months ago by jvh.
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Away
- Administrator
-
11 years 8 months ago #47191
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic View list - ordering?
Hi
Version 1.6.2 is quite old and the code is much different from this version. However, I believe the code for getting list of registrants (so that you can change ordering) are still located in the file components/com_eventbooking/views/registrantlist//view.html.php
Regards,
Tuan
Version 1.6.2 is quite old and the code is much different from this version. However, I believe the code for getting list of registrants (so that you can change ordering) are still located in the file components/com_eventbooking/views/registrantlist//view.html.php
Regards,
Tuan
Please Log in or Create an account to join the conversation.
- jvh
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 13
- Thank you received: 0
11 years 8 months ago #47201
by jvh
Replied by jvh on topic View list - ordering?
Hi again,
Yes i know, i will upgrade after our next upcoming event.
For this event that we have running now, its important to see the teams and also which member are connected to each team. And i checked the file you sent me but i cannot make it work. Looks to me that whatever i do it dont make a difference. Do you have any suggestion?
Yes i know, i will upgrade after our next upcoming event.
For this event that we have running now, its important to see the teams and also which member are connected to each team. And i checked the file you sent me but i cannot make it work. Looks to me that whatever i do it dont make a difference. Do you have any suggestion?
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Away
- Administrator
-
11 years 8 months ago #47206
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic View list - ordering?
Hi
I don't think I can have a good suggestions for you in this case because if you want to display registrants organized by team, you will need to have a strong coding skill to do that since the value of custom field for each registrants are stored in a different database table (#__eb_field_value), not in the table #__eb_registrants.
The code which displays registrants are located in the file components/com_eventbooking/views/registrantlist/tmpl/default.php. However, to display it in the way you want, it is not really easy. It will take a good dev about 3 hours of coding to do that, unfortunately.
So unless you have strong coding skill to do this customization, you will have to use it as how it is
Tuan
I don't think I can have a good suggestions for you in this case because if you want to display registrants organized by team, you will need to have a strong coding skill to do that since the value of custom field for each registrants are stored in a different database table (#__eb_field_value), not in the table #__eb_registrants.
The code which displays registrants are located in the file components/com_eventbooking/views/registrantlist/tmpl/default.php. However, to display it in the way you want, it is not really easy. It will take a good dev about 3 hours of coding to do that, unfortunately.
So unless you have strong coding skill to do this customization, you will have to use it as how it is
Tuan
Please Log in or Create an account to join the conversation.
- jvh
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 13
- Thank you received: 0
11 years 8 months ago #47226
by jvh
Replied by jvh on topic View list - ordering?
I see, and understand. But is there another column i can sort on that will give me a better listing according to the time the registrant has been saved ? Maybe an id that are generated during save or something?
I am thinking maybe this will give a more correct listing than the listing shown today?
I am thinking maybe this will give a more correct listing than the listing shown today?
Please Log in or Create an account to join the conversation.
- jvh
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 13
- Thank you received: 0
11 years 8 months ago #47229
by jvh
Replied by jvh on topic View list - ordering?
I am trying to sort on ID but it does not help. Nothing changes. As you can se below i have changed the following lines:
Code:
{
if (isset($config->include_group_billing_in_registrants) && !$config->include_group_billing_in_registrants)
{
$sql = 'SELECT * FROM #__eb_registrants WHERE event_id=' . $eventId .
' AND is_group_billing=0 AND (published=1 OR (payment_method LIKE "os_offline%" AND published != 2)) ORDER BY id asc';
}
else
{
$sql = 'SELECT * FROM #__eb_registrants WHERE event_id=' . $eventId .
' AND (published=1 OR (payment_method LIKE "os_offline%" AND published != 2)) ORDER BY id asc';
}
$db->setQuery($sql);
$rows = $db->loadObjectList();
}
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Away
- Administrator
-
11 years 8 months ago #47232
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic View list - ordering?
Try to change it to register_date DESC to see how it goes.
Tuan
Tuan
Please Log in or Create an account to join the conversation.
- jvh
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 13
- Thank you received: 0
11 years 8 months ago #47233
by jvh
Replied by jvh on topic View list - ordering?
Somehow it does not seem to change anything in my list. No matter what i do it does not seem to have an effect.
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Away
- Administrator
-
11 years 8 months ago #47300
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic View list - ordering?
Maybe it is caching issue ? Could you please check it again ? or if you want, submit a support ticket so that I can check it for you.
Regards,
Tuan
Regards,
Tuan
Please Log in or Create an account to join the conversation.
Moderators: Tuan Pham Ngoc
Support
Documentation
Information
Copyright © 2026 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.