@extends('layouts.admin')

@section('title', 'Revenue Transaction Summary Report')
@section('content-header', 'Daily Revenue Summary Report')

@section('content')
<div class="container-fluid">
    <div class="row">
        <div class="col-12">
            <div class="card">
                <div class="card-header">
                    <h3 class="card-title">{{$tittle}}</h3>
                    <br>
                    <h3 class="card-title">{{$tittle2}}</h3>
                </div>
                <div class="card-body" style="overflow: auto">
                <button onclick="exportToExcel()">Export to Excel</button>

                    <table class="table table-bordered table-striped" id="TABLE1">
                    <thead> 
                        <tr>
                            <th>Branch ID</th>
                            @foreach ($coloumns as $col)
                            <th>{{$col}}</th>
                            @endforeach
                            <th>Total</th>
                        </tr>
                    </thead>
                    <tbody>
                        @php
                            $cal = 0;
                        @endphp
                        @foreach ($exceldata as $data)
                            <tr>
                                @foreach ($data as $info)
                                    <th>{{$info}}</th>
                                @endforeach
                                <th>{{$overall[$cal]}}</th>
                            </tr>
                            @php
                                $cal++;
                            @endphp
                        @endforeach

                    </tbody>
                    <tfoot>
                        <tr>
                            <th>Total</th>
                            @foreach ($total as $totaldata)
                            <th>{{$totaldata }}</th>
                            @endforeach
                        </tr>
                    </tfoot>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection
@section('js')
    <!-- DataTables  & Plugins -->
    <script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.17.1/xlsx.full.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
    <script src="//cdn.datatables.net/1.10.20/js/jquery.dataTables.min.js"></script>
    <script src="//cdn.datatables.net/buttons/1.6.1/js/dataTables.buttons.min.js"></script>
    <script src="//cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
    <script src="//cdn.datatables.net/buttons/1.6.1/js/buttons.html5.min.js"></script>
    <link href="//cdn.datatables.net/1.10.20/css/jquery.dataTables.min.css" rel="stylesheet"/>
    <script>
        $.ajaxSetup({
            headers: {
                'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
            }
        });

        function exportToExcel() {
    // Get the table element
    var table = document.getElementById("TABLE1");

    // Create a new workbook and sheet
    var wb = XLSX.utils.book_new();
    var ws = XLSX.utils.table_to_sheet(table);

    // Add the sheet to the workbook
    XLSX.utils.book_append_sheet(wb, ws, "Sheet1");

    // Define the file name based on the $type variable
    var fileName = "DailyRevenueReport.xlsx";
@if ($type == 'media')
    fileName = "DailyRevenueReportMedia.xlsx";
@else
    fileName = "DailyRevenueReportHour.xlsx";
@endif


    // Save the workbook as an Excel file
    XLSX.writeFile(wb, fileName);
}



    </script>
@endsection