@extends('layouts.app')

@section('title', 'Category Report')

@section('content')
<div class="container-fluid">
    <!-- Header Section -->
    <div class="row mb-3">
        <div class="col-12">
            <div class="card border-0 shadow-sm">
                <div class="card-body py-3">
                    <div class="row align-items-center">
                        <div class="col-lg-8">
                            <div class="d-flex align-items-center">
                                <div class="mr-3">
                                    <i class="fas fa-folder fa-2x text-primary"></i>
                                </div>
                                <div>
                                    <h3 class="font-weight-bold mb-0 text-dark">Category & Sub Category Report</h3>
                                    <p class="mb-0 text-muted small">View statistics for categories and subcategories (Current Month: {{ now()->format('F Y') }})</p>
                                </div>
                            </div>
                        </div>
                        <div class="col-lg-4 text-lg-right mt-2 mt-lg-0">
                            <button type="button" onclick="history.back()" class="btn btn-secondary">
                                <i class="fas fa-arrow-left"></i> Back
                            </button>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Categories Table Section -->
    <div class="row mb-4">
        <div class="col-12">
            <div class="card shadow-sm">
                <div class="card-header bg-primary text-white">
                    <h5 class="mb-0"><i class="fas fa-folder"></i> Categories</h5>
                </div>
                <div class="card-body">
                    <!-- Show Entries Control -->
                    <div class="row mb-3">
                        <div class="col-12">
                            <div class="d-flex align-items-center justify-content-between">
                                <div class="d-flex align-items-center">
                                    <span class="font-weight-bold text-muted mr-2" style="font-size: 0.9em; color: #6c757d;">SHOW</span>
                                    <select class="form-control form-control-sm" id="categoriesEntriesPerPage" style="width: auto; display: inline-block; margin: 0 8px; border: 1px solid #ced4da; border-radius: 4px; padding: 4px 30px 4px 8px; font-size: 0.9em; color: #495057;">
                                        <option value="10" selected>10</option>
                                        <option value="25">25</option>
                                        <option value="50">50</option>
                                        <option value="100">100</option>
                                        <option value="all">All</option>
                                    </select>
                                    <span class="font-weight-bold text-muted ml-2" style="font-size: 0.9em; color: #6c757d;">ENTRIES</span>
                                </div>
                                <div>
                                    <input type="text" id="categoriesSearch" class="form-control form-control-sm" placeholder="Search..." style="width: 200px; border: 1px solid #ced4da; border-radius: 4px; padding: 4px 8px; font-size: 0.9em;">
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    @if($categories->count() > 0)
                        <div class="table-responsive">
                            <table id="categoriesTable" class="table table-bordered table-hover table-striped">
                                <thead class="thead-dark">
                                    <tr>
                                        <th style="width: 80px;" class="text-center">SL</th>
                                        <th style="min-width: 200px;">Category Name</th>
                                        <th style="min-width: 250px;">Description</th>
                                        <th style="min-width: 120px;" class="text-center">Total Tickets</th>
                                        <th style="min-width: 120px;" class="text-center">Solved Tickets</th>
                                        <th style="min-width: 120px;" class="text-center">Pending Tickets</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach($categories as $index => $category)
                                        <tr>
                                            <td class="align-middle text-center">{{ $index + 1 }}</td>
                                            <td class="align-middle">
                                                <a href="{{ route('reseller-tickets.category-details', $category['id']) }}" style="text-decoration: none; color: #007bff; font-weight: bold;">
                                                    {{ $category['name'] }}
                                                </a>
                                            </td>
                                            <td class="align-middle">
                                                {{ $category['description'] ?? 'N/A' }}
                                            </td>
                                            <td class="align-middle text-center">
                                                <span class="badge badge-info">{{ $category['ticket_count'] }}</span>
                                            </td>
                                            <td class="align-middle text-center">
                                                <span class="badge badge-success">{{ $category['solved_count'] }}</span>
                                            </td>
                                            <td class="align-middle text-center">
                                                <span class="badge badge-warning">{{ $category['pending_count'] }}</span>
                                            </td>
                                        </tr>
                                    @endforeach
                                </tbody>
                            </table>
                        </div>
                    @else
                        <div class="alert alert-info mb-0">
                            <i class="fas fa-info-circle"></i> No categories found.
                        </div>
                    @endif
                </div>
            </div>
        </div>
    </div>

    <!-- Sub Categories Table Section -->
    <div class="row mb-4">
        <div class="col-12">
            <div class="card shadow-sm">
                <div class="card-header bg-success text-white">
                    <h5 class="mb-0"><i class="fas fa-folder-open"></i> Sub Categories</h5>
                </div>
                <div class="card-body">
                    <!-- Show Entries Control -->
                    <div class="row mb-3">
                        <div class="col-12">
                            <div class="d-flex align-items-center justify-content-between">
                                <div class="d-flex align-items-center">
                                    <span class="font-weight-bold text-muted mr-2" style="font-size: 0.9em; color: #6c757d;">SHOW</span>
                                    <select class="form-control form-control-sm" id="subcategoriesEntriesPerPage" style="width: auto; display: inline-block; margin: 0 8px; border: 1px solid #ced4da; border-radius: 4px; padding: 4px 30px 4px 8px; font-size: 0.9em; color: #495057;">
                                        <option value="10" selected>10</option>
                                        <option value="25">25</option>
                                        <option value="50">50</option>
                                        <option value="100">100</option>
                                        <option value="all">All</option>
                                    </select>
                                    <span class="font-weight-bold text-muted ml-2" style="font-size: 0.9em; color: #6c757d;">ENTRIES</span>
                                </div>
                                <div>
                                    <input type="text" id="subcategoriesSearch" class="form-control form-control-sm" placeholder="Search..." style="width: 200px; border: 1px solid #ced4da; border-radius: 4px; padding: 4px 8px; font-size: 0.9em;">
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    @if($subcategories->count() > 0)
                        <div class="table-responsive">
                            <table id="subcategoriesTable" class="table table-bordered table-hover table-striped">
                                <thead class="thead-dark">
                                    <tr>
                                        <th style="width: 80px;" class="text-center">SL</th>
                                        <th style="min-width: 200px;">Sub Category Name</th>
                                        <th style="min-width: 200px;">Category</th>
                                        <th style="min-width: 250px;">Description</th>
                                        <th style="min-width: 120px;" class="text-center">Total Tickets</th>
                                        <th style="min-width: 120px;" class="text-center">Solved Tickets</th>
                                        <th style="min-width: 120px;" class="text-center">Pending Tickets</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach($subcategories as $index => $subcategory)
                                        <tr>
                                            <td class="align-middle text-center">{{ $index + 1 }}</td>
                                            <td class="align-middle">
                                                <a href="{{ route('reseller-tickets.subcategory-details', $subcategory['id']) }}" style="text-decoration: none; color: #007bff; font-weight: bold;">
                                                    {{ $subcategory['name'] }}
                                                </a>
                                            </td>
                                            <td class="align-middle">
                                                <span class="badge badge-primary">{{ $subcategory['category_name'] }}</span>
                                            </td>
                                            <td class="align-middle">
                                                {{ $subcategory['description'] ?? 'N/A' }}
                                            </td>
                                            <td class="align-middle text-center">
                                                <span class="badge badge-info">{{ $subcategory['ticket_count'] }}</span>
                                            </td>
                                            <td class="align-middle text-center">
                                                <span class="badge badge-success">{{ $subcategory['solved_count'] }}</span>
                                            </td>
                                            <td class="align-middle text-center">
                                                <span class="badge badge-warning">{{ $subcategory['pending_count'] }}</span>
                                            </td>
                                        </tr>
                                    @endforeach
                                </tbody>
                            </table>
                        </div>
                    @else
                        <div class="alert alert-info mb-0">
                            <i class="fas fa-info-circle"></i> No subcategories found.
                        </div>
                    @endif
                </div>
            </div>
        </div>
    </div>
</div>

<style>
    tbody tr:hover {
        background-color: #f8f9fa !important;
    }
    .table-striped tbody tr:nth-of-type(odd) {
        background-color: rgba(0, 0, 0, 0.02);
    }
    .table-striped tbody tr:nth-of-type(even) {
        background-color: rgba(0, 0, 0, 0.05);
    }
</style>

<script>
// Categories Table Entries Control
document.addEventListener('DOMContentLoaded', function() {
    const categoriesEntriesSelect = document.getElementById('categoriesEntriesPerPage');
    const categoriesSearchInput = document.getElementById('categoriesSearch');
    const categoriesTable = document.getElementById('categoriesTable');
    
    if (categoriesEntriesSelect && categoriesTable) {
        const categoriesTbody = categoriesTable.querySelector('tbody');
        const categoriesRows = Array.from(categoriesTbody.querySelectorAll('tr'));
        
        // Store original rows
        const categoriesOriginalRows = categoriesRows.map(row => row.cloneNode(true));
        let categoriesFilteredRows = categoriesOriginalRows;
        
        function filterCategoriesRows(searchTerm) {
            if (!searchTerm || searchTerm.trim() === '') {
                categoriesFilteredRows = categoriesOriginalRows;
            } else {
                const term = searchTerm.toLowerCase();
                categoriesFilteredRows = categoriesOriginalRows.filter(row => {
                    const text = row.textContent.toLowerCase();
                    return text.includes(term);
                });
            }
            showCategoriesRows(categoriesEntriesSelect.value);
        }
        
        function showCategoriesRows(count) {
            // Clear tbody
            categoriesTbody.innerHTML = '';
            
            if (count === 'all') {
                // Show all filtered rows
                categoriesFilteredRows.forEach(row => categoriesTbody.appendChild(row.cloneNode(true)));
            } else {
                // Show limited filtered rows
                const limit = parseInt(count);
                categoriesFilteredRows.slice(0, limit).forEach(row => categoriesTbody.appendChild(row.cloneNode(true)));
            }
        }
        
        // Initial display
        showCategoriesRows(categoriesEntriesSelect.value);
        
        // Handle entries change event
        categoriesEntriesSelect.addEventListener('change', function() {
            showCategoriesRows(this.value);
        });
        
        // Handle search input event
        if (categoriesSearchInput) {
            categoriesSearchInput.addEventListener('input', function() {
                filterCategoriesRows(this.value);
            });
        }
    }
});

// Sub Categories Table Entries Control
document.addEventListener('DOMContentLoaded', function() {
    const subcategoriesEntriesSelect = document.getElementById('subcategoriesEntriesPerPage');
    const subcategoriesSearchInput = document.getElementById('subcategoriesSearch');
    const subcategoriesTable = document.getElementById('subcategoriesTable');
    
    if (subcategoriesEntriesSelect && subcategoriesTable) {
        const subcategoriesTbody = subcategoriesTable.querySelector('tbody');
        const subcategoriesRows = Array.from(subcategoriesTbody.querySelectorAll('tr'));
        
        // Store original rows
        const subcategoriesOriginalRows = subcategoriesRows.map(row => row.cloneNode(true));
        let subcategoriesFilteredRows = subcategoriesOriginalRows;
        
        function filterSubcategoriesRows(searchTerm) {
            if (!searchTerm || searchTerm.trim() === '') {
                subcategoriesFilteredRows = subcategoriesOriginalRows;
            } else {
                const term = searchTerm.toLowerCase();
                subcategoriesFilteredRows = subcategoriesOriginalRows.filter(row => {
                    const text = row.textContent.toLowerCase();
                    return text.includes(term);
                });
            }
            showSubcategoriesRows(subcategoriesEntriesSelect.value);
        }
        
        function showSubcategoriesRows(count) {
            // Clear tbody
            subcategoriesTbody.innerHTML = '';
            
            if (count === 'all') {
                // Show all filtered rows
                subcategoriesFilteredRows.forEach(row => subcategoriesTbody.appendChild(row.cloneNode(true)));
            } else {
                // Show limited filtered rows
                const limit = parseInt(count);
                subcategoriesFilteredRows.slice(0, limit).forEach(row => subcategoriesTbody.appendChild(row.cloneNode(true)));
            }
        }
        
        // Initial display
        showSubcategoriesRows(subcategoriesEntriesSelect.value);
        
        // Handle entries change event
        subcategoriesEntriesSelect.addEventListener('change', function() {
            showSubcategoriesRows(this.value);
        });
        
        // Handle search input event
        if (subcategoriesSearchInput) {
            subcategoriesSearchInput.addEventListener('input', function() {
                filterSubcategoriesRows(this.value);
            });
        }
    }
});
</script>
@endsection