@extends('layouts.admin')

@section('title', 'IT Transaction Report')
@section('content-header', 'IT Transaction 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="17">
                                    @php
                                        $date = new \DateTime();
                                    @endphp              
                                    <h3 class="card-title">{{$tittle}} || Printed on {{$date->format('Y-m-d H:i:s')}} By {{$by}}</h3>
                                  
                                </td>
                            </tr>
                            <tr>
                                @foreach ($column as $column)
                                <th>{{$column}}</th>
                                @endforeach
                                
                            </tr>
                            </thead>
                            @php
                            $overall_success = 0;
                            $overall_cancelled = 0;
                            @endphp
                            <tbody>
                           
                            @foreach($data as $info)
                
                                <tr>
                                    <td colspan="17"><strong>{{$info[0]->BID}}</strong></td>
                                </tr>
                                
                                @foreach($info as $key => $detail)
                                    @if($key > 0) <!-- Skip the first element -->
                                        @if($type == 'transaction')
                                            <tr>
                                                <td>{{ $detail->receipt_no }}</td>
                                                <td>{{ $detail->order_type ?? "-"}}</td>
                                                <td>{{ $detail->cashier_no}} - {{ $detail->cashier_name}}</td>
                                                <td>{{ $detail->date}}</td>
                                                <td>{{ $detail->reg}}</td>
                                                <td>{{ $detail->oid}}</td>
                                                <td>{{ $detail->total_subtotal}}</td>
                                                <td>{{ $detail->voucher_amt ?? 0}}</td>
                                                <td>{{ $detail->total_subtotal -  $detail->voucher_amt}}</td>
                                                <td>{{ $detail->tax_amt}}</td>
                                                <td>{{ $detail->SST6}}</td>
                                                <td>{{ $detail->SST8}}</td>

                                                <td>{{ $detail->media_type}}</td>
                                                <td>
                                                    {{ $detail->cancel_status }}
                                                    @php
                                                        if ($detail->cancel_status == 'success') {
                                                            $overall_success++;
                                                        } else if ($detail->cancel_status == 'cancelled') {
                                                            $overall_cancelled++;
                                                        }
                                                    @endphp
                                                </td>
                                                <td>{{ $detail->tissue_quantity ?? 0}}</td>
                                                <td>{{ $detail->plastic_quantity ?? 0}}</td>
                                                <td>{{ $detail->cutlery_quantity ?? 0}}</td>
                                                <td>{{ $detail->item_quantity ?? 0}}</td>
                                                <td>0</td>
                                                <td>{{ $detail->total_subtotal - $detail->tax_amt}}</td>
                                            </tr>
                                        @elseif($type == 'item')
                                            @foreach($detail as $item)
                                            <tr>
                                                <td>{{ $item->receipt_no }}</td>
                                                <td>{{ $item->sku_id }}</td>
                                                <td>{{ $item->sku_desc }}</td>
                                                <td>{{ $item->extra5 }}</td>
                                                <td>{{ $item->sell_price }}</td>
                                                <td>
                                                    @if ($item->cancel_flag == 0)
                                                        Successful
                                                    @else
                                                        Cancelled
                                                    @endif
                                                    @php
                                                        if ($item->cancel_flag == 0) {
                                                            $overall_success++;
                                                        } else {
                                                            $overall_cancelled++;
                                                        }
                                                    @endphp
                                                </td>
                                                <td>{{ $item->quantity }}</td>
                                                <td>{{ $item->amt }}</td>
                                                <td>{{ $item->tax_code }}</td>
                                                <td>{{ $item->tax_amt }}</td>
                                                <td>{{ $item->amt - $item->tax_amt }}</td>
                                            </tr>
                                            @endforeach
                                        @elseif($type == 'card')
                                            @foreach($detail as $item)
                                                <tr>
                                                    <td>{{ $item->receipt_no }}</td>
                                                    <td>{{ $item->media_no}}</td>
                                                    <td>{{ $item->media_type}}</td>
                                                    <td>{{ $item->media_refno ?? "-"}}</td>
                                                    <td>{{ $item->amt}}</td>
                                                    <td>
                                                        @if ($item->cancel_flag == 0)
                                                            Successful
                                                        @else
                                                            Cancelled
                                                        @endif
                                                        @php
                                                            if ($item->cancel_flag == 0) {
                                                                $overall_success++;
                                                            } else {
                                                                $overall_cancelled++;
                                                            }
                                                        @endphp
                                                    </td>
                                                </tr>
                                            @endforeach
                                        @elseif($type == 'voucher')
                                            @foreach($detail as $item)
                                                <tr>
                                                    <td>{{ $item->receipt_no }}</td>
                                                    <td>{{ $item->partBeforeHyphen}}</td>
                                                    <td>{{ $item->partAfterHyphen}}</td>
                                                    <td>{{ $item->amt}}</td>
                                                    <td>
                                                        @if ($item->cancel_flag == 0)
                                                            Successful
                                                        @else
                                                            Cancelled
                                                        @endif
                                                        @php
                                                            if ($item->cancel_flag == 0) {
                                                                $overall_success++;
                                                            } else {
                                                                $overall_cancelled++;
                                                            }
                                                        @endphp
                                                    </td>
                                                </tr>
                                            @endforeach
                                        @elseif($type == 'delivery')
                                            @foreach($detail as $item)
                                                <tr>
                                                    <td>{{ $item->receipt_no }}</td>
                                                    <td>{{ $item->extra6}}</td>
                                                    <td>{{ $item->sub_total}}</td>
                                                    <td>
                                                        @if ($item->cancel_flag == 0)
                                                            Successful
                                                        @else
                                                            Cancelled
                                                        @endif
                                                        @php
                                                            if ($item->cancel_flag == 0) {
                                                                $overall_success++;
                                                            } else {
                                                                $overall_cancelled++;
                                                            }
                                                        @endphp
                                                    </td>
                                                </tr>
                                            @endforeach
                                        @endif
                                    @endif
                                @endforeach
                            @endforeach
                            </tbody>
                            <tfoot>
                            <tr>
                                <td colspan="13"></td>
                              </tr>
                              <tr>
                                  <th></th>
                                  <th></th>

                              </tr>
                              <tr>
                                  <th>Total Success Receipt</th>
                                  <th></th>
                                  <th>{{$overall_success}}</th>
                                  <th colspan="12"></th>
                              </tr>
                              <tr>
                                  <th>Total Failed Receipt</th>
                                  <th></th>
                                  <th>{{$overall_cancelled}}</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 = "{{$tittle}}.xlsx";
            XLSX.writeFile(wb, fileName);
        }


    </script>

@endsection