== Use-case 0010 - Browse Properties ==

'''Initiating actor:''' Client

'''Other actors:''' None

'''Description: '''

A client browses apartment units by first selecting a building, then viewing its floors, and finally exploring individual units. They can view details, images, and pricing information for each unit.

'''Scenario:'''

1. Client accesses the property listing page.

2. System displays all buildings:
{{{
SELECT 
    building_id,
    name,
    address,
    description
FROM building
ORDER BY name;
}}}

3. Client sees a list of buildings with their names, addresses, and brief descriptions.

4. Client clicks on "Golden Tower" building.

5. System displays the building details and all its floors:
{{{
SELECT 
    b.building_id,
    b.name AS building_name,
    b.address,
    b.description,
    a. full_name AS architect_name,
    f.floor_id,
    f.floor_number,
    f.layout_image
FROM building b
LEFT JOIN designs d ON b.building_id = d.building_id
LEFT JOIN architect a ON d.architect_id = a.architect_id
JOIN floor f ON b.building_id = f.building_id
WHERE b.name = 'Golden Tower'
ORDER BY f.floor_number;
}}}

6. Client sees building information and a list of floors with their images.

7. Client clicks on "Floor 2". 

8. All units on Floor 2 are displayed with minimal information:
{{{
SELECT 
    u.unit_id,
    u.unit_number,
    u.room_number,
    u.floor_area,
    u.price,
    u.status,
    u.image
FROM unit u
WHERE u.floor_id = (
    SELECT floor_id 
    FROM floor 
    WHERE building_id = (SELECT building_id FROM building WHERE name = 'Golden Tower')
    AND floor_number = 2
)
ORDER BY u.unit_number;
}}}

9. Client sees a list of units showing their respective minimal information:  unit number, room count, area, price, status, and thumbnail image.

10. Client clicks on "Unit 201" to view full details.

11. System displays complete unit information: 
{{{
SELECT 
    u. unit_id,
    u. unit_number,
    u. room_number,
    u. floor_area,
    u. price,
    u.status,
    u.image,
    u.floorplan,
    u.vector_image
FROM unit u
JOIN floor f ON u.floor_id = f. floor_id
JOIN building b ON f.building_id = b. building_id
WHERE u.unit_number = '201'
AND f.floor_number = 2
AND b.name = 'Golden Tower';
}}}

12. Client views all images, floorplan, building description, architect information, and pricing details.

13. Client can navigate back to floor view, building view, or click a button to inquire about the unit that is being displayed.