[insertMessage] query: insert into messages (sender, receiver, id, msg_type, msg_datetime, msg_status, msg_text, msg_timestamp) values ('51966729736', '15556391605', 'wamid.HBgLNTE5NjY3Mjk3MzYVAgASGBQzQTc3RjlERUVEMTgzOUMzQkVDRAA=', 'text', now(), 'sent', 'Hola', from_unixtime(1744819921)) -> [WabiManager.checkMessageExists] Registrar el mensaje wamid.HBgLNTE5NjY3Mjk3MzYVAgASGBQzQTc3RjlERUVEMTgzOUMzQkVDRAA= curl response: {"messaging_product":"whatsapp","contacts":[{"input":"51966729736","wa_id":"51966729736"}],"messages":[{"id":"wamid.HBgLNTE5NjY3Mjk3MzYVAgARGBI0MTY1RDhCMUE2RThDQURFNEMA","message_status":"accepted"}]} [insertMessage] query: insert into messages (sender, receiver, id, msg_type, msg_datetime, msg_status, msg_text, msg_timestamp) values ('15556391605', '51966729736', 'wamid.HBgLNTE5NjY3Mjk3MzYVAgASGBQzQTc3RjlERUVEMTgzOUMzQkVDRAA=', 'template', now(), 'sent', 'inicio', from_unixtime(1744819921)) [closePayloadTracking] query: update messages set closed = true where sender = '51966729736' and id = 'wamid.HBgLNTE5NjY3Mjk3MzYVAgASGBQzQTc3RjlERUVEMTgzOUMzQkVDRAA=' and not closed -> [TemplateMaker.response] cerré el mensaje de tracking para 51966729736 -> [TemplateMaker.response] 1 [insertMessage] query: insert into messages (sender, receiver, id, msg_type, msg_datetime, msg_status, msg_text, msg_timestamp) values ('51966729736', '15556391605', 'wamid.HBgLNTE5NjY3Mjk3MzYVAgASGBQzQTI0MjJGMTA2MzM1RjNCMTBEMAA=', 'button', now(), 'sent', 'Transporte terrestre', from_unixtime(1744819932)) -> [WabiManager.checkMessageExists] Registrar el mensaje wamid.HBgLNTE5NjY3Mjk3MzYVAgASGBQzQTI0MjJGMTA2MzM1RjNCMTBEMAA= [closeAllPayloadsOpened] query: update messages set closed = true where sender = '51966729736' and msg_type = 'button' and not closed curl response: {"messaging_product":"whatsapp","contacts":[{"input":"51966729736","wa_id":"51966729736"}],"messages":[{"id":"wamid.HBgLNTE5NjY3Mjk3MzYVAgARGBI0QTYxRjlBNjBEM0E0OUUwQUMA","message_status":"accepted"}]} [insertMessage] query: insert into messages (sender, receiver, id, msg_type, msg_datetime, msg_status, msg_text, msg_timestamp) values ('15556391605', '51966729736', 'wamid.HBgLNTE5NjY3Mjk3MzYVAgASGBQzQTI0MjJGMTA2MzM1RjNCMTBEMAA=', 'template', now(), 'sent', 'menu_001', from_unixtime(1744819932)) [closePayloadTracking] query: update messages set closed = true where sender = '51966729736' and id = 'wamid.HBgLNTE5NjY3Mjk3MzYVAgASGBQzQTI0MjJGMTA2MzM1RjNCMTBEMAA=' and not closed -> [TemplateMaker.response] cerré el mensaje de tracking para 51966729736 -> [TemplateMaker.response] 1 [insertMessage] query: insert into messages (sender, receiver, id, msg_type, msg_datetime, msg_status, msg_text, msg_timestamp) values ('51966729736', '15556391605', 'wamid.HBgLNTE5NjY3Mjk3MzYVAgASGBQzQURFQ0UzNEZCNjVGMzAzQUZGRgA=', 'button', now(), 'sent', 'Producto', from_unixtime(1744819949)) -> [WabiManager.checkMessageExists] Registrar el mensaje wamid.HBgLNTE5NjY3Mjk3MzYVAgASGBQzQURFQ0UzNEZCNjVGMzAzQUZGRgA= [closeAllPayloadsOpened] query: update messages set closed = true where sender = '51966729736' and msg_type = 'button' and not closed curl response: {"messaging_product":"whatsapp","contacts":[{"input":"51966729736","wa_id":"51966729736"}],"messages":[{"id":"wamid.HBgLNTE5NjY3Mjk3MzYVAgARGBIwMEJERUMzNzM2OEJDNDJGQjgA","message_status":"accepted"}]} [insertMessage] query: insert into messages (sender, receiver, id, msg_type, msg_datetime, msg_status, msg_text, msg_timestamp) values ('15556391605', '51966729736', 'wamid.HBgLNTE5NjY3Mjk3MzYVAgASGBQzQURFQ0UzNEZCNjVGMzAzQUZGRgA=', 'template', now(), 'sent', 'menu_001_03', from_unixtime(1744819949)) [closePayloadTracking] query: update messages set closed = true where sender = '51966729736' and id = 'wamid.HBgLNTE5NjY3Mjk3MzYVAgASGBQzQURFQ0UzNEZCNjVGMzAzQUZGRgA=' and not closed -> [TemplateMaker.response] cerré el mensaje de tracking para 51966729736 -> [TemplateMaker.response] 1 [insertMessage] query: insert into messages (sender, receiver, id, msg_type, msg_datetime, msg_status, msg_text, msg_timestamp) values ('51989845561', '15556391605', 'wamid.HBgLNTE5ODk4NDU1NjEVAgASGCBCQUIyNEFDMzU2NUU3QkUzRTNBRDcyN0FDQzA2RTQ4OQA=', 'text', now(), 'sent', 'Hola', from_unixtime(1744820163)) -> [WabiManager.checkMessageExists] Registrar el mensaje wamid.HBgLNTE5ODk4NDU1NjEVAgASGCBCQUIyNEFDMzU2NUU3QkUzRTNBRDcyN0FDQzA2RTQ4OQA= curl response: {"messaging_product":"whatsapp","contacts":[{"input":"51989845561","wa_id":"51989845561"}],"messages":[{"id":"wamid.HBgLNTE5ODk4NDU1NjEVAgARGBI3QjYxMDM2QkUwRDlEMDEwOTIA","message_status":"accepted"}]} [insertMessage] query: insert into messages (sender, receiver, id, msg_type, msg_datetime, msg_status, msg_text, msg_timestamp) values ('15556391605', '51989845561', 'wamid.HBgLNTE5ODk4NDU1NjEVAgASGCBCQUIyNEFDMzU2NUU3QkUzRTNBRDcyN0FDQzA2RTQ4OQA=', 'template', now(), 'sent', 'inicio', from_unixtime(1744820163)) [closePayloadTracking] query: update messages set closed = true where sender = '51989845561' and id = 'wamid.HBgLNTE5ODk4NDU1NjEVAgASGCBCQUIyNEFDMzU2NUU3QkUzRTNBRDcyN0FDQzA2RTQ4OQA=' and not closed -> [TemplateMaker.response] cerré el mensaje de tracking para 51989845561 -> [TemplateMaker.response] 1 [insertMessage] query: insert into messages (sender, receiver, id, msg_type, msg_datetime, msg_status, msg_text, msg_timestamp) values ('51989845561', '15556391605', 'wamid.HBgLNTE5ODk4NDU1NjEVAgASGCA3ODc1RDhBMTA0MzJGQTNFQ0M4RjZBRTcyQzQ1Q0ZDMgA=', 'button', now(), 'sent', 'Deseo una cotización', from_unixtime(1744820185)) -> [WabiManager.checkMessageExists] Registrar el mensaje wamid.HBgLNTE5ODk4NDU1NjEVAgASGCA3ODc1RDhBMTA0MzJGQTNFQ0M4RjZBRTcyQzQ1Q0ZDMgA= curl response: {"messaging_product":"whatsapp","contacts":[{"input":"51989845561","wa_id":"51989845561"}],"messages":[{"id":"wamid.HBgLNTE5ODk4NDU1NjEVAgARGBJBRTE5OEY4MkQ5Qjg2RjE0NzMA","message_status":"accepted"}]} [insertMessage] query: insert into messages (sender, receiver, id, msg_type, msg_datetime, msg_status, msg_text, msg_timestamp) values ('15556391605', '51989845561', 'wamid.HBgLNTE5ODk4NDU1NjEVAgASGCA3ODc1RDhBMTA0MzJGQTNFQ0M4RjZBRTcyQzQ1Q0ZDMgA=', 'template', now(), 'sent', 'menu_08', from_unixtime(1744820185)) -> [TemplateMaker.response] 1 [insertMessage] query: insert into messages (sender, receiver, id, msg_type, msg_datetime, msg_status, msg_text, msg_timestamp) values ('51989845561', '15556391605', 'wamid.HBgLNTE5ODk4NDU1NjEVAgASGCBFRURGRkQ0RjU2QTUxODcwNjFEQjQ4MEQzQkQ2N0RBMAA=', 'text', now(), 'sent', 'Hola ahora le envío', from_unixtime(1744820195)) -> [WabiManager.checkMessageExists] Registrar el mensaje wamid.HBgLNTE5ODk4NDU1NjEVAgASGCBFRURGRkQ0RjU2QTUxODcwNjFEQjQ4MEQzQkQ2N0RBMAA= -> [TemplateMaker.response] mensaje no respondido. motivo: El chat está en modo asesor. No debo responder. [registerRequest] query: insert into chat_status (client, receiver, name) values ('51989845561', '15556391605', 'Miguel Velásquez') [insertMessage] query: insert into messages (sender, receiver, id, msg_type, msg_datetime, msg_status, msg_text, msg_timestamp) values ('51989845561', '15556391605', 'wamid.HBgLNTE5ODk4NDU1NjEVAgASGCAxMDg2NzNGREZGNjNDNUZENjgyMkMzRTA1N0RFNjk2QwA=', 'text', now(), 'sent', '.', from_unixtime(1744820239)) -> [WabiManager.checkMessageExists] Registrar el mensaje wamid.HBgLNTE5ODk4NDU1NjEVAgASGCAxMDg2NzNGREZGNjNDNUZENjgyMkMzRTA1N0RFNjk2QwA= -> [TemplateMaker.response] mensaje no respondido. motivo: El chat está en modo asesor. No debo responder. [updateLastMessage] query: update chat_status set last_message = now() where client = '51989845561' and waiting = 1 curl response: {"messaging_product":"whatsapp","contacts":[{"input":"51924888706","wa_id":"51924888706"}],"messages":[{"id":"wamid.HBgLNTE5MjQ4ODg3MDYVAgARGBJBQjU5NjkwNEUxREYzQkM2RTgA","message_status":"accepted"}]} [insertMessage] query: insert into messages (sender, receiver, id, msg_type, msg_datetime, msg_status, msg_text, msg_timestamp) values ('15556391605', '51924888706', 'wamid.HBgLNTE5ODk4NDU1NjEVAgASGCAxMDg2NzNGREZGNjNDNUZENjgyMkMzRTA1N0RFNjk2QwA=', 'template', now(), 'sent', 'mensaje_cliente', from_unixtime(1744820239)) -> [TemplateMaker.sendAllNotifications(0)] 1 [insertMessage] query: insert into messages (sender, receiver, id, msg_type, msg_datetime, msg_status, msg_text, msg_timestamp) values ('51989845561', '15556391605', 'wamid.HBgLNTE5ODk4NDU1NjEVAgASGCBDMUM2NzAwRDc3QUYxRkJEMzNERDc3QkMyOEFFRTMwNQA=', 'button', now(), 'sent', 'Volver', from_unixtime(1744820243)) -> [WabiManager.checkMessageExists] Registrar el mensaje wamid.HBgLNTE5ODk4NDU1NjEVAgASGCBDMUM2NzAwRDc3QUYxRkJEMzNERDc3QkMyOEFFRTMwNQA= [closeAllPayloadsOpened] query: update messages set closed = true where sender = '51989845561' and msg_type = 'button' and not closed curl response: {"messaging_product":"whatsapp","contacts":[{"input":"51989845561","wa_id":"51989845561"}],"messages":[{"id":"wamid.HBgLNTE5ODk4NDU1NjEVAgARGBI0MjhEQUU1NjA3MUU4Q0NGMUUA","message_status":"accepted"}]} [insertMessage] query: insert into messages (sender, receiver, id, msg_type, msg_datetime, msg_status, msg_text, msg_timestamp) values ('15556391605', '51989845561', 'wamid.HBgLNTE5ODk4NDU1NjEVAgASGCBDMUM2NzAwRDc3QUYxRkJEMzNERDc3QkMyOEFFRTMwNQA=', 'template', now(), 'sent', 'inicio', from_unixtime(1744820243)) [closePayloadTracking] query: update messages set closed = true where sender = '51989845561' and id = 'wamid.HBgLNTE5ODk4NDU1NjEVAgASGCBDMUM2NzAwRDc3QUYxRkJEMzNERDc3QkMyOEFFRTMwNQA=' and not closed -> [TemplateMaker.response] cerré el mensaje de tracking para 51989845561 -> [TemplateMaker.response] 1 [insertMessage] query: insert into messages (sender, receiver, id, msg_type, msg_datetime, msg_status, msg_text, msg_timestamp) values ('51966729736', '15556391605', 'wamid.HBgLNTE5NjY3Mjk3MzYVAgASGBQzQUNDQzA4NjFENUZDQ0E4MTVEQwA=', 'text', now(), 'sent', 'Hola, quisiera realizar un envío', from_unixtime(1744821109)) -> [WabiManager.checkMessageExists] Registrar el mensaje wamid.HBgLNTE5NjY3Mjk3MzYVAgASGBQzQUNDQzA4NjFENUZDQ0E4MTVEQwA= curl response: {"messaging_product":"whatsapp","contacts":[{"input":"51966729736","wa_id":"51966729736"}],"messages":[{"id":"wamid.HBgLNTE5NjY3Mjk3MzYVAgARGBIzMEUyNTBCMzc4NzhERDJDNkEA","message_status":"accepted"}]} [insertMessage] query: insert into messages (sender, receiver, id, msg_type, msg_datetime, msg_status, msg_text, msg_timestamp) values ('15556391605', '51966729736', 'wamid.HBgLNTE5NjY3Mjk3MzYVAgASGBQzQUNDQzA4NjFENUZDQ0E4MTVEQwA=', 'template', now(), 'sent', 'inicio', from_unixtime(1744821109)) [closePayloadTracking] query: update messages set closed = true where sender = '51966729736' and id = 'wamid.HBgLNTE5NjY3Mjk3MzYVAgASGBQzQUNDQzA4NjFENUZDQ0E4MTVEQwA=' and not closed -> [TemplateMaker.response] cerré el mensaje de tracking para 51966729736 -> [TemplateMaker.response] 1