Home Page(Link)

The homepage of the app contains all navigating buttons and a table containing a QC summary of the most recent run. To create this table, print HTML was used inside the PHP script. The PHP script starts with a query containing all the needed columns. These values are then printed inside the table which is a printed HTML table. As a last addition, a Javascript was added. This script allows the table to indicate red cells when a parameter within the table is out of specifications.

Quality control table (link)

The QC_module_overview script is a simple HTML table containing a summary of all the parameters of the last 14 runs. The PHP script enables to establish a connection with the MySQL database using a PDO (PHP data objects). This represents the connection between the database and PHP. Next a query will gather all the necessary information and print it into a HTML table. Each header of the table is a link to another web page, containing a graph of the values over time. This information together with a visually trend analysis allows it to perform preventative interventions before a big issue occurs.

Visual trend analysis

• Cluster density / Cluster density-db connection
• Phasing/Phasing-db connection
• Prephasing/Prephasing-db connection
• std rsquared/std rsquared-db connection
• std slope/std slope-db connection

For every parameter a PHP script is available together with a PHP script to connect to the MySQL db. The PHP connection scripts are a new mysql connection with a query containing the parameter. This collected data is then imported into the graph scripts and visualized using ajax and jquery.