All files / models Portfolio.js

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
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
const { DataTypes } = require('sequelize');
const sequelize = require('../config/database');
 
const Portfolio = sequelize.define('Portfolio', {
  id: {
    type: DataTypes.UUID,
    defaultValue: DataTypes.UUIDV4,
    primaryKey: true
  },
  userId: {
    type: DataTypes.UUID,
    allowNull: false,
    references: {
      model: 'users',
      key: 'id'
    }
  },
  totalDeposited: {
    type: DataTypes.DECIMAL(20, 8),
    defaultValue: 0,
    allowNull: false
  },
  totalWithdrawn: {
    type: DataTypes.DECIMAL(20, 8),
    defaultValue: 0,
    allowNull: false
  },
  currentValue: {
    type: DataTypes.DECIMAL(20, 8),
    defaultValue: 0,
    allowNull: false
  },
  totalProfits: {
    type: DataTypes.DECIMAL(20, 8),
    defaultValue: 0,
    allowNull: false
  },
  totalLosses: {
    type: DataTypes.DECIMAL(20, 8),
    defaultValue: 0,
    allowNull: false
  },
  totalFeesPaid: {
    type: DataTypes.DECIMAL(20, 8),
    defaultValue: 0,
    allowNull: false
  },
  performanceFeesPaid: {
    type: DataTypes.DECIMAL(20, 8),
    defaultValue: 0,
    allowNull: false
  },
  managementFeesPaid: {
    type: DataTypes.DECIMAL(20, 8),
    defaultValue: 0,
    allowNull: false
  },
  lastManagementFeeDate: {
    type: DataTypes.DATE,
    allowNull: true
  },
  activeStrategies: {
    type: DataTypes.ARRAY(DataTypes.STRING),
    defaultValue: []
  },
  holdings: {
    type: DataTypes.JSONB,
    defaultValue: {}
  },
  historicalData: {
    type: DataTypes.JSONB,
    defaultValue: {
      daily: [],
      weekly: [],
      monthly: []
    }
  },
  riskScore: {
    type: DataTypes.DECIMAL(5, 2),
    defaultValue: 50.00
  },
  isActive: {
    type: DataTypes.BOOLEAN,
    defaultValue: true
  },
  metadata: {
    type: DataTypes.JSONB,
    defaultValue: {}
  }
}, {
  tableName: 'portfolios',
  timestamps: true,
  indexes: [
    { fields: ['userId'] },
    { fields: ['isActive'] }
  ]
});
 
// Instance methods
Portfolio.prototype.calculateROI = function() {
  if (parseFloat(this.totalDeposited) === 0) return 0;
  const netProfit = parseFloat(this.totalProfits) - parseFloat(this.totalLosses);
  return (netProfit / parseFloat(this.totalDeposited)) * 100;
};
 
Portfolio.prototype.calculateNetValue = function() {
  return parseFloat(this.currentValue) - parseFloat(this.totalFeesPaid);
};
 
module.exports = Portfolio;