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
99
100
|
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta charset="UTF-8"/>
<title>Minimal BubbleTree Demo</title>
<script type="text/javascript" src="lib/bubbletree/lib/jquery-1.5.2.min.js"></script>
<script type="text/javascript" src="lib/bubbletree/lib/jquery.history.js"></script>
<script type="text/javascript" src="lib/bubbletree/lib/raphael.js"></script>
<script type="text/javascript" src="lib/bubbletree/lib/vis4.js"></script>
<script type="text/javascript" src="lib/bubbletree/lib/Tween.js"></script>
<script type="text/javascript" src="lib/bubbletree/build/bubbletree.js"></script>
<link rel="stylesheet" type="text/css" href="lib/bubbletree/build/bubbletree.css" />
<script type="text/javascript" src="lib/bubbletree/styles/cofog.js"></script>
<script type="text/javascript">
$(function() {
<?php
include_once ("lib/common.inc.php");
$unspscresult = mysql_query("select * from UNSPSCcategories;");
while ($row = mysql_fetch_assoc($unspscresult)) {
$unspsc[$row['UNSPSC']] = $row['Title'];
}
$total = 0;
$catsresult = mysql_query("SELECT LEFT( categoryUNSPSC, 1 ) as cat ,
SUM( value ) as value
FROM `contractnotice`
WHERE childCN = 0
GROUP BY cat ;");
$nodes = Array();
while ($row = mysql_fetch_assoc($catsresult)) {
$catName = $unspsc[$row['cat'] . "0000000"] . $row['cat'];
if ($row['cat'] == "") $catName = "null";
$subnodes = Array();
$cattwosresult = mysql_query("SELECT LEFT( categoryUNSPSC, 2 ) as cat ,
SUM( value ) as value
FROM `contractnotice`
WHERE childCN = 0 and LEFT( categoryUNSPSC, 1 ) = '{$row['cat']}'
GROUP BY cat ;");
while ($tworow = mysql_fetch_assoc($cattwosresult)) {
$subcatName = $unspsc[$tworow['cat'] . "000000"] . $tworow['cat'];
if ($tworow['cat'] == "") $subcatName = "null";
$subsubnodes = Array();
$catthreesresult = mysql_query("SELECT LEFT( categoryUNSPSC, 3 ) as cat ,
SUM( value ) as value
FROM `contractnotice`
WHERE childCN = 0 and LEFT( categoryUNSPSC, 2 ) = '{$tworow['cat']}'
GROUP BY cat ;");
while ($threerow = mysql_fetch_assoc($catthreesresult)) {
$subsubcatName = $unspsc[$threerow['cat'] . "00000"] . $threerow['cat'];
if ($threerow['cat'] == "") $subsubcatName = "null";
$subsubnodes[] = Array(
"label" => $subsubcatName,
"amount" => $threerow['value'],
"color" => "#000000"
);
}
$subnodes[] = Array(
"label" => $subcatName,
"amount" => $tworow['value'],
"color" => "#000000",
"children" => $subsubnodes
);
}
$nodes[] = Array(
"label" => $catName,
"amount" => $row['value'],
"color" => "#000000",
"children" => $subnodes
);
$total+= $row['value'];
}
$data = Array(
"label" => "Australian Federal Government Contract Spending",
"amount" => $total,
"color" => "#000000",
"children" => $nodes
);
echo "var data =eval('('+'" . json_encode($data) . "'+')');";
?>
new BubbleTree({
data: data,
container: '.bubbletree'
});
});
</script>
</head>
<body>
<div class="bubbletree-wrapper">
<div class="bubbletree"></div>
</div>
</body>
</html>
|