----------------------------] DEBUG ----------------------------] <> ] Procesar fecha: [2026-01-28] ] Query a procesar: [ SELECT TOP 1 tur_numero ,c.cli_tel as telefono ,c.cli_nombre as nombre, c.cli_dni as doc ,m.med_nombre AS Med ,tt.tit_abrev AS Tit ,DATEPART(dw,tur_fecha) as diaSemana ,DATEPART(dd,tur_fecha) as diaFecha ,DATEPART(mm,tur_fecha) as mesFecha ,t.tur_hora AS Hora ,ISNULL(t.tur_confirmado,0) as confirmado ,t.esp_codigo as turespcod ,(CASE WHEN espt.esp_denom IS NULL THEN '' ELSE espt.esp_denom END) as turespdenom ,(CASE WHEN espm.esp_denom IS NULL THEN '' ELSE espm.esp_denom END) as medespdenom FROM dbo.turnos as t INNER JOIN dbo.clientes as c ON c.cli_codigo = t.cli_codigo INNER JOIN dbo.medicos as m ON m.med_codigo = t.med_codigo INNER JOIN dbo.tbl_titulos tt ON tt.tit_codigo = m.tit_codigo LEFT JOIN dbo.especial as espt ON espt.esp_codigo = t.esp_codigo LEFT JOIN dbo.especial as espm ON espm.esp_codigo = m.esp_codigo WHERE t.cli_codigo > 1 AND t.turRecoWht = 0 AND ISNULL(t.tur_confirmado,0) = 0 AND FORMAT (t.tur_fecha, 'yyyy-MM-dd') = '2026-01-28' ] ] turnos encontrados a procesar: [1] >> TURNOS A PROCESAR[1] SELECT TOP 1 tur_numero ,c.cli_tel as telefono ,c.cli_nombre as nombre, c.cli_dni as doc ,m.med_nombre AS Med ,tt.tit_abrev AS Tit ,DATEPART(dw,tur_fecha) as diaSemana ,DATEPART(dd,tur_fecha) as diaFecha ,DATEPART(mm,tur_fecha) as mesFecha ,t.tur_hora AS Hora ,ISNULL(t.tur_confirmado,0) as confirmado ,t.esp_codigo as turespcod ,(CASE WHEN espt.esp_denom IS NULL THEN '' ELSE espt.esp_denom END) as turespdenom ,(CASE WHEN espm.esp_denom IS NULL THEN '' ELSE espm.esp_denom END) as medespdenom FROM dbo.turnos as t INNER JOIN dbo.clientes as c ON c.cli_codigo = t.cli_codigo INNER JOIN dbo.medicos as m ON m.med_codigo = t.med_codigo INNER JOIN dbo.tbl_titulos tt ON tt.tit_codigo = m.tit_codigo LEFT JOIN dbo.especial as espt ON espt.esp_codigo = t.esp_codigo LEFT JOIN dbo.especial as espm ON espm.esp_codigo = m.esp_codigo WHERE t.cli_codigo > 1 AND t.turRecoWht = 0 AND ISNULL(t.tur_confirmado,0) = 0 AND FORMAT (t.tur_fecha, 'yyyy-MM-dd') = '2026-01-28' >>POD TOTAL[1] ] 1)Actualizar destinatario a procesar: [ UPDATE dbo.turnos SET turRecoWht = 1,tur_RecoWhtFechaEnvio=GETDATE(),turRecoWhtRechazado=0 WHERE tur_numero = 925887] ] Destinatarios ] Array ( [0] => Array ( [men_id] => 1136709925 [msg] => SG9sYSBidWVub3MgZMOtYXMsIG1lIGNvbXVuaWNvIGRlICpBcmNvcyBkZWwgY2llbG8qLypDRVIqLCBwYXJhIGNvbmZpcm1hciBzdSB0dXJubyBkZWwgZMOtYSBtacOpcmNvbGVzIDI4IEVTUEVDSUFMSURBRDogVVJPTE9HSUEgLSBFU1BFQ0lBTElTVEE6IERSQSBBUkNPUyBWQVpRVUVaIFNPRklBIENJRUxPCiog8J+UuU5vIHNlIHBlcm1pdGVuIGFjb21wYcOxYW50ZXMsIGVuIGNhc28gZGUgcXVlIGVsIHBhY2llbnRlIGxvIHJlcXVpZXJhIGRlYmVyw6EgcHJlc2VudGFyIGVsIGNhcm5ldCBkZSBkaXNjYXBhY2lkYWQKKiDwn5S5IExlIHJlY3VlcmRvIHF1ZSBhIGxvcyBwYWNpZW50ZXMgY29uIGxhIG9icmEgc29jaWFsIElPTUEgbmVjZXNpdGFtb3Mgc2kgbyBzaSBxdWUgcG9yIGZhdm9yIGEgbGEgaG9yYSBkZSBsYSByZWNlcGNpw7NuIHByZXNlbnRlcyBlbCB0b2tlbiBkZSBsYSBjcmVkZW5jaWFsIHZpcnR1YWwgcXVlIGZpZ3VyYSBlbiBJT01BIERJR0lUQUwKKiDwn5S5Q29uc3VsdGEgcGFydGljdWxhciB0aWVuZSB1biB2YWxvciBkZSAkMjMuMDAwCiog4oC877iPIENPTkNVUlJJUiAxMCBNSU4gQU5URVMgREVMIFRVUk5PLCBDQVNPIENPTlRSQVJJTyBBR1VBUkRBUsOBIEZVRVJBIERFTCBDRU5UUk8gTcOJRElDTyBIQVNUQSBRVUUgU0VBIEVMIEhPUkFSSU8gSU5ESUNBRE8KQWd1YXJkYW1vcyBzdSBjb25maXJtYWNpb24gcG9yIGVzdGUgbWVkaW8uIFNpIG5vIG9idGVuZW1vcyByZXNwdWVzdGEgZW4gMjRocyBzZSBjb25zaWRlcmFyw6EgY2FuY2VsYWRvIGVsIHR1cm5vLgpBZ3VhcmRhbW9zIHN1IGNvbmZvcm1hY2nDs24gcG9yIGVzdGUgbWVkaW86CioxKikgQXNpc3RvCioyKikgQ2FuY2Vsw7MgZWwgdHVybm8K [destiny] => 5493512349009 [customer] => a340e4bd594ea87bf22c565d838ffc39 [cli] => a340e4bd594ea87bf22c565d838ffc39 [k] => R2VudGl1bTIyJA== [token] => 00000000000000000000 [action] => send [flagFlowCreated] => ) ) >>TOTAL MENSAJES[1] >>2)POSD ACTIVOS 1 >>LISTADO MENSAJES<< Array ( [0] => Array ( [men_id] => 1136709925 [msg] => SG9sYSBidWVub3MgZMOtYXMsIG1lIGNvbXVuaWNvIGRlICpBcmNvcyBkZWwgY2llbG8qLypDRVIqLCBwYXJhIGNvbmZpcm1hciBzdSB0dXJubyBkZWwgZMOtYSBtacOpcmNvbGVzIDI4IEVTUEVDSUFMSURBRDogVVJPTE9HSUEgLSBFU1BFQ0lBTElTVEE6IERSQSBBUkNPUyBWQVpRVUVaIFNPRklBIENJRUxPCiog8J+UuU5vIHNlIHBlcm1pdGVuIGFjb21wYcOxYW50ZXMsIGVuIGNhc28gZGUgcXVlIGVsIHBhY2llbnRlIGxvIHJlcXVpZXJhIGRlYmVyw6EgcHJlc2VudGFyIGVsIGNhcm5ldCBkZSBkaXNjYXBhY2lkYWQKKiDwn5S5IExlIHJlY3VlcmRvIHF1ZSBhIGxvcyBwYWNpZW50ZXMgY29uIGxhIG9icmEgc29jaWFsIElPTUEgbmVjZXNpdGFtb3Mgc2kgbyBzaSBxdWUgcG9yIGZhdm9yIGEgbGEgaG9yYSBkZSBsYSByZWNlcGNpw7NuIHByZXNlbnRlcyBlbCB0b2tlbiBkZSBsYSBjcmVkZW5jaWFsIHZpcnR1YWwgcXVlIGZpZ3VyYSBlbiBJT01BIERJR0lUQUwKKiDwn5S5Q29uc3VsdGEgcGFydGljdWxhciB0aWVuZSB1biB2YWxvciBkZSAkMjMuMDAwCiog4oC877iPIENPTkNVUlJJUiAxMCBNSU4gQU5URVMgREVMIFRVUk5PLCBDQVNPIENPTlRSQVJJTyBBR1VBUkRBUsOBIEZVRVJBIERFTCBDRU5UUk8gTcOJRElDTyBIQVNUQSBRVUUgU0VBIEVMIEhPUkFSSU8gSU5ESUNBRE8KQWd1YXJkYW1vcyBzdSBjb25maXJtYWNpb24gcG9yIGVzdGUgbWVkaW8uIFNpIG5vIG9idGVuZW1vcyByZXNwdWVzdGEgZW4gMjRocyBzZSBjb25zaWRlcmFyw6EgY2FuY2VsYWRvIGVsIHR1cm5vLgpBZ3VhcmRhbW9zIHN1IGNvbmZvcm1hY2nDs24gcG9yIGVzdGUgbWVkaW86CioxKikgQXNpc3RvCioyKikgQ2FuY2Vsw7MgZWwgdHVybm8K [destiny] => 5493512349009 [customer] => a340e4bd594ea87bf22c565d838ffc39 [cli] => a340e4bd594ea87bf22c565d838ffc39 [k] => R2VudGl1bTIyJA== [token] => 00000000000000000000 [action] => send [flagFlowCreated] => 1 ) ) >>WS_WHATSAPP_ACTIVE[1] >> indexPod[0] ] -----------------: ] Destinatario: ] Array ( [men_id] => 1136709925 [msg] => SG9sYSBidWVub3MgZMOtYXMsIG1lIGNvbXVuaWNvIGRlICpBcmNvcyBkZWwgY2llbG8qLypDRVIqLCBwYXJhIGNvbmZpcm1hciBzdSB0dXJubyBkZWwgZMOtYSBtacOpcmNvbGVzIDI4IEVTUEVDSUFMSURBRDogVVJPTE9HSUEgLSBFU1BFQ0lBTElTVEE6IERSQSBBUkNPUyBWQVpRVUVaIFNPRklBIENJRUxPCiog8J+UuU5vIHNlIHBlcm1pdGVuIGFjb21wYcOxYW50ZXMsIGVuIGNhc28gZGUgcXVlIGVsIHBhY2llbnRlIGxvIHJlcXVpZXJhIGRlYmVyw6EgcHJlc2VudGFyIGVsIGNhcm5ldCBkZSBkaXNjYXBhY2lkYWQKKiDwn5S5IExlIHJlY3VlcmRvIHF1ZSBhIGxvcyBwYWNpZW50ZXMgY29uIGxhIG9icmEgc29jaWFsIElPTUEgbmVjZXNpdGFtb3Mgc2kgbyBzaSBxdWUgcG9yIGZhdm9yIGEgbGEgaG9yYSBkZSBsYSByZWNlcGNpw7NuIHByZXNlbnRlcyBlbCB0b2tlbiBkZSBsYSBjcmVkZW5jaWFsIHZpcnR1YWwgcXVlIGZpZ3VyYSBlbiBJT01BIERJR0lUQUwKKiDwn5S5Q29uc3VsdGEgcGFydGljdWxhciB0aWVuZSB1biB2YWxvciBkZSAkMjMuMDAwCiog4oC877iPIENPTkNVUlJJUiAxMCBNSU4gQU5URVMgREVMIFRVUk5PLCBDQVNPIENPTlRSQVJJTyBBR1VBUkRBUsOBIEZVRVJBIERFTCBDRU5UUk8gTcOJRElDTyBIQVNUQSBRVUUgU0VBIEVMIEhPUkFSSU8gSU5ESUNBRE8KQWd1YXJkYW1vcyBzdSBjb25maXJtYWNpb24gcG9yIGVzdGUgbWVkaW8uIFNpIG5vIG9idGVuZW1vcyByZXNwdWVzdGEgZW4gMjRocyBzZSBjb25zaWRlcmFyw6EgY2FuY2VsYWRvIGVsIHR1cm5vLgpBZ3VhcmRhbW9zIHN1IGNvbmZvcm1hY2nDs24gcG9yIGVzdGUgbWVkaW86CioxKikgQXNpc3RvCioyKikgQ2FuY2Vsw7MgZWwgdHVybm8K [destiny] => 5493512349009 [customer] => a340e4bd594ea87bf22c565d838ffc39 [cli] => a340e4bd594ea87bf22c565d838ffc39 [k] => R2VudGl1bTIyJA== [token] => 00000000000000000000 [action] => send [flagFlowCreated] => 1 [podpto] => 1 ) ] >> 1) LLAMARL WEB SERVICE WHP. http://landaware.ddns.net/whatsapp/agentwh/index.php >> ERROR WHP {"r":0,"e":"Failed to connect to landaware.ddns.net port 80: Timed out"} ] ] >> 1) LLAMARL WEB SERVICE WHP. http://landaware.ddns.net/whatsapp/agentwh/index.php >> ERROR WHP {"r":0,"e":"Failed to connect to landaware.ddns.net port 80: Timed out"} ] -----------------: **************]