web控件使用--左树右表F7

简介：左边以树形结构展示分类，右边以表格显示数据

关键词：左树右表F7、自定义核算项目F7

示例1：用左树右表F7做自定义核算项目，此示例可显示多个类别，如果用自定义核算项目F7则只能显示一个类别

1、选择组件类型

2、设置树查询对象、表格查询对象

     树查询对象：com.kingdee.eas.basedata.master.auxacct.app.GeneralGroupQuery

     表格查询对象：com.kingdee.eas.basedata.master.auxacct.app.GeneralQuery

3、设置过滤条件

     树过滤条件：

   waf.parseSql.getFilter("group.id","in",["oJ0AAAAAF+UF0s0M", "oJ0AAAAAf78F0s0M"],"in")

  转换后代码：
  {"subject":[{"left":"id","link":"in","right":["oJ0AAAAAF+UF0s0M","oJ0AAAAAf78F0s0M"]}],"mask":"#0"}

     表格过滤条件：

    var a = waf.parseSql.getFilter("group.id","in",["oJ0AAAAAF+UF0s0M", "oJ0AAAAAf78F0s0M"],"in");
    var b = waf.parseSql.getFilter("isEnabled ","=","1");
    var c = waf.parseSql.getFilter("creatorCompany.name","=","软件公司");
    waf.parseSql.mergeFilter([a,b,c],"#1and#2and#3")

  转换后代码：
   {"subject":[{"subject":[{"left":"group.id","link":"in","right":["oJ0AAAAAF+UF0s0M","oJ0AAAAAf78F0s0M"]}],
   "mask":"#0"},{"subject":[{"left":"isEnabled ","link":"=","right":"1"}],"mask":"#0"},
   {"subject":[{"left":"creatorCompany.name","link":"=","right":"软件公司"}],"mask":"#0"}],
   "mask":"#1and#2and#3"}

    过滤条件转换可参考：https://waf2.kingdee.com:6999/waf2help/samples/sceneCheck/wafParseSql

4、设置查询关联字段

     此字段是表格查询对象与树查询对象的关联字段，在这里使用group

配置如图：

完成：