CB Auto Actions: How to update CBSubs [PAYMENT_STATUS] field based on CB field?

Hi,

Is there a way to updated the CB Subs payment_status field using CB Auto Actions based on a CB field?

I have created a new CB field called cb_processed as a select field with Yes and No as the field options and would like to be able to update the payment_status field to show Processed when Yes has been selected for the cb_processed field. Is this possible?

Or is it possible to added the cb_processed CB field as an additional column in the CB Subs Baskets page?

Any help to achieve either of these options would be greatly appreciated.

Thank you,

Dion.

Why specifically are you wanting to do this? I highly suggest not tampering with the basket. Those values need to updated properly through API. Just changing the value directly in database for example will not tell CBSubs that the basket has been processed.

If you want the basket status to output as a field I suggest using a CB Query Field with the below query.


The above will give the payment status of the most recent basket for a user and output it as a field using CB Query Field.

Thanks for the reply, our client have multiple admin staff who login to the backend of the website and check the CB Subs Baskets page for new orders and have requested if there is a way they could mark orders as "processed" once they have processed the orders so when other admin staff login in and check the CB Subs Baskets summary page, they'll know what orders have been processed by the other admin staff.

Is there a way to display the results of the new CB field "processed" (I created) on the CB Subs Baskets summary page as a new column on the Baskets summary page that would resolve this issue for them?

Thanks,

Dion.

There is no "processed" stage to a basket in that regard. It's either initialized, pending, or paid. If you're using an offline gateway the admin would pay the basket and another admin would see it's paid and can't pay it again.

To add a new column you'd need to modify the basket display XML, but it does no good unless you're familiar with our XML API, which we will document in the future. At any rate if you want to take a stab at it the below XML file is what you'd need to edit.

components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/xml/views/view.showpaymentbaskets.xml