99 lines
2.1 KiB
JavaScript
99 lines
2.1 KiB
JavaScript
/**
|
||
* 贷款合同模型
|
||
* @file LoanContract.js
|
||
* @description 银行系统贷款合同数据模型
|
||
*/
|
||
const { DataTypes } = require('sequelize');
|
||
const BaseModel = require('./BaseModel');
|
||
|
||
class LoanContract extends BaseModel {
|
||
/**
|
||
* 获取合同状态文本
|
||
* @returns {String} 状态文本
|
||
*/
|
||
getStatusText() {
|
||
const statusMap = {
|
||
active: '已放款',
|
||
completed: '已完成',
|
||
defaulted: '违约',
|
||
cancelled: '已取消'
|
||
};
|
||
return statusMap[this.status] || this.status;
|
||
}
|
||
|
||
/**
|
||
* 格式化合同金额
|
||
* @returns {String} 格式化后的金额
|
||
*/
|
||
getFormattedAmount() {
|
||
return `${this.loan_amount.toFixed(2)}元`;
|
||
}
|
||
}
|
||
|
||
// 初始化LoanContract模型
|
||
LoanContract.init({
|
||
id: {
|
||
type: DataTypes.INTEGER,
|
||
primaryKey: true,
|
||
autoIncrement: true
|
||
},
|
||
contract_number: {
|
||
type: DataTypes.STRING(50),
|
||
allowNull: false,
|
||
unique: true,
|
||
comment: '合同编号'
|
||
},
|
||
customer_name: {
|
||
type: DataTypes.STRING(100),
|
||
allowNull: false,
|
||
comment: '客户姓名'
|
||
},
|
||
customer_phone: {
|
||
type: DataTypes.STRING(20),
|
||
allowNull: false,
|
||
comment: '客户电话'
|
||
},
|
||
customer_id_card: {
|
||
type: DataTypes.STRING(18),
|
||
allowNull: false,
|
||
comment: '客户身份证号'
|
||
},
|
||
loan_amount: {
|
||
type: DataTypes.DECIMAL(15, 2),
|
||
allowNull: false,
|
||
comment: '贷款金额'
|
||
},
|
||
loan_term: {
|
||
type: DataTypes.INTEGER,
|
||
allowNull: false,
|
||
comment: '贷款期限（月）'
|
||
},
|
||
interest_rate: {
|
||
type: DataTypes.DECIMAL(5, 2),
|
||
allowNull: false,
|
||
comment: '贷款利率（%）'
|
||
},
|
||
contract_date: {
|
||
type: DataTypes.DATEONLY,
|
||
allowNull: false,
|
||
comment: '合同签订日期'
|
||
},
|
||
status: {
|
||
type: DataTypes.ENUM('active', 'completed', 'defaulted', 'cancelled'),
|
||
allowNull: true,
|
||
defaultValue: 'active',
|
||
comment: '合同状态'
|
||
}
|
||
}, {
|
||
sequelize: require('../config/database').sequelize,
|
||
modelName: 'LoanContract',
|
||
tableName: 'loan_contracts',
|
||
timestamps: true,
|
||
underscored: true,
|
||
createdAt: 'created_at',
|
||
updatedAt: 'updated_at',
|
||
// 移除不存在的字段
|
||
omitNull: true
|
||
});
|
||
|
||
module.exports = LoanContract; |