# 第2フェーズ成果物:完全な管理CRUDシステム
php artisan migrate:fresh --seed
# → 10以上のテーブル, 100以上のレコード, 全CRUD動作

// database/migrations/2024_01_01_000001_create_plans_table.php
Schema::create('plans', function (Blueprint $table) {
    $table->id();
    $table->string('name');
    $table->string('slug')->unique();
    $table->decimal('price', 8, 2);
    $table->integer('shop_limit')->default(5);
    $table->json('features')->nullable();
    $table->boolean('is_active')->default(true);
    $table->timestamps();
});

// database/migrations/2024_01_01_000005_create_shops_table.php
Schema::create('shops', function (Blueprint $table) {
    $table->id();
    $table->foreignId('tenant_id')->constrained()->cascadeOnDelete();
    $table->string('name');
    $table->string('slug');
    $table->text('description')->nullable();
    $table->enum('status', ['active', 'suspended', 'closed'])->default('active');
    $table->decimal('revenue', 12, 2)->default(0);
    $table->timestamps();
    $table->softDeletes();
    $table->unique(['tenant_id', 'slug']);
    $table->index(['tenant_id', 'status']);
});

// 実行成功

// app/Models/Tenant.php
class Tenant extends Model
{
    protected $fillable = ['name', 'slug', 'domain', 'plan_id', 'status'];
    protected $casts = ['status' => 'string'];

    public function shops(): HasMany
    {
        return $this->hasMany(Shop::class);
    }

    public function users(): HasMany
    {
        return $this->hasMany(User::class);
    }

    public function subscription(): HasOne
    {
        return $this->hasOne(Subscription::class)->where('status', 'active');
    }

    public function scopeActive(Builder $query): Builder
    {
        return $query->where('status', 'active');
    }

    public function getDomainUrlAttribute(): string
    {
        return 'https://' . $this->domain;
    }
}

// app/Models/Shop.php
class Shop extends Model
{
    use SoftDeletes;

    protected $fillable = ['tenant_id', 'name', 'slug', 'description', 'status', 'revenue'];
    protected $casts = ['revenue' => 'decimal:2', 'deleted_at' => 'datetime'];

    public function tenant(): BelongsTo
    {
        return $this->belongsTo(Tenant::class);
    }

    public function products(): HasMany
    {
        return $this->hasMany(Product::class);
    }

    public function orders(): HasMany
    {
        return $this->hasMany(Order::class);
    }

    public function scopeActive(Builder $query): Builder
    {
        return $query->where('status', 'active');
    }

    public function getRevenueFormattedAttribute(): string
    {
        return '$' . number_format($this->revenue, 2);
    }
}

// app/Models/Product.php
class Product extends Model
{
    protected $fillable = ['shop_id', 'name', 'sku', 'price', 'stock', 'is_active'];
    protected $casts = ['price' => 'decimal:2', 'is_active' => 'boolean'];

    public function shop(): BelongsTo
    {
        return $this->belongsTo(Shop::class);
    }

    public function categories(): BelongsToMany
    {
        return $this->belongsToMany(Category::class)->withTimestamps();
    }

    public function scopeActive(Builder $query): Builder
    {
        return $query->where('is_active', true);
    }

    public function scopeInStock(Builder $query): Builder
    {
        return $query->where('stock', '>', 0);
    }

    public function getPriceFormattedAttribute(): string
    {
        return '$' . number_format($this->price, 2);
    }
}

// 実行成功

// app/Http/Controllers/ShopController.php
class ShopController extends Controller
{
    public function __construct()
    {
        $this->middleware('auth');
        $this->middleware('tenant.resolve');
    }

    public function index(Request $request): View
    {
        $shops = Shop::where('tenant_id', tenant()->id)
            ->withCount(['products', 'orders as recent_orders' => fn ($q) => $q->where('created_at', '>=', now()->subDays(30))])
            ->when($request->search, fn ($q, $s) => $q->where('name', 'like', "%{$s}%"))
            ->when($request->status, fn ($q, $s) => $q->where('status', $s))
            ->orderBy($request->sort ?? 'created_at', $request->direction ?? 'desc')
            ->paginate(15);

        return view('shops.index', compact('shops'));
    }

    public function create(): View
    {
        return view('shops.create');
    }

    public function store(StoreShopRequest $request): RedirectResponse
    {
        $shop = Shop::create(array_merge(
            $request->validated(),
            ['tenant_id' => tenant()->id],
        ));

        return redirect()->route('shops.show', $shop)
            ->with('success', 'Shop created successfully.');
    }

    public function show(Shop $shop): View
    {
        $shop->load(['products' => fn ($q) => $q->active()->latest()->take(10),
                      'orders' => fn ($q) => $q->with('user')->latest()->take(10)]);

        $stats = [
            'total_revenue' => $shop->orders()->completed()->sum('total'),
            'total_orders' => $shop->orders()->count(),
            'total_products' => $shop->products()->active()->count(),
        ];

        return view('shops.show', compact('shop', 'stats'));
    }

    public function edit(Shop $shop): View
    {
        return view('shops.edit', compact('shop'));
    }

    public function update(UpdateShopRequest $request, Shop $shop): RedirectResponse
    {
        $shop->update($request->validated());
        return redirect()->route('shops.show', $shop)
            ->with('success', 'Shop updated.');
    }

    public function destroy(Shop $shop): RedirectResponse
    {
        $shop->delete();
        return redirect()->route('shops.index')
            ->with('success', 'Shop deleted.');
    }
}

// 実行成功

// app/Http/Requests/StoreShopRequest.php
class StoreShopRequest extends FormRequest
{
    public function authorize(): bool
    {
        return auth()->user()->role === 'tenant_owner';
    }

    public function rules(): array
    {
        return [
            'name' => 'required|string|max:255',
            'slug' => 'required|alpha_dash|unique:shops,slug,NULL,id,tenant_id,' . tenant()->id,
            'description' => 'nullable|string|max:5000',
            'status' => 'sometimes|in:active,suspended',
        ];
    }

    protected function prepareForValidation(): void
    {
        $this->merge(['slug' => Str::slug($this->slug ?? $this->name)]);
    }
}

// app/Http/Requests/StoreProductRequest.php
class StoreProductRequest extends FormRequest
{
    public function rules(): array
    {
        return [
            'name' => 'required|string|max:255',
            'sku' => 'required|string|unique:products,sku',
            'price' => 'required|numeric|min:0.01|max:999999.99',
            'stock' => 'required|integer|min:0',
            'description' => 'nullable|string|max:5000',
            'is_active' => 'boolean',
            'categories' => 'sometimes|array',
            'categories.*' => 'exists:categories,id',
            'image' => 'sometimes|image|max:2048',
        ];
    }
}

// 実行成功

// database/seeders/ShopMetricsSeeder.php
class ShopMetricsSeeder extends Seeder
{
    public function run(): void
    {
        $starter = Plan::create(['name' => 'Starter', 'slug' => 'starter', 'price' => 29, 'shop_limit' => 5, 'features' => ['basic_analytics']]);
        $pro = Plan::create(['name' => 'Pro', 'slug' => 'pro', 'price' => 79, 'shop_limit' => 25, 'features' => ['advanced_analytics', 'api']]);
        $enterprise = Plan::create(['name' => 'Enterprise', 'slug' => 'enterprise', 'price' => 199, 'shop_limit' => null, 'features' => ['all']]);

        User::factory()->create(['email' => 'admin@shopmetrics.io', 'role' => 'super_admin']);

        Category::factory()->count(10)->create();

        Tenant::factory()->count(20)->create()->each(function ($tenant) use ($starter, $pro, $enterprise) {
            $plan = fake()->randomElement([$starter, $pro, $enterprise]);
            Subscription::create(['tenant_id' => $tenant->id, 'plan_id' => $plan->id, 'status' => 'active']);
            $owner = User::factory()->for($tenant)->create(['role' => 'tenant_owner']);
            $analysts = User::factory()->count(3)->for($tenant)->create(['role' => 'analyst']);

            $shopCount = min(fake()->numberBetween(2, 5), $plan->shop_limit ?? 99);
            Shop::factory()->count($shopCount)->for($tenant)->create()->each(function ($shop) use ($tenant, $owner, $analysts) {
                $products = Product::factory()->count(fake()->numberBetween(10, 30))->for($shop)->create();
                $products->each(fn ($p) => $p->categories()->attach(Category::inRandomOrder()->take(rand(1, 3))->pluck('id')));

                Order::factory()->count(fake()->numberBetween(20, 60))->for($tenant)->for($shop)->for(fake()->randomElement(array_merge([$owner], $analysts->all())))->create()->each(function ($order) use ($products) {
                    $items = $products->random(rand(1, 5));
                    foreach ($items as $product) {
                        $qty = rand(1, 3);
                        $order->items()->create(['product_id' => $product->id, 'quantity' => $qty, 'price' => $product->price]);
                    }
                    $order->update(['total' => $order->items->sum(fn ($i) => $i->price * $i->quantity)]);
                });
            });
        });
    }
}

// 実行成功

composer require barryvdh/laravel-debugbar --dev

// 開発環境ではDebugbarが各ページのクエリ数を表示
// N+1を段階的に最適化:

// ステップ1:特定 — Debugbarがshops.indexで"41 queries"と表示
// ステップ2:Eagerローディングを追加
$shops = Shop::with(['products', 'tenant', 'orders'])->get(); // 4クエリ
// ステップ3:完全な関連の代わりにwithCountを使用
$shops = Shop::withCount('products', 'orders')->with('tenant')->get(); // 3クエリ
// ステップ4:確認 — Debugbarが"3 queries"と表示

// 実行成功

// ============================================
// 総合:ShopMetrics管理CRUDセットアップ
// カバー:マイグレーション, モデル, コントローラ, リクエスト, シーダー
// ============================================

// セットアップコマンド (順番に実行)
// 1. php artisan migrate:fresh --seed
// 2. php artisan storage:link
// 3. php artisan serve

// routes/web.php — 完全な管理ルート
Route::middleware('auth')->prefix('dashboard')->name('dashboard.')->group(function () {
    Route::get('/', [DashboardController::class, 'index'])->name('index');

    // 店舗CRUD
    Route::resource('shops', ShopController::class);
    Route::post('/shops/{shop}/logo', [ShopLogoController::class, 'update'])->name('shops.logo');

    // 商品CRUD (店舗の下にネスト)
    Route::resource('shops.products', ProductController::class)->shallow();

    // 注文 (読み取り専用 + ステータス更新)
    Route::resource('orders', OrderController::class)->only(['index', 'show', 'update']);
    Route::post('/orders/{order}/export', ExportOrdersController::class)->name('orders.export');

    // カテゴリ (シンプルCRUD)
    Route::resource('categories', CategoryController::class)->except('show');

    // アナリティクス
    Route::get('/analytics', [AnalyticsController::class, 'index'])->name('analytics');
});

// 最適化クエリ付きDashboardController
class DashboardController extends Controller
{
    public function index(): View
    {
        $tenant = tenant();
        $stats = Cache::remember("dashboard.{$tenant->id}", 300, function () use ($tenant) {
            return [
                'total_revenue' => $tenant->shops()->sum('revenue'),
                'active_shops' => $tenant->shops()->active()->count(),
                'monthly_orders' => $tenant->orders()->whereBetween('created_at', [now()->startOfMonth(), now()->endOfMonth()])->count(),
                'total_products' => Product::whereHas('shop', fn ($q) => $q->where('tenant_id', $tenant->id))->active()->count(),
            ];
        });

        $recentOrders = Order::where('tenant_id', $tenant->id)
            ->with(['shop', 'user'])
            ->latest()
            ->take(5)
            ->get();

        return view('dashboard.index', compact('stats', 'recentOrders'));
    }
}