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>';
}
}
