content.js

chrome.runtime.onMessage.addListener(async function (request, sender, sendResponse) {
  if (request.method === "downloadXLSX") {
    // Array to store all order items
    let orderItems = [];

    // Select all elements representing the print items list
    let printItemsList = document.querySelectorAll(".dn.print-items-list");

    // Loop through each item in the print items list
    printItemsList.forEach((item) => {
      let productName = item.querySelector(".w_U9_0.w_sD6D.w_QcqU")?.innerText;
      let deliveryStatus = item.querySelector(".print-bill-type .w_U9_0.w_sD6D.w_QcqU")?.innerText || "Delivered";
      let quantity = item.querySelector(".print-bill-qty .w_U9_0.w_sD6D.w_QcqU")?.innerText;
      let price = item.querySelector(".print-bill-price .w_U9_0.w_sD6D.w_QcqU")?.innerText;

      // Find the corresponding visible item to get the product link
      let productLink = "N/A";
      let visibleItems = document.querySelectorAll('[data-testid="itemtile-stack"] [data-testid="productName"] span');
      for (let visibleItem of visibleItems) {
        if (visibleItem?.innerText.trim() === productName.trim()) {
          let linkElement = visibleItem.closest('[data-testid="itemtile-stack"]').querySelector('a[link-identifier="itemClick"]');
          if (linkElement) {
            productLink = linkElement.href;
            break;
          }
        }
      }

      // Push the item details into the orderItems array
      orderItems.push({
        productName,
        productLink,
        deliveryStatus,
        quantity,
        price,
      });
    });

    // Function to find the order number based on a list of possible selectors
    function findOrderNumber() {
      const selectors = [
        ".f-subheadline-m.dark-gray-m.print-bill-bar-id",
        "[data-testid='orderInfoCard'] .dark-gray",
        ".print-bill-heading .dark-gray",
        ".print-bill-bar-id",
      ];

      for (let selector of selectors) {
        const element = document.querySelector(selector);
        if (element) {
          const text = element.textContent;
          const match = text.match(/#\s*([\d-]+)/);
          if (match) {
            return match[1];
          }
        }
      }

      console.log("Order number not found with current selectors");
      return null;
    }

    // Extract additional order details
    let orderNumber = findOrderNumber();
    let orderDate = document.querySelector(".print-bill-date")?.innerText;
    orderDate = orderDate.replace("order", "").trim();
    let orderTotal = document.querySelector(".bill-order-total-payment h2:last-child")?.innerText;
    let deliveryCharges = document.querySelector(".print-fees")?.innerText || "$0.00";
    let tax = document.querySelector(".print-bill-payment-section .pv3 .w_U9_0.w_U0S3.w_QcqU:last-child")?.innerText || "$0.00";
    let tip =
      document.querySelector(".print-bill-payment-section .flex.justify-between.pb2.pt3 .w_U9_0.w_U0S3.w_QcqU:last-child")?.innerText || "$0.00";

    // Check if the order number was found
    if (orderNumber) {
      console.log("Order number:", orderNumber);
    } else {
      console.log("Could not find order number");
    }

    // Collect all order details
    let orderDetails = {
      orderNumber,
      orderDate,
      orderTotal,
      deliveryCharges,
      tax,
      tip,
      items: orderItems,
    };

    // Convert the order details to an XLSX file using the convertToXlsx function
    convertToXlsx(orderDetails, ExcelJS);

    // Send the response back to the caller with the order details
    sendResponse({ data: orderDetails });
  }
});

// Function to convert order details to an XLSX file
async function convertToXlsx(orderDetails, ExcelJS) {
  // Create a new Excel workbook and worksheet
  const workbook = new ExcelJS.Workbook();
  const worksheet = workbook.addWorksheet("Order Invoice");

  // Define font styles for headers and product details
  let headerFontStyle = { size: 12, bold: true, name: "Times New Roman" };
  let productFontStyle = { size: 12, name: "Times New Roman" };

  // Set worksheet columns with headers, keys, and styles
  worksheet.columns = [
    { header: "Product Name", key: "productName", width: 60 },
    { header: "Quantity", key: "quantity", width: 20, style: { numFmt: "#,##0", alignment: { horizontal: "center" } } },
    { header: "Price", key: "price", width: 20, style: { numFmt: "$#,##0.00", alignment: { horizontal: "center" } } },
    { header: "Delivery Status", key: "deliveryStatus", width: 30, style: { alignment: { horizontal: "center" } } },
    { header: "Product Link", key: "productLink", width: 60, style: { font: { color: { argb: "FF0000FF" }, underline: true } } },
  ];

  // Add each order item as a row in the worksheet
  orderDetails.items.forEach((item) => {
    worksheet.addRow({
      productName: item.productName,
      productLink: { text: item.productName.length > 60 ? item.productName.substring(0, 60) + "..." : item.productName, hyperlink: item.productLink },
      quantity: Number(item.quantity.replace(/[^0-9.-]+/g, "")),
      price: Number(item.price.replace(/[^0-9.-]+/g, "")),
      deliveryStatus: item.deliveryStatus,
    }).font = productFontStyle;
  });

  // Apply product font style to all cells
  worksheet.eachRow((row) => {
    row.eachCell((cell) => {
      cell.font = productFontStyle;
    });
    const cell = row.getCell("productLink");
    cell.font = { color: { argb: "FF0000FF" }, underline: true };
  });

  // Apply header font style to the first row (header row)
  worksheet.getRow(1).eachCell((cell) => {
    cell.font = headerFontStyle;
  });

  // Add an empty row between product details and order details for clarity
  worksheet.addRow([]);

  // Add order details to the worksheet
  worksheet.addRow(["Order Number", orderDetails.orderNumber]).font = { ...productFontStyle, bold: true };
  worksheet.addRow(["Order Date", orderDetails.orderDate]).font = { ...productFontStyle, bold: true };
  let deliveryCharges = worksheet.addRow(["Delivery Charges", Number(orderDetails.deliveryCharges.replace(/[^0-9.-]+/g, ""))]);
  let tax = worksheet.addRow(["Tax", Number(orderDetails.tax.replace(/[^0-9.-]+/g, ""))]);
  let tip = worksheet.addRow(["Tip", Number(orderDetails.tip.replace(/[^0-9.-]+/g, ""))]);
  let total = worksheet.addRow(["Order Total", Number(orderDetails.orderTotal.replace(/[^0-9.-]+/g, ""))]);

  const styleCells = [deliveryCharges, tax, tip, total];
  styleCells.forEach((row) => {
    row.getCell(2).numFmt = "$#,##0.00";
    row.getCell(2).font = { ...productFontStyle, bold: true };
    row.getCell(1).font = { ...productFontStyle, bold: true };
    row.getCell(2).alignment = { horizontal: "center" };
  });

  // Generate the Excel file and trigger download in the browser
  const buffer = await workbook.xlsx.writeBuffer();
  let blob = new Blob([buffer], { type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" });
  let url = window.URL.createObjectURL(blob);
  let anchor = document.createElement("a");
  anchor.href = url;
  anchor.download = `Order_${orderDetails.orderNumber}.xlsx`;
  document.body.appendChild(anchor);
  anchor.click();
  document.body.removeChild(anchor);
  window.URL.revokeObjectURL(url);
}