Path: C:\
<?php
date_default_timezone_set('America/Sao_Paulo');
$dateadded = date("d/m/Y -- G:i");
require_once("../conexao_srvtms.php");
$query="SELECT rtrim(a.[ds_Departamento]) as Departamento
FROM [dtbTransporte].[dbo].[tbdFuncionario] as a
left join [dtbTransporte].[dbo].tbdPessoa as b on a.id_RhFilialPadrao = b.id_Pessoa
where id_Status='1' and id_TipoContratacao='1' and b.ds_Pessoa is not null
and a.[nr_PIS] is not null and a.[nr_PIS] <> '' and ltrim(a.[hr_Saida]) <>':'
and (ltrim(b.ds_Pessoa)='TRANS WAR - CAMPINAS' or ltrim(b.ds_Pessoa)='TRANS RAW - CAMPINAS'
or ltrim(b.ds_Pessoa)='TRANS WAR - OSASCO' or ltrim(b.ds_Pessoa)='TRANS RAW - OSASCO')
group by a.[ds_Departamento]";
$consulta = sqlsrv_query($conn, $query, array(), array("Scrollable"=>"buffered"));
$td=0;
if( $consulta === false )
{ if( ($errors = sqlsrv_errors() ) != null)
{
foreach( $errors as $error )
{
echo "SQLSTATE: ".$error[ 'SQLSTATE']."<br />";
echo "código: ".$error[ 'code']."<br />";
echo "mensagem: ".$error[ 'message']."<br />";
}
}
exit();
}
else
{ while($row=sqlsrv_fetch_array($consulta, SQLSRV_FETCH_ASSOC))
{ if ($row['Departamento']<>'')
{ $dep[$td]=trim($row['Departamento']);$td++;}
}
}
?>
<!DOCTYPE html>
<html lang='pt-br'>
<head>
<meta http-equiv='Refresh'>
<meta charset='utf-8'/>
<meta content='width=device-width, initial-scale=1, maximum-scale=1' name='viewport'>
<title>Controle de Presença</title>
<link rel="icon" type="image/png" href="../images/favicon.ico">
<link href="../css/estilo.css" rel="stylesheet" type="text/css" />
<link href='../css/redmond/jquery-ui-1.10.1.custom.css' rel='stylesheet' type='text/css'>
<link href="../css/bootstrap.min.css" rel="stylesheet">
<link href="../css/bootstrap-theme.min.css" rel="stylesheet">
<link href="../css/theme.css" rel="stylesheet">
<link href="../css/signin.css" rel="stylesheet">
<script src='../js/jquery-3.3.1.min.js'></script>
<script src='../js/jquery-ui.js' type='text/javascript'></script>
<script src="../js/ui.datepicker-pt-BR.js"></script>
<script src="../js/jquery.mask.js"></script>
</head>
<body role="document">
<div class="container">
<table width="100%">
<tr>
<td>
<img src="../images/logo03.png" width="408" height="88" />
</td>
<td>
<div class="page-header">
<h2>
<span class="label label-primary"> Controle de Presença </span>
</h2>
</div>
</td>
</tr>
<tr>
<td height="30" colspan="2" background="../images/top-menubg.gif" > <?php echo $dateadded; ?>
</td>
</tr>
</table>
<aside role="complementary" class="col-md-12">
<div class="row">
<div class="col-md-12" align="center">
<form id="form" name="form" method="post"action="iPonto06.php"enctype="multipart/form-data">
<div class="col-md-6" align="center">
<font size="4"><strong>Escolha a Empresa:</strong></font>
<select id="empresa" name="empresa" style="height: 30px; width: 300px;" class="form-control">
<option value="GERAL" selected>GERAL</option>
<option value="CAMPINAS">CAMPINAS</option>
<option value="OSASCO">OSASCO</option>
</select>
</div>
<div class="col-md-6" align="center">
<font size="4"><strong>Escolha o Departamento:</strong></font>
<select id="depart" name="depart" style="height: 30px; width: 300px;" class="form-control">
<option value="GERAL" selected>GERAL</option>
<?php
for ($i=0;$i<$td;$i++)
{
echo "<option value='".$dep[$i]."'>".$dep[$i]."</option>";
}
?>
</select>
</div>
<div class="col-md-12" align="center">
<input type="submit" name="Data" id="Data" class="button2" value="Visualizar" onclick='javascript:showCarga();'/>
</div>
</form>
<div class="col-md-12" align="center">
<font size="4"><strong>ou</strong></font>
</div>
<form method='GET' action='iPonto08.php'>
<div class="col-md-12" align="center">
<button type='submit' class='btn btn-primary'>Painel de Presença</button>
</div>
</form>
<form method='GET' action='index.php'>
<div class="col-md-12" align="center">
<button type='submit' class='btn btn-primary'>Voltar</button>
</div>
</form>
</div>
</div>
</aside>
</div>
</body>
<p class="copyright" align="center">© Copyright 2018 TransWar - Todos os direitos reservados. Versão 1.0</p>
<br />
<script src="../js/bootstrap.min.js"></script>
<script src="../js/ie10-viewport-bug-workaround.js"></script>
</html>