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  375f5830960934678bca511ea26845076d1a4214 (commit)
      from  20251b685ca66319b686d210489f8e2b72979587 (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=375f5830960934678bca511ea26845076d1a4214

commit 375f5830960934678bca511ea26845076d1a4214
Author: Franck Villaume <[email protected]>
Date:   Fri Jun 28 21:48:55 2019 +0200

    quota_management: get details for PM database usage.

diff --git 
a/src/plugins/quota_management/common/quota_managementPlugin.class.php 
b/src/plugins/quota_management/common/quota_managementPlugin.class.php
index 072f9e0..faf2d41 100644
--- a/src/plugins/quota_management/common/quota_managementPlugin.class.php
+++ b/src/plugins/quota_management/common/quota_managementPlugin.class.php
@@ -151,6 +151,15 @@ to monitor disk and database usage per user, project.");
                                        AND group_id = $1',
                        array($group_id));
        }
+
+       function getPMSizeForProject($group_id) {
+               return db_query_params('SELECT 
SUM(octet_length(project_group_list.description)+octet_length(project_task.summary)+octet_length(project_task.details)+octet_length(project_messages.body))
 as size, count(project_group_list.group_project_id) as nb
+                                       FROM project_group_list, project_task, 
project_messages
+                                       WHERE 
project_group_list.group_project_id = project_task.group_project_id
+                                       AND project_task.project_task_id = 
project_messages.project_task_id
+                                       AND group_id = $1',
+                       array($group_id));
+       }
 }
 
 // Local Variables:
diff --git a/src/plugins/quota_management/view/quota_project.php 
b/src/plugins/quota_management/view/quota_project.php
index 21f40b7..343a8ff 100644
--- a/src/plugins/quota_management/view/quota_project.php
+++ b/src/plugins/quota_management/view/quota_project.php
@@ -108,6 +108,7 @@ if ($group->usesTracker()) {
 
 if ($group->usesFRS()) {
        $res_db = $quota_management->getFRSSizeForProject($group_id);
+       $q = array();
        $q["name"] = _('FRS');
        $q["nb"] = 0; $q["size"] = 0;
        if (db_numrows($res_db) > 0) {
@@ -118,6 +119,19 @@ if ($group->usesFRS()) {
        $quotas[] = $q;
 }
 
+if ($group->usesPM()) {
+       $res_db = $quota_management->getPMSizeForProject($group_id);
+       $q = array();
+       $q["name"] = _('PM');
+       $q["nb"] = 0; $q["size"] = 0;
+       if (db_numrows($res_db) > 0) {
+               $e = db_fetch_array($res_db);
+               $q["nb"] = $e["nb"];
+               $q["size"] = $e["size"];
+       }
+       $quotas[] = $q;
+}
+
 $quotas_disk = array();
 
 // disk_total_space

-----------------------------------------------------------------------

Summary of changes:
 .../common/quota_managementPlugin.class.php                |  9 +++++++++
 src/plugins/quota_management/view/quota_project.php        | 14 ++++++++++++++
 2 files changed, 23 insertions(+)


hooks/post-receive
-- 
FusionForge

_______________________________________________
Fusionforge-commits mailing list
[email protected]
http://lists.fusionforge.org/cgi-bin/mailman/listinfo/fusionforge-commits

Reply via email to