通用查询-高级查询

 1//通用查询的快速查询增加字段模糊搜索过滤
 2 pageOnRenderEvent_before:function(e){
 3             _self.setInitComponentCallBack(function(cmpType,option,dom){
 4                          if (cmpType=="waf.bizCommonQuery") {
 5                              //option.schemeTabHide = true;
 6                              option.initDatas = _self.getPageInitData().queryInitData;
 7                              option.searchOptions=[{name:"绑定的属性",label:"别名"},{name:"绑定的属性",label:"别名"}];
 8                          }
 9                      });
10         }

//常用条件增加日期过滤选项
 function addGatherDate(){
      var groupFilters = {
        field:'绑定的属性名',
        dataType:"Date",
        title:'日期',
        needScope:true,
        filterItems:[{name:'今天',value:'d1',isDefault:0},{name:'本周',value:'w1',isDefault:0},{name:'本月',value:'m1',isDefault:　　　　　　　　0},{name:'近三月',value:'m3',isDefault:0}]
      　　};
      var groupFiltersArray = new Array(groupFilters);
      waf("#bizCommonQuery").bizCommonQuery("option","groupFilters",groupFiltersArray);
      waf("#bizCommonQuery").bizCommonQuery("addCusFilter");
    }

//常用条件增加枚举选项过滤
function addBillType(){
    var groupFilters = {
      field:'绑定的属性',
      dataType:'ObjectValue',
      title:'显示名称',
      filterItems:[{value:"值",alias:"别名"},{value:"值",alias:"别名"}]
    };
    var groupFiltersArray = new Array(groupFilters);
    waf("#bizCommonQuery").bizCommonQuery("option","groupFilters",groupFiltersArray);
    waf("#bizCommonQuery").bizCommonQuery("addCusFilter");
  }

//常用条件增加文本框模糊搜索
 function addAccountBank(){
    addCusFilterDOM("accountBank","入账账户","ObjectValue",true);
    var json = {
      id:'bizCommonQuery_accountBank_input',
      width:192,
      style:'margin-right:10px;'
    };
    dom = waf.createDOM("text",json);
    var parentEl = waf("#bizCommonQuery_queryaccountBankGroupNav");
    waf("#bizCommonQuery_queryaccountBankGroupNav")[0].style.marginRight = "0px";
    var liEl = waf("<li style='max-width:500px;margin-top:3px;'></li>");
    liEl.appendTo(parentEl);
    waf.appendDOM(liEl,dom);
    waf.initComponent("text",json,dom);
    addSureButton(parentEl,0,"accountBank");
  }

//常用条件自定义新增一行
function addCusFilterDOM(field,title,dataType,required){
        var self = this;
        var id = "bizCommonQuery";
        var optsJson = {
            id:id + "_query"+field+"Col",
            colWidth:"100%"
        };
        var queryColDom = waf.createDOM("column", optsJson);
        waf.appendDOM(waf("#"+id+"_commUsePanel"), queryColDom);
        waf.initComponent("column", optsJson, queryColDom);

        optsJson = {
            id:id + "_query"+field,
            layout:"column",
            tagClass:"ui-commonquery-group"
        };
        var queryPanelDom = waf.createDOM("panel", optsJson);
        waf.appendDOM(queryColDom, queryPanelDom);
        waf.initComponent("panel", optsJson, queryPanelDom);

        optsJson = {
            id:id + "_query"+field+"Hd",
            colWidth:"10%",
            tagClass:"ui-commonquery-group-hd"
        };
        var queryHdDom = waf.createDOM("column", optsJson);
        waf.appendDOM(queryPanelDom, queryHdDom);
        waf.initComponent("column", optsJson, queryHdDom);

        waf("<span class='ui-lb-text'>"+title+":</span>").appendTo(queryHdDom);

        optsJson = {
            id:id + "_query"+field+"Content",
            colWidth:"90%",
            tagClass:"ui-commonquery-group-content"
        };
        var queryContentDom = waf.createDOM("column", optsJson);
        waf.appendDOM(queryPanelDom, queryContentDom);
        waf.initComponent("column", optsJson, queryContentDom);
        waf("<ul id='"+id+"_query"+field+"GroupNav' class='ui-commonquery-group-nav'>").appendTo(queryContentDom);

        optsJson = {
            id:id + "_query"+field+"More",
            colWidth:"",
            tagClass:"ui-commonquery-group-more"
        };
        waf("#" + id + "_query"+field).wafColumnLayout();
    } 

//文本框后面加上查询按钮
  function addSureButton(parentEl,page,idname){
    var liEl = waf("<li style='float:left;margin-top:3px;'></li>");
       liEl.appendTo(parentEl);

       var searchBtnDivDom = waf('<div id="bizCommonQuery_"'+idname+'"Div" class="surebtndiv"></div>');
       var linkOpts = {
           id: idname,
           name: idname,
           tagClass:"btn",
           caption: "查询"
       };
       linkBtnDom = waf.createDOM("linkButton", linkOpts);
       linkBtnDom.attr("title", "查询");
       waf.appendDOM(searchBtnDivDom, linkBtnDom);
       waf.appendDOM(liEl, searchBtnDivDom);
       waf.initComponent("linkButton", linkOpts, linkBtnDom);
       linkBtnDom.bind("click.wafLinkButton", function (event) {
           getRevDetailsList(page,getfilter(page));
       });
  }

 

//如果存在多个页签
//切换页签清空过滤条件-已选条件
function clearFilter(){
    var nav = document.getElementById("bizCommonQuery_queryBarGroupNav");
    while(nav.hasChildNodes()){
        nav.removeChild(nav.firstChild);
    }
}

//切换页签，如果每个页签常用条件不一样，清除所有已加的常用条件
function addBizCommonQueryFilter(page){
    if(page!=null && page!=""){
        var panel = document.getElementById("bizCommonQuery_commUsePanel");
        while(panel.hasChildNodes()){
            panel.removeChild(panel.firstChild);
        }
    }

 

 

//通用查询只支持查询表格，因为需要绑定query来联动查询
//通用查询支持分录表格联动查询可以通过一下代码来实现
 //快速查询联动
//这段快速查询联动是增加两个模糊搜索字段
        $("#bizCommonQuery_searchFilter").bind("DOMNodeInserted",function(e){
          var fil = 0;
          var filNodes = document.getElementById("bizCommonQuery_searchFilter").childNodes;
          var fillen = filNodes.length;
          for(var f=0; f<fillen; f++){
            var spans = $("#bizCommonQuery_searchFilter").find(".query-search-value");
              if(spans[spans.length-1].childNodes.length>0){
                fil++;
              }
          }
        // 删除模糊搜索字段联动查询   
          $(".query-search-facet").find(".query-search-remove").die().live("click",function(e){
            getRowData(getfilter(createType));
          });
          //只选中一种查询字段联动查询
          if(fillen==1){
            if(fil>0)
              getRowData(getfilter(createType));
            //选中2种查询字段联动查询
          }else if(fillen==2){
            if(fil==2)
              getRowData(getfilter(createType));
            //3种联动字段查询
          }else if(fillen==3){
            if(fil==3)
              getRowData(getfilter(createType));
          }
        });     



//通用查询+分录表格常用条件联动查询
        $("#bizCommonQuery_queryBarGroupNav").bind('DOMNodeInserted',function(e) {
          var nav = document.getElementById( "bizCommonQuery_queryBarGroupNav" ).childNodes;
            for(var n=0; n<nav.length; n++){
              var li = nav[n];
              if(li.childNodes.length>0){
                var span = li.childNodes[0];
                if(span.childNodes.length<3){
                  return;
                }else{
                  if(n==nav.length-1){
                //选中常用条件联动查询
                    getRowData(getfilter(createType));

                    waf(".choosing").find(".chooseitem a").die().live("click",function(e){
                    var idstr = this.parentNode.id.split("_")[0];
                    var fieldids = waf(this).parent().find("label").html().split(";");
                    for (var i = 0; i < fieldids.length; i++) {
                      waf("#"+fieldids[i]).parent().removeClass("active");
                      waf("#"+fieldids[i]).removeClass("ui-commonquery-multisel");
                    }
                    this.parentNode.parentNode.parentNode.removeChild(this.parentNode.parentNode);
                        if(idstr.indexOf('FilterBar')<0){
                          waf("#bizCommonQuery").bizCommonQuery("getSelectItems").remove(idstr+".id");
                          waf("#bizCommonQuery").bizCommonQuery("getCurrentFilterItems").cusFilterItems.remove(idstr+".id");
                        }else{
                          idstr = idstr.substring(0,idstr.length-"FilterBar".length);
                          waf("#bizCommonQuery").bizCommonQuery("getSelectItems").remove(idstr);
                          waf("#bizCommonQuery").bizCommonQuery("getCurrentFilterItems").cusFilterItems.remove(idstr);
                        }
                    //删除已选中的常用条件联动查询
                        getRowData(getfilter(createType));
                    });
                  }
                }
              }
            }
        }); 
    },