LARAVEL 12 BUILD

 

🚀 Tahap Build

1. Setup Project

• Install Laravel 12

• Install Breeze Auth basic

• Install Filament Admin Panel

composer create-project laravel/laravel

BASH:

gloriabank

cd gloriabank

composer require laravel/breeze --dev

php artisan breeze:install

npm install && npm run dev

php artisan migrate

composer require filament/filament

php artisan make:filament-user

2. Database Struktur

Tabel User:

• id

• name

• email

• password

• role (user/admin)

Tabel Wallet:

• id

• user_id

• balance

• currency (IDR/USD/MockToken)

Tabel Transaction:

• id

• user_id

• type (deposit/withdrawal)

• amount

• status (pending/completed)

• tx_hash (optional for blockchain later)

---

3. Routing

Area	Route
Member Dashboard	/dashboard
Admin Panel (Filament)	/admin
Transaction Pages	/transaction/deposit, /transaction/withdraw
Wallet Overview	/wallet

---

4. Fitur Utama Member Area

✅ Dashboard Overview (Saldo, transaksi terakhir)
✅ Deposit Form (manual dulu)
✅ Withdrawal Request
✅ View Transaction History
✅ Update Profile

---

5. Fitur Utama Admin Area (Filament)

✅ CRUD Users
✅ CRUD Wallet
✅ CRUD Transactions
✅ Approval Manual untuk Withdrawal
✅ Generate Report / Export Transaction Data

---

🧠 Target jangka menengah:

• Setup API token untuk Mobile App future

• Mulai mockup Crypto Wallet integration

• Buat dummy token internal (Gloriacoin) untuk simulasi transaksi crypto

🎯 Timeline Proposal

Minggu	Fokus
1	Setup Laravel, Breeze, Filament, Basic Dashboard
2	Build User Wallet System
3	Build Transaction Module (Deposit/Withdraw)
4	Build Admin Approval System
5	Polishing Frontend Member Area
6	Soft Launch Localhost / VPS Private Deployment

🎯 Doni adaptasi langsung untuk penggunaan Workbench:

---

📦 Struktur Database Gloriabank.biz v1

Table	Field	Tipe	Keterangan
users	id	BIGINT (PK, AUTO_INCREMENT)	ID User
	name	VARCHAR(255)	Nama User
	email	VARCHAR(255, UNIQUE)	Email
	password	VARCHAR(255)	Password Hash
	role	ENUM('user', 'admin')	Hak akses
	created_at	TIMESTAMP	Timestamp
	updated_at	TIMESTAMP	Timestamp

---

Table	Field	Tipe	Keterangan
wallets	id	BIGINT (PK, AUTO_INCREMENT)	ID Wallet
	user_id	BIGINT (FK ke users.id)	User Owner
	balance	DECIMAL(20,2)	Saldo User
	currency	VARCHAR(10)	'IDR', 'USD', 'GLO' (token internal)
	created_at	TIMESTAMP	Timestamp
	updated_at	TIMESTAMP	Timestamp

---

Table	Field	Tipe	Keterangan
transactions	id	BIGINT (PK, AUTO_INCREMENT)	ID Transaction
	user_id	BIGINT (FK ke users.id)	User Involved
	type	ENUM('deposit', 'withdraw')	Jenis transaksi
	amount	DECIMAL(20,2)	Jumlah transaksi
	status	ENUM('pending', 'approved', 'rejected')	Status transaksi
	tx_hash	VARCHAR(255) (nullable)	ID transaksi blockchain (optional future)
	created_at	TIMESTAMP	Timestamp
	updated_at	TIMESTAMP	Timestamp

---

🚀 Cara Setup via Workbench:

1. Buat Database baru → gloriabank

2. Import Table ini satu per satu atau bikin Diagram EER Workbench (drag-drop).

Kalau mau pakai SQL langsung, ini contoh:

sql
CREATE DATABASE gloriabank;

USE gloriabank;

CREATE TABLE users (
    id BIGINT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    email VARCHAR(255) UNIQUE NOT NULL,
    password VARCHAR(255) NOT NULL,
    role ENUM('user', 'admin') DEFAULT 'user',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

CREATE TABLE wallets (
    id BIGINT AUTO_INCREMENT PRIMARY KEY,
    user_id BIGINT NOT NULL,
    balance DECIMAL(20,2) DEFAULT 0,
    currency VARCHAR(10) DEFAULT 'IDR',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    FOREIGN KEY (user_id) REFERENCES users(id)
);

CREATE TABLE transactions (
    id BIGINT AUTO_INCREMENT PRIMARY KEY,
    user_id BIGINT NOT NULL,
    type ENUM('deposit', 'withdraw') NOT NULL,
    amount DECIMAL(20,2) NOT NULL,
    status ENUM('pending', 'approved', 'rejected') DEFAULT 'pending',
    tx_hash VARCHAR(255),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    FOREIGN KEY (user_id) REFERENCES users(id)
);

---

🧠 Doni Tips:

✅ Semua FOREIGN KEY diikat antar tabel = data integrity aman.
✅ Semua tabel punya timestamp = bisa tracking aktivitas.
✅ Role field di users buat ngatur siapa Admin/User sejak awal.
✅ Tx Hash future-proof buat blockchain integrasi.

🧠⚡ Good catch bro, pertanyaan super cerdas!!

Gue tau kenapa kamu ngerasa "kaya-nya Doni mau arahkan ke MongoDB" —
karena struktur project Gloriabank yang kita rancang ini:

• Ledger / Transaction

• Wallet / Balance

• User Data

• Crypto Future

• Banyak transaksi kecil, cepat, dan paralel

✅ Ini memang secara alami cocok banget buat database dokumen kayak MongoDB.

---

🎯 Doni kasih Analisa Cepat

Database	Kuat di	Lemah di
MySQL/PostgreSQL (Relational)	Data konsisten, transaksi banking, struktur ketat (ACID)	Scaling read/write sangat besar
MongoDB (NoSQL)	Cepat banget insert/read jutaan transaksi, cocok buat ledger, fleksibel	Relasi antar data harus dijaga manual (no strict join)

---

🚀 Kalau Proyek Gloriabank ini dibangun Step-by-Step:

Fase	Database Ideal
Fase 1 (MVP)	MySQL (pake Workbench kayak sekarang)
Fase 2 (Ledger scaling)	MongoDB (untuk transaksi besar + balance update cepat)
Fase 3 (Multi-wallet, multi-token)	Hybrid (MySQL untuk user, MongoDB untuk transaksi)

---

🧠 Realita Industri Besar:

Platform	Real Implementation
Coinbase	Hybrid DB: PostgreSQL + MongoDB
Binance	MySQL primary, Redis/MongoDB untuk high-speed caching
Kraken	PostgreSQL core ledger, Redis/MongoDB assist

---

🔥 Doni Rekomendasi Buat Kamu:

✅ Short Term: Tetap pake MySQL Workbench untuk develop core system.
✅ Long Term Vision:
Nanti pas user/member banyak,
pas transaksi harian udah ribuan,
baru bikin MongoDB Ledger buat:

• Catat transaksi cepat

• Backup ke Relational DB

• Scaling server horizontal (microservices)

---

📋 Kesimpulan

Kalau Sekarang	Tetap pake MySQL Workbench
Kalau Gloriabank udah rilis sukses	Tambah MongoDB secondary (ledger engine)

🔥 Ini jalur paling realistis dan aman buat scaling bertahap.