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/spmodern.in/public_html/admin

Free Space:

10.3 TB

🔧 Quick Actions

✏️ Editing: bar.php

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

/* Preview container - 2 stickers per row */
#labelsPreview {
    display: grid;
    grid-template-columns: repeat(2, 50mm);
    gap: 2mm;
    padding: 0;
    margin: 0;
    background: #fff;
    width: 102mm; /* Total width for 2 labels + gap */
}

/* Each label = 50mm × 25mm */
.label-card {
    width: 50mm;
    height: 25mm;
    box-sizing: border-box;
    display: flex;
    flex-direction: column;
    justify-content: center;
    align-items: center;
    margin: 0;
    padding: 1mm;
    background: #fff;
    overflow: hidden;
    border: 1px dashed #ccc;
    font-family: Arial, sans-serif;
}

/* Shop name on label */
.label-shop {
    font-size: 13px;
    font-weight: bold;
    text-align: center;
    margin-bottom: 1mm;
    line-height: 1;
    padding: 0;
}

/* Product name */
.label-name {
    font-size: 8px;
    line-height: 1;
    text-align: center;
    margin: 0;
    font-weight: bold;
    white-space: nowrap;
    overflow: hidden;
    text-overflow: ellipsis;
    max-width: 100%;
    padding: 0;
}

/* Barcode container */
.barcode-container {
    height: 12mm;
    display: flex;
    align-items: center;
    justify-content: center;
    margin: 0;
    width: 100%;
}

.barcode {
    max-width: 100%;
    height: 100%;
}

/* Price */
.label-price {
    font-size: 10px;
    font-weight: bold;
    text-align: center;
    margin: 0;
    color: #d00;
    padding: 0;
}

/* Increased barcode number font size */
.barcode text {
    font-size: 8px !important;
    font-weight: bold !important;
    font-family: Arial, sans-serif !important;
}

/* Print styles */
@media print {
    @page {
        size: 100mm 25mm;
        margin: 0;
        padding: 0;
    }
    
    body {
        margin: 0 !important;
        padding: 0 !important;
        background: white !important;
        width: 100mm !important;
        font-family: Arial, sans-serif !important;
    }
    
    .no-print, .no-print * {
        display: none !important;
    }
    
    #layout-wrapper, .main-content, .page-content, .container-fluid {
        display: none !important;
    }
    
    #printArea {
        display: block !important;
        width: 100mm !important;
        margin: 0 !important;
        padding: 0 !important;
    }
    
    #labelsPreview {
        display: grid !important;
        grid-template-columns: repeat(2, 50mm) !important;
        gap: 0 !important;
        width: 100mm !important;
        margin: 0 !important;
        padding: 0 !important;
        background: white !important;
    }
    
    .label-card {
        width: 50mm !important;
        height: 25mm !important;
        border: none !important;
        margin: 0 !important;
        padding: 1mm !important;
        background: white !important;
        page-break-inside: avoid;
        display: flex !important;
        justify-content: center !important;
        align-items: center !important;
        flex-direction: column !important;
    }
    
    .label-shop,
    .label-name,
    .label-price,
    .barcode-container,
    .barcode {
        display: block !important;
    }
    
    .barcode-container {
        height: 12mm !important;
        margin: 0 !important;
    }
    
    .label-shop {
        margin-bottom: 1mm !important;
    }
    
    .label-name,
    .label-price {
        margin: 0 !important;
    }
    
    /* Increased barcode number font size for print */
    .barcode text {
        font-size: 8px !important;
        font-weight: bold !important;
        font-family: Arial, sans-serif !important;
    }
}

/* DataTables customization */
.dataTables_wrapper {
    margin-bottom: 20px;
}

/* Preview section styling */
#printArea {
    margin-top: 20px;
    border: 1px solid #ddd;
    padding: 10px;
    background: #f9f9f9;
}
</style>

<div class="row align-items-center mb-3 no-print">
        <div class="col-12 d-flex justify-content-between align-items-center flex-wrap gap-2">
            <h4 class="mb-0">Generate Barcodes (50×25mm Labels)</h4>
            <div class="d-flex flex-wrap gap-2">
                <button id="btnGenerateAll" class="btn btn-primary btn-sm">Generate All</button>
                <button id="btnClear" class="btn btn-danger btn-sm">Clear Preview</button>
                <button id="btnPrint" class="btn btn-success btn-sm">Print Labels</button>
            </div>
        </div>
    </div>

<div class="card no-print mb-3">
        <div class="card-body">
            <div class="shop-info">
                <div class="shop-name">SP MODERN MAJESTY</div>
                <div class="shop-address">Your Shop Address Here</div>
            </div>
        </div>
    </div>

<div class="card no-print">
        <div class="card-body">
            <div class="table-responsive">
                <table id="productsTable" class="table table-bordered table-striped" style="width:100%">
                    <thead>
                        <tr>
                            <th>#</th>
                            <th>Product Name</th>
                            <th>Price</th>
                            <th>Quantity</th>
                            <th>Category</th>
                            <th>Copies</th>
                            <th>Action</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php
                        $sql = "SELECT p.id, p.product_name, p.price, p.quantity, c.category_name
                                FROM products p
                                LEFT JOIN categories c ON p.category_id = c.id
                                ORDER BY p.id DESC";
                        $result = mysqli_query($conn, $sql);
                        $rownum = 1;
                        if ($result && mysqli_num_rows($result) > 0) {
                            while ($row = mysqli_fetch_assoc($result)) {
                                $pid = (int)$row['id'];
                                $code = sprintf('%08d', $pid);
                                $name = htmlspecialchars($row['product_name']);
                                $price = number_format((float)$row['price'], 2);
                                $qty = (int)$row['quantity'];
                                $cat = htmlspecialchars($row['category_name'] ?? 'N/A');

echo "<tr data-code='{$code}' data-name='{$name}' data-price='{$price}'>
                                        <td>{$rownum}</td>
                                        <td>{$name}</td>
                                        <td>{$price}</td>
                                        <td>{$qty}</td>
                                        <td>{$cat}</td>
                                        <td><input type='number' class='form-control form-control-sm copies' min='1' value='1'></td>
                                        <td><button type='button' class='btn btn-sm btn-primary btn-generate-one'>Generate</button></td>
                                      </tr>";
                                $rownum++;
                            }
                        } else {
                            echo "<tr><td colspan='7' class='text-center'>No products found</td></tr>";
                        }
                        ?>
                    </tbody>
                </table>
            </div>
        </div>
    </div>

<div id="printArea">
        <h5 class="no-print">Label Preview (2 labels per row - 50×25mm each)</h5>
        <div id="labelsPreview"></div>
    </div>

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

<script src="https://code.jquery.com/jquery-3.7.1.min.js"></script>
<script src="https://cdn.datatables.net/1.13.7/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/jsbarcode@3.11.6/dist/JsBarcode.all.min.js"></script>

// Generate all products
    $('#btnGenerateAll').on('click', function(){
        const $rows = $('#productsTable tbody tr').filter(function(){
            return $(this).find('td').length > 1;
        });
        if ($rows.length === 0) {
            alert('No products found!');
            return;
        }
        generateFromRows($rows);
    });

// Per-row generate
    $(document).on('click', '.btn-generate-one', function(){
        const $row = $(this).closest('tr');
        generateFromRows($row);
    });

// Clear preview
    $('#btnClear').on('click', function(){
        $('#labelsPreview').empty();
    });

// Print
    $('#btnPrint').on('click', function(){
        if ($('#labelsPreview').children().length === 0) {
            alert('No labels generated to print!');
            return;
        }
        
        // Create print-friendly version
        const printWindow = window.open('', '_blank');
        const printContent = `
            <!DOCTYPE html>
            <html>
            <head>
                <title>Print Labels - SP MODERN MAJESTY</title>
                <style>
                    @page { size: 100mm 25mm; margin: 0; padding: 0; }
                    body { margin: 0; padding: 0; background: white; width: 100mm; font-family: Arial, sans-serif; }
                    #labelsPreview { 
                        display: grid; 
                        grid-template-columns: repeat(2, 50mm); 
                        gap: 0; 
                        width: 100mm; 
                        margin: 0; 
                        padding: 0; 
                    }
                    .label-card { 
                        width: 50mm; 
                        height: 25mm; 
                        display: flex; 
                        flex-direction: column; 
                        justify-content: center; 
                        align-items: center; 
                        box-sizing: border-box; 
                        page-break-inside: avoid;
                    }
                    .label-shop { font-size: 12px; font-weight: bold; text-align: center; margin-bottom: 1mm; line-height: 1; }
                    .label-name { font-size: 10px; text-align: center; margin: 0; font-weight: bold; white-space: nowrap; overflow: hidden; text-overflow: ellipsis; max-width: 100%; }
                    .barcode-container { height: 10mm; display: flex; align-items: center; justify-content: center; margin: 0; width: 100%; }
                    .barcode { max-width: 100%; height: 100%; }
                    .label-price { font-size: 13px; font-weight: bold; text-align: center; margin: 0;}
                    
                    /* Increased barcode number font size */
                    .barcode text {
                        font-size: 8px !important;
                        font-weight: bold !important;
                        font-family: Arial, sans-serif !important;
                    }
                </style>
            </head>
            <body>
                <div id="labelsPreview">${$('#labelsPreview').html()}</div>
                <script>
                    window.onload = function() {
                        window.print();
                        setTimeout(function() {
                            window.close();
                        }, 500);
                    };
                <\/script>
            </body>
            </html>
        `;
        
        printWindow.document.write(printContent);
        printWindow.document.close();
    });

// Generate labels
    function generateFromRows($rows) {
        const $preview = $('#labelsPreview');
        const bcHeight = 12;
        const showText = true;

$rows.each(function(){
            const $r = $(this);
            const code = $r.data('code');
            const name = $r.data('name');
            const price = $r.data('price');
            const copies = Math.max(1, parseInt($r.find('.copies').val(), 10) || 1);

// Truncate long product names
            const displayName = name.length > 25 ? name.substring(0, 22) + '...' : name;

for (let i=0; i<copies; i++) {
                const $label = $('<div class="label-card"></div>');
                
                // Shop name
                $label.append('<div class="label-shop">' + escapeHtml(shopName) + '</div>');
                
                // Product name
                $label.append('<div class="label-name" title="' + escapeHtml(name) + '">'+ escapeHtml(displayName) +'</div>');
                
                // Barcode container
                const $barcodeContainer = $('<div class="barcode-container"></div>');
                const $svg = $('<svg class="barcode"></svg>');
                $barcodeContainer.append($svg);
                $label.append($barcodeContainer);
                
                // Price
                $label.append('<div class="label-price">₹ '+ escapeHtml(price) +'</div>');
                
                $preview.append($label);

// Generate barcode with increased font size
                try {
                    JsBarcode($svg[0], String(code), {
                        format: "CODE128",
                        height: bcHeight,
                        displayValue: showText,
                        fontSize: 8,
                        fontOptions: "bold",
                        margin: 0,
                        width: 1.5,
                        background: 'transparent'
                    });
                } catch (e) {
                    console.error('Barcode generation error:', e);
                }
            }
        });
    }

function escapeHtml(str) {
        return String(str)
            .replaceAll('&','&amp;')
            .replaceAll('<','&lt;')
            .replaceAll('>','&gt;')
            .replaceAll('"','&quot;')
            .replaceAll("'",'&#039;');
    }
});
</script>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: bar.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation