<?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 '../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;
}
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(166, listarAcesso())) {
echo '<script language= "JavaScript">location.href="' . EXTERNAL_ROOT_PORTAL . '/modulos.php";</script>';
}
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");
<?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 -->
$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>";
foreach ($file_ary as $file) {
// $uploadDir = '../../arquivos/remessa/';
$name = $file['name'];
// $uploadFile = $uploadDir . $name;
$remessa->setFile($name);
$explode = explode(".", $name);
