easyui datagrid json扩展

如果使用mybatis association，那么封装对象后，返回到页面是json格式的，这种格式
在页面中显示出来，跟一下数组方式有很大区别，不过还好easyui loadFilter支持这种扩展
1 easyui json表格

function createDg(){
    dgList=$('#dg').datagrid({    
    method: "post",url:ctx+'/smsHouseholdOrder/find', idField : 'id',singleSelect:true,
    fit : true,fitColumns : false,border : false,striped:true,
    pagination:true,rownumbers:true,pageNumber:1,pageSize : 20,pageList : [ 20, 30, 50 ],
    columns:[[    
                                            {field:'smsHouseholdOrder.id',title:'ID',hidden:true}
                                                ,{field:'smsHouseholdOrder.orderId',title:'订单号',sortable:true,width:100,align:'left',halign:'center' }
                                                ,{field:'smsOrder.status',title:'状态',sortable:true,width:80,align:'left',halign:'center',formatter:fmtStatus }
                                                ,{field:'smsOrder.appointmentTime',title:'预约服务时间',sortable:true,width:120,align:'left',halign:'center',formatter: DzmFrame.EasyUI.fmtDatetime}
                                                ,{field:'smsOrder.memberName',title:'会员',sortable:true,width:100,align:'left',halign:'center' }
                                                ,{field:'smsOrder.memberPhone',title:'会员手机号',sortable:true,width:100,align:'left',halign:'center' }
                                                ,{field:'smsOrder.address',title:'服务地址',sortable:true,width:200,align:'left',halign:'center' }
                                                ,{field:'smsHouseholdOrder.times',title:'服务时长',sortable:true,width:100,align:'right',halign:'center' }
                                                ,{field:'smsHouseholdOrder.price',title:'单价',sortable:true,width:100,align:'right',halign:'center',formatter:DzmFrame.EasyUI.fmtMoney }
                                                ,{field:'smsHouseholdOrder.discount',title:'折扣价',sortable:true,width:100,align:'right',halign:'center',formatter:DzmFrame.EasyUI.fmtMoney }
                                                ,{field:'smsHouseholdOrder.amount',title:'金额',sortable:true,width:100,align:'right',halign:'center',formatter:DzmFrame.EasyUI.fmtMoney }
                                                ,{field:'smsOrder.orderTime',title:'下单时间',sortable:true,width:120,align:'left',halign:'center',formatter: DzmFrame.EasyUI.fmtDatetime}
                        ]],
    sortName:'smsHouseholdOrder.orderId',sortOrder:'asc',
    enableHeaderClickMenu: false,
    enableHeaderContextMenu: false,
    toolbar:'#tb',
    loadFilter:function(data){
        return DzmFrame.EasyUI.dataGridLoadFilter(data);
    }
    });
}

2 dataGridLoadFilter
定义filter，解析smsHouseholdOrder.times这种方式的字段。

var _dataGridLoadFilter = function(data,row,pre){
             if(pre)  
                    pre = pre+".";  
             for (var att in data) {  
                   var r = data[att];  
                   if(typeof(r) == "object"){  
                       if ($.array.isArray(r)){
                           row[pre+att] = r;
                       } else{
                           _dataGridLoadFilter(r,row,pre+att);  
                       }
                   }else{  
                                row[pre+att] = r;                    
                            }  

               } 
        }
        var dataGridLoadFilter = function(data){
            var value = {total:data.total,rows:[]};
            if (!$.isEmptyObject(data.rows) && $.isArray(data.rows)){
                for (var i=0; i<data.rows.length; i++){
                    var row = {};
                    _dataGridLoadFilter(data.rows[i],row,"");
                    value.rows.push(row);
                }
            }
            return value;
        }