如何获取未使用jquery数据表选择的行数据。 [英] How to get row data which is not selected using jquery datatables.
问题描述
大家好，
我试图根据选中的行点击一个按钮来改变表的行顺序。
like我想首先显示所选行，然后显示Jquery Datatable中剩余的行。
你可以请参阅rowseleted每个用于显示首先选择的行无法获取未选择的数据。可以任何人帮助我
我尝试过：
这是我到目前为止尝试的脚本。
Hi guys,
Im trying to change the row order of the table when a button clicked based on rows selected.
like i want to display the selected rows first then the remaining rows in Jquery Datatable.
you can see rowseleted each which is meant to display the rows selected first im unable to get the data which is not selected. can any one help me out
What I have tried:
here is the script i tried so far.
$（' #reloadID'）。click（function（）{var prevSelection =;
var tr = $（this）.closest（'tr'）;
var rowsSelected = table.rows（'。selected'）。data（）;
var complete = table.rows（）。data（）;
// var nonselected = table .row（tr）.node（）。className;
// var test = $（＃mytbl）。dataTable（）。fnGetNodes（）。className;
// console.log（未选中）;
var mcb ='< th />';
var vendorsTable =' < table id =mytbl>
< thead>
< tr>'+ mcb +'< th> xyz< / th>
< th> zy< / th>
< th> xyz< / th>
< th& gt; xy< / th>';
vendorsTable = vendorsTable +'< th> City< / th>
< th> State< / th>
< th> Zip< / th>
< / tr>
< / thead>
< ; tbody>';
$ .each（rowsSelected，function（）{
var $ this1 = this;
if（$ this1 [2] +，+，！= prevSelection）{
var selected =;
var ccb ='< td />';
vendorsTable = vendorsTable +'< tr class =>'+ ccb +'< td>'+ $ this1 [1] +'< / td>
< td>'+ $ this1 [2] +'< / td>
< td>'+ $ this1 [3] +'< / td>
< td>'+ $ this1 [4] +'< / td>'
+'< td>'+ $ this1 [5] +'< / td>
< td>'+ $ this1 [6] +'< / td>
< td>'+ $ this1 [7] +'< ; / td>'
+'< / tr>';
prevSelection = $ this1 [2] +，+，;
}
}）;
vendorsTable = vendorsTable +'< / tbody>
< / table>';
$（'＃Vendors'）。empty（） ;
$（'＃供应商）.append（vendorsTable）;
//初始化用datatable插件生成的表
table = $（'＃mytbl'）。DataTable（{
oLanguage：{sSearch：}，
columnDefs：[{
orderable：true，
className：'select-checkbox'，
目标：0
}]，
选择：{
style ：'multi'，
选择器：'td：first-child'
}，
dom： 'T<clear> lfrtip'，
tableTools：{
sRowSelect：multi，
aButtons： [select_all，select_none，
{
sExtends：select_all，
sButtonText：选择过滤，
fnClick：函数（nButton，oConfig，oFlash）{
var oTT = TableTools.fnGetInstance（' mytbl'）;
//删除之前的选择
oTT.fnSelectNone（）;
oTT.fnSelectAll（true）; // True =仅选择已过滤的行（true）。可选 - 默认为false。
}
}，
{
sExtends：select_none，
sButtonText：取消选择过滤，
fnClick：function（nButton，oConfig，oFlash）{
var oTT = TableTools。 fnGetInstance（'mytbl'）;
//删除之前的选择
oTT.fnSelectNone（true）;
}
}
]
}，
订单：[1，'asc']
}
}）;
}}）;
$('#reloadID').click(function () { var prevSelection = "";
var tr = $(this).closest('tr');
var rowsSelected = table.rows('.selected').data();
var complete = table.rows().data();
//var nonselected = table.row(tr).node().className;
//var test = $("#mytbl").dataTable().fnGetNodes().className;
// console.log(nonselected);
var mcb = '<th/>';
var vendorsTable = '<table id="mytbl">
<thead>
<tr>' + mcb + '<th>xyz</th>
<th>zy</th>
<th>xyz</th>
<th>xy</th>';
vendorsTable = vendorsTable + '<th>City</th>
<th>State</th>
<th>Zip</th>
</tr>
</thead>
<tbody>';
$.each(rowsSelected, function () {
var $this1 = this;
if ($this1[2] + "," + "," != prevSelection) {
var selected = "";
var ccb = '<td/>';
vendorsTable = vendorsTable + '<tr class="">' + ccb + '<td>' + $this1[1] + '</td>
<td>' + $this1[2] + '</td>
<td>' + $this1[3] + '</td>
<td>' + $this1[4] + '</td>'
+ '<td>' + $this1[5] + '</td>
<td>' + $this1[6] + '</td>
<td>' + $this1[7] + '</td>'
+ '</tr>';
prevSelection = $this1[2] + "," + ",";
}
});
vendorsTable = vendorsTable + '</tbody>
</table>';
$('#Vendors').empty();
$('#Vendors').append(vendorsTable);
//Initialize the table generated with datatable plug-in
table = $('#mytbl').DataTable({
"oLanguage": { "sSearch": "" },
columnDefs: [{
orderable: true,
className: 'select-checkbox',
targets: 0
}],
select: {
style: 'multi',
selector: 'td:first-child'
},
dom: 'T<"clear">lfrtip',
tableTools: {
"sRowSelect": "multi",
"aButtons": ["select_all", "select_none",
{
"sExtends": "select_all",
"sButtonText": "Select Filtered",
"fnClick": function (nButton, oConfig, oFlash) {
var oTT = TableTools.fnGetInstance('mytbl');
//remove previous selections
oTT.fnSelectNone();
oTT.fnSelectAll(true); //True = Select only filtered rows (true). Optional - default false.
}
},
{
"sExtends": "select_none",
"sButtonText": "Deselect Filtered",
"fnClick": function (nButton, oConfig, oFlash) {
var oTT = TableTools.fnGetInstance('mytbl');
//remove previous selections
oTT.fnSelectNone(true);
}
}
]
},
order: [1, 'asc']
}
});
} });
推荐答案
（'＃ reloadID'）。click（function（）{var prevSelection =;
var tr =
('#reloadID').click(function () { var prevSelection = "";
var tr =
（this）.closest（'tr'）;
var rowsSelected = table.rows（'。selected'）。data（）;
var complete = table.rows（）。data（）;
// var nonselected = table.row（tr）.node（）。className;
// var test =
(this).closest('tr');
var rowsSelected = table.rows('.selected').data();
var complete = table.rows().data();
//var nonselected = table.row(tr).node().className;
//var test =
（＃mytbl ）.dataTable（）。fnGetNodes（）。className;
// console.log（未选中）;
var mcb ='< ; th />';
var vendorsTable ='< table id =mytbl>
< thead>
< ; tr>'+ mcb +'< th> xyz< / th>
< th> zy< / th>
< th> xyz< / th> ;
< th> xy< / th>';
vendorsTable = vendorsTable +'< th> City< / th>
< th> State< / th>
< th> Zip< / th>
< / tr>
< / thead>
< tbody>';
("#mytbl").dataTable().fnGetNodes().className;
// console.log(nonselected);
var mcb = '<th/>';
var vendorsTable = '<table id="mytbl">
<thead>
<tr>' + mcb + '<th>xyz</th>
<th>zy</th>
<th>xyz</th>
<th>xy</th>';
vendorsTable = vendorsTable + '<th>City</th>
<th>State</th>
<th>Zip</th>
</tr>
</thead>
<tbody>';
这篇关于如何获取未使用jquery数据表选择的行数据。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
