Smart Voice-Controlled Resort & Hospitality Management System

// app/api/v1/voice/food-order/route.js
import { NextResponse } from 'next/server';
import pool from '@/lib/db';

export async function POST(req) {
  const connection = await pool.getConnection();
  try {
    const { booking_id, room_number, raw_transcript, parsed_items } = await req.json();

    // 1. CHECK FOR EXISTING ACTIVE ORDERS IN 'PENDING' OR 'COOKING' STATE
    const [activeOrders] = await connection.query(
      `SELECT o.id, o.order_status, m.item_name, od.quantity 
       FROM room_food_orders o 
       JOIN food_order_details od ON o.id = od.order_id 
       JOIN menu_items m ON od.item_id = m.id 
       WHERE o.booking_id = ? AND o.order_status IN ('PENDING_KITCHEN', 'PREPARING')`,
      [booking_id]
    );

    let activeOrderNotice = "";
    if (activeOrders.length > 0) {
      const existingItems = activeOrders.map(i => `${i.quantity} x ${i.item_name}`).join(', ');
      const currentStatus = activeOrders[0].order_status === 'PREPARING' ? 'currently cooking in the kitchen' : 'received and waiting in queue';
      activeOrderNotice = `Notice: Your previous order of (${existingItems}) is ${currentStatus}. `;
    }

    // 2. IF NO NEW ITEMS PASSED, JUST RETURN STATUS UPDATE
    if (!parsed_items || parsed_items.length === 0) {
      return NextResponse.json({
        status: 'STATUS_CHECK',
        tts_speech: `${activeOrderNotice}Would you like to add any new dishes to your room?`
      });
    }

    // 3. PROCESS NEW FOOD ORDER & UPDATE MASTER FOLIO
    await connection.beginTransaction();

    let subtotal = 0;
    const verifiedItems = [];

    for (const item of parsed_items) {
      const [menuRows] = await connection.query(
        'SELECT id, item_name, price FROM menu_items WHERE item_name LIKE ? AND is_available = TRUE LIMIT 1',
        [`%${item.item_name}%`]
      );

      if (menuRows.length > 0) {
        const menuItem = menuRows[0];
        const lineTotal = Number(menuItem.price) * (item.qty || 1);
        subtotal += lineTotal;
        verifiedItems.push({
          id: menuItem.id,
          name: menuItem.item_name,
          qty: item.qty || 1,
          unit_price: menuItem.price,
          lineTotal
        });
      }
    }

    if (verifiedItems.length === 0) {
      await connection.rollback();
      return NextResponse.json({
        status: 'FAILED',
        tts_speech: `${activeOrderNotice}Sorry, we couldn't find those requested items on our active menu. Would you like something else?`
      }, { status: 404 });
    }

    // Create Order Header
    const [orderResult] = await connection.query(
      'INSERT INTO room_food_orders (booking_id, room_number, order_status, total_amount) VALUES (?, ?, "PENDING_KITCHEN", ?)',
      [booking_id, room_number, subtotal]
    );
    const orderId = orderResult.insertId;

    // Insert Line Items with Frozen Prices
    for (const line of verifiedItems) {
      await connection.query(
        'INSERT INTO food_order_details (order_id, item_id, quantity, unit_price, total_item_price) VALUES (?, ?, ?, ?, ?)',
        [orderId, line.id, line.qty, line.unit_price, line.lineTotal]
      );
    }

    // Post Food Charge to Guest Master Folio
    const itemSummary = verifiedItems.map(i => `${i.qty}x ${i.name}`).join(', ');
    await connection.query(
      'INSERT INTO folio_billing (booking_id, charge_type, description, amount) VALUES (?, "FOOD_ORDER", ?, ?)',
      [booking_id, `In-Room Dining: Order #${orderId} (${itemSummary})`, subtotal]
    );

    // Save Voice Audit Logs
    await connection.query(
      'INSERT INTO voice_interaction_logs (booking_id, raw_transcript, parsed_intent, confidence_score) VALUES (?, ?, "ORDER_FOOD", 0.98)',
      [booking_id, raw_transcript]
    );

    await connection.commit();

    const confirmedText = `${activeOrderNotice} Your new order for ${itemSummary} worth ${subtotal} has been placed and added to your master folio!`;

    return NextResponse.json({
      status: 'CONFIRMED',
      order_id: orderId,
      added_amount: subtotal,
      tts_speech: confirmedText
    });
  } catch (error) {
    await connection.rollback();
    return NextResponse.json({ error: 'Food Transaction Failed: ' + error.message }, { status: 500 });
  } finally {
    connection.release();
  }
}

// app/api/v1/voice/housekeeping/route.js
import { NextResponse } from 'next/server';
import pool from '@/lib/db';

export async function POST(req) {
  const connection = await pool.getConnection();
  try {
    const { booking_id, room_id, request_type, notes } = await req.json(); // request_type: 'ROOM_CLEANING' | 'TOWELS' | 'REPAIR'

    await connection.beginTransaction();

    // 1. Create Housekeeping Request Entry
    const [requestResult] = await connection.query(
      'INSERT INTO housekeeping_requests (booking_id, room_id, request_type, request_status, notes) VALUES (?, ?, ?, "PENDING", ?)',
      [booking_id, room_id, request_type || 'ROOM_CLEANING', notes || 'Requested via Voice Terminal']
    );

    // 2. Update Target Room Operational Status
    await connection.query(
      'UPDATE rooms SET room_status = "CLEANING_REQUIRED" WHERE id = ?',
      [room_id]
    );

    await connection.commit();

    return NextResponse.json({
      status: 'DISPATCHED',
      request_id: requestResult.insertId,
      tts_speech: `Housekeeping request for ${(request_type || 'cleaning').toLowerCase().replace('_', ' ')} has been logged. Our resort attendant will arrive at room shorty!`
    });
  } catch (error) {
    await connection.rollback();
    return NextResponse.json({ error: 'Housekeeping Dispatch Failed: ' + error.message }, { status: 500 });
  } finally {
    connection.release();
  }
}

// app/api/v1/billing/folio/[bookingId]/route.js
import { NextResponse } from 'next/server';
import pool from '@/lib/db';

export async function GET(req, { params }) {
  try {
    const { bookingId } = await params;

    // Fetch itemized charges for current guest folio
    const [charges] = await pool.query(
      `SELECT id, charge_type, description, amount, payment_status, created_at 
       FROM folio_billing 
       WHERE booking_id = ? 
       ORDER BY created_at ASC`,
      [bookingId]
    );

    // Calculate total unpaid folio amount dynamically
    const totalAmount = charges.reduce((sum, item) => sum + Number(item.amount), 0);

    return NextResponse.json({
      booking_id: Number(bookingId),
      total_unsettled_amount: Number(totalAmount.toFixed(2)),
      itemized_charges: charges
    });
  } catch (error) {
    return NextResponse.json({ error: 'Failed to calculate folio bill' }, { status: 500 });
  }
}

// components/SmartResortVoiceTerminal.jsx
'use client';
import { useState, useEffect } from 'react';

export default function SmartResortVoiceTerminal({ bookingId, roomId, roomNumber, guestId }) {
  const [isListening, setIsListening] = useState(false);
  const [transcript, setTranscript] = useState('');
  const [aiSpeechResponse, setAiSpeechResponse] = useState('');
  const [roomImage, setRoomImage] = useState(null);
  const [folioTotal, setFolioTotal] = useState(0);
  const [chargeList, setChargeList] = useState([]);

  // Fetch Live Master Folio Card Amount
  const refreshFolioCard = async () => {
    try {
      const res = await fetch(`/api/v1/billing/folio/${bookingId}`);
      const data = await res.json();
      if (data.total_unsettled_amount !== undefined) {
        setFolioTotal(data.total_unsettled_amount);
        setChargeList(data.itemized_charges || []);
      }
    } catch (e) {
      console.error('Folio Sync Error', e);
    }
  };

  useEffect(() => {
    if (bookingId) refreshFolioCard();
  }, [bookingId]);

  // Browser Text-to-Speech (TTS) Engine
  const speak = (text) => {
    if ('speechSynthesis' in window) {
      window.speechSynthesis.cancel();
      const utterance = new SpeechSynthesisUtterance(text);
      utterance.lang = 'en-US';
      utterance.rate = 0.95;
      window.speechSynthesis.speak(utterance);
    }
  };

  // Process Intent with Backend APIs
  const handleVoiceIntent = async (userText) => {
    const lower = userText.toLowerCase();

    // SCENARIO 1: ROOM DETAILS OR SHOW ROOM IMAGE
    if (lower.includes('room details') || lower.includes('show room') || lower.includes('deluxe')) {
      const res = await fetch('/api/v1/voice/room-booking', {
        method: 'POST',
        headers: { 'Content-Type': 'application/json' },
        body: JSON.stringify({ action: 'QUERY_DETAILS', room_type_id: 1 })
      });
      const data = await res.json();
      setAiSpeechResponse(data.tts_speech);
      speak(data.tts_speech);
      if (data.show_image) setRoomImage(data.image_url);
      return;
    }

    // SCENARIO 2: CANCEL BOOKING AT CONFIRMATION
    if (lower.includes('cancel booking') || lower.includes('dont book')) {
      const res = await fetch('/api/v1/voice/room-booking', {
        method: 'POST',
        headers: { 'Content-Type': 'application/json' },
        body: JSON.stringify({ action: 'CANCEL_BOOKING' })
      });
      const data = await res.json();
      setRoomImage(null); // Hide image on cancellation
      setAiSpeechResponse(data.tts_speech);
      speak(data.tts_speech);
      return;
    }

    // SCENARIO 3: HOUSEKEEPING / CLEAN ROOM
    if (lower.includes('clean') || lower.includes('housekeeping') || lower.includes('towel')) {
      setRoomImage(null);
      const res = await fetch('/api/v1/voice/housekeeping', {
        method: 'POST',
        headers: { 'Content-Type': 'application/json' },
        body: JSON.stringify({ booking_id: bookingId, room_id: roomId, request_type: 'ROOM_CLEANING' })
      });
      const data = await res.json();
      setAiSpeechResponse(data.tts_speech);
      speak(data.tts_speech);
      return;
    }

    // SCENARIO 4: ORDER FOOD (WITH COOKING STATUS CHECK)
    setRoomImage(null);
    const res = await fetch('/api/v1/voice/food-order', {
      method: 'POST',
      headers: { 'Content-Type': 'application/json' },
      body: JSON.stringify({
        booking_id: bookingId,
        room_number: roomNumber,
        raw_transcript: userText,
        parsed_items: [{ item_name: userText, qty: 1 }]
      })
    });
    const data = await res.json();
    setAiSpeechResponse(data.tts_speech);
    speak(data.tts_speech);
    refreshFolioCard(); // Instantly update master folio bill amount
  };

  // Browser Speech-to-Text (STT) Engine
  const startListening = () => {
    const SpeechRecognition = window.SpeechRecognition || window.webkitSpeechRecognition;
    if (!SpeechRecognition) {
      alert('Browser does not support Speech Recognition.');
      return;
    }
    const recognition = new SpeechRecognition();
    recognition.lang = 'en-US';

    recognition.onstart = () => setIsListening(true);
    recognition.onend = () => setIsListening(false);

    recognition.onresult = (event) => {
      const voiceInput = event.results[0][0].transcript;
      setTranscript(voiceInput);
      handleVoiceIntent(voiceInput);
    };

    recognition.start();
  };

  return (
    <div className="grid grid-cols-1 md:grid-cols-3 gap-6 bg-slate-50 p-6 rounded-2xl border border-slate-200">
      {/* VOICE TERMINAL INTERACTION CARD */}
      <div className="md:col-span-2 bg-white p-5 rounded-xl border border-slate-200 space-y-4 shadow-sm">
        <div className="flex items-center justify-between border-b pb-3">
          <h4 className="font-bold text-slate-800">🎙️ Smart Voice Assistant (Room #{roomNumber})</h4>
          <span className="text-xs bg-blue-100 text-blue-700 font-bold px-2.5 py-1 rounded-full">System Ready</span>
        </div>

        <button
          onClick={startListening}
          className={`w-full py-3 rounded-xl font-bold transition-all shadow-md ${
            isListening ? 'bg-rose-500 text-white animate-pulse' : 'bg-blue-600 hover:bg-blue-700 text-white'
          }`}
        >
          {isListening ? 'Listening to your voice...' : 'Push to Speak'}
        </button>

        <div className="space-y-2 text-xs">
          <p className="p-2.5 bg-slate-100 rounded-lg"><strong>Guest Voice Input:</strong> {transcript || 'Waiting for speech...'}</p>
          <p className="p-2.5 bg-blue-50 text-blue-900 rounded-lg"><strong>AI Assistant Response:</strong> {aiSpeechResponse || 'Hello! How can I assist you today?'}</p>
        </div>

        {/* DYNAMIC ROOM IMAGE PREVIEW (SHOWN ONLY WHEN DETAILS ARE REQUESTED) */}
        {roomImage && (
          <div className="mt-4 border rounded-xl overflow-hidden bg-slate-900 space-y-2 p-2">
            <img src={roomImage} alt="Room Category Preview" className="w-full h-48 object-cover rounded-lg" />
            <p className="text-[11px] text-slate-300 text-center font-sans">Showing preview image based on voice query.</p>
          </div>
        )}
      </div>

      {/* LIVE MASTER FOLIO BILL CARD */}
      <div className="bg-slate-900 text-white p-5 rounded-xl space-y-4 shadow-md flex flex-col justify-between">
        <div className="space-y-3">
          <span className="text-xs font-mono text-blue-400 font-bold tracking-wider uppercase">Master Folio Ledger</span>
          <div className="border-b border-slate-800 pb-3">
            <h3 className="text-2xl font-extrabold text-white">{folioTotal.toFixed(2)} <span className="text-sm font-normal text-slate-400">BDT</span></h3>
            <p className="text-[11px] text-emerald-400">● Live Auto-Updated Balance</p>
          </div>

          <div className="space-y-2 max-h-40 overflow-y-auto text-[11px] font-mono text-slate-300">
            {chargeList.map((item) => (
              <div key={item.id} className="flex justify-between border-b border-slate-800/80 pb-1">
                <span className="truncate max-w-35">{item.description}</span>
                <span className="font-bold text-white">+{item.amount}</span>
              </div>
            ))}
          </div>
        </div>

        <button onClick={refreshFolioCard} className="w-full bg-slate-800 hover:bg-slate-700 text-xs py-2 rounded-lg text-slate-300 transition">
          🔄 Sync Folio Charges
        </button>
      </div>
    </div>
  );
}