<?php
require_once "{$_SERVER['DOCUMENT_ROOT']}/dependencies.php";
if (!isset($_SESSION['user'])) {
    returnResponse(status: 401, error: true, message: 'No se ha iniciado sesión');
    exit();
}

header('Content-Type: application/json');
$params = [
    'moodle_id' => $_SESSION['moodle_id'],
    'username' => $_POST['username']
];
$calificaciones = $db->query("SELECT * from jsonb_array_elements(public.consulta_moodle(
    consulta =>	(SELECT replace(consulta_sql, ';', '') from consulta whERE clave = 'c-fin')::TEXT,
    moodle_id => :moodle_id
)) AS calificaciones WHERE calificaciones->>'username' = :username;",
    $params
) ?? [];
$calificaciones = array_column($calificaciones, 'value');
$calificaciones = array_map(fn($calificacion) => json_decode($calificacion), $calificaciones);

$timeline = $db->query('SELECT * from public.promedio_snapshot(
    moodle_host_id_param => :moodle_id,
    username_param => :username)',
    $params
) ?? [];

echo json_encode([
    'calificaciones' => $calificaciones,
    'timeline' => $timeline
]);