2016-08-02 10:40:46 +02:00
|
|
|
# -*- coding: utf-8 -*-
|
|
|
|
from __future__ import unicode_literals
|
|
|
|
|
|
|
|
from django.db import models, migrations
|
|
|
|
import django.db.models.deletion
|
|
|
|
import django.core.validators
|
|
|
|
import datetime
|
|
|
|
|
|
|
|
|
|
|
|
class Migration(migrations.Migration):
|
|
|
|
|
|
|
|
dependencies = [
|
2018-06-17 18:37:28 +02:00
|
|
|
('cof', '0007_alter_club'),
|
2016-08-02 10:40:46 +02:00
|
|
|
]
|
|
|
|
|
|
|
|
operations = [
|
|
|
|
migrations.CreateModel(
|
|
|
|
name='Account',
|
|
|
|
fields=[
|
|
|
|
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
|
|
('trigramme', models.CharField(max_length=3, validators=[django.core.validators.RegexValidator(regex='^[^a-z]{3}$')], unique=True)),
|
|
|
|
('balance', models.DecimalField(decimal_places=2, default=0, max_digits=6)),
|
|
|
|
('frozen', models.BooleanField(default=False)),
|
|
|
|
('promo', models.IntegerField(null=True, blank=True, choices=[(1980, 1980), (1981, 1981), (1982, 1982), (1983, 1983), (1984, 1984), (1985, 1985), (1986, 1986), (1987, 1987), (1988, 1988), (1989, 1989), (1990, 1990), (1991, 1991), (1992, 1992), (1993, 1993), (1994, 1994), (1995, 1995), (1996, 1996), (1997, 1997), (1998, 1998), (1999, 1999), (2000, 2000), (2001, 2001), (2002, 2002), (2003, 2003), (2004, 2004), (2005, 2005), (2006, 2006), (2007, 2007), (2008, 2008), (2009, 2009), (2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016)], default=2015)),
|
|
|
|
('nickname', models.CharField(max_length=255, blank=True, default='')),
|
|
|
|
('password', models.CharField(max_length=255, blank=True, null=True, unique=True, default=None)),
|
2018-06-17 18:37:28 +02:00
|
|
|
('cofprofile', models.OneToOneField(on_delete=django.db.models.deletion.PROTECT, related_name='account_kfet', to='cof.CofProfile')),
|
2016-08-02 10:40:46 +02:00
|
|
|
],
|
|
|
|
),
|
|
|
|
migrations.CreateModel(
|
|
|
|
name='AccountNegative',
|
|
|
|
fields=[
|
|
|
|
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
|
|
('start', models.DateTimeField(default=datetime.datetime(2016, 8, 2, 10, 22, 1, 569492))),
|
|
|
|
('balance_offset', models.DecimalField(decimal_places=2, max_digits=6)),
|
|
|
|
('authorized_overdraft', models.DecimalField(decimal_places=2, default=0, max_digits=6)),
|
|
|
|
('comment', models.CharField(max_length=255, blank=True)),
|
|
|
|
('account', models.OneToOneField(on_delete=django.db.models.deletion.PROTECT, related_name='negative', to='kfet.Account')),
|
|
|
|
],
|
|
|
|
),
|
|
|
|
migrations.CreateModel(
|
|
|
|
name='Article',
|
|
|
|
fields=[
|
|
|
|
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
|
|
('name', models.CharField(max_length=45)),
|
|
|
|
('is_sold', models.BooleanField(default=True)),
|
|
|
|
('price', models.DecimalField(decimal_places=2, max_digits=6)),
|
|
|
|
('stock', models.IntegerField(default=0)),
|
|
|
|
],
|
|
|
|
),
|
|
|
|
migrations.CreateModel(
|
|
|
|
name='ArticleCategory',
|
|
|
|
fields=[
|
|
|
|
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
|
|
('name', models.CharField(max_length=45)),
|
|
|
|
],
|
|
|
|
),
|
|
|
|
migrations.CreateModel(
|
|
|
|
name='ArticleRule',
|
|
|
|
fields=[
|
|
|
|
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
|
|
('ratio', models.PositiveSmallIntegerField()),
|
|
|
|
('article_on', models.OneToOneField(on_delete=django.db.models.deletion.PROTECT, related_name='rule_on', to='kfet.Article')),
|
|
|
|
('article_to', models.OneToOneField(on_delete=django.db.models.deletion.PROTECT, related_name='rule_to', to='kfet.Article')),
|
|
|
|
],
|
|
|
|
),
|
|
|
|
migrations.CreateModel(
|
|
|
|
name='Checkout',
|
|
|
|
fields=[
|
|
|
|
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
|
|
('name', models.CharField(max_length=45)),
|
|
|
|
('valid_from', models.DateTimeField()),
|
|
|
|
('valid_to', models.DateTimeField()),
|
|
|
|
('balance', models.DecimalField(decimal_places=2, max_digits=6)),
|
|
|
|
('is_protected', models.BooleanField(default=False)),
|
|
|
|
('created_by', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='+', to='kfet.Account')),
|
|
|
|
],
|
|
|
|
),
|
|
|
|
migrations.CreateModel(
|
|
|
|
name='CheckoutTransfer',
|
|
|
|
fields=[
|
|
|
|
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
|
|
('amount', models.DecimalField(decimal_places=2, max_digits=6)),
|
|
|
|
('from_checkout', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='transfers_from', to='kfet.Checkout')),
|
|
|
|
('to_checkout', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='transfers_to', to='kfet.Checkout')),
|
|
|
|
],
|
|
|
|
),
|
|
|
|
migrations.CreateModel(
|
|
|
|
name='Inventory',
|
|
|
|
fields=[
|
|
|
|
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
|
|
('at', models.DateTimeField(auto_now_add=True)),
|
|
|
|
],
|
|
|
|
),
|
|
|
|
migrations.CreateModel(
|
|
|
|
name='InventoryArticle',
|
|
|
|
fields=[
|
|
|
|
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
|
|
('stock_old', models.IntegerField()),
|
|
|
|
('stock_new', models.IntegerField()),
|
|
|
|
('stock_error', models.IntegerField(default=0)),
|
|
|
|
('article', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='kfet.Article')),
|
|
|
|
('inventory', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='kfet.Inventory')),
|
|
|
|
],
|
|
|
|
),
|
|
|
|
migrations.CreateModel(
|
|
|
|
name='Operation',
|
|
|
|
fields=[
|
|
|
|
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
|
|
('type', models.CharField(max_length=8, choices=[('purchase', 'Achat'), ('deposit', 'Charge'), ('withdraw', 'Retrait')])),
|
|
|
|
('amount', models.DecimalField(decimal_places=2, max_digits=6)),
|
|
|
|
('on_checkout', models.BooleanField(default=True)),
|
|
|
|
('canceled_at', models.DateTimeField(blank=True, null=True, default=None)),
|
|
|
|
('addcost_amount', models.DecimalField(decimal_places=2, max_digits=6)),
|
|
|
|
('addcost_for', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, blank=True, related_name='addcosts', to='kfet.Account', null=True, default=None)),
|
|
|
|
('article', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, blank=True, related_name='operations', to='kfet.Article', null=True, default=None)),
|
|
|
|
('canceled_by', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, blank=True, related_name='+', to='kfet.Account', null=True, default=None)),
|
|
|
|
],
|
|
|
|
),
|
|
|
|
migrations.CreateModel(
|
|
|
|
name='OperationGroup',
|
|
|
|
fields=[
|
|
|
|
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
|
|
('at', models.DateTimeField(auto_now_add=True)),
|
|
|
|
('amount', models.IntegerField()),
|
|
|
|
('is_cof', models.BooleanField(default=False)),
|
|
|
|
('comment', models.CharField(max_length=255, blank=True, default='')),
|
|
|
|
('checkout', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='operations', to='kfet.Checkout')),
|
|
|
|
('on_acc', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='operations', to='kfet.Account')),
|
|
|
|
('valid_by', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, blank=True, related_name='+', to='kfet.Account', null=True, default=True)),
|
|
|
|
],
|
|
|
|
),
|
|
|
|
migrations.CreateModel(
|
|
|
|
name='Order',
|
|
|
|
fields=[
|
|
|
|
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
|
|
('at', models.DateTimeField(auto_now_add=True)),
|
|
|
|
('amount', models.DecimalField(decimal_places=2, max_digits=6)),
|
|
|
|
],
|
|
|
|
),
|
|
|
|
migrations.CreateModel(
|
|
|
|
name='OrderArticle',
|
|
|
|
fields=[
|
|
|
|
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
|
|
('quantity_ordered', models.IntegerField()),
|
|
|
|
('quantity_received', models.IntegerField()),
|
|
|
|
('article', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='kfet.Article')),
|
|
|
|
('order', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='kfet.Order')),
|
|
|
|
],
|
|
|
|
),
|
|
|
|
migrations.CreateModel(
|
|
|
|
name='Statement',
|
|
|
|
fields=[
|
|
|
|
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
|
|
('balance_old', models.DecimalField(decimal_places=2, max_digits=6)),
|
|
|
|
('balance_new', models.DecimalField(decimal_places=2, max_digits=6)),
|
|
|
|
('amount_taken', models.DecimalField(decimal_places=2, max_digits=6)),
|
|
|
|
('amount_error', models.DecimalField(decimal_places=2, max_digits=6)),
|
|
|
|
('at', models.DateTimeField(auto_now_add=True)),
|
|
|
|
('by', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='+', to='kfet.Account')),
|
|
|
|
('checkout', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='statements', to='kfet.Checkout')),
|
|
|
|
],
|
|
|
|
),
|
|
|
|
migrations.CreateModel(
|
|
|
|
name='Supplier',
|
|
|
|
fields=[
|
|
|
|
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
|
|
('name', models.CharField(max_length=45)),
|
|
|
|
('address', models.TextField()),
|
|
|
|
('email', models.EmailField(max_length=254)),
|
|
|
|
('phone', models.CharField(max_length=10)),
|
|
|
|
('comment', models.TextField()),
|
|
|
|
],
|
|
|
|
),
|
|
|
|
migrations.CreateModel(
|
|
|
|
name='SupplierArticle',
|
|
|
|
fields=[
|
|
|
|
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
|
|
('box_type', models.CharField(max_length=7, choices=[('caisse', 'Caisse'), ('carton', 'Carton'), ('palette', 'Palette'), ('fût', 'Fût')])),
|
|
|
|
('box_capacity', models.PositiveSmallIntegerField()),
|
|
|
|
('price_HT', models.DecimalField(decimal_places=4, max_digits=7)),
|
|
|
|
('TVA', models.DecimalField(decimal_places=2, max_digits=4)),
|
|
|
|
('rights', models.DecimalField(decimal_places=4, max_digits=7)),
|
|
|
|
('article', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='kfet.Article')),
|
|
|
|
('supplier', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='kfet.Supplier')),
|
|
|
|
],
|
|
|
|
),
|
|
|
|
migrations.CreateModel(
|
|
|
|
name='Transfer',
|
|
|
|
fields=[
|
|
|
|
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
|
|
('amount', models.DecimalField(decimal_places=2, max_digits=6)),
|
|
|
|
('canceled_at', models.DateTimeField(blank=True, null=True, default=None)),
|
|
|
|
('canceled_by', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, blank=True, related_name='+', to='kfet.Account', null=True, default=None)),
|
|
|
|
('from_acc', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='transfers_from', to='kfet.Account')),
|
|
|
|
],
|
|
|
|
),
|
|
|
|
migrations.CreateModel(
|
|
|
|
name='TransferGroup',
|
|
|
|
fields=[
|
|
|
|
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
|
|
('at', models.DateTimeField(auto_now_add=True)),
|
|
|
|
('comment', models.CharField(max_length=255, blank=True, default='')),
|
|
|
|
('valid_by', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, blank=True, related_name='+', to='kfet.Account', null=True, default=None)),
|
|
|
|
],
|
|
|
|
),
|
|
|
|
migrations.AddField(
|
|
|
|
model_name='transfer',
|
|
|
|
name='group',
|
|
|
|
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='transfers', to='kfet.TransferGroup'),
|
|
|
|
),
|
|
|
|
migrations.AddField(
|
|
|
|
model_name='transfer',
|
|
|
|
name='to_acc',
|
|
|
|
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='transfers_to', to='kfet.Account'),
|
|
|
|
),
|
|
|
|
migrations.AddField(
|
|
|
|
model_name='supplier',
|
|
|
|
name='articles',
|
|
|
|
field=models.ManyToManyField(related_name='suppliers', through='kfet.SupplierArticle', to='kfet.Article'),
|
|
|
|
),
|
|
|
|
migrations.AddField(
|
|
|
|
model_name='order',
|
|
|
|
name='articles',
|
|
|
|
field=models.ManyToManyField(related_name='orders', through='kfet.OrderArticle', to='kfet.Article'),
|
|
|
|
),
|
|
|
|
migrations.AddField(
|
|
|
|
model_name='order',
|
|
|
|
name='supplier',
|
|
|
|
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='orders', to='kfet.Supplier'),
|
|
|
|
),
|
|
|
|
migrations.AddField(
|
|
|
|
model_name='operation',
|
|
|
|
name='group',
|
|
|
|
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='+', to='kfet.OperationGroup'),
|
|
|
|
),
|
|
|
|
migrations.AddField(
|
|
|
|
model_name='inventory',
|
|
|
|
name='articles',
|
|
|
|
field=models.ManyToManyField(related_name='inventories', through='kfet.InventoryArticle', to='kfet.Article'),
|
|
|
|
),
|
|
|
|
migrations.AddField(
|
|
|
|
model_name='inventory',
|
|
|
|
name='by',
|
|
|
|
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='+', to='kfet.Account'),
|
|
|
|
),
|
|
|
|
migrations.AddField(
|
|
|
|
model_name='inventory',
|
|
|
|
name='order',
|
|
|
|
field=models.OneToOneField(on_delete=django.db.models.deletion.PROTECT, blank=True, related_name='inventory', to='kfet.Order', null=True, default=None),
|
|
|
|
),
|
|
|
|
migrations.AddField(
|
|
|
|
model_name='article',
|
|
|
|
name='category',
|
|
|
|
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='articles', to='kfet.ArticleCategory'),
|
|
|
|
),
|
|
|
|
]
|