javascript - 在脚本的另一部分使用 DataTables 返回的变量内容

Question

如何在脚本的另一部分的“列:”中使用“DeviceID”。我已经尝试了各种方法，例如重新定位一些代码，但无论我做什么，我都无法让它工作。

我需要使用“DeviceID”作为变量

"url: 'get_wayfinder_offline_status.php', data: { DeviceID: deviceid },"

查看<< USE THIS IN PART MARKED "HERE"

$(document).ready(function() {
  var table = $('#WayFinderStatusTable').DataTable({
    ordering: false,
    paging: false,
    searching: false,
    bInfo: false,
    responsive: true,
    fixedHeader: true,
    scrollX: false,
    pageResize: true,
    ajax: {
      url: 'check_wayfinder_status.php',
      dataSrc: ''
    },
    columns: [{
        data: 'DisplayDescription',
        "sWidth": "100%"
      },
      {
        data: 'DeviceName',
        "visible": false
      },
      {
        data: 'MessageCount',
        "visible": false
      },
      {
        data: 'BoardOverride',
        "visible": false
      },
      {
        data: 'DeviceID',
        "visible": false
      }, // << USE THIS IN PART MAKED "HERE"
    ],
    rowCallback: function(row, data, dataIndex) {
      if (data.MessageCount == 2) {
        $(row).find('td:eq(0)').addClass('WayFinderStatusTableOn HeaderStatusWayfinderRedTextBlink');
      } else if (data.BoardOverride == 1) {
        $(row).find('td:eq(0)').addClass('WayFinderStatusTableOverrideOn ');
        $('#WayFinderStatusTable tbody').on('click', 'tr', function() {
          var hotelid = "<?php echo $_SESSION['_amember_user']['hotelid'];?>";
          var data = table.row(this).data();
          var deviceid = data.DeviceID;
          console.log("DEVICE ID", deviceid);
          $.ajax({
            url: 'get_wayfinder_override_status.php',
            data: {
              DeviceID: deviceid
            },
            type: 'POST',
            dataType: 'JSON',
            success: function(data) {
              var result = JSON.stringify(data);
              result = JSON.parse(result);
              if (result.length > 0) {
                console.log("BoardName", result);
                $('#EditOverrideWayfinderRecordID').val(result[0]);
                $('#EditOverrideWayfinderBoardName').val(result[1]);
                var testimage = result[2];
                console.log("TEST IMAGE", testimage);
                $('#EditOverrideWayfinderImage').val(result[2]);
                var imagepath = '../../../../conf/conf_images/override/' + hotelid + '/' + result[2];
                $("#EditOverrideWayfinderLookUpCompanyImage").attr("src", imagepath);
                $("#EditOverrideWayfinderImagePreview").attr("src", imagepath);
                $('#EditOverrideWayfinderRoomFromDate').val(result[3]);
                $('#EditOverrideWayfinderRoomFromTimeH').val(result[4]);
                $('#EditOverrideWayfinderRoomFromTimeM').val(result[5]);
                $('#EditOverrideWayfinderRoomToDate').val(result[6]);
                $('#EditOverrideWayfinderRoomToTimeH').val(result[7]);
                $('#EditOverrideWayfinderRoomToTimeM').val(result[8]);
                $('#EditOverrideWayfinderPromotionName').val(result[9]);
                $('#EditOverrideWayfinderHardwareID').val(result[10]);
                $('#edit_wayfinder_override_data_modal').modal('show');
              }
            }
          });
        });
      } else if (data.BoardOverride == "") {
        $(row).find('td:eq(0)').addClass('WayFinderStatusTableOff');
      }
    },
  });

  $(document).on('click', '.WayFinderStatusTableOff', function(e) {
    $('#wayfinder_override_data_modal').modal('show');
  });

  $(document).on('click', '.WayFinderStatusTableOn', function(e) {
    console.log("OFFLINE CLICKED");
    $.ajax({
      url: 'get_wayfinder_offline_status.php',
      data: {
        DeviceID: deviceid //<<HERE
      },
      type: 'POST',
      dataType: 'JSON',
      success: function(data) {
        var result = JSON.stringify(data);
        result = JSON.parse(result);
        if (result.length > 0) {
          // DO SOMETHING
        }
      }
    });
    $('#offline_data_modal').modal('show');
  });

  setInterval(function() {
    $('#WayFinderStatusTable').DataTable().ajax.reload();
  }, 30000);
});

Answer 1

根据数据表和列的结构，单击一行，使用方法 table.row( this ).data(); 查找 deviceId，然后找到该行的正确索引数据。

$('#WayFinderStatusTable').on('click', 'tr', function () {
   const data = table.row( this ).data();
   const deviceId = data[4];
   alert(deviceId + ' -> deviceid');
});