Calculating income and expense by filtering according to the entered date-CodePudding

I have a date picker and I will calculate income and expense based on this date. I want to add a parameter named random_date to my function in view.py. I want the user to set the end date. The start time will be today's date. For example, if the user has selected June 1 as the date, I want to sum the income and expenses from today to June 1st. How can I do that?

Here is my views.py file:

import datetime
from django.shortcuts import render
from incomes.models import Income, Source
from expenses.models import Expense, Category
from .models import SummaryModel


# Create your views here.
def Summary(request):
    todays_date = datetime.date.today()
    six_months_later = todays_date   datetime.timedelta(days=180)
    all_expenses = Expense.objects.filter(owner=request.user, date__gte=todays_date, date__lte=six_months_later)
    all_incomes = Income.objects.filter(owner=request.user, date__gte=todays_date, date__lte=six_months_later)

    def get_amount(EorI):
        amount = 0
        for item in EorI:
            amount  = item.amount
        return amount

    final_rep = {'Net_Income' : get_amount(all_incomes) - get_amount(all_expenses)}
    return render(request, 'summary.html', final_rep)

Here is my summary.html file:

<div >
    <div >
        </select>
        <div >
            <label for="">Choose a date</label>
            <input type="date" value="{{values.date | date:'Y-d-m'}}"  name="random_date" />
        </div>

        <input type="submit" value="Submit"  />

        <div >
            <div >
                <div >
                    <h8 >Net Budget</h8>
                    <h1 >${{ Net_Income }}</h1>
                </div>
            </div>
        </div>
    </div>
    </form>
</div>
</div>

CodePudding user response：

you can access POST or GET parameters from your request like this:

request.GET.get('my_var')
request.POST.get('my_var')

your summary.html sample omits your form opening tag so here is a view you might use assuming that you are POSTing information to your view:

def Summary(request):
    todays_date = datetime.date.today()
    six_months_later = todays_date   datetime.timedelta(days=180)

    random_date = request.POST.get('random_date')

    all_expenses = Expense.objects.filter(owner=request.user, date__gte=todays_date, date__lte=six_months_later)
    all_incomes = Income.objects.filter(owner=request.user, date__gte=todays_date, date__lte=six_months_later)

    context = {'Net_Income' : get_amount(all_incomes) - get_amount(all_expenses)}

    if random_date:
       filtered_expenses = Expense.objects.filter(owner=request.user, date__gte=todays_date, date__lte=random_date)
       filtered_incomes = Income.objects.filter(owner=request.user, date__gte=todays_date, date__lte=random_date)
       context['Filtered_Income'] = get_amount(filtered_incomes) - get_amount(filtered_expenses)

    def get_amount(EorI):
        amount = 0
        for item in EorI:
            amount  = item.amount
        return amount

    
    return render(request, 'summary.html', context)

new value will be available as Filtered_Income in your template, but only if the user has POSTed a date so you will need to use something like {% if Filtered_Income %}