Session::checkCentralAccess();
// Make a select box
if ($_POST['items_id'] && $_POST['itemtype'] && class_exists($_POST['itemtype'])) {
$devicetype = $_POST['itemtype'];
$linktype = $devicetype::getItem_DeviceType();
if (count($linktype::getSpecificities())) {
$name_field = "CONCAT_WS(' - ', `" . implode('`, `', array_keys($linktype::getSpecificities())) . "`)";
} else {
$name_field = "`id`";
}
$query = "SELECT `id`, {$name_field} AS name\n FROM `" . $linktype::getTable() . "`\n WHERE `" . $devicetype::getForeignKeyField() . "` = '" . $_POST['items_id'] . "'\n AND `itemtype` = ''";
$result = $DB->request($query);
echo "<table width='100%'><tr><td>" . __('Choose an existing device') . "</td><td rowspan='2'>" . __('and/or') . "</td><td>" . __('Add new devices') . '</td></tr>';
echo "<tr><td>";
if ($result->numrows() == 0) {
echo __('No unaffected device !');
} else {
$devices = array();
foreach ($result as $row) {
$name = $row['name'];
if (empty($name)) {
$name = $row['id'];
}
$devices[$row['id']] = $name;
}
dropdown::showFromArray($linktype::getForeignKeyField(), $devices, array('multiple' => true));
}
echo "</td><td>";
Dropdown::showNumber('new_devices', array('min' => 0, 'max' => 10));
echo "</td></tr></table>";
}
