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/hifi11.in/public_html/venus

Free Space:

10.27 TB

🔧 Quick Actions

✏️ Editing: add-newbill.php

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

$message = '';

// Get categories for dropdown
$categories = [];
$category_sql = "SELECT * FROM categories WHERE is_active = TRUE ORDER BY name";
$category_result = mysqli_query($conn, $category_sql);
if ($category_result) {
    while ($cat = mysqli_fetch_assoc($category_result)) {
        $categories[] = $cat;
    }
}

// Get existing customers for autocomplete
$customers = [];
$customer_sql = "SELECT DISTINCT customer_name, customer_phone, customer_address FROM bills WHERE customer_name IS NOT NULL AND customer_name != '' ORDER BY customer_name";
$customer_result = mysqli_query($conn, $customer_sql);
if ($customer_result) {
    while ($cust = mysqli_fetch_assoc($customer_result)) {
        $customers[] = $cust;
    }
}

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $title            = trim($_POST['title'] ?? '');
    $customer_name    = trim($_POST['customer_name'] ?? '');
    $customer_phone   = trim($_POST['customer_phone'] ?? '');
    $customer_address = trim($_POST['customer_address'] ?? '');
    $category_id      = intval($_POST['category_id'] ?? 0);
    $amount           = floatval($_POST['amount'] ?? 0);
    $due_date         = $_POST['due_date'] ?? '';
    $status           = $_POST['status'] ?? 'pending';
    $description      = trim($_POST['description'] ?? '');
    $banner_width     = intval($_POST['banner_width'] ?? 0);
    $banner_height    = intval($_POST['banner_height'] ?? 0);
    $banner_unit      = $_POST['banner_unit'] ?? 'px';

// Validation
    $errors = [];
    if (empty($title)) $errors[] = "Bill title is required.";
    if (empty($customer_name)) $errors[] = "Customer name is required.";
    if ($category_id <= 0) $errors[] = "Please select a category.";
    if ($amount <= 0) $errors[] = "Valid amount is required.";
    if (empty($due_date)) $errors[] = "Due date is required.";
    if ($banner_width <= 0) $errors[] = "Valid banner width is required.";
    if ($banner_height <= 0) $errors[] = "Valid banner height is required.";

// File upload
    $banner_image = '';
    if (isset($_FILES['banner_image']) && $_FILES['banner_image']['error'] === UPLOAD_ERR_OK) {
        $upload_dir = 'uploads/banners/';
        if (!is_dir($upload_dir)) mkdir($upload_dir, 0755, true);

$file_ext = pathinfo($_FILES['banner_image']['name'], PATHINFO_EXTENSION);
        $file_name = uniqid('banner_') . '.' . strtolower($file_ext);
        $file_path = $upload_dir . $file_name;

$allowed = ['jpg', 'jpeg', 'png', 'gif'];
        if (!in_array(strtolower($file_ext), $allowed)) {
            $errors[] = "Invalid image type. Only JPG, PNG, GIF allowed.";
        } elseif (move_uploaded_file($_FILES['banner_image']['tmp_name'], $file_path)) {
            $banner_image = $file_path;
        } else {
            $errors[] = "Failed to upload image.";
        }
    }

if (empty($errors)) {
        $title            = mysqli_real_escape_string($conn, $title);
        $customer_name    = mysqli_real_escape_string($conn, $customer_name);
        $customer_phone   = mysqli_real_escape_string($conn, $customer_phone);
        $customer_address = mysqli_real_escape_string($conn, $customer_address);
        $description      = mysqli_real_escape_string($conn, $description);
        $due_date         = mysqli_real_escape_string($conn, $due_date);
        $status           = mysqli_real_escape_string($conn, $status);

$sql = "INSERT INTO bills 
                (title, customer_name, customer_phone, customer_address, category_id, amount, due_date, status, description, banner_image, banner_width, banner_height, banner_unit, created_at) 
                VALUES 
                ('$title', '$customer_name', '$customer_phone', '$customer_address', $category_id, $amount, '$due_date', '$status', '$description', '$banner_image', $banner_width, $banner_height, '$banner_unit', NOW())";

if (mysqli_query($conn, $sql)) {
            $message = '<div class="alert alert-success">Bill added successfully!</div>';
            $_POST = []; // Clear form
        } else {
            $message = '<div class="alert alert-danger">Error: ' . mysqli_error($conn) . '</div>';
        }
    } else {
        $message = '<div class="alert alert-danger"><ul><li>' . implode('</li><li>', $errors) . '</li></ul></div>';
    }
}
?>
<!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 / Create New Bill</h4>
                        <div class="d-flex flex-wrap gap-2">
                            <a href="Manage-bill.php" class="btn btn-secondary btn-sm">Manage Bills</a>
                            <a href="manage-categories.php" class="btn btn-info btn-sm">Manage Categories</a>
                            <a href="customers.php" class="btn btn-success btn-sm">View Customers</a>
                            <button type="submit" form="billForm" class="btn btn-primary btn-sm">Save Bill</button>
                        </div>
                    </div>
                </div>

<form method="POST" enctype="multipart/form-data" id="billForm">
                                    
                                    <div class="card mb-4">
                                        <div class="card-header bg-light">
                                            <h5 class="card-title mb-0">Customer Information</h5>
                                        </div>
                                        <div class="card-body">
                                            <div class="row g-3">
                                                <div class="col-md-6">
                                                    <div class="form-group">
                                                        <label class="form-label">Customer Name <span class="text-danger">*</span></label>
                                                        <input type="text" name="customer_name" class="form-control" placeholder="John Doe" 
                                                               value="<?php echo htmlspecialchars($_POST['customer_name'] ?? ''); ?>" 
                                                               id="customerName" required list="customerList">
                                                        <datalist id="customerList">
                                                            <?php foreach ($customers as $cust): ?>
                                                                <option value="<?php echo htmlspecialchars($cust['customer_name']); ?>" 
                                                                        data-phone="<?php echo htmlspecialchars($cust['customer_phone'] ?? ''); ?>"
                                                                        data-address="<?php echo htmlspecialchars($cust['customer_address'] ?? ''); ?>">
                                                            <?php endforeach; ?>
                                                        </datalist>
                                                    </div>
                                                </div>
                                                <div class="col-md-6">
                                                    <div class="form-group">
                                                        <label class="form-label">Phone Number</label>
                                                        <input type="tel" name="customer_phone" class="form-control" placeholder="+91 9876543210" 
                                                               value="<?php echo htmlspecialchars($_POST['customer_phone'] ?? ''); ?>" 
                                                               id="customerPhone">
                                                    </div>
                                                </div>
                                                
                                                <div class="col-12">
                                                    <div class="form-group">
                                                        <label class="form-label">Address</label>
                                                        <textarea name="customer_address" class="form-control" rows="2" 
                                                                  placeholder="Enter customer address..."
                                                                  id="customerAddress"><?php echo htmlspecialchars($_POST['customer_address'] ?? ''); ?></textarea>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>

<div class="card mb-4">
                                        <div class="card-header bg-light">
                                            <h5 class="card-title mb-0">Bill Information</h5>
                                        </div>
                                        <div class="card-body">
                                            <div class="row g-3">
                                                <div class="col-md-6">
                                                    <div class="form-group">
                                                        <label class="form-label">Bill Title <span class="text-danger">*</span></label>
                                                        <input type="text" name="title" class="form-control" placeholder="e.g., Website Banner Design" 
                                                               value="<?php echo htmlspecialchars($_POST['title'] ?? ''); ?>" required>
                                                    </div>
                                                </div>
                                                
                                                <div class="col-md-6">
                                                    <div class="form-group">
                                                        <label class="form-label">Category <span class="text-danger">*</span></label>
                                                        <select name="category_id" class="form-select" required>
                                                            <option value="">Select Category</option>
                                                            <?php foreach ($categories as $cat): ?>
                                                                <option value="<?php echo $cat['id']; ?>" 
                                                                        <?php echo ($_POST['category_id'] ?? '') == $cat['id'] ? 'selected' : ''; ?>
                                                                        style="color: <?php echo $cat['color']; ?>">
                                                                    <?php echo htmlspecialchars($cat['name']); ?>
                                                                </option>
                                                            <?php endforeach; ?>
                                                        </select>
                                                        <small class="text-muted">Can't find your category? <a href="add-category.php">Add new category</a></small>
                                                    </div>
                                                </div>
                                                <div class="col-md-6">
                                                    <div class="form-group">
                                                        <label class="form-label">Amount (₹) <span class="text-danger">*</span></label>
                                                        <div class="input-group">
                                                            <span class="input-group-text">₹</span>
                                                            <input type="number" step="0.01" name="amount" class="form-control" placeholder="5000.00" 
                                                                   value="<?php echo htmlspecialchars($_POST['amount'] ?? ''); ?>" required>
                                                        </div>
                                                    </div>
                                                </div>
                                                
                                                <div class="col-md-6">
                                                    <div class="form-group">
                                                        <label class="form-label">Due Date <span class="text-danger">*</span></label>
                                                        <input type="date" name="due_date" class="form-control" 
                                                               value="<?php echo $_POST['due_date'] ?? ''; ?>" required>
                                                    </div>
                                                </div>
                                                <div class="col-md-6">
                                                    <div class="form-group">
                                                        <label class="form-label">Status</label>
                                                        <select name="status" class="form-select">
                                                            <option value="pending" <?php echo ($_POST['status'] ?? 'pending') === 'pending' ? 'selected' : ''; ?>>Pending</option>
                                                            <option value="paid" <?php echo ($_POST['status'] ?? '') === 'paid' ? 'selected' : ''; ?>>Paid</option>
                                                            <option value="overdue" <?php echo ($_POST['status'] ?? '') === 'overdue' ? 'selected' : ''; ?>>Overdue</option>
                                                            <option value="cancelled" <?php echo ($_POST['status'] ?? '') === 'cancelled' ? 'selected' : ''; ?>>Cancelled</option>
                                                        </select>
                                                    </div>
                                                </div>
                                                
                                                <div class="col-md-6">
                                                    <div class="form-group">
                                                        <label class="form-label">Banner Preview Image (Optional)</label>
                                                        <input type="file" name="banner_image" class="form-control" accept="image/*" id="bannerImageInput">
                                                        <small class="text-muted">JPG, PNG, GIF only (max 5MB)</small>
                                                        <div id="imagePreview" class="mt-2"></div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>

<div class="card mb-4">
                                        <div class="card-header bg-light">
                                            <h5 class="card-title mb-0">Banner Specifications</h5>
                                        </div>
                                        <div class="card-body">
                                            <div class="row g-3">
                                                <div class="col-md-4">
                                                    <div class="form-group">
                                                        <label class="form-label">Width <span class="text-danger">*</span></label>
                                                        <div class="input-group">
                                                            <input type="number" name="banner_width" class="form-control" 
                                                                   placeholder="300" value="<?php echo htmlspecialchars($_POST['banner_width'] ?? ''); ?>" required>
                                                            <select name="banner_unit" class="form-select" style="max-width: 100px;">
                                                                <option value="px" <?php echo ($_POST['banner_unit'] ?? 'px') === 'px' ? 'selected' : ''; ?>>px</option>
                                                                <option value="in" <?php echo ($_POST['banner_unit'] ?? '') === 'in' ? 'selected' : ''; ?>>in</option>
                                                                <option value="cm" <?php echo ($_POST['banner_unit'] ?? '') === 'cm' ? 'selected' : ''; ?>>cm</option>
                                                                <option value="mm" <?php echo ($_POST['banner_unit'] ?? '') === 'mm' ? 'selected' : ''; ?>>mm</option>
                                                            </select>
                                                        </div>
                                                    </div>
                                                </div>
                                                <div class="col-md-4">
                                                    <div class="form-group">
                                                        <label class="form-label">Height <span class="text-danger">*</span></label>
                                                        <div class="input-group">
                                                            <input type="number" name="banner_height" class="form-control" 
                                                                   placeholder="250" value="<?php echo htmlspecialchars($_POST['banner_height'] ?? ''); ?>" required>
                                                            <span class="input-group-text" id="heightUnitDisplay"><?php echo htmlspecialchars($_POST['banner_unit'] ?? 'px'); ?></span>
                                                        </div>
                                                    </div>
                                                </div>
                                                <div class="col-md-4">
                                                    <div class="form-group">
                                                        <label class="form-label">Aspect Ratio</label>
                                                        <div class="form-control" id="aspectRatioDisplay" style="height: 38px; display: flex; align-items: center; background: #f8f9fa;">
                                                            -
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                            <div class="row mt-3">
                                                <div class="col-12">
                                                    <div class="banner-preview-container text-center">
                                                        <div class="banner-preview-label mb-2">Banner Size Preview</div>
                                                        <div class="banner-preview" id="bannerSizePreview">
                                                            <span class="banner-dimensions"><?php echo htmlspecialchars($_POST['banner_width'] ?? 0) . ' × ' . htmlspecialchars($_POST['banner_height'] ?? 0) . ' ' . htmlspecialchars($_POST['banner_unit'] ?? 'px'); ?></span>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>

<div class="card mb-4">
                                        <div class="card-header bg-light">
                                            <h5 class="card-title mb-0">Additional Information</h5>
                                        </div>
                                        <div class="card-body">
                                            <div class="form-group">
                                                <label class="form-label">Description / Notes</label>
                                                <textarea name="description" class="form-control" rows="4" 
                                                          placeholder="Client requirements, design notes, special instructions..."><?php echo htmlspecialchars($_POST['description'] ?? ''); ?></textarea>
                                            </div>
                                        </div>
                                    </div>

<div class="d-flex justify-content-end gap-2">
                                        <a href="Manage-bill.php" class="btn btn-secondary">Cancel</a>
                                        <button type="reset" class="btn btn-outline-danger">Reset Form</button>
                                        <button type="submit" class="btn btn-primary">Save Bill</button>
                                    </div>
                                </form>
                            </div>
                        </div>
                    </div>
                </div>

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

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

.banner-preview-label {
    font-weight: 600;
    color: #495057;
    font-size: 0.9rem;
}

.banner-preview {
    margin: 0 auto;
    background-color: #ffffff;
    border: 1px dashed #6c757d;
    display: flex;
    align-items: center;
    justify-content: center;
    position: relative;
    overflow: hidden;
    transition: all 0.3s ease;
    box-shadow: 0 2px 4px rgba(0,0,0,0.1);
}

.banner-dimensions {
    font-size: 0.875rem;
    color: #6c757d;
    font-weight: 500;
}

#imagePreview img {
    max-width: 200px;
    max-height: 150px;
    border: 1px solid #dee2e6;
    border-radius: 0.375rem;
    margin-top: 0.5rem;
    box-shadow: 0 2px 4px rgba(0,0,0,0.1);
}

.card-header.bg-light {
    background: linear-gradient(135deg, #f8f9fa 0%, #e9ecef 100%) !important;
    border-bottom: 1px solid #dee2e6;
}

.form-group {
    margin-bottom: 1rem;
}

.form-label {
    font-weight: 600;
    margin-bottom: 0.5rem;
    color: #495057;
}

.input-group-text {
    background-color: #f8f9fa;
    border-color: #ced4da;
}

.customer-info-section {
    background: #f8f9fa;
    border-radius: 0.375rem;
    padding: 1rem;
    margin-bottom: 1rem;
}

/* Responsive adjustments */
@media (max-width: 768px) {
    .banner-preview {
        width: 150px !important;
        height: 100px !important;
    }
}
</style>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: add-newbill.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation