Path: C:\
<!DOCTYPE html>
<html lang="pt-br">
<head>
<meta charset="utf-8" />
<meta http-equiv="x-ua-compatible" content="ie=edge" />
<meta name="viewport" content="width=device-width, initial-scale=1, minimum-scale=1, maximum-scale=1" />
<title>Projeto Dashboard</title>
<link href="imagens/favicon.ico" rel="icon" type="image/png" >
<link href="css/style.css" rel="stylesheet" type="text/css" />
<script src='../js/jquery-2.1.3.min.js'></script>
</head>
<script type="text/javascript">
function historico(url){
window.open(url,'Hist','toolbar=no,location=no,directories=no, status=no, menubar=no, scrollbars=no, resizable=no, width=700, height=300, top=150, left=150');
}
</script>
<style>
tr#linha:hover {
background: yellow;
}
</style>
<?php
if (isset($_GET['arquivo'])) {$arqxlsx=$_GET['arquivo'];}else{$arqxlsx='';}
date_default_timezone_set('America/Sao_Paulo');
$dateadded = date("Ymd");
$lin=0;
$lines = file('projeto1.csv');
$linha = array();
$lin=count($lines);
for($i=0;$i<$lin;$i++)
{$linha[] = explode(';',trim($lines[$i]));}
$ant=$linha[1][11];$start[$ant]=1;$bg1=0;
?>
<body>
<table align="center" width="100%" cellpadding="0" border="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td align="center" width="100%"><img src="imagens/logo.png" width="100%" height="85" border="0" />
</td>
</tr>
</table>
<table class='blue'width="100%" align="center" cellpadding="1" cellspacing="1" bgcolor="#F3F3F3">
<col width="14%" />
<col width="14%" />
<col width="8%" />
<col width="5%" />
<col width="6%" />
<col width="7%" />
<col width="4%" />
<col width="5%" />
<col width="25%" />
<col width="7%" />
<col width="5%" />
<thead>
<tr height="31" >
<th align="center"><b>REMETENTE</b></th>
<th align="center"><b>DESTINATÁRIO</b></th>
<th align="center"><b>CIDADE DESTINO</b></th>
<th align="center"><b>PEDIDO</b></th>
<th align="center"><b>MANIFESTO</b></th>
<th align="center"><b>TIPO</b></th>
<th align="center"><b>CTe</b></th>
<th align="center"><b>N. F.</b></th>
<th align="center"><b>STATUS ATUAL</b></th>
<th align="center"><b>DATA</b></th>
<th align="center"><b>HORA</b></th>
</tr>
</thead>
<tbody>
<?php
for ($q=1; $q < $lin; $q++)
{ if ($linha[$q][11]<>$ant)
{ $start[$linha[$q][11]]=$q;
$stop[$ant]=$q-1;
$ant=$linha[$q][11];
if ($bg1 == 1) { $bg="#BDBDBD";$bg1=0;} else {$bg="#ffffff";$bg1=1;}
?>
<tr id='linha' bgcolor="<?php echo $bg;?>" >
<td align="left"><?php echo $linha[$q-1][2];?></td>
<td align="left"><?php echo $linha[$q-1][3];?></td>
<td align="left"><?php echo $linha[$q-1][4];?></td>
<td align="center"><?php echo $linha[$q-1][5];?></td>
<td align="center"><?php echo $linha[$q-1][8];?></td>
<td align="center"><?php echo $linha[$q-1][7];?></td>
<td align="center"><?php echo $linha[$q-1][10];?></td>
<td align="center"><a href="javascript:historico('projeto_dashboard04.php?start=<?php echo $start[$linha[$q-1][11]];?>&stop=<?php echo $stop[$linha[$q-1][11]];?>&arquivo=<?php echo $arqxlsx;?>')"><?php echo $linha[$q-1][11];?></a></td>
<td align="left"><?php echo $linha[$q-1][12];?></td>
<td align="center"><?php echo $linha[$q-1][13];?></td>
<td align="center"><?php echo $linha[$q-1][14];?></td>
</tr>
<?php
}
}
?>
</tbody>
</table>
<table>
<tr>
<td align="center" valign="middle" width="40%" >
<form method='GET' action='index.php'>
<div class='col-md-2' align='center' >
<button type='submit' class='btn btn-success'>Voltar</button>
</div>
</form>
</td>
<td align="center" valign="middle" width="40%" >
<form method='GET' action='index.php'>
<div class='col-md-2' align='center' >
<input id='arquivo' name='arquivo' type='hidden' value='<?php echo $arqxlsx;?>' />
<button type='submit' class='btn btn-success'>Baixar EXCEL</button>
</div>
</form>
</td>
</tr>
</table>
</body>
<p class="copyright" align="center">© Copyright 2018 TransWar - Todos os direitos reservados.</p> <br />
</html>