PHP CheckListDAO::listar Examples

Programming Language: PHP

Class/Type: CheckListDAO

Method/Function: listar

Examples at hotexamples.com: 5

PHP CheckListDAO::listar - 5 examples found. These are the top rated real world PHP examples of CheckListDAO::listar extracted from open source projects. You can rate examples to help us improve the quality of examples.

Frequently Used Methods

Show Hide

Listar(13)

listar(5)

Autorizar(2)

Gravar(2)

AtualizarEdit(1)

AtualizarProjetoCad(1)

AtualizarRemessaArquivo(1)

AtualizarCodigoGrd(1)

Deletar(1)

AtualizaStatus(1)

GravarAnexo(1)

GravarProjetoCad(1)

GravarProjetoCadTerceirizado(1)

AtualizarCodificacao(1)

ListarRemessa(1)

Obsoleto(1)

VoltarParaVerificacao(1)

AtualizaCheckList(1)

Example #1

Show file

File: obsoleto.php Project: hexti/troncal

						  <thead>
							  <tr>
								  <th style="display:none">Ordem</th>
								  <th nowrap>C&oacute;digo</th>
								  <th nowrap>Analisado</th>
								  <th nowrap>Nome</th>
								  <th nowrap>Disciplina</th>
								  <th nowrap>Fase do Projeto</th>
								  <th nowrap>Obra</th>
								  <th nowrap>Lista</th>
								  <th nowrap>A&ccedil;&atilde;o</th>
							  </tr>
						  </thead>   
						  <tbody>
							<?php 
$retorno = $DAO->listar("SELECT \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tA.id, \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tA.aprovado,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tA.nome_arquivo,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tD.nome as disciplina,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tE.nome as fase,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tF.nome as obra\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tFROM " . MYSQL_BASE_CHECK_LISTS . " A\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_PROJETOS . " B \t\tON A.id = B.id_check_list\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_DISCIPLINAS . " D\t\tON A.id_disciplina = D.id\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_FASE_PROJETOS . " E\tON E.id = A.id_fase_projeto\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_PROJETO_OBRA . " F\tON F.id = A.id_obra_codigo\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tA.status ='O'\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tORDER BY A.id DESC");
$ordem = 0;
foreach ($retorno as $item) {
    $nome_arquivo = explode(".", $item['nome_arquivo']);
    $visualizar = ' <a data-rel="tooltip" title="Imprimir AC" class="btn btn-success" target="_blank" href="../checklists/print.php?id=' . $item['id'] . '"><i class="icon-print icon-white"></i></a>';
    $query2 = mysql_query("SELECT id_remessa_lista FROM " . MYSQL_BASE_REMESSA_ARQUIVOS . " WHERE file LIKE '%" . $item['nome_arquivo'] . "' AND excluido IS NULL LIMIT 1");
    $lista = "";
    while ($row = mysql_fetch_array($query2)) {
        $lista = $row['id_remessa_lista'];
    }
    echo '<tr>';
    echo '	<td style="display:none">' . $ordem . '</td>';
    echo '	<td>' . $item['id'] . '</td>';
    echo '	<td>' . dataBrasil($item['aprovado'], false) . '</td>';
    echo '	<td> <a href="../../arquivos/' . $item['nome_arquivo'] . '" target="_blank"> ' . $nome_arquivo[0] . '</a></td>';
    echo '	<td>' . $item['disciplina'] . '</td>';

Example #2

Show file

File: todos.php Project: hexti/troncal

								  <th nowrap>Nome</th>
								  <th nowrap>Disciplina</th>
								  <th nowrap>Fase do Projeto</th>
								  <th nowrap>Obra</th>
								  <th nowrap>Lista</th>
								  <th nowrap>Status</th>
								  <th nowrap>A&ccedil;&atilde;o</th>
							  </tr>
						  </thead>   
						  <tbody>
							<?php 
$inicio = $pagina * $qnt - $qnt;
$limit = "LIMIT " . $inicio . ", " . $qnt;
$order_by = " ORDER BY CK.id DESC ";
$query = "SELECT \r\n\t\t\t\t\t\t\t\t\t\t\t\tCK.*,\r\n\t\t\t\t\t\t\t\t\t\t\t\tD.nome as disciplina,\r\n\t\t\t\t\t\t\t\t\t\t\t\tFP.nome as fase,\r\n\t\t\t\t\t\t\t\t\t\t\t\tPO.nome as obra,\r\n\t\t\t\t\t\t\t\t\t\t\t\tRA.id_remessa_lista\r\n\t\t\t\t\t\t\t\t\t\t\tFROM \r\n\t\t\t\t\t\t\t\t\t\t\t\t" . MYSQL_BASE_CHECK_LISTS . " CK\r\n\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_DISCIPLINAS . " D ON D.id = CK.id_disciplina \r\n\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_FASE_PROJETOS . " FP ON FP.id = CK.id_fase_projeto\r\n\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_PROJETO_OBRA . " PO ON PO.id = CK.id_obra_codigo\r\n\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_REMESSA_ARQUIVOS . " RA ON RA.id = CK.id_remessa_arquivo\r\n\t\t\t\t\t\t\t\t\t\t\tWHERE \r\n\t\t\t\t\t\t\t\t\t\t\t\tCK.status != '' AND \r\n\t\t\t\t\t\t\t\t\t\t\t\tCK.ativo = 'S' " . $where;
$retorno = $DAO->listar($query . $order_by . $limit);
foreach ($retorno as $item) {
    $nome_arquivo = explode(".", $item['nome_arquivo']);
    if ($item['status'] == 'A') {
        $status = '<span class="label label-success">Aprovado</span>';
        $visualizar = ' <a data-rel="tooltip" data-original-title="Imprimir AC" class="btn btn-success" target="_blank" href="print.php?id=' . $item['id'] . '"><i class="icon-print icon-white"></i></a>';
    } elseif ($item['status'] == 'AC') {
        $status = '<span class="label label-warning">Aprovado com Coment&aacute;rio</span>';
        $visualizar = ' <a data-rel="tooltip" data-original-title="Imprimir AC" class="btn btn-success" target="_blank" href="print.php?id=' . $item['id'] . '"><i class="icon-print icon-white"></i></a>';
    } elseif ($item['status'] == 'C') {
        $status = '<span class="label label-warning">Cancelado</span>';
        $visualizar = ' <a data-rel="tooltip" data-original-title="Imprimir AC" class="btn btn-danger" target="_blank" href="print.php?id=' . $item['id'] . '"><i class="icon-print icon-white"></i></a>';
    } elseif ($item['status'] == 'R') {
        $obs = 'data-rel="popover" data-content="' . strip_tags($item['consideracoes']) . '" title="Motivo"';
        $status = '<span class="label label-important" ' . strip_tags($obs) . '>Reprovado</span>';
        $visualizar = ' <a data-rel="tooltip" data-original-title="Imprimir AC" class="btn btn-success" target="_blank" href="print.php?id=' . $item['id'] . '"><i class="icon-print icon-white"></i></a>';

Example #3

Show file

File: index.php Project: hexti/troncal

						  <thead>
							  <tr>
							  	<th style="display:none">Ordem</th>
								<th nowrap>C&oacute;digo</th>
								<th nowrap>Nome</th>
								<th nowrap>Lista</th>
								<th nowrap>Data da verifica&ccedil;&atilde;o</th>
								<th nowrap>Disciplina</th>
								<th nowrap>Fase</th>
								<th nowrap>Obra</th>
								<th nowrap>A&ccedil;&atilde;o</th>
							  </tr>
						  </thead>   
						  <tbody>
							<?php 
$DAO->listar();
?>
						  </tbody>
					  </table>            
					</div>
				</div>
			</div>
					
					<!-- content ends -->
			</div><!--/#content.span10-->
				</div><!--/fluid-row-->
				
		<hr>

		<?php 
include_once '../../footer.php';

Example #4

Show file

File: aprovar_varios.php Project: hexti/troncal

						<table class="table table-striped table-bordered bootstrap-datatable datatable">
						  <thead>
							  <tr>
								  <th>Obra</th>
								  <th>Fase do Projeto</th>
								   <th>Disciplina</th>
								  <th>Tipo de Documento</th>
								  <th>Quantidade</th>
								  <th>Vers&atilde;o</th>
								  <th width="10%">Status</th>
								  <th width="35%">A&ccedil;&atilde;o</th>
							  </tr>
						  </thead>   
						  <tbody>
							<?php 
$resultado = $DAO->listar("SELECT \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t    A.*,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t    C.nome as nome_disciplina,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t    D.id_remessa_lista as lista,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tD.revisao,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tC.nome as disciplina,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tPO.nome as obra,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tFP.nome as fase,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tTD.nome as tipo,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCOUNT(A.id) as quantidade\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tFROM\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t    " . MYSQL_BASE_CHECK_LISTS . " A\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_DISCIPLINAS . " C \tON A.id_disciplina = C.id\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_PROJETO_OBRA . " PO \tON PO.id = A.id_obra_codigo\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_FASE_PROJETOS . " FP \tON FP.id = A.id_fase_projeto\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_TIPO_DOCUMENTOS . " TD ON TD.id = A.id_tipo_documento\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN " . MYSQL_BASE_REMESSA_ARQUIVOS . " D ON D.file = CONCAT('../', A.nome_arquivo)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t    A.status = '' AND \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tA.ativo != 'N' AND\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tD.excluido IS NULL AND \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tA.aprovado IS NULL\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tGROUP BY A.id_obra_codigo, A.id_fase_projeto, A.id_tipo_documento, A.id_disciplina");
connectSQL();
$query = mysql_query("SELECT * FROM " . MYSQL_BASE_RESPONSAVEL_DISCIPLINA . " WHERE excluido IS NULL AND aprovador_verificador = 'A' AND verificador = " . userId());
$array = array();
while ($row = mysql_fetch_array($query)) {
    $array[] = $row['id_disciplina'];
}
$confirm = "return confirm('Deseja remover esse registro?');";
foreach ($resultado as $item) {
    $nome_arquivo = explode(".", $item['nome_arquivo']);
    if ($item['aprovado_por'] == 1) {
        $btn_arpovar = '';
        $status = '<span class="label label-success">Aprovado</span>';
        $btn_editar = "";
        $deletar = '';
        $visualizar = ' <a class="btn btn-success" href="view.php?id=' . $item['id'] . '"><i class="icon-eye-open icon-white"></i> Visualizar</a>';

Example #5

Show file

File: aprovado_comentario.php Project: hexti/troncal

						  <thead>
							  <tr>
								<th style="display:none">Ordem</th>
								<th nowrap>C&oacute;digo</th>
								<th nowrap>Analisado</th>
								<th nowrap>Nome</th>
								<th nowrap>Disciplina</th>
								<th nowrap>Fase do Projeto</th>
								<th nowrap>Obra</th>
								<th nowrap>Lista</th>
								<th nowrap>A&ccedil;&atilde;o</th>
							  </tr>
						  </thead>   
						  <tbody>
							<?php 
$retorno = $DAO->listar("SELECT \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCK.id, \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCK.aprovado,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCK.nome_arquivo,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tD.nome as disciplina,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tFP.nome as fase,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tPO.nome as obra\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tFROM \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t" . MYSQL_BASE_CHECK_LISTS . " CK\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_DISCIPLINAS . " D ON D.id = CK.id_disciplina\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_FASE_PROJETOS . " FP ON FP.id = CK.id_fase_projeto\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_PROJETO_OBRA . " PO ON PO.id = CK.id_obra_codigo\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCK.status = 'AC' AND \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCK.aprovado_por=3 AND \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCK.ativo = 'S'\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tORDER BY CK.id DESC");
$ordem = 0;
foreach ($retorno as $item) {
    $nome_arquivo = explode(".", $item['nome_arquivo']);
    $lista = "";
    $query2 = mysql_query("SELECT id_remessa_lista FROM " . MYSQL_BASE_REMESSA_ARQUIVOS . " WHERE file LIKE '%" . $item['nome_arquivo'] . "' AND excluido IS NULL LIMIT 1");
    while ($row = mysql_fetch_array($query2)) {
        $lista = $row['id_remessa_lista'];
    }
    $visualizar = ' <a data-rel="tooltip" title="Imprimir AC" class="btn btn-success" target="_blank" href="print.php?id=' . $item['id'] . '"><i class="icon-print icon-white"></i></a>';
    echo '<tr>';
    echo '	<td style="display:none">' . $ordem . '</td>';
    echo '	<td>' . $item['id'] . '</td>';
    echo '	<td>' . dataBrasil($item['aprovado'], false) . '</td>';
    echo '	<td> <a href="../../arquivos/' . $item['nome_arquivo'] . '" target="_blank"> ' . $nome_arquivo[0] . '</a></td>';
    echo '	<td>' . $item['disciplina'] . '</td>';