Oracle NetSuite Advanced PDF模板是否具有“分组依据"?和"SUM"；功能? [英] Does Oracle NetSuite Advanced PDF Template have "Group by" and "SUM" Functions?

问题描述

重复的问题，对不起……

duplicated question, sorry......

推荐答案

如果您可以在将数据传递给freemarker之前进行处理/分组，那么情况会更好.但是，如果您要进行扩展标准交易表格之类的事情，这不是一个简单的选择.

If you can do the processing/grouping prior to passing data to freemarker you are better off. However if you are doing something like extending the standard transaction forms that isn't a simple option.

您可以使用序列操作来模拟分组. (请参见 http://freemarker.org/docs/ref_builtins_sequence.html )

You can simulate grouping by using sequence operations. (see http://freemarker.org/docs/ref_builtins_sequence.html)

然后:

<#assign seen_style = []>
<#list record.item?sort_by('custcol_style') as lineitem>
    <#assign lineStyle = lineitem.custcol_style>
    <#if seen_style?seq_contains(lineStyle)>
    <#else>
        <#assign seen_style = seen_style + [lineStyle]>
        <#assign styleTotal = 0>
        <#list record.item?sort_by('custcol_size') as styleItem>
           <#if lineStyle == styleItem.custcol_style>
              <#assign styleTotal = styleTotal + styleItem.quantity>
          </if>
        </#list>
       <div>${lineStyle} has ${styleTotal}</div>
   </#if>
</#list>

这篇关于Oracle NetSuite Advanced PDF模板是否具有“分组依据"?和"SUM"；功能?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！