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/pennagaram.org/public_html/admin

Free Space:

10.3 TB

🔧 Quick Actions

✏️ Editing: manage-shops.php

<!doctype html>
<html lang="en">
<?php
include('includes/head.php');
include('includes/db.php');

// Handle actions (delete, status change)
if (isset($_GET['action']) && isset($_GET['id'])) {
    $shopId = intval($_GET['id']);
    $action = $_GET['action'];
    
    if ($action === 'delete') {
        // Delete shop
        $deleteSql = "DELETE FROM shops1 WHERE id = ?";
        $stmt = mysqli_prepare($conn, $deleteSql);
        mysqli_stmt_bind_param($stmt, 'i', $shopId);
        if (mysqli_stmt_execute($stmt)) {
            $successMsg = "Shop deleted successfully!";
        } else {
            $errorMsg = "Failed to delete shop: " . mysqli_error($conn);
        }
        mysqli_stmt_close($stmt);
    } elseif ($action === 'toggle_status') {
        // Toggle shop status
        $currentStatus = $_GET['current_status'];
        $newStatus = $currentStatus === 'approved' ? 'pending' : 'approved';
        
        $updateSql = "UPDATE shops1 SET status = ? WHERE id = ?";
        $stmt = mysqli_prepare($conn, $updateSql);
        mysqli_stmt_bind_param($stmt, 'si', $newStatus, $shopId);
        if (mysqli_stmt_execute($stmt)) {
            $successMsg = "Shop status updated successfully!";
        } else {
            $errorMsg = "Failed to update shop status: " . mysqli_error($conn);
        }
        mysqli_stmt_close($stmt);
    }
}

// Get search and filter parameters
$search = $_GET['search'] ?? '';
$status = $_GET['status'] ?? '';
$category = $_GET['category'] ?? '';
$page = $_GET['page'] ?? 1;
$per_page = 10;
$offset = ($page - 1) * $per_page;

// Build query for shops
$shop_query = "SELECT s.*, sc.name as category_name 
               FROM shops1 s 
               LEFT JOIN shop_categories sc ON s.business_type = sc.id 
               WHERE 1=1";

$count_query = "SELECT COUNT(*) as total 
                FROM shops1 s 
                LEFT JOIN shop_categories sc ON s.business_type = sc.id 
                WHERE 1=1";

// Add search filter
if (!empty($search)) {
    $search_term = mysqli_real_escape_string($conn, $search);
    $shop_query .= " AND (s.shop_name LIKE '%$search_term%' 
                         OR s.owner_name LIKE '%$search_term%' 
                         OR s.mobile LIKE '%$search_term%' 
                         OR s.email LIKE '%$search_term%')";
    $count_query .= " AND (s.shop_name LIKE '%$search_term%' 
                          OR s.owner_name LIKE '%$search_term%' 
                          OR s.mobile LIKE '%$search_term%' 
                          OR s.email LIKE '%$search_term%')";
}

// Add status filter
if (!empty($status) && in_array($status, ['pending', 'approved', 'rejected'])) {
    $shop_query .= " AND s.status = '$status'";
    $count_query .= " AND s.status = '$status'";
}

// Add category filter
if (!empty($category)) {
    $category_filter = mysqli_real_escape_string($conn, $category);
    $shop_query .= " AND sc.id = '$category_filter'";
    $count_query .= " AND sc.id = '$category_filter'";
}

// Add ordering and pagination
$shop_query .= " ORDER BY s.created_at DESC LIMIT $per_page OFFSET $offset";

// Execute shop query
$shop_result = mysqli_query($conn, $shop_query);
$shops = [];
while($row = mysqli_fetch_assoc($shop_result)) {
    $shops[] = $row;
}

// Execute count query for pagination
$count_result = mysqli_query($conn, $count_query);
$total_shops = mysqli_fetch_assoc($count_result)['total'];
$total_pages = ceil($total_shops / $per_page);

// Fetch categories for filter
$category_query = "SELECT * FROM shop_categories ORDER BY name";
$category_result = mysqli_query($conn, $category_query);
$categories = [];
while($row = mysqli_fetch_assoc($category_result)) {
    $categories[] = $row;
}

// Function to format date
function formatDate($date) {
    return date('M j, Y g:i A', strtotime($date));
}

// Function to get status badge class
function getStatusBadge($status) {
    switch ($status) {
        case 'approved':
            return 'badge bg-success';
        case 'pending':
            return 'badge bg-warning';
        case 'rejected':
            return 'badge bg-danger';
        default:
            return 'badge bg-secondary';
    }
}

// Function to get listing type badge
function getListingTypeBadge($type) {
    return $type === 'premium' ? 'badge bg-info' : 'badge bg-secondary';
}

// Function to get correct image path
function getShopImagePath($imagePath) {
    if (empty($imagePath)) {
        return false;
    }
    
    // Remove any ../ from the path for security
    $cleanPath = str_replace('../', '', $imagePath);
    
    // Check if the file exists
    if (file_exists($cleanPath)) {
        return $cleanPath;
    }
    
    // If file doesn't exist, try with different path variations
    $pathVariations = [
        $cleanPath,
        'uploads/shops/' . basename($cleanPath),
        '../uploads/shops/' . basename($cleanPath),
        '../../uploads/shops/' . basename($cleanPath)
    ];
    
    foreach ($pathVariations as $path) {
        if (file_exists($path)) {
            return $path;
        }
    }
    
    return false;
}
?>

<div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <h5 class="card-title mb-3">Filters</h5>
                                <form method="GET" action="manage-shops.php" class="row g-3">
                                    <div class="col-md-4">
                                        <label for="search" class="form-label">Search</label>
                                        <input type="text" class="form-control" id="search" name="search" 
                                               value="<?php echo htmlspecialchars($search); ?>" 
                                               placeholder="Search by shop name, owner, mobile, or email">
                                    </div>
                                    <div class="col-md-3">
                                        <label for="status" class="form-label">Status</label>
                                        <select class="form-select" id="status1" name="status">
                                            <option value="">All Status</option>
                                            <option value="pending" <?php echo $status === 'pending' ? 'selected' : ''; ?>>Pending</option>
                                            <option value="approved" <?php echo $status === 'approved' ? 'selected' : ''; ?>>Approved</option>
                                            <option value="rejected" <?php echo $status === 'rejected' ? 'selected' : ''; ?>>Rejected</option>
                                        </select>
                                    </div>
                                    <div class="col-md-3">
                                        <label for="category" class="form-label">Category</label>
                                        <select class="form-select" id="category" name="category">
                                            <option value="">All Categories</option>
                                            <?php foreach($categories as $cat): ?>
                                                <option value="<?php echo $cat['id']; ?>" <?php echo $category == $cat['id'] ? 'selected' : ''; ?>>
                                                    <?php echo htmlspecialchars($cat['name']); ?>
                                                </option>
                                            <?php endforeach; ?>
                                        </select>
                                    </div>
                                    <div class="col-md-2">
                                        <label class="form-label d-block">&nbsp;</label>
                                        <button type="submit" class="btn btn-primary w-100">
                                            <i class="fas fa-filter me-1"></i> Filter
                                        </button>
                                    </div>
                                </form>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex justify-content-between align-items-center mb-3">
                                    <h4 class="card-title">Shops List</h4>
                                    <div class="text-muted">
                                        Total: <?php echo $total_shops; ?> shops
                                    </div>
                                </div>

<?php if(!empty($shops)): ?>
                                    <div class="table-responsive">
                                        <table class="table table-hover table-centered mb-0">
                                            <thead class="table-light">
                                                <tr>
                                                    <th>#</th>
                                                    <th>Shop Info</th>
                                                    <th>Contact</th>
                                                    <th>Category</th>
                                                    <th>Status</th>
                                                    <th>Type</th>
                                                    <th>Created</th>
                                                    <th>Actions</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php foreach($shops as $index => $shop): 
                                                    $imagePath = getShopImagePath($shop['front_image']);
                                                ?>
                                                    <tr>
                                                        <td><?php echo $offset + $index + 1; ?></td>
                                                        <td>
                                                            <div class="d-flex align-items-center">
                                                                <div class="flex-shrink-0 me-3">
                                                                    <?php if($imagePath): ?>
                                                                        <img src="<?php echo $imagePath; ?>" 
                                                                             alt="<?php echo htmlspecialchars($shop['shop_name']); ?>" 
                                                                             class="rounded" width="50" height="50" style="object-fit: cover;">
                                                                    <?php else: ?>
                                                                        <div class="bg-light rounded d-flex align-items-center justify-content-center" 
                                                                             style="width: 50px; height: 50px;">
                                                                            <i class="fas fa-store text-muted"></i>
                                                                        </div>
                                                                    <?php endif; ?>
                                                                </div>
                                                                <div class="flex-grow-1">
                                                                    <h6 class="mb-1"><?php echo htmlspecialchars($shop['shop_name']); ?></h6>
                                                                    <p class="text-muted mb-0 small"><?php echo htmlspecialchars($shop['owner_name']); ?></p>
                                                                </div>
                                                            </div>
                                                        </td>
                                                        <td>
                                                            <div class="text-nowrap">
                                                                <div class="mb-1">
                                                                    <i class="fas fa-phone text-primary me-1"></i>
                                                                    <?php echo htmlspecialchars($shop['mobile']); ?>
                                                                </div>
                                                                <div class="small text-muted">
                                                                    <i class="fas fa-envelope me-1"></i>
                                                                    <?php echo htmlspecialchars($shop['email']); ?>
                                                                </div>
                                                            </div>
                                                        </td>
                                                        <td>
                                                            <span class="badge bg-light text-dark">
                                                                <?php echo htmlspecialchars($shop['category_name'] ?: 'N/A'); ?>
                                                            </span>
                                                        </td>
                                                        <td>
                                                            <span class="<?php echo getStatusBadge($shop['status']); ?>">
                                                                <?php echo ucfirst($shop['status']); ?>
                                                            </span>
                                                        </td>
                                                        <td>
                                                            <span class="<?php echo getListingTypeBadge($shop['listing_type']); ?>">
                                                                <?php echo ucfirst($shop['listing_type']); ?>
                                                            </span>
                                                        </td>
                                                        <td>
                                                            <small class="text-muted">
                                                                <?php echo formatDate($shop['created_at']); ?>
                                                            </small>
                                                        </td>
                                                        <td>
                                                            <div class="btn-group">
                                                                <button type="button" class="btn btn-sm btn-light dropdown-toggle" 
                                                                        data-bs-toggle="dropdown" aria-expanded="false">
                                                                    Actions
                                                                </button>
                                                                <ul class="dropdown-menu">
                                                                    <li>
                                                                        <a class="dropdown-item" href="shop-detailed.php?id=<?php echo $shop['id']; ?>" target="_blank">
                                                                            <i class="fas fa-eye me-2"></i>View
                                                                        </a>
                                                                    </li>
                                                                  <a class="dropdown-item" 
   href="edit-shop.php?id=<?php echo $shop['id']; ?>"
   onclick="window.location=this.href; return true;">
    <i class="fas fa-edit me-2"></i>Edit
</a>

<li><hr class="dropdown-divider"></li>
                                                                    <li>
                                                                        <a class="dropdown-item text-warning" 
                                                                           href="?action=toggle_status&id=<?php echo $shop['id']; ?>&current_status=<?php echo $shop['status']; ?>">
                                                                            <i class="fas fa-sync me-2"></i>
                                                                            <?php echo $shop['status'] === 'approved' ? 'Mark Pending' : 'Approve'; ?>
                                                                        </a>
                                                                    </li>
                                                                    <li>
                                                                        <a class="dropdown-item text-danger" 
                                                                           href="#" 
                                                                           onclick="confirmDelete(<?php echo $shop['id']; ?>, '<?php echo htmlspecialchars($shop['shop_name']); ?>')">
                                                                            <i class="fas fa-trash me-2"></i>Delete
                                                                        </a>
                                                                    </li>
                                                                </ul>
                                                            </div>
                                                        </td>
                                                    </tr>
                                                <?php endforeach; ?>
                                            </tbody>
                                        </table>
                                    </div>

<?php if($total_pages > 1): ?>
                                    <div class="d-flex justify-content-between align-items-center mt-3">
                                        <div class="text-muted">
                                            Showing <?php echo count($shops); ?> of <?php echo $total_shops; ?> entries
                                        </div>
                                        <nav>
                                            <ul class="pagination pagination-rounded mb-0">
                                                
                                                <?php if($page > 1): ?>
                                                    <li class="page-item">
                                                        <a class="page-link" href="?<?php echo http_build_query(array_merge($_GET, ['page' => $page - 1])); ?>" aria-label="Previous">
                                                            <span aria-hidden="true">&laquo;</span>
                                                        </a>
                                                    </li>
                                                <?php endif; ?>

<?php for($i = 1; $i <= $total_pages; $i++): ?>
                                                    <?php if($i == 1 || $i == $total_pages || ($i >= $page - 2 && $i <= $page + 2)): ?>
                                                        <li class="page-item <?php echo $i == $page ? 'active' : ''; ?>">
                                                            <a class="page-link" href="?<?php echo http_build_query(array_merge($_GET, ['page' => $i])); ?>">
                                                                <?php echo $i; ?>
                                                            </a>
                                                        </li>
                                                    <?php elseif($i == $page - 3 || $i == $page + 3): ?>
                                                        <li class="page-item disabled">
                                                            <span class="page-link">...</span>
                                                        </li>
                                                    <?php endif; ?>
                                                <?php endfor; ?>

<?php if($page < $total_pages): ?>
                                                    <li class="page-item">
                                                        <a class="page-link" href="?<?php echo http_build_query(array_merge($_GET, ['page' => $page + 1])); ?>" aria-label="Next">
                                                            <span aria-hidden="true">&raquo;</span>
                                                        </a>
                                                    </li>
                                                <?php endif; ?>
                                            </ul>
                                        </nav>
                                    </div>
                                    <?php endif; ?>

<?php else: ?>
                                    <div class="text-center py-5">
                                        <div class="mb-4">
                                            <i class="fas fa-store display-1 text-muted"></i>
                                        </div>
                                        <h4 class="text-muted">No Shops Found</h4>
                                        <p class="text-muted mb-4">
                                            <?php if(!empty($search) || !empty($status) || !empty($category)): ?>
                                                No shops match your current filters.
                                            <?php else: ?>
                                                No shops have been registered yet.
                                            <?php endif; ?>
                                        </p>
                                        <a href="add-shop.php" class="btn btn-primary">
                                            <i class="fas fa-plus me-2"></i>Add Your First Shop
                                        </a>
                                    </div>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>
                </div>
                
            </div>
            
        </div>
        
        <?php include('includes/footer.php')?>
    </div>
    
</div>


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


<?php include('includes/scripts.php')?>
<script>
function confirmDelete(shopId, shopName) {
    if (confirm('Are you sure you want to delete "' + shopName + '"? This action cannot be undone.')) {
        window.location.href = '?action=delete&id=' + shopId;
    }
}

// Auto-submit form when filters change (optional)
document.addEventListener('DOMContentLoaded', function() {
    const statusFilter = document.getElementById('status');
    const categoryFilter = document.getElementById('category');
    
    if (statusFilter) {
        statusFilter.addEventListener('change', function() {
            if (this.value) {
                this.form.submit();
            }
        });
    }
    
    if (categoryFilter) {
        categoryFilter.addEventListener('change', function() {
            if (this.value) {
                this.form.submit();
            }
        });
    }
});
</script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: manage-shops.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation