This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "FusionForge".
The branch, master has been updated
via e33bef2867442fa95b8cc37bda12f6631b975b4f (commit)
from 121306328494f1e1228ad8f335bb6befe792ff79 (commit)
Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.
- Log -----------------------------------------------------------------
https://scm.fusionforge.org/anonscm/gitweb/?p=fusionforge/fusionforge.git;a=commitdiff;h=e33bef2867442fa95b8cc37bda12f6631b975b4f
commit e33bef2867442fa95b8cc37bda12f6631b975b4f
Author: Franck Villaume <[email protected]>
Date: Sun Jun 30 10:50:01 2019 +0200
quota_management: reorg code
diff --git
a/src/plugins/quota_management/common/quota_managementPlugin.class.php
b/src/plugins/quota_management/common/quota_managementPlugin.class.php
index 1245a25..df59e7f 100644
--- a/src/plugins/quota_management/common/quota_managementPlugin.class.php
+++ b/src/plugins/quota_management/common/quota_managementPlugin.class.php
@@ -136,6 +136,36 @@ to monitor disk and database usage per user, project.");
array($group_id));
}
+ function getNewsSizeQuery() {
+ return db_query_params('SELECT group_id,
SUM(octet_length(summary) + octet_length(details)) as size
+ FROM news_bytes
+ GROUP BY group_id
+ ORDER BY group_id',
+ array());
+ }
+
+ function getNewsSizeForProject($group_id) {
+ return db_query_params('SELECT SUM(octet_length(summary) +
octet_length(details)) as size, count(*) as nb
+ FROM news_bytes
+ WHERE group_id = $1',
+ array($group_id));
+ }
+
+ function getForumSizeQuery() {
+ return db_query_params('SELECT forum_group_list.group_id as
group_id, SUM(octet_length(subject)+octet_length(body)) as size
+ FROM forum INNER JOIN forum_group_list
ON forum.group_forum_id = forum_group_list.group_forum_id
+ GROUP BY group_id
+ ORDER BY group_id',
+ array());
+ }
+
+ function getForumSizeForProject($group_id) {
+ return db_query_params('SELECT
SUM(octet_length(subject)+octet_length(body)) as size, count(*) as nb
+ FROM forum INNER JOIN forum_group_list
ON forum.group_forum_id = forum_group_list.group_forum_id
+ WHERE group_id = $1',
+ array($group_id));
+ }
+
function getTrackersSizeQuery() {
return db_query_params('SELECT artifact_group_list.group_id,
SUM(octet_length(artifact.summary)+octet_length(artifact.details)+octet_length(artifact_message.body)+artifact_file.filesize)
as size
FROM artifact, artifact_group_list,
artifact_message, artifact_file
diff --git a/src/plugins/quota_management/view/quota.php
b/src/plugins/quota_management/view/quota.php
index 9403341..f74b5d0 100644
--- a/src/plugins/quota_management/view/quota.php
+++ b/src/plugins/quota_management/view/quota.php
@@ -106,7 +106,7 @@ if (forge_get_config('use_frs')) {
}
// PM database size
-if (forge_get_config('use_frs')) {
+if (forge_get_config('use_pm')) {
$res_db = $quota_management->getPMSizeQuery();
if (db_numrows($res_db) > 0) {
while($e = db_fetch_array($res_db)) {
@@ -118,8 +118,7 @@ if (forge_get_config('use_frs')) {
// news database size
if (forge_get_config('use_news')) {
- $res_db = db_query_params('SELECT group_id, SUM(octet_length(summary) +
octet_length(details)) as size FROM news_bytes GROUP BY group_id',
- array());
+ $res_db = $quota_management->getNewsSizeQuery();
if (db_numrows($res_db) > 0) {
while($e = db_fetch_array($res_db)) {
$quotas["$e[group_id]"]["database_size"] += $e["size"];
@@ -129,8 +128,7 @@ if (forge_get_config('use_news')) {
// forums database size
if (forge_get_config('use_forums')) {
- $res_db = db_query_params('SELECT forum_group_list.group_id as
group_id, SUM(octet_length(subject)+octet_length(body)) as size FROM forum
INNER JOIN forum_group_list ON forum.group_forum_id =
forum_group_list.group_forum_id GROUP BY group_id',
- array ());
+ $res_db = $quota_management->getForumSizeQuery();
if (db_numrows($res_db) > 0) {
while($e = db_fetch_array($res_db)) {
$quotas["$e[group_id]"]["database_size"] += $e["size"];
diff --git a/src/plugins/quota_management/view/quota_project.php
b/src/plugins/quota_management/view/quota_project.php
index b3e61cc..1634e3e 100644
--- a/src/plugins/quota_management/view/quota_project.php
+++ b/src/plugins/quota_management/view/quota_project.php
@@ -65,8 +65,7 @@ if ($group->usesDocman()) {
}
if ($group->usesNews()) {
- $res_db = db_query_params('SELECT SUM(octet_length(summary) +
octet_length(details)) as size, count(*) as nb FROM news_bytes WHERE group_id =
$1 ',
- array ($group_id));
+ $res_db = $quota_management->getNewsSizeForProject($group_id);
$q = array();
$q["name"] = _('News');
$q["nb"] = 0; $q["size"] = 0;
@@ -80,8 +79,7 @@ if ($group->usesNews()) {
}
if ($group->usesForum()) {
- $res_db = db_query_params('SELECT
SUM(octet_length(subject)+octet_length(body)) as size, count(*) as nb FROM
forum INNER JOIN forum_group_list ON forum.group_forum_id =
forum_group_list.group_forum_id WHERE group_id = $1 ',
- array ($group_id));
+ $res_db = $quota_management->getForumSizeForProject($group_id);
$q = array();
$q["name"] = _('Forums');
$q["nb"] = 0; $q["size"] = 0;
-----------------------------------------------------------------------
Summary of changes:
.../common/quota_managementPlugin.class.php | 30 ++++++++++++++++++++++
src/plugins/quota_management/view/quota.php | 8 +++---
.../quota_management/view/quota_project.php | 6 ++---
3 files changed, 35 insertions(+), 9 deletions(-)
hooks/post-receive
--
FusionForge
_______________________________________________
Fusionforge-commits mailing list
[email protected]
http://lists.fusionforge.org/cgi-bin/mailman/listinfo/fusionforge-commits
