You didn't post your full model code ... I didn't see anything about
auditoriums in it :) ... can you post the relevant part of your model
for that?
So you are basically trying to list movie times/cinema for each
movie..right?
W/out knowing your exact model code...what you have in your py file
should work based on what you had above.
movie_list = CinemaProgramDate.objects.filter
(cinemaprogram__cinema__place_state__slug=state,
screening_date=date,
cinemaprogram__movie=movie_id).select_related().order_by
('cinemas_cinema.name', 'add_screen')
Then this in your template something like this: ( you had a for loop
for your add_screen, but I don't see that it's a one to many
relationship... so that didn't seem to be needed unless I missed
something )
{% for movie in movie_list %}
{% if not forloop.first %}
</td></tr></tbody></table>
{% endif %}
<table class="schedule listing_cinemas {%
cycle bg1,bg2 %}" style="background-color: {% cycle #FCFBFA,#F2F1F0
%};"><thead>
<!-- go thru each cinema program related to
this movie -->
{% for cinemaprogram in
movie.cinemaprogram_set.all %}
<tr><th colspan="2">
<h3><a href="/kino/
{{ movie.cinemaprogram.cinema.id }}/">
{{ movie.cinemaprogram.cinema }}</a>,
{{ movie.cinemaprogram.cinema.place_state
}}</h3>
<a href="{{ path }}kino/
{{ movie.cinemaprogram.cinema.id }}/"
class="right listall
small">Andere Filme in diesem Kino</a>
</th></tr>
{% endfor %}
</thead><tbody>
<tr><td class="label light">Saal
{% if movie.add_screen %}
{{ movie.add_screen }}
{% else %}
k.A.
{% endif %}
</td><td class="ight">
{{ movie.screening_time|
time:"H:i" }}
{% if forloop.last %}
{% ifequal forloop.counter 1 %}</td></tr>
{% endifequal %}</tbody></table>
{% endif %}
{% endfor %}
On May 2, 12:15 pm, "va:patrick.kranzlmueller"
<[EMAIL PROTECTED]> wrote:
> here´s an example of how the page should look
> like:http://www.skip.at/AT/kinoprogramm/abfrage/prog_film.php?
> blnr=1&ort=0&wochtag=3&wahl_tag=02.+05.&filmnr=9315&filmtitel=Das
> +wilde+Leben
>
> (we´re just redesigning that page using django)
>
> patrick
>
> Am 02.05.2007 um 17:47 schrieb [EMAIL PROTECTED]:
>
>
>
> > Oops... that should have been
>
> > {{ screens.screening_date }}
> > {{ screens.screening_time }}
>
> > Forgot the 's'.
>
> > If this isn't quite what you mean...let me know... I may have
> > misunderstood what you were looking for.
>
> > On May 2, 11:44 am, "[EMAIL PROTECTED]"
> > <[EMAIL PROTECTED]> wrote:
> >> You should be able to do something like this:
>
> >> {% for cinema in cinema_list %}
> >> {{ cinema }}
> >> {% for screens in cinema.cinemaprogram_set.all %}
> >> {{ screen.screening_date }}
> >> {{ screen.screening_time }}
> >> {% endfor %}
> >> {% endfor %}
>
> >> Go to this page:http://www.djangoproject.com/documentation/db-api/
> >> and check out the one-to-many relationships, backward section.
>
> >> va:patrick.kranzlmueller wrote:
> >>> I´m having 2 models:
>
> >>> class CinemaProgram(models.Model):
> >>> cinema = models.ForeignKey(Cinema)
> >>> movie = models.ForeignKey(Movie, raw_id_admin=True)
> >>> ....
>
> >>> class CinemaProgramDate(models.Model):
> >>> cinemaprogram = models.ForeignKey(CinemaProgram,
> >>> edit_inline=models.TABULAR, num_in_admin=20, max_num_in_admin=200,
> >>> num_extra_on_change=100)
> >>> screening_date = models.DateField('Screening Date', core=True)
> >>> screening_time = models.TimeField('Screening Time', core=True)
> >>> add_screen = models.CharField('Screen', maxlength=50,
> >>> blank=True, null=True)
> >>> ....
>
> >>> for the template, I´d like to have something like this:
>
> >>> {% for cinema in cinema_list %}
> >>> {{ cinema }}
> >>> {% for screens in cinema %}
> >>> {{ screen }}
> >>> {% for screening_time in screens %}
> >>> {{ screening_time }}
> >>> {% endfor %}
> >>> {% endfor %}
> >>> {% endfor %}
>
> >>> Now, my question is: how do I get/construct the dict for this
> >>> template?
>
> >>> Note: The output should be:
>
> >>> Movie XXX on Date YYY is shown in these Cinemas:
> >>> Cinema 1
> >>> Screen 1: 18:00 20:00 23:00
> >>> Screen 2: 20:00
> >>> Cinema 2
> >>> Screen 1: 18:30
> >>> Cinema 3
> >>> Screen 1: 20:00
> >>> Screen 4: 22:30
>
> >>> I don´t really know if I need a custom manager or a custom method or
> >>> if I have to refactor my models.
>
> >>> any hints are really appreciated (I´ve been working on this one
> >>> for a
> >>> couple of days and it´s getting frustrating ...).
>
> >>> so far, I´ve been using this one:
> >>> movie_list = CinemaProgramDate.objects.filter
> >>> (cinemaprogram__cinema__place_state__slug=state,
> >>> screening_date=date,
> >>> cinemaprogram__movie=movie_id).select_related().order_by
> >>> ('cinemas_cinema.name', 'add_screen')
>
> >>> with what I get here, I´m not able to do the template accordingly
> >>> (because I´d need an {% ifnotchanged %} which doesn´t exist).
>
> >>> well, enough for now - I hope somebody has the time to help me with
> >>> this.
>
> >>> Thanks,
> >>> patrick
--~--~---------~--~----~------------~-------~--~----~
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?hl=en
-~----------~----~----~----~------~----~------~--~---
