import * as plugins from './plugins.js'; import { getDbSync } from './skr.database.js'; import { RetiredLedgerWriteError } from './skr.errors.js'; import type { TSKRType, TTransactionStatus, ITransactionData, } from './skr.types.js'; @plugins.nosqldb.Collection(() => getDbSync(), { collectionName: 'Transaction' }) export class Transaction extends plugins.nosqldb.SmartDataDbDoc { @plugins.nosqldb.unI() public id!: string; @plugins.nosqldb.svDb() @plugins.nosqldb.index() public transactionNumber!: string; @plugins.nosqldb.svDb() @plugins.nosqldb.index() public date!: Date; @plugins.nosqldb.svDb() @plugins.nosqldb.index() public debitAccount!: string; @plugins.nosqldb.svDb() @plugins.nosqldb.index() public creditAccount!: string; @plugins.nosqldb.svDb() public amount!: number; @plugins.nosqldb.svDb() public description!: string; @plugins.nosqldb.svDb() @plugins.nosqldb.index() public reference!: string; @plugins.nosqldb.svDb() @plugins.nosqldb.index() public skrType!: TSKRType; @plugins.nosqldb.svDb() public vatAmount!: number; @plugins.nosqldb.svDb() public costCenter!: string; @plugins.nosqldb.svDb() @plugins.nosqldb.index() public status!: TTransactionStatus; @plugins.nosqldb.svDb() public reversalOf!: string; @plugins.nosqldb.svDb() public reversedBy!: string; @plugins.nosqldb.svDb() @plugins.nosqldb.index() public period!: string; // Format: YYYY-MM @plugins.nosqldb.svDb() public fiscalYear!: number; @plugins.nosqldb.svDb() public createdAt!: Date; @plugins.nosqldb.svDb() public postedAt!: Date | null; @plugins.nosqldb.svDb() public createdBy!: string; constructor(data?: Partial) { super(); if (data) { this.id = plugins.smartunique.shortId(); this.transactionNumber = this.generateTransactionNumber(); this.date = data.date || new Date(); this.debitAccount = data.debitAccount || ''; this.creditAccount = data.creditAccount || ''; this.amount = data.amount || 0; this.description = data.description || ''; this.reference = data.reference || ''; this.skrType = data.skrType || 'SKR03'; this.vatAmount = data.vatAmount || 0; this.costCenter = data.costCenter || ''; this.status = 'pending'; this.reversalOf = ''; this.reversedBy = ''; // Set period and fiscal year const transDate = new Date(this.date); this.period = `${transDate.getFullYear()}-${String(transDate.getMonth() + 1).padStart(2, '0')}`; this.fiscalYear = transDate.getFullYear(); this.createdAt = new Date(); this.postedAt = null; this.createdBy = 'system'; } } private generateTransactionNumber(): string { const timestamp = Date.now(); const random = Math.floor(Math.random() * 1000); return `TXN-${timestamp}-${random}`; } /** * Retired: wrote a standalone Transaction and moved the accounts' cached * balances. The Transaction collection is a frozen read model. */ public static async createTransaction( _data: ITransactionData, ): Promise { throw new RetiredLedgerWriteError( 'Transaction.createTransaction()', 'the Transaction collection is a frozen read model', 'SkrApi.postTransaction() or Ledger.postTransaction()', ); } public static async getTransactionById( id: string, ): Promise { const transaction = await Transaction.getInstance({ id }); return transaction; } public static async getTransactionsByAccount( accountNumber: string, skrType: TSKRType, ): Promise { const transactionsDebit = await Transaction.getInstances({ debitAccount: accountNumber, skrType, status: 'posted', }); const transactionsCredit = await Transaction.getInstances({ creditAccount: accountNumber, skrType, status: 'posted', }); const transactions = [...transactionsDebit, ...transactionsCredit]; return transactions; } public static async getTransactionsByPeriod( period: string, skrType: TSKRType, ): Promise { const transactions = await Transaction.getInstances({ period, skrType, status: 'posted', }); return transactions; } public static async getTransactionsByDateRange( dateFrom: Date, dateTo: Date, skrType: TSKRType, ): Promise { const allTransactions = await Transaction.getInstances({ skrType, status: 'posted', }); const transactions = allTransactions.filter( (t) => t.date >= dateFrom && t.date <= dateTo, ); return transactions; } /** * Retired: posted this instance into the frozen Transaction collection. */ public async validateAndPost(): Promise { throw new RetiredLedgerWriteError( 'Transaction.validateAndPost()', 'the Transaction collection is a frozen read model', 'SkrApi.postTransaction() or Ledger.postTransaction()', ); } /** * Retired: marked the original 'reversed'. A posted entry is immutable; * a Storno entry reverses it. */ public async reverseTransaction(): Promise { throw new RetiredLedgerWriteError( 'Transaction.reverseTransaction()', 'a posted entry is immutable (GoBD); a Storno entry reverses it', 'SkrApi.reverseTransaction() or Ledger.reverseTransaction()', ); } public async beforeSave(): Promise { // Additional validation before saving if (!this.debitAccount || !this.creditAccount) { throw new Error('Both debit and credit accounts are required'); } if (!this.date) { throw new Error('Transaction date is required'); } if (!this.description) { throw new Error('Transaction description is required'); } } }