check-post-suggestions.php

<?php
/**
 * Diagnostic script to check post suggestions
 * Access: https://wegenius.fahmidsroadmap.com/check-post-suggestions.php
 */

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

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

use App\Models\WordPressPost;
use App\Models\ArticleAnalysis;
use App\Models\AiSuggestion;

header('Content-Type: application/json');

try {
    $postId = 3;
    
    $post = WordPressPost::with([
        'articleAnalyses' => function ($query) {
            $query->latest()->limit(1);
        },
        'suggestions' => function ($query) {
            $query->orderBy('status')->orderBy('created_at', 'desc');
        }
    ])->find($postId);
    
    if (!$post) {
        echo json_encode(['error' => 'Post not found'], JSON_PRETTY_PRINT);
        exit;
    }
    
    $latestAnalysis = $post->articleAnalyses->first();
    
    $suggestionsData = $post->suggestions->map(function ($suggestion) {
        // Decode and format suggested content for display
        $suggestedContent = $suggestion->suggested_content;
        if (is_string($suggestedContent)) {
            $decoded = json_decode($suggestedContent, true);
            if (is_array($decoded)) {
                $suggestedContent = $decoded;
            }
        }
        
        return [
            'id' => $suggestion->id,
            'type' => $suggestion->type,
            'section' => $suggestion->section,
            'position' => $suggestion->position,
            'original_content' => $suggestion->original_content,
            'suggested_content' => $suggestedContent,
            'suggested_content_raw' => $suggestion->suggested_content,
            'explanation' => $suggestion->explanation,
            'meta_data' => $suggestion->meta_data,
            'status' => $suggestion->status,
            'implemented_at' => $suggestion->implemented_at?->format('M d, Y H:i'),
            'created_at' => $suggestion->created_at->format('M d, Y H:i'),
        ];
    });
    
    echo json_encode([
        'post_id' => $postId,
        'post_title' => $post->title,
        'analysis' => [
            'id' => $latestAnalysis?->id,
            'status' => $latestAnalysis?->status,
            'overall_score' => $latestAnalysis?->overall_score,
        ],
        'suggestions_count' => $suggestionsData->count(),
        'suggestions' => $suggestionsData->toArray(),
    ], JSON_PRETTY_PRINT | JSON_UNESCAPED_SLASHES);
    
} catch (\Exception $e) {
    echo json_encode([
        'error' => $e->getMessage(),
        'trace' => $e->getTraceAsString()
    ], JSON_PRETTY_PRINT);
}