<?php
/**
 * Base Settings Page for Kayal Aqua
 * Manage categories, business segments, and system settings
 */

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

// Check permissions
if (!hasPermission('manage_categories')) {
    redirect('../index.php');
}

$pageTitle = 'Base Settings';
$breadcrumb = [
    ['title' => 'Base Settings']
];

$success = '';
$error = '';
$activeTab = $_GET['tab'] ?? 'categories';

// Handle form submissions
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    try {
        if (isset($_POST['action'])) {
            switch ($_POST['action']) {
                case 'add_category':
                    $name = sanitizeInput($_POST['name']);
                    $type = sanitizeInput($_POST['type']);
                    $segmentId = !empty($_POST['segment_id']) ? (int)$_POST['segment_id'] : null;
                    $description = sanitizeInput($_POST['description'] ?? '');

                    if (empty($name) || empty($type)) {
                        throw new Exception('Name and type are required.');
                    }

                    // Check if category already exists
                    $existing = fetchRow(
                        "SELECT id FROM categories WHERE name = ? AND type = ?",
                        [$name, $type]
                    );

                    if ($existing) {
                        throw new Exception('Category with this name and type already exists.');
                    }

                    $categoryData = [
                        'name' => $name,
                        'type' => $type,
                        'segment_id' => $segmentId,
                        'description' => $description,
                        'status' => 'active',
                        'created_at' => date('Y-m-d H:i:s')
                    ];

                    insertData('categories', $categoryData);
                    logSystemActivity('Add Category', "Added {$type} category: {$name}");
                    $success = 'Category added successfully!';
                    break;

                case 'update_category':
                    $id = (int)$_POST['id'];
                    $name = sanitizeInput($_POST['name']);
                    $description = sanitizeInput($_POST['description'] ?? '');
                    $segmentId = !empty($_POST['segment_id']) ? (int)$_POST['segment_id'] : null;
                    $status = sanitizeInput($_POST['status']);

                    if (empty($name)) {
                        throw new Exception('Category name is required.');
                    }

                    updateData('categories', [
                        'name' => $name,
                        'description' => $description,
                        'segment_id' => $segmentId,
                        'status' => $status
                    ], 'id = ?', [$id]);

                    logSystemActivity('Update Category', "Updated category ID: {$id}");
                    $success = 'Category updated successfully!';
                    break;

                case 'add_segment':
                    $name = sanitizeInput($_POST['name']);
                    $description = sanitizeInput($_POST['description'] ?? '');

                    if (empty($name)) {
                        throw new Exception('Segment name is required.');
                    }

                    // Check if segment already exists
                    $existing = fetchRow("SELECT id FROM business_segments WHERE name = ?", [$name]);
                    if ($existing) {
                        throw new Exception('Business segment already exists.');
                    }

                    $segmentData = [
                        'name' => $name,
                        'description' => $description,
                        'status' => 'active',
                        'created_at' => date('Y-m-d H:i:s')
                    ];

                    insertData('business_segments', $segmentData);
                    logSystemActivity('Add Segment', "Added business segment: {$name}");
                    $success = 'Business segment added successfully!';
                    break;

                case 'update_segment':
                    $id = (int)$_POST['id'];
                    $name = sanitizeInput($_POST['name']);
                    $description = sanitizeInput($_POST['description'] ?? '');
                    $status = sanitizeInput($_POST['status']);

                    updateData('business_segments', [
                        'name' => $name,
                        'description' => $description,
                        'status' => $status
                    ], 'id = ?', [$id]);

                    logSystemActivity('Update Segment', "Updated segment ID: {$id}");
                    $success = 'Business segment updated successfully!';
                    break;

                case 'update_settings':
                    $settings = $_POST['settings'] ?? [];
                    
                    foreach ($settings as $key => $value) {
                        $value = sanitizeInput($value);
                        updateAppSetting($key, $value);
                    }

                    logSystemActivity('Update Settings', 'Updated application settings');
                    $success = 'Settings updated successfully!';
                    break;
            }
        }
    } catch (Exception $e) {
        $error = $e->getMessage();
    }
}

// Get data for display
$categories = fetchAll("
    SELECT c.*, bs.name as segment_name 
    FROM categories c 
    LEFT JOIN business_segments bs ON c.segment_id = bs.id 
    ORDER BY c.type, c.name
");

$businessSegments = fetchAll("SELECT * FROM business_segments ORDER BY name");
$appSettings = getAppSettings();

// Group categories by type
$categoriesByType = [];
foreach ($categories as $category) {
    $categoriesByType[$category['type']][] = $category;
}

include '../includes/header.php';
?>

<div class="base-settings-container">
    <!-- Page Header -->
    <div class="page-header mb-4">
        <h1 class="page-title">
            <i class="fas fa-cogs"></i>
            Base Settings
        </h1>
        <p class="page-description">
            Manage your business categories, segments, and system settings.
        </p>
    </div>

    <!-- Success/Error Messages -->
    <?php if ($success): ?>
        <div class="alert alert-success alert-dismissible">
            <i class="fas fa-check-circle"></i>
            <?php echo htmlspecialchars($success); ?>
            <button type="button" class="btn-close" onclick="this.parentElement.remove()">×</button>
        </div>
    <?php endif; ?>

    <?php if ($error): ?>
        <div class="alert alert-danger alert-dismissible">
            <i class="fas fa-exclamation-circle"></i>
            <?php echo htmlspecialchars($error); ?>
            <button type="button" class="btn-close" onclick="this.parentElement.remove()">×</button>
        </div>
    <?php endif; ?>

    <!-- Settings Tabs -->
    <div class="tabs">
        <div class="tab-nav">
            <button class="tab-nav-item <?php echo $activeTab === 'categories' ? 'active' : ''; ?>" data-tab="categories">
                <i class="fas fa-tags"></i> Categories
            </button>
            <button class="tab-nav-item <?php echo $activeTab === 'segments' ? 'active' : ''; ?>" data-tab="segments">
                <i class="fas fa-layer-group"></i> Business Segments
            </button>
            <button class="tab-nav-item <?php echo $activeTab === 'settings' ? 'active' : ''; ?>" data-tab="settings">
                <i class="fas fa-sliders-h"></i> System Settings
            </button>
        </div>

        <!-- Categories Tab -->
        <div id="categories" class="tab-content <?php echo $activeTab === 'categories' ? 'active' : ''; ?>">
            <div class="row">
                <!-- Add Category Form -->
                <div class="col-lg-4 mb-4">
                    <div class="card">
                        <div class="card-header">
                            <h5 class="card-title">
                                <i class="fas fa-plus"></i>
                                Add New Category
                            </h5>
                        </div>
                        <div class="card-body">
                            <form method="POST" data-validate>
                                <input type="hidden" name="action" value="add_category">
                                
                                <div class="form-group">
                                    <label for="category_name" class="form-label">Category Name</label>
                                    <input type="text" id="category_name" name="name" class="form-control" required>
                                </div>

                                <div class="form-group">
                                    <label for="category_type" class="form-label">Type</label>
                                    <select id="category_type" name="type" class="form-control" required>
                                        <option value="">Select Type</option>
                                        <option value="revenue">Revenue</option>
                                        <option value="expense">Expense</option>
                                    </select>
                                </div>

                                <div class="form-group">
                                    <label for="category_segment" class="form-label">Business Segment (Optional)</label>
                                    <select id="category_segment" name="segment_id" class="form-control">
                                        <option value="">All Segments</option>
                                        <?php foreach ($businessSegments as $segment): ?>
                                            <option value="<?php echo $segment['id']; ?>">
                                                <?php echo htmlspecialchars($segment['name']); ?>
                                            </option>
                                        <?php endforeach; ?>
                                    </select>
                                </div>

                                <div class="form-group">
                                    <label for="category_description" class="form-label">Description</label>
                                    <textarea id="category_description" name="description" class="form-control" rows="3"></textarea>
                                </div>

                                <button type="submit" class="btn btn-primary btn-block">
                                    <i class="fas fa-plus"></i> Add Category
                                </button>
                            </form>
                        </div>
                    </div>
                </div>

                <!-- Categories List -->
                <div class="col-lg-8 mb-4">
                    <div class="card">
                        <div class="card-header">
                            <h5 class="card-title">
                                <i class="fas fa-list"></i>
                                Manage Categories
                            </h5>
                        </div>
                        <div class="card-body">
                            <?php if (empty($categories)): ?>
                                <div class="empty-state text-center py-4">
                                    <i class="fas fa-tags fa-3x text-muted mb-3"></i>
                                    <h6>No Categories Found</h6>
                                    <p class="text-muted">Start by adding your first category.</p>
                                </div>
                            <?php else: ?>
                                <!-- Revenue Categories -->
                                <?php if (!empty($categoriesByType['revenue'])): ?>
                                    <div class="category-section mb-4">
                                        <h6 class="section-title text-success">
                                            <i class="fas fa-arrow-up"></i> Revenue Categories
                                        </h6>
                                        <div class="table-responsive">
                                            <table class="table table-hover">
                                                <thead>
                                                    <tr>
                                                        <th>Name</th>
                                                        <th class="desktop-only">Segment</th>
                                                        <th class="desktop-only">Description</th>
                                                        <th>Status</th>
                                                        <th>Actions</th>
                                                    </tr>
                                                </thead>
                                                <tbody>
                                                    <?php foreach ($categoriesByType['revenue'] as $category): ?>
                                                        <tr>
                                                            <td>
                                                                <strong><?php echo htmlspecialchars($category['name']); ?></strong>
                                                                <div class="mobile-only">
                                                                    <small class="text-muted">
                                                                        <?php echo htmlspecialchars($category['segment_name'] ?? 'All Segments'); ?>
                                                                    </small>
                                                                </div>
                                                            </td>
                                                            <td class="desktop-only">
                                                                <?php echo htmlspecialchars($category['segment_name'] ?? 'All Segments'); ?>
                                                            </td>
                                                            <td class="desktop-only">
                                                                <?php echo htmlspecialchars($category['description'] ?: '-'); ?>
                                                            </td>
                                                            <td>
                                                                <span class="status-indicator status-<?php echo $category['status']; ?>">
                                                                    <span class="status-dot"></span>
                                                                    <?php echo ucfirst($category['status']); ?>
                                                                </span>
                                                            </td>
                                                            <td>
                                                                <button class="btn btn-sm btn-outline" 
                                                                        onclick="editCategory(<?php echo htmlspecialchars(json_encode($category)); ?>)">
                                                                    <i class="fas fa-edit"></i>
                                                                </button>
                                                            </td>
                                                        </tr>
                                                    <?php endforeach; ?>
                                                </tbody>
                                            </table>
                                        </div>
                                    </div>
                                <?php endif; ?>

                                <!-- Expense Categories -->
                                <?php if (!empty($categoriesByType['expense'])): ?>
                                    <div class="category-section">
                                        <h6 class="section-title text-danger">
                                            <i class="fas fa-arrow-down"></i> Expense Categories
                                        </h6>
                                        <div class="table-responsive">
                                            <table class="table table-hover">
                                                <thead>
                                                    <tr>
                                                        <th>Name</th>
                                                        <th class="desktop-only">Segment</th>
                                                        <th class="desktop-only">Description</th>
                                                        <th>Status</th>
                                                        <th>Actions</th>
                                                    </tr>
                                                </thead>
                                                <tbody>
                                                    <?php foreach ($categoriesByType['expense'] as $category): ?>
                                                        <tr>
                                                            <td>
                                                                <strong><?php echo htmlspecialchars($category['name']); ?></strong>
                                                                <div class="mobile-only">
                                                                    <small class="text-muted">
                                                                        <?php echo htmlspecialchars($category['segment_name'] ?? 'All Segments'); ?>
                                                                    </small>
                                                                </div>
                                                            </td>
                                                            <td class="desktop-only">
                                                                <?php echo htmlspecialchars($category['segment_name'] ?? 'All Segments'); ?>
                                                            </td>
                                                            <td class="desktop-only">
                                                                <?php echo htmlspecialchars($category['description'] ?: '-'); ?>
                                                            </td>
                                                            <td>
                                                                <span class="status-indicator status-<?php echo $category['status']; ?>">
                                                                    <span class="status-dot"></span>
                                                                    <?php echo ucfirst($category['status']); ?>
                                                                </span>
                                                            </td>
                                                            <td>
                                                                <button class="btn btn-sm btn-outline" 
                                                                        onclick="editCategory(<?php echo htmlspecialchars(json_encode($category)); ?>)">
                                                                    <i class="fas fa-edit"></i>
                                                                </button>
                                                            </td>
                                                        </tr>
                                                    <?php endforeach; ?>
                                                </tbody>
                                            </table>
                                        </div>
                                    </div>
                                <?php endif; ?>
                            <?php endif; ?>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <!-- Business Segments Tab -->
        <div id="segments" class="tab-content <?php echo $activeTab === 'segments' ? 'active' : ''; ?>">
            <div class="row">
                <!-- Add Segment Form -->
                <div class="col-lg-4 mb-4">
                    <div class="card">
                        <div class="card-header">
                            <h5 class="card-title">
                                <i class="fas fa-plus"></i>
                                Add Business Segment
                            </h5>
                        </div>
                        <div class="card-body">
                            <form method="POST" data-validate>
                                <input type="hidden" name="action" value="add_segment">
                                
                                <div class="form-group">
                                    <label for="segment_name" class="form-label">Segment Name</label>
                                    <input type="text" id="segment_name" name="name" class="form-control" required>
                                </div>

                                <div class="form-group">
                                    <label for="segment_description" class="form-label">Description</label>
                                    <textarea id="segment_description" name="description" class="form-control" rows="3"></textarea>
                                </div>

                                <button type="submit" class="btn btn-primary btn-block">
                                    <i class="fas fa-plus"></i> Add Segment
                                </button>
                            </form>
                        </div>
                    </div>
                </div>

                <!-- Segments List -->
                <div class="col-lg-8 mb-4">
                    <div class="card">
                        <div class="card-header">
                            <h5 class="card-title">
                                <i class="fas fa-layer-group"></i>
                                Manage Business Segments
                            </h5>
                        </div>
                        <div class="card-body">
                            <?php if (empty($businessSegments)): ?>
                                <div class="empty-state text-center py-4">
                                    <i class="fas fa-layer-group fa-3x text-muted mb-3"></i>
                                    <h6>No Business Segments Found</h6>
                                    <p class="text-muted">Create segments to organize your business activities.</p>
                                </div>
                            <?php else: ?>
                                <div class="table-responsive">
                                    <table class="table table-hover">
                                        <thead>
                                            <tr>
                                                <th>Name</th>
                                                <th class="desktop-only">Description</th>
                                                <th>Status</th>
                                                <th class="desktop-only">Created</th>
                                                <th>Actions</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php foreach ($businessSegments as $segment): ?>
                                                <tr>
                                                    <td>
                                                        <strong><?php echo htmlspecialchars($segment['name']); ?></strong>
                                                        <div class="mobile-only">
                                                            <small class="text-muted">
                                                                <?php echo htmlspecialchars($segment['description'] ?: 'No description'); ?>
                                                            </small>
                                                        </div>
                                                    </td>
                                                    <td class="desktop-only">
                                                        <?php echo htmlspecialchars($segment['description'] ?: '-'); ?>
                                                    </td>
                                                    <td>
                                                        <span class="status-indicator status-<?php echo $segment['status']; ?>">
                                                            <span class="status-dot"></span>
                                                            <?php echo ucfirst($segment['status']); ?>
                                                        </span>
                                                    </td>
                                                    <td class="desktop-only">
                                                        <?php echo formatDate($segment['created_at']); ?>
                                                    </td>
                                                    <td>
                                                        <button class="btn btn-sm btn-outline" 
                                                                onclick="editSegment(<?php echo htmlspecialchars(json_encode($segment)); ?>)">
                                                            <i class="fas fa-edit"></i>
                                                        </button>
                                                    </td>
                                                </tr>
                                            <?php endforeach; ?>
                                        </tbody>
                                    </table>
                                </div>
                            <?php endif; ?>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <!-- System Settings Tab -->
        <div id="settings" class="tab-content <?php echo $activeTab === 'settings' ? 'active' : ''; ?>">
            <div class="row">
                <div class="col-lg-8 mx-auto">
                    <div class="card">
                        <div class="card-header">
                            <h5 class="card-title">
                                <i class="fas fa-sliders-h"></i>
                                System Settings
                            </h5>
                        </div>
                        <div class="card-body">
                            <form method="POST">
                                <input type="hidden" name="action" value="update_settings">
                                
                                <div class="form-group">
                                    <label for="company_name" class="form-label">Company Name</label>
                                    <input type="text" id="company_name" name="settings[company_name]" 
                                           class="form-control" value="<?php echo htmlspecialchars($appSettings['company_name'] ?? 'Kayal Aqua'); ?>">
                                </div>

                                <div class="form-group">
                                    <label for="currency" class="form-label">Currency Symbol</label>
                                    <input type="text" id="currency" name="settings[currency]" 
                                           class="form-control" value="<?php echo htmlspecialchars($appSettings['currency'] ?? '₹'); ?>">
                                </div>

                                <div class="form-group">
                                    <label for="date_format" class="form-label">Date Format</label>
                                    <select id="date_format" name="settings[date_format]" class="form-control">
                                        <option value="d-m-Y" <?php echo ($appSettings['date_format'] ?? 'd-m-Y') === 'd-m-Y' ? 'selected' : ''; ?>>DD-MM-YYYY</option>
                                        <option value="m-d-Y" <?php echo ($appSettings['date_format'] ?? '') === 'm-d-Y' ? 'selected' : ''; ?>>MM-DD-YYYY</option>
                                        <option value="Y-m-d" <?php echo ($appSettings['date_format'] ?? '') === 'Y-m-d' ? 'selected' : ''; ?>>YYYY-MM-DD</option>
                                    </select>
                                </div>

                                <div class="form-group">
                                    <label for="timezone" class="form-label">Timezone</label>
                                    <select id="timezone" name="settings[timezone]" class="form-control">
                                        <option value="Asia/Kolkata" <?php echo ($appSettings['timezone'] ?? 'Asia/Kolkata') === 'Asia/Kolkata' ? 'selected' : ''; ?>>Asia/Kolkata (IST)</option>
                                        <option value="UTC" <?php echo ($appSettings['timezone'] ?? '') === 'UTC' ? 'selected' : ''; ?>>UTC</option>
                                    </select>
                                </div>

                                <button type="submit" class="btn btn-primary">
                                    <i class="fas fa-save"></i> Save Settings
                                </button>
                            </form>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<!-- Edit Category Modal -->
<div class="modal" id="editCategoryModal">
    <div class="modal-content">
        <div class="modal-header">
            <h3 class="modal-title">Edit Category</h3>
            <button class="modal-close" onclick="closeModal('editCategoryModal')">&times;</button>
        </div>
        <div class="modal-body">
            <form id="editCategoryForm" method="POST">
                <input type="hidden" name="action" value="update_category">
                <input type="hidden" name="id" id="edit_category_id">
                
                <div class="form-group">
                    <label for="edit_category_name" class="form-label">Category Name</label>
                    <input type="text" id="edit_category_name" name="name" class="form-control" required>
                </div>

                <div class="form-group">
                    <label for="edit_category_segment" class="form-label">Business Segment</label>
                    <select id="edit_category_segment" name="segment_id" class="form-control">
                        <option value="">All Segments</option>
                        <?php foreach ($businessSegments as $segment): ?>
                            <option value="<?php echo $segment['id']; ?>">
                                <?php echo htmlspecialchars($segment['name']); ?>
                            </option>
                        <?php endforeach; ?>
                    </select>
                </div>

                <div class="form-group">
                    <label for="edit_category_description" class="form-label">Description</label>
                    <textarea id="edit_category_description" name="description" class="form-control" rows="3"></textarea>
                </div>

                <div class="form-group">
                    <label for="edit_category_status" class="form-label">Status</label>
                    <select id="edit_category_status" name="status" class="form-control">
                        <option value="active">Active</option>
                        <option value="inactive">Inactive</option>
                    </select>
                </div>
            </form>
        </div>
        <div class="modal-footer">
            <button type="button" class="btn btn-outline" onclick="closeModal('editCategoryModal')">Cancel</button>
            <button type="submit" form="editCategoryForm" class="btn btn-primary">Update Category</button>
        </div>
    </div>
</div>

<!-- Edit Segment Modal -->
<div class="modal" id="editSegmentModal">
    <div class="modal-content">
        <div class="modal-header">
            <h3 class="modal-title">Edit Business Segment</h3>
            <button class="modal-close" onclick="closeModal('editSegmentModal')">&times;</button>
        </div>
        <div class="modal-body">
            <form id="editSegmentForm" method="POST">
                <input type="hidden" name="action" value="update_segment">
                <input type="hidden" name="id" id="edit_segment_id">
                
                <div class="form-group">
                    <label for="edit_segment_name" class="form-label">Segment Name</label>
                    <input type="text" id="edit_segment_name" name="name" class="form-control" required>
                </div>

                <div class="form-group">
                    <label for="edit_segment_description" class="form-label">Description</label>
                    <textarea id="edit_segment_description" name="description" class="form-control" rows="3"></textarea>
                </div>

                <div class="form-group">
                    <label for="edit_segment_status" class="form-label">Status</label>
                    <select id="edit_segment_status" name="status" class="form-control">
                        <option value="active">Active</option>
                        <option value="inactive">Inactive</option>
                    </select>
                </div>
            </form>
        </div>
        <div class="modal-footer">
            <button type="button" class="btn btn-outline" onclick="closeModal('editSegmentModal')">Cancel</button>
            <button type="submit" form="editSegmentForm" class="btn btn-primary">Update Segment</button>
        </div>
    </div>
</div>

<script>
function editCategory(category) {
    document.getElementById('edit_category_id').value = category.id;
    document.getElementById('edit_category_name').value = category.name;
    document.getElementById('edit_category_segment').value = category.segment_id || '';
    document.getElementById('edit_category_description').value = category.description || '';
    document.getElementById('edit_category_status').value = category.status;
    
    openModal('editCategoryModal');
}

function editSegment(segment) {
    document.getElementById('edit_segment_id').value = segment.id;
    document.getElementById('edit_segment_name').value = segment.name;
    document.getElementById('edit_segment_description').value = segment.description || '';
    document.getElementById('edit_segment_status').value = segment.status;
    
    openModal('editSegmentModal');
}

function openModal(modalId) {
    document.getElementById(modalId).classList.add('active');
    document.body.style.overflow = 'hidden';
}

function closeModal(modalId) {
    document.getElementById(modalId).classList.remove('active');
    document.body.style.overflow = '';
}

// Initialize tabs based on URL parameter
document.addEventListener('DOMContentLoaded', function() {
    const urlParams = new URLSearchParams(window.location.search);
    const tab = urlParams.get('tab');
    if (tab) {
        const tabButton = document.querySelector(`[data-tab="${tab}"]`);
        if (tabButton) {
            tabButton.click();
        }
    }
});
</script>

<style>
.section-title {
    font-weight: 600;
    margin-bottom: var(--space-md);
    padding-bottom: var(--space-sm);
    border-bottom: 2px solid currentColor;
}

.category-section {
    border: 1px solid var(--light-gray);
    border-radius: var(--border-radius);
    padding: var(--space-lg);
    background: var(--white);
}

.category-section:not(:last-child) {
    margin-bottom: var(--space-lg);
}

@media (max-width: 768px) {
    .card-actions {
        margin-top: var(--space-md);
    }
    
    .card-actions .btn {
        display: block;
        width: 100%;
        margin-bottom: var(--space-sm);
    }
}
</style>

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