#!/bin/bash
cd /var/www/html
php -r "
require 'vendor/autoload.php';
\$app = require_once 'bootstrap/app.php';
\$kernel = \$app->make(Illuminate\Contracts\Console\Kernel::class);
\$kernel->bootstrap();

use Illuminate\Support\Facades\DB;

echo \"=== CHECKING DIALPLAN ===\n\n\";

// Check extensions table
echo 'Extensions table entries for *8555:\n';
\$entries = DB::table('extensions')->where('exten', '*8555')->get();
foreach (\$entries as \$e) {
    echo \"Context: {\$e->context}, Priority: {\$e->priority}, App: {\$e->app}, Data: {\$e->appdata}\n\";
}

if (\$entries->isEmpty()) {
    echo \"NO ENTRIES FOUND for *8555\n\";
}

echo \"\nTrunks-in entries for 0414501359:\n\";
\$entries = DB::table('extensions')->where('context', 'trunks-in')->where('exten', 'like', '%0414501359%')->get();
foreach (\$entries as \$e) {
    echo \"Exten: {\$e->exten}, Priority: {\$e->priority}, App: {\$e->app}\n\";
}

if (\$entries->isEmpty()) {
    echo \"NO ENTRIES FOUND for 0414501359\n\";
}

echo \"\n=== DONE ===\n\";
" 2>&1