from decimal import Decimal
from django.db import migrations

# Початкові тарифи з файлу "Тарифи для СРМ.xlsx"
TARIFFS = [
    (0, 25, '32'), (26, 50, '18'), (51, 75, '14.6'), (76, 100, '12'),
    (101, 125, '10.4'), (126, 150, '9.3'), (151, 175, '8.2'), (176, 200, '7.5'),
    (201, 225, '6.8'), (226, 250, '6.4'), (251, 275, '6'), (276, 300, '5.6'),
    (301, 325, '5.5'), (326, 350, '5.4'), (351, 375, '5.3'), (376, 400, '5.2'),
    (401, 425, '5.15'), (426, 450, '5.1'), (451, 475, '5.05'), (476, 500, '5'),
    (501, 525, '4.95'), (526, 550, '4.9'), (551, 575, '4.86'), (576, 600, '4.83'),
    (601, 650, '4.6'), (651, 700, '4.4'), (701, 750, '4.2'), (751, 800, '4.125'),
    (801, 850, '4'), (851, 900, '3.88'), (901, 950, '2.6'), (951, 1000, '2.6'),
]


def load_tariffs(apps, schema_editor):
    TransportTariff = apps.get_model('pricing', 'TransportTariff')
    if TransportTariff.objects.exists():
        return
    TransportTariff.objects.bulk_create([
        TransportTariff(km_from=km_from, km_to=km_to, price_per_ton_km=Decimal(price))
        for km_from, km_to, price in TARIFFS
    ])


class Migration(migrations.Migration):

    dependencies = [
        ('pricing', '0001_initial'),
    ]

    operations = [
        migrations.RunPython(load_tariffs, migrations.RunPython.noop),
    ]
