function SearchByCustomTag($tag = null) { global $dbh; $sql = "SELECT a.* from fac_Cabinet a, fac_CabinetTags b, fac_Tags c WHERE \r\n\t\t\ta.CabinetID=b.CabinetID AND b.TagID=c.TagID AND UCASE(c.Name) LIKE \r\n\t\t\tUCASE('%" . sanitize($tag) . "%') ORDER BY LocationSortable;"; $cabinetList = array(); foreach ($dbh->query($sql) as $cabinetRow) { $cabID = $cabinetRow["CabinetID"]; $cabinetList[$cabID] = Cabinet::RowToObject($cabinetRow); } return $cabinetList; }
print " <option value=\"{$dc->DataCenterID}\">{$dc->Name}</option>\n"; } ?> </select> </div> <?php } else { $datacenter->DataCenterID = $_REQUEST['datacenterid']; $datacenter->GetDataCenter(); $cabinet->DataCenterID = $datacenter->DataCenterID; $DataCenterID = $datacenter->DataCenterID; $cabList = array(); $sql = "SELECT * FROM fac_Cabinet WHERE fac_Cabinet.DataCenterID={$DataCenterID} order by fac_Cabinet.Location;"; foreach ($dbh->query($sql) as $row) { $cabList[$row["CabinetID"]] = Cabinet::RowToObject($row); } print "<input type=\"hidden\" name=\"datacenterid\" value=\"{$datacenter->DataCenterID}\">\n"; print "<h3>" . __("Choose cabinets to print in Data Center") . ": {$datacenter->Name}<br>\n"; print "<input type=submit name=\"action\" value=\"" . __("Generate") . "\"><br>\n"; ?> <div class="table"> <div style="border-bottom: 1px solid black;"> <div><?php print __("Cabinet ID"); ?> </div> </div> <?php // because mpdf is so slow, selecting all cabinets in a big data center frequently times out - just disabling fo rnow