import { Router, Request, Response } from 'express';
import { StayStatus } from '@prisma/client';
import { asyncHandler } from '../../middleware/asyncHandler';
import { authenticate } from '../../middleware/authenticate';
import { requirePermission } from '../../middleware/requirePermission';
import { propertyContext } from '../../middleware/propertyContext';
import { db } from '../../lib/prisma';
import { classifyRoomBeds } from './occupancy-counts';

export const occupancyRouter = Router();
occupancyRouter.use(authenticate, propertyContext, requirePermission('VIEW_OCCUPANCY'));

/** Vacant/occupied/reserved counts overall and per room (tenant-scoped). */
occupancyRouter.get(
  '/',
  asyncHandler(async (req: Request, res: Response) => {
    const rooms = await db.room.findMany({
      where: { archivedAt: null, floor: { not: null }, ...(req.propertyId ? { propertyId: req.propertyId } : {}) },
      include: { beds: { where: { archivedAt: null }, select: { id: true, status: true } } },
      orderBy: [{ floor: 'asc' }, { number: 'asc' }],
    });

    const now = new Date();
    const india = new Date(now.getTime() + 330 * 60_000).toISOString().slice(0, 10);
    const start = new Date(`${india}T00:00:00+05:30`);
    const end = new Date(start.getTime() + 86_400_000);
    const bookings = await db.stay.findMany({
      where: {
        ...(req.propertyId ? { propertyId: req.propertyId } : {}),
        status: { in: [StayStatus.BOOKED, StayStatus.CHECKED_IN] },
        plannedCheckIn: { lt: end },
        OR: [{ plannedCheckOut: { gt: start } }, { status: StayStatus.CHECKED_IN }],
      },
      select: { bedId: true },
    });
    const bookedBedIds = new Set(bookings.map((stay) => stay.bedId));

    const perRoom = rooms.map((r) => {
      const counts = classifyRoomBeds(r.beds, bookedBedIds);
      return { roomId: r.id, number: r.number, floor: r.floor, type: r.type, ...counts };
    });

    const totalBeds = perRoom.reduce((n, r) => n + r.total, 0);
    const occupied = perRoom.reduce((n, r) => n + r.occupied, 0);
    const vacant = perRoom.reduce((n, r) => n + r.vacant, 0);
    const reserved = perRoom.reduce((n, r) => n + r.reserved, 0);

    res.json({
      summary: {
        totalBeds,
        occupied,
        vacant,
        reserved,
        occupancyRate: totalBeds ? Math.round((occupied / totalBeds) * 100) : 0,
      },
      rooms: perRoom,
    });
  }),
);
