This web application was part of a much larger application I developed. What you see here is the web user interface, which generally was only used to query historic data, view trend charts (Mouse over top of columns), manage batteries replaced, as well as the location thereof.
There is a background process that runs daily to go over 2 second data for each inverter (some sites had up to 24), as well as 2 second data for the system as a whole. After that process is ran, the database is updated with the aggregated information in a cache table, and a copy of the report is sent to all necessary parties. Click here to view an example of this report. Also, there was a detailed report sent out daily concerning the purity of the data. This report included each site's reporting purity as well as a trend chart for the last 30 days, any downtime and the duration, as well as any system messages that may have been logged during the downtime. An example of this report can be seen here.
Each project has it's own configuration file, which stores the database credentials for it's particular server, as well as pertinent information about the project, including an e-mail recipient list for ran reports.
