能否给一个与视图对接的脚本示例？

【myApps/OBPM版本号】：v4.4- sp23
【浏览器类型】：Chrome/其他
【联系方式-QQ】：
【联系电话】:
【问题描述】：能否给一个与视图对接的脚本示例？

【解决方法】：

1. (function(){
   
2. var FontBuilder = Packages.net.sf.dynamicreports.report.builder.style.FontBuilder;
   
3. var DynamicReports = Packages.net.sf.dynamicreports.report.builder.DynamicReports;
   
4. var Templates = Packages.cn.myapps.report.examples.Templates;
   
5. var TextColumnBuilder = Packages.net.sf.dynamicreports.report.builder.column.TextColumnBuilder;
   
6. var DRDataSource = Packages.net.sf.dynamicreports.report.datasource.DRDataSource;
   
7. var DRException = Packages.net.sf.dynamicreports.report.exception.DRException;
   
8. var JRDataSource = Packages.net.sf.jasperreports.engine.JRDataSource;
   
9. var Calculation = Packages.net.sf.dynamicreports.report.constant.Calculation;
   
10. var PageType = Packages.net.sf.dynamicreports.report.constant.PageType;
    
11. var PageOrientation = Packages.net.sf.dynamicreports.report.constant.PageOrientation;
    
12. 
    
13. var BigDecimal = Packages.java.math.BigDecimal;
    
14. var Integer = Packages.java.lang.Integer;
    
15. var String = Packages.java.lang.String;
    
16. 
    
17. function createDataSource() {
    
18.         var dataSource = new DRDataSource("物料代码","物料名称","单位","单价","库存地","总金额","工厂", "数量");
    
19.         //var docid="__6jHaF7NmjDE3nqETmQ7";
    
20.         //var request = $WEB.getParamsTable().getHttpRequest();             
    
21.     //var session = request.getSession();            
    
22.     //var docid=session.getAttribute("getdocid");
    
23.   var docid =  new Packages.cn.myapps.util.cache.MemoryCacheUtil().getFromPrivateSpace("getdocid",getWebUser());
    
24. 
    
25.         var sql="select *,sum(item_Count) as item_zongshu,item_Sale*sum(item_Count) as item_AllMoney from tlk_Logistics_Scrap_Material where  parent='"+docid+"' group by item_SKUCode,item_StorageLocation,item_ConFactory order by item_SKUCode,item_StorageLocation,item_ConFactory";
    
26.         var domainid="11e6-20d4-4d46585f-89bc-6371125afd92";  
    
27.           var APPLICATIONID="11e6-20d4-12c9a888-89bc-6371125afd92";  
    
28.         var service = Packages.cn.myapps.designtime.common.service.DesignTimeServiceFactory.resolve("cn.myapps.designtime.datasource.service.DataSourceDesignTimeService");
    
29.         var datas =        service.queryDataSourceSQL("cunhuoBusiness",sql,APPLICATIONID);
    
30.         if(datas!=null){
    
31.                 for(var iterator = datas.iterator();iterator.hasNext();){
    
32.                         var data = iterator.next();
    
33.                         var skucode=data.get("item_SKUCode");
    
34.                         var StandardName=data.get("item_StandardName");
    
35.                         var StorageLocation=data.get("item_StorageLocation");
    
36.                         var ConFactory=data.get("item_ConFactory");
    
37.                         if(ConFactory==null||"".equals(ConFactory)){
    
38.                                 //(select item_ConFactoryName from tlk_ConFactory_Information where item_ConFactoryCode=item_ConFactory)item_ConFactoryName
    
39.                                 ConFactory=data.get("item_ConFactory");
    
40.                         }
    
41.                         var zongshu=data.get("item_zongshu");
    
42.                         var AllMoney=data.get("item_AllMoney");
    
43.                         var Sale=data.get("item_Sale");
    
44.                         var Unit=data.get("item_Unit");
    
45.                         dataSource.add(skucode,StandardName,Unit,Sale.toString(),StorageLocation,AllMoney.toString(),ConFactory,new BigDecimal(zongshu));
    
46.                 }
    
47.         }
    
48. 
    
49.         return dataSource;
    
50. }
    
51. 
    
52.                  var boldFont = DynamicReports.stl.fontArialBold().setFontSize(12);
    
53. 
    
54.                var rowGroup = DynamicReports.ctab.rowGroup("物料代码", String).setTotalHeader("总计").setHeaderWidth(100);
    
55.                  var rowGroup2 = DynamicReports.ctab.rowGroup("物料名称", String).setShowTotal(false).setHeaderWidth(250);
    
56.                  var rowGroup3 = DynamicReports.ctab.rowGroup("单位", String).setShowTotal(false).setHeaderWidth(100);
    
57.                  var rowGroup4 = DynamicReports.ctab.rowGroup("单价", String).setShowTotal(false).setHeaderWidth(100);
    
58.                  var rowGroup5 = DynamicReports.ctab.rowGroup("库存地", String).setShowTotal(false).setHeaderWidth(100);
    
59.                  var rowGroup6 = DynamicReports.ctab.rowGroup("总金额", String).setShowTotal(false).setHeaderWidth(100);
    
60. 
    
61.         var columnGroup = DynamicReports.ctab.columnGroup("工厂", String);
    
62. 
    
63.         var crosstab = DynamicReports.ctab.crosstab()
    
64.                                        .headerCell(DynamicReports.cmp.text("物料代码、物料名称、单位、单价、库存地、总金额 / 工厂").setStyle(Templates.boldCenteredStyle))
    
65.                                        .rowGroups(rowGroup,rowGroup2,rowGroup3,rowGroup4,rowGroup5,rowGroup6)
    
66.                                        .columnGroups(columnGroup)
    
67.                                        .measures(DynamicReports.ctab.measure("数量", "数量", BigDecimal, Calculation.SUM));
    
68. 
    
69. 
    
70. return DynamicReports.report().setPageFormat(PageType.A2, PageOrientation.LANDSCAPE)
    
71.                     .setTemplate(Templates.reportTemplate)
    
72.                     .title(Templates.createTitleComponent("定期报废物料统计报表"))
    
73.                     .summary(crosstab)
    
74.                     .pageFooter(Templates.footerComponent)
    
75.                     .setDataSource(createDataSource())
    
76.                
    
77. })();

复制代码