@extends('layouts/app')
@section('content')
    <div class="content-header">
        <div class="container-fluid">
            <div class="row mb-2">
                <div class="col-sm-6">
                    <!-- <h1 class="m-0">Starter Page</h1> -->
                </div>
                <div class="col-sm-6">
                    <ol class="breadcrumb float-sm-right">
                        <li class="breadcrumb-item">Reports</li>
                        <li class="breadcrumb-item"><a href="{{ route('reports.endOfDayReport') }}">End Of Day</a></li>
                    </ol>
                </div>
            </div>
        </div>
    </div>
    <div class="content">
        <div class="container-fluid">
            <div class="row">
                <div class="col-12">
                    <div class="card">
                        <div class="container mt-3">
                            <form action="{{ route('reports.endOfDayReport') }}" method="post">
                                @csrf
                                <div class="row">
                                    <div class="col-sm">
                                        <div class="form-group">
                                            <label class="control-label">Region</label>
                                            <div class='input-group'>
                                                @php 
                                                    $region = Config('config.region.value'); 
                                                @endphp
                                                @if (Auth::user()->userIsHQBranchs())
                                                    <select class="form-control" id="region" name="region">
                                                        <option value="" selected>--All--</option>
                                                        @foreach ($region as $key => $rg)
                                                        <option value="{{ $key }}" {{ $key == ($_POST['region'] ?? '') ? 'selected' : '' }}>{{ $rg['name'] }}</option>
                                                        @endforeach
                                                    </select>
                                                @else
                                                    <select class="form-control" name="region">
                                                        @foreach ($branch_region as $key)
                                                        <option value="{{ $key }}" {{ $key == ($_POST['region'] ?? '') ? 'selected' : '' }}>{{ $region[$key]['name'] }}</option>
                                                        @endforeach
                                                    </select>
                                                @endif
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-sm">
                                        <div class="form-group">
                                            <label class="control-label">Branch</label>
                                            <div class='input-group'>
                                                @if (Auth::user()->userIsHQBranchs())
                                                    <select class="form-control" name="branch_id">
                                                        @if (!empty($branches))
                                                            <option value="" selected>--All--</option>
                                                            @foreach ($branches as $branch)
                                                                <option value="{{ $branch->id }}"
                                                                    {{ $branch->id == ($_POST['branch_id'] ?? '') ? 'selected' : '' }}>
                                                                    {{ $branch->code }}</option>
                                                            @endforeach
                                                        @endif
                                                    </select>
                                                @else
                                                    <select class="form-control" name="branch_id">
                                                        <option value="{{ Session::get('branch')->id }}">
                                                            {{ Session::get('branch')->code }}
                                                        </option>
                                                    </select>
                                                @endif
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-sm">
                                        <div class="form-group">
                                            <label class="control-label">From Date</label>
                                            <div class="input-group date datetimepicker" id="datetimepicker1">
                                                <input type='date' value="{{ $_POST['from_date'] ?? date('Y-m-d', strtotime('-1 month')) }}"
                                                    class="form-control" id="from_date" name="from_date" max="{{date('Y-m-d')}}"/>
                                                <span class="input-group-addon">
                                                    <span class="glyphicon glyphicon-calendar"></span>
                                                </span>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-sm">
                                        <div class="form-group">
                                            <label class="control-label">End Date</label>
                                            <div class="input-group date datetimepicker" id="datetimepicker2">
                                                <input type='date' value="{{ $_POST['end_date'] ?? date('Y-m-d') }}"
                                                    class="form-control" id="end_date" name="end_date" max="{{date('Y-m-d')}}"/>
                                                <span class="input-group-addon">
                                                    <span class="glyphicon glyphicon-calendar"></span>
                                                </span>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-sm">
                                        <div class="form-group">
                                            <label class="control-label">Select Terminal</label>
                                            <div class='input-group'>
                                                <select class="form-control" name="terminal_id">
                                                    @if (!empty($terminals))
                                                        <option value="" selected>--All--</option>
                                                        @foreach ($terminals as $terminal)
                                                            <option value="{{ $terminal }}"
                                                                {{ $terminal == ($_POST['terminal_id'] ?? '') ? 'selected' : '' }}>
                                                                {{ $terminal }}</option>
                                                        @endforeach
                                                    @endif
                                                </select>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-sm">
                                        <div class="form-group">
                                            <label class="control-label"><span class="right badge badge-light"><a
                                                        href="{{ route('reports.endOfDayReport') }}">clear <i
                                                            class="fa-solid fa-rotate-right"></i></a></span></label>
                                            <div class='input-group'>
                                                <button type="submit" class="btn btn-success">Show report</button>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-sm">
                                        <div class="form-group">
                                            <label class="control-label text-white">---</label>
                                            <div class='input-group'>
                                                <a href="{{ route('reports.downloadEndOfDayReport', [
                                                    'from_date' => $_POST['from_date'] ?? '',
                                                    'end_date' => $_POST['end_date'] ?? '',
                                                    'branch_id' => $_POST['branch_id'] ?? '',
                                                    'terminal_id' => $_POST['terminal_id'] ?? '',
                                                ]) }}"
                                                    class="btn btn-outline-success"><strong><i class="fa fa-file-excel-o"
                                                            aria-hidden="true"></i></strong>
                                                    Export </a>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </form>
                        </div>
                        @if (Session::has('error'))
                            <div class="alert alert-warning alert-dismissible">
                                <button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
                                <h5><i class="icon fas fa-check"></i> Note:</h5>
                                @foreach(Session::get('error') as $err)
                                    {{ $err }}<br>
                                @endforeach
                                @php
                                    Session::forget('error');
                                @endphp
                            </div>
                        @endif

                        <div class="card-body table-responsive p-0">
                            @if (!empty($reports))
                                <table class="table table-hover text-nowrap">
                                    <thead>
                                        <tr>
                                            <th>#</th>
                                            <th>Game</th>
                                            <th>No. of Ticket</th>
                                            <th>Amount</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @php $key = 0; @endphp
                                        @foreach ($reports as $game => $report)
                                        @if(isset($report->code)) 
                                            <tr>
                                                <td>{{ ++$key }}</td>
                                                <td>{{ $report->name }}</td>
                                                <td>{{ $report->number ?? 0 }}</td>
                                                <td>{{ number_format($report->amount,2,'.',',') ?? 0 }}</td>
                                            </tr>
                                        @else
                                            @if($game=='total') 
                                            <tr class="font-weight-bold">
                                                <td colspan="2">Total</td>
                                                <td>{{ $report['number'] }}</td>
                                                <td>{{ number_format($report['amount'],2,'.',',') ?? 0 }}</td>
                                            </tr>
                                            <tr>
                                                <td colspan="4"></td>
                                            </tr>
                                            @endif
                                            @if($game=='payment') 
                                            <tr class="font-weight-bold">
                                                <td colspan="2">Total Payment Success <sup>1</sup></td>
                                                <td>{{ $report[0]["count"] ?? 0 }}</td>
                                                <td>{{ number_format($report[0]["p_amount"] ?? 0,2,'.',',') }}</td>
                                            </tr>
                                            @endif
                                            @if($game=='refund') 
                                            <tr class="font-weight-bold">
                                                <td colspan="2">Total Payment Reject <sup>2</sup></td>
                                                <td>{{ $report[0]["count"] ?? 0 }}</td>
                                                <td>{{ number_format($report[0]["p_amount"] ?? 0,2,'.',',') }}</td>
                                            </tr>
                                            @endif
                                        @endif
                                        @endforeach
                                        <tr>
                                            <td colspan="4" class="small">Note:<br>
                                                Total Payment Success <sup>1</sup> = Payment Success from full or partial pick.<br>
                                                Total Payment Reject <sup>2</sup> = Payment Refund from full & partial pick, insufficient funds and number sold out.
                                            </td>
                                        </tr>
                                </tbody>
                                </table>
                            @else
                                <p class="text-center">No data found</p>
                            @endif
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    </div>
@endsection
@section('js')
<script nonce="{{ csp_nonce() }}">

    // $('input[name="from_date"]').on('change', function() {
    //     var value =  $(this).val();

    //     var today = new Date();
    //     var tyear = today.getFullYear();
    //     var tmonth = (today.getMonth() + 1).toString().padStart(2, '0');
    //     var tday = today.getDate().toString().padStart(2, '0');
    //     // let thisMonth = today.getMonth() + 1;
    //     var newDate = new Date(value);
    //     // let dateMonth = newDate.getMonth() + 1;
    //     newDate.setMonth(newDate.getMonth() + 1);
    //     // Format the date as 'Y-m-d'
    //     var year = newDate.getFullYear();
    //     var month = (newDate.getMonth() + 1).toString().padStart(2, '0'); // Adding 1 because months are 0-indexed
    //     var day = newDate.getDate().toString().padStart(2, '0');

    //     var formattedDate = year + '-' + month + '-' + day;
    //     var tformattedDate = tyear + '-' + tmonth + '-' + tday;

    //     fdate = $('#from_date').val();
    //     edate = $('#end_date').val();

    //     if(new Date(formattedDate) > new Date(tformattedDate)) {
    //         $('#end_date').val(tformattedDate);
    //     }
    //     else if((new Date(edate) > new Date(formattedDate)) || (new Date(edate) < new Date(fdate))) {
    //         $('#end_date').val(formattedDate);
    //     }

    //     // $('#end_date').attr("min", value);
    //     $('#end_date').attr("max", tformattedDate);
    // });

    // $('input[name="end_date"]').on('change', function() {
    //     var value =  $(this).val();

    //     var newDate = new Date(value);
    //     newDate.setMonth(newDate.getMonth() - 1);
    //     // Format the date as 'Y-m-d'
    //     var year = newDate.getFullYear();
    //     var month = (newDate.getMonth() + 1).toString().padStart(2, '0'); // Adding 1 because months are 0-indexed
    //     var day = newDate.getDate().toString().padStart(2, '0');

    //     var formattedDate = year + '-' + month + '-' + day;

    //     fdate = $('#from_date').val();
    //     edate = $('#end_date').val();
        
    //     if((new Date(fdate) < new Date(formattedDate)) || (new Date(edate) < new Date(fdate))) {
    //         $('#from_date').val(formattedDate);
    //     }
    // });

    $('select[name="branch_id"]').on('change', function() {
        var branch_id =  $(this).val();
        $.ajax({
            type: 'get',
            url: '{{ route('reports.getTerminalForBranch') }}',
            data: { 'branch_id': branch_id },
            dataType: 'json',
            success: function(data) {
                $('select[name="terminal_id"]').empty();
                $('select[name="terminal_id"]').html('<option value="">--All--</option>');
                $.each(data, function(key, value) {
                    $('select[name="terminal_id"]').append('<option value="'+ value +'" {{ '+ value +' == ($_POST["terminal_id"] ?? '') ? "selected" : "" }}>'+ value +'</option>');
                });
            }
        });
    });

    $('select[name="region"]').on('change', function() {
        var region =  $(this).val();
        $.ajax({
            type: 'get',
            url: '{{ route('reports.getBranchForRegion') }}',
            data: { 'region': region },
            dataType: 'json',
            success: function(data) {
                $('select[name="branch_id"]').empty();
                $('select[name="branch_id"]').html('<option value="">--All--</option>');
                $.each(data, function(key, value) {
                    $('select[name="branch_id"]').append('<option value="'+ value.id +'" {{ '+ value.id +' == ($_POST["branch_id"] ?? '') ? "selected" : "" }}>'+ value.code +'</option>');
                });
            }
        });
    });
</script>
@stop