class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Review',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('title', models.CharField(max_length=300)),
('description', models.CharField(max_length=2000)),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('rating', models.IntegerField()),
('customer', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='customer_review', to=settings.AUTH_USER_MODEL)),
('worker', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='worker_review', to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Profile',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('is_cooker', models.BooleanField(default=False)),
('bio', models.TextField(blank=True, max_length=500)),
('location', models.CharField(blank=True, max_length=50)),
('birth_date', models.DateField(blank=True, null=True)),
('instagram', models.CharField(blank=True, max_length=100)),
('whatsapp', models.CharField(blank=True, max_length=100)),
('telegram', models.CharField(blank=True, max_length=100)),
('rating', models.IntegerField(default=0)),
('file', models.FileField(blank=True, null=True, upload_to='')),
('user', models.OneToOneField(blank=True, on_delete=django.db.models.deletion.CASCADE, related_name='profile', to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Order',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('title', models.CharField(max_length=300)),
('description', models.CharField(max_length=2000)),
('deadline', models.IntegerField()),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('is_active', models.BooleanField(default=True)),
('weight', models.FloatField()),
('price', models.IntegerField()),
('customer', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='customer_orders', to=settings.AUTH_USER_MODEL)),
('worker', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='worker_orders', to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Avatar',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('file', models.FileField(blank=True, null=True, upload_to='')),
('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='avatar', to=settings.AUTH_USER_MODEL)),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
('clientes', '0002_auto_20181206_1443'),
('estoque', '0001_initial'),
]
operations = [
migrations.CreateModel(
name='ItemVenda',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('quantidade', models.FloatField(default=0.0)),
('desconto',
models.DecimalField(decimal_places=2, default=0,
max_digits=5)),
('produto',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
to='estoque.Produto')),
],
),
migrations.CreateModel(
name='Venda',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('data', models.DateField()),
('valor',
models.DecimalField(blank=True,
decimal_places=2,
max_digits=7,
null=True)),
('desconto',
models.DecimalField(decimal_places=2, default=0,
max_digits=5)),
('cliente',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.PROTECT,
to='clientes.Cliente')),
('vendedor',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.AddField(
model_name='itemvenda',
name='venda',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='vendas.Venda'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
('taggit', '0002_auto_20150616_2121'),
('wagtailimages', '0012_copy_image_permissions_to_collections'),
('comments', '0002_auto_20160411_1006'),
('wagtailcore', '0028_merge'),
]
operations = [
migrations.CreateModel(
name='Address',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('city', models.CharField(max_length=40, verbose_name='stad')),
('postal_code',
models.CharField(max_length=8,
null=True,
verbose_name='postcode')),
('street',
models.CharField(max_length=40,
null=True,
verbose_name='straat')),
('number',
models.CharField(max_length=8,
null=True,
verbose_name='nummer')),
('country',
django_countries.fields.CountryField(default='BE',
max_length=2,
null=True,
verbose_name='land')),
],
options={
'verbose_name_plural': 'adressen',
'verbose_name': 'adres',
},
),
migrations.CreateModel(
name='CommentSnippet',
fields=[
('commentwithtitle_ptr',
models.OneToOneField(
auto_created=True,
on_delete=django.db.models.deletion.CASCADE,
parent_link=True,
primary_key=True,
serialize=False,
to='comments.CommentWithTitle')),
],
options={
'verbose_name_plural': 'comments',
'abstract': False,
'permissions': [('can_moderate', 'Can moderate comments')],
'verbose_name': 'comment',
'ordering': ('submit_date', ),
},
bases=('comments.commentwithtitle', ),
),
migrations.CreateModel(
name='CustomImage',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('title', models.CharField(max_length=255,
verbose_name='title')),
('file',
models.ImageField(
height_field='height',
upload_to=wagtail.wagtailimages.models.get_upload_to,
verbose_name='file',
width_field='width')),
('width',
models.IntegerField(editable=False, verbose_name='width')),
('height',
models.IntegerField(editable=False, verbose_name='height')),
('created_at',
models.DateTimeField(auto_now_add=True,
db_index=True,
verbose_name='created at')),
('focal_point_x',
models.PositiveIntegerField(blank=True, null=True)),
('focal_point_y',
models.PositiveIntegerField(blank=True, null=True)),
('focal_point_width',
models.PositiveIntegerField(blank=True, null=True)),
('focal_point_height',
models.PositiveIntegerField(blank=True, null=True)),
('file_size',
models.PositiveIntegerField(editable=False, null=True)),
('author',
models.CharField(blank=True,
max_length=56,
null=True,
verbose_name='auteur')),
('collection',
models.ForeignKey(
default=wagtail.wagtailcore.models.get_root_collection_id,
on_delete=django.db.models.deletion.CASCADE,
related_name='+',
to='wagtailcore.Collection',
verbose_name='collection')),
('tags',
taggit.managers.TaggableManager(blank=True,
help_text=None,
through='taggit.TaggedItem',
to='taggit.Tag',
verbose_name='tags')),
('uploaded_by_user',
models.ForeignKey(
blank=True,
editable=False,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to=settings.AUTH_USER_MODEL,
verbose_name='uploaded by user')),
],
options={
'abstract': False,
},
bases=(models.Model, wagtail.wagtailadmin.taggable.TagSearchable),
),
migrations.CreateModel(
name='CustomRendition',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('file',
models.ImageField(height_field='height',
upload_to='images',
width_field='width')),
('width', models.IntegerField(editable=False)),
('height', models.IntegerField(editable=False)),
('focal_point_key',
models.CharField(blank=True,
default='',
editable=False,
max_length=255)),
('filter',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='+',
to='wagtailimages.Filter')),
('image',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='renditions',
to='home.CustomImage')),
],
),
migrations.CreateModel(
name='FestivalImage',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('is_primary',
models.BooleanField(default=False,
verbose_name='hoofdafbeelding')),
('image',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='+',
to='home.CustomImage',
verbose_name='afbeelding')),
],
),
migrations.CreateModel(
name='FestivalIndexPage',
fields=[
('page_ptr',
models.OneToOneField(
auto_created=True,
on_delete=django.db.models.deletion.CASCADE,
parent_link=True,
primary_key=True,
serialize=False,
to='wagtailcore.Page')),
],
options={
'abstract': False,
},
bases=('wagtailcore.page', ),
),
migrations.CreateModel(
name='FestivalLocation',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
],
),
migrations.CreateModel(
name='FestivalPage',
fields=[
('page_ptr',
models.OneToOneField(
auto_created=True,
on_delete=django.db.models.deletion.CASCADE,
parent_link=True,
primary_key=True,
serialize=False,
to='wagtailcore.Page')),
('name',
models.CharField(default='',
max_length=40,
unique=True,
verbose_name='Festival naam')),
('description',
wagtail.wagtailcore.fields.RichTextField(
blank=True,
default='',
verbose_name='Festival promo tekst')),
('date',
models.DateField(null=True, verbose_name='Festival datum')),
('duration',
models.PositiveIntegerField(default=1,
verbose_name='Duur (# dagen)')),
('website',
models.URLField(blank=True, max_length=120, null=True)),
],
options={
'verbose_name': 'Festival',
'ordering': ['-date'],
},
bases=('wagtailcore.page', ),
),
migrations.CreateModel(
name='FestivalPageRateableAttribute',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=27)),
],
options={
'verbose_name_plural': 'Beoordeelbare kenmerken',
'verbose_name': 'Beoordeelbaar kenmerk',
'ordering': ['name'],
},
),
migrations.CreateModel(
name='FestivalPageRatebleAttributeValue',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('page',
modelcluster.fields.ParentalKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='rateable_attributes',
to='home.FestivalPage')),
('rateable_attribute',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='+',
to='home.FestivalPageRateableAttribute',
unique=True)),
],
),
migrations.CreateModel(
name='FestivalPageTag',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('content_object',
modelcluster.fields.ParentalKey(
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='tagged_items',
to='home.FestivalPage')),
('tag',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='home_festivalpagetag_items',
to='taggit.Tag')),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='HomePage',
fields=[
('page_ptr',
models.OneToOneField(
auto_created=True,
on_delete=django.db.models.deletion.CASCADE,
parent_link=True,
primary_key=True,
serialize=False,
to='wagtailcore.Page')),
('body',
wagtail.wagtailcore.fields.StreamField(
(('carousel',
wagtail.wagtailcore.blocks.
ListBlock(wagtail.wagtailcore.blocks.StructBlock(
(('image',
wagtail.wagtailimages.blocks.ImageChooserBlock()),
('caption',
wagtail.wagtailcore.blocks.TextBlock(
required=False)))),
icon='image',
template='home/blocks/carousel.html')), ),
null=True)),
('test',
wagtail.wagtailcore.fields.RichTextField(blank=True,
null=True)),
],
options={
'verbose_name': 'Startpagina',
},
bases=('wagtailcore.page', ),
),
migrations.CreateModel(
name='Location',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(max_length=28, verbose_name='locatie naam')),
('longitude',
models.DecimalField(blank=True,
decimal_places=7,
max_digits=10,
null=True)),
('latitude',
models.DecimalField(blank=True,
decimal_places=7,
max_digits=10,
null=True)),
],
options={
'verbose_name_plural': 'locaties',
'verbose_name': 'locatie',
},
),
migrations.CreateModel(
name='Person',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('first_name',
models.CharField(max_length=28,
unique=True,
verbose_name='naam')),
('last_name',
models.CharField(blank=True,
max_length=64,
verbose_name='familienaam')),
('email',
models.EmailField(blank=True,
max_length=254,
null=True,
verbose_name='email adres')),
('phone',
models.CharField(blank=True,
max_length=28,
null=True,
verbose_name='telefoon nr')),
],
options={
'verbose_name_plural': 'personen',
'verbose_name': 'persoon',
'ordering': ['first_name'],
},
),
# migrations.CreateModel(
# name='AddressOrderable',
# fields=[
# ('address_ptr', models.OneToOneField(auto_created=True, on_delete=django.db.models.deletion.CASCADE, parent_link=True, primary_key=True, serialize=False, to='home.Address')),
# ('sort_order', models.IntegerField(blank=True, editable=False, null=True)),
# ],
# options={
# 'abstract': False,
# 'ordering': ['sort_order'],
# },
# bases=('home.address', models.Model),
# ),
# migrations.CreateModel(
# name='OrderableTest',
# fields=[
# ('location_ptr', models.OneToOneField(auto_created=True, on_delete=django.db.models.deletion.CASCADE, parent_link=True, primary_key=True, serialize=False, to='home.Location')),
# ('sort_order', models.IntegerField(blank=True, editable=False, null=True)),
# ],
# options={
# 'abstract': False,
# 'ordering': ['sort_order'],
# },
# bases=('home.location', models.Model),
# ),
migrations.AddField(
model_name='location',
name='address',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='location',
to='home.Address',
verbose_name='adres'),
),
migrations.AddField(
model_name='festivalpage',
name='contact_person',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='festivals',
to='home.Person'),
),
migrations.AddField(
model_name='festivalpage',
name='location',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='festivals',
to='home.Location'),
),
migrations.AddField(
model_name='festivalpage',
name='main_image',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='+',
to='wagtailimages.Image'),
),
migrations.AddField(
model_name='festivalpage',
name='tags',
field=modelcluster.contrib.taggit.ClusterTaggableManager(
blank=True,
help_text='A comma-separated list of tags.',
through='home.FestivalPageTag',
to='taggit.Tag',
verbose_name='Tags'),
),
migrations.AddField(
model_name='festivallocation',
name='location',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='home.Location'),
),
migrations.AddField(
model_name='festivallocation',
name='page',
field=modelcluster.fields.ParentalKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='locations',
to='home.FestivalPage'),
),
migrations.AddField(
model_name='festivalimage',
name='page',
field=modelcluster.fields.ParentalKey(
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='images',
to='home.FestivalPage'),
),
# migrations.AddField(
# model_name='orderabletest',
# name='page',
# field=modelcluster.fields.ParentalKey(on_delete=django.db.models.deletion.CASCADE, related_name='locaties', to='home.FestivalPage'),
# ),
migrations.AlterUniqueTogether(
name='customrendition',
unique_together=set([('image', 'filter', 'focal_point_key')]),
),
# migrations.AddField(
# model_name='addressorderable',
# name='page',
# field=modelcluster.fields.ParentalKey(on_delete=django.db.models.deletion.CASCADE, related_name='adresorderable', to='home.FestivalPage'),
# ),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
('order', '0001_initial'),
]
operations = [
migrations.CreateModel(
name='Bankcard',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('card_type', models.CharField(max_length=128, verbose_name='Card Type')),
('name', models.CharField(blank=True, max_length=255, verbose_name='Name')),
('number', models.CharField(max_length=32, verbose_name='Number')),
('expiry_date', models.DateField(verbose_name='Expiry Date')),
('partner_reference', models.CharField(blank=True, max_length=255, verbose_name='Partner Reference')),
('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='bankcards', to=settings.AUTH_USER_MODEL, verbose_name='User')),
],
options={
'verbose_name': 'Bankcard',
'verbose_name_plural': 'Bankcards',
'abstract': False,
},
),
migrations.CreateModel(
name='Source',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('currency', models.CharField(default=oscar.core.utils.get_default_currency, max_length=12, verbose_name='Currency')),
('amount_allocated', models.DecimalField(decimal_places=2, default=Decimal('0.00'), max_digits=12, verbose_name='Amount Allocated')),
('amount_debited', models.DecimalField(decimal_places=2, default=Decimal('0.00'), max_digits=12, verbose_name='Amount Debited')),
('amount_refunded', models.DecimalField(decimal_places=2, default=Decimal('0.00'), max_digits=12, verbose_name='Amount Refunded')),
('reference', models.CharField(blank=True, max_length=255, verbose_name='Reference')),
('label', models.CharField(blank=True, max_length=128, verbose_name='Label')),
('order', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='sources', to='order.Order', verbose_name='Order')),
],
options={
'verbose_name': 'Source',
'verbose_name_plural': 'Sources',
'abstract': False,
},
),
migrations.CreateModel(
name='SourceType',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=128, verbose_name='Name')),
('code', oscar.models.fields.autoslugfield.AutoSlugField(blank=True, editable=False, help_text='This is used within forms to identify this source type', max_length=128, populate_from='name', unique=True, verbose_name='Code')),
],
options={
'verbose_name': 'Source Type',
'verbose_name_plural': 'Source Types',
'abstract': False,
},
),
migrations.CreateModel(
name='Transaction',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('txn_type', models.CharField(blank=True, max_length=128, verbose_name='Type')),
('amount', models.DecimalField(decimal_places=2, max_digits=12, verbose_name='Amount')),
('reference', models.CharField(blank=True, max_length=128, verbose_name='Reference')),
('status', models.CharField(blank=True, max_length=128, verbose_name='Status')),
('date_created', models.DateTimeField(auto_now_add=True, verbose_name='Date Created')),
('source', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='transactions', to='payment.Source', verbose_name='Source')),
],
options={
'verbose_name': 'Transaction',
'verbose_name_plural': 'Transactions',
'ordering': ['-date_created'],
'abstract': False,
},
),
migrations.AddField(
model_name='source',
name='source_type',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='sources', to='payment.SourceType', verbose_name='Source Type'),
),
]
class Dataset(models.Model):
UPDATE_SCHEDULE_CHOICES = [
('daily', 'Daily'),
('weekly', 'Weekly'),
('monthly', 'Monthly'),
('when needed', 'When Needed'),
]
name = models.CharField(unique=True, max_length=255,
blank=False, null=False)
model_name = models.CharField(
unique=True, max_length=255, blank=False, null=False)
automated = models.BooleanField(blank=True, null=True)
update_instructions = models.TextField(blank=True, null=True)
download_endpoint = models.TextField(blank=True, null=True)
api_last_updated = models.DateTimeField(blank=True, null=True)
records_start = models.DateField(blank=True, null=True)
records_end = models.DateField(blank=True, null=True)
update_schedule = models.CharField(
max_length=255, choices=UPDATE_SCHEDULE_CHOICES, blank=True, null=True)
@classmethod
def annotate_properties_all(self):
try:
for model_name in settings.ANNOTATED_DATASETS:
if model_name == 'AcrisRealMaster':
model_name = 'AcrisRealLegal'
dataset = self.objects.get(model_name=model_name)
dataset.model().annotate_properties()
except Exception as e:
logger.error(
'Error during task: {} with assumed model name: {}'.format(e, model_name))
raise e
def model(self):
return getattr(ds, self.model_name)
def download(self, endpoint=None, file_name=None):
return getattr(ds, self.model_name).download(endpoint=endpoint, file_name=file_name)
def update(self, file=None):
return Update.objects.create(dataset=self, file=file)
def needs_update(self):
return self.api_last_updated != getattr(ds, self.model_name).fetch_last_updated()
def update_records_range(self):
dataset = getattr(ds, self.model_name)
def get_earliest_date():
if hasattr(dataset, 'EARLIEST_RECORD'):
return dataset.EARLIEST_RECORD
else:
return '1950-01-01'
if hasattr(dataset, 'QUERY_DATE_KEY'):
try:
query = dataset.objects.filter(
**{
"{}__isnull".format(dataset.QUERY_DATE_KEY): False,
"{}__gte".format(dataset.QUERY_DATE_KEY): get_earliest_date(),
"{}__lte".format(dataset.QUERY_DATE_KEY): datetime.datetime.now()
})
self.records_start = getattr(query.earliest(
dataset.QUERY_DATE_KEY), dataset.QUERY_DATE_KEY)
self.records_end = getattr(query.latest(
dataset.QUERY_DATE_KEY), dataset.QUERY_DATE_KEY)
self.save()
except Exception as e:
print(e)
logger.warning(e)
def check_api_for_update(self):
self.api_last_updated = getattr(
ds, self.model_name).fetch_last_updated()
if self.api_last_updated:
self.save()
def check_api_for_update_and_update(self):
if self.api_last_updated:
api_last_updated = getattr(
ds, self.model_name).fetch_last_updated()
if not api_last_updated or api_last_updated.replace(tzinfo=timezone.utc) > self.api_last_updated.replace(tzinfo=timezone.utc):
self.model().create_async_update_worker()
else:
logger.debug('Dataset {} is up to date.'.format(self.name))
else:
self.model().create_async_update_worker()
def seed_dataset(self, **kwargs):
getattr(ds, self.model_name).seed_or_update_self(**kwargs)
self.delete_old_files()
def split_seed_dataset(self, **kwargs):
getattr(ds, self.model_name).split_seed_or_update_self(**kwargs)
def latest_update(self):
from core.models import Dataset
# Make sure to prefetch_related('update_set')
try:
update_source = Dataset.objects.get(
model_name=self.model().UPDATE_SOURCE) if hasattr(self.model(), 'UPDATE_SOURCE') else self
latest = update_source.update_set.filter(
task_result__status="SUCCESS").latest('created_date')
except Exception as e:
logger.warning(e)
latest = None
return latest
def latest_file(self):
# Make sure to prefetch_related('datefile_set')
try:
return self.datafile_set.latest('uploaded_date')
except Exception as e:
return None
def second_latest_file(self):
try:
return self.datafile_set.order_by('-uploaded_date').all()[1]
except Exception as e:
return None
def latest_version(self):
latest_file = self.latest_file()
if latest_file:
return latest_file.version
else:
return None
def delete_old_files(self):
# Deletes all but the last 2 files saved for this dataset.
old_files = self.datafile_set.all().order_by('-uploaded_date')[2:]
for file in old_files:
file.delete()
def __str__(self):
return self.name
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0012_alter_user_first_name_max_length'),
]
operations = [
migrations.CreateModel(
name='User',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('password',
models.CharField(max_length=128, verbose_name='password')),
('last_login',
models.DateTimeField(blank=True,
null=True,
verbose_name='last login')),
('is_superuser',
models.BooleanField(
default=False,
help_text=
'Designates that this user has all permissions without explicitly assigning them.',
verbose_name='superuser status')),
('email',
models.EmailField(max_length=254,
unique=True,
verbose_name='email')),
('first_name',
models.CharField(max_length=30, verbose_name='name')),
('last_name',
models.CharField(blank=True,
max_length=30,
verbose_name='surname')),
('date_joined',
models.DateTimeField(auto_now_add=True,
verbose_name='registered')),
('token', models.CharField(max_length=30,
verbose_name='token')),
('age',
models.PositiveIntegerField(blank=True,
default=0,
verbose_name='age')),
('gender',
models.PositiveIntegerField(blank=True,
choices=[(0, 'Ж'), (1, 'M')],
default=0,
verbose_name='gender')),
('is_staff', models.BooleanField(default=True)),
('groups',
models.ManyToManyField(
blank=True,
help_text=
'The groups this user belongs to. A user will get all permissions granted to each of their groups.',
related_name='user_set',
related_query_name='user',
to='auth.Group',
verbose_name='groups')),
('user_permissions',
models.ManyToManyField(
blank=True,
help_text='Specific permissions for this user.',
related_name='user_set',
related_query_name='user',
to='auth.Permission',
verbose_name='user permissions')),
],
options={
'verbose_name': 'user',
'verbose_name_plural': 'users',
},
managers=[
('objects', api.manager.UserManager()),
],
),
migrations.CreateModel(
name='Transaction',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.TextField(verbose_name='Название транзакции')),
('ticket', models.TextField(verbose_name='Тикет')),
('price', models.FloatField(verbose_name='Цена транзакции')),
('data',
models.DateField(verbose_name='Дата совершения транзакции')),
('active_type',
models.PositiveIntegerField(choices=[(0, 'Акция'),
(1, 'Облигация'),
(2, 'Фонд')],
verbose_name='Тип актива')),
('user_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
options={
'verbose_name': 'Транзакция',
'verbose_name_plural': 'Транзакции',
},
),
migrations.CreateModel(
name='Credit',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.TextField(verbose_name='Название кредита')),
('value', models.FloatField(verbose_name='Величина кредита')),
('payment',
models.FloatField(verbose_name='Ежемесячная выплата')),
('user_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
options={
'verbose_name': 'Кредит',
'verbose_name_plural': 'Кредиты',
},
),
migrations.CreateModel(
name='Contribution',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.TextField(verbose_name='Название вклада')),
('percentage_rate',
models.FloatField(verbose_name='Процентная ставка')),
('current_amount',
models.FloatField(verbose_name='Текущая сумма')),
('percentage_accrual_date',
models.DateField(verbose_name='Дата начисления процентов')),
('percentage_to_contribution',
models.BooleanField(
default=False,
verbose_name='Проценты начисляются на вклад')),
('user_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
options={
'verbose_name': 'Вклад',
'verbose_name_plural': 'Вклады',
},
),
]
class Profile(User):
date_of_birth = models.DateField()
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Author',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('first_name', models.CharField(max_length=100)),
('last_name', models.CharField(max_length=100)),
('date_of_birth', models.DateField(blank=True, null=True)),
('date_of_death',
models.DateField(blank=True, null=True, verbose_name='Died')),
],
options={
'ordering': ['last_name', 'first_name'],
},
),
migrations.CreateModel(
name='Book',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('title', models.CharField(max_length=200)),
('summary',
models.TextField(
help_text='Enter a brief description of the book',
max_length=1000)),
('isbn',
models.CharField(
help_text=
'13 Character <a href="https://www.isbn-international.org/content/what-isbn">ISBN number</a>',
max_length=13,
unique=True,
verbose_name='ISBN')),
('author',
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='catalog.author')),
],
),
migrations.CreateModel(
name='Genre',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(
help_text='Enter a book genre (e.g. Science Fiction)',
max_length=200)),
],
),
migrations.CreateModel(
name='BookInstance',
fields=[
('id',
models.UUIDField(
default=uuid.uuid4,
help_text=
'Unique ID for this particular book across whole library',
primary_key=True,
serialize=False)),
('imprint', models.CharField(max_length=200)),
('due_back', models.DateField(blank=True, null=True)),
('status',
models.CharField(blank=True,
choices=[('m', 'Maintenance'),
('o', 'On loan'),
('a', 'Available'),
('r', 'Reserved')],
default='m',
help_text='Book availability',
max_length=1)),
('book',
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='catalog.book')),
],
options={
'ordering': ['due_back'],
},
),
migrations.AddField(
model_name='book',
name='genre',
field=models.ManyToManyField(
help_text='Select a genre for this book', to='catalog.Genre'),
),
]
class ShopCollection(ShopEntityModel):
available = models.BooleanField(default=True)
timestamp = models.DateField(auto_now_add=True)
cover = models.ImageField(upload_to='collections/', blank=True)
class ScheduledEvent(models.Model):
event = models.ForeignKey(RegularEvent, blank=True, null=True,
help_text=('You can leave this blank, but if '
'you do you must give the event a '
'title.'))
title = models.CharField(max_length=60)
date = models.DateField()
start_time = models.TimeField(help_text='What time does the event start?')
duration = models.IntegerField(blank=True, null=True,
help_text=('Duration in minutes (leave '
'blank for unknown duration and '
'for multi-day events).'))
end_date = models.DateField(blank=True, null=True,
help_text=('If an end date is specified, any '
'duration given will be ignored.'))
contact = models.ForeignKey(EventContact,
blank=True,
null=True)
intro = models.CharField(max_length=200,
help_text=('Brief description (no Markdown here) '
'of what the event is and who it is '
'for.'))
details = models.TextField(blank=True, null=True,
help_text=('e.g. Who is this event for? What '
'does it involve? How much does it '
'cost? Where is it held?'))
series = models.ForeignKey(
ScheduledEventSeries,
blank=True,
null=True,
related_name='events'
)
modified = models.DateTimeField(auto_now=True)
objects = ScheduledEventManager()
bare_objects = models.Manager()
class Meta:
# Need this because I've split up models.py into multiple
# files.
app_label = 'kanisa'
ordering = ('date', 'start_time')
def __unicode__(self):
if self.title:
return self.title
if self.event:
return self.event.title
# Hopefully this only occurs during event editing
return 'None'
def save(self, *args, **kwargs):
if self.end_date is None:
self.end_date = self.date
super(ScheduledEvent, self).save(*args, **kwargs)
def is_special(self):
if not self.event:
return True
if self.end_date and self.end_date != self.date:
return True
if self.event and self.details:
if self.event.details != self.details:
return True
return False
def url(self):
if not self.is_special():
return reverse('kanisa_public_diary_regularevent_detail',
args=[self.event.slug, ])
return reverse('kanisa_public_diary_scheduledevent_detail',
args=[self.pk, ])
@classmethod
def events_between(cls, start_date, end_date):
events = ScheduledEvent.objects.exclude(end_date__lt=start_date)
events = events.exclude(date__gt=end_date)
return events
class Employees(models.Model):
EmployeeId = models.AutoField(primary_key = True)
EmployeeName = models.CharField(max_length=100, unique = True)
Department = models.CharField(max_length=100)
DateOfJoint = models.DateField()
PhotoFileName = models.CharField(max_length=100)
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Auto',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('car_number', models.IntegerField()),
('brand_name', models.CharField(max_length=50)),
('model_name', models.CharField(max_length=50)),
('colour', models.CharField(max_length=50)),
],
),
migrations.CreateModel(
name='Owner',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('first_name', models.CharField(max_length=50)),
('last_name', models.CharField(max_length=50)),
('birth_date', models.DateField()),
],
),
migrations.CreateModel(
name='Ownership',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('start_date', models.DateField()),
('exp_date', models.DateField()),
('car_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='project_first_app.Auto')),
('owner_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='project_first_app.Owner')),
],
),
migrations.CreateModel(
name='Licence',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('id_number', models.IntegerField()),
('date', models.DateField()),
('type',
models.CharField(blank=True,
choices=[('A', 'A'), ('B', 'B'), ('C', 'C'),
('D', 'D')],
max_length=2)),
('owner_lic',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='project_first_app.Owner')),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Department',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('department', models.CharField(max_length=100)),
],
),
migrations.CreateModel(
name='EmployeeProfile',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('dob', models.DateField(verbose_name='Date of Birth')),
('address', models.CharField(max_length=75)),
('city', models.CharField(max_length=50)),
('state', models.CharField(max_length=50)),
('origin_state', models.CharField(max_length=50)),
('nationality', models.CharField(max_length=50)),
('mobile', models.CharField(max_length=15)),
('department',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='employees.Department')),
('user',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='LeaveRequest',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('start_date', models.DateField(help_text='Start of Leave')),
('end_date', models.DateField(help_text='End of Leave')),
('leave_type',
models.IntegerField(choices=[(0, 'Study'), (1, 'Medical'),
(2, 'Emergency'),
(3, 'Vacation'), (4, 'Other')],
default=0)),
('reason_for_leave', models.TextField(max_length=250)),
('employee',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to='employees.EmployeeProfile')),
],
),
migrations.CreateModel(
name='ManageRequest',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('status_decision',
models.CharField(choices=[('Pending', 'Pending'),
('Approved', 'Approved'),
('Rejected', 'Rejected')],
max_length=20)),
('manage_request',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to='employees.LeaveRequest')),
],
),
]
class FoiLaw(models.Model):
name = models.CharField(_("Name"), max_length=255)
slug = models.SlugField(_("Slug"), max_length=255)
description = models.TextField(_("Description"), blank=True)
long_description = models.TextField(_("Website Text"), blank=True)
created = models.DateField(_("Creation Date"), blank=True, null=True)
updated = models.DateField(_("Updated Date"), blank=True, null=True)
request_note = models.TextField(_("request note"), blank=True)
meta = models.BooleanField(_("Meta Law"), default=False)
combined = models.ManyToManyField('FoiLaw', verbose_name=_("Combined Laws"), blank=True)
letter_start = models.TextField(_("Start of Letter"), blank=True)
letter_end = models.TextField(_("End of Letter"), blank=True)
jurisdiction = models.ForeignKey(Jurisdiction, verbose_name=_('Jurisdiction'),
null=True, on_delete=models.SET_NULL, blank=True)
priority = models.SmallIntegerField(_("Priority"), default=3)
url = models.CharField(_("URL"), max_length=255, blank=True)
max_response_time = models.IntegerField(_("Maximal Response Time"),
null=True, blank=True, default=30)
max_response_time_unit = models.CharField(_("Unit of Response Time"),
blank=True, max_length=32, default='day',
choices=(('day', _('Day(s)')),
('working_day', _('Working Day(s)')),
('month_de', _('Month(s) (DE)')),
))
refusal_reasons = models.TextField(
_(u"Possible Refusal Reasons, one per line, e.g §X.Y: Privacy Concerns"),
blank=True)
mediator = models.ForeignKey('PublicBody', verbose_name=_("Mediator"),
null=True, blank=True,
default=None, on_delete=models.SET_NULL,
related_name="mediating_laws")
email_only = models.BooleanField(_('E-Mail only'), default=False)
site = models.ForeignKey(Site, verbose_name=_("Site"),
null=True, on_delete=models.SET_NULL,
default=settings.SITE_ID)
class Meta:
verbose_name = _("Freedom of Information Law")
verbose_name_plural = _("Freedom of Information Laws")
def __str__(self):
return u"%s (%s)" % (self.name, self.jurisdiction)
def get_absolute_url(self):
return reverse('publicbody-foilaw-show', kwargs={'slug': self.slug})
def get_absolute_domain_url(self):
return u"%s%s" % (settings.SITE_URL, self.get_absolute_url())
@property
def letter_start_form(self):
return mark_safe(FormGenerator(self.letter_start).render_html())
@property
def letter_end_form(self):
return mark_safe(FormGenerator(self.letter_end).render_html())
def get_letter_start_text(self, post):
return FormGenerator(self.letter_start, post).render()
def get_letter_end_text(self, post):
return FormGenerator(self.letter_end, post).render()
@property
def request_note_html(self):
return markdown(self.request_note)
@property
def description_html(self):
return markdown(self.description)
def get_refusal_reason_choices(self):
not_applicable = [('n/a', _("No law can be applied"))]
if self.meta:
return (not_applicable +
[(l[0], "%s: %s" % (law.name, l[1]))
for law in self.combined.all()
for l in law.get_refusal_reason_choices()[1:]])
else:
return (not_applicable +
[(x, Truncator(x).words(12))
for x in self.refusal_reasons.splitlines()])
@classmethod
def get_default_law(cls, pb=None):
if pb:
return cls.objects.filter(jurisdiction=pb.jurisdiction).order_by('-meta')[0]
try:
return FoiLaw.objects.get(id=settings.FROIDE_CONFIG.get("default_law", 1))
except FoiLaw.DoesNotExist:
return None
def as_dict(self):
return {
"pk": self.pk, "name": self.name,
"description_html": self.description_html,
"request_note_html": self.request_note_html,
"description": self.description,
"letter_start": self.letter_start,
"letter_end": self.letter_end,
"letter_start_form": self.letter_start_form,
"letter_end_form": self.letter_end_form,
"jurisdiction": self.jurisdiction.name,
"jurisdiction_id": self.jurisdiction.id,
"email_only": self.email_only
}
def calculate_due_date(self, date=None, value=None):
if date is None:
date = timezone.now()
if value is None:
value = self.max_response_time
if self.max_response_time_unit == "month_de":
return calculate_month_range_de(date, value)
elif self.max_response_time_unit == "day":
return date + timedelta(days=value)
elif self.max_response_time_unit == "working_day":
return calculate_workingday_range(date, value)
class Migration(migrations.Migration):
initial = True
dependencies = [
]
operations = [
migrations.CreateModel(
name='Cidade',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('nome', models.CharField(max_length=80)),
('codigo_ibge', models.CharField(max_length=80)),
],
),
migrations.CreateModel(
name='Estado',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('nome', models.CharField(max_length=80)),
('codigo_ibge', models.CharField(max_length=80)),
],
options={
'verbose_name': 'Estado',
'verbose_name_plural': 'Estados',
},
),
migrations.CreateModel(
name='Unidade_de_Saude',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('nome', models.CharField(max_length=80)),
('codigo', models.CharField(max_length=10)),
('pais', models.CharField(blank=True, max_length=500)),
('cidade', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='unidade_cidade', to='core.Cidade')),
],
options={
'verbose_name': 'Unidade de Saúde',
'verbose_name_plural': 'Unidades de Saúde',
},
),
migrations.CreateModel(
name='Paciente',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('nome_completo', models.CharField(blank=True, max_length=500)),
('data_nascimento', models.DateField(blank=True, null=True)),
('sexo', models.CharField(choices=[('MASCULINO', 'Masculino'), ('FEMININO', 'Feminino'), ('IGNORADO', 'Ignorado')], max_length=50)),
('gestante', models.CharField(choices=[('1° TRIMESTE', '1° Trimestre '), ('2° TRIMESTE', '2° Trimestre'), ('3° TRIMESTE', '3° Trimestre'), ('IDADE GESTACIONAL IGNORADA', 'Idade Gestacional Ignorada'), ('NÃO', 'Não'), ('NÃO SE APLICA', 'Não se Aplica'), ('IGNORADO', 'Ignorado')], max_length=50)),
('raca', models.CharField(choices=[('NEGRA', 'Negra'), ('BRANCA', 'Branca'), ('PARDA', 'Parda'), ('INDIGENA', 'Indigena')], max_length=50)),
('escolaridade', models.CharField(choices=[('FUNDAMENTAL INCOMPLETO', 'Ensino Fundamental Incompleto'), ('FUNDAMENTAL COMPLETO', 'Ensino Fundamental Completo'), ('ENSINO_MEDIO INCOMPLETO', 'Ensino Médio Incompleto'), ('ENSINO MEDIO COMPLETO', 'Ensino Médio Completo'), ('SUPERIOR INCOMPLETO', 'Educação Superior Incompleto'), ('SUPERIOR COMPLETO', 'Educação Superior Completa'), ('IGNORADO', 'Ignorado'), ('NÃO SE APLICA', 'Não se aplica')], max_length=50)),
('numero_carta_sus', models.CharField(max_length=15)),
('nome_da_mae', models.CharField(blank=True, max_length=500)),
('distrito', models.CharField(max_length=500)),
('bairro', models.CharField(max_length=500)),
('rua', models.CharField(max_length=500)),
('numero', models.IntegerField()),
('cep', models.CharField(max_length=9)),
('ponto_referencia', models.CharField(max_length=500)),
('latitude', models.CharField(blank=True, max_length=50, null=True)),
('longitude', models.CharField(blank=True, max_length=50, null=True)),
('telefone', models.CharField(max_length=50)),
('zona', models.CharField(choices=[('URBANA', 'Urbana'), ('RURAL', 'Rural'), ('PERIURBANA', 'Periurbana'), ('IGNORADO', 'Ignorado')], max_length=50)),
('cidade', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='paciente_cidade', to='core.Cidade')),
],
),
migrations.CreateModel(
name='Endereco',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('bairro', models.CharField(max_length=500)),
('rua', models.CharField(max_length=500)),
('numero', models.IntegerField()),
('cep', models.CharField(blank=True, max_length=9, null=True)),
('cidade', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='estado_cidade', to='core.Estado')),
],
),
migrations.AddField(
model_name='cidade',
name='estado',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='cidade_estado', to='core.Estado'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='BasicRoom',
fields=[
('nome',
models.CharField(max_length=255,
primary_key=True,
serialize=False)),
],
options={
'verbose_name': 'Stanza base',
'verbose_name_plural': 'Stanze base',
'db_table': 'docs_basic_room',
},
),
migrations.CreateModel(
name='BasicPosition',
fields=[
('nome',
models.CharField(max_length=255,
primary_key=True,
serialize=False)),
('immagine',
models.FileField(blank=True, null=True, upload_to='')),
('dettaglio', models.JSONField(default=dict)),
('stanza',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='docs.basicroom')),
],
options={
'verbose_name': 'Posizione base',
'verbose_name_plural': 'Posizione base',
'db_table': 'docs_basic_position',
},
),
migrations.CreateModel(
name='BasicDoc',
fields=[
('nome',
models.CharField(max_length=255,
primary_key=True,
serialize=False)),
('file', models.FileField(blank=True, null=True,
upload_to='')),
('data', models.DateTimeField(auto_now_add=True)),
('data_documento', models.DateField(blank=True, null=True)),
('posizione',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='docs.basicposition')),
],
options={
'verbose_name': 'Documento base',
'verbose_name_plural': 'Documento base',
'db_table': 'docs_basic_doc',
},
),
]
class Country(models.Model):
""" Model for the country of origin.
"""
iso_code = models.CharField(max_length=2, unique=True, blank=False, null=False, db_index=True,
help_text='ISO 3166-1 alpha 2', validators=[MinLengthValidator(2)])
iso_code3 = models.CharField(max_length=3, unique=True, blank=False, null=False, db_index=True,
help_text='ISO 3166-1 alpha 3', validators=[MinLengthValidator(3)])
iso_num = models.CharField(max_length=3, unique=True, blank=False, null=False,
help_text='ISO 3166-1 numeric', validators=[RegexValidator('\d\d\d')])
uuid = UUIDField(auto=True, blank=False, version=1, help_text=_('unique id'), default="")
undp = models.CharField(max_length=3, unique=True, blank=True, null=True,
help_text='UNDP code', validators=[MinLengthValidator(3)])
nato3 = models.CharField(max_length=3, unique=True, blank=True, null=True,
help_text='NATO3 code', validators=[MinLengthValidator(3)])
fips = models.CharField(max_length=255, blank=True, null=True,
help_text='fips code')
itu = models.CharField(max_length=255, blank=True, null=True,
help_text='ITU code')
icao = models.CharField(max_length=255, blank=True, null=True, help_text='ICAO code')
name = models.CharField(max_length=100, db_index=True)
fullname = models.CharField(max_length=100, db_index=True)
region = models.ForeignKey(UNRegion, blank=True, null=True, default=None)
continent = models.CharField(choices=CONTINENTS, max_length=2)
currency = models.ForeignKey(Currency, blank=True, null=True)
tld = models.CharField(help_text='Internet tld', max_length=5, blank=True, null=True)
phone_prefix = models.CharField(help_text='Phone prefix number', max_length=20, blank=True, null=True)
timezone = TimeZoneField(blank=True, null=True, default=None)
expired = models.DateField(blank=True, null=True, default=None)
lat = models.DecimalField("Latitude", max_digits=18, decimal_places=12, blank=True, null=True)
lng = models.DecimalField("Longitude", max_digits=18, decimal_places=12, blank=True, null=True)
last_update = models.DateTimeField(auto_now=True)
fullname.alphabetic_filter = True
objects = CountryManager()
class Meta:
app_label = 'geo'
verbose_name_plural = _('Countries')
ordering = ['name']
def __unicode__(self):
return u"%s (%s)" % (self.fullname, self.iso_code)
def clean(self):
super(Country, self).clean()
self.iso_code = self.iso_code.upper()
self.iso_code3 = self.iso_code3.upper()
def natural_key(self):
return (self.uuid.hex, )
def __contains__(self, item):
if hasattr(item, 'country'):
return item.country.iso_code == self.iso_code
def sub(self, type):
return self.areas.filter(type__name=type)
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
('accounts', '0001_initial'),
]
operations = [
migrations.CreateModel(
name='Document',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('date', models.DateField(null=True)),
('date_removed', models.DateField(blank=True, null=True)),
('status',
models.IntegerField(choices=[
(1, 'Original held by Andreyev Lawyers'), (2, 'Removed'),
(3, 'Not Returned'),
(4, 'Transit Money held by Andreyev Lawyers')
],
null=True)),
('notes', models.TextField(blank=True, null=True)),
('nominated_type',
models.IntegerField(choices=[(1, 'Executor'), (2, 'Attorney'),
(3, 'Guardian'), (4, 'Donee'),
(5, 'Substitute Decision Maker'),
(6, 'Beneficiary'), (7, 'Other'),
(8, 'No Selection')],
null=True)),
('nominated_names', models.TextField(blank=True, null=True)),
('andrew_executor', models.BooleanField(default=True)),
('charging_clause',
models.IntegerField(choices=[(1, 'Yes - Signed'), (2, 'n/a'),
(3, 'Not returned')],
null=True)),
('contact',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='documents',
to='accounts.Contact')),
],
bases=(models.Model, sitename.mixins.UpdateAttributesMixin),
),
migrations.CreateModel(
name='DocumentType',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=256)),
],
options={
'ordering': ('name', ),
},
),
migrations.CreateModel(
name='EmailMessage',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('body', models.TextField()),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='General',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('gst_rate', models.FloatField()),
('logo', models.ImageField(upload_to='')),
('email_from_name', models.CharField(max_length=30)),
('email_from_address', models.EmailField(max_length=254)),
('smtp_server', models.CharField(max_length=30)),
('smtp_username', models.CharField(max_length=30)),
('smtp_password', models.CharField(max_length=30)),
('smtp_port', models.CharField(max_length=30)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='HistoricalPDF',
fields=[
('id',
models.IntegerField(auto_created=True,
blank=True,
db_index=True,
verbose_name='ID')),
('name', models.CharField(max_length=30)),
('pdf_type',
models.IntegerField(choices=[(1, 'Invoice'),
(2, 'My Matter report')],
db_index=True,
null=True,
verbose_name='PDF type')),
('html', models.TextField()),
('history_id',
models.AutoField(primary_key=True, serialize=False)),
('history_date', models.DateTimeField()),
('history_change_reason',
models.CharField(max_length=100, null=True)),
('history_type',
models.CharField(choices=[('+', 'Created'), ('~', 'Changed'),
('-', 'Deleted')],
max_length=1)),
('history_user',
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='+',
to=settings.AUTH_USER_MODEL)),
],
options={
'verbose_name': 'historical pdf',
'ordering': ('-history_date', '-history_id'),
'get_latest_by': 'history_date',
},
),
migrations.CreateModel(
name='Industry',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=100)),
],
options={
'verbose_name_plural': 'industries',
'ordering': ('name', ),
},
),
migrations.CreateModel(
name='InvoiceStatus',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=50)),
],
options={
'verbose_name_plural': 'Invoice statuses',
},
),
migrations.CreateModel(
name='Logo',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('logo',
models.ImageField(blank=True,
null=True,
storage=core.storage.OverwriteStorage(),
upload_to='logo/')),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='MatterSubType',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=100)),
],
options={
'ordering': ('name', ),
},
),
migrations.CreateModel(
name='MatterType',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=100)),
],
options={
'ordering': ('name', ),
},
),
migrations.CreateModel(
name='Occupation',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=100)),
],
options={
'ordering': ('name', ),
},
),
migrations.CreateModel(
name='Office',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('legal_entity', models.CharField(max_length=30)),
('abn', models.CharField(max_length=30)),
('phone', models.CharField(max_length=30)),
('web', models.CharField(max_length=30)),
('bank_account_name', models.CharField(max_length=30)),
('bank_account_bsb', models.CharField(max_length=30)),
('bank_account_number', models.CharField(max_length=30)),
('bpay_biller_code', models.CharField(max_length=30)),
('location',
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='accounts.Location')),
],
),
migrations.CreateModel(
name='PDF',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=30)),
('pdf_type',
models.IntegerField(choices=[(1, 'Invoice'),
(2, 'My Matter report')],
null=True,
unique=True,
verbose_name='PDF type')),
('html', models.TextField()),
],
),
migrations.CreateModel(
name='Section',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('number', models.CharField(max_length=256)),
('office',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='core.Office')),
],
),
migrations.AddField(
model_name='mattersubtype',
name='matter_type',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='subtypes',
to='core.MatterType'),
),
migrations.AddField(
model_name='document',
name='document_type',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='core.DocumentType'),
),
migrations.AddField(
model_name='document',
name='organisation',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='documents',
to='accounts.Organisation'),
),
migrations.AddField(
model_name='document',
name='owner',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='documents',
to=settings.AUTH_USER_MODEL),
),
migrations.AddField(
model_name='document',
name='section',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='documents',
to='core.Section'),
),
]
class Migration(migrations.Migration):
dependencies = [
('main', '0034_auto_20141204_1122'),
]
operations = [
migrations.AlterField(
model_name='contact',
name='comments',
field=models.CharField(blank=True,
max_length=255,
verbose_name='Commentaire supplémentaire'),
preserve_default=True,
),
migrations.AlterField(
model_name='contact',
name='email',
field=models.EmailField(blank=True,
max_length=75,
verbose_name='Adresse email'),
preserve_default=True,
),
migrations.AlterField(
model_name='contact',
name='first_name',
field=models.CharField(max_length=30, verbose_name='Prénom'),
preserve_default=True,
),
migrations.AlterField(
model_name='contact',
name='languages',
field=multiselectfield.db.fields.MultiSelectField(
blank=True,
max_length=8,
choices=[('fr', 'Français'), ('en', 'Anglais'),
('nl', 'Néerlandais')],
verbose_name='Langues parlées'),
preserve_default=True,
),
migrations.AlterField(
model_name='contact',
name='last_name',
field=models.CharField(max_length=30, verbose_name='Nom'),
preserve_default=True,
),
migrations.AlterField(
model_name='contact',
name='location',
field=models.CharField(blank=True,
null=True,
max_length=256,
verbose_name='Adresse'),
preserve_default=True,
),
migrations.AlterField(
model_name='contact',
name='mobile_number',
field=models.CharField(
blank=True,
validators=[
django.core.validators.RegexValidator(
regex='^\\+?1?\\d{9,15}$',
message=
"Votre numéro de téléphone doit être au format '+999999999'. Jusqu'à 15 chiffres."
)
],
max_length=16,
verbose_name='Numéro de téléphone (mobile)'),
preserve_default=True,
),
migrations.AlterField(
model_name='contact',
name='phone_number',
field=models.CharField(
blank=True,
validators=[
django.core.validators.RegexValidator(
regex='^\\+?1?\\d{9,15}$',
message=
"Votre numéro de téléphone doit être au format '+999999999'. Jusqu'à 15 chiffres."
)
],
max_length=16,
verbose_name='Numéro de téléphone (fixe)'),
preserve_default=True,
),
migrations.AlterField(
model_name='contact',
name='relationship',
field=models.CharField(
blank=True,
max_length=255,
verbose_name='Votre relation par rapport à cette personne'),
preserve_default=True,
),
migrations.AlterField(
model_name='emergencycontact',
name='first_name',
field=models.CharField(max_length=30, verbose_name='Prénom'),
preserve_default=True,
),
migrations.AlterField(
model_name='emergencycontact',
name='languages',
field=multiselectfield.db.fields.MultiSelectField(
blank=True,
max_length=8,
choices=[('fr', 'Français'), ('en', 'Anglais'),
('nl', 'Néerlandais')],
verbose_name='Langues parlées'),
preserve_default=True,
),
migrations.AlterField(
model_name='emergencycontact',
name='last_name',
field=models.CharField(max_length=30, verbose_name='Nom'),
preserve_default=True,
),
migrations.AlterField(
model_name='emergencycontact',
name='location',
field=models.CharField(blank=True,
null=True,
max_length=256,
verbose_name='Adresse'),
preserve_default=True,
),
migrations.AlterField(
model_name='emergencycontact',
name='mobile_number',
field=models.CharField(
blank=True,
validators=[
django.core.validators.RegexValidator(
regex='^\\+?1?\\d{9,15}$',
message=
"Votre numéro de téléphone doit être au format '+999999999'. Jusqu'à 15 chiffres."
)
],
max_length=16,
verbose_name='Numéro de téléphone (mobile)'),
preserve_default=True,
),
migrations.AlterField(
model_name='emergencycontact',
name='order',
field=models.IntegerField(default=0,
choices=[(1, 'A contacter en premier'),
(2, 'A contacter'),
(3, 'A contacter en dernier')],
verbose_name='Ordre de priorité'),
preserve_default=True,
),
migrations.AlterField(
model_name='emergencycontact',
name='phone_number',
field=models.CharField(
blank=True,
validators=[
django.core.validators.RegexValidator(
regex='^\\+?1?\\d{9,15}$',
message=
"Votre numéro de téléphone doit être au format '+999999999'. Jusqu'à 15 chiffres."
)
],
max_length=16,
verbose_name='Numéro de téléphone (fixe)'),
preserve_default=True,
),
migrations.AlterField(
model_name='user',
name='birth_date',
field=models.DateField(blank=True,
null=True,
verbose_name='Date de naissance'),
preserve_default=True,
),
migrations.AlterField(
model_name='user',
name='credit',
field=models.IntegerField(default=0,
verbose_name='Crédit restant'),
preserve_default=True,
),
migrations.AlterField(
model_name='user',
name='email',
field=models.EmailField(max_length=75,
verbose_name='Adresse email'),
preserve_default=True,
),
migrations.AlterField(
model_name='user',
name='first_name',
field=models.CharField(max_length=30, verbose_name='Prénom'),
preserve_default=True,
),
migrations.AlterField(
model_name='user',
name='how_found',
field=multiselectfield.db.fields.MultiSelectField(
max_length=41,
choices=[('internet', 'Internet'),
('show', 'Présentation, brochures, flyers, ...'),
('branch', 'Par une branche locale'),
('member', 'Un autre membre'),
('friends',
"Des amis ou de la famille m'en ont parlés"),
('other', 'Autre')],
verbose_name='Comment avez-vous entendu parler de Care4Care ?'
),
preserve_default=True,
),
migrations.AlterField(
model_name='user',
name='languages',
field=multiselectfield.db.fields.MultiSelectField(
blank=True,
max_length=8,
choices=[('fr', 'Français'), ('en', 'Anglais'),
('nl', 'Néerlandais')],
verbose_name='Langues parlées'),
preserve_default=True,
),
migrations.AlterField(
model_name='user',
name='last_name',
field=models.CharField(max_length=30, verbose_name='Nom'),
preserve_default=True,
),
migrations.AlterField(
model_name='user',
name='location',
field=models.CharField(blank=True,
null=True,
max_length=256,
verbose_name='Adresse'),
preserve_default=True,
),
migrations.AlterField(
model_name='user',
name='mobile_number',
field=models.CharField(
blank=True,
validators=[
django.core.validators.RegexValidator(
regex='^\\+?1?\\d{9,15}$',
message=
"Votre numéro de téléphone doit être au format '+999999999'. Jusqu'à 15 chiffres."
)
],
max_length=16,
verbose_name='Numéro de téléphone (mobile)'),
preserve_default=True,
),
migrations.AlterField(
model_name='user',
name='phone_number',
field=models.CharField(
blank=True,
validators=[
django.core.validators.RegexValidator(
regex='^\\+?1?\\d{9,15}$',
message=
"Votre numéro de téléphone doit être au format '+999999999'. Jusqu'à 15 chiffres."
)
],
max_length=16,
verbose_name='Numéro de téléphone (fixe)'),
preserve_default=True,
),
migrations.AlterField(
model_name='user',
name='status',
field=models.IntegerField(default=1,
choices=[(1, 'Actif'),
(2, 'En vacances'),
(3, 'Désactivé')]),
preserve_default=True,
),
migrations.AlterField(
model_name='user',
name='user_type',
field=models.IntegerField(
help_text=
"Un member pourra aider ou être aidé alors qu'un non-membre est un professionnel qui s'inscrira pour avoir accès aux données d'un patient. Veuillez choisir celui qui vous correspond",
default=1,
choices=[(1, 'Membre'), (2, 'Non-membre'),
(3, 'Membre vérifié')],
verbose_name='Type de compte'),
preserve_default=True,
),
migrations.AlterField(
model_name='user',
name='username',
field=models.CharField(validators=[
django.core.validators.RegexValidator(
re.compile('^[\\w.@+-]+$', 32),
"Entrez un nom d'utilisateur valide. 30 caractères ou moins. Peut contenir des lettres, nombres et les caractères @/./+/-/_ ",
'invalid')
],
max_length=30,
verbose_name="Nom d'utilisateur",
unique=True),
preserve_default=True,
),
migrations.AlterField(
model_name='verifiedinformation',
name='criminal_record',
field=models.FileField(null=True,
verbose_name='Casier judiciaire',
upload_to='documents/'),
preserve_default=True,
),
migrations.AlterField(
model_name='verifiedinformation',
name='recomendation_letter_1',
field=models.FileField(null=True,
verbose_name='Lettre de recommendation n°1',
upload_to='documents/'),
preserve_default=True,
),
migrations.AlterField(
model_name='verifiedinformation',
name='recomendation_letter_2',
field=models.FileField(null=True,
verbose_name='Lettre de recommendation n°2',
upload_to='documents/'),
preserve_default=True,
),
migrations.AlterField(
model_name='verifieduser',
name='additional_info',
field=models.TextField(
blank=True,
max_length=300,
verbose_name='Informations supplémentaires'),
preserve_default=True,
),
migrations.AlterField(
model_name='verifieduser',
name='can_wheelchair',
field=models.BooleanField(
default=False,
choices=[(True, 'Oui'),
(False, 'Non')],
verbose_name=
'Pouvez-vous transporter une chaise roulante dans votre voiture ?'
),
preserve_default=True,
),
migrations.AlterField(
model_name='verifieduser',
name='drive_license',
field=multiselectfield.db.fields.MultiSelectField(
blank=True,
max_length=11,
choices=[(1, 'Vélomoteur'), (2, 'Moto'), (3, 'Voiture'),
(4, 'Camion'), (5, 'Bus'), (6, 'Tracteur')],
verbose_name='Type de permis de conduire'),
preserve_default=True,
),
migrations.AlterField(
model_name='verifieduser',
name='have_car',
field=models.BooleanField(
default=False,
choices=[(True, 'Oui'),
(False, 'Non')],
verbose_name="Disposez-vous d'une voiture ?"),
preserve_default=True,
),
migrations.AlterField(
model_name='verifieduser',
name='hobbies',
field=models.TextField(blank=True,
max_length=200,
verbose_name='Vos hobbies'),
preserve_default=True,
),
migrations.AlterField(
model_name='verifieduser',
name='mail_preferences',
field=models.IntegerField(
default=1,
choices=[(1, 'Boite à message'), (2, 'Mail')],
verbose_name='Recevoir mes messages par'),
preserve_default=True,
),
migrations.AlterField(
model_name='verifieduser',
name='offered_job',
field=multiselectfield.db.fields.MultiSelectField(
blank=True,
max_length=21,
choices=[('1', 'Visite à la maison'), ('2', 'Tenir compagnie'),
('3', 'Transport par voiture'), ('4', 'Shopping'),
('5', 'Garder des maisons'),
('6', 'Petits boulots manuels'), ('7', 'Jardinage'),
('8', 'Garder des animaux'),
('9', 'Soins personnels'), ('a', 'Administratif'),
('b', 'Autre')],
verbose_name=
'Quelles sont les tâches que vous souhaitez effectuer ?'),
preserve_default=True,
),
migrations.AlterField(
model_name='verifieduser',
name='receive_help_from_who',
field=models.IntegerField(
default=5,
choices=[(5, 'Tous'), (3, 'Membre vérifié'),
(6, 'Mes membres favoris')],
verbose_name='Recevoir des demandes et des offres de'),
preserve_default=True,
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name="Profile",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("mobile_number", models.CharField(max_length=20)),
("pin", models.CharField(max_length=100)),
("photo", models.URLField()),
("status", models.CharField(max_length=50)),
("birthdate", models.DateField()),
("gender", models.CharField(max_length=1)),
("timestamp_created", models.DateTimeField(auto_now_add=True)),
("last_updated", models.DateTimeField(auto_now=True)),
("last_login", models.DateTimeField()),
(
"user",
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
related_name="profile_user",
to=settings.AUTH_USER_MODEL,
),
),
],
),
migrations.CreateModel(
name="VerificationCode",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("code", models.CharField(max_length=255)),
("is_verified", models.BooleanField()),
("timestamp_created", models.DateTimeField(auto_now_add=True)),
("timestamp_verified", models.DateTimeField()),
(
"sent_to",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name="verificationcode_sent_to",
to="chat_user_profile.Profile",
),
),
],
),
migrations.CreateModel(
name="Contact",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("is_blocked", models.BooleanField()),
("is_favorite", models.BooleanField()),
("timestamp_created", models.DateTimeField(auto_now_add=True)),
(
"added_by",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name="contact_added_by",
to=settings.AUTH_USER_MODEL,
),
),
(
"added_profile",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name="contact_added_profile",
to="chat_user_profile.Profile",
),
),
],
),
]
class JobPost(models.Model):
"""
Employer's job post
"""
YES = 1
NO = 2
YES_NO_CHOICES = (
(YES, 'Yes'),
(NO, 'No'),
)
JOB_OPTION_FULL_TIME = 1
JOB_OPTION_PART_TIME = 2
JOB_OPTION_FREELANCE = 3
JOB_OPTION_CHOICES = (
(JOB_OPTION_FULL_TIME, 'Full-time'),
(JOB_OPTION_PART_TIME, 'Part-time'),
(JOB_OPTION_FREELANCE, 'Freelance'),
)
SALARY_WAGE_EXPERIENCE = 1
SALARY_WAGE_NEGOTIABLE = 2
SALARY_WAGE_10_100_USD = 3
SALARY_WAGE_100_200_USD = 4
SALARY_WAGE_200_300_USD = 5
SALARY_WAGE_300_400_USD = 6
SALARY_WAGE_400_500_USD = 7
SALARY_WAGE_500_600_USD = 8
SALARY_WAGE_600_700_USD = 9
SALARY_WAGE_700_800_USD = 10
SALARY_WAGE_800_900_USD = 11
SALARY_WAGE_900_1000_USD = 12
SALARY_WAGE_1000_1500_USD = 13
SALARY_WAGE_1500_2000_USD = 14
SALARY_WAGE_2000_3000_USD = 15
SALARY_WAGE_3000_PLUS_USD = 16
SALARY_WAGE_CHOICES = (
(SALARY_WAGE_EXPERIENCE, 'Based on experience'),
(SALARY_WAGE_NEGOTIABLE, 'Negotiable'),
(SALARY_WAGE_10_100_USD, '10-100 USD'),
(SALARY_WAGE_100_200_USD, '100-200 USD'),
(SALARY_WAGE_200_300_USD, '200-300 USD'),
(SALARY_WAGE_300_400_USD, '300-400 USD'),
(SALARY_WAGE_400_500_USD, '400-500 USD'),
(SALARY_WAGE_500_600_USD, '500-600 USD'),
(SALARY_WAGE_600_700_USD, '600-700 USD'),
(SALARY_WAGE_700_800_USD, '700-800 USD'),
(SALARY_WAGE_800_900_USD, '800-900 USD'),
(SALARY_WAGE_900_1000_USD, '900-1000 USD'),
(SALARY_WAGE_1000_1500_USD, '1000-1500 USD'),
(SALARY_WAGE_1500_2000_USD, '1500-2000 USD'),
(SALARY_WAGE_2000_3000_USD, '2000-3000 USD'),
(SALARY_WAGE_3000_PLUS_USD, '3000 + USD'),
)
user = models.ForeignKey(
User,
related_name="%(class)s",
null=False
)
title = models.CharField(
_('Job Title'),
blank=False,
max_length=56,
help_text = _("Title of this job post (e.g. PHP developer, Marketing Manager)")
)
slug = models.CharField(
_('Slug'),
blank=True,
max_length=200,
help_text = _("Slug will be auto generated)")
)
description = models.TextField(
_('Job Description'),
blank=False,
validators=[MinLengthValidator(25), MaxLengthValidator(750)],
help_text = _("Detailed description of this jobs post")
)
requirements = models.TextField(
_('Job Requirements'),
blank=True,
validators=[MinLengthValidator(25), MaxLengthValidator(750)],
help_text = _("Detailed requirements for this job posts. (highly recommended)")
)
keywords = models.CharField(
_('Related Keywords, Tags'),
blank=True,
max_length=56,
help_text = _("Job related keywords that makes the job easier to find. (e.g. English Wordpress HTML CSS PHP Article)")
)
contact = models.CharField(
_('Job Contact Info'),
blank=True,
max_length=56,
help_text = _("Email or Number so jobseekers can contact you. OR leave blank to use your profile email")
)
employment_option = models.IntegerField(
_('Employment Option'),
choices=JOB_OPTION_CHOICES,
blank=False,
null=True,
help_text = _("Full-time = dedicated stuff, Part-time = shared staff, Freelance = per project")
)
wage_salary = models.IntegerField(
_('Salary'),
choices=SALARY_WAGE_CHOICES,
blank=False,
null=True,
help_text = _("Monthly salary budget for this job")
)
start_date = models.DateField(
_('Start Date'),
default=datetime.date.today(),
help_text = _("Start date. Select today for immediate start date -- format [YYYY-MM-DD]")
)
viewed = models.IntegerField(
_('Number views'),
default=0,
help_text = _("How many people have viewed this job")
)
bookmarked = models.IntegerField(
_('Number bookmarks'),
default=0,
help_text = _("How many people have bookmarked this job")
)
is_active = models.IntegerField(
_('Active'),
choices=YES_NO_CHOICES,
default=YES,
help_text = _("Yes for active jobs. No for hidden, non-active job posts")
)
created_at = models.DateTimeField(auto_now_add = True)
updated_at = models.DateTimeField(auto_now = True)
class Meta:
app_label = 'profiles'
unique_together = (("user", "title"),)
ordering = ['title',]
def __unicode__(self):
return u'%s' % self.title
def get_absolute_url(self):
return "/job/%d/%s/" % (self.id, self.get_slug)
@property
def get_slug(self):
return str(self.slug)
@property
def is_public(self):
return self.is_active == self.YES
@property
def is_past_due(self):
return datetime.date.today() >= self.start_date
def just_viewed(self):
self.viewed += 1
self.save()
return self.viewed
def set_bookmark(self, increment=True):
if increment:
self.bookmarked += 1
elif self.bookmarked > 0:
self.bookmarked -= 1
self.save()
return self.bookmarked
@property
def is_complete(self):
if self.title and self.description:
return True
return False
def save(self, *args, **kwargs):
self.slug = slugify(self.title[:100])
if not self.slug:
self.slug = 'job' # ensure no empty slug
p = self.user.get_profile()
if p.is_employer:
p.posted_jobs = True
p.save()
return super(JobPost, self).save(*args, **kwargs)
def delete(self, *args, **kwargs):
p = self.user.get_profile()
if p.is_employer:
j = JobPost.objects.filter(user=self.user)
if len(j) <= 1: # this is the last job post, and it will be deleted right now
p.posted_jobs = False
p.save()
return super(JobPost, self).delete(*args, **kwargs)
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Appointment',
fields=[
('appointment_id', models.AutoField(primary_key=True, serialize=False)),
('appointment_date', models.DateField()),
('appointment_time', models.TimeField()),
('message', models.TextField(max_length=500)),
],
),
migrations.CreateModel(
name='Doctor',
fields=[
('doctor_id', models.AutoField(primary_key=True, serialize=False)),
('firstName', models.CharField(default=False, max_length=50)),
('lastName', models.CharField(default=False, max_length=50)),
('emailAddress', models.EmailField(max_length=100)),
('specialization', models.CharField(max_length=500)),
('qualification', models.CharField(max_length=500)),
('date_created', models.DateTimeField(auto_now_add=True)),
('appointment_price', models.IntegerField(default=0)),
('profileImage', models.ImageField(null=True, upload_to='picture')),
('backgroundImage', models.ImageField(null=True, upload_to='picture')),
],
),
migrations.CreateModel(
name='Transaction',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('price', models.IntegerField()),
('date', models.DateTimeField(auto_now_add=True)),
('appointment', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to='Hospital.Appointment')),
('doctor', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Hospital.Doctor')),
('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Report',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('report_date', models.DateField(auto_now=True)),
('report_pdf', models.FileField(upload_to='reports/')),
('report_description', models.TextField(blank=True, max_length=300)),
('appointment', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Hospital.Appointment')),
('doctor', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Hospital.Doctor')),
('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Profile',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('age', models.IntegerField()),
('user_amount', models.IntegerField(default=0)),
('user_bio', models.TextField(max_length=1000, null=True)),
('userprofileImage', models.ImageField(upload_to='picture')),
('userbackgroundImage', models.ImageField(default='static/images/blank-white-page.jpg', upload_to='picture')),
('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Feedback',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('feedback', models.TextField(blank=True, max_length=200)),
('feedback_date', models.DateField(auto_now_add=True)),
('profile', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to='Hospital.Profile')),
('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
migrations.AddField(
model_name='appointment',
name='doctor',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Hospital.Doctor'),
),
migrations.AddField(
model_name='appointment',
name='user',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Category',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=30, null=True)),
],
),
migrations.CreateModel(
name='Profile',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('dob', models.DateField(null=True)),
('city', models.CharField(max_length=30, null=True)),
('address', models.CharField(max_length=50, null=True)),
('contact', models.CharField(max_length=10, null=True)),
('image', models.FileField(null=True, upload_to='')),
('user',
models.ForeignKey(null=True,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Status',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=20, null=True)),
],
),
migrations.CreateModel(
name='Send_Feedback',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('message1', models.TextField(null=True)),
('date', models.CharField(max_length=30, null=True)),
('profile',
models.ForeignKey(null=True,
on_delete=django.db.models.deletion.CASCADE,
to='grocery.Profile')),
],
),
migrations.CreateModel(
name='Product',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('image', models.FileField(null=True, upload_to='')),
('name', models.CharField(max_length=30, null=True)),
('price', models.IntegerField(null=True)),
('desc', models.TextField(null=True)),
('category',
models.ForeignKey(null=True,
on_delete=django.db.models.deletion.CASCADE,
to='grocery.Category')),
],
),
migrations.CreateModel(
name='Booking',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('book_date', models.CharField(max_length=30, null=True)),
('c_name', models.CharField(max_length=30, null=True)),
('email', models.EmailField(max_length=254, null=True)),
('contact', models.CharField(max_length=30, null=True)),
('city', models.CharField(max_length=30, null=True)),
('address', models.CharField(max_length=30, null=True)),
('pro_name', models.CharField(max_length=30, null=True)),
('price', models.IntegerField(null=True)),
('quantity', models.IntegerField(null=True)),
('total', models.IntegerField(null=True)),
('status',
models.ForeignKey(null=True,
on_delete=django.db.models.deletion.CASCADE,
to='grocery.Status')),
('user',
models.ForeignKey(null=True,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Cargo',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('criado',
models.DateField(auto_now_add=True, verbose_name='Criação')),
('modificado',
models.DateField(auto_now_add=True,
verbose_name='Atualização')),
('ativo',
models.BooleanField(default=True, verbose_name='Ativo?')),
('cargo', models.CharField(max_length=100,
verbose_name='Cargo')),
],
options={
'verbose_name': 'Cargo',
'verbose_name_plural': 'Cargos',
},
),
migrations.CreateModel(
name='Servico',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('criado',
models.DateField(auto_now_add=True, verbose_name='Criação')),
('modificado',
models.DateField(auto_now_add=True,
verbose_name='Atualização')),
('ativo',
models.BooleanField(default=True, verbose_name='Ativo?')),
('servico',
models.CharField(max_length=100, verbose_name='Serviço')),
('descricao',
models.TextField(max_length=200, verbose_name='Descricao')),
('icone',
models.CharField(choices=[('lni-cog', 'Engrenagem'),
('lni-stats-up', 'Gráfico'),
('lni-users', 'Usuários'),
('lni-layers', 'Design'),
('lni-mobile', 'Mobile'),
('lni-rocket', 'Foguete')],
max_length=20,
verbose_name='Icone')),
],
options={
'verbose_name': 'Serviço',
'verbose_name_plural': 'Serviços',
},
),
migrations.CreateModel(
name='Funcionario',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('criado',
models.DateField(auto_now_add=True, verbose_name='Criação')),
('modificado',
models.DateField(auto_now_add=True,
verbose_name='Atualização')),
('ativo',
models.BooleanField(default=True, verbose_name='Ativo?')),
('nome', models.CharField(max_length=100,
verbose_name='Nome')),
('bio', models.TextField(max_length=200, verbose_name='Bio')),
('imagem',
stdimage.models.StdImageField(upload_to='equipe',
verbose_name='Imagem')),
('facebook',
models.CharField(default='#',
max_length=100,
verbose_name='Facebook')),
('twitter',
models.CharField(default='#',
max_length=100,
verbose_name='Twitter')),
('instagram',
models.CharField(default='#',
max_length=100,
verbose_name='Instagram')),
('cargo',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='core.Cargo',
verbose_name='Cargo')),
],
options={
'verbose_name': 'Funcionário',
'verbose_name_plural': 'Funcionários',
},
),
]
class openBudgets(
models.Model
): #come back in and set appropriate fields to blank=false to force user to input information
TAX_EXEMPT = '*'
NOT_TAX_EXEMPT = ''
IN_PROGRESS = 'In Progress'
READY_TO_REVIEW = 'Ready For Review'
REVIEWED = 'Reviewed'
COMPLETE = 'Complete'
BUDGET_STATUS_CHOICES = (
(IN_PROGRESS, 'In Progress'),
(READY_TO_REVIEW, 'Ready To Review'),
(REVIEWED, 'Reviewed'),
(COMPLETE, 'Completed'),
)
# TAX_EXEMPT_CHOICES = (
#
# (TAX_EXEMPT, '*'),
# (NOT_TAX_EXEMPT, '')
#
# )
# id = models.AutoField(primary_key=True) id field is handled by django
budget_id = models.PositiveIntegerField(unique=True)
zip_code = models.PositiveIntegerField(unique=False)
# Created and revised_date fields will be auto populated
created = models.DateField(auto_now_add=True, editable=False)
project_name = models.CharField(max_length=255, unique=True)
city = models.CharField(max_length=35, unique=False)
state = models.CharField(max_length=35, unique=False)
internal_due_date = models.DateField()
external_due_date = models.DateField()
estimator = models.CharField(null=True,
blank=True,
max_length=50,
unique=False)
budget_amount = models.DecimalField(null=True,
blank=True,
max_digits=15,
decimal_places=8)
budget_complete = models.CharField(max_length=20,
choices=BUDGET_STATUS_CHOICES,
default=IN_PROGRESS)
tax_exempt_status = models.BooleanField()
revised_date = models.DateField(auto_now=True, editable=False)
general_contractor = models.CharField(max_length=50, unique=False)
# tax_exempt_status = models.CharField(
#
# max_length = 1,
# unique = False,
# choices = TAX_EXEMPT_CHOICES,
# default = NOT_TAX_EXEMPT
#
# )
def get_absolute_url(self):
"""
Returns the url to access a particular instance of a budget.
"""
return reverse('budget-detail',
args=[str(self.id)]) #budget-detail comes form URlS.py
def __str__(self):
return self.project_name
# def save(self, *args, **kwargs):
# # On save, update timestamps
# if not self.id:
# self.created = timezone.now()
# self.revised_date = timezone.now()
# return super(openBudgets, self).save(*args, **kwargs)
class Meta:
# orders data by budget_id in reverse order
ordering = ['-budget_id']
class Migration(migrations.Migration):
initial = True
dependencies = [
]
operations = [
migrations.CreateModel(
name='School',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=255)),
('alias', models.CharField(max_length=50)),
('email', models.EmailField(max_length=255)),
],
options={
'ordering': ['id'],
},
),
migrations.CreateModel(
name='Teacher',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('fullname', models.CharField(max_length=255)),
('username', models.CharField(max_length=50)),
('last_name', models.CharField(max_length=255)),
('email', models.EmailField(max_length=255)),
('likes', models.IntegerField(default=0)),
('number_of_tests', models.IntegerField(default=0)),
('number_of_lessons', models.IntegerField(default=0)),
('tested_pupils', models.IntegerField(default=0)),
('sentHomeworks', models.IntegerField(default=0)),
('school', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='accounts.school')),
],
options={
'ordering': ['id'],
},
),
migrations.CreateModel(
name='Test',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=255)),
('subject', models.CharField(max_length=255)),
('created', models.DateTimeField()),
('grade', models.CharField(choices=[('1', '1 класс'), ('2', '2 класс'), ('3', '3 класс'), ('4', '4 класс'), ('5', '5 класс'), ('6', '6 класс'), ('7', '7 класс'), ('8', '8 класс'), ('9', '9 класс'), ('10', '10 класс'), ('11', '11 класс')], max_length=255)),
('start_date', models.DateField()),
('end_date', models.DateField()),
('author', models.CharField(max_length=255)),
('duration', models.CharField(choices=[('15', '15 минут'), ('30', '30 минут'), ('60', '1 час'), ('90', '1 час 30 минут'), ('120', '2 часа'), ('150', '2 часа 30 минут'), ('180', '3 часа')], max_length=3)),
('quantity', models.CharField(choices=[('5', '5'), ('10', '10'), ('15', '15'), ('20', '20'), ('25', '25'), ('30', '30')], max_length=2)),
('left', models.IntegerField()),
('teacher', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='accounts.teacher')),
],
options={
'ordering': ['id'],
},
),
migrations.CreateModel(
name='Student',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('fullname', models.CharField(max_length=255)),
('username', models.CharField(max_length=50)),
('last_name', models.CharField(max_length=255)),
('email', models.EmailField(max_length=255)),
('grade', models.CharField(choices=[('1', '1 класс'), ('2', '2 класс'), ('3', '3 класс'), ('4', '4 класс'), ('5', '5 класс'), ('6', '6 класс'), ('7', '7 класс'), ('8', '8 класс'), ('9', '9 класс'), ('10', '10 класс'), ('11', '11 класс')], max_length=50)),
('grade_letter', models.CharField(choices=[('A', 'A'), ('Б', 'Б'), ('В', 'В'), ('Г', 'Г'), ('Д', 'Д'), ('Е', 'Е'), ('Ё', 'Ё'), ('Ж', 'Ж')], max_length=50)),
('school', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='accounts.school')),
],
options={
'ordering': ['id'],
},
),
migrations.CreateModel(
name='Question',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('question_text', models.CharField(max_length=500)),
('answer', models.CharField(choices=[('1', '1'), ('2', '2'), ('3', '3'), ('4', '4')], max_length=2)),
('test', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='accounts.test')),
],
options={
'ordering': ['id'],
},
),
migrations.CreateModel(
name='Option',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('option_text', models.CharField(max_length=255)),
('option_number', models.IntegerField()),
('question', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='accounts.question')),
],
options={
'ordering': ['id'],
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Profile',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('date_of_birth', models.DateField(blank=True, null=True)),
('photo',
models.ImageField(blank=True,
null=True,
upload_to='users/%Y/%m/%d')),
('gender',
models.CharField(choices=[('Male', 'Male'),
('female', 'female')],
default='None',
max_length=200)),
('cover_photo',
models.ImageField(blank=True,
null=True,
upload_to='users/%Y/%m/%d')),
('phone_number',
models.CharField(blank=True,
default='',
max_length=20,
null=True)),
('twitter_username',
models.CharField(blank=True,
default='',
max_length=20,
null=True)),
('facebook_username',
models.CharField(blank=True,
default='',
max_length=20,
null=True)),
('snapchat_username',
models.CharField(blank=True,
default='',
max_length=20,
null=True)),
('bio', models.TextField(blank=True, default='', null=True)),
('page_views', models.IntegerField(default=0)),
('counter', models.IntegerField(default=0)),
('subscription', models.TextField()),
('name', models.CharField(max_length=800)),
('message_counter', models.IntegerField(default=0)),
('agree_to_terms', models.BooleanField(default=True)),
('user',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Sub',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('picks', models.CharField(max_length=600)),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
('users', '0001_initial'),
('reports', '0001_initial'),
('tpmpartners', '0001_initial'),
('activities', '0001_initial'),
]
operations = [
migrations.CreateModel(
name='TPMActionPoint',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('created',
model_utils.fields.AutoCreatedField(
default=django.utils.timezone.now,
editable=False,
verbose_name='created')),
('modified',
model_utils.fields.AutoLastModifiedField(
default=django.utils.timezone.now,
editable=False,
verbose_name='modified')),
('due_date', models.DateField(verbose_name='Due Date')),
('description', models.TextField(verbose_name='Description')),
('comments',
models.TextField(blank=True, verbose_name='Comments')),
('status',
models.CharField(choices=[('open', 'Open'),
('progress', 'In-Progress'),
('completed', 'Completed'),
('cancelled', 'Cancelled')],
default='open',
max_length=9,
verbose_name='Status')),
('author',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='created_tpm_action_points',
to=settings.AUTH_USER_MODEL,
verbose_name='Assigned By')),
('person_responsible',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='tpm_action_points',
to=settings.AUTH_USER_MODEL,
verbose_name='Person Responsible')),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='TPMActivity',
fields=[
('activity_ptr',
models.OneToOneField(
auto_created=True,
on_delete=django.db.models.deletion.CASCADE,
parent_link=True,
primary_key=True,
serialize=False,
to='activities.Activity')),
('additional_information',
models.TextField(blank=True,
verbose_name='Additional Information')),
('is_pv',
models.BooleanField(default=False,
verbose_name='HACT Programmatic Visit')),
('section',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='tpm_activities',
to='reports.Sector',
verbose_name='Section')),
],
options={
'ordering': ['tpm_visit', 'id'],
'verbose_name_plural': 'TPM Activities',
},
bases=('activities.activity', ),
),
migrations.CreateModel(
name='TPMPermission',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('user_type', models.CharField(max_length=30)),
('permission',
models.CharField(choices=[('view', 'View'), ('edit', 'Edit'),
('action', 'Action')],
max_length=10)),
('permission_type',
models.CharField(choices=[('allow', 'Allow'),
('disallow', 'Disallow')],
default='allow',
max_length=10)),
('target', models.CharField(max_length=100)),
('instance_status',
models.CharField(max_length=32,
verbose_name='Instance Status')),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='TPMVisit',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('deleted_at',
models.DateTimeField(default=datetime.datetime(1970,
1,
1,
0,
0,
tzinfo=utc),
verbose_name='Deleted At')),
('created',
model_utils.fields.AutoCreatedField(
default=django.utils.timezone.now,
editable=False,
verbose_name='created')),
('modified',
model_utils.fields.AutoLastModifiedField(
default=django.utils.timezone.now,
editable=False,
verbose_name='modified')),
('status',
django_fsm.FSMField(choices=[
('draft', 'Draft'), ('assigned', 'Assigned'),
('cancelled', 'Cancelled'),
('tpm_accepted', 'TPM Accepted'),
('tpm_rejected', 'TPM Rejected'),
('tpm_reported', 'TPM Reported'),
('tpm_report_rejected', 'Sent Back to TPM'),
('unicef_approved', 'UNICEF Approved')
],
default='draft',
max_length=20,
protected=True,
verbose_name='Status')),
('reject_comment',
models.TextField(
blank=True, verbose_name='Request For More Information')),
('approval_comment',
models.TextField(blank=True,
verbose_name='Approval Comments')),
('visit_information',
models.TextField(blank=True,
verbose_name='Visit Information')),
('date_of_assigned',
models.DateField(blank=True,
null=True,
verbose_name='Date of Assigned')),
('date_of_cancelled',
models.DateField(blank=True,
null=True,
verbose_name='Date of Cancelled')),
('date_of_tpm_accepted',
models.DateField(blank=True,
null=True,
verbose_name='Date of TPM Accepted')),
('date_of_tpm_rejected',
models.DateField(blank=True,
null=True,
verbose_name='Date of TPM Rejected')),
('date_of_tpm_reported',
models.DateField(blank=True,
null=True,
verbose_name='Date of TPM Reported')),
('date_of_tpm_report_rejected',
models.DateField(blank=True,
null=True,
verbose_name='Date of Sent Back to TPM')),
('date_of_unicef_approved',
models.DateField(blank=True,
null=True,
verbose_name='Date of UNICEF Approved')),
('offices',
models.ManyToManyField(
blank=True,
related_name='tpm_visits',
to='users.Office',
verbose_name='Office(s) of UNICEF Focal Point(s)')),
('tpm_partner',
models.ForeignKey(null=True,
on_delete=django.db.models.deletion.CASCADE,
to='tpmpartners.TPMPartner',
verbose_name='TPM Vendor')),
('tpm_partner_focal_points',
models.ManyToManyField(blank=True,
related_name='tpm_visits',
to='tpmpartners.TPMPartnerStaffMember',
verbose_name='TPM Focal Points')),
('unicef_focal_points',
models.ManyToManyField(blank=True,
related_name='tpm_visits',
to=settings.AUTH_USER_MODEL,
verbose_name='UNICEF Focal Points')),
],
options={
'abstract': False,
'ordering': ('id', ),
'verbose_name': 'TPM Visit',
'verbose_name_plural': 'TPM Visits'
},
managers=[
('admin_objects', django.db.models.manager.Manager()),
],
),
migrations.CreateModel(
name='TPMVisitReportRejectComment',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('rejected_at',
models.DateTimeField(auto_now_add=True,
verbose_name='Rejected At')),
('reject_reason',
models.TextField(verbose_name='Reason of Rejection')),
('tpm_visit',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='report_reject_comments',
to='tpm.TPMVisit',
verbose_name='Visit')),
],
options={
'ordering': ['tpm_visit', 'id'],
'verbose_name_plural': 'Report Reject Comments',
},
),
migrations.AlterUniqueTogether(
name='tpmpermission',
unique_together=set([('user_type', 'instance_status', 'target',
'permission_type')]),
),
migrations.AddField(
model_name='tpmactivity',
name='tpm_visit',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='tpm_activities',
to='tpm.TPMVisit',
verbose_name='Visit'),
),
migrations.AddField(
model_name='tpmactionpoint',
name='tpm_visit',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='action_points',
to='tpm.TPMVisit',
verbose_name='Visit'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Dataset',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('title', models.TextField()),
('source', models.TextField()),
('description', models.TextField()),
('order', models.IntegerField(default=999)),
('references', django.contrib.postgres.fields.ArrayField(base_field=models.TextField(), null=True, size=None)),
('stored_at', models.CharField(choices=[('LOCAL_POSTGRES', 'Local PostgreSQL instance'), ('UBITECH_POSTGRES', "UBITECH's PostgreSQL instance at http://212.101.173.21"), ('UBITECH_PRESTO', "UBITECH's PRESTO instance"), ('UBITECH_SOLR', 'Solr instance at http://212.101.173.50:8983')], default='LOCAL_POSTGRES', max_length=32)),
('table_name', models.CharField(max_length=200)),
('private', models.BooleanField(default=False)),
('spatialEast', models.CharField(max_length=200, null=True)),
('spatialSouth', models.CharField(max_length=200, null=True)),
('spatialNorth', models.CharField(max_length=200, null=True)),
('spatialWest', models.CharField(max_length=200, null=True)),
('temporalCoverageBegin', models.DateTimeField(null=True)),
('temporalCoverageEnd', models.DateTimeField(null=True)),
('license', models.CharField(max_length=200, null=True)),
('observations', models.CharField(max_length=200, null=True)),
('publisher', models.TextField()),
('category', models.CharField(max_length=200, null=True)),
('image_uri', models.TextField(default='/static/img/logo.png')),
('sample_rows', django.contrib.postgres.fields.jsonb.JSONField(null=True)),
('number_of_rows', models.CharField(max_length=200, null=True)),
('size_in_gb', models.FloatField(null=True)),
('update_frequency', models.CharField(default='-', max_length=200)),
('last_updated', models.DateTimeField(null=True)),
('metadata', django.contrib.postgres.fields.jsonb.JSONField(default={})),
('hascoverage_img', models.BooleanField(default=False)),
('arguments', django.contrib.postgres.fields.jsonb.JSONField(default={})),
],
options={
'ordering': ['-id'],
},
),
migrations.CreateModel(
name='Organization',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('title', models.TextField()),
('description', models.TextField()),
],
),
migrations.CreateModel(
name='Vessel_Identifier',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('column_name', models.CharField(max_length=200)),
('values_list', django.contrib.postgres.fields.jsonb.JSONField()),
('dataset', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='vessel_identifiers', to='aggregator.Dataset')),
],
),
migrations.CreateModel(
name='Variable',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=256)),
('title', models.CharField(max_length=256)),
('unit', models.CharField(max_length=256)),
('description', models.TextField(null=True)),
('sameAs', models.CharField(max_length=256, null=True)),
('dataType', models.CharField(max_length=256, null=True)),
('original_column_name', models.CharField(max_length=256, null=True)),
('scale_factor', models.FloatField(default=1)),
('add_offset', models.FloatField(default=0)),
('cell_methods', django.contrib.postgres.fields.ArrayField(base_field=models.TextField(), null=True, size=None)),
('type_of_analysis', models.TextField(blank=True, default=None, null=True)),
('distribution', django.contrib.postgres.fields.ArrayField(base_field=models.FloatField(), blank=True, default=None, null=True, size=7)),
('dataset', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='variables', to='aggregator.Dataset')),
],
options={
'ordering': ['title'],
},
),
migrations.CreateModel(
name='JoinOfDatasets',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('view_name', models.CharField(max_length=100)),
('dataset_first', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='first', to='aggregator.Dataset')),
('dataset_second', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='second', to='aggregator.Dataset')),
],
),
migrations.CreateModel(
name='Dimension',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=256)),
('title', models.CharField(max_length=256)),
('unit', models.CharField(max_length=256)),
('description', models.TextField(null=True)),
('sameAs', models.CharField(max_length=256, null=True)),
('dataType', models.CharField(max_length=256, null=True)),
('original_column_name', models.CharField(max_length=256, null=True)),
('min', models.DecimalField(blank=True, decimal_places=50, default=None, max_digits=100, null=True)),
('max', models.DecimalField(blank=True, decimal_places=50, default=None, max_digits=100, null=True)),
('step', models.DecimalField(blank=True, decimal_places=50, default=None, max_digits=100, null=True)),
('axis', models.TextField(blank=True, default=None, null=True)),
('non_filterable', models.BooleanField(default=False)),
('variable', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='dimensions', to='aggregator.Variable')),
],
options={
'ordering': ['pk'],
},
),
migrations.CreateModel(
name='DatasetAccessRequest',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('status', models.CharField(choices=[('open', 'open'), ('accepted', 'accepted'), ('rejected', 'rejected')], default='open', max_length=20)),
('creation_date', models.DateTimeField(default=datetime.datetime(2020, 2, 17, 14, 50, 48, 724320))),
('response_date', models.DateTimeField(null=True)),
('resource', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='resource', to='aggregator.Dataset')),
('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='DatasetAccess',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('start', models.DateField()),
('end', models.DateField()),
('valid', models.BooleanField()),
('dataset', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='aggregator.Dataset')),
('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
migrations.AddField(
model_name='dataset',
name='access_list',
field=models.ManyToManyField(through='aggregator.DatasetAccess', to=settings.AUTH_USER_MODEL),
),
migrations.AddField(
model_name='dataset',
name='joined_with_dataset',
field=models.ManyToManyField(related_name='joined_to', through='aggregator.JoinOfDatasets', to='aggregator.Dataset'),
),
migrations.AddField(
model_name='dataset',
name='organization',
field=models.ForeignKey(default=1, on_delete=django.db.models.deletion.CASCADE, related_name='datasets', to='aggregator.Organization'),
),
migrations.AddField(
model_name='dataset',
name='owner',
field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='dataset_owner', to=settings.AUTH_USER_MODEL),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Landlord',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('address', models.CharField(max_length=255)),
('social_security_number', models.CharField(max_length=255)),
('email_address', models.EmailField(max_length=254)),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='rentalProperty',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('type_of_property_listing',
models.CharField(choices=[('APARTMENT', 'Apartment'),
('HOLIDAY_HOME', 'Holiday home'),
('SINGLE_FAMILY_HOME',
'Single family home'),
('COMMERCIAL', 'Commercial')],
default='APARTMENT',
max_length=50)),
('type_of_building_choices',
models.CharField(choices=[
('CONDOMINIUM', 'Condominium'),
('ROW_HOUSE', 'Row house'),
('SINGLE_FAMILY_HOUSE', 'Single family house'),
('HOLIDAY_HOME', 'Holiday_home'), ('DUPLEX', 'Duplex'),
('SINGLE_FAMILY_HOME_COOP', 'Single family home(CO-OP)'),
('CONDOMINIUM_EXTERNAL_ENTRANCE',
'Condominium external entrance'),
('WOODEN_COMDOMINIUM_HOUSE', 'Wooden condominium house')
],
default='CONDOMINIUM',
max_length=50)),
('created_by',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
related_name='rentalProperties',
to=settings.AUTH_USER_MODEL)),
('landlord',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
to='rental_app.Landlord')),
],
),
migrations.CreateModel(
name='rentalImages',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('apartment_pictures', models.ImageField(upload_to='')),
('rentalProperty',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
related_name='images',
to='rental_app.rentalProperty')),
],
),
migrations.CreateModel(
name='Location',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('street', models.CharField(max_length=255)),
('borough', models.CharField(max_length=255)),
('postal_code', models.CharField(max_length=20)),
('city', models.CharField(max_length=50)),
('province', models.CharField(max_length=50)),
('country', models.CharField(max_length=50)),
('rental_property',
models.OneToOneField(
on_delete=django.db.models.deletion.PROTECT,
related_name='location',
to='rental_app.rentalProperty')),
],
),
migrations.CreateModel(
name='Contract',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('type_of_rental_terms',
models.CharField(choices=[('PERMANENT', 'permanent'),
('FiXED', 'fixed')],
default='PERMANENT',
max_length=20)),
('rent_availability', models.DateField()),
('rent_availability_info', models.TextField()),
('rent_per_month', models.IntegerField()),
('deposit_for_rent', models.IntegerField()),
('deposit_for_rent_info', models.TextField()),
('rental_increment', models.IntegerField()),
('index_value', models.IntegerField()),
('index_date', models.DateField()),
('rent_electricity',
models.CharField(choices=[
('UNDEFINED', 'undefined'),
('INCLUDED_IN_THE_RENT', 'included in the rent'),
('RESPONSIBILITY_OF_TENANT', 'responsibility of tenant'),
('FIXED_FEE', 'fixed fee'), ('OTHER', 'other')
],
default='UNDEFINED',
max_length=50)),
('electricity_fixed_fee', models.IntegerField()),
('water_fee',
models.CharField(choices=[
('UNDEFINED', 'undefined'),
('INCLUDED_IN_THE_RENT', 'included in the rent'),
('RESPONSIBILITY_OF_TENANT', 'responsibility of tenant'),
('FIXED_FEE_PER_PERSON', 'fixed fee per person'),
('OTHER', 'other')
],
default='UNDEFINED',
max_length=50)),
('water_fee_per_person', models.IntegerField()),
('heating_fee',
models.CharField(choices=[
('UNDEFINED', 'undefined'),
('INCLUDED_IN_THE_RENT', 'included in the rent'),
('RESPONSIBILITY_OF_TENANT', 'responsibility of tenant'),
('FIXED_FEE', 'fixed fee'), ('OTHER', 'other')
],
default='UNDEFINED',
max_length=50)),
('heating_fixed_fee', models.IntegerField()),
('Other_cost', models.TextField()),
('pets_allowed', models.BooleanField(default=True)),
('smoking_allowed', models.BooleanField(default=True)),
('insurance_required', models.BooleanField(default=True)),
('other_terms', models.TextField()),
('rental_property',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
related_name='contracts',
to='rental_app.rentalProperty')),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
related_name='contracts',
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='ApartmentBasicInfo',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('title', models.TextField()),
('living_area', models.IntegerField()),
('number_of_rooms', models.IntegerField()),
('floors', models.IntegerField()),
('furnished', models.BooleanField(default=True)),
('type_of_kitchen_choices',
models.CharField(choices=[('UNKNOWN', 'Unknown'),
('NO_KITCHEN', 'No kitchen'),
('KITCHEN', 'Kitchen'),
('MINI_KITCHEN', 'Mini kitchen'),
('OPEN_KITCHEN', 'Open kitchen')],
default='UNKNOWN',
max_length=50)),
('sauna', models.BooleanField(default=True)),
('balcony', models.BooleanField(default=True)),
('apartment_layout_type', models.IntegerField()),
('apartment_condition',
models.CharField(choices=[('EXCELLENT', 'excellent'),
('GOOD', 'good'), ('FAIR', 'fair'),
('POOR', 'poor'),
('VERY_BAD', 'very bad')],
default='EXCELLENT',
max_length=50)),
('apartment_conditions_freetext', models.TextField()),
('rental_property',
models.OneToOneField(
on_delete=django.db.models.deletion.PROTECT,
related_name='basic_info',
to='rental_app.rentalProperty')),
],
),
]
