PHP WorkFlowDAO::listar 예제들

예제 #1

파일: index.php 프로젝트: hexti/troncal

						
						<table class="table table-striped table-bordered bootstrap-datatable datatable">
						  <thead>
							  <tr>
								  <th>C&oacute;digo</th>
 								  <th>T&iacute;tulo Doc.</th>
 								  <th>Obra</th>
 								  <th>Disciplina</th>
								  <th width="12%">Data de Entrada</th>
								  <th width="10%">Situa&ccedil;&atilde;o</th>
								  <th width="22%">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';

예제 #2

파일: resultado.php 프로젝트: hexti/troncal

						
						<table class="table table-striped table-bordered bootstrap-datatable datatable">
						  <thead>
							  <tr>
								  <th>C&oacute;digo</th>
								  <th>T&iacute;tulo Doc.</th>
 								  <th>Obra</th>
 								  <th>Disciplina</th>
								  <th width="12%">Data de Entrada</th>
								  <th width="10%">Situa&ccedil;&atilde;o</th>
								  <th width="25%">A&ccedil;&atilde;o</th>
							  </tr>
						  </thead>   
						  <tbody>
							<?php 
$resultado = $DAO->listar($query);
foreach ($resultado as $item) {
    if ($item['finalizado'] == NULL) {
        $status = '<span class="label label-warning">Em aberto</span>';
    } else {
        $status = '<span class="label label-success">Finalizado</span>';
    }
    echo '<tr>';
    echo '	<td>' . $item['id'] . '</td>';
    echo '	<td>' . $item['assunto'] . ' (' . $item['cod_documento'] . ')</td>';
    echo '	<td>' . $item['obra'] . '</td>';
    echo '	<td>' . $item['disciplina'] . '</td>';
    echo '	<td>' . dataBrasil($item['dat_criado'], false) . '</td>';
    echo '	<td>' . $status . '</td>';
    echo '	<td>';
    echo '		<a class="btn" href="view.php?id=' . $item['id'] . '">';

예제 #3

파일: index.php 프로젝트: hexti/troncal

					</div>
					<div class="box-content">
						
						<table class="table table-striped table-bordered bootstrap-datatable datatable">
						  <thead>
							  <tr>
								  <th>C&oacute;digo</th>
								  <th>Tipo de Documento</th>
								  <th width="12%">Data de Entrada</th>
								  <th width="10%">Situa&ccedil;&atilde;o</th>
								  <th width="22%">A&ccedil;&atilde;o</th>
							  </tr>
						  </thead>   
						  <tbody>
							<?php 
$request = $DAO->listar("SELECT wf.id, wff.criado, wf.finalizado, wftd.nome, wff.id as fid FROM " . MYSQL_BASE_WORK_FLOW . " wf, " . MYSQL_BASE_WORK_FLOW_FLUXO . " wff, " . MYSQL_BASE_WORK_FLOW_TIPO_DOCUMENTO . " wftd WHERE\r\n\t\t\t\t\t\t\t\t\t\t\t\t\twf.id = wff.id_work_flow AND wf.id_tipo_documento = wftd.id AND wff.despachado IS NOT NULL AND wff.principal = 'S' AND id_pessoa_despachou = " . userId());
foreach ($request as $item) {
    if ($item['finalizado'] != 'S') {
        $status = '<span class="label label-warning">Em aberto</span>';
    } else {
        $status = '<span class="label label-success">Finalizado</span>';
    }
    echo '<tr>';
    echo '	<td>' . $item['id'] . '</td>';
    echo '	<td>' . $item['nome'] . '</td>';
    echo '	<td>' . dataBrasil($item['criado'], false) . '</td>';
    echo '	<td>' . $status . '</td>';
    echo '		<td><a class="btn btn-info" href="edit.php?workflow=' . $item['id'] . '&id=' . $item['fid'] . '">';
    echo '			<i class="icon-edit icon-white"></i> Editar';
    echo '		</a>';
    echo '	</td>';

예제 #4

파일: encaminhamento.php 프로젝트: hexti/troncal

												  <tr>
												  	  <th> <input type="checkbox" name="all" onclick="marcarTodos(this.checked);"> </th>
													  <th>N&ordm; Protocolo</th>
													  <th>Arquivo</th>
													  <th>Titulo</th>
													  <th width="12%">Data de Entrada</th>
												  </tr>
											  </thead>   
											  <tbody>
												<?php 
    if ($tipo == '1') {
        $tamanho = " = 1";
    } else {
        $tamanho = " > 1";
    }
    $resultado = $DAO->listar("SELECT\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tD.cod_documento,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWF.id,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWFF.criado,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWFF.id as fluxo\r\n\t\t\t\t\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\t\t\t\t\t" . MYSQL_BASE_WORK_FLOW . " WF\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_WORK_FLOW_FLUXO . " WFF ON WFF.id_work_flow = WF.id\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_DOCUMENTOS . " D ON D.id = WF.id_documento\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_PROJETO_OBRA . " PO ON PO.codigo = SUBSTRING(D.cod_documento, 13, 3)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_FASE_PROJETOS . " FP ON FP.codigo = SUBSTRING(D.cod_documento, 20, 2)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_DISCIPLINAS . " DI ON DI.codigo = SUBSTRING(D.cod_documento, 23, 3) \r\n\t\t\t\t\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\t\t\t\t\t(SELECT COUNT(id) FROM " . MYSQL_BASE_WORK_FLOW_FLUXO . " WHERE id_pessoa = " . userId() . " AND id_work_flow = WF.id) " . $tamanho . " AND\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWFF.id_pessoa = " . userId() . " AND\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWFF.principal = 'S' AND\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tPO.id = " . $id_obra . " AND\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tFP.id = " . $id_fase . " AND\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tDI.id = " . $id_disciplina . " AND\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWF.finalizado IS NULL\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tGROUP BY WF.id");
    $count = 1;
    foreach ($resultado as $item) {
        echo '<input type="hidden" name="' . $item['id'] . '" value="' . $item['id'] . '">';
        echo '<tr>';
        echo '<td>
															<input type="checkbox" name="check[]" value="' . $item['fluxo'] . '">
														</td>';
        echo '	<td>' . $item['id'] . '</td>';
        echo '	<td><a target="_blank" href="' . EXTERNAL_ROOT_PORTAL . '/arquivos/remessa/' . $item['cod_documento'] . '">' . str_replace("../", "", $item['cod_documento']) . '</a>
															</td>';
        echo '	<td>' . $item['cod_documento'] . '</td>';
        echo '	<td>' . dataBrasil($item['criado'], false) . '</td>';
        echo '</tr>';
        $count += 1;
    }