<% 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} <% if key == 0 : %> [ <% for item in fieldItems : %> <% if (groupFields.filter ( d ) -> d.groupField == item.field ).length > 0 :%> { text: '<%= @fieldJSLabel( item.field ) %>', style: "blackshade", alignment: '{$<%- @goodFieldName( item.field ) %>_align}', }, <% end %> <% end %> <% for item in fieldItems : %> <% if !(groupFields.filter ( d ) -> d.groupField == item.field ).length :%> { text: '<%= @fieldJSLabel( item.field ) %>', style: "blackshade", alignment: '{$<%- @goodFieldName( item.field ) %>_align}', }, <% end %> <% end %> ], <% end %> [ <% for gg, ggkey in groupFields : %> <% if g.groupField == gg.groupField :%> <% if ggkey == groupFields.length - 1 :%> { colSpan: <%- fieldItems.length - g.groupOrder + 1 %>, text: {$<%- @goodFieldName( g.groupField ) %>_grval}, style:"header_<%- g.groupOrder %>" }, <% else :%> { colSpan: <%- fieldItems.length - g.groupOrder + 1 %>, text: {$<%- @goodFieldName( g.groupField ) %>_grval}, style: "header_<%- g.groupOrder %>" }, <% end %> <% else if gg.groupOrder < g.groupOrder :%> { text: '', style: "group_<%- gg.groupOrder %>" }, <% end %> <% end %> ], {END <%- @goodFieldName( g.groupField ) %>_newgroup} <% end %> <% if settings.showDetailsAndSummary : %> {BEGIN row_data} [ <% for g, key in groupFields : %> { text: [ <% if g.groupInterval :%> {$<%- g.groupField %>_value} <% else :%> '' <% 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 : %> <% if item.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 %> ], <% end %> <% if sumFields.length && g.showGroupSummary : %> [ <% for item, ikey in fieldItems : %> <% fInfo = @reportInfo.field item.field %> <% if item.field == g.groupField : %> { text: "<%= @message 'SUM' %>", style: "group_<%- g.groupOrder %>" }, <% else if fInfo && fInfo.sum : %> { text: {$group<%- @goodFieldName( g.groupField ) %>_total<%- @goodFieldName( item.field ) %>_sum}, style: "group_<%- g.groupOrder %>", alignment: '{$<%- @goodFieldName( item.field ) %>_align}', }, <% else if ikey + 1 < g.groupOrder :%> { text: '', style: "group_<%- ikey + 1 %>" }, <% else :%> { text: '', style: "group_<%- g.groupOrder %>" }, <% end %> <% end %> ], <% end %> <% if avgFields.length && g.showGroupSummary : %> [ <% for item, ikey in fieldItems : %> <% fInfo = @reportInfo.field item.field %> <% if item.field == g.groupField : %> { text: "<%= @message 'AVERAGE' %>", style: "group_<%- g.groupOrder %>" }, <% else if fInfo && fInfo.avg : %> { text: {$group<%- @goodFieldName( g.groupField ) %>_total<%- @goodFieldName( item.field ) %>_avg}, style: "group_<%- g.groupOrder %>", alignment: '{$<%- @goodFieldName( item.field ) %>_align}', }, <% else if ikey + 1 < g.groupOrder :%> { text: '', style: "group_<%- ikey + 1 %>" }, <% else :%> { text: '', style: "group_<%- g.groupOrder %>" }, <% end %> <% end %> ], <% end %> <% if minFields.length && g.showGroupSummary : %> [ <% for item, ikey in fieldItems : %> <% fInfo = @reportInfo.field item.field %> <% if item.field == g.groupField : %> { text: "<%= @message 'MIN' %>", style: "group_<%- g.groupOrder %>" }, <% else if fInfo && fInfo.min : %> { text: {$group<%- @goodFieldName( g.groupField ) %>_total<%- @goodFieldName( item.field ) %>_min}, style: "group_<%- g.groupOrder %>", alignment: '{$<%- @goodFieldName( item.field ) %>_align}', }, <% else if ikey + 1 < g.groupOrder :%> { text: '', style: "group_<%- ikey + 1 %>" }, <% else :%> { text: '', style: "group_<%- g.groupOrder %>" }, <% end %> <% end %> ], <% end %> <% if maxFields.length && g.showGroupSummary : %> [ <% for item, ikey in fieldItems : %> <% fInfo = @reportInfo.field item.field %> <% if item.field == g.groupField : %> { text: "<%= @message 'MAX' %>", style: "group_<%- g.groupOrder %>" }, <% else if fInfo && fInfo.max : %> { text: {$group<%- @goodFieldName( g.groupField ) %>_total<%- @goodFieldName( item.field ) %>_max}, style: "group_<%- g.groupOrder %>", alignment: '{$<%- @goodFieldName( item.field ) %>_align}', }, <% else if ikey + 1 < g.groupOrder :%> { text: '', style: "group_<%- ikey + 1 %>" }, <% else :%> { text: '', style: "group_<%- g.groupOrder %>" }, <% end %> <% end %> ], <% end %> {END <%- @goodFieldName( g.groupField ) %>_endgroup} <% end %> <% end %> {END grid_row} <%- include 'pdf/report-summary.htm', @ %>