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

But now of course we want to go ahead and actually create the order So we're gonna test this signed out first of all in the guest state And then we'll go ahead and look at this when we're signed in as well Okay, so at the moment. We've got a huge amount of information that we have to fill out in here

What I'm just gonna do while we're testing this is Pre-populate this within here just so we don't need to keep typing it out over and over again Let's just check the users that we've got in the database here And we'll get rid of one of these now that violates that because we've got a constraint

So let's just choose another email address that doesn't exist within here and Let's go ahead and fill in the address here as well, so we'll just say line one

city and Postcode just so we've got that data in there, and we don't need to fill it out every single time So when I click confirm order and pay that should go ahead and then store that now We've actually got an error here where we've got call to undefined relationship array on model shipping address

the reason for that is down here what we're doing is And we should have picked up on this earlier. We go down to checkout. We're saying where belongs to or user So let's change this around a little bit and make it a little bit messy But let's go ahead and assign this shipping address to

shipping address query That's going to give us our query builder back, and then we can check if the user is signed in so auth User and then if that's the case we can then go ahead and use the where belongs to so we can say this

shipping address equals this shipping address Where belongs to or User like so and then we can continue down with this after here so we can say this

Shipping address, and then we can just carry this on first or create so first or create pass in this shipping form and Then we can just carry on with what we did before

By turning that into brackets and going ahead and associating the user on that we've already covered Exactly what this does that should make a little bit more sense, okay? let's just test this out, so let's go over and hit confirm order and pay and Yeah, so we've got this as a public property, so let's change

this to protected and Let's go over Okay, so that should have stored that address for us Let's just fix that up yet line one city and postcode with no user associated

Let's go over and just sign in and check this out to make sure we didn't break anything So I'm just going to sign in as my user Come over to our checkout, and let's just store this and that should have created a new one of course because we don't overwrite This address with that user and if we store this again

It should just do nothing because we've already got it in there so a little bit messy But that should be absolutely fine to get us going Okay, so we're gonna go ahead and log out because we don't want to be signed in for this And let's go ahead and read that because that's cleared our car out so at the moment. This is out of stock

Let's go over to our stocks and just get rid of this in here and let's add this back in and We can now come over and look at confirming this great

So what do we want to do here now that we've fixed this issue up with the shipping address? Well, we want to just create an order out We don't want to persist it just yet because we've got lots of things that we need to attach to this So let's go ahead and say order make so we can start to make it out

With all the details that we need and then finally save it to the database so in here We need the user's email address Regardless of whether they are signed in or signed out and we already have all of that information in the account form So depending on the additional details you do have in the account form

You could just go ahead and use array merge so we could array merge in This account form which just contains the email at the moment And then we can merge in other details like the subtotal and we know that we've got the subtotal from the cart so let's bring in our car interface into here and

Then let's come down and say car Subtotal like so there we go. So that should create that out for us Let's just die dump on this order just to make sure that information is in there So the we should get the email Mabel at code course comm and we should have the correct subtotal in there

Which we do great Next thing to do is attach the user if they're signed in and to do this we can just say order user associate and we can associate

Currently signed in user if this is null, it would just be ignored now over on our order We don't have a user relationship at the moment. So let's go ahead and add that before we start to associate this so let's go ahead and crowd a user relationship, which is just going to be a belongs to

relationship and There we go. Okay. So let's again die dump on that order and let's check it out click on there and you should see now this under attributes and User ID is null now if we were signed in and let's go ahead and just sign in again

Just for clarity here just to make sure we don't break anything and we come over We should see now user ID set to one and we should also see this relations property filled With that user model as well in there. Great. So that's working really nicely Okay, so let's go ahead and log out again go back to our guest car and again, we're just gonna have to

read this because the session gets completely wiped and We're back to here, okay So the next thing is associating the shipping type and the shipping address So we need two more belongs to relationships over on our order

Remember we set these up in the database over in orders shipping address ID and shipping type ID We already know what both of these are. So this should be pretty simple to Get added. So let's create out another method in here shipping type and

That's going to belong to a shipping Type and then we want the shipping address as well so shipping address and Reference the shipping

Address model great. So now we can associate both of these things much like we've done here So let's let me just copy this down. It's pretty similar and let's say shipping type and Let's associate This shipping

Type now just before we do this. Let's just die dump on this shipping address, which is what we Create up here and then assign just to make sure we've got this available and Yeah, it looks like we do. So we've got this model in here and

It looks like that information isn't actually filled so let's go and just make sure we assign this so this Shipping address and assign that to that saved shipping address really important and let's try that again We get true, of course because we're just saving that so let's assign that in here

I'll probably make more sense. And there we go. Great So we get the shipping address back that we actually want to associate in that property which we can then attach just here So we've got the shipping type Let's do the same with a shipping address

And we should be good so shipping address and Let's see what we get. So let's die dump on our order and let's come over Confirm order and again, we should get the shipping type ID in there Which we know is one because we have chosen the free package

The shipping address here is six Which should be that shipping address just here because we're not authenticated remember and that looks good So now finally that we've attached all of these things We can go ahead and save this now persist it to the database

So create the order remember behind the scenes this attaches that you you ID add the subtotal add The user if they are authenticated and attach the shipping a type and the shipping address and any other information You need to so finally, let's just get rid of this dummy data that we've got in here fill it out and see this order Created for the first time. So let's get rid of all of this information

And let's head over. Okay, so let's go and say Mabel Code course comm and we'll say one two, three code road code city To make silly things up and just put one two, three, four five and let's choose UPS standard and

Let's hit confirm order. Okay, so great looks like we have forgotten to add a default time Or a date and time for our packaged at and our other column. So let's fix that up really quickly Over in our create orders table there's a couple of ways that we could do this we could do this at the migration level or we could do it at our

Model level when we create it like this Let's look at both options, but let's probably go for the model level What we can actually use here is the use current method and what that's going to do is just fill that with a current timestamp When we create a record so it's entirely up to you

I would always lean for doing this in the model just makes a little bit more sense And we could technically do that for a place that as well. So let's just have a look at this so if you did want to go down this route just roll this back and Remigrate it and if you come over here now and create another order that should work. I'm not gonna do that

I'm actually gonna go ahead and do this at the model level So let's go ahead and roll this back and re-migrate and let's go over and we could technically just say order shipped at and order packaged at and just assign these all in the same order or All in the same row you can do them on multiple lines if you want, okay

Let's go over and just refill out this information a little bit annoying That's fine. One, two, three code road and code City and one two, three

Four five, let's choose the other shipping option hit confirm order. And there we go Now nothing happens at the moment, of course because we're not redirecting anywhere But if we come over to our orders table, there we go So we've got a uuid generated for us the emails been added in here

So we at least know who has that order regardless of whether they're signed in or not The shipping address looks like it's added that new shipping address. Perfect Shipping is UPS standard Subtotal has been added

Placed at package that and shipped at have been filled now They don't need to be filled do they so what we have done here is Actually got a bit confused. So place that needs to be filled. But of course these

Need to be nullable. That's the point because of course They're not going to be packaged and shipped at when we create the order. So place that will be let's make this nullable as well just in case it kind of has a reverted state and Let's go ahead and roll this back and re-migrate. Okay, so we're gonna create this order one more time

Then we're gonna sign in try it again, and we will finish So let's just put X in here just to save time Create that and there we go. So these are null now, which makes a bit more sense and

We've got all that other information in there. Great. Okay, so I'm going to delete this order I'm gonna come over to the browser. I'm gonna sign in And I'm now going to check out as an authenticated user to see the difference now, of course, we've got our

Pre-saved addresses in here, which we created before. So let's just choose this one here and Let's change the delivery click confirm order and pay that's again created that order It has filled the email which is unnecessary because we've got the user attached But it's not really worth adding any kind of logic around here to get rid of this email

We've got the shipping address in there that we've chosen perfect shipping type Everything that we need for our order. So there we go. We have created an order We've attached everything that we need to that order. Let's go over to the next episode and look at attaching Variations to orders because at the moment we've got this order, but we have no idea what has been ordered