$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
