SAGE web application for pharmacy management.
This application manages :
ERD for database
Stock/inventory page covers mostly CRUD operation. User can Create/Read/Update/Delete medicine entities from database. Purchase page displays suggestion based on futures stock and real stock found in database.Table also displays a select box in case there are multiple matching between medicine from local invetory and medicine from provider.
The common-way to generate commands/orders is using the purchase page. From purchase page, quantity to order for each medicines are computed beforehand. That way, one has a wider overview about the command because we have to take in count that certain providers have certain prerequisites about the orders, either by quantity or pricing.
Orders have several status, displayed as Kanban for simplicity.
Orders list
- ORDERED is the initial status of an order
- PENDING means that provider has been notified and they are processing the request. One can send mail directly from the app to notify the provider.
- RECEIVED means that items have been delivered. User can attach evidence (scan image or PDF) file to order.
- terminal stage :
- AVOIR means that some items include issue. (Wrong quantity, expired items, etc...)
- FINISHED means that order has been succefully fulfilled.
- ARCHIVED means that order has been succefully fulfilled but datas might be used later.
Since we can not know each provider's catalogue file pattern, file has to follow some specific pattern in order to be deserialized.
Medicine in inventory and medicine from provider correspondance also has to be done by the user since we can not rely on medicine/item names. If we could, a simple regex matching would have been sufficient.
Archive page displays list of archived orders with receipt/bill/evidence attached to them.
Preview of the application is hosted on Google Cloud. Credentials :
- username : admin
- password : free
- features for client interaction
- features for cashing
- personnel management
Made with ❤️