from django.contrib import admin
from django.utils.html import format_html
from .forms import UnloadingPointForm
from .models import RouteDistance, TariffImport, UnloadingPointImport, TransportTariff, UnloadingPoint, UnloadingPointPrice


@admin.register(TransportTariff)
class TransportTariffAdmin(admin.ModelAdmin):
    list_display = ('id', 'km_from', 'km_to', 'price_per_ton_km', 'last_updated')
    list_display_links = ('id',)
    list_editable = ('km_from', 'km_to', 'price_per_ton_km')
    ordering = ('km_from',)
    list_per_page = 100


class UnloadingPointPriceInline(admin.TabularInline):
    model = UnloadingPointPrice
    extra = 1
    fields = ('culture', 'specification', 'price', 'status', 'last_updated')
    readonly_fields = ('last_updated',)
    autocomplete_fields = ('culture',)


@admin.register(UnloadingPoint)
class UnloadingPointAdmin(admin.ModelAdmin):
    form = UnloadingPointForm
    inlines = [UnloadingPointPriceInline]
    list_display = ('name', 'region', 'district', 'settlement', 'terminal', 'display_cultures', 'map_link', 'active', 'last_updated')
    list_filter = ('active', 'region')
    search_fields = ('name', 'settlement', 'terminal', 'region__name', 'district__name')
    fieldsets = (
        (None, {'fields': ('name', 'terminal', 'active')}),
        ('Розташування', {'fields': ('region', 'district', 'settlement')}),
        ('Координати (необов\'язково)', {'fields': ('latitude', 'longitude')}),
        (None, {'fields': ('comment',)}),
    )

    def get_queryset(self, request):
        return super().get_queryset(request).select_related('region', 'district').prefetch_related('prices__culture')

    @admin.display(description='Культури та ціни')
    def display_cultures(self, obj):
        return "; ".join(
            f"{p.culture}{' ' + p.specification if p.specification else ''}: "
            f"{p.price if p.status == 'active' else p.get_status_display()}"
            for p in obj.prices.all()
        )

    @admin.display(description='Карта')
    def map_link(self, obj):
        if obj.latitude is None or obj.longitude is None:
            return ''
        return format_html('<a href="https://www.google.com/maps?q={},{}" target="_blank">мапа</a>', obj.latitude, obj.longitude)


@admin.register(UnloadingPointPrice)
class UnloadingPointPriceAdmin(admin.ModelAdmin):
    list_display = ('culture', 'specification', 'unloading_point', 'region_name', 'price', 'status', 'last_updated')
    list_editable = ('price', 'status')
    list_filter = ('status', 'culture', 'unloading_point__region')
    search_fields = ('culture__cultureable_name', 'specification', 'unloading_point__name')
    autocomplete_fields = ('culture', 'unloading_point')
    list_select_related = ('culture', 'unloading_point__region')

    @admin.display(description='Область', ordering='unloading_point__region__name')
    def region_name(self, obj):
        return obj.unloading_point.region


@admin.register(RouteDistance)
class RouteDistanceAdmin(admin.ModelAdmin):
    list_display = ('farmer', 'unloading_point', 'distance_km', 'duration_min', 'fetched_at')
    search_fields = ('farmer__name', 'unloading_point__name')
    list_select_related = ('farmer', 'unloading_point')
    raw_id_fields = ('farmer',)
    readonly_fields = ('origin', 'destination', 'fetched_at')


@admin.register(TariffImport)
class TariffImportAdmin(admin.ModelAdmin):
    list_display = ('created_at', 'user', 'source', 'old_count', 'new_count')
    readonly_fields = ('created_at', 'user', 'source', 'sheet_url', 'old_count', 'new_count')


@admin.register(UnloadingPointImport)
class UnloadingPointImportAdmin(admin.ModelAdmin):
    list_display = ('created_at', 'user', 'source', 'created', 'updated', 'deleted')
    readonly_fields = ('created_at', 'user', 'source', 'sheet_url', 'created', 'updated', 'deleted', 'deleted_names')
