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/trading/pos

Free Space:

10.12 TB

🔧 Quick Actions

✏️ Editing: pos-script.js

// ==================== GLOBAL STATE ====================
let CART = [];
let PRODUCTS = [];
let BARCODE_MAP = {};
let CUSTOMERS = [];
let REFERRALS = [];
let LOYALTY_SETTINGS = {};
let CUSTOMER_POINTS = {
  available_points: 0,
  total_points_earned: 0,
  total_points_redeemed: 0,
};

let GLOBAL_PRICE_TYPE = "retail";
let GST_TYPE = "gst";
let ACTIVE_PAYMENT_METHODS = new Set(["cash"]);
let SELECTED_REFERRAL_ID = null;
let CURRENT_CUSTOMER_ID = null;
let LOYALTY_POINTS_DISCOUNT = 0;
let POINTS_USED = 0;
let PENDING_CONFIRMATION = null;
let IS_INITIALIZED = false;
let CURRENT_PRODUCT = null;
let CURRENT_UNIT_IS_SECONDARY = false;
let IS_CART_LOADED = false;
let CREDIT_DUE_DATE = null;
let CREDIT_DUE_DAYS = 30;
let CURRENT_PRODUCT_FILTER = "all";
let TRANSPORT_DETAILS = {
  type: "",
  charge: 0,
};
let SHIPPING_DETAILS = {
  name: "",
  contact: "",
  gstin: "",
  address: "",
  vehicle_number: "",
  charges: 0,
};

// ==================== INITIALIZATION ====================
document.addEventListener("DOMContentLoaded", function () {
  console.log("POS System: Initializing...");
  try {
    initializeApp();
    setupEventListeners();
    loadInitialData();
    loadCartFromSession();
    loadShippingDetailsFromSession();
    loadTransportDetailsFromSession();

setTimeout(() => {
      addProfitButtonToFixedBottom();
      initGstFilter();
      initTransportSection();
      initShippingModal();
    }, 500);
  } catch (error) {
    console.error("POS System: Initialization failed:", error);
    showToast(
      "System initialization failed. Please refresh the page.",
      "danger",
    );
  }

const creditDueDateInput = document.getElementById("credit-due-date");
  if (creditDueDateInput) {
    creditDueDateInput.addEventListener("change", function () {
      CREDIT_DUE_DATE = this.value;
      updatePaymentSummary();
    });
  }

loadCreditSettings();
});

// Add CSS for new features
const style = document.createElement("style");
style.textContent = `
    .category-badge { display: inline-block; padding: 2px 8px; border-radius: 12px; font-size: 0.8em; font-weight: 600; margin-right: 4px; }
    .subcategory-badge { display: inline-block; padding: 2px 8px; border-radius: 12px; font-size: 0.8em; font-weight: 500; background-color: #e3f2fd; color: #0d47a1; }
    .stock-high { background-color: #c8e6c9; color: #1b5e20; padding: 2px 8px; border-radius: 12px; font-weight: 600; }
    .stock-medium { background-color: #e8f5e9; color: #2e7d32; padding: 2px 8px; border-radius: 12px; font-weight: 600; }
    .stock-low { background-color: #fff3e0; color: #ef6c00; padding: 2px 8px; border-radius: 12px; font-weight: 600; }
    .stock-out { background-color: #ffebee; color: #c62828; padding: 2px 8px; border-radius: 12px; font-weight: 600; }
    .price-tag { background-color: #e8f5e9; color: #2e7d32; padding: 2px 8px; border-radius: 12px; font-weight: 700; }
    .product-code { color: #6c757d; font-size: 0.85em; font-family: monospace; }
    .cart-category-badge { font-size: 0.75em; padding: 1px 6px; border-radius: 10px; background-color: #f8f9fa; color: #495057; }
    .gst-filter-section { display: flex; align-items: center; gap: 10px; margin-bottom: 10px; padding: 8px 12px; background: #f8f9fa; border-radius: 8px; border: 1px solid #e9ecef; }
    .gst-filter-section label { margin-bottom: 0; font-size: 12px; font-weight: 600; color: #495057; }
    .toggle-switch { position: relative; display: inline-block; width: 50px; height: 24px; }
    .toggle-switch input { opacity: 0; width: 0; height: 0; }
    .toggle-slider { position: absolute; cursor: pointer; top: 0; left: 0; right: 0; bottom: 0; background-color: #ccc; transition: 0.3s; border-radius: 24px; }
    .toggle-slider:before { position: absolute; content: ""; height: 18px; width: 18px; left: 3px; bottom: 3px; background-color: white; transition: 0.3s; border-radius: 50%; }
    input:checked + .toggle-slider { background-color: #28a745; }
    input:checked + .toggle-slider:before { transform: translateX(26px); }
    .filter-badge { font-size: 11px; padding: 4px 10px; border-radius: 20px; background: #e9ecef; color: #495057; cursor: pointer; transition: all 0.2s; }
    .filter-badge.active-gst { background: #28a745; color: white; }
    .filter-badge.active-non-gst { background: #dc3545; color: white; }
    .filter-badge.all { background: #17a2b8; color: white; }
    .transport-section { background: #f8f9fa; border-radius: 8px; padding: 12px; margin-top: 10px; border: 1px solid #e9ecef; display: none; }
    .transport-section.show { display: block; animation: fadeIn 0.3s ease; }
    .transport-row { display: flex; flex-wrap: wrap; gap: 12px; align-items: flex-end; }
    .transport-row > div { flex: 1; min-width: 150px; }
    .transport-row label { font-size: 11px; font-weight: 600; margin-bottom: 4px; color: #495057; display: block; }
    .transport-row input { width: 100%; padding: 6px 10px; border: 1px solid #ced4da; border-radius: 4px; font-size: 12px; }
    .transport-badge { background: #17a2b8; color: white; padding: 3px 10px; border-radius: 20px; font-size: 11px; display: inline-flex; align-items: center; gap: 5px; }
    .stock-type-badge { font-size: 0.7rem; padding: 2px 6px; border-radius: 10px; margin-left: 5px; font-weight: 600; }
    .old-stock-badge { background-color: #f39c12; color: white; }
    .new-stock-badge { background-color: #3498db; color: white; }
    .stock-warning { border-left: 4px solid #f39c12; background-color: #fff3cd; padding: 10px; margin-bottom: 15px; border-radius: 4px; }
    @keyframes fadeIn { from { opacity: 0; transform: translateY(-10px); } to { opacity: 1; transform: translateY(0); } }
    `;
document.head.appendChild(style);

// Configure SweetAlert2 defaults
const Toast = Swal.mixin({
  toast: true,
  position: "top-end",
  showConfirmButton: false,
  timer: 1000,
  timerProgressBar: true,
  didOpen: (toast) => {
    toast.addEventListener("mouseenter", Swal.stopTimer);
    toast.addEventListener("mouseleave", Swal.resumeTimer);
  },
});

// Toast functions
function showSuccessToast(message) {
  Toast.fire({ icon: "success", title: message });
}
function showErrorToast(message) {
  Toast.fire({ icon: "error", title: message });
}
function showWarningToast(message) {
  Toast.fire({ icon: "warning", title: message });
}
function showInfoToast(message) {
  Toast.fire({ icon: "info", title: message });
}

// ==================== CREDIT SETTINGS FUNCTIONS ====================
async function loadCreditSettings() {
  try {
    const response = await fetchWithTimeout(
      "api/settings.php?action=get_credit_settings",
      { timeout: 5000 },
    );
    if (response.ok) {
      const data = await response.json();
      if (data.success && data.credit_period_days) {
        CREDIT_DUE_DAYS = parseInt(data.credit_period_days);
        const dueDateInput = document.getElementById("credit-due-date");
        if (dueDateInput) {
          const defaultDueDate = new Date();
          defaultDueDate.setDate(defaultDueDate.getDate() + CREDIT_DUE_DAYS);
          dueDateInput.placeholder = `Due: ${defaultDueDate.toISOString().split("T")[0]}`;
        }
      }
    }
  } catch (error) {
    console.warn("Could not load credit settings:", error);
  }
}

function setupDueDaysListener() {
  const dueDaysSelect = document.getElementById("due_days");
  const dueDateInput = document.getElementById("credit-due-date");
  if (dueDaysSelect && dueDateInput) {
    dueDaysSelect.removeEventListener("change", handleDueDaysChange);
    dueDaysSelect.addEventListener("change", handleDueDaysChange);
    if (dueDaysSelect.value)
      updateDueDateFromDays(parseInt(dueDaysSelect.value), dueDateInput);
  }
}

function updateDueDateFromDays(days, dueDateInput) {
  if (!days || !dueDateInput) return;
  const today = new Date();
  const dueDate = new Date();
  dueDate.setDate(today.getDate() + days);
  const formattedDate = dueDate.toISOString().split("T")[0];
  dueDateInput.value = formattedDate;
  if (typeof CREDIT_DUE_DATE !== "undefined")
    window.CREDIT_DUE_DATE = formattedDate;
}

// ==================== GST FILTER FUNCTIONS ====================
function initGstFilter() {
  const toggle = document.getElementById("gstFilterToggle");
  const filterAllBadge = document.getElementById("filterAllBadge");
  const filterGstBadge = document.getElementById("filterGstBadge");
  const filterNonGstBadge = document.getElementById("filterNonGstBadge");
  const filterStatusText = document.getElementById("filterStatusText");

function updateFilterBadges(filter) {
    filterAllBadge.classList.remove("all", "active-gst", "active-non-gst");
    filterGstBadge.classList.remove("all", "active-gst", "active-non-gst");
    filterNonGstBadge.classList.remove("all", "active-gst", "active-non-gst");
    filterAllBadge.classList.add("filter-badge");
    filterGstBadge.classList.add("filter-badge");
    filterNonGstBadge.classList.add("filter-badge");
    switch (filter) {
      case "all":
        filterAllBadge.classList.add("all");
        filterStatusText.innerHTML = "All Products";
        break;
      case "gst":
        filterGstBadge.classList.add("active-gst");
        filterStatusText.innerHTML =
          'GST Products <i class="fas fa-file-invoice-dollar ms-1"></i>';
        break;
      case "non-gst":
        filterNonGstBadge.classList.add("active-non-gst");
        filterStatusText.innerHTML =
          'Non-GST Products <i class="fas fa-receipt ms-1"></i>';
        break;
    }
  }

toggle.addEventListener("change", function () {
    CURRENT_PRODUCT_FILTER = this.checked ? "gst" : "all";
    updateFilterBadges(CURRENT_PRODUCT_FILTER);
    const searchTerm = document.getElementById("search-product").value;
    populateProductDropdownFromSearch(searchTerm);
  });

filterAllBadge.addEventListener("click", function () {
    toggle.checked = false;
    CURRENT_PRODUCT_FILTER = "all";
    updateFilterBadges("all");
    const searchTerm = document.getElementById("search-product").value;
    populateProductDropdownFromSearch(searchTerm);
  });
  filterGstBadge.addEventListener("click", function () {
    toggle.checked = true;
    CURRENT_PRODUCT_FILTER = "gst";
    updateFilterBadges("gst");
    const searchTerm = document.getElementById("search-product").value;
    populateProductDropdownFromSearch(searchTerm);
  });
  filterNonGstBadge.addEventListener("click", function () {
    toggle.checked = false;
    CURRENT_PRODUCT_FILTER = "non-gst";
    updateFilterBadges("non-gst");
    const searchTerm = document.getElementById("search-product").value;
    populateProductDropdownFromSearch(searchTerm);
  });
}

function filterProductsByGstStatus(products) {
  if (CURRENT_PRODUCT_FILTER === "all") return products;
  return products.filter((product) => {
    const hasHsn = product.hsn_code && product.hsn_code.trim().length > 0;
    if (CURRENT_PRODUCT_FILTER === "gst") return hasHsn;
    if (CURRENT_PRODUCT_FILTER === "non-gst") return !hasHsn;
    return true;
  });
}

// ==================== TRANSPORT FUNCTIONS ====================
function initTransportSection() {
  const toggleBtn = document.getElementById("btnToggleTransport");
  const transportSection = document.getElementById("transportSection");
  const saveTransportBtn = document.getElementById("btnSaveTransport");
  const transportType = document.getElementById("transportType");
  const transportCharge = document.getElementById("transportCharge");

if (toggleBtn)
    toggleBtn.addEventListener("click", function () {
      transportSection.classList.toggle("show");
    });
  if (saveTransportBtn)
    saveTransportBtn.addEventListener("click", function () {
      TRANSPORT_DETAILS = {
        type: transportType.value.trim(),
        charge: parseFloat(transportCharge.value) || 0,
      };
      saveTransportDetailsToSession();
      updateTransportDisplay();
      if (typeof showToast === "function")
        showToast("Transport details saved", "success");
      updateBillingSummary();
      transportSection.classList.remove("show");
    });
  loadTransportDetailsFromSession();
  updateTransportDisplay();
}

function clearTransportDetails() {
  TRANSPORT_DETAILS = { type: "", charge: 0 };
  document.getElementById("transportType").value = "";
  document.getElementById("transportCharge").value = "0";
  saveTransportDetailsToSession();
  updateTransportDisplay();
  updateBillingSummary();
  if (typeof showToast === "function")
    showToast("Transport details cleared", "info");
}

// ==================== INITIALIZE APP ====================
async function initializeApp() {
  console.log("POS System: Initializing...");
  try {
    if (typeof $ === "undefined") throw new Error("jQuery not loaded");
    if (typeof bootstrap === "undefined")
      throw new Error("Bootstrap not loaded");
    const today = new Date().toISOString().split("T")[0];
    document.getElementById("date").value = today;
    const quotationDate = new Date();
    quotationDate.setDate(quotationDate.getDate() + 15);
    document.getElementById("quotationValidUntil").value = quotationDate
      .toISOString()
      .split("T")[0];
    try {
      $("#search-product").select2({
        placeholder: "Search product...",
        allowClear: true,
        width: "100%",
      });
      $("#customer-contact").select2({
        placeholder: "Select or type phone",
        tags: true,
        allowClear: true,
        width: "100%",
      });
      $("#referral").select2({
        placeholder: "Select referral...",
        allowClear: true,
        width: "100%",
      });
    } catch (select2Error) {
      console.warn("Select2 initialization warning:", select2Error);
    }
    generateInvoiceNumber();
    IS_INITIALIZED = true;
    console.log("POS System: Application initialized successfully");
  } catch (error) {
    console.error("POS System: Application initialization error:", error);
    showToast(
      `Initialization error: ${error.message}. Some features may not work.`,
      "danger",
    );
  }
}

async function loadInitialData() {
  console.log("POS System: Loading initial data...");
  if (!IS_INITIALIZED) {
    showToast("System not initialized properly. Please refresh.", "danger");
    return;
  }
  try {
    await loadProducts();
    populateProductDropdownFromSearch();
    setTimeout(() => {
      loadCustomers().catch(() => console.warn("Customers load failed"));
      loadReferrals().catch(() => console.warn("Referrals load failed"));
      loadLoyaltySettings().catch(() =>
        console.warn("Loyalty settings load failed"),
      );
    }, 1000);
    console.log(
      `POS System: Ready with ${PRODUCTS.length} products loaded locally`,
    );
    if (!IS_CART_LOADED)
      showToast("System ready! Products loaded locally.", "success");
  } catch (error) {
    console.error("POS System: Initial data loading failed:", error);
    showToast("Could not load products. Please check connection.", "danger");
  }
}

// ==================== SESSION/CART STORAGE ====================
function saveCartToSession() {
  try {
    sessionStorage.setItem("pos_cart", JSON.stringify(CART));
    console.log("Cart saved to session:", CART.length, "items");
  } catch (error) {
    console.error("Error saving cart to session:", error);
  }
}
function clearCartFromSession() {
  try {
    sessionStorage.removeItem("pos_cart");
    console.log("Cart cleared from session");
  } catch (error) {
    console.error("Error clearing cart from session:", error);
  }
}

// ==================== DATA LOADING FUNCTIONS ====================
async function loadProducts() {
  console.log("POS System: Loading products...");
  try {
    const response = await fetchWithTimeout("api/products.php?action=list", {
      timeout: 8000,
      retries: 2,
      credentials: "include",
    });
    if (!response.ok)
      throw new Error(`HTTP ${response.status}: ${response.statusText}`);
    const data = await response.json();
    if (!data.success) throw new Error(data.message || "Unknown server error");
    PRODUCTS = data.products || [];
    BARCODE_MAP = data.barcode_map || {};
    PRODUCTS.forEach((product) => {
      let primaryStock = 0;
      if (product.shop_stock_primary !== undefined)
        primaryStock = parseFloat(product.shop_stock_primary) || 0;
      else if (product.shop_stock !== undefined) {
        primaryStock = parseFloat(product.shop_stock) || 0;
        product.shop_stock_primary = primaryStock;
      } else if (product.stock !== undefined) {
        primaryStock = parseFloat(product.stock) || 0;
        product.shop_stock_primary = primaryStock;
      }
      product.shop_stock_primary = primaryStock;
      if (product.secondary_unit && product.sec_unit_conversion)
        product.shop_stock_secondary =
          primaryStock * (parseFloat(product.sec_unit_conversion) || 1);
      else product.shop_stock_secondary = 0;
      if (product.shop_stock === undefined) product.shop_stock = primaryStock;
    });
    console.log(
      `POS System: Loaded ${PRODUCTS.length} products, ${Object.keys(BARCODE_MAP).length} barcodes`,
    );
    return true;
  } catch (error) {
    console.error("POS System: Product loading failed:", error);
    throw error;
  }
}

async function checkAndGenerateInvoiceNumber() {
  try {
    const response = await fetchWithTimeout(
      "api/invoices.php?action=get_next_invoice_number",
      {
        method: "POST",
        headers: {
          "Content-Type": "application/json",
          Accept: "application/json",
        },
        body: JSON.stringify({
          prefix: GST_TYPE === "gst" ? "INV" : "INVNG",
          year_month: new Date().toISOString().substring(0, 7).replace("-", ""),
          invoice_type: GST_TYPE,
        }),
        timeout: 5000,
      },
    );
    if (!response.ok)
      throw new Error(`HTTP ${response.status}: ${response.statusText}`);
    const data = await response.json();
    if (data.success) {
      document.getElementById("invoice-number").value = data.invoice_number;
      return data.invoice_number;
    } else return null;
  } catch (error) {
    console.warn("Error generating invoice number:", error);
    return null;
  }
}

async function fetchWithTimeout(url, options = {}) {
  const { timeout = 10000, retries = 1, ...fetchOptions } = options;
  fetchOptions.credentials = fetchOptions.credentials || "include";
  for (let attempt = 1; attempt <= retries + 1; attempt++) {
    try {
      const controller = new AbortController();
      const timeoutId = setTimeout(() => controller.abort(), timeout);
      const response = await fetch(url, {
        ...fetchOptions,
        signal: controller.signal,
      });
      clearTimeout(timeoutId);
      return response;
    } catch (error) {
      if (attempt > retries) throw error;
      console.warn(
        `POS System: Fetch attempt ${attempt} failed, retrying...`,
        error,
      );
      await new Promise((resolve) => setTimeout(resolve, 1000 * attempt));
    }
  }
}

function searchProductsLocally(searchTerm) {
  if (!searchTerm || searchTerm.length < 2)
    return filterProductsByGstStatus(PRODUCTS);
  const term = searchTerm.toLowerCase().trim();
  let filtered = PRODUCTS.filter(
    (product) =>
      (product.product_name &&
        product.product_name.toLowerCase().includes(term)) ||
      (product.product_code &&
        product.product_code.toLowerCase().includes(term)) ||
      (product.barcode && product.barcode.toLowerCase().includes(term)),
  );
  return filterProductsByGstStatus(filtered).slice(0, 20);
}

function getCategoryColor(categoryName) {
  const colorMap = {
    Electronics: "#0d47a1",
    Fashion: "#ad1457",
    Groceries: "#2e7d32",
    Furniture: "#bf360c",
    Books: "#4a148c",
    Sports: "#b45309",
    Toys: "#7b1fa2",
    Beauty: "#c2185b",
    Automotive: "#37474f",
    Health: "#00695c",
    default: "#455a64",
  };
  return colorMap[categoryName] || colorMap["default"];
}

function getSubcategoryColor(subcategoryName) {
  const colorMap = {
    Mobile: "#1565c0",
    Laptop: "#283593",
    Men: "#6d4c41",
    Women: "#c2185b",
    Kids: "#f57c00",
    Vegetables: "#2e7d32",
    Fruits: "#ef6c00",
    Dairy: "#0d47a1",
    default: "#546e7a",
  };
  return colorMap[subcategoryName] || colorMap["default"];
}

function getStockColor(stock) {
  if (stock <= 0) return "#c62828";
  if (stock < 10) return "#ef6c00";
  if (stock < 50) return "#2e7d32";
  return "#1b5e20";
}

function getStockBackgroundColor(stock) {
  if (stock <= 0) return "#ffebee";
  if (stock < 10) return "#fff3e0";
  if (stock < 50) return "#e8f5e9";
  return "#c8e6c9";
}

// ==================== EVENT LISTENERS SETUP ====================
function setupEventListeners() {
  console.log("POS System: Setting up event listeners...");
  try {
    $("#search-product").on("change.select2", function (e) {
      if (window.isHandlingProductChange) return;
      window.isHandlingProductChange = true;
      try {
        handleProductSelection.call(this);
      } finally {
        setTimeout(() => {
          window.isHandlingProductChange = false;
        }, 100);
      }
    });
    document
      .getElementById("search-product")
      .addEventListener("input", function (e) {
        const searchTerm = e.target.value;
        if (searchTerm.length >= 2)
          populateProductDropdownFromSearch(searchTerm);
        else populateProductDropdownFromSearch();
      });
    document
      .getElementById("barcode-input")
      .addEventListener("keydown", handleBarcodeScan);
    document
      .getElementById("product-add-button")
      .addEventListener("click", addProductToCart);
    document
      .getElementById("unit-convert")
      .addEventListener("click", toggleUnitConversion);
    $("#customer-contact").on("change", handleCustomerSelection);
    document
      .getElementById("price-type")
      .addEventListener("change", function () {
        GLOBAL_PRICE_TYPE = this.value;
        if (CURRENT_PRODUCT) updateProductForm(CURRENT_PRODUCT);
        updateCartPriceTypes();
        populateProductDropdownFromSearch();
      });
    document
      .getElementById("invoice-type")
      .addEventListener("change", async function () {
        GST_TYPE = this.value;
        await checkAndGenerateInvoiceNumber();
        updateBillingSummary();
      });
    $("#referral").on("change", function () {
      SELECTED_REFERRAL_ID = this.value ? parseInt(this.value) : null;
      updateBillingSummary();
    });
    document
      .getElementById("discount")
      .addEventListener("input", updateProductPriceDisplay);
    document
      .getElementById("discount-type")
      .addEventListener("change", updateProductPriceDisplay);
    document
      .getElementById("btnHoldList")
      .addEventListener("click", loadHoldList);
    document.getElementById("btnHold").addEventListener("click", holdInvoice);
    document
      .getElementById("btnQuotation")
      .addEventListener("click", showQuotationModal);
    document
      .getElementById("btnQuotationList")
      .addEventListener("click", loadQuotationList);
    document
      .getElementById("btnClearCart")
      .addEventListener("click", clearCart);
    document
      .getElementById("btnShowPointsDetails")
      .addEventListener("click", showPointsModal);
    document
      .getElementById("btnGenerateBill")
      .addEventListener("click", generateBill);
    document
      .getElementById("btnPrintBill")
      .addEventListener("click", printBill);
    document
      .getElementById("btnAutoFillRemaining")
      .addEventListener("click", autoFillRemainingAmount);
    document
      .querySelectorAll('input[name="payment-method"]')
      .forEach((checkbox) => {
        checkbox.addEventListener("change", handlePaymentMethodCheckbox);
      });
    document
      .getElementById("cash-amount")
      .addEventListener("input", updatePaymentSummary);
    document
      .getElementById("upi-amount")
      .addEventListener("input", updatePaymentSummary);
    document
      .getElementById("bank-amount")
      .addEventListener("input", updatePaymentSummary);
    document
      .getElementById("cheque-amount")
      .addEventListener("input", updatePaymentSummary);
    document
      .getElementById("credit-amount")
      .addEventListener("input", updatePaymentSummary);
    document
      .getElementById("additional-dis")
      .addEventListener("input", updateBillingSummary);
    document
      .getElementById("overall-discount-type")
      .addEventListener("change", updateBillingSummary);
    document
      .getElementById("selling-price")
      .addEventListener("input", function () {
        const discountInput = document.getElementById("discount");
        if (parseFloat(discountInput.value) === 0) updateProductPriceDisplay();
      });
    document.getElementById("qty-input").addEventListener("input", function () {
      if (CURRENT_PRODUCT && CURRENT_UNIT_IS_SECONDARY)
        updateSecondaryUnitPrice();
    });
    document
      .getElementById("confirmHold")
      .addEventListener("click", saveHoldInvoice);
    document
      .getElementById("saveQuotationBtn")
      .addEventListener("click", saveQuotation);
    document
      .getElementById("btnUseMaxPoints")
      .addEventListener("click", useMaxPoints);
    document
      .getElementById("btnApplyPointsDiscount")
      .addEventListener("click", applyPointsDiscount);
    document
      .getElementById("confirmActionBtn")
      .addEventListener("click", executePendingConfirmation);
    document
      .getElementById("pointsToRedeem")
      .addEventListener("input", updatePointsDiscountPreview);
    document
      .getElementById("search-product")
      .addEventListener("keydown", function (e) {
        if (e.key === "Enter" && this.value) {
          e.preventDefault();
          const productId = this.value;
          if (productId) {
            const product = findProductById(productId);
            if (product) {
              updateProductForm(product);
              setTimeout(() => {
                addProductToCart();
              }, 100);
            }
          }
        }
      });
    document.addEventListener("keydown", function (e) {
      if (e.ctrlKey && e.key === "Enter") {
        e.preventDefault();
        if (CURRENT_PRODUCT) addProductToCart();
      }
      if (e.key === "F1") {
        e.preventDefault();
        showInfoModal(
          "Keyboard Shortcuts",
          "• Enter: Add product to cart<br>• Ctrl+Enter: Add product quickly<br>• Esc: Go to invoices page<br>• F1: Show this help",
        );
      }
      if (e.key === "Escape") {
        e.preventDefault();
        window.location.href = "invoices.php";
      }
    });
    window.addEventListener("beforeunload", function (e) {
      if (CART.length > 0) {
        e.preventDefault();
        e.returnValue =
          "You have unsaved items in your cart. Are you sure you want to leave?";
        return e.returnValue;
      }
    });
    console.log("POS System: Event listeners setup complete");
  } catch (error) {
    console.error("POS System: Error setting up event listeners:", error);
  }
}

// ==================== PRODUCT HANDLING ====================
function handleProductSelection() {
  try {
    const productId = this.value;
    if (!productId) {
      clearProductSelection();
      return;
    }
    const product = PRODUCTS.find((p) => p.id == productId);
    if (product) updateProductForm(product);
    else {
      showToast(
        "Selected product not found. Please refresh the product list.",
        "warning",
      );
      clearProductSelection();
    }
  } catch (error) {
    console.error("POS System: Error handling product selection:", error);
    showToast("Error selecting product. Please try again.", "danger");
  }
}

function findProductById(id) {
  if (!id || isNaN(id)) return null;
  const product = PRODUCTS.find((p) => p.id == id);
  if (!product) return null;
  let shopStockPrimary = 0;
  if (product.shop_stock_primary !== undefined)
    shopStockPrimary = parseFloat(product.shop_stock_primary) || 0;
  else if (product.shop_stock !== undefined) {
    shopStockPrimary = parseFloat(product.shop_stock) || 0;
    product.shop_stock_primary = shopStockPrimary;
  }
  product.shop_stock_primary = shopStockPrimary;
  if (product.secondary_unit && product.sec_unit_conversion)
    product.shop_stock_secondary =
      shopStockPrimary * (parseFloat(product.sec_unit_conversion) || 1);
  else product.shop_stock_secondary = 0;
  return product;
}

function findProductByBarcode(code) {
  if (!code || typeof code !== "string") return null;
  const cleanCode = String(code).trim();
  const prodId = BARCODE_MAP[cleanCode];
  if (prodId) {
    const product = findProductById(prodId);
    if (product) return product;
  }
  return PRODUCTS.find(
    (p) =>
      (p.barcode && p.barcode === cleanCode) ||
      (p.product_code && p.product_code === cleanCode),
  );
}

// ==================== ADD PRODUCT TO CART ====================
function addProductToCart() {
  try {
    if (!CURRENT_PRODUCT) {
      showToast("Please select a product first", "warning");
      return;
    }
    const product = CURRENT_PRODUCT;
    const qtyInput = document.getElementById("qty-input");
    let qty = parseFloat(qtyInput.value) || 1;
    if (qty <= 0) {
      showToast("Please enter a valid quantity (greater than 0)", "warning");
      qtyInput.focus();
      qtyInput.select();
      return;
    }
    if (isNaN(qty)) {
      showToast("Invalid quantity entered. Please enter a number.", "danger");
      qtyInput.value = "1";
      qtyInput.focus();
      qtyInput.select();
      return;
    }
    const shopStockPrimary = parseFloat(product.shop_stock_primary) || 0;
    const oldQty = parseFloat(product.shop_old_qty) || 0;
    const newStockQty = Math.max(0, shopStockPrimary - oldQty);
    const secUnitConversion = parseFloat(product.sec_unit_conversion) || 1;
    let qtyInPrimary = qty;
    if (CURRENT_UNIT_IS_SECONDARY && secUnitConversion > 0)
      qtyInPrimary = qty / secUnitConversion;
    if (qtyInPrimary > shopStockPrimary) {
      const availableSecondary = Math.floor(
        shopStockPrimary * secUnitConversion,
      );
      const unitText = CURRENT_UNIT_IS_SECONDARY
        ? `${availableSecondary} ${product.secondary_unit}`
        : `${shopStockPrimary} ${product.unit_of_measure}`;
      showToast(`Insufficient stock! Available: ${unitText}`, "warning");
      if (CURRENT_UNIT_IS_SECONDARY)
        qtyInput.value = availableSecondary.toString();
      else qtyInput.value = shopStockPrimary.toString();
      qtyInput.focus();
      qtyInput.select();
      return;
    }
    let totalOldStockInCart = 0;
    CART.forEach((item) => {
      if (item.product_id === product.id && item.is_from_old_stock)
        totalOldStockInCart += item.quantity_in_primary;
    });
    const remainingOldStock = oldQty - totalOldStockInCart;
    if (remainingOldStock > 0 && qtyInPrimary > remainingOldStock) {
      showToast(
        `Cannot sell new stock while old stock remains. Remaining old stock: ${Math.floor(remainingOldStock * 100) / 100} ${product.unit_of_measure}. Please reduce quantity to ${Math.floor(remainingOldStock * 100) / 100} or less to sell only old stock.`,
        "warning",
      );
      qtyInput.value = CURRENT_UNIT_IS_SECONDARY
        ? (remainingOldStock * secUnitConversion).toFixed(2)
        : remainingOldStock.toFixed(2);
      qtyInput.focus();
      qtyInput.select();
      return;
    }
    const isFromOldStock =
      remainingOldStock > 0 && qtyInPrimary <= remainingOldStock;
    const mrp = parseFloat(document.getElementById("mrp").value) || 0;
    let sellingPrice =
      parseFloat(document.getElementById("selling-price").value) || 0;
    const discount = parseFloat(document.getElementById("discount").value) || 0;
    const discountType = document.getElementById("discount-type").value;
    const unit = document.getElementById("qty-unit").textContent;
    const isSecondaryUnit = CURRENT_UNIT_IS_SECONDARY;
    if (isSecondaryUnit) sellingPrice = parseFloat(sellingPrice.toFixed(2));
    else sellingPrice = Math.round(sellingPrice);
    let finalPrice = sellingPrice;
    let discountValue = 0;
    if (discount > 0) {
      if (discountType === "percentage")
        discountValue = sellingPrice * (discount / 100);
      else discountValue = discount;
      finalPrice = sellingPrice - discountValue;
    }
    if (finalPrice < 0) {
      showToast("Discount cannot make price negative", "warning");
      return;
    }
    if (isSecondaryUnit) finalPrice = parseFloat(finalPrice.toFixed(2));
    else finalPrice = Math.round(finalPrice);
    const cartItemId = `${product.id}-${unit}-${finalPrice.toFixed(2)}-${discountType}-${isSecondaryUnit}-${isFromOldStock ? "old" : "new"}`;
    const productName = product.product_name;
    const categoryName = product.category_name || "";
    const subcategoryName = product.subcategory_name || "";
    let displayName = productName;
    if (categoryName) {
      displayName += ` (${categoryName}`;
      if (subcategoryName) displayName += ` - ${subcategoryName}`;
      displayName += ")";
    }
    if (isFromOldStock)
      displayName +=
        ' <span class="badge bg-warning text-dark">OLD STOCK</span>';
    else displayName += ' <span class="badge bg-info">NEW STOCK</span>';
    const cartItem = {
      id: cartItemId,
      product_id: product.id,
      name: displayName,
      code: product.product_code || product.id.toString(),
      mrp: mrp,
      base_price: sellingPrice,
      price: finalPrice,
      price_type: GLOBAL_PRICE_TYPE,
      quantity: qty,
      unit: unit,
      is_secondary_unit: isSecondaryUnit,
      is_from_old_stock: isFromOldStock,
      discount_value: discount,
      discount_type: discountType,
      discount_amount: discountValue,
      shop_stock: shopStockPrimary,
      old_qty: oldQty,
      new_stock_qty: newStockQty,
      hsn_code: product.hsn_code || "",
      cgst_rate: parseFloat(product.cgst_rate) || 0,
      sgst_rate: parseFloat(product.sgst_rate) || 0,
      igst_rate: parseFloat(product.igst_rate) || 0,
      referral_enabled: product.referral_enabled || 0,
      referral_type: product.referral_type || "percentage",
      referral_value: parseFloat(product.referral_value) || 0,
      referral_commission: 0,
      secondary_unit: product.secondary_unit || "",
      sec_unit_conversion: secUnitConversion,
      stock_price: parseFloat(product.stock_price) || 0,
      retail_price: parseFloat(product.retail_price) || 0,
      wholesale_price: parseFloat(product.wholesale_price) || 0,
      unit_of_measure: product.unit_of_measure || "PCS",
      quantity_in_primary: qtyInPrimary,
      added_at: new Date().toISOString(),
      total: finalPrice * qty,
      original_product_name: product.product_name,
      category_name: categoryName,
      subcategory_name: subcategoryName,
      use_batch_tracking: product.use_batch_tracking || 0,
    };
    if (cartItem.referral_enabled == 1 && SELECTED_REFERRAL_ID) {
      const referralType = cartItem.referral_type || "percentage";
      const referralValue = cartItem.referral_value || 0;
      if (referralType === "percentage")
        cartItem.referral_commission = cartItem.total * (referralValue / 100);
      else cartItem.referral_commission = referralValue * cartItem.quantity;
    }
    const existingIndex = CART.findIndex(
      (item) =>
        item.product_id === cartItem.product_id &&
        item.unit === cartItem.unit &&
        Math.abs(item.price - cartItem.price) < 0.01 &&
        item.discount_type === cartItem.discount_type &&
        item.is_secondary_unit === cartItem.is_secondary_unit &&
        item.is_from_old_stock === cartItem.is_from_old_stock,
    );
    if (existingIndex >= 0) {
      const newQtyInPrimary =
        CART[existingIndex].quantity_in_primary + qtyInPrimary;
      if (isFromOldStock) {
        let totalOldInCart = 0;
        CART.forEach((item) => {
          if (item.product_id === product.id && item.is_from_old_stock)
            totalOldInCart += item.quantity_in_primary;
        });
        totalOldInCart += qtyInPrimary;
        if (totalOldInCart > oldQty) {
          const availableOld = oldQty - (totalOldInCart - qtyInPrimary);
          showToast(
            `Cannot add more old stock. Remaining old stock: ${Math.floor(availableOld * 100) / 100} ${product.unit_of_measure}`,
            "warning",
          );
          return;
        }
      } else {
        let totalNewInCart = 0;
        CART.forEach((item) => {
          if (item.product_id === product.id && !item.is_from_old_stock)
            totalNewInCart += item.quantity_in_primary;
        });
        totalNewInCart += qtyInPrimary;
        if (totalNewInCart > newStockQty) {
          const availableNew = newStockQty - (totalNewInCart - qtyInPrimary);
          showToast(
            `Cannot add more new stock. Remaining new stock: ${Math.floor(availableNew * 100) / 100} ${product.unit_of_measure}`,
            "warning",
          );
          return;
        }
      }
      CART[existingIndex].quantity += qty;
      CART[existingIndex].quantity_in_primary = newQtyInPrimary;
      CART[existingIndex].total =
        CART[existingIndex].price * CART[existingIndex].quantity;
      showToast(
        `${product.product_name} quantity updated to ${CART[existingIndex].quantity} ${unit} (${isFromOldStock ? "Old Stock" : "New Stock"})`,
        "info",
      );
    } else {
      CART.push(cartItem);
      showToast(`${displayName} added to cart`, "success");
    }
    renderCart();
    saveCartToSession();
    clearProductFormSilently();
    updateBillingSummary();
    updateButtonStates();
  } catch (error) {
    console.error("Error adding product to cart:", error);
    showToast("Error adding product to cart. Please try again.", "danger");
  }
}

// ==================== CART RENDERING ====================
function renderCart() {
  try {
    const tbody = document.getElementById("cartBody");
    const emptyRow = document.getElementById("emptyCartRow");
    if (!tbody) {
      console.error("Cart table body not found");
      return;
    }
    tbody.innerHTML = "";
    if (CART.length === 0) {
      if (!emptyRow) {
        const newEmptyRow = document.createElement("tr");
        newEmptyRow.id = "emptyCartRow";
        newEmptyRow.innerHTML =
          '<td colspan="10" class="cart-empty">No items in cart</td>';
        tbody.appendChild(newEmptyRow);
      } else tbody.appendChild(emptyRow);
      return;
    }
    if (emptyRow) emptyRow.style.display = "none";
    CART.forEach((item, index) => {
      try {
        const row = document.createElement("tr");
        row.id = `cart-row-${index}`;
        let primaryUnitDisplay = "";
        if (item.is_secondary_unit && item.sec_unit_conversion > 0) {
          const primaryQty = item.quantity / item.sec_unit_conversion;
          primaryUnitDisplay = `${primaryQty.toFixed(2)} ${item.unit_of_measure}`;
        }
        let quantityDisplay = item.quantity;
        if (item.is_secondary_unit)
          quantityDisplay = parseFloat(item.quantity.toFixed(2));
        const itemTotal = item.price * item.quantity;
        let stockTypeBadge = "";
        if (item.is_from_old_stock)
          stockTypeBadge =
            '<span class="badge bg-warning text-dark ms-1">OLD</span>';
        else stockTypeBadge = '<span class="badge bg-info ms-1">NEW</span>';
        row.innerHTML = `<td>${index + 1}</td><td class="text-start"><strong>${escapeHtml(item.name)} ${stockTypeBadge}</strong><br><small class="text-muted">${escapeHtml(item.code)}</small>${primaryUnitDisplay ? `<br><small class="text-muted">${primaryUnitDisplay}</small>` : ""}</td><td><div class="d-flex align-items-center gap-1"><button class="btn btn-sm btn-outline-secondary py-0 px-2" onclick="cartItemDecrement(${index})"><i class="fas fa-minus"></i></button><input type="number" class="form-control form-control-sm text-center cart-qty-input" value="${quantityDisplay}" data-index="${index}" min="${item.is_secondary_unit ? 0.01 : 1}" step="${item.is_secondary_unit ? 0.01 : 1}" style="width: 80px;"><button class="btn btn-sm btn-outline-secondary py-0 px-2" onclick="cartItemIncrement(${index})"><i class="fas fa-plus"></i></button></div></td><td>${escapeHtml(item.unit)}</td><td><select class="form-select form-select-sm cart-price-type-select" data-index="${index}"><option value="retail" ${item.price_type === "retail" ? "selected" : ""}>Retail</option><option value="wholesale" ${item.price_type === "wholesale" ? "selected" : ""}>Wholesale</option></select></td><td><div class="d-flex align-items-center gap-1"><input type="number" class="form-control form-control-sm text-center cart-discount-value" value="${item.discount_value || 0}" data-index="${index}" min="0" ${item.discount_type === "percentage" ? 'max="100"' : ""} step="0.01" style="width: 70px;"><select class="form-select form-select-sm cart-discount-type" data-index="${index}" style="width: 70px;"><option value="percentage" ${item.discount_type === "percentage" ? "selected" : ""}>%</option><option value="fixed" ${item.discount_type === "fixed" ? "selected" : ""}>₹</option></select></div></td><td class="text-end">₹${item.price.toFixed(item.is_secondary_unit ? 2 : 0)}<br><small class="text-muted">Per ${item.unit}</small></td><td class="text-end">${((item.cgst_rate || 0) + (item.sgst_rate || 0) + (item.igst_rate || 0)).toFixed(2)}%</td><td class="text-end">₹${item.is_secondary_unit ? itemTotal.toFixed(2) : Math.round(itemTotal)}</td><td><div class="cart-actions"><button class="btn btn-sm btn-outline-danger" onclick="removeCartItem(${index})" title="Remove item"><i class="fas fa-trash"></i></button></div></td>`;
        tbody.appendChild(row);
      } catch (rowError) {
        console.warn("Error rendering cart row:", rowError);
      }
    });
    setTimeout(() => {
      document.querySelectorAll(".cart-qty-input").forEach((input) => {
        input.addEventListener(
          "input",
          debounce(function () {
            const index = parseInt(this.dataset.index);
            const value =
              parseFloat(this.value) ||
              (CART[index].is_secondary_unit ? 0.01 : 1);
            liveUpdateCartItemQuantity(index, value);
          }, 300),
        );
        input.addEventListener("change", function () {
          const index = parseInt(this.dataset.index);
          const value =
            parseFloat(this.value) ||
            (CART[index].is_secondary_unit ? 0.01 : 1);
          updateCartItemQuantity(index, value);
        });
      });
      document.querySelectorAll(".cart-price-type-select").forEach((select) => {
        select.addEventListener("change", function () {
          const index = parseInt(this.dataset.index);
          updateCartItemPriceType(index, this.value);
        });
      });
      document.querySelectorAll(".cart-discount-value").forEach((input) => {
        input.addEventListener(
          "input",
          debounce(function () {
            const index = parseInt(this.dataset.index);
            const value = parseFloat(this.value) || 0;
            liveUpdateCartItemDiscount(index, value);
          }, 300),
        );
        input.addEventListener("change", function () {
          const index = parseInt(this.dataset.index);
          const value = parseFloat(this.value) || 0;
          updateCartItemDiscount(index, value);
        });
      });
      document.querySelectorAll(".cart-discount-type").forEach((select) => {
        select.addEventListener("change", function () {
          const index = parseInt(this.dataset.index);
          updateCartItemDiscountType(index, this.value);
        });
      });
    }, 10);
  } catch (error) {
    console.error("Error rendering cart:", error);
    showToast("Error displaying cart. Please refresh page.", "danger");
  }
}

function cartItemDecrement(index) {
  const item = CART[index];
  if (!item) return;
  const newQty = Math.max(item.is_secondary_unit ? 1 : 1, item.quantity - 1);
  updateCartItemQuantity(index, newQty);
}
function cartItemIncrement(index) {
  const item = CART[index];
  if (!item) return;
  const newQty = item.quantity + 1;
  updateCartItemQuantity(index, newQty);
}

// ==================== CALCULATION FUNCTIONS ====================
function calculateItemGST(item) {
  try {
    if (
      GST_TYPE === "non-gst" ||
      item.cgst_rate + item.sgst_rate + item.igst_rate <= 0
    )
      return {
        taxable: item.price * item.quantity,
        cgst: 0,
        sgst: 0,
        igst: 0,
        total: 0,
      };
    const itemTotal = item.price * item.quantity;
    const totalGSTRate = item.cgst_rate + item.sgst_rate + item.igst_rate;
    const taxableValue = itemTotal / (1 + totalGSTRate / 100);
    const gstAmount = itemTotal - taxableValue;
    let cgst = 0,
      sgst = 0,
      igst = 0;
    if (totalGSTRate > 0) {
      cgst = gstAmount * (item.cgst_rate / totalGSTRate);
      sgst = gstAmount * (item.sgst_rate / totalGSTRate);
      igst = gstAmount * (item.igst_rate / totalGSTRate);
    }
    return {
      taxable: taxableValue,
      cgst: cgst,
      sgst: sgst,
      igst: igst,
      total: gstAmount,
    };
  } catch (error) {
    console.error("Error calculating item GST:", error);
    return { taxable: 0, cgst: 0, sgst: 0, igst: 0, total: 0 };
  }
}

// ==================== PAYMENT FUNCTIONS ====================
function handlePaymentMethodCheckbox(event) {
  try {
    const method = event.target.value;
    const isChecked = event.target.checked;
    const cardId = `${method}-input-card`;
    const cardElement = document.getElementById(cardId);
    if (isChecked) {
      ACTIVE_PAYMENT_METHODS.add(method);
      if (cardElement) {
        cardElement.classList.add("active");
        if (method === "credit")
          setTimeout(() => {
            updateCreditPaymentCard();
          }, 10);
        setTimeout(() => {
          const amountInput = cardElement.querySelector('input[type="number"]');
          if (amountInput) {
            amountInput.focus();
            amountInput.select();
          }
        }, 10);
      }
    } else {
      ACTIVE_PAYMENT_METHODS.delete(method);
      if (cardElement) {
        cardElement.classList.remove("active");
        const amountInput = cardElement.querySelector('input[type="number"]');
        if (amountInput) amountInput.value = "0";
        if (method === "credit") {
          const warning = document.querySelector(
            "#credit-input-card .credit-due-warning",
          );
          if (warning) warning.remove();
        }
      }
    }
    updatePaymentSummary();
  } catch (error) {
    console.error("Error handling payment method checkbox:", error);
    showToast("Error updating payment method. Please try again.", "danger");
  }
}

// ==================== LOYALTY POINTS FUNCTIONS ====================
function handleCustomerSelection() {
  try {
    const selectedOption = this.options[this.selectedIndex];
    if (selectedOption && selectedOption.value) {
      const customerName = selectedOption.dataset.name;
      if (customerName)
        document.getElementById("customer-name").value = customerName;
      const address = selectedOption.dataset.address;
      const gstin = selectedOption.dataset.gstin;
      const creditLimit = selectedOption.dataset.creditLimit;
      const outstanding = selectedOption.dataset.outstanding;
      if (address) document.getElementById("customer-address").value = address;
      if (gstin) document.getElementById("customer-gstin").value = gstin;
      if (creditLimit && creditLimit > 0)
        showCustomerCreditInfo(customerName, creditLimit, outstanding);
      const customerId = selectedOption.dataset.customerId;
      if (customerId) {
        CURRENT_CUSTOMER_ID = customerId;
        loadCustomerPoints(customerId);
      } else hideLoyaltyPoints();
    } else {
      hideCustomerCreditInfo();
      hideLoyaltyPoints();
    }
  } catch (error) {
    console.error("Error handling customer selection:", error);
    hideCustomerCreditInfo();
    hideLoyaltyPoints();
  }
}

async function loadCustomers() {
  console.log("POS System: Loading customers...");
  try {
    const response = await fetchWithTimeout("api/customers.php?action=list", {
      timeout: 5000,
    });
    if (!response.ok)
      throw new Error(`HTTP ${response.status}: ${response.statusText}`);
    const data = await response.json();
    if (data.success) {
      CUSTOMERS = data.customers || [];
      populateCustomerDropdown();
      console.log(`POS System: Loaded ${CUSTOMERS.length} customers`);
      return true;
    } else return false;
  } catch (error) {
    console.error("POS System: Customer loading failed:", error);
    throw new Error(`Cannot load customers: ${error.message}`);
  }
}

async function loadReferrals() {
  console.log("POS System: Loading referrals...");
  try {
    const response = await fetchWithTimeout("api/referrals.php?action=list", {
      timeout: 5000,
    });
    if (!response.ok) return false;
    const data = await response.json();
    if (data.success) {
      REFERRALS = data.referrals || [];
      populateReferralDropdown();
      console.log(`POS System: Loaded ${REFERRALS.length} referrals`);
      return true;
    }
    return false;
  } catch (error) {
    console.warn("POS System: Referral loading failed:", error);
    return false;
  }
}

async function loadLoyaltySettings() {
  console.log("POS System: Loading loyalty settings...");
  try {
    const response = await fetchWithTimeout("api/loyalty.php?action=settings", {
      timeout: 5000,
    });
    if (!response.ok) {
      LOYALTY_SETTINGS = getDefaultLoyaltySettings();
      return true;
    }
    const data = await response.json();
    if (data.success)
      LOYALTY_SETTINGS = data.settings || getDefaultLoyaltySettings();
    else LOYALTY_SETTINGS = getDefaultLoyaltySettings();
    return true;
  } catch (error) {
    console.warn("POS System: Loyalty settings loading failed:", error);
    LOYALTY_SETTINGS = getDefaultLoyaltySettings();
    return true;
  }
}

function getDefaultLoyaltySettings() {
  return {
    points_per_amount: 0.01,
    amount_per_point: 100.0,
    redeem_value_per_point: 1.0,
    min_points_to_redeem: 50,
    expiry_months: null,
    is_active: 1,
  };
}

async function loadCustomerPoints(customerId) {
  try {
    if (!customerId) {
      hideLoyaltyPoints();
      return;
    }
    const response = await fetchWithTimeout(
      `api/loyalty.php?action=customer_points&customer_id=${customerId}`,
      { timeout: 5000 },
    );
    if (!response.ok) throw new Error(`HTTP ${response.status}`);
    const data = await response.json();
    if (data.success) {
      CUSTOMER_POINTS = data.points || {
        available_points: 0,
        total_points_earned: 0,
        total_points_redeemed: 0,
      };
      showLoyaltyPoints();
      updateLoyaltyPointsDisplay();
      const applyBtn = document.getElementById("btnShowPointsDetails");
      if (
        CUSTOMER_POINTS.available_points >=
        LOYALTY_SETTINGS.min_points_to_redeem
      ) {
        applyBtn.disabled = false;
        applyBtn.title = "Apply loyalty points discount";
      } else {
        applyBtn.disabled = true;
        applyBtn.title = `Minimum ${LOYALTY_SETTINGS.min_points_to_redeem} points required`;
      }
    } else hideLoyaltyPoints();
  } catch (error) {
    console.warn("Error loading customer points:", error);
    hideLoyaltyPoints();
  }
}

// ==================== INVOICE FUNCTIONS ====================
function generateInvoiceNumber() {
  try {
    const prefix = GST_TYPE === "gst" ? "INV" : "INVNG";
    const now = new Date();
    const year = now.getFullYear();
    const month = (now.getMonth() + 1).toString().padStart(2, "0");
    const yearMonth = year.toString() + month;
    const tempNumber = `${prefix}${yearMonth}-9999`;
    const invoiceInput = document.getElementById("invoice-number");
    if (invoiceInput) invoiceInput.value = tempNumber;
    fetchLatestInvoiceNumber(prefix, yearMonth);
    return tempNumber;
  } catch (error) {
    console.error("POS System: Error generating invoice number:", error);
    return "INV-ERROR-" + Date.now();
  }
}

async function fetchLatestInvoiceNumber(prefix, yearMonth) {
  try {
    const response = await fetchWithTimeout(
      "api/invoices.php?action=get_next_invoice_number",
      {
        method: "POST",
        headers: {
          "Content-Type": "application/json",
          Accept: "application/json",
        },
        body: JSON.stringify({
          prefix: prefix,
          year_month: yearMonth,
          invoice_type: GST_TYPE,
        }),
        timeout: 5000,
      },
    );
    if (!response.ok) {
      console.warn("Could not fetch latest invoice number from server");
      return;
    }
    const data = await response.json();
    if (data.success && data.invoice_number) {
      document.getElementById("invoice-number").value = data.invoice_number;
      console.log("Updated invoice number to:", data.invoice_number);
    }
  } catch (error) {
    console.warn("Error fetching latest invoice number:", error);
  }
}

let isGeneratingBill = false;

async function generateBill() {
  try {
    if (isGeneratingBill) {
      console.log("Generate Bill already in progress, skipping...");
      return;
    }
    isGeneratingBill = true;
    console.log("🟢 GENERATE BILL - STARTED ====================");
    if (CART.length === 0) {
      console.warn("❌ Generate Bill Failed: Empty cart");
      showWarningToast("Please add items to cart first");
      return;
    }
    const customerName = document.getElementById("customer-name").value.trim();
    if (!customerName) {
      console.warn("❌ Generate Bill Failed: Customer name required");
      showWarningModal(
        "Customer Required",
        "Customer name is required to generate bill",
      );
      document.getElementById("customer-name").focus();
      document.getElementById("customer-name").select();
      return;
    }
    await checkAndGenerateInvoiceNumber();
    const currentInvoiceNumber =
      document.getElementById("invoice-number").value;
    console.log("Using invoice number:", currentInvoiceNumber);
    if (CURRENT_CUSTOMER_ID) {
      console.log(
        "💰 Checking credit limit for customer ID:",
        CURRENT_CUSTOMER_ID,
      );
      const creditCheck = await checkCustomerCreditLimit();
      if (!creditCheck.allowed) {
        console.warn(
          "❌ Generate Bill Failed: Credit limit exceeded",
          creditCheck,
        );
        showWarningModal("Credit Limit Exceeded", creditCheck.message);
        return;
      }
      console.log("✅ Credit check passed");
    }
    console.log("📊 Stock Validation:");
    for (const item of CART) {
      const product = findProductById(item.product_id);
      if (!product) {
        console.warn(
          "❌ Generate Bill Failed: Product not found for item",
          item,
        );
        showErrorToast(`Product not found for ${item.name}`);
        return;
      }
      let availableStock =
        product.shop_stock_primary || product.shop_stock || 0;
      let quantityToCheck = item.quantity_in_primary || item.quantity;
      if (quantityToCheck > availableStock) {
        console.warn("❌ Generate Bill Failed: Insufficient stock for item", {
          item_name: item.name,
          requested_qty: item.quantity,
          requested_in_primary: quantityToCheck,
          available_stock: availableStock,
        });
        let errorMessage = `Insufficient stock for ${item.name}. Available: ${availableStock} ${product.unit_of_measure}`;
        if (
          item.is_secondary_unit &&
          product.secondary_unit &&
          product.sec_unit_conversion
        ) {
          const availableSecondary = Math.floor(
            availableStock * product.sec_unit_conversion,
          );
          errorMessage = `Insufficient stock for ${item.name}. Available: ${availableStock} ${product.unit_of_measure} (≈${availableSecondary} ${product.secondary_unit})`;
        }
        showWarningModal("Stock Insufficient", errorMessage);
        return;
      }
    }
    console.log("✅ All items have sufficient stock");
    const totals = calculateTotals();
    const paymentData = collectPaymentData();
    if (paymentData.totalPaid === 0) {
      console.warn("❌ Generate Bill Failed: No payment entered");
      showWarningToast("Please enter payment amounts");
      return;
    }
    if (paymentData.totalPaid < totals.grandTotal) {
      const pending = totals.grandTotal - paymentData.totalPaid;
      console.warn("❌ Generate Bill Failed: Insufficient payment", {
        grand_total: totals.grandTotal,
        total_paid: paymentData.totalPaid,
        pending_amount: pending,
      });
      showWarningModal(
        "Insufficient Payment",
        `Pending amount: ₹${Math.round(pending)}`,
      );
      return;
    }
    const invoiceData = {
      customer_name: customerName,
      customer_phone: document.getElementById("customer-contact").value || "",
      customer_address: document.getElementById("customer-address").value || "",
      customer_gstin: document.getElementById("customer-gstin").value || "",
      customer_id: CURRENT_CUSTOMER_ID,
      invoice_number: document.getElementById("invoice-number").value,
      invoice_type: GST_TYPE,
      date: document.getElementById("date").value,
      price_type: GLOBAL_PRICE_TYPE,
      referral_id: SELECTED_REFERRAL_ID,
      points_used: POINTS_USED,
      points_discount: totals.pointsDiscount,
      subtotal: totals.subtotal,
      discount: document.getElementById("additional-dis").value,
      discount_type: document.getElementById("overall-discount-type").value,
      overall_discount: totals.overallDiscount,
      total_cgst: totals.totalCGST,
      total_sgst: totals.totalSGST,
      total_igst: totals.totalIGST,
      total_taxable: totals.totalTaxable,
      total_gst: totals.totalGST,
      grand_total: totals.grandTotal,
      referral_commission: totals.totalReferralCommission,
      shipping_details: {
        name: SHIPPING_DETAILS.name,
        contact: SHIPPING_DETAILS.contact,
        gstin: SHIPPING_DETAILS.gstin,
        address: SHIPPING_DETAILS.address,
        vehicle_number: SHIPPING_DETAILS.vehicle_number,
        charges: SHIPPING_DETAILS.charges,
      },
      transport_details: {
        type: TRANSPORT_DETAILS.type,
        charge: TRANSPORT_DETAILS.charge,
      },
      items: CART.map((item) => ({
        product_id: item.product_id,
        name: item.name,
        code: item.code,
        quantity: item.quantity,
        unit: item.unit,
        price: item.price,
        price_type: item.price_type,
        discount_value: item.discount_value,
        discount_type: item.discount_type,
        total: item.price * item.quantity,
        hsn_code: item.hsn_code,
        cgst_rate: item.cgst_rate,
        sgst_rate: item.sgst_rate,
        igst_rate: item.igst_rate,
        taxable_value: calculateItemGST(item).taxable,
        cgst_amount: calculateItemGST(item).cgst,
        sgst_amount: calculateItemGST(item).sgst,
        igst_amount: calculateItemGST(item).igst,
        stock_price: item.stock_price,
        referral_enabled: item.referral_enabled,
        referral_type: item.referral_type,
        referral_value: item.referral_value,
        referral_commission: calculateItemReferralCommission(item),
        is_secondary_unit: item.is_secondary_unit,
        sec_unit_conversion: item.sec_unit_conversion,
        quantity_in_primary:
          item.quantity_in_primary ||
          (item.is_secondary_unit
            ? item.quantity / item.sec_unit_conversion
            : item.quantity),
      })),
      payment_method: Array.from(ACTIVE_PAYMENT_METHODS).join("+"),
      payment_details: paymentData,
      pending_amount:
        paymentData.totalPaid < totals.grandTotal
          ? totals.grandTotal - paymentData.totalPaid
          : 0,
    };
    console.log(
      "📤 Invoice Data to be saved:",
      JSON.stringify(invoiceData, null, 2),
    );
    showLoading("Saving invoice...");
    try {
      console.log("🌐 Sending invoice data to server...");
      const response = await fetchWithTimeout("api/invoices.php?action=save", {
        method: "POST",
        headers: {
          "Content-Type": "application/json",
          Accept: "application/json",
        },
        body: JSON.stringify(invoiceData),
        timeout: 15000,
      });
      console.log(
        "📥 Server Response Status:",
        response.status,
        response.statusText,
      );
      if (!response.ok)
        throw new Error(`HTTP ${response.status}: ${response.statusText}`);
      const data = await response.json();
      console.log("📊 Server Response Data:", data);
      if (data.success) {
        const invoiceId = data.invoice_id || invoiceData.invoice_number;
        console.log("✅ Invoice Saved Successfully!", {
          invoice_number: invoiceData.invoice_number,
          invoice_id: invoiceId,
          timestamp: new Date().toISOString(),
        });
        hideLoading();
        showSuccessModal(
          "Invoice Saved Successfully!",
          `Invoice #${invoiceData.invoice_number} has been saved.`,
          function () {
            CART = [];
            clearCartFromSession();
            SHIPPING_DETAILS = {
              name: "",
              contact: "",
              gstin: "",
              address: "",
              vehicle_number: "",
              charges: 0,
            };
            TRANSPORT_DETAILS = { type: "", charge: 0 };
            sessionStorage.removeItem("pos_shipping_details");
            sessionStorage.removeItem("pos_transport_details");
            updateShippingDetailsHorizontal();
            updateTransportDisplay();
            const shippingRow = document.getElementById("shipping-charges-row");
            if (shippingRow) shippingRow.style.display = "none";
            resetForm();
          },
        );
      } else {
        console.error("❌ Server returned error:", data);
        hideLoading();
        throw new Error(data.message || "Unknown server error");
      }
    } catch (fetchError) {
      console.error("❌ Invoice Save Error:", fetchError);
      hideLoading();
      showErrorModal("Failed to Save Invoice", fetchError.message);
    }
    console.log("🟢 GENERATE BILL - COMPLETED ====================");
  } catch (error) {
    console.error("❌ Generate Bill - Unhandled Error:", error);
    hideLoading();
    showErrorModal("Error", `Error generating bill: ${error.message}`);
  } finally {
    setTimeout(() => {
      isGeneratingBill = false;
    }, 1000);
  }
}

async function checkCustomerCreditLimit() {
  try {
    if (!CURRENT_CUSTOMER_ID) return { allowed: true, message: "" };
    const response = await fetchWithTimeout(
      `api/customers.php?action=credit_check&customer_id=${CURRENT_CUSTOMER_ID}`,
      { timeout: 5000 },
    );
    if (!response.ok)
      return { allowed: true, message: "Unable to check credit limit" };
    const data = await response.json();
    if (data.success && data.has_credit_limit) {
      const totals = calculateTotals();
      const pendingAmount = totals.grandTotal - collectPaymentData().totalPaid;
      if (pendingAmount > 0 && data.available_credit < pendingAmount)
        return {
          allowed: false,
          message: `Credit limit exceeded! Available: ₹${data.available_credit}, Required: ₹${pendingAmount}`,
        };
    }
    return { allowed: true, message: "" };
  } catch (error) {
    console.warn("Credit check error:", error);
    return { allowed: true, message: "Credit check failed" };
  }
}

async function printBill() {
  try {
    if (isGeneratingBill) {
      console.log("Print Bill already in progress, skipping...");
      return;
    }
    isGeneratingBill = true;
    console.log("🟢 PRINT BILL - STARTED ====================");
    if (CART.length === 0) {
      console.warn("❌ Print Bill Failed: Empty cart");
      showWarningToast("Please add items to cart first");
      isGeneratingBill = false;
      return;
    }
    const customerName = document.getElementById("customer-name").value.trim();
    if (!customerName) {
      console.warn("❌ Print Bill Failed: Customer name required");
      showWarningModal(
        "Customer Required",
        "Customer name is required to print bill",
      );
      document.getElementById("customer-name").focus();
      document.getElementById("customer-name").select();
      isGeneratingBill = false;
      return;
    }
    await checkAndGenerateInvoiceNumber();
    const currentInvoiceNumber =
      document.getElementById("invoice-number").value;
    console.log("Using invoice number for print:", currentInvoiceNumber);
    showLoading("Preparing invoice for print...");
    const totals = calculateTotals();
    const paymentData = collectPaymentData();
    const invoiceData = {
      action: "print",
      customer_name: customerName,
      customer_phone: document.getElementById("customer-contact").value || "",
      customer_address: document.getElementById("customer-address").value || "",
      customer_gstin: document.getElementById("customer-gstin").value || "",
      customer_id: CURRENT_CUSTOMER_ID,
      invoice_number: currentInvoiceNumber,
      invoice_type: GST_TYPE,
      date: document.getElementById("date").value,
      price_type: GLOBAL_PRICE_TYPE,
      referral_id: SELECTED_REFERRAL_ID,
      points_used: POINTS_USED,
      points_discount: totals.pointsDiscount,
      subtotal: totals.subtotal,
      discount: document.getElementById("additional-dis").value,
      discount_type: document.getElementById("overall-discount-type").value,
      overall_discount: totals.overallDiscount,
      total_cgst: totals.totalCGST,
      total_sgst: totals.totalSGST,
      total_igst: totals.totalIGST,
      total_taxable: totals.totalTaxable,
      total_gst: totals.totalGST,
      grand_total: totals.grandTotal,
      referral_commission: totals.totalReferralCommission,
      shipping_details: {
        name: SHIPPING_DETAILS.name,
        contact: SHIPPING_DETAILS.contact,
        gstin: SHIPPING_DETAILS.gstin,
        address: SHIPPING_DETAILS.address,
        vehicle_number: SHIPPING_DETAILS.vehicle_number,
        charges: SHIPPING_DETAILS.charges,
      },
      transport_details: {
        type: TRANSPORT_DETAILS.type,
        charge: TRANSPORT_DETAILS.charge,
      },
      items: CART.map((item) => ({
        product_id: item.product_id,
        name: item.name,
        code: item.code,
        quantity: item.quantity,
        unit: item.unit,
        price: item.price,
        price_type: item.price_type,
        discount_value: item.discount_value,
        discount_type: item.discount_type,
        total: item.price * item.quantity,
        hsn_code: item.hsn_code,
        cgst_rate: item.cgst_rate,
        sgst_rate: item.sgst_rate,
        igst_rate: item.igst_rate,
        taxable_value: calculateItemGST(item).taxable,
        cgst_amount: calculateItemGST(item).cgst,
        sgst_amount: calculateItemGST(item).sgst,
        igst_amount: calculateItemGST(item).igst,
        stock_price: item.stock_price,
        referral_enabled: item.referral_enabled,
        referral_type: item.referral_type,
        referral_value: item.referral_value,
        referral_commission: calculateItemReferralCommission(item),
        is_secondary_unit: item.is_secondary_unit,
        sec_unit_conversion: item.sec_unit_conversion,
        quantity_in_primary:
          item.quantity_in_primary ||
          (item.is_secondary_unit
            ? item.quantity / item.sec_unit_conversion
            : item.quantity),
      })),
      payment_method: Array.from(ACTIVE_PAYMENT_METHODS).join("+"),
      payment_details: paymentData,
      pending_amount:
        paymentData.totalPaid < totals.grandTotal
          ? totals.grandTotal - paymentData.totalPaid
          : 0,
    };
    console.log("📤 Sending invoice data for print...", invoiceData);
    try {
      const response = await fetchWithTimeout(
        "api/invoices.php?action=save_for_print",
        {
          method: "POST",
          headers: {
            "Content-Type": "application/json",
            Accept: "application/json",
          },
          body: JSON.stringify(invoiceData),
          timeout: 15000,
        },
      );
      console.log(
        "📥 Print Save Response:",
        response.status,
        response.statusText,
      );
      if (!response.ok)
        throw new Error(`HTTP ${response.status}: ${response.statusText}`);
      const data = await response.json();
      console.log("📊 Print Save Response Data:", data);
      if (data.success) {
        const invoiceId = data.invoice_id;
        console.log("✅ Invoice Saved for Print! Invoice ID:", invoiceId);
        hideLoading();
        CART = [];
        clearCartFromSession();
        SHIPPING_DETAILS = {
          name: "",
          contact: "",
          gstin: "",
          address: "",
          vehicle_number: "",
          charges: 0,
        };
        TRANSPORT_DETAILS = { type: "", charge: 0 };
        sessionStorage.removeItem("pos_shipping_details");
        sessionStorage.removeItem("pos_transport_details");
        updateShippingDetailsHorizontal();
        updateTransportDisplay();
        showSuccessModal(
          "Invoice Saved Successfully!",
          "Opening print preview...",
          function () {
            if (data.print_url) {
              const printWindow = window.open(
                data.print_url,
                "_blank",
                "width=900,height=700",
              );
              if (!printWindow)
                showWarningToast(
                  "Popup blocked. Please allow popups for print preview.",
                );
              else printWindow.focus();
            } else {
              const defaultPrintUrl = `invoice_print.php?invoice_id=${invoiceId}`;
              const printWindow = window.open(
                defaultPrintUrl,
                "_blank",
                "width=900,height=700",
              );
              if (!printWindow)
                showWarningToast(
                  "Popup blocked. Please allow popups for print preview.",
                );
              else printWindow.focus();
            }
            setTimeout(() => {
              resetForm();
            }, 500);
          },
        );
      } else {
        console.error("❌ Print Save Error from server:", data.message);
        hideLoading();
        throw new Error(data.message || "Unknown server error");
      }
    } catch (fetchError) {
      console.error("❌ Print Bill Save Error:", fetchError);
      hideLoading();
      showErrorModal("Failed to Save Invoice", fetchError.message);
    }
    console.log("🟢 PRINT BILL - COMPLETED ====================");
  } catch (error) {
    console.error("❌ Print Bill - Unhandled Error:", error);
    hideLoading();
    showErrorModal("Error", `Error processing print: ${error.message}`);
    isGeneratingBill = false;
    const printBtn = document.getElementById("btnPrintBill");
    if (printBtn) {
      printBtn.disabled = false;
      printBtn.innerHTML = '<i class="fas fa-print me-1"></i> Print Bill';
    }
  }
}

// ==================== HELPER FUNCTIONS ====================
function escapeHtml(text) {
  if (!text) return "";
  const div = document.createElement("div");
  div.textContent = text;
  return div.innerHTML;
}

// ==================== HOLD INVOICE FUNCTIONS ====================
async function loadHoldList() {
  try {
    console.log("Loading hold list...");
    const response = await fetchWithTimeout("api/holds.php?action=list", {
      timeout: 5000,
    });
    if (!response.ok)
      throw new Error(`HTTP ${response.status}: ${response.statusText}`);
    const data = await response.json();
    if (data.success) {
      const tbody = document.getElementById("holdListBody");
      tbody.innerHTML = "";
      if (data.holds && data.holds.length > 0) {
        data.holds.forEach((hold, index) => {
          const cartItems = JSON.parse(hold.cart_items || "[]");
          const itemCount = cartItems.length;
          const row = document.createElement("tr");
          row.innerHTML = `<td>${index + 1}</td><td>${new Date(hold.created_at).toLocaleString()}<br><small class="text-muted">Expires: ${new Date(hold.expiry_at).toLocaleString()}</small></td><td><strong>${hold.hold_number}</strong><br><small>${hold.reference || "No reference"}</small></td><td>${hold.customer_name || "Walk-in"}<br><small>${hold.customer_phone || ""}</small></td><td>${itemCount} items</td><td>₹ ${Math.round(parseFloat(hold.total) || 0)}</td><td><button class="btn btn-sm btn-success" onclick="retrieveHold(${hold.id})"><i class="fas fa-download me-1"></i> Retrieve</button><button class="btn btn-sm btn-danger mt-1" onclick="deleteHold(${hold.id})"><i class="fas fa-trash me-1"></i> Delete</button></td>`;
          tbody.appendChild(row);
        });
      } else
        tbody.innerHTML =
          '<tr><td colspan="7" class="text-center">No holds found</td></tr>';
      const modal = new bootstrap.Modal(
        document.getElementById("holdListModal"),
      );
      modal.show();
      showToast(`Loaded ${data.holds?.length || 0} held invoices`, "success");
    } else throw new Error(data.message || "Failed to load holds");
  } catch (error) {
    console.error("Error loading hold list:", error);
    showToast("Error loading holds: " + error.message, "danger");
  }
}

async function holdInvoice() {
  if (CART.length === 0) {
    showWarningToast("Please add items to cart first");
    return;
  }
  try {
    showPromptModal(
      "Hold Invoice",
      "Enter reference note:",
      "e.g., Waiting for customer confirmation",
      async function (reference) {
        const expiryHours = 48;
        const totals = calculateTotals();
        const holdData = {
          hold_number: document
            .getElementById("invoice-number")
            .value.replace("INV", "HOLD"),
          reference: reference,
          customer_name: document.getElementById("customer-name").value,
          customer_phone:
            document.getElementById("customer-contact").value || "",
          customer_gstin: document.getElementById("customer-gstin").value || "",
          subtotal: totals.subtotal,
          total: totals.grandTotal,
          cart_items: CART,
          cart_json: {
            customer_name: document.getElementById("customer-name").value,
            customer_phone: document.getElementById("customer-contact").value,
            customer_address: document.getElementById("customer-address").value,
            customer_gstin: document.getElementById("customer-gstin").value,
            invoice_type: GST_TYPE,
            price_type: GLOBAL_PRICE_TYPE,
            referral_id: SELECTED_REFERRAL_ID,
            discount: document.getElementById("additional-dis").value,
            discount_type: document.getElementById("overall-discount-type")
              .value,
          },
        };
        showLoading("Saving hold...");
        const response = await fetchWithTimeout("api/holds.php?action=save", {
          method: "POST",
          headers: {
            "Content-Type": "application/json",
            Accept: "application/json",
          },
          body: JSON.stringify(holdData),
          timeout: 10000,
        });
        if (!response.ok)
          throw new Error(`HTTP ${response.status}: ${response.statusText}`);
        const data = await response.json();
        if (data.success) {
          CART = [];
          clearCartFromSession();
          renderCart();
          updateBillingSummary();
          hideLoading();
          showSuccessModal(
            "Invoice Held Successfully!",
            `Hold #: ${holdData.hold_number}<br>Reference: ${reference}<br>Expires in ${expiryHours} hours`,
            function () {
              resetForm();
            },
          );
        } else {
          hideLoading();
          throw new Error(data.message || "Failed to save hold");
        }
      },
    );
  } catch (error) {
    console.error("Error holding invoice:", error);
    hideLoading();
    showErrorModal("Error", `Error holding invoice: ${error.message}`);
  }
}

async function saveHoldInvoice() {
  try {
    const reference = document.getElementById("holdReference").value.trim();
    const expiryHours = parseInt(document.getElementById("holdExpiry").value);
    if (!reference) {
      showToast("Please enter a reference note", "warning");
      return;
    }
    const totals = calculateTotals();
    const holdData = {
      hold_number: document
        .getElementById("invoice-number")
        .value.replace("INV", "HOLD"),
      reference: reference,
      customer_name: document.getElementById("customer-name").value,
      customer_phone: document.getElementById("customer-contact").value || "",
      customer_gstin: document.getElementById("customer-gstin").value || "",
      subtotal: totals.subtotal,
      total: totals.grandTotal,
      cart_items: CART,
      cart_json: {
        customer_name: document.getElementById("customer-name").value,
        customer_phone: document.getElementById("customer-contact").value,
        customer_address: document.getElementById("customer-address").value,
        customer_gstin: document.getElementById("customer-gstin").value,
        invoice_type: GST_TYPE,
        price_type: GLOBAL_PRICE_TYPE,
        referral_id: SELECTED_REFERRAL_ID,
        discount: document.getElementById("additional-dis").value,
        discount_type: document.getElementById("discount-type").value,
      },
    };
    const confirmBtn = document.getElementById("confirmHold");
    confirmBtn.innerHTML =
      '<i class="fas fa-spinner fa-spin me-1"></i> Saving...';
    confirmBtn.disabled = true;
    const response = await fetchWithTimeout("api/holds.php?action=save", {
      method: "POST",
      headers: {
        "Content-Type": "application/json",
        Accept: "application/json",
      },
      body: JSON.stringify(holdData),
      timeout: 10000,
    });
    if (!response.ok)
      throw new Error(`HTTP ${response.status}: ${response.statusText}`);
    const data = await response.json();
    if (data.success) {
      CART = [];
      clearCartFromSession();
      renderCart();
      updateBillingSummary();
      const modal = bootstrap.Modal.getInstance(
        document.getElementById("holdInvoiceModal"),
      );
      if (modal) modal.hide();
      showToast(
        `Invoice held successfully! Hold #: ${holdData.hold_number}`,
        "success",
      );
      setTimeout(() => {
        resetForm();
      }, 1000);
    } else throw new Error(data.message || "Failed to save hold");
  } catch (error) {
    console.error("Error saving hold invoice:", error);
    showToast("Error saving hold: " + error.message, "danger");
  } finally {
    const confirmBtn = document.getElementById("confirmHold");
    if (confirmBtn) {
      confirmBtn.innerHTML = "Save Hold";
      confirmBtn.disabled = false;
    }
  }
}

async function retrieveHold(holdId) {
  try {
    console.log("Retrieving hold:", holdId);
    const response = await fetchWithTimeout(
      `api/holds.php?action=get&hold_id=${holdId}`,
      { timeout: 5000 },
    );
    if (!response.ok)
      throw new Error(`HTTP ${response.status}: ${response.statusText}`);
    const data = await response.json();
    if (data.success && data.hold) {
      const hold = data.hold;
      let cartItems = [];
      try {
        if (typeof hold.cart_items === "string")
          cartItems = JSON.parse(hold.cart_items);
        else if (Array.isArray(hold.cart_items)) cartItems = hold.cart_items;
        else throw new Error("Invalid cart data format");
      } catch (parseError) {
        console.error("Error parsing cart items:", parseError);
        showToast(
          "Error parsing cart data. The hold may be corrupted.",
          "danger",
        );
        return;
      }
      CART = [];
      cartItems.forEach((item) => {
        const cartItem = {
          id: `${item.product_id}-${item.unit || "PCS"}-${item.price || 0}`,
          product_id: item.product_id || item.id,
          name: item.name || "Unknown Product",
          code: item.code || (item.product_id || item.id).toString(),
          mrp: item.mrp || 0,
          base_price: item.base_price || item.price || 0,
          price: item.price || 0,
          price_type: item.price_type || "retail",
          quantity: item.quantity || 1,
          unit: item.unit || "PCS",
          is_secondary_unit: item.is_secondary_unit || false,
          discount_value: item.discount_value || 0,
          discount_type: item.discount_type || "percentage",
          discount_amount: item.discount_amount || 0,
          shop_stock: item.shop_stock || 0,
          hsn_code: item.hsn_code || "",
          cgst_rate: item.cgst_rate || 0,
          sgst_rate: item.sgst_rate || 0,
          igst_rate: item.igst_rate || 0,
          total: (item.price || 0) * (item.quantity || 1),
          stock_price: item.stock_price || 0,
          retail_price: item.retail_price || 0,
          wholesale_price: item.wholesale_price || 0,
          unit_of_measure: item.unit_of_measure || "PCS",
          added_at: new Date().toISOString(),
          quantity_in_primary: item.quantity_in_primary || item.quantity || 1,
        };
        CART.push(cartItem);
      });
      let cartJson = {};
      try {
        if (hold.cart_json) {
          if (typeof hold.cart_json === "string")
            cartJson = JSON.parse(hold.cart_json);
          else cartJson = hold.cart_json;
        }
      } catch (jsonError) {
        console.warn("Error parsing cart_json:", jsonError);
        cartJson = {};
      }
      document.getElementById("customer-name").value =
        cartJson.customer_name || hold.customer_name || "Walk-in Customer";
      if (cartJson.customer_phone || hold.customer_phone)
        $("#customer-contact")
          .val(cartJson.customer_phone || hold.customer_phone)
          .trigger("change");
      document.getElementById("customer-address").value =
        cartJson.customer_address || "";
      document.getElementById("customer-gstin").value =
        cartJson.customer_gstin || hold.customer_gstin || "";
      if (cartJson.invoice_type) {
        document.getElementById("invoice-type").value = cartJson.invoice_type;
        GST_TYPE = cartJson.invoice_type;
      }
      if (cartJson.price_type) {
        document.getElementById("price-type").value = cartJson.price_type;
        GLOBAL_PRICE_TYPE = cartJson.price_type;
      }
      if (cartJson.referral_id) {
        $("#referral").val(cartJson.referral_id).trigger("change");
        SELECTED_REFERRAL_ID = cartJson.referral_id;
      }
      if (cartJson.discount !== undefined)
        document.getElementById("additional-dis").value = cartJson.discount;
      if (cartJson.discount_type)
        document.getElementById("overall-discount-type").value =
          cartJson.discount_type;
      renderCart();
      saveCartToSession();
      updateBillingSummary();
      updateButtonStates();
      const modal = bootstrap.Modal.getInstance(
        document.getElementById("holdListModal"),
      );
      if (modal) modal.hide();
      try {
        await deleteHold(holdId, false);
      } catch (deleteError) {
        console.warn(
          "Could not auto-delete hold after retrieval:",
          deleteError,
        );
      }
      showToast(`Hold #${hold.hold_number} retrieved successfully`, "success");
    } else throw new Error(data.message || "Failed to retrieve hold");
  } catch (error) {
    console.error("Error retrieving hold:", error);
    showToast("Error retrieving hold: " + error.message, "danger");
  }
}

async function deleteHold(holdId, showAlert = true) {
  showConfirmation(
    "Delete Hold",
    "Are you sure you want to delete this held invoice? This action cannot be undone.",
    async function () {
      showLoading("Deleting hold...");
      const response = await fetchWithTimeout("api/holds.php?action=delete", {
        method: "POST",
        headers: {
          "Content-Type": "application/json",
          Accept: "application/json",
        },
        body: JSON.stringify({ hold_id: holdId }),
        timeout: 5000,
      });
      if (!response.ok)
        throw new Error(`HTTP ${response.status}: ${response.statusText}`);
      const data = await response.json();
      if (data.success) {
        hideLoading();
        if (showAlert) showSuccessToast("Hold deleted successfully");
        loadHoldList();
      } else {
        hideLoading();
        throw new Error(data.message || "Failed to delete hold");
      }
    },
  );
}

// ==================== QUOTATION FUNCTIONS ====================
async function showQuotationModal() {
  if (CART.length === 0) {
    showToast("Please add items to cart first", "warning");
    return;
  }
  try {
    const response = await fetchWithTimeout(
      "api/quotations.php?action=get_next_number",
      { timeout: 5000 },
    );
    if (!response.ok)
      throw new Error(`HTTP ${response.status}: ${response.statusText}`);
    const data = await response.json();
    if (data.success) {
      document.getElementById("quotationNumber").value = data.quotation_number;
      const modal = new bootstrap.Modal(
        document.getElementById("quotationModal"),
      );
      modal.show();
    } else
      throw new Error(data.message || "Failed to generate quotation number");
  } catch (error) {
    console.error("Error preparing quotation:", error);
    showToast("Error: " + error.message, "danger");
  }
}

async function saveQuotation() {
  try {
    const quotationNumber = document.getElementById("quotationNumber").value;
    const validUntil = document.getElementById("quotationValidUntil").value;
    const notes = document.getElementById("quotationNotes").value.trim();
    if (!quotationNumber) {
      showWarningToast("Please generate a quotation number first");
      return;
    }
    if (!validUntil) {
      showWarningModal("Date Required", "Please select a valid until date");
      document.getElementById("quotationValidUntil").focus();
      return;
    }
    showConfirmation(
      "Save Quotation?",
      "Are you sure you want to save this as a quotation?",
      async function () {
        const totals = calculateTotals();
        const today = new Date().toISOString().split("T")[0];
        const quotationData = {
          quotation_number: quotationNumber,
          quotation_date: today,
          valid_until: validUntil,
          customer_name: document.getElementById("customer-name").value,
          customer_phone:
            document.getElementById("customer-contact").value || "",
          customer_email: "",
          customer_address:
            document.getElementById("customer-address").value || "",
          customer_gstin: document.getElementById("customer-gstin").value || "",
          subtotal: totals.subtotal,
          total_discount: totals.totalItemDiscount + totals.overallDiscount,
          total_tax: totals.totalGST,
          grand_total: totals.grandTotal,
          notes: notes,
          items: CART.map((item) => ({
            product_id: item.product_id,
            product_name: item.name,
            quantity: item.quantity,
            unit_price: item.price,
            discount_amount: item.discount_amount || 0,
            discount_type: item.discount_type,
            total_price: item.total,
            hsn_code: item.hsn_code,
            cgst_rate: item.cgst_rate,
            sgst_rate: item.sgst_rate,
            igst_rate: item.igst_rate,
            tax_amount: calculateItemGST(item).total,
            price_type: item.price_type,
          })),
        };
        showLoading("Saving quotation...");
        const response = await fetchWithTimeout(
          "api/quotations.php?action=save",
          {
            method: "POST",
            headers: {
              "Content-Type": "application/json",
              Accept: "application/json",
            },
            body: JSON.stringify(quotationData),
            timeout: 10000,
          },
        );
        if (!response.ok)
          throw new Error(`HTTP ${response.status}: ${response.statusText}`);
        const data = await response.json();
        if (data.success) {
          CART = [];
          clearCartFromSession();
          renderCart();
          updateBillingSummary();
          const modal = bootstrap.Modal.getInstance(
            document.getElementById("quotationModal"),
          );
          if (modal) modal.hide();
          hideLoading();
          showSuccessModal(
            "Quotation Saved!",
            `Quotation #${quotationNumber} saved successfully.`,
            function () {
              resetForm();
            },
          );
        } else {
          hideLoading();
          throw new Error(data.message || "Failed to save quotation");
        }
      },
    );
  } catch (error) {
    console.error("Error saving quotation:", error);
    hideLoading();
    showErrorModal("Error", `Error saving quotation: ${error.message}`);
  }
}

async function loadQuotationList() {
  try {
    console.log("Loading quotation list...");
    const response = await fetchWithTimeout("api/quotations.php?action=list", {
      timeout: 5000,
    });
    if (!response.ok)
      throw new Error(`HTTP ${response.status}: ${response.statusText}`);
    const data = await response.json();
    if (data.success) {
      let modalElement = document.getElementById("quotationListModal");
      if (!modalElement) {
        const modalHTML = `<div class="modal fade" id="quotationListModal" tabindex="-1" aria-hidden="true"><div class="modal-dialog modal-lg"><div class="modal-content"><div class="modal-header"><h5 class="modal-title">Saved Quotations</h5><button type="button" class="btn-close" data-bs-dismiss="modal"></button></div><div class="modal-body"><div class="table-responsive"><table class="table table-sm"><thead><tr><th>#</th><th>Date</th><th>Quotation #</th><th>Customer</th><th>Valid Until</th><th>Amount</th><th>Status</th><th>Actions</th></tr></thead><tbody id="quotationListBody"></tbody></table></div></div><div class="modal-footer"><button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button></div></div></div></div>`;
        document.body.insertAdjacentHTML("beforeend", modalHTML);
        modalElement = document.getElementById("quotationListModal");
      }
      const tbody = document.getElementById("quotationListBody");
      tbody.innerHTML = "";
      if (data.quotations && data.quotations.length > 0) {
        data.quotations.forEach((quote, index) => {
          const statusClass =
            {
              active: "badge bg-success",
              expired: "badge bg-danger",
              accepted: "badge bg-info",
              rejected: "badge bg-warning",
            }[quote.status || "active"] || "badge bg-secondary";
          const row = document.createElement("tr");
          row.innerHTML = `<td>${index + 1}</td><td>${quote.formatted_date || quote.quotation_date}</td><td><strong>${quote.quotation_number}</strong></td><td>${quote.customer_name || "Walk-in"}<br><small>${quote.customer_phone || ""}</small></td><td>${quote.formatted_valid_until || quote.valid_until}</td><td>₹ ${Math.round(parseFloat(quote.grand_total) || 0)}</td><td><span class="${statusClass}">${quote.status || "active"}</span></td><td><button class="btn btn-sm btn-success" onclick="retrieveQuotation(${quote.id})"><i class="fas fa-download me-1"></i> Retrieve</button><button class="btn btn-sm btn-danger mt-1" onclick="deleteQuotation(${quote.id})"><i class="fas fa-trash me-1"></i> Delete</button></td>`;
          tbody.appendChild(row);
        });
      } else
        tbody.innerHTML =
          '<tr><td colspan="8" class="text-center">No quotations found</td></tr>';
      const modal = new bootstrap.Modal(modalElement);
      modal.show();
      showToast(`Loaded ${data.quotations?.length || 0} quotations`, "success");
    } else throw new Error(data.message || "Failed to load quotations");
  } catch (error) {
    console.error("Error loading quotation list:", error);
    showToast("Error loading quotations: " + error.message, "danger");
  }
}

async function retrieveQuotation(quotationId) {
  try {
    console.log("Retrieving quotation:", quotationId);
    const quoteResponse = await fetchWithTimeout(
      `api/quotations.php?action=get_items&quotation_id=${quotationId}`,
      { timeout: 5000 },
    );
    if (!quoteResponse.ok)
      throw new Error(
        `HTTP ${quoteResponse.status}: ${quoteResponse.statusText}`,
      );
    const quoteData = await quoteResponse.json();
    if (quoteData.success && quoteData.items) {
      const listResponse = await fetchWithTimeout(
        "api/quotations.php?action=list",
        { timeout: 5000 },
      );
      if (listResponse.ok) {
        const listData = await listResponse.json();
        const quotation = listData.quotations?.find((q) => q.id == quotationId);
        if (quotation) {
          CART = [];
          quoteData.items.forEach((item) => {
            const product = findProductById(item.product_id);
            if (product) {
              const isSecondaryUnit =
                product.secondary_unit &&
                item.unit &&
                item.unit === product.secondary_unit;
              let quantityInPrimary = item.quantity;
              let unit = item.unit || product.unit_of_measure;
              if (isSecondaryUnit && product.sec_unit_conversion) {
                quantityInPrimary = item.quantity / product.sec_unit_conversion;
              } else if (!isSecondaryUnit) {
                quantityInPrimary = item.quantity;
                unit = product.unit_of_measure;
              }
              let price = parseFloat(item.unit_price) || 0;
              let discountValue = 0,
                discountAmount = 0;
              if (item.discount_amount > 0) {
                discountAmount = parseFloat(item.discount_amount) || 0;
                if (item.discount_type === "percentage")
                  discountValue = (discountAmount / price) * 100;
                else discountValue = discountAmount;
              }
              const cartItemId = `${item.product_id}-${unit}-${price}-${item.discount_type}-${isSecondaryUnit}`;
              const cartItem = {
                id: cartItemId,
                product_id: item.product_id,
                name: product.product_name,
                original_product_name: product.product_name,
                code: product.product_code || item.product_id.toString(),
                mrp: product.mrp || 0,
                base_price: price,
                price: price,
                price_type: item.price_type || GLOBAL_PRICE_TYPE || "retail",
                quantity: parseFloat(item.quantity) || 1,
                unit: unit,
                is_secondary_unit: isSecondaryUnit,
                discount_value: parseFloat(discountValue.toFixed(2)) || 0,
                discount_type: item.discount_type || "percentage",
                discount_amount: parseFloat(discountAmount.toFixed(2)) || 0,
                shop_stock: product.shop_stock_primary || 0,
                hsn_code: item.hsn_code || product.hsn_code || "",
                cgst_rate:
                  parseFloat(item.cgst_rate) ||
                  parseFloat(product.cgst_rate) ||
                  0,
                sgst_rate:
                  parseFloat(item.sgst_rate) ||
                  parseFloat(product.sgst_rate) ||
                  0,
                igst_rate:
                  parseFloat(item.igst_rate) ||
                  parseFloat(product.igst_rate) ||
                  0,
                total: price * (parseFloat(item.quantity) || 1),
                referral_enabled: product.referral_enabled || 0,
                referral_type: product.referral_type || "percentage",
                referral_value: parseFloat(product.referral_value) || 0,
                referral_commission: 0,
                secondary_unit: product.secondary_unit || "",
                sec_unit_conversion:
                  parseFloat(product.sec_unit_conversion) || 1,
                stock_price: parseFloat(product.stock_price) || 0,
                retail_price: parseFloat(product.retail_price) || 0,
                wholesale_price: parseFloat(product.wholesale_price) || 0,
                unit_of_measure: product.unit_of_measure || "PCS",
                quantity_in_primary:
                  parseFloat(quantityInPrimary.toFixed(3)) || 1,
                added_at: new Date().toISOString(),
                category_name: product.category_name || "",
                subcategory_name: product.subcategory_name || "",
              };
              CART.push(cartItem);
            } else {
              const cartItem = {
                id: `${item.product_id}-${item.unit}-${item.unit_price}`,
                product_id: item.product_id,
                name: item.product_name || "Unknown Product",
                code: item.product_id.toString(),
                mrp: 0,
                base_price: parseFloat(item.unit_price) || 0,
                price: parseFloat(item.unit_price) || 0,
                price_type: item.price_type || "retail",
                quantity: parseFloat(item.quantity) || 1,
                unit: item.unit || "PCS",
                is_secondary_unit: false,
                discount_value: 0,
                discount_type: "percentage",
                discount_amount: 0,
                shop_stock: 0,
                hsn_code: item.hsn_code || "",
                cgst_rate: parseFloat(item.cgst_rate) || 0,
                sgst_rate: parseFloat(item.sgst_rate) || 0,
                igst_rate: parseFloat(item.igst_rate) || 0,
                total:
                  (parseFloat(item.unit_price) || 0) *
                  (parseFloat(item.quantity) || 1),
                referral_enabled: 0,
                referral_type: "percentage",
                referral_value: 0,
                referral_commission: 0,
                secondary_unit: "",
                sec_unit_conversion: 1,
                stock_price: 0,
                retail_price: 0,
                wholesale_price: 0,
                unit_of_measure: "PCS",
                quantity_in_primary: parseFloat(item.quantity) || 1,
                added_at: new Date().toISOString(),
                category_name: "",
                subcategory_name: "",
              };
              CART.push(cartItem);
            }
          });
          document.getElementById("customer-name").value =
            quotation.customer_name || "Walk-in Customer";
          if (quotation.customer_phone)
            $("#customer-contact")
              .val(quotation.customer_phone)
              .trigger("change");
          document.getElementById("customer-address").value =
            quotation.customer_address || "";
          document.getElementById("customer-gstin").value =
            quotation.customer_gstin || "";
          if (quotation.invoice_type) {
            document.getElementById("invoice-type").value =
              quotation.invoice_type;
            GST_TYPE = quotation.invoice_type;
          }
          if (quotation.price_type) {
            document.getElementById("price-type").value = quotation.price_type;
            GLOBAL_PRICE_TYPE = quotation.price_type;
          }
          clearCartFromSession();
          renderCart();
          saveCartToSession();
          updateBillingSummary();
          updateButtonStates();
          const modal = bootstrap.Modal.getInstance(
            document.getElementById("quotationListModal"),
          );
          if (modal) modal.hide();
          showToast(
            `Quotation #${quotation.quotation_number} retrieved successfully with ${CART.length} items`,
            "success",
          );
        } else throw new Error("Quotation not found");
      } else throw new Error("Failed to load quotation details");
    } else
      throw new Error(
        quoteData.message || "Failed to retrieve quotation items",
      );
  } catch (error) {
    console.error("Error retrieving quotation:", error);
    showToast("Error retrieving quotation: " + error.message, "danger");
  }
}

async function deleteQuotation(quotationId) {
  showConfirmation(
    "Delete Quotation",
    "Are you sure you want to delete this quotation? This action cannot be undone.",
    async function () {
      try {
        showLoading("Deleting quotation...");
        const response = await fetchWithTimeout(
          "api/quotations.php?action=delete",
          {
            method: "POST",
            headers: {
              "Content-Type": "application/json",
              Accept: "application/json",
            },
            body: JSON.stringify({ quotation_id: quotationId }),
            timeout: 5000,
          },
        );
        if (!response.ok)
          throw new Error(`HTTP ${response.status}: ${response.statusText}`);
        const data = await response.json();
        if (data.success) {
          hideLoading();
          showSuccessToast("Quotation deleted successfully");
          loadQuotationList();
        } else {
          hideLoading();
          throw new Error(data.message || "Failed to delete quotation");
        }
      } catch (error) {
        console.error("Error deleting quotation:", error);
        hideLoading();
        showErrorModal("Error", `Error deleting quotation: ${error.message}`);
      }
    },
  );
}

// ==================== PROFIT FUNCTIONS ====================
function calculateItemProfit(item) {
  try {
    const stockPrice = parseFloat(item.stock_price) || 0;
    const profitPerUnit = item.price - stockPrice;
    const totalProfit = profitPerUnit * item.quantity;
    const marginPercentage =
      stockPrice > 0 ? (profitPerUnit / stockPrice) * 100 : 0;
    return {
      profitPerUnit: parseFloat(profitPerUnit.toFixed(2)),
      totalProfit: parseFloat(totalProfit.toFixed(2)),
      marginPercentage: parseFloat(marginPercentage.toFixed(2)),
      sellingPriceWithGST: parseFloat(item.price.toFixed(2)),
      stockPrice: stockPrice,
    };
  } catch (error) {
    console.error("Error calculating item profit:", error);
    return {
      profitPerUnit: 0,
      totalProfit: 0,
      marginPercentage: 0,
      sellingPriceWithGST: 0,
      stockPrice: 0,
    };
  }
}

// ==================== SHIPPING FUNCTIONS ====================
function initShippingModal() {
  try {
    const shippingBtn = document.getElementById("btnShippingDetails");
    if (shippingBtn) {
      shippingBtn.removeEventListener("click", showShippingModal);
      shippingBtn.addEventListener("click", showShippingModal);
    }
    const saveShippingBtn = document.getElementById("btnSaveShipping");
    if (saveShippingBtn) {
      saveShippingBtn.removeEventListener("click", saveShippingDetails);
      saveShippingBtn.addEventListener("click", saveShippingDetails);
    }
    initShippingSectionButtons();
    loadShippingDetailsFromSession();
    createHorizontalShippingDisplay();
    updateShippingDetailsHorizontal();
  } catch (error) {
    console.error("Error initializing shipping modal:", error);
  }
}

// Initialize all features
document.addEventListener("DOMContentLoaded", function () {
  setTimeout(() => {
    initGstFilter();
    initTransportSection();
    initShippingModal();
  }, 500);
});

// Make functions available globally
window.updateCartItemQuantity = updateCartItemQuantity;
window.updateCartItemPriceType = updateCartItemPriceType;
window.updateCartItemDiscount = updateCartItemDiscount;
window.removeCartItem = removeCartItem;
window.cartItemDecrement = cartItemDecrement;
window.cartItemIncrement = cartItemIncrement;
window.SHIPPING_DETAILS = SHIPPING_DETAILS;
window.showShippingModal = showShippingModal;
window.saveShippingDetails = saveShippingDetails;
window.clearShippingDetails = clearShippingDetails;
window.clearShippingDetailsWithConfirm = clearShippingDetailsWithConfirm;
window.updateShippingDetailsHorizontal = updateShippingDetailsHorizontal;
window.retrieveHold = retrieveHold;
window.deleteHold = deleteHold;
window.retrieveQuotation = retrieveQuotation;
window.deleteQuotation = deleteQuotation;
window.printProfitReport = printProfitReport;

console.log("POS System: Script loaded successfully");

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: pos-script.js

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation