taxtech/migrations/0005_auto_20241125_1043.py

# Generated by Django 5.1.1 on 2024-11-25 10:43

from django.db import migrations
from django.core.serializers.json import DjangoJSONEncoder
import json


def add_default_entries(apps, schema_editor):
    TaxData = apps.get_model('taxtech', 'TaxData')
    data = [
    {
        "Country": "Land Australien",
        "Currency": "€",
        "EBT": 2050144,
        "Taxes": 615074,
        "Quote": 30.00,
        "Check_Data": "Nein, Gewinn und Quote>= 15%",
        "Pot. Mehrsteuer": 9898156,
        "De Minimis?": "N/A",
        "5% Check": 24397,
        "Revenues": None,
        "Salaries": 348962,
        "Net Loss": -40501
    },
    {
        "Country": "Land China",
        "Currency": "€",
        "EBT": 6615474,
        "Taxes": 2013643,
        "Quote": 30.44,
        "Check_Data": "Nein, Gewinn und Quote>= 15%",
        "Pot. Mehrsteuer": 69624464,
        "De Minimis?": "N/A",
        "5% Check": 430459,
        "Revenues": None,
        "Salaries": -17508,
        "Net Loss": -117654
    },
    {
        "Country": "Land Deutschland",
        "Currency": "€",
        "EBT": 90554740,
        "Taxes": 30222242,
        "Quote": 33.37,
        "Check_Data": "Nein, Gewinn und Quote>= 15%",
        "Pot. Mehrsteuer": 724777547,
        "De Minimis?": "N/A",
        "5% Check": 14877411,
        "Revenues": None,
        "Salaries": 22201920,
        "Net Loss": -235523
    },
    {
        "Country": "Land Finnland",
        "Currency": "€",
        "EBT": -425655,
        "Taxes": 600,
        "Quote": -0.14,
        "Check_Data": "Nein, Verlust im Land",
        "Pot. Mehrsteuer": 294901,
        "De Minimis?": "N/A",
        "5% Check": 5560,
        "Revenues": None,
        "Salaries": 600,
        "Net Loss": 0
    },
    {
        "Country": "Land Frankreich",
        "Currency": "€",
        "EBT": 30126,
        "Taxes": 1267,
        "Quote": 4.20,
        "Check_Data": "Ja, Gewinn und Quote unter 15%",
        "Pot. Mehrsteuer": 4519,
        "De Minimis?": "De Minimus' Test greift",
        "5% Check": 6691332,
        "Revenues": None,
        "Salaries": 298405,
        "Net Loss": 0
    },
    {
        "Country": "Land Großbritannien",
        "Currency": "€",
        "EBT": -1364065,
        "Taxes": -582332,
        "Quote": 42.69,
        "Check_Data": "Nein, Verlust im Land",
        "Pot. Mehrsteuer": 20880504,
        "De Minimis?": "N/A",
        "5% Check": 433276,
        "Revenues": None,
        "Salaries": 0,
        "Net Loss": 0
    },
    {
        "Country": "Land Hongkong",
        "Currency": "€",
        "EBT": 1103555,
        "Taxes": 164153,
        "Quote": 14.87,
        "Check_Data": "Ja, Gewinn und Quote unter 15%",
        "Pot. Mehrsteuer": 165533,
        "De Minimis?": "Kein 'De Minimus' Fall; EBT zu hoch; Umsatz zu hoch",
        "5% Check": 17279773,
        "Revenues": 1103555,
        "Salaries": 0,
        "Net Loss": 1381
    },
    {
        "Country": "Land Indien",
        "Currency": "€",
        "EBT": 262694,
        "Taxes": 49709,
        "Quote": 18.92,
        "Check_Data": "Nein, Gewinn und Quote>= 15%",
        "Pot. Mehrsteuer": 1544992,
        "De Minimis?": "N/A",
        "5% Check": 6154,
        "Revenues": None,
        "Salaries": -28863,
        "Net Loss": 0
    },
    {
        "Country": "Land Japan",
        "Currency": "€",
        "EBT": 1634316,
        "Taxes": 572843,
        "Quote": 35.05,
        "Check_Data": "Nein, Gewinn und Quote>= 15%",
        "Pot. Mehrsteuer": 13319184,
        "De Minimis?": "N/A",
        "5% Check": 82819,
        "Revenues": None,
        "Salaries": 38108,
        "Net Loss": 0
    },
    {
        "Country": "Land Kanada",
        "Currency": "€",
        "EBT": 8586955,
        "Taxes": 1946076,
        "Quote": 22.66,
        "Check_Data": "Nein, Gewinn und Quote>= 15%",
        "Pot. Mehrsteuer": 54167451,
        "De Minimis?": "N/A",
        "5% Check": 325744,
        "Revenues": None,
        "Salaries": 169119,
        "Net Loss": -186086
    },
    {
        "Country": "Land Niederlande",
        "Currency": "€",
        "EBT": 804169,
        "Taxes": 163865,
        "Quote": 20.38,
        "Check_Data": "Nein, Gewinn und Quote>= 15%",
        "Pot. Mehrsteuer": 3600132,
        "De Minimis?": "N/A",
        "5% Check": 33513,
        "Revenues": None,
        "Salaries": 5548,
        "Net Loss": 0
    },
    {
        "Country": "Land Schweiz",
        "Currency": "€",
        "EBT": 14813848,
        "Taxes": 1987060,
        "Quote": 13.41,
        "Check_Data": "Ja, Gewinn und Quote unter 15%",
        "Pot. Mehrsteuer": 2222077,
        "De Minimis?": "Kein 'De Minimus' Fall; EBT zu hoch; Umsatz zu hoch",
        "5% Check": 117717474,
        "Revenues": 7960207,
        "Salaries": 4452630,
        "Net Loss": 0
    },
    {
        "Country": "Land Singapur",
        "Currency": "€",
        "EBT": -144261,
        "Taxes": 32455,
        "Quote": -22.50,
        "Check_Data": "Nein, Verlust im Land",
        "Pot. Mehrsteuer": 2988059,
        "De Minimis?": "N/A",
        "5% Check": 5223,
        "Revenues": None,
        "Salaries": 0,
        "Net Loss": 0
    },
    {
        "Country": "Land Spanien",
        "Currency": "€",
        "EBT": -9681319,
        "Taxes": 823250,
        "Quote": -8.50,
        "Check_Data": "Nein, Verlust im Land",
        "Pot. Mehrsteuer": 1071584,
        "De Minimis?": "N/A",
        "5% Check": 196269,
        "Revenues": None,
        "Salaries": 812250,
        "Net Loss": 0
    },
    {
        "Country": "Land Südkorea",
        "Currency": "€",
        "EBT": 639996,
        "Taxes": 44057,
        "Quote": 6.88,
        "Check_Data": "Ja, Gewinn und Quote unter 15%",
        "Pot. Mehrsteuer": 95999,
        "De Minimis?": "De Minimus' Test greift",
        "5% Check": 7634468,
        "Revenues": None,
        "Salaries": 160552,
        "Net Loss": 0
    },
    {
        "Country": "Land Taiwan",
        "Currency": "€",
        "EBT": 892780,
        "Taxes": 180293,
        "Quote": 20.19,
        "Check_Data": "Nein, Gewinn und Quote>= 15%",
        "Pot. Mehrsteuer": 5547897,
        "De Minimis?": "N/A",
        "5% Check": 32348,
        "Revenues": None,
        "Salaries": -20675,
        "Net Loss": 1277
    },
    {
        "Country": "Land USA",
        "Currency": "€",
        "EBT": -1450430,
        "Taxes": 1234741,
        "Quote": -85.13,
        "Check_Data": "Nein, Verlust im Land",
        "Pot. Mehrsteuer": 728277,
        "De Minimis?": "N/A",
        "5% Check": 0,
        "Revenues": None,
        "Salaries": 3205307,
        "Net Loss": -41751
    }
    ]

    for item in data:
        TaxData.objects.create(
            country=item['Country'],
            currency=item['Currency'],
            ebt=item['EBT'],
            taxes=item['Taxes'],
            quote=item['Quote'],
            check_data=item['Check_Data'],
            pot_mehrsteuer=item['Pot. Mehrsteuer'],
            de_minimis=item['De Minimis?'],
            five_percent_check=item['5% Check'],
            revenues=item['Revenues'],
            salaries=item['Salaries'],
            net_loss=item['Net Loss']
        )


class Migration(migrations.Migration):

    dependencies = [
        ('taxtech', '0004_auto_20241125_1038'),
    ]

    operations = [
        migrations.RunPython(add_default_entries),
    ]