Processando integração Lupeon - Fassilog

📦 Dados selecionados

Aguardando…

📤 Payload

Aguardando…

🚀 Envio API

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"
    }
}