datatables隐藏列排序

时间:2023-03-08 23:45:24
datatables隐藏列排序
var tableOption = {
id: 'cacScriptTable',
order: [[2, 'desc'],[1, 'desc']],//以第三列‘updatedAt’排序,如果第三列的值相同就以第二列排序
aoColumns: [
{mData: 'scriptName', title: '名称'},
{mData: 'endedAt', title: '创建时间', visible: false,order:'desc'},
{mData: 'updatedAt', title: '修改时间', visible: false,order:'desc'},
{mData: 'scriptName', title: '名称'},
{mData: 'scriptParams', title: '参数'},
{mData: 'createdBy', title: '上传用户'},
{mData: 'description', title: '描述'},
{
mData: 'id',
title: '操作',
className: 'text-center',
searchable: false,
orderable: false,
render: function (data, type, row, meta) {
var id = "'" + row.id + "'";
var script = encodeURI(angular.toJson(row));
var actionHtml =
'<div class="btn-group">' +
'<button type="button" class="btn btn-default btn-sm" title="编辑" ng-click="cacScriptListCtrlVm.views.editScript(\'' + script + '\')">' +
'<span class="fa fa-pencil"></span>' +
'</button>' +
'<button type="button" class="btn btn-default btn-sm" title="删除" ng-click="cacScriptListCtrlVm.views.deleteScript(' + id + ')">' +
'<span class="fa fa-remove"></span>' +
'</button>' +
'</div>';
return actionHtml;
},
createdCell: function (nTd, sData, oData, iRow, iCol) {
$compile(nTd)($scope);
}
}
]
}; function init() {
if (_appconfig.modules.cac.useLocalDb) {
tableOption.ajaxSource = 'app/modules/cac/api/script.json';
$timeout(function () {
vm.views.tableInstance = cacService.prepareDatatable(".scriptTableDiv .scriptTable", tableOption);
}, 10);
} else {
tableOption.ajax = cacService.assembleDataTableUrl('/api/cac/audit/scripts');
$timeout(function () {
vm.views.tableInstance = cacService.prepareDatatable(".scriptTableDiv .scriptTable", tableOption);
}, 10);
}
}

相关文章