/**
* 导出问卷调查
*/
exportExcelFunction:function(forms, store){
var me=this;
var form=forms.getForm();
var school=form.getValues()['school'];
var type=form.getValues()['type'];
var age=form.getValues()['age'];
var sex=form.getValues()['sex'];
var natives=form.getValues()['natives'];
var proxy = store.getProxy();
var filter = new SQLFilter();
var sel = [];
if(school != ''){
var se = new SQLException("and", "school", "like", "%25" + school + "%25", true);
sel.push(se);
}
if(type != ''){
var se = new SQLException("and", "type", "like", "%25" + type + "%25", true);
sel.push(se);
}
if(age != ''){
var se = new SQLException("and", "age", "like", "%25" + age + "%25", true);
sel.push(se);
}
if(sex != ''){
var se = new SQLException("and", "sex", "like", "%25" + sex + "%25", true);
sel.push(se);
}
if(natives != ''){
var se = new SQLException("and", "natives", "like", "%25" + natives + "%25", true);
sel.push(se);
}
if (sel.length > 0)
filter.buildBySe(sel);
var f = filter.getFilter();
var path = "";//接口不宜透露,故省略
var exportUrl = path+"?filter="+escape(JSON.stringify(f));//在此使用Ext.encode(f);函数会对汉字解析出错。所以采用js自带的解析。
//并用escape()函数对其进行编码。
location.href = exportUrl;
},
//后台处理。
filter = HtmlUtils.htmlUnescape(filter);//使用spring自带的函数进行解码。
其余的查询条件需要怎么处理就怎么处理了
extjs 根据查询条件导出内容
最新推荐文章于 2018-08-16 14:45:57 发布