TransWar File Browser

Path: C:\

<?php
// Consulta JotForm NOVO (form 260704561342653) por numero NF = 102
$apiKey = '9659ead4a973f60dc8b567df2e4f259d';

// Primeiro: busca por campo 120 (numero NF) = 102
$url = "https://api.jotform.com/form/260704561342653/submissions?apikey={$apiKey}&limit=50&filter=" . urlencode('{"status":"ACTIVE","q120:eq":"102"}');
$ch = curl_init($url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
$r = curl_exec($ch);
curl_close($ch);
$d = json_decode($r, true);

echo "=== FORM NOVO (260704561342653) - Filtro q120=102 ===" . PHP_EOL;
echo "Total encontrado: " . count($d['content']) . PHP_EOL;
foreach ($d['content'] as $i => $s) {
    $f116 = isset($s['answers'][116]['answer']) ? $s['answers'][116]['answer'] : 'VAZIO';
    $f120 = isset($s['answers'][120]['answer']) ? $s['answers'][120]['answer'] : 'VAZIO';
    $f73  = isset($s['answers'][73]['answer'])  ? $s['answers'][73]['answer']  : 'VAZIO';
    echo "  #{$i}: ID={$s['id']} created={$s['created_at']} field73(movimentacao)={$f73} field120(nf)={$f120} field116(chave)=" . substr($f116, 0, 20) . "..." . PHP_EOL;
}

// Segundo: busca no form ANTIGO (240113399602047) por numero NF = 102
echo PHP_EOL . "=== FORM ANTIGO (240113399602047) - Filtro q120=102 ===" . PHP_EOL;
$url2 = "https://api.jotform.com/form/240113399602047/submissions?apikey={$apiKey}&limit=50&filter=" . urlencode('{"status":"ACTIVE","q120:eq":"102"}');
$ch2 = curl_init($url2);
curl_setopt($ch2, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch2, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($ch2, CURLOPT_SSL_VERIFYHOST, false);
$r2 = curl_exec($ch2);
curl_close($ch2);
$d2 = json_decode($r2, true);

echo "Total encontrado: " . count($d2['content']) . PHP_EOL;
foreach ($d2['content'] as $i => $s) {
    $f116 = isset($s['answers'][116]['answer']) ? $s['answers'][116]['answer'] : 'VAZIO';
    $f120 = isset($s['answers'][120]['answer']) ? $s['answers'][120]['answer'] : 'VAZIO';
    $f73  = isset($s['answers'][73]['answer'])  ? $s['answers'][73]['answer']  : 'VAZIO';
    echo "  #{$i}: ID={$s['id']} created={$s['created_at']} field73(movimentacao)={$f73} field120(nf)={$f120} field116(chave)=" . substr($f116, 0, 20) . "..." . PHP_EOL;
}

// Terceiro: busca por chave exata no form NOVO
echo PHP_EOL . "=== FORM NOVO - Filtro pela CHAVE completa ===" . PHP_EOL;
$chave = '52260582637109002061550010000001021951578368';
$url3 = "https://api.jotform.com/form/260704561342653/submissions?apikey={$apiKey}&limit=50&filter=" . urlencode('{"status":"ACTIVE","q116:eq":"' . $chave . '"}');
$ch3 = curl_init($url3);
curl_setopt($ch3, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch3, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($ch3, CURLOPT_SSL_VERIFYHOST, false);
$r3 = curl_exec($ch3);
curl_close($ch3);
$d3 = json_decode($r3, true);

echo "Total encontrado: " . count($d3['content']) . PHP_EOL;
foreach ($d3['content'] as $i => $s) {
    $f116 = isset($s['answers'][116]['answer']) ? $s['answers'][116]['answer'] : 'VAZIO';
    $f120 = isset($s['answers'][120]['answer']) ? $s['answers'][120]['answer'] : 'VAZIO';
    $f73  = isset($s['answers'][73]['answer'])  ? $s['answers'][73]['answer']  : 'VAZIO';
    echo "  #{$i}: ID={$s['id']} created={$s['created_at']} field73(movimentacao)={$f73} field120(nf)={$f120} field116(chave)={$f116}" . PHP_EOL;
}

// Quarto: mesma consulta no form ANTIGO pela chave
echo PHP_EOL . "=== FORM ANTIGO - Filtro pela CHAVE completa ===" . PHP_EOL;
$url4 = "https://api.jotform.com/form/240113399602047/submissions?apikey={$apiKey}&limit=50&filter=" . urlencode('{"status":"ACTIVE","q116:eq":"' . $chave . '"}');
$ch4 = curl_init($url4);
curl_setopt($ch4, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch4, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($ch4, CURLOPT_SSL_VERIFYHOST, false);
$r4 = curl_exec($ch4);
curl_close($ch4);
$d4 = json_decode($r4, true);

echo "Total encontrado: " . count($d4['content']) . PHP_EOL;
foreach ($d4['content'] as $i => $s) {
    $f116 = isset($s['answers'][116]['answer']) ? $s['answers'][116]['answer'] : 'VAZIO';
    $f120 = isset($s['answers'][120]['answer']) ? $s['answers'][120]['answer'] : 'VAZIO';
    $f73  = isset($s['answers'][73]['answer'])  ? $s['answers'][73]['answer']  : 'VAZIO';
    echo "  #{$i}: ID={$s['id']} created={$s['created_at']} field73(movimentacao)={$f73} field120(nf)={$f120} field116(chave)={$f116}" . PHP_EOL;
}