<?php

declare(strict_types=1);

require __DIR__ . '/../../vendor/autoload.php';

use Mnb\PHPExcel\MnbExcel;

$path = $argv[1] ?? (__DIR__ . '/../samples/large-orders.xlsx');
$iterations = max(1, (int) ($argv[2] ?? 5));
$mode = $argv[3] ?? 'rows';
$times = [];
$rowsRead = 0;

for ($iteration = 0; $iteration < $iterations; $iteration++) {
    gc_collect_cycles();
    $started = hrtime(true);
    $session = MnbExcel::read($path)
        ->sheet('Orders')
        ->withHeaderRow(1)
        ->withOptions(['skip_empty_rows' => true]);

    if ($mode === 'array') {
        $rowsRead = count($session->toArray());
    } else {
        $rowsRead = 0;
        foreach ($session->rows() as $_row) {
            $rowsRead++;
        }
    }

    $times[] = (hrtime(true) - $started) / 1_000_000;
}

sort($times);
$median = $times[(int) floor(count($times) / 2)];

echo json_encode([
    'library' => 'mnb/mnb-phpexcel',
    'php' => PHP_VERSION,
    'mode' => $mode,
    'file' => realpath($path) ?: $path,
    'file_bytes' => filesize($path),
    'iterations' => $iterations,
    'rows' => $rowsRead,
    'median_ms' => round($median, 3),
    'peak_memory_bytes' => memory_get_peak_usage(true),
], JSON_PRETTY_PRINT | JSON_UNESCAPED_SLASHES | JSON_THROW_ON_ERROR), PHP_EOL;