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">
