Donnés
At my day job as a sales assistant, we used handwritten notes to handle special product orders. While this worked to some extent, it often led to misplaced notes, unreadable handwriting, and a general lack of overview of active and completed orders.
To solve this, I built a digital Order Management System (OMS) where all orders are registered, trackable, and exportable to external partners when needed. The system is hosted locally on a LAMP-stack server (Linux, Apache, MySQL, PHP) for GDPR compliance, with a mirrored backup server to ensure continuity in case of technical failures. The application is mainly coded in PHP, styled with CSS, and uses JavaScript and Chart.js to generate visual dashboards.
The platform is designed to be intuitive and user-friendly, allowing staff members with no technical background to quickly place, view, and manage orders easily and securely.
All users must log in with a username and password, with passwords securely hashed using bcrypt to protect sensitive information.
Upon login, users are greeted with a simple dashboard displaying the number of orders by type. They can easily navigate to modules for placing new orders, viewing orders, and exporting data. The interface is kept clean and minimal for ease of use.
When creating a new order, certain fields like name and phone number are mandatory. Once all required fields are completed, the "Save Order" button becomes active, followed by the "Print" option that allows a receipt to be generated for the customer.
The order overview displays all important details in a table format. Users can open each order for more detailed information or search for specific customers or products via an AJAX-powered search field. Deletion of orders is also handled here, with confirmation prompts to prevent mistakes.
When deleting an order, the system requires user confirmation before permanently removing the order and the associated customer data, ensuring safer operation.
When it's time to place production orders, users can filter orders by date and export them into a PDF file. Only the necessary information (no personal customer data) is shared with external production partners, maintaining GDPR compliance.