Path: C:\
<?php
session_start();
date_default_timezone_set('America/Sao_Paulo');
$dateadded = date("d/m/Y -- G:i");
$host = "srvtms";
$db = "dtbtransporte";
$user = "sa";
$password = "13509";
$connectionOptions = array("Database" => $db, "UID" => $user, "PWD" => $password);
$conn = sqlsrv_connect( $host, $connectionOptions);
if (!$conn){echo "ATENÇÃO!! FALHA NA CONEXÃO BANCO DE DADOS!";}
unset($_SESSION['json'],
$_SESSION['coleta'],
$_SESSION['entrega'],
$_SESSION['entregaA'],
$_SESSION['entregaB'],
$_SESSION['json2'],
$_SESSION['link'],
$_SESSION['principal'],
$_SESSION['grupo'],
$_SESSION['dsgru'],
$_SESSION['empresa'],
$_SESSION['inicio'],
$_SESSION['final'],
$_SESSION['inicio2'],
$_SESSION['final2']);
$matriz = file_get_contents('upload/matriz.json');
$_SESSION['matriz'] = $matriz;
?>
<!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>Torre de Controle</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/jquery.mask.js"></script>
<script src="js/ui.datepicker-pt-BR.js"></script>
<script type="text/javascript">
$(document).ready(function() {
$('input:radio[name="forne"]').on("change", function() {
$('#grupo' ).val('nulo');
$('#dsgru' ).val('TODOS');
$('#fornecedor' ).val('nulo');
$("#grupo" ).attr('required','');
$("#termo_busca").attr('required','');
$("#fornecedor" ).attr('required','');
if (this.checked && this.value == '1') {
$("#gru" ).show();
$("#empresa" ).hide();
$("#fornecedor" ).removeAttr('required');
$("#termo_busca").removeAttr('required');
document.getElementById("op1" ).selected=true;
document.getElementById("op2" ).selected=false;
} if (this.checked && this.value == '2') {
$('#termo_busca').val('');
$("#empresa" ).show();
$("#gru" ).hide();
$("#grupo" ).removeAttr('required');
document.getElementById("op1" ).selected=false;
document.getElementById("op2" ).selected=true;
} if (this.checked && this.value == '9') {
$("#grupo" ).removeAttr('required');
$("#fornecedor" ).removeAttr('required');
$("#termo_busca" ).removeAttr('required');
$("#gru, #empresa").hide();
document.getElementById("op1" ).selected=false;
document.getElementById("op2" ).selected=false;
}
});
$(document).on('change', '#grupo', function () {
var value = $(this).val();
var option = $(this).find("option:selected");
var dsgru = option.text();
$('#grupo' ).val(value);
$('#dsgru' ).val(dsgru);
$('#fornecedor').val('nulo');
});
$(document).on('change', '#fornecedor', function () {
var value = $(this).val();
var option = $(this).find("option:selected");
var dsgru = option.text();
$('#grupo' ).val('nulo');
$('#dsgru' ).val(dsgru);
$('#fornecedor').val(value);
});
$('#termo_busca').keyup(function(){
$.ajax({
type: 'POST',
url: 'API10.php',
data: {nome: $("#termo_busca").val()},
success: function(data) {
$('#fornecedor').html(data);
}
});
});
});
</script>
<style>
#fornecedor, #grupo { width:70%;height:25px; }
</style>
</head>
<body role="document">
<div class="container">
<table width="100%">
<tr>
<td><img src="images/logo03.png" width="300" height="88"/></td>
<td>
<div class="page-header">
<h2><span class="label label-primary"> TORRE DE CONTROLE </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='panel panel-primary'>
<div class="col-md-12" align="center">
<form id="form" name="form" method="post"action="API00.php" enctype="multipart/form-data">
<div class="col-md-3" align="center">
<strong>Escolha:</strong>
<p>
<input type="radio" name="forne" value="9" required/>Todos<br>
<input type="radio" name="forne" value="1" required/>Grupo<br>
<input type="radio" name="forne" value="2" required/>Empresa<br>
</p>
</div>
<div class="col-md-9" id="gru" style="display:none;" align="left">
<select id="grupo" name="grupo" style="height: 30px;" class="form-control">
<option id="op1" value="" data-dsgru="">Selecione</option>
<?php
$tsql = "SELECT id_GrupoCliente, ds_GrupoCliente FROM tbdGrupoCliente where id_GrupoCliente>3 ORDER BY id_GrupoCliente ASC";
$row2= sqlsrv_query($conn, $tsql);
while ($row = sqlsrv_fetch_array($row2, SQLSRV_FETCH_ASSOC)) { $ds_gru=$row [ "ds_GrupoCliente" ];
echo "<option value=".$row [ "id_GrupoCliente" ]." data-dsgru=".$ds_gru." >".$ds_gru."</option>";
}
?>
</select>
</div>
<div class="col-md-9" id="empresa" style="display:none;" align="left">
Empresa: <input type="text" id="termo_busca" name="termo_busca"><br>
<select id="fornecedor" name="fornecedor" onclick="if( $('#fornecedor').html() == '' ){ alert('Sem resultados carregados.\n Faça uma busca digitando o nome de uma empresa.');}">
</select>
</div>
<div class="col-md-12">
<div class="col-md-5"></div>
<div class="col-md-2" align="center">
<br>
<input id='dsgru' readonly="true" name='dsgru' type='hidden'/>
<button class="btn btn-lg btn-primary btn-block" type="submit" width="50%">Acessar</button>
</div>
<div class="col-md-5"></div>
</div>
</form>
</div>
</div>
</aside>
</div>
</body>
<script src="js/jquery.min.js"></script>
<script src="js/bootstrap.min.js"></script>
<script src="js/jquery-1.9.1.js" type="text/javascript"></script>
<script src="js/jquery-ui.js" type="text/javascript"></script>
</html>