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/printing

Free Space:

10.28 TB

🔧 Quick Actions

✏️ Editing: Manage-bill.php

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

// Handle bill deletion
if (isset($_GET['delete_id'])) {
    $delete_id = intval($_GET['delete_id']);
    
    // First, get the banner image path to delete the file
    $sql = "SELECT banner_image FROM bills WHERE id = $delete_id";
    $result = mysqli_query($conn, $sql);
    
    if ($result && mysqli_num_rows($result) > 0) {
        $bill = mysqli_fetch_assoc($result);
        // Delete the banner image file if it exists
        if (!empty($bill['banner_image']) && file_exists($bill['banner_image'])) {
            unlink($bill['banner_image']);
        }
    }
    
    // Delete the bill from database
    $delete_sql = "DELETE FROM bills WHERE id = $delete_id";
    if (mysqli_query($conn, $delete_sql)) {
        $_SESSION['message'] = '<div class="alert alert-success">Bill deleted successfully!</div>';
    } else {
        $_SESSION['message'] = '<div class="alert alert-danger">Error deleting bill: ' . mysqli_error($conn) . '</div>';
    }
    
    header('Location: Manage-bill.php');
    exit();
}

// Handle status updates
if (isset($_POST['update_status'])) {
    $bill_id = intval($_POST['bill_id']);
    $new_status = mysqli_real_escape_string($conn, $_POST['status']);
    
    $update_sql = "UPDATE bills SET status = '$new_status', updated_at = NOW() WHERE id = $bill_id";
    if (mysqli_query($conn, $update_sql)) {
        $_SESSION['message'] = '<div class="alert alert-success">Bill status updated successfully!</div>';
    } else {
        $_SESSION['message'] = '<div class="alert alert-danger">Error updating status: ' . mysqli_error($conn) . '</div>';
    }
    
    header('Location: Manage-bill.php');
    exit();
}

// Search and filter parameters
$search = $_GET['search'] ?? '';
$status_filter = $_GET['status'] ?? '';
$date_from = $_GET['date_from'] ?? '';
$date_to = $_GET['date_to'] ?? '';

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

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

if (!empty($status_filter)) {
    $where_conditions[] = "status = '" . mysqli_real_escape_string($conn, $status_filter) . "'";
}

if (!empty($date_from)) {
    $where_conditions[] = "DATE(created_at) >= '" . mysqli_real_escape_string($conn, $date_from) . "'";
}

if (!empty($date_to)) {
    $where_conditions[] = "DATE(created_at) <= '" . mysqli_real_escape_string($conn, $date_to) . "'";
}

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

// Get total count for pagination
$count_sql = "SELECT COUNT(*) as total FROM bills $where_clause";
$count_result = mysqli_query($conn, $count_sql);
$total_bills = mysqli_fetch_assoc($count_result)['total'];

// Pagination
$per_page = 10;
$total_pages = ceil($total_bills / $per_page);
$current_page = isset($_GET['page']) ? max(1, intval($_GET['page'])) : 1;
$offset = ($current_page - 1) * $per_page;

// Get bills with pagination
$sql = "SELECT * FROM bills $where_clause ORDER BY created_at DESC LIMIT $offset, $per_page";
$result = mysqli_query($conn, $sql);

// Display message if exists
$message = '';
if (isset($_SESSION['message'])) {
    $message = $_SESSION['message'];
    unset($_SESSION['message']);
}
?>
<!doctype html>
<html lang="en">
<?php include('includes/head.php')?>
<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="row align-items-center mb-3">
                    <div class="col-12 d-flex justify-content-between align-items-center flex-wrap gap-2">
                        <h4 class="mb-0">Billing / Manage Bills</h4>
                        <div class="d-flex flex-wrap gap-2">
                            <a href="add-banner.php" class="btn btn-primary btn-sm">
                                <i class="fas fa-plus me-1"></i>Add New Bill
                            </a>
                        </div>
                    </div>
                </div>

<div class="card mb-4">
                    <div class="card-body">
                        <form method="GET" action="Manage-bill.php">
                            <div class="row g-3">
                                <div class="col-md-3">
                                    <label class="form-label">Search</label>
                                    <input type="text" name="search" class="form-control" placeholder="Search bills..." 
                                           value="<?php echo htmlspecialchars($search); ?>">
                                </div>
                                <div class="col-md-2">
                                    <label class="form-label">Status</label>
                                    <select name="status" class="form-select">
                                        <option value="">All Status</option>
                                        <option value="pending" <?php echo $status_filter === 'pending' ? 'selected' : ''; ?>>Pending</option>
                                        <option value="paid" <?php echo $status_filter === 'paid' ? 'selected' : ''; ?>>Paid</option>
                                        <option value="overdue" <?php echo $status_filter === 'overdue' ? 'selected' : ''; ?>>Overdue</option>
                                        <option value="cancelled" <?php echo $status_filter === 'cancelled' ? 'selected' : ''; ?>>Cancelled</option>
                                    </select>
                                </div>
                                <div class="col-md-2">
                                    <label class="form-label">From Date</label>
                                    <input type="date" name="date_from" class="form-control" value="<?php echo htmlspecialchars($date_from); ?>">
                                </div>
                                <div class="col-md-2">
                                    <label class="form-label">To Date</label>
                                    <input type="date" name="date_to" class="form-control" value="<?php echo htmlspecialchars($date_to); ?>">
                                </div>
                                <div class="col-md-3 d-flex align-items-end gap-2">
                                    <button type="submit" class="btn btn-primary">Apply Filters</button>
                                    <a href="Manage-bill.php" class="btn btn-secondary">Reset</a>
                                </div>
                            </div>
                        </form>
                    </div>
                </div>

<div class="row mb-4">
                    <div class="col-md-3">
                        <div class="card bg-primary text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0"><?php echo $total_bills; ?></h4>
                                        <span>Total Bills</span>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-file-invoice fa-2x"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="card bg-warning text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">
                                            <?php
                                            $pending_sql = "SELECT COUNT(*) as count FROM bills WHERE status = 'pending'";
                                            $pending_result = mysqli_query($conn, $pending_sql);
                                            echo mysqli_fetch_assoc($pending_result)['count'];
                                            ?>
                                        </h4>
                                        <span>Pending</span>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-clock fa-2x"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="card bg-success text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">
                                            <?php
                                            $paid_sql = "SELECT COUNT(*) as count FROM bills WHERE status = 'paid'";
                                            $paid_result = mysqli_query($conn, $paid_sql);
                                            echo mysqli_fetch_assoc($paid_result)['count'];
                                            ?>
                                        </h4>
                                        <span>Paid</span>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-check-circle fa-2x"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="card bg-danger text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">
                                            <?php
                                            $overdue_sql = "SELECT COUNT(*) as count FROM bills WHERE status = 'overdue'";
                                            $overdue_result = mysqli_query($conn, $overdue_sql);
                                            echo mysqli_fetch_assoc($overdue_result)['count'];
                                            ?>
                                        </h4>
                                        <span>Overdue</span>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-exclamation-triangle fa-2x"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="card">
                    <div class="card-body">
                        <?php echo $message; ?>
                        
                        <div class="table-responsive">
                            <table class="table table-bordered table-hover">
                                <thead class="table-light">
                                    <tr>
                                        <th>#</th>
                                        <th>Bill Title</th>
                                        <th>Customer</th>
                                        <th>Amount</th>
                                        <th>Due Date</th>
                                        <th>Status</th>
                                        <th>Banner Size</th>
                                        <th>Created</th>
                                        <th>Actions</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    <?php if (mysqli_num_rows($result) > 0): ?>
                                        <?php $counter = $offset + 1; ?>
                                        <?php while ($bill = mysqli_fetch_assoc($result)): ?>
                                            <tr>
                                                <td><?php echo $counter++; ?></td>
                                                <td>
                                                    <div class="fw-semibold"><?php echo htmlspecialchars($bill['title']); ?></div>
                                                    <?php if (!empty($bill['description'])): ?>
                                                        <small class="text-muted"><?php echo substr(htmlspecialchars($bill['description']), 0, 50); ?>...</small>
                                                    <?php endif; ?>
                                                </td>
                                                <td><?php echo htmlspecialchars($bill['customer_name']); ?></td>
                                                <td class="fw-bold">₹<?php echo number_format($bill['amount'], 2); ?></td>
                                                <td>
                                                    <?php 
                                                    $due_date = new DateTime($bill['due_date']);
                                                    $today = new DateTime();
                                                    $is_overdue = $due_date < $today && $bill['status'] != 'paid';
                                                    ?>
                                                    <span class="<?php echo $is_overdue ? 'text-danger fw-bold' : ''; ?>">
                                                        <?php echo $due_date->format('M j, Y'); ?>
                                                        <?php if ($is_overdue): ?>
                                                            <br><small class="badge bg-danger">Overdue</small>
                                                        <?php endif; ?>
                                                    </span>
                                                </td>
                                                <td>
                                                    <form method="POST" action="Manage-bill.php" class="d-inline">
                                                        <input type="hidden" name="bill_id" value="<?php echo $bill['id']; ?>">
                                                        <select name="status" class="form-select form-select-sm status-select" 
                                                                onchange="this.form.submit()" style="width: 120px;">
                                                            <option value="pending" <?php echo $bill['status'] == 'pending' ? 'selected' : ''; ?>>Pending</option>
                                                            <option value="paid" <?php echo $bill['status'] == 'paid' ? 'selected' : ''; ?>>Paid</option>
                                                            <option value="overdue" <?php echo $bill['status'] == 'overdue' ? 'selected' : ''; ?>>Overdue</option>
                                                            <option value="cancelled" <?php echo $bill['status'] == 'cancelled' ? 'selected' : ''; ?>>Cancelled</option>
                                                        </select>
                                                        <input type="hidden" name="update_status" value="1">
                                                    </form>
                                                </td>
                                                <td>
                                                    <?php if ($bill['banner_width'] > 0 && $bill['banner_height'] > 0): ?>
                                                        <span class="badge bg-info">
                                                            <?php echo $bill['banner_width'] . '×' . $bill['banner_height'] . ' ' . $bill['banner_unit']; ?>
                                                        </span>
                                                    <?php else: ?>
                                                        <span class="text-muted">-</span>
                                                    <?php endif; ?>
                                                </td>
                                                <td>
                                                    <small><?php echo date('M j, Y', strtotime($bill['created_at'])); ?></small>
                                                    <br>
                                                    <small class="text-muted"><?php echo date('g:i A', strtotime($bill['created_at'])); ?></small>
                                                </td>
                                                <td>
                                                    <div class="btn-group btn-group-sm">
                                                        <button type="button" class="btn btn-info" data-bs-toggle="modal" 
                                                                data-bs-target="#viewBillModal" 
                                                                onclick="viewBill(<?php echo htmlspecialchars(json_encode($bill)); ?>)">
                                                            <i class="fas fa-eye"></i>
                                                        </button>
                                                        <a href="edit-bill.php?id=<?php echo $bill['id']; ?>" class="btn btn-warning">
                                                            <i class="fas fa-edit"></i>
                                                        </a>
                                                        <button type="button" class="btn btn-danger" 
                                                                onclick="confirmDelete(<?php echo $bill['id']; ?>, '<?php echo htmlspecialchars($bill['title']); ?>')">
                                                            <i class="fas fa-trash"></i>
                                                        </button>
                                                    </div>
                                                </td>
                                            </tr>
                                        <?php endwhile; ?>
                                    <?php else: ?>
                                        <tr>
                                            <td colspan="9" class="text-center py-4">
                                                <div class="text-muted">
                                                    <i class="fas fa-file-invoice fa-3x mb-3"></i>
                                                    <h5>No bills found</h5>
                                                    <p>Get started by creating your first bill.</p>
                                                    <a href="add-banner.php" class="btn btn-primary">Add New Bill</a>
                                                </div>
                                            </td>
                                        </tr>
                                    <?php endif; ?>
                                </tbody>
                            </table>
                        </div>

<?php if ($total_pages > 1): ?>
                            <nav>
                                <ul class="pagination justify-content-center">
                                    <?php if ($current_page > 1): ?>
                                        <li class="page-item">
                                            <a class="page-link" href="?<?php echo http_build_query(array_merge($_GET, ['page' => $current_page - 1])); ?>">Previous</a>
                                        </li>
                                    <?php endif; ?>

<?php for ($i = 1; $i <= $total_pages; $i++): ?>
                                        <li class="page-item <?php echo $i == $current_page ? 'active' : ''; ?>">
                                            <a class="page-link" href="?<?php echo http_build_query(array_merge($_GET, ['page' => $i])); ?>"><?php echo $i; ?></a>
                                        </li>
                                    <?php endfor; ?>

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

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

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

<div class="modal fade" id="viewBillModal" tabindex="-1" aria-labelledby="viewBillModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-lg">
        <div class="modal-content">
            <div class="modal-header bg-primary text-white">
                <h5 class="modal-title" id="viewBillModalLabel">Bill Details</h5>
                <button type="button" class="btn-close btn-close-white" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <div class="modal-body" id="billDetails">
                
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
                <button type="button" class="btn btn-primary" onclick="printBill()">Print</button>
            </div>
        </div>
    </div>
</div>

.table th {
    font-weight: 600;
    background-color: #f8f9fa;
}

.badge {
    font-size: 0.75em;
}

.btn-group-sm > .btn {
    padding: 0.25rem 0.5rem;
}

/* Status colors */
.status-select option[value="pending"] { color: #ffc107; font-weight: 600; }
.status-select option[value="paid"] { color: #198754; font-weight: 600; }
.status-select option[value="overdue"] { color: #dc3545; font-weight: 600; }
.status-select option[value="cancelled"] { color: #6c757d; font-weight: 600; }
</style>

function confirmDelete(billId, billTitle) {
    if (confirm(`Are you sure you want to delete the bill "${billTitle}"? This action cannot be undone.`)) {
        window.location.href = `Manage-bill.php?delete_id=${billId}`;
    }
}

// Auto-close alerts after 5 seconds
document.addEventListener('DOMContentLoaded', function() {
    const alerts = document.querySelectorAll('.alert');
    alerts.forEach(alert => {
        setTimeout(() => {
            alert.remove();
        }, 5000);
    });
});
</script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Manage-bill.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation