Hi
You can edit the code alitle to have it sending to Pending registrants (who use offline payment) as well . The steps are :
1. Open the file components/com_eventbooking/models/reminder.php
2. Find the code below :
Code:
$sql = 'SELECT a.id, a.first_name, a.last_name, a.email, a.register_date, a.transaction_id, b.id as event_id, b.title AS event_title, b.event_date '
.' FROM #__eb_registrants AS a INNER JOIN #__eb_events AS b '
.' ON a.event_id = b.id '
.' WHERE a.published=1 AND a.is_reminder_sent = 0 AND b.enable_auto_reminder=1 AND (DATEDIFF(b.event_date, NOW()) <= b.remind_before_x_days) AND (DATEDIFF(b.event_date, NOW()) >=0) ORDER BY b.event_date, a.register_date '
.' LIMIT '.$numberEmailSendEachTime
;
Change it to :
Code:
$sql = 'SELECT a.id, a.first_name, a.last_name, a.email, a.register_date, a.transaction_id, b.id as event_id, b.title AS event_title, b.event_date '
.' FROM #__eb_registrants AS a INNER JOIN #__eb_events AS b '
.' ON a.event_id = b.id '
.' WHERE (a.published=1 OR (a.published=0 AND a.payment_method LIKE "os_offline%")) AND a.is_reminder_sent = 0 AND b.enable_auto_reminder=1 AND (DATEDIFF(b.event_date, NOW()) <= b.remind_before_x_days) AND (DATEDIFF(b.event_date, NOW()) >=0) ORDER BY b.event_date, a.register_date '
.' LIMIT '.$numberEmailSendEachTime
;
Regards,
Tuan
