Update the order status value

[ahmed31916]

Hello,

This query updates the status delivery for the order number 2, but it doesn't store the value in the database.

Code: Select all

\Aimeos\MShop::create( $this->context(), 'order' )->get(2)->setStatusDelivery(2);

Why?

[marnel]

Still trying to understand all of this like you but can you try this ?
I think it will work

Code: Select all

$s = \Aimeos\MShop::create( $this->context(), 'order' );
$order = \Aimeos\MShop::create( $this->context(), 'order' )->get(2);
$order->setStatusDelivery(2);
$s->save($order);

[ahmed31916]

Thanks for your contribution.
The same result.

this is the debug result:

Code: Select all

    "order.id" => "2"
    "order.baseid" => "2"
    "order.siteid" => "1.3."
    "order.channel" => ""
    "order.datepayment" => "2022-05-24 06:30:54"
    "order.datedelivery" => null
    "order.statuspayment" => "5"
    "order.statusdelivery" => 2
    "order.relatedid" => ""
    "order.ctime" => "2022-05-24 06:26:32"
    "order.mtime" => "2022-05-24 06:30:54"
    "order.editor" => "Paul Mcpherson"
    ".statusdelivery" => "4"

statusdelivery changed but doesn't stored in the database.

[aimeos]

@marnel is right, you have to call the save() method to store the modified items.

In a multi-site setup, you also need to make sure that the currently used site is the same as the site (siteid) of the item.

[ahmed31916]

thanks @aimeos, thanks @marnel.
It works after changing the context site locale.