from datetime import date
from django.db import models


class Employee(models.Model):
    NAME_MAX_LEN = 30

    name = models.CharField(
        max_length=NAME_MAX_LEN
    )

    email_address = models.EmailField()

    photo = models.URLField()

    birth_date = models.DateField()

    works_full_time = models.BooleanField()

    created_on = models.DateTimeField(auto_now_add=True)


class Department(models.Model):
    CODE_MAX_LEN = 4
    NAME_MAX_LEN = 50
    LOCATION_MAX_LEN = 50
    LOCATION_CHOICES = (
        ("Sofia", "Sofia"),
        ("Plovdiv", "Plovdiv"),
        ("Burgas", "Burgas"),
        ("Varna", "Varna")
    )

    code = models.CharField(
        max_length=CODE_MAX_LEN,
        primary_key=True,
        unique=True,

    )

    name = models.CharField(
        max_length=NAME_MAX_LEN,
        unique=True,
        null=False,
        blank=False
    )

    employees_count = models.PositiveIntegerField(
        verbose_name='Employees Count',
        default=1,
        null=False,
        blank=False
    )

    location = models.CharField(
        max_length=LOCATION_MAX_LEN,
        choices=LOCATION_CHOICES
    )

    last_edited_on = models.DateTimeField(
        auto_now=True,
        editable=False
    )


class Project(models.Model):
    NAME_MAX_LEN = 100

    name = models.CharField(
        max_length=NAME_MAX_LEN,
        unique=True,
        null=False,
        blank=False
    )

    description = models.TextField(
        null=True,
        blank=True
    )

    budget = models.DecimalField(
        max_digits=10,
        decimal_places=2,
        null=True,
        blank=True
    )

    duration_in_days = models.PositiveIntegerField(
        verbose_name='Duration in Days',
        null=True,
        blank=True
    )

    estimated_hours = models.FloatField(
        verbose_name='Estimated Hours',
        null=True,
        blank=True
    )

    start_date = models.DateField(
        verbose_name='Start Date',
        default=date.today(),
        null=True,
        blank=True
    )

    created_on = models.DateTimeField(
        auto_now_add=True,
        editable=False
    )

    last_edited_on = models.DateTimeField(
        editable=False,
        auto_now=True,

    )