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

<!doctype html>
<html lang="en">

<?php 
include('includes/head.php');
include('includes/db.php');
?>

<?php include('includes/pre-loader.php'); ?>

<?php include('includes/topbar.php'); ?>

/* ===== A4 Invoice Styles ===== */
#invoiceA4 {
  width: 210mm;
  min-height: 297mm;
  margin: 0 auto;
  background: #fff;
  color: #000;
  padding: 18mm 15mm;
  box-sizing: border-box;
  font-family: system-ui, -apple-system, "Segoe UI", Roboto, Arial, sans-serif;
}

/* Header */
.inv-header {
  display: flex; 
  justify-content: space-between; 
  align-items: flex-start; 
  gap: 16px;
  border-bottom: 2px solid #000;
  padding-bottom: 10px;
}
.inv-brand h2 {
  margin: 0;
  font-size: 22px;
  font-weight: 800;
  letter-spacing: 0.2px;
  text-transform: uppercase;
}
.inv-brand .muted {
  font-size: 12px;
  line-height: 1.4;
}
.inv-meta {
  text-align: right;
  font-size: 12px;
}
.inv-meta div { margin-bottom: 3px; }

/* Parties */
.inv-parties {
  display: grid; 
  grid-template-columns: 1fr 1fr; 
  gap: 16px; 
  margin-top: 12px;
  border-bottom: 1px dashed #999;
  padding-bottom: 10px;
}
.inv-box {
  border: 1px solid #ddd;
  border-radius: 6px;
  padding: 10px;
}
.inv-box h6 {
  margin: 0 0 6px 0;
  font-size: 13px;
  font-weight: 700;
}
.inv-box div { font-size: 12px; line-height: 1.4; }

/* Items table */
.inv-table {
  width: 100%;
  border-collapse: collapse;
  margin-top: 12px;
  font-size: 12px;
}
.inv-table th, .inv-table td {
  border: 1px solid #000;
  padding: 6px 8px;
}
.inv-table th { background: #f2f2f2; }
.text-right { text-align: right; }
.text-center { text-align: center; }

/* Totals */
.inv-totals {
  width: 100%;
  display: grid;
  grid-template-columns: 1fr 240px;
  gap: 16px;
  margin-top: 12px;
}
.total-box {
  border: 1px solid #ddd;
  border-radius: 6px;
  padding: 10px;
}
.total-grid {
  display: grid; 
  grid-template-columns: 1fr 120px;
  row-gap: 6px; 
  column-gap: 8px;
  font-size: 12px;
}
.total-grid div { padding: 2px 0; }
.total-grid .label { text-align: left; }
.total-grid .value { text-align: right; font-weight: 600; }
.grand {
  border-top: 2px solid #000; 
  margin-top: 6px; 
  padding-top: 6px; 
  font-weight: 800;
}

/* Amount in words */
.amount-words {
  margin-top: 8px;
  font-size: 12px;
  font-style: italic;
}

/* Footer / signature */
.inv-footer {
  display: grid; 
  grid-template-columns: 1fr 1fr; 
  gap: 16px; 
  margin-top: 18px;
}
.sign-box {
  border-top: 1px dashed #999;
  padding-top: 20px;
  text-align: right;
  font-size: 12px;
}
.notes-box {
  font-size: 11px;
  color: #333;
}
.notes-box ul { margin: 4px 0 0 16px; }

/* Print rules – only print the A4 invoice */
@media print {
  @page { size: A4; margin: 12mm; }
  body * { visibility: hidden !important; }
  #printArea, #printArea * { visibility: visible !important; }
  #printArea { position: absolute; left: 0; top: 0; }
}

/* Mobile niceties for top controls */
@media (max-width: 767px) {
  .controls-row .form-group { margin-bottom: 10px; }
}

/* Search dropdown styles */
.select2-container--default .select2-selection--single {
  height: 38px;
  border: 1px solid #ced4da;
}
.select2-container--default .select2-selection--single .select2-selection__rendered {
  line-height: 36px;
}
.select2-container--default .select2-selection--single .select2-selection__arrow {
  height: 36px;
}
</style>

<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">Sales / Create Invoice</h4>
          <div class="d-flex flex-wrap gap-2">
            <button id="btnNew" class="btn btn-primary btn-sm">New Bill</button>
            <button id="btnPrint" class="btn btn-success btn-sm">Print</button>
          </div>
        </div>
      </div>

<div class="card mb-3">
        <div class="card-body">
          <div class="row controls-row g-3">
            <div class="col-12 col-md-3">
              <div class="form-group">
                <label class="form-label">Customer Name <span class="text-danger">*</span></label>
                <input type="text" id="custName" class="form-control" placeholder="Walk-in" required>
              </div>
            </div>
            <div class="col-12 col-md-3">
              <div class="form-group">
                <label class="form-label">Customer Phone</label>
                <input type="text" id="custPhone" class="form-control" placeholder="">
              </div>
            </div>
            
            <div class="col-12 col-md-3">
              <div class="form-group">
                <label class="form-label">Scan Barcode</label>
                <input type="text" id="scanInput" class="form-control" placeholder="Scan barcode here" autocomplete="off">
                <small class="text-muted">Press Enter after scan</small>
              </div>
            </div>

<div class="col-12 col-md-3">
              <div class="form-group">
                <label class="form-label">Search Product</label>
                <select id="productSelect" class="form-select">
                  <option value="">-- Search product --</option>
                  <?php
                  // Fetch products with customer_price
                  $prodSql = "SELECT p.id, p.product_name, p.customer_price, p.quantity, 
                                     c.category_name
                              FROM products p
                              LEFT JOIN categories c ON p.category_id = c.id
                              ORDER BY p.product_name ASC";
                  $prodRes = mysqli_query($conn, $prodSql);
                  $jsProducts = [];
                  if ($prodRes && mysqli_num_rows($prodRes) > 0) {
                    while ($p = mysqli_fetch_assoc($prodRes)) {
                      $pid   = (int)$p['id'];
                      $name  = htmlspecialchars($p['product_name']);
                      $price = (float)$p['customer_price'];
                      $stock = (int)$p['quantity'];
                      $cat   = htmlspecialchars($p['category_name'] ?? '');
                      $code  = sprintf('%08d', $pid);

echo "<option value='{$pid}' data-price='{$price}' data-code='{$code}'>" . 
                           $name . " — ₹" . number_format($price,2) . " (" . $code . ")</option>";

$jsProducts[] = [
                        'id' => $pid,
                        'name' => $p['product_name'],
                        'price' => $price,
                        'stock' => $stock,
                        'category' => $p['category_name'] ?? '',
                        'code' => $code
                      ];
                    }
                  }
                  ?>
                </select>
              </div>
            </div>

<div class="col-6 col-md-3">
              <div class="form-group">
                <label class="form-label">Quantity</label>
                <input type="number" id="qtyInput" class="form-control" value="1" min="1">
              </div>
            </div>

<div class="row">
        <div class="col-12 col-lg-8">
          <div class="card">
            <div class="card-body">
              <h5 class="mb-3">Items</h5>
              <div class="table-responsive">
                <table class="table table-bordered table-cart" id="cartTable">
                  <thead>
                    <tr>
                      <th style="width:60px;">#</th>
                      <th>Product</th>
                      <th style="width:120px;">Price (₹)</th>
                      <th style="width:120px;">Qty</th>
                      <th style="width:120px;">Total (₹)</th>
                      <th style="width:80px;">Remove</th>
                    </tr>
                  </thead>
                  <tbody id="cartBody">
                    <tr class="text-center text-muted" id="emptyRow"><td colspan="6">No items yet</td></tr>
                  </tbody>
                </table>
              </div>

<div class="d-flex gap-2">
                <button id="btnAddAnother" class="btn btn-light">Add Another Product</button>
                <button id="btnClearCart" class="btn btn-outline-danger">Clear Cart</button>
              </div>
            </div>
          </div>
        </div>

<div class="col-12 col-lg-4">
          <div class="card">
            <div class="card-body">
              <h5 class="mb-3">Billing</h5>

<div class="mb-2 d-flex justify-content-between">
                <div>Subtotal</div>
                <div id="subtotal">₹ 0.00</div>
              </div>

<div class="mb-2">
                <label class="form-label">Discount</label>
                <div class="input-group">
                  <input type="number" id="discountValue" class="form-control" value="0" min="0" step="0.01">
                  <select id="discountType" class="form-select" style="max-width:110px;">
                    <option value="flat" selected>₹ Flat</option>
                    <option value="percent">% Percent</option>
                  </select>
                </div>
              </div>

<div class="mb-2 d-flex justify-content-between">
                <div>Grand Total</div>
                <div id="grandTotal" class="fw-bold">₹ 0.00</div>
              </div>

<div class="mb-2">
                <label class="form-label">Cash Received</label>
                <input type="number" id="cashReceived" class="form-control" value="0" min="0" step="0.01">
              </div>

<div class="mb-3 d-flex justify-content-between">
                <div>Change</div>
                <div id="changeDue" class="fw-bold">₹ 0.00</div>
              </div>

<div class="mb-3">
                <label class="form-label">Payment Method</label>
                <select id="paymentMethod" class="form-select">
                  <option value="cash">Cash</option>
                  <option value="card">Card</option>
                  <option value="upi">UPI</option>
                  <option value="bank_transfer">Bank Transfer</option>
                </select>
              </div>

<div class="d-grid gap-2">
                <button id="btnGenerateBill" class="btn btn-primary">Generate Bill</button>
                <button id="btnPrint2" class="btn btn-success">Print</button>
              </div>
            </div>
          </div>
        </div>
      </div>

<div id="printArea" style="display:none;">
        <div id="invoiceA4">
          
          <div class="inv-header">
            <div class="inv-brand">
              <h2>POORVA SHARPTRONICS</h2>
              <div class="muted">
                2/252, Poorva Sharptronics, Sitlkarampatti Vill,<br>
                Pennagaram Tk, O G Halli, Dharmapuri, Tamil Nadu.
              </div>
              <div class="muted" id="companyTaxLine">
                
              </div>
            </div>
            <div class="inv-meta">
              <div><strong>Invoice</strong></div>
              <div>Invoice No: <span id="a4InvNo">INV0001</span></div>
              <div>Date: <span id="a4InvDate">01-Jan-2025 10:00 AM</span></div>
              <div>Payment: <span id="a4Payment">Cash</span></div>
            </div>
          </div>

<div class="inv-parties">
            <div class="inv-box">
              <h6>Billed To</h6>
              <div>Name: <span id="a4CustName">Walk-in</span></div>
              <div>Phone: <span id="a4CustPhone">-</span></div>
            </div>
            <div class="inv-box">
              <h6>From</h6>
              <div>POORVA SHARPTRONICS</div>
              <div>2/252, Sitlkarampatti Vill, O G Halli,</div>
              <div>Pennagaram Tk, Dharmapuri, Tamil Nadu</div>
            </div>
          </div>

<table class="inv-table">
            <thead>
              <tr>
                <th style="width:40px;">#</th>
                <th>Description</th>
                <th style="width:110px;" class="text-center">Code</th>
                <th style="width:90px;" class="text-right">Qty</th>
                <th style="width:110px;" class="text-right">Rate (₹)</th>
                <th style="width:120px;" class="text-right">Amount (₹)</th>
              </tr>
            </thead>
            <tbody id="a4ItemsBody">
              
            </tbody>
          </table>

<div class="inv-totals">
            <div class="total-box">
              <strong>Notes</strong>
              <div class="notes-box">
                <ul>
                  <li>Prices are inclusive of applicable taxes unless specified.</li>
                  <li>Goods once sold will not be taken back.</li>
                  <li>Warranty as per manufacturer terms (if applicable).</li>
                </ul>
              </div>
              <div class="amount-words">Amount in words: <span id="a4AmountWords">Zero Rupees Only</span></div>
            </div>

<div class="total-box">
              <div class="total-grid">
                <div class="label">Subtotal</div>
                <div class="value"><span id="a4SubTotal">0.00</span></div>

<div class="label">Discount</div>
                <div class="value"><span id="a4Discount">0.00</span></div>

<div class="label">Tax</div>
                <div class="value"><span id="a4Tax">0.00</span></div>

<div class="label grand">Grand Total</div>
                <div class="value grand"><span id="a4GrandTotal">0.00</span></div>

<div class="label">Cash Received</div>
                <div class="value"><span id="a4Cash">0.00</span></div>

<div class="label">Change</div>
                <div class="value"><span id="a4Change">0.00</span></div>
              </div>
            </div>
          </div>

<div class="inv-footer">
            <div class="notes-box">
              Thank you for your business!
            </div>
            <div class="sign-box">
              For Poorva Sharptronics<br><br><br>
              Authorized Signature
            </div>
          </div>
        </div>
      </div>

<div id="receipt" style="display:none;"></div>

</div>
  </div>

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

</div>

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

// Map barcode -> product
const BARCODE_MAP = {};
PRODUCTS.forEach(p => { if (p.code) BARCODE_MAP[String(p.code)] = p; });

// Cart state
let CART = [];
let SCAN_MODE = false;

// Helpers
function findProductById(id){ return PRODUCTS.find(p => String(p.id) === String(id)); }
function findProductByBarcode(code){ return BARCODE_MAP[String(code).trim()] || null; }
function escapeHtml(str){ return String(str).replaceAll('&','&amp;').replaceAll('<','&lt;').replaceAll('>','&gt;').replaceAll('"','&quot;').replaceAll("'","&#039;"); }

function totals(){
  const subtotal = CART.reduce((s,i)=>s + i.price*i.qty, 0);
  const discVal = parseFloat(document.getElementById('discountValue').value || '0');
  const discType = document.getElementById('discountType').value;
  const discount = discType === 'percent' ? (subtotal * (discVal/100)) : discVal;
  const tax = 0; // add GST later if needed
  const total = Math.max(0, subtotal - discount + tax);
  const cash = parseFloat(document.getElementById('cashReceived').value || '0');
  const change = Math.max(0, cash - total);
  return { subtotal, discount, tax, total, cash, change };
}

function updateStockQuantities(){
  CART.forEach(item => {
    const product = findProductById(item.id);
    if(product){ product.stock -= item.qty; }
  });
}

// Save to DB then redirect to print page
function saveInvoiceAndGo(printAfterSave=false){
  if(CART.length===0){ alert('No items in cart.'); return; }
  const customerName = document.getElementById('custName').value.trim();
  if(!customerName){ alert('Customer name is required'); return; }

const t = totals();
  const payload = {
    customer_name: customerName,
    customer_phone: document.getElementById('custPhone').value.trim(),
    subtotal: t.subtotal,
    discount: t.discount,
    discount_type: document.getElementById('discountType').value,
    tax: t.tax,
    total: t.total,
    cash_received: t.cash,
    change_given: t.change,
    payment_method: document.getElementById('paymentMethod').value,
    items: CART
  };

fetch('save_invoice.php', {
    method: 'POST',
    headers: {'Content-Type':'application/json'},
    body: JSON.stringify(payload)
  })
  .then(r => r.json())
  .then(data => {
    if(data.success){
      updateStockQuantities();
      // redirect to print page with the new invoice id
      const url = 'invotest.php?invoice_id=' + encodeURIComponent(data.invoice_id) + (printAfterSave ? '&auto=1' : '');
      window.location.href = url;
    } else {
      alert('Error saving invoice: ' + (data.message || 'Unknown error'));
    }
  })
  .catch(err => { console.error(err); alert('Error saving invoice'); });
}

document.addEventListener('DOMContentLoaded', ()=>{
  $('#productSelect').select2({ placeholder:"Search product...", allowClear:true, width:'100%' });
  document.getElementById('scanInput').focus();

['discountValue','discountType','cashReceived'].forEach(id=>{
    document.getElementById(id).addEventListener('input', renderCart);
    document.getElementById(id).addEventListener('change', renderCart);
  });

document.getElementById('btnAddAnother').addEventListener('click', ()=> document.getElementById('scanInput').focus());
  document.getElementById('btnClearCart').addEventListener('click', ()=>{
    if(!confirm('Clear current cart?')) return; CART=[]; renderCart();
  });
  document.getElementById('btnNew').addEventListener('click', ()=>{
    if(!confirm('Start a new bill?')) return;
    CART=[]; document.getElementById('custName').value=''; document.getElementById('custPhone').value='';
    document.getElementById('discountValue').value=0; document.getElementById('discountType').value='flat';
    document.getElementById('cashReceived').value=0; document.getElementById('paymentMethod').value='cash';
    renderCart(); document.getElementById('scanInput').focus();
  });

// Generate Bill => save & go to print page (no auto print)
  document.getElementById('btnGenerateBill').addEventListener('click', ()=> saveInvoiceAndGo(false));

// Print buttons => save & go to print page (auto print)
  document.getElementById('btnPrint').addEventListener('click', ()=> saveInvoiceAndGo(true));
  document.getElementById('btnPrint2').addEventListener('click', ()=> saveInvoiceAndGo(true));

renderCart();
});
</script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: saletest.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation