class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Course',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=255)),
('teacher', models.CharField(max_length=100)),
],
),
migrations.CreateModel(
name='Student',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=30, null=True)),
('surname', models.CharField(max_length=30, null=True)),
('room', models.IntegerField(null=True)),
('email', models.EmailField(max_length=254, null=True)),
('description', models.TextField(default='')),
('photo',
models.FileField(null=True,
upload_to=crm.models.get_file_path)),
('course',
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='crm.Course')),
],
),
migrations.CreateModel(
name='Comments',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('text', models.TextField(default='')),
('student',
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='crm.Student')),
],
),
]
class Migration(migrations.Migration):
dependencies = [
('crm', '0007_auto_20201127_2059'),
]
operations = [
migrations.CreateModel(
name='CandidateApplication',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('status',
models.IntegerField(choices=[(0, 'Сайт'), (1, 'HeadHunter'),
(2, 'SuperJob')],
default=0)),
('cv_file',
models.FileField(blank=True, null=True, upload_to='')),
('cv_recognition', models.TextField(blank=True, null=True)),
('created',
models.DateTimeField(default=crm.models.default_time)),
('core_condidate',
models.ForeignKey(blank=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='condidate_applicatin',
to='crm.candidate')),
('core_vacancy',
models.ForeignKey(blank=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='vacancy_applicatin',
to='crm.vacancy')),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Client',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('phone', models.CharField(max_length=32)),
('ssn', models.CharField(max_length=32)),
('company_name', models.CharField(max_length=32)),
('company_id', models.CharField(max_length=32)),
('address', models.CharField(max_length=32)),
('user',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='MediaContent',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('code', models.CharField(max_length=32)),
('media_file',
models.FileField(upload_to=crm.models.user_directory_path)),
('media_length', models.DurationField()),
],
),
migrations.CreateModel(
name='ScreenSpecifications',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('code', models.CharField(max_length=30)),
('size', models.IntegerField()),
],
),
migrations.CreateModel(
name='Screen',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('default_content',
models.ForeignKey(null=True,
on_delete=django.db.models.deletion.CASCADE,
to='crm.mediacontent')),
('screen_client',
models.OneToOneField(
default=None,
on_delete=django.db.models.deletion.CASCADE,
related_name='machine',
to='crm.client')),
('screen_owner',
models.ForeignKey(default=None,
on_delete=django.db.models.deletion.CASCADE,
related_name='screens',
to='crm.client')),
('specification',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='crm.screenspecifications')),
],
),
migrations.CreateModel(
name='Match',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('start', models.DateField()),
('end', models.DateField()),
('frequency', models.IntegerField()),
('price', models.IntegerField()),
('advertiser',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='matching_screens',
to='crm.client')),
('screen_owner',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='matchings_adds',
to='crm.client')),
],
),
migrations.CreateModel(
name='Contract',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('start', models.DateField()),
('end', models.DateField()),
('owner',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='crm.client')),
],
),
migrations.CreateModel(
name='Advertisement',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('advertiser',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='crm.client')),
('media_content',
models.ForeignKey(null=True,
on_delete=django.db.models.deletion.CASCADE,
to='crm.mediacontent')),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0008_alter_user_username_max_length'),
]
operations = [
migrations.CreateModel(
name='UserProfile',
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.EmailField(max_length=255, unique=True)),
('is_staff',
models.BooleanField(
default=False,
help_text=
'Designates whether the user can log into this admin site.',
verbose_name='staff status')),
('is_admin', models.BooleanField(default=False)),
('name', models.CharField(max_length=32, verbose_name='名字')),
('mobile',
models.CharField(blank=True,
default=None,
max_length=32,
null=True,
verbose_name='手机')),
('memo',
models.TextField(blank=True,
default=None,
null=True,
verbose_name='备注')),
('date_joined', models.DateTimeField(auto_now_add=True)),
],
options={
'verbose_name': '账户信息',
'verbose_name_plural': '账户信息',
},
managers=[
('objects', crm.models.UserManager()),
],
),
migrations.CreateModel(
name='Campuses',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=64, verbose_name='校区')),
('address',
models.CharField(blank=True,
max_length=512,
null=True,
verbose_name='详细地址')),
],
),
migrations.CreateModel(
name='ClassList',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('course',
models.CharField(choices=[('LinuxL', 'Linux中高级'),
('PythonFullStack', 'Python高级全栈开发')
],
max_length=64,
verbose_name='课程名称')),
('semester', models.IntegerField(verbose_name='学期')),
('price', models.IntegerField(default=10000,
verbose_name='学费')),
('memo',
models.CharField(blank=True,
max_length=100,
null=True,
verbose_name='说明')),
('start_date', models.DateField(verbose_name='开班日期')),
('graduate_date',
models.DateField(blank=True, null=True, verbose_name='结业日期')),
('class_type',
models.CharField(blank=True,
choices=[('fulltime', '脱产班'),
('online', '网络班'),
('weekend', '周末班')],
max_length=64,
null=True,
verbose_name='班额及类型')),
('campuses',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='crm.Campuses',
verbose_name='校区')),
],
),
migrations.CreateModel(
name='ConsultRecord',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('note', models.TextField(verbose_name='跟进内容...')),
('status',
models.CharField(choices=[('A', '近期无报名计划'), ('B', '1个月内报名'),
('C', '2周内报名'), ('D', '1周内报名'),
('E', '定金'), ('F', '到班'),
('G', '全款'), ('H', '无效')],
help_text='选择客户此时的状态',
max_length=8,
verbose_name='跟进状态')),
('date',
models.DateTimeField(auto_now_add=True, verbose_name='跟进日期')),
('delete_status',
models.BooleanField(default=False, verbose_name='删除状态')),
('consultant',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='records',
to=settings.AUTH_USER_MODEL,
verbose_name='跟进人')),
],
),
migrations.CreateModel(
name='ContractTemplate',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(max_length=128,
unique=True,
verbose_name='合同名称')),
('content', models.TextField(verbose_name='合同内容')),
('date', models.DateField(auto_now=True)),
],
),
migrations.CreateModel(
name='CourseRecord',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('day_num',
models.IntegerField(help_text='此处填写第几节课或第几天课程...,必须为数字',
verbose_name='节次')),
('date',
models.DateField(auto_now_add=True, verbose_name='上课日期')),
('course_title',
models.CharField(blank=True,
max_length=64,
null=True,
verbose_name='本节课程标题')),
('course_memo',
models.TextField(blank=True,
max_length=300,
null=True,
verbose_name='本节课程内容')),
('has_homework',
models.BooleanField(default=True, verbose_name='本节有作业')),
('homework_title',
models.CharField(blank=True,
max_length=64,
null=True,
verbose_name='本节作业标题')),
('homework_memo',
models.TextField(blank=True,
max_length=500,
null=True,
verbose_name='作业描述')),
('scoring_point',
models.TextField(blank=True,
max_length=300,
null=True,
verbose_name='得分点')),
('re_class',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='crm.ClassList',
verbose_name='班级')),
('teacher',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL,
verbose_name='讲师')),
],
),
migrations.CreateModel(
name='Customer',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('qq',
models.CharField(help_text='QQ号必须唯一',
max_length=64,
unique=True,
verbose_name='QQ')),
('qq_name',
models.CharField(blank=True,
max_length=64,
null=True,
verbose_name='QQ昵称')),
('name',
models.CharField(blank=True,
help_text='学员报名后，请改为真实姓名',
max_length=32,
null=True,
verbose_name='姓名')),
('sex',
models.CharField(blank=True,
choices=[('male', '男'), ('female', '女')],
default='male',
max_length=16,
null=True,
verbose_name='性别')),
('birthday',
models.DateField(blank=True,
default=None,
help_text='格式yyyy-mm-dd',
null=True,
verbose_name='出生日期')),
('phone',
models.BigIntegerField(blank=True,
null=True,
verbose_name='手机号')),
('source',
models.CharField(choices=[('qq', 'qq群'),
('referral', '内部转介绍'),
('website', '官方网站'),
('baidu_ads', '百度推广'),
('office_direct', '直接上门'),
('WoM', '口碑'),
('public_class', '公开课'),
('website_luffy', '路飞官网'),
('others', '其它')],
default='qq',
max_length=64,
verbose_name='客户来源')),
('class_type',
models.CharField(choices=[('fulltime', '脱产班'),
('online', '网络班'),
('weekend', '周末班')],
default='fulltime',
max_length=64,
verbose_name='班级类型')),
('customer_note',
models.TextField(blank=True, null=True, verbose_name='客户备注')),
('status',
models.CharField(choices=[('signed', '已报名'),
('unregistered', '未报名'),
('studying', '学习中'),
('paid_in_full', '学费已交齐')],
default='unregistered',
help_text='选择客户此时的状态',
max_length=64,
verbose_name='状态')),
('network_consult_note',
models.TextField(blank=True,
null=True,
verbose_name='网络咨询师咨询内容')),
('date',
models.DateTimeField(auto_now_add=True, verbose_name='咨询日期')),
('last_consult_date',
models.DateField(auto_now_add=True, verbose_name='最后跟进日期')),
('next_date',
models.DateField(blank=True,
null=True,
verbose_name='预计再次跟进时间')),
('class_list',
models.ManyToManyField(to='crm.ClassList',
verbose_name='已报班级')),
('consultant',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='customers',
to=settings.AUTH_USER_MODEL,
verbose_name='销售')),
('introduce_from',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='crm.Customer',
verbose_name='转介绍自学员')),
('network_consultant',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='network_consultant',
to=settings.AUTH_USER_MODEL,
verbose_name='咨询师')),
],
),
migrations.CreateModel(
name='Department',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=32, verbose_name='部门名称')),
('count', models.IntegerField(default=0, verbose_name='人数')),
],
),
migrations.CreateModel(
name='Enrollment',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('why_us',
models.TextField(blank=True,
default=None,
max_length=1024,
null=True,
verbose_name='为什么报名')),
('your_expectation',
models.TextField(blank=True,
max_length=1024,
null=True,
verbose_name='学完想达到的具体期望')),
('contract_agreed',
models.BooleanField(default=False,
verbose_name='我已认真阅读完培训协议并同意全部协议内容')),
('contract_approved',
models.BooleanField(default=False,
help_text='在审阅完学员的资料无误后勾选此项,合同即生效',
verbose_name='审批通过')),
('enrolled_date',
models.DateTimeField(auto_now_add=True, verbose_name='报名日期')),
('memo',
models.TextField(blank=True, null=True, verbose_name='备注')),
('delete_status',
models.BooleanField(default=False, verbose_name='删除状态')),
('customer',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='crm.Customer',
verbose_name='客户名称')),
('enrolment_class',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='crm.ClassList',
verbose_name='所报班级')),
('school',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='crm.Campuses')),
],
),
migrations.CreateModel(
name='PaymentRecord',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('pay_type',
models.CharField(choices=[
('deposit', '订金/报名费'), ('tuition', '学费'),
('transfer', '转班'), ('dropout', '退学'), ('refund', '退款')
],
default='deposit',
max_length=64,
verbose_name='费用类型')),
('paid_fee', models.IntegerField(default=0,
verbose_name='费用数额')),
('note',
models.TextField(blank=True, null=True, verbose_name='备注')),
('date',
models.DateTimeField(auto_now_add=True, verbose_name='交款日期')),
('course',
models.CharField(blank=True,
choices=[('LinuxL', 'Linux中高级'),
('PythonFullStack', 'Python高级全栈开发')
],
default='N/A',
max_length=64,
null=True,
verbose_name='课程名')),
('class_type',
models.CharField(blank=True,
choices=[('fulltime', '脱产班'),
('online', '网络班'),
('weekend', '周末班')],
default='N/A',
max_length=64,
null=True,
verbose_name='班级类型')),
('delete_status',
models.BooleanField(default=False, verbose_name='删除状态')),
('status',
models.IntegerField(choices=[(1, '未审核'), (2, '已审核')],
default=1,
verbose_name='审核')),
('confirm_date',
models.DateTimeField(blank=True,
null=True,
verbose_name='确认日期')),
('confirm_user',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='confirms',
to=settings.AUTH_USER_MODEL,
verbose_name='确认人')),
('consultant',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL,
verbose_name='销售')),
('customer',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='crm.Customer',
verbose_name='客户')),
('enrolment_class',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='crm.ClassList',
verbose_name='所报班级')),
],
),
migrations.CreateModel(
name='StudyRecord',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('attendance',
models.CharField(choices=[('checked', '已签到'),
('vacate', '请假'), ('late', '迟到'),
('absence', '缺勤'),
('leave_early', '早退')],
default='checked',
max_length=64,
verbose_name='考勤')),
('score',
models.IntegerField(choices=[(100, 'A+'),
(90, 'A'), (85, 'B+'), (80, 'B'),
(70, 'B-'), (60, 'C+'),
(50, 'C'), (40, 'C-'), (0, ' D'),
(-1, 'N/A'), (-100, 'COPY'),
(-1000, 'FAIL')],
default=-1,
verbose_name='本节成绩')),
('homework_note',
models.CharField(blank=True,
max_length=255,
null=True,
verbose_name='作业批语')),
('date', models.DateTimeField(auto_now_add=True)),
('note',
models.CharField(blank=True,
max_length=255,
null=True,
verbose_name='备注')),
('homework',
models.FileField(blank=True,
default=None,
null=True,
upload_to='',
verbose_name='作业文件')),
('course_record',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='crm.CourseRecord',
verbose_name='某节课程')),
('student',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='crm.Customer',
verbose_name='学员')),
],
),
migrations.AddField(
model_name='consultrecord',
name='customer',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='crm.Customer',
verbose_name='所咨询客户'),
),
migrations.AddField(
model_name='classlist',
name='contract',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='crm.ContractTemplate',
verbose_name='选择合同模版'),
),
migrations.AddField(
model_name='classlist',
name='teachers',
field=models.ManyToManyField(to=settings.AUTH_USER_MODEL,
verbose_name='老师'),
),
migrations.AddField(
model_name='userprofile',
name='department',
field=models.ForeignKey(
blank=True,
default=None,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='crm.Department'),
),
migrations.AddField(
model_name='userprofile',
name='groups',
field=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'),
),
migrations.AddField(
model_name='userprofile',
name='user_permissions',
field=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'),
),
migrations.AlterUniqueTogether(
name='studyrecord',
unique_together=set([('course_record', 'student')]),
),
migrations.AlterUniqueTogether(
name='enrollment',
unique_together=set([('enrolment_class', 'customer')]),
),
migrations.AlterUniqueTogether(
name='courserecord',
unique_together=set([('re_class', 'day_num')]),
),
migrations.AlterUniqueTogether(
name='classlist',
unique_together=set([('course', 'semester', 'campuses')]),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Skills',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('title',
models.CharField(blank=True,
default='Навык',
max_length=200,
null=True)),
('type',
models.IntegerField(choices=[(1, 'Hard skill'),
(2, 'Soft skill')],
default=1,
null=True)),
('created',
models.DateTimeField(default=crm.models.default_time)),
],
),
migrations.CreateModel(
name='Vacancy',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('title',
models.CharField(blank=True,
default='Вакансия #',
max_length=200,
null=True)),
('status',
models.IntegerField(choices=[(0, 'Новая'), (1, 'В работе'),
(100, 'Закрыта')],
default=0,
null=True)),
('description', models.TextField(blank=True, null=True)),
('created',
models.DateTimeField(default=crm.models.default_time)),
('updated', models.DateTimeField(auto_now=True)),
('deadline', models.DateTimeField(blank=True, null=True)),
('owner',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
('vacancy_requaried_skills',
models.ManyToManyField(
blank=True,
related_name='vacancy_requaried_skills',
to='crm.Skills')),
('vacancy_skills',
models.ManyToManyField(blank=True,
related_name='vacancy_skills',
to='crm.Skills')),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Person',
fields=[
('id',
models.AutoField(primary_key=True,
serialize=False,
verbose_name='ID')),
('uuid',
models.CharField(default=crm.models.get_default_uuid,
editable=False,
max_length=63,
verbose_name='UUID')),
('name',
models.CharField(blank=True,
max_length=63,
verbose_name='Name')),
('phone_number',
models.CharField(blank=True,
max_length=63,
verbose_name='Phone Number')),
('remark',
models.CharField(blank=True,
max_length=255,
verbose_name='Remark')),
],
options={
'verbose_name': 'Person',
'verbose_name_plural': 'People',
'ordering': ['id'],
},
),
migrations.CreateModel(
name='Device',
fields=[
('id',
models.AutoField(primary_key=True,
serialize=False,
verbose_name='ID')),
('uuid',
models.CharField(default=crm.models.get_default_uuid,
editable=False,
max_length=63,
verbose_name='UUID')),
('name',
models.CharField(blank=True,
max_length=63,
verbose_name='Name')),
('os',
models.CharField(blank=True, max_length=50,
verbose_name='OS')),
('cpu',
models.IntegerField(blank=True, null=True,
verbose_name='CPU')),
('ram',
models.IntegerField(blank=True,
null=True,
verbose_name='RAM (GB)')),
('remark',
models.CharField(blank=True,
max_length=400,
verbose_name='Remark')),
('customer',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='whose_device_customer',
to='crm.person',
verbose_name='Customer')),
],
options={
'verbose_name': 'Device',
'verbose_name_plural': 'Devices',
'ordering': ['id'],
},
),
migrations.CreateModel(
name='CallLog',
fields=[
('id',
models.AutoField(primary_key=True,
serialize=False,
verbose_name='ID')),
('uuid',
models.CharField(default=crm.models.get_default_uuid,
editable=False,
max_length=63,
verbose_name='UUID')),
('request_url',
models.CharField(max_length=511, verbose_name='Request URL')),
('request_data',
models.CharField(max_length=511,
verbose_name='Request data')),
('called_by',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='whose_calllog_customer',
to='crm.person',
verbose_name='Called by')),
],
options={
'verbose_name': 'Device',
'verbose_name_plural': 'Devices',
'ordering': ['id'],
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0009_alter_user_last_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')),
('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')),
],
options={
'verbose_name': 'user',
'verbose_name_plural': 'users',
'abstract': False,
},
bases=(django_multitenant.mixins.TenantModelMixin, models.Model),
managers=[
('objects', crm.models.CustomUserManager()),
],
),
migrations.CreateModel(
name='Attendance',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
],
bases=(django_multitenant.mixins.TenantModelMixin, models.Model),
),
migrations.CreateModel(
name='Client',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=100, verbose_name='Имя')),
('address',
models.CharField(blank=True,
max_length=255,
verbose_name='Адрес')),
('birthday',
models.DateField(blank=True,
null=True,
verbose_name='Дата рождения')),
('phone_number',
models.CharField(blank=True,
max_length=50,
verbose_name='Телефон')),
('email_address',
models.CharField(blank=True,
max_length=50,
verbose_name='Email')),
('vk_user_id',
models.IntegerField(blank=True,
null=True,
verbose_name='id ученика в ВК')),
('balance', models.FloatField(default=0,
verbose_name='Баланс')),
],
bases=(django_multitenant.mixins.TenantModelMixin, models.Model),
),
migrations.CreateModel(
name='ClientSubscriptions',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('purchase_date',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='Дата покупки')),
('start_date',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='Дата начала')),
('end_date', models.DateTimeField(null=True)),
('price', models.FloatField(verbose_name='Стоимость')),
('visits_left',
models.PositiveIntegerField(
verbose_name='Остаток посещений')),
('client',
django_multitenant.fields.TenantForeignKey(
on_delete=django.db.models.deletion.PROTECT,
to='crm.Client',
verbose_name='Ученик')),
],
options={
'ordering': ['purchase_date'],
},
bases=(django_multitenant.mixins.TenantModelMixin, models.Model),
),
migrations.CreateModel(
name='Coach',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
],
options={
'abstract': False,
},
bases=(django_multitenant.mixins.TenantModelMixin, models.Model),
),
migrations.CreateModel(
name='Company',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(max_length=100,
unique=True,
verbose_name='Название')),
('display_name',
models.CharField(max_length=100,
verbose_name='Отображаемое название')),
],
),
migrations.CreateModel(
name='DayOfTheWeekClass',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('day',
models.PositiveSmallIntegerField(validators=[
django.core.validators.MinValueValidator(0),
django.core.validators.MaxValueValidator(6)
],
verbose_name='День недели')),
('start_time',
models.TimeField(default=django.utils.timezone.now,
verbose_name='Время начала тренировки')),
('end_time',
models.TimeField(default=django.utils.timezone.now,
verbose_name='Время окнчания тренировки')),
('company',
models.ForeignKey(
default=django_multitenant.utils.get_current_tenant,
on_delete=django.db.models.deletion.PROTECT,
to='crm.Company')),
],
bases=(django_multitenant.mixins.TenantModelMixin, models.Model),
),
migrations.CreateModel(
name='Event',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('date', models.DateField(verbose_name='Дата')),
('company',
models.ForeignKey(
default=django_multitenant.utils.get_current_tenant,
on_delete=django.db.models.deletion.PROTECT,
to='crm.Company')),
],
bases=(django_multitenant.mixins.TenantModelMixin, models.Model),
),
migrations.CreateModel(
name='EventClass',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(max_length=100, verbose_name='Название')),
('date_from',
models.DateField(blank=True, null=True,
verbose_name='Дата с')),
('date_to',
models.DateField(blank=True,
null=True,
verbose_name='Дата по')),
('coach',
django_multitenant.fields.TenantForeignKey(
on_delete=django.db.models.deletion.PROTECT,
to='crm.Coach',
verbose_name='Тренер')),
('company',
models.ForeignKey(
default=django_multitenant.utils.get_current_tenant,
on_delete=django.db.models.deletion.PROTECT,
to='crm.Company')),
],
options={
'abstract': False,
},
bases=(django_multitenant.mixins.TenantModelMixin, models.Model),
),
migrations.CreateModel(
name='ExtensionHistory',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('date_extended',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='Дата продления')),
('reason',
models.CharField(max_length=255,
verbose_name='Причина продления')),
('added_visits',
models.PositiveIntegerField(
verbose_name='Добавлено посещений')),
('client_subscription',
django_multitenant.fields.TenantForeignKey(
on_delete=django.db.models.deletion.PROTECT,
to='crm.ClientSubscriptions',
verbose_name='Абонемент клиента')),
('company',
models.ForeignKey(
default=django_multitenant.utils.get_current_tenant,
on_delete=django.db.models.deletion.PROTECT,
to='crm.Company')),
],
options={
'ordering': ['date_extended'],
},
bases=(django_multitenant.mixins.TenantModelMixin, models.Model),
),
migrations.CreateModel(
name='Location',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(max_length=100, verbose_name='Название')),
('address',
models.CharField(blank=True,
max_length=1000,
verbose_name='Адрес')),
('company',
models.ForeignKey(
default=django_multitenant.utils.get_current_tenant,
on_delete=django.db.models.deletion.PROTECT,
to='crm.Company')),
],
options={
'abstract': False,
},
bases=(django_multitenant.mixins.TenantModelMixin, models.Model),
),
migrations.CreateModel(
name='Manager',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('company',
models.ForeignKey(
default=django_multitenant.utils.get_current_tenant,
on_delete=django.db.models.deletion.PROTECT,
to='crm.Company')),
('user',
models.OneToOneField(
on_delete=django.db.models.deletion.PROTECT,
to=settings.AUTH_USER_MODEL)),
],
options={
'abstract': False,
},
bases=(django_multitenant.mixins.TenantModelMixin, models.Model),
),
migrations.CreateModel(
name='SubscriptionsType',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(max_length=100, verbose_name='Название')),
('price', models.FloatField(verbose_name='Стоимость')),
('duration_type',
models.CharField(choices=[('day', 'День'), ('week', 'Неделя'),
('month', 'Месяц'),
('year', 'Год')],
default=('day', 'День'),
max_length=20,
verbose_name='Временные рамки абонемента')),
('duration',
models.PositiveIntegerField(
verbose_name='Продолжительность')),
('rounding',
models.BooleanField(
default=False,
verbose_name='Округление начала действия абонемента')),
('visit_limit',
models.PositiveIntegerField(
verbose_name='Количество посещений')),
('company',
models.ForeignKey(
default=django_multitenant.utils.get_current_tenant,
on_delete=django.db.models.deletion.PROTECT,
to='crm.Company')),
('event_class',
models.ManyToManyField(to='crm.EventClass',
verbose_name='Допустимые тренировки')),
],
options={
'abstract': False,
},
bases=(django_multitenant.mixins.TenantModelMixin, models.Model),
),
migrations.AddField(
model_name='eventclass',
name='location',
field=django_multitenant.fields.TenantForeignKey(
on_delete=django.db.models.deletion.PROTECT,
to='crm.Location',
verbose_name='Расположение'),
),
migrations.AddField(
model_name='event',
name='event_class',
field=django_multitenant.fields.TenantForeignKey(
on_delete=django.db.models.deletion.PROTECT,
to='crm.EventClass',
verbose_name='Тренировка'),
),
migrations.AddField(
model_name='dayoftheweekclass',
name='event',
field=django_multitenant.fields.TenantForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='crm.EventClass',
verbose_name='Мероприятие'),
),
migrations.AddField(
model_name='coach',
name='company',
field=models.ForeignKey(
default=django_multitenant.utils.get_current_tenant,
on_delete=django.db.models.deletion.PROTECT,
to='crm.Company'),
),
migrations.AddField(
model_name='coach',
name='user',
field=models.OneToOneField(
on_delete=django.db.models.deletion.PROTECT,
to=settings.AUTH_USER_MODEL),
),
migrations.AddField(
model_name='clientsubscriptions',
name='company',
field=models.ForeignKey(
default=django_multitenant.utils.get_current_tenant,
on_delete=django.db.models.deletion.PROTECT,
to='crm.Company'),
),
migrations.AddField(
model_name='clientsubscriptions',
name='subscription',
field=django_multitenant.fields.TenantForeignKey(
on_delete=django.db.models.deletion.PROTECT,
to='crm.SubscriptionsType',
verbose_name='Тип Абонемента'),
),
migrations.AddField(
model_name='client',
name='company',
field=models.ForeignKey(
default=django_multitenant.utils.get_current_tenant,
on_delete=django.db.models.deletion.PROTECT,
to='crm.Company'),
),
migrations.AddField(
model_name='attendance',
name='client',
field=django_multitenant.fields.TenantForeignKey(
on_delete=django.db.models.deletion.PROTECT,
to='crm.Client',
verbose_name='Ученик'),
),
migrations.AddField(
model_name='attendance',
name='company',
field=models.ForeignKey(
default=django_multitenant.utils.get_current_tenant,
on_delete=django.db.models.deletion.PROTECT,
to='crm.Company'),
),
migrations.AddField(
model_name='attendance',
name='event',
field=django_multitenant.fields.TenantForeignKey(
on_delete=django.db.models.deletion.PROTECT,
to='crm.Event',
verbose_name='Тренировка'),
),
migrations.AddField(
model_name='user',
name='company',
field=models.ForeignKey(
default=crm.models.get_user_current_tenant,
on_delete=django.db.models.deletion.PROTECT,
to='crm.Company'),
),
migrations.AddField(
model_name='user',
name='groups',
field=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'),
),
migrations.AddField(
model_name='user',
name='user_permissions',
field=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'),
),
migrations.AlterUniqueTogether(
name='subscriptionstype',
unique_together={('id', 'company')},
),
migrations.AlterUniqueTogether(
name='manager',
unique_together={('id', 'company')},
),
migrations.AlterUniqueTogether(
name='location',
unique_together={('id', 'company')},
),
migrations.AlterUniqueTogether(
name='eventclass',
unique_together={('id', 'company')},
),
migrations.AlterUniqueTogether(
name='event',
unique_together={('event_class', 'date')},
),
migrations.AlterUniqueTogether(
name='dayoftheweekclass',
unique_together={('day', 'event')},
),
migrations.AlterUniqueTogether(
name='coach',
unique_together={('id', 'company')},
),
migrations.AlterUniqueTogether(
name='client',
unique_together={('company', 'name')},
),
migrations.AlterUniqueTogether(
name='attendance',
unique_together={('client', 'event')},
),
migrations.RunPython(create_admin_company),
]
