<table class="table table-striped table-bordered bootstrap-datatable datatable"> <thead> <tr> <th>Código</th> <th>Título Doc.</th> <th>Obra</th> <th>Disciplina</th> <th width="12%">Data de Entrada</th> <th width="10%">Situação</th> <th width="22%">Açã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';
<table class="table table-striped table-bordered bootstrap-datatable datatable"> <thead> <tr> <th>Código</th> <th>Título Doc.</th> <th>Obra</th> <th>Disciplina</th> <th width="12%">Data de Entrada</th> <th width="10%">Situação</th> <th width="25%">Açã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'] . '">';
</div> <div class="box-content"> <table class="table table-striped table-bordered bootstrap-datatable datatable"> <thead> <tr> <th>Código</th> <th>Tipo de Documento</th> <th width="12%">Data de Entrada</th> <th width="10%">Situação</th> <th width="22%">Açã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>';
<tr> <th> <input type="checkbox" name="all" onclick="marcarTodos(this.checked);"> </th> <th>Nº 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; }