from django.core.management.base import BaseCommand
from project.models import Bouquet, BouquetVariant
from project.utils.woocommerce_service import get_woocommerce_client

class Command(BaseCommand):
    help = "Sync WooCommerce products and variations into Django"

    def handle(self, *args, **options):
        client = get_woocommerce_client()
        page = 1
        imported_products = 0
        imported_variants = 0

        while True:
            products = client.get("products", params={"per_page": 50, "page": page}).json()
            if not products:
                break

            for product in products:
                bouquet, _ = Bouquet.objects.update_or_create(
                    woo_product_id=product["id"],
                    defaults={
                        "name": product["name"],
                        "sku": product.get("sku") or f"woo-{product['id']}",
                        "active": product["status"] == "publish",
                    },
                )
                imported_products += 1

                # Variations
                variations = client.get(f"products/{product['id']}/variations").json()
                for var in variations:
                    # Extract size from attributes
                    size = None
                    for attr in var.get("attributes", []):
                        if attr["name"].lower() == "size" or attr["name"].lower() == "pa_size":
                            size = attr.get("option")
                            break

                    if not size:  # skip if no size set
                        continue

                    variant, _ = BouquetVariant.objects.update_or_create(
                        woo_variation_id=var["id"],
                        defaults={
                            "bouquet": bouquet,
                            "size": size.capitalize(),  # e.g. Small, Medium
                            "price": var.get("price") or 0,
                        },
                    )
                    imported_variants += 1

            page += 1

        self.stdout.write(self.style.SUCCESS(
            f"✅ Imported {imported_products} products, {imported_variants} variants"
        ))
