@extends('layouts.admin')

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

@section('content')
    <div class="container-fluid">
        <div class="row">
            <div class="col-12">
                <div class="card">
                    <div class="card-header">

                    </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>
                                <td colspan="13">
                                    @if($status == 'succ')
                                        <h3 class="card-title">Transaction Report Summary
                                                || {{ $fromDate }}->{{ $toDate }} || SUCCESS</h3>
                                    @elseif($status == 'all')
                                        <h3 class="card-title">Transaction Report Summary
                                            || {{ $fromDate }}->{{ $toDate }} || ALL</h3>
                                    @elseif($status == 'cann')
                                        <h3 class="card-title">Transaction Report Summary
                                                || {{ $fromDate }}->{{ $toDate }} || CANCELLED</h3>
                                    @endif
                                </td>
                            </tr>
                            <tr>

                                <th>Receipt No</th>
                                <th>Receipt Type</th>
                                <th>Date & Time</th>
                                <th>Sub Total (RM)</th>
                                <th>Media Type</th>
                                <th>Status</th>


                            </tr>
                            </thead>
                            <tbody>
                            @php
                                $count = 0;
                                $spending = 0;
                            @endphp
                            @foreach($receipt_data as $receipt)

                                <tr>
                                    <td colspan="13"><strong>{{$receipt[0]->BID}}</strong></td>
                                </tr>

                                @foreach($receipt as $key => $detail)
                                    @php

                                        if($detail->extra4 == 'DI'){
                                        $order = 'Dine In';
                                        }else if($receipt[0]->extra4 == 'DL'){
                                        $order = 'Delivery';
                                        }else{
                                        $order = 'Take Away';
                                        }
                                    @endphp
                                    @if($key > 0) <!-- Skip the first element -->
                                        <tr>
                                            <td>{{ $detail->receipt_no }}</td>
                                            <td>{{ $order }}</td>
                                            <td>{{ $detail->c_dd }}</td>
                                            <td>{{ $detail->sub_total}}</td>
                                            <td>{{ $detail->media_type}}</td>

                                            @if($detail->cancel_flag == 1)

                                                <td>CANCELLED</td>


                                            @else

                                                <td>SUCCEEDED</td>

                                            @endif

                                            @php
                                            $spending += $detail->sub_total;
                                            $count++;
                                            @endphp
                                        </tr>
                                    @endif
                                @endforeach
                            @endforeach
                            </tbody>
                            <tfoot>



                            <tr>
                              <td colspan="13"></td>
                            </tr>


                            <tr>
                                <th>Total Receipt</th>
                                <th></th>
                                <th>{{ $count}}</th>
                                <th colspan="12"></th>
                            </tr>
                            </tfoot>
                        </table>
                    </div>
                    <br>

                </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 = "transactionSummaryReport.xlsx";
            XLSX.writeFile(wb, fileName);
        }


    </script>

@endsection