<?php

namespace App\Exports;

use DateTime;
use Maatwebsite\Excel\Concerns\FromQuery;
use Maatwebsite\Excel\Concerns\WithHeadings;
use Maatwebsite\Excel\Concerns\WithMapping;
use Spatie\Activitylog\Models\Activity;

class ActivityExport implements FromQuery, WithMapping, WithHeadings
{
    public function __construct(int $year, int $month)
    {
        $this->year = $year;
        $this->month = $month;
    }
    // Activity status translations
    private const STATUS_TRANSLATIONS = [
        'new' => [
            'en' => 'Created',
            'ja' => '作成'
        ],
        'browse' => [
            'en' => 'browse',
            'ja' => 'ブラウズ'
        ],
        'edit' => [
            'en' => 'edit',
            'ja' => '更新'
        ],
        'delete' => [
            'en' => 'delete',
            'ja' => '削除'
        ],
        'capture' => [
            'en' => 'capture',
            'ja' => '捕獲'
        ],
        // Add more status translations as needed
    ];

    public function headings(): array
    {
        if (app()->isLocale('en')) {

            return [
                ['Date', 'Time', 'Order', 'Operator', 'Target'],
            ];
        }
        else {
            return [
                ['日付', '時間', '操作', 'オペレーターユーザーID', 'ターゲットユーザーID'],
            ];
        }
    }

    /**
     * @return \Illuminate\Support\Collection
     */
    public function query()
    {
        return Activity::with(['causer' => function ($query) {
            $query->withTrashed();
        }, 'subject'  => function ($query) {
            $query->withTrashed();
        }])
            ->whereYear('created_at_milliseconds', $this->year)
            ->whereMonth('created_at_milliseconds', $this->month);
    }

    private function translateActivityDescription(string $description): string
    {
        $locale = app()->getLocale();
        return self::STATUS_TRANSLATIONS[$description][$locale] ?? $description;
    }

    //// Oct 02, 2024 - add conditions when user is hard deleted
    public function map($activity): array
    {
        $date = new DateTime($activity->created_at_milliseconds);
        $targetUsername = is_null($activity->subject) ? 
            (app()->isLocale('en') ? 'Deleted' : '削除済み') : 
            $activity->subject->username;
        return [
            $date->format("Y/m/d"),
            $date->format("H:i:s"),
            $this->translateActivityDescription($activity->description),
            $activity->causer->username,
            $targetUsername
            // $activity->subject->username,
        ];
    }
}
