Hello. I need to fetch orders using customn filters. I also need payment information. Why there is n

U0145CP9Q6Q

Hello. I need to fetch orders using customn filters. I also need payment information. Why there is no relation to spy_sales_payment table in src/Orm/Zed/Sales?
And how can I properly add joining with this table?
Thanks.

UKJND3A3H

hey alex 👋 🙂

U0145CP9Q6Q

Hi Andreas

UKJND3A3H

I am not tooo close to all that, but my assumption is that in spryker ootb, different payment type is typically represented by different order state machine being used/assigned to order (order items)

UKJND3A3H

on previous projects, we changed that to have few state machine processes dealing with different payment types and stored a reference to payment information

UKJND3A3H

I believe though that payment information is stored somewhere for orders, can’t remember where 😇

UKJND3A3H

“fetch orders using custom filters”: that’s for which layer? yves? zed?

U0145CP9Q6Q

I need orders for zed.
Yes i know that there can be different state machines and etc.. But i'm didn't create any new state machines.
Just using OOTB functionality. I can join with everything (spy_sales_shipment, spy_sales_order_items etc) but not with payment. They put shipment relations into src/Orm/Zed/Sales but Pyament relations went somehow to src/Orm/Zed/Payment . And there is a relation to spy_sales_payment table. As for me it looks weird.
And when using \Orm\Zed\Sales\Persistence\SpySalesOrderQuery i can't join to spy_sales_payment table. But in this table there is foreign key to order_id

U0145CP9Q6Q

Join methods are generated here \Orm\Zed\Sales\Persistence\Base\SpySalesOrderQuery . But since there is no relation to payment - this method doesn't exist

Andriy Netseplyayev

Hi @U0145CP9Q6Q if you want to join with payments, then you should be looking fo SpySalesOrderQuery and it’s payment-related methods

Andriy Netseplyayev

order itself doesn’t have foreign key to payment, but payment does. That’s why relation and model methods should be present

U0145CP9Q6Q

hi @UKJSE6T47. That is what i'm talking about.
Methods should be present in \Orm\Zed\Sales\Persistence\Base\SpySalesOrderQuery but they don't.

U0145CP9Q6Q

Maybe i need to regenerate smth? or maybe you have another options

Andriy Netseplyayev

@U0145CP9Q6Q hmmm, can you try something, I think I found an issue

Andriy Netseplyayev

please check SpySalesOrderQuery::useOrderQuery()

Andriy Netseplyayev

it seems that the php relation name in propel schema was wrongly named

Andriy Netseplyayev

exactly

Andriy Netseplyayev

this is the reason, should be named after “Payment” instead.

Andriy Netseplyayev

changing that on Spryker side will mean a major update. But we will see what we can do here.

U0145CP9Q6Q

so should be SalesOrder?

U0145CP9Q6Q

or what is the correct variant?

Andriy Netseplyayev

I think you don’t need to change anything. Just use for now useOrderQuery() method. If you like, you can introduce “usePaymentQuery()” and other similar one-s in your Orm\Zed\Sales\Persistence\SpySalesOrderQuery and push it to your code base, that will help you to avoid further confusement

Andriy Netseplyayev

plus I don’t think you can overwrite phpName and refPhpName properties coming from core on project level..

U0145CP9Q6Q

ok. thanks. also another question since you are here so far.
I need also shippng cost. I see that you have spy_sales_shipment table. But there is only name. On item level I also don't see anything. How can i get the shipping cost for order? I see shipping costs only in spy_shipment_method_price . But this is not related to sales as for me

U0145CP9Q6Q

I'm using joinWithSpySalesShipment but it gives me everything except shipping costs

Andriy Netseplyayev

In spryker, shipping costs are added to the expenses, which you can find in spy_sales_order_total.order_expense_total

Andriy Netseplyayev

if you need more granular information about expenses (especially if you have multi-shipment or another expenses), you can check the spy_sales_expense table. There you have “type” column that can give you an idea about what kind of expense it is

U0145CP9Q6Q

thanks

U0145CP9Q6Q

@UKJSE6T47 again about useOrderQuery method. It will return to me the instance of SpySalesPaymentQuery. So the result will contain only payment data but not order's data. How to make it to be in result of SpySalesOrderQuery?

Andriy Netseplyayev

It should look like this, approx.

$ordersQuery
->useOrderQuery() 
->   withColumn(SpySalesPaymentTableMap::COL_ID_PAYMENT, 'payment_id')
->endUse()
->find()
->toArray()

Andriy Netseplyayev

the formatting is crap.. You can find lots of examples in spryker core code, by searching for “->use” in the code base