B2B Customer & Dealer Portals

[Dealer in Tier-2 Town] 
        │
        ▼ (WhatsApp voice note: "Send 40 boxes of Item #104 at old rate")
[Internal Sales Coordinator] 
        │
        ▼ (Manually checks paper stock ledger or calls godown supervisor)
[Accountant] 
        │
        ▼ (Checks if dealer exceeded ₹5,00,000 credit limit; manual argument ensues)
[Order Finally Dispatched 3 Days Later] ──► (Dispute over GST rate & forgotten discount!)

┌──────────────────────────────────────────────────────────────────┐
│                   Secure Dealer Authentication                   │
│         (GSTIN / Phone OTP Login + Role-Based Sub-Accounts)      │
└─────────────────────────────────┬────────────────────────────────┘
                                  │
         ┌────────────────────────┴────────────────────────┐
         ▼                                                 ▼
┌─────────────────────────────────┐   ┌────────────────────────────────────┐
│ Dynamic Wholesale Pricing Engine│   │ Real-Time Credit & Ledger Control  │
│ • Super Stockist vs Dealer Slab │   │ • Live Credit Limit Utilization    │
│ • Volume Quantity Discounts     │   │ • 1-Click Tally Ledger PDF Export  │
│ • Seasonal Trade Scheme Promos  │   │ • Automated UPI / NEFT Payment Rec │
└────────────────┬────────────────┘   └─────────────────┬──────────────────┘
                 │                                      │
                 └──────────────────┬───────────────────┘
                                    ▼
┌──────────────────────────────────────────────────────────────────┐
│          Automated ERP & Logistics Fulfillment Engine            │
│  • Pushes Sales Order to Tally Prime / SAP                       │
│  • Generates E-Way Bill / GST Invoice JSON                       │
│  • Automated WhatsApp Dispatch Alert with Transporter LR Number  │
└──────────────────────────────────────────────────────────────────┘

// server/actions/placeDealerOrder.ts
import { db } from '@/server/db';
import { orders, dealers, tallySyncQueue } from '@/server/schema';
import { eq } from 'drizzle-orm';

interface OrderItem {
  sku: string;
  quantity: number;
  unitPrice: number;
}

export async function processDealerWholesaleOrder(
  dealerId: string,
  items: OrderItem[],
  totalAmount: number
) {
  return await db.transaction(async (tx) => {
    // 1. Fetch live dealer credit profile and outstanding balance
    const [dealer] = await tx.select().from(dealers).where(eq(dealers.id, dealerId));
    if (!dealer) throw new Error('Dealer not found');

    const totalExposure = Number(dealer.currentOutstanding) + totalAmount;

    // 2. Validate credit limit
    if (totalExposure > Number(dealer.creditLimit)) {
      const excess = totalExposure - Number(dealer.creditLimit);
      return {
        status: 'CREDIT_LIMIT_EXCEEDED',
        message: `Order exceeds sanctioned credit limit by ₹${excess.toLocaleString('en-IN')}. Please settle outstanding balance or pay difference online.`,
        requiredPayment: excess,
      };
    }

    // 3. Create confirmed B2B order record
    const [newOrder] = await tx
      .insert(orders)
      .values({
        dealerId,
        items: JSON.stringify(items),
        totalAmount,
        orderStatus: 'APPROVED_FOR_DISPATCH',
        createdAt: new Date(),
      })
      .returning();

    // 4. Update dealer outstanding balance
    await tx
      .update(dealers)
      .set({ currentOutstanding: totalExposure })
      .where(eq(dealers.id, dealerId));

    // 5. Queue sales order for instant Tally Prime sync
    await tx.insert(tallySyncQueue).values({
      orderId: newOrder.id,
      syncType: 'SALES_VOUCHER_CREATE',
      status: 'PENDING',
    });

    return {
      status: 'SUCCESS',
      orderId: newOrder.id,
      message: 'Order confirmed and queued for warehouse dispatch.',
    };
  });
}