Support

August 29, 2017 at 11:30 am

Hello,

I try to count number of registrations by ticket and status, but its not working with a filter on the TKT_ID

$registrations_approved = EEM_Registration::instance()->count(array( array( ‘TKT_ID’ => $ticket->ID(), ‘STS_ID’ => EEM_Registration::status_id_approved ) ), ‘REG_ID’, true);

The “$ticket” object works.
Its also works if I replace TKT_ID by EVT_ID, like this example :

$registrations_approved = EEM_Registration::instance()->count(array( array( ‘EVT_ID’ => $id_event, ‘STS_ID’ => EEM_Registration::status_id_approved ) ), ‘REG_ID’, true);

Do you have a suggestion to fix it ?
Thanks a lot,

August 29, 2017 at 11:56 am

Thx for your reply. Effectively I don’t see a difference between our codes.
For my part I got 0 on my results for every tickets.
Even if I put directly the ticket ID by a valid number.
Here is my code

// Get the ID of the page.
$event = EEM_Event::instance()->get_one_by_ID($id_event);

if ($event instanceof EE_Event) {
$tickets = $event->tickets();

foreach ($tickets as $ticket) {
if ($ticket instanceof EE_Ticket) {
$registrations_approved = EEM_Registration::instance()->count(array( array( 'TKT_ID' => $ticket->ID(), 'STS_ID' => EEM_Registration::status_id_approved ) ), 'REG_ID', true);
$registrations_not_approved = EEM_Registration::instance()->count(array( array( 'TKT_ID' => $ticket->ID(), 'STS_ID' => EEM_Registration::status_id_not_approved ) ), 'REG_ID', true);
?>
<li>
<a href="/outil-tableau-de-bord/?type=event&evtid=<?php echo $id_event; ?>&tktid=<?php echo $ticket->ID(); ?>">
<?php echo $ticket->ID() . ' - ' . $ticket->get('TKT_name') . ' - ' . $registrations_approved . 'A ' . $registrations_not_approved . 'NA' ?>
</a>
</li>
<?php
}
}
}

Here is the results of this code

781 – Test 24 | 200€ – 0A 0NA
789 – T1 | 120€ – 0A 0NA
790 – T3 | 199€ – 0A 0NA
791 – T4 | 31€ – 0A 0NA
792 – T5 | 130€ – 0A 0NA
793 – T6 | 2€ – 0A 0NA
794 – T7 – BABA | 120€ – 0A 0NA
795 – T8 | 120€ – 0A 0NA
796 – T9 AB | 120€ – 0A 0NA