mysql感觉表头对不齐_DataTable表头对不齐、添加参数等方法总结

合同编号供方名称供方地址签订时间签订地点总金额收货人交货地点收货电话结算方式供方法定代表供方代表电话供方代表传真是否回传合同附件订单状态审核状态

var table = $('#staff'). DataTable({

ajax: {

type: 'post',

data: {

flag: 1

},

},

"scrollY": 440,

"scrollX": false,

"scrollCollapse": true,

"destroy" : true,

"paging" : true,

"autoWidth" : false,

"pageLength": 25,

serverSide: true,

// order:[[21, 'desc']],

columns: [

{searchable: true, data: 'contract_id'},

{searchable: true, data: 'supplier_name'},

{searchable: true, data: 'supply_address'},

{searchable: true, data: 'signing_time'},

{searchable: true, data: 'signing_place'},

{searchable: false, data: 'total_amount'},

{searchable: false, data: 'receiver'},

{searchable: false, data: 'trading_location'},

{searchable: true, data: 'receiving_phone'},

{searchable: true, data: 'billing_method'},

{searchable: true, data: 'supplier_representative'},

{searchable: true, data: 'supplier_phone'},

{searchable: true, data: 'supplier_fax'},

{searchable: true, class:'suc' , data: 'is_return_contract', render: function (data){return ['否', '是'][+data]}},

{searchable: true, data: 'order_status', render: function (data){return ['未生成订单','已生成订单','已生成订单','已生成订单','已生成订单'][+data]}},

{searchable: true, data: 'audit_status', render: function (data){return ['新提交', '不合格','审核通过'][+data]}}

],

'fnRowCallback':function(nRow,aData,iDisplayIndex,iDisplayIndexFull){

/*

nRow:每一行的信息 tr 是Object

aData：行 index

*/

for(let key in nRow){

var ADataStatus = nRow['childNodes'][13].innerText

if(ADataStatus == '否'){

$(nRow['childNodes'][13]).css("color",'red')

}else if(ADataStatus == '是'){

$(nRow['childNodes'][13]).css("color",'green')

}

}

},

//或者是 (变色)

"columnDefs" : [ //自定义列

{

"targets" : 7,

"data" : "stock_out_status",

render : function(data, type, row) {

data = parseInt(data);

// var arr = ['未处理', '出库中', '出库完毕','未对接订单,无需处理'];

var html = "";

switch (data) {

case 0 :

html = "";

break;

case 1 :

html = "";

break;

case 2 :

html = "";

break;

default:

html = "";

}

html += stockOutMap[data] + "";

return html;

}

},

oLanguage: {

"oAria": {

"sSortAscending": " - click/return to sort ascending",

"sSortDescending": " - click/return to sort descending"

},

"LengthMenu": "显示 _MENU_ 记录",

"ZeroRecords": "对不起，查询不到任何相关数据",

"EmptyTable": "未有相关数据",

"LoadingRecords": "正在加载数据-请等待...",

"Info": "当前显示 _START_ 到 _END_ 条，共 _TOTAL_ 条记录。",

"InfoEmpty": "当前显示0到0条，共0条记录",

"InfoFiltered": "(数据库中共为 _MAX_ 条记录)",

"Processing": " 正在加载数据...",

"Search": "搜索：",

"Url": "",

"Paginate": {

"sFirst": "首页",

"sPrevious": " 上一页 ",

"sNext": " 下一页 ",

"sLast": " 尾页 "

}

}

})