@extends('admin/layouts/default')

@section('title')
    Cafe & Store Reports
    @parent
@stop

@section('header_styles')
    <link rel="stylesheet" type="text/css" href="{{ asset('assets/vendors/bootstrap-datepicker/css/bootstrap-datepicker.css') }}">
    <style>
        /* Professional Tab Styling */
        .nav-tabs { border-bottom: 2px solid #EEE; margin-bottom: 20px; }
        .nav-tabs > li > a {
            border: none;
            color: #555;
            font-weight: 600;
            padding: 12px 20px;
            transition: all 0.2s;
        }
        .nav-tabs > li.active > a, .nav-tabs > li.active > a:hover {
            border: none;
            border-bottom: 3px solid #337ab7;
            color: #337ab7 !important;
            background: transparent;
        }

        /* Filter Box Styling */
        .report-filter-box {
            background: #ffffff;
            padding: 25px;
            border-radius: 4px;
            border: 1px solid #e7e7e7;
            margin-bottom: 30px;
            box-shadow: 0 1px 3px rgba(0,0,0,0.1);
        }
        .form-inline .form-group { margin-right: 15px; }
        .table thead { background-color: #f9f9f9; color: #333; }
        .tab-pane h3 { margin-top: 0; padding-bottom: 10px; border-bottom: 1px dashed #ddd; margin-bottom: 20px; }
    </style>
@stop

@section('content')
    <section class="content-header">
        <h1>View Store Reports</h1>
        <ol class="breadcrumb">
            <li><a href="{{ route('dashboard') }}"><i class="livicon" data-name="home" data-size="14" data-color="#000"></i> Dashboard</a></li>
            <li class="active">View Reports</li>
        </ol>
    </section>

    <section class="content paddingleft_right15">
        <div class="row">
            <div class="panel panel-primary">
                <div class="panel-heading">
                    <h4 class="panel-title">
                        <i class="livicon" data-name="notebook" data-size="16" data-loop="true" data-c="#fff" data-hc="white"></i>
                        <b>Debre Markos University Cafe Management System</b>
                    </h4>
                </div>

                <div class="panel-body">
                    <div class="report-filter-box">
                        {!! Form::open(['url' => session::get('role_name').'/report', 'class' => 'form-inline']) !!}
                        <div class="form-group">
                            <label>From: </label>
                            <input type="text" id="fromdate" name="fromdate" class="form-control" placeholder="YYYY-MM-DD">
                        </div>
                        <div class="form-group">
                            <label>To: </label>
                            <input type="text" id="todate" name="todate" class="form-control" required placeholder="YYYY-MM-DD">
                        </div>
                        <div class="form-group">
                            <label>Material: </label>
                            <select name="matid" class="form-control">
                                <option value="">Select Materials</option>
                                <option value="all">All</option>
                                @foreach(DB::table('materials')->select('materialname')->distinct()->get() as $mat)
                                    <option value="{{$mat->materialname}}">{{$mat->materialname}}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="form-group">
                            <label>Type: </label>
                            <select name="type" class="form-control">
                                <option value="">Select Type</option>
                                <option value="stored">Stored</option>
                                <option value="used">Used</option>
                            </select>
                        </div>
                        <button type="submit" class="btn btn-info"><i class="fa fa-search"></i> View Report</button>
                        {!! Form::close() !!}
                    </div>

                    <ul class="nav nav-tabs" role="tablist">
                        <li role="presentation" class="active">
                            <a href="#stored" aria-controls="stored" role="tab" data-toggle="tab"><i class="fa fa-archive"></i> Materials Stored</a>
                        </li>
                        <li role="presentation">
                            <a href="#used" aria-controls="used" role="tab" data-toggle="tab"><i class="fa fa-share-square-o"></i> Material Used</a>
                        </li>
                        <li role="presentation">
                            <a href="#cafe_std" aria-controls="cafe_std" role="tab" data-toggle="tab"><i class="fa fa-users"></i> Cafe Students</a>
                        </li>
                        <li role="presentation">
                            <a href="#non_cafe" aria-controls="non_cafe" role="tab" data-toggle="tab"><i class="fa fa-user-times"></i> Non-Cafe Students</a>
                        </li>
                        <li role="presentation">
                            <a href="#usedreport" aria-controls="usedreport" role="tab" data-toggle="tab"><i class="fa fa-user-times"></i> Used Report</a>
                        </li>
                    </ul>

                    <div class="tab-content">

                        <div role="tabpanel" class="tab-pane active" id="stored">
                            <h3 class="text-center text-primary">Material Stored In Store</h3>
                            <table class="table table-bordered table-striped" id="table_stored">
                                <thead>
                                <tr>
                                    <th>ID</th>
                                    <th>Date</th>
                                    <th>Material Name</th>
                                    <th>Amount</th>
                                </tr>
                                </thead>
                                <tbody>
                                @foreach (DB::table('materials')->get() as $m)
                                    <tr>
                                        <td>{{ $m->id }}</td>
                                        <td>{{ $m->date }}</td>
                                        <td>{{ $m->materialname }}</td>
                                        <td>{{ $m->amount }}</td>
                                    </tr>
                                @endforeach
                                </tbody>
                            </table>
                        </div>

                        <div role="tabpanel" class="tab-pane" id="used">
                            <h3 class="text-center text-success">Total Material Used</h3>
                            <table class="table table-bordered table-striped">
                                <thead>
                                <tr>
                                    <th>ID</th>
                                    <th>Date</th>
                                    <th>Material Name</th>
                                    <th>Amount Used</th>
                                </tr>
                                </thead>
                                <tbody>
                                @foreach (DB::table('regtodays')->groupBy('materialname')->get() as $u)
                                    <tr>
                                        <td>{{ $u->id }}</td>
                                        <td>{{ $u->date }}</td>
                                        <td>{{ $u->materialname }}</td>
                                        <td>{{ $u->amount }}</td>
                                    </tr>
                                @endforeach
                                </tbody>
                            </table>
                        </div>


                        <div role="tabpanel" class="tab-pane {{ request('tab') == 'usedreport' ? 'active' : '' }}" id="usedreport">
                            <h3 class="text-center text-success">
                                Total Students Used (By Date)
                            </h3>

                        @php
                            $selectedDate = request('report_date');

                            $query = DB::table('mealcards')
                                        ->select(
                                            'date',
                                            DB::raw('COUNT(DISTINCT std_id) as total_students')
                                        );

                            if($selectedDate){
                                $query->where('date', $selectedDate);
                            }

                            $usedReport = $query->groupBy('date')
                                                ->orderBy('date','desc')
                                                ->get();
                        @endphp

                        <!-- Date Filter Form -->
                            <form method="GET" class="form-inline text-center" style="margin-bottom:20px;">
                                <input type="hidden" name="tab" value="usedreport">

                                <div class="form-group">
                                    <label>Pick Date:</label>
                                    <input type="text" name="report_date" id="report_date" class="form-control"
                                           placeholder="YYYY-MM-DD" value="{{ $selectedDate }}">
                                </div>

                                <button type="submit" class="btn btn-primary">
                                    <i class="fa fa-search"></i> Search
                                </button>
                            </form>

                            <!-- Report Table -->
                            <table class="table table-bordered table-striped">
                                <thead>
                                <tr>
                                    <th>#</th>
                                    <th>Date</th>
                                    <th>Total Students Used</th>
                                </tr>
                                </thead>
                                <tbody>
                                @forelse($usedReport as $key => $row)
                                    <tr>
                                        <td>{{ $key + 1 }}</td>
                                        <td>{{ $row->date }}</td>
                                        <td>
                                            <span class="label label-success">{{ $row->total_students }}</span>
                                        </td>
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="3" class="text-center text-danger">No data found</td>
                                    </tr>
                                @endforelse
                                </tbody>
                            </table>
                        </div>

                        <div role="tabpanel" class="tab-pane" id="cafe_std">
                            <h3 class="text-center text-info">Active Cafe Student Lists</h3>
                            @php $cafeCount = DB::table('students')->where('std_status', '0')->count(); @endphp
                            <div class="alert alert-info">Total Active Cafe Students: <b>{{ $cafeCount }}</b></div>
                            <table class="table table-bordered table-hover">
                                <thead>
                                <tr>
                                    <th>ID</th>
                                    <th>Student Name</th>
                                    <th>Sex</th>
                                    <th>Status</th>
                                    <th>Action</th>
                                </tr>
                                </thead>
                                <tbody>
                                @foreach (DB::table('students')->where('std_status', '0')->get() as $std)
                                    <tr>
                                        <td>{{ $std->id }}</td>
                                        <td>{{ $std->firstname }} {{ $std->lastname }}</td>
                                        <td>{{ $std->sex }}</td>
                                        <td><span class="label label-success">In Cafe</span></td>
                                        <td><button class="btn btn-xs btn-warning">Set to Non-Cafe</button></td>
                                    </tr>
                                @endforeach
                                </tbody>
                            </table>
                        </div>

                        <div role="tabpanel" class="tab-pane" id="non_cafe">
                            <h3 class="text-center text-danger">Non-Cafe Students Lists</h3>
                            @php $nonCount = DB::table('students')->where('std_status', '1')->count(); @endphp
                            <div class="alert alert-danger">Total Non-Cafe Students: <b>{{ $nonCount }}</b></div>
                            <table class="table table-bordered table-hover">
                                <thead>
                                <tr>
                                    <th>Student ID</th>
                                    <th>Student Name</th>
                                    <th>Sex</th>
                                    <th>Cafe Status</th>
                                    <th>Action</th>
                                </tr>
                                </thead>
                                <tbody>
                                @foreach (DB::table('students')->where('std_status', '1')->get() as $std)
                                    <tr>
                                        <td>{{ $std->id }}</td>
                                        <td>{{ $std->firstname }} {{ $std->lastname }}</td>
                                        <td>{{ $std->sex }}</td>
                                        <td><span class="label label-default">Non-Cafe</span></td>
                                        <td><button class="btn btn-xs btn-primary">Change Status</button></td>
                                    </tr>
                                @endforeach
                                </tbody>
                            </table>
                        </div>

                    </div> </div>
            </div>
        </div>
    </section>
@stop

@section('footer_scripts')
    <script type="text/javascript" src="{{ asset('assets/vendors/bootstrap-datepicker/js/bootstrap-datepicker.js') }}"></script>
    <script>
        $(document).ready(function() {
            // Initialize Datepickers
            $('#fromdate, #todate').datepicker({
                format: 'yyyy-mm-dd',
                autoclose: true,
                todayHighlight: true
            });
        });
    </script>
    <script>
        $(document).ready(function() {

            // Initialize datepicker for Used Report
            $('#report_date').datepicker({
                format: 'yyyy-mm-dd',
                autoclose: true,
                todayHighlight: true
            });

            // Keep selected tab active after reload
            var activeTab = "{{ request('tab') }}";
            if(activeTab){
                $('.nav-tabs a[href="#' + activeTab + '"]').tab('show');
            }

        });
    </script>

@stop