} } else { //update cabinet $cab->FrontEdge = $_POST["airflow"]; $cab->UpdateCabinet(); } } exit; } if (isset($_POST['dc']) && (isset($_POST['getobjects']) || isset($_POST['getoverview']))) { $payload = array(); if (isset($_POST['getobjects'])) { $cab->DataCenterID = $_POST['dc']; $zone = new Zone(); $zone->DataCenterID = $cab->DataCenterID; $payload = array('cab' => $cab->ListCabinetsByDC(true), 'zone' => $zone->GetZonesByDC(true)); } else { $dc->DataCenterID = $_POST['dc']; $dc->GetDataCenterByID(); $payload = $dc->GetOverview(); } header('Content-Type: application/json'); echo json_encode($payload); exit; } if (!isset($_GET["dc"])) { // No soup for you. header('Location: ' . redirect()); exit; } $dc->DataCenterID = $_GET["dc"];
function AddDCToTree($lev = 0) { $dept = new Department(); $zone = new Zone(); $classType = "liClosed"; $tree = str_repeat(" ", $lev + 1) . "<li class=\"{$classType}\" id=\"dc{$this->DataCenterID}\"><a class=\"DC\" href=\"dc_stats.php?dc=" . "{$this->DataCenterID}\">{$this->Name}</a>\n"; $tree .= str_repeat(" ", $lev + 2) . "<ul>\n"; $zone->DataCenterID = $this->DataCenterID; $zoneList = $zone->GetZonesByDC(); while (list($zoneNum, $myzone) = each($zoneList)) { $tree .= str_repeat(" ", $lev + 3) . "<li class=\"liClosed\" id=\"zone{$myzone->ZoneID}\"><a class=\"ZONE\" href=\"zone_stats.php?zone=" . "{$myzone->ZoneID}\">{$myzone->Description}</a>\n"; $tree .= str_repeat(" ", $lev + 4) . "<ul>\n"; //Rows $sql = "SELECT CabRowID, Name AS Fila FROM fac_CabRow WHERE \n\t\t\t\tZoneID={$myzone->ZoneID} ORDER BY Fila;"; foreach ($this->query($sql) as $filaRow) { $tree .= str_repeat(" ", $lev + 5) . "<li class=\"liClosed\">" . "<a class=\"CABROW\" href=\"rowview.php?row={$filaRow['CabRowID']}\">" . __("Row ") . "{$filaRow['Fila']}</a>\n"; $tree .= str_repeat(" ", $lev + 6) . "<ul>\n"; // DataCenterID and ZoneID are redundant if fac_cabrow is defined and is CabrowID set in fac_cabinet $cabsql = "SELECT * FROM fac_Cabinet WHERE DataCenterID={$this->DataCenterID} \n\t\t\t\t\tAND ZoneID={$myzone->ZoneID} AND CabRowID={$filaRow['CabRowID']} ORDER \n\t\t\t\t\tBY Location REGEXP '^[A-Za-z]+\$', CAST(Location as SIGNED INTEGER),\n\t\t\t\t\tLocation;"; foreach ($this->query($cabsql) as $cabRow) { $tree .= str_repeat(" ", $lev + 7) . "<li id=\"cab{$cabRow['CabinetID']}\"><a class=\"RACK\" href=\"cabnavigator.php?cabinetid={$cabRow['CabinetID']}\">{$cabRow['Location']}</a></li>\n"; } $tree .= str_repeat(" ", $lev + 6) . "</ul>\n"; $tree .= str_repeat(" ", $lev + 5) . "</li>\n"; } //Cabinets without CabRowID $cabsql = "SELECT * FROM fac_Cabinet WHERE DataCenterID={$this->DataCenterID} AND \n\t\t\t\tZoneID={$myzone->ZoneID} AND CabRowID=0 ORDER BY Location ASC;"; foreach ($this->query($cabsql) as $cabRow) { $tree .= str_repeat(" ", $lev + 5) . "<li id=\"cab{$cabRow['CabinetID']}\"><a class=\"RACK\" href=\"cabnavigator.php?cabinetid={$cabRow['CabinetID']}\">{$cabRow['Location']}</a></li>\n"; } $tree .= str_repeat(" ", $lev + 4) . "</ul>\n"; $tree .= str_repeat(" ", $lev + 3) . "</li>\n"; } //zone //Cabinets without ZoneID $cabsql = "SELECT * FROM fac_Cabinet WHERE DataCenterID={$this->DataCenterID} AND \n\t\t\tZoneID=0 ORDER BY Location ASC;"; foreach ($this->query($cabsql) as $cabRow) { $tree .= str_repeat(" ", $lev + 3) . "<li id=\"cab{$cabRow['CabinetID']}\"><a class=\"RACK\" href=\"cabnavigator.php?cabinetid={$cabRow['CabinetID']}\">{$cabRow['Location']}</a></li>\n"; } //StorageRoom for this DC $tree .= str_repeat(" ", $lev + 3) . "<li id=\"sr-{$this->DataCenterID}\"><a href=\"storageroom.php?dc={$this->DataCenterID}\">" . __("Storage Room") . "</a></li>\n"; $tree .= str_repeat(" ", $lev + 2) . "</ul>\n"; $tree .= str_repeat(" ", $lev + 1) . "</li>\n"; return $tree; }