#!/usr/bin/env php
<?php

/**
 * Test regex for removing markdown tables
 */

require __DIR__.'/../vendor/autoload.php';

$app = require_once __DIR__.'/../bootstrap/app.php';
$kernel = $app->make(Illuminate\Contracts\Console\Kernel::class);
$kernel->bootstrap();

use App\Models\AuditLibrary\AuditTemplate;

$pattern = '/\|[^\n]+\|\s*\n\|[-:\s|]+\|/';
$removePattern = '/\n*\|[^\n]+\|\s*\n\|[-:\s|]+\|\s*\n?(?:\|[^\n]+\|\s*\n?)*/';

$templates = AuditTemplate::whereNotNull('description')
    ->where('description', 'like', '%Finding%')
    ->limit(5)
    ->get();

foreach ($templates as $t) {
    echo "=== Template #{$t->id}: {$t->name} ===\n";
    echo 'Has table: '.(preg_match($pattern, $t->description) ? 'YES' : 'NO')."\n";

    if (preg_match($pattern, $t->description)) {
        $cleaned = preg_replace($removePattern, '', $t->description);
        $cleaned = preg_replace('/\n{3,}/', "\n\n", $cleaned);
        $cleaned = rtrim($cleaned);

        echo 'Original length: '.strlen($t->description)."\n";
        echo 'Cleaned length: '.strlen($cleaned)."\n";
        echo "Cleaned result:\n".$cleaned."\n";
    }
    echo "\n";
}