"""This module contains the data model for the project funded by NME

through ICT.

"""

__authors__ = [

  '"Madhusudan.C.S" <madhusudancs@gmail.com>',

]

from django.db import models

from django.contrib.auth.models import User

class Project(models.Model):

  """Model class for NME funded projects.

  """

  LINE_ITEM_CHOICES = [('ME', 'Mechanical'), 

                       ('CE', 'Chemical'),

                       ('EE', 'Electrical'),

                       ('AE', 'Aero Space'),

                       ('CS', 'Computer Science'),

                       ('IT', 'Information Technology'),

                      ]

  STATE_CHOICES = [('MH', 'Maharashtra'), 

                   ('KA', 'Karnataka'),

                   ('KL', 'Kerala'),

                   ('TN', 'Tamil Nadu'),

                   ('AP', 'Andra Pradesh'),

                  ]

  DISTRICT_CHOICES = [('AD', 'Adilabad'),

                      ('RT', 'Ratnagiri'),

                      ('MU', 'Mumbai suburban'),

                      ('PU', 'Pune'),

                      ('PL', 'Palakkad'),

                      ('BN', 'Bangalore Urban district'),

                      ('CK', 'Chikmagalur District'),

                     ]

  # Field containing the Line Item to which the project belongs to.

  line_item = models.CharField(max_length=256,

                               choices=LINE_ITEM_CHOICES)

  # Field containing the name of the institution working on the

  # project.

  institution = models.CharField(max_length=256)

  # Field containing the state to which the institution belongs to.

  state = models.CharField(max_length=256,

                           choices=STATE_CHOICES)

  # Field containing the district to which the institution belongs

  # to in the state of India.

  district = models.CharField(max_length=256,

                              choices=DISTRICT_CHOICES)

  # Field containing the autogenerated MICR code for the project.

  micr_code = models.CharField(max_length=15, unique=True)

  # Field containing the status of the project.

  # status of the project can be one among the following

  # New, Revised, Funded, Pilot, DPE

  status = models.CharField(max_length=256,

                            choices=[('new', 'New'), ('pilot', 'Pilot'),

                                     ('invalid', 'Invalid')])

  last_updated_on = models.DateTimeField(auto_now=True)

  @classmethod

  def getLineItem(cls, code):

    """Get the State name from its code.

    """

    line_item_dict = dict(cls.LINE_ITEM_CHOICES)

    return line_item_dict[code]

  @classmethod

  def getLineItemCode(cls, name):

    """Get the Line Item code from its name.

    """

    for ln_code, ln_name in cls.LINE_ITEM_CHOICES:

      if ln_name == name:

        return ln_code

    return None

  @classmethod

  def getState(cls, code):

    """Get the State code from its name.

    """

    state_dict = dict(cls.STATE_CHOICES)

    return state_dict[code]

  @classmethod

  def getStateCode(cls, name):

    """Get the State code from its name.

    """

    for st_code, st_name in cls.STATE_CHOICES:

      if st_name == name:

        return st_code

    return None

  @classmethod

  def getDistrict(cls, code):

    """Get the District name from its code.

    """

    district_dict = dict(cls.DISTRICT_CHOICES)

    return district_dict[code]

  @classmethod

  def getDistrictCode(cls, name):

    """Get the District code from its name.

    """

    for dt_code, dt_name in cls.DISTRICT_CHOICES:

      if dt_name == name:

        return dt_code

    return None

class Proposal(models.Model):

  """Model class for the project's proposal.

  """

  #: Field representing the relation to the corresponding project.

  project = models.ForeignKey(Project)

  #: Field containing the Line Item to which the project belongs to.

  document = models.FileField(upload_to='proposals/%Y/%m/%d')

  #: Field containing the date on which the document was submitted

  submitted_on = models.DateTimeField(auto_now_add=True)

  #: Field containing the reference to the user who submitted the proposal.

  submitted_by = models.ForeignKey(User, null=True)

  #: Field containing the revision number of the proposal belonging to

  #: the Project.

  rev_num = models.PositiveIntegerField()

class Timeline(models.Model):

  """Model class for the project's timeline.

  """

  #: Field representing the relation to the corresponding project.

  project = models.ForeignKey(Project)

  #: Field containing the date and time of submission of proposal.

  submitted = models.DateTimeField()

  #: Field containing the last date and time of review of proposal.

  reviewed = models.DateTimeField()

  #: Field containing the date and time of amount paid for the project.

  amount_paid = models.DateTimeField()

  #: Field containing the date and time of presentation of the project.

  presentation = models.DateTimeField()

  #: Field containing the date and time of monitoring of the project.

  monitoring = models.DateTimeField()

class Fund(models.Model):

  """Model class for the project's funds.

  """

  #: Field representing the relation to the corresponding project.

  project = models.ForeignKey(Project)

  #: Field containing the amount sanctioned as funds for the project.

  sanctioned = models.FloatField()

  #: Field containing the expenses for the sanctioned fund for

  #: the project.

  expenses = models.FloatField()

  #: Field containing the date and time on which the funds were

  #: sanctioned for the project.

  sanctioned_on = models.DateTimeField(auto_now_add=True)

class Review(models.Model):

  """Model class for the project's proposal's review.

  """

  #: Field representing the relation to the corresponding project.

  project = models.ForeignKey(Project)

  #: Field containing the comment entered along with the review.

  comment = models.TextField()

  #: Field representing the reference to the person who

  #: did the review.

  reviewer = models.ForeignKey(User, null=True)

  #: Field containing the date and time of review of the proposal.

  reviewed_on = models.DateTimeField(auto_now_add=True)

  #: Field containing the review value for this attribute.

  attribute1 = models.PositiveSmallIntegerField(

      choices=[(1, 1), (2, 2), (3, 3), (4, 4), (5, 5)])

  attribute2 = models.PositiveSmallIntegerField(

      choices=[(1, 1), (2, 2), (3, 3), (4, 4), (5, 5)])

  attribute3 = models.PositiveSmallIntegerField(

      choices=[(1, 1), (2, 2), (3, 3), (4, 4), (5, 5)])

  attribute4 = models.PositiveSmallIntegerField(

      choices=[(1, 1), (2, 2), (3, 3), (4, 4), (5, 5)])

  attribute5 = models.PositiveSmallIntegerField(

      choices=[(1, 1), (2, 2), (3, 3), (4, 4), (5, 5)])

  attribute6 = models.PositiveSmallIntegerField(

      choices=[(1, 1), (2, 2), (3, 3), (4, 4), (5, 5)])

  attribute7 = models.PositiveSmallIntegerField(

      choices=[(1, 1), (2, 2), (3, 3), (4, 4), (5, 5)])

  attribute8 = models.PositiveSmallIntegerField(

      choices=[(1, 1), (2, 2), (3, 3), (4, 4), (5, 5)])

  attribute9 = models.PositiveSmallIntegerField(

      choices=[(1, 1), (2, 2), (3, 3), (4, 4), (5, 5)])