root / hci / trunk / eneraptor-web-app / grails-app / controllers / com / eneraptor / hci / SysLogController.groovy @ 66
History | View | Annotate | Download (8.13 KB)
1 |
package com.eneraptor.hci
|
---|---|
2 |
|
3 |
import groovy.sql.* |
4 |
import java.sql.* |
5 |
|
6 |
class SysLogController { |
7 |
|
8 |
def dataSource
|
9 |
|
10 |
def index = { }
|
11 |
|
12 |
def main = {
|
13 |
|
14 |
/*
|
15 |
* DISK USAGE - ONLY IF ENERAPOTR HCI IS SUPERUSER
|
16 |
*/
|
17 |
def freeSpace = 0 |
18 |
def totalSpace = 0 |
19 |
def percent = 0 |
20 |
/*
|
21 |
def db_sql = new Sql(dataSource)
|
22 |
|
23 |
def single = db_sql.firstRow("show data_directory")
|
24 |
def loca = single.data_directory
|
25 |
def partition = new File(loca)
|
26 |
totalSpace = partition.getTotalSpace()
|
27 |
freeSpace = partition.getFreeSpace()
|
28 |
|
29 |
totalSpace = (int)((totalSpace/1024)/1024)
|
30 |
freeSpace = (int)((freeSpace/1024)/1024)
|
31 |
|
32 |
percent = 100 - ((int) ((freeSpace/totalSpace)*100))
|
33 |
*/
|
34 |
|
35 |
[totalSpace: totalSpace, freeSpace: freeSpace, percent: percent] |
36 |
|
37 |
} |
38 |
|
39 |
def browse = {
|
40 |
|
41 |
flash['warnings'] = null |
42 |
|
43 |
List devicesForCheckBox = new ArrayList() |
44 |
|
45 |
def crit1 = DeviceInfo.createCriteria()
|
46 |
devicesForCheckBox = crit1 { |
47 |
and { |
48 |
or { |
49 |
eq("outputDevice",true) |
50 |
eq("inputDevice",true) |
51 |
} |
52 |
eq("hwSet",session.hwSet)
|
53 |
} |
54 |
order("friendlyName","asc") |
55 |
} |
56 |
|
57 |
def entries = new ArrayList() |
58 |
|
59 |
List checkedDevices = new ArrayList() |
60 |
devicesForCheckBox.each { |
61 |
if(params['cb_' + it.deviceId]) { |
62 |
checkedDevices << it.deviceId
|
63 |
} |
64 |
} |
65 |
|
66 |
if(params['fromDate'] && params['tillDate']) { |
67 |
if(params['all_cb']) { |
68 |
def c = LoggedData.createCriteria()
|
69 |
entries = c { |
70 |
and { |
71 |
between("dateRecieved",params['fromDate'],params['tillDate']) |
72 |
} |
73 |
order("dateRecieved","asc") |
74 |
} |
75 |
} else {
|
76 |
if(checkedDevices.size > 0) { |
77 |
def c = LoggedData.createCriteria()
|
78 |
entries = c { |
79 |
and { |
80 |
between("dateRecieved",params['fromDate'],params['tillDate']) |
81 |
'in'("deviceId",checkedDevices) |
82 |
} |
83 |
order("dateRecieved","asc") |
84 |
} |
85 |
} |
86 |
} |
87 |
} |
88 |
|
89 |
Map devices = new HashMap() |
90 |
Map icons = new HashMap() |
91 |
List unknownDevices = new ArrayList() |
92 |
DeviceInfo.list().each { |
93 |
devices[it.deviceId] = it.friendlyName |
94 |
if(it.iconPath) { |
95 |
icons[it.deviceId] = it.iconPath |
96 |
} |
97 |
} |
98 |
entries.each { |
99 |
if(!devices[it.deviceId]) { |
100 |
if(!unknownDevices.contains(it.deviceId)) { |
101 |
unknownDevices << it.deviceId
|
102 |
} |
103 |
} |
104 |
} |
105 |
unknownDevices.each { |
106 |
if(!flash['warnings']) flash['warnings'] = "" |
107 |
flash['warnings'] += "<p>There was found at least one log entry for a device with id <b>${it}</b>, which is <b>unknown</b> to HCI. You should <b>add this device</b> by <b>" + g.link(controller: 'config', action: 'addDevice', params: ['deviceId' : it], "clicking here") + "</b>.</p>" |
108 |
} |
109 |
|
110 |
[data: entries, devices: devices, icons: icons, devicesForCheckBox:devicesForCheckBox] |
111 |
|
112 |
} |
113 |
|
114 |
def detail = {
|
115 |
|
116 |
def detailsOf = LoggedData.findById(params.id)
|
117 |
if(!detailsOf) {
|
118 |
flash['errors'] = "<p>There is no logged data with id ${params.id}</p>" |
119 |
redirect(action: 'browse') |
120 |
return false |
121 |
} |
122 |
return detailsOf.getProperties()
|
123 |
} |
124 |
|
125 |
def deleteEntry = {
|
126 |
|
127 |
def entry = LoggedData.findById(params.id)
|
128 |
if(entry) {
|
129 |
entry.delete() |
130 |
flash['confirms'] = "<p>Log entry with id " + params.id + " deleted successfully.</p>" |
131 |
redirect(action: 'browse') |
132 |
} else {
|
133 |
flash['errors'] = "<p>Cannot find log entry with id " + params.id + "</p>" |
134 |
redirect(action: 'browse') |
135 |
} |
136 |
|
137 |
} |
138 |
|
139 |
def graph = {
|
140 |
|
141 |
List devices = new ArrayList() |
142 |
List data = new ArrayList() |
143 |
|
144 |
def crit1 = DeviceInfo.createCriteria()
|
145 |
devices = crit1 { |
146 |
and { |
147 |
eq("inputDevice",true) |
148 |
eq("hwSet",session.hwSet)
|
149 |
} |
150 |
order("friendlyName","asc") |
151 |
} |
152 |
|
153 |
if(params['dataList']) |
154 |
data = params['dataList']
|
155 |
else if(params['deviceId'] && params['fromDate'] && params['tillDate']) { |
156 |
|
157 |
def c = LoggedData.createCriteria()
|
158 |
def results = c {
|
159 |
and { |
160 |
eq("deviceId",params['deviceId']) |
161 |
between("dateRecieved",params['fromDate'],params['tillDate']) |
162 |
} |
163 |
order("dateRecieved","asc") |
164 |
} |
165 |
|
166 |
results.each { |
167 |
data << [it.dateRecieved.getTime(),it.reportedData] |
168 |
} |
169 |
|
170 |
} |
171 |
|
172 |
[data: data, devices: devices, params:params] |
173 |
|
174 |
} |
175 |
|
176 |
def export = { |
177 |
|
178 |
List devicesForCheckBox = new ArrayList() |
179 |
|
180 |
def crit1 = DeviceInfo.createCriteria()
|
181 |
devicesForCheckBox = crit1 { |
182 |
and { |
183 |
or { |
184 |
eq("outputDevice",true) |
185 |
eq("inputDevice",true) |
186 |
} |
187 |
eq("hwSet",session.hwSet)
|
188 |
} |
189 |
order("friendlyName","asc") |
190 |
} |
191 |
|
192 |
[devicesForCheckBox: devicesForCheckBox]
|
193 |
|
194 |
} |
195 |
|
196 |
def exportDo = {
|
197 |
|
198 |
List devicesForCheckBox = new ArrayList() |
199 |
DeviceInfo.findAllByInputDeviceOrOutputDevice(true,true).each { |
200 |
devicesForCheckBox << it
|
201 |
} |
202 |
|
203 |
List checkedDevices = new ArrayList() |
204 |
devicesForCheckBox.each { |
205 |
if(params['cb_' + it.deviceId]) { |
206 |
checkedDevices << it.deviceId
|
207 |
} |
208 |
} |
209 |
|
210 |
List entries = new ArrayList() |
211 |
def cont = "" |
212 |
|
213 |
if(params['all_cb']) { |
214 |
def c = LoggedData.createCriteria()
|
215 |
entries = c { |
216 |
and { |
217 |
between("dateRecieved",params['fromDate'],params['tillDate']) |
218 |
} |
219 |
order("dateRecieved","asc") |
220 |
} |
221 |
} else {
|
222 |
if(checkedDevices.size > 0) { |
223 |
def c = LoggedData.createCriteria()
|
224 |
entries = c { |
225 |
and { |
226 |
between("dateRecieved",params['fromDate'],params['tillDate']) |
227 |
'in'("deviceId",checkedDevices) |
228 |
} |
229 |
order("dateRecieved","asc") |
230 |
} |
231 |
} |
232 |
} |
233 |
|
234 |
if(entries.size == 0) { |
235 |
flash['errors'] = "<p>Nothing to export!</p><p>There are no log entries for selected devices in the time interval specified.</p>" |
236 |
redirect(action:'export') |
237 |
} |
238 |
else if(params['format'] == "Plain text (.txt)") { |
239 |
entries.each { |
240 |
cont += it.dateRecieved.toString() + " " + it.deviceId + " " + it.reportedData + "\n" |
241 |
} |
242 |
render(text: cont,contentType:"text/plain",encoding:"UTF-8") |
243 |
} else if(params['format'] == "PostgreSQL script (.sql)") { |
244 |
entries.each { |
245 |
cont += "INSERT INTO logged_data(id, \"version\", date_recieved, device_id, reported_data) VALUES (nextval('hibernate_sequence'), 0, '" + it.dateRecieved.toString() + "', '" + it.deviceId + "', '" + it.reportedData + "');\n"; |
246 |
} |
247 |
render(text: cont,contentType:"text/plain",encoding:"UTF-8") |
248 |
} else {
|
249 |
cont += "<log>\n"
|
250 |
entries.each { |
251 |
cont += "\t<entry>\n"
|
252 |
cont += "\t\t<device>" + it.deviceId + "</device>\n" |
253 |
cont += "\t\t<time>" + it.dateRecieved.toString() + "</time>\n" |
254 |
cont += "\t\t<data>\n"
|
255 |
cont += "\t\t\t" + it.reportedData + "\n" |
256 |
cont += "\t\t</data>\n"
|
257 |
cont += "\t</entry>\n"
|
258 |
} |
259 |
cont += "</log>"
|
260 |
render(text: cont,contentType:"text/xml",encoding:"UTF-8") |
261 |
} |
262 |
} |
263 |
|
264 |
def clear = {
|
265 |
|
266 |
List devicesForCheckBox = new ArrayList() |
267 |
|
268 |
def crit1 = DeviceInfo.createCriteria()
|
269 |
devicesForCheckBox = crit1 { |
270 |
and { |
271 |
or { |
272 |
eq("outputDevice",true) |
273 |
eq("inputDevice",true) |
274 |
} |
275 |
eq("hwSet",session.hwSet)
|
276 |
} |
277 |
order("friendlyName","asc") |
278 |
} |
279 |
|
280 |
[devicesForCheckBox: devicesForCheckBox]
|
281 |
|
282 |
} |
283 |
|
284 |
def clearDo = {
|
285 |
|
286 |
List devicesForCheckBox = new ArrayList() |
287 |
DeviceInfo.findAllByInputDeviceOrOutputDevice(true,true).each { |
288 |
devicesForCheckBox << it
|
289 |
} |
290 |
|
291 |
List checkedDevices = new ArrayList() |
292 |
devicesForCheckBox.each { |
293 |
if(params['cb_' + it.deviceId]) { |
294 |
checkedDevices << it.deviceId
|
295 |
} |
296 |
} |
297 |
|
298 |
List entries = new ArrayList() |
299 |
def cont = "" |
300 |
|
301 |
if(params['all_cb']) { |
302 |
def c = LoggedData.createCriteria()
|
303 |
entries = c { |
304 |
and { |
305 |
between("dateRecieved",params['fromDate'],params['tillDate']) |
306 |
} |
307 |
order("dateRecieved","asc") |
308 |
} |
309 |
} else {
|
310 |
if(checkedDevices.size > 0) { |
311 |
def c = LoggedData.createCriteria()
|
312 |
entries = c { |
313 |
and { |
314 |
between("dateRecieved",params['fromDate'],params['tillDate']) |
315 |
'in'("deviceId",checkedDevices) |
316 |
} |
317 |
order("dateRecieved","asc") |
318 |
} |
319 |
} |
320 |
} |
321 |
|
322 |
if(entries.size == 0) { |
323 |
flash['errors'] = "<p>Nothing to clear!</p><p>There are no log entries for selected devices in the time interval specified.</p>" |
324 |
} else {
|
325 |
def entCleared = 0 |
326 |
entries.each { |
327 |
it.delete()
|
328 |
entCleared++ |
329 |
} |
330 |
flash['confirms'] = "<p>" + entCleared + " log entries succesfully cleared!</p>" |
331 |
} |
332 |
redirect(action:'clear') |
333 |
|
334 |
} |
335 |
|
336 |
} |