How to filter orders by payment status for custom actions

Hi:

This thread is related to https://forum.oroinc.com/orocommerce/topic/can-i-add-actions-to-orders-screen.

I’d like to show this action only for orders not fully paid.

I was looking at the attributes for the order in oro/commerce/src/Oro/Bundle/OrderBundle/Entity/Order.php but I can’t see any direct way to access the PaymentStatus.

I see there’s a table storing the payment status (oro_payment_status) but I’m not sure how to use it in the action configuration.

Thanks.

Topic

[Andrey YatsenkoModerator]

To hide an action you can use “preconditions”.
For example, you can check actions.yml at OrderBundle.
You can fetch the payment status from the database the same way it is fetched at the datagrid by using “@find_entity” in “preactions”.

[Mauro ChojrinParticipant]

Hi Andrey:

Thanks again :)

I believe the link to actions.yml was broken, here’s the correct reference: https://github.com/oroinc/orocommerce/blob/master/src/Oro/Bundle/OrderBundle/Resources/config/oro/actions.yml.

I’ve been doing some experiments with this but I can’t seem to work it out… the problem I have now is that I need to issue a query using an AND.

This is the configuration I have so far:

YAML

- '@find_entities': class: Oro\Bundle\PaymentBundle\Entity\PaymentTransaction where: '@and': - entityClass: 'Oro\Bundle\OroBundle\Entity\Order' - entityIdentifier: $.data.entityIdentifier attribute: $.paymentTransactions

1 2 3 4 5 6 7

- '@find_entities':     class: Oro\Bundle\PaymentBundle\Entity\PaymentTransaction     where:         '@and':             - entityClass: 'Oro\Bundle\OroBundle\Entity\Order'             - entityIdentifier: $.data.entityIdentifier     attribute: $.paymentTransactions

This isn’t actually for the filter but I think it’s the same issue (I’m trying to use this query to populate the popup where the user is supposed to enter the details of the new payment transaction).

I tried different options but I believe I’m missing the correct syntax for the and…

I am getting every payment transaction (instead of just the ones related to the order I’m editing…)

Thanks

[Mauro ChojrinParticipant]

Ok, so I finally got this thing working. The answer I was looking for was here.

My configuration now looks like this:

YAML

form_init: - '@find_entities': class: Oro\Bundle\PaymentBundle\Entity\PaymentTransaction where: and: - e.entityClass = '%oro_order.entity.order.class%' - e.entityIdentifier = :id query_parameters: id: $.data.id attribute: $.paymentTransactions

1 2 3 4 5 6 7 8 9 10

form_init:             - '@find_entities':                 class: Oro\Bundle\PaymentBundle\Entity\PaymentTransaction                 where:                     and:                         - e.entityClass = '%oro_order.entity.order.class%'                         - e.entityIdentifier = :id                 query_parameters:                     id: $.data.id                 attribute: $.paymentTransactions

Thanks for your help!

[Author]

Replies