2026-02-25-client-1772033293903.txt

export async function get_azure_costs_date_range({ date } = {}) {
  try {
    const transcriptDir = '/home/ubuntu/realtime-voice/transcripts';
    let targetDate;
    
    if (date === 'today') {
      targetDate = new Date().toISOString().split('T')[0];
    } else if (date === 'yesterday') {
      const yesterday = new Date();
      yesterday.setDate(yesterday.getDate() - 1);
      targetDate = yesterday.toISOString().split('T')[0];
    } else {
      targetDate = date;
    }
    
    const files = execSync(`find ${transcriptDir} -name "${targetDate}*.txt" -type f`, { encoding: 'utf-8' }).trim().split('\n').filter(Boolean);
    
    if (files.length === 0) {
      return `Geen transcripts gevonden voor ${targetDate}`;
    }
    
    let totalMinutes = 0;
    let sessionCount = files.length;
    
    for (const file of files) {
      const content = execSync(`cat "${file}"`, { encoding: 'utf-8' });
      const lines = content.split('\n').filter(l => l.includes('USER:') || l.includes('AI:'));
      const duration = lines.length * 0.5;
      totalMinutes += duration;
    }
    
    const inputCost = (totalMinutes * 60 * 0.06) / 1000000;
    const outputCost = (totalMinutes * 60 * 0.24) / 1000000;
    const totalCost = inputCost + outputCost;
    
    return `Datum: ${targetDate}\nSessies: ${sessionCount}\nGeschatte duur: ${Math.round(totalMinutes)} minuten\nGeschatte kosten: $${totalCost.toFixed(2)} USD`;
  } catch (e) {
    return 'Fout bij ophalen kosten: ' + e.message;
  }
}

export async function get_qbittorrent_torrent_details() {
  try {
    const torrents = await fetchJson(QB_URL + '/api/v2/torrents/info?filter=completed&limit=5');
    
    if (!torrents || torrents.length === 0) {
      return 'Geen voltooide torrents gevonden';
    }
    
    const result = torrents.map(t => {
      const completedOn = new Date(t.completion_on * 1000);
      const addedOn = new Date(t.added_on * 1000);
      const durationMs = completedOn - addedOn;
      const durationMin = Math.round(durationMs / 60000);
      const sizeGB = (t.size / (1024 ** 3)).toFixed(2);
      const avgSpeed = t.size / (durationMs / 1000) / (1024 ** 2);
      
      return `${t.name}\n  Grootte: ${sizeGB} GB\n  Duur: ${durationMin} minuten\n  Gem. snelheid: ${avgSpeed.toFixed(1)} MB/s\n  Voltooid: ${completedOn.toLocaleString('nl-NL')}`;
    }).join('\n\n');
    
    return result;
  } catch (e) {
    return 'Fout bij ophalen torrent details: ' + e.message;
  }
}

export async function compare_ai_hosting_costs({ daily_minutes } = {}) {
  try {
    const monthlyMinutes = daily_minutes * 30;
    const monthlyHours = monthlyMinutes / 60;
    
    const realtimeInputTokens = monthlyMinutes * 60 * 1000;
    const realtimeOutputTokens = monthlyMinutes * 60 * 1000;
    const realtimeCost = (realtimeInputTokens * 0.06 / 1000000) + (realtimeOutputTokens * 0.24 / 1000000);
    
    const t4HourlyCost = 0.40;
    const t4MonthlyCost = monthlyHours * t4HourlyCost;
    
    const t4PurchaseCost = 1500;
    const monthsToBreakEven = t4PurchaseCost / t4MonthlyCost;
    
    return `Kostenvergelijking voor ${daily_minutes} min/dag (${monthlyMinutes} min/maand):\n\nOpenAI Realtime API:\n  Maandelijks: $${realtimeCost.toFixed(2)}\n  Jaarlijks: $${(realtimeCost * 12).toFixed(2)}\n\nNVIDIA T4 huren (cloud):\n  Maandelijks: $${t4MonthlyCost.toFixed(2)}\n  Jaarlijks: $${(t4MonthlyCost * 12).toFixed(2)}\n\nNVIDIA T4 kopen (~$1500):\n  Break-even na: ${monthsToBreakEven.toFixed(1)} maanden\n  Stroom/onderhoud: ~$50/maand extra\n\nAanbeveling: ${realtimeCost < t4MonthlyCost ? 'OpenAI Realtime API (goedkoper)' : 'Eigen GPU huren of kopen (goedkoper)'}`;
  } catch (e) {
    return 'Fout bij kostenvergelijking: ' + e.message;
  }
}

export async function get_system_service_count() {
  try {
    const dockerContainers = execSync('docker ps --format "{{.Names}}"', { encoding: 'utf-8' }).trim().split('\n').filter(Boolean);
    const systemdActive = execSync('systemctl list-units --type=service --state=running --no-pager --no-legend | wc -l', { encoding: 'utf-8' }).trim();
    const listeningPorts = execSync('ss -tuln | grep LISTEN | wc -l', { encoding: 'utf-8' }).trim();
    
    const dockerList = dockerContainers.join(', ');
    
    return `Services overzicht:\n\nDocker containers: ${dockerContainers.length}\n  ${dockerList}\n\nSystemd services: ${systemdActive}\nListening poorten: ${listeningPorts}`;
  } catch (e) {
    return 'Fout bij ophalen services: ' + e.message;
  }
}

export async function get_prowlarr_indexer_stats() {
  try {
    const indexers = await fetchJson(PROWLARR_URL + '/api/v1/indexer', { 'X-Api-Key': PROWLARR_KEY });
    
    if (!indexers || indexers.length === 0) {
      return 'Geen indexers gevonden in Prowlarr';
    }
    
    const active = indexers.filter(i => i.enable);
    const inactive = indexers.filter(i => !i.enable);
    
    const result = `Prowlarr Indexers:\n\nActief: ${active.length}\nInactief: ${inactive.length}\nTotaal: ${indexers.length}\n\nActieve indexers:\n` + 
      active.map(i => `  - ${i.name} (${i.protocol})`).join('\n');
    
    return result;
  } catch (e) {
    return 'Fout bij ophalen Prowlarr indexers: ' + e.message;
  }
}