Order – Payment Status

Hi !
How to get the payment status of an order ?

Thanks.

Topic

[Dmitriy PasechnikParticipant]

Hello Tyler.

If you want to see payment status of an order via web interface – then you can see it in product`s view page (e.g. /admin/order/view/1, or Admin -> sales -> orders -> view order -> ‘Payment status’ in ‘general’ section)

Or, if you want to get it in code, then you should use
\Oro\Bundle\PaymentBundle\Provider\PaymentStatusProvider::getPaymentStatus($order)
method

[TylerParticipant]

Hi Dmitriy,

Yes I know this method ?
But with this method I have to loop on each orders to know the payment status.
Or there is another way to search my orders by payment status into the code ?

I want to explose as API my all order by payment status like a search.
I want to request my order like orderByPaymentStatus($status), then the code return the orders with the status given.
Is it possible ?
I saw the table payement_status doesnt have relation with others tables, but the entity_class is referer.
Have I to make a custom request between both tables ?
Like

MySQL

Select oro_order.*, oro_payment_status.payment_status from oro_order, oro_payment_status where oro_payment_status.entity_identifier = oro_order.id AND oro_payment_status.payment_status :operator :status and oro_payment_status.entity_class = 'Oro\\Bundle\\OrderBundle\\Entity\\Order';

1	Select oro_order.*, oro_payment_status.payment_status from oro_order, oro_payment_status where oro_payment_status.entity_identifier = oro_order.id AND oro_payment_status.payment_status :operator :status and oro_payment_status.entity_class = 'Oro\\Bundle\\OrderBundle\\Entity\\Order';

[Dmitriy PasechnikParticipant]

Yes, you have to make custom query. But it would be better to do DQL query instead of SQL (to get array of ‘Order’ entities instead of array of … arrays :))
Something like this:

PHP

$orders = $em->createQuery( "SELECT o FROM Oro\Bundle\OrderBundle\Entity\Order o JOIN Oro\Bundle\PaymentBundle\Entity\PaymentStatus ps WITH ps.entityIdentifier = o.id AND ps.entityClass = 'Oro\Bundle\OrderBundle\Entity\Order' WHERE ps.paymentStatus = :paymentStatus" )->execute(['paymentStatus' => \Oro\Bundle\PaymentBundle\Provider\PaymentStatusProvider::FULL]);

1 2 3 4 5

$orders = $em->createQuery(     "SELECT o FROM Oro\Bundle\OrderBundle\Entity\Order o         JOIN Oro\Bundle\PaymentBundle\Entity\PaymentStatus ps WITH ps.entityIdentifier = o.id AND ps.entityClass = 'Oro\Bundle\OrderBundle\Entity\Order'         WHERE ps.paymentStatus = :paymentStatus" )->execute(['paymentStatus' => \Oro\Bundle\PaymentBundle\Provider\PaymentStatusProvider::FULL]);

[TylerParticipant]

Haha, of course.
I made a Subquery and It works.

Sorry, I was sure we could not use the joins without a foreign key…
I will try your solution know :)

Thx.

[Author]

Replies