<?php
include '../db/db.php';
include '../includes/session_control.php';

header('Content-Type: application/json');

if (!isset($_SESSION['user'])) {
    echo json_encode([]);
    exit;
}

$tipo_id = $_POST['tipo_id'];
$query = "SELECT id, nombre FROM tb_marcacion_tipo_escala WHERE idTecnica = ? ORDER BY nombre";
$stmt = $conn->prepare($query);
if ($stmt === false) {
    echo json_encode(['error' => $conn->error]);
    exit;
}

$stmt->bind_param('i', $tipo_id);
$stmt->execute();
$result = $stmt->get_result();
$rangos = [];
while ($row = $result->fetch_assoc()) {
    $rangos[] = $row;
}

if ($result === false) {
    echo json_encode(['error' => $conn->error]);
    exit;
}

echo json_encode($rangos);
?>