netmon/networkstatistic.php at master · ffansbach/netmon · GitHub

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
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
<?php

/** Include Classes **/
require_once('runtime.php');
require_once('./lib/core/router_old.class.php');
require_once('./lib/core/crawling.class.php');
require_once('./lib/core/Chipsetlist.class.php');

/** Get and assign global messages **/
$smarty->assign('message', Message::getMessage());

/** Get and assign crawler status **/
$last_ended_crawl_cycle = Crawling::getLastEndedCrawlCycle();

if(!empty($last_ended_crawl_cycle)) {
	$last_ended_crawl_cycle['crawl_date_end'] = strtotime($last_ended_crawl_cycle['crawl_date'])+$GLOBALS['crawl_cycle']*60;

	$actual_crawl_cycle = Crawling::getActualCrawlCycle();
	$actual_crawl_cycle['crawl_date_end'] = strtotime($actual_crawl_cycle['crawl_date'])+$GLOBALS['crawl_cycle']*60;
	$actual_crawl_cycle['crawl_date_end_minutes'] = floor(($actual_crawl_cycle['crawl_date_end']-time())/60).':'.sprintf("%02d", (($actual_crawl_cycle['crawl_date_end']-time()) % 60));

	$smarty->assign('last_ended_crawl_cycle', $last_ended_crawl_cycle);
	$smarty->assign('actual_crawl_cycle', $actual_crawl_cycle);

	/**Get number of routers by chipset **/
	$chipsetlist = new Chipsetlist();
	$router_chipsets = array();
	foreach ($chipsetlist->getList() as $key=>$chipset) {
		$router_chipsets[$key]['chipset_id'] = $chipset->getChipsetId();
		$router_chipsets[$key]['chipset_name'] = $chipset->getName();
		$router_chipsets[$key]['hardware_name'] = $chipset->getHardwareName();
		$router_chipsets[$key]['count'] = Router_old::countRoutersByChipsetId($chipset->getChipsetId());;
	}

/*	echo "<pre>";
	print_r($router_chipsets);
	die();*/

	$smarty->assign('router_chipsets', $router_chipsets);

	/**Get number of routers by batman advanced version **/
	try {
		$stmt = DB::getInstance()->prepare("SELECT  batman_advanced_version
						    FROM crawl_routers
						    WHERE crawl_cycle_id=?
							AND batman_advanced_version != \"\"
						    GROUP BY batman_advanced_version");
		$stmt->execute(array($last_ended_crawl_cycle['id']));
		$batman_advanced_versions = $stmt->fetchAll(PDO::FETCH_ASSOC);
	} catch(PDOException $e) {
		echo $e->getMessage();
	};

	$batman_advanced_versions_count = array();
	foreach($batman_advanced_versions as $key=>$batman_advanced_version) {
		$batman_advanced_versions_count[$key]['batman_advanced_version'] = $batman_advanced_version['batman_advanced_version'];

		try {
			$stmt = DB::getInstance()->prepare("SELECT  COUNT(*) as count
							    FROM crawl_routers
							    WHERE crawl_cycle_id=? AND status='online' AND batman_advanced_version=?");
			$stmt->execute(array($last_ended_crawl_cycle['id'], $batman_advanced_versions_count[$key]['batman_advanced_version']));
			$count = $stmt->fetch(PDO::FETCH_ASSOC);
		} catch(PDOException $e) {
			echo $e->getMessage();
		};
		$batman_advanced_versions_count[$key]['count'] = $count['count'];
	}
	$smarty->assign('batman_advanced_versions_count', $batman_advanced_versions_count);

	/**Get number of routers by kernel version **/
	try {
		$stmt = DB::getInstance()->prepare("SELECT  kernel_version
						    FROM crawl_routers
						    WHERE crawl_cycle_id=$last_ended_crawl_cycle[id]
							AND kernel_version != \"\"
						    GROUP BY kernel_version");
		$stmt->execute(array($last_ended_crawl_cycle['id']));
		$kernel_versions = $stmt->fetchAll(PDO::FETCH_ASSOC);
	} catch(PDOException $e) {
		echo $e->getMessage();
	};

	$kernel_versions_count = array();
	foreach($kernel_versions as $key=>$kernel_version) {
		$kernel_versions_count[$key]['kernel_version'] = $kernel_version['kernel_version'];

		try {
			$stmt = DB::getInstance()->prepare("SELECT  COUNT(*) as count
							    FROM crawl_routers
							    WHERE crawl_cycle_id=? AND status='online' AND kernel_version=?");
			$stmt->execute(array($last_ended_crawl_cycle['id'], $kernel_versions_count[$key]['kernel_version']));
			$count = $stmt->fetch(PDO::FETCH_ASSOC);
		} catch(PDOException $e) {
			echo $e->getMessage();
		};
		$kernel_versions_count[$key]['count'] = $count['count'];
	}
	$smarty->assign('kernel_versions_count', $kernel_versions_count);

	/**Get number of routers by firmware version **/
	try {
		$stmt = DB::getInstance()->prepare("SELECT  firmware_version
						    FROM crawl_routers
						    WHERE crawl_cycle_id=?
							AND firmware_version != \"\"
						    GROUP BY firmware_version");
		$stmt->execute(array($last_ended_crawl_cycle['id']));
		$firmware_versions = $stmt->fetchAll(PDO::FETCH_ASSOC);
	} catch(PDOException $e) {
		echo $e->getMessage();
	};

	$firmware_versions_count = array();
	foreach($firmware_versions as $key=>$firmware_version) {
		$firmware_versions_count[$key]['firmware_version'] = $firmware_version['firmware_version'];

		try {
			$stmt = DB::getInstance()->prepare("SELECT  COUNT(*) as count
							    FROM crawl_routers
							    WHERE crawl_cycle_id=? AND status='online' AND firmware_version=?");
			$stmt->execute(array($last_ended_crawl_cycle['id'], $firmware_versions_count[$key]['firmware_version']));
			$count = $stmt->fetch(PDO::FETCH_ASSOC);
		} catch(PDOException $e) {
			echo $e->getMessage();
		};
		$firmware_versions_count[$key]['count'] = $count['count'];
	}
	$smarty->assign('firmware_versions_count', $firmware_versions_count);

	/**Get number of routers by nodewatcher version **/
	try {
		$stmt = DB::getInstance()->prepare("SELECT  nodewatcher_version
						    FROM crawl_routers
						    WHERE crawl_cycle_id=?
							AND nodewatcher_version != \"\"
						    GROUP BY nodewatcher_version");
		$stmt->execute(array($last_ended_crawl_cycle['id']));
		$nodewatcher_versions = $stmt->fetchAll(PDO::FETCH_ASSOC);
	} catch(PDOException $e) {
		echo $e->getMessage();
	};

	$nodewatcher_versions_count = array();
	foreach($nodewatcher_versions as $key=>$nodewatcher_version) {
		$nodewatcher_versions_count[$key]['nodewatcher_version'] = $nodewatcher_version['nodewatcher_version'];
		try {
			$stmt = DB::getInstance()->prepare("SELECT  COUNT(*) as count
							    FROM crawl_routers
							    WHERE crawl_cycle_id=? AND status='online' AND nodewatcher_version=?");
			$stmt->execute(array($last_ended_crawl_cycle['id'], $nodewatcher_versions_count[$key]['nodewatcher_version']));
			$count = $stmt->fetch(PDO::FETCH_ASSOC);
		} catch(PDOException $e) {
			echo $e->getMessage();
		};
		$nodewatcher_versions_count[$key]['count'] = $count['count'];
	}
	$smarty->assign('nodewatcher_versions_count', $nodewatcher_versions_count);

	 //Count router statuses
	$online = Router_old::countRoutersByCrawlCycleIdAndStatus($last_ended_crawl_cycle['id'], 'online');
	$offline = Router_old::countRoutersByCrawlCycleIdAndStatus($last_ended_crawl_cycle['id'], 'offline');
	$unknown = Router_old::countRoutersByCrawlCycleIdAndStatus($last_ended_crawl_cycle['id'], 'unknown');
	$total = $unknown+$offline+$online;

	$smarty->assign('router_status_online', $online);
	$smarty->assign('router_status_offline', $offline);
	$smarty->assign('router_status_unknown', $unknown);
	$smarty->assign('router_status_total', $total);
	$smarty->assign('clients_connected', Router_old::countRoutersByCrawlCycleId($last_ended_crawl_cycle['id']));
}

/** Display templates **/
$smarty->display("header.tpl.html");
$smarty->display("networkstatistic.tpl.html");
$smarty->display("footer.tpl.html");

?>