Automatiser le Fastidieux d'Abord : Là Où Réside la Véritable Rentabilité

// Direct Sage 100 ODBC Transaction Bridge
import { odbcPool } from '../db/sageConnection';

export async function insertDeliverySlipTransactional(slip: ValidatedDeliverySlip) {
  const connection = await odbcPool.connect();
  try {
    await connection.beginTransaction();
    // Insert header record
    await connection.query(
      'INSERT INTO F_DOCENTETE (DO_Piece, DO_Date, DO_Tiers, DO_TotalHT) VALUES (?, ?, ?, ?)',
      [slip.reference, slip.date, slip.customerCode, slip.amountHT]
    );
    // Insert line items atomically
    for (const item of slip.lineItems) {
      await connection.query(
        'INSERT INTO F_DOCLIGNE (DO_Piece, AR_Ref, DL_Qte, DL_PrixUnitaire) VALUES (?, ?, ?, ?)',
        [slip.reference, item.sku, item.quantity, item.unitPrice]
      );
    }
    await connection.commit();
  } catch (err) {
    await connection.rollback();
    throw new Error(`Sage Transaction Failed: ${err.message}`);
  }
}