@extends('layouts.adminapp')

@section('content')
    {{-- Student Fund --}}

    <div class="container-fluid px-4">

        <h2 class="mt-4">
            Student Fund Report
        </h2>
        <form action="">
            {{-- <form action="{{ route('StudentFundSearch') }}" method="get"> --}}
            <div class="card-body p-5">
                <div class="row">
                    {{-- <div class="col-md-6 mb-3">
                        <label for="FromDate" class="form-label"> {{ __('lng.FromDate') }}:</label>
                        <input type="date" class="form-control @error('dob') border-red-600 @enderror" name="FromDate"
                            id="FromDate" value="{{ date('Y-m-d H:i') }}" />
                        <button type="reset" class="btn btn-secondary mt-2">
                            {{ __('lng.Clear') }}
                        </button>
                    </div>
                    <div class="col-md-6 mb-3">
                        <label for="ToDate" class="form-label"> {{ __('lng.Todate') }}:</label>
                        <input type="date" class="form-control @error('dob') border-red-600 @enderror" name="ToDate"
                            id="ToDate" value="{{ date('Y-m-d H:i') }}" />
                    </div> --}}
                    <div class="col-md-6 mb-3">
                        <label for="search_transaction" class="form-label">Transaction Type:</label>
                        <select class="form-select" name="search_transaction" id="search_transaction">
                            <option value="all">{{ __('lng.All') }}</option>
                            <option value="deposit" {{ old('search_transaction') == 'deposit' ? 'selected' : '' }}>Deposit
                            </option>
                            <option value="withdraw" {{ old('search_transaction') == 'withdraw' ? 'selected' : '' }}>
                                Withdraw</option>
                        </select>
                    </div>
                    <div class="col-md-6 mb-3">
                        <label for="BatchId" class="form-label"> {{ __('lng.Batch') }}:</label>
                        <select class="form-select @error('completebatchcourse_id') border-red-600 @enderror" id="BatchId"
                            name="BatchID" required onchange="changeBatch(this.value)">
                            <option value="all" selected>{{ __('lng.All') }}</option>
                            @foreach (\App\Models\Batch::all() as $Batch)
                                <option value="{{ $Batch->id }}">{{ $Batch->title }}</option>
                            @endforeach
                        </select>

                        @error('batch_id')
                            <span class="text-xs text-red-700" id="passwordHelp">{{ $message }}</span>
                        @enderror
                    </div>
                    <div class="col-md-6 mb-3">
                        <label for="StudentID" class="form-label"> {{ __('lng.Student') }}:</label>
                        <select class="form-select @error('completebatchcourse_id') border-red-600 @enderror" id="StudentID"
                            name="StudentID" required>
                            <option value="all" selected>{{ __('lng.All') }}</option>
                            @foreach ($Students as $Student)
                                <option value="{{ $Student->id }}">{{ $Student->name }} -
                                    ({{ __('lng.AdmNo') }}: {{ $Student->admission_no }})
                                </option>
                            @endforeach
                        </select>
                        @error('batch_id')
                            <span class="text-xs text-red-700" id="passwordHelp">{{ $message }}</span>
                        @enderror
                    </div>
                </div>
                <div class="d-flex justify-content-center mt-3">
                    <button type="button" onclick="Search()" class="btn btn-primary">
                        {{ __('lng.Search') }}
                    </button>
                </div>


            </div>
        </form>
        <div class="card mb-4">
            <div class="card-header shadow">
                <div class="card-body">
                    <div id="search_tbl">
                        <table class="table table-bordered table-hover">
                            <thead>
                                <tr>
                                    <th>Si No</th>
                                    <th>Admission No</th>
                                    <th>Name</th>
                                    <th>Date</th>
                                    <th>Donation</th>
                                    <th>Withdraw</th>
                                    <th>Narration</th>
                                </tr>
                            </thead>
                            <tbody>
                                @php $si = 0; @endphp
                                @forelse ($StudentFunds as $StudentFund)
                                    <tr>
                                        <td>
                                            {{ ++$si }}
                                        </td>
                                        <td>
                                            {{ $StudentFund->Student->admission_no ?? '' }}
                                        </td>
                                        <td>
                                            {{ $StudentFund->Student->name ?? '' }}
                                        </td>
                                        <td>
                                            @if ($StudentFund->date)
                                                {{ date('d-m-Y', strtotime($StudentFund->date)) }}
                                            @endif
                                        </td>
                                        <td>
                                            {{ $StudentFund->inAmount }}
                                        </td>
                                        <td>
                                            {{ $StudentFund->outAmount }}
                                        </td>
                                        <td>
                                            {{ $StudentFund->narration }}
                                        </td>
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="6" style="color:red;"><strong>No Match Found!</strong></td>
                                    </tr>
                                @endforelse
                            </tbody>
                            <tfoot>
                                <tr>
                                    <th colspan="4">Total:</th>
                                    <th>{{ $TotalDeposit }}</th>
                                    <th>{{ $TotalWithdraw }}</th>
                                    <th></th>
                                </tr>
                                <tr>
                                    <th colspan="4">Grand Total:</th>
                                    <th colspan="2" class="text-center">{{ $TotalAmount }} {{ $Journal }}</th>
                                    <th></th>
                                </tr>
                            </tfoot>
                        </table>

                        <div class="d-flex justify-content-end mt-3">
                            <form action="{{ route('StudentFundPrint') }}" method="POST">
                                @csrf
                                {{-- <input type="hidden" name="FromDate" value="{{ $FromDate }}">
                            <input type="hidden" name="ToDate" value="{{ $ToDate }}"> --}}
                                <input type="hidden" name="StudentID"
                                    value="{{ $StudentID !== null ? $StudentID : 'all' }}">
                                <input type="hidden" name="BatchID" value="{{ $BatchID !== null ? $BatchID : 'all' }}">
                                <input type="hidden" name="search_transaction" value="{{ $Transaction ?? 'all' }}">
                                <button type="submit" class="btn btn-sm btn-outline-primary">
                                    <i class="fas fa-print"></i>
                                    {{ __('lng.Print') }}
                                </button>
                            </form>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <script>
        var All = '{{ __('lng.All') }}';

        function Search() {
            // var FromDate = document.getElementById("FromDate").value;
            // var ToDate = document.getElementById("ToDate").value;
            var BatchID = document.getElementById("BatchId").value;
            var StudentID = document.getElementById("StudentID").value;
            var searchTransaction = document.getElementById("search_transaction").value;

            $.ajax({
                method: "get",
                url: '{{ route('StudentFundSearch') }}',
                data: {
                    // FromDate: FromDate,
                    // ToDate: ToDate,
                    BatchID: BatchID,
                    StudentID: StudentID,
                    search_transaction: searchTransaction
                },
                success: function(response) {
                    document.getElementById('search_tbl').innerHTML = response;
                }
            });
        }

        function changeBatch(BatchId) {
            $.ajax({
                method: "get",
                url: '{{ url('StudentListWithBatchForCombo') }}' + '/' + BatchId + '/' + 'all',
                success: function(response) {
                    document.getElementById('StudentID').innerHTML = '<option value="all">' + All +
                        '</option>' +
                        response;
                }
            });
        }
    </script>
@endsection