# V3 Pricing Report - Test Summary

## Changes Made
1. Updated `report_pricing.php` to dynamically fetch latest query_date from database (2025-10-30)
2. Set default checkin filter to today's date (2025-11-01) to display upcoming availability
3. Query date range defaults to latest 14 days of query_date data

## Database Status
- properties.query_date: 2025-05-25 to 2025-10-30
- properties.checkin: 2025-05-25 to 2025-12-08  
- room_details.query_date: 2025-10-30 only
- room_details.checkin: 2025-12-07 to 2025-12-08

## API Test Results
### price_points (ci=2025-12-07, limitW=5)
- Returns 131 series with pricing data
- Sample: Vienna House (76.29 EUR/night for 2025-12-07)

### comparisons (ci=2025-12-06, limitW=5)  
- Returns 393 rows
- Data available for future checkin dates

## Browser Test Checklist
1. Open: https://mssql.danmarcrm.com/hotel/v3/report_pricing.php
2. Verify default dates populate:
   - Query Date From: 2025-10-16
   - Query Date To: 2025-10-30
   - Check-in: 2025-11-01 (today)
3. Click "Apply" button
4. Verify chart loads with price-per-night data
5. Verify table shows comparison data
6. Check F12 console for JavaScript errors
7. Test with ci=2025-12-07 to see Dec data

## Expected Results
- Chart shows pricing trends for upcoming windows
- Table displays properties with median comparisons
- No JavaScript console errors
- Data displays for checkin dates >= 2025-11-01

