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/vkmobiles/admin

Free Space:

10.27 TB

🔧 Quick Actions

✏️ Editing: view-branch.php

<!doctype html>
<html lang="en">

<?php 
include('includes/db.php');
include('includes/head.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">

<?php
                // Check if branch ID is provided
                if (!isset($_GET['id']) || empty($_GET['id'])) {
                    echo '<div class="alert alert-danger alert-dismissible fade show" role="alert">
                            <i class="fas fa-exclamation-circle me-2"></i>
                            Branch ID is required!
                            <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                          </div>';
                    echo '<div class="text-center py-5">
                            <a href="branches.php" class="btn btn-primary">Back to Branches</a>
                          </div>';
                    exit();
                }

$branch_id = intval($_GET['id']);

// Fetch branch details
                $sql = "SELECT * FROM branches WHERE id = $branch_id";
                $result = $conn->query($sql);

if ($result->num_rows === 0) {
                    echo '<div class="alert alert-warning alert-dismissible fade show" role="alert">
                            <i class="fas fa-exclamation-triangle me-2"></i>
                            Branch not found!
                            <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                          </div>';
                    echo '<div class="text-center py-5">
                            <a href="branches.php" class="btn btn-primary">Back to Branches</a>
                          </div>';
                    exit();
                }

$branch = $result->fetch_assoc();

// Status badge
                $status_badge = '';
                if ($branch['status'] == 'active') {
                    $status_badge = '<span class="badge bg-success">Active</span>';
                } elseif ($branch['status'] == 'inactive') {
                    $status_badge = '<span class="badge bg-danger">Inactive</span>';
                } else {
                    $status_badge = '<span class="badge bg-warning">Pending</span>';
                }

// Get branch statistics
                $stats_sql = "SELECT 
                    (SELECT COUNT(*) FROM sales WHERE branch_id = $branch_id) as total_sales,
                    (SELECT COUNT(*) FROM staff WHERE branch_id = $branch_id) as total_staff,
                    (SELECT COUNT(*) FROM products WHERE branch_id = $branch_id) as total_products,
                    (SELECT SUM(total_amount) FROM sales WHERE branch_id = $branch_id AND status = 'completed') as total_revenue";

$stats_result = $conn->query($stats_sql);
                $stats = $stats_result->fetch_assoc();
                ?>

<div class="row">
                    <div class="col-lg-12">
                        <div class="card">
                            <div class="card-header">
                                <div class="d-flex align-items-center justify-content-between">
                                    <h5 class="card-title mb-0">Branch Information</h5>
                                    <div>
                                        <a href="branches.php" class="btn btn-secondary me-2">
                                            <i class="fas fa-arrow-left me-2"></i>Back
                                        </a>
                                        <a href="edit-branch.php?id=<?php echo $branch_id; ?>" class="btn btn-primary">
                                            <i class="fas fa-edit me-2"></i>Edit Branch
                                        </a>
                                    </div>
                                </div>
                            </div>
                            <div class="card-body">
                                
                                <div class="row">
                                    <div class="col-xl-3 col-md-6">
                                        <div class="card card-animate">
                                            <div class="card-body">
                                                <div class="d-flex align-items-center">
                                                    <div class="flex-grow-1 overflow-hidden">
                                                        <p class="text-uppercase fw-medium text-muted text-truncate mb-0">Total Sales</p>
                                                        <h4 class="fs-22 fw-semibold mb-3">
                                                            <?php echo number_format($stats['total_sales']); ?>
                                                        </h4>
                                                    </div>
                                                    <div class="flex-shrink-0">
                                                        <div class="avatar-sm flex-shrink-0">
                                                            <span class="avatar-title bg-soft-success rounded-circle fs-3">
                                                                <i class="fas fa-shopping-cart text-success"></i>
                                                            </span>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>

<div class="col-xl-3 col-md-6">
                                        <div class="card card-animate">
                                            <div class="card-body">
                                                <div class="d-flex align-items-center">
                                                    <div class="flex-grow-1 overflow-hidden">
                                                        <p class="text-uppercase fw-medium text-muted text-truncate mb-0">Total Revenue</p>
                                                        <h4 class="fs-22 fw-semibold mb-3">
                                                            ₹<?php echo number_format($stats['total_revenue'] ?: 0, 2); ?>
                                                        </h4>
                                                    </div>
                                                    <div class="flex-shrink-0">
                                                        <div class="avatar-sm flex-shrink-0">
                                                            <span class="avatar-title bg-soft-primary rounded-circle fs-3">
                                                                <i class="fas fa-rupee-sign text-primary"></i>
                                                            </span>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>

<div class="col-xl-3 col-md-6">
                                        <div class="card card-animate">
                                            <div class="card-body">
                                                <div class="d-flex align-items-center">
                                                    <div class="flex-grow-1 overflow-hidden">
                                                        <p class="text-uppercase fw-medium text-muted text-truncate mb-0">Staff Members</p>
                                                        <h4 class="fs-22 fw-semibold mb-3">
                                                            <?php echo number_format($stats['total_staff']); ?>
                                                        </h4>
                                                    </div>
                                                    <div class="flex-shrink-0">
                                                        <div class="avatar-sm flex-shrink-0">
                                                            <span class="avatar-title bg-soft-info rounded-circle fs-3">
                                                                <i class="fas fa-users text-info"></i>
                                                            </span>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>

<div class="col-xl-3 col-md-6">
                                        <div class="card card-animate">
                                            <div class="card-body">
                                                <div class="d-flex align-items-center">
                                                    <div class="flex-grow-1 overflow-hidden">
                                                        <p class="text-uppercase fw-medium text-muted text-truncate mb-0">Products</p>
                                                        <h4 class="fs-22 fw-semibold mb-3">
                                                            <?php echo number_format($stats['total_products']); ?>
                                                        </h4>
                                                    </div>
                                                    <div class="flex-shrink-0">
                                                        <div class="avatar-sm flex-shrink-0">
                                                            <span class="avatar-title bg-soft-warning rounded-circle fs-3">
                                                                <i class="fas fa-box text-warning"></i>
                                                            </span>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>

<div class="row mt-4">
                                    <div class="col-lg-8">
                                        
                                        <div class="card mb-4">
                                            <div class="card-header">
                                                <h6 class="m-0 font-weight-bold text-primary">
                                                    <i class="fas fa-info-circle me-2"></i>Basic Information
                                                </h6>
                                            </div>
                                            <div class="card-body">
                                                <div class="row">
                                                    <div class="col-md-6 mb-3">
                                                        <label class="form-label text-muted">Branch Name</label>
                                                        <div class="form-control-plaintext border-bottom pb-2">
                                                            <strong><?php echo htmlspecialchars($branch['branch_name']); ?></strong>
                                                        </div>
                                                    </div>
                                                    <div class="col-md-6 mb-3">
                                                        <label class="form-label text-muted">Branch Code</label>
                                                        <div class="form-control-plaintext border-bottom pb-2">
                                                            <code class="fs-5"><?php echo htmlspecialchars($branch['branch_code']); ?></code>
                                                        </div>
                                                    </div>
                                                </div>
                                                
                                                <div class="row">
                                                    <div class="col-md-6 mb-3">
                                                        <label class="form-label text-muted">Status</label>
                                                        <div class="form-control-plaintext border-bottom pb-2">
                                                            <?php echo $status_badge; ?>
                                                        </div>
                                                    </div>
                                                    <div class="col-md-6 mb-3">
                                                        <label class="form-label text-muted">Opening Date</label>
                                                        <div class="form-control-plaintext border-bottom pb-2">
                                                            <?php echo !empty($branch['opening_date']) ? date('d M, Y', strtotime($branch['opening_date'])) : 'Not specified'; ?>
                                                        </div>
                                                    </div>
                                                </div>
                                                
                                                <?php if (!empty($branch['gst_number'])): ?>
                                                <div class="row">
                                                    <div class="col-md-12 mb-3">
                                                        <label class="form-label text-muted">GST Number</label>
                                                        <div class="form-control-plaintext border-bottom pb-2">
                                                            <?php echo htmlspecialchars($branch['gst_number']); ?>
                                                        </div>
                                                    </div>
                                                </div>
                                                <?php endif; ?>
                                            </div>
                                        </div>

<div class="card mb-4">
                                            <div class="card-header">
                                                <h6 class="m-0 font-weight-bold text-primary">
                                                    <i class="fas fa-map-marker-alt me-2"></i>Address Information
                                                </h6>
                                            </div>
                                            <div class="card-body">
                                                <div class="row">
                                                    <div class="col-md-12 mb-3">
                                                        <label class="form-label text-muted">Full Address</label>
                                                        <div class="form-control-plaintext border-bottom pb-2">
                                                            <?php echo nl2br(htmlspecialchars($branch['address'])); ?>
                                                        </div>
                                                    </div>
                                                </div>
                                                
                                                <div class="row">
                                                    <div class="col-md-4 mb-3">
                                                        <label class="form-label text-muted">City</label>
                                                        <div class="form-control-plaintext border-bottom pb-2">
                                                            <?php echo htmlspecialchars($branch['city']); ?>
                                                        </div>
                                                    </div>
                                                    <div class="col-md-4 mb-3">
                                                        <label class="form-label text-muted">State</label>
                                                        <div class="form-control-plaintext border-bottom pb-2">
                                                            <?php echo htmlspecialchars($branch['state']); ?>
                                                        </div>
                                                    </div>
                                                    <div class="col-md-4 mb-3">
                                                        <label class="form-label text-muted">Pincode</label>
                                                        <div class="form-control-plaintext border-bottom pb-2">
                                                            <?php echo htmlspecialchars($branch['pincode']); ?>
                                                        </div>
                                                    </div>
                                                </div>
                                                
                                                <div class="row">
                                                    <div class="col-md-12 mb-3">
                                                        <label class="form-label text-muted">Country</label>
                                                        <div class="form-control-plaintext border-bottom pb-2">
                                                            <?php echo htmlspecialchars($branch['country']); ?>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>

<div class="col-lg-4">
                                        
                                        <div class="card mb-4">
                                            <div class="card-header">
                                                <h6 class="m-0 font-weight-bold text-primary">
                                                    <i class="fas fa-phone-alt me-2"></i>Contact Information
                                                </h6>
                                            </div>
                                            <div class="card-body">
                                                <div class="mb-3">
                                                    <label class="form-label text-muted">Phone Number</label>
                                                    <div class="form-control-plaintext border-bottom pb-2">
                                                        <?php if (!empty($branch['phone'])): ?>
                                                            <i class="fas fa-phone text-primary me-2"></i>
                                                            <a href="tel:<?php echo htmlspecialchars($branch['phone']); ?>">
                                                                <?php echo htmlspecialchars($branch['phone']); ?>
                                                            </a>
                                                        <?php else: ?>
                                                            <span class="text-muted">Not provided</span>
                                                        <?php endif; ?>
                                                    </div>
                                                </div>
                                                
                                                <div class="mb-3">
                                                    <label class="form-label text-muted">Email Address</label>
                                                    <div class="form-control-plaintext border-bottom pb-2">
                                                        <?php if (!empty($branch['email'])): ?>
                                                            <i class="fas fa-envelope text-primary me-2"></i>
                                                            <a href="mailto:<?php echo htmlspecialchars($branch['email']); ?>">
                                                                <?php echo htmlspecialchars($branch['email']); ?>
                                                            </a>
                                                        <?php else: ?>
                                                            <span class="text-muted">Not provided</span>
                                                        <?php endif; ?>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>

<div class="card mb-4">
                                            <div class="card-header">
                                                <h6 class="m-0 font-weight-bold text-primary">
                                                    <i class="fas fa-user-tie me-2"></i>Manager Information
                                                </h6>
                                            </div>
                                            <div class="card-body">
                                                <div class="mb-3">
                                                    <label class="form-label text-muted">Manager Name</label>
                                                    <div class="form-control-plaintext border-bottom pb-2">
                                                        <?php if (!empty($branch['manager_name'])): ?>
                                                            <i class="fas fa-user text-primary me-2"></i>
                                                            <?php echo htmlspecialchars($branch['manager_name']); ?>
                                                        <?php else: ?>
                                                            <span class="text-muted">Not assigned</span>
                                                        <?php endif; ?>
                                                    </div>
                                                </div>
                                                
                                                <div class="mb-3">
                                                    <label class="form-label text-muted">Manager Phone</label>
                                                    <div class="form-control-plaintext border-bottom pb-2">
                                                        <?php if (!empty($branch['manager_phone'])): ?>
                                                            <i class="fas fa-phone text-primary me-2"></i>
                                                            <a href="tel:<?php echo htmlspecialchars($branch['manager_phone']); ?>">
                                                                <?php echo htmlspecialchars($branch['manager_phone']); ?>
                                                            </a>
                                                        <?php else: ?>
                                                            <span class="text-muted">Not provided</span>
                                                        <?php endif; ?>
                                                    </div>
                                                </div>
                                                
                                                <div class="mb-3">
                                                    <label class="form-label text-muted">Manager Email</label>
                                                    <div class="form-control-plaintext border-bottom pb-2">
                                                        <?php if (!empty($branch['manager_email'])): ?>
                                                            <i class="fas fa-envelope text-primary me-2"></i>
                                                            <a href="mailto:<?php echo htmlspecialchars($branch['manager_email']); ?>">
                                                                <?php echo htmlspecialchars($branch['manager_email']); ?>
                                                            </a>
                                                        <?php else: ?>
                                                            <span class="text-muted">Not provided</span>
                                                        <?php endif; ?>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>

<?php if (!empty($branch['notes'])): ?>
                                        <div class="card mb-4">
                                            <div class="card-header">
                                                <h6 class="m-0 font-weight-bold text-primary">
                                                    <i class="fas fa-sticky-note me-2"></i>Notes
                                                </h6>
                                            </div>
                                            <div class="card-body">
                                                <div class="mb-3">
                                                    <div class="form-control-plaintext">
                                                        <?php echo nl2br(htmlspecialchars($branch['notes'])); ?>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                        <?php endif; ?>

<div class="card">
                                            <div class="card-header">
                                                <h6 class="m-0 font-weight-bold text-primary">
                                                    <i class="fas fa-bolt me-2"></i>Quick Actions
                                                </h6>
                                            </div>
                                            <div class="card-body">
                                                <div class="d-grid gap-2">
                                                    <?php if ($branch['status'] !== 'active'): ?>
                                                    <a href="branches.php?change_status=active&id=<?php echo $branch_id; ?>" 
                                                       class="btn btn-success btn-sm">
                                                        <i class="fas fa-check-circle me-2"></i>Activate Branch
                                                    </a>
                                                    <?php endif; ?>
                                                    
                                                    <?php if ($branch['status'] !== 'inactive'): ?>
                                                    <a href="branches.php?change_status=inactive&id=<?php echo $branch_id; ?>" 
                                                       class="btn btn-danger btn-sm">
                                                        <i class="fas fa-times-circle me-2"></i>Deactivate Branch
                                                    </a>
                                                    <?php endif; ?>
                                                    
                                                    <button type="button" class="btn btn-warning btn-sm" onclick="printBranchInfo()">
                                                        <i class="fas fa-print me-2"></i>Print Details
                                                    </button>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>

<div class="row mt-4">
                                    <div class="col-lg-12">
                                        <div class="card">
                                            <div class="card-header">
                                                <h6 class="m-0 font-weight-bold text-primary">
                                                    <i class="fas fa-history me-2"></i>Recent Activity
                                                </h6>
                                            </div>
                                            <div class="card-body">
                                                <?php
                                                // Get recent sales for this branch
                                                $activity_sql = "SELECT s.*, c.customer_name 
                                                                FROM sales s 
                                                                LEFT JOIN customers c ON s.customer_id = c.id 
                                                                WHERE s.branch_id = $branch_id 
                                                                ORDER BY s.sale_date DESC 
                                                                LIMIT 5";
                                                $activity_result = $conn->query($activity_sql);
                                                
                                                if ($activity_result->num_rows > 0): ?>
                                                    <div class="table-responsive">
                                                        <table class="table table-sm table-hover">
                                                            <thead>
                                                                <tr>
                                                                    <th>Date</th>
                                                                    <th>Sale #</th>
                                                                    <th>Customer</th>
                                                                    <th>Amount</th>
                                                                    <th>Status</th>
                                                                    <th>Action</th>
                                                                </tr>
                                                            </thead>
                                                            <tbody>
                                                                <?php while($activity = $activity_result->fetch_assoc()): 
                                                                    $sale_status_badge = '';
                                                                    if ($activity['status'] == 'completed') {
                                                                        $sale_status_badge = '<span class="badge bg-success">Completed</span>';
                                                                    } elseif ($activity['status'] == 'cancelled') {
                                                                        $sale_status_badge = '<span class="badge bg-danger">Cancelled</span>';
                                                                    } else {
                                                                        $sale_status_badge = '<span class="badge bg-warning">Draft</span>';
                                                                    }
                                                                ?>
                                                                <tr>
                                                                    <td><?php echo date('d M, Y', strtotime($activity['sale_date'])); ?></td>
                                                                    <td><code><?php echo htmlspecialchars($activity['sale_number']); ?></code></td>
                                                                    <td><?php echo htmlspecialchars($activity['customer_name']); ?></td>
                                                                    <td>₹<?php echo number_format($activity['total_amount'], 2); ?></td>
                                                                    <td><?php echo $sale_status_badge; ?></td>
                                                                    <td>
                                                                        <a href="sales-view.php?id=<?php echo $activity['id']; ?>" 
                                                                           class="btn btn-sm btn-outline-primary">
                                                                            <i class="fas fa-eye"></i>
                                                                        </a>
                                                                    </td>
                                                                </tr>
                                                                <?php endwhile; ?>
                                                            </tbody>
                                                        </table>
                                                        <div class="text-center mt-2">
                                                            <a href="sales.php?branch=<?php echo $branch_id; ?>" class="btn btn-sm btn-outline-primary">
                                                                View All Sales
                                                            </a>
                                                        </div>
                                                    </div>
                                                <?php else: ?>
                                                    <div class="text-center py-4">
                                                        <i class="fas fa-history fa-2x text-muted mb-3"></i>
                                                        <p class="text-muted">No recent activity found</p>
                                                    </div>
                                                <?php endif; ?>
                                            </div>
                                        </div>
                                    </div>
                                </div>

</div>
                        </div>
                    </div>
                </div>

</div>
            
        </div>

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

</div>

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

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

// Copy branch details to clipboard
function copyBranchDetails() {
    const details = `Branch: ${document.querySelector('strong').innerText}
Code: ${document.querySelector('code').innerText}
Address: ${document.querySelector('.form-control-plaintext').innerText}
Phone: ${document.querySelector('[href^="tel:"]') ? document.querySelector('[href^="tel:"]').innerText : 'N/A'}
Email: ${document.querySelector('[href^="mailto:"]') ? document.querySelector('[href^="mailto:"]').innerText : 'N/A'}`;
    
    navigator.clipboard.writeText(details).then(() => {
        const alert = document.createElement('div');
        alert.className = 'alert alert-success alert-dismissible fade show position-fixed top-0 end-0 m-3';
        alert.style.zIndex = '9999';
        alert.innerHTML = `
            <i class="fas fa-check-circle me-2"></i>
            Branch details copied to clipboard!
            <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
        `;
        document.body.appendChild(alert);
        
        setTimeout(() => {
            alert.remove();
        }, 3000);
    });
}

// Initialize tooltips
document.addEventListener('DOMContentLoaded', function() {
    var tooltipTriggerList = [].slice.call(document.querySelectorAll('[data-bs-toggle="tooltip"]'));
    var tooltipList = tooltipTriggerList.map(function (tooltipTriggerEl) {
        return new bootstrap.Tooltip(tooltipTriggerEl);
    });
});

// Download branch details as PDF
function downloadAsPDF() {
    alert('PDF download feature would be implemented here. This would typically connect to a PDF generation service.');
}

// Share branch details
function shareBranchDetails() {
    if (navigator.share) {
        navigator.share({
            title: 'Branch Details - <?php echo htmlspecialchars($branch['branch_name']); ?>',
            text: 'Check out this branch information',
            url: window.location.href
        })
        .then(() => console.log('Shared successfully'))
        .catch((error) => console.log('Error sharing:', error));
    } else {
        alert('Web Share API not supported in your browser. You can copy the URL manually.');
    }
}
</script>

</body>
</html>

<?php
// Close database connection
$conn->close();
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: view-branch.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation