From e5c173de496fc99ca73e2da20152d11a3dd58018 Mon Sep 17 00:00:00 2001
From: Christian Klinger
Date: Tue, 9 Aug 2016 11:28:54 +0200
Subject: loading & saving of roomconfig.

---
 modules-available/roomplanner/page.inc.php | 91 ++++++++++++++++++++++++++++--
 1 file changed, 86 insertions(+), 5 deletions(-)

(limited to 'modules-available/roomplanner/page.inc.php')

diff --git a/modules-available/roomplanner/page.inc.php b/modules-available/roomplanner/page.inc.php
index 222192c1..b1869443 100644
--- a/modules-available/roomplanner/page.inc.php
+++ b/modules-available/roomplanner/page.inc.php
@@ -14,16 +14,36 @@ class Page_Roomplanner extends Page
 
     protected function doRender()
     {
+
         $locationid = Request::get('locationid', null, 'integer');
 
-        if ($locationid === null) {
-            die('please specify locationid');
-        }
+        if ($locationid === null) { die('please specify locationid'); }
 
+
+        $furniture      = $this->getFurniture($locationid);
         $subnetMachines = $this->getPotentialMachines($locationid);
+        $machinesOnPlan = $this->getMachinesOnPlan($locationid);
+
+        $action = Request::any('action', 'show', 'string');
+
+        $roomConfig = array_merge($furniture, $machinesOnPlan);
+
+
+        if ($action === 'show') {
+            /* do nothing */
+            Render::addTemplate('page', [
+                'subnetMachines' => json_encode($subnetMachines),
+                'locationid' => $locationid,
+                'roomConfiguration' => json_encode($roomConfig, JSON_PRETTY_PRINT)]);
+        } else if ($action === 'save') {
+            /* save */
+            $config = Request::post('serializedRoom', null, 'string');
+            $config = json_decode($config, true);
+            $this->saveRoomConfig($locationid, $config['furniture']);
+            $this->saveComputerConfig($locationid, $config['computers'], $machinesOnPlan);
+            Util::redirect("?do=roomplanner&locationid=$locationid&action=show");
+        }
 
-        Render::addTemplate('page', ['subnetMachines' => json_encode($subnetMachines),
-                                    ]);
     }
 
     protected function doAjax()
@@ -58,6 +78,67 @@ class Page_Roomplanner extends Page
         }
     }
 
+    protected function saveComputerConfig($locationid, $computers, $oldComputers) {
+
+        $oldUuids = [];
+        /* collect all uuids  from the old computers */
+        foreach($oldComputers['computers'] as $c) {
+            $oldUuids[] = $c['muuid'];
+        }
+
+        $newUuids = [];
+        foreach($computers as $computer) {
+            $newUuids[] =  $computer['muuid'];
+
+            $position = json_encode(['gridRow' => $computer['gridRow'],
+                                     'gridCol' => $computer['gridCol'],
+                                     'itemlook' => $computer['itemlook']], JSON_PRETTY_PRINT);
+
+            Database::exec('UPDATE machine SET position = :position, locationid = :locationid WHERE machineuuid = :muuid',
+            ['locationid' => $locationid, 'muuid' => $computer['muuid'], 'position' => $position]);
+        }
+
+        $toDelete = array_diff($oldUuids, $newUuids);
+
+        foreach($toDelete as $d) {
+            Database::exec("UPDATE machine SET position = '', locationid = NULL WHERE machineuuid = :uuid", ['uuid' => $d]);
+        }
+    }
+    protected function saveRoomConfig($locationid, $furniture) {
+        $obj = json_encode(['furniture' => $furniture], JSON_PRETTY_PRINT);
+        Database::exec('INSERT INTO location_roomplan (locationid, roomplan) VALUES (:locationid, :roomplan) ON DUPLICATE KEY UPDATE roomplan=:roomplan',
+            ['locationid' => $locationid,
+             'roomplan' => $obj]);
+    }
+
+    protected function getFurniture($locationid) {
+        $config = Database::queryFirst('SELECT roomplan FROM location_roomplan WHERE locationid = :locationid', ['locationid' => $locationid]);
+        if ($config == null) { return null; }
+        $config = json_decode($config['roomplan'], true);
+        return $config;
+    }
+    protected function getMachinesOnPlan($locationid) {
+        $result = Database::simpleQuery('SELECT machineuuid, macaddr, clientip, hostname, position FROM machine WHERE locationid = :locationid',
+            ['locationid' => $locationid]);
+        $machines = [];
+        while ($row = $result->fetch(PDO::FETCH_ASSOC)) {
+            $machine = [];
+            $pos = json_decode($row['position'], true);
+
+            $machine['muuid'] = $row['machineuuid'];
+            $machine['ip']      = $row['clientip'];
+            $machine['mac_address'] = $row['macaddr'];
+            $machine['hostname'] = $row['hostname'];
+            $machine['gridRow'] = (int) $pos['gridRow'];
+            $machine['gridCol'] = (int) $pos['gridCol'];
+            $machine['itemlook'] = $pos['itemlook'];
+            $machine['data-width'] = 100;
+            $machine['data-height'] = 100;
+            $machines[] = $machine;
+        }
+        return ['computers' => $machines];
+    }
+
     protected function getPotentialMachines($locationid)
     {
         $result = Database::simpleQuery('SELECT machineuuid, macaddr, clientip, hostname '
-- 
cgit v1.2.3-55-g7522