"Do a Good Turn Daily — Lord Baden-Powell"

Gold Testing Lab ERP

Gold Testing Lab ERP

Developing Tools
  • Front-End: Thymeleaf, HTML, CSS, Bootstrap, jQuery, Javascript
  • Back-End: Java Spring Boot Framework
  • Database: MySQL
Github Link

Project Description

Developed a comprehensive Gold Testing Lab ERP system that analyzes raw Excel data from testing machines and automatically generates professional Gold Purity Certificates and Invoices on official company letterheads. The software features a robust B2B customer ledger system with automated email notifications for payments and outstanding dues. Additionally, it integrates comprehensive customer and product management, real-time live market pricing, and a highly interactive analytics dashboard.

The main features of this project is:
  • Automated Certificate Generation- Processes raw Excel data to instantly create official Gold Purity Certificates and Invoices on company letterheads.
  • Comprehensive B2B Ledger- A dedicated ledger system for B2B clients to smoothly manage billing, payments, and outstanding dues.
  • Automated Email Notifications- Keeps clients updated by automatically sending emails for payment receipts and due reminders.
  • Staff Management & Appointment System- Manages employee profiles with Role-Based Access Control (RBAC) and generates official appointment letters.
  • Manual Data Backup System- Enables administrators to create and download manual backups for data security and easy recovery.
  • Customer & Product Management- Efficiently organizes and maintains records for both customers and inventory.
  • Live Market Pricing- Integrates real-time market rates directly into the system for accurate calculations.
  • Interactive Analytics Dashboard- Provides clear, visual insights into business performance at a glance.

Project Gallery