javascript - 在jquery和php中过滤搜索时如何解决数据表选择的行
问题描述
我想在搜索表格行列时选择我的表格第一行,但我也选择了选择的第一行代码,但这不起作用我该如何解决?
var table = this.oTable = $('#mytable').DataTable({
"lengthMenu": [
[20, 40, 60, 80, 100],
[20, 40, 60, 80, 100]
],
scrollX: true,
scrollY: $(window).height() - 232,
"stateSave": true,
"info": true,
// "aaSorting": [[ 1, "desc" ]],
"ordering": true,
"order": [
[1, "desc"]
],
language: {
oPaginate: {
sNext: '<i class="fa fa-angle-right"></i>',
sPrevious: '<i class="fa fa-angle-left "></i>',
sFirst: '<i class="fa fa-angle-double-left"></i>',
sLast: '<i class="fa fa-angle-double-right"></i>'
},
"sProcessing": '<div class="fulloverlay"> <img id="loading-image" src="' + base_url + '/assets/v1/images/loader.gif"> </div>',
},
columnDefs: [{
targets: [0],
"orderable": false,
},
{
"orderable": false,
targets: [0, 2]
}
],
"bProcessing": true,
"bServerSide": true,
"sAjaxSource": base_url + 'index.php/Customer_Category/tableList1',
"bJQueryUI": true,
"sPaginationType": "full_numbers",
"iDisplayStart ": 20,
"pageLength": 40,
searching: false,
orderCellsTop: true,
fixedHeader: true,
"bLengthChange": false,
"fnInitComplete": function() {},
'fnServerData': function(sSource, aoData, fnCallback) {
var cnt = 0;
$('#mytable thead tr:eq(1) th').each(function(i) {
if ($("#searchFilter_" + cnt).attr('type') == 'checkbox') {
if ($("#searchFilter_" + cnt).prop("checked") == true) {
var val = 1;
} else if ($("#searchFilter_" + cnt).prop("checked") == false) {
var val = 0;
}
aoData.push({
"name": "searchFilter_" + cnt,
"value": val
});
} else {
aoData.push({
"name": "searchFilter_" + cnt,
"value": $("#searchFilter_" + cnt).val()
});
}
cnt++;
});
$.ajax({
'dataType': 'json',
'type': 'POST',
'url': sSource,
'data': aoData,
'success': fnCallback
});
},
rowCallback: function(row, data, index) {
if (index % 2 == 0) {
$(row).removeClass('myodd myeven');
$(row).addClass('myodd');
} else {
$(row).removeClass('myodd myeven');
$(row).addClass('myeven');
}
},
});
解决方案
您可以使用initComplete
选择第一条记录。
$('#mytable').DataTable( {
"initComplete": function () {
var table = $('#myTable').DataTable();
table.row(':eq(0)', { page: 'current' }).select();
}
});
推荐阅读
- python - 读取 JSON 文件并转换为 Panda DataFrame
- ssl - NET::ERR_SSL_OBSOLETE_VERSION 与 Chrome
- android - 使用共享元素转换时的 VideoView 故障
- ansible - Ansible 从 ec2 实例(Linux)中获取标签信息和事实
- shell - 执行 shell 脚本时找不到 fc
- rust - 在 Rust 中基于用户输入运行函数
- jquery - JQuery自动完成多个单词的最小长度
- go - 无法从私有 Gitlab 存储库中获取
- azure - 如何将下一个 js 应用部署到 azure 应用服务?
- mysql - 如何从sql中的现有列创建新列