luci-app-nlbwmon: new package 1259/head
authorJo-Philipp Wich <jo@mein.io>
Fri, 28 Jul 2017 13:57:44 +0000 (15:57 +0200)
committerJo-Philipp Wich <jo@mein.io>
Fri, 28 Jul 2017 14:26:42 +0000 (16:26 +0200)
This commit introduces luci-app-nlbwmon, a frontend for nlbwmon, the
lightweight NetLink BandWidth Montor.

The nlbwmon daemon gathers per-host traffic statistics by querying netlink
accounting data. Due to this approach, the executable is very small and does
not rely on libpcap and CPU intensive raw sockets to monitor traffic.

Depends on PR https://github.com/openwrt/packages/pull/4646

Signed-off-by: Jo-Philipp Wich <jo@mein.io>
applications/luci-app-nlbwmon/Makefile [new file with mode: 0644]
applications/luci-app-nlbwmon/luasrc/controller/nlbw.lua [new file with mode: 0644]
applications/luci-app-nlbwmon/luasrc/model/cbi/nlbw/config.lua [new file with mode: 0644]
applications/luci-app-nlbwmon/luasrc/view/nlbw/backup.htm [new file with mode: 0644]
applications/luci-app-nlbwmon/luasrc/view/nlbw/display.htm [new file with mode: 0644]
applications/luci-app-nlbwmon/root/etc/uci-defaults/40_luci-nlbwmon [new file with mode: 0644]

diff --git a/applications/luci-app-nlbwmon/Makefile b/applications/luci-app-nlbwmon/Makefile
new file mode 100644 (file)
index 0000000..a00177f
--- /dev/null
@@ -0,0 +1,8 @@
+include $(TOPDIR)/rules.mk
+
+LUCI_TITLE:=Netlink based bandwidth accounting
+LUCI_DEPENDS:=+nlbwmon
+
+include ../../luci.mk
+
+# call BuildPackage - OpenWrt buildroot signature
diff --git a/applications/luci-app-nlbwmon/luasrc/controller/nlbw.lua b/applications/luci-app-nlbwmon/luasrc/controller/nlbw.lua
new file mode 100644 (file)
index 0000000..4f41bb8
--- /dev/null
@@ -0,0 +1,216 @@
+-- Copyright 2017 Jo-Philipp Wich <jo@mein.io>
+-- Licensed to the public under the Apache License 2.0.
+
+module("luci.controller.nlbw", package.seeall)
+
+function index()
+       entry({"admin", "nlbw"}, firstchild(), _("Bandwidth Monitor"), 80)
+       entry({"admin", "nlbw", "display"}, template("nlbw/display"), _("Display"), 1)
+       entry({"admin", "nlbw", "config"}, cbi("nlbw/config"), _("Configuration"), 2)
+       entry({"admin", "nlbw", "backup"}, template("nlbw/backup"), _("Backup"), 3)
+       entry({"admin", "nlbw", "data"}, call("action_data"), nil, 4)
+       entry({"admin", "nlbw", "list"}, call("action_list"), nil, 5)
+       entry({"admin", "nlbw", "ptr"}, call("action_ptr"), nil, 6).leaf = true
+       entry({"admin", "nlbw", "download"}, call("action_download"), nil, 7)
+       entry({"admin", "nlbw", "restore"}, post("action_restore"), nil, 8)
+end
+
+local function exec(cmd, args, writer)
+       local os = require "os"
+       local nixio = require "nixio"
+
+       local fdi, fdo = nixio.pipe()
+       local pid = nixio.fork()
+
+       if pid > 0 then
+               fdo:close()
+
+               while true do
+                       local buffer = fdi:read(2048)
+                       local wpid, stat, code = nixio.waitpid(pid, "nohang")
+
+                       if writer and buffer and #buffer > 0 then
+                               writer(buffer)
+                       end
+
+                       if wpid and stat == "exited" then
+                               break
+                       end
+               end
+       elseif pid == 0 then
+               nixio.dup(fdo, nixio.stdout)
+               fdi:close()
+               fdo:close()
+               nixio.exece(cmd, args, nil)
+               nixio.stdout:close()
+               os.exit(1)
+       end
+end
+
+function action_data()
+       local http = require "luci.http"
+
+       local types = {
+               csv = "text/csv",
+               json = "application/json"
+       }
+
+       local args = { }
+       local mtype = http.formvalue("type") or "json"
+       local delim = http.formvalue("delim") or ";"
+       local period = http.formvalue("period")
+       local group_by = http.formvalue("group_by")
+       local order_by = http.formvalue("order_by")
+
+       if types[mtype] then
+               args[#args+1] = "-c"
+               args[#args+1] = mtype
+       else
+               http.status(400, "Unsupported type")
+               return
+       end
+
+       if delim and #delim > 0 then
+               args[#args+1] = "-s%s" % delim
+       end
+
+       if period and #period > 0 then
+               args[#args+1] = "-t"
+               args[#args+1] = period
+       end
+
+       if group_by and #group_by > 0 then
+               args[#args+1] = "-g"
+               args[#args+1] = group_by
+       end
+
+       if order_by and #order_by > 0 then
+               args[#args+1] = "-o"
+               args[#args+1] = order_by
+       end
+
+       http.prepare_content(types[mtype])
+       exec("/usr/sbin/nlbw", args, http.write)
+end
+
+function action_list()
+       local http = require "luci.http"
+
+       local fd = io.popen("/usr/sbin/nlbw -c list")
+       local periods = { }
+
+       if fd then
+               while true do
+                       local period = fd:read("*l")
+
+                       if not period then
+                               break
+                       end
+
+                       periods[#periods+1] = period
+               end
+
+               fd:close()
+       end
+
+       http.prepare_content("application/json")
+       http.write_json(periods)
+end
+
+function action_ptr(...)
+       local http = require "luci.http"
+       local util = require "luci.util"
+
+       http.prepare_content("application/json")
+       http.write_json(util.ubus("network.rrdns", "lookup", {
+               addrs = {...}, timeout = 3000
+       }))
+end
+
+function action_download()
+       local nixio = require "nixio"
+       local http = require "luci.http"
+       local sys = require "luci.sys"
+       local uci = require "luci.model.uci".cursor()
+
+       local dir = uci:get_first("nlbwmon", "nlbwmon", "database_directory")
+               or "/var/lib/nlbwmon"
+
+       if dir and nixio.fs.stat(dir, "type") == "dir" then
+               local n = "nlbwmon-backup-%s-%s.tar.gz"
+                       %{ sys.hostname(), os.date("%Y-%m-%d") }
+
+               http.prepare_content("application/octet-stream")
+               http.header("Content-Disposition", "attachment; filename=\"%s\"" % n)
+               exec("/bin/tar", { "-C", dir, "-c", "-z", ".", "-f", "-" }, http.write)
+       else
+               http.status(500, "Unable to find database directory")
+       end
+end
+
+function action_restore()
+       local nixio = require "nixio"
+       local http = require "luci.http"
+       local i18n = require "luci.i18n"
+       local tpl = require "luci.template"
+       local uci = require "luci.model.uci".cursor()
+
+       local tmp = "/tmp/nlbw-restore.tar.gz"
+       local dir = uci:get_first("nlbwmon", "nlbwmon", "database_directory")
+               or "/var/lib/nlbwmon"
+
+       local fp
+       http.setfilehandler(
+               function(meta, chunk, eof)
+                       if not fp and meta and meta.name == "archive" then
+                               fp = io.open(tmp, "w")
+                       end
+                       if fp and chunk then
+                               fp:write(chunk)
+                       end
+                       if fp and eof then
+                               fp:close()
+                       end
+               end)
+
+       local files = { }
+       local tar = io.popen("/bin/tar -tzf %s" % tmp, "r")
+       if tar then
+               while true do
+                       local file = tar:read("*l")
+                       if not file then
+                               break
+                       elseif file:match("^%d%d%d%d%d%d%d%d%.db%.gz$") or
+                              file:match("^%./%d%d%d%d%d%d%d%d%.db%.gz$") then
+                               files[#files+1] = file
+                       end
+               end
+               tar:close()
+       end
+
+       if #files == 0 then
+               http.status(500, "Internal Server Error")
+               tpl.render("nlbw/backup", {
+                       message = i18n.translate("Invalid or empty backup archive")
+               })
+               return
+       end
+
+
+       local output = { }
+
+       exec("/etc/init.d/nlbwmon", { "stop" })
+       exec("/bin/mkdir", { "-p", dir })
+
+       exec("/bin/tar", { "-C", dir, "-vxzf", tmp, unpack(files) },
+               function(chunk) output[#output+1] = chunk:match("%S+") end)
+
+       exec("/bin/rm", { "-f", tmp })
+       exec("/etc/init.d/nlbwmon", { "start" })
+
+       tpl.render("nlbw/backup", {
+               message = i18n.translatef(
+                       "The following database files have been restored: %s",
+                       table.concat(output, ", "))
+       })
+end
diff --git a/applications/luci-app-nlbwmon/luasrc/model/cbi/nlbw/config.lua b/applications/luci-app-nlbwmon/luasrc/model/cbi/nlbw/config.lua
new file mode 100644 (file)
index 0000000..71e096c
--- /dev/null
@@ -0,0 +1,215 @@
+-- Copyright 2017 Jo-Philipp Wich <jo@mein.io>
+-- Licensed to the public under the Apache License 2.0.
+
+local utl = require "luci.util"
+local sys = require "luci.sys"
+local fs  = require "nixio.fs"
+local ip  = require "luci.ip"
+local nw  = require "luci.model.network"
+
+local s, m, period, warning, date, days, interval, ifaces, subnets, limit, prealloc, compress, generations, commit, refresh, directory, protocols
+
+m = Map("nlbwmon", translate("Netlink Bandwidth Monitor - Configuration"),
+       translate("The Netlink Bandwidth Monitor (nlbwmon) is a lightweight, efficient traffic accounting program keeping track of bandwidth usage per host and protocol."))
+
+nw.init(luci.model.uci.cursor_state())
+
+s = m:section(TypedSection, "nlbwmon")
+s.anonymous = true
+s.addremove = false
+s:tab("general", translate("General Settings"))
+s:tab("advanced", translate("Advanced Settings"))
+s:tab("protocol", translate("Protocol Mapping"),
+       translate("Protocol mappings to distinguish traffic types per host, one mapping per line. The first value specifies the IP protocol, the second value the port number and the third column is the name of the mapped protocol."))
+
+period = s:taboption("general", ListValue, "_period", translate("Accounting period"),
+       translate("Choose \"Day of month\" to restart the accounting period monthly on a specific date, e.g. every 3rd. Choose \"Fixed interval\" to restart the accounting period exactly every N days, beginning at a given date."))
+
+period:value("relative", translate("Day of month"))
+period:value("absolute", translate("Fixed interval"))
+
+period.write = function(self, cfg, val)
+       if period:formvalue(cfg) == "relative" then
+               m:set(cfg, "database_interval", interval:formvalue(cfg))
+       else
+               m:set(cfg, "database_interval", "%s/%s" %{
+                       date:formvalue(cfg),
+                       days:formvalue(cfg)
+               })
+       end
+end
+
+period.cfgvalue = function(self, cfg)
+       local val = m:get(cfg, "database_interval") or ""
+       if val:match("^%d%d%d%d%-%d%d%-%d%d/%d+$") then
+               return "absolute"
+       end
+       return "relative"
+end
+
+
+warning = s:taboption("general", DummyValue, "_warning", translate("Warning"))
+warning.default = translatef("Changing the accounting interval type will invalidate existing databases!<br /><strong><a href=\"%s\">Download backup</a></strong>.", luci.dispatcher.build_url("admin/nlbw/backup"))
+warning.rawhtml = true
+
+if (m.uci:get_first("nlbwmon", "nlbwmon", "database_interval") or ""):match("^%d%d%d%d-%d%d-%d%d/%d+$") then
+       warning:depends("_period", "relative")
+else
+       warning:depends("_period", "absolute")
+end
+
+
+interval = s:taboption("general", Value, "_interval", translate("Due date"),
+       translate("Day of month to restart the accounting period. Use negative values to count towards the end of month, e.g. \"-5\" to specify the 27th of July or the 24th of Februrary."))
+
+interval.datatype = "or(range(1,31),range(-31,-1))"
+interval.placeholder = "1"
+interval:value("1", translate("1 - Restart every 1st of month"))
+interval:value("-1", translate("-1 - Restart every last day of month"))
+interval:value("-7", translate("-7 - Restart a week before end of month"))
+interval.rmempty = false
+interval:depends("_period", "relative")
+interval.write = period.write
+
+interval.cfgvalue = function(self, cfg)
+       local val = m:get(cfg, "database_interval")
+       return val and tonumber(val)
+end
+
+
+date = s:taboption("general", Value, "_date", translate("Start date"),
+       translate("Start date of the first accounting period, e.g. begin of ISP contract."))
+
+date.datatype = "dateyyyymmdd"
+date.placeholder = "2016-03-15"
+date.rmempty = false
+date:depends("_period", "absolute")
+date.write = period.write
+
+date.cfgvalue = function(self, cfg)
+       local val = m:get(cfg, "database_interval") or ""
+       return (val:match("^(%d%d%d%d%-%d%d%-%d%d)/%d+$"))
+end
+
+
+days = s:taboption("general", Value, "_days", translate("Interval"),
+       translate("Length of accounting interval in days."))
+
+days.datatype = "min(1)"
+days.placeholder = "30"
+days.rmempty = false
+days:depends("_period", "absolute")
+days.write = period.write
+
+days.cfgvalue = function(self, cfg)
+       local val = m:get(cfg, "database_interval") or ""
+       return (val:match("^%d%d%d%d%-%d%d%-%d%d/(%d+)$"))
+end
+
+
+ifaces = s:taboption("general", Value, "_ifaces", translate("Local interfaces"),
+       translate("Only conntrack streams from or to any of these networks are counted."))
+
+ifaces.template = "cbi/network_netlist"
+ifaces.widget = "checkbox"
+ifaces.nocreate = true
+
+ifaces.cfgvalue = function(self, cfg)
+       return m:get(cfg, "local_network")
+end
+
+ifaces.write = function(self, cfg)
+       local item
+       local items = {}
+       for item in utl.imatch(subnets:formvalue(cfg)) do
+               items[#items+1] = item
+       end
+       for item in utl.imatch(ifaces:formvalue(cfg)) do
+               items[#items+1] = item
+       end
+       m:set(cfg, "local_network", items)
+end
+
+
+subnets = s:taboption("general", DynamicList, "_subnets", translate("Local subnets"),
+       translate("Only conntrack streams from or to any of these subnets are counted."))
+
+subnets.datatype = "ipaddr"
+
+subnets.cfgvalue = function(self, cfg)
+       local subnet
+       local subnets = {}
+       for subnet in utl.imatch(m:get(cfg, "local_network")) do
+               subnet = ip.new(subnet)
+               subnets[#subnets+1] = subnet and subnet:string()
+       end
+       return subnets
+end
+
+subnets.write = ifaces.write
+
+
+limit = s:taboption("advanced", Value, "database_limit", translate("Maximum entries"),
+       translate("The maximum amount of entries that should be put into the database, setting the limit to 0 will allow databases to grow indefinitely."))
+
+limit.datatype = "uinteger"
+limit.placeholder = "10000"
+
+prealloc = s:taboption("advanced", Flag, "database_prealloc", translate("Preallocate database"),
+       translate("Whether to preallocate the maximum possible database size in memory. This is mainly useful for memory constrained systems which might not be able to satisfy memory allocation after longer uptime periods."))
+
+prealloc:depends({["database_limit"] = "0", ["!reverse"] = true })
+
+
+compress = s:taboption("advanced", Flag, "database_compress", translate("Compress database"),
+       translate("Whether to gzip compress archive databases. Compressing the database files makes accessing old data slightly slower but helps to reduce storage requirements."))
+
+compress.default = compress.enabled
+
+
+generations = s:taboption("advanced", Value, "database_generations", translate("Stored periods"),
+       translate("Maximum number of accounting periods to keep, use zero to keep databases forever."))
+
+generations.datatype = "uinteger"
+generations.placeholder = "10"
+
+
+commit = s:taboption("advanced", Value, "commit_interval", translate("Commit interval"),
+       translate("Interval at which the temporary in-memory database is committed to the persistent database directory."))
+
+commit.placeholder = "24h"
+commit:value("24h", translate("24h - least flash wear at the expense of data loss risk"))
+commit:value("12h", translate("12h - compromise between risk of data loss and flash wear"))
+commit:value("10m", translate("10m - frequent commits at the expense of flash wear"))
+commit:value("60s", translate("60s - commit minutely, useful for non-flash storage"))
+
+
+refresh = s:taboption("advanced", Value, "refresh_interval", translate("Refresh interval"),
+       translate("Interval at which traffic counters of still established connections are refreshed from netlink information."))
+
+refresh.placeholder = "30s"
+refresh:value("30s", translate("30s - refresh twice per minute for reasonably current stats"))
+refresh:value("5m", translate("5m - rarely refresh to avoid frequently clearing conntrack counters"))
+
+
+directory = s:taboption("advanced", Value, "database_directory", translate("Database directory"),
+       translate("Database storage directory. One file per accounting period will be placed into this directory."))
+
+directory.placeholder = "/var/lib/nlbwmon"
+
+
+protocols = s:taboption("protocol", TextValue, "_protocols")
+protocols.rows = 50
+
+protocols.cfgvalue = function(self, cfg)
+       return fs.readfile("/usr/share/nlbwmon/protocols")
+end
+
+protocols.write = function(self, cfg, value)
+       fs.writefile("/usr/share/nlbwmon/protocols", (value or ""):gsub("\r\n", "\n"))
+end
+
+protocols.remove = protocols.write
+
+
+return m
diff --git a/applications/luci-app-nlbwmon/luasrc/view/nlbw/backup.htm b/applications/luci-app-nlbwmon/luasrc/view/nlbw/backup.htm
new file mode 100644 (file)
index 0000000..ea2e0f0
--- /dev/null
@@ -0,0 +1,34 @@
+<%#
+ Copyright 2017 Jo-Philipp Wich <jo@mein.io>
+ Licensed to the public under the Apache License 2.0.
+-%>
+
+<%+header%>
+
+<script type="text/javascript" src="<%=resource%>/cbi.js"></script>
+
+<h2 name="content"><%:Netlink Bandwidth Monitor - Backup / Restore %></h2>
+
+<fieldset class="cbi-section">
+       <legend><%:Restore Database Backup%></legend>
+       <p>
+               <form method="POST" action="<%=url("admin/nlbw/restore")%>" enctype="multipart/form-data">
+                       <input type="hidden" name="token" value="<%=token%>" />
+                       <input type="file" name="archive" accept="application/gzip,.gz" />
+                       <input type="submit" value="<%:Restore%>" class="cbi-button cbi-button-apply" />
+               </form>
+
+               <% if message then %>
+                       <div class="alert-message"><%=message%></div>
+               <% end %>
+       </p>
+
+       <legend><%:Download Database Backup%></legend>
+       <p>
+               <form method="GET" action="<%=url("admin/nlbw/download")%>">
+                       <input type="submit" value="<%:Generate Backup%>" class="cbi-button cbi-button-link" />
+               </form>
+       </p>
+</fieldset>
+
+<%+footer%>
diff --git a/applications/luci-app-nlbwmon/luasrc/view/nlbw/display.htm b/applications/luci-app-nlbwmon/luasrc/view/nlbw/display.htm
new file mode 100644 (file)
index 0000000..7db4785
--- /dev/null
@@ -0,0 +1,1027 @@
+<%#
+ Copyright 2017 Jo-Philipp Wich <jo@mein.io>
+ Licensed to the public under the Apache License 2.0.
+-%>
+
+<% css = [[
+
+    #chartjs-tooltip {
+        opacity: 0;
+        position: absolute;
+        background: rgba(0, 0, 0, .7);
+        color: white;
+        padding: 3px;
+        border-radius: 3px;
+        -webkit-transition: all .1s ease;
+        transition: all .1s ease;
+        pointer-events: none;
+        -webkit-transform: translate(-50%, 0);
+        transform: translate(-50%, 0);
+               z-index: 200;
+    }
+
+    #chartjs-tooltip.above {
+        -webkit-transform: translate(-50%, -100%);
+        transform: translate(-50%, -100%);
+    }
+
+    #chartjs-tooltip.above:before {
+        border: solid;
+        border-color: #111 transparent;
+        border-color: rgba(0, 0, 0, .8) transparent;
+        border-width: 8px 8px 0 8px;
+        bottom: 1em;
+        content: "";
+        display: block;
+        left: 50%;
+        top: 100%;
+        position: absolute;
+        z-index: 99;
+        -webkit-transform: translate(-50%, 0);
+        transform: translate(-50%, 0);
+    }
+
+       table {
+               border: 1px solid #999;
+               border-collapse: collapse;
+               margin: 0 0 2px !important;
+       }
+
+       th, td, table table td {
+               border: 1px solid #999;
+               text-align: right;
+               padding: 1px 3px !important;
+               white-space: nowrap;
+       }
+
+       tbody td {
+               border-bottom-color: #ccc;
+       }
+
+       tbody td[rowspan] {
+               border-bottom-color: #999;
+       }
+
+       tbody tr:last-child td {
+               border-bottom-color: #999;
+       }
+
+
+       .pie {
+               width: 200px;
+               display: inline-block;
+               margin: 20px;
+       }
+
+       .pie label {
+               font-weight: bold;
+               font-size: 14px;
+               display: block;
+               margin-bottom: 10px;
+               text-align: center;
+       }
+
+       .kpi {
+               display: inline-block;
+               margin: 80px 20px 20px;
+               vertical-align: top;
+       }
+
+       .kpi ul {
+               list-style: none;
+       }
+
+       .kpi li {
+               margin: 10px;
+               display: none;
+       }
+
+       .kpi big {
+               font-weight: bold;
+       }
+
+       #detail-bubble {
+               position: absolute;
+               opacity: 0;
+               visibility: hidden;
+       }
+
+       #detail-bubble.in {
+               opacity: 1;
+               visibility: visible;
+               transition: opacity 0.5s;
+       }
+
+       #detail-bubble > div {
+               border: 1px solid #ccc;
+               border-radius: 2px;
+               padding: 5px;
+               background: #fcfcfc;
+       }
+
+       #detail-bubble .head {
+               text-align: center;
+               white-space: nowrap;
+               position: relative;
+       }
+
+       #detail-bubble .head .dismiss {
+               top: 0;
+               right: 0;
+               width: 20px;
+               line-height: 20px;
+               text-align: center;
+               text-decoration: none;
+               font-weight: bold;
+               color: #000;
+               position: absolute;
+               font-size: 20px;
+       }
+
+       #detail-bubble .pie {
+               width: 100px;
+               margin: 5px;
+       }
+
+       #detail-bubble .kpi {
+               margin: 40px 5px 5px;
+               font-size: smaller;
+               text-align: left;
+       }
+
+       #detail-bubble .kpi ul {
+               margin: 0;
+       }
+
+       #bubble-arrow {
+               border: 1px solid #ccc;
+               border-width: 1px 0 0 1px;
+               background: #fcfcfc;
+               width: 15px;
+               height: 15px;
+               position: absolute;
+               left: 0;
+               top: -8px;
+               transform: rotate(45deg);
+               margin: 0 0 0 -8px;
+       }
+
+       tr.active > td {
+               border-bottom: 2px solid red;
+       }
+
+       tr.active > td.active {
+               border: 2px solid red;
+               border-bottom: none;
+       }
+
+       td.detail {
+               border: 2px solid red;
+               border-top: none;
+               opacity: 0;
+               transition: opacity 0.5s;
+       }
+
+       td.detail.in {
+               opacity: 1;
+       }
+
+       th.hostname,
+       td.hostname {
+               text-align: left;
+       }
+
+]] -%>
+
+<%+header%>
+
+<script type="text/javascript" src="<%=resource%>/cbi.js"></script>
+<script type="text/javascript" src="<%=resource%>/nlbw.chart.min.js"></script>
+<script type="text/javascript">//<![CDATA[
+
+var chartRegistry = {},
+       trafficPeriods = [],
+       trafficData = { columns: [], data: [] },
+       hostNames = {},
+       hostInfo = <%=luci.util.serialize_json(luci.sys.net.host_hints())%>,
+       ouiData = [];
+
+
+function off(elem)
+{
+       var val = [0, 0];
+       do {
+               if (!isNaN(elem.offsetLeft) && !isNaN(elem.offsetTop)) {
+                       val[0] += elem.offsetLeft;
+                       val[1] += elem.offsetTop;
+               }
+       }
+       while ((elem = elem.offsetParent) != null);
+       return val;
+}
+
+Chart.defaults.global.customTooltips = function(tooltip) {
+       var tooltipEl = document.getElementById('chartjs-tooltip');
+
+       if (!tooltipEl) {
+               tooltipEl = document.createElement('div');
+               tooltipEl.setAttribute('id', 'chartjs-tooltip');
+               document.body.appendChild(tooltipEl);
+       }
+
+       if (!tooltip) {
+               if (tooltipEl.row)
+                       tooltipEl.row.style.backgroundColor = '';
+
+               tooltipEl.style.opacity = 0;
+               return;
+       }
+
+       var pos = off(tooltip.chart.canvas);
+
+       tooltipEl.className = tooltip.yAlign;
+       tooltipEl.innerHTML = tooltip.text[0];
+
+       tooltipEl.style.opacity = 1;
+       tooltipEl.style.left = pos[0] + tooltip.x + 'px';
+       tooltipEl.style.top = pos[1] + tooltip.y - tooltip.caretHeight - tooltip.caretPadding + 'px';
+
+       var row = tooltip.text[1],
+           hue = tooltip.text[2];
+
+       if (row && !isNaN(hue)) {
+               row.style.backgroundColor = 'hsl(%u, 100%%, 80%%)'.format(hue);
+               tooltipEl.row = row;
+       }
+};
+
+Chart.defaults.global.tooltipFontSize = 10;
+Chart.defaults.global.tooltipTemplate = function(tip) {
+       tip.label[0] = tip.label[0].format(tip.value);
+       return tip.label;
+};
+
+function kpi(id, val1, val2, val3)
+{
+       var e = document.getElementById(id);
+
+       if (val1 && val2 && val3)
+               e.innerHTML = '<%:%s, %s and %s%>'.format(val1, val2, val3);
+       else if (val1 && val2)
+               e.innerHTML = '<%:%s and %s%>'.format(val1, val2);
+       else if (val1)
+               e.innerHTML = val1;
+
+       e.parentNode.style.display = val1 ? 'list-item' : '';
+}
+
+function pie(id, data)
+{
+       data.sort(function(a, b) { return b.value - a.value });
+
+       for (var i = 0; i < data.length; i++) {
+               if (!data[i].color) {
+                       var hue = 120 / (data.length-1) * i;
+                       data[i].color = 'hsl(%u, 80%%, 50%%)'.format(hue);
+                       data[i].label.push(hue);
+               }
+       }
+
+       var ctx = document.getElementById(id).getContext('2d');
+
+       if (chartRegistry.hasOwnProperty(id))
+               chartRegistry[id].destroy();
+
+       chartRegistry[id] = new Chart(ctx).Doughnut(data, {
+               segmentStrokeWidth: 1,
+               percentageInnerCutout: 30
+       });
+
+       return chartRegistry[id];
+}
+
+function query(filter, group, order)
+{
+       var keys = [], columns = {}, records = {}, result = [];
+
+       if (typeof(group) !== 'function' && typeof(group) !== 'object')
+               group = ['mac'];
+
+       for (var i = 0; i < trafficData.columns.length; i++)
+               columns[trafficData.columns[i]] = i;
+
+       for (var i = 0; i < trafficData.data.length; i++) {
+               var record = trafficData.data[i];
+
+               if (typeof(filter) === 'function' && filter(columns, record) !== true)
+                       continue;
+
+               var key;
+
+               if (typeof(group) === 'function') {
+                       key = group(columns, record);
+               }
+               else {
+                       key = [];
+
+                       for (var j = 0; j < group.length; j++)
+                               if (columns.hasOwnProperty(group[j]))
+                                       key.push(record[columns[group[j]]]);
+
+                       key = key.join(',');
+               }
+
+               if (!records.hasOwnProperty(key)) {
+                       var rec = {};
+
+                       for (var col in columns)
+                               rec[col] = record[columns[col]];
+
+                       records[key] = rec;
+                       result.push(rec);
+               }
+               else {
+                       records[key].conns    += record[columns.conns];
+                       records[key].rx_bytes += record[columns.rx_bytes];
+                       records[key].rx_pkts  += record[columns.rx_pkts];
+                       records[key].tx_bytes += record[columns.tx_bytes];
+                       records[key].tx_pkts  += record[columns.tx_pkts];
+               }
+       }
+
+       if (typeof(order) === 'function')
+               result.sort(order);
+
+       return result;
+}
+
+function oui(mac) {
+       var m, l = 0, r = ouiData.length / 3 - 1;
+       var mac1 = parseInt(mac.replace(/[^a-fA-F0-9]/g, ''), 16);
+
+       while (l <= r) {
+               m = l + Math.floor((r - l) / 2);
+
+               var mask = (0xffffffffffff -
+                                       (Math.pow(2, 48 - ouiData[m * 3 + 1]) - 1));
+
+               var mac1_hi = ((mac1 / 0x10000) & (mask / 0x10000)) >>> 0;
+               var mac1_lo = ((mac1 &  0xffff) & (mask &  0xffff)) >>> 0;
+
+               var mac2 = parseInt(ouiData[m * 3], 16);
+               var mac2_hi = (mac2 / 0x10000) >>> 0;
+               var mac2_lo = (mac2 &  0xffff) >>> 0;
+
+               if (mac1_hi === mac2_hi && mac1_lo === mac2_lo)
+                       return ouiData[m * 3 + 2];
+
+               if (mac2_hi > mac1_hi ||
+                       (mac2_hi === mac1_hi && mac2_lo > mac1_lo))
+                       r = m - 1;
+               else
+                       l = m + 1;
+       }
+
+       return null;
+}
+
+
+function fetchData(period)
+{
+       XHR.get('<%=url("admin/nlbw/data")%>', { period: period, group_by: 'family,mac,ip,layer7', order_by: '-rx_bytes,-tx_bytes' }, function(xhr, res) {
+               if (res !== null && typeof(res) === 'object' && typeof(res.columns) === 'object' && typeof(res.data) === 'object')
+                       trafficData = res;
+
+               var addrs = query(null, ['ip'], null);
+               var ipAddrs = [];
+
+               for (var i = 0; i < addrs.length; i++)
+                       if (ipAddrs.indexOf(addrs[i].ip) < 0)
+                               ipAddrs.push(addrs[i].ip);
+
+               renderHostData();
+               renderLayer7Data();
+               renderIPv6Data();
+
+               XHR.get('<%=url("admin/nlbw/ptr")%>/' + ipAddrs.join('/'), null, function(xhr, res) {
+                       if (res !== null && typeof(res) === 'object')
+                               hostNames = res;
+               });
+       });
+}
+
+function switchTab(tab)
+{
+       bubbleDismiss();
+
+       return cbi_t_switch('nlbw', tab);
+}
+
+function renderPeriods()
+{
+       var sel = document.getElementById('nlbw.period');
+
+       for (var e, i = trafficPeriods.length - 1; e = trafficPeriods[i]; i--) {
+               var d1 = new Date(e);
+               var d2;
+
+               if (i) {
+                       d2 = new Date(trafficPeriods[i - 1]);
+                       d2.setDate(d2.getDate() - 1);
+               }
+               else {
+                       d2 = new Date();
+               }
+
+               var opt = document.createElement('option');
+                   opt.setAttribute('data-duration', (d2.getTime() - d1.getTime()) / 1000);
+                   opt.value = '%04d-%02d-%02d'.format(d1.getFullYear(), d1.getMonth() + 1, d1.getDate());
+                   opt.text = '%04d-%02d-%02d - %04d-%02d-%02d'.format(
+                               d1.getFullYear(), d1.getMonth() + 1, d1.getDate(),
+                               d2.getFullYear(), d2.getMonth() + 1, d2.getDate());
+
+               sel.appendChild(opt);
+       }
+
+       sel.selectedIndex = sel.childNodes.length - 1;
+       sel.style.display = '';
+
+       sel.onchange = function() {
+               bubbleDismiss();
+               fetchData(sel.options[sel.selectedIndex].value);
+       }
+}
+
+function renderHostDetail()
+{
+       var key = this.getAttribute('href').substr(1),
+           col = this.getAttribute('data-col'),
+           label = this.getAttribute('data-label'),
+           bubble = document.getElementById('detail-bubble'),
+           arrow = document.getElementById('bubble-arrow'),
+           table = document.getElementById('bubble-table');
+
+       bubbleDismiss();
+
+       var detailData = query(
+               function(c, r) {
+                       return ((r[c.mac] === key || r[c.ip] === key) &&
+                               (r[c.rx_bytes] > 0 || r[c.tx_bytes] > 0));
+               },
+               [col],
+               function(r1, r2) {
+                       return ((r2.rx_bytes + r2.tx_bytes) - (r1.rx_bytes + r1.tx_bytes));
+               }
+       );
+
+       var rxData = [], txData = [], rxEmpty = true, txEmpty = true;
+
+       table.innerHTML = '<tr>' +
+               '<th>%s</th>'.format(label || col) +
+               '<th><%:Conn.%></th>' +
+               '<th colspan="2"><%:Down. (Bytes / Pkts.)%></th>' +
+               '<th colspan="2"><%:Up. (Bytes / Pkts.)%></th>' +
+       '</tr>';
+
+       for (var i = 0; i < detailData.length; i++) {
+               var rec = detailData[i],
+                   row = table.insertRow(-1);
+
+               row.insertCell(-1).innerHTML = rec[col] || '<%:other%>';
+               row.insertCell(-1).innerHTML = "%1000.2m".format(rec.conns);
+               row.insertCell(-1).innerHTML = "%1024.2mB".format(rec.rx_bytes);
+               row.insertCell(-1).innerHTML = "%1000.2mP".format(rec.rx_pkts);
+               row.insertCell(-1).innerHTML = "%1024.2mB".format(rec.tx_bytes);
+               row.insertCell(-1).innerHTML = "%1000.2mP".format(rec.tx_pkts);
+
+               rxData.push({
+                       label: ['%s: %%1024.2mB'.format(rec[col] || '<%:other%>'), row],
+                       value: rec.rx_bytes
+               });
+
+               txData.push({
+                       label: ['%s: %%1024.2mB'.format(rec[col] || '<%:other%>'), row],
+                       value: rec.tx_bytes
+               });
+
+               if (rec.rx_bytes)
+                       rxEmpty = false;
+
+               if (rec.tx_bytes)
+                       txEmpty = false;
+       }
+
+       if (rxEmpty) {
+               rxData[0].value = 1;
+               rxData[0].color = '#cccccc';
+               rxData[0].label[0] = '<%:no traffic%>';
+       }
+
+       if (txEmpty) {
+               txData[0].value = 1;
+               txData[0].color = '#cccccc';
+               txData[0].label[0] = '<%:no traffic%>';
+       }
+
+       pie('bubble-pie1', rxData);
+       pie('bubble-pie2', txData);
+
+       var mac = key.toUpperCase();
+       var name = hostInfo.hasOwnProperty(mac) ? hostInfo[mac].name : null;
+
+       if (!name)
+               for (var i = 0; i < detailData.length; i++)
+                       if ((name = hostNames[detailData[i].ip]) !== undefined)
+                               break;
+
+       if (mac !== '00:00:00:00:00:00') {
+               kpi('bubble-hostname', name);
+               kpi('bubble-vendor', oui(mac));
+       }
+       else {
+               kpi('bubble-hostname');
+               kpi('bubble-vendor');
+       }
+
+       var tr = this.parentNode.parentNode,
+           xy = off(tr),
+           xy2 = off(this);
+
+       bubble.style.width = tr.offsetWidth + 'px';
+       bubble.style.left = xy[0] + 'px';
+       bubble.style.top = (xy[1] + tr.offsetHeight) + 'px';
+       arrow.style.left = Math.floor(xy2[0] + this.offsetWidth / 2 - xy[0]) + 'px';
+
+       bubble.className = 'in';
+
+       return false;
+}
+
+function formatHostname(dns)
+{
+       if (dns === undefined || dns === null || dns === '')
+               return '-';
+
+       dns = dns.split('.')[0];
+
+       if (dns.length > 12)
+               return '<span title="%q">%h…</span>'.format(dns, dns.substr(0, 12));
+
+       return '%h'.format(dns);
+}
+
+function renderHostData()
+{
+       var trafData = [], connData = [];
+       var rx_total = 0, tx_total = 0, conn_total = 0;
+       var table = document.getElementById('host-data');
+
+       var hostData = query(
+               function(c, r) {
+                       return (r[c.rx_bytes] > 0 || r[c.tx_bytes] > 0);
+               },
+               ['mac'],
+               //function(c, r) {
+               //      return (r[c.mac] !== '00:00:00:00:00:00') ? r[c.mac] : r[c.ip];
+               //},
+               function(r1, r2) {
+                       return ((r2.rx_bytes + r2.tx_bytes) - (r1.rx_bytes + r1.tx_bytes));
+               }
+       );
+
+       while (table.rows.length > 1)
+               table.deleteRow(1);
+
+       for (var i = 0; i < hostData.length; i++) {
+               var row = table.insertRow(-1),
+                   cell = row.insertCell(-1),
+                   rec = hostData[i],
+                   mac = rec.mac.toUpperCase(),
+                   key = (mac !== '00:00:00:00:00:00') ? mac : rec.ip,
+                   dns = hostInfo[mac] ? hostInfo[mac].name : null;
+
+               var link1 = document.createElement('a');
+                   link1.onclick = renderHostDetail;
+                   link1.href = '#' + rec.mac;
+                   link1.setAttribute('data-col', 'ip');
+                   link1.setAttribute('data-label', '<%:Source IP%>');
+                   link1.innerHTML = (mac !== '00:00:00:00:00:00') ? mac : '<%:other%>';
+
+               var link2 = document.createElement('a');
+                   link2.onclick = renderHostDetail;
+                   link2.href = '#' + rec.mac;
+                   link2.setAttribute('data-col', 'layer7');
+                   link2.setAttribute('data-label', '<%:Protocol%>');
+                   link2.innerHTML = "%1000.2m".format(rec.conns);
+
+               cell.innerHTML = formatHostname(dns);
+               cell.className = 'hostname';
+
+               row.insertCell(-1).appendChild(link1);
+               row.insertCell(-1).appendChild(link2);
+               row.insertCell(-1).innerHTML = "%1024.2mB".format(rec.rx_bytes);
+               row.insertCell(-1).innerHTML = "%1000.2mP".format(rec.rx_pkts);
+               row.insertCell(-1).innerHTML = "%1024.2mB".format(rec.tx_bytes);
+               row.insertCell(-1).innerHTML = "%1000.2mP".format(rec.tx_pkts);
+
+               trafData.push({
+                       value: rec.rx_bytes + rec.tx_bytes,
+                       label: ["%s: %%.2mB".format(key), row]
+               });
+
+               connData.push({
+                       value: rec.conns,
+                       label: ["%s: %%.2m".format(key), row]
+               });
+
+               rx_total += rec.rx_bytes;
+               tx_total += rec.tx_bytes;
+               conn_total += rec.conns;
+       }
+
+       pie('traf-pie', trafData);
+       pie('conn-pie', connData);
+
+       kpi('rx-total', '%1024.2mB'.format(rx_total));
+       kpi('tx-total', '%1024.2mB'.format(tx_total));
+       kpi('conn-total', '%1000m'.format(conn_total));
+       kpi('host-total', '%u'.format(hostData.length));
+}
+
+function renderLayer7Data()
+{
+       var rxData = [], txData = [];
+       var topConn = [[0],[0],[0]], topRx = [[0],[0],[0]], topTx = [[0],[0],[0]];
+       var table = document.getElementById('layer7-data');
+
+       var layer7Data = query(
+               null, ['layer7'],
+               function(r1, r2) {
+                       return ((r2.rx_bytes + r2.tx_bytes) - (r1.rx_bytes + r1.tx_bytes));
+               }
+       );
+
+       while (table.rows.length > 1)
+               table.deleteRow(1);
+
+       for (var i = 0, c = 0; i < layer7Data.length; i++) {
+               var rec = layer7Data[i],
+                   row = table.insertRow(-1);
+
+               rxData.push({
+                       value: rec.rx_bytes,
+                       label: ["%s: %%.2mB".format(rec.layer7 || '<%:other%>'), row]
+               });
+
+               txData.push({
+                       value: rec.tx_bytes,
+                       label: ["%s: %%.2mB".format(rec.layer7 || '<%:other%>'), row]
+               });
+
+               row.insertCell(-1).innerHTML = rec.layer7 || '<%:other%>';
+               row.insertCell(-1).innerHTML = "%1000m".format(rec.conns);
+               row.insertCell(-1).innerHTML = "%1024.2mB".format(rec.rx_bytes);
+               row.insertCell(-1).innerHTML = "%1000.2mP".format(rec.rx_pkts);
+               row.insertCell(-1).innerHTML = "%1024.2mB".format(rec.tx_bytes);
+               row.insertCell(-1).innerHTML = "%1000.2mP".format(rec.tx_pkts);
+
+               if (rec.layer7) {
+                       topRx.push([rec.rx_bytes, rec.layer7]);
+                       topTx.push([rec.tx_bytes, rec.layer7]);
+                       topConn.push([rec.conns, rec.layer7]);
+               }
+       }
+
+       pie('layer7-rx-pie', rxData);
+       pie('layer7-tx-pie', txData);
+
+       topRx.sort(function(a, b) { return b[0] - a[0] });
+       topTx.sort(function(a, b) { return b[0] - a[0] });
+       topConn.sort(function(a, b) { return b[0] - a[0] });
+
+       kpi('layer7-total', layer7Data.length);
+       kpi('layer7-most-rx', topRx[0][1], topRx[1][1], topRx[2][1]);
+       kpi('layer7-most-tx', topTx[0][1], topTx[1][1], topTx[2][1]);
+       kpi('layer7-most-conn', topConn[0][1], topConn[1][1], topConn[2][1]);
+}
+
+function renderIPv6Data()
+{
+       var table     = document.getElementById('ipv6-data'),
+           col       = { },
+           rx4_total = 0,
+           tx4_total = 0,
+           rx6_total = 0,
+           tx6_total = 0,
+           v4_total  = 0,
+           v6_total  = 0,
+           ds_total  = 0,
+           families  = { },
+           records   = { };
+
+       ipv6Data = query(
+               null, ['family', 'mac'],
+               function(r1, r2) {
+                       return ((r2.rx_bytes + r2.tx_bytes) - (r1.rx_bytes + r1.tx_bytes));
+               }
+       );
+
+       for (var i = 0, c = 0; i < ipv6Data.length; i++) {
+               var rec = ipv6Data[i],
+                   mac = rec.mac.toUpperCase(),
+                   ip  = rec.ip,
+                   fam = families[mac] || 0,
+                   recs = records[mac] || {};
+
+               if (rec.family == 4) {
+                       rx4_total += rec.rx_bytes;
+                       tx4_total += rec.tx_bytes;
+                       fam |= 1;
+               }
+               else {
+                       rx6_total += rec.rx_bytes;
+                       tx6_total += rec.tx_bytes;
+                       fam |= 2;
+               }
+
+               recs[rec.family] = rec;
+               records[mac] = recs;
+
+               families[mac] = fam;
+       }
+
+       for (var mac in families) {
+               switch (families[mac])
+               {
+               case 3:
+                       ds_total++;
+                       break;
+
+               case 2:
+                       v6_total++;
+                       break;
+
+               case 1:
+                       v4_total++;
+                       break;
+               }
+       }
+
+       while (table.rows.length > 1)
+               table.deleteRow(1);
+
+       for (var mac in records) {
+               if (mac === '00:00:00:00:00:00')
+                       continue;
+
+               var tbd = document.createElement('tbody'),
+                   row = tbd.insertRow(-1),
+                   cell1 = row.insertCell(-1),
+                   cell2 = row.insertCell(-1),
+                   dns = hostInfo[mac] ? hostInfo[mac].name : null,
+                   rec4 = records[mac][4],
+                   rec6 = records[mac][6];
+
+               cell1.setAttribute('rowspan', 2);
+               cell1.innerHTML = formatHostname(dns);
+               cell1.className = 'hostname';
+
+               cell2.setAttribute('rowspan', 2);
+               cell2.innerHTML = mac;
+
+               row.insertCell(-1).innerHTML = 'IPv4';
+               row.insertCell(-1).innerHTML = rec4 ? "%1024.2mB".format(rec4.rx_bytes) : '-';
+               row.insertCell(-1).innerHTML = rec4 ? "%1000.2mP".format(rec4.rx_pkts)  : '-';
+               row.insertCell(-1).innerHTML = rec4 ? "%1024.2mB".format(rec4.tx_bytes) : '-';
+               row.insertCell(-1).innerHTML = rec4 ? "%1000.2mP".format(rec4.tx_pkts)  : '-';
+
+               row = tbd.insertRow(-1);
+
+               row.insertCell(-1).innerHTML = 'IPv6';
+               row.insertCell(-1).innerHTML = rec6 ? "%1024.2mB".format(rec6.rx_bytes) : '-';
+               row.insertCell(-1).innerHTML = rec6 ? "%1000.2mP".format(rec6.rx_pkts)  : '-';
+               row.insertCell(-1).innerHTML = rec6 ? "%1024.2mB".format(rec6.tx_bytes) : '-';
+               row.insertCell(-1).innerHTML = rec6 ? "%1000.2mP".format(rec6.tx_pkts)  : '-';
+
+               table.appendChild(tbd);
+       }
+
+       pie('ipv6-share-pie', [{
+               value: rx4_total + tx4_total,
+               label: ["IPv4: %.2mB"],
+               color: 'hsl(140, 100%, 50%)'
+       }, {
+               value: rx6_total + tx6_total,
+               label: ["IPv6: %.2mB"],
+               color: 'hsl(180, 100%, 50%)'
+       }]);
+
+       pie('ipv6-hosts-pie', [{
+               value: v4_total,
+               label: ["<%:%d IPv4-only hosts%>"],
+               color: 'hsl(140, 100%, 50%)'
+       }, {
+               value: v6_total,
+               label: ["<%:%d IPv6-only hosts%>"],
+               color: 'hsl(180, 100%, 50%)'
+       }, {
+               value: ds_total,
+               label: ["<%:%d dual-stack hosts%>"],
+               color: 'hsl(50, 100%, 50%)'
+       }]);
+
+       kpi('ipv6-hosts', '%.2f%%'.format(100 / (ds_total + v4_total + v6_total) * (ds_total + v6_total)));
+       kpi('ipv6-share', '%.2f%%'.format(100 / (rx4_total + rx6_total + tx4_total + tx6_total) * (rx6_total + tx6_total)));
+       kpi('ipv6-rx', '%1024.2mB'.format(rx6_total));
+       kpi('ipv6-tx', '%1024.2mB'.format(tx6_total));
+}
+
+function bubbleDismiss()
+{
+       var bubble = document.getElementById('detail-bubble');
+
+       bubble.className = '';
+       document.body.appendChild(bubble);
+
+       return false;
+}
+
+
+//]]></script>
+
+<h2 name="content"><%:Netlink Bandwidth Monitor%></h2>
+
+<div id="detail-bubble">
+       <span id="bubble-arrow"></span>
+       <div>
+               <div class="head">
+                       <a class="dismiss" href="#" onclick="this.blur(); return bubbleDismiss()">×</a>
+                       <div class="pie">
+                               <label>Download</label>
+                               <canvas id="bubble-pie1" width="100" height="100"></canvas>
+                       </div>
+                       <div class="pie">
+                               <label>Upload</label>
+                               <canvas id="bubble-pie2" width="100" height="100"></canvas>
+                       </div>
+                       <div class="kpi">
+                               <ul>
+                                       <li><%_Hostname: <big id="bubble-hostname">example.org</big>%></li>
+                                       <li><%_Vendor: <big id="bubble-vendor">Example Corp.</big>%></li>
+                               </ul>
+                       </div>
+               </div>
+               <table id="bubble-table"></table>
+       </div>
+</div>
+
+<hr>
+
+<p>
+       <%:Select accounting period:%>
+       <select id="nlbw.period" style="display:none"></select>
+</p>
+
+<hr>
+
+<ul class="cbi-tabmenu">
+       <li id="tab.nlbw.traffic" class="cbi-tab"><a href="#" onclick="return switchTab('traffic')"><%:Traffic Distribution%></a></li>
+       <li id="tab.nlbw.layer7" class="cbi-tab-disabled"><a href="#" onclick="return switchTab('layer7')"><%:Application Protocols%></a></li>
+       <li id="tab.nlbw.ipv6" class="cbi-tab-disabled"><a href="#" onclick="return switchTab('ipv6')"><%:IPv6%></a></li>
+       <li id="tab.nlbw.export" class="cbi-tab-disabled"><a href="#" onclick="return switchTab('export')"><%:Export%></a></li>
+</ul>
+
+<div class="cbi-section" id="container.nlbw.traffic">
+       <div>
+               <div class="pie">
+                       <label><%:Traffic / Host%></label>
+                       <canvas id="traf-pie" width="200" height="200"></canvas>
+               </div>
+
+               <div class="pie">
+                       <label><%:Connections / Host%></label>
+                       <canvas id="conn-pie" width="200" height="200"></canvas>
+               </div>
+
+               <div class="kpi">
+                       <ul>
+                               <li><%_<big id="host-total">0</big> hosts%></li>
+                               <li><%_<big id="rx-total">0</big> download%></li>
+                               <li><%_<big id="tx-total">0</big> upload%></li>
+                               <li><%_<big id="conn-total">0</big> connections%></li>
+                       </ul>
+               </div>
+       </div>
+       <table id="host-data">
+               <tr>
+                       <th width="10%" class="hostname"><%:Host%></th>
+                       <th width="5%"><%:MAC%></th>
+                       <th width="5%"><%:Connections%></th>
+                       <th width="30%" colspan="2"><%:Download (Bytes / Packets)%></th>
+                       <th width="30%" colspan="2"><%:Upload (Bytes / Packets)%></th>
+               </tr>
+       </table>
+</div>
+
+<div class="cbi-section" id="container.nlbw.layer7" style="display:none">
+       <div>
+               <div class="pie">
+                       <label><%:Download / Application%></label>
+                       <canvas id="layer7-rx-pie" width="200" height="200"></canvas>
+               </div>
+
+               <div class="pie">
+                       <label><%:Upload / Application%></label>
+                       <canvas id="layer7-tx-pie" width="200" height="200"></canvas>
+               </div>
+
+               <div class="kpi">
+                       <ul>
+                               <li><%_<big id="layer7-total">0</big> different application protocols%></li>
+                               <li><%_<big id="layer7-most-rx">0</big> cause the most download%></li>
+                               <li><%_<big id="layer7-most-tx">0</big> cause the most upload%></li>
+                               <li><%_<big id="layer7-most-conn">0</big> cause the most connections%></li>
+                       </ul>
+               </div>
+       </div>
+       <table id="layer7-data">
+               <tr>
+                       <th width="20%"><%:Application%></th>
+                       <th width="10%"><%:Connections%></th>
+                       <th width="30%" colspan="2"><%:Download (Bytes / Packets)%></th>
+                       <th width="30%" colspan="2"><%:Upload (Bytes / Packets)%></th>
+               </tr>
+       </table>
+</div>
+
+<div class="cbi-section" id="container.nlbw.ipv6" style="display:none">
+       <div>
+               <div class="pie">
+                       <label><%:IPv4 vs. IPv6%></label>
+                       <canvas id="ipv6-share-pie" width="200" height="200"></canvas>
+               </div>
+
+               <div class="pie">
+                       <label><%:Dualstack enabled hosts%></label>
+                       <canvas id="ipv6-hosts-pie" width="200" height="200"></canvas>
+               </div>
+
+               <div class="kpi">
+                       <ul>
+                               <li><%_<big id="ipv6-hosts">0%</big> IPv6 support rate among hosts%></li>
+                               <li><%_<big id="ipv6-share">0%</big> of the total traffic is IPv6%></li>
+                               <li><%_<big id="ipv6-rx">0B</big> total IPv6 download%></li>
+                               <li><%_<big id="ipv6-tx">0B</big> total IPv6 upload%></li>
+                       </ul>
+               </div>
+       </div>
+       <table id="ipv6-data">
+               <tr>
+                       <th width="10%" class="hostname"><%:Host%></th>
+                       <th width="5%"><%:MAC%></th>
+                       <th width="5%"><%:Family%></th>
+                       <th width="40%" colspan="2"><%:Download (Bytes / Packets)%></th>
+                       <th width="40%" colspan="2"><%:Upload (Bytes / Packets)%></th>
+               </tr>
+       </table>
+</div>
+
+<div class="cbi-section" id="container.nlbw.export" style="display:none">
+       <ul>
+               <li><a href="<%=url('admin/nlbw/data')%>?type=csv&#38;group_by=mac&#38;order_by=-rx,-tx"><%:CSV, grouped by MAC%></a></li>
+               <li><a href="<%=url('admin/nlbw/data')%>?type=csv&#38;group_by=ip&#38;order_by=-rx,-tx"><%:CSV, grouped by IP%></a></li>
+               <li><a href="<%=url('admin/nlbw/data')%>?type=csv&#38;group_by=layer7&#38;order_by=-rx,-tx"><%:CSV, grouped by protocol%></a></li>
+               <li><a href="<%=url('admin/nlbw/data')%>?type=json"><%:JSON dump%></a></li>
+       </ul>
+</div>
+
+<script type="text/javascript">//<![CDATA[
+       cbi_t_add('nlbw', 'traffic');
+       cbi_t_add('nlbw', 'layer7');
+       cbi_t_add('nlbw', 'ipv6');
+       cbi_t_add('nlbw', 'export');
+
+       XHR.get('<%=url("admin/nlbw/list")%>', null, function(xhr, res) {
+
+               if (res !== null && typeof(res) === 'object' && res.length > 0) {
+                       trafficPeriods = res;
+                       renderPeriods();
+               }
+
+               xhr.open('GET', 'https://raw.githubusercontent.com/jow-/oui-database/master/oui.json', true);
+               xhr.onreadystatechange = function() {
+                       if (xhr.readyState === 4) {
+                               try { res = JSON.parse(xhr.responseText); }
+                               catch(e) { res = null; }
+
+                               if (res !== null && typeof(res) === 'object' && (res.length % 3) === 0)
+                                       ouiData = res;
+
+                               fetchData(trafficPeriods[0]);
+                       }
+               };
+               xhr.send(null);
+       });
+//]]></script>
+
+<%+footer%>
diff --git a/applications/luci-app-nlbwmon/root/etc/uci-defaults/40_luci-nlbwmon b/applications/luci-app-nlbwmon/root/etc/uci-defaults/40_luci-nlbwmon
new file mode 100644 (file)
index 0000000..c977177
--- /dev/null
@@ -0,0 +1,11 @@
+#!/bin/sh
+
+uci -q batch <<-EOF >/dev/null
+       delete ucitrack.@nlbwmon[-1]
+       add ucitrack nlbwmon
+       set ucitrack.@nlbwmon[-1].init=nlbwmon
+       commit ucitrack
+EOF
+
+rm -f /tmp/luci-indexcache
+exit 0