使用aggregate报错

爱我刺鳌 · 发表于 2014-4-14 16:03:51

本帖最后由爱我刺鳌于 2014-4-14 17:44 编辑

错误代码：
Cannot set property 'innerHTML' of null
TypeError: Cannot set property 'innerHTML' of null
at mainActivity.MasterInAfterRefresh (http://localhost:8080/x5/$v829b5a6ccbb54838ae45c0ff2cfb441c/UI/production/trainSubsystem/tjCx/jchlch_shaohf/QueryTrainIO/process/TrainIOQuery2/mainActivity.js?language=zh_CN:763:55)
at z [as ev_onafterrefresh] (http://localhost:8080/x5/$vb8c2489b861b452ebd490a8251fb314b/form/form.js?language=zh_CN:1:287448)
at obj.(anonymous function) [as callEvent] (http://localhost:8080/x5/$vb8c2489b861b452ebd490a8251fb314b/form/form.js?language=zh_CN:1:287175)
at null.refreshData (http://localhost:8080/x5/$vdf3431fcc35740cfb540fcc1a12c0763/component/data/data.js?language=zh_CN:1:5453)
at Object.mainActivity.trigger1Click (http://localhost:8080/x5/$v829b5a6ccbb54838ae45c0ff2cfb441c/UI/production/trainSubsystem/tjCx/jchlch_shaohf/QueryTrainIO/process/TrainIOQuery2/mainActivity.js?language=zh_CN:188:11)
at Object.mainActivity.model1Load (http://localhost:8080/x5/$v829b5a6ccbb54838ae45c0ff2cfb441c/UI/production/trainSubsystem/tjCx/jchlch_shaohf/QueryTrainIO/process/TrainIOQuery2/mainActivity.js?language=zh_CN:678:15)
at null.callFunction (http://localhost:8080/x5/$v3db52694bfa3464b867cc1c08c9361be/UI/production/trainSubsystem/tjCx/jchlch_shaohf/QueryTrainIO/process/TrainIOQuery2/.cache/mainActivity_zh_CN_x5_6204369e77ef4391801004f8162f21b8.js?language=zh_CN&$version=92cca371-ab02-472d-a37c-4a65350bb0dd:861:120)
at null.run (http://localhost:8080/x5/$vb8c2489b861b452ebd490a8251fb314b/form/form.js?language=zh_CN:1:386415)
at null.exec_ (http://localhost:8080/x5/$vb8c2489b861b452ebd490a8251fb314b/form/form.js?language=zh_CN:1:308283)
at null.execute (http://localhost:8080/x5/$vb8c2489b861b452ebd490a8251fb314b/form/form.js?language=zh_CN:1:289847)

aggregate值
sum(BT_JCHLCH1.LSH) AS sumLSH,
sum(BT_JCHLCH1.ZHCH) AS sumZHCH,
sum(BT_JCHLCH1.KCH) AS sumKCH,
sum(BT_JCHLCH1.MCH) AS sumMCH,
sum(BT_JCHLCH1.ZCH) AS sumZCH,
sum(BT_JCHLCH1.ZZH) AS sumZZH,
sum(BT_JCHLCH1.DDMD) AS sumDDMD,
sum(BT_JCHLCH1.ZHD) AS sumZHD,
sum(BT_JCHLCH1.DZHCH) AS sumDZHCH,
sum(BT_JCHLCH1.JKCH) AS sumJKCH,
sum(BT_JCHLCH1.HPCH) AS sumHPCH,
sum(BT_JCHLCH1.HBSH) AS sumHBSH,
sum(BT_JCHLCH1.ZHXCH) AS sumZHXCH,
sum(BT_JCHLCH1.ZHLCH) AS sumZHLCH,
sum(BT_JCHLCH1.ZHBCH) AS sumZHBCH,
sum(BT_JCHLCH1.HTLYCH) AS sumHTLYCH

bizData刷新之后
/**
 name:bizData#onAfterRefresh
 description: [回调型事件]业务数据刷新后
 @param {object} event
 结构如下：
 <xmp>
 {
 "source" : 组件的js对象
 }
 </xmp>
*/
mainActivity.MasterInAfterRefresh = function(event){
 var main = justep.xbl("MasterIn");
 document.getElementById("sumLSH").innerHTML = main.getAggregateValue("sumLSH");
 document.getElementById("sumZHCH").innerHTML = main.getAggregateValue("sumZHCH");
 document.getElementById("sumKCH").innerHTML = main.getAggregateValue("sumKCH");
 document.getElementById("sumMCH").innerHTML = main.getAggregateValue("sumMCH");
 document.getElementById("sumZCH").innerHTML = main.getAggregateValue("sumZCH");
 document.getElementById("sumZZH").innerHTML = main.getAggregateValue("sumZZH");
 document.getElementById("sumDDMD").innerHTML = main.getAggregateValue("sumDDMD");
 document.getElementById("sumZHD").innerHTML = main.getAggregateValue("sumZHD");
 document.getElementById("sumDZHCH").innerHTML = main.getAggregateValue("sumDZHCH");
 document.getElementById("sumJKCH").innerHTML = main.getAggregateValue("sumJKCH");
 document.getElementById("sumHPCH").innerHTML = main.getAggregateValue("sumHPCH");
 document.getElementById("sumHBSH").innerHTML = main.getAggregateValue("sumHBSH");
 document.getElementById("sumZHXCH").innerHTML = main.getAggregateValue("sumZHXCH");
 document.getElementById("sumZHLCH").innerHTML = main.getAggregateValue("sumZHLCH");
 document.getElementById("sumZHBCH").innerHTML = main.getAggregateValue("sumZHBCH");
 document.getElementById("sumHTLYCH").innerHTML = main.getAggregateValue("sumHTLYCH");
};

grid的init事件
/**
 name:grid#onInit
 description: 表格初始化时
 @param {object} event 
 参数结构：
 <xmp>
 {
 "source" : XFGrid对象,
 "grid" : dhtmlxGrid对象
 }
 </xmp>
*/
mainActivity.grid2Init = function(event){
 this.grid.attachFooter("合计,#cspan,#cspan," +
 "时间," +
 " ," +
 " ,"+
 " ,"+
 " ,"+
 " ,"+
 " ,"+
 " ,"+
 " ,"+
 " ,"+
 " ,"+
 " ,"+
 " "
 );
};

jishuang · 发表于 2014-4-14 17:03:49

参考http://bbs.justep.com/forum.php?mod=viewthread&tid=39784中的写法

爱我刺鳌 · 发表于 2014-4-14 17:45:46

jishuang 发表于 2014-4-14 17:03
参考http://bbs.justep.com/forum.php?mod=viewthread&tid=39784中的写法

看我最后那张图片，grid里面设定了几个隐藏列，在特定情况下显示。当隐藏的时候，数据有问题，成组情况一列下面应该是空的才对。。而且数据好像也不是下一列的。。

爱我刺鳌 · 发表于 2014-4-14 17:49:58

jishuang 发表于 2014-4-14 17:03
参考http://bbs.justep.com/forum.php?mod=viewthread&tid=39784中的写法

杂货吨一列结果不应该是70，实际是16.。

爱我刺鳌 · 发表于 2014-4-14 17:53:34

本帖最后由爱我刺鳌于 2014-4-14 17:55 编辑

jishuang 发表于 2014-4-14 17:03
参考http://bbs.justep.com/forum.php?mod=viewthread&tid=39784中的写法

感觉就是后两列必须要显示，隐藏了后面几列，后两列的求和就把前面的求和掩盖掉了。。70和9这俩之一直占据右下角两个格子，无论对应的列有没有列被隐藏或显示。

爱我刺鳌 · 发表于 2014-4-15 14:30:17

结帖

		自动登录	找回密码
密码			注册

[结贴] 使用aggregate报错