applications/luci-app-nlbwmon/luasrc/view/nlbw/display.htm

   1 <%#
   2  Copyright 2017 Jo-Philipp Wich <jo@mein.io>
   3  Licensed to the public under the Apache License 2.0.
   4 -%>
   5
   6 <% css = [[
   7
   8     #chartjs-tooltip {
   9         opacity: 0;
  10         position: absolute;
  11         background: rgba(0, 0, 0, .7);
  12         color: white;
  13         padding: 3px;
  14         border-radius: 3px;
  15         -webkit-transition: all .1s ease;
  16         transition: all .1s ease;
  17         pointer-events: none;
  18         -webkit-transform: translate(-50%, 0);
  19         transform: translate(-50%, 0);
  20                 z-index: 200;
  21     }
  22
  23     #chartjs-tooltip.above {
  24         -webkit-transform: translate(-50%, -100%);
  25         transform: translate(-50%, -100%);
  26     }
  27
  28     #chartjs-tooltip.above:before {
  29         border: solid;
  30         border-color: #111 transparent;
  31         border-color: rgba(0, 0, 0, .8) transparent;
  32         border-width: 8px 8px 0 8px;
  33         bottom: 1em;
  34         content: "";
  35         display: block;
  36         left: 50%;
  37         top: 100%;
  38         position: absolute;
  39         z-index: 99;
  40         -webkit-transform: translate(-50%, 0);
  41         transform: translate(-50%, 0);
  42     }
  43
  44         table {
  45                 border: 1px solid #999;
  46                 border-collapse: collapse;
  47                 margin: 0 0 2px !important;
  48         }
  49
  50         th, td, table table td {
  51                 border: 1px solid #999;
  52                 text-align: right;
  53                 padding: 1px 3px !important;
  54                 white-space: nowrap;
  55         }
  56
  57         tbody td {
  58                 border-bottom-color: #ccc;
  59         }
  60
  61         tbody td[rowspan] {
  62                 border-bottom-color: #999;
  63         }
  64
  65         tbody tr:last-child td {
  66                 border-bottom-color: #999;
  67         }
  68
  69
  70         .pie {
  71                 width: 200px;
  72                 display: inline-block;
  73                 margin: 20px;
  74         }
  75
  76         .pie label {
  77                 font-weight: bold;
  78                 font-size: 14px;
  79                 display: block;
  80                 margin-bottom: 10px;
  81                 text-align: center;
  82         }
  83
  84         .kpi {
  85                 display: inline-block;
  86                 margin: 80px 20px 20px;
  87                 vertical-align: top;
  88         }
  89
  90         .kpi ul {
  91                 list-style: none;
  92         }
  93
  94         .kpi li {
  95                 margin: 10px;
  96                 display: none;
  97         }
  98
  99         .kpi big {
 100                 font-weight: bold;
 101         }
 102
 103         #detail-bubble {
 104                 position: absolute;
 105                 opacity: 0;
 106                 visibility: hidden;
 107         }
 108
 109         #detail-bubble.in {
 110                 opacity: 1;
 111                 visibility: visible;
 112                 transition: opacity 0.5s;
 113         }
 114
 115         #detail-bubble > div {
 116                 border: 1px solid #ccc;
 117                 border-radius: 2px;
 118                 padding: 5px;
 119                 background: #fcfcfc;
 120         }
 121
 122         #detail-bubble .head {
 123                 text-align: center;
 124                 white-space: nowrap;
 125                 position: relative;
 126         }
 127
 128         #detail-bubble .head .dismiss {
 129                 top: 0;
 130                 right: 0;
 131                 width: 20px;
 132                 line-height: 20px;
 133                 text-align: center;
 134                 text-decoration: none;
 135                 font-weight: bold;
 136                 color: #000;
 137                 position: absolute;
 138                 font-size: 20px;
 139         }
 140
 141         #detail-bubble .pie {
 142                 width: 100px;
 143                 margin: 5px;
 144         }
 145
 146         #detail-bubble .kpi {
 147                 margin: 40px 5px 5px;
 148                 font-size: smaller;
 149                 text-align: left;
 150         }
 151
 152         #detail-bubble .kpi ul {
 153                 margin: 0;
 154         }
 155
 156         #bubble-arrow {
 157                 border: 1px solid #ccc;
 158                 border-width: 1px 0 0 1px;
 159                 background: #fcfcfc;
 160                 width: 15px;
 161                 height: 15px;
 162                 position: absolute;
 163                 left: 0;
 164                 top: -8px;
 165                 transform: rotate(45deg);
 166                 margin: 0 0 0 -8px;
 167         }
 168
 169         tr.active > td {
 170                 border-bottom: 2px solid red;
 171         }
 172
 173         tr.active > td.active {
 174                 border: 2px solid red;
 175                 border-bottom: none;
 176         }
 177
 178         td.detail {
 179                 border: 2px solid red;
 180                 border-top: none;
 181                 opacity: 0;
 182                 transition: opacity 0.5s;
 183         }
 184
 185         td.detail.in {
 186                 opacity: 1;
 187         }
 188
 189         th.hostname,
 190         td.hostname {
 191                 text-align: left;
 192         }
 193
 194 ]] -%>
 195
 196 <%+header%>
 197
 198 <script type="text/javascript" src="<%=resource%>/cbi.js"></script>
 199 <script type="text/javascript" src="<%=resource%>/nlbw.chart.min.js"></script>
 200 <script type="text/javascript">//<![CDATA[
 201
 202 var chartRegistry = {},
 203         trafficPeriods = [],
 204         trafficData = { columns: [], data: [] },
 205         hostNames = {},
 206         hostInfo = <%=luci.util.serialize_json(luci.sys.net.host_hints())%>,
 207         ouiData = [];
 208
 209
 210 function off(elem)
 211 {
 212         var val = [0, 0];
 213         do {
 214                 if (!isNaN(elem.offsetLeft) && !isNaN(elem.offsetTop)) {
 215                         val[0] += elem.offsetLeft;
 216                         val[1] += elem.offsetTop;
 217                 }
 218         }
 219         while ((elem = elem.offsetParent) != null);
 220         return val;
 221 }
 222
 223 Chart.defaults.global.customTooltips = function(tooltip) {
 224         var tooltipEl = document.getElementById('chartjs-tooltip');
 225
 226         if (!tooltipEl) {
 227                 tooltipEl = document.createElement('div');
 228                 tooltipEl.setAttribute('id', 'chartjs-tooltip');
 229                 document.body.appendChild(tooltipEl);
 230         }
 231
 232         if (!tooltip) {
 233                 if (tooltipEl.row)
 234                         tooltipEl.row.style.backgroundColor = '';
 235
 236                 tooltipEl.style.opacity = 0;
 237                 return;
 238         }
 239
 240         var pos = off(tooltip.chart.canvas);
 241
 242         tooltipEl.className = tooltip.yAlign;
 243         tooltipEl.innerHTML = tooltip.text[0];
 244
 245         tooltipEl.style.opacity = 1;
 246         tooltipEl.style.left = pos[0] + tooltip.x + 'px';
 247         tooltipEl.style.top = pos[1] + tooltip.y - tooltip.caretHeight - tooltip.caretPadding + 'px';
 248
 249         var row = tooltip.text[1],
 250             hue = tooltip.text[2];
 251
 252         if (row && !isNaN(hue)) {
 253                 row.style.backgroundColor = 'hsl(%u, 100%%, 80%%)'.format(hue);
 254                 tooltipEl.row = row;
 255         }
 256 };
 257
 258 Chart.defaults.global.tooltipFontSize = 10;
 259 Chart.defaults.global.tooltipTemplate = function(tip) {
 260         tip.label[0] = tip.label[0].format(tip.value);
 261         return tip.label;
 262 };
 263
 264 function kpi(id, val1, val2, val3)
 265 {
 266         var e = document.getElementById(id);
 267
 268         if (val1 && val2 && val3)
 269                 e.innerHTML = '<%:%s, %s and %s%>'.format(val1, val2, val3);
 270         else if (val1 && val2)
 271                 e.innerHTML = '<%:%s and %s%>'.format(val1, val2);
 272         else if (val1)
 273                 e.innerHTML = val1;
 274
 275         e.parentNode.style.display = val1 ? 'list-item' : '';
 276 }
 277
 278 function pie(id, data)
 279 {
 280         data.sort(function(a, b) { return b.value - a.value });
 281
 282         for (var i = 0; i < data.length; i++) {
 283                 if (!data[i].color) {
 284                         var hue = 120 / (data.length-1) * i;
 285                         data[i].color = 'hsl(%u, 80%%, 50%%)'.format(hue);
 286                         data[i].label.push(hue);
 287                 }
 288         }
 289
 290         var ctx = document.getElementById(id).getContext('2d');
 291
 292         if (chartRegistry.hasOwnProperty(id))
 293                 chartRegistry[id].destroy();
 294
 295         chartRegistry[id] = new Chart(ctx).Doughnut(data, {
 296                 segmentStrokeWidth: 1,
 297                 percentageInnerCutout: 30
 298         });
 299
 300         return chartRegistry[id];
 301 }
 302
 303 function query(filter, group, order)
 304 {
 305         var keys = [], columns = {}, records = {}, result = [];
 306
 307         if (typeof(group) !== 'function' && typeof(group) !== 'object')
 308                 group = ['mac'];
 309
 310         for (var i = 0; i < trafficData.columns.length; i++)
 311                 columns[trafficData.columns[i]] = i;
 312
 313         for (var i = 0; i < trafficData.data.length; i++) {
 314                 var record = trafficData.data[i];
 315
 316                 if (typeof(filter) === 'function' && filter(columns, record) !== true)
 317                         continue;
 318
 319                 var key;
 320
 321                 if (typeof(group) === 'function') {
 322                         key = group(columns, record);
 323                 }
 324                 else {
 325                         key = [];
 326
 327                         for (var j = 0; j < group.length; j++)
 328                                 if (columns.hasOwnProperty(group[j]))
 329                                         key.push(record[columns[group[j]]]);
 330
 331                         key = key.join(',');
 332                 }
 333
 334                 if (!records.hasOwnProperty(key)) {
 335                         var rec = {};
 336
 337                         for (var col in columns)
 338                                 rec[col] = record[columns[col]];
 339
 340                         records[key] = rec;
 341                         result.push(rec);
 342                 }
 343                 else {
 344                         records[key].conns    += record[columns.conns];
 345                         records[key].rx_bytes += record[columns.rx_bytes];
 346                         records[key].rx_pkts  += record[columns.rx_pkts];
 347                         records[key].tx_bytes += record[columns.tx_bytes];
 348                         records[key].tx_pkts  += record[columns.tx_pkts];
 349                 }
 350         }
 351
 352         if (typeof(order) === 'function')
 353                 result.sort(order);
 354
 355         return result;
 356 }
 357
 358 function oui(mac) {
 359         var m, l = 0, r = ouiData.length / 3 - 1;
 360         var mac1 = parseInt(mac.replace(/[^a-fA-F0-9]/g, ''), 16);
 361
 362         while (l <= r) {
 363                 m = l + Math.floor((r - l) / 2);
 364
 365                 var mask = (0xffffffffffff -
 366                                         (Math.pow(2, 48 - ouiData[m * 3 + 1]) - 1));
 367
 368                 var mac1_hi = ((mac1 / 0x10000) & (mask / 0x10000)) >>> 0;
 369                 var mac1_lo = ((mac1 &  0xffff) & (mask &  0xffff)) >>> 0;
 370
 371                 var mac2 = parseInt(ouiData[m * 3], 16);
 372                 var mac2_hi = (mac2 / 0x10000) >>> 0;
 373                 var mac2_lo = (mac2 &  0xffff) >>> 0;
 374
 375                 if (mac1_hi === mac2_hi && mac1_lo === mac2_lo)
 376                         return ouiData[m * 3 + 2];
 377
 378                 if (mac2_hi > mac1_hi ||
 379                         (mac2_hi === mac1_hi && mac2_lo > mac1_lo))
 380                         r = m - 1;
 381                 else
 382                         l = m + 1;
 383         }
 384
 385         return null;
 386 }
 387
 388
 389 function fetchData(period)
 390 {
 391         XHR.get('<%=url("admin/nlbw/data")%>', { period: period, group_by: 'family,mac,ip,layer7', order_by: '-rx_bytes,-tx_bytes' }, function(xhr, res) {
 392                 if (res !== null && typeof(res) === 'object' && typeof(res.columns) === 'object' && typeof(res.data) === 'object')
 393                         trafficData = res;
 394
 395                 var addrs = query(null, ['ip'], null);
 396                 var ipAddrs = [];
 397
 398                 for (var i = 0; i < addrs.length; i++)
 399                         if (ipAddrs.indexOf(addrs[i].ip) < 0)
 400                                 ipAddrs.push(addrs[i].ip);
 401
 402                 renderHostData();
 403                 renderLayer7Data();
 404                 renderIPv6Data();
 405
 406                 XHR.get('<%=url("admin/nlbw/ptr")%>/' + ipAddrs.join('/'), null, function(xhr, res) {
 407                         if (res !== null && typeof(res) === 'object')
 408                                 hostNames = res;
 409                 });
 410         });
 411 }
 412
 413 function switchTab(tab)
 414 {
 415         bubbleDismiss();
 416
 417         return cbi_t_switch('nlbw', tab);
 418 }
 419
 420 function renderPeriods()
 421 {
 422         var sel = document.getElementById('nlbw.period');
 423
 424         for (var e, i = trafficPeriods.length - 1; e = trafficPeriods[i]; i--) {
 425                 var d1 = new Date(e);
 426                 var d2;
 427
 428                 if (i) {
 429                         d2 = new Date(trafficPeriods[i - 1]);
 430                         d2.setDate(d2.getDate() - 1);
 431                 }
 432                 else {
 433                         d2 = new Date();
 434                 }
 435
 436                 var opt = document.createElement('option');
 437                     opt.setAttribute('data-duration', (d2.getTime() - d1.getTime()) / 1000);
 438                     opt.value = '%04d-%02d-%02d'.format(d1.getFullYear(), d1.getMonth() + 1, d1.getDate());
 439                     opt.text = '%04d-%02d-%02d - %04d-%02d-%02d'.format(
 440                                 d1.getFullYear(), d1.getMonth() + 1, d1.getDate(),
 441                                 d2.getFullYear(), d2.getMonth() + 1, d2.getDate());
 442
 443                 sel.appendChild(opt);
 444         }
 445
 446         sel.selectedIndex = sel.childNodes.length - 1;
 447         sel.style.display = '';
 448
 449         sel.onchange = function() {
 450                 bubbleDismiss();
 451                 fetchData(sel.options[sel.selectedIndex].value);
 452         }
 453 }
 454
 455 function renderHostDetail()
 456 {
 457         var key = this.getAttribute('href').substr(1),
 458             col = this.getAttribute('data-col'),
 459             label = this.getAttribute('data-label'),
 460             bubble = document.getElementById('detail-bubble'),
 461             arrow = document.getElementById('bubble-arrow'),
 462             table = document.getElementById('bubble-table');
 463
 464         bubbleDismiss();
 465
 466         var detailData = query(
 467                 function(c, r) {
 468                         return ((r[c.mac] === key || r[c.ip] === key) &&
 469                                 (r[c.rx_bytes] > 0 || r[c.tx_bytes] > 0));
 470                 },
 471                 [col],
 472                 function(r1, r2) {
 473                         return ((r2.rx_bytes + r2.tx_bytes) - (r1.rx_bytes + r1.tx_bytes));
 474                 }
 475         );
 476
 477         var rxData = [], txData = [], rxEmpty = true, txEmpty = true;
 478
 479         table.innerHTML = '<tr>' +
 480                 '<th>%s</th>'.format(label || col) +
 481                 '<th><%:Conn.%></th>' +
 482                 '<th colspan="2"><%:Down. (Bytes / Pkts.)%></th>' +
 483                 '<th colspan="2"><%:Up. (Bytes / Pkts.)%></th>' +
 484         '</tr>';
 485
 486         for (var i = 0; i < detailData.length; i++) {
 487                 var rec = detailData[i],
 488                     row = table.insertRow(-1);
 489
 490                 row.insertCell(-1).innerHTML = rec[col] || '<%:other%>';
 491                 row.insertCell(-1).innerHTML = "%1000.2m".format(rec.conns);
 492                 row.insertCell(-1).innerHTML = "%1024.2mB".format(rec.rx_bytes);
 493                 row.insertCell(-1).innerHTML = "%1000.2mP".format(rec.rx_pkts);
 494                 row.insertCell(-1).innerHTML = "%1024.2mB".format(rec.tx_bytes);
 495                 row.insertCell(-1).innerHTML = "%1000.2mP".format(rec.tx_pkts);
 496
 497                 rxData.push({
 498                         label: ['%s: %%1024.2mB'.format(rec[col] || '<%:other%>'), row],
 499                         value: rec.rx_bytes
 500                 });
 501
 502                 txData.push({
 503                         label: ['%s: %%1024.2mB'.format(rec[col] || '<%:other%>'), row],
 504                         value: rec.tx_bytes
 505                 });
 506
 507                 if (rec.rx_bytes)
 508                         rxEmpty = false;
 509
 510                 if (rec.tx_bytes)
 511                         txEmpty = false;
 512         }
 513
 514         if (rxEmpty) {
 515                 rxData[0].value = 1;
 516                 rxData[0].color = '#cccccc';
 517                 rxData[0].label[0] = '<%:no traffic%>';
 518         }
 519
 520         if (txEmpty) {
 521                 txData[0].value = 1;
 522                 txData[0].color = '#cccccc';
 523                 txData[0].label[0] = '<%:no traffic%>';
 524         }
 525
 526         pie('bubble-pie1', rxData);
 527         pie('bubble-pie2', txData);
 528
 529         var mac = key.toUpperCase();
 530         var name = hostInfo.hasOwnProperty(mac) ? hostInfo[mac].name : null;
 531
 532         if (!name)
 533                 for (var i = 0; i < detailData.length; i++)
 534                         if ((name = hostNames[detailData[i].ip]) !== undefined)
 535                                 break;
 536
 537         if (mac !== '00:00:00:00:00:00') {
 538                 kpi('bubble-hostname', name);
 539                 kpi('bubble-vendor', oui(mac));
 540         }
 541         else {
 542                 kpi('bubble-hostname');
 543                 kpi('bubble-vendor');
 544         }
 545
 546         var tr = this.parentNode.parentNode,
 547             xy = off(tr),
 548             xy2 = off(this);
 549
 550         bubble.style.width = tr.offsetWidth + 'px';
 551         bubble.style.left = xy[0] + 'px';
 552         bubble.style.top = (xy[1] + tr.offsetHeight) + 'px';
 553         arrow.style.left = Math.floor(xy2[0] + this.offsetWidth / 2 - xy[0]) + 'px';
 554
 555         bubble.className = 'in';
 556
 557         return false;
 558 }
 559
 560 function formatHostname(dns)
 561 {
 562         if (dns === undefined || dns === null || dns === '')
 563                 return '-';
 564
 565         dns = dns.split('.')[0];
 566
 567         if (dns.length > 12)
 568                 return '<span title="%q">%h…</span>'.format(dns, dns.substr(0, 12));
 569
 570         return '%h'.format(dns);
 571 }
 572
 573 function renderHostData()
 574 {
 575         var trafData = [], connData = [];
 576         var rx_total = 0, tx_total = 0, conn_total = 0;
 577         var table = document.getElementById('host-data');
 578
 579         var hostData = query(
 580                 function(c, r) {
 581                         return (r[c.rx_bytes] > 0 || r[c.tx_bytes] > 0);
 582                 },
 583                 ['mac'],
 584                 //function(c, r) {
 585                 //      return (r[c.mac] !== '00:00:00:00:00:00') ? r[c.mac] : r[c.ip];
 586                 //},
 587                 function(r1, r2) {
 588                         return ((r2.rx_bytes + r2.tx_bytes) - (r1.rx_bytes + r1.tx_bytes));
 589                 }
 590         );
 591
 592         while (table.rows.length > 1)
 593                 table.deleteRow(1);
 594
 595         for (var i = 0; i < hostData.length; i++) {
 596                 var row = table.insertRow(-1),
 597                     cell = row.insertCell(-1),
 598                     rec = hostData[i],
 599                     mac = rec.mac.toUpperCase(),
 600                     key = (mac !== '00:00:00:00:00:00') ? mac : rec.ip,
 601                     dns = hostInfo[mac] ? hostInfo[mac].name : null;
 602
 603                 var link1 = document.createElement('a');
 604                     link1.onclick = renderHostDetail;
 605                     link1.href = '#' + rec.mac;
 606                     link1.setAttribute('data-col', 'ip');
 607                     link1.setAttribute('data-label', '<%:Source IP%>');
 608                     link1.innerHTML = (mac !== '00:00:00:00:00:00') ? mac : '<%:other%>';
 609
 610                 var link2 = document.createElement('a');
 611                     link2.onclick = renderHostDetail;
 612                     link2.href = '#' + rec.mac;
 613                     link2.setAttribute('data-col', 'layer7');
 614                     link2.setAttribute('data-label', '<%:Protocol%>');
 615                     link2.innerHTML = "%1000.2m".format(rec.conns);
 616
 617                 cell.innerHTML = formatHostname(dns);
 618                 cell.className = 'hostname';
 619
 620                 row.insertCell(-1).appendChild(link1);
 621                 row.insertCell(-1).appendChild(link2);
 622                 row.insertCell(-1).innerHTML = "%1024.2mB".format(rec.rx_bytes);
 623                 row.insertCell(-1).innerHTML = "%1000.2mP".format(rec.rx_pkts);
 624                 row.insertCell(-1).innerHTML = "%1024.2mB".format(rec.tx_bytes);
 625                 row.insertCell(-1).innerHTML = "%1000.2mP".format(rec.tx_pkts);
 626
 627                 trafData.push({
 628                         value: rec.rx_bytes + rec.tx_bytes,
 629                         label: ["%s: %%.2mB".format(key), row]
 630                 });
 631
 632                 connData.push({
 633                         value: rec.conns,
 634                         label: ["%s: %%.2m".format(key), row]
 635                 });
 636
 637                 rx_total += rec.rx_bytes;
 638                 tx_total += rec.tx_bytes;
 639                 conn_total += rec.conns;
 640         }
 641
 642         pie('traf-pie', trafData);
 643         pie('conn-pie', connData);
 644
 645         kpi('rx-total', '%1024.2mB'.format(rx_total));
 646         kpi('tx-total', '%1024.2mB'.format(tx_total));
 647         kpi('conn-total', '%1000m'.format(conn_total));
 648         kpi('host-total', '%u'.format(hostData.length));
 649 }
 650
 651 function renderLayer7Data()
 652 {
 653         var rxData = [], txData = [];
 654         var topConn = [[0],[0],[0]], topRx = [[0],[0],[0]], topTx = [[0],[0],[0]];
 655         var table = document.getElementById('layer7-data');
 656
 657         var layer7Data = query(
 658                 null, ['layer7'],
 659                 function(r1, r2) {
 660                         return ((r2.rx_bytes + r2.tx_bytes) - (r1.rx_bytes + r1.tx_bytes));
 661                 }
 662         );
 663
 664         while (table.rows.length > 1)
 665                 table.deleteRow(1);
 666
 667         for (var i = 0, c = 0; i < layer7Data.length; i++) {
 668                 var rec = layer7Data[i],
 669                     row = table.insertRow(-1);
 670
 671                 rxData.push({
 672                         value: rec.rx_bytes,
 673                         label: ["%s: %%.2mB".format(rec.layer7 || '<%:other%>'), row]
 674                 });
 675
 676                 txData.push({
 677                         value: rec.tx_bytes,
 678                         label: ["%s: %%.2mB".format(rec.layer7 || '<%:other%>'), row]
 679                 });
 680
 681                 row.insertCell(-1).innerHTML = rec.layer7 || '<%:other%>';
 682                 row.insertCell(-1).innerHTML = "%1000m".format(rec.conns);
 683                 row.insertCell(-1).innerHTML = "%1024.2mB".format(rec.rx_bytes);
 684                 row.insertCell(-1).innerHTML = "%1000.2mP".format(rec.rx_pkts);
 685                 row.insertCell(-1).innerHTML = "%1024.2mB".format(rec.tx_bytes);
 686                 row.insertCell(-1).innerHTML = "%1000.2mP".format(rec.tx_pkts);
 687
 688                 if (rec.layer7) {
 689                         topRx.push([rec.rx_bytes, rec.layer7]);
 690                         topTx.push([rec.tx_bytes, rec.layer7]);
 691                         topConn.push([rec.conns, rec.layer7]);
 692                 }
 693         }
 694
 695         pie('layer7-rx-pie', rxData);
 696         pie('layer7-tx-pie', txData);
 697
 698         topRx.sort(function(a, b) { return b[0] - a[0] });
 699         topTx.sort(function(a, b) { return b[0] - a[0] });
 700         topConn.sort(function(a, b) { return b[0] - a[0] });
 701
 702         kpi('layer7-total', layer7Data.length);
 703         kpi('layer7-most-rx', topRx[0][1], topRx[1][1], topRx[2][1]);
 704         kpi('layer7-most-tx', topTx[0][1], topTx[1][1], topTx[2][1]);
 705         kpi('layer7-most-conn', topConn[0][1], topConn[1][1], topConn[2][1]);
 706 }
 707
 708 function renderIPv6Data()
 709 {
 710         var table     = document.getElementById('ipv6-data'),
 711             col       = { },
 712             rx4_total = 0,
 713             tx4_total = 0,
 714             rx6_total = 0,
 715             tx6_total = 0,
 716             v4_total  = 0,
 717             v6_total  = 0,
 718             ds_total  = 0,
 719             families  = { },
 720             records   = { };
 721
 722         ipv6Data = query(
 723                 null, ['family', 'mac'],
 724                 function(r1, r2) {
 725                         return ((r2.rx_bytes + r2.tx_bytes) - (r1.rx_bytes + r1.tx_bytes));
 726                 }
 727         );
 728
 729         for (var i = 0, c = 0; i < ipv6Data.length; i++) {
 730                 var rec = ipv6Data[i],
 731                     mac = rec.mac.toUpperCase(),
 732                     ip  = rec.ip,
 733                     fam = families[mac] || 0,
 734                     recs = records[mac] || {};
 735
 736                 if (rec.family == 4) {
 737                         rx4_total += rec.rx_bytes;
 738                         tx4_total += rec.tx_bytes;
 739                         fam |= 1;
 740                 }
 741                 else {
 742                         rx6_total += rec.rx_bytes;
 743                         tx6_total += rec.tx_bytes;
 744                         fam |= 2;
 745                 }
 746
 747                 recs[rec.family] = rec;
 748                 records[mac] = recs;
 749
 750                 families[mac] = fam;
 751         }
 752
 753         for (var mac in families) {
 754                 switch (families[mac])
 755                 {
 756                 case 3:
 757                         ds_total++;
 758                         break;
 759
 760                 case 2:
 761                         v6_total++;
 762                         break;
 763
 764                 case 1:
 765                         v4_total++;
 766                         break;
 767                 }
 768         }
 769
 770         while (table.rows.length > 1)
 771                 table.deleteRow(1);
 772
 773         for (var mac in records) {
 774                 if (mac === '00:00:00:00:00:00')
 775                         continue;
 776
 777                 var tbd = document.createElement('tbody'),
 778                     row = tbd.insertRow(-1),
 779                     cell1 = row.insertCell(-1),
 780                     cell2 = row.insertCell(-1),
 781                     dns = hostInfo[mac] ? hostInfo[mac].name : null,
 782                     rec4 = records[mac][4],
 783                     rec6 = records[mac][6];
 784
 785                 cell1.setAttribute('rowspan', 2);
 786                 cell1.innerHTML = formatHostname(dns);
 787                 cell1.className = 'hostname';
 788
 789                 cell2.setAttribute('rowspan', 2);
 790                 cell2.innerHTML = mac;
 791
 792                 row.insertCell(-1).innerHTML = 'IPv4';
 793                 row.insertCell(-1).innerHTML = rec4 ? "%1024.2mB".format(rec4.rx_bytes) : '-';
 794                 row.insertCell(-1).innerHTML = rec4 ? "%1000.2mP".format(rec4.rx_pkts)  : '-';
 795                 row.insertCell(-1).innerHTML = rec4 ? "%1024.2mB".format(rec4.tx_bytes) : '-';
 796                 row.insertCell(-1).innerHTML = rec4 ? "%1000.2mP".format(rec4.tx_pkts)  : '-';
 797
 798                 row = tbd.insertRow(-1);
 799
 800                 row.insertCell(-1).innerHTML = 'IPv6';
 801                 row.insertCell(-1).innerHTML = rec6 ? "%1024.2mB".format(rec6.rx_bytes) : '-';
 802                 row.insertCell(-1).innerHTML = rec6 ? "%1000.2mP".format(rec6.rx_pkts)  : '-';
 803                 row.insertCell(-1).innerHTML = rec6 ? "%1024.2mB".format(rec6.tx_bytes) : '-';
 804                 row.insertCell(-1).innerHTML = rec6 ? "%1000.2mP".format(rec6.tx_pkts)  : '-';
 805
 806                 table.appendChild(tbd);
 807         }
 808
 809         pie('ipv6-share-pie', [{
 810                 value: rx4_total + tx4_total,
 811                 label: ["IPv4: %.2mB"],
 812                 color: 'hsl(140, 100%, 50%)'
 813         }, {
 814                 value: rx6_total + tx6_total,
 815                 label: ["IPv6: %.2mB"],
 816                 color: 'hsl(180, 100%, 50%)'
 817         }]);
 818
 819         pie('ipv6-hosts-pie', [{
 820                 value: v4_total,
 821                 label: ["<%:%d IPv4-only hosts%>"],
 822                 color: 'hsl(140, 100%, 50%)'
 823         }, {
 824                 value: v6_total,
 825                 label: ["<%:%d IPv6-only hosts%>"],
 826                 color: 'hsl(180, 100%, 50%)'
 827         }, {
 828                 value: ds_total,
 829                 label: ["<%:%d dual-stack hosts%>"],
 830                 color: 'hsl(50, 100%, 50%)'
 831         }]);
 832
 833         kpi('ipv6-hosts', '%.2f%%'.format(100 / (ds_total + v4_total + v6_total) * (ds_total + v6_total)));
 834         kpi('ipv6-share', '%.2f%%'.format(100 / (rx4_total + rx6_total + tx4_total + tx6_total) * (rx6_total + tx6_total)));
 835         kpi('ipv6-rx', '%1024.2mB'.format(rx6_total));
 836         kpi('ipv6-tx', '%1024.2mB'.format(tx6_total));
 837 }
 838
 839 function bubbleDismiss()
 840 {
 841         var bubble = document.getElementById('detail-bubble');
 842
 843         bubble.className = '';
 844         document.body.appendChild(bubble);
 845
 846         return false;
 847 }
 848
 849
 850 //]]></script>
 851
 852 <h2 name="content"><%:Netlink Bandwidth Monitor%></h2>
 853
 854 <div id="detail-bubble">
 855         <span id="bubble-arrow"></span>
 856         <div>
 857                 <div class="head">
 858                         <a class="dismiss" href="#" onclick="this.blur(); return bubbleDismiss()">×</a>
 859                         <div class="pie">
 860                                 <label>Download</label>
 861                                 <canvas id="bubble-pie1" width="100" height="100"></canvas>
 862                         </div>
 863                         <div class="pie">
 864                                 <label>Upload</label>
 865                                 <canvas id="bubble-pie2" width="100" height="100"></canvas>
 866                         </div>
 867                         <div class="kpi">
 868                                 <ul>
 869                                         <li><%_Hostname: <big id="bubble-hostname">example.org</big>%></li>
 870                                         <li><%_Vendor: <big id="bubble-vendor">Example Corp.</big>%></li>
 871                                 </ul>
 872                         </div>
 873                 </div>
 874                 <table id="bubble-table"></table>
 875         </div>
 876 </div>
 877
 878 <hr>
 879
 880 <p>
 881         <%:Select accounting period:%>
 882         <select id="nlbw.period" style="display:none"></select>
 883 </p>
 884
 885 <hr>
 886
 887 <ul class="cbi-tabmenu">
 888         <li id="tab.nlbw.traffic" class="cbi-tab"><a href="#" onclick="return switchTab('traffic')"><%:Traffic Distribution%></a></li>
 889         <li id="tab.nlbw.layer7" class="cbi-tab-disabled"><a href="#" onclick="return switchTab('layer7')"><%:Application Protocols%></a></li>
 890         <li id="tab.nlbw.ipv6" class="cbi-tab-disabled"><a href="#" onclick="return switchTab('ipv6')"><%:IPv6%></a></li>
 891         <li id="tab.nlbw.export" class="cbi-tab-disabled"><a href="#" onclick="return switchTab('export')"><%:Export%></a></li>
 892 </ul>
 893
 894 <div class="cbi-section" id="container.nlbw.traffic">
 895         <div>
 896                 <div class="pie">
 897                         <label><%:Traffic / Host%></label>
 898                         <canvas id="traf-pie" width="200" height="200"></canvas>
 899                 </div>
 900
 901                 <div class="pie">
 902                         <label><%:Connections / Host%></label>
 903                         <canvas id="conn-pie" width="200" height="200"></canvas>
 904                 </div>
 905
 906                 <div class="kpi">
 907                         <ul>
 908                                 <li><%_<big id="host-total">0</big> hosts%></li>
 909                                 <li><%_<big id="rx-total">0</big> download%></li>
 910                                 <li><%_<big id="tx-total">0</big> upload%></li>
 911                                 <li><%_<big id="conn-total">0</big> connections%></li>
 912                         </ul>
 913                 </div>
 914         </div>
 915         <table id="host-data">
 916                 <tr>
 917                         <th width="10%" class="hostname"><%:Host%></th>
 918                         <th width="5%"><%:MAC%></th>
 919                         <th width="5%"><%:Connections%></th>
 920                         <th width="30%" colspan="2"><%:Download (Bytes / Packets)%></th>
 921                         <th width="30%" colspan="2"><%:Upload (Bytes / Packets)%></th>
 922                 </tr>
 923         </table>
 924 </div>
 925
 926 <div class="cbi-section" id="container.nlbw.layer7" style="display:none">
 927         <div>
 928                 <div class="pie">
 929                         <label><%:Download / Application%></label>
 930                         <canvas id="layer7-rx-pie" width="200" height="200"></canvas>
 931                 </div>
 932
 933                 <div class="pie">
 934                         <label><%:Upload / Application%></label>
 935                         <canvas id="layer7-tx-pie" width="200" height="200"></canvas>
 936                 </div>
 937
 938                 <div class="kpi">
 939                         <ul>
 940                                 <li><%_<big id="layer7-total">0</big> different application protocols%></li>
 941                                 <li><%_<big id="layer7-most-rx">0</big> cause the most download%></li>
 942                                 <li><%_<big id="layer7-most-tx">0</big> cause the most upload%></li>
 943                                 <li><%_<big id="layer7-most-conn">0</big> cause the most connections%></li>
 944                         </ul>
 945                 </div>
 946         </div>
 947         <table id="layer7-data">
 948                 <tr>
 949                         <th width="20%"><%:Application%></th>
 950                         <th width="10%"><%:Connections%></th>
 951                         <th width="30%" colspan="2"><%:Download (Bytes / Packets)%></th>
 952                         <th width="30%" colspan="2"><%:Upload (Bytes / Packets)%></th>
 953                 </tr>
 954         </table>
 955 </div>
 956
 957 <div class="cbi-section" id="container.nlbw.ipv6" style="display:none">
 958         <div>
 959                 <div class="pie">
 960                         <label><%:IPv4 vs. IPv6%></label>
 961                         <canvas id="ipv6-share-pie" width="200" height="200"></canvas>
 962                 </div>
 963
 964                 <div class="pie">
 965                         <label><%:Dualstack enabled hosts%></label>
 966                         <canvas id="ipv6-hosts-pie" width="200" height="200"></canvas>
 967                 </div>
 968
 969                 <div class="kpi">
 970                         <ul>
 971                                 <li><%_<big id="ipv6-hosts">0%</big> IPv6 support rate among hosts%></li>
 972                                 <li><%_<big id="ipv6-share">0%</big> of the total traffic is IPv6%></li>
 973                                 <li><%_<big id="ipv6-rx">0B</big> total IPv6 download%></li>
 974                                 <li><%_<big id="ipv6-tx">0B</big> total IPv6 upload%></li>
 975                         </ul>
 976                 </div>
 977         </div>
 978         <table id="ipv6-data">
 979                 <tr>
 980                         <th width="10%" class="hostname"><%:Host%></th>
 981                         <th width="5%"><%:MAC%></th>
 982                         <th width="5%"><%:Family%></th>
 983                         <th width="40%" colspan="2"><%:Download (Bytes / Packets)%></th>
 984                         <th width="40%" colspan="2"><%:Upload (Bytes / Packets)%></th>
 985                 </tr>
 986         </table>
 987 </div>
 988
 989 <div class="cbi-section" id="container.nlbw.export" style="display:none">
 990         <ul>
 991                 <li><a href="<%=url('admin/nlbw/data')%>?type=csv&#38;group_by=mac&#38;order_by=-rx,-tx"><%:CSV, grouped by MAC%></a></li>
 992                 <li><a href="<%=url('admin/nlbw/data')%>?type=csv&#38;group_by=ip&#38;order_by=-rx,-tx"><%:CSV, grouped by IP%></a></li>
 993                 <li><a href="<%=url('admin/nlbw/data')%>?type=csv&#38;group_by=layer7&#38;order_by=-rx,-tx"><%:CSV, grouped by protocol%></a></li>
 994                 <li><a href="<%=url('admin/nlbw/data')%>?type=json"><%:JSON dump%></a></li>
 995         </ul>
 996 </div>
 997
 998 <script type="text/javascript">//<![CDATA[
 999         cbi_t_add('nlbw', 'traffic');
1000         cbi_t_add('nlbw', 'layer7');
1001         cbi_t_add('nlbw', 'ipv6');
1002         cbi_t_add('nlbw', 'export');
1003
1004         XHR.get('<%=url("admin/nlbw/list")%>', null, function(xhr, res) {
1005
1006                 if (res !== null && typeof(res) === 'object' && res.length > 0) {
1007                         trafficPeriods = res;
1008                         renderPeriods();
1009                 }
1010
1011                 xhr.open('GET', 'https://raw.githubusercontent.com/jow-/oui-database/master/oui.json', true);
1012                 xhr.onreadystatechange = function() {
1013                         if (xhr.readyState === 4) {
1014                                 try { res = JSON.parse(xhr.responseText); }
1015                                 catch(e) { res = null; }
1016
1017                                 if (res !== null && typeof(res) === 'object' && (res.length % 3) === 0)
1018                                         ouiData = res;
1019
1020                                 fetchData(trafficPeriods[0]);
1021                         }
1022                 };
1023                 xhr.send(null);
1024         });
1025 //]]></script>
1026
1027 <%+footer%>