Changes between Initial Version and Version 1 of UseCase0003PrototypeImplementation

Timestamp:

01/21/26 22:53:18 (5 days ago)

Author:

213257

Comment:

--

UseCase0003PrototypeImplementation

@@ +1 @@
+= Use-case 0003 Implementation - Create Unit Listing
+
+'''Initiating actor: ''' Admin
+
+'''Other actors:''' None
+
+'''Description:'''
+
+The admin adds new apartment units to the system after a floor has been created.  This includes entering all unit details such as unit number, room count, area, price, and uploading images. The unit becomes available for agents to show to clients.
+
+== Scenario
+
+=== Step 1
+
+'''User action:''' Admin navigates to building management. 
+
+'''Screenshot:''' [[Image(0003-1.png)]]
+
+=== Step 2
+
+'''System action:''' System displays all buildings managed by this admin.
+
+'''Query:'''
+{{{
+SET search_path TO project;
+
+SELECT building_id, name, address, description
+FROM building
+WHERE admin_id = (SELECT admin_id FROM admin WHERE name = 'Nikola')
+ORDER BY name;
+}}}
+
+'''Screenshot:''' [[Image(0003-2.png)]]
+
+* Note selecting an admin by name is only for the prototype, this design poses serious issues if used in a production application.
+
+=== Step 3
+
+'''User action:''' Admin selects "Golden Tower" building.
+
+'''Screenshot:''' [[Image(0003-3.png)]]
+
+=== Step 4
+
+'''System action: ''' System shows all floors in the selected building.
+
+'''Query:'''
+{{{
+SET search_path TO project;
+
+SELECT floor_id, floor_number, layout_image
+FROM floor
+WHERE building_id = (SELECT building_id FROM building WHERE name = 'Golden Tower')
+ORDER BY floor_number;
+}}}
+
+'''Screenshot:''' [[Image(0003-4.png)]]
+
+=== Step 5
+
+'''User action:''' Admin selects Floor 1 and clicks to add a new unit. 
+
+'''Screenshot:''' [[Image(0003-5.png)]]
+
+=== Step 6
+
+'''System action:''' System displays a form with fields: unit number, room number, floor area, price, status, images.
+
+'''Screenshot:''' [[Image(0003-6.png)]]
+
+=== Step 7
+
+'''User action: ''' Admin enters unit details:
+* Unit Number: 104
+* Room Number:  2
+* Floor Area: 90 m²
+* Price: 150000 EUR
+* Status: Available
+* Uploads images (unit image, floorplan, vector image)
+
+'''Screenshot:''' [[Image(0003-7.png)]]
+
+=== Step 8
+
+'''User action:''' Admin submits the form. 
+
+'''Screenshot:''' [[Image(0003-8.png)]]
+
+=== Step 9
+
+'''System action:''' System validates that unit number doesn't already exist.
+
+'''Query:'''
+{{{
+SET search_path TO project;
+
+SELECT COUNT(*) 
+FROM unit 
+WHERE floor_id = (
+    SELECT floor_id FROM floor 
+    WHERE building_id = (SELECT building_id FROM building WHERE name = 'Golden Tower') 
+    AND floor_number = 1
+) 
+AND unit_number = '104';
+}}}
+
+=== Step 10
+
+'''System action:''' System inserts the new unit.
+
+'''Query:'''
+{{{
+SET search_path TO project;
+
+INSERT INTO unit(unit_number, room_number, floor_area, status, price, image, floorplan, vector_image, floor_id, admin_id)
+VALUES (
+    '104',
+    2,
+    82.50,
+    'Available',
+    95000.00,
+    'unit_104.jpg',
+    'plan_104.pdf',
+    'vector_104.svg',
+    (SELECT floor_id FROM floor 
+     WHERE building_id = (SELECT building_id FROM building WHERE name = 'Golden Tower') 
+     AND floor_number = 1),
+    (SELECT admin_id FROM admin WHERE name = 'Nikola')
+);
+}}}
+
+=== Step 11
+
+'''System action:''' System confirms successful creation and displays the unit details.
+
+'''Screenshot:''' [[Image(0003-9.png)]]