I have run into the same problem on several different websites: a
couple of PHP sites and, most recently, two Django sites. This is
where you have a 'container object' that has a particular desired
order of subordinate objects.
Consider:
class Newletter(models.Model):
title = models.CharField(maxsize=128)
pub_date = models.DateField(); etc. etc.
class Article(models.Model):
title = models.CharField(maxsize=128)
newsletter = models.ForeignKey(Newsletter); etc. etc.
There are 1..N articles in a newsletter and *the order is important.*
Now, you could just tell your content people that they should enter
the articles in the desired order, but sometimes people miss one and
have to go back and enter it. But if the order is completely dependent
on the "invisible" record id in the Article table, well, it doesn't
work, short of deleting all of them and then getting the order right.
You can also add an 'order' field to the subordinates, but you are
only looking at one of them at a time in admin, so ... it requires the
user to do a lot of remembering/note-taking.
The only semi-reasonable solution I have found is to have a field in
the Newsletter class like:
article_order = models.CharField(maxsize=255)
which has a comma-separated list of Article id's, and then creating an
extension of the admin page for the container class (Newsletter in
this case). Most recently I did this using the Interface Sortables
extension to jQuery to update the id order each time an item oves up
or down. It works fairly well, but there is a fair amount of explicit
coding involved, which means I need to Repeat Myself the next time
this comes up.
Does anyone have a clean, reusable method for dealing with this?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
