buildframework/helium/tools/common/templates/log/cc_summary_metadata_orm.html.ftl
changeset 587 85df38eb4012
parent 217 0f5e3a7fb6af
child 588 c7c26511138f
equal deleted inserted replaced
217:0f5e3a7fb6af 587:85df38eb4012
    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 
       
    46 <#assign metadata_ccm_records = table_info['native']['select * from metadataentry where logpath_id = ${logpath} and (priority_id in (select id from priority where priority=\'ERROR\')  or priority_id in (select id from priority where priority=\'WARNING\'))'] >
       
    47 <h2>Synergy errors</h2>
    45 <h2>Synergy errors</h2>
    48     <p>
    46     <p>
    49     <#list table_info['native:com.nokia.helium.jpa.entity.metadata.MetadataEntry']['select * from metadataentry INNER JOIN priority ON priority.priority_id=metadataentry.priority_id where metadateentry.logpath_id=${logfile.id} and (UPPER(priority.priority) like \'ERROR\' OR UPPER(priority.priority) like \'WARNING\''] as entry >    
    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 >
    50         ${entry.text}
    48         ${entry.text}<br/>
    51     </#list>
    49     </#list>
    52     </p>
    50     </p>
    53 </#list>
    51 </#list>
    54 
    52 
    55 <h2>Build errors</h2>
    53 <#list table_info['jpa']['select l from LogFile l where LOWER(l.path) like \'%_compile.log\' and LOWER(l.path) not like \'%_clean_%compile.log\''] as logfile>
    56 <#list table_info['jpa']['select l from LogFile l where LOWER(l.path) like \'%_compile.log\' and path not like \'%_clean_compile.log\''] as logfile>
    54 <h2>Build errors (${logfile.path})</h2>
    57 <#assign colors = {'error': 'FF0000', 'critical': 'FF7000', 'warning': 'FFF000', 'remark': '0000FF'}/>
    55 <#assign colors = {'error': 'FF0000', 'critical': 'FF7000', 'warning': 'FFF000', 'remark': '0000FF'}/>
    58 
    56 
    59 <table border="1" cellpadding="0" cellspacing="0" width="100%">
    57 <table border="1" cellpadding="0" cellspacing="0" width="100%">
    60 <tr>
    58 <tr>
    61     <th width="55%">Component</th>
    59     <th width="55%">Component</th>
    62     <th width="15%">Errors</th>
    60     <th width="15%">Errors</th>
    63     <th width="15%">Criticals</th>
    61     <th width="15%">Criticals</th>
    64     <th width="15%">Warnings</th>
    62     <th width="15%">Warnings</th>
    65     <th width="15%">Notes</th>
    63     <th width="15%">Notes</th>
    66 </tr>
    64 </tr>
    67     <#assign component_table = table_info['select id, component from component where logPath_id=${logpath}'] >
       
    68     <#assign component_ids = component_table?keys?sort >
       
    69 
    65 
    70 <#list table_info['jpa']['select c from Component c where c.logpathID=${logpath.id} ORDERBY component'] as component>
    66 <#list table_info['jpa']['select c from Component c where c.logPathID=${logfile.id} ORDER BY c.component'] as component>
    71 <tr>
    67 <tr>
    72 <td>"${component.id}"</td>
    68 <td>${component.component}</td>
    73     <#list colors?keys as type>
    69     <#list colors?keys as type>
    74          <#assign count =  table_info['jpasingle']['select count(m.id) from MetadataEntry as m JOIN  m.priority as p where (UPPER(p.priority) like \'%${type?upper_case}%\' and M.componentId=${component.id}'][0] >    
    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] >    
    75         <#if ( count?number &gt; 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 w.missing=\'true\''][0]> 
       
    73             <#assign count = count?number + count_missing?number>
       
    74         </#if>
       
    75         <#if (count?number > 0)>
    76 <td align="center" bgcolor="#${colors[type]}">${count}</td>
    76 <td align="center" bgcolor="#${colors[type]}">${count}</td>
    77         <#else>
    77         <#else>
    78 <td align="center">0</td>
    78 <td align="center">0</td>
    79         </#if>
    79         </#if>
    80     </#list>
    80     </#list>
    81 </tr>
    81 </tr>
    82 </#list>
    82 </#list>
       
    83 </table>
    83 </#list>
    84 </#list>
    84 </table>
       
    85 
    85 
    86 <#list table_info['jpa']['select l from LogFile l where LOWER(l.path) like \'%roms.log\''] as logfile>
    86 <#list table_info['jpa']['select l from LogFile l where LOWER(l.path) like \'%roms.log\''] as logfile>
    87     <h2>ROMs ${logfile.path}</h2>
    87     <h2>ROMs ${logfile.path}</h2>
    88         <p>
    88         <p>
    89     <#list table_info['native:com.nokia.helium.jpa.entity.metadata.MetadataEntry']['select * from metadataentry where m.logpathId=${logfile.id}'] as entry >
    89     <#list table_info['native:com.nokia.helium.jpa.entity.metadata.MetadataEntry']['select * from metadataentry m where m.logpath_id=${logfile.id}'] as entry >
    90         ${entry.text}<br/>
    90         ${entry.text}<br/>
    91     </#list>
    91     </#list>
    92         </p>
    92         </p>
    93 </#list>
    93 </#list>
    94 
    94 
    95 <#list table_info['jpa']['select l from LogFile l where LOWER(l.path) like \'%validate_policy.xml\''] as logfile>
    95 <#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>
    96 <h2>Distribution Policy validation</h2>
    97         <p>
    97         <p>
    98         <#list table_info['native:com.nokia.helium.jpa.entity.metadata.MetadataEntry']['select * from metadataentry where m.logpathId=${logfile.id}'] as entry >
    98         <#list table_info['native:com.nokia.helium.jpa.entity.metadata.MetadataEntry']['select * from metadataentry m where m.logpath_id=${logfile.id}'] as entry >
    99             ${entry.text}<br/>
    99             ${entry.text}<br/>
   100         </#list>
   100         </#list>
   101         </p>
   101         </p>
   102 </#list>
   102 </#list>
   103 
   103