class Migration(migrations.Migration):
dependencies = [
('accounting', '0001_initial'),
]
operations = [
migrations.CreateModel(
name='AccountBalance',
fields=[
('account', models.ForeignKey(on_delete=django.db.models.deletion.DO_NOTHING, primary_key=True, serialize=False, to='accounting.Account')),
('timestamp', models.DateField()),
('balance', models.DecimalField(decimal_places=2, max_digits=20)),
],
options={
'db_table': 'account_balances',
'managed': False,
},
),
migrations.CreateModel(
name='AccountLedgers',
fields=[
('timestamp', models.DateTimeField()),
('entry', models.ForeignKey(on_delete=django.db.models.deletion.DO_NOTHING, primary_key=True, serialize=False, to='accounting.Entries')),
('amount', models.DecimalField(decimal_places=2, max_digits=20, validators=[accounting.models.validate_positive_amount])),
],
options={
'db_table': 'account_ledgers',
'managed': False,
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
]
operations = [
migrations.CreateModel(
name='Expenses',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('title', models.CharField(max_length=100)),
('rupes', models.FloatField(validators=[accounting.models.is_positive])),
('checque', models.FileField(blank=True, null=True, upload_to='expenses/')),
('date', models.DateField(default=django.utils.timezone.now)),
('description', models.TextField(blank=True, null=True)),
],
),
migrations.CreateModel(
name='ExpensesCategory',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('category', models.CharField(max_length=100)),
],
),
migrations.CreateModel(
name='Income',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('title', models.CharField(max_length=100)),
('rupes', models.FloatField(validators=[accounting.models.is_positive])),
('bill_no', models.CharField(blank=True, max_length=100, null=True)),
('biiling_file', models.FileField(blank=True, null=True, upload_to='income/')),
('date', models.DateField(default=django.utils.timezone.now)),
('description', models.TextField(blank=True, null=True)),
],
),
migrations.CreateModel(
name='IncomeCategory',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('category', models.CharField(max_length=100)),
],
),
migrations.AddField(
model_name='income',
name='category',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='accounting.IncomeCategory'),
),
migrations.AddField(
model_name='expenses',
name='category',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='accounting.ExpensesCategory'),
),
]
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')),
('name', models.CharField(max_length=256)),
],
),
migrations.CreateModel(
name='Entries',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('description', models.CharField(max_length=1024)),
('timestamp', models.DateTimeField(auto_now_add=True)),
('amount',
models.DecimalField(
decimal_places=2,
max_digits=20,
validators=[accounting.models.validate_positive_amount])),
('credit',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
related_name='credit',
to='accounting.Account')),
('debit',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
related_name='debit',
to='accounting.Account')),
],
),
migrations.AddIndex(
model_name='entries',
index=models.Index(fields=['credit', 'debit'],
name='accounting__credit__aebb13_idx'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0011_update_proxy_permissions'),
]
operations = [
migrations.CreateModel(
name='Account',
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')),
('uuid',
models.UUIDField(db_index=True,
default=uuid.uuid4,
verbose_name='Идентификатор')),
('slug', models.SlugField(unique=True, verbose_name='URL')),
('name', models.CharField(max_length=50, verbose_name='Имя')),
('color',
models.CharField(blank=True,
max_length=9,
null=True,
verbose_name='Цвет')),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='TransactionType',
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')),
('uuid',
models.UUIDField(db_index=True,
default=uuid.uuid4,
verbose_name='Идентификатор')),
('name', models.CharField(max_length=50, verbose_name='Имя')),
('color',
models.CharField(blank=True,
max_length=9,
null=True,
verbose_name='Цвет')),
('slug', models.SlugField(unique=True, verbose_name='URL')),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='Transaction',
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')),
('uuid',
models.UUIDField(db_index=True,
default=uuid.uuid4,
verbose_name='Идентификатор')),
('slug', models.SlugField(unique=True, verbose_name='URL')),
('category',
models.CharField(max_length=50, verbose_name='Категория')),
('branch',
models.CharField(blank=True,
max_length=50,
null=True,
verbose_name='Филиал')),
('note',
models.CharField(blank=True,
max_length=400,
null=True,
verbose_name='Примечание')),
('consumption',
models.DecimalField(blank=True,
decimal_places=2,
default=0.0,
max_digits=12,
verbose_name='Расход')),
('profit',
models.DecimalField(blank=True,
decimal_places=2,
default=0.0,
max_digits=12,
verbose_name='Приход')),
('balance',
models.DecimalField(blank=True,
decimal_places=2,
default=0.0,
max_digits=12,
verbose_name='Баланс/Сальдо')),
('date',
models.DateField(auto_now_add=True,
verbose_name='Дата проведения операции')),
('order',
models.IntegerField(default=1,
verbose_name='Порядок операции')),
('account',
models.ForeignKey(blank=True,
on_delete='SET_NULL',
related_name='account_of_transactions',
to='accounting.Account',
verbose_name='Cчёт транзакции')),
('transactionType',
models.ForeignKey(blank=True,
on_delete='SET_NULL',
related_name='transaction_type',
to='accounting.TransactionType',
verbose_name='Транзакции счёта')),
],
options={
'abstract': False,
},
),
migrations.AddField(
model_name='account',
name='transactions',
field=models.ManyToManyField(
blank=True,
related_name='transactions_of_account',
to='accounting.Transaction',
verbose_name='Транзакции счёта'),
),
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')),
('uuid',
models.UUIDField(db_index=True,
default=uuid.uuid4,
verbose_name='Идентификатор')),
('email',
models.EmailField(max_length=254,
unique=True,
verbose_name='Email')),
('name',
models.CharField(blank=True,
max_length=254,
verbose_name='Имя пользователя')),
('role',
models.CharField(choices=[('admin', 'Смотрящий'),
('user', 'Рядовой'),
('viewer', 'Наблюдающий')],
default='viewer',
max_length=6,
verbose_name='Роль')),
('is_active', models.BooleanField(default=True)),
('is_staff', models.BooleanField(default=False)),
('date_joined', models.DateTimeField(auto_now_add=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={
'abstract': False,
},
managers=[
('objects', accounting.models.UserManager()),
],
),
]
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')),
('provider', models.CharField(max_length=40, null=True)),
('name', models.CharField(max_length=20)),
('email', models.EmailField(max_length=30, unique=True)),
('username',
models.CharField(max_length=100, null=True, unique=True)),
('token_id', models.CharField(max_length=100, null=True)),
('password', models.CharField(max_length=100, null=True)),
('created_on',
models.DateTimeField(
default=datetime.datetime(2020, 6, 28, 14, 12, 30, 57582))
),
],
),
migrations.CreateModel(
name='Campaigns',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('ca_name', models.CharField(max_length=30)),
('add_on',
models.DateTimeField(
default=datetime.datetime(2020, 6, 28, 14, 12, 30, 62594))
),
('ca_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='accounting.Account')),
],
),
migrations.CreateModel(
name='Group',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('g_name', models.CharField(default=None, max_length=30)),
('add_on',
models.DateTimeField(
default=datetime.datetime(2020, 6, 28, 14, 12, 30, 61591))
),
('g_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='accounting.Account')),
],
),
migrations.CreateModel(
name='Session',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('createid', models.CharField(max_length=100)),
('session_id', models.CharField(max_length=300)),
('session_key', models.CharField(max_length=100)),
],
),
migrations.CreateModel(
name='Stats',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('From',
models.DateTimeField(
default=datetime.datetime(2020, 6, 28, 14, 12, 30, 63597))
),
('To',
models.DateTimeField(
default=datetime.datetime(2020, 6, 28, 14, 12, 30, 63597))
),
('messagesent', models.IntegerField(default=0)),
('contacts_created', models.IntegerField(default=0)),
('groups_created', models.IntegerField(default=0)),
('campaigns_created', models.IntegerField(default=0)),
('templated_created', models.IntegerField(default=0)),
('s_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='accounting.Account')),
],
),
migrations.CreateModel(
name='Groupdetails',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('contact_id', models.IntegerField(default=0)),
('gd_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='accounting.Group')),
],
),
migrations.CreateModel(
name='EmailAccounts',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('e_provider', models.CharField(max_length=50)),
('e_email', models.EmailField(max_length=254)),
('e_password', models.CharField(max_length=200)),
('addon',
models.DateTimeField(
default=datetime.datetime(2020, 6, 28, 14, 12, 30, 59586))
),
('addpassword', models.BooleanField(default=False)),
('e_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='accounting.Account')),
],
),
migrations.CreateModel(
name='ContactlistFile',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('date',
models.DateTimeField(
default=datetime.datetime(2020, 6, 28, 14, 12, 30, 60589))
),
('myfile',
models.FileField(
upload_to=accounting.models.user_directory_path)),
('cf_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='accounting.Account')),
],
),
migrations.CreateModel(
name='Contactlist',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('c_name', models.CharField(max_length=50)),
('c_first_name', models.CharField(default=None,
max_length=50)),
('c_middle_name', models.CharField(default=None,
max_length=50)),
('c_last_name', models.CharField(default=None, max_length=50)),
('c_gender', models.CharField(default=None, max_length=40)),
('c_group', models.CharField(default=None, max_length=50)),
('c_subgroup', models.CharField(default=None, max_length=50)),
('c_status', models.CharField(default=None, max_length=50)),
('c_company', models.CharField(default=None, max_length=50)),
('c_designation', models.CharField(default=None,
max_length=50)),
('c_title', models.CharField(default=None, max_length=50)),
('c_department', models.CharField(default=None,
max_length=50)),
('c_university', models.CharField(default=None,
max_length=50)),
('c_degree', models.CharField(default=None, max_length=50)),
('c_passingyear', models.CharField(default=None,
max_length=50)),
('c_college', models.CharField(default=None, max_length=50)),
('c_ctc', models.CharField(default=None, max_length=50)),
('c_email', models.EmailField(max_length=254)),
('c_alternativeemailid',
models.EmailField(default=None, max_length=254)),
('c_phone', models.CharField(default=None, max_length=40)),
('c_alternativephone',
models.CharField(default=None, max_length=40)),
('c_city', models.CharField(default=None, max_length=50)),
('c_address', models.CharField(default=None, max_length=50)),
('c_state', models.CharField(default=None, max_length=50)),
('c_country', models.CharField(default=None, max_length=50)),
('c_zip', models.CharField(default=None, max_length=50)),
('c_industry', models.CharField(default=None, max_length=50)),
('c_keyskills', models.CharField(default=None, max_length=50)),
('c_totalexperience',
models.CharField(default=None, max_length=50)),
('c_yearbusiness', models.CharField(default=None,
max_length=50)),
('c_turnover', models.CharField(default=None, max_length=50)),
('c_dateofincorportaion',
models.CharField(default=None, max_length=50)),
('c_employess', models.CharField(default=None, max_length=50)),
('c_addon',
models.DateTimeField(
default=datetime.datetime(2020, 6, 28, 14, 12, 30, 60589))
),
('c_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='accounting.Account')),
],
),
migrations.CreateModel(
name='Campaignsdetails',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('contact_id', models.IntegerField(default=0)),
('cd_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='accounting.Campaigns')),
],
),
migrations.CreateModel(
name='Accountdetail',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('city', models.CharField(max_length=100, null=True)),
('potp', models.CharField(max_length=200, null=True)),
('rotp', models.CharField(max_length=200, null=True)),
('date2',
models.DateTimeField(
default=datetime.datetime(2020, 6, 28, 14, 12, 30, 58584))
),
('date',
models.DateTimeField(
default=datetime.datetime(2020, 6, 28, 14, 12, 30, 58584))
),
('defaultaccount', models.EmailField(max_length=254,
null=True)),
('profile',
models.ImageField(
null=True, upload_to=accounting.models.user_photo_path)),
('everify', models.BooleanField(default=False)),
('comlpeted', models.BooleanField(default=False)),
('acc_id',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to='accounting.Account')),
],
),
]
class Migration(migrations.Migration):
dependencies = [
('accounting', '0001_initial'),
]
operations = [
migrations.CreateModel(
name='Produto',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('nome', models.CharField(max_length=40)),
],
),
migrations.CreateModel(
name='ProdutoDespesa',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('valor', models.DecimalField(decimal_places=2,
max_digits=19)),
('quantidade', models.IntegerField(default=1)),
],
bases=(accounting.models.BaseModel, models.Model),
),
migrations.CreateModel(
name='ProdutoReceita',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('valor', models.DecimalField(decimal_places=2,
max_digits=19)),
('quantidade', models.IntegerField(default=1)),
('produto',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='accounting.Produto')),
],
bases=(accounting.models.BaseModel, models.Model),
),
migrations.AlterField(
model_name='despesa',
name='valor',
field=models.DecimalField(decimal_places=2,
default=0,
max_digits=19),
),
migrations.AlterField(
model_name='receita',
name='valor',
field=models.DecimalField(decimal_places=2,
default=0,
max_digits=19),
),
migrations.AddField(
model_name='produtoreceita',
name='receita',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='accounting.Receita'),
),
migrations.AddField(
model_name='produtodespesa',
name='despesa',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='accounting.Despesa'),
),
migrations.AddField(
model_name='produtodespesa',
name='produto',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='accounting.Produto'),
),
migrations.AddField(
model_name='despesa',
name='produtos',
field=models.ManyToManyField(through='accounting.ProdutoDespesa',
to='accounting.Produto'),
),
migrations.AddField(
model_name='receita',
name='produtos',
field=models.ManyToManyField(through='accounting.ProdutoReceita',
to='accounting.Produto'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='CentroDeCusto',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('total',
models.DecimalField(decimal_places=2,
default=0,
max_digits=19)),
('nome', models.CharField(max_length=40)),
('descricao', models.CharField(max_length=200)),
],
),
migrations.CreateModel(
name='Despesa',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('valor', models.DecimalField(decimal_places=2,
max_digits=19)),
('nome', models.CharField(max_length=40)),
('descricao', models.CharField(max_length=200)),
('data', models.DateField(default=datetime.date.today)),
('centro_de_custo',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='accounting.CentroDeCusto')),
],
bases=(accounting.models.BaseModel, models.Model),
),
migrations.CreateModel(
name='Receita',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('valor', models.DecimalField(decimal_places=2,
max_digits=19)),
('nome', models.CharField(max_length=40)),
('descricao', models.CharField(max_length=200)),
('data', models.DateField(default=datetime.date.today)),
('centro_de_custo',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='accounting.CentroDeCusto')),
],
bases=(accounting.models.BaseModel, models.Model),
),
migrations.CreateModel(
name='TipoCentroCusto',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('nome', models.CharField(max_length=40)),
('descricao', models.CharField(max_length=200)),
],
),
migrations.CreateModel(
name='TipoDespesa',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('nome', models.CharField(max_length=40)),
('descricao', models.CharField(max_length=200)),
],
),
migrations.CreateModel(
name='TipoReceita',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('nome', models.CharField(max_length=40)),
('descricao', models.CharField(max_length=200)),
],
),
migrations.AddField(
model_name='receita',
name='tipo_receita',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='accounting.TipoReceita'),
),
migrations.AddField(
model_name='despesa',
name='tipo_despesa',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='accounting.TipoDespesa'),
),
migrations.AddField(
model_name='centrodecusto',
name='tipo_centro_custo',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='accounting.TipoCentroCusto'),
),
]