iao_team/resources/views/livewire/course_member.blade.php

<div class="col">
    <div class="row h-100">
<div class="col-auto filterWrapper" id="filter--section"  wire:ignore.self>
    <aside>
        <header>
            <h2>Filtra</h2>
        </header>

        <form action="" id="filter--form" class="dark-form row">
            <div class="filter--item">
                <span class="filter--item_title">Corso</span>

                <div class="filter--item_formElement">
                    <select class="form-select" wire:model="filterCourse" onchange="destroyDataTable()">
                        <option value="">--Seleziona--
                        @foreach($courses as $c)
                            <option value="{{$c}}">{{$c}}
                        @endforeach
                    </select>
                </div>
            </div>
            <div class="filter--item">
                <span class="filter--item_title">Livello</span>

                <div class="filter--item_formElement">
                    <select class="form-select" wire:model="filterLevel" onchange="destroyDataTable()">
                        <option value="">--Seleziona--
                        @foreach($course_levels as $c)
                            <option value="{{$c->id}}">{{$c->name}}
                        @endforeach
                    </select>
                </div>
            </div>

            <div class="filter--item">
                <span class="filter--item_title">Tipologia</span>

                <div class="filter--item_formElement">
                    <select class="form-select" wire:model="filterType" onchange="destroyDataTable()">
                        <option value="">--Seleziona--
                        @foreach($course_types as $c)
                            <option value="{{$c->id}}">{{$c->name}}
                        @endforeach
                    </select>
                </div>
            </div>

            <div class="filter--item">
                <span class="filter--item_title">Frequenza</span>

                <div class="filter--item_formElement">
                    <select class="form-select" wire:model="filterFrequency" onchange="destroyDataTable()">
                        <option value="">--Seleziona--
                        @foreach($course_frequencies as $c)
                            <option value="{{$c->id}}">{{$c->name}}
                        @endforeach
                    </select>
                </div>
            </div>

            <div class="filter--item">
                <span class="filter--item_title">Giorni</span>

                <div class="filter--item_formElement">
                    <select class="form-select" wire:model="filterDays" onchange="destroyDataTable()">
                        <option value="">--Seleziona--
                        <option value="lun">Lunedì
                        <option value="mar">Martedì
                        <option value="mer">Mercoledì
                        <option value="gio">Giovedì
                        <option value="ven">Venerdì
                        <option value="sab">Sabato
                        <option value="dom">Domenica
                    </select>
                </div>
            </div>

            <div class="filter--item">
                <span class="filter--item_title">Orari</span>

                <div class="filter--item_formElement">
                    <select class="form-select" wire:model="filterHours" onchange="destroyDataTable()">
                        <option value="">--Seleziona--
                        @for($c=6;$c<=23;$c++)
                            <option value="{{str_pad($c, 2, "0", STR_PAD_LEFT)}}:00">{{str_pad($c, 2, "0", STR_PAD_LEFT)}}:00
                            <option value="{{str_pad($c, 2, "0", STR_PAD_LEFT)}}:30">{{str_pad($c, 2, "0", STR_PAD_LEFT)}}:30
                        @endfor
                    </select>
                </div>
            </div>

            <div class="filter--item">
                <span class="filter--item_title">Anno</span>

                <div class="filter--item_formElement">
                    <select class="form-select" wire:model="filterYear" onchange="destroyDataTable()">
                        <option value="">--Seleziona--
                        @foreach($course_years as $c)
                            <option value="{{$c}}">{{$c}}
                        @endforeach
                    </select>
                </div>

            </div>

            <div class="filter--item">
                <span class="filter--item_title">Pagamento iscrizione</span>

                <div class="filter--item_formElement">
                    <select class="form-select" wire:model="filterSubscription" onchange="destroyDataTable()">
                        <option value="">--Seleziona--
                        <option value="1">Pagata
                        <option value="0">Non Pagata
                    </select>
                </div>
            </div>

            <div class="filter--item">
                <span class="filter--item_title">Tipologia di Tesseramento</span>

                <div class="filter--item_formElement row">

                    <div class="col-12">
                        @foreach(getCards() as $card)
                            <div class="form-check form-check-inline  align-items-center">
                                <input class="form-check-input chkCard" type="checkbox" value="{{$card->id}}" wire:model="chkCard" onclick="destroyDataTable()">
                                <label class="form-check-label ms-2" >{{$card->name}}</label>
                            </div>
                        @endforeach
                    </div>
                </div>
            </div>
            <!-- filter item -->

            <div class="filter--item">
                <span class="filter--item_title">Stato tesseramento</span>

                <div class="filter--item_formElement">
                    <select class="form-select" wire:model="filterStatus" onchange="destroyDataTable()">
                        <option value="">--Seleziona--
                        <option value="2">Attivo
                        <option value="1">Sospeso
                        <option value="0">Non tesserato
                    </select>
                </div>

            </div>

            <div class="filter--item">
                <span class="filter--item_title">Certificato Medico</span>

                <div class="filter--item_formElement row">
                    <div class="col-6">
                        <div class="form-check form-check-inline  align-items-center">
                            <input class="form-check-input chkCertificateNormal" type="checkbox" wire:model="chkCertificateNormal" onclick="destroyDataTable()" value="1">
                            <label class="form-check-label ms-2" >Normale</label>
                        </div>
                        <div class="form-check form-check-inline  align-items-center">
                            <input class="form-check-input chkCertificateScadenza" type="checkbox" wire:model="chkCertificateScadenza" onclick="destroyDataTable()"  value="1">
                            <label class="form-check-label ms-2" >In Scadenza</label>
                        </div>
                    </div>
                    <div class="col-6">
                        <div class="form-check form-check-inline  align-items-center">
                            <input class="form-check-input chkCertificateAgonistico" type="checkbox" wire:model="chkCertificateAgonistico" onclick="destroyDataTable()" value="1">
                            <label class="form-check-label ms-2" >Agonistico</label>
                        </div>
                        <div class="form-check form-check-inline  align-items-center">
                            <input class="form-check-input chkCertificateScaduti" type="checkbox" wire:model="chkCertificateScaduti" onclick="destroyDataTable()" value="1">
                            <label class="form-check-label ms-2" >Scaduti</label>
                        </div>

                    </div>
                </div>
            </div>

        </form>

        <footer>
            <div class="filter--buttons d-flex align-items-center justify-content-between">
                <button class="btn--ui small dark disable" wire:click.prevent="disableSearch()" onclick="destroyDataTable()">cancella</button>
                <button class="btn--ui small white" wire:click.prevent="search()" onclick="destroyDataTable()">filtra</button>
            </div>
        </footer>

    </aside>
</div>

<div class="col card--ui" id="card--dashboard">


    <header id="title--section" class="d-flex align-items-center justify-content-between">
        <div class="title--section_name d-flex align-items-center justify-content-between">
            <i class="ico--ui title_section utenti me-2"></i>
            <h2 class="primary">Iscritti ai corsi</h2>
        </div>

    </header>

    <button id="open-filter" onclick="pcsh1()"></button>
    <button id="close-filter" onclick="pcsh2()"></button>

    <section id="resume-table">
        <div class="compare--chart_wrapper d-none"></div>

        <div id="filter">{{$filter}}</div>

        <table class="table tablesaw tablesaw-stack" id="tablesaw-350">
            <thead>
                <tr>
                    <th scope="col">#</th>
                    <th scope="col">Cognome</th>
                    <th scope="col">Nome</th>
                    <th scope="col">Età</th>
                    <th scope="col">Telefono</th>
                    <th scope="col">Email</th>
                </tr>
            </thead>
            <tbody id="checkall-target">
                @foreach($records as $idx => $record)
                    <tr>
                        <td>{{$idx +1}}</td>
                        <td>{{$record->member->last_name}}</td>
                        <td>{{$record->member->first_name}}</td>
                        <td>{{$record->member->getAge() . " (" . date("Y", strtotime($record->member->birth_date)) . ")"}}</td>
                        <td>{{$record->member->phone}}</td>
                        <td>{{$record->member->email}}</td>
                    </tr>
                @endforeach

            </tbody>
        </table>

    </section>
</div>

@push('scripts')
    <link href="/css/datatables.css" rel="stylesheet" />
    <script src="https://code.jquery.com/jquery-2.2.4.min.js" integrity="sha256-BbhdlvQf/xTY9gja0Dq3HiwQF8LaCRTXxZKRutelT44=" crossorigin="anonymous"></script>
    <script src="/assets/js/datatables.js"></script>
    <script src="https://cdn.datatables.net/buttons/3.0.2/js/buttons.dataTables.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.10.1/jszip.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.2.7/pdfmake.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.2.7/vfs_fonts.js"></script>
@endpush

@push('scripts')
    <script>

        var t = '{{$filter}}';

        $(document).ready(function() {
            loadDataTable();
        } );

        Livewire.on('load-data-table', () => {
            loadDataTable();
        });

        Livewire.on('destroy-data-table', () => {
            $('#tablesaw-350').DataTable().destroy();
        });

        function destroyDataTable()
        {
            $('#tablesaw-350').DataTable().destroy();
        }

        function loadDataTable(){
            $('#tablesaw-350').DataTable({
                // caption : $("#filter").html(),
                thead: {
                'th': {'background-color': 'blue'}
                },
                layout: {
                    topStart: {
                        buttons: [
                            {
                                extend: 'excelHtml5',
                                title: 'Iscritti corsi',
                                messageTop: $("#filter").html()
                            },
                            {
                                extend: 'pdfHtml5',
                                title: 'Iscritti corsi',
                                messageTop: $("#filter").html()
                            },
                            {
                                extend: 'print',
                                text: 'Stampa',
                                title: 'Iscritti corsi',
                                messageTop: $("#filter").html()
                            }
                        ]
                    }
                },
                pagingType: 'numbers',
                order: [[1, 'asc'], [2, 'asc']],
                "language": {
                    "url": "/assets/js/Italian.json"
                }
            });
            $('#tablesaw-350 thead tr th').addClass('col');
            $('#tablesaw-350 thead tr th').css("background-color", "#EDF0F2");

        }

    </script>
@endpush