View list - ordering?

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
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
  • Administrator
More
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

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

More
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?

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

  • Tuan Pham Ngoc
  • Away
  • Administrator
  • Administrator
More
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

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

More
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?

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

More
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
  • Administrator
More
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

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

More
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
  • Administrator
More
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

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

Moderators: Tuan Pham Ngoc