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