# Generated by Django 5.2.5 on 2025-08-06 17:35

import django.db.models.deletion
import uuid
from django.db import migrations, models


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='Bouquet',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=200)),
                ('sku', models.CharField(max_length=80, unique=True)),
                ('active', models.BooleanField(default=True)),
                ('capacity_per_day', models.PositiveIntegerField(default=30)),
            ],
        ),
        migrations.CreateModel(
            name='Stem',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=120, unique=True)),
                ('sku', models.CharField(max_length=80, unique=True)),
                ('stock_quantity', models.PositiveIntegerField(default=0)),
                ('reserved_quantity', models.PositiveIntegerField(default=0)),
                ('low_stock_threshold', models.PositiveIntegerField(default=5)),
            ],
        ),
        migrations.CreateModel(
            name='Reservation',
            fields=[
                ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
                ('quantity', models.PositiveIntegerField(default=1)),
                ('delivery_date', models.DateField()),
                ('status', models.CharField(choices=[('pending', 'Pending'), ('confirmed', 'Confirmed'), ('cancelled', 'Cancelled'), ('expired', 'Expired')], default='pending', max_length=10)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('expires_at', models.DateTimeField()),
                ('woo_order_id', models.CharField(blank=True, max_length=120, null=True)),
                ('payment_ref', models.CharField(blank=True, max_length=200, null=True)),
                ('idempotency_key', models.CharField(blank=True, max_length=200, null=True)),
                ('bouquet', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='project.bouquet')),
            ],
        ),
        migrations.CreateModel(
            name='OrderRecord',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('woo_order_id', models.CharField(max_length=120, unique=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('customer_name', models.CharField(blank=True, max_length=200)),
                ('customer_phone', models.CharField(blank=True, max_length=50)),
                ('customer_email', models.EmailField(blank=True, max_length=254)),
                ('total_amount', models.DecimalField(blank=True, decimal_places=2, max_digits=10, null=True)),
                ('reservation', models.OneToOneField(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='project.reservation')),
            ],
        ),
        migrations.CreateModel(
            name='BouquetStem',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('units_needed', models.PositiveIntegerField(default=1)),
                ('bouquet', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='project.bouquet')),
                ('stem', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='project.stem')),
            ],
        ),
        migrations.AddField(
            model_name='bouquet',
            name='stems',
            field=models.ManyToManyField(through='project.BouquetStem', to='project.stem'),
        ),
        migrations.CreateModel(
            name='DailyCapacity',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('date', models.DateField()),
                ('confirmed_orders', models.PositiveIntegerField(default=0)),
                ('reserved_orders', models.PositiveIntegerField(default=0)),
                ('bouquet', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='project.bouquet')),
            ],
            options={
                'unique_together': {('bouquet', 'date')},
            },
        ),
        migrations.AddIndex(
            model_name='reservation',
            index=models.Index(fields=['status', 'expires_at'], name='project_res_status_78fa4d_idx'),
        ),
        migrations.AlterUniqueTogether(
            name='bouquetstem',
            unique_together={('bouquet', 'stem')},
        ),
    ]
