Orders Report

GET /api/v1/organizations/{organizationId}/merchants/{merchantId}/accounts/{accountId}/reports/orders

{
  "accountId": "acc_0031c537-2301-40ab-9153-0f7c48505350",
  "currency": "CLP",
  "periodStart": "2025-01-01T00:00:00.000Z",
  "periodEnd": "2025-01-31T23:59:59.999Z",
  "orders": [
    {
      "orderId": "ord_abc123",
      "type": "PAYIN",
      "status": "COMPLETED",
      "amountIn": "1000000.00",
      "amountOut": "1000000.00",
      "originCurrency": "CLP",
      "destinationCurrency": "CLP",
      "counterparty": {
        "name": "Juan Pérez",
        "identifier": "12345678-9"
      },
      "createdAt": "2025-01-15T10:30:00.000Z",
      "completedAt": "2025-01-15T10:35:00.000Z",
      "externalId": "INV-2025-001"
    },
    {
      "orderId": "ord_def456",
      "type": "PAYOUT",
      "status": "COMPLETED",
      "amountIn": "500000.00",
      "amountOut": "500000.00",
      "originCurrency": "CLP",
      "destinationCurrency": "CLP",
      "counterparty": {
        "name": "Supplier Co",
        "identifier": "98765432-1"
      },
      "createdAt": "2025-01-20T14:00:00.000Z",
      "completedAt": "2025-01-20T14:15:00.000Z",
      "externalId": "PO-2025-042"
    }
  ],
  "summary": {
    "totalOrders": 150,
    "byType": {
      "PAYIN": 100,
      "PAYOUT": 50
    },
    "byStatus": {
      "COMPLETED": 140,
      "PENDING": 5,
      "FAILED": 5
    }
  },
  "pagination": {
    "cursor": "eyJvcmRlcklkIjoib3JkX2RlZjQ1NiJ9",
    "hasMore": true,
    "limit": 50
  },
  "generatedAt": "2025-01-31T12:00:00.000Z"
}

const response = await axios.get(
  `https://api.koywe.com/api/v1/organizations/${orgId}/merchants/${merchantId}/accounts/${accountId}/reports/orders`,
  {
    params: { from: '2025-01-01', to: '2025-01-31' },
    headers: { 'Authorization': `Bearer ${token}` }
  }
);
 
const { summary } = response.data;
 
// Volume analysis
console.log('=== Monthly Volume ===');
console.log(`Total Orders: ${summary.totalOrders}`);
 
// By type
console.log('\n=== By Type ===');
Object.entries(summary.byType).forEach(([type, count]) => {
  console.log(`${type}: ${count} orders`);
});
 
// By status
console.log('\n=== By Status ===');
Object.entries(summary.byStatus).forEach(([status, count]) => {
  const percentage = ((count / summary.totalOrders) * 100).toFixed(1);
  console.log(`${status}: ${count} (${percentage}%)`);
});
 
// Success rate
const completed = summary.byStatus.COMPLETED || 0;
const failed = summary.byStatus.FAILED || 0;
const successRate = (completed / (completed + failed) * 100).toFixed(1);
console.log(`\nSuccess Rate: ${successRate}%`);

// Get ledger statement
const ledger = await getLedgerStatement(orgId, merchantId, accountId, from, to, token);
 
// Get orders report
const orders = await getOrdersReport(orgId, merchantId, accountId, from, to, token);
 
// Cross-reference
ledger.movements.forEach(movement => {
  if (movement.orderId) {
    const order = orders.orders.find(o => o.orderId === movement.orderId);
    if (order) {
      console.log(`Movement ${movement.ledgerEntryId} matches Order ${order.orderId} (${order.type})`);
    }
  }
});

async function generateOrdersAnalysis(orgId, merchantId, accountId, from, to, token) {
  // Fetch all orders (handling pagination)
  const allOrders = [];
  let cursor = null;
  let summary = null;
  
  do {
    const response = await axios.get(
      `https://api.koywe.com/api/v1/organizations/${orgId}/merchants/${merchantId}/accounts/${accountId}/reports/orders`,
      {
        params: {
          from,
          to,
          limit: 100,
          ...(cursor && { cursor })
        },
        headers: { 'Authorization': `Bearer ${token}` }
      }
    );
    
    allOrders.push(...response.data.orders);
    summary = response.data.summary;
    cursor = response.data.pagination.hasMore ? response.data.pagination.cursor : null;
    
  } while (cursor);
  
  // Generate analysis
  console.log('='.repeat(60));
  console.log('ORDERS ANALYSIS REPORT');
  console.log(`Period: ${from} to ${to}`);
  console.log('='.repeat(60));
  
  // Summary statistics
  console.log('\n📊 SUMMARY');
  console.log(`Total Orders: ${summary.totalOrders}`);
  
  // Type breakdown
  console.log('\n📈 BY TYPE');
  Object.entries(summary.byType).forEach(([type, count]) => {
    const pct = ((count / summary.totalOrders) * 100).toFixed(1);
    console.log(`  ${type.padEnd(20)} ${String(count).padStart(5)} (${pct}%)`);
  });
  
  // Status breakdown
  console.log('\n📋 BY STATUS');
  Object.entries(summary.byStatus).forEach(([status, count]) => {
    const pct = ((count / summary.totalOrders) * 100).toFixed(1);
    console.log(`  ${status.padEnd(20)} ${String(count).padStart(5)} (${pct}%)`);
  });
  
  // Calculate totals by type
  console.log('\n💰 VOLUME BY TYPE');
  const volumeByType = {};
  allOrders.forEach(order => {
    if (!volumeByType[order.type]) {
      volumeByType[order.type] = 0;
    }
    volumeByType[order.type] += parseFloat(order.amountIn);
  });
  
  Object.entries(volumeByType).forEach(([type, volume]) => {
    console.log(`  ${type.padEnd(20)} ${volume.toLocaleString()}`);
  });
  
  // Failed orders detail
  const failedOrders = allOrders.filter(o => o.status === 'FAILED');
  if (failedOrders.length > 0) {
    console.log('\n⚠️ FAILED ORDERS');
    failedOrders.forEach(order => {
      console.log(`  ${order.orderId} | ${order.type} | ${order.amountIn} | ${order.createdAt}`);
    });
  }
  
  console.log('\n' + '='.repeat(60));
  
  return { orders: allOrders, summary };
}
 
// Usage
const analysis = await generateOrdersAnalysis(
  'org3_xxx',
  'mrc_xxx', 
  'acc_xxx',
  '2025-01-01',
  '2025-01-31',
  token
);