@extends('layouts.app', ['class' => 'g-sidenav-show bg-gray-100'])

@section('content')
@include('layouts.navbars.auth.topnav', ['title' => 'Dashboard'])
    <div class="container-fluid py-4">
        <div class="card p-1">
        <h4 class="mx-5">Welcome to CMS</h4>

        <div class="row">
            <!-- No.Of Departments -->
            <div class="col-12 col-sm-6 col-md-6">
                <a href="/department" class="text-decoration-none"> <!-- Add the anchor tag here -->
                    <div class="info-box bg-light shadow">
                        <span class="info-box-icon bg-info elevation-1"><i class="fas fa-th-list"></i></span>
                        <div class="info-box-content">
                            <span class="info-box-text"><b>No.Of Departments</b></span>
                            <span class="info-box-number">
                                {{ DB::table('cms_department')->where('oprtnl_flag', 'A')->count() }}
                            </span>
                        </div>
                    </div>
                </a>
            </div>


            <!-- No.Of Courses -->
            <div class="col-12 col-sm-6 col-md-6">
                <a href="/course" class="text-decoration-none">
                <div class="info-box bg-light shadow">
                    <span class="info-box-icon bg-success elevation-1"><i class="fas fa-user-graduate"></i></span>

                    <div class="info-box-content">
                        <span class="info-box-text"><b>No.Of Courses</b></span>
                        <span class="info-box-number">
                            {{ DB::table('cms_course')->where('oprtnl_flag', 'A')->count() }}
                        </span>
                    </div>
                </div>
            </a>
            </div>

            <!-- Group-Wise Student Report -->
            {{-- <div class="col-12 col-sm-6 col-md-6">
                <div class="info-box bg-light shadow">
                    <span class="info-box-icon bg-yellow elevation-1"><i class="fas fa-users text-dark"></i></span>
                    <div class="info-box-content">
                        <span class="info-box-text"><b>Group-Wise Student Report</b></span>
                        <table class="table table-striped table-sm">
                            <thead>
                                <tr>
                                    <th>Group Type</th>
                                    <th>Count</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach (DB::select('
                                        SELECT cca.course_name, COUNT(*) AS count
                                        FROM cms_student cs
                                        JOIN cms_course cca ON cca.cms_course_sid = cs.cms_course_sid
                                        WHERE cs.cms_academic_year_sid IN (SELECT academicyear_Id FROM academicyear WHERE oprtnl_flag = "A")
                                        AND cs.oprtnl_flag = "A"
                                        GROUP BY cca.course_name') as $row)
                                    <tr>
                                        <td>{{ $row->course_name }}</td>
                                        <td>{{ $row->count }}</td>
                                    </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                </div>
            </div> --}}

            <!-- Caste-Wise Student Report -->
            {{-- <div class="col-12 col-sm-6 col-md-6">
                <div class="info-box bg-light shadow">
                    <span class="info-box-icon bg-yellow elevation-1"><i class="fas fa-users text-dark"></i></span>
                    <div class="info-box-content">
                        <span class="info-box-text"><b>Caste-Wise Student Report</b></span>
                        <table class="table table-striped table-sm">
                            <thead>
                                <tr>
                                    <th>Caste Type</th>
                                    <th>Count</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach (DB::select('
                                        SELECT cca.caste_name, COUNT(*) AS count
                                        FROM cms_student cs
                                        JOIN cms_caste cca ON cca.cms_caste_sid = cs.caste
                                        WHERE cs.cms_academic_year_sid IN (SELECT academicyear_Id FROM academicyear WHERE oprtnl_flag = "A")
                                        AND cs.oprtnl_flag = "A"
                                        GROUP BY cca.caste_name') as $row)
                                    <tr>
                                        <td>{{ $row->caste_name }}</td>
                                        <td>{{ $row->count }}</td>
                                    </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                </div>
            </div> --}}

            <!-- Student Attendance Report -->
            <div class="col-12 col-sm-6 col-md-6">
                {{-- <div class="info-box bg-light shadow">
                    <span class="info-box-icon bg-dark elevation-1"><i class="fas fa-users"></i></span>
                    <div class="info-box-content">
                        <span class="info-box-text"><b>Student Attendance Report</b></span>
                        <table class="table table-striped table-sm">
                            <thead>
                                <tr>
                                    <th>Total No. Of Student</th>
                                    <th>{{ $totalStudent }}</th>
                                </tr>
                            </thead>
                            <tbody>
                                <tr>
                                    <td>Whole day Present Student</td>
                                    <td>{{ $wholeDayPresentCount }}</td>
                                </tr>
                                <tr>
                                    <td>Whole day Absent Student</td>
                                    <td>{{ $wholeDayAbsentCount }}</td>
                                </tr>
                                @for ($i = 5; $i >= 1; $i--)
                                    <tr>
                                        <td>{{ $i }} period Present Student</td>
                                        <td>{{ $periodCounts[$i] ?? 0 }}</td>
                                    </tr>
                                @endfor
                            </tbody>
                        </table>
                    </div>
                </div> --}}
                <div class="info-box bg-light shadow">
                    <span class="info-box-icon bg-primary elevation-1"><i class="fas fa-donate"></i></span>
                    <div class="info-box-content">
                        <span class="info-box-text"><b> Donations</b></span>
                        <table class="table table-striped table-sm">
                            <tbody>
                                <tr>
                                    <th>User Types</th>
                                    <th>Today Donations</th>
                                    <th>Total Donations</th>
                                </tr>
                                <tr>
                                    <td>Public Donations</td>
                                    <td>{{ $totalTodayAmountP }}</td>
                                    <td>{{ $totalAmountP }}</td>
                                </tr>
                                <tr>
                                    <td>Member Donations</td>
                                    <td>{{ $totalTodayAmountM }}</td>
                                    <td>{{ $totalAmountM }}</td>
                                </tr>
                                <tr>
                                    <td>Alumni Donations</td>
                                    <td>{{ $totalTodayAmountA }}</td>
                                    <td>{{ $totalAmountA }}</td>
                                </tr>
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>

            <!-- Staff Attendance Report -->
            <div class="col-12 col-sm-6 col-md-6">
                {{-- <div class="info-box bg-light shadow">
                    <span class="info-box-icon bg-danger elevation-1"><i class="fas fa-users"></i></span>
                    <div class="info-box-content">
                        <span class="info-box-text"><b>Staff Attendance Report</b></span>
                        <table class="table table-striped table-sm">
                            <thead>
                                <tr>
                                    <th>Total No. Of Staff</th>
                                    <th>{{ DB::table('cms_staff')->where('oprtnl_flag', 'A')->count() }}</th>
                                </tr>
                            </thead>
                            <tbody>
                                <tr>
                                    <td>WholeDay Attended Staff</td>
                                    <td>{{ $wholeDayPresent }}</td>
                                </tr>
                                <tr>
                                    <td>WholeDay Absent staff</td>
                                    <td>{{ $wholeDayAbsent }}</td>
                                </tr>
                                <tr>
                                    <td>Half Day present / Absent attendant staff</td>
                                    <td>{{ $halfDay }}</td>
                                </tr>
                            </tbody>
                        </table>
                    </div>
                </div> --}}

                <!-- Fees Report - Student -->
                <div class="info-box bg-light shadow">
                    <span class="info-box-icon bg-pink elevation-1"><i class="fas fa-money-bill-wave"></i></span>
                    <div class="info-box-content">
                        <span class="info-box-text"><b>Fees Report - Student</b></span>
                        <table class="table table-striped table-sm">
                            <tbody>
                                <tr>
                                    <td>Today Fee Collection</td>
                                    <td>{{ $totalAmount }} </td>
                                </tr>
                                <tr>
                                    <td>Total Fee Collection</td>
                                    <td> {{ $totalFullAmount }}</td>
                                </tr>
                            </tbody>
                        </table>
                    </div>
                </div>

                <div class="info-box bg-light shadow">
                    <span class="info-box-icon bg-primary elevation-1"><i class="fas fa-wallet"></i></span>
                    <div class="info-box-content">
                        <span class="info-box-text"><b>Total Expensions</b></span>
                        <table class="table table-striped table-sm">
                            <tbody>

                                <tr>
                                    <td>Total Expense</td>
                                    <td>{{ $totalExpense }}</td>
                                </tr>
                                <tr>
                                    <td>Today Expense</td>
                                    <td>{{ $todayExpense }}</td>
                                </tr>
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection
@push('styles')
<style>
.bg-spark{
    background-color: rgb(0, 255, 213)
}
    .bg-light {
        background-color: #8eccdf !important;
    }

    .bg-pink{
        background-color: #e83e8c !important;
    }

    .bg-yellow{
        background-color: #ffc107  !important;
    }
    .table-striped tbody tr:nth-child(odd) {
    background-color: #87c2d4; /* Set your preferred color for odd rows */
    color : black;
}
.table-striped > tbody > tr:nth-of-type(odd) > * {
    --bs-table-accent-bg: var(--bs-table-striped-bg);
    color: #000000;
}
    .table{
        color : black;
    }
</style>
@endpush