-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathrelatorio.php
87 lines (80 loc) · 3.38 KB
/
relatorio.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
<html>
<head>
<link rel="stylesheet" type="text/css" href="assets/css/css.css">
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css"
integrity="sha384-MCw98/SFnGE8fJT3GXwEOngsV7Zt27NXFoaoApmYm81iuXoPkFOJwJ8ERdknLPMO" crossorigin="anonymous">
<title></title>
<script src="https://code.jquery.com/jquery-3.3.1.slim.min.js"
integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo"
crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.3/umd/popper.min.js"
integrity="sha384-ZMP7rVo3mIykV+2+9J3UJ46jBk0WLaUAdn689aCwoqbBJiSnjAK/l8WvCWPIPm49"
crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/js/bootstrap.min.js"
integrity="sha384-ChfqqxuZUCnJSK3+MXmPNIyE6ZbWh2IMqE241rYiqJxyMiZ6OW/JmZQ5stwEULTy"
crossorigin="anonymous"></script>
<script src="assets/js/homeUser.js"></script>
<title>Relatorio</title>
</head>
<?php
require('navbar.php');
function lista_chamado($sql){
if($sql == null){
$sql = "SELECT * FROM chamado";
}
$conexao = conectar();
$select = executar_SQL($conexao, $sql);
if(verifica_resultado($select)>0){
foreach ($select as $res) {
$res['status_id'] = getById("status",$res['status_id']);
echo '<tr>';
echo '<td class="col-md-3">'.$res['id'].'</td>';
echo '<td class="col-md-6" style="word-break: break-word;">'.$res['descricao'].'</td>';
echo '<td class="col-md-3">'.$res['status_id']['descricao'].'</td></tr>';
}
}else {
echo "Não existem registros";
}
}
?>
<body>
<form class="mb-0" style="position: fixed; top: 56px; width: 100%;" action="relatorio.php" method="post">
<div class="input-group">
<select class="custom-select" id="status" name="status" required>
<?php
getStatusOrTipo("status");
?>
</select>
<select class="custom-select" id="tipo" name="tipo" required>
<?php
getStatusOrTipo("tipo");
?>
</select>
<input class="form-control" type="date" id="data_inicio" name="data_inicio" required>
<input class="form-control" type="date" id="data_fim" name="data_fim" required>
<div class="input-group-append">
<button class="btn-info" type="submit"> Pesquisar</button>
</div>
</div>
</form>
<table class="table" style="table-layout: fixed;position: fixed; table-layout: fixed;top: 14%;">
<tr class="thead-dark">
<th style="width: 100px;">Chamado</th>
<th>Descricao</th>
<th style="width: 200px;">Status</th>
</tr>
<?php
if($_SERVER["REQUEST_METHOD"] == "POST"){
$status = $_POST["status"];
$tipo = $_POST["tipo"];
$inicio = $_POST["data_inicio"];
$final = $_POST["data_fim"];
$sql = "SELECT * FROM chamado WHERE status_id LIKE $status AND tipo_id LIKE $tipo and data_abertura >= '$inicio' AND data_abertura <= '$final'";
$conexao = conectar();
lista_chamado($sql,$conexao);
} else {
lista_chamado(null);
} ?>
</table>
</body>
</html>