@extends('layouts.admin')

@section('title', 'Revenue Transaction Summary Report')
@section('content-header', 'Revenue Transaction 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>
                                    Department
                                </th>
                                @foreach ($data as $outlet)
                                    <th>{{$outlet['oid']}}</th>
                                @endforeach
                            </tr>
                        </thead>
                        <tbody>
                            
                        @if ($format == 'detailed')

                           <!-- departmet sale -->
                           @php
                            $uniqueDepartmentTypes = [];
                            @endphp

                             @foreach ($data as $datas ) 
                            @php
                                $p = 0;
                            @endphp
                            
                                    @foreach ($datas['Category'] as $category)
                                        @if (!in_array($category, $uniqueDepartmentTypes))
                                            @if ($category != '-')

                                                <tr>
                                                    <th>{{$category}}</th>
                                                    @foreach ($data as $branch)
                                                        <th>
                                                            @php
                                                                $p = array_search($category, $branch['Category']);
                                                            @endphp
                                                            @if ($p !== false)
                                                                {{ $branch['payment'][$p] }}
                                                            @else
                                                                0
                                                            @endif
                                                        </th>
                                                    @endforeach
                                                </tr>
                                                @php
                                                    $uniqueDepartmentTypes[] = $category;
                                                    $p++;
                                                @endphp
                                            @endif
                                        @endif

                                    @endforeach
                              

                            
                            @endforeach

                       
                            <tr>
                                <th>Tissue</th>
                                @foreach ($tissue as $tis)
                                    <th>{{$tis}}</th>
                                @endforeach
                            </tr>
                            <tr>
                                <th></th>
                            </tr>
                       
                            <!-- for summary sale -->
                            <tr>
                                <th>Overall Summary</th>
                            </tr>
                            <tr>
                                <th>Period Total</th>
                                @php
                                    $p = 0;
                                @endphp
                                @foreach ($data as $outlet)
                                    <th>{{$data[$p]['Period']}}</th>
                                    @php
                                        $p++;
                                    @endphp
                                @endforeach
                            </tr>
                            <tr>
                                <th>Difference</th>
                                @php
                                    $p = 0;
                                @endphp
                                @foreach ($data as $outlet)
                                    <th>{{$data[$p]['Difference']}}</th>
                                    @php
                                        $p++;
                                    @endphp
                                @endforeach
                            </tr>
                            <tr>
                                <th>6% Tax</th>
                                @php
                                    $p = 0;
                                @endphp
                                @foreach ($data as $outlet)
                                    <th>{{$data[$p]['sst6']}}</th>
                                    @php
                                        $p++;
                                    @endphp
                                @endforeach
                            </tr>
                            <tr>
                                <th>8% Tax</th>
                                @php
                                    $p = 0;
                                @endphp
                                @foreach ($data as $outlet)
                                    <th>{{$data[$p]['sst8']}}</th>
                                    @php
                                        $p++;
                                    @endphp
                                @endforeach
                            </tr>
                            <tr>
                                <th>Service Tax</th>
                                @php
                                    $p = 0;
                                @endphp
                                @foreach ($data as $outlet)
                                    <th>{{$data[$p]['Tax']}}</th>
                                    @php
                                        $p++;
                                    @endphp
                                @endforeach
                            </tr>
                            <tr>
                                <th>Total Amount</th>
                                @php
                                    $p = 0;
                                @endphp
                                @foreach ($data as $outlet)
                                    <th>{{$data[$p]['TotalAmount']}}</th>
                                    @php
                                        $p++;
                                    @endphp
                                @endforeach
                            </tr>
                            <tr>
                                <th>Total Receipt</th>
                                @php
                                    $p = 0;
                                @endphp
                                @foreach ($data as $outlet)
                                    <th>{{$data[$p]['TotalReceipt']}}</th>
                                    @php
                                        $p++;
                                    @endphp
                                @endforeach
                            </tr>
                            <tr>
                                <th>Average Per Receipt</th>
                                @php
                                    $p = 0;
                                @endphp
                                @foreach ($data as $outlet)
                                    <th>{{$data[$p]['AverageReceipt']}}</th>
                                    @php
                                        $p++;
                                    @endphp
                                @endforeach
                            </tr>
                        @endif
                            <tr>
                                <th></th>
                            </tr>
                        
                             <!-- for payment summary -->
                             <tr>
                                <th>Payment Summary</th>
                            </tr>
                             @php
                            $uniquePaymentTypes = [];
                            @endphp

                             @foreach ($data as $datas ) 
                            @php
                                $p = 0;
                            @endphp
                            

                                    @foreach ($datas['paymenttype'] as $pt)
                                        @if (!in_array($pt, $uniquePaymentTypes))
                                            @if ($pt != '-')

                                                <tr>
                                                    <th>{{$pt}}</th>
                                                    @foreach ($data as $branch)
                                                        <th>
                                                            @php
                                                                $p = array_search($pt, $branch['paymenttype']);
                                                            @endphp
                                                            @if ($p !== false)
                                                                {{ $branch['paymenttotal'][$p] }}
                                                            @else
                                                                0
                                                            @endif
                                                        </th>
                                                    @endforeach
                                                </tr>
                                                @php
                                                    $uniquePaymentTypes[] = $pt;
                                                    $p++;
                                                @endphp
                                            @endif
                                        @endif

                                    @endforeach
                               
                            @endforeach
                            <tr>
                                <th>Total Payment</th>
                                @foreach ($payment as $pay)
                                    <th>{{$pay}}</th>
                                @endforeach
                            </tr>
                            <tr>
                                <th></th>
                            </tr>

                              <!-- for delivery summary -->
                              <tr>
                                <th>Delivery Summary</th>
                            </tr>
                            @php
                            $uniqueDeliveryTypes = [];
                            @endphp

                             @foreach ($data as $datas ) 
                            @php
                                $p = 0;
                            @endphp
                            
                            @foreach ($datas['deliverytype'] as $pd)
                                @if (!in_array($pd, $uniqueDeliveryTypes))
                                    <tr>
                                        <th>{{$pd}}</th>
                                        @foreach ($data as $branch)
                                            <th>
                                                @php
                                                    $p = array_search($pd, $branch['deliverytype']);
                                                @endphp
                                                @if ($p !== false)
                                                    {{ $branch['deliverytotal'][$p] }}
                                                @else
                                                    0
                                                @endif
                                            </th>
                                        @endforeach
                                    </tr>
                                    @php
                                        $uniqueDeliveryTypes[] = $pd;
                                        $p++;
                                    @endphp
                                @endif
                            @endforeach
                            @endforeach
                            <tr>
                                <th>Total Delivery</th>
                                @foreach ($delivery as $deli)
                                    <th>{{$deli}}</th>
                                @endforeach
                            </tr>
                        </tbody>
                       
                    </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 = "RevenueReport.xlsx";
            XLSX.writeFile(wb, fileName);
        }


    </script>
@endsection