@extends('layouts.app')
@section('title', 'Student Ledger')
@section('content')
    <div class="container">
        <div class="page-breadcrumb d-flex align-items-center mb-2 border-bottom pb-2">
            <div>
                <h6 class="m-0">Student Ledger</h6>
            </div>
        </div>
        <div class="row">
            <div class="col-12">
                <div class="card">
                    <div class="card-body">
                        <h4>Student Information</h4>
                        <div class="table-responsive">
                            <table class="table table-bordered table-hover">
                                <tbody>
                                    <tr>
                                        <th>Student ID</th>
                                        <td>{{ $studentuser->uid }} </td>
                                        <th>Name</th>
                                        <td>
                                            {{ $studentuser->name }}
                                        </td>
                                    </tr>
                                    <tr>
                                        <th>Mobile</th>
                                        <td>
                                            {{ $studentuser->mobile }}
                                        </td>
                                        <th>Email</th>
                                        <td>
                                            {{ $studentuser->email }}
                                        </td>
                                    </tr>
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <div class="row">
            <div class="col-12 col-sm-3 col-md-3">
                <div class="card overflow-hidden radius-10">
                    <div class="card-body p-2">
                        <div class="d-flex align-items-stretch justify-content-between radius-10 overflow-hidden">
                            <div class="w-100 p-3 bg-pink text-white">
                                <p>Fee Category</p>
                                <h4>{{ $payable }}</h4>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <div class="col-12 col-sm-3 col-md-3">
                <div class="card overflow-hidden radius-10">
                    <div class="card-body p-2">
                        <div class="d-flex align-items-stretch justify-content-between radius-10 overflow-hidden">
                            <div class="w-100 p-3 bg-info text-white">
                                <p>Total Waiver</p>
                                <h4> {{ $waiver }}</h4>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <div class="col-12 col-sm-3 col-md-3">
                <div class="card overflow-hidden radius-10">
                    <div class="card-body p-2">
                        <div class="d-flex align-items-stretch justify-content-between radius-10 overflow-hidden">
                            <div class="w-100 p-3 bg-orange text-white">
                                <p>Total Improvment Due</p>
                                <h4> {{ $improvment }} </h4>
                            </div>

                        </div>
                    </div>
                </div>
            </div>
            <div class="col-12 col-sm-3 col-md-3">
                <div class="card overflow-hidden radius-10">
                    <div class="card-body p-2">
                        <div class="d-flex align-items-stretch justify-content-between radius-10 overflow-hidden">
                            <div class="w-100 p-3 bg-orange text-white">
                                <p>Total Document Due</p>
                                <h4> {{ $documentdue }} </h4>
                            </div>

                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="row">
            <div class="col-12 col-sm-4 col-md-4">
                <div class="card overflow-hidden radius-10">
                    <div class="card-body p-2">
                        <div class="d-flex align-items-stretch justify-content-between radius-10 overflow-hidden">
                            <div class="w-100 p-3 bg-warning ">
                                <p>Total Other Due</p>
                                <h4> {{ $settlement }} </h4>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <div class="col-12 col-sm-4 col-md-4">
                <div class="card overflow-hidden radius-10">
                    <div class="card-body p-2">
                        <div class="d-flex align-items-stretch justify-content-between radius-10 overflow-hidden">
                            <div class="w-100 p-3 bg-success text-white">
                                <p>Total Paid</p>
                                <h4> {{ $paidamount }} </h4>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <div class="col-12 col-sm-4 col-md-4">
                <div class="card overflow-hidden radius-10">
                    <div class="card-body p-2">
                        <div class="d-flex align-items-stretch justify-content-between radius-10 overflow-hidden">
                            <div class="w-100 p-3 bg-danger text-white">
                                <p>Total Due</p>
                                <h4> {{ $dueamount }}</h4>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <div class="card">
            <div class="card-body">
                <h5>Class History</h5>
                <div class="table-responsive">
                    @if ($students)
                        <table id="example" class="table table-striped table-bordered" style="width:100%">
                            <thead>
                                <tr>
                                    <th>Action</th>
                                    <th>#</th>
                                    <th>Class</th>
                                    <th>Session</th>
                                    <th>Group</th>
                                    <th>Year</th>
                                    <th>Section</th>
                                    <th>Status</td>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach ($students as $item)
                                    <tr>
                                        <td>
                                            <a class="btn btn-primary btn-sm"
                                                href="{{ route('admin.application.student.show', $item->id) }}"><i
                                                    class="bi bi-eye-fill"></i> Show</a>
                                        </td>
                                        <td>{{ $loop->iteration }}</td>
                                        <td>{{ optional($item->classtype)->name }}</td>
                                        <td>{{ optional($item->session)->name }}</td>
                                        <td>{{ optional($item->group)->name }}</td>
                                        <td>{{ optional($item->classyear)->name }}</td>
                                        <td>{{ optional($item->section)->name }}</td>
                                        <td>
                                            <div class="btn btn-primary btn-sm">
                                                {{ $item->status }}
                                            </div>
                                        </td>

                                    </tr>
                                @endforeach
                            </tbody>
                        </table>
                    @else
                        <h4 class="text-center mt-5  py-5">No Student Found</h4>
                    @endif
                </div>
            </div>
        </div>

        <div class="card">
            <div class="card-body">
                <h5>Payment History</h5>
                <div class="table-responsive">
                    <table id="example" class="table table-striped table-bordered" style="width:100%">
                        <thead>
                            <tr>
                                <th>#</th>
                                <th>UID</th>
                                <th>Name</th>
                                <th>Class</th>
                                <th>Session</th>
                                <th>Group</th>
                                <th>Year</th>
                                <th>Amount</th>
                                <th>Transaction No</th>
                                <th>Payment Method</th>
                                <th>Date</th>
                            </tr>
                        </thead>
                        <tbody>
                            @php
                                $historytotal = 0;
                            @endphp
                            @foreach ($studentuser->students as $student)
                                @foreach ($student->paymenthistories as $item)
                                    <tr>
                                        <td>{{ $loop->iteration }}</td>
                                        <td>{{ optional($item->studentuser)->uid }}</td>
                                        <td>{{ optional($item->studentuser)->name }}</td>
                                        <td>{{ optional($item->classtype)->name }}</td>
                                        <td>{{ optional($item->session)->name }}</td>
                                        <td>{{ optional($item->group)->name }}</td>
                                        <td>{{ optional($item->classyear)->name }}</td>
                                        <td>{{ number_format($item->amount, 2) }}</td>
                                        <td>{{ $item->receipt }}</td>
                                        <td>{{ optional($item->paymentmethod)->name }}</td>
                                        <td>{{ $item->created_at->format('d-m-Y') }}</td>
                                        @php
                                            $historytotal += $item->amount;
                                        @endphp
                                    </tr>
                                @endforeach
                            @endforeach
                        </tbody>
                        <tfoot>
                            <tr>
                                <th colspan="6"></th>
                                <th>Total</th>
                                <th> {{ number_format($historytotal, 2) }} </th>
                                <th colspan="2"></th>
                            </tr>
                        </tfoot>
                    </table>
                </div>
                <h5>Waivers History</h5>
                <div class="table-responsive">
                    <table id="example" class="table table-striped table-bordered" style="width:100%">
                        <thead>
                            <tr>
                                <th>Action</th>
                                <th>#</th>
                                <th>UID</th>
                                <th>Name</th>
                                <th>Class</th>
                                <th>Session</th>
                                <th>Group</th>
                                <th>Year</th>
                                <th>Amount</th>
                                <th>Created</th>
                                <th>Created By</th>
                                <th>Status</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach ($studentuser->students as $student)
                                @foreach ($student->waivers as $item)
                                    <tr>
                                        <td>
                                            <div class="dropdown">
                                                <button class="btn btn-primary btn-sm dropdown-toggle" type="button"
                                                    data-bs-toggle="dropdown" aria-expanded="false">Action</button>
                                                <ul class="dropdown-menu">
                                                    <li>
                                                        <a class="dropdown-item"
                                                            href="{{ route('admin.waiver.show', $item->id) }}"><i
                                                                class="bi bi-eye-fill"></i> Show</a>
                                                    </li>
                                                    <li>
                                                        <a href="{{ route('admin.waiver.edit', $item->id) }}"
                                                            class="dropdown-item"><i class="bi bi-pencil-fill"></i> Edit</a>
                                                    </li>
                                                    <li>
                                                        <a href="javascript:;" onclick="deleteItem({{ $item->id }})"
                                                            class="text-danger dropdown-item"><i
                                                                class="bi bi-trash-fill"></i>
                                                            Delete</a>
                                                    </li>
                                                </ul>
                                            </div>
                                        </td>
                                        <td>{{ $loop->iteration }}</td>
                                        <td>{{ optional($item->studentuser)->uid }}</td>
                                        <td>{{ optional($item->studentuser)->name }}</td>
                                        <td>{{ optional($item->classtype)->name }}</td>
                                        <td>{{ optional($item->session)->name }}</td>
                                        <td>{{ optional($item->group)->name }}</td>
                                        <td>{{ optional($item->classyear)->name }}</td>
                                        <td>{{ $item->amount }}</td>
                                        <td>{{ $item->created_at->format('d-m-Y') }}</td>
                                        <td>{{ optional($item->user)->name }}</td>
                                        <td>
                                            <div class="btn btn-primary btn-sm">
                                                {{ $item->status }}
                                            </div>
                                        </td>
                                    </tr>
                                @endforeach
                            @endforeach
                        </tbody>
                        <tfoot>
                            <tr>
                                <th colspan="7"></th>
                                <th>Total</th>
                                <th> {{ number_format($student->waivers->sum('amount'), 2) }}</th>
                            </tr>
                        </tfoot>

                    </table>
                </div>
                <h5>Exam Improvement Due History</h5>
                <div class="table-responsive">
                    <table id="example" class="table table-striped table-bordered" style="width:100%">
                        <thead>
                            <tr>
                                <th>Action</th>
                                <th>#</th>
                                <th>UID</th>
                                <th>Name</th>
                                <th>Class</th>
                                <th>Session</th>
                                <th>Group</th>
                                <th>Year</th>
                                <th>Amount</th>
                                <th>Created</th>
                                <th>Created By</th>
                                <th>Status</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach ($studentuser->students as $student)
                                @foreach ($student->examimprovementdue as $item)
                                    <tr>
                                        <td>
                                            <div class="dropdown">
                                                <button class="btn btn-primary btn-sm dropdown-toggle" type="button"
                                                    data-bs-toggle="dropdown" aria-expanded="false">Action</button>
                                                <ul class="dropdown-menu">
                                                    <li>
                                                        <a class="dropdown-item"
                                                            href="{{ route('admin.examimprovementdue.show', $item->id) }}"><i
                                                                class="bi bi-eye-fill"></i> Show</a>
                                                    </li>
                                                    <li>
                                                        <a href="{{ route('admin.examimprovementdue.edit', $item->id) }}"
                                                            class="dropdown-item"><i class="bi bi-pencil-fill"></i> Edit</a>
                                                    </li>
                                                    <li>
                                                        <a href="javascript:;" onclick="deleteItem({{ $item->id }})"
                                                            class="text-danger dropdown-item"><i class="bi bi-trash-fill"></i>
                                                            Delete</a>
                                                    </li>
                                                </ul>
                                            </div>
                                        </td>
                                        <td>{{ $loop->iteration }}</td>
                                        <td>{{ optional($item->studentuser)->uid }}</td>
                                        <td>{{ optional($item->studentuser)->name }}</td>
                                        <td>{{ optional($item->classtype)->name }}</td>
                                        <td>{{ optional($item->session)->name }}</td>
                                        <td>{{ optional($item->group)->name }}</td>
                                        <td>{{ optional($item->classyear)->name }}</td>
                                        <td>{{ $item->amount }}</td>
                                        <td>{{ $item->created_at->format('d-m-Y') }}</td>
                                        <td>{{ optional($item->user)->name }}</td>
                                        <td>
                                            <div class="btn btn-primary btn-sm">
                                                {{ $item->status }}
                                            </div>
                                        </td>
                                    </tr>
                                @endforeach
                            @endforeach
                        </tbody>
                    </table>
                </div>
                <h5>Settlement History</h5>
                <div class="table-responsive">
                    <table id="example" class="table table-striped table-bordered" style="width:100%">
                        <thead>
                            <tr>
                                <th>Action</th>
                                <th>#</th>
                                <th>UID</th>
                                <th>Name</th>
                                <th>Class</th>
                                <th>Session</th>
                                <th>Group</th>
                                <th>Year</th>
                                <th>Amount</th>
                                <th>Type</th>
                                <th>Created</th>
                                <th>Created By</th>
                                <th>Status</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach ($studentuser->students as $student)
                            @foreach ($student->settlementdue as $item)
                                <tr>
                                    <td>
                                        <div class="dropdown">
                                            <button class="btn btn-primary btn-sm dropdown-toggle" type="button"
                                                data-bs-toggle="dropdown" aria-expanded="false">Action</button>
                                            <ul class="dropdown-menu">
                                                <li>
                                                    <a class="dropdown-item"
                                                        href="{{ route('admin.settlement.show', $item->id) }}"><i
                                                            class="bi bi-eye-fill"></i> Show</a>
                                                </li>
                                            </ul>
                                        </div>
                                    </td>
                                    <td>{{ $loop->iteration }}</td>
                                    <td>{{ optional($item->studentuser)->uid }}</td>
                                    <td>{{ optional($item->studentuser)->name }}</td>
                                    <td>{{ optional($item->classtype)->name }}</td>
                                    <td>{{ optional($item->session)->name }}</td>
                                    <td>{{ optional($item->group)->name }}</td>
                                    <td>{{ optional($item->classyear)->name }}</td>
                                    <td>{{ $item->amount }}</td>
                                    <td>
                                        {{ $item->type }}
                                    </td>
                                    <td>{{ $item->created_at->format('d-m-Y') }}</td>
                                    <td>{{ optional($item->user)->name }}</td>
                                    <td>
                                        <div class="btn btn-primary btn-sm">
                                            {{ $item->status }}
                                        </div>
                                    </td>
                                </tr>
                            @endforeach
                            @endforeach
                        </tbody>

                    </table>
                </div>
                <h5>Document Due History</h5>
                <div class="table-responsive">
                    <table id="example" class="table table-striped table-bordered" style="width:100%">
                        <thead>
                            <tr>
                                <th>Action</th>
                                <th>#</th>
                                <th>UID</th>
                                <th>Name</th>
                                <th>Class</th>
                                <th>Session</th>
                                <th>Group</th>
                                <th>Year</th>
                                <th>Type</th>
                                <th>Amount</th>
                                <th>Created At</th>
                                <th>Created By</th>
                                <th>Status</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach ($studentuser->students as $student)
                                @foreach ($student->examimprovementdue as $item)
                                <tr>
                                    <td>
                                        <div class="dropdown">
                                            <button class="btn btn-primary btn-sm dropdown-toggle" type="button"
                                                data-bs-toggle="dropdown" aria-expanded="false">Action</button>
                                            <ul class="dropdown-menu">
                                                <li>
                                                    <a class="dropdown-item"
                                                        href="{{ route('admin.settlement.show', $item->id) }}"><i
                                                            class="bi bi-eye-fill"></i> Show</a>
                                                </li>
                                                <li>
                                                    <a href="{{ route('admin.settlement.edit', $item->id) }}"
                                                        class="dropdown-item"><i class="bi bi-pencil-fill"></i> Edit</a>
                                                </li>
                                            </ul>
                                        </div>
                                    </td>
                                    <td>{{ $loop->iteration }}</td>
                                    <td>{{ optional($item->studentuser)->uid }}</td>
                                    <td>{{ optional($item->studentuser)->name }}</td>
                                    <td>{{ optional($item->classtype)->name }}</td>
                                    <td>{{ optional($item->session)->name }}</td>
                                    <td>{{ optional($item->group)->name }}</td>
                                    <td>{{ optional($item->classyear)->name }}</td>
                                    <td>{{ optional($item->documenttype)->name }}</td>
                                    <td>{{ $item->amount }}</td>

                                    <td>{{ $item->created_at->format('d-m-Y') }}</td>
                                    <td>{{ optional($item->user)->name }}</td>
                                    <td>
                                        <div class="btn btn-primary btn-sm">
                                            {{ $item->status }}
                                        </div>
                                    </td>
                                </tr>
                                @endforeach
                            @endforeach
                        </tbody>

                    </table>
                </div>
            </div>
        </div>

    </div>
@endsection

@include('admin.components.toster')
@include('admin.components.tosterjs')