from django.db import models
from django.contrib.postgres.fields import ArrayField

# Model for user widgets
from farm.models import *

"""
Cadastral parcel has informations about grounds cadastral parcel
"""
class CadastralParcel(models.Model):
    grounds = models.ForeignKey(Ground,verbose_name=('Applicant'))
    precinct_plot_nr = models.TextField(default="", verbose_name=('precinct_plot'))
    sheet_map_nr = models.IntegerField(default=0, verbose_name=('sheet_map'))
    plot_nr = models.IntegerField(default=0, verbose_name=('plot'))
    hectare_quality = models.FloatField(default=0, verbose_name=('hectare_quality'))
    arable_land = models.FloatField(default=0, verbose_name=('arable_land'))
    arable_land_unreported = models.FloatField(default=0, verbose_name=('arable_land_unreported'))
    preeco_element = models.BooleanField(default=False, verbose_name=('preeco_element'))

    class Meta:
        verbose_name=('Cadastral parcel')
        verbose_name_plural=('Cadastral_parcel')
        db_table='document_cadastral_parcel'

"""
Cadastral_info has information about Agricultural land
"""
class CadastralInfo(models.Model):
    cadastral_parcel = models.ForeignKey(CadastralParcel,verbose_name=('cadastral_parcel'))
    agricultural_area_hectar = models.FloatField(default=0, verbose_name=('agricultural_area_hectar'))

    class Meta:
        verbose_name=('Cadastral info')
        verbose_name_plural=('Cadastral_info')
        db_table='document_cadastral_info'


"""
Aplicantion save last choosen option
"""
class ApplicationOptions(models.Model):
    target = ArrayField(models.TextField())
    statement = ArrayField(models.TextField())
    options = ArrayField(models.TextField())
    system_farm = ArrayField(models.TextField())

    class Meta:
        verbose_name=('Application options')
        verbose_name_plural=('Application_options')
        db_table='document_application_options'


"""
Aplicant save last configuration worker
"""
class ApplicantData(models.Model):
    identity_number = models.TextField(default="",verbose_name=('identity_number'))
    firstname = models.TextField(default="",verbose_name=('firstname'))
    secondname = models.TextField(default="",verbose_name=('secondname'))
    lastname = models.TextField(default="",verbose_name=('lastname'))
    pesel = models.TextField(default="",verbose_name=('pesel'))
    regon = models.TextField(default="",verbose_name=('regon'))
    number_passport = models.TextField(default="",verbose_name=('passport'))
    country_code = models.TextField(default="",verbose_name=('country_code'))
    phone = models.TextField(default="",verbose_name=('phone'))
    email = models.TextField(default="",verbose_name=('email'))
    bank_account = models.TextField(default="",verbose_name=('bank_account'))
    bank_name = models.TextField(default="",verbose_name=('bank_name'))
    bill_owner = models.TextField(default="",verbose_name=('bill_owner'))

    class Meta:
        verbose_name=('Applicant data')
        verbose_name_plural=('Applicant_data')
        db_table='document_applicant_data'

"""
Defined list of group crops
"""
class GroupCrops(models.Model):
    name = models.TextField(default="", verbose_name=('name'))

    class Meta:
        verbose_name=('Group crops')
        verbose_name_plural=('Group_crops')
        db_table='document_group_crops'

"""
Defined list of area
"""
class Area(models.Model):
    name = models.TextField(default="", verbose_name=('name'))

    class Meta:
        verbose_name=('Area')
        verbose_name_plural=('Area')
        db_table='document_area'

"""
Defined list of plant
"""
class Plant(models.Model):
    name = models.TextField(default="", verbose_name=('name'))

    class Meta:
        verbose_name=('Plant')
        verbose_name_plural=('Plant')
        db_table='document_plant'

"""
The_parcel has information about Agricultural land
"""
class TheParcel(models.Model):
    the_parcel_sign =  models.TextField(default="", verbose_name=('the_parcel_sign'))
    group_crops = models.ForeignKey(GroupCrops,verbose_name=('group_crops'))
    area = models.ForeignKey(Area,verbose_name=('area'))
    plant = models.ForeignKey(Plant,verbose_name=('plant'))
    cadastral_parcel = models.ManyToManyField(CadastralInfo)
    surface_plot =  models.FloatField(default=0, verbose_name=('surface_plot'))

    class Meta:
        verbose_name=('The parcel')
        verbose_name_plural=('The_parcel')
        db_table='document_the_parcel'

"""
Document has all information about applicant and his options
"""
class Document(models.Model):
    farm = models.ForeignKey(Farm, null=True, verbose_name=('Farm'))
    applicant_data = models.ForeignKey(ApplicantData,verbose_name=('Applicant'))
    application_options = models.ForeignKey(ApplicationOptions,verbose_name=('Options'))
    cadastral_parcel = models.ManyToManyField(CadastralParcel)
    create_data = models.DateTimeField(default=timezone.now,verbose_name=('create_data'))
    campaing_year = models.DateField(verbose_name=('campaing_year'),null=False,default=timezone.now)
    The_parcel = models.ManyToManyField(TheParcel)

    class Meta:
        verbose_name=('Document')
        verbose_name_plural=('Document')
        db_table='document_document'