Processando integração Lupeon - Fassilog
📦 Dados selecionados
Aguardando…
📥 Resposta Lupeon
Aguardando…
Diagnostico automatico
{
"php_now": "2026-11-18 23:45:40",
"date_ini": "2026-08-21",
"date_fim": "2026-11-18",
"periodo_dias": 90,
"observacao": "Contadores limitados ao mesmo periodo do select principal.",
"sql_executada": "\n SELECT Cod,NRomaneio,DataEmissao,CNPJCliente,NomeCliente,chave_nfe,\n ocorrencia_data,img,data_alteracao,NotaFiscal,Cte,status,\n integracao,minuta,lupeon_integra\n FROM itensromaneio\n WHERE (NomeCliente LIKE '%SHERWIN%' OR NomeCliente LIKE '%JEFTE%')\r\n AND status='entregue'\n AND DataEmissao BETWEEN '2026-08-21' AND '2026-11-18'\n AND lupeon_integra='0'\n AND img!=''\n AND data_alteracao <= DATE_SUB(NOW(), INTERVAL 10 MINUTE)\n \n ORDER BY data_alteracao ASC\n LIMIT 1",
"contadores": {
"nome": {
"total": "21090",
"sql": "SELECT COUNT(*) as total FROM itensromaneio WHERE (NomeCliente LIKE '%SHERWIN%' OR NomeCliente LIKE '%JEFTE%') AND DataEmissao BETWEEN '2026-08-21' AND '2026-11-18'"
},
"nome_status": {
"total": "14635",
"sql": "SELECT COUNT(*) as total FROM itensromaneio WHERE (NomeCliente LIKE '%SHERWIN%' OR NomeCliente LIKE '%JEFTE%') AND DataEmissao BETWEEN '2026-08-21' AND '2026-11-18' AND status='entregue'"
},
"nome_status_data": {
"total": "14635",
"sql": "SELECT COUNT(*) as total FROM itensromaneio WHERE (NomeCliente LIKE '%SHERWIN%' OR NomeCliente LIKE '%JEFTE%') AND status='entregue' AND DataEmissao BETWEEN '2026-08-21' AND '2026-11-18'"
},
"nome_status_data_integracao": {
"total": "23",
"sql": "SELECT COUNT(*) as total FROM itensromaneio WHERE (NomeCliente LIKE '%SHERWIN%' OR NomeCliente LIKE '%JEFTE%') AND status='entregue' AND DataEmissao BETWEEN '2026-08-21' AND '2026-11-18' AND lupeon_integra='0'"
},
"nome_status_data_integracao_img": {
"total": "0",
"sql": "SELECT COUNT(*) as total FROM itensromaneio WHERE (NomeCliente LIKE '%SHERWIN%' OR NomeCliente LIKE '%JEFTE%') AND status='entregue' AND DataEmissao BETWEEN '2026-08-21' AND '2026-11-18' AND lupeon_integra='0' AND img!=''"
},
"nome_status_data_integracao_img_carencia": {
"total": "0",
"sql": "SELECT COUNT(*) as total FROM itensromaneio WHERE (NomeCliente LIKE '%SHERWIN%' OR NomeCliente LIKE '%JEFTE%') AND status='entregue' AND DataEmissao BETWEEN '2026-08-21' AND '2026-11-18' AND lupeon_integra='0' AND img!='' AND data_alteracao <= DATE_SUB(NOW(), INTERVAL 10 MINUTE)"
}
},
"amostra": [
{
"Cod": "657614",
"NotaFiscal": "97675",
"Cte": "886855",
"DataEmissao": "2026-11-18",
"NomeCliente": "SHERWIN TABOAO",
"chave_nfe": "35261160872306000160550030000976751101928225",
"status": "entregue",
"img": "[\"97675-886855-657614-0-c0e7f8380f0321a0.jpg\"]",
"lupeon_integra": "2",
"data_alteracao": "2026-11-18 18:44:06"
},
{
"Cod": "657613",
"NotaFiscal": "97676",
"Cte": "886855",
"DataEmissao": "2026-11-18",
"NomeCliente": "SHERWIN TABOAO",
"chave_nfe": "35261160872306000160550030000976761101928621",
"status": "entregue",
"img": "[\"97676-886855-657613-0-3f633a5fc51a9a49.jpg\"]",
"lupeon_integra": "2",
"data_alteracao": "2026-11-18 18:44:01"
},
{
"Cod": "657591",
"NotaFiscal": "374909",
"Cte": "886899",
"DataEmissao": "2026-11-18",
"NomeCliente": "SHERWIN ARUJA",
"chave_nfe": "35261160872306000836550050003749091721560680",
"status": "entregue",
"img": "[\"374909-886899-657591-0-90d06a1d62c0224d.jpg\"]",
"lupeon_integra": "2",
"data_alteracao": "2026-11-18 17:58:44"
},
{
"Cod": "657596",
"NotaFiscal": "374914",
"Cte": "886904",
"DataEmissao": "2026-11-18",
"NomeCliente": "SHERWIN ARUJA",
"chave_nfe": "35261160872306000836550050003749141645581660",
"status": "entregue",
"img": "",
"lupeon_integra": "0",
"data_alteracao": "2026-11-18 17:57:42"
},
{
"Cod": "657595",
"NotaFiscal": "374913",
"Cte": "886903",
"DataEmissao": "2026-11-18",
"NomeCliente": "SHERWIN ARUJA",
"chave_nfe": "35261160872306000836550050003749131641418732",
"status": "entregue",
"img": "[\"374913-886903-657595-0-de8e144ce62a4cbf.jpg\"]",
"lupeon_integra": "2",
"data_alteracao": "2026-11-18 17:57:02"
},
{
"Cod": "657156",
"NotaFiscal": "1449791",
"Cte": "884515",
"DataEmissao": "2026-11-18",
"NomeCliente": "SHERWIN TABOAO",
"chave_nfe": "35261160872306000160550010014497911101863697",
"status": "ocorrencia",
"img": "[\"657156-1449791-0.png\"]",
"lupeon_integra": "0",
"data_alteracao": "2026-11-18 17:57:00"
},
{
"Cod": "657594",
"NotaFiscal": "374912",
"Cte": "886902",
"DataEmissao": "2026-11-18",
"NomeCliente": "SHERWIN ARUJA",
"chave_nfe": "35261160872306000836550050003749121590222669",
"status": "entregue",
"img": "[\"374912-886902-657594-0-372fafd5ddf8b073.jpg\"]",
"lupeon_integra": "2",
"data_alteracao": "2026-11-18 17:56:57"
},
{
"Cod": "657593",
"NotaFiscal": "374911",
"Cte": "886901",
"DataEmissao": "2026-11-18",
"NomeCliente": "SHERWIN ARUJA",
"chave_nfe": "35261160872306000836550050003749111860715452",
"status": "entregue",
"img": "[\"374911-886901-657593-0-ccd0cfbfcb6e7a71.jpg\"]",
"lupeon_integra": "2",
"data_alteracao": "2026-11-18 17:56:52"
},
{
"Cod": "657592",
"NotaFiscal": "374910",
"Cte": "886900",
"DataEmissao": "2026-11-18",
"NomeCliente": "SHERWIN ARUJA",
"chave_nfe": "35261160872306000836550050003749101014285155",
"status": "entregue",
"img": "[\"374910-886900-657592-0-c19bf5541720338d.jpg\"]",
"lupeon_integra": "2",
"data_alteracao": "2026-11-18 17:54:28"
},
{
"Cod": "657164",
"NotaFiscal": "668323",
"Cte": "885566",
"DataEmissao": "2026-11-18",
"NomeCliente": "SHERWIN SUMARE",
"chave_nfe": "35261160872306004661550010006683231101897735",
"status": "ocorrencia",
"img": "[\"657164-668323-0.jpeg\",\"657164-668323-0.jpeg\",\"657164-668323-0.jpeg\"]",
"lupeon_integra": "0",
"data_alteracao": "2026-11-18 17:54:00"
},
{
"Cod": "657590",
"NotaFiscal": "374907",
"Cte": "886898",
"DataEmissao": "2026-11-18",
"NomeCliente": "SHERWIN ARUJA",
"chave_nfe": "35261160872306000836550050003749071916126322",
"status": "entregue",
"img": "[\"374907-886898-657590-0-003f546f3bae126b.jpg\"]",
"lupeon_integra": "2",
"data_alteracao": "2026-11-18 17:52:15"
},
{
"Cod": "657154",
"NotaFiscal": "667943",
"Cte": "884731",
"DataEmissao": "2026-11-18",
"NomeCliente": "SHERWIN SUMARE",
"chave_nfe": "35261160872306004661550010006679431101868914",
"status": "ocorrencia",
"img": "[\"657154-667943-0.png\"]",
"lupeon_integra": "0",
"data_alteracao": "2026-11-18 17:47:00"
},
{
"Cod": "657155",
"NotaFiscal": "1449773",
"Cte": "884515",
"DataEmissao": "2026-11-18",
"NomeCliente": "SHERWIN TABOAO",
"chave_nfe": "35261160872306000160550010014497731101863516",
"status": "ocorrencia",
"img": "[\"657155-1449773-0.png\",\"657155-1449773-0.png\",\"657155-1449773-0.png\",\"657155-1449773-0.png\",\"657155-1449773-0.png\",\"657155-1449773-0.png\",\"657155-1449773-0.png\",\"657155-1449773-0.png\",\"657155-1449773-0.png\"]",
"lupeon_integra": "0",
"data_alteracao": "2026-11-18 17:46:00"
},
{
"Cod": "657552",
"NotaFiscal": "1450587",
"Cte": "885480",
"DataEmissao": "2026-11-18",
"NomeCliente": "SHERWIN TABOAO",
"chave_nfe": "35261160872306000160550010014505871101896632",
"status": "entregue",
"img": "[\"canhotoretido.png\"]",
"lupeon_integra": "1",
"data_alteracao": "2026-11-18 17:31:00"
},
{
"Cod": "657549",
"NotaFiscal": "1450581",
"Cte": "885480",
"DataEmissao": "2026-11-18",
"NomeCliente": "SHERWIN TABOAO",
"chave_nfe": "35261160872306000160550010014505811101896590",
"status": "entregue",
"img": "[\"canhotoretido.png\"]",
"lupeon_integra": "1",
"data_alteracao": "2026-11-18 17:30:00"
},
{
"Cod": "657550",
"NotaFiscal": "1450582",
"Cte": "885480",
"DataEmissao": "2026-11-18",
"NomeCliente": "SHERWIN TABOAO",
"chave_nfe": "35261160872306000160550010014505821101896628",
"status": "entregue",
"img": "[\"canhotoretido.png\"]",
"lupeon_integra": "1",
"data_alteracao": "2026-11-18 17:30:00"
},
{
"Cod": "657551",
"NotaFiscal": "1450583",
"Cte": "885480",
"DataEmissao": "2026-11-18",
"NomeCliente": "SHERWIN TABOAO",
"chave_nfe": "35261160872306000160550010014505831101896587",
"status": "entregue",
"img": "[\"canhotoretido.png\"]",
"lupeon_integra": "1",
"data_alteracao": "2026-11-18 17:30:00"
},
{
"Cod": "657548",
"NotaFiscal": "1450586",
"Cte": "885480",
"DataEmissao": "2026-11-18",
"NomeCliente": "SHERWIN TABOAO",
"chave_nfe": "35261160872306000160550010014505861101896562",
"status": "entregue",
"img": "[\"canhotoretido.png\"]",
"lupeon_integra": "1",
"data_alteracao": "2026-11-18 17:29:00"
},
{
"Cod": "657553",
"NotaFiscal": "668477",
"Cte": "885585",
"DataEmissao": "2026-11-18",
"NomeCliente": "SHERWIN SUMARE",
"chave_nfe": "35261160872306004661550010006684771101905122",
"status": "entregue",
"img": "[\"canhotoretido.png\"]",
"lupeon_integra": "1",
"data_alteracao": "2026-11-18 17:29:00"
},
{
"Cod": "657554",
"NotaFiscal": "668183",
"Cte": "885570",
"DataEmissao": "2026-11-18",
"NomeCliente": "SHERWIN SUMARE",
"chave_nfe": "35261160872306004661550010006681831101901284",
"status": "entregue",
"img": "[\"canhotoretido.png\"]",
"lupeon_integra": "1",
"data_alteracao": "2026-11-18 17:29:00"
}
],
"banco": {
"banco_now": "2026-11-18 23:45:40",
"banco_date": "2026-11-18"
}
}