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/sk-store

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'); ?>
<link rel="stylesheet" href="https://cdn.datatables.net/1.13.7/css/jquery.dataTables.min.css">
<style>
/* Shop details */
.shop-info {
    text-align: center;
    margin-bottom: 10px;
    padding: 5px;
}
.shop-name {
    font-size: 13px;
    font-weight: bold;
    margin-bottom: 2px;
    color: #000;
}
.shop-address {
    font-size: 10px;
    color: #666;
}

/* Preview container - 3 labels per row for 35x25 mm */
#labelsPreview {
    display: grid;
    grid-template-columns: repeat(3, 35mm); /* 35mm width per label */
    gap: 1mm; /* Small gap between labels */
    padding: 0;
    margin: 0;
    background: #fff;
    width: 108mm; /* Total width for 3 labels + gaps (35*3 + 2*1 = 107mm) */
}

/* Each label = 35mm width × 25mm height (TVS LP 46 Neo die-cut label size) */
.label-card {
    width: 35mm;
    height: 25mm; /* 25mm height */
    box-sizing: border-box;
    display: flex;
    flex-direction: column;
    justify-content: center; /* Center vertically */
    align-items: center;
    margin: 0;
    padding: 0.5mm 1mm; /* Minimal padding */
    background: #fff;
    overflow: hidden;
    border: 1px dashed #ccc;
    font-family: Arial, sans-serif;
    page-break-inside: avoid;
}

/* Shop name on label - INCREASED SIZE */
.label-shop {
    font-size: 9px; /* Increased from 7.5px */
    font-weight: bold;
    text-align: center;
    margin-bottom: 0.5px;
    line-height: 1;
    padding: 0;
    color: #000;
    white-space: nowrap;
    overflow: hidden;
    text-overflow: ellipsis;
    width: 100%;
}

/* Product name - INCREASED SIZE for better readability */
.label-name {
    font-size: 9px; /* Increased from 8px */
    line-height: 1.1; /* Slightly increased line height */
    text-align: center;
    margin: 0.5px 0 0.5px 0;
    font-weight: 600;
    white-space: normal; /* Allow wrapping */
    overflow: hidden;
    text-overflow: ellipsis;
    max-width: 100%;
    max-height: 2.4em; /* Allow up to 2 lines */
    padding: 0;
    word-break: break-word;
    display: -webkit-box;
    -webkit-line-clamp: 2;
    -webkit-box-orient: vertical;
}

/* Barcode container - compact for small label */
.barcode-container {
    height: 7mm; /* Increased from 6mm */
    display: flex;
    align-items: center;
    justify-content: center;
    margin: 0.5px 0;
    width: 100%;
    min-height: 7mm;
}
.barcode {
    width: 95%; /* SVG will take 95% of container width */
    height: 100%;
    display: block;
    overflow: visible;
    transform-origin: center;
}

/* Barcode numeric value - INCREASED SIZE */
.barcode-text {
    font-size: 8px !important; /* Increased from 6px */
    font-family: 'Arial', sans-serif !important;
    font-weight: bold !important;
    letter-spacing: 0.5px;
}

/* Price - INCREASED SIZE */
.label-price {
    font-size: 9px; /* Increased from 8px */
    font-weight: bold;
    text-align: center;
    margin: 0.5px 0 0 0;
    color: #000;
    padding: 0;
    white-space: nowrap;
    overflow: hidden;
    text-overflow: ellipsis;
    width: 100%;
}

/* Print styles optimized for TVS LP 46 Neo - 35x25mm die-cut labels */
@media print {
    @page {
        size: 108mm auto; /* Total width for 3 labels */
        margin: 0 !important;
        padding: 0 !important;
    }

body {
        margin: 0 !important;
        padding: 0 !important;
        background: white !important;
        width: 108mm !important; /* Match container width */
        min-height: 100vh;
        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: 108mm !important;
        margin: 0 !important;
        padding: 0 !important;
    }

#labelsPreview {
        display: grid !important;
        grid-template-columns: repeat(3, 35mm) !important;
        gap: 0 !important; /* No gap in print for die-cut labels */
        width: 105mm !important; /* 35mm * 3 = 105mm */
        margin: 0 !important;
        padding: 0 !important;
        background: white !important;
        page-break-inside: avoid;
    }

.label-card {
        width: 35mm !important;
        height: 25mm !important;
        border: none !important;
        margin: 0 !important;
        padding: 0.3mm 0.5mm !important; /* Minimal padding for print */
        background: white !important;
        page-break-inside: avoid;
        display: flex !important;
        justify-content: center !important;
        align-items: center !important;
        flex-direction: column !important;
        overflow: hidden !important;
    }

/* INCREASED SIZES FOR PRINT */
    .label-shop {
        font-size: 8.5px !important; /* Increased from 7px */
        margin-bottom: 0.3mm !important;
        color: #000 !important;
        letter-spacing: -0.1px;
    }

.label-name {
        font-size: 8.5px !important; /* Increased from 7.5px */
        margin: 0.3px 0 !important;
        max-height: 2.2em !important;
        line-height: 1.1 !important;
        -webkit-line-clamp: 2 !important;
    }

.barcode-container {
        height: 6.5mm !important; /* Increased from 5.5mm */
        margin: 0.3px 0 !important;
        min-height: 6.5mm !important;
    }

.barcode {
        width: 96% !important;
        height: 100% !important;
        overflow: visible !important;
    }

.label-price {
        font-size: 8.5px !important; /* Increased from 7.5px */
        font-weight: bold !important;
        margin: 0.3px 0 0 0 !important;
        color: #000 !important;
    }

/* Ensure no extra spacing */
    * {
        box-sizing: border-box;
        max-width: 100%;
    }
}

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

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

/* Responsive adjustments */
@media screen and (max-width: 1200px) {
    #labelsPreview {
        grid-template-columns: repeat(3, 35mm);
        width: 108mm;
    }
}

@media screen and (max-width: 768px) {
    #labelsPreview {
        grid-template-columns: repeat(2, 35mm);
        width: 72mm;
    }
}

@media screen and (max-width: 576px) {
    #labelsPreview {
        grid-template-columns: repeat(1, 35mm);
        width: 37mm;
    }
}

/* Optimize text visibility */
.text-bold {
    font-weight: 900 !important;
    -webkit-font-smoothing: antialiased;
    -moz-osx-font-smoothing: grayscale;
}

/* Indicator for existing barcode */
.barcode-source {
    font-size: 6px;
    color: #666;
    font-style: italic;
    margin-top: 1px;
}
</style>
<body data-sidebar="dark">

<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">

<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 (35×25 mm Die-Cut Labels - 3 per row)</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">SK- Store</div>
                            <div class="shop-address">TVS LP 46 Neo - 35×25 mm Die-Cut Labels (3 per row)</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>Stock Price</th>
                                        <th>Customer Price</th>
                                        <th>Profit</th>
                                        <th>Quantity</th>
                                        <th>Category</th>
                                        <th>Product Code</th>
                                        <th>Copies</th>
                                        <th>Action</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    <?php
                                    $sql = "SELECT p.id, p.product_name, p.stock_price, p.customer_price, 
                                                   p.profit, p.quantity, c.category_name, p.product_code
                                            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']);
                                            $stock_price = number_format((float)$row['stock_price'], 2);
                                            $customer_price = number_format((float)$row['customer_price'], 2);
                                            $profit = number_format((float)$row['profit'], 2);
                                            $qty = (int)$row['quantity'];
                                            $cat = htmlspecialchars($row['category_name'] ?? 'N/A');
                                            $product_code = htmlspecialchars($row['product_code'] ?? '');
                                            
                                            // Determine which barcode to use
                                            $barcode_value = !empty($product_code) ? $product_code : $code;
                                            $has_custom_code = !empty($product_code) ? '1' : '0';
                                            
                                            echo "<tr data-code='{$barcode_value}' 
                                                        data-product-id='{$pid}'
                                                        data-name='{$name}' 
                                                        data-price='{$customer_price}'
                                                        data-has-custom='{$has_custom_code}'
                                                        data-custom-code='{$product_code}'>
                                                    <td>{$rownum}</td>
                                                    <td>{$name}</td>
                                                    <td>₹ {$stock_price}</td>
                                                    <td><strong>₹ {$customer_price}</strong></td>
                                                    <td>₹ {$profit}</td>
                                                    <td>{$qty}</td>
                                                    <td>{$cat}</td>
                                                    <td>";
                                            if (!empty($product_code)) {
                                                echo "<span class='badge bg-success' title='Using custom product code'>";
                                                echo htmlspecialchars($product_code);
                                                echo "</span>";
                                            } else {
                                                echo "<span class='badge bg-secondary' title='Using auto-generated ID'>Auto</span>";
                                            }
                                            echo "</td>
                                                    <td><input type='number' class='form-control form-control-sm copies' min='1' value='1' style='width: 80px;'></td>
                                                    <td><button type='button' class='btn btn-sm btn-primary btn-generate-one'>Generate</button></td>
                                                  </tr>";
                                            $rownum++;
                                        }
                                    } else {
                                        echo "<tr><td colspan='10' class='text-center'>No products found</td></tr>";
                                    }
                                    ?>
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
                
                <div id="printArea">
                    <h5 class="no-print">Label Preview (35×25 mm Die-Cut Labels - 3 labels per row)</h5>
                    <div id="labelsPreview"></div>
                </div>
            </div>
        </div>
<br>
        <?php include('includes/footer.php'); ?>
    </div>
</div>
<?php include('includes/rightbar.php'); ?>
<?php include('includes/scripts.php'); ?>

<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>
<script>
$(function(){
    // Shop details
    const shopName = "SK- Store";

$('#productsTable').DataTable({
        pageLength: 10,
        dom: '<"row"<"col-sm-12 col-md-6"l><"col-sm-12 col-md-6"f>>rt<"row"<"col-sm-12 col-md-6"i><"col-sm-12 col-md-6"p>>',
        columnDefs: [
            { targets: [0, 4, 5, 6, 7, 8, 9], orderable: false }
        ]
    });

// 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 optimized for TVS LP 46 Neo
        const printWindow = window.open('', '_blank');
        const printContent = `
            <!DOCTYPE html>
            <html>
            <head>
                <title>Print Labels - SK- Store</title>
                <style>
                    @page { 
                        size: 105mm auto; 
                        margin: 0 !important; 
                        padding: 0 !important; 
                    }
                    body { 
                        margin: 0; 
                        padding: 0; 
                        background: white; 
                        width: 105mm; 
                        font-family: Arial, sans-serif;
                        min-height: 100vh;
                    }
                    #labelsPreview {
                        display: grid;
                        grid-template-columns: repeat(3, 35mm);
                        gap: 0;
                        width: 105mm;
                        margin: 0;
                        padding: 0;
                        page-break-inside: avoid;
                    }
                    .label-card {
                        width: 35mm;
                        height: 25mm;
                        display: flex;
                        flex-direction: column;
                        justify-content: center;
                        align-items: center;
                        padding: 0.3mm 0.5mm;
                        box-sizing: border-box;
                        page-break-inside: avoid;
                        border: none;
                    }
                    .label-shop { 
                        font-size: 8.5px !important; 
                        font-weight: bold !important; 
                        text-align: center; 
                        margin-bottom: 0.3mm; 
                        line-height: 1; 
                        color: #000;
                        white-space: nowrap;
                        overflow: hidden;
                        text-overflow: ellipsis;
                        width: 100%;
                        letter-spacing: -0.1px;
                    }
                    .label-name { 
                        font-size: 8.5px !important; 
                        text-align: center; 
                        margin: 0.3px 0; 
                        font-weight: 600 !important; 
                        white-space: normal; 
                        overflow: hidden; 
                        text-overflow: ellipsis; 
                        max-width: 100%; 
                        max-height: 2.2em; 
                        line-height: 1.1 !important; 
                        display: -webkit-box;
                        -webkit-line-clamp: 2;
                        -webkit-box-orient: vertical;
                        word-break: break-word;
                    }
                    .barcode-container { 
                        height: 6.5mm !important; 
                        display: flex; 
                        align-items: center; 
                        justify-content: center; 
                        margin: 0.3px 0; 
                        width: 100%;
                        min-height: 6.5mm !important;
                    }
                    .barcode { 
                        width: 96%; 
                        height: 100%; 
                        display: block; 
                        overflow: visible;
                    }
                    .label-price { 
                        font-size: 8.5px !important; 
                        font-weight: bold !important; 
                        text-align: center; 
                        margin: 0.3px 0 0 0; 
                        color: #000;
                        white-space: nowrap;
                        overflow: hidden;
                        text-overflow: ellipsis;
                        width: 100%;
                    }
                    .barcode-text {
                        font-size: 8px !important;
                        font-family: 'Arial', sans-serif !important;
                        font-weight: bold !important;
                        letter-spacing: 0.5px;
                    }
                    .barcode-source {
                        font-size: 6px;
                        color: #666;
                        font-style: italic;
                        margin-top: 1px;
                        display: none; /* Hide in print */
                    }
                    * {
                        box-sizing: border-box;
                        max-width: 100%;
                    }
                </style>
            </head>
            <body>
                <div id="labelsPreview">${$('#labelsPreview').html()}</div>
                <script>
                    window.onload = function() {
                        // Force print dialog
                        window.print();
                        
                        // Close window after print
                        setTimeout(function() { 
                            window.close(); 
                        }, 500);
                    };
                <\/script>
            </body>
            </html>
        `;

printWindow.document.write(printContent);
        printWindow.document.close();
    });

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

// Settings optimized for 35x25mm die-cut labels with larger text
        const bcHeight = 16;        // Increased from 14 for better visibility
        const bcWidthModule = 1.0;  // Slightly thinner bars to accommodate larger numbers
        const showText = true;      // Show numeric text under barcode
        const fontSize = 8;         // Increased from 6 for better readability

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

// Determine barcode source for display
            const barcodeSource = hasCustom ? "Prod. Code" : "Auto Gen";
            const barcodeValue = hasCustom ? customCode : code;
            
            // Truncate product name for small label
            const displayName = String(name).length > 25 ? 
                String(name).substring(0, 22) + '...' : 
                String(name);

for (let i=0; i<copies; i++) {
                const $label = $('<div class="label-card"></div>');

// Shop name
                $label.append('<div class="label-shop text-bold" title="' + escapeHtml(shopName) + '">' + escapeHtml(shopName) + '</div>');

// Product name (truncated, will wrap up to 2 lines)
                $label.append('<div class="label-name text-bold" title="' + escapeHtml(name) + '">'+ escapeHtml(displayName) +'</div>');

// Barcode container
                const $barcodeContainer = $('<div class="barcode-container"></div>');
                const $svg = $('<svg class="barcode" xmlns="http://www.w3.org/2000/svg" aria-hidden="true"></svg>');
                $barcodeContainer.append($svg);
                $label.append($barcodeContainer);
                
                // Barcode source indicator (only show on screen, not in print)
                if (!hasCustom) {
                    $label.append('<div class="barcode-source no-print">Auto-generated</div>');
                }

// Price
                $label.append('<div class="label-price text-bold">₹ '+ escapeHtml(price) +'</div>');

$preview.append($label);

// Generate barcode with optimized settings for better visibility
                try {
                    JsBarcode($svg[0], String(barcodeValue), {
                        format: "CODE128",
                        height: bcHeight,
                        displayValue: showText,
                        fontSize: fontSize,
                        margin: 0,
                        width: bcWidthModule,
                        background: 'transparent',
                        fontOptions: 'bold',
                        textMargin: 0
                    });

// Post-process SVG for better printing
                    setTimeout(() => {
                        const svgElement = $svg[0];
                        if (!svgElement) return;

// Add class to barcode text for styling
                        const textElements = svgElement.querySelectorAll('text');
                        textElements.forEach(text => {
                            text.classList.add('barcode-text');
                            // Make barcode numbers bolder
                            text.setAttribute('font-weight', 'bold');
                        });

// Remove background rects
                        const rects = svgElement.querySelectorAll('rect');
                        rects.forEach(rect => {
                            const w = rect.getAttribute('width') || '';
                            const h = rect.getAttribute('height') || '';
                            const cls = rect.getAttribute('class') || '';
                            // Remove background rectangles
                            if (w === '100%' || w === '100' || cls.toLowerCase().includes('background') || 
                                (h && svgElement.getAttribute('height') && h === svgElement.getAttribute('height'))) {
                                rect.remove();
                            }
                        });

// Make SVG responsive
                        svgElement.setAttribute('width', '100%');
                        svgElement.setAttribute('height', '100%');
                        svgElement.setAttribute('preserveAspectRatio', 'xMidYMid meet');
                        svgElement.style.margin = '0';
                        svgElement.style.padding = '0';
                        svgElement.style.overflow = 'visible';

}, 10);

} catch (e) {
                    console.error('Barcode generation error:', e);
                    // If barcode generation fails, show the numeric code as fallback
                    $svg.replaceWith('<div style="font-size:8px;color:#333;text-align:center;font-weight:bold;">' + escapeHtml(barcodeValue) + '</div>');
                }
            }
        });
        
        // Show notification about barcode sources
        const customCodes = $rows.filter('[data-has-custom="1"]').length;
        const autoCodes = $rows.filter('[data-has-custom="0"]').length;
        
        if (customCodes > 0 && autoCodes > 0) {
            alert(`Generated labels:\n• ${customCodes} product(s) using existing product codes\n• ${autoCodes} product(s) using auto-generated IDs`);
        } else if (customCodes > 0) {
            alert(`Generated labels for ${customCodes} product(s) using existing product codes`);
        }
    }

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