<% settings = @reportSettingsFromInfo(@reportInfo) %> <% fieldItems = @form.getReportItems() %> <% totalTypes = [ {type: 'sum', label: 'SUM'} {type: 'avg', label: 'AVERAGE'} {type: 'min', label: 'MIN'} {type: 'max', label: 'MAX'} ] %> <% totalTypes = totalTypes.filter( (total) => @reportInfo.fields.some( (f) -> f[total.type] ) ) %> <% groupFields = settings.reportGroupFields %> {BEGIN grid_row} <% for itemId, key in @form.getReportGroupItemsIds() : %> <% item = @page.items[itemId] %> <% g = groupFields.find (d) -> d.groupField == item.field %> {BEGIN <%- @goodFieldName( g.groupField ) %>_newgroup} > <% for gg in ( groupFields.filter ( gg ) -> gg.groupOrder < g.groupOrder ) : %> <% end %> <% if key == groupFields.length - 1 :%> <% for gg in groupFields : %> <% end %> <% for item in fieldItems : %> <% if !(groupFields.filter ( d ) -> d.groupField == item.field ).length :%> <% end %> <% end %> <% end %> {END <%- @goodFieldName( g.groupField ) %>_newgroup} <% end %> <% if settings.showDetailsAndSummary :%> {BEGIN row_data} <% for itemId, key in @form.getReportGroupItemsIds() : %> <% item = @page.items[itemId] %> <% g = groupFields.find (d) -> d.groupField == item.field %> <% end %> <% for itemId in @form.getReportItemsIds() : %> <% item = @page.items[itemId] %> <% if !(groupFields.filter ( d ) -> d.groupField == item.field ).length :%> <% 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 groupFields.length - key - 1 > 0 :%> <% for idx in [1..(groupFields.length - key - 1)] : %> <% end %> <% end %> <% for item in ( fieldItems.filter ( i ) -> i.field == g.groupField ) : %> <% end %> <% for total in totalTypes : %> > <% for item, ikey in fieldItems : %> <% fInfo = @reportInfo.field item.field %> <% isGroupField = groupFields.some( (gg) -> gg.groupField == item.field ) %> <% if item.field == g.groupField : %> <% else if fInfo && fInfo[total.type] : %> <% else if ikey + 1 < g.groupOrder :%> <% else :%> <% end %> <% end %> <% end %> {END <%- @goodFieldName( g.groupField ) %>_endgroup} <% end %> <% end %> {END grid_row} <%- include 'forms/report-summary.htm', @ %>
  <%= @fieldLabel( g.groupField ) %>:  <% @setProp("id",@props.id + 1) %> <%- include 'items/report_group_field.htm', @addItem( itemId ) %>
 <%= @fieldLabel( item.field) %>
<% if g.groupInterval :%> <%- include 'items/report_grid_field.htm', @addItem( itemId ) %> <% else :%>   <% end %> <%- include 'items/report_grid_field.htm', @addItem( itemId ) %>
headers="{$groupcellheaders_<%- @goodFieldName(g.groupField) %>}" > <%= @message 'SUMMARY_FOR' %> <%= @fieldLabel( item.field ) %> {$<%- @goodFieldName( g.groupField ) %>_grval} - {$group<%- @goodFieldName( g.groupField )%>_total_cnt} <%= @message 'RECORDS_TOTAL' %>
<%= @message total.label %> {$group<%- @goodFieldName( g.groupField ) %>_total<%- @goodFieldName( item.field ) %>_<%- total.type %>}