@extends('admin.layouts.app')

@section('content')
    <div class="container">
        <style>
        .card{
            border: none;
            box-shadow: var(--cs);
        }
        button.badge{
            border: unset;
        }
        </style>
        <div class="card mt-4">
            <div class="card-body">
                @if(session('success'))
                <div class="alert alert-success">
                    {{ session('success') }}
                    </div>
                @endif
                @if(session('error'))
                    <div class="alert alert-danger">
                        {{ session('error') }}
                    </div>
                @endif
                <div class="w-100 d-flex align-items-center justify-content-between mb-3">
                    <h1 class="main-tittel mb-0">Ticket List</h1>
                  
                </div>
        
        <table class="table table-striped data-table user-ticket-listing">
            {{-- <button class="delete_records">Delete</button> --}}
            <thead>
                <tr>
                    {{-- <th>Check All <input type="checkbox" class='checkall' id='checkall'><input type="button" id='delete_record' value='Delete' ></th> --}}
                    <th>SL NO</th>
                    <th>Ticket No</th>
                    <th>Ticket Date</th>
                    <th>Draw Date</th>
                    <th>Result</th>
                    <th>Claim Amount</th>
                </tr>
            </thead>
            <tbody>
                @foreach ($tickets as $ticket)
                    @php     
                        $ticket_sequences = App\Models\TicketSequence::where('ticket_detail_id', $ticket->id)->get();
                        $result_publish = App\Models\ResultPublish::where('game_id', $ticket->game_id)->first();
                        $result_numbers = App\Models\ResultPublishDetail::where('result_publish_id', $result_publish->id)->get();
                        
                        $totalMatchingNumbersCount = 0;
        
                        foreach ($ticket_sequences as $sequence) {
                            $winningNumbers = explode(',', $sequence->winning_sequence);
                            $matchingNumbersCount = 0;
        
                            foreach ($winningNumbers as $winningNumber) {
                                $matchingNumber = App\Models\WinningNumber::where('number', $winningNumber)->first();
                                if ($matchingNumber) {
                                    $matchingNumbersCount++;
                                }
                            }
        
                            $totalMatchingNumbersCount += $matchingNumbersCount;
                        }
        
                        $description = [];
                        $amount = [];
                        foreach($result_numbers as $number){
                            if($number->number_range == $totalMatchingNumbersCount) {
                                $description[] = $number->description;
                                $amount[] = $number->amount;
                            }
                        }
        
                    @endphp
                    <tr>
                        <td>{{ $loop->iteration }}</td>
                        <td>{{ @$ticket->ticket_code }}</td>
                        <td>{{ @$ticket->created_at->format('Y-m-d') }}</td>
                        <td>{{ getGameDetailById($ticket->game_id, 'game_draw_date')}}</td>
                        <td>
                          @php
                          $game = getGameDetailById($ticket->game_id, 'result_publish');
                          @endphp
                        @if ($game == 1)
                            Published
                        @else
                            Waiting
                        @endif
                      </td>
                    <td>
                        @if (count($amount) > 0 && $game == 1)
                            @foreach ($amount as $amnt)
                                $ {{ $amnt }}<br>
                            @endforeach
                        @elseif (count($amount) == 0 && $game == 1)
                            No Amount Available
                        @else
                            $ 0
                        @endif
                    </td>
                        
                    </tr>
                @endforeach
            </tbody>
        </table>
    </div>
    </div>
</div>
    @push('scripts')
    <link rel="stylesheet" href="https://cdn.datatables.net/v/dt/jqc-1.12.4/dt-1.13.5/b-2.4.1/sl-1.7.0/datatables.min.css"/>
    <link rel="stylesheet" href="Editor-2.2.2/css/editor.dataTables.css">
    
    <script src="https://cdn.datatables.net/v/dt/jqc-1.12.4/dt-1.13.5/b-2.4.1/sl-1.7.0/datatables.min.js"></script>
    <script src="Editor-2.2.2/js/dataTables.editor.js"></script>

    {{-- <script src="https://cdn.datatables.net/v/dt/jqc-1.12.4/dt-1.13.5/b-2.4.1/sl-1.7.0/datatables.min.js"></script> --}}
    {{-- <script src="https://cdn.datatables.net/select/1.3.3/js/dataTables.select.min.js"></script>  --}}
    <script>
        $('.user-ticket-listing').DataTable();
    </script>


    @endpush
@endsection