X5合计行使用

1、BIZ中action的设置:

<action name="queryTOA_DutyPersonsAction" procedure="bizQueryProcedure">

    <permission name="range" type="List"/> 

    <private name="concept" type="String" value="TOA_DutyPersons"/> 

    <private name="select" type="String" value="TOA_DutyPersons.*"/> 

    <private name="from" type="String" value="TOA_DutyPersons TOA_DutyPersons"/> 

    <private name="aggregate" type="String" value="sum(TOA_DutyPersons.version) AS sumValue,count(TOA_DutyPersons.version) AS cntValue"/> 

    <private name="dataModel" type="String" value="/ZTOA/ADM/duty/data"/> 

    <private name="fnModel" type="String"/> 

    <protected name="condition" type="String"/> 

    <public name="distinct" type="Boolean" value="false"/> 

    <public name="idColumn" type="String" value="TOA_DutyPersons"/> 

    <public name="filter" type="String"/> 

    <public name="limit" type="Integer"/> 

    <public name="offset" type="Integer"/> 

    <public name="columns" type="String"/> 

    <public name="orderBy" type="String"/> 

    <public name="aggregateColumns" type="String" value="sumValue,cntValue"/> 

    <public name="variables" type="Map"/>

  </action>

2、UI中grid初始化事件中执行：

function grdMainInit(event){

    var main = justep.xbl("dataMain");

    this.grid.attachFooter("<span style='font-size:12px;'>合计</span>,#cspan,#cspan," +

       "<span id='sumValue' style='height:100%;width:100%;text-align:center; vertical-align:middle;background-color:green;'> </span>," +

       "<span id='cntValue' style='height:100%;width:100%;text-align:center; vertical-align:middle'> </span>");

}

3、刷新数据之后的事件：

function dataMainAfterRefresh(event){

    var main = justep.xbl("dataMain");

    document.getElementById("sumValue").innerHTML = main.getAggregateValue("sumValue");

    document.getElementById("cntValue").innerHTML = main.getAggregateValue("cntValue");

}

4、注意确认/UI/system/components/data/js/data.js代码中的有“return”：

justep.XData.prototype.getAggregateValue = function(name){

    var store = this.getStore();

    return store.getUserData(null, name);

}