Difference between revisions of "Where Are Floorplan Objects Stored"

From LinuxMCE
Jump to: navigation, search
(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

  1. reorder the Page numbers in table Floorplan
  2. rename the files in /home/pluto/floorplans/instXXXXX
  3. translate the Page component in all triplets in DD 10
  4. also taking care of overlaps between the old and the new set