templates/mapa_pendencias.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Prato aberto</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
<link href="//maxcdn.bootstrapcdn.com/font-awesome/4.1.0/css/font-awesome.min.css" rel="stylesheet">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
<script type="text/javascript" src="https://code.jquery.com/jquery-1.11.3.min.js"></script>
<script type="text/javascript"
src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.4.1/js/bootstrap-datepicker.min.js"></script>
<link rel="stylesheet"
href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.4.1/css/bootstrap-datepicker3.css" />
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
<style>
.row.tbl {
padding-top: 40px;
}
.container {
width: 80%;
}
/* Objetos da tabela */
.row {
margin-top: 20px;
margin-bottom: 20px;
padding: 0 10px;
}
.clickable {
cursor: pointer;
}
.panel-heading div {
margin-top: -18px;
font-size: 15px;
}
.panel-heading div span {
margin-left: 5px;
}
.panel-body {
display: none;
}
.table-responsive {
height: 450px;
overflow-y: auto;
overflow-x: auto;
}
.table>tbody>tr>td,
.table>tfoot>tr>td {
vertical-align: inherit;
}
.navbar-nav {
margin-top: 8px;
}
.col-sm-3 {
padding-top: 6px;
padding-left: 0px;
}
</style>
</head>
<body>
<div class="container">
<!-- NAVBAR -->
<div class="row" style="padding-top: 20px;">
<nav class="navbar navbar-default">
<div class="container-fluid">
<!-- Brand and toggle get grouped for better mobile display -->
<div class="navbar-header">
<a class="navbar-brand" href="#">Prato Aberto - Mapa Pendências</a>
</div>
<div class="collapse navbar-collapse">
<ul class="nav navbar-nav navbar-right">
<a type="button" class="btn btn-default " href="{{ referrer }}">
<span class="glyphicon glyphicon-chevron-left"></span> VOLTAR PARA CARDÁPIOS
</a>
</ul>
</div>
</div>
</nav>
</div>
<!-- Campos GERAÇAO TABELA -->
<div class="panel panel-default">
<div class="row">
<form method="post" action="/editor/mapa_pendencias">
<div class="col-sm-3" style="width: 9%; padding-top: 13px; padding-left: 20px;">
<label for="data-inicial">Data Inicial:</label>
</div>
<div class="col-sm-3" style="width: 17%">
<input type="text" id="data-inicial" name="data-inicial" value="Date" class="form-control">
</div>
<div class="col-sm-3" style="width: 7%; padding-top: 13px;">
<label for="data-final">Data Final:</label>
</div>
<div class="col-sm-3" style="width: 17%">
<input type="text" id="data-final" name="data-final" value="Date" class="form-control">
</div>
<div class="col-sm-3 dropdown" style="width: 11%">
<select class="form-control input" id="filtro" name="filtro">
<option>STATUS</option>
<option>PUBLICADO</option>
<option>PENDENTE</option>
<option>DELETADO</option>
</select>
</div>
<div class="col-sm-3" style="width: 15%">
<button type="submit" class="btn btn-success">OBTER STATUS</button>
</div>
</form>
</div>
</div>
<div class="row tbl">
<div class="panel panel-success">
<div class="panel-heading">
<h3 class="panel-title">Mapa Pendências</h3>
<div class="pull-right">
<span class="clickable filter" data-toggle="tooltip" title="Toggle table filter"
data-container="body">
<i class="glyphicon glyphicon-filter"></i>
</span>
</div>
</div>
<div class="panel-body">
<input type="text" class="form-control" id="task-table-filter" data-action="filter"
data-filters="#task-table" placeholder="Filter Tasks" />
</div>
<div class="table-responsive">
<div class="panel panel-default">
<table class="table table-hover table-striped" id="task-table">
<thead>
<tr>
<th onclick="w3.sortHTML('#task-table', '.item', 'td:nth-child(1)')"
style="cursor:pointer">ATENDIMENTO <i class="fa fa-sort" aria-hidden="true"></i>
</th>
<th onclick="w3.sortHTML('#task-table', '.item', 'td:nth-child(2)')"
style="cursor:pointer">UNIDADE <i class="fa fa-sort" aria-hidden="true"></i>
</th>
<th onclick="w3.sortHTML('#task-table', '.item', 'td:nth-child(3)')"
style="cursor:pointer">AGRUPAMENTO <i class="fa fa-sort" aria-hidden="true"></i>
</th>
<th onclick="w3.sortHTML('#task-table', '.item', 'td:nth-child(4)')"
style="cursor:pointer">STATUS <i class="fa fa-sort" aria-hidden="true"></i></th>
<th onclick="w3.sortHTML('#task-table', '.item', 'td:nth-child(5)')"
style="cursor:pointer">IDADE <i class="fa fa-sort" aria-hidden="true"></i></th>
<th onclick="w3.sortHTML('#task-table', '.item', 'td:nth-child(6)')"
style="cursor:pointer">DATA INICIAL <i class="fa fa-sort"
aria-hidden="true"></i></th>
<th onclick="w3.sortHTML('#task-table', '.item', 'td:nth-child(7)')"
style="cursor:pointer">DATA FINAL <i class="fa fa-sort" aria-hidden="true"></i>
</th>
<th onclick="w3.sortHTML('#task-table', '.item', 'td:nth-child(8)')"
style="cursor:pointer">STATUS <i class="fa fa-sort" aria-hidden="true"></i></th>
</tr>
</thead>
<tbody>
{% for linha in publicados: %}
<tr class="item">
<td class="tipo_atendimento">{{ linha['tipo_atendimento'] }}</td>
<td class="tipo_unidade">{{ linha['tipo_unidade'] }}</td>
<td class="agrupamento">{{ linha['agrupamento'] }}</td>
<td class="status">{{ linha['status'] }}</td>
<td class="idade">{{ linha['idade'] }}</td>
<td class="data_inicial">{{ linha['data_inicial'] }}</td>
<td class="data_final">{{ linha['data_final'] }}</td>
<td class="status_publicacao">{{ linha['status_publicacao'] }}</td>
</tr>
{% endfor %}
</tbody>
</table>
</div>
</div>
</div>
</div>
<footer class="container-fluid text-center">
<br>
<p><a href="http://pratoaberto.sme.prefeitura.sp.gov.br/"
title="Projeto Prato Aberto">http://pratoaberto.sme.prefeitura.sp.gov.br/</a></p>
</footer>
</div>
<!-- Script com a funcionalidade do filtro da tabela -->
<script>
/**
* I don't recommend using this plugin on large tables, I just wrote it to make the demo useable. It will work fine for smaller tables
* but will likely encounter performance issues on larger tables.
*
* <input type="text" class="form-control" id="dev-table-filter" data-action="filter" data-filters="#dev-table" placeholder="Filter Developers" />
* $(input-element).filterTable()
*
* The important attributes are 'data-action="filter"' and 'data-filters="#table-selector"'
*/
(function () {
'use strict';
var $ = jQuery;
$.fn.extend({
filterTable: function () {
return this.each(function () {
$(this).on('keyup', function (e) {
$('.filterTable_no_results').remove();
var $this = $(this),
search = $this.val().toLowerCase(),
target = $this.attr('data-filters'),
$target = $(target),
$rows = $target.find('tbody tr');
if (search == '') {
$rows.show();
} else {
$rows.each(function () {
var $this = $(this);
$this.text().toLowerCase().indexOf(search) === -1 ? $this.hide() : $this.show();
})
if ($target.find('tbody tr:visible').size() === 0) {
var col_count = $target.find('tr').first().find('td').size();
var no_results = $('<tr class="filterTable_no_results"><td colspan="' + col_count + '">No results found</td></tr>')
$target.find('tbody').append(no_results);
}
}
});
});
}
});
$('[data-action="filter"]').filterTable();
})(jQuery);
$(function () {
// attach table filter plugin to inputs
$('[data-action="filter"]').filterTable();
$('.container').on('click', '.panel-heading span.filter', function (e) {
var $this = $(this),
$panel = $this.parents('.panel');
$panel.find('.panel-body').slideToggle();
if ($this.css('display') != 'none') {
$panel.find('.panel-body input').focus();
}
});
$('[data-toggle="tooltip"]').tooltip();
});
</script>
<!-- Botões de ordenação da tabela -->
<script src="/editor/static/js/w3.js"></script>
<!-- Deleta linha da tabela -->
<script>
function deleteRow(r) {
var i = r.parentNode.parentNode.rowIndex;
document.getElementById("task-table").deleteRow(i);
}
</script>
<!-- Seta Datas -->
<!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
<!-- Referência do arquivo JS do plugin após carregar o jquery -->
<!-- Datepicker -->
<script src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.7.1/js/bootstrap-datepicker.js"></script>
<!-- Include all compiled plugins (below), or include individual files as needed -->
<script src="//maxcdn.bootstrapcdn.com/bootstrap/3.2.0/js/bootstrap.min.js"></script>
<!--Data Picker Inicial-->
<script>
$(document).ready(function () {
$('#data-inicial').datepicker({
format: "dd/mm/yyyy",
language: "pt-BR"
});
});
</script>
<!--Data Picker Final-->
<script>
$(document).ready(function () {
$('#data-final').datepicker({
format: "dd/mm/yyyy",
language: "pt-BR"
});
});
</script>
<!-- Seta Refeições -->
<script>
function adicionaRefeicao() {
var REFEICAO = document.getElementById("REFEICAO").value;
$('#lista-refeicao').append(
"<span type='button' class='btn btn-default' onclick='deletar(this)' style='margin-right: 8px' id=" + REFEICAO + ">" + REFEICAO + " ×</span>"
);
};
</script>
<!-- Deleta botões -->
<script>
function deletar(r) {
$(r).remove()
};
</script>
<!-- Atualiza dropdown -->
<script>
$("#dropdown-status li a").click(function () {
$("#dropdown-name").html($(this).text() + ' <span class="caret"></span>');
$("#dropdown-name").html($(this).text() + ' <span class="caret"></span>');
});
</script>
</body>
</html>