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: invo.php

<?php
// invoice_print.php — 80mm Thermal Receipt (Thicker Fonts, NO GST, UTC→IST)
include('includes/db.php');

/* ================================
   COMPANY DETAILS
   ================================ */
$SHOP_NAME   = 'STYLE29 MENS WEAR';
$SHOP_ADDR1  = 'Paparapatti Pennagaram Main Road';
$SHOP_ADDR2  = 'Givt. Boys School Opposite, 636809';
$SHOP_PHONE  = '8883889127';
$OWNER_NAME  = 'Hari';

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

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

// Invoice + customer
$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
$items = [];
$stmt2 = mysqli_prepare(
  $conn,
  "SELECT product_name, quantity, 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)) { $items[] = $row; }
mysqli_stmt_close($stmt2);

/* ================================
   HELPERS
   ================================ */
function nf($n){ return number_format((float)$n, 2); }
function toIndianCurrencyWords($num){
  $num=(int)floor(abs($num)); if($num===0)return 'Zero Rupees';
  $ones=['','One','Two','Three','Four','Five','Six','Seven','Eight','Nine','Ten','Eleven','Twelve','Thirteen','Fourteen','Fifteen','Sixteen','Seventeen','Eighteen','Nineteen'];
  $tens=['','','Twenty','Thirty','Forty','Fifty','Sixty','Seventy','Eighty','Ninety'];
  $two=function($n)use($ones,$tens){if($n<20)return$ones[$n];$t=intdiv($n,10);$o=$n%10;return$tens[$t].($o?' '.$ones[$o]:'');};
  $three=function($n)use($two,$ones){if($n<100)return$two($n);$h=intdiv($n,100);$r=$n%100;return($h?$ones[$h].' Hundred':'').($r?' '.$two($r):'');};
  $parts=[['Crore',10000000],['Lakh',100000],['Thousand',1000],['Hundred',100]];
  $words='';$rem=$num;foreach($parts as$p){if($rem>=$p[1]){$cnt=intdiv($rem,$p[1]);$rem=$rem%$p[1];$words.=($words?' ':'').(($p[1]===100)?$three($cnt):$two($cnt)).' '.$p[0];}}
  if($rem>0)$words.=($words?' ':'').($rem<100?$two($rem):$three($rem));return$words.' Rupees';
}

/* ================================
   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']);
?>
<!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">

<div class="center">
    
    <img src="inv.png" alt="<?php echo htmlspecialchars($SHOP_NAME); ?>" class="logo">
    <div class="bold"><?php echo htmlspecialchars($SHOP_ADDR1); ?></div>
    <div class="bold"><?php echo htmlspecialchars($SHOP_ADDR2); ?></div>
    <?php if($SHOP_PHONE): ?><div>Ph: <?php echo htmlspecialchars($SHOP_PHONE); ?></div><?php endif; ?>
    <div>Proprietor: <span class="bold"><?php echo htmlspecialchars($OWNER_NAME); ?></span></div>
  </div>

<div>Invoice: <span class="bold"><?php echo htmlspecialchars($invNo); ?></span></div>
  <div>Date: <span class="bold"><?php echo htmlspecialchars($dateStr); ?> IST</span></div>
  <div>Payment: <span class="bold"><?php echo htmlspecialchars($payMode); ?></span></div>

<div class="h2">Bill To</div>
  <div>Name: <span class="bold"><?php echo htmlspecialchars($custName); ?></span></div>
  <div>Phone: <span class="bold"><?php echo htmlspecialchars($custPh); ?></span></div>

<div class="right">Subtotal: <span class="bold">₹ <?php echo nf($inv['subtotal']); ?></span></div>
  <div class="right">Discount: <span class="bold">₹ <?php echo nf($inv['discount']); ?></span></div>
  <div class="line"></div>
  <div class="right h2">Grand Total: ₹ <?php echo nf($inv['total']); ?></div>
  <div class="right">Paid: <span class="bold">₹ <?php echo nf($inv['cash_received']); ?></span></div>
  <?php if ($amountDue>0): ?><div class="right">Amount Due: <span class="bold">₹ <?php echo nf($amountDue); ?></span></div><?php endif; ?>
  <?php if ($changeBack>0): ?><div class="right">Change: <span class="bold">₹ <?php echo nf($changeBack); ?></span></div><?php endif; ?>

<div class="bold">Amount in words:</div>
  <div><?php echo htmlspecialchars($amountWords); ?></div>

<div class="line"></div>
  <div class="center bold">Thank you for shopping with <?php echo htmlspecialchars($SHOP_NAME); ?>!</div>
  <div class="center">Proprietor: <?php echo htmlspecialchars($OWNER_NAME); ?></div>

</div>

<?php if($autoPrint): ?><script>window.addEventListener('load',()=>window.print());</script><?php endif; ?>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: invo.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation