Thanks Rajesh, I am not sure about Choices, since there are some 12 stages, with condition at couple of stages. I do not know how to conditionalize the choice fields. Also this would mean that for a single tender, we create 12-14 instances of the Calendar Table. Advise, please
Ramdas On Dec 21, 2007 2:50 AM, Rajesh Dhawan <[EMAIL PROTECTED]> wrote: > > > > > > What is the best method to capture, all events happening on a specific > day. > > > > The view must give a report.... > > > > when you try the url calendar/2007/dec/20 > > On December 20th 2007 > > > > Tender 222 date of announcement > > Tender 243 last date for receiving bids > > Tender 227 date for recieving final bid > > Tender 270 date of opening of bid > > Here's one way to model that: > > class Calendar(models.Model): > date = models.DateField() # what date > tender = models.ForeignKey(Tender) # which tender > # what happens to this tender on this date: > tender_stage = models.CharField(choices=TENDER_STAGE_CHOICES) > > where TENDER_STAGE_CHOICES is something like: > TENDER_STAGE_CHOICES = ( > ('announcement', 'Date of announcement'), > ('bid-last-date', 'Date for receiving final bid'), > #...and so on > ) > > In this model, the tender_stage field gives the date field its meaning > (e.g. if tender_stage is 'announcement', the date is an announcement > date.) > > -Rajesh > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---