$checkList->setSequencial($explode[8]); $checkList->setRevisao($explode[9]); $result_cod = $DAO_CK->AtualizarCodificacao($checkList); $result_disciplina = $DAO_CK->Listar("SELECT nome FROM " . MYSQL_BASE_DISCIPLINAS . " WHERE codigo=" . $explode[6]); foreach ($result_disciplina as $item) { $disciplina = $item['nome']; } $checkList->setDescricao($obra . "<br>" . $disciplina . "<br>" . $_POST['titulo']); if ($checkList->getAprovadoPor() != "") { // verifica se foi aprovado (SIM) if ($checkList->getAprovadoPor() == 1 || $checkList->getAprovadoPor() == 3) { // Identifica qual Documento deletar $result_versao = $DAO_CK->Listar("SELECT A.id, C.id as check_id\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t FROM " . MYSQL_BASE_DOCUMENTOS . " A\r\n\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_PROJETOS . " B ON A.id = B.id_documento\r\n\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_CHECK_LISTS . " C ON B.id_check_list = C.id\r\n\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE C.nome_arquivo LIKE '" . $arq_anterior . "%' AND A.ativo = 'S'"); foreach ($result_versao as $item) { $id_doc = $item['id']; $DAO->Deletar($id_doc); $query_status = mysql_query("UPDATE " . MYSQL_BASE_CHECK_LISTS . " set status = 'O' WHERE id =" . $item['check_id']); } } $resultado = $DAO_CK->Autorizar($checkList); $sql_ck = mysql_query("SELECT A.id, B.id AS id_projeto\r\n\t\t\t\t\t\t\t\t\t\tFROM " . MYSQL_BASE_CHECK_LISTS . " A \r\n\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_PROJETO_CADASTRO . " B ON A.id_obra_codigo = B.id_obra\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND A.id_fase_projeto = B.id_fase\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND A.id_disciplina = B.id_disciplina\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND A.id_tipo_documento = B.id_tipo_doc\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND A.id_empresa = B.id_empresa\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND A.sequencial = B.numero \r\n\t\t\t\t\t\t\t\t\tWHERE A.id = " . $checkList->getId()); $linhas = mysql_num_rows($sql_ck); if ($linhas > 0) { while ($row = mysql_fetch_array($sql_ck)) { $id_ck = $row['id']; $id_projeto = $row['id_projeto']; //Add id_check_list à tabela tb_projeto_cad $DAO_CK->AtualizaCheckList($id_ck, $id_projeto); switch ($checkList->getAprovadoPor()) { case 1: $status = 'A';
<?php include_once '../../includes.sys/ini.php'; include_once '../../includes.sys/metodos.php'; include_once "../DAO/DocumentoDAO.php"; checkUserAuth(EXTERNAL_ROOT_PORTAL . '/index.php?error=true'); include_once '../../head.php'; if (!in_array(10, listarAcesso())) { echo '<script language= "JavaScript">location.href="' . EXTERNAL_ROOT_PORTAL . '/modulos.php";</script>'; } $DAO = new DocumentoDAO(); if (!empty($_GET['cmd']) && $_GET['cmd'] == 'del') { $id = ValidateInteger(INPUT_GET, 'id'); $retorno = $DAO->Deletar($id); if ($retorno == 1) { echo '<script language= "JavaScript">alert("Registro removido com sucesso");</script>'; echo '<script language= "JavaScript">location.href="index.php";</script>'; } else { print_r($retorno); } } ?> <!-- topbar ends --> <div class="container-fluid"> <div class="row-fluid"> <!-- left menu starts --> <div class="span2 main-menu-span"> <?php include_once '../menu.php'; ?>
include_once '../../includes.sys/ini.php'; include_once '../../includes.sys/metodos.php'; include_once "../DAO/DocumentoDAO.php"; include_once "../Documento.class.php"; checkUserAuth(EXTERNAL_ROOT_PORTAL . '/index.php?error=true'); include_once INTERNAL_ROOT_PORTAL . '/head.php'; if (!in_array(282, listarAcesso())) { echo '<script language= "JavaScript">location.href="' . EXTERNAL_ROOT_PORTAL . '/modulos.php";</script>'; } // $carta = new Documento(); $DAO = new Documento(); $DocumentoDAO = new DocumentoDAO(); if (!empty($_GET['cmd']) && $_GET['cmd'] == 'del') { $id = ValidateInteger(INPUT_GET, 'id'); $retorno = $DocumentoDAO->Deletar($id); if ($retorno == 1) { echo '<script language= "JavaScript">alert("Registro 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