class ProjectBudgetCost(models.Model):
id = UUIDField(primary_key=True)
project_budget = models.ForeignKey(ProjectBudget)
cost_type = models.ForeignKey(BudgetCost, \
related_name = "budgetcost_costtype")
cost = models.FloatField()
cost_approved = models.BooleanField(blank=True)
class ProjectBudget(models.Model):
id = UUIDField(primary_key=True)
project = models.ForeignKey(Project, related_name = "projectbudget", \
blank=True, null=True)
planned_start_date = models.DateField(blank=True, null=True)
org_end_date = models.DateField(blank=True, null=True)
revised_start_date = models.DateField(blank=True, null=True)
revised_end_date = models.DateField(blank=True, null=True)
remarks = models.TextField()
rejection_reason = models.TextField()
pjt_owner = models.ForeignKey(User, related_name = "request_given_by", \
null=True)
business_head = models.ForeignKey(User, \
related_name = "going_to_approve", blank=True, null=True)
status = models.ForeignKey(SaveRecordStatus, \
related_name = "%(app_label)s_%(class)s_Record_status", blank=True, null=True)
budget_updated = models.BooleanField(blank=True)
version = models.IntegerField(blank=True)
approved_on = models.DateField(blank=True, null=True)
modified_on = models.DateField(auto_now = True)
execution_mode = models.CharField(max_length = 200, blank=True, null=True)
total_effort = models.FloatField(blank=True, null=True)
total_cost = models.FloatField(blank=True, null=True)
other1_description = models.CharField(max_length=50, default='Other1')
other2_description = models.CharField(max_length=50, default='Other2')
class AlertRaisedTime(models.Model):
id = UUIDField(primary_key=True)
alert = models.ForeignKey(AlertDataConfiguration)
record_id = models.CharField(max_length=255)
raised_on = models.DateField()
class Meta:
db_table = 'AlertRaisedTime'
def _unicode_(self):
return u'%s' % (self.id)
class AlertDataTransaction(models.Model):
id = UUIDField(primary_key=True)
alert = models.ForeignKey(AlertDataConfiguration)
record_id = models.CharField(max_length=255)
to_id = models.TextField()
cc_id = models.TextField()
body = models.TextField()
subject = models.TextField()
raised_on = models.DateTimeField(auto_now=True)
is_active = models.BooleanField(blank=True, default=1)
class Meta:
db_table = 'AlertDataTransaction'
def _unicode_(self):
return u'%s' % (self.id)
class ProjectBudgetEfforts(models.Model):
id = UUIDField(primary_key=True)
project_budget = models.ForeignKey(ProjectBudget)
activity_type = models.CharField(max_length = 200, blank=True, null=True)
phase = models.ForeignKey(BudgetPhase, \
related_name = "budgetphase_phase", blank=True, null=True)
module = models.CharField(max_length = 200, blank=True, null=True)
location = models.ForeignKey(BudgetLocation, \
related_name = "budgetlocation_location", blank=True, null=True)
duration_days = models.CharField(max_length = 200, blank=True, null=True)
pm_effort = models.CharField(max_length = 200, blank=True, null=True)
lead_effort = models.CharField(max_length = 200, blank=True, null=True)
developpper_effort = models.CharField(max_length = 200, blank=True, \
null=True)
tester_effort = models.CharField(max_length = 200, blank=True, null=True)
other1 = models.CharField(max_length = 200, blank=True, null=True)
other2 = models.CharField(max_length = 200, blank=True, null=True)
effort_approved = models.BooleanField(blank=True)
class AlertDataConfiguration(models.Model):
id = UUIDField(primary_key=True)
name = models.CharField(max_length=255)
alert_type = models.CharField(max_length=5, choices=ALERT_TYPE_CHOICES)
action = models.CharField(max_length=10, choices=ACTION)
days = models.IntegerField(default=0)
frequency = models.IntegerField(default=1)
subject_fields = models.TextField()
body_fields = models.TextField()
toemail = models.ManyToManyField(
User, related_name="%(app_label)s_%(class)s_alert_email")
cc = models.ManyToManyField(
User, related_name="%(app_label)s_%(class)s_alert_cc")
bcc = models.ManyToManyField(
User, related_name="%(app_label)s_%(class)s_alert_bcc")
subject = models.TextField()
body = models.TextField()
is_email = models.BooleanField(blank=True)
is_screen = models.BooleanField(blank=True)
is_active = models.BooleanField(blank=True)
is_lock = models.BooleanField(blank=True)
###audit fields
created_by = models.ForeignKey(
User, null=True, related_name="%(app_label)s_%(class)s_alert_created")
created_on = models.DateField(blank=True, null=True)
modified_by = models.ForeignKey(
User, null=True, related_name="%(app_label)s_%(class)s_alert_updated")
modified_on = models.DateTimeField(auto_now=True)
class Meta:
db_table = 'AlertDataConfiguration'
def __unicode__(self):
return u'%s:%s' % (self.name, self.alert_type)
def get_absolute_url(self):
return "/alert/edit/%s" % self.id
class BudgetCost(models.Model):
id = UUIDField(primary_key=True)
code = models.CharField(max_length = 100, blank=True, null=True)
cost_type = models.CharField(max_length = 200, blank=True, null=True)
is_active = models.BooleanField(default = True)
class SaveRecordStatus(models.Model):
id = UUIDField(primary_key=True)
code = models.CharField(max_length = 100, blank=True, null=True)
status = models.CharField(max_length = 200, blank=True, null=True)
class BudgetLocation(models.Model):
id = UUIDField(primary_key=True)
code = models.CharField(max_length = 100, blank=True, null=True)
location = models.CharField(max_length = 200, blank=True, null=True)