欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

DataTables warning: table id=dataTable - Requested unknown parameter 'acceptId' for row 0. For more

程序员文章站 2022-06-14 10:33:52
...

转载:http://blog.csdn.net/zml6308/article/details/47083135

重点内容 
DataTables warning: table id=dataTable - Requested unknown parameter ‘acceptId’ for row 0. For more information about this error, please see http://datatables.net/tn/4

使用jquery.datatable时发生上面错误,配置如下:

table = $("#dataTable").dataTable({
                        "scrollY": "400px", //高度
                        "scrollX": true, //左右滚动条
                        "ordering":false,//thead上的排序按钮
                        "bLengthChange": false,//分页条数选择按钮
                        "bProcessing": true,//显示加载中
                        "bInfo": false,//页脚信息显示
                        "searching":false,//搜索输入框显示
                        "sPaginationType": "full_numbers",//分页显示样式
                        "paging":true,//
                        "sAjaxSource": '<%= basePath %>sellcar/getSellCarOrderList',
                        "bProcessing" : true,
                        "bServerSide" : true,
                        "oLanguage": {  
                                    "sLengthMenu": "每页显示 _MENU_  条",  
                                    "sZeroRecords": "没有找到符合条件的数据",  
                                    "sProcessing": "我也是醉了,正在加载数据...",  
                                    "sInfo": "当前第 _START_ - _END_ 条 共计 _TOTAL_ 条",  
                                    "sInfoEmpty": "没有有记录",  
                                    "sInfoFiltered": "(从 _MAX_ 条记录中过滤)",  
                                    "sSearch": "搜索:",  
                                    "oPaginate": {  
                                        "sFirst": "首页",  
                                        "sPrevious": "前一页",  
                                        "sNext": "后一页",  
                                        "sLast": "尾页"  
                                    }  
                        },
                        "aoColumns": [
                        //{ "sDefaultContent": ' '},
                        { "mData":"brandName",'sClass':'left',
                            "mRender":function(data,type,full) {
                                var cusId = full.customerId;
                                var sellNo = full.sellNo;
                                var content = "<td><input type='checkbox' name='batchAllocated' id='batchAllocated' value='"+cusId+"' sell_no='"+sellNo+"'></td>";
                                return content;
                            }
                        },
                            { "mData":"brandId",
                            "mRender":function(data,type,full){
                                if(full.carBrand!=null){
                                    return full.carBrand.brandName;
                                };
                                return "";
                            }
                        },
                        { "mData":"serieId",
                            "mRender":function(data,type,full){
                                if(full.carSerie!=null){
                                    return full.carSerie.serieName;
                                };
                                return "";
                            }
                        },
                        { "mData":"customeId",
                            "mRender":function(data,type,full){
                                if(full.customer!=null){
                                    return full.customer.userName;
                                };
                                return "";
                            }
                        },
                        { "mData":"phoneNo"},
                        { "mData":"createdFormat"},
                        { "mData":"sellStatus",'sClass':'left',
                            "mRender":function(data,type,full) {
                                var sellStatus = full.sellStatus;
                                var content = "";
                                if(sellStatus==0){
                                    content = "待估车";
                                }else if(sellStatus==10){
                                    content = "估车成功";
                                    if(full.recordStatus == "wlr"){
                                        content = "估车成功,未录入";                               
                                    }else if(full.recordStatus == "ylr"){
                                        content = "已录入";
                                    }
                                    if(full.item !=null){
                                        var item = full.item;
                                        if(item.carStatus == "ysh"){
                                            content = "通过审核";
                                            if(item.carOnSale == 0){
                                                content = "待上架";
                                            }else if(item.carOnSale ==1){
                                                content ="上架";
                                            }else if(item.carOnSale == 2){
                                                content = "下架";
                                            }else if(item.carOnSale == 3){
                                                content = "已售";
                                            }else if(item.carOnSale == 4){
                                                content = "申请下架";
                                            }
                                        }else if(item.carStatus =="dsh"){
                                            content = "待审核";
                                        }else if(item.carStatus == "wsh"){
                                            content = "未通过审核";
                                        }
                                    }
                                }else if(sellStatus==20){
                                    content = "重新估车";
                                }else if(sellStatus == 30){
                                    content = "估车失败,结束";
                                }else if(sellStatus == 40){
                                    content = "无效信息";
                                }
                                return content;
                            }
                        },
                        { "mData":"acceptId",
                            "mRender":function(data,type,full){
                                if(data !=null){
                                    if(full.acceptUser !=null){
                                        return full.acceptUser.userName;
                                    }
                                }
                            }
                        },
                        { "mData":"carStatus",'sClass':'left',
                            "mRender":function(data,type,full) {
                                var content = "<a href='javascript:void(0);' class='show_info' info_id='"+full.sellNo+"'>查看</a>";
                                return content;
                            }
                        },
                        { "mData":"isAllocated",'sClass':'left',
                        "mRender":function(data,type,full) {
                                var isAllocated = full.isAllocated;
                                var content = "";
                                if(isAllocated==0){
                                    content = "<a href='javascript:void(0);' class='change_info' info_id='"+full.sellNo+"' cus_id='"+full.customerId+"'>分配</a>";
                                }else{
                                    content = "<a href='javascript:void(0);' class='change_info' info_id='"+full.sellNo+"' cus_id='"+full.customerId+"'>重新分配</a>";
                                }
                                return content;
                            }
                        }],
//                      "bLengthChange": true,// 控制每页显示记录数
                        "iDisplayLength": 10, // 每页显示数量
                        "fnServerData" : function(sSource, aoData, fnCallback) {
                            $.ajax({
                                "type" : 'post',
                                "url" : sSource,
                                "dataType" : "json",
                                "data" : {
                                    aoData : JSON.stringify(aoData),
                                    searchData: JSON.stringify(searchData)
                                },
                                "success" : function(resp) {
                                    fnCallback(resp);
                                    var datas=resp.aaData;                              
                                },
                                error: function(resp){
                                }
                            });
                        }/* ,
                        "fnRowCallback": function(nRow, aData, iDisplayIndex) {
//                          当创建了行,但还未绘制到屏幕上的时候调用,通常用于改变行的class风格,此处用于显示‘表格序号’ 
                            $('td:eq(0)', nRow).html(iDisplayIndex+1);
                            return nRow;
                        } */
                    });
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160

提示acceptId找不到,解决方案:

{ "mData":"acceptId",
                            "mRender":function(data,type,full){
                                if(data !=null){
                                    if(full.acceptUser !=null){
                                        return full.acceptUser.userName;
                                    }
                                }else{
                                    return "";
                                }
                            }
                        }
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11

在写mRender时,必须所有路径都要有返回值,做了空值判断,但是没有给返回值所以出现了上述错误,做个记录,以备后续使用。


相关标签: jquery datatable