<% settings = @reportSettingsFromInfo(@reportInfo) %> <% fieldItems = @form.getReportItems() %> <% sumFields = @reportInfo.fields.filter( (f) -> f.sum ).map( (f) -> f.field ) %> <% minFields = @reportInfo.fields.filter( (f) -> f.min ).map( (f) -> f.field ) %> <% maxFields = @reportInfo.fields.filter( (f) -> f.max ).map( (f) -> f.field ) %> <% avgFields = @reportInfo.fields.filter( (f) -> f.avg ).map( (f) -> f.field ) %> <% groupFields = settings.reportGroupFields %> {BEGIN grid_row} <% for g, key in groupFields : %> {BEGIN <%- @goodFieldName( g.groupField ) %>_newgroup} [ <% for gg in ( groupFields.filter ( gg ) -> gg.groupOrder < g.groupOrder ) : %> { text: [''], style: 'group_<%- gg.groupOrder %>', }, <% end %> { colSpan: <%- fieldItems.length - g.groupOrder + 1 %>, text: ['<%- @fieldJSLabel( g.groupField ) %> ', {$<%- @goodFieldName( g.groupField ) %>_grval}], style: 'header_<%- g.groupOrder %>', } ], <% if key == groupFields.length - 1 :%> [ <% for gg in groupFields : %> { text: [''], style: 'group_<%- gg.groupOrder %>', }, <% end %> <% for item in fieldItems : %> <% if !(groupFields.filter ( d ) -> d.groupField == item.field ).length :%> { text: '<%- @fieldJSLabel( item.field ) %>', style: 'blackshade' }, <% end %> <% end %> ], <% end %> {END <%- @goodFieldName( g.groupField ) %>_newgroup} <% end %> <% if settings.showDetailsAndSummary :%> {BEGIN row_data} [ <% for g, key in groupFields : %> { <% if g.groupInterval :%> text: {$<%- @goodFieldName( g.groupField ) %>_value}, <% else :%> text: '', <% end %> style: 'group_<%- key + 1 %>', }, <% end %> <% for item in fieldItems : %> <% if !(groupFields.filter ( d ) -> d.groupField == item.field ).length :%> { text: {$<%- @goodFieldName( item.field ) %>_value}, alignment: '{$<%- @goodFieldName( item.field ) %>_align}', }, <% end %> <% end %> ], {END row_data} <% end %> <% for g, key in groupFields.slice().reverse() : %> <% if g.showGroupSummary || key == 0 || key == groupFields.length - 1 : %> {BEGIN <%- @goodFieldName( g.groupField ) %>_endgroup} <% if g.showGroupSummary : %> [ <% if groupFields.length - key - 1 > 0 :%> <% for idx in [1..(groupFields.length - key - 1)] : %> { text: [''], style: 'group_<%- idx %>', }, <% end %> <% end %> <% for item in ( fieldItems.filter (i) -> i.field == g.groupField ) : %> { colSpan:<%- fieldItems.length - g.groupOrder + 1 %>, text: ['<%- @message 'SUMMARY_FOR' %> <%- @fieldJSLabel( item.field ) %> ', {$<%- @goodFieldName( g.groupField ) %>_grval}, ' - ', {$group<%- @goodFieldName( g.groupField ) %>_total_cnt}, ' <%- @message 'RECORDS_TOTAL' %>'], style: 'group_<%- g.groupOrder %>', }, <% end %> ], <% end %> <% if sumFields.length && g.showGroupSummary : %> [ <% for item, ikey in fieldItems : %> <% fInfo = @reportInfo.field item.field %> { text: [ <% if item.field == g.groupField :%> '<%- @message 'SUM' %> ', <% else if fInfo && fInfo.sum :%> {$group<%- @goodFieldName( g.groupField ) %>_total<%- @goodFieldName( item.field ) %>_sum}, <% else :%> '' <% end %> ], <% if item.field == g.groupField || fInfo && fInfo.sum || ikey + 1 >= g.groupOrder : %> style: 'group_<%- g.groupOrder %>', <% else : %> style: 'group_<%- ikey + 1 %>', <% end %> <% if item.field != g.groupField && fInfo && fInfo.sum : %> alignment: '{$<%- @goodFieldName( item.field ) %>_align}', <% end %> }, <% end %> ], <% end %> <% if avgFields.length && g.showGroupSummary : %> [ <% for item, ikey in fieldItems : %> <% fInfo = @reportInfo.field item.field %> { text: [ <% if item.field == g.groupField :%> '<%- @message 'AVG' %> ', <% else if fInfo && fInfo.avg :%> {$group<%- @goodFieldName( g.groupField ) %>_total<%- @goodFieldName( item.field ) %>_avg}, <% else :%> '' <% end %> ], <% if item.field == g.groupField || fInfo && fInfo.avg || ikey + 1 >= g.groupOrder : %> style: 'group_<%- g.groupOrder %>', <% else : %> style: 'group_<%- ikey + 1 %>', <% end %> <% if item.field != g.groupField && fInfo && fInfo.avg : %> alignment: '{$<%- @goodFieldName( item.field ) %>_align}', <% end %> }, <% end %> ], <% end %> <% if minFields.length && g.showGroupSummary : %> [ <% for item, ikey in fieldItems : %> <% fInfo = @reportInfo.field item.field %> { text: [ <% if item.field == g.groupField :%> '<%- @message 'MIN' %> ', <% else if fInfo && fInfo.min :%> {$group<%- @goodFieldName( g.groupField ) %>_total<%- @goodFieldName( item.field ) %>_min}, <% else :%> '' <% end %> ], <% if item.field == g.groupField || fInfo && fInfo.min || ikey + 1 >= g.groupOrder : %> style: 'group_<%- g.groupOrder %>', <% else : %> style: 'group_<%- ikey + 1 %>', <% end %> <% if item.field != g.groupField && fInfo && fInfo.min : %> alignment: '{$<%- @goodFieldName( item.field ) %>_align}', <% end %> }, <% end %> ], <% end %> <% if maxFields.length && g.showGroupSummary : %> [ <% for item, ikey in fieldItems : %> <% fInfo = @reportInfo.field item.field %> { text: [ <% if item.field == g.groupField :%> '<%- @message 'MAX' %> ', <% else if fInfo && fInfo.max :%> {$group<%- @goodFieldName( g.groupField ) %>_total<%- @goodFieldName( item.field ) %>_max}, <% else :%> '' <% end %> ], <% if item.field == g.groupField || fInfo && fInfo.max || ikey + 1 >= g.groupOrder : %> style: 'group_<%- g.groupOrder %>', <% else : %> style: 'group_<%- ikey + 1 %>', <% end %> <% if item.field != g.groupField && fInfo && fInfo.max : %> alignment: '{$<%- @goodFieldName( item.field ) %>_align}', <% end %> }, <% end %> ], <% end %> {END <%- @goodFieldName( g.groupField ) %>_endgroup} <% end %> <% end %> {END grid_row} <% if settings.pageSummary || settings.reportGlobalSummary : %> [ <% for item in fieldItems : %> <% if (groupFields.filter ( d ) -> d.groupField == item.field ).length :%> { text: '<%- @fieldJSLabel( item.field ) %>', style: 'blackshade' }, <% end %> <% end %> <% for item in fieldItems : %> <% if !(groupFields.filter ( d ) -> d.groupField == item.field ).length :%> { text: '<%- @fieldJSLabel( item.field ) %>', alignment: '{$<%- @goodFieldName( item.field ) %>_align}', style: 'blackshade' }, <% end %> <% end %> ], <% end %> <%- include 'pdf/report-summary.htm', @ %>