buildframework/helium/tools/common/templates/log/cc_summary_metadata_orm.html.ftl
changeset 628 7c4a911dc066
parent 588 c7c26511138f
equal deleted inserted replaced
588:c7c26511138f 628:7c4a911dc066
    23     <#assign table_info = pp.loadData('com.nokia.helium.metadata.ORMFMPPLoader',
    23     <#assign table_info = pp.loadData('com.nokia.helium.metadata.ORMFMPPLoader',
    24         "${dbPath}") >
    24         "${dbPath}") >
    25  
    25  
    26 <h1>${ant['build.id']}</h1>
    26 <h1>${ant['build.id']}</h1>
    27 
    27 
    28 <#if ant?keys?seq_contains('publish')>
    28 <#if ant?keys?seq_contains('publish.enabled') || ant?keys?seq_contains('publish')>
    29     <#if ant?keys?seq_contains('publish.dir.list')>
    29     <#if ant?keys?seq_contains('publish.dir.list')>
    30         <h2>Publish locations</h2>
    30         <h2>Publish locations</h2>
    31         <p>
    31         <p>
    32         <#list ant['publish.dir.list']?split(',') as site>
    32         <#list ant['publish.dir.list']?split(',') as site>
    33           <a href="${site}">${site}</a></br>
    33           <a href="${site}">${site}</a></br>
    39         <p><a href="${ant['publish.dir']}">${ant['publish.dir']}</a></p>
    39         <p><a href="${ant['publish.dir']}">${ant['publish.dir']}</a></p>
    40         </#if>
    40         </#if>
    41     </#if>
    41     </#if>
    42 </#if>
    42 </#if>
    43 
    43 
    44 <#list table_info['jpa']['select l from LogFile l where LOWER(l.path) like \'%_ccm_get_input.log%\''] as logfile>
    44 <#list table_info['jpa']['select l from LogFile l where LOWER(l.path) like \'%_ccm_get_input.log\''] as logfile>
    45 <h2>Synergy errors</h2>
    45 <h2>Synergy errors</h2>
    46     <p>
    46     <p>
    47     <#list table_info['native:com.nokia.helium.jpa.entity.metadata.MetadataEntry']['select * from metadataentry m INNER JOIN priority p ON p.priority_id=m.priority_id where m.logpath_id=${logfile.id} and ( UPPER(p.priority) like \'ERROR\' or UPPER(p.priority) like \'WARNING\' )'] as entry >
    47     <#list table_info['jpa']['select m from MetadataEntry m JOIN m.severity p where m.logFileId=${logfile.id} and (p.severity=\'ERROR\' or p.severity=\'WARNING\' )'] as entry>
    48         ${entry.text}<br/>
    48         ${entry.text}<br/>
    49     </#list>
    49     </#list>
    50     </p>
    50     </p>
    51 </#list>
    51 </#list>
    52 
    52 
    61     <th width="15%">Criticals</th>
    61     <th width="15%">Criticals</th>
    62     <th width="15%">Warnings</th>
    62     <th width="15%">Warnings</th>
    63     <th width="15%">Notes</th>
    63     <th width="15%">Notes</th>
    64 </tr>
    64 </tr>
    65 
    65 
    66 <#list table_info['jpa']['select c from Component c where c.logPathID=${logfile.id} ORDER BY c.component'] as component>
    66 <#list table_info['jpa']['select c from Component c where c.logFileId=${logfile.id} ORDER BY c.component'] as component>
    67 <tr>
    67 <tr>
    68 <td>${component.component}</td>
    68 <td>${component.component}</td>
    69     <#list colors?keys as type>
    69     <#list colors?keys as type>
    70         <#assign count =  table_info['jpasingle']['select count(m.id) from MetadataEntry m JOIN  m.priority as p JOIN m.component as c where (UPPER(p.priority)=\'${type?upper_case}\' and c.id=${component.id})'][0] >    
    70         <#assign count =  table_info['jpasingle']['select count(m.id) from MetadataEntry m JOIN  m.severity as p JOIN m.component as c where (p.severity=\'${type?upper_case}\' and c.id=${component.id})'][0] >    
    71         <#if type=='error'>
       
    72             <#assign count_missing = table_info['jpasingle']['select count(w.id) from WhatLogEntry w JOIN w.component c where c.logPathID=${logfile.id} and c.id=${component.id} and w.missing=\'true\''][0]> 
       
    73             <#assign count = count?number + count_missing?number>
       
    74         </#if>
       
    75         <#if (count?number > 0)>
    71         <#if (count?number > 0)>
    76 <td align="center" bgcolor="#${colors[type]}">${count}</td>
    72 <td align="center" bgcolor="#${colors[type]}">${count}</td>
    77         <#else>
    73         <#else>
    78 <td align="center">0</td>
    74 <td align="center">0</td>
    79         </#if>
    75         </#if>
    84 </#list>
    80 </#list>
    85 
    81 
    86 <#list table_info['jpa']['select l from LogFile l where LOWER(l.path) like \'%roms.log\''] as logfile>
    82 <#list table_info['jpa']['select l from LogFile l where LOWER(l.path) like \'%roms.log\''] as logfile>
    87     <h2>ROMs ${logfile.path}</h2>
    83     <h2>ROMs ${logfile.path}</h2>
    88         <p>
    84         <p>
    89     <#list table_info['native:com.nokia.helium.jpa.entity.metadata.MetadataEntry']['select * from metadataentry m where m.logpath_id=${logfile.id}'] as entry >
    85     <#list table_info['jpa']['select m from MetadataEntry m where m.logFileId=${logfile.id}'] as entry>
    90         ${entry.text}<br/>
    86         ${entry.text}<br/>
    91     </#list>
    87     </#list>
    92         </p>
    88         </p>
    93 </#list>
    89 </#list>
    94 
    90 
    95 <#list table_info['jpa']['select l from LogFile l where LOWER(l.path) like \'%validate-policy.summary.xml\''] as logfile>
    91 <#list table_info['jpa']['select l from LogFile l where LOWER(l.path) like \'%validate-policy.summary.xml\''] as logfile>
    96 <h2>Distribution Policy validation</h2>
    92 <h2>Distribution Policy validation</h2>
    97         <p>
    93         <p>
    98         <#list table_info['native:com.nokia.helium.jpa.entity.metadata.MetadataEntry']['select * from metadataentry m where m.logpath_id=${logfile.id}'] as entry >
    94         <#list table_info['jpa']['select m from MetadataEntry m where m.logFileId=${logfile.id}'] as entry>
    99             ${entry.text}<br/>
    95             ${entry.text}<br/>
   100         </#list>
    96         </#list>
   101         </p>
    97         </p>
   102 </#list>
    98 </#list>
   103 
    99