<?php
require_once '../../config/config.php';
header('Content-Type: application/json');

try {
    $section_id = (int)($_GET['section_id'] ?? 0);
    if ($section_id <= 0) { echo json_encode(['status'=>'success','data'=>[]]); exit; }
    $stmt = $pdo->prepare('SELECT id, section_id, question_no, question_type, cognitive_level, question_text, co_codes, po_codes FROM pattern_questions WHERE section_id = ? ORDER BY question_no');
    $stmt->execute([$section_id]);
    $rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
    foreach ($rows as &$r) { 
        $r['po_codes'] = $r['po_codes'] ? json_decode($r['po_codes'], true) : []; 
        $r['co_codes'] = $r['co_codes'] ? json_decode($r['co_codes'], true) : []; 
        $r['question_no'] = (string)$r['question_no']; // Ensure question_no is always a string
    }
    echo json_encode(['status'=>'success','data'=>$rows]);
} catch (Throwable $e) {
    http_response_code(500);
    echo json_encode(['status'=>'error','message'=>$e->getMessage()]);
}
?>