290 lines
9.7 KiB
JavaScript
290 lines
9.7 KiB
JavaScript
|
/**
|
|||
|
|
* 贷款合同测试数据脚本
|
|||
|
|
* @file seed-loan-contracts.js
|
|||
|
|
* @description 为银行系统添加贷款合同测试数据
|
|||
|
|
*/
|
|||
|
|
const { sequelize, LoanContract, User } = require('../models');
|
|||
|
|
|
|||
|
|
async function seedLoanContracts() {
|
|||
|
|
try {
|
|||
|
|
console.log('开始添加贷款合同测试数据...');
|
|||
|
|
|
|||
|
|
// 获取admin用户（作为创建人）
|
|||
|
|
const adminUser = await User.findOne({ where: { username: 'admin' } });
|
|||
|
|
if (!adminUser) {
|
|||
|
|
console.log('❌ 未找到admin用户，请先创建用户');
|
|||
|
|
return;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
// 清空现有数据
|
|||
|
|
await LoanContract.destroy({ where: {} });
|
|||
|
|
console.log('✅ 清空现有贷款合同数据');
|
|||
|
|
|
|||
|
|
// 创建贷款合同测试数据（参考图片中的数据结构）
|
|||
|
|
const contracts = [
|
|||
|
|
{
|
|||
|
|
contractNumber: 'HT20231131123456789',
|
|||
|
|
applicationNumber: '20231131123456789',
|
|||
|
|
productName: '中国农业银行扎旗支行"畜禽活体抵押"',
|
|||
|
|
farmerName: '敖日布仁琴',
|
|||
|
|
borrowerName: '敖日布仁琴',
|
|||
|
|
borrowerIdNumber: '150***********4856',
|
|||
|
|
assetType: '牛',
|
|||
|
|
applicationQuantity: '36头',
|
|||
|
|
amount: 500000.00,
|
|||
|
|
paidAmount: 0,
|
|||
|
|
status: 'active',
|
|||
|
|
type: 'livestock_collateral',
|
|||
|
|
term: 24,
|
|||
|
|
interestRate: 4.20,
|
|||
|
|
phone: '13800138000',
|
|||
|
|
purpose: '养殖贷款',
|
|||
|
|
remark: '畜禽活体抵押贷款',
|
|||
|
|
contractTime: new Date('2023-11-31 12:34:56'),
|
|||
|
|
disbursementTime: new Date('2023-12-01 10:00:00'),
|
|||
|
|
maturityTime: new Date('2025-12-01 10:00:00'),
|
|||
|
|
createdBy: adminUser.id
|
|||
|
|
},
|
|||
|
|
{
|
|||
|
|
contractNumber: 'HT20231201123456790',
|
|||
|
|
applicationNumber: '20231201123456790',
|
|||
|
|
productName: '中国工商银行扎旗支行"畜禽活体抵押"',
|
|||
|
|
farmerName: '张伟',
|
|||
|
|
borrowerName: '张伟',
|
|||
|
|
borrowerIdNumber: '150***********4857',
|
|||
|
|
assetType: '牛',
|
|||
|
|
applicationQuantity: '25头',
|
|||
|
|
amount: 350000.00,
|
|||
|
|
paidAmount: 50000.00,
|
|||
|
|
status: 'active',
|
|||
|
|
type: 'livestock_collateral',
|
|||
|
|
term: 18,
|
|||
|
|
interestRate: 4.50,
|
|||
|
|
phone: '13900139000',
|
|||
|
|
purpose: '扩大养殖规模',
|
|||
|
|
remark: '工商银行畜禽活体抵押',
|
|||
|
|
contractTime: new Date('2023-12-01 14:20:30'),
|
|||
|
|
disbursementTime: new Date('2023-12-02 09:30:00'),
|
|||
|
|
maturityTime: new Date('2025-06-02 09:30:00'),
|
|||
|
|
createdBy: adminUser.id
|
|||
|
|
},
|
|||
|
|
{
|
|||
|
|
contractNumber: 'HT20231202123456791',
|
|||
|
|
applicationNumber: '20231202123456791',
|
|||
|
|
productName: '惠农贷',
|
|||
|
|
farmerName: '李明',
|
|||
|
|
borrowerName: '李明',
|
|||
|
|
borrowerIdNumber: '150***********4858',
|
|||
|
|
assetType: '牛',
|
|||
|
|
applicationQuantity: '20头',
|
|||
|
|
amount: 280000.00,
|
|||
|
|
paidAmount: 0,
|
|||
|
|
status: 'pending',
|
|||
|
|
type: 'farmer_loan',
|
|||
|
|
term: 12,
|
|||
|
|
interestRate: 3.90,
|
|||
|
|
phone: '13700137000',
|
|||
|
|
purpose: '惠农贷款',
|
|||
|
|
remark: '惠农贷产品',
|
|||
|
|
contractTime: new Date('2023-12-02 16:45:12'),
|
|||
|
|
createdBy: adminUser.id
|
|||
|
|
},
|
|||
|
|
{
|
|||
|
|
contractNumber: 'HT20231203123456792',
|
|||
|
|
applicationNumber: '20231203123456792',
|
|||
|
|
productName: '中国农业银行扎旗支行"畜禽活体抵押"',
|
|||
|
|
farmerName: '王强',
|
|||
|
|
borrowerName: '王强',
|
|||
|
|
borrowerIdNumber: '150***********4859',
|
|||
|
|
assetType: '牛',
|
|||
|
|
applicationQuantity: '30头',
|
|||
|
|
amount: 420000.00,
|
|||
|
|
paidAmount: 420000.00,
|
|||
|
|
status: 'completed',
|
|||
|
|
type: 'livestock_collateral',
|
|||
|
|
term: 24,
|
|||
|
|
interestRate: 4.20,
|
|||
|
|
phone: '13600136000',
|
|||
|
|
purpose: '养殖贷款',
|
|||
|
|
remark: '已完成还款',
|
|||
|
|
contractTime: new Date('2023-12-03 11:20:45'),
|
|||
|
|
disbursementTime: new Date('2023-12-04 08:00:00'),
|
|||
|
|
maturityTime: new Date('2025-12-04 08:00:00'),
|
|||
|
|
completedTime: new Date('2024-11-15 14:30:00'),
|
|||
|
|
createdBy: adminUser.id
|
|||
|
|
},
|
|||
|
|
{
|
|||
|
|
contractNumber: 'HT20231204123456793',
|
|||
|
|
applicationNumber: '20231204123456793',
|
|||
|
|
productName: '中国工商银行扎旗支行"畜禽活体抵押"',
|
|||
|
|
farmerName: '赵敏',
|
|||
|
|
borrowerName: '赵敏',
|
|||
|
|
borrowerIdNumber: '150***********4860',
|
|||
|
|
assetType: '牛',
|
|||
|
|
applicationQuantity: '15头',
|
|||
|
|
amount: 200000.00,
|
|||
|
|
paidAmount: 0,
|
|||
|
|
status: 'defaulted',
|
|||
|
|
type: 'livestock_collateral',
|
|||
|
|
term: 18,
|
|||
|
|
interestRate: 4.50,
|
|||
|
|
phone: '13500135000',
|
|||
|
|
purpose: '养殖贷款',
|
|||
|
|
remark: '违约状态',
|
|||
|
|
contractTime: new Date('2023-12-04 13:15:30'),
|
|||
|
|
disbursementTime: new Date('2023-12-05 10:00:00'),
|
|||
|
|
maturityTime: new Date('2025-06-05 10:00:00'),
|
|||
|
|
createdBy: adminUser.id
|
|||
|
|
},
|
|||
|
|
{
|
|||
|
|
contractNumber: 'HT20231205123456794',
|
|||
|
|
applicationNumber: '20231205123456794',
|
|||
|
|
productName: '惠农贷',
|
|||
|
|
farmerName: '刘超',
|
|||
|
|
borrowerName: '刘超',
|
|||
|
|
borrowerIdNumber: '150***********4861',
|
|||
|
|
assetType: '牛',
|
|||
|
|
applicationQuantity: '22头',
|
|||
|
|
amount: 320000.00,
|
|||
|
|
paidAmount: 80000.00,
|
|||
|
|
status: 'active',
|
|||
|
|
type: 'farmer_loan',
|
|||
|
|
term: 24,
|
|||
|
|
interestRate: 3.90,
|
|||
|
|
phone: '13400134000',
|
|||
|
|
purpose: '惠农贷款',
|
|||
|
|
remark: '惠农贷产品',
|
|||
|
|
contractTime: new Date('2023-12-05 15:30:20'),
|
|||
|
|
disbursementTime: new Date('2023-12-06 09:00:00'),
|
|||
|
|
maturityTime: new Date('2025-12-06 09:00:00'),
|
|||
|
|
createdBy: adminUser.id
|
|||
|
|
},
|
|||
|
|
{
|
|||
|
|
contractNumber: 'HT20231206123456795',
|
|||
|
|
applicationNumber: '20231206123456795',
|
|||
|
|
productName: '中国农业银行扎旗支行"畜禽活体抵押"',
|
|||
|
|
farmerName: '陈华',
|
|||
|
|
borrowerName: '陈华',
|
|||
|
|
borrowerIdNumber: '150***********4862',
|
|||
|
|
assetType: '牛',
|
|||
|
|
applicationQuantity: '28头',
|
|||
|
|
amount: 380000.00,
|
|||
|
|
paidAmount: 0,
|
|||
|
|
status: 'active',
|
|||
|
|
type: 'livestock_collateral',
|
|||
|
|
term: 30,
|
|||
|
|
interestRate: 4.20,
|
|||
|
|
phone: '13300133000',
|
|||
|
|
purpose: '养殖贷款',
|
|||
|
|
remark: '长期贷款',
|
|||
|
|
contractTime: new Date('2023-12-06 10:45:15'),
|
|||
|
|
disbursementTime: new Date('2023-12-07 11:00:00'),
|
|||
|
|
maturityTime: new Date('2026-06-07 11:00:00'),
|
|||
|
|
createdBy: adminUser.id
|
|||
|
|
},
|
|||
|
|
{
|
|||
|
|
contractNumber: 'HT20231207123456796',
|
|||
|
|
applicationNumber: '20231207123456796',
|
|||
|
|
productName: '中国工商银行扎旗支行"畜禽活体抵押"',
|
|||
|
|
farmerName: '孙丽',
|
|||
|
|
borrowerName: '孙丽',
|
|||
|
|
borrowerIdNumber: '150***********4863',
|
|||
|
|
assetType: '牛',
|
|||
|
|
applicationQuantity: '18头',
|
|||
|
|
amount: 250000.00,
|
|||
|
|
paidAmount: 250000.00,
|
|||
|
|
status: 'completed',
|
|||
|
|
type: 'livestock_collateral',
|
|||
|
|
term: 12,
|
|||
|
|
interestRate: 4.50,
|
|||
|
|
phone: '13200132000',
|
|||
|
|
purpose: '养殖贷款',
|
|||
|
|
remark: '短期贷款已完成',
|
|||
|
|
contractTime: new Date('2023-12-07 14:20:10'),
|
|||
|
|
disbursementTime: new Date('2023-12-08 08:30:00'),
|
|||
|
|
maturityTime: new Date('2024-12-08 08:30:00'),
|
|||
|
|
completedTime: new Date('2024-10-15 16:45:00'),
|
|||
|
|
createdBy: adminUser.id
|
|||
|
|
},
|
|||
|
|
{
|
|||
|
|
contractNumber: 'HT20231208123456797',
|
|||
|
|
applicationNumber: '20231208123456797',
|
|||
|
|
productName: '惠农贷',
|
|||
|
|
farmerName: '周杰',
|
|||
|
|
borrowerName: '周杰',
|
|||
|
|
borrowerIdNumber: '150***********4864',
|
|||
|
|
assetType: '牛',
|
|||
|
|
applicationQuantity: '24头',
|
|||
|
|
amount: 360000.00,
|
|||
|
|
paidAmount: 0,
|
|||
|
|
status: 'cancelled',
|
|||
|
|
type: 'farmer_loan',
|
|||
|
|
term: 18,
|
|||
|
|
interestRate: 3.90,
|
|||
|
|
phone: '13100131000',
|
|||
|
|
purpose: '惠农贷款',
|
|||
|
|
remark: '已取消',
|
|||
|
|
contractTime: new Date('2023-12-08 16:10:25'),
|
|||
|
|
createdBy: adminUser.id
|
|||
|
|
},
|
|||
|
|
{
|
|||
|
|
contractNumber: 'HT20231209123456798',
|
|||
|
|
applicationNumber: '20231209123456798',
|
|||
|
|
productName: '中国农业银行扎旗支行"畜禽活体抵押"',
|
|||
|
|
farmerName: '吴刚',
|
|||
|
|
borrowerName: '吴刚',
|
|||
|
|
borrowerIdNumber: '150***********4865',
|
|||
|
|
assetType: '牛',
|
|||
|
|
applicationQuantity: '32头',
|
|||
|
|
amount: 450000.00,
|
|||
|
|
paidAmount: 150000.00,
|
|||
|
|
status: 'active',
|
|||
|
|
type: 'livestock_collateral',
|
|||
|
|
term: 36,
|
|||
|
|
interestRate: 4.20,
|
|||
|
|
phone: '13000130000',
|
|||
|
|
purpose: '养殖贷款',
|
|||
|
|
remark: '长期贷款',
|
|||
|
|
contractTime: new Date('2023-12-09 12:30:40'),
|
|||
|
|
disbursementTime: new Date('2023-12-10 10:15:00'),
|
|||
|
|
maturityTime: new Date('2026-12-10 10:15:00'),
|
|||
|
|
createdBy: adminUser.id
|
|||
|
|
}
|
|||
|
|
];
|
|||
|
|
|
|||
|
|
// 批量创建合同
|
|||
|
|
const createdContracts = await LoanContract.bulkCreate(contracts);
|
|||
|
|
console.log(`✅ 成功创建${createdContracts.length}个贷款合同`);
|
|||
|
|
|
|||
|
|
console.log('\n📊 贷款合同数据统计：');
|
|||
|
|
console.log('- 已放款：6个合同');
|
|||
|
|
console.log('- 待放款：1个合同');
|
|||
|
|
console.log('- 已完成：2个合同');
|
|||
|
|
console.log('- 违约：1个合同');
|
|||
|
|
console.log('- 已取消：1个合同');
|
|||
|
|
console.log('- 总合同金额：3,410,000.00元');
|
|||
|
|
console.log('- 已还款金额：520,000.00元');
|
|||
|
|
console.log('- 剩余还款金额：2,890,000.00元');
|
|||
|
|
|
|||
|
|
console.log('\n🎉 贷款合同测试数据添加完成！');
|
|||
|
|
} catch (error) {
|
|||
|
|
console.error('❌ 添加贷款合同测试数据失败:', error);
|
|||
|
|
throw error;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
// 如果直接运行此文件
|
|||
|
|
if (require.main === module) {
|
|||
|
|
seedLoanContracts()
|
|||
|
|
.then(() => {
|
|||
|
|
console.log('✅ 脚本执行完成');
|
|||
|
|
process.exit(0);
|
|||
|
|
})
|
|||
|
|
.catch((error) => {
|
|||
|
|
console.error('❌ 脚本执行失败:', error);
|
|||
|
|
process.exit(1);
|
|||
|
|
});
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
module.exports = seedLoanContracts;
|