Stuart Calcote | Full Stack Web Developer

Invoice Calculator 1

One of multiple in-house customer invoice calculators I wrote to cut down on time consuming data-entry and auditing tasks for a customer. With functionality completed, this tool reduced the time to complete a series of monthly tasks from 1-2 business days to under 1 hour.

It's a Python Flask-based web-application backed by a MySQL (or SQLite) database. Some of its services include: user authentication, customer data storage, automated email notifications, reporting, and notably a data import utility connected to the customer's Learning Management System (LMS) via a RESTful integration.

My Role

Front end & backend developer, Designer, QA, Deployment

Technology

Python, JavaScript, Flask, Bootstrap 4, JQuery, Gunicorn, MySQL, SQLite3, Nginx, Rocky Linux

Source Code

This project is not open source

Log in page to authenticate employees
login
The list of customer accounts are easily search-able
table of accounts
Adding new accounts
new account
Editing an existing account
existing account
A simple user import wizard accepts CSVs
user import wizard
The importer returns user-by-user import results
user import results
Graphical reporting provides and overview of categories and billing
reporting
reporting
Setup configs, batch tools, and logs are available from the GUI
setup