<?php
include_once '../../includes.sys/ini.php';
include_once '../../includes.sys/metodos.php';
include_once '../DAO/RemessaDAO.php';
include_once '../Remessa.class.php';
checkUserAuth(EXTERNAL_ROOT_PORTAL . '/index.php?error=true');
include_once '../../head.php';
$remessa = new Remessa();
$DAO = new RemessaDAO();
$remessa->setId(limpaTexto($_GET['lista']));
if (!in_array(235, listarAcesso())) {
echo '<script language= "JavaScript">location.href="' . EXTERNAL_ROOT_PORTAL . '/modulos.php";</script>';
}
if (!empty($_POST['cmd']) && $_POST['cmd'] == 'editar') {
$msg_erro = NULL;
$msg_sucesso = NULL;
$file = $_FILES['file'];
$remessa->setFile($file['name']);
$remessa->setTitulo($_POST['titulo']);
$remessa->setIdArquivo($_POST['id']);
if ($file['error'] == UPLOAD_ERR_NO_FILE) {
$res = $DAO->Listar("SELECT * FROM " . MYSQL_BASE_REMESSA_ARQUIVOS . " WHERE id = " . $remessa->getIdArquivo());
foreach ($res as $item) {
$remessa->setFile($item['file']);
}
$num = 1;
} else {
$res = $DAO->Listar("SELECT * FROM " . MYSQL_BASE_REMESSA_ARQUIVOS . " WHERE file = '" . $file['name'] . "' AND excluido IS NULL");
$num = $res->rowCount();
}
<?php
include_once '../../includes.sys/ini.php';
include_once '../../includes.sys/metodos.php';
include_once "../DAO/RemessaDAO.php";
checkUserAuth(EXTERNAL_ROOT_PORTAL . '/index.php?error=true');
include_once '../../head.php';
if (!in_array(236, listarAcesso())) {
echo '<script language= "JavaScript">location.href="' . EXTERNAL_ROOT_PORTAL . '/modulos.php";</script>';
}
$DAO = new RemessaDAO();
?>
<!-- topbar ends -->
<div class="container-fluid">
<div class="row-fluid">
<!-- left menu starts -->
<div class="span2 main-menu-span">
<?php
include_once '../menu.php';
?>
</div><!--/span-->
<!-- left menu ends -->
<noscript>
<div class="alert alert-block span10">
<h4 class="alert-heading">Warning!</h4>
<p>You need to have <a href="http://en.wikipedia.org/wiki/JavaScript" target="_blank">JavaScript</a> enabled to use this site.</p>
</div>
</noscript>
function listarEmpresas($id = null)
{
$DAO = new RemessaDAO();
$empresas = $DAO->Listar("SELECT * FROM " . MYSQL_BASE_EMPRESAS . " WHERE id IN (8, 9, 10)");
foreach ($empresas as $empresa) {
if ($id == $empresa['id']) {
echo '<option selected="selected" value="' . $empresa['id'] . '">' . $empresa['nome'] . '</option>';
} else {
echo '<option value="' . $empresa['id'] . '">' . $empresa['nome'] . '</option>';
}
}
}
<?php
include_once '../../includes.sys/ini.php';
include_once '../../includes.sys/metodos.php';
include_once '../DAO/RemessaDAO.php';
checkUserAuth(EXTERNAL_ROOT_PORTAL . '/index.php?error=true');
$acesso = listarAcesso();
if (!in_array(211, $acesso)) {
echo '<script language= "JavaScript">location.href="' . EXTERNAL_ROOT_PORTAL . '/modulos.php";</script>';
}
include_once '../../head.php';
$DAO = new RemessaDAO();
?>
<!-- topbar ends -->
<div class="container-fluid">
<div class="row-fluid">
<!-- left menu starts -->
<div class="span2 main-menu-span">
<?php
include_once '../menu.php';
?>
</div>
<!--/span-->
<!-- left menu ends -->
<noscript>
<div class="alert alert-block span10">
<h4 class="alert-heading">Warning!</h4>
<p>
You need to have <a href="http://en.wikipedia.org/wiki/JavaScript"
<?php
include_once '../../includes.sys/ini.php';
include_once '../../includes.sys/metodos.php';
include_once '../Remessa.class.php';
include_once '../DAO/RemessaDAO.php';
checkUserAuth(EXTERNAL_ROOT_PORTAL . '/index.php?error=true');
if (!in_array(165, listarAcesso())) {
echo '<script language= "JavaScript">location.href="index.php";</script>';
}
$id = limpaTexto($_GET['id']);
$remessa = new Remessa();
$DAO = new RemessaDAO();
$sql_lista = $DAO->Listar("SELECT A.id, A.criado, B.nome, C.nome_completo, A.id_empresa, C.id AS id_usuario\r\n\t\t\t\t\t\t\tFROM " . MYSQL_BASE_REMESSA_LISTAS . " A \r\n\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_EMPRESAS . " B ON A.id_empresa = B.id \r\n\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_PESSOAS . " C ON A.id_usuario = C.id\r\n\t\t\t\t\t\t\tWHERE A.id =" . $id);
foreach ($sql_lista as $item) {
$remessa->setId($item['id']);
$remessa->setCriado($item['criado']);
$remessa->setEmpresa($item['nome']);
$remessa->setIdEmpresa($item['id_empresa']);
$remessa->setIdUsuario($item['id_usuario']);
$remessa->setNome($item['nome_completo']);
}
$resultado = $DAO->Listar("SELECT \tA.id_remessa_lista, \r\n\t\t\t\t\t\t\t\t\tSUBSTRING(A.file,4,35) AS cod_doc, \r\n\t\t\t\t\t\t\t\t\tB.nome_completo, \r\n\t\t\t\t\t\t\t\t\tC.nome AS obra, \r\n\t\t\t\t\t\t\t\t\tA.titulo, \r\n\t\t\t\t\t\t\t\t\tD.nome AS disciplina, \r\n\t\t\t\t\t\t\t\t\tSUBSTRING(A.file,37,2) AS revisao \r\n\t\t\t\t\t\t\tFROM " . MYSQL_BASE_REMESSA_ARQUIVOS . " A \r\n\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_PESSOAS . " B ON B.id = A.id_usuario \r\n\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_PROJETO_OBRA . " C ON C.codigo = SUBSTRING(A.file,16,3) \r\n\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_DISCIPLINAS . " D ON D.codigo = SUBSTRING(A.file,26,3) \r\n\t\t\t\t\t\t\tWHERE excluido IS NULL \r\n\t\t\t\t\t\t\tAND A.id_remessa_lista =" . $id);
?>
<style>
table {
/* border-spacing: 0px; */
/* border-collapse: collapse; */
width: 800px;
}
<?php
include_once '../../includes.sys/ini.php';
include_once '../../includes.sys/metodos.php';
include_once '../DAO/RemessaDAO.php';
include_once '../Remessa.class.php';
checkUserAuth(EXTERNAL_ROOT_PORTAL . '/index.php?error=true');
include_once '../../head.php';
$remessa = new Remessa();
$DAO = new RemessaDAO();
$remessa->setId(limpaTexto($_GET['id']));
if (!empty($_GET['cmd']) && $_GET['cmd'] == 'del') {
$id = ValidateInteger(INPUT_GET, 'id');
$retorno = $DAO->Deletar($id);
if ($retorno == 1) {
echo '<script language= "JavaScript">alert("Categoria removido com sucesso");</script>';
echo '<script language= "JavaScript">location.href="index.php";</script>';
} else {
echo '<script language= "JavaScript">alert("Erro ao remover o registro.");</script>';
}
}
?>
<!-- topbar ends -->
<div class="container-fluid">
<div class="row-fluid">
<!-- left menu starts -->
<div class="span2 main-menu-span">
<?php
include_once '../menu.php';
?>
<?php
include_once '../../includes.sys/ini.php';
include_once '../../includes.sys/metodos.php';
include_once '../DAO/RemessaDAO.php';
checkUserAuth(EXTERNAL_ROOT_PORTAL . '/index.php?error=true');
include_once '../../head.php';
$remessa = new Remessa();
$DAO = new RemessaDAO();
if (!in_array(165, listarAcesso())) {
echo '<script language= "JavaScript">location.href="' . EXTERNAL_ROOT_PORTAL . '/modulos.php";</script>';
}
if (!empty($_GET['cmd']) && $_GET['cmd'] == 'del') {
$id = limpaTexto($_GET['id']);
$retorno = $DAO->DeletarLista($id);
if ($retorno == 1) {
echo '<script language= "JavaScript">alert("Lista removida com sucesso");</script>';
echo '<script language= "JavaScript">location.href="index.php";</script>';
} else {
echo '<script language= "JavaScript">alert("Erro ao remover o registro.");</script>';
}
}
/*Download compactado*/
if (!empty($_GET['cmd']) && $_GET['cmd'] == 'compact') {
$remessa->zipar(limpaTexto($_GET['id']));
}
// echo gethostname();
?>
<!-- topbar ends -->
<div class="container-fluid">
<div class="row-fluid">
<?php
include_once '../../includes.sys/ini.php';
include_once '../../includes.sys/metodos.php';
include_once '../DAO/RemessaDAO.php';
include_once '../Remessa.class.php';
checkUserAuth(EXTERNAL_ROOT_PORTAL . '/index.php?error=true');
include_once '../../head.php';
$remessa = new Remessa();
$remessa->setId(0);
$DAO = new RemessaDAO();
if (!empty($_POST['cmd']) && $_POST['cmd'] == 'inserir') {
$remessa->salvarTitulos($_FILES['files']);
}
if (!empty($_GET['id'])) {
$remessa->setId(limpaTexto($_GET['id']));
}
?>
<!-- topbar ends -->
<div class="container-fluid">
<div class="row-fluid">
<!-- left menu starts -->
<div class="span2 main-menu-span">
<?php
include_once '../menu.php';
?>
</div>
<!--/span-->
<!-- left menu ends -->
<?php
include_once '../../includes.sys/ini.php';
include_once '../../includes.sys/metodos.php';
include_once '../DAO/RemessaDAO.php';
checkUserAuth(EXTERNAL_ROOT_PORTAL . '/index.php?error=true');
$acesso = listarAcesso();
if (!in_array(211, $acesso)) {
echo '<script language= "JavaScript">location.href="' . EXTERNAL_ROOT_PORTAL . '/modulos.php";</script>';
}
include_once '../../head.php';
$remessa = new Remessa();
$DAO = new RemessaDAO();
if (!empty($_GET['cmd']) && $_GET['cmd'] == 'search') {
$query = "SELECT \r\n\t\t\t\t\tPI.id,\r\n\t\t\t\t RA.id_remessa_lista as remessa,\r\n\t\t\t\t E.nome as empresa,\r\n\t\t\t\t PI.assunto,\r\n\t\t\t\t PO.nome as obra,\r\n\t\t\t\t D.nome as disciplina,\r\n\t\t\t\t FP.nome as fase,\r\n\t\t\t\t DATE_FORMAT(PIA.dat_pergunta, '%d/%m/%Y') as data_pi,\r\n\t\t\t\t\tCK.status,\r\n\t\t\t\t\tPIA.file\r\n\t\t\t\tFROM\r\n\t\t\t\t\t" . MYSQL_BASE_PEDIDO_INFORMACAO_ARQUIVO . " PIA\r\n\t\t\t\t INNER JOIN " . MYSQL_BASE_PEDIDO_INFORMACAO . " PI ON PI.id = PIA.id_pedido_informacao\r\n\t\t\t\t INNER JOIN " . MYSQL_BASE_EMPRESAS . " E ON E.id = PI.id_empresa\r\n\t\t\t\t INNER JOIN " . MYSQL_BASE_REMESSA_ARQUIVOS . " RA ON RA.id = PIA.id_lista_arquivo\r\n\t\t\t\t INNER JOIN " . MYSQL_BASE_CHECK_LISTS . " CK ON CK.id_remessa_arquivo = RA.id\r\n\t\t\t\t INNER JOIN " . MYSQL_BASE_PROJETO_OBRA . " PO ON PO.id = RA.id_obra\r\n\t\t\t\t INNER JOIN " . MYSQL_BASE_DISCIPLINAS . " D ON D.id = RA.id_disciplina\r\n\t\t\t\t INNER JOIN " . MYSQL_BASE_FASE_PROJETOS . " FP ON FP.id = RA.id_fase_projeto\r\n\t\t\t\tWHERE\r\n\t\t\t\t\tRA.excluido IS NULL";
if (!empty($_GET['obra'])) {
$query .= " AND PO.codigo = " . $_GET['obra'];
}
if (!empty($_GET['disciplina'])) {
$query .= " AND D.codigo = " . $_GET['disciplina'];
}
if (!empty($_GET['fase'])) {
$query .= " AND FP.codigo = " . $_GET['fase'];
}
if (!empty($_GET['anexo']) && $_GET['anexo'] == 'S') {
$query .= " AND PIA.file != '' AND PIA.file IS NOT NULL";
}
if (!empty($_GET['ultima_versao']) && $_GET['ultima_versao'] == 'S') {
$query .= " AND CK.status != 'O'";
}
if (!empty($_GET['status']) && $_GET['status'] != 'T') {
public function GravarArquivo($remessa)
{
// echo $remessa->getObra().'<br>'.$remessa->getDisciplina().'<br>'.$remessa->getFaseProjeto().'<br>'.$remessa->getTipoDocumento();
try {
$query = "INSERT INTO " . MYSQL_BASE_REMESSA_ARQUIVOS . " (id, id_remessa_lista, file, criado, id_usuario, status, id_codigo_projeto, id_nucleo, id_contrato, id_obra, id_trecho, id_fase_projeto,\r\n\t\t\t\t\tid_disciplina, id_tipo_documento, sequencial, revisao, grupo) ";
$query .= "VALUES (NULL, ?, ?, NOW(), ?, 'S', ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
$stmt = $this->p->prepare($query);
$stmt->bindValue(1, $remessa->getId());
$stmt->bindValue(2, $remessa->getFile());
$stmt->bindValue(3, userId());
$stmt->bindValue(4, $remessa->getCodigoProjeto());
$stmt->bindValue(5, $remessa->getNucleo());
$stmt->bindValue(6, $remessa->getContrato());
$stmt->bindValue(7, $remessa->getObra());
$stmt->bindValue(8, $remessa->getTrecho());
$stmt->bindValue(9, $remessa->getFaseProjeto());
$stmt->bindValue(10, $remessa->getDisciplina());
$stmt->bindValue(11, $remessa->getTipoDocumento());
$stmt->bindValue(12, $remessa->getSequencial());
$stmt->bindValue(13, $remessa->getRevisao());
$stmt->bindValue(14, $remessa->getGrupo());
if (!$stmt->execute()) {
return 0;
} else {
$DAO = new RemessaDAO();
connectSQL();
$id = $this->p->lastInsertId();
if ($remessa->getRevisao() == 'AA') {
$sequencial = "";
} else {
$sequencial = " AND numero = " . $remessa->getSequencial();
}
//Seleciona arquivo para atualizar o primeiro com as caracteristicas
$sql = mysql_query("SELECT id FROM " . MYSQL_BASE_PROJETO_CADASTRO . "\r\n\t\t\t\t\t\t\t\t\tWHERE excluido IS NULL\r\n\t\t\t\t\t\t\t\t\tAND id_obra = " . $remessa->getObra() . "\r\n\t\t\t\t\t\t\t\t\tAND id_fase = " . $remessa->getFaseProjeto() . "\r\n\t\t\t\t\t\t\t\t\tAND id_disciplina = " . $remessa->getDisciplina() . "\r\n\t\t\t\t\t\t\t\t\tAND id_tipo_doc = " . $remessa->getTipoDocumento() . "\r\n\t\t\t\t\t\t\t\t\t" . $sequencial . " LIMIT 1");
$num_proj_cad = mysql_num_rows($sql);
//Verifica se vai ser inserido um novo registro na previsao de projeto
if ($num_proj_cad == 1) {
}
while ($item = mysql_fetch_array($sql)) {
$id_projeto_cad = $item['id'];
}
$linhas = mysql_num_rows($sql);
// $id_pedido_informacao = 0;
// //Retorna o id da lista - remessa de arquivo
// $sql_pi = mysql_query("SELECT B.id_pedido_informacao FROM ".MYSQL_BASE_REMESSA_ARQUIVOS." A
// INNER JOIN ".MYSQL_BASE_PEDIDO_INFORMACAO_ARQUIVO." B ON A.id = B.id_lista_arquivo
// WHERE A.excluido IS NULL
// AND A.id_codigo_projeto = ".$remessa->getCodigoProjeto()."
// AND A.id_nucleo = ".$remessa->getNucleo()."
// AND A.id_contrato = ".$remessa->getContrato()."
// AND A.id_obra = ".$remessa->getObra()."
// AND A.id_trecho = ".$remessa->getTrecho()."
// AND A.id_fase_projeto = ".$remessa->getFaseProjeto()."
// AND A.id_disciplina = ".$remessa->getDisciplina()."
// AND A.id_tipo_documento = ".$remessa->getTipoDocumento()."
// AND A.sequencial = ".$remessa->getSequencial());
// while($item = mysql_fetch_array($sql_pi)){
// $id_pedido_informacao = $item['id_pedido_informacao'];
// }
// $status = '';
// //Retorna qual status est� o documento
// $sql_ck = mysql_query("SELECT status FROM ".MYSQL_BASE_CHECK_LISTS."
// WHERE excluido IS NULL
// AND id_codigo_projeto = ".$remessa->getCodigoProjeto()."
// AND id_nucleo = ".$remessa->getNucleo()."
// AND id_contrato = ".$remessa->getContrato()."
// AND id_obra_codigo = ".$remessa->getObra()."
// AND id_trecho = ".$remessa->getTrecho()."
// AND id_fase = ".$remessa->getFaseProjeto()."
// AND id_disciplina = ".$remessa->getDisciplina()."
// AND id_tipo_documento = ".$remessa->getTipoDocumento());
// while($item = mysql_fetch_array($sql)){
// $status = $item['status'];
// }
if ($linhas == 0) {
//insere novo projeto
$id_projeto_cad = $DAO->GravarProjeto($remessa);
$resultado = $DAO->GravarProjetoTercerizada($id, $id_projeto_cad, NULL, 'P');
} else {
//edita projeto existente
$DAO->AtualizaProjeto($remessa, $id_projeto_cad);
$resultado = $DAO->GravarProjetoTercerizada($id, $id_projeto_cad, NULL, 'P');
}
return $id;
}
// fecho a conex�o
$this->p->__destruct();
// caso ocorra um erro, retorna o erro;
} catch (PDOException $ex) {
echo "Mensagem de erro: " . $ex->getMessage();
}
}
<?php
include_once '../../includes.sys/ini.php';
include_once '../../includes.sys/metodos.php';
include_once "../DAO/RemessaDAO.php";
checkUserAuth(EXTERNAL_ROOT_PORTAL . '/index.php?error=true');
include_once '../../head.php';
$DAO = new RemessaDAO();
?>
<!-- topbar ends -->
<div class="container-fluid">
<div class="row-fluid">
<!-- left menu starts -->
<div class="span2 main-menu-span">
<?php
include_once '../menu.php';
?>
</div><!--/span-->
<!-- left menu ends -->
<noscript>
<div class="alert alert-block span10">
<h4 class="alert-heading">Warning!</h4>
<p>You need to have <a href="http://en.wikipedia.org/wiki/JavaScript" target="_blank">JavaScript</a> enabled to use this site.</p>
</div>
</noscript>
<div id="content" class="span10">
<!-- content starts -->
<?php
include_once '../../includes.sys/ini.php';
include_once '../../includes.sys/metodos.php';
include_once '../DAO/RemessaDAO.php';
include_once '../Remessa.class.php';
checkUserAuth(EXTERNAL_ROOT_PORTAL . '/index.php?error=true');
include_once '../../head.php';
if (!in_array(165, listarAcesso())) {
echo '<script language= "JavaScript">location.href="' . EXTERNAL_ROOT_PORTAL . '/modulos.php";</script>';
}
$remessa = new Remessa();
$DAO = new RemessaDAO();
$remessa->setId(limpaTexto($_GET['id']));
if (!empty($_GET['cmd']) && $_GET['cmd'] == 'del') {
$id = ValidateInteger(INPUT_GET, 'id');
$retorno = $DAO->DeletarArquivo($id);
if ($retorno == 1) {
echo '<script language= "JavaScript">alert("Categoria removido com sucesso");</script>';
echo '<script language= "JavaScript">location.href="view.php?id=' . $_GET['lista'] . '";</script>';
} else {
echo '<script language= "JavaScript">alert("Erro ao remover o registro.");</script>';
}
}
?>
<!-- topbar ends -->
<div class="container-fluid">
<div class="row-fluid">
<!-- left menu starts -->
<div class="span2 main-menu-span">
}
connectSQL();
$msg_codigo_erro = "";
$validador = 0;
$inseridos = 0;
$remessa = new Remessa();
$get = NULL;
if (!empty($_GET['id'])) {
$get = "?id=" . $_GET['id'];
$remessa->setId($_GET['id']);
}
//Verifica se a opcao de salvar foi iniciada
if (!empty($_POST['cmd']) && $_POST['cmd'] == 'inserir') {
$msg_success = NULL;
$erros = 0;
$DAO = new RemessaDAO();
$msg_erro = NULL;
$msg_not_insert = NULL;
$file_ary = reArrayFiles($_FILES['files']);
$msg_codigo_erro = "";
$count = 0;
$remessa->setId(0);
$remessa->setEmpresa($_POST['empresa']);
$remessa->setUsuario(userId());
$remessa->setTipo("P");
foreach ($file_ary as $file) {
$uploadDir = '../../arquivos/remessa/';
$name = $file['name'];
$uploadFile = $uploadDir . $name;
$remessa->setFile($name);
$explode = explode(".", $name);
// echo "<h2>Successfully Uploaded Images</h2>";
$user = userId();
if ($user == 82) {
$empresa = 8;
} else {
$resultado = $DAO->Listar("SELECT\r\n\t\t\t\t\t\t\t\tE.id\r\n\t\t\t\t\t\t\tFROM " . MYSQL_BASE_EMPRESAS . " E\r\n\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_CARGOS . " C ON C.id_empresa = E.id\r\n\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_PESSOAS . " P ON P.id_cargo = C.id\r\n\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t\tP.id=" . $user);
$empresa = 10;
foreach ($resultado as $item) {
//if($item['id'] == 10 || $item['id'] == 9 || $item['id'] == 8 || $item['id'] == 21){
$empresa = $item['id'];
//}
}
}
$msg_success = NULL;
$erros = 0;
$DAO = new RemessaDAO();
$msg_erro = NULL;
$msg_not_insert = NULL;
$file_ary = reArrayFiles($_FILES['images']);
$msg_codigo_erro = "";
$count = 0;
$remessa->setId(0);
$remessa->setEmpresa($empresa);
$remessa->setUsuario(userId());
$remessa->setTipo("P");
$msg_email = '<table style="border: 1px solid black;border-collapse: collapse;">';
$msg_email .= '<tr style="border: 1px solid black;border-collapse: collapse;">';
$msg_email .= '<td align="center" style="border: 1px solid black;border-collapse: collapse;margin: 0 5px 0 5px;"><b>Obra</b></td>';
$msg_email .= '<td align="center" style="border: 1px solid black;border-collapse: collapse;margin: 0 5px 0 5px;"><b>Disciplina</b></td>';
$msg_email .= '<td align="center" style="border: 1px solid black;border-collapse: collapse;margin: 0 5px 0 5px;"><b>Arquivo</b></td>';
$msg_email .= "</tr>";
<?php include_once '../../includes.sys/ini.php'; include_once '../../includes.sys/metodos.php'; include_once '../DAO/RemessaDAO.php'; checkUserAuth(EXTERNAL_ROOT_PORTAL . '/index.php?error=true'); include_once '../../head.php'; $DAO = new RemessaDAO(); ?> <!-- topbar ends --> <div class="container-fluid"> <div class="row-fluid"> <!-- left menu starts --> <div class="span2 main-menu-span"> <?php include_once '../menu.php'; ?> </div><!--/span--> <!-- left menu ends --> <noscript> <div class="alert alert-block span10"> <h4 class="alert-heading">Warning!</h4> <p>You need to have <a href="http://en.wikipedia.org/wiki/JavaScript" target="_blank">JavaScript</a> enabled to use this site.</p> </div> </noscript> <div id="content" class="span10"> <!-- content starts -->
<?php
include_once '../../includes.sys/ini.php';
include_once '../../includes.sys/metodos.php';
include_once "../DAO/RemessaDAO.php";
checkUserAuth(EXTERNAL_ROOT_PORTAL . '/index.php?error=true');
include_once '../../head.php';
$DAO = new RemessaDAO();
?>
<!-- topbar ends -->
<div class="container-fluid">
<div class="row-fluid">
<!-- left menu starts -->
<div class="span2 main-menu-span">
<?php
include_once '../menu.php';
?>
</div><!--/span-->
<!-- left menu ends -->
<noscript>
<div class="alert alert-block span10">
<h4 class="alert-heading">Warning!</h4>
<p>You need to have <a href="http://en.wikipedia.org/wiki/JavaScript" target="_blank">JavaScript</a> enabled to use this site.</p>
</div>
</noscript>
<div id="content" class="span10">
<!-- content starts -->
include_once '../../includes.sys/metodos.php';
include_once '../DAO/RemessaDAO.php';
include_once '../Remessa.class.php';
if (!empty($_GET['arquivo'])) {
$nome_arquivo = $_GET['arquivo'];
//file location
// header("Content-type: application/vnd.ms-excel");
header("Content-type: application/force-download");
header('Content-Disposition: attachment; filename="' . basename($nome_arquivo) . '"');
readfile('../../arquivos/remessa/' . $nome_arquivo);
// ../../arquivos/remessa
header("Pragma: no-cache");
} else {
$lista = $_GET['lista'];
$remessa = new Remessa();
$DAO = new RemessaDAO();
$res = $DAO->Listar("SELECT * FROM " . MYSQL_BASE_REMESSA_ARQUIVOS . " WHERE id_remessa_lista =" . $lista);
foreach ($res as $item) {
$remessa->setFile($item['file']);
$nome_arquivo = $remessa->getFile();
//file location
// header("Content-type: application/vnd.ms-excel");
header("Content-type: application/force-download");
header('Content-Disposition: attachment; filename="' . basename($nome_arquivo) . '"');
readfile('../../arquivos/' . $nome_arquivo);
header("Pragma: no-cache");
}
}
?>
<?php
include_once '../../includes.sys/ini.php';
include_once '../../includes.sys/metodos.php';
include_once '../DAO/RemessaDAO.php';
checkUserAuth(EXTERNAL_ROOT_PORTAL . '/index.php?error=true');
include_once '../../head.php';
$remessa = new Remessa();
$DAO = new RemessaDAO();
if (!empty($_GET['cmd']) && $_GET['cmd'] == 'del') {
$id = ValidateInteger(INPUT_GET, 'id');
$retorno = $DAO->Deletar($id);
if ($retorno == 1) {
echo '<script language= "JavaScript">alert("Categoria removido com sucesso");</script>';
echo '<script language= "JavaScript">location.href="index.php";</script>';
} else {
echo '<script language= "JavaScript">alert("Erro ao remover o registro.");</script>';
}
}
/*Download compactado*/
if (!empty($_GET['cmd']) && $_GET['cmd'] == 'compact') {
$remessa->zipar(limpaTexto($_GET['id']));
}
!empty($_GET['p']) ? $pagina = limpaTexto($_GET['p']) : ($pagina = 1);
?>
<style>
<!--
a:HOVER {
text-decoration: none;
}
-->
