python/django/vs code

Mee “MeeGrp” Grp

unread,

Jun 5, 2024, 3:40:02 AMJun 5

to Django users

I have two html files 1. view_sales.html 2. total_sales.html

I want to display output of total_sales.html within view_sales.html just below

view_sales.html output

Your help would be highly appreciated !!!!!!!!

Web dev

unread,

Jun 5, 2024, 4:18:46 AMJun 5

to django...@googlegroups.com

Hi, I guess your trouble.

Let me try.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/30b6b324-22b2-44f1-b2dd-b0b034ac2f61n%40googlegroups.com.

Nagaraja

unread,

Jun 5, 2024, 10:54:46 PMJun 5

to django...@googlegroups.com

try below method

<body>
    {% block content %}
    {% endblock content %}
</body>

Bhagyashri Phalake

unread,

Jun 6, 2024, 12:43:46 PMJun 6

to Django users

Calculate Total Sales in View

from django.shortcuts import render
from .models import Sale

def sales_report(request):
sales = Sale.objects.all()
total_sales = sales.aggregate(total=models.Sum('total_price'))['total']
return render(request, 'sales_report.html', {'sales': sales, 'total_sales': total_sales})

Calculate Total Sales in View:

from flask import Flask, render_template

from models import db, Sale

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///sales.db'
db.init_app(app)

@app.route('/sales_report')
def sales_report():
sales = Sale.query.all()
total_sales = sum(sale.total_price for sale in sales)
return render_template('sales_report.html', sales=sales, total_sales=total_sales)

if __name__ == '__main__':
app.run(debug=True)

Sales
------------------------------------------------------------
| Product | Date | Amount | Quantity Sold | Total Price |
------------------------------------------------------------
| Product A | 2024-06-01 | 100.00 | 2 | 200.00 |
| Product B | 2024-06-02 | 150.00 | 1 | 150.00 |
| Product A | 2024-06-03 | 100.00 | 3 | 300.00 |
------------------------------------------------------------
Total Sales: 650.00

Reply all

Reply to author

Forward