コード例 #1
0
    $_POST['FK_printers'] = $_POST['ID'];
    unset($_POST['ID']);
    $query = "SELECT * \n             FROM `glpi_plugin_fusioninventory_printers`\n             WHERE `FK_printers`='" . $_POST['FK_printers'] . "' ";
    $result = $DB->query($query);
    $data = $DB->fetch_assoc($result);
    $_POST['ID'] = $data['ID'];
    $plugin_fusioninventory_printers->update($_POST);
} else {
    if (isset($_POST["GetRightModel"]) && isset($_POST['ID'])) {
        $plugin_fusioninventory_model_infos = new PluginFusioninventoryModelInfos();
        $plugin_fusioninventory_model_infos->getrightmodel($_POST['ID'], PRINTER_TYPE);
    }
}
if (isset($_POST['update_cartridges']) && isset($_POST['ID'])) {
    PluginFusioninventoryAuth::checkRight("snmp_printers", "w");
    $plugin_fusioninventory_printers_cartridges = new PluginFusioninventoryPrintersCartridges();
    $query = "SELECT * \n             FROM `glpi_plugin_fusioninventory_printers_cartridges`\n             WHERE `FK_printers`='" . $_POST['ID'] . "'\n                   AND `object_name`='" . $_POST['object_name'] . "' ";
    $result = $DB->query($query);
    if ($DB->numrows($result) == "0") {
        $_POST['FK_printers'] = $_POST['ID'];
        unset($_POST['ID']);
        $plugin_fusioninventory_printers_cartridges->add($_POST);
    } else {
        $data = $DB->fetch_assoc($result);
        $plugin_fusioninventory_printers_cartridges->update($_POST);
    }
}
$arg = "";
for ($i = 1; $i <= 5; $i++) {
    switch ($i) {
        case 1:
コード例 #2
0
 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);
     }
 }