1
const response = await axios.get(
2
  `https://api.koywe.com/api/v1/organizations/${orgId}/merchants/${merchantId}/accounts/${accountId}/reports/orders`,
3
  {
4
    params: { from: '2025-01-01', to: '2025-01-31' },
5
    headers: { 'Authorization': `Bearer ${token}` }
6
  }
7
);
8
9
const { summary } = response.data;
10
11
// Volume analysis
12
console.log('=== Monthly Volume ===');
13
console.log(`Total Orders: ${summary.totalOrders}`);
14
15
// By type
16
console.log('\n=== By Type ===');
17
Object.entries(summary.byType).forEach(([type, count]) => {
18
  console.log(`${type}: ${count} orders`);
19
});
20
21
// By status
22
console.log('\n=== By Status ===');
23
Object.entries(summary.byStatus).forEach(([status, count]) => {
24
  const percentage = ((count / summary.totalOrders) * 100).toFixed(1);
25
  console.log(`${status}: ${count} (${percentage}%)`);
26
});
27
28
// Success rate
29
const completed = summary.byStatus.COMPLETED || 0;
30
const failed = summary.byStatus.FAILED || 0;
31
const successRate = (completed / (completed + failed) * 100).toFixed(1);
32
console.log(`\nSuccess Rate: ${successRate}%`);

1
async function generateOrdersAnalysis(orgId, merchantId, accountId, from, to, token) {
2
  // Fetch all orders (handling pagination)
3
  const allOrders = [];
4
  let cursor = null;
5
  let summary = null;
6
  
7
  do {
8
    const response = await axios.get(
9
      `https://api.koywe.com/api/v1/organizations/${orgId}/merchants/${merchantId}/accounts/${accountId}/reports/orders`,
10
      {
11
        params: {
12
          from,
13
          to,
14
          limit: 100,
15
          ...(cursor && { cursor })
16
        },
17
        headers: { 'Authorization': `Bearer ${token}` }
18
      }
19
    );
20
    
21
    allOrders.push(...response.data.orders);
22
    summary = response.data.summary;
23
    cursor = response.data.pagination.hasMore ? response.data.pagination.cursor : null;
24
    
25
  } while (cursor);
26
  
27
  // Generate analysis
28
  console.log('='.repeat(60));
29
  console.log('ORDERS ANALYSIS REPORT');
30
  console.log(`Period: ${from} to ${to}`);
31
  console.log('='.repeat(60));
32
  
33
  // Summary statistics
34
  console.log('\n📊 SUMMARY');
35
  console.log(`Total Orders: ${summary.totalOrders}`);
36
  
37
  // Type breakdown
38
  console.log('\n📈 BY TYPE');
39
  Object.entries(summary.byType).forEach(([type, count]) => {
40
    const pct = ((count / summary.totalOrders) * 100).toFixed(1);
41
    console.log(`  ${type.padEnd(20)} ${String(count).padStart(5)} (${pct}%)`);
42
  });
43
  
44
  // Status breakdown
45
  console.log('\n📋 BY STATUS');
46
  Object.entries(summary.byStatus).forEach(([status, count]) => {
47
    const pct = ((count / summary.totalOrders) * 100).toFixed(1);
48
    console.log(`  ${status.padEnd(20)} ${String(count).padStart(5)} (${pct}%)`);
49
  });
50
  
51
  // Calculate totals by type
52
  console.log('\n💰 VOLUME BY TYPE');
53
  const volumeByType = {};
54
  allOrders.forEach(order => {
55
    if (!volumeByType[order.type]) {
56
      volumeByType[order.type] = 0;
57
    }
58
    volumeByType[order.type] += parseFloat(order.amountIn);
59
  });
60
  
61
  Object.entries(volumeByType).forEach(([type, volume]) => {
62
    console.log(`  ${type.padEnd(20)} ${volume.toLocaleString()}`);
63
  });
64
  
65
  // Failed orders detail
66
  const failedOrders = allOrders.filter(o => o.status === 'FAILED');
67
  if (failedOrders.length > 0) {
68
    console.log('\n⚠️ FAILED ORDERS');
69
    failedOrders.forEach(order => {
70
      console.log(`  ${order.orderId} | ${order.type} | ${order.amountIn} | ${order.createdAt}`);
71
    });
72
  }
73
  
74
  console.log('\n' + '='.repeat(60));
75
  
76
  return { orders: allOrders, summary };
77
}
78
79
// Usage
80
const analysis = await generateOrdersAnalysis(
81
  'org3_xxx',
82
  'mrc_xxx', 
83
  'acc_xxx',
84
  '2025-01-01',
85
  '2025-01-31',
86
  token
87
);