@extends('admin.layout.page-app')
@section('page_title', __('label.transactions'))
@section('tab_title', __('label.transactions'))

@section('content')
    @include('admin.layout.sidebar')

    <div class="right-content">
        @include('admin.layout.header')

        <!-- Select2 -->
        <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.13/css/select2.min.css" />

        <div class="body-content">
            <!-- mobile title -->
            <h1 class="page-title-sm">{{__('label.transactions')}}</h1>

            <div class="border-bottom row mb-3">
                <div class="col-sm-10">
                    <ol class="breadcrumb">
                        <li class="breadcrumb-item"><a href="{{ route('admin.dashboard') }}">{{__('label.dashboard')}}</a></li>
                        <li class="breadcrumb-item active" aria-current="page">{{__('label.transactions')}}</li>
                    </ol>
                </div>
                <div class="col-sm-2 d-flex align-items-center justify-content-end">
                    <a href="{{ route('admin.transaction.create') }}" class="btn btn-default mw-120" style="margin-top:-14px">{{__('label.add_transaction')}}</a>
                </div>
            </div>

            <!-- Earning Cards -->
            <div class="row mb-3">
                <div class="col-sm-12 col-md-6 col-lg-4">
                    <div class="card-earning">
                        <div class="card-align">
                            <div>
                                <p class="earning-amount">{{ Currency_Code() }} {{ $today_sum['total_price'] ?? 00 }}</p>
                                <p class="earning-title">{{__('label.total_transactions_today')}}</p>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-sm-12 col-md-6 col-lg-4">
                    <div class="card-earning">
                        <div class="card-align">
                            <div>
                                <p class="earning-amount">{{ Currency_Code() }} {{ $month_sum['total_price'] ?? 00 }}</p>
                                <p class="earning-title">{{__('label.total_transactions_month')}}</p>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-sm-12 col-md-6 col-lg-4">
                    <div class="card-earning">
                        <div class="card-align">
                            <div>
                                <p class="earning-amount">{{ Currency_Code() }} {{ $year_sum['total_price'] ?? 00 }}</p>
                                <p class="earning-title">{{__('label.total_transactions_year')}}</p>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

            <!-- Search -->
            <div class="page-search mb-3">
                <div class="input-group">
                    <div class="input-group-prepend">
                        <span class="input-group-text" id="basic-addon1"><i class="fa-solid fa-magnifying-glass fa-xl"></i></span>
                    </div>
                    <input type="text" id="input_search" class="form-control" placeholder="{{__('label.search')}}" aria-label="Search" aria-describedby="basic-addon1">
                </div>
                <div class="sorting mr-2 w-75">
                    <label>{{__('label.sort_by')}}</label>
                    <select class="form-control" name="input_user" id="input_user">
                        <option value="0" selected>{{__('label.all_users')}}</option>
                        @for ($i = 0; $i < count($user); $i++) 
                            <option value="{{ $user[$i]['id'] }}" @if(isset($_GET['input_user'])){{ $_GET['input_user'] == $user[$i]['id'] ? 'selected' : ''}} @endif>
                                {{ $user[$i]['user_name'] }} | {{ $user[$i]['full_name'] }}
                            </option>
                        @endfor
                    </select>
                </div>
                <div class="sorting mr-2 w-50">
                    <select class="form-control" name="input_package" id="input_package">
                        <option value="0" selected>{{__('label.all_package')}}</option>
                        @for ($i = 0; $i < count($package); $i++) 
                            <option value="{{ $package[$i]['id'] }}" @if(isset($_GET['input_package'])){{ $_GET['input_package'] == $package[$i]['id'] ? 'selected' : ''}} @endif>
                                {{ $package[$i]['name'] }}
                            </option>
                        @endfor
                    </select>
                </div>
                <div class="sorting w-25">
                    <select class="form-control" id="input_type">
                        <option value="all">{{__('label.all_type')}}</option>
                        <option value="today">{{__('label.today')}}</option>
                        <option value="month">{{__('label.month')}}</option>
                        <option value="year">{{__('label.year')}}</option>
                    </select>
                </div>
            </div>

            <div class="table-responsive table">
                <table class="table table-striped text-center table-bordered" id="datatable">
                    <thead>
                        <tr>
                            <th>{{__('label.#')}}</th>
                            <th>{{__('label.users')}}</th>
                            <th>{{__('label.packages')}}</th>
                            <th>{{__('label.price')}}</th>
                            <th>{{__('label.coin')}}</th>
                            <th>{{__('label.transaction_id')}}</th>
                            <th>{{__('label.date')}}</th>
                            <th>{{__('label.action')}}</th>
                        </tr>
                    </thead>
                    <tbody></tbody>
                    <tfoot>
                        <tr>
                            <td colspan="3" class="text-right"></td>
                            <td class="text-center"></td>
                            <td class="text-center"></td>
                            <td colspan="3" class="text-center"></td>
                        </tr>
                    </tfoot>
                </table>
            </div>
        </div>
    </div>
@endsection

@section('pagescript')
    <!-- Select2 -->
    <script src="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.13/js/select2.min.js"></script>

    <script>
        $("#input_user").select2();

        $(document).ready(function() {
            var table = $('#datatable').DataTable({
                ...dataTableDefaults,
                ajax: {
                    url: "{{ route('admin.transaction.index') }}",
                    data: function(d) {
                        d.input_search = $('#input_search').val();
                        d.input_user = $('#input_user').val();
                        d.input_package = $('#input_package').val();
                        d.input_type = $('#input_type').val();
                    },
                },
                columns: [
                    { data: 'DT_RowIndex', name: 'DT_RowIndex', orderable: false, searchable: false },
                    {
                        data: 'user',
                        name: 'user',
                        render: function(data, type, row) {                            
                            return `<div style="text-align: left;">${data.user_name || ''}<br><span style="font-size: 14px; font-weight: 600;">${data.full_name || ''}</span>`;
                        }
                    },
                    {
                        data: 'package',
						name: 'package',
						render: function(data) {
                            return data ? data.name : "-";
                        }
					},
                    {
						data: 'price',
						name: 'price',
						render: function(data) {
                            return `<span style="font-size: 18px; font-weight: 600;" class="primary-color">${data || 0}</span>`;
                        }
					},
                    {
						data: 'coin',
						name: 'coin',
						render: function(data) {
                            return `<span style="font-size: 18px; font-weight: 600;" class="primary-color">${data || 0}</span>`;
                        }
					},
                    {
                        data: 'transaction_id',
                        name: 'transaction_id',
                        orderable: false,
                        searchable: false,
                        render: function(data) {
                            return data ? data : "-";
                        }
                    },
                    {
                        data: 'date',
                        name: 'date',
                        render: function(data) {
                            return data ? data : "-";
                        }
                    },
                    {
                        data: 'action',
                        name: 'action',
                        orderable: false,
                        searchable: false
                    },
                ],
                footerCallback: function ( row, data, start, end, display ) {
                    var api = this.api(), data;

                    // converting to interger to find total
                    var intVal = function ( i ) {
                        return typeof i === 'string' ? i.replace(/[\$,]/g, '')*1 : typeof i === 'number' ? i : 0;
                    };

                    // computing column Total of the complete result 
                    var price = api.column(3).data()
                        .reduce( function (a, b) {
                            return intVal(a) + intVal(b);
                        }, 0 );
                    var coin = api.column(4).data()
                        .reduce( function (a, b) {
                            return intVal(a) + intVal(b);
                        }, 0 );

                    // Update footer by showing the total with the reference of the column index
                    $(api.column(1).footer() ).html("<span style='font-size: 18px; font-weight: 600;' class='primary-color'>{{__('label.total')}}</span>");
                    $(api.column(3).footer() ).html("<span style='font-size: 18px; font-weight: 600;' class='primary-color'>{{Currency_Code() }}"+ " " + price + "</span>");
                    $(api.column(4).footer() ).html("<span style='font-size: 18px; font-weight: 600;' class='primary-color'>"+ coin + "</span>");
                },
            });

            $('#input_type, #input_package, #input_user').change(function() {
                table.draw();
            });
            $('#input_search').keyup(function() {
                table.draw();
            });
        });
    </script>
@endsection