Spaces:
Sleeping
Sleeping
| import { randomUUID } from 'crypto'; | |
| import { DataTypes } from 'sequelize'; | |
| import { sequelize } from '../db.js'; | |
| import { enumField, ContractStatus, PaymentStatus } from '../utils/enums.js'; | |
| export const EMIContract = sequelize.define( | |
| 'EMIContract', | |
| { | |
| id: { type: DataTypes.STRING(36), primaryKey: true, defaultValue: randomUUID }, | |
| contract_number: { type: DataTypes.STRING(50), allowNull: false, unique: true }, | |
| customer_id: { type: DataTypes.STRING(36), allowNull: false }, | |
| device_id: { type: DataTypes.STRING(36), allowNull: false }, | |
| product_name: { type: DataTypes.STRING(255) }, | |
| product_price: { type: DataTypes.DECIMAL(12, 2), allowNull: false }, | |
| down_payment: { type: DataTypes.DECIMAL(12, 2), defaultValue: 0 }, | |
| principal_amount: { type: DataTypes.DECIMAL(12, 2), allowNull: false }, | |
| interest_rate: { type: DataTypes.DECIMAL(5, 2), defaultValue: 0 }, | |
| tenure_months: { type: DataTypes.INTEGER, allowNull: false }, | |
| emi_amount: { type: DataTypes.DECIMAL(10, 2), allowNull: false }, | |
| total_amount: { type: DataTypes.DECIMAL(12, 2), allowNull: false }, | |
| start_date: { type: DataTypes.DATEONLY, allowNull: false }, | |
| end_date: { type: DataTypes.DATEONLY, allowNull: false }, | |
| emi_due_day: { type: DataTypes.INTEGER, defaultValue: 1 }, | |
| status: enumField({ field: 'status', defaultValue: 'active' }), | |
| grace_period_days: { type: DataTypes.INTEGER, defaultValue: 7 }, | |
| total_paid: { type: DataTypes.DECIMAL(12, 2), defaultValue: 0 }, | |
| emis_paid: { type: DataTypes.INTEGER, defaultValue: 0 }, | |
| notes: { type: DataTypes.TEXT }, | |
| created_at: { type: DataTypes.DATE, defaultValue: DataTypes.NOW }, | |
| updated_at: { type: DataTypes.DATE, defaultValue: DataTypes.NOW }, | |
| created_by: { type: DataTypes.STRING(36) }, | |
| }, | |
| { tableName: 'emi_contracts', timestamps: false }, | |
| ); | |
| export const EMIPayment = sequelize.define( | |
| 'EMIPayment', | |
| { | |
| id: { type: DataTypes.STRING(36), primaryKey: true, defaultValue: randomUUID }, | |
| contract_id: { type: DataTypes.STRING(36), allowNull: false }, | |
| installment_number: { type: DataTypes.INTEGER, allowNull: false }, | |
| due_amount: { type: DataTypes.DECIMAL(10, 2), allowNull: false }, | |
| paid_amount: { type: DataTypes.DECIMAL(10, 2), defaultValue: 0 }, | |
| late_fee: { type: DataTypes.DECIMAL(10, 2), defaultValue: 0 }, | |
| due_date: { type: DataTypes.DATEONLY, allowNull: false }, | |
| paid_date: { type: DataTypes.DATE }, | |
| status: enumField({ field: 'status', defaultValue: 'pending' }), | |
| payment_method: { type: DataTypes.STRING(50) }, | |
| payment_reference: { type: DataTypes.STRING(100) }, | |
| created_at: { type: DataTypes.DATE, defaultValue: DataTypes.NOW }, | |
| updated_at: { type: DataTypes.DATE, defaultValue: DataTypes.NOW }, | |
| recorded_by: { type: DataTypes.STRING(36) }, | |
| }, | |
| { tableName: 'emi_payments', timestamps: false }, | |
| ); | |
| export { ContractStatus, PaymentStatus }; | |
| export default EMIContract; | |