Payment Service

LAST UPDATED on 20-10-2023 by @Isuru

---

Code for the payment management service for the e-commerce application.

Flow

graph TD
    A(Customer checkout) -->|places order on| B(Shop)
    B --- note1>store payment info in db]
    B --> |forwards info to| C(Payment gateway) -.-> D(Risk check)
    note2>no need to worry about the following steps] ---E
    C --> E(Acquiring bank a.k.a Merchant's bank)
    E --> F(Card scheme ex. visa, master, etc)
    F --> G(Issuer bank a.ka. Customer's bank)
    G --> if{approved?} --> |yes| H(update ledger & wallet)
    
    if --> |no| I(halt) --> |failure| A
    H --> |success|A
    

Loading

Important

Sensitive credentials are stored in the .env file.
In order to run the application, create a secrets.properties file at the same folder as application.properties, sign up for a sandbox paypal account and add the CLIENT_ID and CLIENT_SECRET to the secrets.properties file.

Database

create database payment;

create table payment_record(
id INT not null auto_increment,
user_id VARCHAR(50) not null,
order_id INT not null,
amount DECIMAL not null,
datetime TIMESTAMP not null,
status VARCHAR(10) not null,
currency VARCHAR(4) not null,
payment_id VARCHAR(255),
description VARCHAR(255),
primary key(id)
);