Generate order number before save order

[krzysiekp]

I have additional column in mshop_order => order_no
How can I generate unique an order number just before it is saved to the database?

[aimeos]

There's already a column named invoiceno which you can use. If you just want the order ID to be displayed differently, you can also add a macro to the boot() method in your ./app/Providers/AppServiceProvider.php file.

Invoice number:

Code: Select all

\Aimeos\MShop\Order\Item\Standard::macro('invoicenumber', function($order) {
   return 'INV-' . $this->get( 'order.invoiceno', '' );
});

Order number:

Code: Select all

\Aimeos\MShop\Order\Item\Standard::macro('ordernumber', function($order) {
   return 'No-' . $this->getId();
});

If you really need an extra column with a totally different number, than you have to overwrite the saveBase() method of the order manager: https://github.com/aimeos/aimeos-core/b ... #L604-L623

[krzysiekp]

Thanks for reply

[krzysiekp]

Is it possible get id from the newly added order before saveBase method has executed ?
I need create order number base on id. Order number is new column in database in mshop_order (order_no) table.
I want to save order with order number in one transaction.

[aimeos]

If you add a customer column "order_no", you can set the value before saving, so it's saved at once but you can't get the mshop_order.id value before saving because it's an auto increment value from the database.

[krzysiekp]

Could you give a example how to do it ?

[aimeos]

How to add a new column to a table for your order_no value is described here:
https://aimeos.org/docs/latest/models/extend-managers/

[krzysiekp]

I'm more interested in how to solve the problem of assigning an order number (new column in mshop_order) based on the order ID (mshop_order.id) during order placing

[aimeos]

Like said, this isn't possible because the order ID is auto generated by the database.