Mercurial > public > sg101
annotate gpp/templates/bulletins/bulletins.html @ 388:c3231af55778
For #191; r410 is wrong: it is returning the wrong posts. Rework. MySQL is not using an index on our query, and it is taking 10+ seconds. Replace this slow query with a loop that loops over the public forums, then sorts and returns the posts.
| author | Brian Neal <bgneal@gmail.com> |
|---|---|
| date | Sat, 19 Mar 2011 05:03:51 +0000 |
| parents | 04377c5bf912 |
| children |
| rev | line source |
|---|---|
| bgneal@28 | 1 {% load humanize %} |
| bgneal@28 | 2 {% for bulletin in bulletins %} |
| bgneal@28 | 3 <div class="bulletin" id="bulletin-{{ bulletin.id }}"> |
| bgneal@28 | 4 <h3>{{ bulletin.title }}</h3> |
| bgneal@28 | 5 <div class="bulletin-text"> |
| bgneal@28 | 6 {{ bulletin.text|safe }} |
| bgneal@28 | 7 </div> |
| bgneal@28 | 8 <p class="bulletin-meta">Posted: {{ bulletin.start_date|naturalday|capfirst }} |
| bgneal@28 | 9 {{ bulletin.start_date|date:"H:i" }}.</p> |
| bgneal@28 | 10 </div> |
| bgneal@28 | 11 {% endfor %} |