Matt Bateman
Web Development:
SolutionsISC
In addition to my full-time responsibilities at Industrial Supply Co., I took sole responsible for the full-stack development and implementation of a new website: SolutionsISC. As COVID and quarantines hit, management needed a way to track internal activities. The deadline was rapid; I had just over a month.
I began by outlining the framework and determining essentials - who would be using this? What’s the scope? What information do we want to collect? Simple design was a high priority. The site had to be accessible and friendly enough for ISC's users, many of whom are older and uneager to engage with new technology.
I built the site in PHP with a MySQL database to create distinct tables for the users, the customers, and the user's activities. Supplementary tables were added, as well as the queries and framework to allow users to fill out forms, update activities, and add new customers.
Logged-in managers would have additional abilities to see all user's data, approve entries, and make edits. They also had access to a dashboard, built with d3.js, to visualize site statistics.
After deployement in April 2020, new features were requested by June. In the v2 of the site, Javascript allowed users to download their data to CSV, as well as link multiple users and customers to entries. I updated the layout to better accomodate mobile users.
Additionally, all entries now had a status, which enabled supervisors to mark users' entries that they had read and accepted. Emails would be sent to supervisors upon creation of a new entry, and in return, users would receive an email if a supervisor updated the status of one of their entries.
See Also:
