setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// Crear tabla automáticamente si no existe
$pdo->exec("CREATE TABLE IF NOT EXISTS rto_app_data (
doc_key VARCHAR(50) PRIMARY KEY,
doc_value LONGTEXT
)");
if ($_SERVER['REQUEST_METHOD'] === 'GET') {
$stmt = $pdo->query("SELECT doc_key, doc_value FROM rto_app_data");
$result = ['config' => null, 'history' => null, 'pending_records' => null, 'pending_extras' => null];
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
$result[$row['doc_key']] = json_decode($row['doc_value'], true);
}
echo json_encode(['success' => true, 'data' => $result]);
}
elseif ($_SERVER['REQUEST_METHOD'] === 'POST') {
$input = json_decode(file_get_contents('php://input'), true);
if (isset($input['doc_key']) && isset($input['doc_value'])) {
$stmt = $pdo->prepare("INSERT INTO rto_app_data (doc_key, doc_value) VALUES (?, ?) ON DUPLICATE KEY UPDATE doc_value = ?");
$val = json_encode($input['doc_value']);
$stmt->execute([$input['doc_key'], $val, $val]);
echo json_encode(['success' => true]);
} else {
echo json_encode(['success' => false, 'error' => 'Datos incompletos']);
}
}
} catch (PDOException $e) {
echo json_encode(['success' => false, 'error' => $e->getMessage()]);
}
exit;
}
?>
Planilla Comisiones - RTO Seguros
