<?php
// api/qna.php
require_once '../config/database.php';
require_once __DIR__ . '/session_auth.php';
rvu_audit_context_from_request($pdo);
header("Content-Type: application/json");

$method = $_SERVER['REQUEST_METHOD'];
$path_info = isset($_SERVER['PATH_INFO']) ? explode('/', trim($_SERVER['PATH_INFO'], '/')) : [];
$resource = $path_info[0] ?? ''; // should be 'questions'
$action_or_id = $path_info[1] ?? null;
$sub_action = $path_info[2] ?? null;

$input = json_decode(file_get_contents("php://input"), true) ?? [];

try {
    if ($resource === 'questions') {
        if ($method === 'GET' && !$action_or_id) {
            // Get questions
            $stmt = $pdo->query("SELECT * FROM qna_questions ORDER BY created_at DESC");
            $questions = $stmt->fetchAll(PDO::FETCH_ASSOC);
            
            // Get nested answers
            foreach ($questions as &$q) {
                $astmt = $pdo->prepare("SELECT * FROM qna_answers WHERE question_id = ? ORDER BY created_at ASC");
                $astmt->execute([$q['id']]);
                $q['answers'] = $astmt->fetchAll(PDO::FETCH_ASSOC);
            }
            echo json_encode($questions);
        } 
        elseif ($method === 'POST' && $action_or_id === 'ask') {
            $stmt = $pdo->prepare("INSERT INTO qna_questions (author_name, author_profile_picture, title, body, answers_count, is_resolved, created_at) VALUES (?, ?, ?, ?, 0, 0, NOW())");
            $stmt->execute([$input['author_name'], $input['author_profile_picture'] ?? null, $input['title'], $input['body']]);
            $id = $pdo->lastInsertId();
            echo json_encode(["message" => "Question submitted successfully", "id" => $id]);
        } 
        elseif ($method === 'POST' && $sub_action === 'reply' && is_numeric($action_or_id)) {
            $q_id = $action_or_id;
            
            // Insert answer
            $stmt = $pdo->prepare("INSERT INTO qna_answers (question_id, author_name, author_profile_picture, content, is_accepted, created_at) VALUES (?, ?, ?, ?, 1, NOW())");
            $stmt->execute([$q_id, $input['author_name'], $input['author_profile_picture'] ?? null, $input['content']]);
            
            // Update question stats
            $pdo->prepare("UPDATE qna_questions SET is_resolved = 1, answers_count = answers_count + 1 WHERE id = ?")->execute([$q_id]);
            echo json_encode(["message" => "Reply posted successfully"]);
        } 
        elseif ($method === 'DELETE' && is_numeric($action_or_id)) {
            $pdo->prepare("DELETE FROM qna_questions WHERE id = ?")->execute([$action_or_id]);
            echo json_encode(["message" => "Question deleted successfully"]);
        }
    }
} catch (PDOException $e) {
    http_response_code(500);
    echo json_encode(["detail" => $e->getMessage()]);
}
?>