Exemplos de Faxada::gerarGrid em PHP

Exemplo n.º 1

Arquivo: index.php Projeto: hexti/monitoramento

        }
    }
    $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';

Exemplo n.º 2

Arquivo: index.php Projeto: hexti/monitoramento

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';

Exemplo n.º 3

Arquivo: index.php Projeto: hexti/tocksys

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';

Exemplo n.º 4

Arquivo: index.php Projeto: hexti/adv

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';

Exemplo n.º 5

Arquivo: index.php Projeto: hexti/monitoramento

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';

Exemplo n.º 6

Arquivo: liberacao.php Projeto: hexti/tocksys

}
?>
						</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';

Exemplo n.º 7

Arquivo: index.php Projeto: hexti/casamento

} 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';

Exemplo n.º 8

Arquivo: index.php Projeto: hexti/monitoramento

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';

Exemplo n.º 9

Arquivo: index.php Projeto: hexti/monitoramento

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';

Exemplo n.º 10

Arquivo: index.php Projeto: hexti/tocksys

    $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';

Exemplo n.º 11

Arquivo: index.php Projeto: hexti/tocksys

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';