Re: database update after paypal payment

Hello Michael, I am having the same problem. I have no problems submitting the data from my website to paypal. I am using Django 2.0.x and just need the django IPN-listener code in an easy to understand way. I want to receive data back from paypal IPN and be able to store it in my database ie

Django Nested Query with Aggregate.Sum()

QUESTION I have an application that will make on-line reservations for a series of weekly events. I would like to display the list of upcoming events in an html template with the number of remaining seats available in a single html page. I was able to create views to display the list of upcomi

Re: Django Nested Query with Aggregate.Sum()

Thank you Simon. I will take a look at annotations. How would I represent seats remaining in the template for loop? Here is what I have so far. # {% for i in events %} {{ i.event_date|date:"l M j, Y" }} {{ i.event_time|date:"g:i A" }} {{i.event_type|t

Re: Django Nested Query with Aggregate.Sum()

Hello Simon, I tried implementing your recommendations today and all appeared to go well except that I was not getting any results from the query for remaining seating on the html template. I took a look at my reservation table and the data was gone. I had the data in an original table I copie

Re: Django Nested Query with Aggregate.Sum()

Ok, data transfer error fixed and data now in table. However, I am still not getting a value for {{i.seats_remaining}}. It comes out blank. I had an error in the view that I corrected as below but still does not give results. def winery_events_view(request): winery_events = WineryEvents.o

Re: Django Nested Query with Aggregate.Sum()

FINAL SOLUTION / SOLVED A bit of a more complex single query... VIEW def winery_events_view(request): events = WineryEvents.objects.filter(publish='Y').filter(event_date__gte=datetime.now()).order_by('event_date').annotate(seats_remaining = F('seating')-Sum('reservations__seats_reserved')

Django Admin Multiple Models and Dropdown list

I have the following models and admin files and I would like to be able to show the text representation of the ExpenseCategory category field in the dropdown list on the Admin page. However, the dropdown list is displaying "ExpenseCategory Object(n)" instead of the actual text category such as

Re: Django Admin Multiple Models and Dropdown list

Hi Julio, Thank you so much. I should have picked that up myself. It worked! Thanks again. Marc On Tuesday, September 18, 2018 at 10:30:20 AM UTC-5, Julio Biason wrote: > > Hey Mab, > > You probably need to replace you `__init__` to `__str__`. They are two > different things. > > On Tue, Sep

Django Admin Filtering Drop Down Menu by Date

Hello, I am trying to develop an employee schedule based on upcoming events and I only need to make additions or updates in Django Admin. To add a new event I would like to pick from a drop down list of only the events that are in the future or on todays date not the entire table list of event

Re: Django Admin Filtering Drop Down Menu by Date

Thank you Nelson. I will try this option. On Friday, October 12, 2018 at 9:57:31 AM UTC-5, Nelson Varela wrote: > > You could make a custom form for your admin which is a model form which >> points to EmployeeSchedule. And in the form its init you can change the >> queryset of the events field:

Re: Django Admin Filtering Drop Down Menu by Date

Hello Nelson, I may need you to walk me through this more. I am relatively new to Django. I modified my admin.py and added from django import forms and added the following code in the admin.py file. It's still giving me an error ... "type object 'EmployeeSchedule' has no attribute 'events'" I

Can't add users to groups. No Groups Chosen Box in Admin

I've created an Employee group for my project but the Admin Group Chosen Box is not displayed. See screenshot Need help on adding users to groups and getting the box to display. Thank you. -- You received this message because you are subscribed to the Google Groups "Django users" group. To u