Difference between revisions of "Where Are Floorplan Objects Stored"
(added note about multiple floorplan locations in each floorplan info device data) |
|||
(One intermediate revision by one other user not shown) | |||
Line 9: | Line 9: | ||
All FloorplanInfo is formatted FK_Floorplan,X-Coordinate,Y-Coordinate. | 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. | The floorplan background image is stored below the lmce-admin web directory. | ||
Floorplan objects show different colors based on their state. | 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 |
Latest revision as of 18:13, 20 November 2011
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