import { VercelRequest, VercelResponse } from '@vercel/node';
import { queryStore, addPendingOrder, queryStock } from '../../db'
import { Store } from '../../store'
import { Product } from '../../product'
import { nanoid } from 'nanoid/non-secure'
import Stripe from 'stripe';



const stripe = new Stripe(process.env.STRIPE_SECRET_KEY!, {
  apiVersion: '2025-04-30.basil',
});

interface order {
  product_id: number,
  quantity: number
}

interface POSTBODY {
  store_url: string,
  order: order[]
}

async function checkStockAvailability(order: order[], products: Product[]): Promise<boolean> {
  for (const item of order) {
    const product = products.find((p) => p.id === item.product_id);
    if (!product || product.stock === undefined || product.stock === null) {
      return false;
    }

    // Check if stock is available for the requested quantity
    if (product.stock < item.quantity) {
      return false;
    }
  }

  // If no issues were found, return null
  return true;
}

export default async function handler(req: VercelRequest, res: VercelResponse) {

  res.setHeader('Access-Control-Allow-Origin', '*');
  res.setHeader('Access-Control-Allow-Methods', 'GET, POST, PUT, DELETE, OPTIONS');
  res.setHeader('Access-Control-Allow-Headers', 'Content-Type, Authorization');

  if (req.method === 'OPTIONS') {
    return res.status(200).end(); // Stop here for preflight
  }

  try {
    const { store_url,order }: POSTBODY = req.body;

    const store: Store | null = await queryStore(store_url);
    if (!store) {
      return res.status(500).json({ error: 'No store found' });
    }

    const products: Product[] = await queryStock(store.id)
    console.log(products)
    if (!(await checkStockAvailability(order, products))) {
      return res.status(500).json({ error: 'No stock left or invalid order' });
    }  
}

import { createClient } from "@libsql/client/web";
import { Store } from '../store'
import { nanoid } from 'nanoid/non-secure';

{
    "functions": {
      "src/api/**/*": {
        "includeFiles": "src/db.ts"
      }
    }
  }
  

{
    "compilerOptions": {

        "outDir": "dist",
        "baseUrl": "./",
        "paths": {
            "@/*": ["*"]
        },
      "module": "ESNext",
      "target": "ES2020",
      "moduleResolution": "node",
      "esModuleInterop": true,
      "forceConsistentCasingInFileNames": true,
      "strict": true,
      "skipLibCheck": true
    },
    "include": ["src/**/*"],
    "exclude": ["node_modules", "dist"]

}
  

Cannot find module '/var/task/src/db' imported from /var/task/src/api/create-checkout-session/index.js
    at finalizeResolution (node:internal/modules/esm/resolve:281:11)
    at moduleResolve (node:internal/modules/esm/resolve:866:10)
    at moduleResolveWithNodePath (node:internal/modules/esm/resolve:990:14)
    at defaultResolve (node:internal/modules/esm/resolve:1033:79)
    at ModuleLoader.defaultResolve (node:internal/modules/esm/loader:685:12)
    at #cachedDefaultResolve (node:internal/modules/esm/loader:634:25)
    at ModuleLoader.resolve (node:internal/modules/esm/loader:617:38)
    at ModuleLoader.getModuleJobForImport (node:internal/modules/esm/loader:273:38)
    at ModuleJob._link (node:internal/modules/esm/module_job:135:49) {
  code: 'ERR_MODULE_NOT_FOUND',
  url: 'file:///var/task/db'
}
Node.js process exited with exit status: 1. The logs above can help with debugging the issue.