查看: 3594|回复: 8

datagrid 用到groupBy分组后，sortBy不能正常排序 [复制链接]

ffffohno

注册会员

Rank: 2

电梯直达

楼主

发表于 2017-1-19 16:36:45 |只看该作者 |倒序浏览

本帖最后由 ffffohno 于 2017-1-22 11:12 编辑

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

收藏0

ffffohno

注册会员

Rank: 2

沙发

发表于 2017-1-19 16:50:48 |只看该作者

排序列是时间

dforce

超级版主

Rank: 8 Rank: 8

板凳

发表于 2017-1-19 17:02:01 |只看该作者

ffffohno 发表于 2017-1-19 16:50
排序列是时间

http://www.miniui.com/demo/#src=datagrid/grouping.html
如示例，分组按点击排序可以正常使用
你可以更新到最新版本，如果还有问题可以基于我们示例的代码重现出你说的问题。

ffffohno

注册会员

Rank: 2

地板

发表于 2017-1-22 10:03:29 |只看该作者

本帖最后由 ffffohno 于 2017-1-22 10:07 编辑

dforce 发表于 2017-1-19 17:02
http://www.miniui.com/demo/#src=datagrid/grouping.html
如示例，分组按点击排序可以正常使用
你可以更 ...

就是3.7版本，你说的页面，把分页数扩大，返回的数据用以下数据：，你看看效果，1楼的图片就是效果
{"total":29,"maxAge":37,"avgAge":27.2759,"minAge":24,"data":
[{"loginname":"zhang0","name":"zhang0","gender":1,"salary":2000,"age":24,"createtime":"2015-12-18T01:57:17.870Z"},{"loginname":"li1","name":"li1","gender":2,"salary":2000,"age":24,"createtime":"2015-05-27T01:57:17.870Z"},{"loginname":"gong2","name":"gong2","gender":2,"salary":2000,"age":24,"createtime":"2016-07-21T01:57:17.870Z"},{"loginname":"zhao3","name":"zhao3","gender":2,"salary":2000,"age":24,"createtime":"2016-01-15T01:57:17.870Z"},{"loginname":"cai4","name":"cai4","gender":2,"salary":2000,"age":24,"createtime":"2016-04-21T01:57:17.870Z"},{"loginname":"zhang5","name":"zhang5","gender":2,"salary":2000,"age":24,"createtime":"2016-04-09T01:57:17.870Z"},{"loginname":"li6","name":"li6","gender":2,"salary":2000,"age":24,"createtime":"2015-08-08T01:57:17.870Z"},{"loginname":"gong7","name":"gong7","gender":2,"salary":2000,"age":24,"createtime":"2016-05-21T01:57:17.870Z"},{"loginname":"zhao8","name":"zhao8","gender":2,"salary":2000,"age":24,"createtime":"2015-05-12T01:57:17.870Z"},{"loginname":"cai9","name":"cai9","gender":1,"salary":2000,"age":24,"createtime":"2016-10-17T01:57:17.870Z"},{"loginname":"zhang10","name":"zhang10","gender":1,"salary":2000,"age":24,"createtime":"2015-03-23T01:57:17.870Z"},{"loginname":"li11","name":"li11","gender":1,"salary":2000,"age":24,"createtime":"2015-02-25T01:57:17.870Z"},{"loginname":"gong12","name":"gong12","gender":2,"salary":2000,"age":24,"createtime":"2016-10-29T01:57:17.870Z"},{"loginname":"zhao13","name":"zhao13","gender":2,"salary":2000,"age":24,"createtime":"2016-05-27T01:57:17.870Z"},{"loginname":"cai14","name":"cai14","gender":1,"salary":2000,"age":24,"createtime":"2016-12-15T01:57:17.870Z"},{"loginname":"zhang15","name":"zhang15","gender":2,"salary":2000,"age":24,"createtime":"2016-01-29T01:57:17.870Z"},{"loginname":"li16","name":"li16","gender":1,"salary":2000,"age":24,"createtime":"2015-05-19T01:57:17.870Z"},{"loginname":"gong17","name":"gong17","gender":2,"salary":2000,"age":24,"createtime":"2016-11-18T01:57:17.870Z"},{"loginname":"zhao18","name":"zhao18","gender":2,"salary":2000,"age":24,"createtime":"2014-08-19T01:57:17.870Z"},{"loginname":"cai19","name":"cai19","gender":2,"salary":2000,"age":24,"createtime":"2015-11-07T01:57:17.870Z"},{"loginname":"zhang20","name":"zhang20","gender":1,"salary":2000,"age":24,"createtime":"2016-06-18T01:57:17.870Z"},{"loginname":"li21","name":"li21","gender":2,"salary":2000,"age":24,"createtime":"2015-11-30T01:57:17.870Z"},{"loginname":"gong22","name":"gong22","gender":2,"salary":2000,"age":24,"createtime":"2015-03-02T01:57:17.870Z"},{"loginname":"zhao23","name":"zhao23","gender":1,"salary":2000,"age":24,"createtime":"2015-08-08T01:57:17.870Z"},{"loginname":"cai24","name":"cai24","gender":2,"salary":2000,"age":24,"createtime":"2015-06-18T01:57:17.870Z"},{"loginname":"zhang25","name":"zhang25","gender":2,"salary":2000,"age":24,"createtime":"2014-08-04T01:57:17.870Z"},{"loginname":"li26","name":"li26","gender":2,"salary":2000,"age":24,"createtime":"2016-05-12T01:57:17.870Z"},{"loginname":"gong27","name":"gong27","gender":1,"salary":2000,"age":24,"createtime":"2016-03-01T01:57:17.870Z"},{"loginname":"zhao28","name":"zhao28","gender":2,"salary":2000,"age":24,"createtime":"2015-02-05T01:57:17.870Z"}]
}

dforce

超级版主

Rank: 8 Rank: 8

5^#

发表于 2017-1-22 10:40:33 |只看该作者

ffffohno 发表于 2017-1-22 10:03
就是3.7版本，你说的页面，把分页数扩大，返回的数据用以下数据：，你看看效果，1楼的图片就是效果
{"tota ...

请问你后台处理了吗？所谓排序，前台做的只是将排序字段和数据传递到后台。

ffffohno

注册会员

Rank: 2

6^#

发表于 2017-1-22 10:56:08 |只看该作者

本帖最后由 ffffohno 于 2017-1-22 11:01 编辑

dforce 发表于 2017-1-22 10:40
请问你后台处理了吗？所谓排序，前台做的只是将排序字段和数据传递到后台。 ...

肯定有处理啊！现在就是加了group后打乱了嘛

把上面的data按时间排序后，如下：（也是有排序错乱）
{"total":29,"maxAge":37,"avgAge":27.2759,"minAge":24,"data":
[{"loginname":"zhang20","name":"zhang20","gender":1,"salary":2000,"age":24,"createtime":"2014-06-08T02:52:34.288Z"},{"loginname":"zhang25","name":"zhang25","gender":2,"salary":2000,"age":24,"createtime":"2014-08-21T02:52:34.288Z"},{"loginname":"gong27","name":"gong27","gender":1,"salary":2000,"age":24,"createtime":"2014-09-13T02:52:34.288Z"},{"loginname":"zhang15","name":"zhang15","gender":2,"salary":2000,"age":24,"createtime":"2014-09-21T02:52:34.288Z"},{"loginname":"zhang0","name":"zhang0","gender":1,"salary":2000,"age":24,"createtime":"2014-09-26T02:52:34.287Z"},{"loginname":"li21","name":"li21","gender":2,"salary":2000,"age":24,"createtime":"2014-09-30T02:52:34.288Z"},{"loginname":"li6","name":"li6","gender":2,"salary":2000,"age":24,"createtime":"2014-10-27T02:52:34.288Z"},{"loginname":"gong7","name":"gong7","gender":1,"salary":2000,"age":24,"createtime":"2015-02-01T02:52:34.288Z"},{"loginname":"zhao23","name":"zhao23","gender":1,"salary":2000,"age":24,"createtime":"2015-02-05T02:52:34.288Z"},{"loginname":"li1","name":"li1","gender":2,"salary":2000,"age":24,"createtime":"2015-03-17T02:52:34.287Z"},{"loginname":"zhang10","name":"zhang10","gender":2,"salary":2000,"age":24,"createtime":"2015-04-25T02:52:34.288Z"},{"loginname":"li26","name":"li26","gender":2,"salary":2000,"age":24,"createtime":"2015-05-06T02:52:34.288Z"},{"loginname":"gong17","name":"gong17","gender":1,"salary":2000,"age":24,"createtime":"2015-05-14T02:52:34.288Z"},{"loginname":"li11","name":"li11","gender":2,"salary":2000,"age":24,"createtime":"2015-06-08T02:52:34.288Z"},{"loginname":"cai9","name":"cai9","gender":2,"salary":2000,"age":24,"createtime":"2015-06-19T02:52:34.288Z"},{"loginname":"cai24","name":"cai24","gender":2,"salary":2000,"age":24,"createtime":"2015-07-02T02:52:34.288Z"},{"loginname":"zhang5","name":"zhang5","gender":1,"salary":2000,"age":24,"createtime":"2015-08-16T02:52:34.288Z"},{"loginname":"zhao28","name":"zhao28","gender":1,"salary":2000,"age":24,"createtime":"2015-09-08T02:52:34.288Z"},{"loginname":"cai14","name":"cai14","gender":2,"salary":2000,"age":24,"createtime":"2015-09-18T02:52:34.288Z"},{"loginname":"li16","name":"li16","gender":1,"salary":2000,"age":24,"createtime":"2015-09-24T02:52:34.288Z"},{"loginname":"gong12","name":"gong12","gender":1,"salary":2000,"age":24,"createtime":"2015-10-11T02:52:34.288Z"},{"loginname":"cai19","name":"cai19","gender":1,"salary":2000,"age":24,"createtime":"2016-03-17T02:52:34.288Z"},{"loginname":"zhao13","name":"zhao13","gender":1,"salary":2000,"age":24,"createtime":"2016-05-30T02:52:34.288Z"},{"loginname":"gong22","name":"gong22","gender":2,"salary":2000,"age":24,"createtime":"2016-07-01T02:52:34.288Z"},{"loginname":"zhao8","name":"zhao8","gender":2,"salary":2000,"age":24,"createtime":"2016-07-09T02:52:34.288Z"},{"loginname":"zhao3","name":"zhao3","gender":1,"salary":2000,"age":24,"createtime":"2016-08-27T02:52:34.288Z"},{"loginname":"gong2","name":"gong2","gender":2,"salary":2000,"age":24,"createtime":"2016-09-04T02:52:34.288Z"},{"loginname":"zhao18","name":"zhao18","gender":2,"salary":2000,"age":24,"createtime":"2016-12-02T02:52:34.288Z"},{"loginname":"cai4","name":"cai4","gender":2,"salary":2000,"age":24,"createtime":"2017-01-05T02:52:34.288Z"}]
}