PharmaSys
Enterprise Pharmacy Inventory & Multi-Branch POS System
Local community pharmacies routinely suffer financial losses and safety hazards from untracked medication expirations, manual inventory errors, and unverified dispensing in paper registers.
Staff have diverse technical literacy; cashier checkouts must be fast, offline-tolerant, and require zero manual batch calculation during high-volume periods.
Engineered a centralized ERP-level pharmacy management system featuring automated FEFO (First-Expiry First-Out) stock depletion, real-time expiry warning thresholds, multi-branch POS terminal transactions, purchasing orders, and role-based access control.
PharmaSys: Strict FEFO Inventory & POS Pipeline
Atomic batch-level depletion with First-Expiry First-Out row-locking
When a cashier initiates a sale, the POS controller triggers an atomic transaction. Batches are selected strictly ordered by earliest expiry_date (ASC) with FOR UPDATE row locks. Stock decrements across consecutive batches until the requested volume is fulfilled, immediately logging an immutable audit record.
Implemented automated database triggers and service checks that force stock dispensing from the nearest expiration batch, eliminating shelf spoilage.
Enforced separated permission tiers (Owner, Administrator, Cashier) with immutable change logs on all stock adjustments and cash registers.
Structured batches, products, suppliers, and transaction line items in MySQL to guarantee audit consistency across multi-branch expansion.