mayankvalechha/django-invoice

An Invoice web app developed in Django

django-invoice's Issues

I want to generate a Dynamic URL based on date, such as localhost.com/search/dd-mm-yyyy.

Here is the code.

index.html

<div class="form-group mb-2">
    <form method="POST" action="/search/">
        {% csrf_token %}
        <input type="date" name="search_by_date" required class="form-control mb-1">
        <button type="submit" class="btn btn-primary btn-sm">Search</button>
    </form>
</div>

This is my form, in which the there's a date input which lets you choose the date, and the form is submitted to search/ URL. But the generated URL is localhost.com/search/

What I want to do is, I want to generate a dynamic URL based on the date itself.

Example, If the user chooses the 10-08-2020 date, the URL should be localhost.com/search/10-08-2020

urls.py

urlpatterns = [
    ...
    path('search/', get_by_date, name='search'),
]

view.py

# Function used to get the data based on the entered date
def get_by_date(request):
    if request.method == 'POST':
        
        # query contains the date entered by the user
        query = request.POST['search_by_date']
        if query:
            invoice_by_date = Invoice.objects.filter(purchase_date__icontains=query)
            expense_by_date = Expense.objects.filter(expense_date__icontains=query)

            # Summing the selling price by the date
            amount = Invoice.objects.filter(purchase_date__icontains=query).aggregate(amount = Sum('selling_price'))['amount']

            if invoice_by_date:
                # Changing Format of Input Date to Display in Template
                query = datetime.datetime.strptime(query, '%Y-%m-%d').strftime('%d-%B-%Y')

                return render(request, 'invoice/get_by_date.html', 
                {   'query_result':invoice_by_date,
                    'query_date':query,
                    'amount': amount,
                    'query_result2': expense_by_date,
                })
            else:
                return render(request, 'invoice/get_by_date.html')
        else:
            return HttpResponse('No Data Found!')
    else:
        return HttpResponse('No Data Found!')

Screenshots:
User Selects the date in the date field and press submit button.

The URL that comes in the URL bar is this.

Any help would be appreciated.
Thank you!