static function clean_db()
{
global $DB;
$ptp = new PluginFusioninventoryPort();
$pti = new PluginFusioninventoryIfaddr();
$ptn = new PluginFusioninventoryNetworking2();
$ptpr = new PluginFusioninventoryPrinters();
$ptpc = new PluginFusioninventoryPrintersCartridges();
$ptph = new PluginFusioninventoryPrintersHistory();
// * Clean glpi_plugin_fusioninventory_networking_ports
$query_select = "SELECT `glpi_plugin_fusioninventory_networking_ports`.`ID`\n FROM `glpi_plugin_fusioninventory_networking_ports`\n LEFT JOIN `glpi_networking_ports`\n ON `glpi_networking_ports`.`ID` = `FK_networking_ports`\n LEFT JOIN `glpi_networking` ON `glpi_networking`.`ID` = `on_device`\n WHERE `glpi_networking`.`ID` IS NULL";
$result = $DB->query($query_select);
while ($data = $DB->fetch_array($result)) {
$ptp->deleteFromDB($data["ID"], 1);
}
// * Clean glpi_plugin_fusioninventory_networking_ifaddr
$query_select = "SELECT `glpi_plugin_fusioninventory_networking_ifaddr`.`ID`\n FROM `glpi_plugin_fusioninventory_networking_ifaddr`\n LEFT JOIN `glpi_networking` ON `glpi_networking`.`ID` = `FK_networking`\n WHERE `glpi_networking`.`ID` IS NULL";
$result = $DB->query($query_select);
while ($data = $DB->fetch_array($result)) {
$pti->deleteFromDB($data["ID"], 1);
}
// * Clean glpi_plugin_fusioninventory_networking
$query_select = "SELECT `glpi_plugin_fusioninventory_networking`.`ID`\n FROM `glpi_plugin_fusioninventory_networking`\n LEFT JOIN `glpi_networking` ON `glpi_networking`.`ID` = `FK_networking`\n WHERE `glpi_networking`.`ID` IS NULL";
$result = $DB->query($query_select);
while ($data = $DB->fetch_array($result)) {
$ptn->deleteFromDB($data["ID"], 1);
}
// * Clean glpi_plugin_fusioninventory_printers
$query_select = "SELECT `glpi_plugin_fusioninventory_printers`.`ID`\n FROM `glpi_plugin_fusioninventory_printers`\n LEFT JOIN `glpi_printers` ON `glpi_printers`.`ID` = `FK_printers`\n WHERE `glpi_printers`.`ID` IS NULL";
$result = $DB->query($query_select);
while ($data = $DB->fetch_array($result)) {
$ptpr->deleteFromDB($data["ID"], 1);
}
// * Clean glpi_plugin_fusioninventory_printers_cartridges
$query_select = "SELECT `glpi_plugin_fusioninventory_printers_cartridges`.`ID`\n FROM `glpi_plugin_fusioninventory_printers_cartridges`\n LEFT JOIN `glpi_printers` ON `glpi_printers`.`ID` = `FK_printers`\n WHERE `glpi_printers`.`ID` IS NULL";
$result = $DB->query($query_select);
while ($data = $DB->fetch_array($result)) {
$ptpc->deleteFromDB($data["ID"], 1);
}
// * Clean glpi_plugin_fusioninventory_printers_history
$query_select = "SELECT `glpi_plugin_fusioninventory_printers_history`.`ID`\n FROM `glpi_plugin_fusioninventory_printers_history`\n LEFT JOIN `glpi_printers` ON `glpi_printers`.`ID` = `FK_printers`\n WHERE `glpi_printers`.`ID` IS NULL";
$result = $DB->query($query_select);
while ($data = $DB->fetch_array($result)) {
$ptph->deleteFromDB($data["ID"], 1);
}
}
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with GLPI; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
------------------------------------------------------------------------
*/
// ----------------------------------------------------------------------
// Original Author of file: David DURIEUX
// Purpose of file:
// ----------------------------------------------------------------------
define('GLPI_ROOT', '../../..');
include GLPI_ROOT . "/inc/includes.php";
checkRight("printer", "r");
PluginFusioninventoryAuth::checkRight("snmp_printers", "r");
$printer_history = new PluginFusioninventoryPrintersHistory();
if (isset($_POST['delete'])) {
PluginFusioninventoryAuth::checkRight("snmp_printers", "w");
if (isset($_POST['limit'])) {
for ($i = 0; $i < $_POST['limit']; $i++) {
if (isset($_POST["checked_{$i}"]) && $_POST["checked_{$i}"] == 1) {
if (isset($_POST["ID_{$i}"])) {
$input['ID'] = $_POST["ID_{$i}"];
}
$printer_history->delete($input);
}
}
}
}
glpi_header($_SERVER['HTTP_REFERER']);
function plugin_headings_fusioninventory_printerHistory($type, $ID)
{
$print_history = new PluginFusioninventoryPrintersHistory();
$print_history->showForm(GLPI_ROOT . '/plugins/fusioninventory/front/printer_history.form.php', $_GET["ID"]);
}
