class Migration(migrations.Migration):
initial = True
dependencies = [
]
operations = [
migrations.CreateModel(
name='Appointments',
fields=[
('appointment_number', models.IntegerField(primary_key=True, serialize=False)),
('appointment_date', models.DateField()),
('appointment_time', models.TimeField()),
],
options={
'verbose_name': 'Appointment',
'verbose_name_plural': 'Appointments',
},
),
migrations.CreateModel(
name='Claims',
fields=[
('claim_number', models.IntegerField(primary_key=True, serialize=False)),
('claim_date', models.DateTimeField(default=datetime.datetime(2019, 12, 9, 23, 4, 20, 96594, tzinfo=utc))),
('claim_amount', models.IntegerField()),
],
options={
'verbose_name': 'Claim',
'verbose_name_plural': 'Claims',
},
),
migrations.CreateModel(
name='Customers',
fields=[
('cust_name', models.CharField(max_length=50)),
('insurance_number', models.CharField(max_length=6, primary_key=True, serialize=False)),
('email', models.EmailField(max_length=100)),
('phone_number', models.CharField(max_length=50)),
('dob', models.DateTimeField()),
('address', models.CharField(max_length=200)),
],
options={
'verbose_name': 'Customer',
'verbose_name_plural': 'Customers',
},
),
migrations.CreateModel(
name='Providers',
fields=[
('provider_name', models.CharField(max_length=50)),
('provider_id', models.CharField(max_length=5, primary_key=True, serialize=False)),
('speciality', models.CharField(max_length=100)),
],
options={
'verbose_name': 'Provider',
'verbose_name_plural': 'Providers',
},
),
migrations.AddField(
model_name='claims',
name='insurance_number',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='d', to='blog.Customers'),
),
migrations.AddField(
model_name='claims',
name='provider_id',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='b', to='blog.Providers'),
),
migrations.AddField(
model_name='appointments',
name='insurance_number',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='b', to='blog.Customers'),
),
migrations.AddField(
model_name='appointments',
name='provider_id',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='a', to='blog.Providers'),
),
]
class AbstractHourlyMeasure(models.Model):
state_code = models.CharField(_("State code"),
max_length=3,
blank=True,
null=True)
county_code = models.CharField(_("County code"),
max_length=3,
blank=True,
null=True)
site_num = models.CharField(_("Site number"),
max_length=4,
blank=True,
null=True)
parameter_code = models.CharField(_("Parameter code"),
max_length=5,
blank=True,
null=True)
poc = models.SmallIntegerField(_("POC"), blank=True, null=True)
latitude = models.FloatField(_("Latitude"), blank=True, null=True)
longitude = models.FloatField(_("Longitude"), blank=True, null=True)
datum = models.CharField(_("Datum"), max_length=8, blank=True, null=True)
parameter_name = models.CharField(_("Parameter Name"),
max_length=32,
blank=True,
null=True)
date_local = models.DateField(_("Local date"), blank=True, null=True)
time_local = models.TimeField(_("Local time"), blank=True, null=True)
date_gmt = models.DateField(_("GMT date"), blank=True, null=True)
time_gmt = models.TimeField(_("GMT time"), blank=True, null=True)
sample_measurement = models.FloatField(_("Sample measurement"),
blank=True,
null=True)
units_of_measure = models.CharField(_("Units of measurement"),
max_length=64,
blank=True,
null=True)
mdl = models.FloatField(_("MDL"), blank=True, null=True)
unceirtanty = models.CharField(_("Unceirtanty"),
max_length=32,
blank=True,
null=True)
qualifier = models.CharField(_("Qualifier"),
max_length=32,
blank=True,
null=True)
method_type = models.CharField(_("Method type"),
max_length=32,
blank=True,
null=True)
method_code = models.CharField(_("Method code"),
max_length=32,
blank=True,
null=True)
method_name = models.CharField(_("Method name"),
max_length=128,
blank=True,
null=True)
state_name = models.CharField(_("State name"),
max_length=64,
blank=True,
null=True)
county_name = models.CharField(_("County name"),
max_length=64,
blank=True,
null=True)
date_of_last_change = models.DateField(_("Date of last change"),
blank=True,
null=True)
@property
def min_format(self):
return (self.parameter_name, self.sample_measurement,
self.units_of_measure)
class Meta:
abstract = True
class MusicTrack(models.Model):
name = models.TextField(max_length=200, null=False)
name_es = models.TextField(max_length=200, null=False)
author = models.ForeignKey(Author)
short_description = models.TextField(max_length=160, null=False)
long_description = models.TextField(max_length=2000, null=False)
short_description_es = models.TextField(max_length=160, null=False)
long_description_es = models.TextField(max_length=2000, null=False)
duration = models.TimeField(null=False)
image = models.ImageField(
upload_to='music_tracks',
null=True,
)
song_preview = models.FileField(
upload_to='music_tracks',
null=True,
)
song = models.FileField(
upload_to='private_music_tracks',
null=True,
)
price = models.FloatField(null=False, default=1)
category = models.ForeignKey(Category)
tags = models.ManyToManyField(Tag)
def __str__(self):
return self.name
def downloaded_file_name(self):
"""
Returns the filename of the downlodaded file
:return: string
"""
return self.name + '.' + self.song.url.split(".")[-1]
def backend(self, full=False):
base = {
'id': self.id,
'name': self.name,
'name_es': self.name_es,
'short_description': self.short_description,
'short_description_es': self.short_description_es,
'image': settings.BASE_URL + self.image.name,
'price': self.price,
}
if full:
base['author_id'] = self.author_id
base['author'] = self.author.name
base['long_description'] = self.long_description
base['long_description_es'] = self.long_description_es
base['preview'] = settings.BASE_URL + self.song_preview.name
base['length'] = self.duration,
base['category'] = self.category.name,
base['category_es'] = self.category.name_es,
return base
class Photo(models.Model):
user = models.ForeignKey(settings.AUTH_USER_MODEL,
on_delete=models.CASCADE,
related_name='photos')
flickr_id = models.CharField(max_length=100)
secret = models.CharField(max_length=100, blank=True)
title = models.CharField(max_length=300, blank=True)
flickr_tags = models.CharField(max_length=300, blank=True)
date_imported = models.DateTimeField(auto_now_add=True)
date_taken = models.DateField(blank=True, null=True)
time_taken = models.TimeField(blank=True, null=True)
processed = models.BooleanField(default=False)
exif_imported = models.BooleanField(default=False)
machine_tags = models.CharField(max_length=300, blank=True)
camera = models.CharField(max_length=300, blank=True)
lens = models.CharField(max_length=300, blank=True)
aperture = models.DecimalField(blank=True,
null=True,
max_digits=5,
decimal_places=2)
exposure = models.CharField(max_length=300, blank=True)
iso = models.IntegerField(blank=True, null=True)
latitude = models.DecimalField(blank=True,
null=True,
max_digits=9,
decimal_places=6)
longitude = models.DecimalField(blank=True,
null=True,
max_digits=9,
decimal_places=6)
url_sq = models.URLField(blank=True)
url_t = models.URLField(blank=True)
url_s = models.URLField(blank=True)
url_q = models.URLField(blank=True)
url_m = models.URLField(blank=True)
url_n = models.URLField(blank=True)
url_z = models.URLField(blank=True)
url_c = models.URLField(blank=True)
url_l = models.URLField(blank=True)
url_o = models.URLField(blank=True)
def __str__(self):
return self.title
def get_api_data(self, method, api=None, **kwargs):
if api is None:
api = get_flickr_api_user_session(self.user)
r = api.get(method, **kwargs)
r.raise_for_status()
return r.json()
def get_info(self, api=None):
return self.get_api_data('flickr.photos.getInfo',
api,
params=dict(photo_id=self.flickr_id))
def get_exif(self, api=None):
return self.get_api_data('flickr.photos.getExif',
api,
params=dict(photo_id=self.flickr_id))
def update_geodata(self, api=None):
data = self.get_api_data('flickr.photos.getInfo',
api,
params=dict(photo_id=self.flickr_id))
try:
lat = data['photo']['location']['latitude']
lng = data['photo']['location']['longitude']
except KeyError:
return False
if not (lat and lng):
return False
self.latitude = lat
self.longitude = lng
self.save()
return True
def tag(self):
from .google import tag_photo
tag_photo(self.id)
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Patient',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=150)),
('age', models.DecimalField(decimal_places=0, max_digits=100)),
('sex',
models.CharField(choices=[('1', 'male'), ('2', 'female'),
('3', "don't wanna tell")],
default='male',
max_length=100)),
('mob', models.CharField(max_length=12)),
('emailid', models.EmailField(max_length=150)),
],
),
migrations.CreateModel(
name='Appointment',
fields=[
('patient_ptr',
models.OneToOneField(
auto_created=True,
on_delete=django.db.models.deletion.CASCADE,
parent_link=True,
primary_key=True,
serialize=False,
to='doc_patient.Patient')),
('date', models.DateField()),
('time', models.TimeField()),
('description', models.TextField()),
('xray_1', models.ImageField(upload_to=None)),
('xray_2', models.ImageField(upload_to=None)),
],
bases=('doc_patient.patient', ),
),
migrations.CreateModel(
name='Doctor',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('Name', models.CharField(max_length=150)),
('dept', models.CharField(max_length=150)),
('timing', models.DateTimeField()),
('patient',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='doc_patient.Patient')),
],
),
]
class Migration(migrations.Migration):
dependencies = [
('core', '0015_auto_20161030_1105'),
]
operations = [
migrations.CreateModel(
name='TVSeries',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name_rus', models.CharField(blank=True, max_length=255)),
('name_eng', models.CharField(blank=True, max_length=255)),
('date_release_last_ongoing_series', models.DateTimeField(default=datetime.datetime.now)),
('site', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='tv_series', to='core.SiteCinema')),
],
options={
'ordering': ('date_release_last_ongoing_series',),
},
),
migrations.RemoveField(
model_name='sitetvseries',
name='site',
),
migrations.AlterModelOptions(
name='news',
options={'ordering': ('-date_created',)},
),
migrations.AlterModelOptions(
name='series',
options={'ordering': ('-date_created',)},
),
migrations.RenameField(
model_name='series',
old_name='dc',
new_name='date_created',
),
migrations.RenameField(
model_name='usernews',
old_name='dc',
new_name='date_created',
),
migrations.RenameField(
model_name='userseries',
old_name='dc',
new_name='date_created',
),
migrations.RemoveField(
model_name='news',
name='dc',
),
migrations.AddField(
model_name='news',
name='date',
field=models.DateField(blank=True, null=True),
),
migrations.AddField(
model_name='news',
name='date_created',
field=models.DateTimeField(auto_now_add=True, default=django.utils.timezone.now),
preserve_default=False,
),
migrations.AddField(
model_name='news',
name='time',
field=models.TimeField(blank=True, null=True),
),
migrations.AlterField(
model_name='series',
name='tv_series',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='series', to='core.TVSeries'),
),
migrations.AlterField(
model_name='telegrambot',
name='sites_cinema',
field=models.ManyToManyField(blank=True, related_name='bots', to='core.SiteCinema'),
),
migrations.AlterField(
model_name='telegrambot',
name='sites_news',
field=models.ManyToManyField(blank=True, related_name='bots', to='core.SiteNews'),
),
migrations.AlterField(
model_name='userseries',
name='tv_series',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='users', to='core.TVSeries'),
),
migrations.DeleteModel(
name='SiteTVSeries',
),
]
class DjangoDocument(models.Model):
"""
Базовая абстрактная Django-модель для сохранения платежного документа из формата 1CClientBankExchange
"""
class Meta:
abstract = True
document_type = models.TextField(null=True, blank=True)
number = models.IntegerField(null=True, blank=True)
date = models.DateField(null=True, blank=True)
amount = models.DecimalField(max_digits=15, decimal_places=2, null=True, blank=True)
receipt_date = models.DateField(null=True, blank=True)
receipt_time = models.TimeField(null=True, blank=True)
receipt_content = models.TextField(null=True, blank=True)
payer_account = models.CharField(max_length=20, null=True, blank=True)
payer_date_charged = models.DateField(null=True, blank=True)
payer_name = models.TextField(null=True, blank=True)
payer_inn = models.CharField(max_length=12, null=True, blank=True)
payer_l1_name = models.TextField(null=True, blank=True)
payer_l2_account_number = models.TextField(null=True, blank=True)
payer_l3_bank = models.TextField(null=True, blank=True)
payer_l4_city = models.TextField(null=True, blank=True)
payer_account_number = models.CharField(max_length=20, null=True, blank=True)
payer_bank_1_name = models.TextField(null=True, blank=True)
payer_bank_2_city = models.TextField(null=True, blank=True)
payer_bank_bic = models.CharField(max_length=9, null=True, blank=True)
payer_bank_corr_account = models.CharField(max_length=20, null=True, blank=True)
receiver_account = models.CharField(max_length=20, null=True, blank=True)
receiver_date_received = models.DateField(null=True, blank=True)
receiver_name = models.TextField(null=True, blank=True)
receiver_inn = models.CharField(max_length=12, null=True, blank=True)
receiver_l1_name = models.TextField(null=True, blank=True)
receiver_l2_account_number = models.TextField(null=True, blank=True)
receiver_l3_bank = models.TextField(null=True, blank=True)
receiver_l4_city = models.TextField(null=True, blank=True)
receiver_account_number = models.CharField(max_length=20, null=True, blank=True)
receiver_bank_1_name = models.TextField(null=True, blank=True)
receiver_bank_2_city = models.TextField(null=True, blank=True)
receiver_bank_bic = models.CharField(max_length=9, null=True, blank=True)
receiver_bank_corr_account = models.CharField(max_length=20, null=True, blank=True)
payment_payment_type = models.TextField(null=True, blank=True)
payment_operation_type = models.CharField(max_length=2, null=True, blank=True)
payment_code = models.CharField(max_length=25, null=True, blank=True)
payment_purpose = models.TextField(null=True, blank=True)
payment_purpose_l1 = models.TextField(null=True, blank=True)
payment_purpose_l2 = models.TextField(null=True, blank=True)
payment_purpose_l3 = models.TextField(null=True, blank=True)
payment_purpose_l4 = models.TextField(null=True, blank=True)
payment_purpose_l5 = models.TextField(null=True, blank=True)
payment_purpose_l6 = models.TextField(null=True, blank=True)
tax_originator_status = models.CharField(max_length=2, null=True, blank=True)
tax_payer_kpp = models.CharField(max_length=9, null=True, blank=True)
tax_receiver_kpp = models.CharField(max_length=9, null=True, blank=True)
tax_kbk = models.CharField(max_length=20, null=True, blank=True)
tax_okato = models.CharField(max_length=11, null=True, blank=True)
tax_basis = models.CharField(max_length=2, null=True, blank=True)
tax_period = models.CharField(max_length=10, null=True, blank=True)
tax_number = models.TextField(null=True, blank=True)
tax_date = models.TextField(null=True, blank=True)
tax_type = models.TextField(null=True, blank=True)
special_priority = models.CharField(max_length=2, null=True, blank=True)
special_term_of_acceptance = models.TextField(null=True, blank=True)
special_letter_of_credit_type = models.TextField(null=True, blank=True)
special_maturity = models.TextField(null=True, blank=True)
special_payment_condition_1 = models.TextField(null=True, blank=True)
special_payment_condition_2 = models.TextField(null=True, blank=True)
special_payment_condition_3 = models.TextField(null=True, blank=True)
special_by_submission = models.TextField(null=True, blank=True)
special_extra_conditions = models.TextField(null=True, blank=True)
special_supplier_account_number = models.TextField(null=True, blank=True)
special_docs_sent_date = models.TextField(null=True, blank=True)
@classmethod
def from_document(cls, document: Document):
return cls(
document_type=document.document_type,
number=document.number,
date=document.date,
amount=document.amount,
receipt_date=document.receipt.date,
receipt_time=document.receipt.time,
receipt_content=document.receipt.content,
payer_account=document.payer.account,
payer_date_charged=document.payer.date_charged,
payer_name=document.payer.name,
payer_inn=document.payer.inn,
payer_l1_name=document.payer.l1_name,
payer_l2_account_number=document.payer.l2_account_number,
payer_l3_bank=document.payer.l3_bank,
payer_l4_city=document.payer.l4_city,
payer_account_number=document.payer.account_number,
payer_bank_1_name=document.payer.bank_1_name,
payer_bank_2_city=document.payer.bank_2_city,
payer_bank_bic=document.payer.bank_bic,
payer_bank_corr_account=document.payer.bank_corr_account,
receiver_account=document.receiver.account,
receiver_date_received=document.receiver.date_received,
receiver_name=document.receiver.name,
receiver_inn=document.receiver.inn,
receiver_l1_name=document.receiver.l1_name,
receiver_l2_account_number=document.receiver.l2_account_number,
receiver_l3_bank=document.receiver.l3_bank,
receiver_l4_city=document.receiver.l4_city,
receiver_account_number=document.receiver.account_number,
receiver_bank_1_name=document.receiver.bank_1_name,
receiver_bank_2_city=document.receiver.bank_2_city,
receiver_bank_bic=document.receiver.bank_bic,
receiver_bank_corr_account=document.receiver.bank_corr_account,
payment_payment_type=document.payment.payment_type,
payment_operation_type=document.payment.operation_type,
payment_code=document.payment.code,
payment_purpose=document.payment.purpose,
payment_purpose_l1=document.payment.purpose_l1,
payment_purpose_l2=document.payment.purpose_l2,
payment_purpose_l3=document.payment.purpose_l3,
payment_purpose_l4=document.payment.purpose_l4,
payment_purpose_l5=document.payment.purpose_l5,
payment_purpose_l6=document.payment.purpose_l6,
tax_originator_status=document.tax.originator_status,
tax_payer_kpp=document.tax.payer_kpp,
tax_receiver_kpp=document.tax.receiver_kpp,
tax_kbk=document.tax.kbk,
tax_okato=document.tax.okato,
tax_basis=document.tax.basis,
tax_period=document.tax.period,
tax_number=document.tax.number,
tax_date=document.tax.date,
tax_type=document.tax.type,
special_priority=document.special.priority,
special_term_of_acceptance=document.special.term_of_acceptance,
special_letter_of_credit_type=document.special.letter_of_credit_type,
special_maturity=document.special.maturity,
special_payment_condition_1=document.special.payment_condition_1,
special_payment_condition_2=document.special.payment_condition_2,
special_payment_condition_3=document.special.payment_condition_3,
special_by_submission=document.special.by_submission,
special_extra_conditions=document.special.extra_conditions,
special_supplier_account_number=document.special.supplier_account_number,
special_docs_sent_date=document.special.docs_sent_date
)
# noinspection PyTypeChecker
def to_document(self):
return Document(
document_type=self.document_type,
number=self.number,
date=self.date,
amount=self.amount,
receipt=Receipt(
date=self.receipt_date,
time=self.receipt_time,
content=self.receipt_content,
),
payer=Payer(
account=self.payer_account,
date_charged=self.payer_date_charged,
name=self.payer_name,
inn=self.payer_inn,
l1_name=self.payer_l1_name,
l2_account_number=self.payer_l2_account_number,
l3_bank=self.payer_l3_bank,
l4_city=self.payer_l4_city,
account_number=self.payer_account_number,
bank_1_name=self.payer_bank_1_name,
bank_2_city=self.payer_bank_2_city,
bank_bic=self.payer_bank_bic,
bank_corr_account=self.payer_bank_corr_account,
),
receiver=Receiver(
account=self.receiver_account,
date_received=self.receiver_date_received,
name=self.receiver_name,
inn=self.receiver_inn,
l1_name=self.receiver_l1_name,
l2_account_number=self.receiver_l2_account_number,
l3_bank=self.receiver_l3_bank,
l4_city=self.receiver_l4_city,
account_number=self.receiver_account_number,
bank_1_name=self.receiver_bank_1_name,
bank_2_city=self.receiver_bank_2_city,
bank_bic=self.receiver_bank_bic,
bank_corr_account=self.receiver_bank_corr_account,
),
payment=Payment(
payment_type=self.payment_payment_type,
operation_type=self.payment_operation_type,
code=self.payment_code,
purpose=self.payment_purpose,
purpose_l1=self.payment_purpose_l1,
purpose_l2=self.payment_purpose_l2,
purpose_l3=self.payment_purpose_l3,
purpose_l4=self.payment_purpose_l4,
purpose_l5=self.payment_purpose_l5,
purpose_l6=self.payment_purpose_l6,
),
tax=Tax(
originator_status=self.tax_originator_status,
payer_kpp=self.tax_payer_kpp,
receiver_kpp=self.tax_receiver_kpp,
kbk=self.tax_kbk,
okato=self.tax_okato,
basis=self.tax_basis,
period=self.tax_period,
number=self.tax_number,
date=self.tax_date,
type=self.tax_type,
),
special=Special(
priority=self.special_priority,
term_of_acceptance=self.special_term_of_acceptance,
letter_of_credit_type=self.special_letter_of_credit_type,
maturity=self.special_maturity,
payment_condition_1=self.special_payment_condition_1,
payment_condition_2=self.special_payment_condition_2,
payment_condition_3=self.special_payment_condition_3,
by_submission=self.special_by_submission,
extra_conditions=self.special_extra_conditions,
supplier_account_number=self.special_supplier_account_number,
docs_sent_date=self.special_docs_sent_date
)
)
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Atividade',
fields=[
('id',
models.UUIDField(default=uuid.uuid4,
editable=False,
primary_key=True,
serialize=False)),
('created_at',
models.DateTimeField(auto_now_add=True,
verbose_name='criado em')),
('updated_at',
models.DateTimeField(auto_now=True,
verbose_name='atualizado em')),
('nome',
models.CharField(max_length=255,
verbose_name='nome da atividade')),
('duracao', models.TimeField(verbose_name='duração')),
('data', models.DateField(verbose_name='data da atividade')),
('hora', models.TimeField(verbose_name='hora da atividade')),
('tipo',
models.IntegerField(choices=[(0, 'Palestra'),
(1, 'Minicurso')],
verbose_name='tipo de atividade')),
('inscritos',
models.ManyToManyField(blank=True,
related_name='inscritos',
to=settings.AUTH_USER_MODEL,
verbose_name='inscritos')),
],
options={
'verbose_name': 'atividade',
'verbose_name_plural': 'atividades',
},
),
migrations.CreateModel(
name='Evento',
fields=[
('id',
models.UUIDField(default=uuid.uuid4,
editable=False,
primary_key=True,
serialize=False)),
('created_at',
models.DateTimeField(auto_now_add=True,
verbose_name='criado em')),
('updated_at',
models.DateTimeField(auto_now=True,
verbose_name='atualizado em')),
('nome',
models.CharField(max_length=255,
verbose_name='nome do evento')),
('criado', models.DateTimeField(auto_now_add=True)),
('dono',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='users',
to=settings.AUTH_USER_MODEL,
verbose_name='dono do evento')),
('minicursos',
models.ManyToManyField(blank=True,
related_name='minicursos',
to='evento.Atividade',
verbose_name='minicursos')),
('palestras',
models.ManyToManyField(blank=True,
related_name='palestras',
to='evento.Atividade',
verbose_name='palestras')),
],
options={
'verbose_name': 'evento',
'verbose_name_plural': 'eventos',
},
),
migrations.CreateModel(
name='Palestrante',
fields=[
('id',
models.UUIDField(default=uuid.uuid4,
editable=False,
primary_key=True,
serialize=False)),
('created_at',
models.DateTimeField(auto_now_add=True,
verbose_name='criado em')),
('updated_at',
models.DateTimeField(auto_now=True,
verbose_name='atualizado em')),
('nome',
models.CharField(max_length=255,
verbose_name='nome do palestrante')),
],
options={
'verbose_name': 'palestrante',
'verbose_name_plural': 'palestrantes',
},
),
migrations.AddField(
model_name='atividade',
name='palestrante',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='user',
to='evento.Palestrante',
verbose_name='palestrante'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
]
operations = [
migrations.CreateModel(
name='ClientCli',
fields=[
('cli_id', models.AutoField(primary_key=True, serialize=False)),
('cli_nom', models.CharField(max_length=100, null=True, verbose_name='Nom')),
('cli_prenom', models.CharField(max_length=100, null=True, verbose_name='Prénom')),
('cli_situation', models.CharField(choices=[('Marié (e)', 'Marié (e)'), ('Divorcé (e)', 'Divorcé (e)'), ('Célibataire', 'Célibataire'), ('Séparé (e)', 'Séparé (e)'), ('Veuf (ve)', 'Veuf (ve)')], max_length=100, null=True, verbose_name='Situation matrimoniale')),
('cli_contact', models.CharField(max_length=100, null=True, verbose_name='Contact')),
('cli_email', models.EmailField(max_length=100, null=True, verbose_name='Email')),
('cli_noumber_of_pesons', models.IntegerField(blank=True, null=True, verbose_name='Nombre de personne dans le foyer')),
('cli_adresse_professionnelle', models.CharField(max_length=100, null=True, verbose_name='Adresse professionnelle')),
('cli_pays', django_countries.fields.CountryField(max_length=2, null=True, verbose_name='Pays')),
('cli_ville', models.CharField(max_length=100, null=True, verbose_name='Ville')),
('cli_lieu_recherche', models.CharField(max_length=100, null=True, verbose_name='Lieu de recherche')),
('cli_type_bien', models.CharField(help_text='Maison ou Appart et taille', max_length=100, verbose_name='Type de bien')),
('cli_pack', models.CharField(choices=[('pack dossier', 'pack dossier'), ('pack visites', 'pack visites')], max_length=100, null=True, verbose_name='Pack')),
('cli_budget', models.DecimalField(decimal_places=0, max_digits=8, null=True, verbose_name='Budget alloué')),
('cli_salaire_total', models.DecimalField(decimal_places=0, max_digits=8, null=True, verbose_name='Salaire total du foyer')),
('cli_montant_declare', models.DecimalField(decimal_places=0, max_digits=8, null=True, verbose_name="Montant declaré sur le dernier avis d'import")),
('cli_type', models.CharField(choices=[('visites substituées', 'visites substituées'), ('visites physiques', 'visites physiques')], max_length=100, null=True, verbose_name='Type visite')),
('cli_horaire_debut', models.TimeField(null=True, verbose_name='Heure début: créneau horaire de visite')),
('cli_horaire_fin', models.TimeField(null=True, verbose_name='Heure fin: créneau horaire de visite')),
('cli_motif', models.TextField(null=True, verbose_name='Motif de déménagement')),
('cli_document_avis', models.FileField(null=True, upload_to='documents/', verbose_name="Pièce 1: Avis d'impot, attestation d'emplyeur ou contrat de travail")),
('cli_document_paye', models.FileField(null=True, upload_to='documents/', verbose_name="Pièce 2: 3 dernières fiches de payes, pièces d'identité")),
('cli_document_quittance', models.FileField(null=True, upload_to='documents/', verbose_name='Pièce 3: 3 dernières quittance de loyers')),
('cli_decision_ok', models.BooleanField(blank=True, null=True, verbose_name='Décision')),
('cli_decision_reunion', models.BooleanField(blank=True, null=True, verbose_name='Reunion')),
],
options={
'verbose_name': 'Client',
'db_table': 'client_cli',
'managed': True,
},
),
migrations.CreateModel(
name='PlanningPla',
fields=[
('pla_id', models.AutoField(primary_key=True, serialize=False)),
('pla_intitule', models.CharField(max_length=100, unique=True, verbose_name='Jour')),
],
options={
'verbose_name': 'Planning',
'db_table': 'planning_pla',
'managed': True,
},
),
migrations.CreateModel(
name='VisiteVit',
fields=[
('vit_id', models.AutoField(primary_key=True, serialize=False)),
('vit_commentaire', models.TextField(blank=True, null=True, verbose_name='Commentaire')),
('vit_bilan', models.TextField(blank=True, null=True, verbose_name='Bilan de la visite')),
('vit_date', models.DateTimeField(blank=True, null=True, verbose_name='Date prevu de la visite')),
('cli', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='soumission.ClientCli', verbose_name='Client')),
],
options={
'verbose_name': 'Visite',
'db_table': 'visite_vit',
'managed': True,
},
),
migrations.CreateModel(
name='RecommandationNek',
fields=[
('nek_id', models.AutoField(primary_key=True, serialize=False)),
('nek_recommandation', models.TextField(blank=True, null=True, verbose_name='Recommandation')),
('nek_date_recommandation', models.DateField(auto_now_add=True, null=True, verbose_name='Date')),
('nek_decision', models.CharField(choices=[('Ok', 'Ok'), ('Demande de reunion', 'Demande de reunion')], max_length=100, null=True, verbose_name='Decision')),
('cli', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='soumission.ClientCli', verbose_name='Client')),
],
options={
'verbose_name': 'Recommandation',
'db_table': 'recommandation_nek',
'managed': True,
},
),
migrations.CreateModel(
name='CommentaireDem',
fields=[
('dem_id', models.AutoField(primary_key=True, serialize=False)),
('dem_commentaires', models.TextField(blank=True, null=True, verbose_name='Commentaire')),
('dem_date_commentaire', models.DateTimeField(auto_now_add=True, null=True, verbose_name='Date')),
('dem_decision', models.CharField(choices=[('Ok', 'Ok'), ('Demande de reunion', 'Demande de reunion')], max_length=100, null=True, verbose_name='Decision')),
('cli', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='soumission.ClientCli', verbose_name='Client')),
],
options={
'verbose_name': 'Commentaire',
'db_table': 'commentaire_dem',
'managed': True,
},
),
migrations.AddField(
model_name='clientcli',
name='cli_planning',
field=models.ManyToManyField(to='soumission.PlanningPla', verbose_name='Planning'),
),
migrations.CreateModel(
name='BilanBil',
fields=[
('bil_id', models.AutoField(primary_key=True, serialize=False)),
('bil_commentaire', models.TextField(blank=True, null=True, verbose_name='Bilan semaine')),
('bil_date', models.DateTimeField(blank=True, null=True, verbose_name='Date')),
('cli', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='soumission.ClientCli', verbose_name='Client')),
],
options={
'verbose_name': 'Bilan',
'db_table': 'bilan_bil',
'managed': True,
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
]
operations = [
migrations.CreateModel(
name='administrador',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
],
),
migrations.CreateModel(
name='aluno',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
],
),
migrations.CreateModel(
name='config',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('dominio', models.CharField(max_length=200)),
('endservidor', models.CharField(max_length=200)),
('gadmin', models.CharField(max_length=200)),
('ou', models.CharField(max_length=200)),
('filter', models.TextField(verbose_name='Filtro')),
('hora_fechamento_vendas', models.TimeField(default='23:59:59')),
],
),
migrations.CreateModel(
name='pessoa',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('nome', models.CharField(max_length=100)),
('usuario', models.CharField(max_length=11, unique=True)),
('status', models.BooleanField()),
],
),
migrations.CreateModel(
name='prato',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('descricao', models.TextField(max_length=200)),
('preco', models.FloatField()),
('status', models.BooleanField()),
],
),
migrations.CreateModel(
name='usuariorestaurante',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('id_pessoa', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.pessoa')),
],
),
migrations.CreateModel(
name='venda',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('data', models.DateTimeField()),
('valor', models.FloatField()),
('id_aluno', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.aluno')),
('id_prato', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.prato')),
('id_usuario_restaurante', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.usuariorestaurante')),
],
),
migrations.AddField(
model_name='aluno',
name='id_pessoa',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.pessoa'),
),
migrations.AddField(
model_name='administrador',
name='id_pessoa',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.pessoa'),
),
]
class Migration(migrations.Migration):
dependencies = [
('OceanInspect', '0005_delete_oceaninspectexport'),
]
operations = [
migrations.AlterModelOptions(
name='oceaninspectmodel',
options={'verbose_name': '海洋監測報表', 'verbose_name_plural': '海洋監測報表'},
),
migrations.AlterField(
model_name='oceaninspectmodel',
name='inspectAirTemp',
field=models.FloatField(verbose_name='氣溫', null=True),
),
migrations.AlterField(
model_name='oceaninspectmodel',
name='inspectBOD',
field=models.FloatField(verbose_name='生化需氧量', null=True),
),
migrations.AlterField(
model_name='oceaninspectmodel',
name='inspectCFU',
field=models.FloatField(verbose_name='大腸桿菌群', null=True),
),
migrations.AlterField(
model_name='oceaninspectmodel',
name='inspectCMS',
field=models.FloatField(verbose_name='水流量', null=True),
),
migrations.AlterField(
model_name='oceaninspectmodel',
name='inspectCOD',
field=models.FloatField(verbose_name='化學需氧量', null=True),
),
migrations.AlterField(
model_name='oceaninspectmodel',
name='inspectCd',
field=models.FloatField(verbose_name='鎘', null=True),
),
migrations.AlterField(
model_name='oceaninspectmodel',
name='inspectComment',
field=models.TextField(verbose_name='備註', max_length=100, null=True),
),
migrations.AlterField(
model_name='oceaninspectmodel',
name='inspectCr',
field=models.FloatField(verbose_name='鉻', null=True),
),
migrations.AlterField(
model_name='oceaninspectmodel',
name='inspectCu',
field=models.FloatField(verbose_name='銅', null=True),
),
migrations.AlterField(
model_name='oceaninspectmodel',
name='inspectDate',
field=models.DateField(verbose_name='採樣日期', null=True),
),
migrations.AlterField(
model_name='oceaninspectmodel',
name='inspectEle',
field=models.IntegerField(verbose_name='導電度', null=True, default=0),
),
migrations.AlterField(
model_name='oceaninspectmodel',
name='inspectMPN',
field=models.FloatField(verbose_name='腸球菌', null=True),
),
migrations.AlterField(
model_name='oceaninspectmodel',
name='inspectMn',
field=models.FloatField(verbose_name='錳', null=True),
),
migrations.AlterField(
model_name='oceaninspectmodel',
name='inspectN2',
field=models.FloatField(verbose_name='氨氣', null=True),
),
migrations.AlterField(
model_name='oceaninspectmodel',
name='inspectNO2N',
field=models.FloatField(verbose_name='亞硝酸鹽氮', null=True),
),
migrations.AlterField(
model_name='oceaninspectmodel',
name='inspectNO3N',
field=models.FloatField(verbose_name='硝酸鹽氮', null=True),
),
migrations.AlterField(
model_name='oceaninspectmodel',
name='inspectNTU',
field=models.FloatField(verbose_name='濁度', null=True),
),
migrations.AlterField(
model_name='oceaninspectmodel',
name='inspectNi',
field=models.FloatField(verbose_name='鎳', null=True),
),
migrations.AlterField(
model_name='oceaninspectmodel',
name='inspectO2',
field=models.FloatField(verbose_name='溶氧量', null=True),
),
migrations.AlterField(
model_name='oceaninspectmodel',
name='inspectPH',
field=models.FloatField(verbose_name='PH值', null=True),
),
migrations.AlterField(
model_name='oceaninspectmodel',
name='inspectPO34',
field=models.FloatField(verbose_name='磷酸鹽', null=True),
),
migrations.AlterField(
model_name='oceaninspectmodel',
name='inspectPSU',
field=models.FloatField(verbose_name='鹽度', null=True),
),
migrations.AlterField(
model_name='oceaninspectmodel',
name='inspectPb',
field=models.FloatField(verbose_name='鉛', null=True),
),
migrations.AlterField(
model_name='oceaninspectmodel',
name='inspectSS',
field=models.FloatField(verbose_name='懸浮固體', null=True),
),
migrations.AlterField(
model_name='oceaninspectmodel',
name='inspectSixOy',
field=models.FloatField(verbose_name='矽酸鹽', null=True),
),
migrations.AlterField(
model_name='oceaninspectmodel',
name='inspectTN',
field=models.FloatField(verbose_name='總氮', null=True),
),
migrations.AlterField(
model_name='oceaninspectmodel',
name='inspectTP',
field=models.FloatField(verbose_name='總磷', null=True),
),
migrations.AlterField(
model_name='oceaninspectmodel',
name='inspectTime',
field=models.TimeField(verbose_name='採樣時間', null=True),
),
migrations.AlterField(
model_name='oceaninspectmodel',
name='inspectWaterTemp',
field=models.FloatField(verbose_name='水溫', null=True),
),
migrations.AlterField(
model_name='oceaninspectmodel',
name='inspectZn',
field=models.FloatField(verbose_name='鋅', null=True),
),
migrations.AlterField(
model_name='oceaninspectmodel',
name='riverName',
field=models.CharField(verbose_name='河川名稱', max_length=10, null=True),
),
migrations.AlterField(
model_name='oceaninspectmodel',
name='riverStandard',
field=models.CharField(verbose_name='水體分類等級', max_length=10, null=True),
),
migrations.AlterField(
model_name='oceaninspectmodel',
name='riverstationNumber',
field=models.IntegerField(verbose_name='監測站編號', null=True, default=0),
),
migrations.AlterField(
model_name='oceaninspectmodel',
name='stationName',
field=models.CharField(verbose_name='監測站名稱', max_length=10, null=True),
),
]
class Migration(migrations.Migration):
dependencies = [
('products', '0009_auto_20201003_1151'),
]
operations = [
migrations.RemoveField(
model_name='desktop',
name='memory_size',
),
migrations.RemoveField(
model_name='desktop',
name='storage_size',
),
migrations.RemoveField(
model_name='monitor',
name='resolution',
),
migrations.RemoveField(
model_name='monitor',
name='screen_size',
),
migrations.RemoveField(
model_name='producted',
name='name',
),
migrations.RemoveField(
model_name='producted',
name='stock',
),
migrations.AddField(
model_name='desktop',
name='country',
field=models.CharField(default='другие',
max_length=255,
verbose_name='Страна производитель'),
),
migrations.AddField(
model_name='desktop',
name='nicotine',
field=models.DecimalField(decimal_places=2,
max_digits=9,
null=True,
verbose_name='Содержание никотина'),
),
migrations.AddField(
model_name='desktop',
name='salt',
field=models.CharField(choices=[('NO', 'Нет'), ('YES', 'Да')],
max_length=255,
null=True,
verbose_name='SALT'),
),
migrations.AddField(
model_name='desktop',
name='taste',
field=models.CharField(default='другие',
max_length=255,
verbose_name='Вкус'),
),
migrations.AddField(
model_name='desktop',
name='vg_to_pg',
field=models.CharField(max_length=255,
null=True,
verbose_name='ВГ на ПГ'),
),
migrations.AddField(
model_name='desktop',
name='volume',
field=models.DecimalField(decimal_places=2,
max_digits=9,
null=True,
verbose_name='Объем'),
),
migrations.AddField(
model_name='monitor',
name='type_category',
field=models.CharField(
choices=[('CRT', 'Картриджи'), ('IS', 'Испарители'),
('MND', 'Мундштуки'), ('NMK', 'Намотки'),
('VTA', 'Вата')],
max_length=255,
null=True,
verbose_name='Подтверди название категории'),
),
migrations.AddField(
model_name='producted',
name='add_date',
field=models.DateField(default=django.utils.timezone.now,
verbose_name='Дата добавления'),
),
migrations.AddField(
model_name='producted',
name='add_time',
field=models.TimeField(default=datetime.datetime(
2020, 10, 3, 12, 5, 16, 786341),
verbose_name='Время добавления'),
),
migrations.AddField(
model_name='producted',
name='brand',
field=models.CharField(default='другие',
max_length=255,
verbose_name='Бренд'),
),
migrations.AddField(
model_name='producted',
name='category',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='products.category',
verbose_name='Категория'),
),
migrations.AddField(
model_name='producted',
name='description',
field=models.TextField(null=True, verbose_name='Описание'),
),
migrations.AddField(
model_name='producted',
name='image',
field=models.ImageField(default=90,
upload_to='images',
verbose_name='Изображение'),
preserve_default=False,
),
migrations.AddField(
model_name='producted',
name='new',
field=models.BooleanField(
default=False, verbose_name='Добавить в категорию новые?'),
),
migrations.AddField(
model_name='producted',
name='sale',
field=models.DecimalField(decimal_places=2,
max_digits=10,
null=True,
verbose_name='Скидка'),
),
migrations.AddField(
model_name='producted',
name='slug',
field=django_extensions.db.fields.AutoSlugField(
blank=True, editable=False, populate_from='title',
unique=True),
),
migrations.AddField(
model_name='producted',
name='title',
field=models.CharField(default=1,
max_length=255,
verbose_name='Наименование'),
preserve_default=False,
),
migrations.AlterField(
model_name='accessory',
name='add_time',
field=models.TimeField(default=datetime.datetime(
2020, 10, 3, 12, 5, 16, 782351),
verbose_name='Время добавления'),
),
migrations.AlterField(
model_name='accessory',
name='type_category',
field=models.CharField(
choices=[('CRT', 'Картриджи'), ('IS', 'Испарители'),
('MND', 'Мундштуки'), ('NMK', 'Намотки'),
('VTA', 'Вата')],
max_length=255,
null=True,
verbose_name='Подтверди название категории'),
),
migrations.AlterField(
model_name='crate',
name='add_time',
field=models.TimeField(default=datetime.datetime(
2020, 10, 3, 12, 5, 16, 782351),
verbose_name='Время добавления'),
),
migrations.AlterField(
model_name='liquid',
name='add_time',
field=models.TimeField(default=datetime.datetime(
2020, 10, 3, 12, 5, 16, 782351),
verbose_name='Время добавления'),
),
migrations.AlterField(
model_name='order',
name='event_time',
field=models.TimeField(default=datetime.datetime(
2020, 10, 3, 12, 5, 16, 785347),
verbose_name='Время добавления'),
),
migrations.AlterField(
model_name='producted',
name='id',
field=models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
unique=True),
),
migrations.AlterField(
model_name='producted',
name='price',
field=models.DecimalField(decimal_places=2,
max_digits=9,
verbose_name='Цена'),
),
migrations.AlterField(
model_name='slider',
name='add_time',
field=models.TimeField(default=datetime.datetime(
2020, 10, 3, 12, 5, 16, 785347),
verbose_name='Время добавления'),
),
migrations.AlterField(
model_name='slider',
name='table',
field=models.CharField(choices=[('Liquid', 'Liquid'),
('Accessory', 'Accessory')],
max_length=255,
null=True,
verbose_name='Категория'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='DumpTruck',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('date_added',
models.DateTimeField(auto_now_add=True, null=True)),
('nama', models.CharField(max_length=140)),
('merk', models.CharField(max_length=140)),
('unit_model', models.CharField(max_length=140)),
],
),
migrations.CreateModel(
name='Excavator',
fields=[
('date_added',
models.DateTimeField(auto_now_add=True, null=True)),
('unit_id', models.AutoField(primary_key=True,
serialize=False)),
('nama', models.CharField(max_length=140)),
('merk', models.CharField(max_length=140)),
('unit_model', models.CharField(max_length=140)),
],
),
migrations.CreateModel(
name='Lokasi',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('date_added',
models.DateTimeField(auto_now_add=True, null=True)),
('lokasi', models.CharField(max_length=140)),
('sublokasi', models.TextField(max_length=140)),
],
),
migrations.CreateModel(
name='Material',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('material_inti',
models.CharField(choices=[('COAL', 'COAL'), ('OB', 'OB')],
default='COAL',
max_length=140)),
('submaterial', models.CharField(blank=True, max_length=140)),
],
),
migrations.CreateModel(
name='Muatan',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('date_added', models.DateTimeField(auto_now_add=True)),
('shift', models.CharField(max_length=50)),
('shift_start_time', models.TimeField()),
('shift_end_time', models.TimeField()),
('ritasi', models.PositiveIntegerField()),
('bcm', models.PositiveIntegerField()),
('reported_problem', models.TextField(blank=True)),
],
),
migrations.CreateModel(
name='Worker',
fields=[
('date_added', models.DateTimeField(auto_now_add=True)),
('employee_id',
models.AutoField(primary_key=True, serialize=False)),
('name', models.CharField(max_length=140)),
('tipe_pekerja',
models.CharField(choices=[('OPERATOR', 'operator'),
('DRIVER', 'driver')],
default='DRIVER',
max_length=140)),
],
),
migrations.AddField(
model_name='muatan',
name='driver_dumptruck',
field=models.ForeignKey(
on_delete=django.db.models.deletion.DO_NOTHING,
related_name='muatan_driver_dumptruck',
to='core.Worker'),
),
migrations.AddField(
model_name='muatan',
name='dumpTruck',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.DO_NOTHING,
to='core.DumpTruck'),
),
migrations.AddField(
model_name='muatan',
name='excavator',
field=models.ForeignKey(
on_delete=django.db.models.deletion.DO_NOTHING,
to='core.Excavator'),
),
migrations.AddField(
model_name='muatan',
name='lokasi',
field=models.ForeignKey(
on_delete=django.db.models.deletion.DO_NOTHING,
to='core.Lokasi'),
),
migrations.AddField(
model_name='muatan',
name='material',
field=models.ForeignKey(
on_delete=django.db.models.deletion.DO_NOTHING,
to='core.Material'),
),
migrations.AddField(
model_name='muatan',
name='operator_excavator',
field=models.ForeignKey(
on_delete=django.db.models.deletion.DO_NOTHING,
related_name='muatan_operator_excavator',
to='core.Worker'),
),
migrations.AddField(
model_name='dumptruck',
name='exacavator_id',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='core.Excavator'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Meeting',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('MeetingTittle', models.CharField(max_length=255)),
('MeetingDate', models.DateField()),
('MeetingTime', models.TimeField()),
('Location', models.CharField(max_length=255)),
('Agenda', models.TextField()),
],
options={
'verbose_name_plural': 'meetings',
'db_table': 'meeting',
},
),
migrations.CreateModel(
name='Resource',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('ResourceName', models.CharField(max_length=255)),
('ResourceType', models.CharField(max_length=255)),
('URL', models.URLField()),
('DateEntered', models.DateField()),
('Description', models.TextField()),
('UserID', models.ForeignKey(on_delete=django.db.models.deletion.DO_NOTHING, to=settings.AUTH_USER_MODEL)),
],
options={
'db_table': 'resources',
},
),
migrations.CreateModel(
name='Meeting_Minutes',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('Minutes', models.TextField()),
('Attendance', models.ManyToManyField(to=settings.AUTH_USER_MODEL)),
('MeetingID', models.ForeignKey(on_delete=django.db.models.deletion.DO_NOTHING, to='Clubapp.meeting')),
],
options={
'verbose_name_plural': '',
'db_table': 'meeting minutes',
},
),
migrations.CreateModel(
name='Event',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('EventTitle', models.CharField(max_length=255)),
('location', models.CharField(max_length=255)),
('Date', models.DateField()),
('Time', models.TimeField()),
('Description', models.TextField()),
('UserID', models.ForeignKey(on_delete=django.db.models.deletion.DO_NOTHING, to=settings.AUTH_USER_MODEL)),
],
options={
'db_table': 'event',
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
]
operations = [
migrations.CreateModel(
name='Attendence',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('date', models.DateField(null=True)),
('morningattendence', models.CharField(max_length=200, null=True)),
('nightattendence', models.CharField(max_length=200, null=True)),
('guestname', models.CharField(max_length=200, null=True)),
('guestmno', models.IntegerField(null=True)),
('guestintime', models.TimeField(null=True)),
('guestouttime', models.TimeField(null=True)),
('schoolouttime', models.TimeField(null=True)),
('schoolintime', models.TimeField(null=True)),
('personalvisit', models.CharField(max_length=200, null=True)),
('pvouttime', models.TimeField(null=True)),
('pvintime', models.TimeField(null=True)),
],
),
migrations.CreateModel(
name='Branches',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('branchname', models.CharField(max_length=200)),
('ownername', models.CharField(max_length=200)),
('branchid', models.CharField(max_length=200)),
('password', models.CharField(max_length=200)),
('address', models.CharField(max_length=200)),
('village', models.CharField(max_length=200)),
('city', models.CharField(max_length=200)),
('state', models.CharField(max_length=200)),
('phoneno', models.IntegerField()),
],
),
migrations.CreateModel(
name='Children',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('childid', models.IntegerField()),
('childname', models.CharField(max_length=200)),
('childdob', models.DateField()),
('gender', models.CharField(max_length=200)),
('photo', models.ImageField(null=True, upload_to='')),
('branch', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='govnportal.Branches')),
],
),
migrations.CreateModel(
name='DCPUlogin',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('userid', models.CharField(max_length=200)),
('password', models.CharField(max_length=200)),
],
),
migrations.CreateModel(
name='Donations',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('donationid', models.IntegerField(null=True)),
('donorname', models.CharField(max_length=200)),
('phoneno', models.CharField(max_length=200)),
('address', models.CharField(max_length=500)),
('informof', models.CharField(max_length=100)),
('amount', models.IntegerField(null=True)),
('foodtime', models.CharField(max_length=100, null=True)),
('date', models.DateField(null=True)),
('receipt', models.FileField(upload_to='')),
('branch', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='govnportal.Branches')),
],
),
migrations.CreateModel(
name='Funds',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('fundid', models.IntegerField()),
('fundfor', models.CharField(max_length=200)),
('fundraisedby', models.CharField(max_length=200)),
('amount', models.IntegerField()),
('paymentmode', models.CharField(max_length=200)),
('paymentimage', models.ImageField(upload_to='')),
('date', models.DateField(null=True)),
('balance', models.IntegerField(null=True)),
('completestatus', models.CharField(max_length=200, null=True)),
('branch', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='govnportal.Branches')),
],
),
migrations.CreateModel(
name='Fundusagebills',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('bill', models.ImageField(upload_to='')),
('fund', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='govnportal.Funds')),
],
),
migrations.CreateModel(
name='Organization',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('orgname', models.CharField(max_length=200)),
('ownername', models.CharField(max_length=200)),
('orgid', models.CharField(max_length=200)),
('password', models.CharField(max_length=200)),
('address', models.CharField(max_length=200)),
('village', models.CharField(max_length=200)),
('city', models.CharField(max_length=200)),
('state', models.CharField(max_length=200)),
('phoneno', models.IntegerField()),
],
),
migrations.CreateModel(
name='Problem',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('problemname', models.CharField(max_length=200)),
('problemdes', models.CharField(max_length=10000)),
('problemid', models.IntegerField()),
('photo', models.ImageField(null=True, upload_to='')),
('date', models.DateField()),
('orgacceptance', models.CharField(max_length=100)),
('solved', models.CharField(max_length=100)),
('branch', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='govnportal.Branches')),
('organization', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='govnportal.Organization')),
],
),
migrations.CreateModel(
name='Problemsolution',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('problemsolution', models.CharField(max_length=1000)),
('branch', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='govnportal.Branches')),
('fund', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='govnportal.Funds')),
('organization', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='govnportal.Organization')),
('problem', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='govnportal.Problem')),
],
),
migrations.AddField(
model_name='funds',
name='organization',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='govnportal.Organization'),
),
migrations.AddField(
model_name='funds',
name='problem',
field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='govnportal.Problem'),
),
migrations.AddField(
model_name='donations',
name='organization',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='govnportal.Organization'),
),
migrations.AddField(
model_name='branches',
name='organization',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='govnportal.Organization'),
),
migrations.AddField(
model_name='attendence',
name='branch',
field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='govnportal.Branches'),
),
migrations.AddField(
model_name='attendence',
name='child',
field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='govnportal.Children'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='CourseInfo',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('cNum', models.CharField(max_length=15)),
('cNo', models.CharField(max_length=4)),
('cName', models.CharField(max_length=30)),
('cMajor', models.CharField(max_length=50)),
('cClassWeek', models.CharField(max_length=25)),
('cClassDay', models.IntegerField()),
('cClassSessions', models.IntegerField()),
('cContinuingSession', models.IntegerField()),
('cBegTime', models.TimeField(blank=True)),
('cEndTime', models.TimeField(blank=True)),
],
options={
'db_table': 'course',
},
),
migrations.CreateModel(
name='FaceInfo',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('feature', models.TextField(max_length=1050)),
],
options={
'db_table': 'faceInfo',
},
),
migrations.CreateModel(
name='SignInfo',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('sSignTime', models.DateTimeField(auto_now=True, null=True)),
('sIsSign', models.BooleanField(default=False)),
('sSignDay', models.IntegerField(default=1)),
('sSignWeek', models.IntegerField(default=10)),
('sSignBegTime',
models.TimeField(default=datetime.time(8, 30))),
('sSignEndTime',
models.TimeField(default=datetime.time(14, 30))),
('sCouse',
models.ForeignKey(blank=True,
on_delete=django.db.models.deletion.CASCADE,
to='student.CourseInfo')),
],
options={
'db_table': 'signInfo',
},
),
migrations.CreateModel(
name='StudentCourse',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('score', models.IntegerField(blank=True, null=True)),
('course',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='student.CourseInfo')),
],
options={
'db_table': 'studentcourse',
},
),
migrations.CreateModel(
name='StudentInfo',
fields=[
('sNum',
models.CharField(max_length=10,
primary_key=True,
serialize=False)),
('sName', models.CharField(max_length=30)),
('sSex', models.BooleanField()),
('sPassword', models.CharField(max_length=100)),
('sMajor', models.CharField(max_length=50)),
('sGrade', models.CharField(max_length=10)),
],
options={
'db_table': 'student',
},
),
migrations.AddField(
model_name='studentcourse',
name='student',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='student.StudentInfo'),
),
migrations.AddField(
model_name='signinfo',
name='sStudent',
field=models.ForeignKey(
blank=True,
on_delete=django.db.models.deletion.CASCADE,
to='student.StudentInfo'),
),
migrations.AddField(
model_name='faceinfo',
name='student',
field=models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to='student.StudentInfo'),
),
]
class DateTimeArrayModel(PostgreSQLModel):
datetimes = ArrayField(models.DateTimeField())
dates = ArrayField(models.DateField())
times = ArrayField(models.TimeField())
class Migration(migrations.Migration):
initial = True
dependencies = [
]
operations = [
migrations.CreateModel(
name='TicketCustomField',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('creator', models.CharField(max_length=50, verbose_name='创建人')),
('gmt_created', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
('gmt_modified', models.DateTimeField(auto_now=True, verbose_name='更新时间')),
('is_deleted', models.BooleanField(default=False, verbose_name='已删除')),
('name', models.CharField(max_length=50, verbose_name='字段名')),
('field_key', models.CharField(max_length=50, verbose_name='字段标识')),
('ticket_id', models.IntegerField(verbose_name='工单id')),
('field_type_id', models.IntegerField(help_text='见service.constant_service中定义', verbose_name='字段类型')),
('char_value', models.CharField(blank=True, default='', max_length=1000, verbose_name='字符串值')),
('int_value', models.IntegerField(blank=True, default=0, verbose_name='整形值')),
('float_value', models.FloatField(blank=True, default=0.0, verbose_name='浮点值')),
('bool_value', models.BooleanField(default=False, verbose_name='布尔值')),
('date_value', models.DateField(blank=True, default=datetime.datetime(1, 1, 1, 0, 0), verbose_name='日期值')),
('datetime_value', models.DateTimeField(blank=True, default=datetime.datetime(1, 1, 1, 0, 0), verbose_name='日期时间值')),
('time_value', models.TimeField(blank=True, default=datetime.datetime(1900, 1, 1, 0, 0, 1), verbose_name='时间值')),
('radio_value', models.CharField(blank=True, default='', max_length=50, verbose_name='radio值')),
('checkbox_value', models.CharField(blank=True, default='', help_text='逗号隔开多个选项', max_length=50, verbose_name='checkbox值')),
('select_value', models.CharField(blank=True, default='', max_length=50, verbose_name='下拉列表值')),
('multi_select_value', models.CharField(blank=True, default='', help_text='逗号隔开多个选项', max_length=50, verbose_name='多选下拉列表值')),
('text_value', models.TextField(blank=True, default='', verbose_name='文本值')),
('username_value', models.CharField(blank=True, default='', max_length=50, verbose_name='用户名')),
('multi_username_value', models.CharField(blank=True, default='', max_length=1000, verbose_name='多选用户名')),
],
options={
'verbose_name': '工单自定义字段',
'verbose_name_plural': '工单自定义字段',
},
),
migrations.CreateModel(
name='TicketFlowLog',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('creator', models.CharField(max_length=50, verbose_name='创建人')),
('gmt_created', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
('gmt_modified', models.DateTimeField(auto_now=True, verbose_name='更新时间')),
('is_deleted', models.BooleanField(default=False, verbose_name='已删除')),
('ticket_id', models.IntegerField(verbose_name='工单id')),
('transition_id', models.IntegerField(help_text='与worklow.Transition关联， 为0时表示认为干预的操作', verbose_name='流转id')),
('suggestion', models.CharField(blank=True, default='', max_length=1000, verbose_name='处理意见')),
('participant_type_id', models.IntegerField(help_text='见service.constant_service中定义', verbose_name='处理人类型')),
('participant', models.CharField(blank=True, default='', max_length=50, verbose_name='处理人')),
('state_id', models.IntegerField(blank=True, default=0, verbose_name='当前状态id')),
('intervene_type_id', models.IntegerField(default=0, help_text='0.非人为干预的流转，1.转交操作 2.加签操作 3.加签处理完成', verbose_name='干预类型')),
('ticket_data', models.CharField(blank=True, default='', help_text='可以用于记录当前表单数据，json格式', max_length=10000, verbose_name='工单数据')),
],
options={
'verbose_name': '工单流转日志',
'verbose_name_plural': '工单流转日志',
},
),
migrations.CreateModel(
name='TicketRecord',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('creator', models.CharField(max_length=50, verbose_name='创建人')),
('gmt_created', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
('gmt_modified', models.DateTimeField(auto_now=True, verbose_name='更新时间')),
('is_deleted', models.BooleanField(default=False, verbose_name='已删除')),
('title', models.CharField(blank=True, default='', help_text='工单的标题', max_length=500, verbose_name='标题')),
('workflow_id', models.IntegerField(help_text='与workflow.Workflow流程关联', verbose_name='关联的流程id')),
('sn', models.CharField(help_text='工单的流水号', max_length=25, verbose_name='流水号')),
('state_id', models.IntegerField(help_text='与workflow.State关联', verbose_name='当前状态')),
('parent_ticket_id', models.IntegerField(default=0, help_text='与ticket.TicketRecord关联', verbose_name='父工单id')),
('parent_ticket_state_id', models.IntegerField(default=0, help_text='与workflow.State关联,子工单是关联到父工单的某个状态下的', verbose_name='对应父工单状态id')),
('participant_type_id', models.IntegerField(default=0, help_text='0.无处理人,1.个人,2.多人,3.部门,4.角色', verbose_name='当前处理人类型')),
('participant', models.CharField(blank=True, default='', help_text='可以为空(无处理人的情况，如结束状态)、username\\多个username(以,隔开)\\部门id\\角色id\\脚本文件名等', max_length=100, verbose_name='当前处理人')),
('relation', models.CharField(blank=True, default='', help_text='工单流转过程中将保存所有相关的人(包括创建人、曾经的待处理人)，用于查询', max_length=1000, verbose_name='工单关联人')),
('in_add_node', models.BooleanField(default=False, help_text='是否处于加签状态下', verbose_name='加签状态中')),
('add_node_man', models.CharField(blank=True, default='', help_text='加签操作的人，工单当前处理人处理完成后会回到该处理人，当处于加签状态下才有效', max_length=50, verbose_name='加签人')),
('script_run_last_result', models.BooleanField(default=True, verbose_name='脚本最后一次执行结果')),
('is_end', models.BooleanField(default=False, help_text='工单是否已处于结束状态', verbose_name='已结束')),
('is_rejected', models.BooleanField(default=False, help_text='工单是否处于被拒绝状态', verbose_name='被拒绝')),
('multi_all_person', models.CharField(blank=True, default='{}', help_text='需要当前状态处理人全部处理时实际的处理结果，json格式', max_length=1000, verbose_name='全部处理的结果')),
],
options={
'verbose_name': '工单记录',
'verbose_name_plural': '工单记录',
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Event',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('eventtitle', models.CharField(max_length=255)),
('eventdate', models.DateField()),
('eventtime', models.TimeField()),
('eventlocation', models.CharField(max_length=255)),
('eventdescription', models.TextField()),
('user',
models.ForeignKey(
on_delete=django.db.models.deletion.DO_NOTHING,
to=settings.AUTH_USER_MODEL)),
],
options={
'db_table': 'event',
},
),
migrations.CreateModel(
name='Meeting',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('meetingtitle', models.CharField(max_length=255)),
('meetingdate', models.DateField()),
('meetingtime', models.TimeField()),
('meetinglocation', models.CharField(max_length=255)),
('meetingagenda', models.TextField()),
],
options={
'db_table': 'meeting',
},
),
migrations.CreateModel(
name='MeetingMinutes',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('minutestime', models.SmallIntegerField()),
('meeting',
models.ForeignKey(
on_delete=django.db.models.deletion.DO_NOTHING,
to='club.Meeting')),
('minutesattendance',
models.ManyToManyField(to=settings.AUTH_USER_MODEL)),
],
options={
'db_table': 'minutes',
},
),
migrations.CreateModel(
name='Resource',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('resourcename', models.CharField(max_length=255)),
('resourcetype', models.CharField(max_length=255)),
('resourceurl', models.URLField(blank=True, null=True)),
('resourcedateentered', models.DateField()),
('resourcedescription', models.TextField()),
('user',
models.ForeignKey(
on_delete=django.db.models.deletion.DO_NOTHING,
to=settings.AUTH_USER_MODEL)),
],
options={
'db_table': 'resource',
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
]
operations = [
migrations.CreateModel(
name='Amenity',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('created', models.DateTimeField(auto_now_add=True)),
('updated', models.DateTimeField(auto_now=True)),
('name', models.CharField(max_length=80)),
],
options={
'verbose_name_plural': 'Amenities',
},
),
migrations.CreateModel(
name='Facility',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('created', models.DateTimeField(auto_now_add=True)),
('updated', models.DateTimeField(auto_now=True)),
('name', models.CharField(max_length=80)),
],
options={
'verbose_name_plural': 'Facilities',
},
),
migrations.CreateModel(
name='HouseRule',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('created', models.DateTimeField(auto_now_add=True)),
('updated', models.DateTimeField(auto_now=True)),
('name', models.CharField(max_length=80)),
],
options={
'verbose_name': 'House Rule',
},
),
migrations.CreateModel(
name='Photo',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('created', models.DateTimeField(auto_now_add=True)),
('updated', models.DateTimeField(auto_now=True)),
('caption', models.CharField(max_length=80)),
('file', models.ImageField(upload_to='room_photos')),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='RoomType',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('created', models.DateTimeField(auto_now_add=True)),
('updated', models.DateTimeField(auto_now=True)),
('name', models.CharField(max_length=80)),
],
options={
'verbose_name': 'Room Tpye',
},
),
migrations.CreateModel(
name='Room',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('created', models.DateTimeField(auto_now_add=True)),
('updated', models.DateTimeField(auto_now=True)),
('name', models.CharField(max_length=140)),
('description', models.TextField()),
('country', django_countries.fields.CountryField(max_length=2)),
('city', models.CharField(max_length=80)),
('price', models.IntegerField()),
('address', models.CharField(max_length=140)),
('guests', models.IntegerField()),
('beds', models.IntegerField()),
('bedrooms', models.IntegerField()),
('baths', models.IntegerField()),
('check_in', models.TimeField()),
('check_out', models.TimeField()),
('instant_book', models.BooleanField(default=False)),
('amenities', models.ManyToManyField(blank=True, related_name='rooms', to='rooms.Amenity')),
('facility', models.ManyToManyField(blank=True, related_name='rooms', to='rooms.Facility')),
],
options={
'abstract': False,
},
),
]
class DjangoStatement(models.Model):
"""
Базовая абстрактная Django-модель для сохранения выписки из формата 1CClientBankExchange
"""
class Meta:
abstract = True
format_version = models.TextField(null=True, blank=True)
encoding = models.TextField(null=True, blank=True)
sender = models.TextField(null=True, blank=True)
receiver = models.TextField(null=True, blank=True)
creation_date = models.DateField(null=True, blank=True)
creation_time = models.TimeField(null=True, blank=True)
filter_date_since = models.DateField(null=True, blank=True)
filter_date_till = models.DateField(null=True, blank=True)
balance_date_since = models.DateField(null=True, blank=True)
balance_date_till = models.DateField(null=True, blank=True)
balance_account_number = models.CharField(max_length=20, null=True, blank=True)
balance_initial_balance = models.DecimalField(max_digits=15, decimal_places=2, null=True, blank=True)
balance_total_income = models.DecimalField(max_digits=15, decimal_places=2, null=True, blank=True)
balance_total_expense = models.DecimalField(max_digits=15, decimal_places=2, null=True, blank=True)
balance_final_balance = models.DecimalField(max_digits=15, decimal_places=2, null=True, blank=True)
@classmethod
def from_statement(cls, statement: Statement):
return cls(
format_version=statement.header.format_version,
encoding=statement.header.encoding,
sender=statement.header.sender,
receiver=statement.header.receiver,
creation_date=statement.header.creation_date,
creation_time=statement.header.creation_time,
filter_date_since=statement.header.filter_date_since,
filter_date_till=statement.header.filter_date_till,
balance_date_since=statement.balance.date_since,
balance_date_till=statement.balance.date_till,
balance_account_number=statement.balance.account_number,
balance_initial_balance=statement.balance.initial_balance,
balance_total_income=statement.balance.total_income,
balance_total_expense=statement.balance.total_expense,
balance_final_balance=statement.balance.final_balance
)
# noinspection PyTypeChecker
def to_statement(self, documents: Optional[List[Document]]=None):
return Statement(
header=Header(
format_version=self.format_version,
encoding=self.encoding,
sender=self.sender,
receiver=self.receiver,
creation_date=self.creation_date,
creation_time=self.creation_time,
filter_date_since=self.filter_date_since,
filter_date_till=self.filter_date_till,
),
balance=Balance(
date_since=self.balance_date_since,
date_till=self.balance_date_till,
account_number=self.balance_account_number,
initial_balance=self.balance_initial_balance,
total_income=self.balance_total_income,
total_expense=self.balance_total_expense,
final_balance=self.balance_final_balance
),
documents=documents or []
)
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0011_update_proxy_permissions'),
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Asistente',
fields=[
('usuario',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
primary_key=True,
related_name='asistente',
serialize=False,
to=settings.AUTH_USER_MODEL,
verbose_name='Usuario')),
('telefono', models.CharField(max_length=8)),
],
),
migrations.CreateModel(
name='Carrera',
fields=[
('codigo',
models.PositiveIntegerField(primary_key=True,
serialize=False,
unique=True)),
('nombre', models.CharField(max_length=128, unique=True)),
],
),
migrations.CreateModel(
name='Conferencista',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('nombre', models.CharField(max_length=64)),
('profesion', models.CharField(max_length=128)),
('resumen', models.CharField(default='', max_length=256)),
],
),
migrations.CreateModel(
name='Salon',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('nombre', models.CharField(max_length=64, unique=True)),
('ubicacion', models.CharField(max_length=128)),
('capacidad', models.SmallIntegerField()),
],
),
migrations.CreateModel(
name='Pago',
fields=[
('titular',
models.OneToOneField(
on_delete=django.db.models.deletion.PROTECT,
primary_key=True,
related_name='pago',
serialize=False,
to='administracion.Asistente',
verbose_name='Asistente')),
('codigo_pago',
models.CharField(max_length=32,
verbose_name='Código de recibo')),
('foto', models.TextField(verbose_name='Foto')),
('fecha_registro',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='Fecha de registro')),
('fecha', models.DateField(null=True, verbose_name='Fecha')),
('hora', models.TimeField(null=True, verbose_name='Hora')),
('estado',
models.SmallIntegerField(choices=[(1, 'Pendiente'),
(2, 'Rechazado'),
(3, 'Aceptado'),
(4, 'Reembolso solicitado'),
(5, 'Reembolso aprobado'),
(6, 'Reembolsado')],
default=1,
verbose_name='Estado')),
],
),
migrations.CreateModel(
name='Ticket',
fields=[
('asistente',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
primary_key=True,
related_name='ticket',
serialize=False,
to='administracion.Asistente',
verbose_name='Usuario')),
('codigo_qr', models.TextField()),
('estado',
models.PositiveSmallIntegerField(choices=[(1, 'VALIDO'),
(2, 'INVALIDADO')],
default=1,
verbose_name='Estados')),
],
),
migrations.CreateModel(
name='Cuenta',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('numero',
models.CharField(max_length=32,
verbose_name='Número de cuenta')),
('banco', models.CharField(max_length=64,
verbose_name='Banco')),
('titular',
models.CharField(max_length=128, verbose_name='Titular')),
],
options={
'unique_together': {('numero', 'banco')},
},
),
migrations.CreateModel(
name='Conferencia',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('tema', models.CharField(max_length=128, unique=True)),
('inicio', models.TimeField(verbose_name='Hora de inicio')),
('fin', models.TimeField(verbose_name='Hora de finalización')),
('foto',
models.ImageField(default='none', upload_to='conferencias')),
('conferencista',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
related_name='conferencias',
to='administracion.Conferencista')),
('salon',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='conferencias',
to='administracion.Salon')),
],
),
migrations.CreateModel(
name='ValidacionPago',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('mensaje',
models.CharField(max_length=256,
null=True,
verbose_name='Mensaje')),
('resultado',
models.PositiveSmallIntegerField(choices=[(1, 'Rechazado'),
(2, 'Aceptado')],
default=2,
verbose_name='Resultado')),
('fecha_hora',
models.DateTimeField(
default=datetime.datetime.utcnow,
verbose_name='Fecha y hora de validación')),
('usuario',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
related_name='validaciones_pagos',
to=settings.AUTH_USER_MODEL,
verbose_name='Usuario que validó')),
('pago',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
related_name='validaciones',
to='administracion.Pago',
verbose_name='Pago')),
],
),
migrations.CreateModel(
name='Reservacion',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('fecha',
models.DateTimeField(verbose_name='Fecha de reservación')),
('estado',
models.SmallIntegerField(choices=[
(1, 'Confirmada'), (2, 'Pago pendiente de validar')
],
default=1,
verbose_name='Estado')),
('asistente',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='reservaciones',
to='administracion.Asistente',
verbose_name='Asistente')),
('conferencia',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='reservaciones',
to='administracion.Conferencia',
verbose_name='Conferencia')),
],
options={
'unique_together': {('conferencia', 'asistente')},
},
),
migrations.AddField(
model_name='pago',
name='cuenta',
field=models.ForeignKey(
on_delete=django.db.models.deletion.PROTECT,
related_name='pagos',
to='administracion.Cuenta',
verbose_name='Cuenta'),
),
migrations.CreateModel(
name='EvaluacionReembolso',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('mensaje',
models.CharField(max_length=256,
null=True,
verbose_name='Mensaje')),
('resultado',
models.PositiveSmallIntegerField(choices=[(1, 'Rechazado'),
(2, 'Aceptado'),
(3, 'Reembolsado')],
default=2,
verbose_name='Resultado')),
('fecha_hora',
models.DateTimeField(
default=datetime.datetime.utcnow,
verbose_name='Fecha y hora de evaluación')),
('usuario',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
related_name='evaluaciones_reembolsos',
to=settings.AUTH_USER_MODEL,
verbose_name='Usuario que evaluó')),
('pago',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
related_name='evaluaciones_reembolso',
to='administracion.Pago',
verbose_name='Pago')),
],
),
migrations.CreateModel(
name='EstudianteUmg',
fields=[
('asistente',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
primary_key=True,
related_name='estudianteUmg',
serialize=False,
to='administracion.Asistente',
verbose_name='Asistente')),
('carnet', models.CharField(max_length=32, unique=True)),
('semestre',
models.PositiveSmallIntegerField(verbose_name='Semestre')),
('carrera',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
related_name='estudiantes',
to='administracion.Carrera',
verbose_name='Carrera')),
],
),
migrations.AlterUniqueTogether(
name='pago',
unique_together={('cuenta', 'codigo_pago')},
),
migrations.CreateModel(
name='Asistencia',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('hora', models.TimeField(verbose_name='Hora de asistencia')),
('conferencia',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
related_name='asistencias',
to='administracion.Conferencia',
verbose_name='Conferencia')),
('ticket',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
related_name='asistencias',
to='administracion.Ticket',
verbose_name='Ticket')),
],
options={
'unique_together': {('conferencia', 'ticket')},
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('accounts', '0001_initial'),
]
operations = [
migrations.CreateModel(
name='Permit',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('contractor', models.CharField(default='', max_length=100)),
('contractor_name', models.CharField(default='',
max_length=100)),
('facility', models.CharField(default='', max_length=100)),
('date_of_arrival',
models.DateField(default=django.utils.timezone.now)),
('time_of_arrival',
models.TimeField(default=django.utils.timezone.now)),
('date_of_finish',
models.DateField(default=django.utils.timezone.now)),
('time_of_finish',
models.TimeField(default=django.utils.timezone.now)),
('job_location', models.CharField(default='', max_length=100)),
('job_spec', models.TextField(default='', max_length=500)),
('equipment', models.TextField(default='', max_length=100)),
('status_closed', models.BooleanField(default=False)),
('works_completed', models.BooleanField(default=False)),
('profile',
models.ForeignKey(null=True,
on_delete=django.db.models.deletion.CASCADE,
to='accounts.Profile')),
],
),
migrations.CreateModel(
name='ElectricalWorks',
fields=[
('permit_ptr',
models.OneToOneField(
auto_created=True,
on_delete=django.db.models.deletion.CASCADE,
parent_link=True,
primary_key=True,
serialize=False,
to='permits.Permit')),
('location1', models.CharField(default='', max_length=100)),
('location2', models.CharField(default='', max_length=100)),
('location3', models.CharField(default='', max_length=100)),
],
options={
'verbose_name': 'Electrical Works Permit',
'verbose_name_plural': 'Electrical Works Permits',
'ordering': ('date_of_arrival', ),
},
bases=('permits.permit', ),
),
migrations.CreateModel(
name='General',
fields=[
('permit_ptr',
models.OneToOneField(
auto_created=True,
on_delete=django.db.models.deletion.CASCADE,
parent_link=True,
primary_key=True,
serialize=False,
to='permits.Permit')),
('safety_precautions',
models.TextField(default='', max_length=200)),
('ra_ready', models.BooleanField(default=False)),
('ms_ready', models.BooleanField(default=False)),
('confined_space_entry', models.BooleanField(default=False)),
],
options={
'verbose_name': 'General Permit',
'verbose_name_plural': 'General Permits',
'ordering': ('date_of_arrival', ),
},
bases=('permits.permit', ),
),
migrations.CreateModel(
name='HotWorks',
fields=[
('permit_ptr',
models.OneToOneField(
auto_created=True,
on_delete=django.db.models.deletion.CASCADE,
parent_link=True,
primary_key=True,
serialize=False,
to='permits.Permit')),
('ppe', models.BooleanField(default=False)),
('welding_screen', models.BooleanField(default=False)),
('smoke_heat_isolated', models.BooleanField(default=False)),
],
options={
'verbose_name': 'Hot Works Permit',
'verbose_name_plural': 'Hot Works Permits',
'ordering': ('date_of_arrival', ),
},
bases=('permits.permit', ),
),
]
class Event(models.Model):
competition = models.ForeignKey(Competition,
on_delete=models.CASCADE,
blank=True,
null=True)
typeOfEvent = models.CharField(choices=(('match', 'match'), ('training',
'training')),
max_length=8,
default='training',
verbose_name='Type of event')
date = models.DateField(verbose_name='Date of event')
startTime = models.TimeField(verbose_name='Time of start')
status = models.CharField(choices=(('planned', 'planned'), ('cancelled',
'cancelled'),
('live', 'live'), ('postponed',
'postponed'),
('is over', 'is over')),
max_length=9)
teamA = models.ForeignKey(Team,
on_delete=models.CASCADE,
related_name='events',
verbose_name="Team A")
teamB = models.ForeignKey(Team,
on_delete=models.CASCADE,
null=True,
blank=True,
verbose_name="Team B")
field = models.ForeignKey(Field, on_delete=models.CASCADE)
class Meta:
ordering = ('date', )
unique_together = ('date', 'startTime', 'teamA', 'teamB')
@property
def stat(self):
# This property returns statistics for an event
team_a_goals = self.goals.filter(scoringTeam=self.teamA).count()
team_b_goals = self.goals.filter(scoringTeam=self.teamB).count()
team_a_cards_yellow = self.cards.filter(receivedTeam=self.teamA,
color='yellow').count()
team_b_cards_yellow = self.cards.filter(receivedTeam=self.teamB,
color='yellow').count()
team_a_cards_red = self.cards.filter(receivedTeam=self.teamA,
color='red').count()
team_b_cards_red = self.cards.filter(receivedTeam=self.teamA,
color='red').count()
team_a_substitutions = self.substitutions.filter(
inTeam=self.teamA).count()
team_b_substitutions = self.substitutions.filter(
inTeam=self.teamB).count()
if self.teamB:
b_id = self.teamB.id
if self.status != 'is over':
winner = None
looser = None
draw = False
elif team_a_goals == team_b_goals:
winner = None
looser = None
draw = True
elif team_a_goals > team_b_goals:
winner = self.teamA.id
looser = b_id
draw = False
else:
winner = b_id
looser = self.teamA.id
draw = False
else:
b_id, winner, looser, draw = None, None, None, False
return {
'stat': {
'winner': winner,
'looser': looser,
'draw': draw,
'teamA_': {
'id': self.teamA.id,
'goals': team_a_goals,
'cardsYellow': team_a_cards_yellow,
'cardsRed': team_a_cards_red,
'substitutions': team_a_substitutions
},
'teamB_': {
'id': b_id,
'goals': team_b_goals,
'cardsYellow': team_b_cards_yellow,
'cardsRed': team_b_cards_red,
'substitutions': team_b_substitutions
}
}
}
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Configuration',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('res_height', models.IntegerField()),
('res_width', models.IntegerField()),
('measure_intervall_sensors', models.IntegerField()),
('measure_intervall_cam', models.IntegerField()),
('post_intervall_sensor_data', models.IntegerField()),
('post_intervall_image_data', models.IntegerField()),
],
),
migrations.CreateModel(
name='MeasurementSession',
fields=[
('session_id',
models.BigIntegerField(primary_key=True,
serialize=False,
unique=True)),
('image_size', models.IntegerField(null=True)),
('time', models.DateTimeField(auto_now_add=True,
db_index=True)),
],
),
migrations.CreateModel(
name='Wind',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('speed',
models.DecimalField(decimal_places=2, max_digits=6,
null=True)),
('direction',
models.DecimalField(decimal_places=2, max_digits=6,
null=True)),
('measure_time', models.DateTimeField(db_index=True,
null=True)),
('measurement_session',
models.OneToOneField(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='restapi.MeasurementSession')),
],
),
migrations.CreateModel(
name='Temperature',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('degrees',
models.DecimalField(decimal_places=2, max_digits=6,
null=True)),
('measure_time', models.DateTimeField(db_index=True,
null=True)),
('measurement_session',
models.OneToOneField(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='restapi.MeasurementSession')),
],
),
migrations.CreateModel(
name='SolarCell',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('power',
models.DecimalField(decimal_places=2, max_digits=6,
null=True)),
('voltage',
models.DecimalField(decimal_places=2, max_digits=6,
null=True)),
('measure_time', models.DateTimeField(db_index=True,
null=True)),
('measurement_session',
models.OneToOneField(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='restapi.MeasurementSession')),
],
),
migrations.CreateModel(
name='Load',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('current',
models.DecimalField(decimal_places=2, max_digits=6,
null=True)),
('voltage',
models.DecimalField(decimal_places=2, max_digits=6,
null=True)),
('measure_time', models.DateTimeField(db_index=True,
null=True)),
('measurement_session',
models.OneToOneField(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='restapi.MeasurementSession')),
],
),
migrations.CreateModel(
name='Image',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('image', models.ImageField(upload_to='images/%Y/%m')),
('measure_time', models.DateTimeField(db_index=True,
null=True)),
('measurement_session',
models.OneToOneField(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='restapi.MeasurementSession')),
],
),
migrations.CreateModel(
name='Controller',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('mode', models.CharField(max_length=2, null=True)),
('measure_time', models.DateTimeField(db_index=True)),
('measurement_session',
models.OneToOneField(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='restapi.MeasurementSession')),
],
),
migrations.CreateModel(
name='Battery',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('current',
models.DecimalField(decimal_places=2, max_digits=6,
null=True)),
('voltage',
models.DecimalField(decimal_places=2, max_digits=6,
null=True)),
('temperature',
models.DecimalField(decimal_places=2, max_digits=6,
null=True)),
('measure_time', models.DateTimeField(db_index=True)),
('measurement_session',
models.OneToOneField(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='restapi.MeasurementSession')),
],
),
migrations.CreateModel(
name='ConfigSession',
fields=[
('configuration',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
primary_key=True,
serialize=False,
to='restapi.Configuration')),
('time', models.TimeField(auto_now_add=True)),
('applied', models.BooleanField()),
('user',
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to=settings.AUTH_USER_MODEL)),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
]
operations = [
migrations.CreateModel(
name='Course',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('number', models.CharField(max_length=8)),
('title', models.CharField(max_length=32)),
],
),
migrations.CreateModel(
name='Department',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=64)),
('code', models.CharField(max_length=16)),
],
),
migrations.CreateModel(
name='Institution',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=64)),
('code', models.CharField(max_length=8)),
],
),
migrations.CreateModel(
name='Professor',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=64)),
('institution', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='main.Institution')),
],
),
migrations.CreateModel(
name='ScheduleOwner',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
],
),
migrations.CreateModel(
name='Section',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('uid', models.CharField(max_length=16)),
('section_type', models.CharField(choices=[('M', 'Main'), ('A', 'Additional')], max_length=1)),
('monday', models.BooleanField(default=False)),
('tuesday', models.BooleanField(default=False)),
('wednesday', models.BooleanField(default=False)),
('thursday', models.BooleanField(default=False)),
('friday', models.BooleanField(default=False)),
('start_time', models.TimeField()),
('end_time', models.TimeField()),
('course', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='main.Course')),
('professor', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='main.Professor')),
],
),
migrations.AddField(
model_name='department',
name='institution',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='main.Institution'),
),
migrations.AddField(
model_name='course',
name='department',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='main.Department'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
]
operations = [
migrations.CreateModel(
name='Modalidade',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('descricao', models.CharField(max_length=50, unique=True, verbose_name='Descrição')),
],
options={
'verbose_name_plural': 'Modalidades',
},
),
migrations.CreateModel(
name='OfertaDeTurma',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('valor_da_mensalidade', models.DecimalField(decimal_places=2, default=0, max_digits=4, verbose_name='Valor da mensalidade')),
('modalidade', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='cadastros_basicos.Modalidade')),
],
),
migrations.CreateModel(
name='Periodicidade',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('descricao', models.CharField(max_length=30, unique=True, verbose_name='Periodicidade por semana')),
],
),
migrations.CreateModel(
name='Professor',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('nome', models.CharField(max_length=50, unique=True)),
('sexo', models.CharField(choices=[('M', 'Masculino'), ('F', 'Feminino')], max_length=1)),
],
options={
'verbose_name_plural': 'Professores',
},
),
migrations.CreateModel(
name='Promocao',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('descricao', models.CharField(max_length=30, unique=True, verbose_name='Valor promocional')),
],
),
migrations.CreateModel(
name='Turma',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('horario', models.TimeField(blank=True, null=True)),
('oferta_de_turma', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='turmas_da_modalidade', to='cadastros_basicos.OfertaDeTurma')),
('professor', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='turmas_do_professor', to='cadastros_basicos.Professor')),
],
options={
'verbose_name_plural': 'Turmas',
},
),
migrations.AddField(
model_name='ofertadeturma',
name='periodicidade',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='cadastros_basicos.Periodicidade', verbose_name='Vezes por semana'),
),
migrations.AddField(
model_name='ofertadeturma',
name='promocao',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='cadastros_basicos.Promocao'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Asign',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('start_hour', models.TimeField()),
('end_hour', models.TimeField()),
],
),
migrations.CreateModel(
name='Park',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('floor',
models.IntegerField(choices=[('1', '1'), ('2', '2'), ('3',
'3')])),
('parking_spot',
models.CharField(choices=[('1', '1'), ('2', '2'), ('3', '3'),
('4', '4'), ('5', '5'), ('6', '6'),
('7', '7'), ('8', '8'), ('9', '9'),
('10', '10')],
max_length=4)),
],
),
migrations.CreateModel(
name='VehicleType',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=60)),
('description', models.TextField()),
],
),
migrations.CreateModel(
name='Vehicle',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('image', models.ImageField(upload_to='products')),
('plate', models.CharField(max_length=10)),
('color', models.TextField(max_length=10)),
('Vehicle_type',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
to='vehicle.VehicleType')),
('spot',
models.ManyToManyField(through='vehicle.Asign',
to='vehicle.Park')),
],
),
migrations.AddField(
model_name='asign',
name='spot',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='vehicle.Park'),
),
migrations.AddField(
model_name='asign',
name='vehicle',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='vehicle.Vehicle'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
("auth", "0009_alter_user_last_name_max_length"),
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
("contenttypes", "0002_remove_content_type_name"),
]
operations = [
migrations.CreateModel(
name="Coupon",
fields=[
("id", models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name="ID",),),
("code", models.UUIDField(default=uuid.uuid4, editable=False)),
(
"value",
models.PositiveIntegerField(default=0, validators=[django.core.validators.MinValueValidator(1)],),
),
("notes", models.CharField(blank=True, max_length=190, null=True)),
("created_at", models.DateTimeField(auto_now_add=True)),
],
options={"ordering": ("event", "id"),},
),
migrations.CreateModel(
name="Day",
fields=[
("id", models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name="ID",),),
("date", models.DateField()),
("name", models.CharField(max_length=190)),
],
options={"ordering": ("date",),},
),
migrations.CreateModel(
name="Event",
fields=[
("id", models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name="ID",),),
("code", models.CharField(max_length=32, unique=True)),
("name", models.CharField(max_length=32)),
("full_name", models.CharField(max_length=160)),
("city", models.CharField(max_length=160)),
("country", django_countries.fields.CountryField(max_length=2)),
("presentation", models.TextField(blank=True, null=True)),
("website", models.URLField(blank=True, null=True)),
("hashtag", models.CharField(blank=True, max_length=16, null=True)),
("start_date", models.DateField()),
("end_date", models.DateField()),
("registration_start_date", models.DateField()),
("registration_early_deadline", models.DateTimeField(blank=True, null=True),),
("registration_deadline", models.DateTimeField()),
("wbs_element", models.CharField(blank=True, max_length=32, null=True)),
("test_mode", models.BooleanField(default=True, editable=False)),
("badge", models.TextField(blank=True, default="{}", null=True)),
],
),
migrations.CreateModel(
name="Fee",
fields=[
("id", models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name="ID",),),
(
"type",
models.CharField(
choices=[("regular", "Regular"), ("student", "Student"), ("one_day", "One day"),],
max_length=16,
),
),
(
"value",
models.PositiveIntegerField(default=0, validators=[django.core.validators.MinValueValidator(1)],),
),
("notes", models.CharField(blank=True, max_length=190, null=True)),
("is_early", models.BooleanField(default=False)),
("social_events_included", models.BooleanField(default=True)),
],
),
migrations.CreateModel(
name="Metadata",
fields=[
("id", models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name="ID",),),
(
"type",
models.CharField(
choices=[("gender", "Gender"), ("meal_preference", "Meal preference"),], max_length=32,
),
),
("value", models.CharField(max_length=64)),
("position", models.PositiveSmallIntegerField(default=0)),
],
options={"ordering": ("type", "value"),},
),
migrations.CreateModel(
name="Paper",
fields=[
("id", models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name="ID",),),
("title", models.TextField()),
("authors", models.TextField()),
(
"event",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE, related_name="papers", to="evan.Event",
),
),
],
),
migrations.CreateModel(
name="Payment",
fields=[
("id", models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name="ID",),),
("amount", models.PositiveIntegerField(default=0)),
(
"type",
models.CharField(
choices=[("stripe_charge", "Stripe charge"), ("stripe_refund", "Stripe refund"),],
default="stripe_charge",
max_length=32,
),
),
(
"status",
models.CharField(
choices=[("succeeded", "Succeeded"), ("pending", "Pending"), ("failed", "Failed"),],
default="failed",
max_length=16,
),
),
("outcome", models.TextField(blank=True, null=True)),
("stripe_id", models.CharField(blank=True, max_length=64, null=True)),
("stripe_response", models.TextField(blank=True, null=True)),
("created_at", models.DateTimeField(auto_now_add=True)),
],
),
migrations.CreateModel(
name="Permission",
fields=[
("id", models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name="ID",),),
(
"level",
models.PositiveSmallIntegerField(
choices=[(9, "Owner"), (5, "Administrator"), (1, "Guest")], db_index=True,
),
),
("object_id", models.PositiveIntegerField()),
(
"content_type",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name="perms",
to="contenttypes.ContentType",
),
),
],
),
migrations.CreateModel(
name="Profile",
fields=[
(
"user",
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
primary_key=True,
serialize=False,
to=settings.AUTH_USER_MODEL,
),
),
(
"gender",
models.CharField(
blank=True, choices=[("F", "Female"), ("M", "Male")], db_index=True, max_length=1, null=True,
),
),
(
"dietary",
models.CharField(
blank=True,
choices=[
("none", "No special requirements"),
("vegetarian", "Vegetarian"),
("vegan", "Vegan"),
("kosher", "Kosher"),
("muslim", "Muslim"),
("int_gluten", "Gluten intolerant"),
("int_lactose", "Lactose intolerant"),
("al_peanuts", "Allergic to crustaceans"),
("al_peanuts", "Allergic to peanuts"),
],
db_index=True,
max_length=16,
null=True,
),
),
("affiliation", models.CharField(max_length=190)),
("country", django_countries.fields.CountryField(max_length=2)),
],
),
migrations.CreateModel(
name="Registration",
fields=[
("id", models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name="ID",),),
("uuid", models.UUIDField(default=uuid.uuid4, editable=False)),
("visa_requested", models.BooleanField(default=False)),
("visa_sent", models.BooleanField(default=False)),
(
"fee_type",
models.CharField(
choices=[("regular", "Regular"), ("student", "Student"), ("one_day", "One day"),],
default="regular",
max_length=8,
),
),
("base_fee", models.PositiveSmallIntegerField(default=0, editable=False),),
("manual_extra_fees", models.PositiveSmallIntegerField(default=0)),
("invoice_requested", models.BooleanField(default=False)),
("invoice_sent", models.BooleanField(default=False)),
("paid", models.PositiveSmallIntegerField(default=0, editable=False)),
("paid_via_invoice", models.PositiveSmallIntegerField(default=0)),
("saldo", models.IntegerField(default=0, editable=False)),
("created_at", models.DateTimeField(auto_now_add=True)),
("updated_at", models.DateTimeField(auto_now=True)),
(
"coupon",
models.OneToOneField(
blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to="evan.Coupon",
),
),
("days", models.ManyToManyField(related_name="registrations", to="evan.Day"),),
(
"event",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE, related_name="registrations", to="evan.Event",
),
),
],
options={"ordering": ("-created_at",),},
),
migrations.CreateModel(
name="RegistrationLog",
fields=[
("id", models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name="ID",),),
("created_at", models.DateTimeField(auto_now_add=True)),
(
"registration",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE, related_name="logs", to="evan.Registration",
),
),
],
),
migrations.CreateModel(
name="Room",
fields=[
("id", models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name="ID",),),
("name", models.CharField(max_length=190)),
("max_capacity", models.PositiveSmallIntegerField(default=0)),
("position", models.PositiveSmallIntegerField(default=0)),
],
options={"ordering": ("position",),},
),
migrations.CreateModel(
name="Session",
fields=[
("id", models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name="ID",),),
("date", models.DateField()),
("start_at", models.TimeField(blank=True, null=True)),
("end_at", models.TimeField(blank=True, null=True)),
("title", models.CharField(max_length=190)),
("summary", models.TextField(blank=True, null=True)),
("website", models.URLField(blank=True, null=True)),
("image", models.FileField(blank=True, null=True, upload_to="public/sympo/activity"),),
(
"max_attendees",
models.PositiveSmallIntegerField(default=0, help_text="Leave on `0` for non limiting."),
),
("extra_attendees_fee", models.PositiveSmallIntegerField(default=0)),
("is_private", models.BooleanField(default=False)),
("is_social_event", models.BooleanField(default=False)),
("created_at", models.DateTimeField(auto_now_add=True)),
("updated_at", models.DateTimeField(auto_now=True)),
(
"event",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE, related_name="sessions", to="evan.Event",
),
),
(
"organizers",
models.ManyToManyField(blank=True, related_name="organized_sessions", to=settings.AUTH_USER_MODEL,),
),
(
"room",
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name="sessions",
to="evan.Room",
),
),
],
options={"ordering": ("date", "start_at", "end_at"),},
),
migrations.CreateModel(
name="Topic",
fields=[
("id", models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name="ID",),),
("name", models.CharField(max_length=64)),
(
"event",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE, related_name="topics", to="evan.Event",
),
),
],
),
migrations.CreateModel(
name="Track",
fields=[
("id", models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name="ID",),),
("name", models.CharField(max_length=64)),
("position", models.PositiveSmallIntegerField(default=0)),
(
"event",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE, related_name="tracks", to="evan.Event",
),
),
],
options={"ordering": ("position", "name"),},
),
migrations.CreateModel(
name="Venue",
fields=[
("id", models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name="ID",),),
("is_main", models.BooleanField(default=False)),
("name", models.CharField(max_length=160)),
("city", models.CharField(blank=True, max_length=160, null=True)),
("presentation", models.TextField(blank=True, null=True)),
("address", models.CharField(blank=True, max_length=160, null=True)),
("lat", models.FloatField(blank=True, null=True, verbose_name="Latitude"),),
("lng", models.FloatField(blank=True, null=True, verbose_name="Longitude"),),
("website", models.URLField(blank=True, null=True)),
(
"event",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE, related_name="venues", to="evan.Event",
),
),
],
),
migrations.AddField(
model_name="session",
name="topics",
field=models.ManyToManyField(blank=True, related_name="sessions", to="evan.Topic"),
),
migrations.AddField(
model_name="session",
name="track",
field=models.ForeignKey(
null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="sessions", to="evan.Track",
),
),
migrations.AddField(
model_name="room",
name="venue",
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE, related_name="rooms", to="evan.Venue",
),
),
migrations.AddField(
model_name="registrationlog",
name="session",
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE, related_name="logs", to="evan.Session",
),
),
migrations.AddField(
model_name="registration",
name="sessions",
field=models.ManyToManyField(related_name="registrations", to="evan.Session"),
),
migrations.AddField(
model_name="registration",
name="user",
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE, related_name="registrations", to=settings.AUTH_USER_MODEL,
),
),
migrations.AddField(
model_name="permission",
name="user",
field=models.ForeignKey(
blank=True,
on_delete=django.db.models.deletion.CASCADE,
related_name="perms",
to=settings.AUTH_USER_MODEL,
),
),
migrations.AddField(
model_name="payment",
name="registration",
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE, related_name="payments", to="evan.Registration",
),
),
migrations.AddIndex(
model_name="metadata", index=models.Index(fields=["type"], name="evan_metada_type_61f530_idx"),
),
migrations.AddField(
model_name="fee",
name="event",
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name="fees", to="evan.Event",),
),
migrations.AddIndex(
model_name="event", index=models.Index(fields=["code"], name="evan_event_code_de03e5_idx"),
),
migrations.AddIndex(
model_name="event",
index=models.Index(fields=["start_date", "end_date"], name="evan_event_start_d_907dae_idx"),
),
migrations.AddField(
model_name="day",
name="event",
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name="days", to="evan.Event",),
),
migrations.AddField(
model_name="coupon",
name="event",
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE, related_name="coupons", to="evan.Event",
),
),
migrations.AddIndex(
model_name="session", index=models.Index(fields=["event", "date"], name="evan_sessio_event_i_fa353e_idx"),
),
migrations.AddIndex(
model_name="session", index=models.Index(fields=["event", "track"], name="evan_sessio_event_i_74abf3_idx"),
),
migrations.AlterUniqueTogether(name="registrationlog", unique_together={("registration", "session")},),
migrations.AddIndex(
model_name="registration", index=models.Index(fields=["uuid"], name="evan_regist_uuid_df76cd_idx"),
),
migrations.AlterUniqueTogether(name="registration", unique_together={("event", "user")},),
migrations.AddIndex(
model_name="fee", index=models.Index(fields=["type", "is_early"], name="evan_fee_type_f6ca07_idx"),
),
migrations.AddIndex(
model_name="day", index=models.Index(fields=["event", "date"], name="evan_day_event_i_74099f_idx"),
),
migrations.AddIndex(
model_name="coupon", index=models.Index(fields=["code"], name="evan_coupon_code_196326_idx"),
),
]
class Route(models.Model):
"""
Bus routes of İzmir.
"""
code = models.PositiveSmallIntegerField(
unique=True,
primary_key=True,
verbose_name="Code"
)
# stops = models.ManyToManyField(
# Stop,
# null=True,
# blank=True,
# through="RouteStop",
# related_name="routes",
# verbose_name="Stops"
# )
stops_forwards = ArrayField(
ArrayField(
models.PositiveIntegerField(),
size=2
),
default=[],
verbose_name="Stops Forwards (Ordered)"
)
stops_backwards = ArrayField(
ArrayField(
models.PositiveIntegerField(),
size=2
),
default=[],
verbose_name="Stops Backwards (Ordered)"
)
terminals = ArrayField(
models.CharField(
null=False,
blank=False,
max_length=32,
),
size=2,
default=[],
verbose_name="Terminals"
)
departure_times_forwards = ArrayField(
ArrayField(
models.TimeField(
null=False,
blank=False
),
null=True,
default=[]
),
default=[],
size=6,
verbose_name="Departure Times (Forwards)"
)
departure_times_backwards = ArrayField(
ArrayField(
models.TimeField(
null=False,
blank=False
),
null=True,
default=[]
),
default=[],
size=6,
verbose_name="Departure Times (Backwards)"
)
class Meta:
verbose_name = "Route"
verbose_name_plural = "Routes"
ordering = ["code"]
def __str__(self):
return "{}: {} - {}".format(str(self.code), self.terminals[0], self.terminals[1])
