Endpoint y callback para turnero integrado con sistema externo

+-------------------+          +------------------+          +------------------+
|                   |  1. POST |                  |  2. POST |                  |
|    AsisteClick    | -------> |   Tu Endpoint    | -------> |   Tu Sistema     |
|    (Chatbot)      |  slots?  |  Disponibilidad  |  reserva |   de Turnos      |
|                   | <------- |                  | <------- |                  |
+-------------------+  JSON    +------------------+          +------------------+
         |                                                            |
         |  3. POST (callback)                                        |
         | <----------------------------------------------------------|
         |  EVENT.CREATED / EVENT.UPDATED / EVENT.CANCELED            |
         +------------------------------------------------------------+

https://tu-dominio.com/api/turnero/disponibilidad

https://tu-dominio.com/api/turnero/callback

{
  "calendar_id": 5,
  "timezone": "-3",
  "preferred": "2025-01-15T10:00:00",
  "count": 6,
  "start_date": "2025-01-15",
  "end_date": "2025-01-22",
  "slots": [
    {
      "text": "Miercoles 15 de Enero - 09:00",
      "isoLocal": "2025-01-15T09:00:00",
      "iso": "2025-01-15T12:00:00Z",
      "id": "slot_001"
    },
    {
      "text": "Miercoles 15 de Enero - 10:00",
      "isoLocal": "2025-01-15T10:00:00",
      "iso": "2025-01-15T13:00:00Z",
      "id": "slot_002"
    },
    {
      "text": "Miercoles 15 de Enero - 11:00",
      "isoLocal": "2025-01-15T11:00:00",
      "iso": "2025-01-15T14:00:00Z",
      "id": "slot_003"
    }
  ]
}

{
  "slots": [
    {
      "text": "Miercoles 15 de Enero - 10:00",
      "isoLocal": "2025-01-15T10:00:00",
      "iso": "2025-01-15T13:00:00Z",
      "id": "slot_002"
    },
    {
      "text": "Miercoles 15 de Enero - 11:00",
      "isoLocal": "2025-01-15T11:00:00",
      "iso": "2025-01-15T14:00:00Z",
      "id": "slot_003"
    }
  ],
  "showBeforeButton": false,
  "showAfterButton": true
}

// Pseudocodigo - Ejemplo en Node.js
app.post('/api/turnero/disponibilidad', async (req, res) => {
  const { calendar_id, slots, start_date, end_date } = req.body;

  // Obtener reservas existentes en tu sistema
  const reservasExistentes = await db.query(`
    SELECT fecha_hora FROM reservas
    WHERE fecha_hora BETWEEN ? AND ?
    AND estado = 'confirmada'
  `, [start_date, end_date]);

  // Convertir a Set para busqueda rapida
  const horariosOcupados = new Set(
    reservasExistentes.map(r => r.fecha_hora.toISOString())
  );

  // Filtrar slots disponibles
  const slotsDisponibles = slots.filter(slot =>
    !horariosOcupados.has(slot.iso)
  );

  res.json({
    slots: slotsDisponibles,
    showBeforeButton: false,
    showAfterButton: slotsDisponibles.length > 0
  });
});

{
  "event_type": "EVENT.CREATED",
  "ticket_id": "#A1B2C3",
  "key": "d41d8cd98f00b204e9800998ecf8427e",
  "timestamp": "2025-01-15T10:30:00Z",
  "channel": "WHATSAPP",
  "source": "whatsapp_api",
  "source_id": "+5491155551234",
  "status": "OPEN",
  "subject": "Reserva de turno",
  "bot": {
    "id": 123,
    "name": "Bot de Turnos"
  },
  "agent": {
    "id": null,
    "name": null,
    "email": null
  },
  "department": {
    "id": 5,
    "name": "Atencion al Cliente"
  },
  "customer": {
    "fingerprint": "abc123xyz",
    "name": "Juan Perez",
    "email": "[email protected]",
    "phone": "+5491155551234",
    "facebook_id": null,
    "sentiment": null,
    "ip": "190.100.50.25",
    "browser_os": "WhatsApp/2.23.5",
    "country_code": "AR",
    "country_name": "Argentina"
  },
  "event": {
    "id": 456,
    "calendar_id": 5,
    "calendar_title": "Turnos Consulta",
    "utc_from": "2025-01-15T13:00:00Z",
    "utc_to": "2025-01-15T13:30:00Z",
    "location": "Consultorio 3, Piso 2",
    "public_key": "XY7K9M2P"
  },
  "messages": [
    {
      "action": "IN",
      "timestamp": "2025-01-15T10:25:00Z",
      "name": "Juan Perez",
      "message": "Hola, quiero sacar un turno",
      "attachments": null
    },
    {
      "action": "OUT",
      "timestamp": "2025-01-15T10:25:05Z",
      "name": "Bot de Turnos",
      "message": "Perfecto! Estos son los horarios disponibles...",
      "attachments": null
    }
  ],
  "tags": ["turno", "consulta_general"],
  "custom_fields": [
    {
      "id": "motivo_consulta",
      "value": "Control anual"
    },
    {
      "id": "obra_social",
      "value": "OSDE"
    }
  ]
}

{
  "status": "ok",
  "message": "Reserva procesada correctamente",
  "external_id": "TU-REF-12345"
}

// Ejemplo en Node.js con Express
app.post('/api/turnero/callback', async (req, res) => {
  const { event_type, customer, event, custom_fields } = req.body;

  // Verificar token de autenticacion
  const token = req.headers['asisteclick-access-token'];
  if (!verificarToken(token)) {
    return res.status(401).json({ error: 'Token invalido' });
  }

  try {
    switch (event_type) {
      case 'EVENT.CREATED':
        // Crear reserva en tu sistema
        await crearReserva({
          fecha: event.utc_from,
          duracion: calcularMinutos(event.utc_from, event.utc_to),
          cliente: customer.name,
          telefono: customer.phone,
          email: customer.email,
          ubicacion: event.location,
          codigo_asisteclick: event.public_key,
          datos_adicionales: custom_fields
        });
        break;

      case 'EVENT.UPDATED':
        // Actualizar reserva existente
        await actualizarReserva(event.public_key, {
          nuevaFecha: event.utc_from
        });
        break;

      case 'EVENT.CANCELED':
        // Cancelar reserva
        await cancelarReserva(event.public_key);
        break;
    }

    res.json({ status: 'ok' });

  } catch (error) {
    console.error('Error procesando callback:', error);
    res.status(500).json({ error: 'Error interno' });
  }
});

<?php
// disponibilidad.php

header('Content-Type: application/json');

// Recibir datos de AsisteClick
$input = json_decode(file_get_contents('php://input'), true);
$calendar_id = $input['calendar_id'];
$slots = $input['slots'];
$start_date = $input['start_date'];
$end_date = $input['end_date'];

// Mapear calendar_id de AsisteClick a profesional en HIS
$profesionales = [
    5 => 'DR_GARCIA',
    6 => 'DRA_MARTINEZ',
    7 => 'DR_LOPEZ'
];

$profesional_id = $profesionales[$calendar_id] ?? null;

if (!$profesional_id) {
    http_response_code(400);
    echo json_encode(['error' => 'Calendario no mapeado']);
    exit;
}

// Consultar turnos ocupados en el HIS
$conn = new mysqli('localhost', 'user', 'pass', 'his_db');
$stmt = $conn->prepare("
    SELECT fecha_turno
    FROM turnos
    WHERE profesional_id = ?
    AND fecha_turno BETWEEN ? AND ?
    AND estado IN ('confirmado', 'en_espera')
");
$stmt->bind_param("sss", $profesional_id, $start_date, $end_date);
$stmt->execute();
$result = $stmt->get_result();

// Crear set de horarios ocupados
$ocupados = [];
while ($row = $result->fetch_assoc()) {
    $ocupados[] = date('c', strtotime($row['fecha_turno']));
}

// Filtrar slots disponibles
$disponibles = array_filter($slots, function($slot) use ($ocupados) {
    return !in_array($slot['iso'], $ocupados);
});

// Responder
echo json_encode([
    'slots' => array_values($disponibles),
    'showBeforeButton' => false,
    'showAfterButton' => count($disponibles) > 0
]);

<?php
// callback.php

header('Content-Type: application/json');

// Verificar token
$token = $_SERVER['HTTP_ASISTECLICK_ACCESS_TOKEN'] ?? '';
if ($token !== 'TU_ACCESS_TOKEN_SECRETO') {
    http_response_code(401);
    echo json_encode(['error' => 'No autorizado']);
    exit;
}

$input = json_decode(file_get_contents('php://input'), true);
$event_type = $input['event_type'];
$customer = $input['customer'];
$event = $input['event'];
$custom_fields = $input['custom_fields'] ?? [];

$conn = new mysqli('localhost', 'user', 'pass', 'his_db');

// Mapear calendario a profesional
$profesionales = [
    5 => 'DR_GARCIA',
    6 => 'DRA_MARTINEZ'
];
$profesional_id = $profesionales[$event['calendar_id']] ?? 'NO_ASIGNADO';

switch ($event_type) {
    case 'EVENT.CREATED':
        // Buscar o crear paciente
        $stmt = $conn->prepare("SELECT paciente_id FROM pacientes WHERE telefono = ?");
        $stmt->bind_param("s", $customer['phone']);
        $stmt->execute();
        $result = $stmt->get_result();

        if ($result->num_rows == 0) {
            // Crear paciente nuevo
            $stmt = $conn->prepare("
                INSERT INTO pacientes (nombre, telefono, email, pais)
                VALUES (?, ?, ?, ?)
            ");
            $stmt->bind_param("ssss",
                $customer['name'],
                $customer['phone'],
                $customer['email'],
                $customer['country_code']
            );
            $stmt->execute();
            $paciente_id = $conn->insert_id;
        } else {
            $paciente_id = $result->fetch_assoc()['paciente_id'];
        }

        // Crear turno
        $stmt = $conn->prepare("
            INSERT INTO turnos
            (paciente_id, profesional_id, fecha_turno, fecha_fin, ubicacion,
             codigo_externo, estado, origen)
            VALUES (?, ?, ?, ?, ?, ?, 'confirmado', 'asisteclick')
        ");
        $stmt->bind_param("isssss",
            $paciente_id,
            $profesional_id,
            $event['utc_from'],
            $event['utc_to'],
            $event['location'],
            $event['public_key']
        );
        $stmt->execute();

        // Guardar campos personalizados
        foreach ($custom_fields as $field) {
            $stmt = $conn->prepare("
                INSERT INTO turno_extras (turno_id, campo, valor)
                VALUES (?, ?, ?)
            ");
            $turno_id = $conn->insert_id;
            $stmt->bind_param("iss", $turno_id, $field['id'], $field['value']);
            $stmt->execute();
        }
        break;

    case 'EVENT.UPDATED':
        $stmt = $conn->prepare("
            UPDATE turnos
            SET fecha_turno = ?, fecha_fin = ?
            WHERE codigo_externo = ?
        ");
        $stmt->bind_param("sss",
            $event['utc_from'],
            $event['utc_to'],
            $event['public_key']
        );
        $stmt->execute();
        break;

    case 'EVENT.CANCELED':
        $stmt = $conn->prepare("
            UPDATE turnos
            SET estado = 'cancelado'
            WHERE codigo_externo = ?
        ");
        $stmt->bind_param("s", $event['public_key']);
        $stmt->execute();
        break;
}

echo json_encode([
    'status' => 'ok',
    'turno_id' => $conn->insert_id ?? null
]);

curl -X POST https://tu-dominio.com/api/turnero/disponibilidad \
  -H "Content-Type: application/json" \
  -H "User-Agent: AsisteClick-Booking/2.0" \
  -d '{
    "calendar_id": 5,
    "timezone": "-3",
    "preferred": null,
    "count": 6,
    "start_date": "2025-01-15",
    "end_date": "2025-01-22",
    "slots": [
      {
        "text": "Miercoles 15 de Enero - 10:00",
        "isoLocal": "2025-01-15T10:00:00",
        "iso": "2025-01-15T13:00:00Z",
        "id": "slot_001"
      }
    ]
  }'

curl -X POST https://tu-dominio.com/api/turnero/callback \
  -H "Content-Type: application/json" \
  -H "AsisteClick-Access-Token: TU_TOKEN" \
  -d '{
    "event_type": "EVENT.CREATED",
    "ticket_id": "#TEST123",
    "customer": {
      "name": "Usuario Prueba",
      "phone": "+5491155550000",
      "email": "[email protected]"
    },
    "event": {
      "id": 1,
      "calendar_id": 5,
      "utc_from": "2025-01-15T13:00:00Z",
      "utc_to": "2025-01-15T13:30:00Z",
      "location": "Consultorio Test",
      "public_key": "TESTKEY1"
    }
  }'

https://tu-dominio.com/callback::Authorization:Bearer tu-token;X-Custom:valor