File size: 1,492 Bytes
1d3aceb
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
0ba1efd
 
1d3aceb
0ba1efd
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1d3aceb
 
0ba1efd
1d3aceb
 
 
 
 
 
 
 
 
 
0ba1efd
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
import mongoose from 'mongoose';

const transactionSchema = new mongoose.Schema({
    user: {
        type: mongoose.Schema.Types.ObjectId,
        ref: 'User',
        required: true
    },
    amount: {
        type: Number,
        required: true
    },
    currency: {
        type: String,
        default: 'TZS'
    },
    creditsPurchased: {
        type: Number,
        required: true
    },
    providerReference: String,  // ID from ClickPesa (auto payments)
    reference: String,           // Our internal short ref
    phoneNumber: String,
    // Payment method tracking
    paymentMethod: {
        type: String,
        enum: ['auto', 'mpesa_manual'],
        default: 'auto'
    },
    // M-Pesa manual payment fields
    mpesaProof: String,          // Storage key of screenshot OR typed transaction code
    mpesaProofType: {
        type: String,
        enum: ['screenshot', 'code'],
        default: 'code'
    },
    mpesaNumber: String,         // The M-Pesa number used
    reviewNote: String,          // Admin note on approval/rejection
    reviewedBy: String,          // Admin email who reviewed
    reviewedAt: Date,
    status: {
        type: String,
        enum: ['pending', 'pending_review', 'completed', 'failed', 'rejected', 'SUCCESS', 'SETTLED'],
        default: 'pending'
    },
    createdAt: {
        type: Date,
        default: Date.now
    }
});

const Transaction = mongoose.model('Transaction', transactionSchema);
export default Transaction;