Skip to content
Snippets Groups Projects
0001_initial.py 4.46 KiB
Newer Older
# Generated by Django 3.0.2 on 2020-02-02 22:14
import datetime
from django.conf import settings
from django.db import migrations, models
import django.db.models.deletion


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')),
                ('name', models.CharField(max_length=20, verbose_name='Booking account')),
                ('income', models.BooleanField(default=False, verbose_name='Income account')),
                ('budget', models.IntegerField(default=0, verbose_name='Budget')),
                ('saldo', models.DecimalField(decimal_places=2, default=0.0, max_digits=9)),
                ('rest', models.DecimalField(decimal_places=2, default=0.0, max_digits=9)),
            ],
            options={
                'verbose_name': 'Booking account',
                'verbose_name_plural': 'Booking accounts',
                'permissions': [('manage_account', 'Can manage account')],
            },
        ),
        migrations.CreateModel(
Jonathan Weth's avatar
Jonathan Weth committed
            name='CostCenter',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=30, verbose_name='Cost center')),
                ('year', models.IntegerField(choices=[(2020, '2020'), (2021, '2021'), (2022, '2022'), (2023, '2023')], default=2020, verbose_name='Year')),
            ],
            options={
                'verbose_name': 'Cost center',
                'verbose_name_plural': 'Cost centers',
                'permissions': [('manage_costcenter', 'Can manage costcenter')],
            },
        ),
        migrations.CreateModel(
            name='Booking',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.CharField(max_length=50, verbose_name='Description')),
                ('justification', models.CharField(blank=True, max_length=2000, null=True, verbose_name='Reason')),
                ('planned_amount', models.IntegerField(verbose_name='Planned amount')),
                ('invoice_date', models.DateField(blank=True, null=True, verbose_name='Date of invoice')),
                ('invoice_number', models.CharField(blank=True, max_length=20, null=True, verbose_name='Bill number')),
                ('firma', models.CharField(blank=True, max_length=30, null=True, verbose_name='Company')),
                ('amount', models.DecimalField(decimal_places=2, default=0.0, max_digits=9, verbose_name='Amount')),
                ('payout_number', models.IntegerField(blank=True, null=True, verbose_name='Payout number')),
                ('submission_date', models.DateField(blank=True, null=True, verbose_name='Submission date')),
                ('booking_date', models.DateField(default=datetime.date.today, verbose_name='Booking date')),
                ('maturity', models.DateField(blank=True, null=True, verbose_name='Maturity')),
                ('upload', models.FileField(blank=True, default=None, null=True, upload_to='uploads/fibu/%Y/', verbose_name='Scan of invoice')),
                ('status', models.IntegerField(choices=[(0, 'requested'), (1, 'rejected'), (2, 'accepted'), (3, 'ordered'), (4, 'submitted'), (5, 'paid')], default=0, verbose_name='Status')),
                ('account', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='fibu.Account', verbose_name='Booking account')),
                ('contact', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='bookings', to=settings.AUTH_USER_MODEL, verbose_name='Created by')),
            ],
            options={
                'verbose_name': 'Booking',
                'verbose_name_plural': 'Bookings',
                'permissions': [('manage_booking', 'Can manage bookings'), ('request_booking', 'Can request a booking'), ('check_booking', 'Can check bookings')],
            },
        ),
        migrations.AddField(
            model_name='account',
            name='cost_center',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='fibu.CostCenter', verbose_name='Cost center'),