va_admin_server/src/modules/api/entity/open_payment_order.ts

import { Entity, Column, PrimaryGeneratedColumn } from 'typeorm';
import { BaseEntity } from '@cool-midway/core';

/**
 * 订单管理
 */
@Entity('open_payment_order')
export class OpenPaymentOrderEntity extends BaseEntity {
  /*
   * 申请收款账户
   * 查询申请列表
   * 查询收款账户列表
   */

  @Column({ length: 100, comment: '商户编号', default: '' })
  mch_id: string;

  @Column({ length: 100, comment: '用户编号', default: '' })
  account_id?: string;

  @Column({ length: 100, comment: '转出账户', default: '' })
  from_account_id?: string;

  @Column({ length: 100, comment: '转入账户', default: '' })
  to_account_id?: string;

  @Column({ length: 100, comment: '订单编号', default: '' })
  request_id?: string;

  @Column({ length: 100, comment: '数据编号', default: '' })
  event_id?: string;

  @Column({ length: 100, comment: '币种', default: '' })
  currency?: string;

  @Column({ comment: '金额', type: 'decimal', precision: 20, scale: 6, default: 0 })
  amount?: number;

  @Column({ length: 100, comment: '目标币种', default: '' })
  target_currency?: string;

  @Column({ comment: '目标金额', type: 'decimal', precision: 20, scale: 6, default: 0 })
  target_amount?: number;

  @Column({ comment: '历史余额', type: 'decimal', precision: 20, scale: 6, default: 0 })
  before_balance?: number;

  @Column({ comment: '余额', type: 'decimal', precision: 20, scale: 6, default: 0 })
  balance?: number;

  @Column({ comment: '手续费', type: 'decimal', precision: 20, scale: 6, default: 0 })
  fee?: number;

  @Column({ comment: '渠道手续费', type: 'decimal', precision: 20, scale: 6, default: 0 })
  currency_fee?: number;

  @Column({ comment: '汇率', type: 'decimal', precision: 20, scale: 6, default: 0 })
  exchange_rate?: number;

  @Column({ length: 100, comment: 'credit or debit', default: '' })
  type?: string;

  @Column({ length: 100, comment: '订单类型', default: '' })
  order_type?: OrderType; // 使用枚举类型

  @Column({ length: 100, comment: '支付类型', default: '' })
  payment_type?: string; // 使用枚举类型

  @Column({ type: 'json', comment: '扩展信息' }) // 定义为 JSON 类型
  additional_info?: any;

  @Column({ length: 100, comment: '订单编号', default: '' })
  order_id?: string;

  @Column({ length: 100, comment: '订单状态', default: '' })
  status?: string;

  @Column({ length: 100, comment: '客户来源', default: '' })
  source?: string;

  @Column({ comment: '更新次数', default: 0 })
  update_count: number;
}

// 定义枚举类型
export enum OrderType {
  CURRENCY_EXCHANGE = 'CURRENCY_EXCHANGE', // 换汇
  ACQUIRING_PAYMENT = 'ACQUIRING_PAYMENT', // 收单支付订单
  ACQUIRING_REFUND = 'ACQUIRING_REFUND', // 收单退款订单
  PAYMENT = 'PAYMENT', // 付款
  TRANSFER = 'TRANSFER', // 转账
  DEPOSIT = 'DEPOSIT', // 入账
  EXCHANGE = 'EXCHANGE', // 换汇
  TRANSACTION_FEE_ORDER = 'TRANSACTION_FEE_ORDER', // 交易手续费订单
}

export const OrderTypeEnum = {
  CURRENCY_EXCHANGE: '换汇',
  ACQUIRING_PAYMENT: '收单支付订单',
  ACQUIRING_REFUND: '收单退款订单',
  PAYMENT: '付款',
  TRANSFER: '转账',
  DEPOSIT: '入账',
  EXCHANGE: '换汇',
  TRANSACTION_FEE_ORDER: '交易手续费订单',
};

export const StatusTypeEnum = {
  PENDING: '处理中',
  SUCCESS: '成功',
  FAILED: '失败',
};