GSBStock

About the project

GSBStock uses an MVC architecture in PHP, backed by a relational MySQL database. User accounts are managed with multiple security measures—including password hashing and status validation. The system supports automated inventory updates via triggers after order completion and restricts user actions based on role and access level. Deployment is streamlined with Docker for easy setup on any machine, and role-based interfaces optimize user workflow. The application aims not only to digitize stock management for GSB but also to allow developers to learn professional practices: mastering C#, deepening SQL/database skills, and building robust, secure web apps. Testing is facilitated via multiple demo accounts, and user experiences differ depending on their permissions.

Key Features

• • User Roles: Administrator, Employee, and Client, each with specific permissions and access levels​
• • Stock Management: Track and manage product inventory for pharmaceutical sales​
• • Order Handling: Create incoming (positive) and outgoing (negative) orders, with order validation​
• • Role-Based Interfaces: Users see tailored navigation and controls based on their role
• • Account Management: Registration, admin approval, and enterprise affiliation for clients​
• • Access Level Control: Three-tier access to restrict product operations by user level
• • Automated Stock Updates: Trigger updates inventory after order validation​
• • Password Security: Passwords hashed and verified before account access​
• • Input Validation: Strict checks on user inputs (e.g., emails, password strength)
• • Error Management: Inform users of failed operations, with SGBD error handling
• • Data Protection: Sensitive credentials kept in environment files
• • Deployment via Docker: Fast setup and multi-container support on any machine