Dave Cross: Still Munging Data With Perl: Online event - Mar 27 Learn more

OLIVER / App-Netdisco-2.084001 / share / views / ajax / report / apradiochannelpower.tt 

            

              
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115

              
<table id="data-table" class="table table-bordered table-hover" width="100%" cellspacing="0">
  <thead>
    <tr>
      <th>IP</th>
      <th>DNS</th>
      <th>Device</th>
      <th>Port</th>            
      <th>Name</th>
      <th>Description</th>
      <th class="nd_center-cell">Channel</th>
      <th class="nd_center-cell">Tx Power (mW/dBm)</th>
    </tr>
  </thead>
</table>
<style>
tr.group,
tr.group:hover {
    background-color: #ddd !important;
}
</style>
<script>
function groupString(d) {
    "use strict";
    var s = '';
    s = s + 'Device: ';
    s = s + '<a href="[% uri_for('/device') | none %]?tab=details&q=' + encodeURIComponent(d.ip) + '">';
    s = s + he.encode(d.dns || d.device_name || d.ip);
    if (d.dns || d.device_name) {
        s = s + ' (' +  he.encode(d.ip) + ') ';
    }
    s = s + '</a> Model: ' + he.encode(d.model || '');
    s = s + he.encode(d.location ? ' Location: ' + d.location : '');
    return s;
}
$(document).ready(function() {
  var table = $('#data-table').DataTable({
    "serverSide": true,
    "ajax": "[% uri_for('/ajax/content/report/apradiochannelpower/data') | none %]",
    "order": [[ 0, 'asc' ]],
    "columns": [
      {
        // Grouping column
        "data": 'ip',
        "visible": false
      }, {
        // Included for filtering
        "data": 'dns',
        "visible": false
      }, {
        // Included for filtering
        "data": 'device_name',
        "visible": false
      }, {
        "data": 'port',
        "type": 'portsort',
        "render": function(data, type, row, meta) {
          return type === 'display' ?
            '<a href="[% device_ports | none %]&q=' + encodeURIComponent(row.ip) + '&f=' + encodeURIComponent(data) + '">' + he.encode(data || '') + '</a>' :
            he.encode(data || '');
        }
      }, {
        "data": 'port_name',
        "render": function(data, type, row, meta) {
          return he.encode(data || '');
        }
      }, {
        "data": 'descr',
        "render": function(data, type, row, meta) {
          return he.encode(data || '');
        }
      }, {
        "data": 'channel',
        "className": "nd_center-cell"
      }, {
        "data": 'power',
        "className": "nd_center-cell",
        "render": function(data, type, row, meta) {
          return (row.power2 ? data + ' / ' + row.power2 : '');
        }
      }
    ],
    "drawCallback": function ( settings ) {
      var api = this.api();
      var rows = api.rows( {page:'current'} ).nodes();
      var last=null;
      api.column(0, {page:'current'} ).data().each( function ( group, i ) {
        if ( last !== group ) {
          var row_data = api.row( i ).data();
          $(rows).eq( i ).before(
            '<tr class="group"><td colspan="5">' + groupString(row_data) + '</td></tr>'
            );
          last = group;
        }
      } );
    },
[% INCLUDE 'ajax/datatabledefaults.tt' -%]
  } );
  
  // Order by the grouping
  $('#data-table tbody').on( 'click', 'tr.group', function () {
    var currentOrder = table.order()[0];
    if ( currentOrder[0] === 0 && currentOrder[1] === 'asc' ) {
      table.order( [ 0, 'desc' ] ).draw();
    }
    else {
      table.order( [ 0, 'asc' ] ).draw();
    }
  } );
} );
</script>