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
On Thursday 6 June 2024 at 08:24:46 UTC+5:30 Nagaraja wrote:
> try below method
>
> <body>
> {% block content %}
> {% endblock content %}
> </body>
>
>
> On Wed, Jun 5, 2024 at 1:09 PM 'Mee “MeeGrp” Grp' via Django users <
> django...@googlegroups.com> wrote:
>
>> 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 !!!!!!!!
>>
>>
>> --
>> 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
>>
>> <https://groups.google.com/d/msgid/django-users/30b6b324-22b2-44f1-b2dd-b0b034ac2f61n%40googlegroups.com?utm_medium=email&utm_source=footer>
>> .
>>
>
--
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/96e52f98-0225-4f2c-b210-41458a913dd1n%40googlegroups.com.
