from django.db import migrations, models


GCC_CODES = {'SAR', 'QAR', 'KWD', 'BHD', 'OMR'}
GCC_DEFAULT = 'SAR'


def _gcc_or_default(code: str | None) -> str:
    value = (code or '').strip().upper()
    return value if value in GCC_CODES else GCC_DEFAULT


def backfill_vehicle_rate_currency(apps, schema_editor):
    from core.currencies import currency_code_for_country

    ZoneVehicleRate = apps.get_model('core', 'ZoneVehicleRate')
    FreightRouteVehicleRate = apps.get_model('core', 'FreightRouteVehicleRate')

    for row in ZoneVehicleRate.objects.select_related('zone').iterator():
        mapped = currency_code_for_country(getattr(row.zone, 'country_code', None), default='')
        row.currency = _gcc_or_default(mapped)
        row.save(update_fields=['currency'])

    for row in FreightRouteVehicleRate.objects.select_related('route').iterator():
        route_currency = getattr(row.route, 'currency', None)
        row.currency = _gcc_or_default(route_currency)
        row.save(update_fields=['currency'])


class Migration(migrations.Migration):

    dependencies = [
        ('core', '0042_country_vat_fixed_amount'),
    ]

    operations = [
        migrations.AddField(
            model_name='zonevehiclerate',
            name='currency',
            field=models.CharField(
                choices=[
                    ('SAR', 'SAR — Saudi riyal'),
                    ('QAR', 'QAR — Qatari riyal'),
                    ('KWD', 'KWD — Kuwaiti dinar'),
                    ('BHD', 'BHD — Bahraini dinar'),
                    ('OMR', 'OMR — Omani rial'),
                ],
                default='SAR',
                help_text='GCC currency for this vehicle-type rate (SAR/QAR/KWD/BHD/OMR).',
                max_length=3,
            ),
        ),
        migrations.AddField(
            model_name='freightroutevehiclerate',
            name='currency',
            field=models.CharField(
                choices=[
                    ('SAR', 'SAR — Saudi riyal'),
                    ('QAR', 'QAR — Qatari riyal'),
                    ('KWD', 'KWD — Kuwaiti dinar'),
                    ('BHD', 'BHD — Bahraini dinar'),
                    ('OMR', 'OMR — Omani rial'),
                ],
                default='SAR',
                help_text='GCC currency for this vehicle-type rate (SAR/QAR/KWD/BHD/OMR).',
                max_length=3,
            ),
        ),
        migrations.RunPython(backfill_vehicle_rate_currency, migrations.RunPython.noop),
    ]
