class Category(models.Model):
#id
code = models.TextField(blank=True, null=True)
name = models.TextField(blank=True, null=True)
def __str__(self):
return self.name
class Migration(migrations.Migration):
initial = True
dependencies = [
]
operations = [
migrations.CreateModel(
name='User',
fields=[
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')),
('username', models.CharField(max_length=64, unique=True)),
('password', models.CharField(max_length=128)),
('old_password', django.contrib.postgres.fields.ArrayField(base_field=models.CharField(blank=True, max_length=128, null=True), default=list, size=None)),
('user_type', models.CharField(default='normal_user', max_length=32)),
('phone_number', models.CharField(max_length=11, null=True, unique=True)),
('email', models.TextField(null=True, unique=True)),
('avatar_path', models.TextField(null=True)),
('remark', models.TextField(null=True)),
('create_time', models.DateTimeField(auto_now_add=True)),
('last_login_time', models.DateTimeField(null=True)),
('last_update_time', models.DateTimeField(auto_now=True)),
],
options={
'db_table': 'user',
'ordering': ['id'],
},
managers=[
('object', account.models.UserManager()),
],
),
]
class Migration(migrations.Migration):
dependencies = [
('account', '0005_auto_20200212_1307'),
]
operations = [
migrations.CreateModel(
name='Offices',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(help_text='Set office name',
max_length=32,
verbose_name='Office Name')),
('short_code',
models.CharField(
help_text='Set Short code for current office',
max_length=5,
verbose_name='Short Code')),
('address',
models.TextField(blank=True,
verbose_name='Place Affress Ofice')),
('twoGisCode',
models.TextField(blank=True,
help_text='Set 2gis code for curent place',
verbose_name='2gis site code')),
('phone',
models.CharField(blank=True,
max_length=12,
unique=True,
validators=[account.models.validate_phone],
verbose_name='Phone Number')),
('work_time_start',
models.TimeField(default=django.utils.timezone.now,
verbose_name='Work Time Start')),
('work_time_end',
models.TimeField(default=django.utils.timezone.now,
verbose_name='Work Time End')),
('return_time_start',
models.TimeField(blank=True,
default=django.utils.timezone.now,
verbose_name='Start Time Return')),
('view_on_front',
models.BooleanField(default=False,
verbose_name='view on frontend')),
],
options={
'verbose_name': 'Ofice',
'verbose_name_plural': 'Ofices',
},
),
]
class Product(PolymorphicModel):
#id
price = models.DecimalField(max_digits=8,
decimal_places=2,
blank=True,
null=True) #999,999.99
name = models.TextField(blank=True, null=True)
brand = models.TextField(blank=True, null=True)
category = models.ForeignKey('Category')
create_date = models.DateTimeField(auto_now_add=True)
modified_date = models.DateTimeField(auto_now=True)
path = models.TextField(blank=True, null=True)
desc = models.TextField(blank=True, null=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')),
('first_name', models.CharField(blank=True, max_length=255)),
('country', models.CharField(blank=True, max_length=30)),
('city', models.CharField(blank=True, max_length=30)),
('bio', models.TextField(blank=True, max_length=255)),
('image',
models.ImageField(default='static/media/default.png',
upload_to=account.models.get_image_path)),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now_add=True)),
('user',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
]
class Migration(migrations.Migration):
dependencies = [
('account', '0022_auto_20200223_1506'),
]
operations = [
migrations.CreateModel(
name='UpcomingTest',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=30)),
('date', models.DateField()),
('description',
models.TextField(blank=True, max_length=250, null=True)),
('topics',
models.FileField(
blank=True,
null=True,
upload_to=account.models.Event.test_pdf_upload_path)),
('sub_class',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='account.SubClass')),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Plan',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('title', models.CharField(max_length=128, verbose_name='title')),
('description', models.TextField(blank=True, verbose_name='description')),
('total_bandwidth', models.BigIntegerField(default=0, verbose_name='total_bandwidth')),
],
),
migrations.CreateModel(
name='Profile',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('amount_consumed_down', models.BigIntegerField(default=0, verbose_name='amount_consumed_down')),
('amount_consumed_up', models.BigIntegerField(default=0, verbose_name='amount_consumed_up')),
('active_plan', models.ForeignKey(default=account.models.get_sentinel_plan, on_delete=models.SET(account.models.get_sentinel_plan), to='account.Plan')),
('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('post', '0001_initial'),
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')),
('first_name', models.CharField(blank=True, max_length=50, null=True)),
('last_name', models.CharField(blank=True, max_length=50, null=True)),
('location', models.CharField(blank=True, max_length=50, null=True)),
('url', models.CharField(blank=True, max_length=80, null=True)),
('profile_info', models.TextField(blank=True, max_length=150, null=True)),
('created', models.DateField(auto_now_add=True)),
('picture', models.ImageField(blank=True, null=True, upload_to=account.models.user_directory_path, verbose_name='Picture')),
('favorites', models.ManyToManyField(to='post.Post')),
('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='profile', to=settings.AUTH_USER_MODEL)),
],
),
]
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')),
('img',
account.fields.AvatarImageField(
default='defaultprofile.png',
upload_to=account.models.manage_upload)),
('description', models.TextField(max_length=200)),
('actual_job', models.CharField(max_length=200)),
('phone_number', models.CharField(max_length=100)),
('user',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
options={
'permissions':
(('can_change_profile', 'Can edit the profile'), ),
},
),
]
class Migration(migrations.Migration):
dependencies = [
('account', '0005_auto_20190404_0103'),
]
operations = [
migrations.AlterField(
model_name='user',
name='description',
field=models.TextField(blank=True,
default='',
max_length=500,
null=True,
verbose_name='プロフィール文'),
),
migrations.AlterField(
model_name='user',
name='name',
field=models.CharField(max_length=50,
null=True,
verbose_name='表示名'),
),
migrations.AlterField(
model_name='user',
name='profile_banner',
field=models.ImageField(
blank=True,
default='images/default-banner.png',
null=True,
upload_to=account.models.profile_image_upload_to,
verbose_name='プロフィール背景画像'),
),
migrations.AlterField(
model_name='user',
name='profile_icon',
field=models.ImageField(
blank=True,
default='images/default-icon.png',
null=True,
upload_to=account.models.profile_image_upload_to,
verbose_name='プロフィール画像'),
),
migrations.AlterField(
model_name='user',
name='username',
field=models.CharField(
max_length=20,
unique=True,
validators=[account.validators.UsernameValidator()],
verbose_name='ユーザー名'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Account',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('password',
models.CharField(max_length=128, verbose_name='password')),
('email',
models.EmailField(max_length=60,
unique=True,
verbose_name='email')),
('username', models.CharField(max_length=30, unique=True)),
('first_name', models.CharField(max_length=20)),
('last_name', models.CharField(max_length=20)),
('about', models.TextField(blank=True, max_length=250)),
('profile_picture',
models.ImageField(blank=True,
upload_to=account.models.upload_location)),
('date_joined',
models.DateTimeField(auto_now_add=True,
verbose_name='date_joined')),
('last_login',
models.DateTimeField(auto_now=True,
verbose_name='last_login')),
('is_admin', models.BooleanField(default=False)),
('is_active', models.BooleanField(default=True)),
('is_staff', models.BooleanField(default=False)),
('is_superuser', models.BooleanField(default=False)),
('followers',
models.ManyToManyField(blank=True,
related_name='account_followers',
to=settings.AUTH_USER_MODEL)),
('following',
models.ManyToManyField(blank=True,
related_name='account_following',
to=settings.AUTH_USER_MODEL)),
],
options={
'abstract': False,
},
),
]
class Migration(migrations.Migration):
dependencies = [
('account', '0040_auto_20200316_1154'),
]
operations = [
migrations.CreateModel(
name='Archive',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('title', models.TextField(max_length=100)),
('text', models.TextField(max_length=1000)),
('date_added', models.DateField(auto_now_add=True)),
('archive_type',
models.CharField(choices=[('submission', 'Submission'),
('private', 'Private')],
default='private',
max_length=30)),
('pdf',
models.FileField(
blank=True,
null=True,
upload_to=account.models.Archive.pdf_upload_archive_path)
),
('author',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='account.Userprofile')),
('sub_class',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='account.SubClass')),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
('auth', '0011_update_proxy_permissions'),
]
operations = [
migrations.CreateModel(
name='Student',
fields=[
('student',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
primary_key=True,
serialize=False,
to=settings.AUTH_USER_MODEL)),
('institute', models.CharField(max_length=50)),
('image',
models.FileField(default='profile_img/user.png',
null=True,
upload_to=account.models.get_image_name)),
('interests', models.CharField(max_length=50)),
],
),
migrations.CreateModel(
name='Teacher',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('image',
models.FileField(default='profile_img/user.png',
null=True,
upload_to=account.models.get_image_name1)),
('institute', models.CharField(max_length=50)),
('qualifications', models.CharField(max_length=50)),
('status', models.CharField(max_length=50)),
('work_experience', models.TextField(blank=True, null=True)),
('teacher',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0011_update_proxy_permissions'),
]
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 address')),
('is_staff', models.BooleanField(default=False, help_text='Designates whether the user can log into this admin site.', verbose_name='staff status')),
('is_active', models.BooleanField(default=True, help_text='Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')),
('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')),
('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',
},
),
migrations.CreateModel(
name='Profile',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=150, verbose_name='first name')),
('username', models.CharField(blank=True, max_length=30, null=True, unique=True)),
('photo', models.ImageField(blank=True, null=True, upload_to='profile_photo/')),
('gender', models.CharField(blank=True, choices=[('male', 'Male'), ('female', 'Female')], max_length=6, null=True)),
('about', models.TextField(blank=True, null=True)),
('phone_number', models.CharField(blank=True, max_length=11, null=True, unique=True)),
('facebook', models.URLField(blank=True, null=True)),
('twitter', models.URLField(blank=True, null=True)),
('linkedin', models.URLField(blank=True, null=True)),
('instagram', models.URLField(blank=True, null=True)),
('github', models.URLField(blank=True, null=True)),
('youtube', models.URLField(blank=True, null=True)),
('date', models.DateTimeField(auto_now_add=True)),
('user', models.OneToOneField(default=account.models.get_current_user, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0011_update_proxy_permissions'),
]
operations = [
migrations.CreateModel(
name='SIG',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(choices=[('Crypt', 'CRYPT'), ('Charge', 'CHARGE'), ('Credit', 'CREDIT'), ('Chronicle', 'CHRONICLE'), ('Clutch', 'CLUTCH'), ('Concrete', 'CONCRETE'), ('Create', 'CREATE'), ('Catalyst', 'CATALYST')], max_length=9)),
('description', models.TextField(default='', max_length=10000)),
],
),
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')),
('username', models.CharField(error_messages={'unique': 'A user with that username already exists.'}, help_text='Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[django.contrib.auth.validators.UnicodeUsernameValidator()], verbose_name='username')),
('first_name', models.CharField(blank=True, max_length=30, verbose_name='first name')),
('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')),
('email', models.EmailField(blank=True, max_length=254, verbose_name='email address')),
('is_staff', models.BooleanField(default=False, help_text='Designates whether the user can log into this admin site.', verbose_name='staff status')),
('is_active', models.BooleanField(default=True, help_text='Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')),
('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')),
('phone_number', models.CharField(blank=True, max_length=17, validators=[django.core.validators.RegexValidator(message="Phone number must be entered in the format: '+999999999'. Up to 15 digits allowed.", regex='^\\+?1?\\d{9,15}$')])),
('avatar', models.ImageField(blank=True, upload_to=account.models.user_avatar_path)),
('batch_of', models.IntegerField(default=2020)),
('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')),
('sigs', models.ManyToManyField(to='account.SIG')),
('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',
'abstract': False,
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
]
class Sales(models.Model):
user = models.ForeignKey('account.FomoUser', null=True)
date = models.DateTimeField(auto_now=True, null=True)
shipping_address = models.TextField(blank=False, null=False)
total_cost = models.DecimalField(max_digits=6, decimal_places=2)
@staticmethod
def record_sale(user, cart_items, address, stripe_token, sale_id):
sale = Sales()
sale.user = user
sale.shipping_address = address
sale.total_cost = SaleItems.calc_total()
sale.save()
saleItem = SaleItems()
for s in cart_items:
saleItem.product = s.product
saleItem.sale = sale
saleItem.quantity_purchased = s.quantity
saleItem.sale_price = s.product.price
saleItem.tax = round(s.product.price * Decimal(.075), 2)
saleItem.shipping_cost = 10
saleItem.save()
payment = Payment()
payment.sale = sale
payment.stripe_token = stripe_token
payment.amount = sale.total_cost
payment.save()
for s in cart_items:
product = Product.objects.get(id=s.product.id)
if hasattr(s.product, 'quantity'):
product.quantity -= s.quantity
elif hasattr(s.product, 'active'):
product.active = False
product.save()
sale_id['value'] = sale.id
class Migration(migrations.Migration):
dependencies = [
('account', '0001_initial'),
]
operations = [
migrations.AlterModelManagers(
name='user',
managers=[
('objects', account.models.UserManage()),
],
),
migrations.CreateModel(
name='Token',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('created',
models.DateTimeField(auto_now_add=True,
verbose_name='create time')),
('expired',
models.DateTimeField(
default=account.models._default_expire_time,
verbose_name='token expire time')),
('token', models.TextField(blank=True, verbose_name='token')),
('user',
models.ForeignKey(null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='tokens',
to=settings.AUTH_USER_MODEL,
verbose_name='User')),
],
options={
'verbose_name': 'Token',
'verbose_name_plural': 'Tokens',
'ordering': ('user', ),
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0008_alter_user_username_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 address')),
('first_name', models.CharField(blank=True, default='', max_length=255, verbose_name='first name')),
('last_name', models.CharField(blank=True, default='', max_length=255, verbose_name='last name')),
('date_joined', models.DateTimeField(default=utils.dates.utcnow, verbose_name='date joined')),
('is_active', models.BooleanField(default=True, verbose_name='active')),
('is_staff', models.BooleanField(default=False, help_text='Designates whether the user can log into this admin site.', verbose_name='staff status')),
('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', account.models.UserManager()),
],
),
migrations.CreateModel(
name='OutlookUser',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('unique_identifier', models.TextField()),
('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),
]
operations = [
migrations.CreateModel(
name='Order',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('profile_name', models.CharField(max_length=200)),
('profile_email', models.CharField(max_length=200)),
('profile_amount', models.IntegerField()),
('date', models.DateTimeField(blank=True, default=datetime.datetime.now)),
],
),
migrations.CreateModel(
name='Profile',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('username', models.CharField(max_length=200)),
('email', models.EmailField(max_length=254)),
('password', models.CharField(max_length=100)),
('note', models.TextField(blank=True, help_text='Want to say something to customer', max_length=500)),
('is_allowed', models.BooleanField(default=False)),
('amount', models.IntegerField(default=5, help_text='Enter amount in dollars')),
('drive_url', models.CharField(blank=True, max_length=200)),
('stripe_id', models.CharField(blank=True, max_length=120, null=True)),
('image1', models.ImageField(blank=True, null=True, upload_to=account.models.upload_location)),
('image2', models.ImageField(blank=True, null=True, upload_to=account.models.upload_location)),
('image3', models.ImageField(blank=True, null=True, upload_to=account.models.upload_location)),
('image4', models.ImageField(blank=True, null=True, upload_to=account.models.upload_location)),
('user', models.OneToOneField(editable=False, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='profile', to=settings.AUTH_USER_MODEL)),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Post',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('photo', models.ImageField(editable=False, upload_to=account.models.image_file_path)),
('text', models.TextField(blank=True, max_length=500)),
('location', models.CharField(blank=True, max_length=30)),
('posted_on', models.DateTimeField(auto_now_add=True)),
('author', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='user_posts', to=settings.AUTH_USER_MODEL)),
('likes', models.ManyToManyField(blank=True, related_name='likers', to=settings.AUTH_USER_MODEL)),
],
options={
'ordering': ['-posted_on'],
},
),
migrations.CreateModel(
name='Comment',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('text', models.CharField(max_length=100)),
('posted_on', models.DateTimeField(auto_now_add=True)),
('author', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='user_comments', to=settings.AUTH_USER_MODEL)),
('post', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='post_comments', to='main.post')),
],
options={
'ordering': ['-posted_on'],
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Account',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('about', models.TextField(blank=True)),
('updated_on', models.DateTimeField(auto_now=True)),
('user_pic', models.ImageField(blank=True, default='user_pic_male.png', upload_to=account.models.user_directory_path)),
('phone', models.CharField(blank=True, max_length=15)),
('status', models.IntegerField(choices=[(0, 'Blocked'), (1, 'Active'), (2, 'Limited')], default=1)),
('gender', models.IntegerField(choices=[(1, 'Male'), (2, 'Female')], default=1, verbose_name='Gender')),
('role', models.CharField(choices=[('admin', 'Admin'), ('user', 'User')], default='user', max_length=10, verbose_name='Role')),
('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='profile', to=settings.AUTH_USER_MODEL)),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Notification',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('text', models.TextField(verbose_name='Notifictation text')),
('seen', models.BooleanField(verbose_name='Seen')),
('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='StudentField',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('title', models.CharField(max_length=255)),
],
),
migrations.CreateModel(
name='UserProfile',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('student_id', models.IntegerField()),
('avatar', models.ImageField(default='/avatars/default.jpg', upload_to=account.models.handle_avatar_upload_path)),
('field', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='account.StudentField')),
('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='profile', to=settings.AUTH_USER_MODEL)),
],
),
]
class Migration(migrations.Migration):
replaces = [('account', '0001_initial'), ('account', '0002_user_is_staff'), ('account', '0003_auto_20200501_1155'), ('account', '0004_auto_20200507_1451'), ('account', '0005_auto_20200507_1504'), ('account', '0006_auto_20200507_1504'), ('account', '0007_delete_visibility'), ('account', '0008_auto_20200713_0955'), ('account', '0009_auto_20200728_0537'), ('account', '0010_auto_20200728_0544')]
initial = True
dependencies = [
('auth', '0011_update_proxy_permissions'),
]
operations = [
migrations.CreateModel(
name='User',
fields=[
('password', models.CharField(max_length=128, verbose_name='password')),
('is_superuser', models.BooleanField(default=False, help_text='Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')),
('gid', models.CharField(max_length=16, unique=True, verbose_name='GID')),
('student_id', models.CharField(max_length=10, unique=True, verbose_name='学号')),
('real_name', models.CharField(max_length=16, verbose_name='真实姓名')),
('nick_name', models.CharField(max_length=64, verbose_name='昵称')),
('email', models.EmailField(max_length=254, null=True, unique=True, verbose_name='Email')),
('phone', models.CharField(blank=True, max_length=32, verbose_name='手机号')),
('profile', models.TextField(blank=True, verbose_name='个人简介')),
('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='注册时间')),
('last_login', models.DateTimeField(blank=True, null=True, verbose_name='上次登录时间')),
('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')),
('is_staff', models.BooleanField(default=False, help_text='对 admin/ 管理页的只读权限', verbose_name='staff status')),
('id', models.AutoField(auto_created=True, default=1, primary_key=True, serialize=False, verbose_name='ID')),
('avatar', models.ImageField(blank=True, upload_to=account.models.user_avatar_path, verbose_name='头像')),
],
options={
'abstract': False,
},
),
]
class UniqueProduct(Product):
#id
serial_number = models.TextField(blank=True, null=True)
active = models.BooleanField(default=True)
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Reason',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('name', models.CharField(default='', max_length=200)),
],
),
migrations.CreateModel(
name='ref_barangay',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('brgyCode', models.CharField(max_length=50, unique=True)),
('name', models.TextField()),
],
options={
'verbose_name': 'Barangay',
'verbose_name_plural': 'Barangays',
},
),
migrations.CreateModel(
name='ref_region',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('psgcCode', models.CharField(max_length=50, unique=True)),
('name', models.TextField()),
('regCode', models.CharField(max_length=50, unique=True)),
],
options={
'verbose_name': 'Region',
'verbose_name_plural': 'Regions',
},
),
migrations.CreateModel(
name='Relationship',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('name', models.CharField(default='', max_length=50)),
('is_owner', models.BooleanField(default=False)),
],
),
migrations.CreateModel(
name='ref_purok',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('name', models.CharField(default='', max_length=50)),
('president', models.CharField(blank=True, default='', max_length=50, null=True)),
('barangay', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='ref_barangay_id', to='account.ref_barangay')),
],
),
migrations.CreateModel(
name='ref_province',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('psgcCode', models.CharField(max_length=50, unique=True)),
('name', models.TextField()),
('provCode', models.CharField(max_length=50, unique=True)),
('f_region', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='account.ref_region', to_field='regCode')),
('region', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='ref_region_id', to='account.ref_region')),
],
options={
'verbose_name': 'Province',
'verbose_name_plural': 'Provinces',
},
),
migrations.CreateModel(
name='ref_citymun',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('psgcCode', models.CharField(max_length=50, unique=True)),
('name', models.TextField()),
('citymunCode', models.CharField(max_length=50, unique=True)),
('f_province', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='account.ref_province', to_field='provCode')),
('province', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='ref_province_id', to='account.ref_province')),
],
options={
'verbose_name': 'City/Municipality',
'verbose_name_plural': 'Cities and Municipalities',
},
),
migrations.AddField(
model_name='ref_barangay',
name='citymun',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='ref_citymun_id', to='account.ref_citymun'),
),
migrations.AddField(
model_name='ref_barangay',
name='f_citymun',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='account.ref_citymun', to_field='citymunCode'),
),
migrations.CreateModel(
name='household_profile',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('phone_number', models.CharField(max_length=10, unique=True)),
('date_of_birth', models.DateField()),
('gender', models.BooleanField(choices=[(0, 'Male'), (1, 'Female')], default=0)),
('street', models.CharField(max_length=150)),
('verification_file', models.FileField(help_text='Select File', null=True, upload_to=account.models.filename_generator)),
('profile', models.FileField(help_text='Select File', null=True, upload_to=account.models.filename_generator)),
('account_is_verified', models.IntegerField(choices=[(0, 'Pending'), (1, 'Verified')], default=0)),
('date_created', models.DateField(default=datetime.date.today)),
('purok', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='account.ref_purok')),
('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='family_members',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('first_name', models.CharField(max_length=150)),
('last_name', models.CharField(max_length=150)),
('date_of_birth', models.DateField()),
('verification_file', models.FileField(help_text='Select documents', upload_to=account.models.filename_generator)),
('profile', models.FileField(help_text='Select File', null=True, upload_to=account.models.filename_generator)),
('gender', models.BooleanField(choices=[(0, 'Male'), (1, 'Female')], default=0)),
('is_confirm', models.IntegerField(choices=[(0, 'Pending'), (1, 'Approved'), (2, 'decline')], default=0)),
('date_added', models.DateField(default=datetime.date.today)),
('household_profile', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='account.household_profile')),
('relationship', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='account.Relationship')),
],
),
migrations.CreateModel(
name='building_owner',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('establishment_name', models.TextField()),
('street', models.CharField(max_length=150)),
('verification_file', models.FileField(help_text='Select File', upload_to=account.models.filename_generator)),
('profile', models.FileField(help_text='Select File', null=True, upload_to=account.models.filename_generator)),
('account_is_verified', models.IntegerField(choices=[(0, 'Pending'), (1, 'Verified')], default=0)),
('date_created', models.DateField(default=datetime.date.today)),
('is_confirm', models.IntegerField(choices=[(0, 'Pending'), (1, 'Approved'), (2, 'decline')], default=0)),
('purok', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='account.ref_purok')),
('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0008_alter_user_username_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')),
('username',
models.CharField(max_length=255,
unique=True,
verbose_name='Username')),
('email',
models.EmailField(blank=True,
max_length=254,
null=True,
verbose_name='Email')),
('gpg_fingerprint',
models.CharField(blank=True, max_length=40, null=True)),
('registered', models.DateTimeField(auto_now_add=True)),
('registration_method',
models.SmallIntegerField(choices=[(0, 'Via Website'),
(1, 'In-Band Registration'),
(2, 'Manually'),
(9, 'Unknown')],
default=0)),
('confirmed', models.DateTimeField(blank=True, null=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_plural': 'users',
'verbose_name': 'user',
'abstract': False,
},
),
migrations.CreateModel(
name='Confirmation',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('created', models.DateTimeField(auto_now_add=True)),
('updated', models.DateTimeField(auto_now=True)),
('to',
models.EmailField(blank=True,
max_length=254,
null=True,
verbose_name='Recipient')),
('key',
models.CharField(default=account.models.default_key,
max_length=40)),
('expires',
models.DateTimeField(default=account.models.default_expires)),
('purpose',
models.CharField(blank=True, max_length=16, null=True)),
('payload',
jsonfield.fields.JSONField(
default=account.models.default_payload)),
('language', models.CharField(max_length=2)),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='confirmations',
to=settings.AUTH_USER_MODEL)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='GpgKey',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('created', models.DateTimeField(auto_now_add=True)),
('updated', models.DateTimeField(auto_now=True)),
('fingerprint', models.CharField(max_length=40)),
('key', models.TextField()),
('expires', models.DateTimeField(blank=True, null=True)),
('revoked', models.BooleanField(default=False)),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='gpg_keys',
to=settings.AUTH_USER_MODEL)),
],
options={
'verbose_name_plural': 'GPG keys',
'verbose_name': 'GPG key',
},
),
migrations.CreateModel(
name='UserLogEntry',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('created', models.DateTimeField(auto_now_add=True)),
('updated', models.DateTimeField(auto_now=True)),
('address', models.GenericIPAddressField(null=True)),
('message', models.TextField()),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='log_entries',
to=settings.AUTH_USER_MODEL)),
],
options={
'verbose_name_plural': 'User activity logs',
'verbose_name': 'User activity log',
},
),
migrations.AlterUniqueTogether(
name='gpgkey',
unique_together=set([('user', 'fingerprint')]),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Customer',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('fund',
models.CharField(default=0, max_length=100,
verbose_name='余额')),
],
),
migrations.CreateModel(
name='Seller',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('phone', models.CharField(max_length=50, verbose_name='电话')),
('fund',
models.CharField(default=0, max_length=100,
verbose_name='余额')),
('store_status',
models.BooleanField(default=False, verbose_name='商店状态')),
('address',
models.CharField(blank=True, max_length=40,
verbose_name='地址')),
],
),
migrations.CreateModel(
name='UserAll',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=20, verbose_name='姓名')),
('password', models.TextField()),
('email', models.EmailField(max_length=254,
verbose_name='邮箱')),
('avatar',
models.ImageField(
blank=True,
default='timg.jpg',
upload_to=account.models.user_dictionary_path,
verbose_name='头像')),
('identity',
models.CharField(choices=[('s', '商家'), ('c', '买家')],
max_length=1,
null=True,
verbose_name='身份')),
],
),
migrations.AddField(
model_name='seller',
name='person',
field=models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to='account.UserAll'),
),
migrations.AddField(
model_name='customer',
name='person',
field=models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to='account.UserAll'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0011_update_proxy_permissions'),
]
operations = [
migrations.CreateModel(
name='Offices',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(help_text='Set office name', max_length=32, verbose_name='Office Name')),
('short_code', models.CharField(help_text='Set Short code for current office', max_length=5, verbose_name='Short Code')),
('address', models.TextField(blank=True, verbose_name='Place Affress Ofice')),
('twoGisCode', models.TextField(blank=True, help_text='Set 2gis code for curent place', verbose_name='2gis site code')),
('phone', models.CharField(blank=True, max_length=12, unique=True, validators=[account.models.validate_phone], verbose_name='Phone Number')),
('work_time_start', models.TimeField(default=django.utils.timezone.now, verbose_name='Work Time Start')),
('work_time_end', models.TimeField(default=django.utils.timezone.now, verbose_name='Work Time End')),
('return_time_start', models.TimeField(blank=True, default=django.utils.timezone.now, verbose_name='Start Time Return')),
('view_on_front', models.BooleanField(default=False, verbose_name='view on frontend')),
],
options={
'verbose_name': 'Ofice',
'verbose_name_plural': 'Ofices',
},
),
migrations.CreateModel(
name='CustomUser',
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')),
('first_name', models.CharField(blank=True, max_length=30, verbose_name='first name')),
('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')),
('is_staff', models.BooleanField(default=False, help_text='Designates whether the user can log into this admin site.', verbose_name='staff status')),
('is_active', models.BooleanField(default=True, help_text='Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')),
('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')),
('email', models.EmailField(max_length=254, unique=True, verbose_name='email address')),
('middle_name', models.CharField(blank=True, max_length=32, verbose_name='Middle name')),
('phone', models.CharField(max_length=12, unique=True, validators=[account.models.validate_phone], verbose_name='Phone Number')),
('address', models.CharField(blank=True, max_length=64, verbose_name='Address')),
('position', models.IntegerField(choices=[(1, 'administrator'), (2, 'master'), (3, 'manager')], default=2, verbose_name='Position in company')),
('birth_to_day', models.DateField(blank=True, null=True, verbose_name='User BirthDay')),
('avatar', models.ImageField(default='../static/images/avatar/women.jpg', upload_to='users/', verbose_name='Photo')),
('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',
'ordering': ('last_name',),
},
),
migrations.CreateModel(
name='WorkStation',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('host', models.CharField(max_length=64, verbose_name='host name')),
('ip_address', models.CharField(max_length=16, verbose_name='ip_address')),
('office', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='account.Offices')),
],
options={
'verbose_name': 'Work Station',
'verbose_name_plural': 'Work Stations',
'unique_together': {('host', 'ip_address')},
},
),
]
class ProductPicture(models.Model):
product = models.ForeignKey('Product')
path = models.TextField()
class RentalProduct(Product):
#id
serial_number = models.TextField(blank=True, null=True)
quantity = models.IntegerField(default=1)
