<% 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 %> <% groupFieldsNames = groupFields.map (g) -> g.groupField %> <% notGroupItems = fieldItems.filter ( i ) -> ( groupFieldsNames.indexOf( i.field ) == -1 ) %> {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} > <% if key == groupFields.length - 1 :%> <% 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 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} > <% for item in ( fieldItems.filter (i) -> i.field == g.groupField ) : %> <% end %> <% for total in totalTypes : %> <% totalHeaderId = total.type + '{$groupcellid_' + @goodFieldName(g.groupField) + '}' %> > <% for item, ikey in notGroupItems : %> <% fInfo = @reportInfo.field item.field %> <% cellTag = if ikey == 0 then 'th' else 'td' %> <<%- cellTag %> class="group_<%- g.groupOrder %><% if fInfo && fInfo[total.type] && ikey != 0 :%> {$fieldclass_<%- @goodFieldName(item.field) %>}<% end %>" <% if ikey == 0 :%>id="<%- totalHeaderId %>"<% end %> headers="{$groupcellheaders_<%- @goodFieldName(g.groupField) %>} {$groupcellid_<%- @goodFieldName(g.groupField) %>}<%- if ikey != 0 then ' ' + totalHeaderId %><%- if fInfo && fInfo[total.type] then ' field_header_' + @goodFieldName(item.field) %>" > <% if ikey == 0 :%> <%= @message total.label %> <% end %>   <% if fInfo && fInfo[total.type] : %> {$group<%- @goodFieldName( g.groupField ) %>_total<%- @goodFieldName( item.field ) %>_<%- total.type %>} <% end %> > <% end %> <% end %> {END <%- @goodFieldName( g.groupField ) %>_endgroup} <% end %> <% end %> {END grid_row} <%- include 'forms/report-summary.htm', @ %>
<%= @fieldLabel( g.groupField ) %>:  {$x<%- @goodFieldName( g.groupField ) %>_grval} <%- include 'items/report_group_field.htm', @addItem( itemId ) %>
<%= @fieldLabel( item.field ) %>
{$x<%- @goodFieldName( item.field ) %>_value} <%- include 'items/report_grid_field.htm', @addItem( itemId ) %>
<%= @message 'SUMMARY_FOR' %> <%= @fieldLabel( item.field ) %> {$<%- @goodFieldName( g.groupField ) %>_grval} - {$group<%- @goodFieldName( g.groupField ) %>_total_cnt} <%= @message 'RECORDS_TOTAL' %>