| [719e4bb] | 1 | from django.db import models |
|---|
| [13a23ce] | 2 | import settings |
|---|
| [f468e6d] | 3 | from finance_core.models import BudgetArea, BudgetTerm |
|---|
| [f186a0e] | 4 | |
|---|
| [93e2ab9] | 5 | import datetime |
|---|
| 6 | |
|---|
| [3e29d7a] | 7 | APPROVAL_STATES = ( |
|---|
| 8 | ( 0, 'None'), |
|---|
| 9 | ( 1, 'Approved'), |
|---|
| 10 | (-1, 'Rejected'), |
|---|
| 11 | ) |
|---|
| [f186a0e] | 12 | |
|---|
| [13a23ce] | 13 | class ReimbursementRequest(models.Model): |
|---|
| 14 | submitter = models.CharField(max_length=10) # MIT username of submitter |
|---|
| [a96d938] | 15 | check_to_name = models.CharField(max_length=50, verbose_name="check recipient's name") |
|---|
| 16 | check_to_email = models.EmailField(verbose_name="email address for check pickup") |
|---|
| 17 | check_to_addr = models.TextField(blank=True, verbose_name="address for check mailing", help_text="For most requests, this should be blank for pickup in SAO (W20-549)") |
|---|
| [6b8d891] | 18 | amount = models.DecimalField(max_digits=7, decimal_places=2, help_text='Do not include "$"') |
|---|
| [31bd056] | 19 | budget_area = models.ForeignKey(BudgetArea, related_name='as_budget_area') |
|---|
| [13a23ce] | 20 | budget_term = models.ForeignKey(BudgetTerm) |
|---|
| [31bd056] | 21 | expense_area = models.ForeignKey(BudgetArea, related_name='as_expense_area') # ~GL |
|---|
| [6a867b3] | 22 | request_time = models.DateTimeField(default=datetime.datetime.now) |
|---|
| [6b8d891] | 23 | approval_time = models.DateTimeField(blank=True, null=True,) |
|---|
| [3e29d7a] | 24 | approval_status = models.IntegerField(default=0, choices=APPROVAL_STATES) |
|---|
| [6b8d891] | 25 | printing_time = models.DateTimeField(blank=True, null=True,) |
|---|
| 26 | name = models.CharField(max_length=50, verbose_name='short description', ) |
|---|
| 27 | description = models.TextField(blank=True, verbose_name='long description', ) |
|---|
| [d7e325a] | 28 | |
|---|
| 29 | def __unicode__(self, ): |
|---|
| [3235c66] | 30 | return "%s: %s (%s) (by %s) for $%s in %s during %s" % ( |
|---|
| 31 | self.name, |
|---|
| [d7e325a] | 32 | self.check_to_name, |
|---|
| 33 | self.check_to_email, |
|---|
| 34 | self.submitter, |
|---|
| 35 | self.amount, |
|---|
| 36 | self.budget_area.name, |
|---|
| 37 | self.budget_term.name, |
|---|
| 38 | ) |
|---|
| [31bd056] | 39 | |
|---|
| 40 | |
|---|
| 41 | class Voucher(models.Model): |
|---|
| 42 | group_name = models.CharField(max_length=10) |
|---|
| 43 | account = models.IntegerField() |
|---|
| 44 | signatory = models.CharField(max_length=50) |
|---|
| 45 | first_name = models.CharField(max_length=20) |
|---|
| 46 | last_name = models.CharField(max_length=20) |
|---|
| 47 | email_address = models.EmailField(max_length=50) |
|---|
| 48 | mailing_address = models.TextField() |
|---|
| 49 | amount = models.DecimalField(max_digits=7, decimal_places=2,) |
|---|
| 50 | description = models.TextField() |
|---|
| 51 | gl = models.IntegerField() |
|---|