Easter Sale 2025

  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: Tickets Sold (count) in Category View

Tickets Sold (count) in Category View 9 years 5 months ago #33110

  • massageindy
  • massageindy's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 18
  • Thank you received: 2
People should be able to see which events are popular based on tickets sold from the list view (category view). HOw can we add the sold tickets or reservations total for each event?
The administrator has disabled public write access.

Tickets Sold (count) in Category View 9 years 5 months ago #33125

  • alexp
  • alexp's Avatar
  • OFFLINE
  • RSJoomla! Official Staff
  • Posts: 2253
  • Thank you received: 180
There is no built-in feature that would allow you to do this, but you might just be able to this via template overrides. Scripting knowledge required!
Please note: my help is not official customer support. To receive your support, submit a ticket by clicking here
Regards,
RSJoomla! Development Team
The administrator has disabled public write access.

Tickets Sold (count) in Category View 9 years 5 months ago #33126

  • massageindy
  • massageindy's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 18
  • Thank you received: 2
Yes i did figure it out and it is working. If anyone else wants this feature let me know and ill share how i did it. Total number of people coming seems something that is critical information to be known by all parties involved. Surprised this isnt a standard feature.

Even in the backend, the admin view only shows how many subscribers to an event. If 10 people each bought 2 tickets thats 20 tickets. Seeing "10" subscribers doesnt prepare a host for proper headcount.
The administrator has disabled public write access.

Tickets Sold (count) in Category View 8 years 11 months ago #34925

  • john16
  • john16's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 1
Hello all

I'am also looking for this feature since people can buy multiple tickets. It's hard to say how many tickets are sold.
So Massageindy, i would love to hear how you managed to do this.

Thanks a lot
The administrator has disabled public write access.

Tickets Sold (count) in Category View 8 years 11 months ago #35050

  • massageindy
  • massageindy's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 18
  • Thank you received: 2
Below you will see how we use the html overrides to include the code below to display ticket count sold but we also wanted to change a message displayed based on that ticket count number. For example we charge less if their group is larger. So we take a deposit that doesnt change in price, but the final price at the door will vary based on how many join the event. It encourages larger groups. That part can be easily deleted from this code below.


<?php
$db = &JFactory::getDBO();
// Amount of Subscriptions
$db->setQuery("SELECT SUM(ut.quantity) FROM #__rseventspro_user_tickets ut LEFT JOIN #__rseventspro_users u ON ut.ids = u.id WHERE u.ide = '".$event->id."'");
$subs = $db->loadResult();?>
<p 
<?php if ($subs == 0) echo 'style="color:red"'; ?>
<?php if ($subs > 0) echo 'style="color:green"'; ?>
<?php
echo '<b>';?>
<?php if ($subs == 0) echo '0'; ?>
<?php
echo ''.($subs);
echo ' Deposits Paid</b></br>';?>
<?php if ($featured) echo 'Lets Party! Time is set!.</p>'; ?>
<?php if ($subs == 1) echo '$70 per person. 2 more deposits needed for $60 rate. 5 more deposits needed for the $50 rate.</p>'; ?>
<?php if ($subs == 2) echo '$70 per person. 1 more deposit needed for $60 rate. 4 more deposits needed for the $50 rate.</p>'; ?>
<?php if ($subs == 3) echo '$60 per person. 3 more deposits needed for $50 rate.</p>'; ?>
<?php if ($subs == 4) echo '$60 per person. 2 more deposits needed for $50 rate.</p>'; ?>
<?php if ($subs == 5) echo '$60 per person. 1 more deposit needed for $50 rate.</p>'; ?>
<?php if ($subs > 5) echo '$50 per person because 6 or more deposits have been paid! </p>'; ?>
The administrator has disabled public write access.
The following user(s) said Thank You: paul.andrews
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!