<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    /**
     * Run the migrations.
     */
    public function up(): void
    {
        Schema::table("kanban_tasks", function (Blueprint $table) {
            // Location fields for Google Maps integration
            $table->decimal("latitude", 10, 8)->nullable()->after("due_date");
            $table->decimal("longitude", 11, 8)->nullable()->after("latitude");
            $table->string("location_name")->nullable()->after("longitude");
            $table->text("location_address")->nullable()->after("location_name");
            
            // Labels/Tags support
            $table->json("labels")->nullable()->after("location_address");
            $table->json("tags")->nullable()->after("labels");
            
            // Due time (separate from due_date for better time handling)
            $table->time("due_time")->nullable()->after("due_date");
            
            // Add indexes for new fields
            $table->index(["latitude", "longitude"]);
            $table->index(["labels"]);
            $table->index(["tags"]);
        });
    }

    /**
     * Reverse the migrations.
     */
    public function down(): void
    {
        Schema::table("kanban_tasks", function (Blueprint $table) {
            $table->dropIndex(["latitude", "longitude"]);
            $table->dropIndex(["labels"]);
            $table->dropIndex(["tags"]);
            
            $table->dropColumn([
                "latitude",
                "longitude", 
                "location_name",
                "location_address",
                "labels",
                "tags",
                "due_time"
            ]);
        });
    }
};