Processando integração Lupeon - Fassilog
📦 Dados selecionados
Aguardando…
📥 Resposta Lupeon
Aguardando…
Diagnostico automatico
{
"php_now": "2026-09-19 01:33:21",
"date_ini": "2026-06-21",
"date_fim": "2026-09-19",
"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-06-21' AND '2026-09-19'\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": "22293",
"sql": "SELECT COUNT(*) as total FROM itensromaneio WHERE (NomeCliente LIKE '%SHERWIN%' OR NomeCliente LIKE '%JEFTE%') AND DataEmissao BETWEEN '2026-06-21' AND '2026-09-19'"
},
"nome_status": {
"total": "15324",
"sql": "SELECT COUNT(*) as total FROM itensromaneio WHERE (NomeCliente LIKE '%SHERWIN%' OR NomeCliente LIKE '%JEFTE%') AND DataEmissao BETWEEN '2026-06-21' AND '2026-09-19' AND status='entregue'"
},
"nome_status_data": {
"total": "15324",
"sql": "SELECT COUNT(*) as total FROM itensromaneio WHERE (NomeCliente LIKE '%SHERWIN%' OR NomeCliente LIKE '%JEFTE%') AND status='entregue' AND DataEmissao BETWEEN '2026-06-21' AND '2026-09-19'"
},
"nome_status_data_integracao": {
"total": "120",
"sql": "SELECT COUNT(*) as total FROM itensromaneio WHERE (NomeCliente LIKE '%SHERWIN%' OR NomeCliente LIKE '%JEFTE%') AND status='entregue' AND DataEmissao BETWEEN '2026-06-21' AND '2026-09-19' 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-06-21' AND '2026-09-19' 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-06-21' AND '2026-09-19' AND lupeon_integra='0' AND img!='' AND data_alteracao <= DATE_SUB(NOW(), INTERVAL 10 MINUTE)"
}
},
"amostra": [
{
"Cod": "624299",
"NotaFiscal": "366842",
"Cte": "872307",
"DataEmissao": "2026-09-18",
"NomeCliente": "SHERWIN ARUJA",
"chave_nfe": "35260960872306000836550050003668421833052564",
"status": "entregue",
"img": "[\"366842-872307-624299-0.jpg\"]",
"lupeon_integra": "2",
"data_alteracao": "2026-09-18 20:08:05"
},
{
"Cod": "624298",
"NotaFiscal": "366841",
"Cte": "872314",
"DataEmissao": "2026-09-18",
"NomeCliente": "SHERWIN ARUJA",
"chave_nfe": "35260960872306000836550050003668411533842511",
"status": "entregue",
"img": "[\"366841-872314-624298-0.jpg\"]",
"lupeon_integra": "2",
"data_alteracao": "2026-09-18 20:08:00"
},
{
"Cod": "624297",
"NotaFiscal": "366840",
"Cte": "872316",
"DataEmissao": "2026-09-18",
"NomeCliente": "SHERWIN ARUJA",
"chave_nfe": "35260960872306000836550050003668401937484253",
"status": "entregue",
"img": "[\"366840-872316-624297-0.jpg\"]",
"lupeon_integra": "2",
"data_alteracao": "2026-09-18 20:07:55"
},
{
"Cod": "624296",
"NotaFiscal": "366839",
"Cte": "872306",
"DataEmissao": "2026-09-18",
"NomeCliente": "SHERWIN ARUJA",
"chave_nfe": "35260960872306000836550050003668391280006070",
"status": "entregue",
"img": "[\"366839-872306-624296-0.jpg\"]",
"lupeon_integra": "2",
"data_alteracao": "2026-09-18 20:07:50"
},
{
"Cod": "624295",
"NotaFiscal": "366838",
"Cte": "872315",
"DataEmissao": "2026-09-18",
"NomeCliente": "SHERWIN ARUJA",
"chave_nfe": "35260960872306000836550050003668381147642975",
"status": "entregue",
"img": "[\"366838-872315-624295-0.jpg\"]",
"lupeon_integra": "2",
"data_alteracao": "2026-09-18 20:07:45"
},
{
"Cod": "624294",
"NotaFiscal": "366837",
"Cte": "872305",
"DataEmissao": "2026-09-18",
"NomeCliente": "SHERWIN ARUJA",
"chave_nfe": "35260960872306000836550050003668371067256257",
"status": "entregue",
"img": "[\"366837-872305-624294-0.jpg\"]",
"lupeon_integra": "2",
"data_alteracao": "2026-09-18 20:07:40"
},
{
"Cod": "624293",
"NotaFiscal": "366836",
"Cte": "872310",
"DataEmissao": "2026-09-18",
"NomeCliente": "SHERWIN ARUJA",
"chave_nfe": "35260960872306000836550050003668361403013868",
"status": "entregue",
"img": "[\"366836-872310-624293-0.jpg\"]",
"lupeon_integra": "2",
"data_alteracao": "2026-09-18 20:05:34"
},
{
"Cod": "624292",
"NotaFiscal": "366835",
"Cte": "872309",
"DataEmissao": "2026-09-18",
"NomeCliente": "SHERWIN ARUJA",
"chave_nfe": "35260960872306000836550050003668351301495955",
"status": "entregue",
"img": "[\"366835-872309-624292-0.jpg\"]",
"lupeon_integra": "2",
"data_alteracao": "2026-09-18 20:05:29"
},
{
"Cod": "624291",
"NotaFiscal": "366834",
"Cte": "872312",
"DataEmissao": "2026-09-18",
"NomeCliente": "SHERWIN ARUJA",
"chave_nfe": "35260960872306000836550050003668341155374233",
"status": "entregue",
"img": "[\"366834-872312-624291-0.jpg\"]",
"lupeon_integra": "2",
"data_alteracao": "2026-09-18 20:05:24"
},
{
"Cod": "624290",
"NotaFiscal": "366833",
"Cte": "872313",
"DataEmissao": "2026-09-18",
"NomeCliente": "SHERWIN ARUJA",
"chave_nfe": "35260960872306000836550050003668331842415497",
"status": "entregue",
"img": "[\"366833-872313-624290-0.jpg\"]",
"lupeon_integra": "2",
"data_alteracao": "2026-09-18 20:05:19"
},
{
"Cod": "624289",
"NotaFiscal": "366832",
"Cte": "872308",
"DataEmissao": "2026-09-18",
"NomeCliente": "SHERWIN ARUJA",
"chave_nfe": "35260960872306000836550050003668321911577996",
"status": "entregue",
"img": "[\"366832-872308-624289-0.jpg\"]",
"lupeon_integra": "2",
"data_alteracao": "2026-09-18 20:05:14"
},
{
"Cod": "624300",
"NotaFiscal": "366843",
"Cte": "872311",
"DataEmissao": "2026-09-18",
"NomeCliente": "SHERWIN ARUJA",
"chave_nfe": "35260960872306000836550050003668431955974331",
"status": "entregue",
"img": "[\"366843-872311-624300-0.jpg\"]",
"lupeon_integra": "2",
"data_alteracao": "2026-09-18 20:03:19"
},
{
"Cod": "624288",
"NotaFiscal": "366831",
"Cte": "872303",
"DataEmissao": "2026-09-18",
"NomeCliente": "SHERWIN ARUJA",
"chave_nfe": "35260960872306000836550050003668311362451860",
"status": "entregue",
"img": "[\"366831-872303-624288-0.jpg\"]",
"lupeon_integra": "2",
"data_alteracao": "2026-09-18 20:03:14"
},
{
"Cod": "624287",
"NotaFiscal": "366830",
"Cte": "872304",
"DataEmissao": "2026-09-18",
"NomeCliente": "SHERWIN ARUJA",
"chave_nfe": "35260960872306000836550050003668301275714954",
"status": "entregue",
"img": "[\"366830-872304-624287-0.jpg\"]",
"lupeon_integra": "2",
"data_alteracao": "2026-09-18 20:03:09"
},
{
"Cod": "624615",
"NotaFiscal": "42653",
"Cte": "0",
"DataEmissao": "2026-09-18",
"NomeCliente": "SHERWIN SBC",
"chave_nfe": "35260971676001000107550010000426531325846570",
"status": "entregue",
"img": "[\"42653-0-624615-0.jpg\"]",
"lupeon_integra": "2",
"data_alteracao": "2026-09-18 19:12:58"
},
{
"Cod": "624614",
"NotaFiscal": "42652",
"Cte": "0",
"DataEmissao": "2026-09-18",
"NomeCliente": "SHERWIN SBC",
"chave_nfe": "35260971676001000107550010000426521827002002",
"status": "entregue",
"img": "[\"42652-0-624614-0.jpg\"]",
"lupeon_integra": "2",
"data_alteracao": "2026-09-18 19:12:53"
},
{
"Cod": "624613",
"NotaFiscal": "42651",
"Cte": "0",
"DataEmissao": "2026-09-18",
"NomeCliente": "SHERWIN SBC",
"chave_nfe": "35260971676001000107550010000426511720001923",
"status": "entregue",
"img": "[\"42651-0-624613-0.jpg\"]",
"lupeon_integra": "2",
"data_alteracao": "2026-09-18 19:12:48"
},
{
"Cod": "624612",
"NotaFiscal": "18858",
"Cte": "0",
"DataEmissao": "2026-09-18",
"NomeCliente": "SHERWIN SBC",
"chave_nfe": "35260971676001000360550010000188581219832078",
"status": "entregue",
"img": "[\"18858-0-624612-0.jpg\"]",
"lupeon_integra": "2",
"data_alteracao": "2026-09-18 19:12:43"
},
{
"Cod": "624611",
"NotaFiscal": "18857",
"Cte": "0",
"DataEmissao": "2026-09-18",
"NomeCliente": "SHERWIN SBC",
"chave_nfe": "35260971676001000360550010000188571753803109",
"status": "entregue",
"img": "[\"18857-0-624611-0.jpg\"]",
"lupeon_integra": "2",
"data_alteracao": "2026-09-18 19:12:38"
},
{
"Cod": "624610",
"NotaFiscal": "18856",
"Cte": "0",
"DataEmissao": "2026-09-18",
"NomeCliente": "SHERWIN SBC",
"chave_nfe": "35260971676001000360550010000188561969819294",
"status": "entregue",
"img": "[\"18856-0-624610-0.jpg\"]",
"lupeon_integra": "2",
"data_alteracao": "2026-09-18 19:12:33"
}
],
"banco": {
"banco_now": "2026-09-19 01:33:21",
"banco_date": "2026-09-19"
}
}