Django: using multiple models in one view

Question

I have three models linked via foreign keys (Guest, Item, Order(FK Item, FK Guest)). Now I want to write a view that shows the Guests' Details from the model and a table view listing all his Orders in status unpaid).

The first part I did like this. But how can I get the orders in?

@login_required
def guest_detail(request, pk):
    guest = get_object_or_404(Guest, pk=pk)
    if request.method == "POST":
        form = RegisterGuestForm(request.POST, instance=guest)
        if form.is_valid():
            guest = form.save(commit=False)
            guest.save()
            #post.published_date = timezone.now()
            return redirect('guest_detail', pk=guest.pk)
    else:
            form = RegisterGuestForm(instance=guest)
    context = {'form': form}
    return render(request, 'hotel/register_guest.html', context)

The Order Model looks like this:

class Order(models.Model):
    guest = models.ForeignKey('hotel.Guest', on_delete=models.CASCADE)
    amount = models.IntegerField(default=1)
    item = models.ForeignKey('hotel.Item', on_delete=models.CASCADE)
    price = models.IntegerField()
    is_paid = models.BooleanField(default=False)

    class Meta:
        ordering = ['guest']

    def __str__(self):
        return "{} x {}".format(self.amount, self.item)

Adam Donaghy · Accepted Answer · 2016-11-07 02:55:24Z

1

    guest = get_object_or_404(Guest, pk=pk)
    # The 404 will catch any bad requests
    orders = Order.objects.filter(guest = guest, is_paid=False)
    context = {'form': form}
    context['orders'] = orders

remember to add it to your context and you can access it in the template

answered Nov 7, 2016 at 2:55

Adam Donaghy

93 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Philä Bu Over a year ago

that was helpful. Thank you. Could you maybe explain me the context['orders']=orders doest it simply end up meaning context['orders']=Order.objects.filter(guest = guest, is_paid=False)?

Adam Donaghy Over a year ago

IMO It's just a slightly more readable version. It does exactly the same.

Nhan Hoang · Accepted Answer · 2016-11-07 03:00:33Z

0

you could get the Orders via the foreign key, by default (if not set via related_name): guest.order_set.objects

Good luck!

answered Nov 7, 2016 at 3:00

Nhan Hoang

1472 bronze badges

Comments

Shehab ElDin · Accepted Answer · 2016-11-07 12:16:04Z

0

I think you need to query Order instance from given Guest check this my help you:
orders = Order.objects.filter(guest=guest).all()
this will retrieve list of orders that you want

answered Nov 7, 2016 at 12:16

Shehab ElDin

6141 gold badge9 silver badges15 bronze badges

1 Comment

Shehab ElDin Over a year ago

then you can access every order individually in for loop as QuerySet is iterable (list like)

Collectives™ on Stack Overflow

Django: using multiple models in one view

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related