<?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);