----------------------------]
DEBUG
----------------------------]
<>
]
Procesar fecha: [2026-01-16]
]
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-16'
							AND t.med_codigo NOT IN (64,88,113,121,89,74)]
]
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-16'
							AND t.med_codigo NOT IN (64,88,113,121,89,74)
>>POD TOTAL[1]
]
1)Actualizar destinatario a procesar: [   UPDATE  dbo.turnos  SET  turRecoWht = 1,tur_RecoWhtFechaEnvio=GETDATE(),turRecoWhtRechazado=0 WHERE tur_numero = 924628]
]
Destinatarios
]
Array
(
    [0] => Array
        (
            [men_id] => 1141667332
            [msg] => SG9sYSBidWVub3MgZMOtYXMsIG1lIGNvbXVuaWNvIGRlICpBcmNvcyBkZWwgY2llbG8qLCBlbnRyZSByw61vcyAyNjY0IHBiLCBwYXJhIGNvbmZpcm1hciBzdSB0dXJubyBkZWwgZMOtYSB2aWVybmVzIDE2IEVTUEVDSUFMSURBRDogQ0xJTklDQSBNRURJQ0EgLSBFU1BFQ0lBTElTVEE6ICAgQVJDT1MgLS0tIFNJRVJSQSBMRUFORFJPIERBTklFTAoqIPCflLlObyBzZSBwZXJtaXRlbiBhY29tcGHDsWFudGVzLCBlbiBjYXNvIGRlIHF1ZSBlbCBwYWNpZW50ZSBsbyByZXF1aWVyYSBkZWJlcsOhIHByZXNlbnRhciBlbCBjYXJuZXQgZGUgZGlzY2FwYWNpZGFkCiog8J+UuSBMZSByZWN1ZXJkbyBxdWUgYSBsb3MgcGFjaWVudGVzIGNvbiBsYSBvYnJhIHNvY2lhbCBJT01BIG5lY2VzaXRhbW9zIHNpIG8gc2kgcXVlIHBvciBmYXZvciBhIGxhIGhvcmEgZGUgbGEgcmVjZXBjacOzbiBwcmVzZW50ZXMgZWwgdG9rZW4gZGUgbGEgY3JlZGVuY2lhbCB2aXJ0dWFsIHF1ZSBmaWd1cmEgZW4gSU9NQSBESUdJVEFMCiog8J+UuUNvbnN1bHRhIHBhcnRpY3VsYXIgdGllbmUgdW4gdmFsb3IgZGUgJDIzLjAwMAoqIOKAvO+4jyBDT05DVVJSSVIgMTAgTUlOIEFOVEVTIERFTCBUVVJOTywgQ0FTTyBDT05UUkFSSU8gQUdVQVJEQVLDgSBGVUVSQSBERUwgQ0VOVFJPIE3DiURJQ08gSEFTVEEgUVVFIFNFQSBFTCBIT1JBUklPIElORElDQURPCkFndWFyZGFtb3Mgc3UgY29uZmlybWFjaW9uIHBvciBlc3RlIG1lZGlvLiBTaSBubyBvYnRlbmVtb3MgcmVzcHVlc3RhIGVuIDI0aHMgc2UgY29uc2lkZXJhcsOhIGNhbmNlbGFkbyBlbCB0dXJuby4KQWd1YXJkYW1vcyBzdSBjb25mb3JtYWNpw7NuIHBvciBlc3RlIG1lZGlvOgoqMSopIEFzaXN0bwoqMiopIENhbmNlbMOzIGVsIHR1cm5vCg==
            [destiny] => 5493512349009
            [customer] => a340e4bd594ea87bf22c565d838ffc39
            [cli] => a340e4bd594ea87bf22c565d838ffc39
            [k] => R2VudGl1bTIyJA==
            [token] => 00000000000000000000
            [action] => send
            [flagFlowCreated] => 
        )

)
>>TOTAL MENSAJES[1]
>>2)POSD ACTIVOS
1
>>WS_WHATSAPP_ACTIVE[1]

**************]