Developing a showcase for the https://www.cave.tech website to show the the realtime components in action for the web applications that are built. This version is 1.24 and was created back in 2017. Since then a new version 2.0 is being created with more features like excel ribbons, menus, and copying and pasting.
The table was created using completely custom UI, HTML5, PHP, SQL PDO, and Javascript. The reports were created using PDF.js library and a template was created to load the data. I designed the table to make data entry easier for editing large portions of data and added pagination and sql optimizations to improve the performance.
I created a css class that would style the table and a Javascript library for the functionality of the table. In the code review example I show that I am taking advantage of angular to create a simple HTML table. The css and Javascript will customize the look and functionality of the table.
The app has features such as in cell editing and update callbacks. The update callback will update the SQL table in realtime using a simple PHP script and PDO to update the SQL table. When a cell is edited the master dataset is also updated as well to provide a cached copy of the data to easily load into the report.
Pagination is used to improve performance when loading the data from the SQL database. I update the cached version every call to the SQL database and load data into the table from the cached version of the table.