<?php


namespace App;


use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\ShouldAutoSize;
use Maatwebsite\Excel\Concerns\WithHeadings;

class UserResponseExport implements FromCollection, WithHeadings, ShouldAutoSize
{

    public function headings(): array
    {
        return [
            'Naam',
            'Categorie',
            'Aanwezig',
            'Aantal personen',
            'Naar ceremonie',
            'Blijft slapen',
            'Allergieën',
            'Straat',
            'Postcode',
            'Woonplaats',
            'Email',
            'Opmerking',
        ];
    }

    public function collection()
    {

        $collection = collect();

        $users = User::with('response')->get();

        $currentCategory = null;

        foreach ($users as $user) {

            if($user->user_type != $currentCategory) {

                $currentCategory = $user->user_type;
                if($currentCategory != null) $collection->push(['', '']);

            }

            if(empty($user->response)) {
                $collection->push([
                    $user->name,
                    $user->user_type,
                ]);
            }

            if(!empty($user->response)) {
                $collection->push([
                    $user->name,
                    $user->user_type,

                    $user->response->present,
                    $user->response->present_persons,
                    $user->response->at_ceremony,
                    $user->response->stay_sleeping,
                    $user->response->has_allergies,
                    $user->response->street,
                    $user->response->postal,
                    $user->response->city,
                    $user->response->email,
                    $user->response->form_message,
                ]);
            }
        }

        return $collection;
    }

}