DeletedWikiMetricsController.php

<?php

namespace App\Http\Controllers;

use App\Wiki;
use Carbon\CarbonImmutable;
use Illuminate\Http\Request;

class DeletedWikiMetricsController extends Controller {
    private string $fileName = 'deleted_wiki_metric.csv';

    /**
     * Produce a downloadable csv file with deleted wiki metrics.
     */
    public function index(Request $request) {
        $allDeletedWikis = Wiki::onlyTrashed()->get();
        $output = $this->createOutput($allDeletedWikis);

        return $this->returnCsv($output);
    }

    private function returnCsv($output) {
        ob_start();
        $handle = fopen('php://output', 'r+');
        fputcsv($handle, [
            'domain_name_for_wiki',
            'wiki_deletion_reason',
            'number_of_wiki_edits_for_wiki',
            'number_of_wiki_pages_for_wiki',
            'number_of_users_for_wiki',
            'wiki_creation_time',
            'wiki_deletion_time',
        ],
        escape: '\\');
        foreach ($output as $deletedWikiMetrics) {
            fputcsv($handle, array_values($deletedWikiMetrics), escape: '\\');
        }
        $csv = ob_get_clean();

        return response($csv, 200, [
            'Content-Type' => 'text/csv',
            'Content-Disposition' => 'attachment;filename=' . CarbonImmutable::now()->toIso8601String() . '-' . $this->fileName]);
    }

    private function createOutput($wikis): array {
        $output = [];
        foreach ($wikis as $wiki) {
            $output[] = [
                'domain_name_for_wiki' => $wiki->domain,
                'wiki_deletion_reason' => $wiki->wiki_deletion_reason,
                'number_of_wiki_edits_for_wiki' => $wiki->wikiSiteStats()->first()->edits ?? null,
                'number_of_wiki_pages_for_wiki' => $wiki->wikiSiteStats()->first()->pages ?? null,
                'number_of_users_for_wiki' => $wiki->wikiSiteStats()->first()->users ?? null,
                'wiki_creation_time' => $wiki->created_at,
                'wiki_deletion_time' => $wiki->deleted_at,
            ];
        }

        return $output;
    }
}