<?php

namespace App\Http\Controllers\Exports;

use App\Http\Controllers\UtilController;
use Carbon\Carbon;
use Maatwebsite\Excel\Concerns\FromQuery;
use Maatwebsite\Excel\Concerns\WithCustomChunkSize;
use Maatwebsite\Excel\Concerns\WithHeadings;
use Maatwebsite\Excel\Concerns\WithMapping;

class ClientsExport implements FromQuery, WithHeadings, WithMapping, WithCustomChunkSize
{
    private $util;
    private $query;

    public function __construct()
    {
        $this->util = new UtilController();
    }

    // set the headings
    public function headings(): array
    {
        return [
            __('messages.screen_clients_tag3'),
            __('messages.screen_clients_tag4'),
            __('messages.screen_clients_tag5'),
            __('messages.screen_clients_tag6'),
            __('messages.screen_clients_tag11'),
            __('messages.screen_clients_tag13'),
            __('messages.screen_clients_tag14'),
            __('messages.screen_clients_tag19'),
            __('messages.screen_clients_tag15'),
            __('messages.screen_clients_tag16'),
            __('messages.screen_clients_tag17'),
            __('messages.screen_clients_tag18'),
            __('messages.screen_clients_tag20'),
            __('messages.screen_clients_tag21'),
            __('messages.screen_clients_tag22'),
            __('messages.screen_clients_accept_terms'),
            __('messages.screen_clients_terms_conditions'),
            'Id',
            'QR'
        ];
    }

    public function setQuery($query)
    {
        $this->query = $query;
    }

    public function query()
    {
        return $this->query;
    }

    public function chunkSize(): int
    {
        return 1000;
    }

    public function map($client): array
    {
        return [
            $client->last_name,
            $client->first_name,
            $client->email,
            $client->active === 1 ? 'SI' : 'NO',
            $client->is_subscriber === 1 ? 'SI' : 'NO',
            $client->document,
            $client->documentType,
            $client->dob,
            $client->phone,
            Carbon::parse($client->created_at)->format('Y-m-d'),
            Carbon::parse($client->last_session)->format('Y-m-d'),
            Carbon::parse($client->last_session)->format('h:i:s A'),
            $this->util->getFullSexText($client->sex),
            $client->model,
            $client->segmentation,
            $client->accepted ? 'SI' : 'NO',
            $client->terms_conditions,
            $client->id,
            $this->getQRCode($client->id, $client->cards)
        ];
    }

    private function getQRCode($id, $cards)
    {
        $qrCode = '';
        if ($cards) {
            $itemCards = explode(',', $cards);
            foreach ($itemCards as $item) {
                if ($item) {
                    $qrCode = '{"u":' . $id . ',"c":' . $item . '}';
                }
            }
        }
        return $qrCode;
    }
}