@extends('layout.master')

@push('plugin-styles')
    <link href="{{ asset('assets/plugins/datatables-net/dataTables.bootstrap4.css') }}" rel="stylesheet" />
    <link href="{{ asset('assets/plugins/select2/select2.min.css') }}" rel="stylesheet" />
    <link href="{{ asset('assets/plugins/bootstrap-datepicker/bootstrap-datepicker.min.css') }}" rel="stylesheet" />
    <link href="{{ asset('css/app.css') }}" rel="stylesheet" />
@endpush

@section('content')
    {{-- <nav class="page-breadcrumb">
  <ol class="breadcrumb">
    <li class="breadcrumb-item"><a href="#">Forms</a></li>
    <li class="breadcrumb-item active" aria-current="page">Basic Elements</li>
  </ol>
</nav> --}}

    <div class="row">
        <div class="col-md-12 grid-margin stretch-card">
            <div class="card">
                <div class="card-header d-flex">
                    <div class="col-sm-8 mt-2">
                        <div class="btn-group">
                            @php
                                $mon = strtotime('last monday');
                                $monday = date('W', $mon) == date('W') ? $mon - 7 * 86400 : $mon;
                                $sunday = strtotime(date('Y-m-d', $monday) . ' +6 days');
                                $week_sd = date('Y-m-d', $monday);
                                $week_ed = date('Y-m-d', $sunday);
                                // die();
                            @endphp
                            <a href="{{ url('Tnover?type=1&from=' . date('Y-m-d', strtotime('-6 month')) . '&to=' . date('Y-m-d')) }}"
                                class="btn btn-outline-info {{ $_GET['type'] == 1 ? 'active' : '' }}">Last 6 Months</a>
                            <a href="{{ url('Tnover?type=2&from=' . date('Y-m-01') . '&to=' . date('Y-m-t')) }}"
                                class="btn btn-outline-info {{ $_GET['type'] == '2' ? 'active' : '' }}">Current Month</a>
                            <a href="{{ url('Tnover?type=3&from=' . date('Y-m-d', strtotime('first day of last month')) . '&to=' . date('Y-m-d', strtotime('last day of last month'))) }}"
                                class="btn btn-outline-info {{ $_GET['type'] == '3' ? 'active' : '' }}">Last Month</a>
                            <a href="{{ url('Tnover?type=4&from=' . $week_sd . '&to=' . $week_ed) }}"
                                class="btn btn-outline-info {{ $_GET['type'] == '4' ? 'active' : '' }}">Last Week</a>
                            <a href="{{ url('Tnover?type=5&from=' . date('Y-m-d', strtotime('last monday')) . '&to=' . date('Y-m-d', strtotime('+' . (7 - date('w')) . ' days'))) }}"
                                class="btn btn-outline-info {{ $_GET['type'] == '5' ? 'active' : '' }}">Current Week</a>
                            <a href="{{ url('Tnover?type=6&from=' . date('Y-m-d', strtotime('-1 day')) . '&to=' . date('Y-m-d', strtotime('-1 day'))) }}"
                                class="btn btn-outline-info {{ $_GET['type'] == '6' ? 'active' : '' }}">Yesterday</a>
                            <a href="{{ url('Tnover?type=7&from=' . date('Y-m-d') . '&to=' . date('Y-m-d')) }}"
                                class="btn btn-outline-info {{ $_GET['type'] == '7' ? 'active' : '' }}">Today</a>
                            <button type="button" class="btn btn-outline-info {{ $_GET['type'] == '8' ? 'active' : '' }}"
                                data-toggle="modal" data-target="#myModal">Date Range</button>
                        </div>
                        <button class="btn btn-primary" href="#" onclick="printDiv('visible-print')"><i
                                class="fa fa-print"></i>
                            Print</button>
                    </div>
                </div>

                <div class="card-body">
                    <div class="breadcrumb bg-light" id="live2">
                        <div class="col-sm-2 text-center">
                            Total Play Points<br> <span>{{ number_format($total['totalPlayPoints'], 2) }}</span>
                        </div>
                        <div class="col-sm-2 text-center">
                            Total Win Points <br> <span>{{ number_format($total['TotalWinPoints'], 2) }}
                                {{ $total['TotalWinPoints'] != 0
                                    ? '( ' . number_format(($total['TotalWinPoints'] / $total['totalPlayPoints']) * 100, 2) . '% )'
                                    : '' }}</span>
                        </div>
                        <div class="col-sm-2 text-center">
                            End Point <br>
                            <span>{{ number_format($total['EndPoint'], 2) }}{{ $total['EndPoint'] != 0 ? '( ' . number_format(($total['EndPoint'] / $total['totalPlayPoints']) * 100, 2) . '% )' : '' }}
                            </span>
                        </div>
                        @if (Session::get('role') != 'retailer')
                            <div class="col-sm-2 text-center">
                                Retailer Commission <br> <span>{{ number_format($total['retailerCommission'], 2) }}</span>
                            </div>
                            <div class="col-sm-2 text-center">
                                Profit <br>
                                <span>{{ number_format($total['EndPoint'] - $total['retailerCommission'], 2) }}</span>
                            </div>
                            <div class="col-sm-2 text-center">
                                Profit % <br>
                                <span>{{ $total['percentage'] }}</span>
                            </div>
                        @endif
                        {{-- <div class="col-sm-3 text-center">	
                            Total Commission <br> <span>{{number_format($total['TotalCommission']}}</span>
                </div> --}}
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div id="myModal" class="modal fade" role="dialog">
        <div class="modal-dialog modal-sm">
            <!-- Modal content-->
            <div class="modal-content">
                <div class="modal-header">
                    <h4 class="modal-title" id="myModalLabel">Game Summary</h4>
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span
                            aria-hidden="true">×</span></button>
                </div>
                <form action="{{ url('Tnover') }}" method="get">
                    <div class="modal-body">
                        <input type="hidden" name="type" value="8" />
                        From
                        <div class="input-group date datepicker" id="datePickerExample1">
                            <input type="text" class="form-control" name="from" placeholder="From"><span
                                class="input-group-addon"><i data-feather="calendar"></i></span>
                        </div>
                        To
                        <div class="input-group date datepicker" id="datePickerExample">
                            <input type="text" class="form-control" name="to" placeholder="To"><span
                                class="input-group-addon"><i data-feather="calendar"></i></span>
                        </div>
                    </div>
                    <div class="modal-footer">
                        <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
                        <button type="submit" class="btn btn-primary">Get Summary</button>
                    </div>
                </form>
            </div>
        </div>
    </div>
    <div class="row">
        <div class="col-md-12 grid-margin stretch-card">
            <div class="card">
                <div class="card-body">
                    <h6 class="card-title" style="text-transform: none !important;">TurnOver Player</h6>
                    <div class="table-responsive">
                        <table id="dataTableExample" class="table table-bordered">
                            <thead>
                                <tr>
                                    <th>Sl.No</th>
                                    <th>Username</th>
                                    <th>Distributer</th>
                                    <th>Credit</th>
                                    <th>Play Points</th>
                                    <th>Win Points</th>
                                    <th>End Point</th>
                                    @if (Session::get('role') != 'retailer')
                                        <th>Retailer Commission</th>
                                        <th>Profit</th>
                                        <th>Profit %</th>
                                    @endif
                                </tr>
                            </thead>
                            <tbody>
                                @php $no = 1 @endphp
                                @if (Session::get('role') == 'Admin' || Session::get('role') == 'distributer')
                                    @foreach ($data as $play)
                                        <tr>
                                            <td>{{ $no++ }}</td>
                                            <td>{{ $play['userName'] }}</td>
                                            <td>{{ $play['distributer'] }}</td>
                                            <td>{{ $play['credit'] }}</td>
                                            <td>{{ number_format($play['playPoint'], 2) }}</td>
                                            <td>{{ number_format($play['wonPoint'], 2) }}</td>
                                            <td>{{ number_format($play['endPoint'], 2) }}</td>
                                            <td>{{ number_format($play['retailerCommission'], 2) }}</td>
                                            <td>{{ number_format($play['endPoint'] - $play['retailerCommission'], 2) }}
                                            <td>{{ $play['percentage'] }}
                                            </td>
                                        </tr>
                                    @endforeach
                                @endif
                                @if (Session::get('role') == 'retailer')
                                    <tr>
                                        <td>{{ $no++ }}</td>
                                        <td>{{ $data['userName'] }}</td>
                                        <td>{{ $data['distributer'] }}</td>
                                        <td>{{ $data['credit'] }}</td>
                                        <td>{{ number_format($data['playPoint'], 2) }}</td>
                                        <td>{{ number_format($data['wonPoint'], 2) }}</td>
                                        <td>{{ number_format($data['endPoint'], 2) }}</td>
                                    </tr>
                                @endif
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <div class="visible-print" id="visible-print">
        <div class="col-sm-12">
            <h2 class="text-center">Diamond Casino</h2>
            <h3 class="text-center">Turnover Report</h3>
            <table class="table table-bordered datatable table-striped" id="tabler">
                <thead>
                    <tr>
                        <th>SL.No</th>
                        <th>Username</th>
                        <th>Play Points</th>
                        <th>Win Points</th>
                        <th>End Point</th>
                        <th>Type</th>
                    </tr>
                </thead>
                <tbody>
                    @php $no = 1 @endphp
                    @if (Session::get('role') == 'Admin')
                        @foreach ($data as $play)
                            <tr>
                                <td>{{ $no++ }}</td>
                                <td>{{ $play['userName'] }}</td>
                                <td>{{ $play['distributer'] }}</td>
                                <td>{{ number_format($play['playPoint'], 2) }}</td>
                                <td>{{ number_format($play['wonPoint'], 2) }}</td>
                                <td>{{ number_format($play['endPoint'], 2) }}</td>
                                <td>TN</td>
                            </tr>
                        @endforeach
                    @endif
                    @if (Session::get('role') == 'retailer')
                        <tr>
                            <td>{{ $no++ }}</td>
                            <td>{{ $data['userName'] }}</td>
                            <td>{{ number_format($data['playPoint'], 2) }}</td>
                            <td>{{ number_format($data['wonPoint'], 2) }}</td>
                            <td>{{ number_format($data['endPoint'], 2) }}</td>
                            <td>TN</td>
                        </tr>
                    @endif
                </tbody>
            </table>
            <table class="table table-bordered mt-3">
                <tbody>
                    <tr>
                        <td>Total PlayPoints</td>
                        <td>Total WinPoints</td>
                        <td>End Point</td>
                    </tr>
                    <tr>
                        <td>{{ number_format($total['totalPlayPoints'], 2) }}</td>
                        <td>{{ number_format($total['TotalWinPoints'], 2) }}</td>
                        <td>{{ number_format($total['EndPoint'], 2) }}</td>
                    </tr>
                </tbody>
            </table>
        </div>
    </div>

@endsection

@push('plugin-scripts')
    <script src="{{ asset('assets/plugins/promise-polyfill/polyfill.min.js') }}"></script>
    <script src="{{ asset('assets/plugins/datatables-net/jquery.dataTables.js') }}"></script>
    <script src="{{ asset('assets/plugins/datatables-net-bs4/dataTables.bootstrap4.js') }}"></script>
    <script src="{{ asset('assets/plugins/bootstrap-datepicker/bootstrap-datepicker.min.js') }}"></script>
    <script src="{{ asset('assets/plugins/select2/select2.min.js') }}"></script>
    <script src="{{ asset('assets/plugins/tempusdominus-bootstrap-4/tempusdominus-bootstrap-4.js') }}"></script>
@endpush

@push('custom-scripts')
    <script src="{{ asset('assets/js/select2.js') }}"></script>
    <script src="{{ asset('assets/js/datepicker.js') }}"></script>
    <script src="{{ asset('assets/js/data-table.js') }}"></script>
    <script type="text/javascript">
        $("#datePickerExample").datepicker();
        $("#datePickerExample1").datepicker();
        $(document).ready(function() {
            startTime();

            function startTime() {
                var today = new Date();
                var h = today.getHours();
                var m = today.getMinutes();
                var s = today.getSeconds();
                m = checkTime(m);
                s = checkTime(s);
                $('#clock').html(h + ":" + m + ":" + s);
                setTimeout(startTime, 1000);
            }

            function checkTime(i) {
                if (i < 10) {
                    i = "0" + i
                }; // add zero in front of numbers < 10
                return i;
            }
        });
    </script>
    <script type="text/javascript">
        function printDiv(divName) {
            var printContents = document.getElementById(divName).innerHTML;
            var originalContents = document.body.innerHTML;
            document.body.innerHTML = printContents;
            window.print();
            document.body.innerHTML = originalContents;
        }
    </script>
@endpush