EXTJS grid 排序 我给显示的字段设置了 SORTABLE=TRUE 为什么有的字段可以排序有的字段不可以排序呢
<script type="text/javascript">
var IDS=new Array();
Ext.onReady(function(){
var roleCombox;
var bbar;
Ext.BLANK_IMAGE_URL = "<%=basePath%>js/extjs/resources/images/default/s.gif";
Ext.QuickTips.init();
Ext.lib.Ajax.defaultPostHeader+=";charset=utf-8";
var cm=new Ext.grid.ColumnModel([
{header:'角色名称',dateIndex:'ROLE_NAME',sortable:true},
{header:'创建人',dataIndex:'CREATE_USER_NAME',sortable:true},
{header:'创建时间',dataIndex:'CREATE_TIME',sortable:true}
]);
//数据源的获取
var store = new Ext.data.Store({
reader: new Ext.data.JsonReader({
totalProperty: "results",
root: "items",
id: "store"
},
Ext.data.Record.create(['ROLE_NAME','CREATE_USER_NAME','CREATE_TIME','ROLE_ID'])
),
proxy : new Ext.data.HttpProxy({
url : '<%=basePath%>system/role_findRole.action'
});
store.load({params:{start:0, limit:25}});
var tbar=new Ext.Toolbar({
name:'usertbar',
id:'usertbar'
});
tbar.render('toolbar');
varcomboxRoleStore=new Ext.data.JsonStore({
url:'<%=basePath%>system/role_findRoleByCom.action',
root:'items',
totalProperty: 'results',
fields:[
{name:'ROLE_ID', mapping:'ROLE_ID'},
{name:'ROLE_NAME', mapping:'ROLE_NAME'}
],
disableCaching:false,
autoLoad:true
});
roleCombox=new Ext.form.ComboBox({
xtype : 'combo',
name:'ROLE_ID',
id:'ROLE_ID',
store: comboxRoleStore,
displayField:'ROLE_NAME',
valueField:'ROLE_NAME',
emptyText:'请输入查询',
width:160,
listWidth:200,
minHeight:100,
editable:true,
allowBlank:true,
mode:'local',
typeAhead: false,
loadingText:'loading...',
hiddenName:'ROLE_NAME',
triggerAction:'all',
onKeyUp : function(e){
var a=e.getKey();
if(e.getKey()==e.SPACE||(parseInt(a)>48&&parseInt(a)<58)){
this.store.baseParams = { query:this.getEl().dom.value };
this.collapse();
this.store.reload();
}
}
});
comboxRoleStore.load({params:{query:roleCombox.getRawValue(),start:0,limit:10}});
var searchBus=new Ext.Toolbar.Button({text:'查询',handler:searchRole,cls:'x-btn-text-icon',icon: 'images/ico/sousuo.gif'});
var roleCreate=new Ext.Toolbar.Button({text:'新增',handler:create,cls:'x-btn-text-icon',icon: 'images/ico/tianjia.gif'});
var roleDelete=new Ext.Toolbar.Button({text:'删除',handler:deleteRole,cls:'x-btn-text-icon',icon: 'images/ico/shanchu.gif'});
var roleModify=new Ext.Toolbar.Button({text:'修改',handler:modify,cls:'x-btn-text-icon',icon: 'images/ico/xiugai.gif'});
var roleMenu=new Ext.Toolbar.Button({text:'角色配置菜单',handler:addRoleMenu,cls:'x-btn-text-icon',icon: 'images/ico/shezhi.gif'});
var rolefun=new Ext.Toolbar.Button({text:'角色功能权限',handler:findmenurole,cls:'x-btn-text-icon',icon: 'images/ico/shenzhi.gif'});
tbar.add(roleCombox);
tbar.add(searchBus);
tbar.add({xtype:'tbseparator'});
tbar.add(roleCreate);
tbar.add({xtype:'tbseparator'});
tbar.add(roleDelete);
tbar.add({xtype:'tbseparator'});
tbar.add(roleModify);
tbar.add({xtype:'tbseparator'});
tbar.add(roleMenu);
tbar.add({xtype:'tbseparator'});
tbar.add(rolefun);
bbar=new Ext.PagingToolbar({
pageSize:25,
store:store,
displayInfo:true,
displayMsg:'显示第{0}条到{1}条记录, 一共{2}条',
emptyMsg:"没有记录"
});
var grid=new Ext.grid.GridPanel({
renderTo:'grid',
store:store,
cm:cm,
width: Ext.get("grid").getWidth(),
height: Ext.get("grid").getHeight(),
viewConfig:{
forceFit:true
},
bbar:bbar
});
function searchRole(){
var values =roleCombox.getEl().getValue();
grid.store.proxy =new Ext.data.HttpProxy({url:'<%=basePath%>system/role_findRole.action?ROLE_NAME=' + values,method : 'POST'});
grid.store.reload({params:{start:0, limit:25}});
}
function deleteRole(){
var record = grid.getSelectionModel().getSelected();
if(!record){
top.Ext.Msg.alert("信息", "请选择要删除的一项");
}else{
top.Ext.MessageBox.confirm("请确认","是否真的要删除指定的内容",function(button,text){
if(button=='yes'){
var rid =record.get('ROLE_ID');
roleService.deleteRole(rid,function (data){
if(data==true){
top.Ext.Msg.alert('信息','删除成功');
var s=bbar.cursor;
store.load({params:{start:s, limit:25}});
}else{
top.Ext.Msg.alert('信息','删除失败');
}
});
}
});
}
}
var cuswin=null;
var cuspanle=null;
function createwin(){
cuswin = new top.Ext.Window({
title:'角色新增',
width:550,
height:425,
plain:true,
closable:true,
resizable:true,
closeAction:'close',
id:'cuswin',
modal:true,
listeners : {'hide':{fn: makesure}}
});
cuspanle = new top.Ext.FormPanel({
labelAlign : 'right',
border:false,
buttonAlign : 'center',
frame : true,
width:550,
id:'cusfrm',
layout : "form",
labelWidth :75,
defaultType : 'textfield',
items : [{
xtype : 'tabpanel',
plain : true,
activeTab : 0,
height : 340,
defaults : { bodyStyle : 'padding:10px'},
items : [{
title : '基本信息',
items:[{
xtype:'fieldset',
title:'基本信息',
items:[{
layout:'form',
items:[{xtype : "textfield",
fieldLabel : '角色名称',
name : 'ROLE_NAME',
width:390,
id :'ROLE_NAME'}]
}]}]}] }],
buttons:[{text:'保存',handler:submit},{text:'取消',handler:submit}]
});}
ROLE_NAME不可以排序 其他 两个字段都可以点击排序 我都设置了 sortable:true
[解决办法]
中文排序不能用true,
Ext.data.Store.prototype.applySort = function(){ //重载 applySort
if(this.sortInfo && !this.remoteSort){
var s = this.sortInfo, f = s.field;
var st = this.fields.get(f).sortType;
var fn = function(r1, r2){
var v1 = st(r1.data[f]), v2 = st(r2.data[f]);
// 添加:修复汉字排序异常的Bug
if(typeof(v1) == "string"){ //若为字符串，
return v1.localeCompare(v2);//则用 localeCompare 比较汉字字符串, Firefox 与 IE 均支持
}
// 添加结束
return v1 > v2 ? 1 : (v1 < v2 ? -1 : 0);
};
this.data.sort(s.direction, fn);
if(this.snapshot && this.snapshot != this.data){
this.snapshot.sort(s.direction, fn);
}
}
};
