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/pawn

Free Space:

10.26 TB

🔧 Quick Actions

✏️ Editing: common_sale.php

<!doctype html>
<html lang="en">
<?php include('includes/head.php'); ?>
<?php include('includes/db.php'); ?>
<?php  ?>
<body data-sidebar="dark">
<?php //include('includes/pre-loader.php'); ?>
<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>

<?php
// Check if converting from quotation
$isConvertingFromQuotation = isset($_SESSION['converting_from_quotation']) && $_SESSION['converting_from_quotation'];
$quotationData = $isConvertingFromQuotation ? ($_SESSION['quotation_data'] ?? []) : [];
$quotationItems = $isConvertingFromQuotation ? ($_SESSION['quotation_items'] ?? []) : [];
$quotationItemsJson = $isConvertingFromQuotation ? ($_SESSION['quotation_items_json'] ?? []) : [];

// Get quotation ID from URL or session
$quotationId = $_GET['quotation_id'] ?? ($quotationData['quotation_id'] ?? 0);

// If we have quotation data, pre-fill the form 
$prefilledCustomerName = $quotationData['customer_name'] ?? 'Walk-in-Customer';
$prefilledCustomerPhone = $quotationData['customer_phone'] ?? '';
$prefilledCustomerGst = ''; // Add if you have this in quotation data
$prefilledCustomerAddress = ''; // Add if you have this in quotation data
$prefilledBusinessId = $quotationData['business_id'] ?? '';
$prefilledBusinessName = $quotationData['business_name'] ?? '';
$prefilledGstNumber = $quotationData['gst_number'] ?? '';
$prefilledTemplateFile = $quotationData['template_file'] ?? '';
$prefilledTemplateName = $quotationData['template_name'] ?? '';
$prefilledNotes = $quotationData['notes'] ?? '';

// Clear session data after loading to prevent re-use
if ($isConvertingFromQuotation) {
    unset($_SESSION['converting_from_quotation']);
    unset($_SESSION['quotation_data']);
    unset($_SESSION['quotation_items']);
    unset($_SESSION['quotation_items_json']);
}
?>

/* Customer GST and Address Section */
.customer-details-section {
    margin-bottom: 20px;
    padding: 15px;
    background: #f8f9fa;
    border-radius: 8px;
    border: 1px solid #dee2e6;
}
.customer-details-section h5 {
    margin-bottom: 15px;
    color: #495057;
    font-weight: 600;
}
.gst-badge {
    background: #6f42c1;
    color: white;
    padding: 4px 8px;
    border-radius: 4px;
    font-size: 11px;
    font-weight: 500;
    display: inline-block;
    letter-spacing: 0.5px;
}
.address-preview {
    font-size: 12px;
    color: #6c757d;
    margin-top: 3px;
}
.address-preview i {
    color: #0d6efd;
}

.business-selection-section { margin-bottom: 20px; padding: 15px; background: #f8f9fa; border-radius: 8px; border: 1px solid #dee2e6; }
.business-selection-section .business-info-display { margin-top: 10px; padding: 10px; background: white; border-radius: 6px; border: 1px solid #dee2e6; }

/* Quotation Conversion Banner */
.quotation-conversion-banner {
    background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);
    color: white;
    border-radius: 8px;
    padding: 15px 20px;
    margin-bottom: 20px;
    box-shadow: 0 4px 12px rgba(102, 126, 234, 0.2);
    border-left: 5px solid #20c997;
}
.quotation-conversion-banner h5 {
    color: white;
    margin-bottom: 8px;
    font-weight: 600;
}
.quotation-conversion-banner .badge {
    background: rgba(255, 255, 255, 0.2);
    color: white;
    font-weight: 500;
    margin-right: 10px;
}
.quotation-conversion-banner small {
    opacity: 0.9;
}
.quotation-conversion-banner .close-btn {
    background: none;
    border: none;
    color: white;
    font-size: 20px;
    position: absolute;
    right: 15px;
    top: 15px;
    cursor: pointer;
}

/* NEW: Small floating summary card that matches screenshot style */
.fixed-total-card {
  position: fixed;
  right: 28px;
  bottom: 28px;
  z-index: 1200;
  background: transparent;
  border-radius: 12px;
  pointer-events: auto;
  display: flex;
  align-items: center;
  gap: 12px;
  font-family: system-ui, -apple-system, "Segoe UI", Roboto, "Helvetica Neue", Arial;
}

/* inner pill container */
.fixed-total-card .mini-card {
  display: flex;
  align-items: center;
  gap: 12px;
  background: #ffffff;
  border-radius: 12px;
  box-shadow: 0 10px 30px rgba(8,45,26,0.12);
  padding: 12px 14px;
  border: 1px solid rgba(0,0,0,0.06);
  min-width: 220px;
  max-width: 340px;
  align-items: center;
}

/* label block - left */
.fixed-total-card .mini-card .left {
  display: flex;
  flex-direction: column;
  gap: 2px;
  flex: 1;
  min-width: 0;
}

/* small label */
.fixed-total-card .mini-card .label {
  font-size: 11px;
  font-weight: 700;
  color: #2f2f2f;
  letter-spacing: .4px;
}

/* amount text */
.fixed-total-card .mini-card .amount {
  font-size: 18px;
  font-weight: 800;
  color: #198754;
  line-height: 1;
}

/* print button on right */
.fixed-total-card .mini-card .print-btn {
  display: inline-flex;
  align-items: center;
  gap: 8px;
  background: linear-gradient(180deg,#4fc78b,#2fa76a);
  color: #fff;
  border: none;
  padding: 8px 12px;
  border-radius: 10px;
  font-weight: 700;
  box-shadow: 0 6px 18px rgba(47,167,113,0.18);
  cursor: pointer;
  white-space: nowrap;
  font-size: 13px;
}

/* PDF Preview Modal */
.pdf-preview-modal {
  display: none;
  position: fixed;
  top: 0;
  left: 0;
  width: 100%;
  height: 100%;
  background: rgba(0,0,0,0.8);
  z-index: 9999;
  align-items: center;
  justify-content: center;
}
.pdf-preview-modal.show {
  display: flex;
}
.pdf-preview-content {
  background: #fff;
  border-radius: 12px;
  width: 95%;
  max-width: 1200px;
  height: 95%;
  display: flex;
  flex-direction: column;
  overflow: hidden;
  box-shadow: 0 20px 60px rgba(0,0,0,0.3);
}
.pdf-preview-header {
  padding: 20px;
  background: #f8f9fa;
  border-bottom: 1px solid #dee2e6;
  display: flex;
  justify-content: space-between;
  align-items: center;
}
.pdf-preview-body {
  flex: 1;
  padding: 0;
  overflow: auto;
  background: #f5f5f5;
}
.pdf-preview-footer {
  padding: 15px 20px;
  background: #f8f9fa;
  border-top: 1px solid #dee2e6;
  display: flex;
  gap: 10px;
  justify-content: flex-end;
}
.pdf-iframe {
  width: 100%;
  height: 100%;
  border: none;
  background: white;
}

/* Responsive tweaks */
@media (max-width: 990px) {
  .fixed-total-card { right: 16px; bottom: 16px; }
  .fixed-total-card .mini-card { min-width: 200px; max-width: 300px; padding: 10px; }
  .fixed-total-card .mini-card .amount { font-size: 16px; }
}

/* Hide elements in print preview */
.print-only {
  display: none !important;
}
</style>

<div class="main-content">
  <div class="page-content">
    <div class="container-fluid">
      
      <?php if ($isConvertingFromQuotation && !empty($quotationData)): ?>
      
      <div class="quotation-conversion-banner">
        <button class="close-btn" id="closeQuotationBanner">&times;</button>
        <h5>
          <i class="fas fa-exchange-alt me-2"></i>Converting Quotation to Sale
          <span class="badge"><?php echo htmlspecialchars($quotationData['quotation_number'] ?? ''); ?></span>
        </h5>
        <div class="row">
          <div class="col-md-6">
            <small><i class="fas fa-user me-1"></i> Customer: <?php echo htmlspecialchars($quotationData['customer_name'] ?? ''); ?></small><br>
            <small><i class="fas fa-building me-1"></i> Business: <?php echo htmlspecialchars($quotationData['business_name'] ?? ''); ?></small>
          </div>
          <div class="col-md-6">
            <small><i class="fas fa-file-invoice me-1"></i> Template: <?php echo htmlspecialchars($quotationData['template_name'] ?? 'Default'); ?></small><br>
            <small><i class="fas fa-shopping-cart me-1"></i> Items: <?php echo count($quotationItems); ?> items loaded</small>
          </div>
        </div>
      </div>
      <?php endif; ?>
      
      
      <div id="loadingOverlay" class="loading-overlay">
        <div class="loading-content">
          <div class="spinner"></div>
          <div id="loadingMessage">Saving invoice...</div>
        </div>
      </div>
      
      
      <div id="toastContainer"></div>
      
      
      <div id="confirmationModal" class="confirmation-modal">
        <div class="confirmation-content">
          <div id="confirmationMessage" class="confirmation-message"></div>
          <div class="confirmation-buttons">
            <button id="confirmCancel" class="btn btn-light">Cancel</button>
            <button id="confirmOk" class="btn btn-primary">OK</button>
          </div>
        </div>
      </div>

<div id="pdfPreviewModal" class="pdf-preview-modal">
        <div class="pdf-preview-content">
          <div class="pdf-preview-header">
            <h5 class="mb-0">Invoice Preview - <?php echo date('Y-m-d'); ?></h5>
            <div>
              <button class="btn btn-sm btn-outline-secondary me-2" id="refreshPreview">
                <i class="fas fa-redo"></i> Refresh
              </button>
              <button class="btn-close" id="closePdfPreview"></button>
            </div>
          </div>
          <div class="pdf-preview-body">
            <iframe id="pdfIframe" class="pdf-iframe" frameborder="0"></iframe>
          </div>
          <div class="pdf-preview-footer">
            <button class="btn btn-secondary" id="cancelPdf">Cancel</button>
            <button class="btn btn-primary" id="printPdf">Print</button>
          </div>
        </div>
      </div>

<div class="card mb-3">
        <div class="card-body business-selection-section">
          <h5 class="mb-3">Business Selection <span class="text-danger">*</span></h5>
          <div class="row">
            <div class="col-12 col-md-6">
              <div class="form-group">
                <label class="form-label">Select Business</label>
                <select id="businessSelect" class="form-control" required>
                  <option value="">-- Select Business --</option>
                  <?php
                  $businessSql = "SELECT 
                                  gd.id, 
                                  gd.business_name, 
                                  gd.gst_num, 
                                  gd.gst_status,
                                  COALESCE(
                                      (SELECT tm.invoice_file FROM template_mapping tm 
                                       WHERE tm.gst_id = gd.id AND tm.is_active = 1 
                                       AND tm.invoice_file IS NOT NULL AND tm.invoice_file != ''
                                       LIMIT 1),
                                      (SELECT tm.template_file FROM template_mapping tm 
                                       WHERE tm.gst_id = gd.id AND tm.is_active = 1 
                                       AND tm.template_file IS NOT NULL AND tm.template_file != ''
                                       LIMIT 1)
                                  ) as template_file,
                                  COALESCE(
                                      (SELECT tm.invoice_name FROM template_mapping tm 
                                       WHERE tm.gst_id = gd.id AND tm.is_active = 1 
                                       AND tm.invoice_file IS NOT NULL AND tm.invoice_file != ''
                                       LIMIT 1),
                                      (SELECT tm.template_name FROM template_mapping tm 
                                       WHERE tm.gst_id = gd.id AND tm.is_active = 1 
                                       AND tm.template_file IS NOT NULL AND tm.template_file != ''
                                       LIMIT 1)
                                  ) as template_name
                                  FROM gst_details gd
                                  WHERE gd.gst_status = 1
                                  GROUP BY gd.id
                                  ORDER BY gd.business_name ASC";
                  
                  $businessRes = mysqli_query($conn, $businessSql);
                  $businesses = [];
                  $addedBusinesses = [];
                  
                  if ($businessRes && mysqli_num_rows($businessRes) > 0) {
                    while ($b = mysqli_fetch_assoc($businessRes)) {
                      $bid = (int)$b['id'];
                      $bname = htmlspecialchars($b['business_name']);
                      $gst = htmlspecialchars($b['gst_num'] ?? '');
                      $template = htmlspecialchars($b['template_file'] ?? '');
                      $templateName = htmlspecialchars($b['template_name'] ?? '');
                      
                      if (isset($addedBusinesses[$bid])) {
                        continue;
                      }
                      
                      $addedBusinesses[$bid] = true;
                      
                      $display = $bname;
                      if ($gst) $display .= " (GST: " . $gst . ")";
                      
                      $selected = ($bid == $prefilledBusinessId) ? 'selected' : '';
                      echo "<option value='{$bid}' {$selected}
                            data-business-name='{$bname}' 
                            data-gst='{$gst}'
                            data-template='{$template}'
                            data-template-name='{$templateName}'>
                            {$display}</option>";
                      
                      $businesses[] = [
                        'id' => $bid,
                        'business_name' => $b['business_name'],
                        'gst_num' => $b['gst_num'],
                        'template_file' => $b['template_file'],
                        'template_name' => $b['template_name']
                      ];
                    }
                  } else {
                    $fallbackSql = "SELECT id, business_name, gst_num FROM gst_details 
                                   WHERE gst_status = 1 
                                   ORDER BY business_name ASC";
                    $fallbackRes = mysqli_query($conn, $fallbackSql);
                    
                    if ($fallbackRes && mysqli_num_rows($fallbackRes) > 0) {
                      while ($b = mysqli_fetch_assoc($fallbackRes)) {
                        $bid = (int)$b['id'];
                        $bname = htmlspecialchars($b['business_name']);
                        $gst = htmlspecialchars($b['gst_num'] ?? '');
                        
                        $selected = ($bid == $prefilledBusinessId) ? 'selected' : '';
                        echo "<option value='{$bid}' {$selected}
                              data-business-name='{$bname}' 
                              data-gst='{$gst}'
                              data-template=''
                              data-template-name=''>
                              {$bname} (GST: {$gst})</option>";
                        
                        $businesses[] = [
                          'id' => $bid,
                          'business_name' => $b['business_name'],
                          'gst_num' => $b['gst_num'],
                          'template_file' => '',
                          'template_name' => ''
                        ];
                      }
                    }
                  }
                  ?>
                </select>
                <small class="text-muted">Select business for GST and invoice template.</small>
              </div>
            </div>

<div class="col-12 col-md-6">
              <div class="row g-2">
                <div class="col-7">
                  <label class="form-label">Bill Discount</label>
                  <input type="number" id="discountValue" class="form-control" value="0" min="0" step="0.01" />
                </div>
                <div class="col-5">
                  <label class="form-label">&nbsp;</label>
                  <select id="discountType" class="form-select">
                    <option value="percent">%</option>
                    <option value="flat">₹</option>
                  </select>
                </div>
              </div>
              <small class="text-muted d-block mt-2">Apply a bill-level discount (percent or flat).</small>
            </div>
          </div>
          
          
          <div id="businessInfoDisplay" class="business-info-display" style="display: none;">
            <div class="d-flex justify-content-between align-items-center">
              <div>
                <strong id="selectedBusinessName"></strong>
                <span id="selectedBusinessGST" class="ms-2 business-badge"></span>
                <span id="selectedBusinessTemplate" class="ms-2 business-badge"></span>
              </div>
              <small class="text-muted">This business will be used for this invoice</small>
            </div>
          </div>
        </div>
      </div>

<div class="card mb-3">
        <div class="card-body customer-details-section">
          <h5 class="mb-3"><i class="fas fa-user me-2"></i>Customer Details</h5>
          <div class="row">
            <div class="col-md-4 mb-3">
              <div class="form-group">
                <label class="form-label required">Customer Name <span class="text-danger">*</span></label>
                <input type="text" id="custName" value="<?php echo htmlspecialchars($prefilledCustomerName); ?>" class="form-control" placeholder="Enter customer name" required>
              </div>
            </div>
            
            <div class="col-md-4 mb-3">
              <div class="form-group">
                <label class="form-label">Customer Phone</label>
                <select id="custPhone" class="form-control">
                  <option value="">-- Select or type phone --</option>
                  <?php
                  $phoneSql = "SELECT DISTINCT phone, name FROM customers WHERE phone != '' AND phone IS NOT NULL ORDER BY name";
                  $phoneRes = mysqli_query($conn, $phoneSql);
                  if ($phoneRes && mysqli_num_rows($phoneRes) > 0) {
                    while ($customer = mysqli_fetch_assoc($phoneRes)) {
                      $phone = htmlspecialchars($customer['phone']);
                      $name = htmlspecialchars($customer['name']);
                      $selected = ($phone == $prefilledCustomerPhone) ? 'selected' : '';
                      echo "<option value='{$phone}' data-name='{$name}' {$selected}>{$phone} - {$name}</option>";
                    }
                  }
                  ?>
                </select>
              </div>
            </div>

<div class="col-md-4 mb-3">
              <div class="form-group">
                <label class="form-label">Customer GST Number</label>
                <input type="text" id="custGst" class="form-control" placeholder="e.g., 22AAAAA0000A1Z5" maxlength="15" value="<?php echo htmlspecialchars($prefilledCustomerGst); ?>">
                <small class="text-muted">Format: 15 characters (optional)</small>
                <div class="address-preview">
                  <i class="fas fa-info-circle"></i> For B2B invoices with GST
                </div>
              </div>
            </div>
          </div>

<div class="row">
            <div class="col-md-8 mb-3">
              <div class="form-group">
                <label class="form-label">Customer Address</label>
                <textarea id="custAddress" class="form-control" rows="2" placeholder="Enter full address..."><?php echo htmlspecialchars($prefilledCustomerAddress); ?></textarea>
                <small class="text-muted">Complete address for billing purposes (optional)</small>
              </div>
            </div>
            
            <div class="col-md-4 mb-3">
              <div class="form-group">
                <label class="form-label">Payment Method</label>
                <select id="paymentMethod" class="form-control">
                  <option value="cash">Cash</option>
                  <option value="card">Card</option>
                  <option value="upi">UPI</option>
                  <option value="bank_transfer">Bank Transfer</option>
                  <option value="cheque">Cheque</option>
                </select>
              </div>
            </div>
          </div>

<div class="row">
            <div class="col-md-4 mb-3">
              <div class="form-group">
                <label class="form-label">Cash Received</label>
                <div class="input-group">
                  <span class="input-group-text">₹</span>
                  <input type="number" id="cashReceived" class="form-control" value="0" min="0" step="0.01">
                </div>
                <small class="text-muted">Optional - for payment tracking</small>
              </div>
            </div>
            
            <div class="col-md-4 mb-3">
              <div class="form-group">
                <label class="form-label">Change Given</label>
                <div class="input-group">
                  <span class="input-group-text">₹</span>
                  <input type="number" id="changeGiven" class="form-control" value="0" min="0" step="0.01" readonly>
                </div>
                <small class="text-muted">Auto-calculated from cash received</small>
              </div>
            </div>
            
            <div class="col-md-4 mb-3 d-flex align-items-end">
              <div class="form-check">
                <input class="form-check-input" type="checkbox" id="fullPaymentCheck">
                <label class="form-check-label" for="fullPaymentCheck">
                  Set Cash Received = Grand Total
                </label>
              </div>
            </div>
          </div>
        </div>
      </div>

<div class="card mb-3">
        <div class="card-body">
          <h5 class="mb-3"><i class="fas fa-box me-2"></i>Add Products</h5>
          
          
          <div class="auto-add-notification" id="autoAddNotification">
            <i class="fas fa-info-circle"></i> Product automatically added to cart with quantity 1
          </div>

<div class="row controls-row g-3 mt-3">
            
            <div class="col-12 col-md-4">
              <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 - Auto adds with Qty 1</small>
              </div>
            </div>

<div class="col-12 col-md-8">
              <div class="form-group">
                <label class="form-label">Search Product</label>
                <select id="productSelect" class="form-select">
                  <option value="">-- Search product --</option>
                  <?php
                  $prodSql = "SELECT p.id, p.product_name, p.customer_price, p.quantity, p.hsn_code,
                                     p.is_gst_applicable, p.gst_percentage,
                                     c.category_name
                              FROM products p
                              LEFT JOIN categories c ON p.category_id = c.id
                              WHERE p.quantity > 0
                              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'] ?? '');
                      $hsn = htmlspecialchars($p['hsn_code'] ?? '');
                      $gstApplicable = (bool)$p['is_gst_applicable'];
                      $gstPercent = (float)$p['gst_percentage'];
                      $code = sprintf('%08d', $pid);
                      
                      echo "<option value='{$pid}' 
                            data-price='{$price}' 
                            data-code='{$code}'
                            data-category='{$cat}'
                            data-hsn='{$hsn}'
                            data-gst-applicable='{$gstApplicable}'
                            data-gst-percent='{$gstPercent}'
                            data-stock='{$stock}'>
                            {$name} — ₹" . number_format($price,2) . " ({$code})</option>";
                      
                      $jsProducts[] = [
                        'id' => $pid,
                        'name' => $p['product_name'],
                        'price' => $price,
                        'stock' => $stock,
                        'category' => $p['category_name'] ?? '',
                        'code' => $code,
                        'hsn_code' => $p['hsn_code'] ?? '',
                        'is_gst_applicable' => $gstApplicable,
                        'gst_percentage' => $gstPercent
                      ];
                    }
                  }
                  ?>
                </select>
                <small class="text-muted">Select product to auto-add with Qty 1</small>
              </div>
            </div>

<div class="col-6 col-md-2">
              <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="col-6 col-md-3">
              <div class="form-group">
                <label class="form-label">Item Discount</label>
                <div class="input-group">
                  <input type="number" id="itemDiscountValue" class="form-control" value="0" min="0" step="0.01">
                  <select id="itemDiscountType" class="form-select" style="max-width:110px;">
                    <option value="percent">%</option>
                    <option value="flat">₹</option>
                  </select>
                </div>
              </div>
            </div>
            
            <div class="col-12 col-md-4 d-flex align-items-end">
              <button id="btnAddProduct" class="btn btn-primary w-100">
                <i class="fas fa-plus me-2"></i>Add Product
              </button>
            </div>
          </div>

<div class="row mt-3">
            <div class="col-12">
              <div class="form-group">
                <label class="form-label">Invoice Notes (Optional)</label>
                <textarea id="invoiceNotes" class="form-control" rows="2" placeholder="Additional notes for this invoice..."><?php echo htmlspecialchars($prefilledNotes); ?></textarea>
              </div>
            </div>
          </div>
        </div>
      </div>

<div class="row">
        <div class="col-12">
          <div class="card">
            <div class="card-body">
              <h5 class="mb-3" id="cartTitle">
                <i class="fas fa-shopping-cart me-2"></i>Cart Items 
                <?php if($isConvertingFromQuotation): ?>
                  <span class="badge bg-info">From Quotation</span>
                <?php endif; ?>
              </h5>
              <div class="table-responsive">
                <table class="table table-bordered table-cart" id="cartTable">
                  <thead>
                    <tr>
                      <th style="width:50px;">#</th>
                      <th>Item</th>
                      <th style="width:120px;">Price (₹)</th>
                      <th style="width:100px;">Qty</th>
                      <th style="width:150px;">Discount</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="7">No items added yet</td></tr>
                  </tbody>
                </table>
              </div>
              <div class="d-flex gap-2 mt-3">
                <button id="btnAddAnother" class="btn btn-light">
                  <i class="fas fa-plus me-2"></i>Add Another Item
                </button>
                <button id="btnClearCart" class="btn btn-outline-danger">
                  <i class="fas fa-trash me-2"></i>Clear Cart
                </button>
                <button id="btnSaveBill" class="btn btn-primary ms-auto">
                  <i class="fas fa-save me-2"></i>Save Bill
                </button>
                <button id="btnGenerateBill" class="btn btn-success">
                  <i class="fas fa-print me-2"></i>Generate & Print
                </button>
              </div>
            </div>
          </div>
        </div>
      </div>
    </div>
  </div>

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

<div id="fixedTotalCard" class="fixed-total-card" role="region" aria-label="Invoice summary">
  <div class="mini-card" id="miniCard">
    <div class="left">
      <div class="label">GRAND TOTAL</div>
      <div id="miniAmount" class="amount">₹ 0.00</div>
    </div>

<button id="fixedBtnGenerateBill" class="print-btn" title="Generate & Print">
      <svg viewBox="0 0 24 24" fill="none" xmlns="http://www.w3.org/2000/svg" aria-hidden="true">
        <path d="M6 9V3h12v6" stroke="rgba(255,255,255,0.95)" stroke-width="1.6" stroke-linecap="round" stroke-linejoin="round"/>
        <path d="M6 18H4a2 2 0 0 1-2-2V11a2 2 0 0 1 2-2h16a2 2 0 0 1 2 2v5a2 2 0 0 1-2 2h-2" stroke="rgba(255,255,255,0.95)" stroke-width="1.6" stroke-linecap="round" stroke-linejoin="round"/>
        <rect x="8" y="12" width="8" height="6" rx="1" stroke="rgba(255,255,255,0.95)" stroke-width="1.6" fill="rgba(255,255,255,0.02)"/>
      </svg>
      PRINT
    </button>
  </div>
</div>

<?php include('includes/rightbar.php'); ?>
<?php include('includes/scripts.php); ?>
<link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" />
<script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/html2pdf.js/0.10.1/html2pdf.bundle.min.js"></script>

// Quotation data from PHP
const QUOTATION_DATA = <?php echo json_encode($quotationData, JSON_UNESCAPED_UNICODE|JSON_UNESCAPED_SLASHES); ?>;
const QUOTATION_ITEMS = <?php echo json_encode($quotationItems, JSON_UNESCAPED_UNICODE|JSON_UNESCAPED_SLASHES); ?>;
const IS_CONVERTING_FROM_QUOTATION = <?php echo $isConvertingFromQuotation ? 'true' : 'false'; ?>;
const QUOTATION_ID = <?php echo $quotationId; ?>;

let CART = [];
let selectedBusiness = null;
let currentInvoiceData = null;
let currentInvoiceId = null;

// === UI HELPER FUNCTIONS ===
function showToast(message, type = 'success', duration = 3000) {
    const container = document.getElementById('toastContainer');
    const toast = document.createElement('div');
    toast.className = `toast-notification ${type}`;
    toast.innerHTML = `
        <div class="toast-header">
            <div class="toast-title">
                ${type === 'success' ? '✓ Success' : type === 'error' ? '✗ Error' : type === 'warning' ? '⚠ Warning' : 'ℹ Info'}
            </div>
            <button class="toast-close">&times;</button>
        </div>
        <div class="toast-body">${message}</div>
    `;
    
    container.appendChild(toast);
    
    setTimeout(() => toast.classList.add('show'), 10);
    
    toast.querySelector('.toast-close').addEventListener('click', () => {
        toast.classList.remove('show');
        setTimeout(() => toast.remove(), 300);
    });
    
    setTimeout(() => {
        if (toast.parentNode) {
            toast.classList.remove('show');
            setTimeout(() => toast.remove(), 300);
        }
    }, duration);
}

function showLoading(message = 'Processing...') {
    const overlay = document.getElementById('loadingOverlay');
    document.getElementById('loadingMessage').textContent = message;
    overlay.classList.add('show');
}

function hideLoading() {
    const overlay = document.getElementById('loadingOverlay');
    overlay.classList.remove('show');
}

// === 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).replace(/[&<>"']/g, m => ({'&':'&amp;','<':'&lt;','>':'&gt;','"':'&quot;',"'":'&#039;'})[m]); 
}
function money(n) { 
    return '₹ ' + Number(n).toFixed(2); 
}

// === GST Validation ===
function validateGST(gst) {
    if (!gst) return true; // Optional field
    // GST format: 2 digits state code + 10 digits PAN + 1 digit entity number + 1 digit check + 1 digit
    const gstRegex = /^[0-9]{2}[A-Z]{5}[0-9]{4}[A-Z]{1}[1-9A-Z]{1}[Z]{1}[0-9A-Z]{1}$/;
    return gstRegex.test(gst);
}

// === CART FUNCTIONS ===
function calculateItemTotal(item) {
    const base = item.price * item.qty;
    const disc = item.discountType === 'percent' ? base * (item.discountValue / 100) : item.discountValue;
    return Math.max(0, base - disc);
}
function calculateItemDiscount(item) {
    const base = item.price * item.qty;
    return item.discountType === 'percent' ? base * (item.discountValue / 100) : item.discountValue;
}
function showAutoAddNotification(msg) {
    const el = document.getElementById('autoAddNotification');
    el.innerHTML = `<i class="fas fa-info-circle"></i> ${msg}`;
    el.style.display = 'block';
    setTimeout(() => el.style.display = 'none', 3000);
}

// Add to cart function
async function addToCart(item, qty = 1, discountValue = 0, discountType = 'percent', options = {}) {
    // Check if business is selected
    if (!selectedBusiness) {
        showToast('Please select a business first', 'warning');
        document.getElementById('businessSelect').focus();
        return;
    }
    
    qty = Math.max(1, parseInt(qty, 10) || 1);
    discountValue = parseFloat(discountValue) || 0;
    
    const showNotif = options.showNotif || false;

// Check stock for products
    if (item.stock !== undefined && qty > item.stock) {
        const confirmProceed = await showConfirmation(`Only ${item.stock} units available for "${item.name}". Add ${qty} anyway?`);
        if (!confirmProceed) {
            return;
        }
    }

// Check if same item already exists (merge if same ID)
    const existingIndex = CART.findIndex(cartItem => cartItem.id === item.id);
    
    if (existingIndex >= 0) {
        // Update existing item
        CART[existingIndex].qty += qty;
        if (discountValue > 0) {
            CART[existingIndex].discountValue = discountValue;
            CART[existingIndex].discountType = discountType;
        }
        
        if (showNotif) showAutoAddNotification(`${item.name} - Quantity increased to ${CART[existingIndex].qty}`);
    } else {
        // Add new item
        const cartItem = {
            id: item.id,
            name: item.name,
            price: +item.price,
            qty: qty,
            category: item.category || '',
            discountValue: discountValue,
            discountType: discountType,
            originalPrice: +item.price,
            stock: item.stock || 0,
            code: item.code || '',
            hsn_code: item.hsn_code || '',
            is_gst_applicable: item.is_gst_applicable || false,
            gst_percentage: item.gst_percentage || 0
        };
        
        CART.unshift(cartItem);
        if (showNotif) showAutoAddNotification(`${item.name} - Added with quantity ${qty}`);
    }
    
    renderCart();
    clearInputs();
    updateMiniAmount();
    updateChangeGiven(); // Update change calculation
}

function removeFromCart(id) { 
    CART = CART.filter(i => i.id !== id); 
    renderCart(); 
    updateMiniAmount();
    updateChangeGiven();
}

function updateItemDiscount(id, val, type) {
    const item = CART.find(i => i.id === id);
    if (item) { 
        item.discountValue = parseFloat(val) || 0; 
        item.discountType = type; 
        renderCart(); 
        updateMiniAmount();
        updateChangeGiven();
    }
}

function updatePrice(id, price) {
    const item = CART.find(i => i.id === id);
    if (item && price > 0) {
        item.price = parseFloat(price);
        renderCart();
        updateMiniAmount();
        updateChangeGiven();
    }
}

// === RENDER CART ===
function renderCart() {
    const tbody = document.getElementById('cartBody');
    const cartTitle = document.getElementById('cartTitle');
    
    // Update cart title
    if (CART.length === 0) {
        cartTitle.innerHTML = '<i class="fas fa-shopping-cart me-2"></i>Cart Items';
    } else {
        cartTitle.innerHTML = `<i class="fas fa-shopping-cart me-2"></i>Cart Items (${CART.length} items)`;
    }
    
    tbody.innerHTML = '';
    
    if (CART.length === 0) {
        tbody.innerHTML = '<tr class="text-center text-muted" id="emptyRow"><td colspan="7">No items added yet</td></tr>';
    } else {
        CART.forEach((item, idx) => {
            const total = calculateItemTotal(item);
            
            const tr = document.createElement('tr');
            
            let itemDetails = `<div>${escapeHtml(item.name)}</div><small class="service-notes">`;
            
            if (item.category) itemDetails += `<span class="badge bg-secondary text-white ms-1">${item.category}</span>`;
            if (item.code) itemDetails += `<span class="badge bg-dark text-white ms-1">${item.code}</span>`;
            if (item.is_gst_applicable) itemDetails += `<span class="badge bg-success text-white ms-1">GST: ${item.gst_percentage}%</span>`;
            if (item.stock !== undefined) itemDetails += `<span class="badge bg-warning text-dark ms-1">Stock: ${item.stock}</span>`;
            
            itemDetails += '</small>';
            
            tr.innerHTML = `
                <td>${idx + 1}</td>
                <td>${itemDetails}</td>
                <td>
                    <input type="number" class="form-control price-input" value="${item.price.toFixed(2)}" 
                           step="0.01" min="0" data-act="price" data-id="${item.id}">
                </td>
                <td>
                    <div class="input-group input-group-sm">
                        <button class="btn btn-light btn-sm" data-act="minus" data-id="${item.id}">-</button>
                        <input type="number" class="form-control text-center" style="max-width:80px" 
                               value="${item.qty}" min="1" data-act="qty" data-id="${item.id}">
                        <button class="btn btn-light btn-sm" data-act="plus" data-id="${item.id}">+</button>
                    </div>
                </td>
                <td>
                    <div class="input-group input-group-sm" style="display:flex;align-items:center;">
                        <input type="number" class="form-control discount-input" 
                               value="${item.discountValue || 0}" min="0" step="0.01" 
                               data-act="discount-value" data-id="${item.id}" style="flex:3;min-width:60px;">
                        <select class="form-select discount-type" data-act="discount-type" data-id="${item.id}" 
                                style="flex:1;max-width:50px;">
                            <option value="percent" ${item.discountType==='percent'?'selected':''}>%</option>
                            <option value="flat" ${item.discountType==='flat'?'selected':''}>₹</option>
                        </select>
                    </div>
                </td>
                <td class="item-total">${total.toFixed(2)}</td>
                <td>
                    <button class="btn btn-danger btn-sm" data-act="remove" data-id="${item.id}">
                        <i class="fas fa-times"></i>
                    </button>
                </td>
            `;
            tbody.appendChild(tr);
        });
    }

updateMiniAmount();
}

// Update floating mini card amount
function updateMiniAmount() {
    const t = totals();
    document.getElementById('miniAmount').textContent = '₹ ' + Number(t.grandTotal).toFixed(2);
}

// Update change given based on cash received
function updateChangeGiven() {
    const t = totals();
    const cashReceived = parseFloat(document.getElementById('cashReceived')?.value || '0') || 0;
    const changeGiven = Math.max(0, cashReceived - t.grandTotal);
    document.getElementById('changeGiven').value = changeGiven.toFixed(2);
}

// === BUSINESS SELECTION ===
function updateBusinessInfo(businessId) {
    if (!businessId) {
        selectedBusiness = null;
        document.getElementById('businessInfoDisplay').style.display = 'none';
        renderCart();
        updateMiniAmount();
        updateChangeGiven();
        return;
    }
    
    // Find business
    const business = BUSINESSES.find(b => b.id == businessId);
    if (business) {
        selectedBusiness = business;
        
        // Update display
        document.getElementById('selectedBusinessName').textContent = business.business_name;
        document.getElementById('selectedBusinessGST').textContent = business.gst_num ? `GST: ${business.gst_num}` : 'No GST';
        
        const templateText = business.template_name ? `Template: ${business.template_name}` : 'No Template';
        document.getElementById('selectedBusinessTemplate').textContent = templateText;
        document.getElementById('selectedBusinessTemplate').title = business.template_file || '';
        
        document.getElementById('businessInfoDisplay').style.display = 'block';
        renderCart(); // Recalculate totals with GST
        updateMiniAmount();
        updateChangeGiven();
    }
}

// === GET INVOICE TEMPLATE ===
function getInvoiceTemplate(businessId) {
    const business = BUSINESSES.find(b => b.id == businessId);
    if (!business) return 'invoice_print.php';
    
    let templateFile = business.template_file || '';
    
    // If template file is empty, use default
    if (!templateFile) {
        return 'invoice_print.php';
    }
    
    // Check if it's a quotation template (quo-*) and convert to invoice template (inv-*)
    if (templateFile.startsWith('quo-')) {
        templateFile = templateFile.replace('quo-', 'inv-');
    }
    
    return templateFile;
}

// === SHOW PDF PREVIEW ===
function showPDFPreview(invoiceData) {
    currentInvoiceData = invoiceData;
    currentInvoiceId = invoiceData.invoice_id;
    
    // Get the template file
    const templateFile = getInvoiceTemplate(selectedBusiness.id);
    const previewUrl = `${templateFile}?invoice_id=${currentInvoiceId}&print_mode=pdf&preview=1`;
    
    // Show the modal
    const modal = document.getElementById('pdfPreviewModal');
    const iframe = document.getElementById('pdfIframe');
    
    iframe.src = previewUrl;
    modal.classList.add('show');
    
    // Set modal title
    document.querySelector('#pdfPreviewModal .pdf-preview-header h5').textContent = 
        `Invoice Preview - ${invoiceData.invoice_number}`;
    
    showToast('Invoice loaded in preview', 'info');
}

// === PRINT PDF ===
function printPDF() {
    if (!currentInvoiceId) {
        showToast('No invoice loaded', 'error');
        return;
    }
    
    const templateFile = getInvoiceTemplate(selectedBusiness.id);
    const printUrl = `${templateFile}?invoice_id=${currentInvoiceId}&print_mode=print`;
    
    const printWindow = window.open(printUrl, '_blank', 'width=800,height=600,scrollbars=yes');
    
    if (!printWindow) {
        showToast('Print window blocked. Please allow popups for this site.', 'warning');
        return;
    }
    
    // Close the preview modal after opening print window
    setTimeout(() => {
        document.getElementById('pdfPreviewModal').classList.remove('show');
    }, 500);
}

// === SAVE INVOICE ===
async function saveInvoice(printAfterSave = false) {
    if (CART.length === 0) { 
        showToast('No items in cart', 'warning');
        return null; 
    }
    
    if (!selectedBusiness) {
        showToast('Please select a business', 'error');
        document.getElementById('businessSelect').focus();
        return null;
    }
    
    const custName = document.getElementById('custName').value.trim();
    
    if (!custName) { 
        showToast('Customer name is required', 'error');
        document.getElementById('custName').focus();
        return null; 
    }

// Validate GST if provided
    const custGst = document.getElementById('custGst').value.trim();
    if (custGst && !validateGST(custGst)) {
        showToast('Please enter a valid GST number (15 characters with correct format)', 'error');
        document.getElementById('custGst').focus();
        return null;
    }

// Get invoice template
    const invoiceTemplate = getInvoiceTemplate(selectedBusiness.id);
    
    // Get bill discount values
    const discVal = parseFloat(document.getElementById('discountValue')?.value || '0') || 0;
    const discType = document.getElementById('discountType')?.value || 'percent';
    
    // Prepare payload - Include quotation_id if converting
    const payload = {
        customer_name: custName,
        customer_phone: document.getElementById('custPhone').value.trim(),
        customer_gst: custGst,
        customer_address: document.getElementById('custAddress').value.trim(),
        business_id: selectedBusiness.id,
        business_name: selectedBusiness.business_name,
        gst_number: selectedBusiness.gst_num || '',
        template_file: invoiceTemplate,
        template_name: selectedBusiness.template_name || '',
        subtotal: t.originalSubtotal,
        total_item_discount: t.totalItemDiscount,
        discount: t.billDiscount,
        discount_type: discType,
        total: t.grandTotal,
        cash_received: cashReceived,
        change_given: changeGiven,
        payment_method: paymentMethod,
        invoice_notes: document.getElementById('invoiceNotes')?.value || '',
        total_gst: t.gstAmount,
        total_cgst: t.gstAmount / 2,
        total_sgst: t.gstAmount / 2,
        quotation_id: IS_CONVERTING_FROM_QUOTATION ? QUOTATION_ID : null, // Include quotation ID
        items: CART.map(item => ({
            id: item.id,
            name: item.name,
            price: item.price,
            quantity: item.qty,
            discount: item.discountValue,
            discount_type: item.discountType,
            total_price: calculateItemTotal(item),
            item_discount: calculateItemDiscount(item),
            category: item.category,
            product_code: item.code || '',
            hsn_code: item.hsn_code || '',
            is_gst_applicable: item.is_gst_applicable || false,
            gst_percentage: item.gst_percentage || 0
        }))
    };

// Show loading
    showLoading(printAfterSave ? 'Saving and preparing print...' : 'Saving invoice...');
    
    try {
        const response = await fetch('save_common.php', {
            method: 'POST',
            headers: { 'Content-Type': 'application/json' },
            body: JSON.stringify(payload)
        });
        
        hideLoading();
        
        if (!response.ok) {
            throw new Error(`HTTP error! Status: ${response.status}`);
        }
        
        const text = await response.text();
        
        // Check if it's HTML (should be JSON)
        if (text.trim().startsWith('<!DOCTYPE') || 
            text.trim().startsWith('<html') || 
            text.includes('<br />') || 
            text.includes('<b>') ||
            text.includes('<?php')) {
            throw new Error('Server configuration error');
        }
        
        const data = JSON.parse(text);
        
        if (data.success) {
            let successMessage = `Invoice #${data.invoice_number} saved successfully`;
            if (IS_CONVERTING_FROM_QUOTATION) {
                successMessage += ` (converted from quotation ${QUOTATION_DATA?.quotation_number || ''})`;
            }
            showToast(successMessage, 'success');
            return data;
        } else {
            let errorMsg = data.message || 'Unknown error';
            
            if (data.error_code === 'MISSING_CUSTOMER') {
                errorMsg = 'Customer name is required';
            } else if (data.error_code === 'MISSING_BUSINESS') {
                errorMsg = 'Business selection is required';
            } else if (data.error_code === 'EMPTY_CART') {
                errorMsg = 'No items in cart';
            } else if (data.error_code === 'INSUFFICIENT_STOCK') {
                errorMsg = 'Insufficient stock for some products';
            }
            
            showToast(`Save failed: ${errorMsg}`, 'error');
            return null;
        }
    } catch (err) { 
        console.error('Save error:', err);
        hideLoading();
        
        let errorMsg = err.message;
        if (errorMsg.includes('HTML') || err.message.includes('Server configuration')) {
            errorMsg = 'Server configuration error. Please make sure save_common.php is properly configured.';
        } else if (errorMsg.includes('Failed to fetch') || err.message.includes('Network')) {
            errorMsg = 'Network error. Please check your internet connection.';
        } else if (errorMsg.includes('Invalid JSON')) {
            errorMsg = 'Server returned invalid data. Please try again.';
        }
        
        showToast(`Save failed: ${errorMsg}`, 'error');
        return null;
    }
}

// === OPEN PRINT WINDOW ===
function openPrintWindow(invoiceId) {
    if (!selectedBusiness) {
        showToast('Please select a business to print invoice', 'error');
        return false;
    }
    
    const invoiceTemplate = getInvoiceTemplate(selectedBusiness.id);
    const url = `${invoiceTemplate}?invoice_id=${encodeURIComponent(invoiceId)}&auto=1&business_id=${selectedBusiness.id}`;
    
    const printWindow = window.open(url, '_blank', 'width=800,height=600,scrollbars=yes');
    
    if (!printWindow) {
        showToast('Print window blocked. Please allow popups for this site.', 'warning');
        return false;
    }
    
    return true;
}

// === RESET FORM ===
function resetFormAfterSave() {
    CART = [];
    selectedBusiness = null;
    renderCart();
    clearInputs();
    updateMiniAmount();
    
    // Reset business selection
    $('#businessSelect').val('').trigger('change');
    document.getElementById('businessInfoDisplay').style.display = 'none';
    
    // Reset customer info
    document.getElementById('custName').value = 'Walk-in-Customer';
    document.getElementById('custGst').value = '';
    document.getElementById('custAddress').value = '';
    $('#custPhone').val('').trigger('change');
    
    // Reset discount
    document.getElementById('discountValue').value = 0;
    
    // Reset payment
    document.getElementById('cashReceived').value = 0;
    document.getElementById('changeGiven').value = 0;
    document.getElementById('paymentMethod').value = 'cash';
    
    // Reset invoice notes
    document.getElementById('invoiceNotes').value = '';
    
    // Reset full payment checkbox
    document.getElementById('fullPaymentCheck').checked = false;
    
    // Focus on scan input
    document.getElementById('scanInput').focus();
    
    showToast('New bill started', 'info');
}

// === LOAD QUOTATION ITEMS ===
async function loadQuotationItems() {
    if (!IS_CONVERTING_FROM_QUOTATION || QUOTATION_ITEMS.length === 0) {
        return;
    }
    
    showLoading('Loading quotation items...');
    
    try {
        // Load business first if we have it
        if (QUOTATION_DATA.business_id) {
            const businessSelect = document.getElementById('businessSelect');
            if (businessSelect) {
                businessSelect.value = QUOTATION_DATA.business_id;
                $(businessSelect).trigger('change');
                updateBusinessInfo(QUOTATION_DATA.business_id);
            }
        }
        
        // Set customer info if available
        if (QUOTATION_DATA.customer_name) {
            document.getElementById('custName').value = QUOTATION_DATA.customer_name;
        }
        if (QUOTATION_DATA.customer_phone) {
            $('#custPhone').val(QUOTATION_DATA.customer_phone).trigger('change');
        }
        if (QUOTATION_DATA.notes) {
            document.getElementById('invoiceNotes').value = QUOTATION_DATA.notes;
        }
        
        // Load each quotation item
        for (const item of QUOTATION_ITEMS) {
            // Find product in PRODUCTS array
            const product = PRODUCTS.find(p => p.id == item.item_id);
            if (product) {
                const cartItem = {
                    id: product.id,
                    name: product.name,
                    price: parseFloat(item.unit_price) || product.price,
                    qty: parseFloat(item.quantity) || 1,
                    category: product.category || '',
                    discountValue: parseFloat(item.discount) || 0,
                    discountType: item.discount_type || 'percent',
                    originalPrice: product.price,
                    stock: product.stock || 0,
                    code: product.code || '',
                    hsn_code: item.hsn_code || product.hsn_code || '',
                    is_gst_applicable: product.is_gst_applicable || false,
                    gst_percentage: product.gst_percentage || 0
                };
                CART.push(cartItem);
            }
        }
        
        hideLoading();
        
        if (CART.length > 0) {
            renderCart();
            updateMiniAmount();
            updateChangeGiven();
            showToast(`Loaded ${CART.length} items from quotation`, 'success');
        } else {
            showToast('No valid items found in quotation', 'warning');
        }
        
    } catch (error) {
        console.error('Error loading quotation items:', error);
        hideLoading();
        showToast('Error loading quotation items', 'error');
    }
}

// === DOM READY ===
document.addEventListener('DOMContentLoaded', () => {
    // Initialize select2
    $('#productSelect').select2({ placeholder: "Search product...", allowClear: true, width: '100%' });
    $('#custPhone').select2({ placeholder: "Select or type phone", allowClear: true, width: '100%', tags: true });
    $('#businessSelect').select2({ placeholder: "Select business...", allowClear: true, width: '100%' });

// Business selection change
    $('#businessSelect').on('change', function () {
        updateBusinessInfo(this.value);
    });

// Auto-add on product select
    $('#productSelect').on('select2:select', function () {
        const pid = this.value;
        if (!pid) return;
        const product = findProductById(pid);
        if (!product) {
            showToast('Product not found', 'error');
            return;
        }

const qty = parseInt(document.getElementById('qtyInput').value) || 1;
        const discountValue = document.getElementById('itemDiscountValue').value;
        const discountType = document.getElementById('itemDiscountType').value;

addToCart(product, qty, discountValue, discountType, { showNotif: true });
    });

// Customer phone change
    $('#custPhone').on('change', function () {
        const name = $(this).find('option:selected').data('name');
        if (name) {
            document.getElementById('custName').value = name;
        }
    });

// Add product button
    document.getElementById('btnAddProduct').addEventListener('click', async () => {
        const pid = document.getElementById('productSelect').value;
        const qty = parseInt(document.getElementById('qtyInput').value) || 1;
        if (!pid) { 
            showToast('Select a product', 'warning');
            return; 
        }
        
        const product = findProductById(pid);
        if (!product) { 
            showToast('Product not found', 'error');
            return; 
        }

const discountValue = document.getElementById('itemDiscountValue').value;
        const discountType = document.getElementById('itemDiscountType').value;

await addToCart(product, qty, discountValue, discountType, { showNotif: true });
    });

// Barcode scanning
    document.getElementById('scanInput').addEventListener('keydown', async (e) => {
        if (e.key !== 'Enter') return;
        
        const code = e.target.value.trim();
        if (!code) return;
        
        const product = findProductByBarcode(code);
        if (!product) {
            showToast(`No product found for barcode: ${code}`, 'error');
            e.target.value = '';
            return;
        }

const discountValue = document.getElementById('itemDiscountValue').value;
        const discountType = document.getElementById('itemDiscountType').value;

await addToCart(product, 1, discountValue, discountType, { showNotif: true });
        e.target.value = '';
        document.getElementById('itemDiscountValue').value = 0;
        e.target.focus();
    });

// Cart actions - Event delegation
    document.getElementById('cartBody').addEventListener('click', async e => {
        const act = e.target.getAttribute('data-act');
        const id = parseInt(e.target.getAttribute('data-id'), 10);
        if (!act || isNaN(id)) return;
        
        if (act === 'remove') {
            const confirmRemove = await showConfirmation(`Remove this item from cart?`);
            if (confirmRemove) {
                removeFromCart(id);
                showToast(`Item removed from cart`, 'info');
            }
        }
        if (act === 'minus') { 
            const item = CART.find(i => i.id === id); 
            if (item && item.qty > 1) {
                updateQty(id, item.qty - 1);
            }
        }
        if (act === 'plus') { 
            const item = CART.find(i => i.id === id); 
            if (item) {
                updateQty(id, item.qty + 1);
            }
        }
    });

// Cart input changes
    document.getElementById('cartBody').addEventListener('change', e => {
        const act = e.target.getAttribute('data-act');
        const id = parseInt(e.target.getAttribute('data-id'), 10);
        
        if (act === 'qty') {
            updateQty(id, e.target.value);
        }
        if (act === 'discount-value') {
            const typeEl = document.querySelector(`[data-act="discount-type"][data-id="${id}"]`);
            updateItemDiscount(id, e.target.value, typeEl?.value || 'percent');
        }
        if (act === 'discount-type') {
            const valEl = document.querySelector(`[data-act="discount-value"][data-id="${id}"]`);
            updateItemDiscount(id, valEl?.value || 0, e.target.value);
        }
        if (act === 'price') {
            updatePrice(id, e.target.value);
        }
    });

// Cart input live updates
    document.getElementById('cartBody').addEventListener('input', e => {
        const act = e.target.getAttribute('data-act');
        const id = parseInt(e.target.getAttribute('data-id'), 10);
        
        if (act === 'qty' || act === 'discount-value' || act === 'price') {
            const item = CART.find(i => i.id === id);
            if (item) {
                if (act === 'qty') item.qty = parseInt(e.target.value) || 1;
                if (act === 'discount-value') item.discountValue = parseFloat(e.target.value) || 0;
                if (act === 'price') item.price = parseFloat(e.target.value) || 0;
                renderCart();
                updateMiniAmount();
                updateChangeGiven();
            }
        }
    });

// Cash received change
    document.getElementById('cashReceived').addEventListener('input', function() {
        updateChangeGiven();
    });

// Full payment checkbox
    document.getElementById('fullPaymentCheck').addEventListener('change', function() {
        if (this.checked) {
            const t = totals();
            document.getElementById('cashReceived').value = t.grandTotal.toFixed(2);
            updateChangeGiven();
        }
    });

// Button actions
    document.getElementById('btnAddAnother').addEventListener('click', () => {
        document.getElementById('scanInput').focus();
    });
    
    document.getElementById('btnClearCart').addEventListener('click', async () => {
        if (CART.length === 0) {
            showToast('Cart is already empty', 'info');
            return;
        }
        const confirmClear = await showConfirmation('Clear all items from cart?');
        if (confirmClear) {
            CART = [];
            renderCart();
            updateMiniAmount();
            updateChangeGiven();
            showToast('Cart cleared', 'info');
        }
    });

// SAVE BILL (Save only)
    document.getElementById('btnSaveBill')?.addEventListener('click', async () => {
        const result = await saveInvoice(false);
        if (result) {
            setTimeout(async () => {
                const startNew = await showConfirmation('Bill saved successfully. Start new bill?');
                if (startNew) {
                    resetFormAfterSave();
                }
            }, 1000);
        }
    });

// GENERATE & PRINT BILL (Save + Print)
    document.getElementById('btnGenerateBill')?.addEventListener('click', async () => {
        const result = await saveInvoice(true);
        if (result) {
            const printSuccess = openPrintWindow(result.invoice_id);
            
            if (printSuccess) {
                setTimeout(() => {
                    resetFormAfterSave();
                }, 1000);
            }
        }
    });

// fixed card print button: reuse same logic
    document.getElementById('fixedBtnGenerateBill').addEventListener('click', async () => {
        const result = await saveInvoice(true);
        if (result) {
            const printSuccess = openPrintWindow(result.invoice_id);
            if (printSuccess) {
                setTimeout(() => resetFormAfterSave(), 1000);
            }
        }
    });

// PDF Preview Modal Controls
    document.getElementById('closePdfPreview').addEventListener('click', () => {
        document.getElementById('pdfPreviewModal').classList.remove('show');
        document.getElementById('pdfIframe').src = '';
    });
    
    document.getElementById('cancelPdf').addEventListener('click', () => {
        document.getElementById('pdfPreviewModal').classList.remove('show');
        document.getElementById('pdfIframe').src = '';
    });
    
    document.getElementById('printPdf').addEventListener('click', () => {
        printPDF();
    });
    
    document.getElementById('refreshPreview').addEventListener('click', () => {
        if (currentInvoiceId) {
            const templateFile = getInvoiceTemplate(selectedBusiness.id);
            const previewUrl = `${templateFile}?invoice_id=${currentInvoiceId}&print_mode=pdf&preview=1&t=${Date.now()}`;
            document.getElementById('pdfIframe').src = previewUrl;
            showToast('Preview refreshed', 'info');
        }
    });

// Close quotation banner
    document.getElementById('closeQuotationBanner')?.addEventListener('click', function() {
        this.parentElement.style.display = 'none';
    });

// Initialize - Load quotation items if converting
    renderCart();
    updateMiniAmount();
    updateChangeGiven();
    
    if (IS_CONVERTING_FROM_QUOTATION) {
        // Set initial business if available
        if (QUOTATION_DATA.business_id) {
            setTimeout(() => {
                const businessSelect = document.getElementById('businessSelect');
                if (businessSelect) {
                    businessSelect.value = QUOTATION_DATA.business_id;
                    $(businessSelect).trigger('change');
                }
            }, 500);
        }
        
        // Load quotation items
        setTimeout(() => {
            loadQuotationItems();
        }, 800);
    } else {
        document.getElementById('scanInput').focus();
    }
});

// Clear input fields after adding items
function clearInputs() {
    // Clear product inputs
    document.getElementById('qtyInput').value = 1;
    document.getElementById('itemDiscountValue').value = 0;
    
    // Reset select2 dropdown
    $('#productSelect').val(null).trigger('change');
}
</script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: common_sale.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation