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
