<?php
require_once 'auth.php';
$auth->requireLogin();

$page_title = 'Settings';
$success_message = '';
$error_message = '';

// Handle form submissions
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    try {
        switch ($_POST['action']) {
            case 'create_unit':
                $unit_name = trim($_POST['unit_name'] ?? '');
                $unit_symbol = trim($_POST['unit_symbol'] ?? '');
                $unit_type = $_POST['unit_type'] ?? '';
                
                if (empty($unit_name) || empty($unit_symbol) || empty($unit_type)) {
                    $error_message = 'All fields are required for unit creation.';
                } else {
                    $stmt = $pdo->prepare("SELECT id FROM units WHERE unit_name = ? OR unit_symbol = ?");
                    $stmt->execute([$unit_name, $unit_symbol]);
                    if ($stmt->fetch()) {
                        $error_message = 'Unit name or symbol already exists.';
                    } else {
                        $stmt = $pdo->prepare("INSERT INTO units (unit_name, unit_symbol, unit_type, created_by) VALUES (?, ?, ?, ?)");
                        if ($stmt->execute([$unit_name, $unit_symbol, $unit_type, $_SESSION['user_id']])) {
                            $_SESSION['success_message'] = 'Unit created successfully.';
                            header("Location: settings.php");
                            exit();
                        } else {
                            $error_message = 'Failed to create unit.';
                        }
                    }
                }
                break;
                
            case 'edit_unit':
                $unit_id = $_POST['unit_id'] ?? 0;
                $unit_name = trim($_POST['unit_name'] ?? '');
                $unit_symbol = trim($_POST['unit_symbol'] ?? '');
                $unit_type = $_POST['unit_type'] ?? '';
                
                if (empty($unit_name) || empty($unit_symbol) || empty($unit_type)) {
                    $error_message = 'All fields are required for unit update.';
                } else {
                    $stmt = $pdo->prepare("SELECT id FROM units WHERE (unit_name = ? OR unit_symbol = ?) AND id != ?");
                    $stmt->execute([$unit_name, $unit_symbol, $unit_id]);
                    if ($stmt->fetch()) {
                        $error_message = 'Unit name or symbol already exists.';
                    } else {
                        $stmt = $pdo->prepare("UPDATE units SET unit_name = ?, unit_symbol = ?, unit_type = ? WHERE id = ?");
                        if ($stmt->execute([$unit_name, $unit_symbol, $unit_type, $unit_id])) {
                            $_SESSION['success_message'] = 'Unit updated successfully.';
                            header("Location: settings.php");
                            exit();
                        } else {
                            $error_message = 'Failed to update unit.';
                        }
                    }
                }
                break;
                
            case 'delete_unit':
                $unit_id = $_POST['unit_id'] ?? 0;
                // Check if unit is being used by any products/services
                $stmt = $pdo->prepare("SELECT COUNT(*) FROM products_services WHERE unit_id = ?");
                $stmt->execute([$unit_id]);
                $usage_count = $stmt->fetchColumn();
                
                if ($usage_count > 0) {
                    $error_message = 'Cannot delete unit. It is being used by ' . $usage_count . ' product(s)/service(s).';
                } else {
                    $stmt = $pdo->prepare("DELETE FROM units WHERE id = ?");
                    if ($stmt->execute([$unit_id])) {
                        $_SESSION['success_message'] = 'Unit deleted successfully.';
                    } else {
                        $_SESSION['error_message'] = 'Failed to delete unit.';
                    }
                    header("Location: settings.php");
                    exit();
                }
                break;
                
            case 'create_expense_category':
                $category_name = trim($_POST['category_name'] ?? '');
                $description = trim($_POST['description'] ?? '');
                
                if (empty($category_name)) {
                    $error_message = 'Category name is required.';
                } else {
                    $stmt = $pdo->prepare("SELECT id FROM expense_categories WHERE category_name = ?");
                    $stmt->execute([$category_name]);
                    if ($stmt->fetch()) {
                        $error_message = 'Category already exists.';
                    } else {
                        $stmt = $pdo->prepare("INSERT INTO expense_categories (category_name, description, created_by) VALUES (?, ?, ?)");
                        if ($stmt->execute([$category_name, $description, $_SESSION['user_id']])) {
                            $_SESSION['success_message'] = 'Expense category created successfully.';
                            header("Location: settings.php");
                            exit();
                        } else {
                            $error_message = 'Failed to create category.';
                        }
                    }
                }
                break;
                
            case 'edit_expense_category':
                $category_id = $_POST['category_id'] ?? 0;
                $category_name = trim($_POST['category_name'] ?? '');
                $description = trim($_POST['description'] ?? '');
                
                if (empty($category_name)) {
                    $error_message = 'Category name is required.';
                } else {
                    $stmt = $pdo->prepare("SELECT id FROM expense_categories WHERE category_name = ? AND id != ?");
                    $stmt->execute([$category_name, $category_id]);
                    if ($stmt->fetch()) {
                        $error_message = 'Category name already exists.';
                    } else {
                        $stmt = $pdo->prepare("UPDATE expense_categories SET category_name = ?, description = ? WHERE id = ?");
                        if ($stmt->execute([$category_name, $description, $category_id])) {
                            $_SESSION['success_message'] = 'Category updated successfully.';
                            header("Location: settings.php");
                            exit();
                        } else {
                            $error_message = 'Failed to update category.';
                        }
                    }
                }
                break;
                
            case 'delete_expense_category':
                $category_id = $_POST['category_id'] ?? 0;
                // Check if category has subcategories
                $stmt = $pdo->prepare("SELECT COUNT(*) FROM expense_subcategories WHERE category_id = ?");
                $stmt->execute([$category_id]);
                $subcategory_count = $stmt->fetchColumn();
                
                if ($subcategory_count > 0) {
                    $error_message = 'Cannot delete category. It has ' . $subcategory_count . ' subcategory/subcategories.';
                } else {
                    $stmt = $pdo->prepare("DELETE FROM expense_categories WHERE id = ?");
                    if ($stmt->execute([$category_id])) {
                        $_SESSION['success_message'] = 'Category deleted successfully.';
                    } else {
                        $_SESSION['error_message'] = 'Failed to delete category.';
                    }
                    header("Location: settings.php");
                    exit();
                }
                break;
                
            case 'create_expense_subcategory':
                $category_id = $_POST['category_id'] ?? 0;
                $subcategory_name = trim($_POST['subcategory_name'] ?? '');
                $description = trim($_POST['description'] ?? '');
                
                if (empty($subcategory_name) || empty($category_id)) {
                    $error_message = 'Subcategory name and category are required.';
                } else {
                    $stmt = $pdo->prepare("SELECT id FROM expense_subcategories WHERE category_id = ? AND subcategory_name = ?");
                    $stmt->execute([$category_id, $subcategory_name]);
                    if ($stmt->fetch()) {
                        $error_message = 'Subcategory already exists in this category.';
                    } else {
                        $stmt = $pdo->prepare("INSERT INTO expense_subcategories (category_id, subcategory_name, description, created_by) VALUES (?, ?, ?, ?)");
                        if ($stmt->execute([$category_id, $subcategory_name, $description, $_SESSION['user_id']])) {
                            $_SESSION['success_message'] = 'Expense subcategory created successfully.';
                            header("Location: settings.php");
                            exit();
                        } else {
                            $error_message = 'Failed to create subcategory.';
                        }
                    }
                }
                break;
                
            case 'edit_expense_subcategory':
                $subcategory_id = $_POST['subcategory_id'] ?? 0;
                $category_id = $_POST['category_id'] ?? 0;
                $subcategory_name = trim($_POST['subcategory_name'] ?? '');
                $description = trim($_POST['description'] ?? '');
                
                if (empty($subcategory_name) || empty($category_id)) {
                    $error_message = 'Subcategory name and category are required.';
                } else {
                    $stmt = $pdo->prepare("SELECT id FROM expense_subcategories WHERE category_id = ? AND subcategory_name = ? AND id != ?");
                    $stmt->execute([$category_id, $subcategory_name, $subcategory_id]);
                    if ($stmt->fetch()) {
                        $error_message = 'Subcategory already exists in this category.';
                    } else {
                        $stmt = $pdo->prepare("UPDATE expense_subcategories SET category_id = ?, subcategory_name = ?, description = ? WHERE id = ?");
                        if ($stmt->execute([$category_id, $subcategory_name, $description, $subcategory_id])) {
                            $_SESSION['success_message'] = 'Subcategory updated successfully.';
                            header("Location: settings.php");
                            exit();
                        } else {
                            $error_message = 'Failed to update subcategory.';
                        }
                    }
                }
                break;
                
            case 'delete_expense_subcategory':
                $subcategory_id = $_POST['subcategory_id'] ?? 0;
                $stmt = $pdo->prepare("DELETE FROM expense_subcategories WHERE id = ?");
                if ($stmt->execute([$subcategory_id])) {
                    $_SESSION['success_message'] = 'Subcategory deleted successfully.';
                } else {
                    $_SESSION['error_message'] = 'Failed to delete subcategory.';
                }
                header("Location: settings.php");
                exit();
                break;
                
            case 'create_product_service':
                $name = trim($_POST['name'] ?? '');
                $type = $_POST['type'] ?? '';
                $description = trim($_POST['description'] ?? '');
                $unit_id = $_POST['unit_id'] ?? 0;
                $unit_rate = $_POST['unit_rate'] ?? 0;
                
                if (empty($name) || empty($type) || empty($unit_id)) {
                    $error_message = 'Name, type, and unit are required.';
                } elseif (!is_numeric($unit_rate) || $unit_rate < 0) {
                    $error_message = 'Please enter a valid unit rate.';
                } else {
                    $stmt = $pdo->prepare("SELECT id FROM products_services WHERE name = ?");
                    $stmt->execute([$name]);
                    if ($stmt->fetch()) {
                        $error_message = 'Product/Service name already exists.';
                    } else {
                        $stmt = $pdo->prepare("INSERT INTO products_services (name, type, description, unit_id, unit_rate, created_by) VALUES (?, ?, ?, ?, ?, ?)");
                        if ($stmt->execute([$name, $type, $description, $unit_id, $unit_rate, $_SESSION['user_id']])) {
                            $_SESSION['success_message'] = ucfirst($type) . ' created successfully.';
                            header("Location: settings.php");
                            exit();
                        } else {
                            $error_message = 'Failed to create ' . $type . '.';
                        }
                    }
                }
                break;
                
            case 'edit_product_service':
                $ps_id = $_POST['ps_id'] ?? 0;
                $name = trim($_POST['name'] ?? '');
                $type = $_POST['type'] ?? '';
                $description = trim($_POST['description'] ?? '');
                $unit_id = $_POST['unit_id'] ?? 0;
                $unit_rate = $_POST['unit_rate'] ?? 0;
                
                if (empty($name) || empty($type) || empty($unit_id)) {
                    $error_message = 'Name, type, and unit are required.';
                } elseif (!is_numeric($unit_rate) || $unit_rate < 0) {
                    $error_message = 'Please enter a valid unit rate.';
                } else {
                    $stmt = $pdo->prepare("SELECT id FROM products_services WHERE name = ? AND id != ?");
                    $stmt->execute([$name, $ps_id]);
                    if ($stmt->fetch()) {
                        $error_message = 'Product/Service name already exists.';
                    } else {
                        $stmt = $pdo->prepare("UPDATE products_services SET name = ?, type = ?, description = ?, unit_id = ?, unit_rate = ? WHERE id = ?");
                        if ($stmt->execute([$name, $type, $description, $unit_id, $unit_rate, $ps_id])) {
                            $_SESSION['success_message'] = 'Product/Service updated successfully.';
                            header("Location: settings.php");
                            exit();
                        } else {
                            $error_message = 'Failed to update product/service.';
                        }
                    }
                }
                break;
                
            case 'delete_product_service':
                $ps_id = $_POST['ps_id'] ?? 0;
                $stmt = $pdo->prepare("DELETE FROM products_services WHERE id = ?");
                if ($stmt->execute([$ps_id])) {
                    $_SESSION['success_message'] = 'Product/Service deleted successfully.';
                } else {
                    $_SESSION['error_message'] = 'Failed to delete product/service.';
                }
                header("Location: settings.php");
                exit();
                break;
                
            case 'toggle_unit_status':
                $unit_id = $_POST['unit_id'] ?? 0;
                $status = $_POST['status'] ?? 'active';
                $stmt = $pdo->prepare("UPDATE units SET status = ? WHERE id = ?");
                if ($stmt->execute([$status, $unit_id])) {
                    $_SESSION['success_message'] = 'Unit status updated successfully.';
                } else {
                    $_SESSION['error_message'] = 'Failed to update unit status.';
                }
                header("Location: settings.php");
                exit();
                break;
                
            case 'toggle_category_status':
                $category_id = $_POST['category_id'] ?? 0;
                $status = $_POST['status'] ?? 'active';
                $stmt = $pdo->prepare("UPDATE expense_categories SET status = ? WHERE id = ?");
                if ($stmt->execute([$status, $category_id])) {
                    $_SESSION['success_message'] = 'Category status updated successfully.';
                } else {
                    $_SESSION['error_message'] = 'Failed to update category status.';
                }
                header("Location: settings.php");
                exit();
                break;
                
            case 'toggle_product_status':
                $product_id = $_POST['product_id'] ?? 0;
                $status = $_POST['status'] ?? 'active';
                $stmt = $pdo->prepare("UPDATE products_services SET status = ? WHERE id = ?");
                if ($stmt->execute([$status, $product_id])) {
                    $_SESSION['success_message'] = 'Product/Service status updated successfully.';
                } else {
                    $_SESSION['error_message'] = 'Failed to update status.';
                }
                header("Location: settings.php");
                exit();
                break;
        }
    } catch (PDOException $e) {
        $error_message = 'Database error: ' . $e->getMessage();
    }
}

// Get edit data if editing
$edit_unit = null;
$edit_category = null;
$edit_subcategory = null;
$edit_ps = null;

if (isset($_GET['edit_unit'])) {
    $stmt = $pdo->prepare("SELECT * FROM units WHERE id = ?");
    $stmt->execute([$_GET['edit_unit']]);
    $edit_unit = $stmt->fetch(PDO::FETCH_ASSOC);
}

if (isset($_GET['edit_category'])) {
    $stmt = $pdo->prepare("SELECT * FROM expense_categories WHERE id = ?");
    $stmt->execute([$_GET['edit_category']]);
    $edit_category = $stmt->fetch(PDO::FETCH_ASSOC);
}

if (isset($_GET['edit_subcategory'])) {
    $stmt = $pdo->prepare("SELECT * FROM expense_subcategories WHERE id = ?");
    $stmt->execute([$_GET['edit_subcategory']]);
    $edit_subcategory = $stmt->fetch(PDO::FETCH_ASSOC);
}

if (isset($_GET['edit_ps'])) {
    $stmt = $pdo->prepare("SELECT * FROM products_services WHERE id = ?");
    $stmt->execute([$_GET['edit_ps']]);
    $edit_ps = $stmt->fetch(PDO::FETCH_ASSOC);
}

// Fetch data for display
try {
    // Fetch units
    $stmt = $pdo->prepare("SELECT * FROM units ORDER BY unit_type, unit_name");
    $stmt->execute();
    $units = $stmt->fetchAll(PDO::FETCH_ASSOC);
    
    // Fetch expense categories
    $stmt = $pdo->prepare("SELECT * FROM expense_categories ORDER BY category_name");
    $stmt->execute();
    $categories = $stmt->fetchAll(PDO::FETCH_ASSOC);
    
    // Fetch expense subcategories with category names
    $stmt = $pdo->prepare("
        SELECT es.*, ec.category_name 
        FROM expense_subcategories es 
        JOIN expense_categories ec ON es.category_id = ec.id 
        ORDER BY ec.category_name, es.subcategory_name
    ");
    $stmt->execute();
    $subcategories = $stmt->fetchAll(PDO::FETCH_ASSOC);
    
    // Fetch products/services with unit info
    $stmt = $pdo->prepare("
        SELECT ps.*, u.unit_name, u.unit_symbol 
        FROM products_services ps 
        JOIN units u ON ps.unit_id = u.id 
        ORDER BY ps.type, ps.name
    ");
    $stmt->execute();
    $products_services = $stmt->fetchAll(PDO::FETCH_ASSOC);
    
} catch (PDOException $e) {
    $error_message = 'Failed to fetch data: ' . $e->getMessage();
    $units = $categories = $subcategories = $products_services = [];
}

include 'includes/header.php';
?>

<div class="page-header">
    <h1 class="page-title">Settings</h1>
    <p class="page-subtitle">Configure your business settings and preferences</p>
</div>

<?php if ($error_message): ?>
    <div class="alert alert-error"><?php echo htmlspecialchars($error_message); ?></div>
<?php endif; ?>

<!-- Units Settings -->
<div class="card" id="units-section">
    <div class="card-header">
        <h2 class="card-title"><?php echo $edit_unit ? 'Edit Unit' : 'Units Management'; ?></h2>
    </div>
    
    <form method="POST" action="">
        <input type="hidden" name="action" value="<?php echo $edit_unit ? 'edit_unit' : 'create_unit'; ?>">
        <?php if ($edit_unit): ?>
            <input type="hidden" name="unit_id" value="<?php echo $edit_unit['id']; ?>">
        <?php endif; ?>
        
        <div style="display: grid; grid-template-columns: 1fr 1fr 1fr auto auto; gap: 1rem; align-items: end;">
            <div class="form-group">
                <label for="unit_name" class="form-label">Unit Name</label>
                <input type="text" id="unit_name" name="unit_name" class="form-input" 
                       placeholder="e.g., Kilogram" value="<?php echo htmlspecialchars($edit_unit['unit_name'] ?? ''); ?>" required>
            </div>
            
            <div class="form-group">
                <label for="unit_symbol" class="form-label">Symbol</label>
                <input type="text" id="unit_symbol" name="unit_symbol" class="form-input" 
                       placeholder="e.g., kg" maxlength="10" value="<?php echo htmlspecialchars($edit_unit['unit_symbol'] ?? ''); ?>" required>
            </div>
            
            <div class="form-group">
                <label for="unit_type" class="form-label">Type</label>
                <select id="unit_type" name="unit_type" class="form-select" required>
                    <option value="">Select Type</option>
                    <option value="weight" <?php echo ($edit_unit['unit_type'] ?? '') == 'weight' ? 'selected' : ''; ?>>Weight</option>
                    <option value="length" <?php echo ($edit_unit['unit_type'] ?? '') == 'length' ? 'selected' : ''; ?>>Length</option>
                    <option value="time" <?php echo ($edit_unit['unit_type'] ?? '') == 'time' ? 'selected' : ''; ?>>Time</option>
                    <option value="volume" <?php echo ($edit_unit['unit_type'] ?? '') == 'volume' ? 'selected' : ''; ?>>Volume</option>
                    <option value="quantity" <?php echo ($edit_unit['unit_type'] ?? '') == 'quantity' ? 'selected' : ''; ?>>Quantity</option>
                </select>
            </div>
            
            <button type="submit" class="btn btn-primary"><?php echo $edit_unit ? 'Update' : 'Add'; ?> Unit</button>
            <?php if ($edit_unit): ?>
                <a href="settings.php#units-section" class="btn btn-secondary">Cancel</a>
            <?php endif; ?>
        </div>
    </form>
    
    <?php if (!empty($units)): ?>
        <div class="table-container mt-2">
            <table class="table">
                <thead>
                    <tr>
                        <th>Name</th>
                        <th>Symbol</th>
                        <th>Type</th>
                        <th>Status</th>
                        <th>Actions</th>
                    </tr>
                </thead>
                <tbody>
                    <?php foreach ($units as $unit): ?>
                        <tr>
                            <td><?php echo htmlspecialchars($unit['unit_name']); ?></td>
                            <td><strong><?php echo htmlspecialchars($unit['unit_symbol']); ?></strong></td>
                            <td><?php echo ucfirst(htmlspecialchars($unit['unit_type'])); ?></td>
                            <td>
                                <span style="color: <?php echo $unit['status'] == 'active' ? 'var(--success)' : 'var(--error)'; ?>">
                                    <?php echo ucfirst(htmlspecialchars($unit['status'])); ?>
                                </span>
                            </td>
                            <td>
                                <div class="d-flex gap-1">
                                    <a href="settings.php?edit_unit=<?php echo $unit['id']; ?>#units-section" class="btn btn-secondary" style="padding: 0.3rem 0.8rem; font-size: 0.7rem;">Edit</a>
                                    
                                    <form method="POST" style="display: inline;">
                                        <input type="hidden" name="action" value="toggle_unit_status">
                                        <input type="hidden" name="unit_id" value="<?php echo $unit['id']; ?>">
                                        <input type="hidden" name="status" value="<?php echo $unit['status'] == 'active' ? 'inactive' : 'active'; ?>">
                                        <button type="submit" class="btn <?php echo $unit['status'] == 'active' ? 'btn-danger' : 'btn-success'; ?>" 
                                                style="padding: 0.3rem 0.8rem; font-size: 0.7rem;"
                                                data-confirm="Are you sure?">
                                            <?php echo $unit['status'] == 'active' ? 'Disable' : 'Enable'; ?>
                                        </button>
                                    </form>
                                    
                                    <form method="POST" style="display: inline;">
                                        <input type="hidden" name="action" value="delete_unit">
                                        <input type="hidden" name="unit_id" value="<?php echo $unit['id']; ?>">
                                        <button type="submit" class="btn btn-danger" 
                                                style="padding: 0.3rem 0.8rem; font-size: 0.7rem;"
                                                data-confirm="Are you sure you want to delete this unit? This action cannot be undone.">
                                            Delete
                                        </button>
                                    </form>
                                </div>
                            </td>
                        </tr>
                    <?php endforeach; ?>
                </tbody>
            </table>
        </div>
    <?php endif; ?>
</div>

<!-- Expense Categories -->
<div class="card" id="categories-section">
    <div class="card-header">
        <h2 class="card-title"><?php echo $edit_category ? 'Edit Expense Category' : 'Expense Categories'; ?></h2>
    </div>
    
    <form method="POST" action="">
        <input type="hidden" name="action" value="<?php echo $edit_category ? 'edit_expense_category' : 'create_expense_category'; ?>">
        <?php if ($edit_category): ?>
            <input type="hidden" name="category_id" value="<?php echo $edit_category['id']; ?>">
        <?php endif; ?>
        
        <div style="display: grid; grid-template-columns: 1fr 2fr auto auto; gap: 1rem; align-items: end;">
            <div class="form-group">
                <label for="category_name" class="form-label">Category Name</label>
                <input type="text" id="category_name" name="category_name" class="form-input" 
                       placeholder="e.g., Feed Costs" value="<?php echo htmlspecialchars($edit_category['category_name'] ?? ''); ?>" required>
            </div>
            
            <div class="form-group">
                <label for="category_description" class="form-label">Description (Optional)</label>
                <input type="text" id="category_description" name="description" class="form-input" 
                       placeholder="Brief description" value="<?php echo htmlspecialchars($edit_category['description'] ?? ''); ?>">
            </div>
            
            <button type="submit" class="btn btn-primary"><?php echo $edit_category ? 'Update' : 'Add'; ?> Category</button>
            <?php if ($edit_category): ?>
                <a href="settings.php#categories-section" class="btn btn-secondary">Cancel</a>
            <?php endif; ?>
        </div>
    </form>
    
    <?php if (!empty($categories)): ?>
        <div class="table-container mt-2">
            <table class="table">
                <thead>
                    <tr>
                        <th>Category Name</th>
                        <th>Description</th>
                        <th>Status</th>
                        <th>Actions</th>
                    </tr>
                </thead>
                <tbody>
                    <?php foreach ($categories as $category): ?>
                        <tr>
                            <td><strong><?php echo htmlspecialchars($category['category_name']); ?></strong></td>
                            <td><?php echo htmlspecialchars($category['description'] ?: '-'); ?></td>
                            <td>
                                <span style="color: <?php echo $category['status'] == 'active' ? 'var(--success)' : 'var(--error)'; ?>">
                                    <?php echo ucfirst(htmlspecialchars($category['status'])); ?>
                                </span>
                            </td>
                            <td>
                                <div class="d-flex gap-1">
                                    <a href="settings.php?edit_category=<?php echo $category['id']; ?>#categories-section" class="btn btn-secondary" style="padding: 0.3rem 0.8rem; font-size: 0.7rem;">Edit</a>
                                    
                                    <form method="POST" style="display: inline;">
                                        <input type="hidden" name="action" value="toggle_category_status">
                                        <input type="hidden" name="category_id" value="<?php echo $category['id']; ?>">
                                        <input type="hidden" name="status" value="<?php echo $category['status'] == 'active' ? 'inactive' : 'active'; ?>">
                                        <button type="submit" class="btn <?php echo $category['status'] == 'active' ? 'btn-danger' : 'btn-success'; ?>" 
                                                style="padding: 0.3rem 0.8rem; font-size: 0.7rem;"
                                                data-confirm="Are you sure?">
                                            <?php echo $category['status'] == 'active' ? 'Disable' : 'Enable'; ?>
                                        </button>
                                    </form>
                                    
                                    <form method="POST" style="display: inline;">
                                        <input type="hidden" name="action" value="delete_expense_category">
                                        <input type="hidden" name="category_id" value="<?php echo $category['id']; ?>">
                                        <button type="submit" class="btn btn-danger" 
                                                style="padding: 0.3rem 0.8rem; font-size: 0.7rem;"
                                                data-confirm="Are you sure you want to delete this category? This action cannot be undone.">
                                            Delete
                                        </button>
                                    </form>
                                </div>
                            </td>
                        </tr>
                    <?php endforeach; ?>
                </tbody>
            </table>
        </div>
    <?php endif; ?>
</div>

<!-- Expense Subcategories -->
<div class="card" id="subcategories-section">
    <div class="card-header">
        <h2 class="card-title"><?php echo $edit_subcategory ? 'Edit Expense Subcategory' : 'Expense Subcategories'; ?></h2>
    </div>
    
    <form method="POST" action="">
        <input type="hidden" name="action" value="<?php echo $edit_subcategory ? 'edit_expense_subcategory' : 'create_expense_subcategory'; ?>">
        <?php if ($edit_subcategory): ?>
            <input type="hidden" name="subcategory_id" value="<?php echo $edit_subcategory['id']; ?>">
        <?php endif; ?>
        
        <div style="display: grid; grid-template-columns: 1fr 1fr 1fr auto auto; gap: 1rem; align-items: end;">
            <div class="form-group">
                <label for="category_id" class="form-label">Main Category</label>
                <select id="category_id" name="category_id" class="form-select" required>
                    <option value="">Select Category</option>
                    <?php foreach ($categories as $category): ?>
                        <?php if ($category['status'] == 'active'): ?>
                            <option value="<?php echo $category['id']; ?>" <?php echo ($edit_subcategory['category_id'] ?? '') == $category['id'] ? 'selected' : ''; ?>>
                                <?php echo htmlspecialchars($category['category_name']); ?>
                            </option>
                        <?php endif; ?>
                    <?php endforeach; ?>
                </select>
            </div>
            
            <div class="form-group">
                <label for="subcategory_name" class="form-label">Subcategory Name</label>
                <input type="text" id="subcategory_name" name="subcategory_name" class="form-input" 
                       placeholder="e.g., Fish Feed" value="<?php echo htmlspecialchars($edit_subcategory['subcategory_name'] ?? ''); ?>" required>
            </div>
            
            <div class="form-group">
                <label for="subcategory_description" class="form-label">Description (Optional)</label>
                <input type="text" id="subcategory_description" name="description" class="form-input" 
                       placeholder="Brief description" value="<?php echo htmlspecialchars($edit_subcategory['description'] ?? ''); ?>">
            </div>
            
            <button type="submit" class="btn btn-primary"><?php echo $edit_subcategory ? 'Update' : 'Add'; ?> Subcategory</button>
            <?php if ($edit_subcategory): ?>
                <a href="settings.php#subcategories-section" class="btn btn-secondary">Cancel</a>
            <?php endif; ?>
        </div>
    </form>
    
    <?php if (!empty($subcategories)): ?>
        <div class="table-container mt-2">
            <table class="table">
                <thead>
                    <tr>
                        <th>Main Category</th>
                        <th>Subcategory</th>
                        <th>Description</th>
                        <th>Status</th>
                        <th>Actions</th>
                    </tr>
                </thead>
                <tbody>
                    <?php foreach ($subcategories as $subcategory): ?>
                        <tr>
                            <td><?php echo htmlspecialchars($subcategory['category_name']); ?></td>
                            <td><strong><?php echo htmlspecialchars($subcategory['subcategory_name']); ?></strong></td>
                            <td><?php echo htmlspecialchars($subcategory['description'] ?: '-'); ?></td>
                            <td>
                                <span style="color: <?php echo $subcategory['status'] == 'active' ? 'var(--success)' : 'var(--error)'; ?>">
                                    <?php echo ucfirst(htmlspecialchars($subcategory['status'])); ?>
                                </span>
                            </td>
                            <td>
                                <div class="d-flex gap-1">
                                    <a href="settings.php?edit_subcategory=<?php echo $subcategory['id']; ?>#subcategories-section" class="btn btn-secondary" style="padding: 0.3rem 0.8rem; font-size: 0.7rem;">Edit</a>
                                    
                                    <form method="POST" style="display: inline;">
                                        <input type="hidden" name="action" value="delete_expense_subcategory">
                                        <input type="hidden" name="subcategory_id" value="<?php echo $subcategory['id']; ?>">
                                        <button type="submit" class="btn btn-danger" 
                                                style="padding: 0.3rem 0.8rem; font-size: 0.7rem;"
                                                data-confirm="Are you sure you want to delete this subcategory? This action cannot be undone.">
                                            Delete
                                        </button>
                                    </form>
                                </div>
                            </td>
                        </tr>
                    <?php endforeach; ?>
                </tbody>
            </table>
        </div>
    <?php endif; ?>
</div>

<!-- Products/Services -->
<div class="card" id="products-section">
    <div class="card-header">
        <h2 class="card-title"><?php echo $edit_ps ? 'Edit Product/Service' : 'Products & Services'; ?></h2>
    </div>
    
    <form method="POST" action="">
        <input type="hidden" name="action" value="<?php echo $edit_ps ? 'edit_product_service' : 'create_product_service'; ?>">
        <?php if ($edit_ps): ?>
            <input type="hidden" name="ps_id" value="<?php echo $edit_ps['id']; ?>">
        <?php endif; ?>
        
        <div style="display: grid; grid-template-columns: 1fr 1fr 1fr 1fr 100px auto auto; gap: 1rem; align-items: end;">
            <div class="form-group">
                <label for="ps_name" class="form-label">Name</label>
                <input type="text" id="ps_name" name="name" class="form-input" 
                       placeholder="e.g., Live Fish" value="<?php echo htmlspecialchars($edit_ps['name'] ?? ''); ?>" required>
            </div>
            
            <div class="form-group">
                <label for="ps_type" class="form-label">Type</label>
                <select id="ps_type" name="type" class="form-select" required>
                    <option value="">Select Type</option>
                    <option value="product" <?php echo ($edit_ps['type'] ?? '') == 'product' ? 'selected' : ''; ?>>Product</option>
                    <option value="service" <?php echo ($edit_ps['type'] ?? '') == 'service' ? 'selected' : ''; ?>>Service</option>
                </select>
            </div>
            
            <div class="form-group">
                <label for="ps_unit_id" class="form-label">Unit</label>
                <select id="ps_unit_id" name="unit_id" class="form-select" required>
                    <option value="">Select Unit</option>
                    <?php foreach ($units as $unit): ?>
                        <?php if ($unit['status'] == 'active'): ?>
                            <option value="<?php echo $unit['id']; ?>" <?php echo ($edit_ps['unit_id'] ?? '') == $unit['id'] ? 'selected' : ''; ?>>
                                <?php echo htmlspecialchars($unit['unit_name'] . ' (' . $unit['unit_symbol'] . ')'); ?>
                            </option>
                        <?php endif; ?>
                    <?php endforeach; ?>
                </select>
            </div>
            
            <div class="form-group">
                <label for="ps_description" class="form-label">Description</label>
                <input type="text" id="ps_description" name="description" class="form-input" 
                       placeholder="Optional" value="<?php echo htmlspecialchars($edit_ps['description'] ?? ''); ?>">
            </div>
            
            <div class="form-group">
                <label for="ps_unit_rate" class="form-label">Rate (₹)</label>
                <input type="number" id="ps_unit_rate" name="unit_rate" class="form-input" 
                       step="0.01" min="0" placeholder="0.00" value="<?php echo $edit_ps['unit_rate'] ?? ''; ?>" required>
            </div>
            
            <button type="submit" class="btn btn-primary"><?php echo $edit_ps ? 'Update' : 'Add'; ?> Item</button>
            <?php if ($edit_ps): ?>
                <a href="settings.php#products-section" class="btn btn-secondary">Cancel</a>
            <?php endif; ?>
        </div>
    </form>
    
    <?php if (!empty($products_services)): ?>
        <div class="table-container mt-2">
            <table class="table">
                <thead>
                    <tr>
                        <th>Name</th>
                        <th>Type</th>
                        <th>Unit</th>
                        <th>Rate (₹)</th>
                        <th>Description</th>
                        <th>Status</th>
                        <th>Actions</th>
                    </tr>
                </thead>
                <tbody>
                    <?php foreach ($products_services as $ps): ?>
                        <tr>
                            <td><strong><?php echo htmlspecialchars($ps['name']); ?></strong></td>
                            <td><?php echo ucfirst(htmlspecialchars($ps['type'])); ?></td>
                            <td><?php echo htmlspecialchars($ps['unit_name'] . ' (' . $ps['unit_symbol'] . ')'); ?></td>
                            <td>₹<?php echo number_format($ps['unit_rate'], 2); ?></td>
                            <td><?php echo htmlspecialchars($ps['description'] ?: '-'); ?></td>
                            <td>
                                <span style="color: <?php echo $ps['status'] == 'active' ? 'var(--success)' : 'var(--error)'; ?>">
                                    <?php echo ucfirst(htmlspecialchars($ps['status'])); ?>
                                </span>
                            </td>
                            <td>
                                <div class="d-flex gap-1">
                                    <a href="settings.php?edit_ps=<?php echo $ps['id']; ?>#products-section" class="btn btn-secondary" style="padding: 0.3rem 0.8rem; font-size: 0.7rem;">Edit</a>
                                    
                                    <form method="POST" style="display: inline;">
                                        <input type="hidden" name="action" value="toggle_product_status">
                                        <input type="hidden" name="product_id" value="<?php echo $ps['id']; ?>">
                                        <input type="hidden" name="status" value="<?php echo $ps['status'] == 'active' ? 'inactive' : 'active'; ?>">
                                        <button type="submit" class="btn <?php echo $ps['status'] == 'active' ? 'btn-danger' : 'btn-success'; ?>" 
                                                style="padding: 0.3rem 0.8rem; font-size: 0.7rem;"
                                                data-confirm="Are you sure?">
                                            <?php echo $ps['status'] == 'active' ? 'Disable' : 'Enable'; ?>
                                        </button>
                                    </form>
                                    
                                    <form method="POST" style="display: inline;">
                                        <input type="hidden" name="action" value="delete_product_service">
                                        <input type="hidden" name="ps_id" value="<?php echo $ps['id']; ?>">
                                        <button type="submit" class="btn btn-danger" 
                                                style="padding: 0.3rem 0.8rem; font-size: 0.7rem;"
                                                data-confirm="Are you sure you want to delete this product/service? This action cannot be undone.">
                                            Delete
                                        </button>
                                    </form>
                                </div>
                            </td>
                        </tr>
                    <?php endforeach; ?>
                </tbody>
            </table>
        </div>
    <?php endif; ?>
</div>

<?php include 'includes/footer.php'; ?>