[2025-11-21 13:19:26] local.INFO: Resultado crudo CelulaApiService {"resultado_raw":"false"} [2025-11-21 13:26:27] local.INFO: Resultado crudo CelulaApiService {"resultado_raw":"false"} [2025-11-21 13:32:05] local.DEBUG: CelulaApiService - SQL minificada {"original_snippet":"SELECT CASE WHEN c.status = 'Abandoned' THEN 'Abandonada' WHEN c.status = 'Failure' THEN 'Fallida' WHEN c.status = 'OnQueue' THEN 'EnCola' WHEN c.status = 'ShortCall' THEN 'LlamadaCorta' WHEN c.status = 'Success' THEN 'Contestada' WHEN c.status = 'NoAnswer' THEN 'NoContestada' WHEN c.status = 'Ringi...","minificada_snippet":"SELECT CASE WHEN c.status = 'Abandoned' THEN 'Abandonada' WHEN c.status = 'Failure' THEN 'Fallida' WHEN c.status = 'OnQueue' THEN 'EnCola' WHEN c.status = 'ShortCall' THEN 'LlamadaCorta' WHEN c.status = 'Success' THEN 'Contestada' WHEN c.status = 'NoAnswer' THEN 'NoContestada' WHEN c.status = 'Ringi..."} [2025-11-21 13:32:05] local.DEBUG: CelulaApiService - REQUEST hacia célula {"url":"https://demo.itbx.co/ApiRestFullItbx.php","json_length":1670,"json_snippet":"{\"sql\":\"SELECT CASE WHEN c.status = 'Abandoned' THEN 'Abandonada' WHEN c.status = 'Failure' THEN 'Fallida' WHEN c.status = 'OnQueue' THEN 'EnCola' WHEN c.status = 'ShortCall' THEN 'LlamadaCorta' WHEN c.status = 'Success' THEN 'Contestada' WHEN c.status = 'NoAnswer' THEN 'NoContestada' WHEN c.status = 'Ringing' THEN 'Timbrando' WHEN c.status = 'Placing' THEN 'EnProceso' WHEN c.status IS NULL THEN 'SinGesti\\u00f3n' ELSE c.status END AS status, cp.name AS campaign, CASE WHEN a.name IS NULL THEN '' ELSE a.name END AS agent_name, SUM(CASE WHEN c.duration IS NULL THEN 0 ELSE c.duration END) AS total_duration, COUNT(c.status) AS total_calls, IFNULL(ROUND(SUM(CASE WHEN c.duration IS NULL THEN 0 ELSE c.duration END)\\/COUNT(c.status),0),0) AS tmo, SUM(CASE WHEN c.transfer IS NULL THEN 0 ELSE 1 END) AS total_transfer, SUM(CASE WHEN c.transfer LIKE '901%' THEN 1 ELSE 0 END) AS transfer_survey, SUM(CASE WHEN c.transfer IS NULL THEN 0 ELSE 1 END) - SUM(CASE WHEN c.transfer LIKE '901%' THEN 1 ELSE 0 ..."} [2025-11-21 13:32:06] local.DEBUG: CelulaApiService - RAW RESPONSE de célula {"result_type":"string","result_snippet":"false..."} [2025-11-21 13:32:06] local.DEBUG: CelulaApiService - RESULTADO json_decode {"json_last_error":0,"json_last_error_msg":"No error","decoded_type":"boolean","decoded_snippet":false} [2025-11-21 13:32:06] local.INFO: Resultado crudo CelulaApiService {"resultado_raw":"false"} [2025-11-21 15:05:21] local.DEBUG: CelulaApiService - SQL minificada {"original_snippet":"SELECT CASE WHEN c.status = 'Abandoned' THEN 'Abandonada' WHEN c.status = 'Failure' THEN 'Fallida' WHEN c.status = 'OnQueue' THEN 'EnCola' WHEN c.status = 'ShortCall' THEN 'LlamadaCorta' WHEN c.status = 'Success' THEN 'Contestada' WHEN c.status = 'NoAnswer' THEN 'NoContestada' WHEN c.status = 'Ringi...","minificada_snippet":"SELECT CASE WHEN c.status = 'Abandoned' THEN 'Abandonada' WHEN c.status = 'Failure' THEN 'Fallida' WHEN c.status = 'OnQueue' THEN 'EnCola' WHEN c.status = 'ShortCall' THEN 'LlamadaCorta' WHEN c.status = 'Success' THEN 'Contestada' WHEN c.status = 'NoAnswer' THEN 'NoContestada' WHEN c.status = 'Ringi..."} [2025-11-21 15:05:21] local.DEBUG: CelulaApiService - REQUEST hacia célula {"url":"https://demo.itbx.co/ApiRestFullItbx.php","json_length":1670,"json_snippet":"{\"sql\":\"SELECT CASE WHEN c.status = 'Abandoned' THEN 'Abandonada' WHEN c.status = 'Failure' THEN 'Fallida' WHEN c.status = 'OnQueue' THEN 'EnCola' WHEN c.status = 'ShortCall' THEN 'LlamadaCorta' WHEN c.status = 'Success' THEN 'Contestada' WHEN c.status = 'NoAnswer' THEN 'NoContestada' WHEN c.status = 'Ringing' THEN 'Timbrando' WHEN c.status = 'Placing' THEN 'EnProceso' WHEN c.status IS NULL THEN 'SinGesti\\u00f3n' ELSE c.status END AS status, cp.name AS campaign, CASE WHEN a.name IS NULL THEN '' ELSE a.name END AS agent_name, SUM(CASE WHEN c.duration IS NULL THEN 0 ELSE c.duration END) AS total_duration, COUNT(c.status) AS total_calls, IFNULL(ROUND(SUM(CASE WHEN c.duration IS NULL THEN 0 ELSE c.duration END)\\/COUNT(c.status),0),0) AS tmo, SUM(CASE WHEN c.transfer IS NULL THEN 0 ELSE 1 END) AS total_transfer, SUM(CASE WHEN c.transfer LIKE '901%' THEN 1 ELSE 0 END) AS transfer_survey, SUM(CASE WHEN c.transfer IS NULL THEN 0 ELSE 1 END) - SUM(CASE WHEN c.transfer LIKE '901%' THEN 1 ELSE 0 ..."} [2025-11-21 15:05:21] local.DEBUG: CelulaApiService - RAW RESPONSE de célula {"result_type":"string","result_snippet":"false..."} [2025-11-21 15:05:21] local.DEBUG: CelulaApiService - RESULTADO json_decode {"json_last_error":0,"json_last_error_msg":"No error","decoded_type":"boolean","decoded_snippet":false} [2025-11-21 15:05:21] local.INFO: Resultado crudo CelulaApiService {"resultado_raw":"false"}