Path: C:\
<?php
ini_set('max_execution_time',259200);
ini_set ('memory_limit','-1');
setlocale(LC_TIME, 'pt_BR', 'pt_BR.utf-8', 'pt_BR.utf-8', 'portuguese');
date_default_timezone_set('America/Fortaleza');
define('URL_HTTP_SiiMP', 'https://transwar.lannister.emitir.me/nfs/search?id=');
define('API_KEY_SiiMP', '75594207-b5d7-43bf-a7c2-571b3030308d');
define('PATH_FOTO','http://192.168.0.201/hmc/');
define('PATH_JSON','\\\\192.168.0.210\\jotform_db\\json\\');
define('PATH_LOGS','\\\\192.168.0.210\\jotform_db\\logs\\');
function getName($string) {
$ct=explode("/", $string);
$nm=$ct[count($ct)-1];
return $nm;
}
function pastaExiste($path,$pasta) {
if (is_dir($path.$pasta.'\\')) {
return true; // a pasta já existe
}else{
mkdir($path.$pasta.'\\', 0777, true);
return false;
}
}
function Limpa($str){
$limpa=str_replace('[', '', $str);
$limpa=str_replace(']', '', $limpa);
$limpa=str_replace('"', '', $limpa);
return $limpa;
}
$fopen_logs = fopen(PATH_LOGS.'mysql.txt','a');
require_once("conecta_mysql.php");
require_once("RequestAPI.php");
$numero=$_POST['numero1'];
for ($q=0; $q <= 50; $q++) {$resultset[$q]='';}
$resultset[10]=$resultset[43]=0;
$sql = "SELECT * FROM jotform_HMC where nr_etiqueta='$numero' order by nr_etiqueta asc,id_submission desc;";
if (!$query = mysqli_query($conn, $sql)){
echo "<script type=\"text/javascript\">alert(\"Erro no Banco de Dados!\");window.close();opener.location.href='index.php';</script>";
}else{ $num = mysqli_num_rows($query);
if($num==0){ echo "<script type=\"text/javascript\">alert(\"Nº de Etiqueta não existe!\");opener.location.href='index.php';</script>";
}else{
while($row = $query->fetch_assoc()) {
$ler[$numero][$row['dt_pasta']][]=$row['id_submission'];
}
}
}
//echo '<pre>';
$resp=array();
foreach($ler[$numero] as $dia => $ids){
//echo 'Abre json: submissions_'.$dia.'<br>';
$arq=PATH_JSON.'submissions_'.$dia.'.json';
if (file_exists($arq)){
$json_sub = file_get_contents($arq);
$sub_dia = json_decode($json_sub, true)['content'];
foreach($ids as $nr => $id){
//echo 'Id: '.$id.'<br>';
foreach($sub_dia as $regs => $reg){
if($reg['id']==$id){$resp[]=$reg;}
}
}
}
}
$nl = count($resp); // Número de Linhas
if ($nl >=1 ){
$data=$resp;
if($numero!='9999999'){
$v1=$numero;
$dataResponse = new RequestAPI();
$siimp = $dataResponse->getResponse($v1);
if ($siimp['success']==1){
$resultset[8] = $siimp['data'][0]['qtd']; // volume
$resultset[9] = $siimp['data'][0]['number']; // nº nf
$resultset[10] = $siimp['data'][0]['total']; // valor
$resultset[30] = ''; // data limite de entrega
$resultset[37] = ''; // data da coleta
$resultset[43] = $siimp['data'][0]['weight']; // peso
$resultset[14] = $siimp['data'][0]['issuer']['name']; // remetente
$resultset[20] = $siimp['data'][0]['addressee']['name']; // destinatário
$resultset[21] = $siimp['data'][0]['addressee']['address']['street']; // end. destinatário
$resultset[22] = $siimp['data'][0]['addressee']['address']['district'].', '.$siimp['data'][0]['addressee']['address']['number'];
$resultset[23] = $siimp['data'][0]['addressee']['address']['city']['name'];
$resultset[24] = $siimp['data'][0]['addressee']['address']['zipcode'];
if (isset($siimp['data'][0]['receiver'])){
$resultset[15] = $siimp['data'][0]['receiver']['name']; // redespacho
$resultset[16] = $siimp['data'][0]['receiver']['address']['street']; // end. redespacho
$resultset[17] = $siimp['data'][0]['receiver']['address']['district'].', '.$siimp['data'][0]['receiver']['address']['number'];
$resultset[18] = $siimp['data'][0]['receiver']['address']['city']['name'];
$resultset[19] = $siimp['data'][0]['receiver']['address']['zipcode'];
}
}
}
$start=0;
$stop=$nl-1;
for($q=$start;$q<=$stop;$q++){
$f=0;$foto[$q]=array();$n9[$q]=0;
$diafoto=substr($data[$q]['created_at'], 0,10);
for($w=64;$w<=104;$w++){
if(isset($data[$q]['answers'][$w]['answer'])){
$answer[$q][$w]=$data[$q]['answers'][$w]['answer'];
}else{
$answer[$q][$w]='';
}
if($w==92 or $w==93 or $w==67 or $w==75 or $w==76 or $w==82){
foreach($data[$q]['answers'][$w]['answer'] as $fot){
$f++;
//if($w==67){ $fot=PATH_FOTO.$diafoto.'/'.getName($fot);}
$fot=PATH_FOTO.$diafoto.'/'.getName($fot);
$foto[$q][$f]=$fot;
$n9[$q]=$f;$ativo[$q][$f]='';
if($w==92){$titulo[$q][$f]='FOTO DA AVARIA';}else{
if($w==93){$titulo[$q][$f]='FOTO DA SUJIDADE';}else{
if($w==67){$titulo[$q][$f]='FOTO DA NF: '.$answer[$q][64];}else{
$titulo[$q][$f]=$data[$q]['answers'][$w]['text'];
}
}
}
}
}
}
$answer[$q][84]=explode(";",$answer[$q][84])[0];
$ativo[$q][1]=' active';
}
$resultado='
<div><br></div>
<p align="center">
<button id="btn_nf" class="btn btn-info" type="button" data-toggle="collapse" data-target="#nf" aria-expanded="false" aria-controls="collapseExample" onclick="javascript:botao1();" value="Mostrar">
Mostrar Detalhes da(s) NF(s)
</button>
</p>
<div class="collapse" id="nf">
<table class="box" align="center" >
<tr height="45">
<td colspan="3" align="center" style="width:60%">
<font color="black" size="4" style="border: solid 1px #3073AE;color:white;border-radius:5px;background-color:#3073AE"> NF(s): '.$resultset[9].' </font>
</td>
<td colspan="3" align="center" style="width:40%">
<font color="black" size="2" style="border: solid 1px #3073AE;color:white;border-radius:5px;background-color:#3073AE"> Entrega Prevista: '.$resultset[30].' </font>
</td>
</tr>
<tr class="col-2">
<td style="width:50%"><label>Remetente</label><span>'.$resultset[14].'</span></td>
<td style="width:20%"><label>Valor da(s) NF(s)</label><span>R$ '.number_format($resultset[10], 2, ',', '.').'</span></td>
<td style="width:10%"><label>Volume</label><span>'.$resultset[8].'</span></td>
<td style="width:10%"><label>Peso</label><span>'.number_format($resultset[43], 2, ',', '.').'</span></td>
<td style="width:10%"><label>Data Coleta</label><span>'.$resultset[37].'</span></td>
</tr>
</table>
<table class="box" align="center" >
<tr class="col-2">
<td colspan="2"><label>Destinatário</label><span>'.$resultset[20].'</span></td>
<td colspan="2"><label>Endereço</label><span>'.$resultset[21].'</span></td>
</tr>
<tr class="col-2">
<td colspan="2" style="width:50%"><label>Bairro</label><span>'.$resultset[22].'</span></td>
<td style="width:40%"><label>Cidade/UF</label><span>'.$resultset[23].'</span></td>
<td style="width:10%"><label>CEP</label><span>'.$resultset[24].'</span></td>
</tr>
</table>';
if ($resultset[15]!==''){
$resultado.='
<table class="box" align="center">
<tr class="col-2">
<td colspan="2"><label>Redespacho</label><span>'.$resultset[15].'</span></td>
<td colspan="2"><label>Endereço</label><span>'.$resultset[16].'</span></td>
</tr>
<tr class="col-2">
<td colspan="2" style="width:50%"><label>Bairro</label><span>'.$resultset[17].'</span></td>
<td style="width:40%"><label>Cidade/UF</label><span>'.$resultset[18].'</span></td>
<td style="width:10%"><label>CEP</label><span>'.$resultset[19].'</span></td>
</tr>
</table>';
}
$resultado.='
</div>
<div id="adm" align="center">
<table class="box" width="90%" align="center" cellpadding="1" cellspacing="1" >';
for ($q=$start; $q <= $stop; $q++) {
if ($q == $start and $q==$stop) {$bg='<img src="images/local00.png" width="50%" height="100"';} else if ($q == $start) {$bg='<img src="images/local02.png" width="50%" height="100"';} else if ($q == $stop) {$bg='<img src="images/local01.png" width="50%" height="100"';} else {$bg='<img src="images/meio00.png" width="50%" height="100"';}
$cor='black';
$mantem=strstr($answer[$q][100], ' ', true);
$resultado.='
<table class="ocorre" CELLSPACING="0" CELLPADDING="2" width="90%" align="center" >
<TR align="center">
<TD width="15%" ROWSPAN="4" >'.$bg.'</TD>
<TD style="color:green;font-weight: bold;font-size:14px;" width="25%">'.utf8_encode(strftime('%A', strtotime($data[$q]['created_at']))).'</TD>
<TD style="color:green;font-weight: bold;font-size:12px;" width="45%" align="left">'.$answer[$q][84].'</TD>';
if($mantem=='MANTEM'){
$resultado.='
<TD width="15%" ROWSPAN="4" align="center">
<p align="center">
<button id="btn'.$q.'" class="btn btn-info" type="button" data-toggle="collapse" data-target="#adm'.$q.'" aria-expanded="false" aria-controls="collapseExample" onclick="javascript:botao('.$q.');" value="Mantem">Mantem Condições</button>
</p>
</TD>';
}
else{
$resultado.='
<TD width="15%" ROWSPAN="4" align="center">
<p align="center">
<button id="btn'.$q.'" class="btn btn-info" type="button" data-toggle="collapse" data-target="#adm'.$q.'" aria-expanded="false" aria-controls="collapseExample" onclick="javascript:botao('.$q.');" value="Mostrar">Mostrar Detalhes</button>
</p>
</TD>';
}
$resultado.='
</TR>
<TR align="center">
<TD style="color:black;font-weight: bold;font-size:16px;">'.utf8_encode(strftime('%d de %B de %Y', strtotime($data[$q]['created_at']))).'</TD>
<TD style="color:'.$cor.';font-weight: bold;font-size:14px;" align="left">'.$answer[$q][73].'</TD>
</TR>
<TR align="center">
<TD style="color:blue;font-weight: bold;font-size:14px;" width="30%">'.utf8_encode(strftime('%H:%M', strtotime($data[$q]['created_at']))).' Horário local</TD>';
$obs='';
if ($answer[$q][95]!=='') { $obs=$answer[$q][95];}
if ($answer[$q][104]!=='') { $obs='CARREGAMENTO POR: '.$answer[$q][104];}
$resultado.='
<TD style="color:green;font-weight: bold;font-size:12px;" align="left">'.$obs.'</TD>
</TR>
<TR align="center">
<TD> </TD>
</TR>
</table>
<div class="collapse" id="adm'.$q.'" align="center">
<table class="box" align="center" >';
if($mantem!=='MANTEM'){
$resultado.='
<tr class="col-2">
<td style="width:40%" colspan="4"><label>Nome do Cliente:</label><span>'.$answer[$q][78].'</span></td>';
if($answer[$q][101]!==''){ $nf=$answer[$q][101];}
else{
if($answer[$q][64]!==''){$nf=$answer[$q][64];}
else{$nf='';}}
$resultado.='
<td style="width:60%" colspan="5"><label>Nº da(s) NF(s)</label><span>'.$nf.'</span></td>
</tr>
<tr class="col-2">
<td style="width:10%"><label>Volumes</label><span>'.$answer[$q][68].'</span></td>
<td style="width:10%"><label>Ressalvas na NF?</label><span>'.$answer[$q][98].'</span></td>
<td style="width:20%" colspan="2"><label>Com Avarias?</label><span>'.$answer[$q][81].'</span></td>
<td style="width:10%"><label>Com Sujidade?</label><span>'.$answer[$q][89].'</span></td>
<td style="width:20%" colspan="2"><label>Dados da NF Conferem?</label><span>'.$answer[$q][85].'</span></td>
<td style="width:30%" colspan="2"><label>Carga foi Remontada?</label><span>'.$answer[$q][103].'</span></td>
</tr>
<tr class="col-2">';
$tab='';
if(is_array($answer[$q][77])){
foreach($answer[$q][77] as $carac){
if(trim($carac)=='QUÍMICO CLASSIFICADO (ONU)'){$tab='onu';}
}
}
if(is_array($answer[$q][72])){ $tp_forma=$answer[$q][72]['other'];}
else{ $tp_forma=$answer[$q][72];}
if(is_array($answer[$q][96])){ $tp_palete=$answer[$q][96]['other'];}
else{ $tp_palete=$answer[$q][96];}
if($tab=='onu'){
$resultado.='
<td colspan="3"><label>Forma de Acondicionamento:</label><span>'.$tp_forma.'</span></td>
<td colspan="3"><label>Tipo de Palete</label><span>'.$tp_palete.'</span></td>
<td colspan="3"><label>Número ONU</label><span>'.$answer[$q][86].'</span></td>';
}else{
$resultado.='
<td colspan="5"><label>Forma de Acondicionamento:</label><span>'.$tp_forma.'</span></td>
<td colspan="4"><label>Tipo de Palete</label><span>'.$tp_palete.'</span></td>';
}
$resultado.='
</tr>
<tr class="col-2">';
$tab='';
if(is_array($answer[$q][77])){
foreach($answer[$q][77] as $carac){
if(trim($carac)=='QUÍMICO NÃO CLASSIFICADO (MATERIA PRIMA)'){$tab='qnc';}
}
}
if($tab=='qnc'){
$resultado.='
<td colspan="3"><label>Embalagem</label><span>';
if(is_array($answer[$q][74])){foreach($answer[$q][74] as $emb){$resultado.=$emb.'<br>';}}
$resultado.='</span></td>
<td colspan="3"><label>Característica da Carga</label><span>';
if(is_array($answer[$q][77])){foreach($answer[$q][77] as $carac){$resultado.=$carac.'<br>';}}
$resultado.='</span></td>
<td colspan="3"><label>Químico Não Classificado</label><span>';
if(is_array($answer[$q][88])){foreach($answer[$q][88] as $quim => $qui){$resultado.=$quim.' ➔ '.Limpa($qui).'<br>';}}
$resultado.='</span></td>';
}else{
$resultado.='
<td colspan="5"><label>Embalagem</label><span>';
if(is_array($answer[$q][74])){foreach($answer[$q][74] as $emb){$resultado.=$emb.'<br>';}}
$resultado.='</span></td>
<td colspan="4"><label>Característica da Carga</label><span>';
if(is_array($answer[$q][77])){foreach($answer[$q][77] as $carac){$resultado.=$carac.'<br>';}}
$resultado.='</span></td>';
}
$resultado.='
</tr>
<tr class="col-2">
<td colspan="9"><label>Direcionamento Interno:</label><span>'.$answer[$q][99].'</span></td>
</tr>';
}
if($n9[$q]>=1){
$resultado.='
<tr class="col-2">
<td colspan="3"> </td>
<td style="width:10%" colspan="3">
<button class="btn btn-primary" data-toggle="modal" data-target="#largeModal-'.$q.'">Mostrar Fotos da Movimentação</button>
</td>
<td colspan="3"> </td>
</tr>';
}
$resultado.='
</table>
<div class="modal fade" id="largeModal-'.$q.'" tabindex="-1" role="dialog" aria-labelledby="basicModal" aria-hidden="true">
<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-body">
<!-- carousel -->
<div id="carouselIndicators'.$q.'"class="carousel slide"data-ride="carousel">
<div class="carousel-inner">';
for ($i=1;$i<=$n9[$q];$i++){
$resultado.='
<div class="carousel-item'.$ativo[$q][$i].'">
<img class="img-size" src="'.$foto[$q][$i].'"/>
<div class="carousel-caption">
<h4 style="background-color:#81BEF7;color:black;border-radius: 10px;border: solid;border-width: 1px;opacity:0.5;">'.$titulo[$q][$i].'</h4>
</div>
</div>';
}
$resultado.='
</div>
<a class="carousel-control-prev"href="#carouselIndicators'.$q.'"role="button"data-slide="prev">
<span class="carousel-control-prev-icon"aria-hidden="true"></span>
<span class="sr-only">Previous</span>
</a>
<a class="carousel-control-next"href="#carouselIndicators'.$q.'"role="button"data-slide="next">
<span class="carousel-control-next-icon"aria-hidden="true"></span>
<span class="sr-only">Next</span>
</a>
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-primary" data-dismiss="modal">Fechar</button>
</div>
</div>
</div>
</div>
</div>';
}
$resultado.='
</table>';
$resultado.='
</div>';
echo $resultado;
}
else{
echo'<script language="JavaScript">alert("Etiqueta NÃO está na Base de Dados!");location.href="index.php";</script>';
}
?>