# V3 Pricing Report - Browser Test Checklist

## URL
https://mssql.danmarcrm.com/hotel/v3/report_pricing.php

## Features Added
1. **Type Filter** - Multi-select dropdown for apartment/hotel filtering
2. **Availability Graph** - Bar chart showing available properties per check-in night
3. **Bookings Delta Report** - Table showing room decreases between query dates

## Test Checklist

### 1. Initial Page Load
- [ ] Page loads without errors
- [ ] F12 Console shows no JavaScript errors
- [ ] Default filters populate:
  - Query Date: 2025-10-16 to 2025-10-30
  - Check-in: 2025-11-01
  - Type: empty (both selected by default)

### 2. Type Filter
- [ ] Multi-select dropdown visible with Apartment/Hotel options
- [ ] Ctrl+Click to select both types
- [ ] Click Apply - verify data updates
- [ ] Select only "Apartment" - verify table filters to apartments
- [ ] Select only "Hotel" - verify table filters to hotels

### 3. Availability Graph (New)
- [ ] Bar chart displays above pricing chart
- [ ] X-axis shows check-in dates (2025-11-01, 2025-11-02, etc.)
- [ ] Y-axis shows count of available properties
- [ ] Hovering shows exact counts
- [ ] Graph updates when filters change

### 4. Bookings Delta Report (New)
- [ ] Table appears between charts and main pricing table
- [ ] Column headers show actual dates (e.g., "Rooms (2025-10-29)" and "Rooms (2025-10-30)")
- [ ] Shows hotels with room decreases
- [ ] Data sorted by decrease (highest first)
- [ ] Sample row format: Hotel name, check-in, check-out, yesterday rooms, today rooms, decrease

### 5. Pricing Chart (Existing)
- [ ] Line chart loads with price trends
- [ ] Property selector works
- [ ] Quick Add Zenith button works
- [ ] Chart updates with selected properties

### 6. Comparison Table (Existing)
- [ ] Table shows pricing comparisons
- [ ] Delta vs Median column shows colors (red=above, green=below)
- [ ] "Send to AI" button responds

### 7. Integration Tests
- [ ] Change Type filter + Apply → all sections update
- [ ] Change Check-in date → availability graph and delta table update
- [ ] Select specific properties → pricing chart filters correctly
- [ ] All API calls succeed (check Network tab)

## API Test Results (Server-side verified)
- availability_by_night: 9 nights returned ✓
- bookings_delta: 100 rows returned (2025-10-29 → 2025-10-30) ✓
- price_points: 131 properties with pricing data ✓
- comparisons: 393 rows ✓

## Expected Console Output
Should be clean with no errors. If you see errors, capture them for debugging.

