Show unpaid registrants in list

Hello,

I want to show both completed (=paid) participants and uncompleted (=unpaid) participants in the registrants view of an event, ideally with a note in the overview if they have paid or not.

Is this possible ?

Cheers,
Markus

Hi Markus

For unpaid registrants, what payment method they are using? Also, what's the page you are talking about (EB has different pages to show registrants from backend and frontend)

Tuan

payment method is paypal.

I am talking about a view like here:

internationalkiteboarding.org/index.php/...-world-championships

instead of the paid entries (when clicking on "view entries") I want to show all entries, with an additional column of "paid" and "unpaid" (I can work that out from the status)

I looked at components/com_eventbooking/registrantlist/view.html.php and I guess it belongs to tbl.published but couldnt work it out...

Thanks a lot,
Markus

And one more question... how can I sort the registrant list, i.e. by gender and then by lastname.frstname ?

Hi Markus

In that file, you can remove the line:

and it should show all registrants. You could not sort by render, you can only sort it by one of the core field such as first name , last name..by modifying the order by clause of the query. Change from

$query->order('register_date DESC');

to
$query->order('first_name, last_name') ;

for example

Hope it gives you some help

Tuan

Hi Tuan,

great, I tried with the other lines, that works perfectly.

Any suggestion on how to add something in the end of the line like "complete" or "paid" to mark the ones that have completed payment and those who dont ? I guess I could use something like "if tbl.published=1 then echo 'complete'" or so ?

Cheers,
Markus

if ($row->published == 1)
{
echo 'Paid';
}
else
{
echo 'Pending';
}

Something like that

Tuan

Can we get this option paid/unpaid into the core extension? I need this too

. Strange that someone want to show unpaid registrants (who doesn't make payment) as registrants in the frontend. What's the reason for doing it ?

Tuan

I use offline payment and paypal payment. So i have user with status paid and status unpaid. When i see the money on my bank i switch status from unpaid to paid. Clear enough?