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.25 TB

🔧 Quick Actions

✏️ Editing: manage-services.php

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

// Check if user is logged in
if (!isset($_SESSION['user_role'])) {
    header("Location: user-login.php");
    exit();
}

// Handle service deletion (with proper transaction handling)
if (isset($_GET['delete_id'])) {
    $delete_id = (int)$_GET['delete_id'];

// Start transaction for atomic operation
    mysqli_begin_transaction($conn);

try {
        // Check if service exists and get service details before deletion
        $check_sql = "SELECT id, service_name, category_id, selling_price FROM services WHERE id = ?";
        $check_stmt = mysqli_prepare($conn, $check_sql);
        
        if (!$check_stmt) {
            throw new Exception('Failed to prepare select statement: ' . mysqli_error($conn));
        }
        
        mysqli_stmt_bind_param($check_stmt, "i", $delete_id);
        mysqli_stmt_execute($check_stmt);
        $res = mysqli_stmt_get_result($check_stmt);
        
        if ($res && mysqli_num_rows($res) > 0) {
            $service_data = mysqli_fetch_assoc($res);
            mysqli_stmt_close($check_stmt);
            
            // Log deletion BEFORE deleting the service (to avoid foreign key constraint violation)
            $log_check = mysqli_query($conn, "SHOW TABLES LIKE 'service_logs'");
            if ($log_check && mysqli_num_rows($log_check) > 0) {
                $details_json = json_encode([
                    'service_name' => $service_data['service_name'] ?? null,
                    'category_id'   => $service_data['category_id'] ?? null,
                    'selling_price' => $service_data['selling_price'] ?? null
                ]);
                
                $log_sql = "INSERT INTO service_logs (service_id, action, details, created_at) VALUES (?, 'SERVICE_DELETED', ?, NOW())";
                $log_stmt = mysqli_prepare($conn, $log_sql);
                
                if ($log_stmt) {
                    mysqli_stmt_bind_param($log_stmt, "is", $delete_id, $details_json);
                    mysqli_stmt_execute($log_stmt);
                    mysqli_stmt_close($log_stmt);
                }
            }
            
            // Now delete the service
            $delete_sql = "DELETE FROM services WHERE id = ?";
            $del_stmt = mysqli_prepare($conn, $delete_sql);
            
            if (!$del_stmt) {
                throw new Exception('Failed to prepare delete statement: ' . mysqli_error($conn));
            }
            
            mysqli_stmt_bind_param($del_stmt, "i", $delete_id);
            
            if (mysqli_stmt_execute($del_stmt)) {
                // Also delete related logs to keep the table clean
                $cleanup_sql = "DELETE FROM service_logs WHERE service_id = ?";
                $cleanup_stmt = mysqli_prepare($conn, $cleanup_sql);
                if ($cleanup_stmt) {
                    mysqli_stmt_bind_param($cleanup_stmt, "i", $delete_id);
                    mysqli_stmt_execute($cleanup_stmt);
                    mysqli_stmt_close($cleanup_stmt);
                }
                
                mysqli_commit($conn);
                $success = 'Service deleted successfully!';
            } else {
                mysqli_rollback($conn);
                $error = 'Error deleting service: ' . mysqli_error($conn);
            }
            
            mysqli_stmt_close($del_stmt);
        } else {
            mysqli_stmt_close($check_stmt);
            mysqli_rollback($conn);
            $error = 'Service not found!';
        }
    } catch (Exception $e) {
        mysqli_rollback($conn);
        $error = 'Error: ' . $e->getMessage();
    }
}

// Handle service status toggle
if (isset($_GET['toggle_status'])) {
    $service_id = (int)$_GET['toggle_status'];

$status_sql = "SELECT status FROM services WHERE id = ?";
    if ($status_stmt = mysqli_prepare($conn, $status_sql)) {
        mysqli_stmt_bind_param($status_stmt, "i", $service_id);
        mysqli_stmt_execute($status_stmt);
        $status_res = mysqli_stmt_get_result($status_stmt);
        
        if ($status_res && mysqli_num_rows($status_res) > 0) {
            $service_row = mysqli_fetch_assoc($status_res);
            $old_status = $service_row['status'];
            $new_status = ($old_status == 'active') ? 'inactive' : 'active';
            mysqli_stmt_close($status_stmt);

$update_sql = "UPDATE services SET status = ?, updated_at = NOW() WHERE id = ?";
            if ($upd_stmt = mysqli_prepare($conn, $update_sql)) {
                mysqli_stmt_bind_param($upd_stmt, "si", $new_status, $service_id);
                
                if (mysqli_stmt_execute($upd_stmt)) {
                    $success = "Service status updated to $new_status!";

// Log status change if table exists
                    $log_check = mysqli_query($conn, "SHOW TABLES LIKE 'service_logs'");
                    if ($log_check && mysqli_num_rows($log_check) > 0) {
                        $details_json = json_encode(['old_status' => $old_status, 'new_status' => $new_status]);
                        $log_sql = "INSERT INTO service_logs (service_id, action, details, created_at) VALUES (?, 'STATUS_CHANGED', ?, NOW())";
                        if ($log_stmt = mysqli_prepare($conn, $log_sql)) {
                            mysqli_stmt_bind_param($log_stmt, "is", $service_id, $details_json);
                            mysqli_stmt_execute($log_stmt);
                            mysqli_stmt_close($log_stmt);
                        }
                    }
                } else {
                    $error = 'Error updating service status: ' . mysqli_error($conn);
                }
                mysqli_stmt_close($upd_stmt);
            }
        } else {
            mysqli_stmt_close($status_stmt);
            $error = 'Service not found for status update.';
        }
    }
}

// Search and filter parameters
$search = isset($_GET['search']) ? mysqli_real_escape_string($conn, trim($_GET['search'])) : '';
$category_filter = isset($_GET['category']) ? (int)$_GET['category'] : 0;
$status_filter = isset($_GET['status_filter']) ? $_GET['status_filter'] : '';
$gst_filter = isset($_GET['gst_filter']) ? $_GET['gst_filter'] : '';

// Build query with filters
$where_conditions = [];

if (!empty($search)) {
    $search_term = "%" . mysqli_real_escape_string($conn, $search) . "%";
    $where_conditions[] = "(s.service_name LIKE '$search_term' OR s.description LIKE '$search_term' OR s.hsn_code LIKE '$search_term')";
}

if ($category_filter > 0) {
    $where_conditions[] = "s.category_id = $category_filter";
}

if ($status_filter === 'active' || $status_filter === 'inactive') {
    $where_conditions[] = "s.status = '" . mysqli_real_escape_string($conn, $status_filter) . "'";
}

if ($gst_filter === 'with_gst') {
    $where_conditions[] = "s.is_gst_applicable = 1";
} elseif ($gst_filter === 'without_gst') {
    $where_conditions[] = "s.is_gst_applicable = 0";
}

$where_clause = '';
if (!empty($where_conditions)) {
    $where_clause = 'WHERE ' . implode(' AND ', $where_conditions);
}

// Get services with category names
$services_sql = "SELECT s.*, 
                COALESCE(sc.category_name, c.category_name, 'Uncategorized') as category_name
                FROM services s
                LEFT JOIN service_categories sc ON s.category_id = sc.id
                LEFT JOIN categories c ON s.category_id = c.id
                $where_clause
                ORDER BY s.created_at DESC";

$services_result = mysqli_query($conn, $services_sql);
$services = [];
$total_services = 0;
$total_active = 0;
$total_inactive = 0;
$total_gst = 0;

if ($services_result) {
    while ($service = mysqli_fetch_assoc($services_result)) {
        $services[] = $service;
        $total_services++;
        if ($service['status'] == 'active') {
            $total_active++;
        } else {
            $total_inactive++;
        }
        if ($service['is_gst_applicable'] == 1) {
            $total_gst++;
        }
    }
}

// Get categories for filter dropdown
$categories_sql = "SELECT id, category_name FROM service_categories WHERE status = 'active' 
                   UNION 
                   SELECT id, category_name FROM categories WHERE status = 'active'
                   ORDER BY category_name";
$categories_result = mysqli_query($conn, $categories_sql);
$categories = [];
if ($categories_result) {
    while ($cat = mysqli_fetch_assoc($categories_result)) {
        $categories[] = $cat;
    }
}
?>

<!doctype html>
<html lang="en">
<head>
    <?php include('includes/head.php'); ?>
    <style>
        .service-card {
            transition: all 0.3s ease;
            border: 1px solid #e9ecef;
        }
        .service-card:hover {
            transform: translateY(-2px);
            box-shadow: 0 4px 15px rgba(0,0,0,0.1);
            border-color: #007bff;
        }
        .badge-service {
            font-size: 0.75rem;
            padding: 0.25rem 0.5rem;
        }
        .status-active {
            color: #198754;
            background-color: rgba(25, 135, 84, 0.1);
        }
        .status-inactive {
            color: #6c757d;
            background-color: rgba(108, 117, 125, 0.1);
        }
        .profit-badge {
            background: linear-gradient(45deg, #28a745, #20c997);
            color: white;
        }
        .price-badge {
            background: linear-gradient(45deg, #007bff, #6610f2);
            color: white;
        }
        .gst-badge {
            background: linear-gradient(45deg, #dc3545, #fd7e14);
            color: white;
        }
        .gst-badge-secondary {
            background: linear-gradient(45deg, #0d6efd, #0dcaf0);
            color: white;
        }
        .gst-badge-invalid {
            background: linear-gradient(45deg, #ffc107, #ff9800);
            color: #000;
        }
        .action-buttons .btn {
            padding: 0.25rem 0.5rem;
            font-size: 0.875rem;
        }
        .table th {
            background-color: #f8f9fa;
            font-weight: 600;
        }
        .search-box {
            max-width: 300px;
        }
        .stats-card {

border: none;
            box-shadow: 0 2px 4px rgba(0,0,0,0.05);
        }
        .stats-icon {
            font-size: 2rem;
            opacity: 0.8;
        }
        .empty-state {
            padding: 3rem 1rem;
            text-align: center;
            color: #6c757d;
        }
        .empty-state i {
            font-size: 4rem;
            margin-bottom: 1rem;
            opacity: 0.3;
        }
    </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 mb-4">
                        <div class="col-md-3">
                            <div class="card stats-card">
                                <div class="card-body">
                                    <div class="d-flex justify-content-between align-items-center">
                                        <div>
                                            <h6 class="text-muted mb-2">Total Services</h6>
                                            <h3 class="mb-0"><?php echo $total_services; ?></h3>
                                        </div>
                                        <div class="stats-icon text-primary">
                                            <i class="fas fa-concierge-bell"></i>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="card stats-card">
                                <div class="card-body">
                                    <div class="d-flex justify-content-between align-items-center">
                                        <div>
                                            <h6 class="text-muted mb-2">Active Services</h6>
                                            <h3 class="mb-0"><?php echo $total_active; ?></h3>
                                        </div>
                                        <div class="stats-icon text-success">
                                            <i class="fas fa-check-circle"></i>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="card stats-card">
                                <div class="card-body">
                                    <div class="d-flex justify-content-between align-items-center">
                                        <div>
                                            <h6 class="text-muted mb-2">GST Services</h6>
                                            <h3 class="mb-0"><?php echo $total_gst; ?></h3>
                                        </div>
                                        <div class="stats-icon text-danger">
                                            <i class="fas fa-receipt"></i>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="card stats-card">
                                <div class="card-body">
                                    <div class="d-flex justify-content-between align-items-center">
                                        <div>
                                            <h6 class="text-muted mb-2">Avg. Profit</h6>
                                            <h3 class="mb-0">
                                                <?php 
                                                if ($total_services > 0) {
                                                    $avg_profit_sql = "SELECT AVG(profit) as avg_profit FROM services";
                                                    $avg_result = mysqli_query($conn, $avg_profit_sql);
                                                    $avg_data = mysqli_fetch_assoc($avg_result);
                                                    echo '₹' . number_format($avg_data['avg_profit'] ?? 0, 2);
                                                } else {
                                                    echo '₹0.00';
                                                }
                                                ?>
                                            </h3>
                                        </div>
                                        <div class="stats-icon text-warning">
                                            <i class="fas fa-chart-line"></i>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

<?php if (isset($success)): ?>
                        <div class="alert alert-success alert-dismissible fade show mb-4" role="alert">
                            <i class="fas fa-check-circle me-2"></i>
                            <?php echo htmlspecialchars($success); ?>
                            <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
                        </div>
                    <?php endif; ?>
                    
                    <?php if (isset($error)): ?>
                        <div class="alert alert-danger alert-dismissible fade show mb-4" role="alert">
                            <i class="fas fa-exclamation-circle me-2"></i>
                            <?php echo htmlspecialchars($error); ?>
                            <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
                        </div>
                    <?php endif; ?>

<div class="card mb-4">
                        <div class="card-body">
                            <div class="row">
                                <div class="col-md-8">
                                    <form method="GET" class="row g-2">
                                        <div class="col-md-4">
                                            <div class="input-group">
                                                <span class="input-group-text"><i class="fas fa-search"></i></span>
                                                <input type="text" name="search" class="form-control" 
                                                       placeholder="Search services..." 
                                                       value="<?php echo htmlspecialchars($search); ?>">
                                            </div>
                                        </div>
                                        <div class="col-md-3">
                                            <select name="category" class="form-control">
                                                <option value="">All Categories</option>
                                                <?php foreach ($categories as $cat): ?>
                                                    <option value="<?php echo $cat['id']; ?>"
                                                            <?php echo $category_filter == $cat['id'] ? 'selected' : ''; ?>>
                                                        <?php echo htmlspecialchars($cat['category_name']); ?>
                                                    </option>
                                                <?php endforeach; ?>
                                            </select>
                                        </div>
                                        <div class="col-md-2">
                                            <select name="status_filter" class="form-control">
                                                <option value="">All Status</option>
                                                <option value="active" <?php echo $status_filter == 'active' ? 'selected' : ''; ?>>Active</option>
                                                <option value="inactive" <?php echo $status_filter == 'inactive' ? 'selected' : ''; ?>>Inactive</option>
                                            </select>
                                        </div>
                                        <div class="col-md-2">
                                            <select name="gst_filter" class="form-control">
                                                <option value="">All GST</option>
                                                <option value="with_gst" <?php echo $gst_filter == 'with_gst' ? 'selected' : ''; ?>>With GST</option>
                                                <option value="without_gst" <?php echo $gst_filter == 'without_gst' ? 'selected' : ''; ?>>Without GST</option>
                                            </select>
                                        </div>
                                        <div class="col-md-1">
                                            <button type="submit" class="btn btn-primary w-100" title="Filter">
                                                <i class="fas fa-filter"></i>
                                            </button>
                                        </div>
                                    </form>
                                </div>
                                <div class="col-md-4 text-end">
                                    <a href="add-service.php" class="btn btn-success">
                                        <i class="fas fa-plus-circle me-1"></i> Add New Service
                                    </a>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="card">
                        <div class="card-body">
                            <?php if (empty($services)): ?>
                                
                                <div class="empty-state">
                                    <i class="fas fa-concierge-bell"></i>
                                    <h4>No Services Found</h4>
                                    <p class="mb-4"><?php echo empty($search) && empty($category_filter) && empty($status_filter) ? 
                                        'You haven\'t added any services yet.' : 
                                        'No services match your search criteria.'; ?></p>
                                    <a href="add-service.php" class="btn btn-success">
                                        <i class="fas fa-plus-circle me-1"></i>Add Your First Service
                                    </a>
                                </div>
                            <?php else: ?>
                                <div class="table-responsive">
                                    <table class="table table-hover">
                                        <thead>
                                            <tr>
                                                <th width="5%">#</th>
                                                <th width="20%">Service Name</th>
                                                <th width="10%">Category</th>
                                                <th width="10%">HSN Code</th>
                                                <th width="10%">GST</th>
                                                <th width="15%">Pricing</th>
                                                <th width="10%">Duration</th>
                                                <th width="10%">Status</th>
                                                <th width="10%">Actions</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php foreach ($services as $index => $service): ?>
                                                <tr>
                                                    <td><?php echo $index + 1; ?></td>
                                                    <td>
                                                        <div class="fw-semibold"><?php echo htmlspecialchars($service['service_name']); ?></div>
                                                        <?php if (!empty($service['description'])): ?>
                                                            <small class="text-muted"><?php echo substr(htmlspecialchars($service['description']), 0, 50); ?>...</small>
                                                        <?php endif; ?>
                                                    </td>
                                                    <td>
                                                        <span class="badge bg-light text-dark">
                                                            <?php echo htmlspecialchars($service['category_name']); ?>
                                                        </span>
                                                    </td>
                                                    <td>
                                                        <?php if (!empty($service['hsn_code'])): ?>
                                                            <span class="badge bg-secondary">
                                                                <?php echo htmlspecialchars($service['hsn_code']); ?>
                                                            </span>
                                                        <?php else: ?>
                                                            <span class="badge bg-light text-muted">N/A</span>
                                                        <?php endif; ?>
                                                    </td>
                                                    <td>
                                                        <?php 
                                                        $gst_percentage = isset($service['gst_percentage']) ? (float)$service['gst_percentage'] : 0;
                                                        $is_gst_applicable = isset($service['is_gst_applicable']) ? (int)$service['is_gst_applicable'] : 0;
                                                        
                                                        if ($is_gst_applicable == 1): 
                                                            if ($gst_percentage > 0 && $gst_percentage <= 100): ?>
                                                                <span class="badge gst-badge">
                                                                    <i class="fas fa-receipt me-1"></i>
                                                                    <?php echo number_format($gst_percentage, 2); ?>%
                                                                </span>
                                                            <?php elseif ($gst_percentage == 0): ?>
                                                                <span class="badge gst-badge-secondary">
                                                                    <i class="fas fa-receipt me-1"></i>
                                                                    GST Exempt (0%)
                                                                </span>
                                                            <?php else: ?>
                                                                <span class="badge gst-badge-invalid">
                                                                    <i class="fas fa-exclamation-triangle me-1"></i>
                                                                    Invalid GST
                                                                </span>
                                                            <?php endif; ?>
                                                        <?php else: ?>
                                                            <span class="badge bg-light text-muted">
                                                                <i class="fas fa-times me-1"></i>
                                                                No GST
                                                            </span>
                                                        <?php endif; ?>
                                                    </td>
                                                    <td>
                                                        <div class="d-flex flex-column gap-1">
                                                            <span class="badge price-badge">
                                                                <i class="fas fa-rupee-sign me-1"></i>
                                                                <?php echo number_format($service['selling_price'], 2); ?>
                                                            </span>
                                                            <?php if ($service['cost_price'] > 0): ?>
                                                                <span class="badge profit-badge">
                                                                    <i class="fas fa-chart-line me-1"></i>
                                                                    Profit: ₹<?php echo number_format($service['profit'], 2); ?>
                                                                </span>
                                                            <?php endif; ?>
                                                        </div>
                                                    </td>
                                                    <td>
                                                        <?php if (!empty($service['duration'])): ?>
                                                            <span class="badge bg-info">
                                                                <i class="fas fa-clock me-1"></i>
                                                                <?php echo htmlspecialchars($service['duration']); ?>
                                                            </span>
                                                        <?php else: ?>
                                                            <span class="badge bg-secondary">Not Set</span>
                                                        <?php endif; ?>
                                                    </td>
                                                    <td>
                                                        <span class="badge badge-service <?php echo $service['status'] == 'active' ? 'status-active' : 'status-inactive'; ?>">
                                                            <i class="fas fa-circle me-1" style="font-size: 0.5rem;"></i>
                                                            <?php echo ucfirst($service['status']); ?>
                                                        </span>
                                                    </td>
                                                    <td>
                                                        <div class="action-buttons d-flex gap-1">
                                                            <a href="edit-service.php?id=<?php echo $service['id']; ?>" 
                                                               class="btn btn-sm btn-outline-primary" 
                                                               title="Edit Service">
                                                                <i class="fas fa-edit"></i>
                                                            </a>
                                                            <a href="?toggle_status=<?php echo $service['id']; ?>" 
                                                               class="btn btn-sm btn-outline-warning" 
                                                               title="<?php echo $service['status'] == 'active' ? 'Deactivate' : 'Activate'; ?>"
                                                               onclick="return confirm('Are you sure you want to <?php echo $service['status'] == 'active' ? 'deactivate' : 'activate'; ?> this service?')">
                                                                <i class="fas fa-power-off"></i>
                                                            </a>
                                                            <a href="?delete_id=<?php echo $service['id']; ?>" 
                                                               class="btn btn-sm btn-outline-danger" 
                                                               title="Delete Service"
                                                               onclick="return confirm('Are you sure you want to delete this service? This action cannot be undone.')">
                                                                <i class="fas fa-trash"></i>
                                                            </a>
                                                        </div>
                                                    </td>
                                                </tr>
                                            <?php endforeach; ?>
                                        </tbody>
                                    </table>
                                </div>

<div class="row mt-4">
                                    <div class="col-md-12">
                                        <div class="alert alert-light">
                                            <div class="d-flex justify-content-between">
                                                <div>
                                                    <strong>Summary:</strong> 
                                                    Showing <?php echo count($services); ?> service(s)
                                                    <?php if (!empty($search)): ?>
                                                        matching "<strong><?php echo htmlspecialchars($search); ?></strong>"
                                                    <?php endif; ?>
                                                </div>
                                                <div>
                                                    <strong>Total Value:</strong> 
                                                    ₹<?php 
                                                        $total_selling_price = array_sum(array_column($services, 'selling_price'));
                                                        echo number_format($total_selling_price, 2);
                                                    ?>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            <?php endif; ?>
                        </div>
                    </div>

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

<?php include('includes/rightbar.php'); ?>
    <?php include('includes/scripts.php'); ?>
    
    <script>
    $(document).ready(function() {
        // Initialize tooltips
        $('[title]').tooltip();
        
        // Search with Enter key
        $('input[name="search"]').keypress(function(e) {
            if (e.which == 13) {
                $(this).closest('form').submit();
            }
        });
    });
    </script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: manage-services.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation