Where Are Floorplan Objects Stored

From LinuxMCE
Jump to: navigation, search

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