@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: 'Course Wise Report',
                    filename: 'Course Wise Report'
                },
                {
                    extend: 'csv',
                    messageTop: 'Course Wise Report',
                    filename: 'Course Wise Report'
                },
                {
                    extend: 'pdf',
                    messageTop: 'Course Wise Report',
                    filename: 'Course Wise Report',
                    title: 'Course Wise Report',
                    orientation: 'landscape',
                    pageSize: 'LEGAL'
                },
                {
                    extend: 'print',
                    title: function() {
                        var printTitle = 'Course Wise 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="Funded" checked /> Funded By &nbsp;&nbsp;
                        <input type="checkbox" class="toggle-vis" data-column="5" value="Fund" checked /> Budget &nbsp;&nbsp;
                        <input type="checkbox" class="toggle-vis" data-column="6" value="Duration" checked /> Duration &nbsp;&nbsp;
                        <input type="checkbox" class="toggle-vis" data-column="7" value="Totbatch" checked /> Total Batch &nbsp;&nbsp;
                        <input type="checkbox" class="toggle-vis" data-column="8" value="Sdate" checked /> Start Date &nbsp;&nbsp;
                        <input type="checkbox" class="toggle-vis" data-column="9" value="Edate" checked /> End Date &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>Funded By</strong></td>
                                <td style="font-size:15px;"><strong>Budget</strong></td>
                                <td style="font-size:15px;"><strong>Duration</strong></td>
                                <td style="font-size:15px;"><strong>Total Batch</strong></td>
                                <td style="font-size:15px;"><strong>Start Date</strong></td>
                                <td style="font-size:15px;"><strong>End Date</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->funded }}</td>
                                <td>{{ $all->fund }}</td>
                                <td>{{ $all->duration }}</td>
                                <td>{{ $all->total_batch }}</td>
                                <td>{{ DateFormatter::dtformat($all->started_at) }}</td>
                                <td>{{ DateFormatter::dtformat($all->ended_at) }}</td>
                            </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
    <!-- /.container-fluid -->
</div>