echo "<th colspan='3'>" . __('Duplicate computers', 'reports') . "</th></tr>\n";
if (Session::haveRight("config", "r")) {
// Check only read as we probably use the replicate (no 'w' in this case)
echo "<tr class='tab_bg_3 center'><td colspan='" . ($crit > 0 ? '3' : '2') . "'>";
echo "<a href='./doublons.config.php'>" . __('Report configuration', 'reports') . "</a></td></tr>\n";
}
echo "<tr class='tab_bg_1'><td class='right'>" . _n('Criterion', 'Criteria', 2) . "</td><td>";
echo "<select name='crit'>";
foreach ($crits as $key => $val) {
echo "<option value='{$key}'" . ($crit == $key ? "selected" : "") . ">{$val}</option>";
}
echo "</select></td>";
if ($crit > 0) {
echo "<td>";
//Add parameters to uri to be saved as bookmarks
$_SERVER["REQUEST_URI"] = buildBookmarkUrl($_SERVER["REQUEST_URI"], $crit);
Bookmark::showSaveButton(Bookmark::SEARCH, 'Computer');
echo "</td>";
}
echo "</tr>\n";
echo "<tr class='tab_bg_1 center'><td colspan='" . ($crit > 0 ? '3' : '2') . "'>";
echo "<input type='submit' value='valider' class='submit'/>";
echo "</td></tr>\n";
echo "</table>\n";
Html::closeForm();
if ($crit == 5) {
// Search Duplicate IP Address - From glpi_networking_ports
$IPBlacklist = "AA.`ip` != ''\n AND AA.`ip` != '0.0.0.0'";
if (TableExists("glpi_plugin_reports_doublons_backlists")) {
$res = $DB->query("SELECT `addr`\n FROM `glpi_plugin_reports_doublons_backlists`\n WHERE `type` = '2'");
while ($data = $DB->fetch_array($res)) {
function displaySearchForm()
{
global $_SERVER, $_GET, $LANG, $CFG_GLPI;
echo "<form action='" . $_SERVER["PHP_SELF"] . "' method='post'>";
echo "<table class='tab_cadre' cellpadding='5'>";
echo "<tr class='tab_bg_1' align='center'>";
echo "<td>";
echo $LANG["financial"][8] . " :";
$values = array();
$values["sup"] = ">";
$values["inf"] = "<";
$values["equal"] = "=";
if (isset($_GET["contains"][1])) {
if (strstr($_GET["contains"][1], "lt;")) {
$_GET["dropdown_sup_inf"] = "inf";
$_GET["dropdown_calendar"] = str_replace("lt;", "", $_GET["contains"][1]);
$_GET["dropdown_calendar"] = str_replace("&", "", $_GET["dropdown_calendar"]);
$_GET["dropdown_calendar"] = str_replace("\\", "", $_GET["dropdown_calendar"]);
$_GET["dropdown_calendar"] = str_replace("'", "", $_GET["dropdown_calendar"]);
$_GET["dropdown_calendar"] = str_replace(" 00:00:00", "", $_GET["dropdown_calendar"]);
$_GET["contains"][1] = "<" . $_GET["dropdown_calendar"];
}
if (strstr($_GET["contains"][1], "gt;")) {
$_GET["dropdown_sup_inf"] = "sup";
$_GET["dropdown_calendar"] = str_replace("gt;", "", $_GET["contains"][1]);
$_GET["dropdown_calendar"] = str_replace("&", "", $_GET["dropdown_calendar"]);
$_GET["dropdown_calendar"] = str_replace("\\", "", $_GET["dropdown_calendar"]);
$_GET["dropdown_calendar"] = str_replace("'", "", $_GET["dropdown_calendar"]);
$_GET["dropdown_calendar"] = str_replace(" 00:00:00", "", $_GET["dropdown_calendar"]);
$_GET["contains"][1] = ">" . $_GET["dropdown_calendar"];
}
if (strstr($_GET["contains"][1], "LIKE")) {
$_GET["dropdown_sup_inf"] = "equal";
$_GET["dropdown_calendar"] = str_replace("=", "", $_GET["contains"][1]);
$_GET["dropdown_calendar"] = str_replace("&", "", $_GET["dropdown_calendar"]);
$_GET["dropdown_calendar"] = str_replace("\\", "", $_GET["dropdown_calendar"]);
$_GET["dropdown_calendar"] = str_replace("'", "", $_GET["dropdown_calendar"]);
$_GET["dropdown_calendar"] = str_replace("%", "", $_GET["dropdown_calendar"]);
$_GET["dropdown_calendar"] = str_replace("LIKE ", "", $_GET["dropdown_calendar"]);
$_GET["contains"][1] = "LIKE '" . $_GET["dropdown_calendar"] . "%'";
}
}
Dropdown::showFromArray("dropdown_sup_inf", $values, array('value' => isset($_GET["dropdown_sup_inf"]) ? $_GET["dropdown_sup_inf"] : "sup"));
echo "</td>\n\t\t<td width='120'>";
showDateFormItem("dropdown_calendar", isset($_GET["dropdown_calendar"]) ? $_GET["dropdown_calendar"] : 0);
echo "</td>";
echo "<td>" . $LANG["common"][15] . "</td>";
echo "<td>";
Dropdown::show("Location", array('name' => "location", 'value' => isset($_GET["location"]) ? $_GET["location"] : ""));
echo "</td>";
// Display Reset search
echo "<td>";
echo "<a href='" . $CFG_GLPI["root_doc"] . "/plugins/fusioninventory/report/ports_date_connections.php?reset_search=reset_search' ><img title=\"" . $LANG["buttons"][16] . "\" alt=\"" . $LANG["buttons"][16] . "\" src='" . $CFG_GLPI["root_doc"] . "/pics/reset.png' class='calendrier'></a>";
echo "</td>";
echo "<td>";
//Add parameters to uri to be saved as bookmarks
$_SERVER["REQUEST_URI"] = buildBookmarkUrl($_SERVER["REQUEST_URI"], $_GET);
showSaveBookmarkButton(BOOKMARK_SEARCH, PLUGIN_FUSIONINVENTORY_SNMP_NETWORKING_PORTS2);
echo "</td>";
echo "<td>";
echo "<input type='submit' value='Valider' class='submit' />";
echo "</td>";
echo "</tr>";
echo "</table>";
echo "</form>";
}
function displaySearchForm()
{
global $_SERVER, $_GET, $CFG_GLPI;
echo "<form action='" . $_SERVER["PHP_SELF"] . "' method='post'>";
echo "<table class='tab_cadre' cellpadding='5'>";
echo "<tr class='tab_bg_1' align='center'>";
echo "<td>";
echo __('Initial contract period') . " :";
$values = array();
$values["sup"] = ">";
$values["inf"] = "<";
$values["equal"] = "=";
if (isset($_GET["contains"][1])) {
if (strstr($_GET["contains"][1], "lt;")) {
$_GET["dropdown_sup_inf"] = "inf";
$_GET["dropdown_calendar"] = str_replace("lt;", "", $_GET["contains"][1]);
$_GET["dropdown_calendar"] = str_replace("&", "", $_GET["dropdown_calendar"]);
$_GET["dropdown_calendar"] = str_replace("\\", "", $_GET["dropdown_calendar"]);
$_GET["dropdown_calendar"] = str_replace("'", "", $_GET["dropdown_calendar"]);
$_GET["dropdown_calendar"] = str_replace(" 00:00:00", "", $_GET["dropdown_calendar"]);
$_GET["contains"][1] = "<" . $_GET["dropdown_calendar"];
}
if (strstr($_GET["contains"][1], "gt;")) {
$_GET["dropdown_sup_inf"] = "sup";
$_GET["dropdown_calendar"] = str_replace("gt;", "", $_GET["contains"][1]);
$_GET["dropdown_calendar"] = str_replace("&", "", $_GET["dropdown_calendar"]);
$_GET["dropdown_calendar"] = str_replace("\\", "", $_GET["dropdown_calendar"]);
$_GET["dropdown_calendar"] = str_replace("'", "", $_GET["dropdown_calendar"]);
$_GET["dropdown_calendar"] = str_replace(" 00:00:00", "", $_GET["dropdown_calendar"]);
$_GET["contains"][1] = ">" . $_GET["dropdown_calendar"];
}
if (strstr($_GET["contains"][1], "LIKE")) {
$_GET["dropdown_sup_inf"] = "equal";
$_GET["dropdown_calendar"] = str_replace("=", "", $_GET["contains"][1]);
$_GET["dropdown_calendar"] = str_replace("&", "", $_GET["dropdown_calendar"]);
$_GET["dropdown_calendar"] = str_replace("\\", "", $_GET["dropdown_calendar"]);
$_GET["dropdown_calendar"] = str_replace("'", "", $_GET["dropdown_calendar"]);
$_GET["dropdown_calendar"] = str_replace("%", "", $_GET["dropdown_calendar"]);
$_GET["dropdown_calendar"] = str_replace("LIKE ", "", $_GET["dropdown_calendar"]);
$_GET["contains"][1] = "LIKE '" . $_GET["dropdown_calendar"] . "%'";
}
}
Dropdown::showFromArray("dropdown_sup_inf", $values, array('value' => isset($_GET["dropdown_sup_inf"]) ? $_GET["dropdown_sup_inf"] : "sup"));
echo "</td>\n <td width='120'>";
Html::showDateFormItem("dropdown_calendar", isset($_GET["dropdown_calendar"]) ? $_GET["dropdown_calendar"] : 0);
echo "</td>";
echo "<td>" . __('Location') . "</td>";
echo "<td>";
Dropdown::show("Location", array('name' => "location", 'value' => isset($_GET["location"]) ? $_GET["location"] : ""));
echo "</td>";
// Display Reset search
echo "<td>";
echo "<a href='" . $CFG_GLPI["root_doc"] . "/plugins/fusioninventory/report/ports_date_connections.php?reset_search=reset_search' ><img title=\"" . __('Blank') . "\" alt=\"" . __('Blank') . "\" src='" . $CFG_GLPI["root_doc"] . "/pics/reset.png' class='calendrier'></a>";
echo "</td>";
echo "<td>";
//Add parameters to uri to be saved as bookmarks
$_SERVER["REQUEST_URI"] = buildBookmarkUrl($_SERVER["REQUEST_URI"], $_GET);
Bookmark::showSaveButton(Bookmark::SEARCH, 'PluginFusioninventoryNetworkport2');
echo "</td>";
echo "<td>";
echo "<input type='submit' value='Valider' class='submit' />";
echo "</td>";
echo "</tr>";
echo "</table>";
Html::closeForm();
}
