@extends('layouts.admin')

@section('title', 'Hourly Report')
@section('content-header', 'Hourly 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">

                                        <h3 class="card-title">Hourly Report For {{$tittle}} on {{$date}}</h3>

                                </td>
                              <tr>
                                <th>Period</th>
                                <th>Receipt Count</th>
                                <th>Sale</th>
                                <th>Total Tax</th>
                                <th>Overall Sales</th>
                                <th>Total Cancelled Receipt</th>
                                <th>Overall Cancelled Sales</th>
                              </tr>
                            </tr>

                            </thead>
                            <tbody>
                              @php
                                  $k = 0;
                                  $overall_receipt = 0;
                                  $overall_cancel = 0;
                                  $overall_tax = 0;
                                  $overall_sale = 0;
                                  $overall_cancel_sale = 0;
                              @endphp
                              @foreach ($info as $infos)
                              @php
                                  $j = $start;
                                  $l = $end;
                                  $i = 0;
                              @endphp

                              <tr>

                                  <td colspan="8">{{$infos['BID']}} || {{$infos['Description']}}</td>

                              </tr>
                              @while ($j < $l)

                              <tr>
                                <td>{{$j}}->{{$j+1}}</td>
                                @if (isset($data[$k][$i]) && $data[$k][$i]->hour == $j)
                                    <td>{{$data[$k][$i]->count}}</td>
                                    <td>{{number_format(($data[$k][$i]->sub_total_sum - $data[$k][$i]->total_tax_sum),2)}}</td>
                                    <td>{{number_format($data[$k][$i]->total_tax_sum,2)}}</td>
                                    <td>{{number_format($data[$k][$i]->sub_total_sum,2)}}</td>
                                    <td>{{$data[$k][$i]->cancel_count}}</td>
                                    <td>{{number_format($data[$k][$i]->cancel_total_sum,2)}}</td>
                                    @php
                                    $overall_receipt += $data[$k][$i]->count;
                                    $overall_cancel += $data[$k][$i]->cancel_count;
                                    $overall_tax += number_format($data[$k][$i]->total_tax_sum,2);
                                    $overall_sale += $data[$k][$i]->sub_total_sum;
                                    $overall_cancel_sale += $data[$k][$i]->cancel_total_sum;
                                    $i++;
                                    @endphp
                                @else
                                    <td>-</td>
                                    <td>-</td>
                                    <td>-</td>
                                    <td>-</td>
                                    <td>-</td>
                                    <td>-</td>
                                @endif
                              </tr>

                              @php
                                  $j++;
                              @endphp
                              @endwhile
                              @php
                                  $k++;
                              @endphp
                              <tr>
                                <td colspan="8"></td>
                              </tr>
                              @endforeach

                            </tbody>
                            <tfoot>
                              <tr>
                                <td colspan="13"></td>
                              </tr>
                              <tr>
                                  <th></th>
                                  <th></th>

                              </tr>
                              <tr>
                                  <th>Overall Receipt</th>
                                  <th></th>
                                  <th>{{$overall_receipt}}</th>
                                  <th colspan="12"></th>
                              </tr>
                              <tr>
                                  <th>Overall Cancelled Receipt</th>
                                  <th></th>
                                  <th>{{$overall_cancel}}</th>
                                  <th colspan="12"></th>
                              </tr>
                              <tr>
                                  <th>Total Tax</th>
                                  <th></th>
                                  <th>{{$overall_tax}}</th>
                                  <th colspan="12"></th>
                              </tr>
                              <tr>
                                  <th>Total Sales</th>
                                  <th></th>
                                  <th>{{number_format($overall_sale,2)}}</th>
                                  <th colspan="12"></th>
                              </tr>
                              <tr>
                                  <th>Total Cancelled Sales</th>
                                  <th></th>
                                  <th>{{number_format($overall_cancel_sale,2)}}</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 = "hourlyreport.xlsx";
            XLSX.writeFile(wb, fileName);
        }


    </script>
@endsection