Background & Goals
Hardware retail businesses face unique operational challenges—such as handling fractional units (divisible measurements like weight, length, or custom cut sizes), managing bulk supplier credit, tracking equipment rentals, and running local-time compliant daily cash balancing.
This project was developed as a modern, high-performance Point of Sale (POS) and Enterprise Resource Planning (ERP) platform built explicitly to streamline inventory management, barcode billing, customer credit tracking, human resources, and multi-role operations for hardware retail enterprises.
Key Features & User Flows
- High-Speed POS Checkout: Integrated barcode scanning, support for fractional unit calculations (meters, kilograms, pieces), held cart queues, instant discounts, returns handling, and receipt thermal/PDF printing.
- Advanced Inventory & Stock Control: Real-time stock adjustments, reorder threshold alerts, supplier Purchase Orders (PO), and Goods Received Notes (GRN).
- Customer & Supplier Credit Management: Comprehensive ledger tracking, debt settlement workflows, and credit limit enforcement.
- Financial Operations & Cash Drawer: Expenses recording, daily cash drawer reconciliation, bank deposits, and profit/loss statements.
- HR & Payroll Management: Employee profile management, shift scheduling, attendance recording, leave requests, and automated monthly salary sheet calculation.
- Equipment & Tool Rentals: Specialized rental module to issue tools, track rental durations, record security deposits, and process equipment returns.
- Role-Based Access Control (RBAC): Granular permission architecture distinguishing between Admins, Managers, and Cashiers.
Architecture & Design Decisions
- Backend Engine: Powered by Laravel 12 on PHP 8.3 for robust API endpoints, queued job processing, structured ORM models, and strict RBAC controls.
- Frontend Stack: Single-page dynamic components compiled via Vite 7 with Tailwind CSS v4 styling and dynamic visual utilities.
- Dual-Database Support: Dual configuration utilizing lightweight SQLite for development/testing environments and optimized MySQL 8 for production workloads.
- Document & Label Generation: Server-side PDF invoice generation (dompdf) and SVG/PNG barcode label creation (picqer/php-barcode-generator).
Challenges Solved
- Divisible Unit Inventory Accounting: Implemented precise floating-point unit math for inventory items sold by length or weight to ensure accurate stock deductions without rounding discrepancies.
- Timezone & Local Fiscal Synchronization: Standardized system-wide timezone management (Asia/Colombo) to ensure invoice generation, daily financial reconciliation, and HR attendance records sync perfectly with local business operating hours.
- Optimized Production Deployment Pipeline: Designed cross-platform automated build scripts (build.bat, build.sh) handling Composer optimization, route/config caching, asset bundling, and graceful database migrations.