@extends('layouts.app')
@section('title', 'Students Due List')
@section('content')
    <div class="container">
        <!--breadcrumb-->
        <div class="page-breadcrumb d-flex align-items-center mb-2 border-bottom pb-2">
            <div>
                <h6 class="m-0">Students Due List</h6>
            </div>
        </div>
        <!--breadcrumb-->
        <div class="card">
            <div class="card-body">
                <form action="" method="get">
                    <div class="row pb-4">
                        <div class="col-12 col-md-3 mb-3">
                            <div class="form-group">
                                <label for="">Student ID/Name</label>
                                <input type="text" name="uid" @if(isset($uid)) value="{{ $uid }}" @endif class="form-control">
                            </div>
                        </div>
                        <div class="col-12 col-md-3 mb-3">
                            <div class="form-group">
                                <label>Class</label>
                                <select name="class_id" id="class_id" class="form-control class_type_id">
                                    <option value="">Select Class</option>
                                    @foreach ($classtypes as $type)
                                        <option
                                            @if (isset($class_id)) {{ $class_id == $type->id ? 'selected' : '' }} @endif
                                            value="{{ $type->id }}">{{ $type->name }}</option>
                                    @endforeach
                                </select>
                            </div>
                        </div>
                        <div class="col-12 col-md-3 mb-3">
                            <div class="form-group">
                                <label>Session </label>
                                <select name="session_id" id="session_id" class="form-control session_id">
                                    <option value="">Select Session</option>
                                    @foreach ($sessiones as $session)
                                        <option
                                            @if (isset($session_id)) {{ $session_id == $session->id ? 'selected' : '' }} @endif
                                            value="{{ $session->id }}">{{ $session->name }}</option>
                                    @endforeach
                                </select>

                            </div>
                        </div>
                        <div class="col-12 col-md-3 mb-3">
                            <div class="form-group">
                                <label>Group/Department </label>
                                <select name="group_id" id="group_id" class="form-control group_id">
                                    <option value="">Select Group</option>
                                    @if (isset($groupes))
                                        @foreach ($groupes as $group)
                                            <option {{ $group->id == $group_id ? 'selected' : '' }}
                                                value="{{ $group->id }}"> {{ $group->name }}</option>
                                        @endforeach
                                    @endif
                                </select>

                            </div>
                        </div>
                        <div class="col-12 col-md-3">
                            <div class="form-group">
                                <label>Year </label>
                                <select name="class_year_id" id="class_year_id" class="form-control class_year_id">
                                    <option value="">Select Class Year</option>
                                    @if (isset($classyears))
                                        @foreach ($classyears as $classyear)
                                            <option {{ $classyear->id == $class_year_id ? 'selected' : '' }}
                                                value="{{ $classyear->id }}"> {{ $classyear->name }}</option>
                                        @endforeach
                                    @endif
                                </select>

                            </div>
                        </div>
                        <div class="col-12 col-md-3">
                            <div class="form-group">
                                <label>Section </label>
                                <select name="section_id" id="section_id" class="form-control section_id">
                                    <option value="">Select Section</option>
                                    @if (isset($sections))
                                        @foreach ($sections as $section)
                                            <option {{ $section->id == $section_id ? 'selected' : '' }}
                                                value="{{ $section->id }}"> {{ $section->name }}</option>
                                        @endforeach
                                    @endif
                                </select>
                            </div>
                        </div>

                        <div class="col-12 col-md-2">
                            <div class="form-group">
                                <label>Student Type </label>
                                <select name="student_type" id="student_type" class="form-control student_type">
                                    <option value="">Select Type</option>
                                    <option
                                        @if (isset($student_type)) {{ $student_type == 'Regular' ? 'selected' : '' }} @endif
                                        value="Regular">Regular</option>
                                    <option
                                        @if (isset($student_type)) {{ $student_type == 'Irregular' ? 'selected' : '' }} @endif
                                        value="Irregular">Irregular</option>
                                </select>
                            </div>
                        </div>
                        <div class="col-12 col-md-4">
                            <button class="btn btn-primary btn-sm mt-3" name="search"><i class="bi bi-search"></i> Search </button>
                            <button class="btn btn-info btn-sm mt-3" name="pdf"><i class="bi bi-download"></i> PDF </button>
                            <button class="btn btn-success btn-sm mt-3" name="excel"><i class="bi bi-download"></i> Excel </button>
                        </div>
                    </div>
                </form>
                <div class="table-responsive border-top">
                    @if($students)
                    <table id="example" class="table table-striped table-bordered" style="width:100%">
                        <thead>
                            <tr>
                                <th>#</th>
                                <th>Student ID</th>
                                <th>Roll</th>
                                <th>Name</th>
                                <th>Class</th>
                                <th>Session</th>
                                <th>Group</th>
                                <th>Year</th>
                                <th>Section</th>
                                <th>Due Amount</th>
                            </tr>
                        </thead>
                        <tbody>
                            @php
                                $amount = 0;
                            @endphp
                            @foreach ($students as $item)
                                <tr>
                                    <td>{{ $loop->iteration }}</td>
                                    <td>{{ optional($item->user)->uid }}</td>
                                    <td>{{ optional($item->user)->roll }}</td>
                                    <td>{{ optional($item->user)->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->section)->name }}</td>
                                    <td>{{ $item->studentdueamount($item->id); }}</td>
                                </tr>
                                @php
                                     $amount += $item->studentdueamount($item->id);
                                @endphp
                            @endforeach
                        </tbody>
                        <tfoot>
                            <tr>
                                <th></th>
                                <th colspan="8">Total</th>
                                <th>{{ number_format($amount,2) }}</th>
                            </tr>
                        </tfoot>
                    </table>
                    @else
                        <h4 class="text-center mt-5  py-5">No Student Found</h4>
                    @endif
                </div>
            </div>
        </div>
    </div>





    @include('admin.components.common')
@endsection