Sign up to access "Build an E-Commerce Platform" right now.

and we're going to have an order variation pivot table, which gives us the products that have been ordered and the quantities. That means that over on our orders page, we can show the order details like the subtotal, remember which is static in case the variation prices change,

but we can then show each of the variations that are attached to that order as well. We're going to be doing this down here directly after we've saved the order. Now, things are getting a little bit long here. We're doing lots of different things here.

We're going to be tidying this up a little bit later with events and listeners, but for now, let's just put it all in here just so it's easy to see what we're doing. Okay, before we do anything, let's go ahead and create out this pivot table to sync our order with our variation. So let's go ahead and make a migration, and we'll create our order variation table,

and let's head over to that order variation table, and this is pretty straightforward. We just need two foreign IDs. So we need the order ID, and we'll constrain that,

and we need the variation ID, and we'll constrain that, and we also, of course, want to make sure we show how many we've ordered. So let's go ahead and add in some quantity. Okay, let's go ahead and run phpArt and migrate, and we're good.

So let's head over to our order model first of all, and let's create this relationship out. So we're going to go ahead and say variations, kind of makes sense. We'll keep it the same name, and of course, because this is a pivot,

we want to say belongs to many, variation, and we've got that pivot in there. So let's say with pivot, and we'll put quantity in there, and we'll also say with timestamps, so we get them timestamps filled when we insert this. Okay, that's pretty much it.

Now we need to figure out how to attach those variations. Now normally what we would do is something like order, variations, and attach. So we've already saved this, so we're just attaching these now, and we would say cart and contents.

Remember, that gives us back a collection of variations. The only problem with this is this will attach them, but not with the quantities. So if we just head over to order variation, it won't fill in the quantities. So what we want to do is map through this and build up an array with the quantities in there,

kind of like what we did over on our cart model when we synced our available quantities. Remember, we mapped through with keys and returned this array structure, so we had the ID of the variation and the quantity. So we want to do something very similar to this directly within here.

So we'll go ahead and grab the contents from the cart, but then we'll go ahead and map through these with keys, so we get them keys output for each of the variations, and let's go ahead and just create a standard closure in here just to keep this simple,

and let's grab the variation for each of them loops, and then we're going to go ahead and return from here the variation ID and then the pivot information, which is the quantity. So we know that that is variation, pivot, and quantity.

Okay, so we'll tidy this up with a short closure in just a minute, a short function in PHP. Let's just see if this works first of all. So if we come over to the database under orders, let's get rid of this order and let's come over and reorder something in here.

So we'll just choose any address and let's just click confirm order and pay. Okay, so it looks like we've got a variation ID being inserted here of zero, which of course because we have that constraint set up isn't working. Let's just figure out what we're doing here.

The first thing we do want to do is make sure this is an array, and second of all, that is what we want to do. We're not assigning this, we're using an arrow in here, so that should fix that up. Now that order will have been created, so let's get rid of that.

Come back over and let's try and create this again. Great, so that looks like it's worked. So we've got the order created with an ID of seven, and over in order variation, sure enough, that variation there,

size eight in that one that we chose with a quantity of one, has been attached. Now let's just delete this in here and delete this order, and let's go and in fact just clear up all of these empty carts. So why don't we just truncate this and we'll do a restart entity in Cascade.

Let's go over, give this a refresh, that'll probably break because of course the cart can't be found anymore, and we'll fix this up later, but let's get rid of our session, and let's just start from scratch.

So we'll go over to Nike Air Force One. Let's add one of these, and let's search for Nike again, and we'll add one of these. There we go.

So when we order both of these, if we change the quantities up as well, so let's do two and five. So when we order both of these, this should work nicely. I'm going to go ahead and log in just for the sake of not having to fill out all of this information again,

and let's just choose an address and confirm this. Okay, so let's head over to the orders table that has of course been created, and then over in order variation, we've got two products now attached to that order, both of them different variations, which we know,

and then of course the correct quantities have also been attached here as well. So of course when we see that order, we know exactly how many to dispatch, and that's pretty much it. We are now attaching the variations to an order.