@extends('layouts.admin')

@section('title', 'Revenue Tax Summary Report')
@section('content-header', 'Revenue Tax 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">{{$Date}}</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>Outlet</th> <th>Without Tissue
        </th> <th>With Tissue</th>
        <th>Total Tissue</th>
        <th>Without Tissue + Tax</th>
        <th>Without Tax</th>
        <th>6%</th>
        <th>8%</th>
        <th>Total Item Tax</th>
        <th>Actual Tax Amount</th>
        <th>Rounding</th>
        <th>Without Tax + Total Item Tax</th>



        </thead>
        <tbody>
        @foreach ($exceldata as $data)
        <tr>
            <th>{{$data['oid']}}</th>
            <th>{{$data['b_tissue']}}</th>
            <th>{{$data['w_tissue']}}</th>
            <th>{{$data['total_tissue']}}</th>
            <th>{{$data['tissue_tax']}}</th>
            <th>{{$data['b_tax']}}</th>
            <th>{{$data['sst6']}}</th>
            <th>{{$data['sst8']}}</th>
            <th>{{$data['total_item_tax']}}</th>
            <th>{{$data['actual_tax']}}</th>
            <th>{{$data['rounding']}}</th>
            <th>{{$data['b_tax+total_tax']}}</th>

            </tr>
            @endforeach
        <tr>
            <th>Summary</th>
            <th>{{$overalexceldata['b_tissue']}}</th>
            <th>{{$overalexceldata['w_tissue']}}</th>
            <th>{{$overalexceldata['total_tissue']}}</th>
            <th>{{$overalexceldata['tissue_tax']}}</th>
            <th>{{$overalexceldata['b_tax']}}</th>
            <th>{{$overalexceldata['t6']}}</th>
            <th>{{$overalexceldata['t8']}}</th>
            <th>{{$overalexceldata['total_item_tax']}}</th>
            <th>{{$overalexceldata['actual_tax']}}</th>
            <th>{{$overalexceldata['rounding']}}</th>
            <th>{{$overalexceldata['b_tax+total_tax']}}</th>
        </tr>
        <tr>
        <th></th>
        </tr>
        </tbody>
        <tfoot>

        <tr>

        </tr>
        <tr>
        <th>Media Type</th>
        @foreach ($mediaexcel as $data)
        @if (array_key_exists('media_type', $data) && $data['media_type'] !== null)
        <th>{{$data['media_type']}}</th>
        @endif
        @endforeach
        <th>Summary</th>
        </tr>
        <tr>
        <th>Before Tax</th>
        @foreach ($mediaexcel as $data)
        @if ($data['b_tax'] !==0)
        <th>{{$data['b_tax']}}</th>
        @endif
        @endforeach
        <th>{{$overallmediaexcel['b_tax']}}</th>
        </tr>
        <tr>
        <th>After Tax</th>
        @foreach ($mediaexcel as $data)
        @if ($data['w_tax'] !== 0)
        <th>{{$data['w_tax']}}</th>
        @endif
        @endforeach
        <th>{{$overallmediaexcel['w_tax']}}</th>
        </tr>
        <tr>
        <th>6% Tax</th>
        @foreach ($mediaexcel as $data)
        @if ($data['sst6'] !== 0)
        <th>{{$data['sst6']}}</th>
        @endif
        @endforeach
        <th>{{$overallmediaexcel['T6']}}</th>
        </tr>
        <tr>
        <tr>
        <th>8% Tax</th>
        @foreach ($mediaexcel as $data)
        @if ($data['sst8'] !== 0)
        <th>{{$data['sst8']}}</th>
        @endif
        @endforeach
        <th>{{$overallmediaexcel['T8']}}</th>
        </tr>
        <tr>
        <tr>
        <th>Total Item Tax</th>
        @foreach ($mediaexcel as $data)
        @if ($data['total_tax'] !== 0)
        <th>{{$data['total_tax']}}</th>
        @endif
        @endforeach
        <th>{{$overallmediaexcel['total_tax']}}</th>
        </tr>
        <tr>
        <th>Rounding</th>
        @foreach ($mediaexcel as $data)
        @if ($data['rounding'] !== 0)
        <th>{{$data['rounding']}}</th>
        @endif
        @endforeach
        <th>{{$overallmediaexcel['rounding']}}</th>
        </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");

            // Save the workbook as an Excel file
            var fileName = "TaxReport.xlsx";
            XLSX.writeFile(wb, fileName);
        }


    </script>
@endsection