Z-ENG: Pharmacy Management Platform

Félév: 2025-2026 tavasz

Kategória: Nincs megadva

Téma leírása

This project is divided into two parts corresponding to Project Lab and Thesis, allowing students to complete a usable core pharmacy system in the current semester and extend it in the following semester.

Part 1: Project Lab (Design & MVP)

Design and implement a standalone pharmacy management application that supports daily pharmacy operations: managing items and stock, selling products at the counter using barcode scanning, and monitoring expired / soon-to-expire medicines using batch-level expiry dates.

A key professional requirement is to manage stock by batch/lot and expiry date, and to support FEFO (First-Expired, First-Out) to reduce waste and avoid dispensing near-expiry products.

The main requirements include:

• Product catalog management (add, edit, delete, view)
• Product details: name, dosage/form, barcode (EAN/UPC/GTIN), selling price, category/VAT (as a simple field)
• Batch-based inventory management (add, edit, delete, view)
• Each stock entry stored per batch/lot with: batch number, expiry date, purchase cost, quantity
• Inventory adjustments with reasons (damage, correction, return)
• Expiry monitoring
• Automatic lists: Expired, Expiring soon (e.g., next 30/60/90 days)
• FEFO support when selecting which batch to sell first
• Point-of-Sale (POS) sales workflow
• Scan barcode -> item lookup -> price shown -> add to cart -> finalize sale
• Finalizing a sale decrements inventory (ideally from the FEFO batch order)
• Barcode scanner support (practical requirement)
• Support common USB scanners operating as keyboard wedge devices (scanned code appears as typed input in the focused field)
• Local SQL-based database (no networking required)
• SQLite or PostgreSQL, with transaction-safe updates so stock cannot become inconsistent
• Graphical user interface suitable for pharmacy staff
• Simple screens for cashier (POS) and manager (inventory/expiry/reports)

The outcome of this part is a working minimum viable product (MVP) demonstrating correct stock decrement during sales, correct batch/expiry handling, clear workflows, and basic usability, tested with a small sample dataset and typical pharmacy scenarios.

Part 2: Thesis (Enhancements & Evaluation)

Extend the system with additional features and refinements, such as:

• Improved FEFO automation: Automatic batch selection, partial batch consumption, and clear batch traceability during sales
• Purchasing and supplier workflow: Purchase orders / receiving notes, supplier history, cost tracking per batch
• Reorder support (automated management): Low-stock alerts, suggested reorder quantities based on recent sales trends
• Record history and audit logging: Who changed what (prices, stock, batch edits), and when, aligned with good distribution practice expectations for traceable records
• Data export and reporting: Daily/monthly sales summaries, expiry value-at-risk, fast/slow movers
• Improved UI, validation, and reliability: Stronger input validation, backups/restore, error handling, and consistency checks
• Evaluation: Scenario-based correctness tests (inventory invariants), performance measures (checkout time), and a small usability evaluation with sample users

Maximális létszám: 2 fő