path: root/modules-available/roomplanner/page.inc.php

<?php

class Page_Roomplanner extends Page
{
    protected function doPreprocess()
    {
        User::load();

        if (!User::hasPermission('superadmin')) {
            Message::addError('main.no-permission');
            Util::redirect('?do=Main');
        }
    }

    protected function doRender()
    {

        $locationid = Request::get('locationid', null, 'integer');

        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)]);
        } 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");
        }

    }

    protected function doAjax()
    {
        $action = Request::get('action', null, 'string');

        if ($action === 'getmachines') {
            $query = Request::get('query', null, 'string');

            /* the query could be anything: UUID, IP or macaddr */
//			$result = Database::simpleQuery('SELECT machineuuid, macaddr, clientip, hostname '
//				. ', MATCH (machineuuid, macaddr, clientip, hostname) AGAINST (:query) AS relevance '
//				. 'FROM machine '
//				. 'WHERE MATCH (machineuuid, macaddr, clientip, hostname) AGAINST (:query) '
//				. 'ORDER BY relevance DESC '
//				. 'LIMIT 5'
//				, ['query' => $query]);
//
            $result = Database::simpleQuery('SELECT machineuuid, macaddr, clientip, hostname '
                .'FROM machine '
                .'WHERE machineuuid LIKE :query '
                .' OR macaddr  	 LIKE :query '
                .' OR clientip    LIKE :query '
                .' OR hostname	 LIKE :query ', ['query' => "%$query%"]);

            $returnObject = ['machines' => []];

            while ($row = $result->fetch(PDO::FETCH_ASSOC)) {
                $returnObject['machines'][] = $row;
            }
            echo json_encode($returnObject);
        }
    }

    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']]);

            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]);
        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 === false) {
        	  return array();
        }
        $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);
			  // TODO: Check if pos is valid (has required keys)

            $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 '
            .'FROM machine INNER JOIN subnet ON (INET_ATON(clientip) BETWEEN startaddr AND endaddr) '
            .'WHERE subnet.locationid = :locationid', ['locationid' => $locationid]);

        $machines = [];

        while ($row = $result->fetch(PDO::FETCH_ASSOC)) {
            $row['combined'] = implode(' ', array_values($row));
            $machines[] = $row;
        }

        return $machines;
    }
}