<?php

namespace App\ExportMaps;

use App\IntegrationRepository;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Support\Facades\App;
use Illuminate\Support\Facades\Config;
use Mtc\MercuryDataModels\Vehicle;

class VehicleExportMap
{
    /**
     * Report name
     *
     * @return string
     */
    public function name(): string
    {
        return 'Vehicles';
    }

    /**
     * Columns that can be used
     *
     * @return string[]
     */
    public function columns(bool $onlyEnabledIntegrations = false): array
    {
        return array_merge([
            'uuid' => 'Unique Identifier',
            'registration_number' => 'Registration number',
            'vin' => 'VIN',
            'is_published' => 'Is Published',
            'is_sold' => 'Is Sold',
            'is_new' => 'Is New',
            'is_demo' => 'Is Demo',
            'is_reserved' => 'Is Reserved',
            'type' => 'Type (Car/LCV)',
            'title' => 'Title',
            'derivative' => 'Derivative',
            'make.name' => 'Vehicle make',
            'model.name' => 'Vehicle model',
            'fuelType.name' => 'Fuel Type',
            'drivetrain_id' => 'Drivetrain',
            'transmission.name' => 'Transmission',
            'dealership_id' => 'Dealership ID',
            'dealership.name' => 'Dealership Name',
            'dealership.address1' => 'Dealership Address 1',
            'dealership.county' => 'Dealership County',
            'dealership.postcode' => 'Dealership Postcode',
            'dealership.email' => 'Dealership Email',
            'bodyStyle.name' => 'Body Style',
            'price' => 'Price',
            'price_as_integer' => 'Price - without decimals',
            'monthly_price' => 'Monthly Price',
            'deposit' => 'Deposit',
            'colour' => 'Colour',
            'odometer_mi' => 'Odometer (miles)',
            'odometer_km' => 'Odometer (km)',
            'engine_size_cc' => 'Engine size (cc)',
            'co2' => 'CO2',
            'mpg' => 'MPG',
            'door_count' => 'Door count',
            'seats' => 'Seat count',
            'manufacture_year' => 'Manufacture year',
            'previous_owner_count' => 'Previous owner count',
            'images' => 'Image URLs - All',
            'images20' => 'Image URLs - First 20',
            'features.name' => 'Features',
            'specs.description' => 'Specs',
            'equipment.description' => 'Equipment - All',
            'standardEquipment.description' => 'Equipment - Standard',
            'optionalEquipment.description' => 'Equipment - Optional',
            'main_video_url' => 'Video URL',
            'cap_id' => 'CAP ID',
            'cap_code' => 'CAP Code',
            'auto_trader_id' => 'AutoTrader ID',
            'first_registration_date' => 'First registration date',
            'description' => 'Description text',
            'trim' => 'Trim',
            'attention_grabber' => 'Attention grabber text',
            'vehicle_length' => 'Vehicle length (mm)',
            'exterior_video_url' => 'Exterior video URL',
            'interior_video_url' => 'Interior video URL',
            'battery_range' => '[EV] Battery range',
            'battery_capacity_kwh' => '[EV] Battery capacity (kWh)',
            'battery_usable_capacity_kwh' => '[EV] Battery usable capacity (kWh)',
            'battery_charge_time' => '[EV] Battery charge time',
            'battery_quick_charge_time' => '[EV] Battery quick charge time',
            'battery_quick_charge_level' => '[EV] Battery level at end of quick charge',
            'wheelbase_type' => 'Wheelbase (mm)',
            'wheelbase_mm' => 'Wheelbase (mm)',
            'payload_kg' => 'Payload (kg)',
            'gross_vehicle_weight_kg' => 'Gross vehicle weight (kg)',
            'bhp' => 'BHP',
            'empty' => 'Empty value',
            'site_identifier' => 'Site Identifier',
            'reservation_amount' => 'Reservation Amount',
            'vrm_condensed' => 'VRM Condensed',
            'condition' => 'Condition',
            'created_at' => 'Created at',
            'updated_at' => 'Updated at',
            'rrp_price' => 'RRP price',
            'is_vat_applicable' => 'Is VAT applicable',
            'available_date' => 'Available from date',
            'custom1' => '[Custom] - Mapping Rules Field 1',
            'custom2' => '[Custom] - Mapping Rules Field 2',
            'custom3' => '[Custom] - Mapping Rules Field 3',
            'custom4' => '[Custom] - Mapping Rules Field 4',
            'custom5' => '[Custom] - Mapping Rules Field 5',
            'custom6' => '[Custom] - Mapping Rules Field 6',
            'colourMap.colour.colour' => 'Colour from Colour Map',
            'days_since_first_registration' => 'Days since first registration date',
            'calculated_available_date' => 'Available from date - calculated for empty',
            'site_url' => 'Site URL',
        ], $this->getDealershipAdditionalDataFields($onlyEnabledIntegrations));
    }

    /**
     * Start a query
     *
     * @return Builder
     */
    public function query(): Builder
    {
        return Vehicle::query();
    }

    protected function getDealershipAdditionalDataFields(bool $onlyEnabledIntegrations = true): array
    {
        $integrationRepository = App::make(IntegrationRepository::class);
        $integrations = $onlyEnabledIntegrations ?
            $integrationRepository->getEnabledForType('sales-channels') :
            $integrationRepository->getAllForType('sales-channels');

        return $integrations
            ->filter(fn($integration) => !empty($integration['class'])
                && class_exists($integration['class'])
                && method_exists($integration['class'], 'dealershipAdditionalDataFields'))
            ->flatMap(function ($integration) {
                $instance = App::make($integration['class']);
                $fields = $instance->dealershipAdditionalDataFields();
                return collect($fields)->mapWithKeys(fn($fieldData, $fieldKey) => [
                    'dealership.data.' . $fieldKey => '[Dealership] ' . ($fieldData['label'] ?? $fieldKey),
                ]);
            })
            ->all();
    }
}
