class="table table-striped table-bordered bootstrap-datatable datatable"> <thead> <tr> <th>Nome</th> <th>Lista</th> <th>Destinatário</th> <th>Assunto</th> <th>Obra</th> <th>Disciplina</th> <th>Status</th> <th width="12%">Açã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\tPI.id,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t RL.id as lista,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t P.nome_completo,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PI.assunto,\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\tD.nome as disciplina,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCASE \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t WHEN CK.aprovado_por = 1 THEN 'Aprovado'\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t WHEN CK.aprovado_por = 2 THEN 'Reprovado'\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t WHEN CK.aprovado_por = 3 THEN 'Aprovado com Comentário'\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t ELSE NULL\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t END AS status\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\t" . MYSQL_BASE_PEDIDO_INFORMACAO . " PI\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t INNER JOIN " . MYSQL_BASE_PEDIDO_INFORMACAO_ARQUIVO . " PIA ON PI.id = PIA.id_pedido_informacao\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_REMESSA_ARQUIVOS . " RA ON RA.id = PIA.id_lista_arquivo\r\n\t\t\t \t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_REMESSA_LISTAS . " RL ON RL.id = RA.id_remessa_lista\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_PROJETO_OBRA . " PO ON PO.id = RA.id_obra\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_DISCIPLINAS . " D ON D.id = RA.id_disciplina\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_PESSOAS . " P ON P.id = PI.id_responsavel\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_CHECK_LISTS . " CK ON CK.nome_arquivo = REPLACE(RA.file, '../', '')\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\tPI.excluido IS NULL AND\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PI.fim IS NOT NULL\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tGROUP BY PIA.id_pedido_informacao"); foreach ($resultado as $item) { $explode = explode(' ', $item['nome_completo']); $destinatario = $explode[0] . ' ' . $explode[1]; echo '<tr>'; echo ' <td>PI ' . $item['id'] . '</td>'; echo ' <td>' . $item['lista'] . '</td>'; echo ' <td>' . $destinatario . '</td>'; echo ' <td>' . $item['assunto'] . '</td>'; echo ' <td>' . $item['obra'] . '</td>'; echo ' <td>' . $item['disciplina'] . '</td>'; echo ' <td>' . $item['status'] . '</td>'; echo ' <td>'; echo ' <a class="btn btn-info" target="_blank" href="' . EXTERNAL_ROOT_PORTAL . '/remessa/pedido_informacao/view.php?id=' . $item['id'] . '">'; echo ' <i class="icon-eye-open icon-white"></i> Visualizar'; echo ' </a>';
?> <div class="row-fluid sortable"> <div class="box span12"> <div class="box-content"> <table class="table table-striped table-bordered"> <thead> <tr> <th>Selecionar</th> <th>Arquivo</th> <th>Titulo</th> <th>Usuário</th> </tr> </thead> <tbody> <?php $resultado = $DAO->listar("SELECT ra.*, p.nome_completo, c.observacao, c.consideracoes \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_REMESSA_ARQUIVOS . " ra, \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t" . MYSQL_BASE_PESSOAS . " p, \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t" . MYSQL_BASE_CHECK_LISTS . " c\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE excluido IS NULL\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t AND p.id = ra.id_usuario \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t AND ra.id_remessa_lista =" . $id_lista . "\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t AND ra.id_disciplina =" . $id_disciplina . "\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t AND ra.file LIKE CONCAT ('%' , c.nome_arquivo)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t AND ra.id NOT IN (SELECT id_lista_arquivo FROM tb_pedido_informacao_arquivo pi)"); $count = 1; foreach ($resultado as $item) { if ($item['observacao'] == '' || $item['observacao'] == null) { $observacoes = $item['consideracoes']; } else { $observacoes = $item['observacao']; } $id_lista_arquivo[] = $item['id']; echo '<input type="hidden" name="lista_arquivo-' . $item['id'] . '" value="' . $item['id'] . '">'; echo '<tr>'; ?> <td><input type="checkbox" name="selecionado<?php echo $item['id']; ?> " value="1" id="" onclick="showMe('valida<?php
<tr> <th style="display:none">Ordem</th> <th>Nome</th> <th>Lista</th> <th>Destinatário</th> <th>Assunto</th> <th>Obra</th> <th>Disciplina</th> <th>Status</th> <th>Data</th> <th width="31%">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';