@extends('admin.layouts.app')
@section('section')
    <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.25/css/jquery.dataTables.min.css">
    <div class="content-wrapper">
        <section class="content-header">
            <div class="container-fluid">
                <div class="row mb-2">
                    <div class="col-sm-6">
                        <h1>User Payments</h1>
                    </div>
                    <div class="col-sm-6">
                        <ol class="breadcrumb float-sm-right">
                            <li class="breadcrumb-item"><a href="{{ url('admin/dashboard') }}">Home</a></li>
                            <li class="breadcrumb-item active">User Payments</li>
                        </ol>
                    </div>
                </div>
            </div><!-- /.container-fluid -->
        </section>
        <section class="content">
            <div class="container-fluid">
                <div class="row">
                    <div class="col-12">

                        <!-- /.card -->

                        <div class="card">
                            <div class="card-header" style="text-align: right;">
                            </div>
                            <div class="col-md-12">

                            </div>

                            <!-- /.card-header -->
                            <div class="card-body">
                                <table id="myTable" class="display">
                                    <thead>
                                    <tr>
                                        <th>Estimation ID</th>
                                        <th>Name</th>
                                        <th>Email</th>
                                        <th>Service</th>
                                        <th>Payment Type</th>
                                        <th>Service Total Payment</th>
                                        <th>Transaction Amount</th>
                                        <th>Remaining Amount</th>
                                        <th>Status</th>
                                        <th>Transaction Date</th>
                                    </tr>
                                    </thead>
                                    <tbody>
                                    @foreach($payments as $payment)
                                        <tr>
                                            <td>{{$payment->estimation->id}}</td>
                                            @if($payment->estimation->user)
                                                <td>{{$payment->estimation->user->name ?? ''}}</td>
                                                <td>{{$payment->estimation->user->email ?? ''}}</td>
                                            @else
                                                @php
                                                    $user = DB::table('users')->where('email', $payment->estimation->email)->first();
                                                @endphp
                                                <td>{{$user->name ?? ''}}</td>
                                                <td>{{$user->email ?? ''}}</td>
                                            @endif

                                            <td>
                                                @if($payment->estimation->services->count() > 1 || $payment->estimation->others != null)
                                                    multiple
                                                @elseif($payment->estimation->services->count() == 1)
                                                    {{$payment->estimation->services->first()->title ?? ''}}
                                                @endif
                                            </td>

                                            <td>{{$payment->payment_type ?? ''}}</td>
                                            @foreach($payment->estimation->emailUser->where('type', '==', 'userPayment') as $email)
                                                @php
                                                    $serviceTotalFees = json_decode($email->content)
                                                @endphp
                                                <td>${{$serviceTotalFees->serviceTotalFees ?? ''}}</td>
                                            @endforeach
                                            <td>${{$payment->payment_transaction ?? ''}}</td>

                                            @foreach($payment->estimation->emailUser->where('type', '==', 'userPayment') as $email)
                                                @php
                                                    $serviceTotalFees = json_decode($email->content)
                                                @endphp

                                                <td>
                                                    @if($payment->payment_type == 'remaining_payment')
                                                    ${{$serviceTotalFees->serviceAdvanceFees - $payment->payment_transaction ?? ''}}
                                                    @else
                                                    ${{$serviceTotalFees->serviceTotalFees - $payment->payment_transaction ?? ''}}
                                                    @endif
                                                </td>
                                            @endforeach

                                            <td>{{$payment->status ?? ''}}</td>
                                            <td>{{$payment->created_at->diffForHumans() ?? ''}}</td>
                                        </tr>
                                    @endforeach

                                    </tbody>
                                </table>
                            </div>
                            <!-- /.card-body -->
                        </div>
                        <!-- /.card -->
                    </div>
                    <!-- /.col -->
                </div>
                <!-- /.row -->
            </div>
            <!-- /.container-fluid -->
        </section>
        <div class="modal fade" id="deleteModal" tabindex="-1" role="dialog" aria-labelledby="deleteModalLabel"
             aria-hidden="true">
            <div class="modal-dialog" role="document">
                <div class="modal-content">
                    <div class="modal-header">
                        <h5 class="modal-title" id="deleteModalLabel">Confirm Deletion</h5>
                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                            <span aria-hidden="true">&times;</span>
                        </button>
                    </div>
                    <div class="modal-body">
                        Are you sure you want to delete this estimation request?
                    </div>
                    <div class="modal-footer">
                        <button type="button" class="btn btn-secondary" data-dismiss="modal">Cancel</button>
                        <form method="get" action="{{ route('estimated_request.destroy', ':id') }}" id="deleteForm">
                            @csrf
                            <button type="submit" class="btn btn-danger">Delete</button>
                        </form>
                    </div>
                </div>
            </div>
        </div>


    </div>
@endsection
@section('script')
    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
    <script src="https://cdn.datatables.net/1.10.25/js/jquery.dataTables.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/sweetalert2@11"></script>
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/sweetalert2@11/dist/sweetalert2.min.css">
    <script type="text/javascript">
        $(document).ready(function () {
            $('#myTable').DataTable();
        });
    </script>

    <script>
        @if (session('success'))
        Swal.fire({
            icon: 'success',
            title: '{{ session('success') }}',
            showConfirmButton: false,
            timer: 3000
        });
        @endif

        @if (session('error'))
        Swal.fire({
            icon: 'error',
            title: '{{ session('error') }}',
            showConfirmButton: false,
            timer: 3000
        });
        @endif
    </script>

    <script>
        $(document).ready(function () {
            // When the delete button is clicked
            $('.delete-button').click(function (e) {
                e.preventDefault();

                var estimationId = $(this).data('estimation-id');
                $('#deleteForm').attr('action', "{{ route('estimated_request.destroy', ':id') }}".replace(':id', estimationId));
            });
        });
    </script>

@endsection