# -*- coding: utf-8 -*-

from django.db import models
from p4l.models.common import P4lModel, P4lModelLang


class Imprint(P4lModelLang):
    record = models.ForeignKey('p4l.Record', related_name="imprints")
    imprintCity = models.CharField(max_length=512, blank=True, null=True, db_index=True)
    publisher = models.CharField(max_length=512, blank=True, null=True, db_index=True)
    imprintDate = models.CharField(max_length=512, blank=True, null=True, db_index=True)    


class Serie(P4lModelLang):
    record = models.ForeignKey('p4l.Record', related_name="series")
    title = models.CharField(max_length=2048, blank=False, null=False, db_index=True)
    volume = models.CharField(max_length=2048, blank=True, null=True, db_index=True)


class ProjectName(P4lModel):
    uri = models.URLField(max_length=2048, unique=True, db_index=True) 
#    label = models.CharField(max_length=2048, blank=False, null=False, db_index=True)
#    acronym = models.CharField(max_length=2048, blank=True, null=True, db_index=True) #iiep:acronym        # 
#    class Meta(P4lModel.Meta):
#        unique_together = ['label', 'acronym']


class CorporateAuthor(P4lModel):
    uri = models.URLField(max_length=2048, unique=True, db_index=True)
#    label = models.CharField(max_length=2048, blank=True, null=True, db_index=True)
#    acronym = models.CharField(max_length=2048, blank=True, null=True, db_index=True) #iiep:acronym    
#    class Meta(P4lModel.Meta):
#        unique_together = ['label','acronym']

class Url(P4lModel):
    record = models.ForeignKey('p4l.Record', related_name="urls", db_index=True)
    address = models.CharField(max_length=2048, blank=False, null=False, db_index=True) #iiep:address
    display = models.CharField(max_length=2048, blank=True, null=True, db_index=True) #iiep:display
    accessLevel = models.CharField(max_length=512, blank=True, null=True, db_index=True) #iiep:accessLevel


class Subject(P4lModel):
    uri = models.URLField(max_length=2048, unique=True, db_index=True)
    #label = models.CharField(max_length=2048, blank=True, null=True, db_index=True) # filled from sparql request after import

class Theme(P4lModel):
    uri = models.URLField(max_length=2048, unique=True, db_index=True)
    #label = models.CharField(max_length=2048, blank=True, null=True, db_index=True) # filled from sparql request after import


class Country(P4lModel):
    uri = models.URLField(max_length=2048, unique=True, db_index=True)
    #label = models.CharField(max_length=2048, blank=True, null=True, db_index=True) # filled from sparql request after import


class Isbn(P4lModelLang):
    record = models.ForeignKey('p4l.Record', related_name="isbns", db_index=True)
    isbn = models.CharField(max_length=128) #iiep:isbn


class Issn(P4lModelLang):
    record = models.ForeignKey('p4l.Record', related_name="issns", db_index=True)
    issn = models.CharField(max_length=128) #iiep:issn

class DocumentCode(P4lModelLang):
    record = models.ForeignKey('p4l.Record', related_name="documentCodes", db_index=True)
    documentCode = models.CharField(max_length=128) #iiep:issn

class Language(P4lModel):
    uri = models.URLField(max_length=2048, unique=True, db_index=True)
    #label = models.CharField(max_length=2048, blank=True, null=True, db_index=True) # filled from sparql request after import

class BaseTitle(P4lModelLang):
    title = models.CharField(max_length=2048, blank=False, null=False, db_index=True)
    class Meta(P4lModelLang.Meta):
        abstract = True

class Title(BaseTitle):
    record = models.ForeignKey('p4l.Record', related_name="titles", db_index=True)

class AddedTitle(BaseTitle):
    record = models.ForeignKey('p4l.Record', related_name="addedTitles", db_index=True)

class TitleMainDocument(BaseTitle):
    record = models.ForeignKey('p4l.Record', related_name="titlesMainDocument", db_index=True)


class Abstract(P4lModelLang):
    record = models.ForeignKey('p4l.Record', related_name="abstracts", db_index=True)
    abstract = models.TextField(blank=True, null=True)


class Collation(P4lModelLang):
    record = models.ForeignKey('p4l.Record', related_name="collations", db_index=True)
    collation = models.CharField(max_length=1024, blank=False, null=False, db_index=True)


class VolumeIssue(P4lModelLang):
    record = models.ForeignKey('p4l.Record', related_name="volumeIssues", db_index=True)
    volume = models.CharField(max_length=1024, blank=True, null=True, db_index=True) #iiep:volume
    number = models.CharField(max_length=1024, blank=True, null=True, db_index=True) #iiep:number


class P4lPerson(P4lModel):
    name = models.CharField(max_length=2048, blank=False, null=False, db_index=True)
    class Meta(P4lModel.Meta):
        abstract = True


class Author(P4lPerson):
    record = models.ForeignKey('p4l.Record', related_name="authors", db_index=True)
    
class SubjectPerson(P4lPerson):
    record = models.ForeignKey('p4l.Record', related_name="subjectPersons", db_index=True)

class Periodical(P4lModelLang):
    record = models.ForeignKey('p4l.Record', related_name="periodicals", db_index=True)
    label = models.CharField(max_length=2048, blank=False, null=False, db_index=True) #iiep:periodical


class BaseMeeting(P4lModel):
    label = models.CharField(max_length=2048, blank=False, null=False, db_index=True) #rdfs:label
    meetingNumber = models.CharField(max_length=2048, blank=True, null=True, db_index=True) #iiep:meetingNumber
    meetingPlace = models.CharField(max_length=2048, blank=True, null=True, db_index=True) #iiep:meetingPlace
    meetingDate = models.CharField(max_length=2048, blank=True, null=True, db_index=True) #iiep:meetingDate
    meetingYear = models.PositiveSmallIntegerField(blank=True, null=True, db_index=True) #iiep:meetingYear
    class Meta(P4lModel.Meta):
        abstract = True


class Meeting(BaseMeeting):
    lang = models.CharField(max_length=15, blank=True, null=True, db_index=True) #@xml:lang
    record = models.ForeignKey('p4l.Record', related_name="meetings")


class SubjectMeeting(BaseMeeting):
    record = models.ForeignKey('p4l.Record', related_name="subjectMeetings", db_index=True)


class Record(P4lModel):
    uri = models.URLField(max_length=2048, unique=True, db_index=True) #subject
    subjects = models.ManyToManyField('p4l.Subject') #dct:subject                                                       # <Thesaurus> with no country
    themes = models.ManyToManyField('p4l.Theme') #iiep:theme                                                            # <Themes>
    countries = models.ManyToManyField('p4l.Country') #iiep:country                                                     # <Thesaurus> filtered with country only
    identifier = models.CharField(max_length=128, unique=True, db_index=True) #dct:identifier    
    notes = models.TextField(blank=True, null=True) #iiep:notes    
    #issns foreign key from Isbn #iiep:issn
    #isbns foreign key from Isbn #iiep:isbn
    #documentCodes foreign key from Isbn #iiep:documentCode
    language = models.ForeignKey('p4l.Language', blank=True, null=True) #dct:language                                    # <Languages>
    otherLanguages = models.ManyToManyField('p4l.Language', related_name='otherLanguage_record') #iiep:otherLanguage     # <Languages>
    #titles foreign Key from Title #dct:title
    #abstracts foreign Key from Abstract #dct:abstract
    #addedTitles foreign Key from AddedTitle #iiep:addedTitle
    #titlesMainDocument foreign Key from TitleMainDocument #iiep:titleMainDocument
    editionStatement = models.CharField(max_length=1024, blank=True, null=True) #iiep:editionStatement
    #imprints foreign Key from Imprint #iiep:imprint
    #collations = foreign Key from Collation #iiep:collation
    #volumeIssues = foreign Key from VolumeIssue #iiep:volumeIssue
    projectNames = models.ManyToManyField('p4l.ProjectName') #iiep:projectName                                            # <Projects>
    #periodicals = foreign key from 'p4l.Periodical' #iiep:periodical
    #meetings = foreign key from 'p4l.Meeting' #iiep:meeting
    #series = foreign key from 'p4l.Serie'  #iiep:serie
    #authors = foreign key from 'p4l.Author' #iiep:author
    #subjectPersons = foreign key from 'p4l.SubjectPerson' #iiep:subjectPerson
    subjectCorporateBodies = models.ManyToManyField('p4l.CorporateAuthor', related_name='recordsSubjectCorporateBody') #iiep:subjectCorporateBody # <Organizations>
    #subjectMeetings = foreign key from 'p4l.SubjectMeeting' #iiep:subjectMeeting
    corporateAuthors = models.ManyToManyField('p4l.CorporateAuthor', related_name='recordsCorporateAuthor') #iiep:subjectCorporateBody # <Organizations>
    #urls foreign Key from Url #iiep:url
    recordType = models.URLField(max_length=2048) #dct:type                                                                # <DocumentType>
    
    isDocumentPart = models.BooleanField() #iiep:isDocumentPart
    isMultilingual = models.BooleanField() #iiep:isMultilingual
    
    def get_imprints_years(self):
        return set(sorted([i.imprintDate for i in self.imprints.all()]))

    def __unicode__(self):
        return "Record id %s { identifier: %s, uri: %s, editionStatement: %s,  recordType: %s, isDocumentPart: %s, notes: %s, language : %s}" \
            % (
                self.id,
                self.identifier,
                self.uri,
                self.editionStatement,
                self.recordType,
                self.isDocumentPart,
                self.notes[:100] if self.notes else None,
                self.language.id if self.language else None
            )

#('{http://www.iiep.unesco.org/plan4learning/model.owl#}issn', 3)
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}documentCode', 3)
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}country', 44)
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}imprint', 5)
#('{http://purl.org/dc/terms/}title', 4)
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}isDocumentPart', 1)
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}notes', 1)
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}isbn', 8)
#('{http://purl.org/dc/terms/}identifier', 1)
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}meeting', 4)
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}projectName', 10)
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}addedTitle', 18)
#('{http://purl.org/dc/terms/}subject', 29)
#('{http://purl.org/dc/terms/}language', 1)
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}serie', 4)
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}volumeIssue', 3)
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}url', 20)
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}titleMainDocument', 3)
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}otherLanguage', 13)
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}periodical', 3)
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}editionStatement', 1)
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}collation', 4)
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}subjectMeeting', 6)
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}corporateAuthor', 7)
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}author', 26)
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}subjectPerson', 2)
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}subjectCorporateBody', 8)
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}theme', 6)
#('{http://purl.org/dc/terms/}abstract', 3)
#('{http://purl.org/dc/terms/}type', 1)