[02-Apr-2025 16:59:10 Europe/Berlin] [PIE] Iniciando script. start=2025-04-01, end=2025-04-02 23:59:59
[02-Apr-2025 16:59:10 Europe/Berlin] [PIE] Canal de agrupamento: sourceChannelName
[02-Apr-2025 16:59:10 Europe/Berlin] [PIE] SQL: 
    SELECT 
        sourceChannelName AS canal,
        SUM(roomingNightCount) AS RN,
        SUM(amount) AS Diarias,
        SUM(mealPlanAmountPaxChd) AS AeB,
        SUM(amount + mealPlanAmountPaxChd) AS DiariaPensao
    FROM RoomingNights
    WHERE endOfDayDate BETWEEN :start AND :end
      AND reservationStatus <> 2
    GROUP BY sourceChannelName

[02-Apr-2025 16:59:10 Europe/Berlin] [PIE] Número de resultados: 5
[02-Apr-2025 16:59:10 Europe/Berlin] [PIE] Dados para gráfico: [{"name":"AHI SITE","y":1840},{"name":"OTA","y":549.46},{"name":"Fracionado Voucher","y":398},{"name":"Campanhas Promocionais","y":389},{"name":"Whatsapp","y":0}]