1 <#-- |
|
2 ============================================================================ |
|
3 Name : bmd.macros.xml.ftl |
|
4 Part of : Helium |
|
5 |
|
6 Copyright (c) 2009 Nokia Corporation and/or its subsidiary(-ies). |
|
7 All rights reserved. |
|
8 This component and the accompanying materials are made available |
|
9 under the terms of the License "Eclipse Public License v1.0" |
|
10 which accompanies this distribution, and is available |
|
11 at the URL "http://www.eclipse.org/legal/epl-v10.html". |
|
12 |
|
13 Initial Contributors: |
|
14 Nokia Corporation - initial contribution. |
|
15 |
|
16 Contributors: |
|
17 |
|
18 Description: |
|
19 |
|
20 ============================================================================ |
|
21 --> |
|
22 |
|
23 <#macro helium_scanlog_entry > |
|
24 <style type="text/css"> |
|
25 <#include "log3.css"/> |
|
26 </style> |
|
27 <script type="text/javascript"> |
|
28 <#include "expand3.js"/> |
|
29 </script> |
|
30 </#macro> |
|
31 |
|
32 <#assign table_info = pp.loadData('com.nokia.helium.metadata.SQLFMPPLoader', |
|
33 "${dbPath}") > |
|
34 <html> |
|
35 <body> |
|
36 <h1>Summary</h1> |
|
37 <table> |
|
38 <#assign priority_table = table_info['select * from priority'] > |
|
39 <#assign component_table = table_info['select id, component from component'] > |
|
40 <#assign logpath_table = table_info['select * from logfiles'] > |
|
41 <#assign priority_ids = priority_table?keys> |
|
42 <tr><td>Total </td> |
|
43 <#assign quotes='\'' /> |
|
44 <#list priority_ids as priority> |
|
45 <td>${priority_table['${priority}']} |
|
46 ${table_info['select count(data) as COUNT from metadata where priority_id=${priority}'][0]['COUNT']}</td> |
|
47 </#list> |
|
48 </tr> |
|
49 </table> |
|
50 <h1>Listing based on Priority</h1> |
|
51 <table> |
|
52 <#list priority_ids as priority> |
|
53 <tr><td>priority_id:${priority} </td> |
|
54 <tr><td> </td></tr> |
|
55 <tr><td><h3>${priority_table['${priority}']}</h3></td></tr> |
|
56 |
|
57 <#list table_info['select * from metadata where priority_id=${priority}'] as recordentry > |
|
58 <tr><td>logtext:${recordentry['data']} </td> |
|
59 <td>lineNo:${recordentry['line_number']} </td></tr> |
|
60 </#list> |
|
61 </#list> |
|
62 </table> |
|
63 <h1>Listing based on Component</h1> |
|
64 <table> |
|
65 <#assign component_ids = component_table?keys> |
|
66 <#list component_ids as component> |
|
67 <tr><td> </td></tr> |
|
68 <tr><td><h3>${component_table['${component}']}</h3></td></tr> |
|
69 <#list table_info['select * from metadata where component_id=${component} order by priority_id'] as recordentry > |
|
70 <tr><td>priority:${priority_table["${recordentry['priority_id']}"]} </td> |
|
71 <td>logtext:${recordentry['data']} </td> |
|
72 <td>lineNo:${recordentry['line_number']} </td></tr> |
|
73 </#list> |
|
74 </#list> |
|
75 </table> |
|
76 </body> |
|
77 </html> |
|