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

Free Space:

10.3 TB

🔧 Quick Actions

✏️ Editing: invoice_print.php

<?php
// invoice_print.php — 80mm Thermal Receipt (ULTRA BOLD LARGE FONTS)
include('includes/db.php');

/* ================================
   COMPANY DETAILS FROM DATABASE
   ================================ */
// Fetch company details from shop_settings table
$SHOP_NAME = $SHOP_ADDR1 = $SHOP_ADDR2 = $SHOP_PHONE = $OWNER_NAME = '';

$settings_sql = "SELECT setting_key, setting_value FROM shop_settings 
                 WHERE setting_key IN ('shop_name', 'shop_addr1', 'shop_addr2', 'shop_phone', 'owner_name')";
$result = mysqli_query($conn, $settings_sql);

if ($result && mysqli_num_rows($result) > 0) {
    while ($row = mysqli_fetch_assoc($result)) {
        switch ($row['setting_key']) {
            case 'shop_name':
                $SHOP_NAME = $row['setting_value'];
                break;
            case 'shop_addr1':
                $SHOP_ADDR1 = $row['setting_value'];
                break;
            case 'shop_addr2':
                $SHOP_ADDR2 = $row['setting_value'];
                break;
            case 'shop_phone':
                $SHOP_PHONE = $row['setting_value'];
                break;
            case 'owner_name':
                $OWNER_NAME = $row['setting_value'];
                break;
        }
    }
}

// Set default values if not found in database
if (empty($SHOP_NAME)) $SHOP_NAME = 'STYLE29 MENS WEAR';
if (empty($SHOP_ADDR1)) $SHOP_ADDR1 = 'Paparapatti Pennagaram Main Road';
if (empty($SHOP_ADDR2)) $SHOP_ADDR2 = 'Givt. Boys School Opposite, 636809';
if (empty($SHOP_PHONE)) $SHOP_PHONE = '8883889127';
if (empty($OWNER_NAME)) $OWNER_NAME = 'Hari';

/* ================================
   INPUT / LOAD DATA
   ================================ */
$invoiceNumber = isset($_GET['invoice_id']) ? trim($_GET['invoice_id']) : '';
$autoPrint     = isset($_GET['auto']);
$returnUrl     = isset($_GET['return']) ? $_GET['return'] : 'sales.php';

if ($invoiceNumber === '') { http_response_code(400); echo 'Missing invoice_id'; exit; }

// Invoice + customer - Using existing database structure
$stmt = mysqli_prepare(
  $conn,
  "SELECT i.id, i.invoice_number, i.customer_id, i.subtotal, i.discount, i.discount_type,
          i.total, i.cash_received, i.change_given, i.payment_method, i.created_at,
          c.name AS customer_name, c.phone AS customer_phone
   FROM invoices i
   LEFT JOIN customers c ON c.id = i.customer_id
   WHERE i.invoice_number = ?
   LIMIT 1"
);
mysqli_stmt_bind_param($stmt, 's', $invoiceNumber);
mysqli_stmt_execute($stmt);
$res = mysqli_stmt_get_result($stmt);
$inv = ($res && mysqli_num_rows($res) === 1) ? mysqli_fetch_assoc($res) : null;
mysqli_stmt_close($stmt);
if (!$inv) { http_response_code(404); echo 'Invoice not found'; exit; }

// Items - Fetch all item details including price and discount information
$items = [];
$stmt2 = mysqli_prepare(
  $conn,
  "SELECT product_name, quantity, original_price, discount_percentage, discounted_price, total_price, product_category 
   FROM invoice_items WHERE invoice_id = ? ORDER BY id ASC"
);
mysqli_stmt_bind_param($stmt2, 'i', $inv['id']);
mysqli_stmt_execute($stmt2);
$res2 = mysqli_stmt_get_result($stmt2);
while ($row = mysqli_fetch_assoc($res2)) { 
    // Calculate values based on actual database columns
    $originalPrice = $row['original_price'];
    $quantity = $row['quantity'];
    $discountPercent = $row['discount_percentage'] ?: 0;
    $discountedPrice = $row['discounted_price'];
    $totalPrice = $row['total_price'];
    
    // Calculate base amount (price × quantity)
    $baseAmount = $originalPrice * $quantity;
    
    // Calculate discount amount
    $discountAmount = $baseAmount - $totalPrice;
    
    $items[] = [
        'product_name' => $row['product_name'],
        'quantity' => $quantity,
        'unit_price' => $originalPrice,
        'discount_percent' => $discountPercent,
        'discount_amount' => $discountAmount,
        'total_price' => $totalPrice,
        'base_amount' => $baseAmount,
        'product_category' => $row['product_category']
    ];
}
mysqli_stmt_close($stmt2);

/* ================================
   HELPERS
   ================================ */
function nf($n){ 
    // If number is integer, return without .00, otherwise format with 2 decimals
    return (floor($n) == $n) ? number_format($n, 0) : number_format($n, 2);
}

function nfGrandTotal($n){
    // Always show 2 decimals for grand total
    return number_format((float)$n, 2);
}

/* ================================
   DERIVED FIELDS
   ================================ */
// Convert UTC → Asia/Kolkata
if ($inv['created_at']) {
    $dt = new DateTime($inv['created_at'], new DateTimeZone('UTC'));
    $dt->setTimezone(new DateTimeZone('Asia/Kolkata'));
    $dateStr = $dt->format('d M Y, h:i A');
} else {
    $dateStr = date('d M Y, h:i A');
}

$invNo    = $inv['invoice_number'];
$custName = $inv['customer_name'] ?: 'Walk-in';
$custPh   = $inv['customer_phone'] ?: '-';
$payMode  = strtoupper($inv['payment_method']);
$amountWords = toIndianCurrencyWords(round($inv['total'])) . ' Only';

$amountDue  = max(0, (float)$inv['total'] - (float)$inv['cash_received']);
$changeBack = max(0, (float)$inv['change_given']);

// Calculate totals
$totalItemDiscount = 0;
$subtotalBeforeDiscount = 0;

foreach ($items as $item) {
    $subtotalBeforeDiscount += $item['base_amount'];
    $totalItemDiscount += $item['discount_amount'];
}

$billDiscount = (float)$inv['discount'];
$totalDiscount = $totalItemDiscount + $billDiscount;
?>
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Invoice #<?php echo htmlspecialchars($invNo); ?></title>
<meta name="viewport" content="width=device-width, initial-scale=1">

/* Header Styles - Much Larger and Bolder */
.h1{
    font-size: 26px !important; /* Increased from 22px */
    font-weight: 900 !important; 
    text-transform: uppercase; 
    letter-spacing: 2px; 
    -webkit-text-stroke: 0.8px black; /* Thicker stroke */
    text-stroke: 1px black;
    filter: contrast(3) brightness(0.8); /* More contrast */
    margin: 5px 0;
}

.h2{
    font-size: 19px !important; /* Increased from 16px */
    font-weight: 900 !important;
    -webkit-text-stroke: 0.8px black; /* Thicker stroke */
    text-stroke: 0.8px black;
    margin: 4px 0;
}

/* Lines */
.line{
    border-top: 3px dashed #000; /* Thicker dashes */
    margin: 6px 0;
}
.line2{
    border-top: 3px solid #000; /* Thicker solid line */
    margin: 6px 0;
}

/* Table Styles - Larger and Bolder */
.table{
    width: 100%;
    border-collapse: collapse;
    font-size: 14px !important; /* Increased from 11px */
    font-weight: 900 !important; /* Ultra bold table */
}
.table th, .table td{
    padding: 3px 0; /* More padding */
    font-weight: 900 !important; /* Ultra bold */
}
.table thead th{
    border-bottom: 2px solid #000; /* Thicker border */
    padding: 4px 0;
    font-size: 15px !important; /* Larger header */
    font-weight: 900 !important;
}

/* Column widths */
.col-item{width: 38%; text-align: left; font-weight: 900 !important;}
.col-qty{width: 12%; text-align: center; font-weight: 900 !important;}
.col-price{width: 18%; text-align: right; font-weight: 900 !important;}
.col-disc{width: 12%; text-align: center; font-weight: 900 !important;}
.col-amt{width: 20%; text-align: right; font-weight: 900 !important;}

.logo{
    width: 95% !important; 
    max-width: 95% !important; 
    height: auto !important; 
    margin-bottom: 5px !important;
    filter: contrast(2) brightness(0.7); /* Darker logo */
}

.item-row { 
    border-bottom: 2px dotted #000 !important; /* Thicker dots */
    font-weight: 900 !important;
}

/* General text elements - Much bolder */
#receipt div {
    font-weight: 900 !important;
    font-size: 15px !important; /* Increased base size */
}

/* Print button styles */
.print-btn {
    position: fixed;
    top: 10px;
    right: 10px;
    background: #28a745;
    color: white;
    border: none;
    padding: 10px 18px;
    border-radius: 4px;
    cursor: pointer;
    font-size: 16px;
    z-index: 10000;
    font-weight: bold;
}
.print-btn:hover {
    background: #218838;
}

/* Return button styles */
.return-btn {
    position: fixed;
    top: 60px;
    right: 10px;
    background: #007bff;
    color: white;
    border: none;
    padding: 10px 18px;
    border-radius: 4px;
    cursor: pointer;
    font-size: 16px;
    z-index: 10000;
}
.return-btn:hover {
    background: #0056b3;
}

@media print{
    @page{
        margin: 0 !important;
    }
    body{
        margin: 0 !important;
        font-weight: 900 !important;
    }
    #receipt{
        padding: 6px !important;
        font-weight: 900 !important;
    }
    .h1{
        font-weight: 900 !important; 
        -webkit-print-color-adjust: exact; 
        color-adjust: exact; 
        font-size: 24px !important;
        -webkit-text-stroke: 1px black !important;
    }
    .logo{
        width: 90% !important; 
        max-width: 90% !important; 
        height: auto !important; 
        margin-bottom: 4px !important;
        filter: contrast(2) brightness(0.7) !important;
    }
    .print-btn, .return-btn { 
        display: none !important; 
    }
    .table{
        font-size: 13px !important; /* Slightly smaller for print but still bold */
        font-weight: 900 !important;
    }
    #receipt div {
        font-weight: 900 !important;
        font-size: 14px !important;
    }
}

/* Discount styling - Bolder */
.discount-amount {
    color: #000 !important; /* Black for better print */
    font-weight: 900 !important;
    font-size: 14px !important;
    -webkit-text-stroke: 0.3px #000;
}

.discount-percent {
    color: #000 !important; /* Black for better print */
    font-size: 12px !important;
    font-weight: 900 !important;
}

.item-name {
    font-weight: 900 !important;
    font-size: 14px !important;
}

/* Make numbers and prices extra bold */
.col-price, .col-amt, .col-qty {
    font-weight: 900 !important;
    -webkit-text-stroke: 0.3px black;
}

/* Grand total extra styling */
.h2 {
    font-weight: 900 !important;
    -webkit-text-stroke: 0.8px black;
    font-size: 18px !important;
}

/* Amount in words styling */
#receipt div[style*="font-size: 11px"] {
    font-size: 13px !important; /* Larger font for amount in words */
    font-weight: 900 !important;
    line-height: 1.3;
}

/* Policy text - larger and bolder */
.center.bold[style*="color: #d00"] {
    font-size: 13px !important;
    font-weight: 900 !important;
    -webkit-text-stroke: 0.3px #d00;
}

/* Force all text to be ultra bold */
body, div, span, td, th, p {
    font-weight: 900 !important;
}
</style>
</head>
<body style="font-weight: 900 !important;">

<button class="print-btn" onclick="printReceipt()">🖨️ Print Receipt</button>

<button class="return-btn" onclick="returnToSales()">← Return to Sales</button>

<div id="receipt" style="font-weight: 900 !important;">
  <div class="center">
    
    <img src="inv.png" alt="<?php echo htmlspecialchars($SHOP_NAME); ?>" class="logo">
    <div class="bold" style="font-weight: 900 !important; font-size: 16px !important;"><?php echo htmlspecialchars($SHOP_ADDR1); ?></div>
    <div class="bold" style="font-weight: 900 !important; font-size: 16px !important;"><?php echo htmlspecialchars($SHOP_ADDR2); ?></div>
    <?php if($SHOP_PHONE): ?>
    <div style="font-weight: 900 !important; font-size: 15px !important;">Ph: <?php echo htmlspecialchars($SHOP_PHONE); ?></div>
    <?php endif; ?>
    
    <div style="font-weight: 900 !important; font-size: 15px !important;">Proprietor: <span class="bold" style="font-weight: 900 !important;"><?php echo htmlspecialchars($OWNER_NAME); ?></span></div>
  </div>

<div style="font-weight: 900 !important; font-size: 15px !important;">Invoice: <span class="bold" style="font-weight: 900 !important;"><?php echo htmlspecialchars($invNo); ?></span></div>
  <div style="font-weight: 900 !important; font-size: 15px !important;">Date: <span class="bold" style="font-weight: 900 !important;"><?php echo htmlspecialchars($dateStr); ?> IST</span></div>
  <div style="font-weight: 900 !important; font-size: 15px !important;">Payment: <span class="bold" style="font-weight: 900 !important;"><?php echo htmlspecialchars($payMode); ?></span></div>

<div class="h2">Bill To</div>
  <div style="font-weight: 900 !important; font-size: 15px !important;">Name: <span class="bold" style="font-weight: 900 !important;"><?php echo htmlspecialchars($custName); ?></span></div>
  <div style="font-weight: 900 !important; font-size: 15px !important;">Phone: <span class="bold" style="font-weight: 900 !important;"><?php echo htmlspecialchars($custPh); ?></span></div>

<table class="table">
    <thead>
      <tr>
        <th class="col-item" style="font-weight: 900 !important;">Particular</th>
        <th class="col-qty" style="font-weight: 900 !important;">Qty</th>
        <th class="col-price" style="font-weight: 900 !important;">Price</th>
        <th class="col-disc" style="font-weight: 900 !important;">Disc%</th>
        <th class="col-amt" style="font-weight: 900 !important;">Amount</th>
      </tr>
    </thead>
    <tbody>
      <?php foreach($items as $it): ?>
      <tr class="item-row">
        <td class="col-item item-name" style="font-weight: 900 !important;"><?php echo htmlspecialchars($it['product_name']); ?></td>
        <td class="col-qty" style="font-weight: 900 !important;"><?php echo (int)$it['quantity']; ?></td>
        <td class="col-price" style="font-weight: 900 !important;"><?php echo nf($it['unit_price']); ?></td>
        <td class="col-disc discount-percent" style="font-weight: 900 !important;">
          <?php if($it['discount_percent'] > 0): ?>
            <?php echo nf($it['discount_percent']); ?>%
          <?php else: ?>
            -
          <?php endif; ?>
        </td>
        <td class="col-amt" style="font-weight: 900 !important;"><?php echo nf($it['total_price']); ?></td>
      </tr>
      <?php endforeach; ?>
    </tbody>
  </table>

<div class="right" style="font-weight: 900 !important; font-size: 15px !important;">Subtotal: <span class="bold" style="font-weight: 900 !important;">₹ <?php echo nf($subtotalBeforeDiscount); ?></span></div>

<?php if ($totalItemDiscount > 0): ?>
<div class="right" style="font-weight: 900 !important; font-size: 15px !important;">Item Discount: <span class="discount-amount">- ₹ <?php echo nf($totalItemDiscount); ?></span></div>
<?php endif; ?>

<?php if ($billDiscount > 0): ?>
<div class="right" style="font-weight: 900 !important; font-size: 15px !important;">Bill Discount: <span class="discount-amount">- ₹ <?php echo nf($billDiscount); ?></span></div>
<?php endif; ?>

<?php if ($totalDiscount > 0): ?>
<div class="right" style="font-weight: 900 !important; font-size: 15px !important;">Total Discount: <span class="discount-amount">- ₹ <?php echo nf($totalDiscount); ?></span></div>
<?php endif; ?>

<div class="right" style="font-weight: 900 !important; font-size: 15px !important;">Cash Received: <span class="bold" style="font-weight: 900 !important;">₹ <?php echo nf($inv['cash_received']); ?></span></div>

<div class="line"></div>
<div class="right h2">Grand Total: ₹ <?php echo nfGrandTotal($inv['total']); ?></div>

<?php if ($totalDiscount > 0): ?>
<div class="right" style="font-size: 13px !important; color: #000 !important; font-weight: 900 !important;">
  You Saved: ₹ <?php echo nf($totalDiscount); ?>
</div>
<?php endif; ?>
<div class="line2"></div>

<div class="center bold" style="font-weight: 900 !important; font-size: 16px !important;">Thank you for shopping with <?php echo htmlspecialchars($SHOP_NAME); ?>!</div>
  
  
  <div class="center bold" style="color: #000 !important; font-size: 13px !important; margin-top: 6px; font-weight: 900 !important;">
    * NO RETURN * ONLY EXCHANGE *
  </div>
</div>

// Function to print receipt and return to sales
function printReceipt() {
    // First print the receipt
    window.print();
    
    // Then return to sales page after a short delay
    setTimeout(returnToSales, 500);
}

// Auto print functionality (if auto parameter is set)
<?php if($autoPrint): ?>
window.addEventListener('load', function() {
    // Silent print for Electron app
    if (window.electronAPI) {
        // Use Electron's silent printing
        window.electronAPI.printReceipt({
            silent: true,
            printBackground: false,
            color: false,
            margins: {
                marginType: 'custom',
                top: 0,
                bottom: 0,
                left: 0,
                right: 0
            }
        }).then(function(result) {
            console.log('Print result:', result);
            // Wait a moment then return to sales page
            setTimeout(returnToSales, 1000);
        }).catch(function(error) {
            console.error('Print failed:', error);
            // Still return to sales page even if print fails
            setTimeout(returnToSales, 1000);
        });
    } else {
        // Fallback for web browser - show print dialog
        window.print();
        
        // Return to sales page after print dialog is closed
        setTimeout(returnToSales, 1000);
    }
});
<?php endif; ?>

// Alternative: Return to sales when print dialog is closed (for browsers)
window.onafterprint = function() {
    setTimeout(returnToSales, 500);
};

// Keyboard shortcuts
document.addEventListener('keydown', function(e) {
    if (e.key === 'Escape') {
        returnToSales();
    }
    if (e.key === 'p' && (e.ctrlKey || e.metaKey)) {
        e.preventDefault();
        printReceipt();
    }
});
</script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: invoice_print.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation