} } $campos = array('id' => 'id', 'nome_guerra' => 'Nome', 'email' => 'Email'); } ?> <div class="container"> <!-- Main component for a primary marketing message or call to action --> <div class="table-responsive"> <div class="panel panel-default"> <div class="panel-heading"> <div class="col-lg-11"> <h4>Lista de Usuários</h4> </div> <a class="btn btn-primary" href="new.php"><span class="glyphicon glyphicon-plus text-bold" aria-hidden="true"></span> Novo</a> </div> <div class="panel-body"> <?php $faxada->gerarGrid(MYSQL_BASE_USUARIOS, $campos, $where, 1, NULL); ?> </div> </div> </div> </div> <?php include_once '../footer.php';
if (!empty($_GET['q'])) { $q = str_replace(" ", "|", $_GET['q']); $where .= " AND (\n\t\t\t\t\tcod_contrato REGEXP '" . $q . "' OR\n\t\t\t\t\tdescricao REGEXP '" . $q . "' OR\n\t\t\t\t\ttrecho REGEXP '" . $q . "')"; } ?> <div class="container"> <!-- Main component for a primary marketing message or call to action --> <div class="table-responsive"> <div class="panel panel-default"> <div class="panel-heading"> <div class="col-lg-11"> <h4>Listagem de Obras</h4> </div> <a class="btn btn-primary" href="new.php"><span class="glyphicon glyphicon-plus text-bold" aria-hidden="true"></span> Novo</a> </div> <div class="panel-body"> <?php $faxada->gerarGrid(MYSQL_BASE_CONTRATO, $campos, $where, 1); ?> </div> </div> </div> </div> <?php include_once '../footer.php';
if (!empty($_GET['q'])) { $q = str_replace(" ", "|", $_GET['q']); $where .= " AND (\r\n\t\t\t\t\trazao_social REGEXP '" . $q . "' OR\r\n\t\t\t\t\ttelefone REGEXP\t'" . $q . "' OR\r\n\t\t\t\t\temail REGEXP '" . $q . "' OR\r\n\t\t\t\t\tcnpj REGEXP '" . $q . "')"; } ?> <div class="container"> <!-- Main component for a primary marketing message or call to action --> <div class="table-responsive"> <div class="panel panel-default"> <div class="panel-heading"> <div class="col-lg-11"> <h4>Lista de Fornecedores</h4> </div> <a class="btn btn-primary" href="new.php"><span class="glyphicon glyphicon-plus text-bold" aria-hidden="true"></span> Novo</a> </div> <div class="panel-body"> <?php $faxada->gerarGrid(MYSQL_BASE_FORNECEDORES, $campos, $where, 1); ?> </div> </div> </div> </div> <?php include_once '../footer.php';
if (!empty($_GET['q'])) { $q = str_replace(" ", "|", $_GET['q']); $where .= " AND (\r\n\t\t\t\t\tnome_completo REGEXP '" . $q . "' OR\r\n\t\t\t\t\trg REGEXP '" . $q . "' OR\r\n\t\t\t\t\ttel_1 REGEXP '" . $q . "' OR\r\n\t\t\t\t\ttel_2 REGEXP '" . $q . "' OR\r\n\t\t\t\t\ttel_3 REGEXP '" . $q . "' OR\r\n\t\t\t\t\tendereco REGEXP '" . $q . "' OR\r\n\t\t\t\t\tcpf REGEXP '" . $q . "')"; } ?> <div class="container"> <!-- Main component for a primary marketing message or call to action --> <div class="table-responsive"> <div class="panel panel-default"> <div class="panel-heading"> <div class="col-lg-11"> <h4>Listagem de Relatórios</h4> </div> <a class="btn btn-primary" href="new.php"><span class="glyphicon glyphicon-plus text-bold" aria-hidden="true"></span> Novo</a> </div> <div class="panel-body"> <?php $faxada->gerarGrid($tabela, $campos, $where, 1); ?> </div> </div> </div> </div> <?php include_once '../footer.php';
if (!empty($_GET['q'])) { $q = str_replace(" ", "|", $_GET['q']); $where .= " AND (\n\t\t\t\t\tcod_contrato REGEXP '" . $q . "' OR\n\t\t\t\t\tdescricao REGEXP '" . $q . "' OR\n\t\t\t\t\ttrecho REGEXP '" . $q . "')"; } ?> <div class="container"> <!-- Main component for a primary marketing message or call to action --> <div class="table-responsive"> <div class="panel panel-default"> <div class="panel-heading"> <div class="col-lg-11"> <h4>Listagem de Disciplina - Status</h4> </div> <a class="btn btn-primary" href="new.php"><span class="glyphicon glyphicon-plus text-bold" aria-hidden="true"></span> Novo</a> </div> <div class="panel-body"> <?php $faxada->gerarGrid(MYSQL_BASE_DISCIPLINA_STATUS, $campos, $where, 1); ?> </div> </div> </div> </div> <?php include_once '../footer.php';
} ?> </select> </div> <div class="form-group"> <label for="exampleInputEmail1">Quantidade</label> <input type="text" class="form-control" id="exampleInputEmail1" placeholder="Quantidade" name="quantidade" required="required"> </div> <input type="hidden" name="cmd" value="editar"> <input type="hidden" name="id" value="<?php echo $_GET['id']; ?> "> <button type="submit" class="btn btn-primary">Salvar</button> </form> </div> <div class="panel-body"> teste <?php $faxada->gerarGrid($tabela, $campos, $where_busca, 1, NULL); ?> </div> </div> </div> </div> <?php include_once '../footer.php';
} else { $tabela = MYSQL_BASE_PAGAMENTOS . " P\r\n\t\t\t INNER JOIN " . MYSQL_BASE_CONTRATOS . " \tC ON P.id_contrato = C.id\r\n\t\t\t INNER JOIN " . MYSQL_BASE_DESPESAS . " \tD ON D.id = C.id_despesa"; $campos = array('P.id' => 'id', 'P.valor' => 'Valor', "DATE_FORMAT(P.data_pagamento, '%d/%m/%Y')" => 'Data de Pagamento', 'C.estabelecimento' => 'Estabelecimento', 'D.nome' => 'Despesa'); } ?> <div class="container"> <!-- Main component for a primary marketing message or call to action --> <div class="table-responsive"> <div class="panel panel-default"> <div class="panel-heading"> <div class="col-lg-11"> <h4>Lista de Pagamento</h4> </div> <a class="btn btn-primary" href="new.php"><span class="glyphicon glyphicon-plus text-bold" aria-hidden="true"></span> Novo</a> </div> <div class="panel-body"> <?php $faxada->gerarGrid($tabela, $campos, 'C.excluido IS NULL', 1); ?> </div> </div> </div> </div> <?php include_once '../footer.php';
if (!empty($_GET['q'])) { $q = str_replace(" ", "|", $_GET['q']); $where .= " AND (\n\t\t\t\t\tcod_contrato REGEXP '" . $q . "' OR\n\t\t\t\t\tdescricao REGEXP '" . $q . "' OR\n\t\t\t\t\ttrecho REGEXP '" . $q . "')"; } ?> <div class="container"> <!-- Main component for a primary marketing message or call to action --> <div class="table-responsive"> <div class="panel panel-default"> <div class="panel-heading"> <div class="col-lg-11"> <h4>Listagem de Grupo de Acesso</h4> </div> <a class="btn btn-primary" href="new.php"><span class="glyphicon glyphicon-plus text-bold" aria-hidden="true"></span> Novo</a> </div> <div class="panel-body"> <?php $faxada->gerarGrid(MYSQL_BASE_GRUPO, $campos, $where, 1); ?> </div> </div> </div> </div> <?php include_once '../footer.php';
if (!empty($_GET['q'])) { $q = str_replace(" ", "|", $_GET['q']); $where .= " AND (\n\t\t\t\t\tcod_contrato REGEXP '" . $q . "' OR\n\t\t\t\t\tdescricao REGEXP '" . $q . "' OR\n\t\t\t\t\ttrecho REGEXP '" . $q . "')"; } ?> <div class="container"> <!-- Main component for a primary marketing message or call to action --> <div class="table-responsive"> <div class="panel panel-default"> <div class="panel-heading"> <div class="col-lg-11"> <h4>Listagem de Funcionalidade</h4> </div> <a class="btn btn-primary" href="new.php"><span class="glyphicon glyphicon-plus text-bold" aria-hidden="true"></span> Novo</a> </div> <div class="panel-body"> <?php $faxada->gerarGrid(MYSQL_BASE_FUNCIONALIDADE, $campos, $where, 1); ?> </div> </div> </div> </div> <?php include_once '../footer.php';
$faxada->deletar(MYSQL_BASE_ENTREGA_PRODUTOS, limpaTexto($_GET['id'])); } else { $campos = array('id' => 'id', 'nome_completo' => 'Nome', 'matricula' => 'Matrícula'); $acao = array('liberacao.php?id=' => 'Entregar Material'); $where = "excluido IS NULL"; if (!empty($_GET['q'])) { $q = str_replace(" ", "|", $_GET['q']); $where .= " AND (\r\n\t\t\t\t\tnome_completo REGEXP '" . $q . "' OR\r\n\t\t\t\t\tmatricula REGEXP\t'" . $q . "')"; } } ?> <div class="container"> <!-- Main component for a primary marketing message or call to action --> <div class="table-responsive"> <div class="panel panel-default"> <div class="panel-heading"> <h4>Entra de Materia</h4> </div> <div class="panel-body"> <?php $faxada->gerarGrid(MYSQL_BASE_FUNCIONARIOS, $campos, $where, 1, $acao); ?> </div> </div> </div> </div> <?php include_once '../footer.php';
if (!empty($_GET['q'])) { $q = str_replace(" ", "|", $_GET['q']); $where .= " AND (\r\n\t\t\t\t\tnome REGEXP '" . $q . "')"; } ?> <div class="container"> <!-- Main component for a primary marketing message or call to action --> <div class="table-responsive"> <div class="panel panel-default"> <div class="panel-heading"> <div class="col-lg-11"> <h4>Lista de Unidades</h4> </div> <a class="btn btn-primary" href="new.php"><span class="glyphicon glyphicon-plus text-bold" aria-hidden="true"></span> Novo</a> </div> <div class="panel-body"> <?php $faxada->gerarGrid(MYSQL_BASE_UNIDADE, $campos, $where, 1); ?> </div> </div> </div> </div> <?php include_once '../footer.php';