Newbie - Django Project with Multiple Apps - Unable to render Views

Question

I am in process of developing a Django Project that has 3 apps namely Customer, Investments and Stocks. Each Customer can have multiple Investments and Stocks but not the other way round. So far, everything works well on Admin side of the application. I am able to CRUD as an admin, but my goal is to have a 3 separate user levels - customer, advisor and admin (this is working fine!). A customer can only view his/her profile, investments and stocks pertaining to it. An advisor can view information of multiple customers and their portfolios. I think I can separate these by different Authentication levels/restrictions. These are my files,

This is my customer model,

    from django.db import models
from django.utils import timezone
from django.contrib.auth.models import User


class Customer(models.Model):
    name = models.CharField(max_length=50)
    address = models.CharField(max_length=200)
    cust_number = models.AutoField(max_length=5, primary_key=True)
    city = models.CharField(max_length=50)
    state = models.CharField(max_length=50)
    zipcode = models.CharField(max_length=10)
    email = models.CharField(max_length=200)
    home_phone = models.CharField(max_length=50)
    cell_phone = models.CharField(max_length=50)
    created_date = models.DateTimeField(
        default=timezone.now)
    updated_date = models.DateTimeField(
        blank=True, null=True)

    def created(self):
        self.created_date = timezone.now()
        self.save()

    def updated(self):
        self.updated_date = timezone.now()
        self.save()

    def __str__(self):
        return self.name

This is my investment model,

from django.db import models
from django.utils import timezone
from django.contrib.auth.models import User


class Investment(models.Model):
    category = models.CharField(max_length=50)
    description = models.CharField(max_length=200)
    cust_number = models.ForeignKey('customers.Customer')
    acquired_value = models.DecimalField(max_digits=10, decimal_places=2)
    acquired_date = models.DateTimeField(default=timezone.now)
    recent_value = models.DecimalField(max_digits=10, decimal_places=2)
    recent_date = models.DateTimeField(default=timezone.now, blank=True, null=True)

    def created(self):
        self.acquired_date = timezone.now()
        self.save()

    def updated(self):
        self.recent_date = timezone.now()
        self.save()

    def __str__(self):
        return self.category

This is my stocks model,

from django.db import models
from django.utils import timezone
from django.contrib.auth.models import User


class Stock(models.Model):
    symbol = models.CharField(max_length=10)
    name = models.CharField(max_length=50)
    shares = models.CharField(max_length=50)
    cust_number = models.ForeignKey('customers.Customer')
    purchase_price = models.DecimalField(max_digits=10, decimal_places=2)
    recent_date = models.DateTimeField(default=timezone.now, blank=True, null=True)

    def created(self):
        self.recent_date = timezone.now()
        self.save()

    def __str__(self):
        return self.name

This is my views.py in customers app although have separate views for investments and stocks, I defined same classes in customers/views.py so it renders in single view.

from django.shortcuts import render
from django.utils import timezone
from .models import Customer
from investments.models import Investment
from stocks.models import Stock


def customer(request):
    customers = Customer.objects.filter(created_date__lte=timezone.now())
    return render(request, 'customers/customer.html', {'customers': customers})


def investment(request):
    investments = Investment.objects.filter(created_date__lte=timezone.now())
    return render(request, 'customers/customer.html', {'investments': investments})


def stock(request):
    stocks = Stock.objects.filter(created_date__lte=timezone.now())
    return render(request, 'customers/customer.html', {'stocks': stocks})

I am trying to render the views on single html page like this,

Here's my customer.html template

{% load staticfiles %}








  
  
  Eagle Financial Services



  
    
      
        
          Welcome!
          
            ABC Financial Services, your Financial Services Partner.
          
        
      
    
  
  
    Customer Information
  
  
    
        {% for customer in customers %}
        
        {% endfor %}
      
      
        
          Customer ID
          Name
          Address
          City
          State
          Zip
          Primary Email
          Home Phone
          Cell Phone
          Actions
        
      
      
          {{ customer.cust_number }}
          {{ customer.name }}
          {{ customer.address }}
          {{ customer.city }}
          {{ customer.state }}
          {{ customer.zipcode }}
          {{ customer.email }}
          {{ customer.home_phone }}
          {{ customer.cell_phone }}
          Read
        
    
  

  
    Investments Information
  
  
    
        {% for customer in customers %}
        
          {% for investment in investments %}
          
          {% endfor %} {% endfor %}

      
      
        
          Customer ID
          Name
          Category
          Description
          Acquired Value
          Acquired Date
          Recent Value
          Recent Date
          Actions
        
      
      
          {{ customer.cust_number }}
          {{ customer.name }} {{ investment.category }}
          {{ investment.description }}
          {{ investment.acquired_value }}
          {{ investment.acquired_date }}
          {{ investment.recent_value }}
          {{ investment.recent_date }}
    
  

  
    Stocks Information
  
  
    
        {% for stock in stocks %}
        
        {% endfor %}
      
      
        
          Symbol
          Name
          Shares
          Cust_Number
          Purchase Price
          Recent Date
          Actions
        
      
      
          {{ stock.symbol }}
          {{ stock.name }}
          {{ stock.shares }}
          {{ stock.cust_number }}
          {{ stock.purchase_price }}
          {{ stock.recent_date }}

Here's projectname.url

from django.conf.urls import include, url
from django.contrib import admin

urlpatterns = [
    url(r'^admin/', admin.site.urls),
    url(r'', include('customers.urls')),
    url(r'', include('investments.urls')),
    url(r'', include('stocks.urls')),
]

Here's customers.url

`from django.conf.urls import url
from . import views

urlpatterns = [
    url(r'^$', views.customer, name='customer'),
]`

Investment and Stocks resemble customer.urls except the name.

Now on the webpage, only the values in customer table are being displayed, and in investment table only cust_number and name are being displayed nothing else and in stocks nothing is displayed. I have tried almost all the trial/errors for past 3 days. I am lot confused. Where I am getting it wrong. Any guidance will be highly appreciated. Thanks.

I am using Python - 3.6, Django - 1.11.1.

Arpit Solanki · Accepted Answer

The reason why you are facing this problem is that views.customer only passes the information of customer and not the other variables like stocks. So in your customer/views.py:

def customer(request):
    customers = Customer.objects.filter(created_date__lte=timezone.now())
    investments = Investment.objects.filter(created_date__lte=timezone.now())
    stocks = Stock.objects.filter(created_date__lte=timezone.now())
    return render(request, 'customers/customer.html', {'customers': customers, 'stocks': stock, 'investments', investments})

Newbie - Django Project with Multiple Apps - Unable to render Views

Answers (2)

Related Questions