@php use App\Myclass\BanglaNumber; use App\Myclass\DateFormatter; @endphp
<script>
    $(document).ready(function() {
        $('#statusid').DataTable({
            "paging": false,
            "bInfo": false,
            dom: 'Bfrtip',
            "createdRow": function(row, data, index) {
                $('td', row).eq(1).addClass('wrap');
            },
            buttons: [
                'copy',
                {
                    extend: 'excel',
                    messageTop: 'Trainer Report',
                    filename: 'Trainern Report'
                },
                {
                    extend: 'csv',
                    messageTop: 'Trainer Report',
                    filename: 'Trainer Report'
                },
                {
                    extend: 'pdf',
                    messageTop: 'Trainer Report',
                    filename: 'Trainer Report',
                    title: 'TTrainer Report',
                    orientation: 'landscape',
                    pageSize: 'LEGAL'
                },
                {
                    extend: 'print',
                    title: function() {
                        var printTitle = 'Trainer Report'
                        return "<div style='font-size: 20px;text-align:center;'>" + printTitle + "</div>";
                    },
                    exportOptions: {
                        columns: ':visible'
                    }
                }
            ]
        });
        //
        $('.toggle-vis').on('click', function(e) {
            // Get the column API object
            var column = $('#statusid').dataTable().api().column($(this).attr('data-column'));
            // Toggle the visibility
            column.visible(!column.visible());
        });
    });
</script>
<div class="content-header">
    <div class="container-fluid">
        <div class="row mb-2">
            <div class="col-sm-6">
            </div>
            <!-- /.col -->
            <div class="col-sm-6">
            </div>
            <!-- /.col -->
        </div>
        <!-- /.row -->
        <div>
            <div class="row">
                <div class="dt-responsive table-responsive">
                    <div style="font-weight: 500;">
                        Show/Hide columns:
                        <input type="checkbox" class="toggle-vis" data-column="0" value="Sl#" checked /> Sl# &nbsp;&nbsp;
                        <input type="checkbox" class="toggle-vis" data-column="1" value="Name" checked /> Course Name &nbsp;&nbsp;
                        <input type="checkbox" class="toggle-vis" data-column="2" value="Designation" checked /> Venue name &nbsp;&nbsp;
                        <input type="checkbox" class="toggle-vis" data-column="3" value="Wing" checked /> Batch name &nbsp;&nbsp;
                        <input type="checkbox" class="toggle-vis" data-column="4" value="Category" checked /> Trainer name &nbsp;&nbsp;
                        <input type="checkbox" class="toggle-vis" data-column="5" value="Discipline" checked /> Designation &nbsp;&nbsp;
                        <input type="checkbox" class="toggle-vis" data-column="6" value="Cadre" checked /> Institute Name &nbsp;&nbsp;
                        <input type="checkbox" class="toggle-vis" data-column="7" value="Phone" checked /> PDS Id &nbsp;&nbsp;
                        <input type="checkbox" class="toggle-vis" data-column="8" value="E-mail" checked /> Mobile No &nbsp;&nbsp;
                        <input type="checkbox" class="toggle-vis" data-column="9" value="Joining" checked /> Email &nbsp;&nbsp;
                    </div>
                    <br>
                    <table id="statusid" class="table table-bordered">
                        <thead style="padding-bottom:20px;">
                            <tr style="font-weight:bold;">
                                <td style="font-size:15px;">#</td>
                                <td style="font-size:15px;"><strong>Course name</strong></td>
                                <td style="font-size:15px;"><strong>Venue name</strong></td>
                                <td style="font-size:15px;"><strong>Batch name</strong></td>
                                <td style="font-size:15px;"><strong>Trainer name</strong></td>
                                <td style="font-size:15px;"><strong>Designation</strong></td>
                                <td style="font-size:15px;"><strong>Institute Name</strong></td>
                                <td style="font-size:15px;"><strong>PDS Id</strong></td>
                                <td style="font-size:15px;"><strong>Mobile No</strong></td>
                                <td style="font-size:15px;"><strong>Email</strong></td>
                            </tr>
                        </thead>
                        <tbody>                            @foreach ($data as $all)
                            <tr>
                                <td>{{ $i++ }}</td>
                                <td>{{ $all->title }}</td>
                                <td>{{ $all->venue_name }}</td>
                                <td>{{ $all->batch_name }}</td>
                                <td>{{ $all->full_name }}</td>
                                <td>{{ $all->des_name }}</td>
                                <td>{{ $all->institute_name }}</td>
                                <td>{{ $all->emp_id }}</td>
                                <td>{{ $all->mobile_no }}</td>
                                <td>{{ $all->email }}</td>
                            </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
    <!-- /.container-fluid -->
</div>