@extends('layouts.app')

@section('content')
    <meta http-equiv="content-type" content="text/plain; charset=UTF-8" />
    <div style="display:none;">
        <div class="container">
            <div class="row justify-content-center">
                <div class="col-md-12">
                    <div class="card">
                        <div class="card-header card-header-fle color-back">
                            <div class="col-md-10 div-button">Usuários</div>
                            <div class="col-md-2 div-button">
                                <input type="button" id="btnExport" value=" Export Table data into Excel" />
                            </div>
                        </div>
                        <div class="card-body">
                            <div class="col-md-12">
                                <div id="dvData">
                                    <table class="table table-striped table-sm table-bordered" border="1">
                                        <thead>
                                            <tr>
                                                <th scope="col">Setor</th>
                                                <th scope="col">Nome</th>
                                                <th scope="col">Formulário</th>
                                                <th scope="col">E-mail</th>
                                                <th scope="col">Enviado</th>
                                                <th scope="col">Iniciado</th>
                                                <th scope="col">Progresso</th>
                                                <th scope="col">Concluído</th>
                                                <th scope="col">Data início de participação</th>
                                                <th scope="col">Data fim de participação</th>
                                                <th scope="col">Data última atualização</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @foreach ($users as $user)
                                                @if (count($user['all_questionaries']) > 0)
                                                    @foreach ($user['all_questionaries'] as $userresponded)
                                                        <tr>
                                                            <td>{{ $user['setor'] }}</td>
                                                            <td>{{ $user['name'] }}</td>
                                                            <td>{{ $userresponded['name_quest'] }}</td>
                                                            <td>{{ $user['email'] }}</td>
                                                            <td>{{ $user['is_emailed'] ? 'Sim' : 'Não' }}</td>
                                                            <td>{{ $userresponded['initialized_at'] != null ? 'Sim' : 'Não' }}
                                                            </td>
                                                            <td>{{ $userresponded['progress'] }}%</td>
                                                            <td>{{ $userresponded['progress'] == 100 ? 'Sim' : 'Não' }}</td>
                                                            <td>{{ !empty($userresponded['data_inicio']) ? \Carbon\Carbon::parse($userresponded['data_inicio'])->format('d/m/Y') : '-' }}
                                                            </td>
                                                            <td>{{ !empty($userresponded['data_fim']) ? \Carbon\Carbon::parse($userresponded['data_fim'])->format('d/m/Y') : '-' }}
                                                            </td>
                                                            <td>{{ \Carbon\Carbon::parse($user['updated_at'])->format('d/m/Y H:i') }}</td>

                                                        </tr>
                                                    @endforeach
                                                @else
                                                    <tr>
                                                        <td>{{ $user['setor'] }}</td>
                                                        <td>{{ $user['name'] }}</td>
                                                        <td style="text-align:center;">-</td>
                                                        <td>{{ $user['email'] }}</td>
                                                        <td>Não</td>
                                                        <td>Não</td>
                                                        <td>0%</td>
                                                        <td>Não</td>
                                                        <td>-</td>
                                                        <td>-</td>
                                                        <td>{{ \Carbon\Carbon::parse($user['updated_at'])->format('d/m/Y H:i') }}</td>
                                                    </tr>
                                                @endif
                                            @endforeach
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <script defer>
            $(document).ready(function() {
                var a = document.createElement('a');
                var data_type = 'data:application/vnd.ms-excel';
                var table_div = document.getElementById('dvData');
                var table_html = table_div.outerHTML.replace(/ /g, '%20');
                // Adding UTF-8 BOM and replacing spaces with '%20'
                var BOM = "\uFEFF";

                table_html = BOM + table_html.replace(/ /g, '%20');

                a.href = data_type + ', ' + table_html;
                a.download = 'Tabela.xls';
                a.click();
                e.preventDefault();
            });
        </script>
        <script defer>
            $(document).ready(function() {
                setTimeout(history.back(), 3000);
            });
        </script>
    </div>
@endsection