芝麻web文件管理V1.00

编辑当前文件:/home/forge/stage.herta-bht.smartcon-survey.com/app/Exports/KPIFunnelExport.php

<?php

namespace App\Exports;

use App\Models\Brand;
use App\Models\Country;
use App\Models\Product;
use Maatwebsite\Excel\Concerns\FromArray;
use Maatwebsite\Excel\Concerns\WithHeadings;

class KPIFunnelExport implements FromArray, WithHeadings
{
    private array $data;

private Country $country;

private Brand|Product $model;

private string $wave;

private string $quarter;

public function __construct(array $data, Country $country, Brand|Product $model)
    {
        $this->data = $data['data'];
        $this->quarter = $data['quarterYear'];
        $this->country = $country;
        $this->model = $model;
    }

public function array(): array
    {
        $rows = [];
        foreach ($this->data as $row) {
            foreach ($row as $key => $value) {
                $row[$key] = (string) $value;
            }
            $rows[] = [
                'Country' => $this->country->name,
                'Brand' => $this->model->name,
                'Quarter' => $this->quarter,
                ...$row,
            ];
        }

return $rows;
    }

public function headings(): array
    {
        return ['Country', 'Brand', 'Quarter', 'KPI Funnel', 'n', '%', 'Conversion', 'Delta'];
    }
}