Design HTML Reports - Githubissues

jxmot / router-log-monitor

A utility that monitors Netgear R6400 logs received via email(IMAP). It processes them and parses each entry for writing into a database.

MIT License

0 stars 0 forks source link

Design HTML Reports #14

Closed jxmot closed 3 years ago

jxmot commented 3 years ago

A Node.js instance will be created to serve the HTML report pages. It will use the parsed data created by logwatcher.

jxmot commented 3 years ago

Prerequisite steps:

Log.js replace with npm simple-text-log - DONE
Convert mysql source to an npm

jxmot commented 3 years ago

A separate node.js app has been created (WIP). It provides an endpoint for GET requests, where a "report ID" is contained in the query.

At this time converting the mysql source to an NPM is on hold.

jxmot commented 3 years ago

Report HTML table generation is complete and has the following features:

Tables can be retrieved with a GET and a "report ID".
Some aspects of report tables are defined (configurable) -
- Table title
- database columns are mapped to table column headings
- Node require() caching is defeated, report definitions will always be read.
- TBD
A "library" of SQL query files is used for data retrieval.
- Each SQL file name, report IDs and report definitions are identical

jxmot commented 3 years ago

Added ability to optionally generate full HTML page per report. It uses Bootstrap 4.

jxmot commented 3 years ago

Added ability to optionally generate 2 tier table headings

jxmot commented 3 years ago

Added public_html/index.html that retrieves 3 report tables