Path: C:\
<script type="text/Javascript">
function send(action)
{
switch(action) {
case 'apagar':
url = 'processa/proc_apaga_dow.php';
break;
case 'editar':
url = 'processa/proc_edit_dow.php';
break;
case 'incluir':
url = 'main.php?link=11';
break;
}
document.forms[0].action = url;
document.forms[0].submit();
}
</script>
<?php
$resultado=sqlsrv_query($conn3,"SELECT
Convert(varchar(16), dt_Incluido,106)+' às '+Convert(varchar(5), dt_Incluido,108) as diahora
,id_Arq as id
,ds_NomeArq as nomearq
,nr_Dow as nrdow
,id_Ver as ver
FROM dbo.tbdArqDow ORDER BY 'nomearq'", array(), array( "Scrollable" => SQLSRV_CURSOR_KEYSET ));
$linhas=sqlsrv_num_rows($resultado);
?>
<aside role="complementary" class="col-md-9" style="height:100%">
<div>
<h2>Lista de Arquivos para Download Controlado:</h2>
</div>
<div class="row" >
<div class="col-md-12" >
<table class="table">
<thead>
<tr>
<th class="col-md-5">Nome do Arquivo</th>
<th class="col-md-3" style="text-align:center">Dia/Hora</th>
<th class="col-md-1" style="text-align:center">nº Dow.</th>
<?php
if(($_SESSION['usuarioNivelAcesso'] == 0) || ($_SESSION['usuarioNivelAcesso'] == 4)) {
echo "<th class='col-md-1' style='text-align:center'>Ocultar</th>
<th class='col-md-1' style='text-align:center'>Apagar</th>
<th class='col-md-1' style='text-align:center'>Ação</th>";}?>
</tr>
</thead>
</table>
<form method="POST" action="">
<div style="width:100%; height: calc(60vh - 100px); overflow: auto">
<table class="table">
<tbody align="left">
<?php $n=1;
while($linhas = sqlsrv_fetch_array($resultado, SQLSRV_FETCH_ASSOC)){
$ver[$n] = $linhas ["ver"];
if ($ver[$n]=="N"){$checked="checked";}else{$checked="";}
$ver[$n] = $linhas ["id"];
if(($checked =="")||($_SESSION['usuarioNivelAcesso'] == 0) || ($_SESSION['usuarioNivelAcesso'] == 4)) {
echo "<tr>";
echo "<td class='col-md-5'><a href='baixando.php?id=".$linhas['id']."&usuario=".$id_usuario."' title='Clique para fazer o Download'>".$linhas['nomearq']."</a></td>";
echo "<td class='col-md-3' style='text-align:center'>".$linhas['diahora']."</td>";
echo "<td class='col-md-1' style='text-align:center'>".$linhas['nrdow']."</td>";
if(($_SESSION['usuarioNivelAcesso'] == 0) || ($_SESSION['usuarioNivelAcesso'] == 4)) {
echo "<td class='col-md-1' style='text-align:center'><input type='checkbox' name='ver[]' value=".$ver[$n]." ".$checked." /></td>";
echo "<td class='col-md-1' style='text-align:center'><input type='checkbox' name='del[]' value='".$linhas['id']."'></td>";
echo "<td class='col-md-2' style='text-align:center'>";
if ($linhas['nrdow'] >= 1){ $href="main.php?link=10&id=".$linhas['id']."&arq=".$linhas['nomearq']."'";}else {$href="";}
echo "<a href='".$href."'><button type='button' class='btn btn-xs btn-primary'>Histórico</button></a>";
}?>
</td><?php
echo "</tr>";}
$n++;} echo'</tbody></table></div>';
if(($_SESSION['usuarioNivelAcesso'] == 0) || ($_SESSION['usuarioNivelAcesso'] == 4)) {
echo'<div class="col-sm-4" align="center"><button type="submit" class="btn btn-danger" onclick="send(\'incluir\');">Incluir Arquivo</button></div>
<div class="col-sm-4" align="center"><button type="submit" class="btn btn-danger" onclick="send(\'editar\');">Atualizar</button></div></form>
<div class="col-sm-4" align="center"><button type="submit" class="btn btn-danger" onclick="send(\'apagar\');">Apagar Seleção</button></div>';}
?>
</form>
</div>
</div>
</aside>