function delete($id = null) { $sql = "DELETE FROM `user` WHERE id = :id"; $query = Conexao::prepare($sql); $query->bindValue(":id", $id); $query->execute(); }
$query = "UPDATE " . MYSQL_BASE_WORK_FLOW_FLUXO . " SET download = 'S' WHERE id = ?"; $stmt = $conexao->prepare($query); $stmt->bindValue(1, $id); if ($stmt->execute()) { echo '<script language= "JavaScript">close();</script>'; } else { echo '<script language= "JavaScript">close();</script>'; } } else { $documento = limpaTexto($_GET['documento']); $conexao = new Conexao(); $stmt = $conexao->query("SELECT a.*, a.versao as revisao FROM " . MYSQL_BASE_ARQUIVOS . " a, " . MYSQL_BASE_DOCUMENTOS . " d\r\n\t\t\tWHERE d.id = a.id_documento AND a.principal = 'S' AND a.id_documento=" . $documento . " LIMIT 1"); foreach ($stmt as $item) { $idDocumento = $item['id_documento']; $versaoDocumento = $item['versao']; $file = $item['file']; $revisao = $item['revisao']; } $conexao->__destruct(); //Insrir registro no log de donwloads $query = "INSERT INTO " . MYSQL_BASE_LOG_DOWNLOAD . " (id, id_usuario, data, revisao, arquivo, ip)"; $query .= "VALUES (NULL, ?, NOW(), ?, ?, ?)"; $stmt = $conexao->prepare($query); $stmt->bindValue(1, userId()); $stmt->bindValue(2, $revisao); $stmt->bindValue(3, $file); $stmt->bindValue(4, getIP()); if ($stmt->execute()) { echo '<script language= "JavaScript">close();</script>'; } }