forked from Kitware/CDash
/
siteStatistics.php
98 lines (85 loc) · 3.01 KB
/
siteStatistics.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
<?php
/*=========================================================================
Program: CDash - Cross-Platform Dashboard System
Module: $Id$
Language: PHP
Date: $Date$
Version: $Revision$
Copyright (c) 2002 Kitware, Inc. All rights reserved.
See Copyright.txt or http://www.cmake.org/HTML/Copyright.html for details.
This software is distributed WITHOUT ANY WARRANTY; without even
the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR
PURPOSE. See the above copyright notices for more information.
=========================================================================*/
include("cdash/config.php");
require_once("cdash/pdo.php");
include('login.php');
include("cdash/version.php");
if($session_OK)
{
include_once('cdash/common.php');
include_once("cdash/ctestparser.php");
$db = pdo_connect("$CDASH_DB_HOST", "$CDASH_DB_LOGIN","$CDASH_DB_PASS");
pdo_select_db("$CDASH_DB_NAME",$db);
checkUserPolicy(@$_SESSION['cdash']['loginid'],0); // only admin
$xml = begin_XML_for_XSLT();
$xml .= "<backurl>user.php</backurl>";
$xml .= "<title>CDash - Sites Statistics</title>";
$xml .= "<menutitle>CDash</menutitle>";
$xml .= "<menusubtitle>Site Statistics</menusubtitle>";
if($CDASH_DB_TYPE == "pgsql")
{
$query = pdo_query("SELECT siteid,sitename, SUM(elapsed) AS busytime FROM
(
SELECT site.id AS siteid,site.name AS sitename, project.name AS projectname, build.name AS buildname, build.type,
AVG(submittime - buildupdate.starttime) AS elapsed
FROM build, build2update, buildupdate, project, site
WHERE
submittime > NOW()- interval '168 hours'
AND build2update.buildid = build.id
AND buildupdate.id = build2update.updateid
AND site.id = build.siteid
AND build.projectid = project.id
GROUP BY sitename,projectname,buildname,build.type,site.id
ORDER BY elapsed DESC
)
AS summary
GROUP BY sitename,summary.siteid
ORDER BY busytime DESC
");
}
else
{
$query = pdo_query("SELECT siteid,sitename, SEC_TO_TIME(SUM(elapsed)) AS busytime FROM
(
SELECT site.id AS siteid,site.name AS sitename, project.name AS projectname, build.name AS buildname, build.type,
AVG(TIME_TO_SEC(TIMEDIFF(submittime, buildupdate.starttime))) AS elapsed
FROM build, build2update, buildupdate, project, site
WHERE
submittime > TIMESTAMPADD(".qiv("HOUR").", -168, NOW())
AND build2update.buildid = build.id
AND buildupdate.id = build2update.updateid
AND site.id = build.siteid
AND build.projectid = project.id
GROUP BY sitename,projectname,buildname,build.type
ORDER BY elapsed DESC
)
AS summary
GROUP BY sitename
ORDER BY busytime DESC
");
}
echo pdo_error();
while($query_array = pdo_fetch_array($query))
{
$xml .= "<site>";
$xml .= add_XML_value("id",$query_array["siteid"]);
$xml .= add_XML_value("name",$query_array["sitename"]);
$xml .= add_XML_value("busytime",$query_array["busytime"]);
$xml .= "</site>";
}
$xml .= "</cdash>";
// Now doing the xslt transition
generate_XSLT($xml,"siteStatistics");
} // end session
?>