Tiranga Color Trading

{ "name": "tiranga-color-trading-app", "version": "1.0.0", "description": "Color trading demo app with UPI flow and MS SQL stored procedures", "main": "server/index.js", "scripts": { "start": "node server/index.js" }, "dependencies": { "cors": "^2.8.5", "dotenv": "^16.0.3", "express": "^4.18.2", "mssql": "^9.1.1", "uuid": "^9.0.0" } } # Copy to .env and update values PORT=4000 # MSSQL config MSSQL_USER=sa MSSQL_PASSWORD=YourStrong!Passw0rd MSSQL_SERVER=localhost MSSQL_DATABASE=TirangaTrading MSSQL_PORT=1433 MSSQL_TRUST_SERVER_CERT=true # UPI Merchant configuration (set your merchant UPI ID) MERCHANT_UPI=merchant@bank MERCHANT_NAME=TirangaMart CALLBACK_URL=http://localhost:4000/api/payment/verify -- Create database (run as a user with permission) IF DB_ID(N'TirangaTrading') IS NULL BEGIN CREATE DATABASE TirangaTrading; END GO USE TirangaTrading; GO -- Users table IF OBJECT_ID('Users') IS NULL BEGIN CREATE TABLE Users ( UserId INT IDENTITY(1,1) PRIMARY KEY, Name NVARCHAR(100) NOT NULL, Email NVARCHAR(150) NULL, CreatedAt DATETIME DEFAULT GETDATE() ); END GO -- Wallets table IF OBJECT_ID('Wallets') IS NULL BEGIN CREATE TABLE Wallets ( WalletId INT IDENTITY(1,1) PRIMARY KEY, UserId INT NOT NULL, Balance DECIMAL(18,2) DEFAULT 0, FOREIGN KEY (UserId) REFERENCES Users(UserId) ); END GO -- Transactions table IF OBJECT_ID('Transactions') IS NULL BEGIN CREATE TABLE Transactions ( TransactionId INT IDENTITY(1,1) PRIMARY KEY, WalletId INT NOT NULL, Amount DECIMAL(18,2) NOT NULL, Type NVARCHAR(20) NOT NULL, -- 'credit' or 'debit' Reference NVARCHAR(200) NULL, Meta NVARCHAR(500) NULL, CreatedAt DATETIME DEFAULT GETDATE(), FOREIGN KEY (WalletId) REFERENCES Wallets(WalletId) ); END GO -- Seed sample user IF NOT EXISTS (SELECT 1 FROM Users WHERE Email = 'user@example.com') BEGIN INSERT INTO Users (Name, Email) VALUES ('Demo User', 'user@example.com'); DECLARE @uid INT = SCOPE_IDENTITY(); INSERT INTO Wallets (UserId, Balance) VALUES (@uid, 0); END GO -- Stored procedure: Add funds (minimum 100) IF OBJECT_ID('sp_AddFunds') IS NOT NULL DROP PROCEDURE sp_AddFunds; GO CREATE PROCEDURE sp_AddFunds @UserId INT, @Amount DECIMAL(18,2), @Reference NVARCHAR(200) = NULL, @Success BIT OUTPUT, @Message NVARCHAR(255) OUTPUT AS BEGIN SET NOCOUNT ON; IF @Amount < 100 BEGIN SET @Success = 0; SET @Message = 'Minimum add amount is 100'; RETURN; END BEGIN TRY BEGIN TRANSACTION; DECLARE @WalletId INT; SELECT @WalletId = WalletId FROM Wallets WHERE UserId = @UserId; IF @WalletId IS NULL BEGIN INSERT INTO Wallets(UserId, Balance) VALUES(@UserId, 0); SET @WalletId = SCOPE_IDENTITY(); END UPDATE Wallets SET Balance = Balance + @Amount WHERE WalletId = @WalletId; INSERT INTO Transactions (WalletId, Amount, Type, Reference, CreatedAt) VALUES(@WalletId, @Amount, 'credit', @Reference, GETDATE()); COMMIT TRANSACTION; SET @Success = 1; SET @Message = 'Funds added successfully'; END TRY BEGIN CATCH IF @@TRANCOUNT > 0 ROLLBACK TRANSACTION; SET @Success = 0; SET @Message = ERROR_MESSAGE(); END CATCH END GO -- Stored procedure: Withdraw funds (minimum 300) IF OBJECT_ID('sp_WithdrawFunds') IS NOT NULL DROP PROCEDURE sp_WithdrawFunds; GO CREATE PROCEDURE sp_WithdrawFunds @UserId INT, @Amount DECIMAL(18,2), @Reference NVARCHAR(200) = NULL, @Meta NVARCHAR(500) = NULL, @Success BIT OUTPUT, @Message NVARCHAR(255) OUTPUT AS BEGIN SET NOCOUNT ON; IF @Amount < 300 BEGIN SET @Success = 0; SET @Message = 'Minimum withdrawal amount is 300'; RETURN; END BEGIN TRY BEGIN TRANSACTION; DECLARE @WalletId INT; DECLARE @Balance DECIMAL(18,2); SELECT @WalletId = WalletId FROM Wallets WHERE UserId = @UserId; IF @WalletId IS NULL BEGIN SET @Success = 0; SET @Message = 'Wallet not found'; ROLLBACK TRANSACTION; RETURN; END SELECT @Balance = Balance FROM Wallets WHERE WalletId = @WalletId; IF @Balance < @Amount BEGIN SET @Success = 0; SET @Message = 'Insufficient balance'; ROLLBACK TRANSACTION; RETURN; END UPDATE Wallets SET Balance = Balance - @Amount WHERE WalletId = @WalletId; INSERT INTO Transactions (WalletId, Amount, Type, Reference, Meta, CreatedAt) VALUES(@WalletId, @Amount, 'debit', @Reference, @Meta, GETDATE()); COMMIT TRANSACTION; SET @Success = 1; SET @Message = 'Withdrawal successful'; END TRY BEGIN CATCH IF @@TRANCOUNT > 0 ROLLBACK TRANSACTION; SET @Success = 0; SET @Message = ERROR_MESSAGE(); END CATCH END GO -- Stored procedure: Get balance and wallet id IF OBJECT_ID('sp_GetWallet') IS NOT NULL DROP PROCEDURE sp_GetWallet; GO CREATE PROCEDURE sp_GetWallet @UserId INT AS BEGIN SET NOCOUNT ON; SELECT w.WalletId, w.Balance FROM Wallets w WHERE w.UserId = @UserId; END GO -- Stored procedure: Get transactions for user IF OBJECT_ID('sp_GetTransactions') IS NOT NULL DROP PROCEDURE sp_GetTransactions; GO CREATE PROCEDURE sp_GetTransactions @UserId INT AS BEGIN SET NOCOUNT ON; SELECT t.TransactionId, t.Amount, t.Type, t.Reference, t.Meta, t.CreatedAt FROM Transactions t INNER JOIN Wallets w ON t.WalletId = w.WalletId WHERE w.UserId = @UserId ORDER BY t.CreatedAt DESC; END GO const sql = require('mssql'); const dotenv = require('dotenv'); dotenv.config(); const config = { user: process.env.MSSQL_USER, password: process.env.MSSQL_PASSWORD, server: process.env.MSSQL_SERVER, database: process.env.MSSQL_DATABASE, port: parseInt(process.env.MSSQL_PORT || '1433', 10), options: { encrypt: false, trustServerCertificate: process.env.MSSQL_TRUST_SERVER_CERT === 'true' }, pool: { max: 10, min: 0, idleTimeoutMillis: 30000 } }; const poolPromise = new sql.ConnectionPool(config) .connect() .then(pool => { console.log('Connected to MSSQL'); return pool; }) .catch(err => { console.error('MSSQL Connection Error: ', err); throw err; }); module.exports = { sql, poolPromise }; const express = require('express'); const router = express.Router(); const { poolPromise, sql } = require('../db'); // Get wallet balance router.get('/balance/:userId', async (req, res) => { try { const pool = await poolPromise; const result = await pool.request() .input('UserId', sql.Int, parseInt(req.params.userId, 10)) .execute('sp_GetWallet'); const recordset = result.recordset && result.recordset[0]; if (!recordset) return res.json({ walletId: null, balance: 0 }); res.json({ walletId: recordset.WalletId, balance: parseFloat(recordset.Balance) }); } catch (err) { res.status(500).json({ error: err.message }); } }); // Get transactions router.get('/transactions/:userId', async (req, res) => { try { const pool = await poolPromise; const result = await pool.request() .input('UserId', sql.Int, parseInt(req.params.userId, 10)) .execute('sp_GetTransactions'); res.json({ transactions: result.recordset || [] }); } catch (err) { res.status(500).json({ error: err.message }); } }); // Add funds (this endpoint expects verification from payment gateway) router.post('/add', async (req, res) => { try { const { userId, amount, reference } = req.body; const pool = await poolPromise; const request = pool.request() .input('UserId', sql.Int, userId) .input('Amount', sql.Decimal(18,2), amount) .input('Reference', sql.NVarChar(200), reference || null) .output('Success', sql.Bit) .output('Message', sql.NVarChar(255)); await request.execute('sp_AddFunds'); const success = request.parameters.Success.value; const message = request.parameters.Message.value; res.json({ success: !!success, message }); } catch (err) { res.status(500).json({ error: err.message }); } }); // Withdraw funds router.post('/withdraw', async (req, res) => { try { const { userId, amount, reference, meta } = req.body; const pool = await poolPromise; const request = pool.request() .input('UserId', sql.Int, userId) .input('Amount', sql.Decimal(18,2), amount) .input('Reference', sql.NVarChar(200), reference || null) .input('Meta', sql.NVarChar(500), meta || null) .output('Success', sql.Bit) .output('Message', sql.NVarChar(255)); await request.execute('sp_WithdrawFunds'); const success = request.parameters.Success.value; const message = request.parameters.Message.value; res.json({ success: !!success, message }); } catch (err) { res.status(500).json({ error: err.message }); } }); module.exports = router; const express = require('express'); const router = express.Router(); const { v4: uuidv4 } = require('uuid'); const { poolPromise, sql } = require('../db'); const dotenv = require('dotenv'); dotenv.config(); // Initiate UPI payment - generate UPI deep link router.post('/initiate', async (req, res) => { try { const { userId, amount } = req.body; if (!userId || !amount) return res.status(400).json({ error: 'userId and amount required' }); // In a real integration you'd call the payment gateway here. const reference = 'TXN-' + uuidv4(); const pa = encodeURIComponent(process.env.MERCHANT_UPI || 'merchant@bank'); const pn = encodeURIComponent(process.env.MERCHANT_NAME || 'Merchant'); const tn = encodeURIComponent('Add funds: ' + reference); const am = encodeURIComponent(parseFloat(amount).toFixed(2)); const upiLink = `upi://pay?pa=${pa}&pn=${pn}&am=${am}&cu=INR&tn=${tn}`; // Return the UPI link and a reference. Frontend can open this link in UPI apps. res.json({ upiLink, reference, message: 'Open this link with a UPI app to complete payment' }); } catch (err) { res.status(500).json({ error: err.message }); } }); // Verify payment (mock). In production this is a webhook from payment provider router.post('/verify', async (req, res) => { try { const { userId, amount, reference } = req.body; if (!userId || !amount || !reference) return res.status(400).json({ error: 'userId, amount, reference required' }); // For demo: call stored procedure to add funds const pool = await poolPromise; const request = pool.request() .input('UserId', sql.Int, userId) .input('Amount', sql.Decimal(18,2), amount) .input('Reference', sql.NVarChar(200), reference) .output('Success', sql.Bit) .output('Message', sql.NVarChar(255)); await request.execute('sp_AddFunds'); const success = request.parameters.Success.value; const message = request.parameters.Message.value; res.json({ success: !!success, message }); } catch (err) { res.status(500).json({ error: err.message }); } }); module.exports = router; const express = require('express'); const dotenv = require('dotenv'); const cors = require('cors'); const path = require('path'); dotenv.config(); const app = express(); app.use(cors()); app.use(express.json()); app.use(express.urlencoded({ extended: true })); const walletRoutes = require('./routes/wallet'); const paymentRoutes = require('./routes/payment'); app.use('/api/wallet', walletRoutes); app.use('/api/payment', paymentRoutes); // Serve static frontend app.use(express.static(path.join(__dirname, '..', 'public'))); const PORT = process.env.PORT || 4000; app.listen(PORT, () => { console.log(`Server running on port ${PORT}`); }); Tiranga Color Trading

Wallet

Balance

₹0.00

Add Funds

Withdraw

Recent Transactions

:root{ --saffron:#ff9933; --green:#138808; --deep:#0b3d91; --muted:#f6f6f6; --card:#ffffff; --accent: #0b72b9; --danger:#d9534f; } *{box-sizing:border-box;font-family:Inter,ui-sans-serif,system-ui,-apple-system,Segoe UI,Roboto,"Helvetica Neue",Arial;} body{margin:0;background:linear-gradient(180deg,var(--muted),#ffffff);color:#222;min-height:100vh;display:flex;flex-direction:column;} .topbar{display:flex;justify-content:space-between;align-items:center;padding:14px 20px;background:linear-gradient(90deg,var(--saffron),#ffffff,var(--green));box-shadow:0 2px 8px rgba(0,0,0,0.08);} .brand{display:flex;align-items:center;gap:12px;} .flag{display:flex;flex-direction:column;height:36px;width:48px;border-radius:6px;overflow:hidden;border:2px solid rgba(0,0,0,0.06);} .flag span{flex:1;display:block} .saffron{background:var(--saffron)} .white{background:#fff} .green{background:var(--green)} h1{font-size:18px;margin:0;color:var(--deep);text-shadow:0 1px 0 rgba(255,255,255,0.6);} .user-info{font-weight:600;color:#fff} .container{flex:1;display:flex;align-items:flex-start;justify-content:center;padding:28px;} .wallet-card{width:100%;max-width:980px;background:var(--card);border-radius:12px;padding:20px;box-shadow:0 6px 24px rgba(16,24,40,0.08);} .balance-row{display:flex;justify-content:space-between;align-items:center;border-bottom:1px solid #f0f0f0;padding-bottom:14px;margin-bottom:18px;} .label{font-size:13px;color:#666} .amount{font-size:28px;font-weight:700;color:var(--deep);margin-top:6px} .forms{display:flex;gap:18px;flex-wrap:wrap;margin-bottom:18px} .card{padding:12px;border-radius:8px;background:linear-gradient(180deg,#fff,#fafafa);flex:1;min-width:260px} .form-card input{width:100%;padding:10px;border-radius:8px;border:1px solid #e6e6e6;margin:8px 0} .row{display:flex;gap:10px;align-items:center} .btn{cursor:pointer;padding:10px 14px;border-radius:8px;border:none;font-weight:600} .btn.primary{background:var(--accent);color:#fff} .btn.accent{background:#06a77d;color:#fff} .btn.danger{background:var(--danger);color:#fff} .btn.outline{background:transparent;color:#333;border:1px solid rgba(0,0,0,0.06)} .info{margin-top:8px;color:#444;font-size:14px} .transactions h3{margin:10px 0} .tx-list{list-style:none;padding:0;margin:0;display:grid;gap:8px} .tx-item{display:flex;justify-content:space-between;align-items:center;padding:10px;border-radius:8px;border:1px solid #f0f0f0;background:#fff} .tx-item .meta{font-size:13px;color:#666} .tx-item .amt.credit{color:green;font-weight:700} .tx-item .amt.debit{color:var(--danger);font-weight:700} .footer{text-align:center;padding:14px;color:#666;font-size:13px} @media (max-width:760px){ .forms{flex-direction:column} .balance-row{flex-direction:column;align-items:flex-start;gap:10px} } const API_BASE = ''; // Demo user id (seeded in SQL script) const DEMO_USER_ID = 1; const balanceEl = document.getElementById('balance'); const refreshBtn = document.getElementById('refreshBtn'); const transactionsList = document.getElementById('transactionsList'); const initiatePaymentBtn = document.getElementById('initiatePayment'); const addAmountInput = document.getElementById('addAmount'); const upiInfo = document.getElementById('upiInfo'); const mockConfirm = document.getElementById('mockConfirm'); const withdrawBtn = document.getElementById('withdrawBtn'); const withdrawAmountInput = document.getElementById('withdrawAmount'); const withdrawMetaInput = document.getElementById('withdrawMeta'); const withdrawMsg = document.getElementById('withdrawMsg'); async function fetchBalance() { try { const res = await fetch(`${API_BASE}/api/wallet/balance/${DEMO_USER_ID}`); const data = await res.json(); balanceEl.textContent = '₹' + parseFloat(data.balance || 0).toFixed(2); } catch (err) { console.error(err); } } async function fetchTransactions() { try { const res = await fetch(`${API_BASE}/api/wallet/transactions/${DEMO_USER_ID}`); const data = await res.json(); transactionsList.innerHTML = ''; (data.transactions || []).forEach(tx => { const li = document.createElement('li'); li.className = 'tx-item'; const left = document.createElement('div'); left.innerHTML = `

${tx.Reference || ''}

${new Date(tx.CreatedAt).toLocaleString()}

`; const right = document.createElement('div'); right.className = 'amt ' + (tx.Type === 'credit' ? 'credit' : 'debit'); right.textContent = (tx.Type === 'credit' ? '+ ' : '- ') + '₹' + parseFloat(tx.Amount).toFixed(2); li.appendChild(left); li.appendChild(right); transactionsList.appendChild(li); }); } catch (err) { console.error(err); } } refreshBtn.addEventListener('click', () => { fetchBalance(); fetchTransactions(); }); initiatePaymentBtn.addEventListener('click', async () => { const amount = parseFloat(addAmountInput.value); if (!amount || amount < 100) { upiInfo.textContent = 'Minimum add amount is ₹100'; return; } upiInfo.textContent = 'Generating UPI link...'; try { const res = await fetch(`${API_BASE}/api/payment/initiate`, { method: 'POST', headers: {'Content-Type': 'application/json'}, body: JSON.stringify({ userId: DEMO_USER_ID, amount }) }); const data = await res.json(); if (data.upiLink) { upiInfo.innerHTML = `Open this link in your UPI app: ${data.upiLink}
Reference: ${data.reference}`; // Show simulate confirm button for demo purposes mockConfirm.style.display = 'inline-block'; mockConfirm.dataset.amount = amount; mockConfirm.dataset.reference = data.reference; } else { upiInfo.textContent = data.message || 'Could not generate link'; } } catch (err) { upiInfo.textContent = 'Error initiating payment'; } }); mockConfirm.addEventListener('click', async () => { const amount = parseFloat(mockConfirm.dataset.amount); const reference = mockConfirm.dataset.reference; upiInfo.textContent = 'Simulating payment verification...'; try { const res = await fetch(`${API_BASE}/api/payment/verify`, { method: 'POST', headers: {'Content-Type': 'application/json'}, body: JSON.stringify({ userId: DEMO_USER_ID, amount, reference }) }); const data = await res.json(); upiInfo.textContent = data.message || 'Verified'; mockConfirm.style.display = 'none'; fetchBalance(); fetchTransactions(); } catch (err) { upiInfo.textContent = 'Verification failed'; } }); withdrawBtn.addEventListener('click', async () => { const amount = parseFloat(withdrawAmountInput.value); const meta = withdrawMetaInput.value || ''; withdrawMsg.textContent = ''; if (!amount || amount < 300) { withdrawMsg.textContent = 'Minimum withdrawal amount is ₹300'; return; } withdrawMsg.textContent = 'Processing withdrawal...'; try { const res = await fetch(`${API_BASE}/api/wallet/withdraw`, { method: 'POST', headers: {'Content-Type': 'application/json'}, body: JSON.stringify({ userId: DEMO_USER_ID, amount, meta }) }); const data = await res.json(); if (data.success) { withdrawMsg.textContent = data.message; withdrawAmountInput.value = ''; withdrawMetaInput.value = ''; fetchBalance(); fetchTransactions(); } else { withdrawMsg.textContent = data.message || 'Withdrawal failed'; } } catch (err) { withdrawMsg.textContent = 'Error'; } }); // initial load fetchBalance(); fetchTransactions();