Webhooks: List Orders

app.get('/api/orders', (req, res) => {
  const { offset = 0, next, sortorder = 'desc', jobid } = req.query;
  const apiKey = req.headers['t2skey'];

  // Validate API key
  if (apiKey !== process.env.TALK2SYNC_KEY) {
    return res.status(401).json({ error: 'Unauthorized' });
  }

  try {
    // Fetch orders from your database
    const allOrders = fetchOrdersFromDatabase(sortorder);
    
    // Implement pagination (numeric offset example)
    const pageSize = 20;
    const startIndex = parseInt(offset) || 0;
    const paginatedOrders = allOrders.slice(startIndex, startIndex + pageSize);

    // Build response
    const response = {
      paging: {
        pageSize: paginatedOrders.length,
        itemsTotal: allOrders.length,
        offset: startIndex
      },
      orders: paginatedOrders.map(order => ({
        _id: order.id,
        orderid: order.orderNumber,
        last_updated: new Date(order.updatedAt).getTime(),
        status: order.status,
        dateCreated: order.createdAt,
        dateClosed: order.closedAt || "",
        total: {
          amount: order.totalAmount,
          currency: order.currency || "USD"
        },
        orderItems: order.items.map(item => ({
          id: item.productId,
          variation_id: item.variationId || "0",
          quantity: item.quantity,
          unitPrice: item.price,
          currencyId: order.currency || "USD"
        })),
        buyer: {
          id: order.buyerId,
          email: order.buyerEmail,
          phone: order.buyerPhone || "",
          firstName: order.buyerFirstName || "",
          lastName: order.buyerLastName || "",
          billingaddress: {
            addressline: order.billingAddress?.street || "",
            zipcode: order.billingAddress?.zipcode || "",
            city: order.billingAddress?.city || "",
            state: order.billingAddress?.state || "",
            country: order.billingAddress?.country || ""
          },
          shipmentaddress: {
            addressline: order.shippingAddress?.street || "",
            zipcode: order.shippingAddress?.zipcode || "",
            city: order.shippingAddress?.city || "",
            state: order.shippingAddress?.state || "",
            country: order.shippingAddress?.country || ""
          }
        },
        shipments: order.shipments?.map(ship => ({
          id: ship.id,
          shiptracknum: ship.trackingNumber || "",
          shipitems: ship.itemIds || [],
          shiptype: ship.carrier || "",
          shipstatus: ship.status || "pending"
        })) || [],
        rating: order.rating || 0,
        feedback: order.review || "",
        messages: order.messages?.map(msg => ({
          message_id: msg.id || "",
          date_created: new Date(msg.createdAt).getTime(),
          from: msg.sender || "",
          message: msg.content || ""
        })) || []
      }))
    };

    res.json(response);
  } catch (error) {
    console.error('Error fetching orders:', error);
    res.status(500).json({ error: 'Internal Server Error' });
  }
});