strprfcrm/database/migrations/2025_11_06_141206_create_reclamation_views_table.php

<?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
    {
        $sql = "CREATE OR REPLACE VIEW reclamations_view AS
       	
                SELECT r.*,
                    u.name as user_name,
                    u1.name as brigadier_name,
                    o.year,
                    o.name as order_name,
                    o.object_address,
                    o.district_name,
                    o.area_name,
                    o.object_type_name,
                    rs.name as status_name
                FROM reclamations r 
                    LEFT JOIN users u ON r.user_id = u.id
                    LEFT JOIN users u1 ON r.brigadier_id = u1.id
                    LEFT JOIN reclamation_statuses rs ON r.status_id = rs.id
                    LEFT JOIN orders_view o ON r.order_id = o.id";
        DB::unprepared($sql);
    }

    /**
     * Reverse the migrations.
     */
    public function down(): void
    {
        DB::unprepared('DROP VIEW IF EXISTS reclamations_view');
    }
};