Code calc total buy money on shopee

async function getOrders(offset, limit) {
  try {
    const url = `https://shopee.vn/api/v4/order/get_all_order_and_checkout_list?limit=${limit}&offset=${offset}`
    const response = await fetch(url)
    if (!response.ok) {
      throw new Error(`Request failed with status ${response.status}`)
    }
    const data = await response.json()
    const orderData = data?.data?.order_data || []
    return orderData.details_list || []
  } catch (error) {
    console.error('Error in getOrders:', error)
    return []
  }
}

const listTypeMapping = {
  3: 'Hoàn thành',
  4: 'Đã hủy',
  7: 'Vận chuyển',
  // Add other mappings here
}

function mapListType(listType) {
  return listTypeMapping[listType] || 'Không rõ'
}

async function getAllOrders() {
  const limit = 20
  let offset = 0
  let allOrders = []
  let sum = 0 // Initialize the sum variable
  let count = 0
  let order = 0
  let tbody = ''

  while (true) {
    const data = await getOrders(offset, limit)
    if (data.length === 0) break

    for (const item of data) {
      order++
      const cTime = item?.shipping?.tracking_info?.ctime
      const deliveredTime = cTime ? new Date(cTime * 1000).toLocaleDateString('vi-VN') : ''
      const infoCard = item.info_card
      const listType = item.list_type

      const strListType = mapListType(listType)

      const productCount = infoCard.product_count
      let subTotal = listType !== 4 && listType !== 12 ? infoCard.subtotal / 1e5 : 0
      count += productCount
      const orderCard = infoCard.order_list_cards[0]
      const shopName = `${orderCard.shop_info.username} - ${orderCard.shop_info.shop_name}`
      const products = orderCard.product_info.item_groups
      const productSummary = products
        .map((product) =>
          product.items
            .map(
              (item) =>
                `${item.name} -- amount: ${item.amount} -- price: ${new Intl.NumberFormat().format(
                  item.item_price,
                )}`,
            )
            .join(', '),
        )
        .join('; ')
      const name = products[0].items[0].name

      const subTotalNative = new Intl.NumberFormat().format(subTotal) // Removed `let` declaration

      // Add the subtotal to the sum
      sum += subTotal

      const row = [
        order,
        name,
        productCount,
        subTotalNative,
        strListType,
        shopName,
        productSummary,
        deliveredTime,
      ]

      tbody += `<tr>${row.map((item) => `<td>${item}</td>`).join('')}</tr>`
      allOrders.push(row.join('\t'))
    }

    console.log(`Collected: ${offset}`)
    offset += limit
  }

  const thead = `
    <thead>
      <tr>
        <th>STT</th>
        <th>Tên chung</th>
        <th>Số lượng</th>
        <th>Tổng tiền (VNĐ)</th>
        <th>Trạng thái</th>
        <th>Tên shop</th>
        <th>Chi tiết</th>
        <th>Ngày giao</th>
      </tr>
    </thead>
  `

  tbody = `<tbody>${tbody}</tbody>`

  const totalRow = `
    <tfoot>
      <th></th>
      <th>Tổng cộng:</th>
      <th>${count}</th>
      <th>${new Intl.NumberFormat().format(sum)}</th>
      <th></th>
      <th></th>
      <th></th>
      <th></th>
    </tfoot>
  `

  const table = `
    <table id="myTable" class="display" style="width: 100%">
      ${thead}
      ${tbody}
      ${totalRow}
    </table>
  `

  const htmlContent = `
    <!DOCTYPE html>
    <html>
    <head>
      <link rel="stylesheet" href="https://cdn.datatables.net/1.13.6/css/jquery.dataTables.min.css" />
      <script src="https://code.jquery.com/jquery-3.7.0.js"></script>
      <script src="https://cdn.datatables.net/1.13.6/js/jquery.dataTables.min.js"></script>
    </head>
    <body>
      ${table}
      <script>
        $(document).ready( function () {
          var table = $('#myTable').DataTable({
            info: false,
            fixedHeader: {
              header: true,
              footer: true
            },
            paging: false,
            scrollCollapse: true,
            scrollX: true,
            scrollY: 700
          });
        });
      </script>
    </body>
    </html>
  `

  const blob = new Blob([htmlContent], { type: 'text/html' })
  const tempURL = URL.createObjectURL(blob)

  const link = document.createElement('a')
  link.id = 'link'
  link.href = tempURL
  link.textContent = 'View Detail Shopee Report'

  link.addEventListener('click', async function (event) {
    event.preventDefault()
    const iframe = document.createElement('iframe')
    iframe.src = tempURL
    iframe.style.width = '100%'
    iframe.style.height = '900px'
    document.body.appendChild(iframe)
    link.style.pointerEvents = 'none'
    link.hidden = true
  })

  const output = `
    <h3>Click copy and paste to a blank excel file! </h3>
    <textarea id="textarea">${allOrders.join('\r\n')}</textarea><br>
    <button onclick="copy()">Copy</button>
  `

  document.body.innerHTML = output
  document.body.appendChild(link)
}

function copy() {
  const textarea = document.getElementById('textarea')
  textarea.select()
  document.execCommand('copy')
}

getAllOrders()
Editor is loading...