如何根据选择在jquery数据表中隐藏页脚 [英] How to hide footer in jquery datatable based on selection
问题描述
HI，
我正在使用Jquery DataTable。我需要根据选择来输入整个列。
PLease帮我怎么做。
谢谢
我的尝试：
函数CreateTableFromJSON（数据，ID，RpType）{
$（'＃FOOTER'）。hide（）;
$（'＃ 。FOOTER'）空（）;
var col = [];
if（$ .fn.dataTable.isDataTable（'＃example'））{
table.destroy （）;
$（'＃tblempDetails'）。empty（）;
}
for（var i = 0; i< Data.length; i ++）{
for（Data [i]中的var键）{
if（col.indexOf（key）=== -1）{
col.push（key）;
}
}
}
var HEADER =;
HEADER + =
var Footer =;
页脚+ =
var Total1 = 0;
var Total2 = 0;
var Total3 = 0;
var Total4 = 0;
var Total5 = 0;
var Total6 = 0;
var Total7 = 0;
var Total8 = 0;
var Total9 = 0;
var Total10 = 0;
var Total11 = 0;
for（var i = 0; i< col.length; i ++）{
HEADER + =+ col [i] .toUpperCase（）+ ;
调试器;
}
HEADER + =
if（HEADER！= null）{
if（document。 getElementById（'HEADER'）！= null）{
document.getElementById（'HEADER'）。innerHTML = HEADER;
}
}
var html =;
for（var i = 0; i< Data.length; i ++）{
debugger;
html + ='';
for（var j = 0; j< col.length; j ++）{
if（ID = ='1.0.2'）{
if（RpType =='10'）{
if（j =='5'）{
Total1 = Total1 + Data [i] [col [j]];
}
if（j =='6'）{
Total2 = Total2 + Data [i] [col [j]];
}
if（j =='7'）{
Total3 = Total3 + Data [i] [col [j]];
}
if（j =='8'）{
Total4 = Total4 + Data [i] [col [j]];
}
if（j =='9'）{
Total5 = Total5 + Data [i] [col [j]];
}
if（j =='10'）{
Total6 = Total6 + Data [i] [col [j]];
}
if（j == '11'）{
Total7 = Total7 + Data [i] [col [j]];
}
} b / b
}
if（Data [i] [col [j]]！= null ）{
var dt = Data [i] [col [j]]。toString（）;
var letters = /^ [0-9-.]*$/;
if（dt.match（字母）&& dt！=&& dt！= Data [i] [SLNO]&& dt！= Data [ i] [ITEMCODE]&& dt！= Data [i] [SlNo]&& dt！= Data [i] [slno]&& dt！= Data [i] [ItemCode]&& dt！= Data [i] [Itemcode]&& dt！= Data [i] [itemcode]&& dt！= Data [i] [ OEMCode]&& dt！= Data [i] [OEMCODE]&& dt！= Data [i] [OemCode]&& dt！= Data [i] [OEM ]）{
调试器;
html + =''+ parseFloat（Data [i] [col [j]]）。toFixed（2）+''; < br $>
}
else {
html + =''+ Data [i] [col [j]] +'';
}
}
其他
html + =''+''+'';
}
html + ='';
}
if（ID =='1.0.2'）{
if（RpType =='10'）{
Footer + =+;
页脚+ =+;
页脚+ =+;
页脚+ =+;
页脚+ =+ ;
页脚+ =+// CURQTY
页脚+ =+//价格
页脚+ = +// CLOSING.VAL
页脚+ =+// RECEIVEDVALUE
页脚+ =+// ISSUEDQTY
Footer + =+;
页脚+ =+// MRP
页脚+ =+// MRPVALUE
页脚+ = +;
页脚+ =+;
}
}
var leng = col.length;
/ / alert（leng）;
var flength = Footer.length;
// alert（flength）;
if（document.getElementById（'tblempDetails'）！= null）{
document.getElementById（ 'tblempDetails'）。innerHTML = html;
}
调试器;
if（$ .fn.dataTable.isDataTable（'＃example'） ））{
table = $（'＃example'）。DataTable（{
response：true，
columnDefs：[
{responsivePriority：1，目标：0}，
{responsivePriority：2，目标：-2}，
]，
分页：true，
搜索：true，
dom：'Bfrtip'，按钮：['colvis'，'excel']
}）;
}
else {
调试器;
table = $（'＃example'） .DataTable（{
责任香港专业教育学院：真的，
columnDefs：[
{responsivePriority：1，目标：0}，
{responsivePriority：2，目标：-2 }
]，
分页：真，
搜索：true，
dom：'Bfrtip'，按钮：['colvis'，'excel']
}）;
}
if（ID =='1.0.2'）{
if（RpType =='10'）{
$（'＃FOOTER'）。show（）;
debugger;
if（document.getElementById（'FOOTER'）！= null&& document.getElementById（'FOOTER'）！= undefined）{
document.getElementById（'FOOTER' ）.innerHTML =页脚;
}
$（'＃txt1'）。text（Total1.toFixed（2））;
$ （ '＃TXT2'）。文本（Total2.toFixed （2））;
$（'＃txt3'）。text（Total3.toFixed（2））;
$（'＃txt4'）。text（Total4 .toFixed（2））;
$（'＃txt5'）。text（Total5.toFixed（2））;
$（'＃txt6'）。text （Total6.toFixed（2））;
$（'＃txt7'）。text（Total7.toFixed（2））;
}
}
}
I am using Jquery DataTable.I need to hode an entire column based on selection.
PLease help me how to do it.
Thank you
What I have tried:
function CreateTableFromJSON(Data, ID, RpType) {
$('#FOOTER').hide();
$('#FOOTER').empty();
var col = [];
if ($.fn.dataTable.isDataTable('#example')) {
table.destroy();
$('#tblempDetails').empty();
}
for (var i = 0; i < Data.length; i++) {
for (var key in Data[i]) {
if (col.indexOf(key) === -1) {
col.push(key);
}
}
}
var HEADER = "";
HEADER += ""
var Footer = "";
Footer += ""
var Total1 = 0;
var Total2 = 0;
var Total3 = 0;
var Total4 = 0;
var Total5 = 0;
var Total6 = 0;
var Total7 = 0;
var Total8 = 0;
var Total9 = 0;
var Total10 = 0;
var Total11 = 0;
for (var i = 0; i < col.length; i++) {
HEADER += "" + col[i].toUpperCase() + "";
debugger;
}
HEADER += ""
if (HEADER != null) {
if (document.getElementById('HEADER') != null) {
document.getElementById('HEADER').innerHTML = HEADER;
}
}
var html = "";
for (var i = 0; i < Data.length; i++) {
debugger;
html += '';
for (var j = 0; j < col.length; j++) {
if (ID == '1.0.2') {
if (RpType == '10') {
if (j == '5') {
Total1 = Total1 + Data[i][col[j]];
}
if (j == '6') {
Total2 = Total2 + Data[i][col[j]];
}
if (j == '7') {
Total3 = Total3 + Data[i][col[j]];
}
if (j == '8') {
Total4 = Total4 + Data[i][col[j]];
}
if (j == '9') {
Total5 = Total5 + Data[i][col[j]];
}
if (j == '10') {
Total6 = Total6 + Data[i][col[j]];
}
if (j == '11') {
Total7 = Total7 + Data[i][col[j]];
}
}
}
}
if (Data[i][col[j]] != null) {
var dt = Data[i][col[j]].toString();
var letters = /^[0-9-.]*$/;
if (dt.match(letters) && dt != "" && dt != Data[i]["SLNO"] && dt != Data[i]["ITEMCODE"] && dt != Data[i]["SlNo"] && dt != Data[i]["slno"] && dt != Data[i]["ItemCode"] && dt != Data[i]["Itemcode"] && dt != Data[i]["itemcode"] && dt != Data[i]["OEMCode"] && dt != Data[i]["OEMCODE"] && dt != Data[i]["OemCode"] && dt != Data[i]["OEM"]) {
debugger;
html += '' + parseFloat(Data[i][col[j]]).toFixed(2) + '';
}
else {
html += '' + Data[i][col[j]] + '';
}
}
else
html += '' + '' + '';
}
html += '';
}
if (ID == '1.0.2') {
if (RpType == '10') {
Footer += "" + "";
Footer += "" + "";
Footer += "" + "";
Footer += "" + "";
Footer += "" + "";
Footer += "" + "" //CURQTY
Footer += "" + "" //RATE
Footer += "" + "" //CLOSING.VAL
Footer += "" + "" //RECEIVEDVALUE
Footer += "" + "" //ISSUEDQTY
Footer += "" + "";
Footer += "" + "" //MRP
Footer += "" + "" //MRPVALUE
Footer += "" + "";
Footer += "" + "";
}
}
var leng = col.length;
// alert(leng);
var flength = Footer.length;
//alert(flength);
if (document.getElementById('tblempDetails') != null) {
document.getElementById('tblempDetails').innerHTML = html;
}
debugger;
if ($.fn.dataTable.isDataTable('#example')) {
table = $('#example').DataTable({
responsive: true,
columnDefs: [
{ responsivePriority: 1, targets: 0 },
{ responsivePriority: 2, targets: -2 },
],
paging: true,
searching: true,
dom: 'Bfrtip', buttons: ['colvis', 'excel']
});
}
else {
debugger;
table = $('#example').DataTable({
responsive: true,
columnDefs: [
{ responsivePriority: 1, targets: 0 },
{ responsivePriority: 2, targets: -2 }
],
paging: true,
searching: true,
dom: 'Bfrtip', buttons: ['colvis', 'excel']
});
}
if (ID == '1.0.2') {
if (RpType == '10'){
$('#FOOTER').show();
debugger;
if (document.getElementById('FOOTER') != null&&document.getElementById('FOOTER') != undefined) {
document.getElementById('FOOTER').innerHTML = Footer;
}
$('#txt1').text(Total1.toFixed(2));
$('#txt2').text(Total2.toFixed(2));
$('#txt3').text(Total3.toFixed(2));
$('#txt4').text(Total4.toFixed(2));
$('#txt5').text(Total5.toFixed(2));
$('#txt6').text(Total6.toFixed(2));
$('#txt7').text(Total7.toFixed(2));
}
}
}
推荐答案
（'＃FOOTER'）。hide（）;
('#FOOTER').hide();
（'＃FOOTER'）。empty（）;
var col = [];
if（
('#FOOTER').empty();
var col = [];
if (
.fn.dataTable.isDataTable（'＃example'））{
table.destroy（）;
.fn.dataTable.isDataTable('#example')) {
table.destroy();
这篇关于如何根据选择在jquery数据表中隐藏页脚的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
