Please Log in to join the conversation.
We've plans to implement frontend payment history display. It has not started development. Please understand we've over 20 products that all need to be maintained so they are cycled through. My focus is making PayPal Pro and Stripe PSD2 complaint since banks decided to enforce a new EU law now instead of in September when it goes in affect. This has interrupted CB Activity 5.0.0 development, which I will return to once these implementations are done. I do not know when we will get to implementing frontend payment history, but I suppose technically you could implement it using CB Query Field and its Multiple Row output by querying _cbsubs_payments. The below for example should work.You told us about payment numbering scheme, is this still in dev ?
SELECT * FROM `#__cbsubs_payments` WHERE `by_user_id` = '[user_id]' ORDER BY `time_paid` DESC
<table>
<thead>
<tr>
<th>Invoice</th>
<th>Item</th>
<th>Amount</th>
<th>Date</th>
</tr>
</thead>
<tbody>
<tr>
<td>[column_invoice]</td>
<td>[column_item_name]</td>
<td>[column_mc_gross]</td>
<td>[column_time_paid]</td>
</tr>
</tbody>
</table>
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.
$_PLUGINS->trigger( 'onCPayAfterPaymentStatusChange', array( &$user, &$paymentBasket, &$subscriptions, $unifiedStatus, $previousUnifiedStatus, $occurrences, $autorecurring_type, $autorenew_type ) );
$_PLUGINS->trigger( 'onCPayAfterPaymentStatusUpdateEvent', array( &$user, &$paymentBasket, &$subscriptions, $unifiedStatus, $previousUnifiedStatus, $eventType, &$notification ) );
SET @a = 0;
UPDATE `#__cbsubs_payments` SET `invoice` = CONCAT( 'PAYMENT-', ( @a:=@a + 1 ) ) WHERE `payment_basket_id` = 47
SET @a = 0;
UPDATE `#__cbsubs_payments` SET `invoice` = CONCAT( `invoice`, '-', ( @a:=@a + 1 ) ) WHERE `payment_basket_id` = 47
SET @a = 0;
UPDATE `#__cbsubs_payments` SET `invoice` = CONCAT( SUBSTRING_INDEX( `invoice`, '-', 1 ), '-', ( @a:=@a + 1 ) ) WHERE `payment_basket_id` = 47
Please Log in to join the conversation.