@extends('layouts.admin')

@section('title', 'Summary Report')
@section('content-header', 'Summary Report')
@section('content-actions')
@endsection

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

                        <table class="table table-bordered table-striped" id="example1">
                            <thead>
                            <tr>
                                @php
                                    if ($sub_order_list->count() > 0){
                                        $rowspan_1 = 3;
                                        $rowspan_2 = 2;
                                    }else{
                                        $rowspan_1 = 2;
                                        $rowspan_2 = 1;
                                    }
                                @endphp
                                <th rowspan="{{ $rowspan_1 }}">Branch ID</th>
                                <th rowspan="{{ $rowspan_1 }}">Description</th>
                                <th rowspan="{{ $rowspan_1 }}">Base License (RM)</th>
                                <th rowspan="{{ $rowspan_2 }}" colspan="{{ count($date) + 3 }}" style="background: #00a87d">Sales Collection</th>
                                <th rowspan="{{ $rowspan_2 }}" colspan="3" style="background: #ff94ca">{{ $period_type }} Order Type Sales</th>
                                <th rowspan="{{ $rowspan_1 }}" style="background: #feff94">Hutong Delivery</th>
                                @if ($sub_order_list->count() > 0)
                                    <th colspan="{{ (count($sub_order_list)*2) }}" style="background: #feff94">{{ $period_type }} Deduction</th>
                                @endif
                                <th rowspan="{{ $rowspan_2 }}" colspan="10" style="background: #7ae6ff">{{ $period_type }} Sales Refund To Tenant</th>
                            </tr>

                            @if ($sub_order_list->count() > 0)
                            <tr>
                                <th colspan="{{ count($sub_order_list) }}" style="background: #feff94">Tenant Income - Delivery Sales W/O GTO (60%)</th>
                                <th colspan="{{ count($sub_order_list) }}" style="background: #ff8379">Hutong Income - Delivery Sales W/O GTO (40%)</th>
                            </tr>
                            @endif

                            <tr>
                                @foreach ($date as $key => $value)
                                    <th style="background: #00a87d">{{ date('d/m/Y D', strtotime($value)) }} (RM)</th>
                                @endforeach
                                <th style="background: #00a87d">Total Sales</th>
                                <th style="background: #00a87d">{{ $period_type }} Hutong Tissue (RM)</th>
                                <th style="background: #00a87d">Total {{ $period_type }} Sales (RM)</th>

                                <th style="background: #ff94ca">{{ $period_type }} Dine-In (RM)</th>
                                <th style="background: #ff94ca">{{ $period_type }} Take Away (RM)</th>
                                <th style="background: #ff94ca">{{ $period_type }} Delivery (RM)</th>

                                @foreach ($sub_order_list as $list )
                                    <th style="background: #feff94">{{$list->sub_order_type}} Tenant</th>
                                @endforeach

                                @foreach ($sub_order_list as $list )
                                    <th style="background: #ff8379">{{$list->sub_order_type}} Delivery</th>
                                @endforeach

                                <th style="background: #7ae6ff">Nett GTO Sales For Tenants (RM)</th>
                                <th style="background: #7ae6ff">Percentage Age On GTO (%)</th>
                                <th style="background: #7ae6ff">Tenants Charges (RM)</th>
                                <th style="background: #7ae6ff">Hutong GTO Charges (RM)</th>
                                <th style="background: #7ae6ff">95% On Hutong Delivery (RM)</th>
                                <th style="background: #7ae6ff">Take Away Bio Bag (RM)</th>
                                <th style="background: #7ae6ff">Total RM</th>
                                <th style="background: #7ae6ff">Pro-Rated Base License (RM)</th>
                                <th style="background: #7ae6ff">Total Deduction (RM)</th>
                                <th style="background: #7ae6ff">Amount Payable (RM)</th>
                            </tr>
                            </thead>
                            <tbody>
                            @foreach ($data_1 as $key_1 => $value_1)
                                <tr>
                                    <td>{{ $value_1['BID'] }}</td>
                                    <td>{{ $value_1['Description'] }}</td>
                                    <td>{{ $value_1['base_license'] }}</td>
                                    @foreach ($date as $id => $day)
                                        <td>{{ $value_1[$day.'_sales_collection'] }}</td>
                                    @endforeach
                                    <td>{{ $value_1['total_sales'] }}</td>
                                    <td>{{ $value_1['weekly_tissue_sales'] }}</td>
                                    <td>{{ $value_1['weekly_sales_collection'] }}</td>

                                    <td>{{ $value_1['weekly_dine_in_sales_collection'] }}</td>
                                    <td>{{ $value_1['weekly_take_away_sales_collection'] }}</td>
                                    <td>{{ $value_1['weekly_delivery_sales_collection'] }}</td>

                                    <td>{{ $value_1['sub_order_delivery_default'] }}</td>
                                    {{--Tenant--}}
                                    @foreach ($sub_order_list as $list )
                                        @if(empty($value_1['sub_order_delivery']['data_1'][$list->sub_order_type]))
                                            <td>0</td>
                                        @else
                                            <td>{{ $value_1['sub_order_delivery']['data_1'][$list->sub_order_type] }}</td>
                                        @endif
                                    @endforeach
                                    {{--Delivery--}}
                                    @foreach ($sub_order_list as $list )
                                        @if(empty($value_1['sub_order_delivery']['data_2'][$list->sub_order_type]))
                                            <td>0</td>
                                        @else
                                            <td>{{ $value_1['sub_order_delivery']['data_2'][$list->sub_order_type] }}</td>
                                        @endif
                                    @endforeach

                                    <td>{{ $value_1['nett_gto_sales_for_tenants'] }}</td>
                                    <td>{{ $value_1['percentage_gto'] }}</td>
                                    <td>{{ $value_1['tenants_charges'] }}</td>
                                    <td>{{ $value_1['merchant_charges'] }}</td>
                                    <td>{{ $value_1['95_merchant_delivery'] }}</td>
                                    <td>{{ $value_1['weekly_plastic_sales'] }}</td>
                                    <td>{{ $value_1['total_sales_refund'] }}</td>
                                    <td>{{ $value_1['pro_rated_base_license'] }}</td>
                                    <td>{{ $value_1['total_deduction'] }}</td>
                                    <td>{{ $value_1['amount_payable'] }}</td>
                                </tr>
                            @endforeach
                            </tbody>
                            <tfoot>
                            <tr>
                                <th>Net Sales</th>
                                <th></th>
                                <th>{{ $total_base_license }}</th>
                                @foreach ($data_2 as $value_2)
                                    <th>{{ $value_2['net_sales'] }}</th>
                                @endforeach
                                <th>{{ $data_3['total_net_sales'] }}</th>
                                <th>{{ $data_3['total_weekly_tissue_sales'] }}</th>
                                <th>{{ $data_3['total_period_sales'] }}</th>

                                <th>{{ $data_3['total_weekly_dine_in_sales_collection'] }}</th>
                                <th>{{ $data_3['total_weekly_take_away_sales_collection'] }}</th>
                                <th>{{ $data_3['total_weekly_delivery_sales_collection'] }}</th>

                                <td>{{ $data_3['sub_order_delivery_total_default'] }}</td>

                                {{--Tenant--}}
                                @foreach ($sub_order_list as $list )
                                    @if(empty($data_3['sub_order_delivery_total']['data_1'][$list->sub_order_type]))
                                        <td>0</td>
                                    @else
                                        <td>{{ $data_3['sub_order_delivery_total']['data_1'][$list->sub_order_type] }}</td>
                                    @endif
                                @endforeach
                                {{--Delivery--}}
                                @foreach ($sub_order_list as $list )
                                    @if(empty($data_3['sub_order_delivery_total']['data_2'][$list->sub_order_type]))
                                        <td>0</td>
                                    @else
                                        <td>{{ $data_3['sub_order_delivery_total']['data_2'][$list->sub_order_type] }}</td>
                                    @endif
                                @endforeach

                                <th>{{ $data_3["total_nett_gto_sales_for_tenants"] }}</th>
                                <th>0</th>
                                <th>{{ $data_3['total_tenant_charges'] }}</th>
                                <th>{{ $data_3['total_merchant_charges'] }}</th>
                                <th>{{ $data_3['total_95_merchant_delivery'] }}</th>
                                <th>{{ $data_3['total_weekly_plastic_sales'] }}</th>
                                <th>{{ $data_3['grand_total_sales_refund'] }}</th>

                                <th>0</th>
                                <th>0</th>
                                <th>{{ $data_3['total_amount_payable'] }}</th>
                            </tr>
                            <tr>
                                <th>Total Tissue Sales</th>
                                <th></th>
                                <th></th>
                                @foreach ($data_2 as $value_2)
                                    <th>{{ $value_2['tissue_sales'] }}</th>
                                @endforeach
                                <th>{{ $data_3['total_weekly_tissue_sales'] }}</th>
                                <th>0</th>
                                <th>0</th>
                                <th colspan="23"></th>
                            </tr>
                            <tr>
                                <th>Total Hutong Sales</th>
                                <th></th>
                                <th></th>
                                @foreach ($data_2 as $value_2)
                                    <th>{{ $value_2['total_net_tissue_sales'] }}</th>
                                @endforeach
                                <th>{{ $data_3['total_period_sales'] }}</th>
                                <th>0</th>
                                <th>0</th>
                                <th colspan="23"></th>
                            </tr>
                            <tr>
                                <th>6% Service Tax</th>
                                <th></th>
                                <th></th>
                                @foreach ($data_2 as $value_2)
                                    <th>{{ $value_2['sst6'] }}</th>
                                @endforeach
                                <th>{{ $data_3['total_tax6'] }}</th>
                                <th>0</th>
                                <th>0</th>
                                <th colspan="23"></th>
                            </tr>
                            <tr>
                                <th>8% Service Tax</th>
                                <th></th>
                                <th></th>
                                @foreach ($data_2 as $value_2)
                                    <th>{{ $value_2['sst8'] }}</th>
                                @endforeach
                                <th>{{ $data_3['total_tax8'] }}</th>
                                <th>0</th>
                                <th>0</th>
                                <th colspan="23"></th>
                            </tr>
                            <tr>
                                <th>Total Service Tax</th>
                                <th></th>
                                <th></th>
                                @foreach ($data_2 as $value_2)
                                    <th>{{ $value_2['tax'] }}</th>
                                @endforeach
                                <th>{{ $data_3['total_tax'] }}</th>
                                <th>0</th>
                                <th>0</th>
                                <th colspan="23"></th>
                            </tr>
                            <tr>
                                <th>Service Charge</th>
                                <th></th>
                                <th></th>
                                @foreach ($data_2 as $value_2)
                                    <th>{{ $value_2['total_service_charge'] }}</th>
                                @endforeach
                                <th>{{ $data_3['total_weekly_service_charge'] }}</th>
                                <th>0</th>
                                <th>0</th>
                                <th colspan="23"></th>
                            </tr>
                            <tr>
                                <th>Add/(Less): Round Up Adjustment</th>
                                <th></th>
                                <th></th>
                                @foreach ($data_2 as $value_2)
                                    <th>{{ $value_2['rounding'] }}</th>
                                @endforeach
                                <th>{{ $data_3['total_rounding'] }}</th>
                                <th>0</th>
                                <th>0</th>
                                <th colspan="23"></th>
                            </tr>
                            <tr>
                                <th>Total Sales</th>
                                <th></th>
                                <th></th>
                                @foreach ($data_2 as $value_2)
                                    <th>{{ $value_2['total_sales'] }}</th>
                                @endforeach
                                <th>{{ $data_3['grand_total_sales'] }}</th>
                                <th>0</th>
                                <th>0</th>
                                <th colspan="23"></th>
                            </tr>
                            <tr>
                                <th></th>
                                <th></th>
                                <th></th>
                                @foreach ($date as $key => $value)
                                    <th></th>
                                @endforeach
                                <th></th>
                                <th colspan="25"></th>
                            </tr>
                            <tr>
                                <th>Payment Summary:-</th>
                                <th></th>
                                <th></th>
                                @foreach ($date as $key => $value)
                                    <th></th>
                                @endforeach
                                <th></th>
                                <th colspan="25"></th>
                            </tr>
                            @foreach ($data_4 as $value_4)
                                <tr>
                                    <th>{{ $value_4['media_type'] }}</th>
                                    <th></th>
                                    <th></th>
                                    @foreach ($date as $key => $value)
                                        <th>{{ $value_4[$value."_payment_summary"] }}</th>
                                    @endforeach
                                    <th>{{ $value_4['total_payment_summary'] }}</th>
                                    <th colspan="25"></th>
                                </tr>
                            @endforeach
                            <tr>
                                <th>Total Collections</th>
                                <th></th>
                                <th></th>
                                @foreach ($data_2 as $value_2)
                                    <th>{{ $value_2['total_collection_sales'] }}</th>
                                @endforeach
                                <th>{{ $data_3['total_collection'] }}</th>
                                <th colspan="25"></th>
                            </tr>
                            </tfoot>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection

@section('js')
    <!-- DataTables  & Plugins -->
{{--    <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 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
            const table = document.getElementById("example1");

            // Create a new workbook and sheet
            const wb = XLSX.utils.book_new();
            const 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
            const fileName = "Summary_Report.xlsx";
            XLSX.writeFile(wb, fileName);
        }

        <!-- Page specific script -->
        // $(function () {
        //     $('#example1').DataTable({
        //         dom: 'Bfrtip',
        //         buttons: [
        //             {
        //                 extend: 'excel',
        //                 footer: true,
        //                 customize: function (xlsx) {
        //                     var sheet = xlsx.xl.worksheets['sheet1.xml'];
        //                     var footerIndex = $('sheetData row', sheet).length;
        //                     var $footerRows = $('tr', '#example1 tfoot');
        //
        //                     // If there are more than one footer rows
        //                     if ($footerRows.length > 1) {
        //                         // First header row is already present, so we start from the second row (i = 1)
        //                         for (var i = 1; i < $footerRows.length; i++) {
        //                             // Get the current footer row
        //                             var $footerRow = $footerRows[i];
        //
        //                             // Get footer row columns
        //                             var $footerRowCols = $('th', $footerRow);
        //
        //                             // Increment the last row index
        //                             footerIndex++;
        //
        //                             // Create the new header row XML using footerIndex and append it at sheetData
        //                             $('sheetData', sheet).append(
        //                                 '<row r="' + footerIndex + '">' +
        //                                 $footerRowCols.map(function (index, el) {
        //                                     return '<c t="inlineStr" r="' + String.fromCharCode(65 + index) + footerIndex + '" s="2">' +
        //                                         '<is>' +
        //                                         '<t xml:space="default">' + $(el).text() + '</t>' +
        //                                         '</is>' +
        //                                         '</c>';
        //                                 }).get().join('') +
        //                                 '</row>'
        //                             );
        //                         }
        //                     }
        //                 }
        //             }
        //         ]
        //     });
        // });

    </script>
@endsection