Where Are Floorplan Objects Stored
Floorplans are a very nice way to visualize where devices are located, and what there current status is.
Floorplan objects are stored in various tables around the system.
- EntertainmentArea contain FloorplanInfo as coordinates.
- Rooms contain FloorplanInfo as coordinates
- All other locations are stored in DeviceData type Floorplan Info (FK_DeviceData = 10)
All FloorplanInfo is formatted FK_Floorplan,X-Coordinate,Y-Coordinate.
Each device, which can be placed on a floorplan, has this triplet of FK_Floorplan, X and Y-coordinates for EACH floorplan that exists in the system. For example, if there are two floorplans, and a device is only on the first floorplan the IK_DeviceData for FK_DeviceData 10 looks like this:
1,595,820,2,-1,-1
No visibility for floorplan 2, but positioned on 595x and 820y on floorplan 1.
The floorplan background image is stored below the lmce-admin web directory.
Floorplan objects show different colors based on their state.
Changing Floorplan Order
- reorder the Page numbers in table Floorplan
- rename the files in /home/pluto/floorplans/instXXXXX
- translate the Page component in all triplets in DD 10
- also taking care of overlaps between the old and the new set