snils = models.CharField(u"СНИЛС", max_length=30, default="")
birth_date = models.DateField(u"дата рождения")
phone = models.CharField(u"телефон", max_length=30)
def __unicode__(self):
return self.fio
class Meta:
verbose_name = u"работник"
verbose_name_plural = u"работники"Sertificate(models.Model):
worker = models.ForeignKey(
Worker,on_delete=models.CASCADE,verbose_name = u"работник"
) start_date = models.DateTimeField(u"дата начала сертификата")
end_date = models.DateTimeField(u"дата конца сертификата")
serial_number = models.CharField(u"серийный номер", max_length=50)
def __unicode__(self):
return self.serial_number
class Meta:
verbose_name = u"сертификат"
verbose_name_plural = u"сертификаты"WorkerMPA(models.Model):
worker = models.ForeignKey(Worker,on_delete=models.CASCADE)
mpa = models.ForeignKey("MPA", on_delete=models.CASCADE)MPA(models.Model):
name_mpa = models.CharField(u"название МПА", max_length=100)
type_mpa = models.CharField(u"тип МПА", max_length=100)
date_mpa = models.DateField(u"дата МПА")
num_mpa = models.CharField(u"номер МПА", max_length=100)
def __unicode__(self):
return self.name_mpa
class Meta:
verbose_name = u"муниципальный правовой акт"
verbose_name_plural = u"муниципальные правовые акты"
class OID(models.Model):
name_oid = models.CharField(u"название ОИД", max_length=100)
cod_oid = models.CharField(u"код ОИД", max_length=100)
comment = models.TextField(u"примечание",
null=True,blank=True)
def __unicode__(self):
return self.name_oid
class Meta:
verbose_name = u"ОИД"OIDSertCategory(models.Model):
oid = models.ForeignKey(OID,on_delete=models.CASCADE)
sertificatecategory = models.ForeignKey(
"SertificateCategory",on_delete=models.CASCADE
)SertificateCategory(models.Model):
name_category = models.CharField(u"название категории", max_length=100)
def __unicode__(self):
return self.name_category
class Meta:
verbose_name = u"категория сертификата"
verbose_name_plural = u"категории сертификатов"SertCategoryWorkerMPA(models.Model):
workermpa = models.ForeignKey(WorkerMPA,on_delete=models.CASCADE)
sertificatecategory = models.ForeignKey(
SertificateCategory,on_delete=models.CASCADE
)Token(models.Model):
ETOKEN = u'eToken'
RUTOKEN = u'ruToken'
TOKEN_CHOICES = (
(ETOKEN, u'eToken'),
(RUTOKEN, u'ruToken'),
)
type_token = models.CharField(u"тип", max_length=20, choices=TOKEN_CHOICES)
reg_num = models.CharField(u"регистрационный номер", max_length=20)
def __unicode__(self):
return self.type_token
class Meta:
verbose_name = u"token"
verbose_name_plural = u"token'ы"VerificationCenter (models.Model):
name = models.CharField(u"название", max_length=20)
comment = models.TextField(u"примечание", null=True,
blank=True)
def __unicode__(self):
return self.name
class Meta:
verbose_name = u"удостоверяющий центр"
verbose_name_plural = u"удостоверяющие центры"
class ContractType (models.Model):
name = models.CharField(u"тип контракта", max_length=100)
def __unicode__(self):
return self.name
class Meta:
verbose_name = u"тип контракта"
verbose_name_plural = u"типы контрактов"Contract (models.Model):
verificationcenter = models.ForeignKey (
VerificationCenter, on_delete=models.CASCADE,
verbose_name = u"удостоверяющий центр", null=True
)
contracttype = models.ForeignKey (ContractType, on_delete=models.CASCADE,
verbose_name = u"тип контракта")
reg_num = models.CharField(u"регистрационный номер", max_length=20)
start_date = models.DateField(u"дата начала контракта")
end_date = models.DateField(u"дата окончания контракта")
comment = models.TextField(u"примечание", null=True,blank=True)
def __unicode__(self):
return self.reg_num
class Meta:
verbose_name = u"контракт"
verbose_name_plural = u"контракты"ContractLine (models.Model):
contract = models.ForeignKey ("Contract", on_delete=models.CASCADE)
price = models.FloatField ("Цена")
count_sert = models.PositiveSmallIntegerField("количество")Application (models.Model):
worker = models.ForeignKey ("Worker", on_delete=models.CASCADE,verbose_name = u"работник")
sertificatecategory = models.ForeignKey ("Sertificatecategory",
on_delete=models.CASCADE,verbose_name = u"категория сертификата")
verificationcenter = models.ForeignKey ("Verificationcenter", on_delete=models.CASCADE,
verbose_name = u"удостоверяющий центр")
date = models.DateField(u"дата")
class Meta:
verbose_name = u"заявка"
verbose_name_plural = u"заявки"SertificateDelivery (models.Model):
worker = models.ForeignKey ("Worker", on_delete=models.CASCADE,verbose_name = u"работник")
delivery_date = models.DateField(u"дата выдачи сертификата")
early_stop_date = models.DateField(u"дата досрочного прекращения")
destruction_date = models.DateField(u"отметка об уничтожении")
token = models.ForeignKey ("Token", on_delete=models.CASCADE)
contract= models.ForeignKey ("Contract", on_delete=models.CASCADE,verbose_name = u"контракт")
def delivery_d(self):
return self.delivery_date
class Meta:
verbose_name = u"выдача сертификатов"
verbose_name_plural = u"выдача сертификатов"