5 * Portions Copyright 1999-2001 (c) VA Linux Systems
6 * The rest Copyright (c) GForge, LLC
8 * This file is part of FusionForge.
10 * FusionForge is free software; you can redistribute it and/or modify
11 * it under the terms of the GNU General Public License as published by
12 * the Free Software Foundation; either version 2 of the License, or
13 * (at your option) any later version.
15 * GForge is distributed in the hope that it will be useful,
16 * but WITHOUT ANY WARRANTY; without even the implied warranty of
17 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
18 * GNU General Public License for more details.
20 * You should have received a copy of the GNU General Public License
21 * along with GForge; if not, write to the Free Software
22 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 US
25 require dirname(__FILE__).'/../www/env.inc.php';
26 require_once $gfcommon.'include/pre.php';
27 require $gfcommon.'include/cron_utils.php';
37 // project stats by month
40 $err .= "\n\nBeginning stats_project_months: ".date('Y-m-d H:i:s',time());
42 $res = db_query_params ('DELETE FROM stats_project_months',
46 $res = db_query_params ('INSERT INTO stats_project_months
47 SELECT month, group_id,
48 avg(developers)::int AS developers,
49 avg(group_ranking)::int AS group_ranking,
50 avg(group_metric) AS group_metric,
51 sum(logo_showings) AS logo_showings,
52 sum(downloads) AS downloads,
53 sum(site_views) AS site_views ,
54 sum(subdomain_views) AS subdomain_views,
55 sum(page_views) AS page_views,
56 sum(file_releases) AS file_releases,
57 sum(msg_posted) AS msg_posted,
58 sum(msg_uniq_auth) AS msg_uniq_auth,
59 sum(bugs_opened) AS bugs_opened,
60 sum(bugs_closed) AS bugs_closed,
61 sum(support_opened) AS support_opened,
62 sum(support_closed) AS support_closed,
63 sum(patches_opened) AS patches_opened,
64 sum(patches_closed) AS patches_closed,
65 sum(artifacts_opened) AS artifacts_opened,
66 sum(artifacts_closed) AS artifacts_closed,
67 sum(tasks_opened) AS tasks_opened,
68 sum(tasks_closed) AS tasks_closed,
69 sum(help_requests) AS help_requests,
70 sum(cvs_checkouts) AS cvs_checkouts,
71 sum(cvs_commits) AS cvs_commits,
72 sum(cvs_adds) AS cvs_adds
74 GROUP BY month,group_id',
81 // main site page views by month
85 $err .= "\n\nBeginning stats_site_pages_by_month: ".date('Y-m-d H:i:s',time());
87 $res = db_query_params ('DELETE FROM stats_site_pages_by_month',
91 $res = db_query_params ('INSERT INTO stats_site_pages_by_month
92 select month,sum(site_page_views) as site_page_views
93 from stats_site_pages_by_day group by month',
97 $err .= "ERROR IN stats_site_pages_by_month";
105 // sitewide stats in last 30 days
109 $err .= "\n\nBeginning stats_site_months: ".date('Y-m-d H:i:s',time());
111 $res = db_query_params ('DELETE FROM stats_site_months',
115 $res = db_query_params ('INSERT INTO stats_site_months
117 sspbm.site_page_views,
118 SUM(spm.downloads) AS downloads,
119 SUM(spm.subdomain_views) AS subdomain_views,
120 SUM(spm.msg_posted) AS msg_posted,
121 SUM(spm.bugs_opened) AS bugs_opened,
122 SUM(spm.bugs_closed) AS bugs_closed,
123 SUM(spm.support_opened) AS support_opened,
124 SUM(spm.support_closed) AS support_closed,
125 SUM(spm.patches_opened) AS patches_opened,
126 SUM(spm.patches_closed) AS patches_closed,
127 SUM(spm.artifacts_opened) AS artifacts_opened,
128 SUM(spm.artifacts_closed) AS artifacts_closed,
129 SUM(spm.tasks_opened) AS tasks_opened,
130 SUM(spm.tasks_closed) AS tasks_closed,
131 SUM(spm.help_requests) AS help_requests,
132 SUM(spm.cvs_checkouts) AS cvs_checkouts,
133 SUM(spm.cvs_commits) AS cvs_commits,
134 SUM(spm.cvs_adds) AS cvs_adds
135 FROM stats_project_months spm, stats_site_pages_by_month sspbm
136 WHERE spm.month=sspbm.month
137 GROUP BY spm.month,sspbm.site_page_views
138 ORDER BY spm.month ASC;