var qualidade = 300; //dpi var novaAltura = (altura / qualidade) * 2.54; // polegadas -> cm document.getElementsByTagName('fieldset')[0].style.height = novaAltura; } </script> <table class="corpo"> <thead style="display: table-header-group;"> <tbody class="bordasimples"> <tr class="AddBorder"> <td colspan="6" align="center"> <br/><h3>FED - FORMULARIO DE ENVIO DE DOCUMENTO</h3> </td> <td colspan="1" align="center"> <br/>CTB-DC-ED-<?php echo str_pad($remessa->getId(), 5, '0', STR_PAD_LEFT); ?> </td> </tr> <tr class="AddBorder"> <td colspan="1" align="left"> EMITENTE: </td> <td colspan="5" align="left"> <?php if ($remessa->getIdEmpresa() == 9) { $margim = "margin-top: -5%;"; ?> <div class="tudo"><div class="conteudo"><img src="<?php echo EXTERNAL_ROOT_PORTAL; ?>
</div> <div class="box-content"> <form class="form-horizontal" method="post" action="arquivo.php" enctype="multipart/form-data"> <fieldset> <div class="control-group"> <label class="control-label"><b>Arquivo CSV</b></label> <div class="controls"> <input type="file" name="files"> <p class="help-block"><a href="modelo.csv" target="_blank">Baixar Arquivo modelo</a></p> </div> </div> <?php if ($remessa->getId() != 0) { ?> <div class="control-group"> <label class="control-label"><b>Arquivo Sem Titulo</b></label> <div class="controls"> <ul> <?php $resultado = $DAO->Listar("SELECT * FROM " . MYSQL_BASE_REMESSA_ARQUIVOS . " WHERE excluido IS NULL AND titulo IS NULL AND id_remessa_lista = " . $remessa->getId()); foreach ($resultado as $item) { echo '<li>' . $item['file'] . '</li>'; } ?> </ul> </div> </div> <?php
public function Listar($query = null) { try { $remessa = new Remessa(); if ($query == null) { $stmt = $this->p->query("SELECT rl.*, \r\n\t\t\t\t\t\t\t\t\t\t\t(SELECT COUNT(id) FROM " . MYSQL_BASE_REMESSA_ARQUIVOS . " WHERE id_remessa_lista = rl.id AND excluido IS NULL) as total, \r\n\t\t\t\t\t\t\t\t\t\t\t(SELECT COUNT(id) FROM " . MYSQL_BASE_REMESSA_ARQUIVOS . " WHERE id_remessa_lista = rl.id AND finalizado IS NOT NULL AND excluido IS NULL) as total_finalizado,\r\n\t\t\t\t\t\t\t\t\t\t\t(SELECT COUNT(id) FROM " . MYSQL_BASE_REMESSA_ARQUIVOS . " WHERE id_remessa_lista = rl.id AND titulo IS NOT NULL AND excluido IS NULL) as total_titulo, \r\n\t\t\t\t\t\t\t\t\t\t\te.nome, \r\n\t\t\t\t\t\t\t\t\t\t\tp.nome_completo \r\n\t\t\t\t\t\t\t\t\t\tFROM " . MYSQL_BASE_REMESSA_LISTAS . " rl, \r\n\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 " . MYSQL_BASE_EMPRESAS . " e \r\n\t\t\t\t\t\t\t\t\t\tWHERE \r\n\t\t\t\t\t\t\t\t\t\t\tp.id = rl.id_usuario \r\n\t\t\t\t\t\t\t\t\t\tAND e.id = rl.id_empresa \r\n\t\t\t\t\t\t\t\t\t\tAND rl.excluido IS NULL \r\n\t\t\t\t\t\t\t\t\t\tAND rl.tipo = 'P' \r\n\t\t\t\t\t\t\t\t\t\tAND rl.finalizado IS NULL \r\n\t\t\t\t\t\t\t\t\t\tORDER BY rl.criado DESC "); $count = 0; $confirm = "return confirm('Deseja remover esse registro?');"; $user = userId(); connectSQL(); foreach ($stmt as $item) { $query = mysql_query("SELECT\r\n\t\t\t\t\t\t\t\t\t\t\tD.nome,\r\n\t\t\t\t\t\t\t\t\t\t\tD.id,\r\n\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\tFP.nome as fase,\r\n\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\tFROM\r\n\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\tINNER JOIN " . MYSQL_BASE_DISCIPLINAS . " D ON D.id = RA.id_disciplina\r\n\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\tINNER JOIN " . MYSQL_BASE_FASE_PROJETOS . " FP ON FP.id = RA.id_fase_projeto\r\n\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_TIPO_DOCUMENTOS . " TD ON TD.id = RA.id_tipo_documento\r\n\t\t\t\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t\t\t\t\tRA.id_remessa_lista = " . $item['id'] . "\r\n\t\t\t\t\t\t\t\t\t\tGROUP BY D.nome"); $disciplina = " "; $obra = " "; $fase = " "; $tipo = " "; $id_disc = " "; while ($row = mysql_fetch_array($query)) { $disciplina .= " " . $row['nome'] . ','; $id_disc = $row['id'] . ','; $obra .= " " . $row['obra'] . ','; $tipo .= " " . $row['tipo'] . ','; $fase .= " " . $row['fase'] . ','; } $disciplina = substr($disciplina, 0, -1); $obra = substr($obra, 0, -1); $tipo = substr($tipo, 0, -1); $fase = substr($fase, 0, -1); $id_disc = substr($id_disc, 0, -1); $query = mysql_query("SELECT \r\n\t\t\t\t\t\t\t\t\t\t\tP.nome_completo \r\n\t\t\t\t\t\t\t\t\t\tFROM \r\n\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\tINNER JOIN " . MYSQL_BASE_RESPONSAVEL_DISCIPLINA . " RD ON RD.verificador = P.id\r\n\t\t\t\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t\t\t\t\tRD.id_disciplina IN (" . $id_disc . ") AND\r\n\t\t\t\t\t\t\t\t\t\t\tRD.aprovador_verificador = 'V' AND\r\n\t\t\t\t\t\t\t\t\t\t\tRD.excluido IS NULL\r\n\t\t\t\t\t\t\t\t\t\tGROUP BY P.id"); $verificador = " "; while ($row = mysql_fetch_array($query)) { $explode = explode(' ', $row['nome_completo']); $verificador .= " " . $explode[0] . ','; } $verificador = substr($verificador, 0, -1); $query_aprovador = mysql_query("SELECT\r\n\t\t\t\t\t\t\t\t\t\t\tP.nome_completo\r\n\t\t\t\t\t\t\t\t\t\tFROM\r\n\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\tINNER JOIN " . MYSQL_BASE_RESPONSAVEL_DISCIPLINA . " RD ON RD.verificador = P.id\r\n\t\t\t\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t\t\t\t\tRD.id_disciplina IN (" . $id_disc . ") AND\r\n\t\t\t\t\t\t\t\t\t\t\tRD.aprovador_verificador = 'A' AND\r\n\t\t\t\t\t\t\t\t\t\t\tRD.excluido IS NULL\r\n\t\t\t\t\t\t\t\t\t\tGROUP BY P.id"); $aprovador = " "; while ($row = mysql_fetch_array($query_aprovador)) { $explode = explode(' ', $row['nome_completo']); $aprovador .= " " . $explode[0] . ','; } $aprovador = substr($aprovador, 0, -1); echo '<tr>'; echo ' <td style="display: none;">' . $count . '</td>'; echo ' <td>Lista ' . $item['id'] . '</td>'; echo ' <td>' . $obra . '</td>'; echo ' <td>' . $fase . '</td>'; echo ' <td>' . $disciplina . '</td>'; echo ' <td>' . $tipo . '</td>'; echo ' <td>' . $verificador . '</td>'; echo ' <td>' . $aprovador . '</td>'; echo ' <td>' . dataBrasil($item['criado'], false) . '</td>'; echo ' <td>' . $item['total_finalizado'] . '/' . $item['total'] . '</td>'; echo ' <td>' . $item['nome_completo'] . '</td>'; echo ' <td>' . $item['nome'] . '</td>'; echo ' <td>'; $count += 1; if (in_array(165, listarAcesso())) { echo ' <a data-rel="tooltip" data-original-title="Visualizar" class="btn btn-info" href="view.php?id=' . $item['id'] . '">'; echo ' <i class="icon-eye-open icon-white"></i>'; echo ' </a>'; } //Gerar FED if (in_array(165, listarAcesso())) { echo ' <a data-rel="tooltip" data-original-title="FED" class="btn btn-info" target="_blank" href="view_grd.php?id=' . $item['id'] . '">'; echo ' <i class="icon-list-alt icon-white"></i>'; echo ' </a>'; } //Verifica se pode fazer download if (in_array(165, listarAcesso()) && $item['total'] > 0) { echo ' <a data-rel="tooltip" title="Download" class="btn btn-inverse" href="index.php?cmd=compact&id=' . $item['id'] . '">'; echo ' <i class="icon-download-alt icon-white"></i>'; echo ' </a>'; } if ($item['id_usuario'] == $user) { echo ' <a data-rel="tooltip" title="Deletar" class="btn btn-danger" onclick="' . $confirm . '" href="index.php?lista=' . $remessa->getId() . '&cmd=del&id=' . $item['id'] . '">'; echo ' <i class="icon-trash icon-white"></i>'; echo ' </a>'; } if (in_array(210, listarAcesso())) { if ($item['total_titulo'] < $item['total']) { echo ' <a data-rel="tooltip" title="Arquivo CSV" class="btn btn-info" href="arquivo.php?id=' . $item['id'] . '">'; echo ' <i class="icon-file icon-white"></i>'; echo ' </a>'; } } echo ' </td>'; echo '</tr>'; } } else { $stmt = $this->p->query($query); return $stmt; } $this->p = null; } catch (PDOException $ex) { echo "Erro: " . $ex->getMessage(); } }
<a href="<?php echo EXTERNAL_ROOT_PORTAL; ?> /modulos.php">SIG</a> <span class="divider">-</span> </li> <li> <a href="<?php echo EXTERNAL_ROOT_PORTAL; ?> /remessa/proj_pendente/index.php">Projetos Pendentes</a> <span class="divider">-</span> </li> <li> Lista <?php echo $remessa->getId(); ?> </li> </ul> </div> <div class="row-fluid"> <div class="box span12"> <div class="box-header well"> <h2><i class="icon-file"></i> Projetos Pendentes</h2> <div class="box-icon"> </div> </div> <div class="box-content"> <table class="table table-striped table-bordered bootstrap-datatable datatable">
$versao_ck[] = substr($ex[0], 33, 35); } rsort($versao_ck); foreach ($superior as $row) { $desc2 = $item['revisao']; } if ($versao_ck[0] > $desc2) { $versao = $versao_ck[0]; } else { $versao = $desc2; } } $msg_erro .= utf8_encode("<br>A revisão do arquivo " . $remessa->getFile() . " deve ser superior a " . $versao); } else { if (move_uploaded_file($file['tmp_name'], $uploadFile)) { if ($remessa->getId() == 0) { $remessa->setId($DAO->Gravar($remessa)); if (is_array($remessa->getId())) { $validador = 1; $erros += 1; $msg_not_insert .= utf8_encode("<br> O arquivo " . $remessa->getFile() . " não foi salvo, favor entrar em contato com a TI."); } else { $DAO->AtualizaStatus($remessa->getId()); // $resultado = $DAO->GravarArquivo($remessa); if ($resultado != 1) { $validador = 1; $erros += 1; $msg_not_insert .= utf8_encode("<br>Não foi possível salvar o o arquivo " . $remessa->getFile() . ", por favor informar a TI."); } else { $inseridos += 1; $msg_success .= "<li>" . $result . "</li>";
<a href="<?php echo EXTERNAL_ROOT_PORTAL; ?> /modulos.php">Modulos</a> <span class="divider">-</span> </li> <li> <a href="<?php echo EXTERNAL_ROOT_PORTAL; ?> /remessa/proj_concluido/index.php">Projetos Concluídos</a> <span class="divider">-</span> </li> <li> Lista <?php echo $remessa->getId(); ?> </li> </ul> </div> <div class="row-fluid"> <div class="box span12"> <div class="box-header well"> <h2><i class="icon-file"></i> Projetos Concluídos</h2> <div class="box-icon"> </div> </div> <div class="box-content"> <table class="table table-striped table-bordered bootstrap-datatable datatable">