You can use choices for the Frequency model, if you like. It may
simplify things.
DAY_CHOICES = (
('Sa', 'Saturday'),
('Su', 'Sunday'),
('Mo', 'Monday'),
('Tu', 'Tuesday'),
('We', 'Wednesday'),
('Th', 'Thursday'),
('Fr', 'Friday'),
)
class Frequency(models.Model):
days = models.CharField('Frequency', maxlength=2,
choices=DAY_CHOICES)
def __str__(self):
return self.get_days_display()
In your view, I'm not sure why you're putting all the HTML in the view
itself. A better solution would be to use a template and do the output
that way.
from django.shortcuts import render_to_response
from project.app.models import Frequency, Airline, Schedule
def index(request):
flight_list = Schedule.objects.all().order_by('-departs')
return render_to_response('flights.html', {'flight_list':
flight_list})
Then in flights.html you would do:
<table border="0" width="50%">
<tr><td>Flight</td><td>Airline</td><td>Frequency</td></tr>
{% for fl in flight_list %}
<tr>
<td>{{ fl.flightNumber }}</td>
<td>{{ fl.airline.aname }}</td>
<td>
{% for x in fl.freq.all %}
{{ fl.get_days_display }}
{% endfor %}
</td>
{% endfor %}
</tr>
{% endfor %}
</table>
This is not tested, so it might not work, but it should put you on the
right track.
Burhan wrote:
> Hello Everyone:
>
> I am trying my luck with django again, and I found a way to show a
> list of related objects in a many-to-many relationship, using the
> following model and view:
>
> Model
>
> # Flight Frequency
> class Frequency(models.Model):
>
> day_translated = {'Sa': 'Saturday', 'Su': 'Sunday', 'Mo': 'Monday',
> 'Tu': 'Tuesday', 'We': 'Wednesday', 'Th': 'Thursday', 'Fr': 'Friday'}
>
> days = models.CharField('Frequency', maxlength=2)
>
> def __str__(self):
> return self.day_translated[self.days];
>
>
>
> # Flight Schedule
>
> class Schedule(models.Model):
> flightNumber = models.CharField('Flight', maxlength=20)
> from_city = models.ForeignKey(Destination, related_name='From',
> verbose_name='Origin')
> to_city = models.ForeignKey(Destination, related_name='To',
> verbose_name='Destination')
> airline = models.ForeignKey(Airline)
> departs = models.TimeField(help_text='All times are local')
> arrives = models.TimeField(help_text='All times are local')
> from_date = models.DateField('Valid From', blank=True, null=True)
> till_date = models.DateField('Valid Till', blank=True, null=True)
>
> freq =
> models.ManyToManyField(Frequency,filter_interface=models.HORIZONTAL,
> verbose_name='Occurance')
>
> def __str__(self):
> return 'Flight '+self.flightNumber
>
> class Admin:
> list_display = ('flightNumber','from_city','to_city','airline',
> 'departs', 'arrives')
> list_filter = ['freq','from_city','to_city',
> 'departs','arrives']
> search_fields = ['from_city','to_city','freq']
>
> View:
>
> def index(request):
> flight_list = Schedule.objects.all().order_by('-departs')
> output = '<table border="0"
> width="50%"><tr><td>Flight</td><td>Airline</td><td>Frequency</td></tr>'
>
> for fl in flight_list:
> output = output + '<tr><td>' + fl.flightNumber + '</td><td>'
> output = output + fl.airline.aname + '</td><td>'
> foo = fl.freq.all().values()
> for x in foo:
> output = output + ' ' + x['days']
> output = output + '</td></tr>'
> output = output + '</table>'
> return HttpResponse(output)
>
>
> Now this does work, but is there a better way to get the same result?
> The way I did it seems a bit of a hack.
>
> Thanks
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users
-~----------~----~----~----~------~----~------~--~---
