<?php
/**
 * Admin Categories Management
 * Video Portal Management System
 */

require_once '../config/database.php';
require_once '../includes/functions.php';
require_once '../includes/auth.php';

requireAdmin();

$settings = getAllSettings();

$error = '';
$success = '';

// Handle form submissions
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $action = $_POST['action'] ?? '';
    
    if ($action === 'add') {
        $name = sanitize($_POST['name'] ?? '');
        $description = sanitize($_POST['description'] ?? '');
        $icon = sanitize($_POST['icon'] ?? 'fas fa-folder');
        $sortOrder = intval($_POST['sort_order'] ?? 0);
        $status = $_POST['status'] ?? 'active';
        
        if (empty($name)) {
            $error = 'Please enter a category name';
        } else {
            global $pdo;
            try {
                $stmt = $pdo->prepare("INSERT INTO categories (name, description, icon, sort_order, status) VALUES (?, ?, ?, ?, ?)");
                $stmt->execute([$name, $description, $icon, $sortOrder, $status]);
                $success = 'Category added successfully';
            } catch (PDOException $e) {
                $error = 'Failed to add category';
            }
        }
    } elseif ($action === 'edit') {
        $id = intval($_POST['id'] ?? 0);
        $name = sanitize($_POST['name'] ?? '');
        $description = sanitize($_POST['description'] ?? '');
        $icon = sanitize($_POST['icon'] ?? 'fas fa-folder');
        $sortOrder = intval($_POST['sort_order'] ?? 0);
        $status = $_POST['status'] ?? 'active';
        
        if (empty($name) || empty($id)) {
            $error = 'Invalid data';
        } else {
            global $pdo;
            try {
                $stmt = $pdo->prepare("UPDATE categories SET name = ?, description = ?, icon = ?, sort_order = ?, status = ? WHERE id = ?");
                $stmt->execute([$name, $description, $icon, $sortOrder, $status, $id]);
                $success = 'Category updated successfully';
            } catch (PDOException $e) {
                $error = 'Failed to update category';
            }
        }
    } elseif ($action === 'delete') {
        $id = intval($_POST['id'] ?? 0);
        if ($id) {
            global $pdo;
            try {
                // Check if category has videos
                $stmt = $pdo->prepare("SELECT COUNT(*) FROM videos WHERE category_id = ?");
                $stmt->execute([$id]);
                if ($stmt->fetchColumn() > 0) {
                    $error = 'Cannot delete category with videos. Move or delete videos first.';
                } else {
                    $stmt = $pdo->prepare("DELETE FROM categories WHERE id = ?");
                    $stmt->execute([$id]);
                    $success = 'Category deleted successfully';
                }
            } catch (PDOException $e) {
                $error = 'Failed to delete category';
            }
        }
    }
}

// Get all categories
$categories = getCategories(false);

$siteName = $settings['site_name'] ?? 'Video Portal';
$portalLogo = $settings['portal_logo'] ?? '';
$rtl = $settings['rtl_direction'] ?? '0';
?>
<!DOCTYPE html>
<html lang="<?php echo $rtl == '1' ? 'he' : 'en'; ?>" dir="<?php echo $rtl == '1' ? 'rtl' : 'ltr'; ?>">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Manage Categories - <?php echo htmlspecialchars($siteName); ?></title>
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css">
    <link rel="stylesheet" href="../assets/css/style.css">
    <?php if (!empty($settings['primary_color'])): ?>
    <style>
        :root {
            --primary-color: <?php echo $settings['primary_color']; ?>;
            --secondary-color: <?php echo $settings['secondary_color'] ?? '#2c3e50'; ?>;
            --sidebar-color: <?php echo $settings['sidebar_color'] ?? '#1e272e'; ?>;
        }
    </style>
    <?php endif; ?>
</head>
<body class="<?php echo $rtl == '1' ? 'rtl' : ''; ?>">
    <div class="portal-wrapper">
        <!-- Sidebar -->
        <aside class="sidebar">
            <div class="sidebar-header">
                <?php if (!empty($portalLogo)): ?>
                    <img src="../assets/uploads/logos/<?php echo $portalLogo; ?>" alt="<?php echo htmlspecialchars($siteName); ?>">
                <?php else: ?>
                    <i class="fas fa-play-circle" style="font-size: 40px;"></i>
                <?php endif; ?>
                <h2>Admin Panel</h2>
            </div>
            
            <ul class="sidebar-menu">
                <li>
                    <a href="dashboard.php">
                        <i class="fas fa-tachometer-alt"></i>
                        <span>Dashboard</span>
                    </a>
                </li>
                
                <li>
                    <a href="videos.php">
                        <i class="fas fa-video"></i>
                        <span>Videos</span>
                    </a>
                </li>
                
                <li>
                    <a href="categories.php" class="active">
                        <i class="fas fa-folder"></i>
                        <span>Categories</span>
                    </a>
                </li>
                
                <li>
                    <a href="users.php">
                        <i class="fas fa-users"></i>
                        <span>Users</span>
                    </a>
                </li>
                
                <li>
                    <a href="settings.php">
                        <i class="fas fa-cog"></i>
                        <span>Settings</span>
                    </a>
                </li>
                
                <li>
                    <a href="logs.php">
                        <i class="fas fa-file-alt"></i>
                        <span>Upload Logs</span>
                    </a>
                </li>
                
                <div class="menu-divider"></div>
                
                <li>
                    <a href="../index.php">
                        <i class="fas fa-home"></i>
                        <span>Back to Portal</span>
                    </a>
                </li>
                
                <li>
                    <a href="../logout.php">
                        <i class="fas fa-sign-out-alt"></i>
                        <span>Logout</span>
                    </a>
                </li>
            </ul>
        </aside>
        
        <!-- Main Content -->
        <main class="main-content">
            <!-- Top Bar -->
            <div class="top-bar">
                <h1><i class="fas fa-folder"></i> Manage Categories</h1>
                
                <button class="btn btn-primary" data-modal="addCategoryModal">
                    <i class="fas fa-plus"></i> Add Category
                </button>
            </div>
            
            <?php if ($error): ?>
                <div class="alert alert-danger">
                    <i class="fas fa-exclamation-circle"></i> <?php echo $error; ?>
                </div>
            <?php endif; ?>
            
            <?php if ($success): ?>
                <div class="alert alert-success">
                    <i class="fas fa-check-circle"></i> <?php echo $success; ?>
                </div>
            <?php endif; ?>
            
            <!-- Categories Table -->
            <div class="card">
                <div class="card-body">
                    <?php if (empty($categories)): ?>
                        <div class="empty-state">
                            <i class="fas fa-folder-open"></i>
                            <h3>No Categories</h3>
                            <p>Start by adding your first category</p>
                        </div>
                    <?php else: ?>
                        <div class="table-responsive">
                            <table class="table">
                                <thead>
                                    <tr>
                                        <th>Order</th>
                                        <th>Icon</th>
                                        <th>Name</th>
                                        <th>Description</th>
                                        <th>Status</th>
                                        <th>Actions</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    <?php foreach ($categories as $category): ?>
                                    <tr>
                                        <td><?php echo $category['sort_order']; ?></td>
                                        <td><i class="<?php echo $category['icon']; ?>"></i></td>
                                        <td><?php echo htmlspecialchars($category['name']); ?></td>
                                        <td><?php echo htmlspecialchars($category['description'] ?? '-'); ?></td>
                                        <td>
                                            <span class="badge badge-<?php echo $category['status'] === 'active' ? 'success' : 'danger'; ?>">
                                                <?php echo ucfirst($category['status']); ?>
                                            </span>
                                        </td>
                                        <td>
                                            <div class="actions">
                                                <button class="btn btn-primary btn-sm" 
                                                        onclick="editCategory(<?php echo htmlspecialchars(json_encode($category)); ?>)">
                                                    <i class="fas fa-edit"></i>
                                                </button>
                                                <form method="POST" style="display: inline;" 
                                                      onsubmit="return confirm('Are you sure you want to delete this category?');">
                                                    <input type="hidden" name="action" value="delete">
                                                    <input type="hidden" name="id" value="<?php echo $category['id']; ?>">
                                                    <button type="submit" class="btn btn-danger btn-sm">
                                                        <i class="fas fa-trash"></i>
                                                    </button>
                                                </form>
                                            </div>
                                        </td>
                                    </tr>
                                    <?php endforeach; ?>
                                </tbody>
                            </table>
                        </div>
                    <?php endif; ?>
                </div>
            </div>
            
            <!-- Icon Reference -->
            <div class="card">
                <div class="card-header">
                    <h2><i class="fas fa-icons"></i> Common Icons</h2>
                </div>
                <div class="card-body">
                    <p style="margin-bottom: 15px;">Use these Font Awesome icon classes:</p>
                    <div style="display: flex; flex-wrap: wrap; gap: 15px;">
                        <?php 
                        $icons = ['fas fa-folder', 'fas fa-video', 'fas fa-film', 'fas fa-play', 'fas fa-graduation-cap', 
                                  'fas fa-chalkboard-teacher', 'fas fa-book', 'fas fa-music', 'fas fa-gamepad', 
                                  'fas fa-code', 'fas fa-camera', 'fas fa-heart', 'fas fa-star', 'fas fa-home'];
                        foreach ($icons as $icon): ?>
                            <span style="padding: 10px; background: #f8f9fa; border-radius: 5px; cursor: pointer;" 
                                  onclick="copyIcon('<?php echo $icon; ?>')" title="Click to copy">
                                <i class="<?php echo $icon; ?>"></i> <?php echo $icon; ?>
                            </span>
                        <?php endforeach; ?>
                    </div>
                </div>
            </div>
        </main>
    </div>
    
    <!-- Add Category Modal -->
    <div class="modal-overlay" id="addCategoryModal">
        <div class="modal">
            <div class="modal-header">
                <h3><i class="fas fa-plus"></i> Add New Category</h3>
                <button class="modal-close">&times;</button>
            </div>
            <form method="POST">
                <div class="modal-body">
                    <input type="hidden" name="action" value="add">
                    
                    <div class="form-group">
                        <label>Category Name *</label>
                        <input type="text" name="name" class="form-control" required>
                    </div>
                    
                    <div class="form-group">
                        <label>Description</label>
                        <input type="text" name="description" class="form-control">
                    </div>
                    
                    <div class="form-group">
                        <label>Icon Class</label>
                        <input type="text" name="icon" class="form-control" value="fas fa-folder" placeholder="fas fa-folder">
                        <small style="color: #666;">Font Awesome icon class (e.g., fas fa-video)</small>
                    </div>
                    
                    <div class="form-group">
                        <label>Sort Order</label>
                        <input type="number" name="sort_order" class="form-control" value="0">
                    </div>
                    
                    <div class="form-group">
                        <label>Status</label>
                        <select name="status" class="form-control">
                            <option value="active">Active</option>
                            <option value="inactive">Inactive</option>
                        </select>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-dismiss="modal">Cancel</button>
                    <button type="submit" class="btn btn-primary">
                        <i class="fas fa-save"></i> Save Category
                    </button>
                </div>
            </form>
        </div>
    </div>
    
    <!-- Edit Category Modal -->
    <div class="modal-overlay" id="editCategoryModal">
        <div class="modal">
            <div class="modal-header">
                <h3><i class="fas fa-edit"></i> Edit Category</h3>
                <button class="modal-close">&times;</button>
            </div>
            <form method="POST">
                <div class="modal-body">
                    <input type="hidden" name="action" value="edit">
                    <input type="hidden" name="id" id="edit_id">
                    
                    <div class="form-group">
                        <label>Category Name *</label>
                        <input type="text" name="name" id="edit_name" class="form-control" required>
                    </div>
                    
                    <div class="form-group">
                        <label>Description</label>
                        <input type="text" name="description" id="edit_description" class="form-control">
                    </div>
                    
                    <div class="form-group">
                        <label>Icon Class</label>
                        <input type="text" name="icon" id="edit_icon" class="form-control">
                    </div>
                    
                    <div class="form-group">
                        <label>Sort Order</label>
                        <input type="number" name="sort_order" id="edit_sort_order" class="form-control">
                    </div>
                    
                    <div class="form-group">
                        <label>Status</label>
                        <select name="status" id="edit_status" class="form-control">
                            <option value="active">Active</option>
                            <option value="inactive">Inactive</option>
                        </select>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-dismiss="modal">Cancel</button>
                    <button type="submit" class="btn btn-primary">
                        <i class="fas fa-save"></i> Update Category
                    </button>
                </div>
            </form>
        </div>
    </div>
    
    <!-- Mobile Toggle -->
    <button class="mobile-toggle">
        <i class="fas fa-bars"></i>
    </button>
    
    <script src="../assets/js/script.js"></script>
    <script>
        function editCategory(category) {
            document.getElementById('edit_id').value = category.id;
            document.getElementById('edit_name').value = category.name;
            document.getElementById('edit_description').value = category.description || '';
            document.getElementById('edit_icon').value = category.icon;
            document.getElementById('edit_sort_order').value = category.sort_order;
            document.getElementById('edit_status').value = category.status;
            openModal('editCategoryModal');
        }
        
        function copyIcon(icon) {
            navigator.clipboard.writeText(icon);
            showAlert('success', 'Icon class copied: ' + icon);
        }
    </script>
</body>
</html>
