Back to Portfolio
Web Application

OptiPharm SPK

OptiPharm SPK screenshot 1
1 / 7

About the Project

OptiPharm SPK is a web-based decision support system (DSS) designed specifically to assist pharmacies in determining the best drug supplier recommendations objectively, quickly, and measurably. The application is built by implementing a multi-criteria analytical decision-making method using the ELECTRE (Elimination and Choice Translating Reality) algorithm. The system is mathematically programmed with absolute precision and aligned 100% with the parameters and logic from the scientific journal: "Aplikasi Sistem Pendukung Keputusan Pemilihan Supplier Obat Menggunakan Metode ELECTRE di Apotek Crystal Farma Oebobo" (Jurnal J-ICON, Vol. 10 No. 1, March 2022).

Key Features

✨ Main Features

This system offers several key features to facilitate pharmacy administrators in managing data and making decisions:

  • 🔒 Admin Security Authentication: A protected login system utilizing JSON Web Tokens (JWT) and bcryptjs password encryption to prevent unauthorized access to the dashboard.
  • 📦 Supplier Data Management (CRUD): Complete management of active drug supplier data, supporting a soft-delete mechanism to preserve the integrity of historical calculation records.
  • 💊 Drug Data Management (CRUD): A master data registry for medicines to facilitate supplier ranking tailored to specific types of drugs.
  • ⚖️ Dynamic Criteria Weight Settings: Adjustment of priority weights (scale 1-5) across 6 main criteria (Price, Discount, Expiration Date, Stock, Distance, Payment System) directly via the admin interface.
  • 🧮 Automated ELECTRE Calculation Engine: A multi-stage guided assessment process that instantly executes the 12 mathematical steps of the ELECTRE algorithm on the backend.
  • 📊 Chart Visualization & Matrix Transparency: Presentation of the final results using an interactive bar chart and detailed visualization of transition matrices at every step of the calculation (Normalization, Concordance/Discordance, Thresholds, up to the Dominant Aggregate Matrix).
  • 📄 PDF Report Export: A feature to instantly print a summary report of the recommendation results directly to PDF format (client-side generation) for physical archival needs.

Project Specs

Category
Web Application

Tech Stack

Frontend / Client
React 18Tailwind CSS v4Vite 6Recharts
Backend / Server
Node.js & Express 5TypeScript (v6)Prisma ORMVercel Serverless
Database
PostgreSQL (Neon)