object is not iterable

Question

i am trying to fetch orders record from order model and passing as a context into template but in template problem occurs when i use a loop inside a loop such as

                                        {% for o in objects %}
                                        {% for p in o %}
                                        
                                            {{forloop.counter}}
                                            {{p.img.url}}
                                            {{o.date}}
                                            {{p.price}}
                                            {% if o.order_status == 'completed' %}
                                            {{o.order_status}}                    
                                            {% else %}
                                            {{o.order_status}}
                                            {% endif %}
                                        
                                        {% endfor %}
                                        {% endfor %}

i am fetching products related to a particular order object and passing as a context with the as that particular order object such as

context=OrderProduct.fetch_customer_order_products(customer)

OrderProduct.py model

from django.db.models.deletion import DO_NOTHING
from django.shortcuts import get_object_or_404
from django.db.models import Case, When
from django.db import models
from django.db.models.fields.related import ForeignKey
from .order import Order
from .products import Products
from .customer import Customer

class OrderProduct(models.Model):
    order = models.ForeignKey(Order, on_delete=models.CASCADE)
    product = models.ForeignKey(Products, on_delete=models.DO_NOTHING)
    customer = models.ForeignKey(Customer, on_delete=DO_NOTHING, default="")
    quantity = models.IntegerField()

    def __str__(self):
        return self.product.name
    @staticmethod
    def fetch_customer_order_products(cust):
        obj = Order.objects.filter(customer=cust)
        dict = {}
        context={}
        for o in obj:
            l = []
            id = o.id
            prods = list(Order.objects.filter(id=id).values('products'))
            for a in range(0,len(prods)):
                l.append(prods[a]['products'])
            dict[o] = l
            prods = list(Products.objects.filter(id__in=l))  # to be passed as context 
            
         
            context[o]=prods
        context['objects'] = obj

        return context

order.py model

from django.db import models
from django.db.models.enums import Choices
from django.db.models.fields.related import ManyToManyField
from .customer import Customer
from .products import Products
from .payment_method import Payment_method
from datetime import datetime

Order_status_choices = (
    ('created', 'Created'),
    ('approved', 'Approved'),
    ('paid','Paid'),
    ('packaged','Packaged'),
    ('shipped','Shipped'),
    ('completed','Completed'),
)

class Order(models.Model):
    name = models.CharField(max_length=20, default="")
    products = models.ManyToManyField(Products)
    customer = models.ForeignKey(Customer, on_delete=models.DO_NOTHING)
    address = models.CharField(max_length=100, default='')
    order_status = models.CharField(max_length=20, choices = Order_status_choices, default='created')
    shipping_address = models.CharField(max_length=100, default='')
    phno = models.BigIntegerField(default=00000000000)
    email = models.EmailField(default="")
    date = models.DateTimeField(default=datetime.now,blank=True)
    price = models.IntegerField(default=0)
    payment_method = models.ForeignKey(Payment_method, on_delete=models.DO_NOTHING, null=True)
    name_additional = models.CharField(max_length=20, null=True,blank=True)
    phno_additional = models.BigIntegerField(null=True, blank=True)

    def __str__(self):
        return self.name

    @staticmethod
    def get_order_by_customer_id(customer):
        return Order.objects.filter(customer=customer)

myaccount.html file

{% extends 'base.html' %}
{% load static %}
{% load cart %}
{% block content %}
        
        
        
            
                
                    Home
                    Products
                    My Account
                
            
        
        
        
        
        
        
            
                
                    
                        
                            Dashboard
                            Orders
                            Payment Method
                            address
                            Account Details
                            Logout
                        
                    
                    
                        
                            
                                Dashboard
                                
                                    Lorem ipsum dolor sit amet, consectetur adipiscing elit. In condimentum quam ac mi viverra dictum. In efficitur ipsum diam, at dignissim lorem tempor in. Vivamus tempor hendrerit finibus. Nulla tristique viverra nisl, sit amet bibendum ante suscipit non. Praesent in faucibus tellus, sed gravida lacus. Vivamus eu diam eros. Aliquam et sapien eget arcu rhoncus scelerisque.
                                 
                            
                            
                                
                                    
                                            {% for o in objects %}
                                            {% for p in o %}
                                            
                                                {% if order.order_status == 'completed' %}
                                                                    
                                                {% else %}
                                                
                                                {% endif %}
                                            
                                            {% endfor %}
                                            {% endfor %}
                                        
                                        
                                            
                                                Sno
                                                image
                                                DateTime
                                                price
                                                Order Status
                                            
                                        
                                        
                                                {{forloop.counter}}
                                                {{p.img.url}}
                                                {{o.date}}
                                                {{p.price}} {{order.order_status}} {{order.order_status}}
                                    
                                
                            
                            
                                Payment Method
                                
                                    Lorem ipsum dolor sit amet, consectetur adipiscing elit. In condimentum quam ac mi viverra dictum. In efficitur ipsum diam, at dignissim lorem tempor in. Vivamus tempor hendrerit finibus. Nulla tristique viverra nisl, sit amet bibendum ante suscipit non. Praesent in faucibus tellus, sed gravida lacus. Vivamus eu diam eros. Aliquam et sapien eget arcu rhoncus scelerisque.
                                 
                            
                            
                                Address
                                
                                    
                                        Payment Address
                                        123 Payment Street, Los Angeles, CA
                                        Mobile: 012-345-6789
                                        
                                    
                                    
                                        Shipping Address
                                        123 Shipping Street, Los Angeles, CA
                                        Mobile: 012-345-6789
                                        
                                    
                                
                            
                            
                                Account Details
                                
                                    
                                    
                                    
                                    {% if profile.img %}
                                    
                                    {% else %}
                                    
                                    {% endif %}
                                    







                                    
                                        {% csrf_token %}
                                        
                                            {{form.as_p}}
                                        {% if request.session.customer|check_customer_profile %}
                                        
                                            
                                            


                                        
                                        {% else %}
                                        
                                            
                                            


                                        
                                        {% endif %}
                                    
                                    
                                
                                
                            
                        
                    
                
            
        
        
        
       {% endblock %}

myaccount.py

from django.utils.decorators import method_decorator
from ..middlewares.authorization import auth_middleware
from store.models.customer import Customer
from django.views import View
from django.shortcuts import render,redirect
from ..models.order import Order
from ..models.orderproduct import OrderProduct
from ..models.profile import Profile
from ..forms.ProfileForm import ProfileForm
class MyAccount(View):
    @method_decorator(auth_middleware)
    def get(self, request):
        customer = request.session.get('customer')
        

        if customer:
            profile = Profile.whether_customer_exists(customer)
            form = None
            form = ProfileForm(instance=profile)
            context=OrderProduct.fetch_customer_order_products(customer)
            
            context['form']=form
            
            if profile:
                context['profile'] = profile
        
        print(context)  
        return render(request, 'my-account.html',context)

    def post(self, request):
        customer = request.session.get('customer')
        if customer:
            profile = Profile.whether_customer_exists(customer)
            if profile:
                form = ProfileForm(request.POST or None, request.FILES or None,instance=profile)
                if form.is_valid():
                    form.save()
                
            else:
                cust = Customer.objects.filter(id = customer).first()
                
                
                
                form = ProfileForm(request.POST or None, request.FILES or None)
                form1 = form.save(commit=False)
                form1.customer = cust
                form1.save()
                
            
            form = ProfileForm(instance=profile)
            context = {'form':form}

            return render(request, 'my-account.html',context)
                

                
            
        else:
            return redirect('login')

azeem_pdd · Accepted Answer

actually what i was trying to do is to fetch products ordered by a customer related to a particular Ordermodel object and their repective quantity from OrderProductmodel i was giving the order object to inner loop to show products related to that object as

                                {% for o in objects %}
                                {% for p in o %}
                                
                                    {{forloop.counter}}
                                    {{p.img.url}}
                                    {{o.date}}
                                    {{p.price}}
                                    {% if o.order_status == 'completed' %}
                                    {{o.order_status}}                    
                                    {% else %}
                                    {{o.order_status}}
                                    {% endif %}
                                
                                {% endfor %}
                                {% endfor %}

so how is solved the problem was to fetch order query set object to template via context and inside template used a loop to iterate over queryset and get order object and then created a custom template filter inside templatetags folder to fetch the products related to a particular object by giving order object as argument to the cutstom filter such as

{%for o in objects %}
                                Order{{forloop.counter}}
                                
                                    
                                            
                                            {% for p in o|get_object_related_products:request.session.customer %}
                                            
                                                {% if o.order_status == 'completed' %}
                                                                    
                                                {% else %}
                                                
                                                {% endif %}
                                            
    {% endfor %}
so thanks to anyone who made consideratiions...

                                        
                                            
                                                Sno                                   
                                                image
                                                Name
                                                price
                                                Quantity
                                                product total
                                                DateTime
                                                Order Status
                                            
                                        
                                        
                                                {{forloop.counter}}
                                                
                                                
                                                    
                                                
                                                
                                                {{p.name}}
                                                {{p.price}}
                                                {{o|get_product_quantity:p}}
                                                {{o|get_order_total:p}}
                                                {{o.date}} {{o.order_status}} {{o.order_status}}

<order> object is not iterable

Answers (1)

Related Questions

&lt;order&gt; object is not iterable

Answers (1)

Related Questions

<order> object is not iterable