die("\nUsage : php -q -f rollbackocs.php --server=# [ --run=1 ]\n");
}
$DBocs = new DBocs($_GET["server"]);
echo "Connecting to " . $DBocs->dbhost . "\n";
if (!PluginOcsinventoryngOcsServer::checkOCSconnection($_GET["server"])) {
die("Failed connexion to OCS\n");
}
$run = isset($_GET["run"]) && $_GET["run"] > 0;
$debug = isset($_GET["debug"]) && $_GET["debug"] > 0;
// Find Last Machine ID + time
$sql = "SELECT *\n FROM `hardware`\n ORDER BY `ID` DESC\n LIMIT 0,1";
$res = $DBocs->query($sql);
if (!($res && $DBocs->numrows($res) > 0)) {
die("No data from OCS\n");
}
$data = $DBocs->fetch_array($res);
$maxid = $data["ID"];
$maxti = $data["LASTCOME"];
echo "Last new computer : " . $data["DEVICEID"] . " ({$maxid}, {$maxti})\n";
if (!$maxid) {
die("Bad value\n");
}
// Computer from OCS : New, ID Changed, Linked
$sql = "SELECT *\n FROM `glpi_logs`\n WHERE `date_mod` >= '{$maxti}'\n AND `itemtype` = 1\n AND `linked_action` IN (8,10,11)\n ORDER BY `id` DESC";
$res = $DB->query($sql);
if (!$res) {
die("No data from GLPI\n");
}
$comp = new Computer();
echo "Start\n";
$tabres = array();
function update068to0681()
{
global $DB, $CFG_GLPI;
if (TableExists("glpi_repair_item")) {
$query = "DROP TABLE `glpi_repair_item`";
$DB->queryOrDie($query, "0.68.1 drop glpi_repair_item");
}
$tables = array("computers", "monitors", "networking", "peripherals", "phones", "printers");
foreach ($tables as $tbl) {
if (isIndex("glpi_" . $tbl, "type")) {
$query = "ALTER TABLE `glpi_{$tbl}`\n DROP INDEX `type`";
$DB->queryOrDie($query, "0.68.1 drop index type glpi_{$tbl}");
}
if (isIndex("glpi_" . $tbl, "type_2")) {
$query = "ALTER TABLE `glpi_{$tbl}`\n DROP INDEX `type_2`";
$DB->queryOrDie($query, "0.68.1 drop index type_2 glpi_{$tbl}");
}
if (isIndex("glpi_" . $tbl, "model")) {
$query = "ALTER TABLE `glpi_{$tbl}`\n DROP INDEX `model`";
$DB->queryOrDie($query, "0.68.1 drop index model glpi_{$tbl}");
}
if (!isIndex("glpi_" . $tbl, "type")) {
$query = "ALTER TABLE `glpi_{$tbl}`\n ADD INDEX (`type`)";
$DB->queryOrDie($query, "0.68.1 add index type glpi_{$tbl}");
}
if (!isIndex("glpi_" . $tbl, "model")) {
$query = "ALTER TABLE `glpi_{$tbl}`\n ADD INDEX (`model`)";
$DB->queryOrDie($query, "0.68.1 add index model glpi_{$tbl}");
}
if (!isIndex("glpi_" . $tbl, "FK_groups")) {
$query = "ALTER TABLE `glpi_{$tbl}`\n ADD INDEX (`FK_groups`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_{$tbl}.FK_groups");
}
if (!isIndex("glpi_" . $tbl, "FK_users")) {
$query = "ALTER TABLE `glpi_{$tbl}`\n ADD INDEX ( `FK_users` )";
$DB->queryOrDie($query, "0.68.1 add index on glpi_{$tbl}.FK_users");
}
}
if (!isIndex("glpi_software", "FK_groups")) {
$query = "ALTER TABLE `glpi_software`\n ADD INDEX (`FK_groups`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_software.FK_groups");
}
if (!isIndex("glpi_software", "FK_users")) {
$query = "ALTER TABLE `glpi_software`\n ADD INDEX ( `FK_users` )";
$DB->queryOrDie($query, "0.68.1 add index on glpi_software.FK_users");
}
if (!isIndex("glpi_cartridges_type", "location")) {
$query = "ALTER TABLE `glpi_cartridges_type`\n ADD INDEX (`location`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_cartridges_type.location");
}
if (FieldExists("glpi_cartridges_type", "type", false)) {
$query = "ALTER TABLE `glpi_cartridges_type`\n CHANGE `type` `type` INT NOT NULL DEFAULT '0'";
$DB->queryOrDie($query, "0.68.1 alter glpi_cartridges_type.type");
}
if (!isIndex("glpi_cartridges_type", "type")) {
$query = "ALTER TABLE `glpi_cartridges_type`\n ADD INDEX (`type`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_cartridges_type.type");
}
if (!isIndex("glpi_cartridges_type", "alarm")) {
$query = "ALTER TABLE `glpi_cartridges_type`\n ADD INDEX (`alarm`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_cartridges_type.alarm");
}
if (!isIndex("glpi_computers", "os_sp")) {
$query = "ALTER TABLE `glpi_computers`\n ADD INDEX (`os_sp`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_computers.os_sp");
}
if (!isIndex("glpi_computers", "os_version")) {
$query = "ALTER TABLE `glpi_computers`\n ADD INDEX (`os_version`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_computers.os_version");
}
if (!isIndex("glpi_computers", "network")) {
$query = "ALTER TABLE `glpi_computers`\n ADD INDEX (`network`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_computers.network");
}
if (!isIndex("glpi_computers", "domain")) {
$query = "ALTER TABLE `glpi_computers`\n ADD INDEX (`domain`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_computers.domain");
}
if (!isIndex("glpi_computers", "auto_update")) {
$query = "ALTER TABLE `glpi_computers`\n ADD INDEX (`auto_update`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_computers.auto_update");
}
if (!isIndex("glpi_computers", "ocs_import")) {
$query = "ALTER TABLE `glpi_computers`\n ADD INDEX (`ocs_import`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_computers.ocs_import");
}
if (!isIndex("glpi_consumables", "id_user")) {
$query = "ALTER TABLE `glpi_consumables`\n ADD INDEX (`id_user`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_consumables.id_user");
}
if (!isIndex("glpi_consumables_type", "location")) {
$query = "ALTER TABLE `glpi_consumables_type`\n ADD INDEX (`location`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_consumables_type.location");
}
if (!isIndex("glpi_consumables_type", "type")) {
$query = "ALTER TABLE `glpi_consumables_type`\n ADD INDEX (`type`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_consumables_type.type");
}
if (!isIndex("glpi_consumables_type", "alarm")) {
$query = "ALTER TABLE `glpi_consumables_type`\n ADD INDEX (`alarm`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_consumables_type.alarm");
}
if (FieldExists("glpi_contacts", "type", false)) {
$query = "ALTER TABLE `glpi_contacts`\n CHANGE `type` `type` INT( 11 ) NULL ";
$DB->queryOrDie($query, "0.68.1 alter glpi_contacts.type");
}
if (!isIndex("glpi_contract_device", "device_type")) {
$query = "ALTER TABLE `glpi_contract_device`\n ADD INDEX (`device_type`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_contract_device.device_type");
}
if (!isIndex("glpi_contract_device", "is_template")) {
$query = "ALTER TABLE `glpi_contract_device`\n ADD INDEX (`is_template`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_contract_device.is_template");
}
if (!isIndex("glpi_device_hdd", "interface")) {
$query = "ALTER TABLE `glpi_device_hdd`\n ADD INDEX (`interface`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_device_hdd.interface");
}
if (!isIndex("glpi_device_ram", "type")) {
$query = "ALTER TABLE `glpi_device_ram`\n ADD INDEX (`type`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_device_ram.type");
}
if (!isIndex("glpi_display", "FK_users")) {
$query = "ALTER TABLE `glpi_display`\n ADD INDEX (`FK_users`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_display.FK_users");
}
if (!isIndex("glpi_docs", "FK_users")) {
$query = "ALTER TABLE `glpi_docs`\n ADD INDEX (`FK_users`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_docs.FK_users");
}
if (!isIndex("glpi_docs", "FK_tracking")) {
$query = "ALTER TABLE `glpi_docs`\n ADD INDEX (`FK_tracking`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_docs.FK_tracking");
}
if (!isIndex("glpi_doc_device", "device_type")) {
$query = "ALTER TABLE `glpi_doc_device`\n ADD INDEX (`device_type`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_doc_device.device_type");
}
if (!isIndex("glpi_dropdown_tracking_category", "parentID")) {
$query = "ALTER TABLE `glpi_dropdown_tracking_category`\n ADD INDEX (`parentID`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_dropdown_tracking_category.parentID");
}
if (!isIndex("glpi_history", "device_type")) {
$query = "ALTER TABLE `glpi_history`\n ADD INDEX (`device_type`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_history.device_type");
}
if (!isIndex("glpi_history", "device_internal_type")) {
$query = "ALTER TABLE `glpi_history`\n ADD INDEX (`device_internal_type`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_history.device_internal_type");
}
if (!isIndex("glpi_infocoms", "budget")) {
$query = "ALTER TABLE `glpi_infocoms`\n ADD INDEX (`budget`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_infocoms.budget");
}
if (!isIndex("glpi_infocoms", "alert")) {
$query = "ALTER TABLE `glpi_infocoms`\n ADD INDEX (`alert`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_infocoms.alert");
}
if (!isIndex("glpi_kbitems", "author")) {
$query = "ALTER TABLE `glpi_kbitems`\n ADD INDEX (`author`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_kbitems.author");
}
if (!isIndex("glpi_kbitems", "faq")) {
$query = "ALTER TABLE `glpi_kbitems`\n ADD INDEX (`faq`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_kbitems.faq");
}
if (!isIndex("glpi_licenses", "oem_computer")) {
$query = "ALTER TABLE `glpi_licenses`\n ADD INDEX (`oem_computer`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_licenses.oem_computer");
}
if (!isIndex("glpi_licenses", "oem")) {
$query = "ALTER TABLE `glpi_licenses`\n ADD INDEX (`oem`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_licenses.oem");
}
if (!isIndex("glpi_licenses", "buy")) {
$query = "ALTER TABLE `glpi_licenses`\n ADD INDEX (`buy`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_licenses.buy");
}
if (!isIndex("glpi_licenses", "serial")) {
$query = "ALTER TABLE `glpi_licenses`\n ADD INDEX (`serial`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_licenses.serial");
}
if (!isIndex("glpi_licenses", "expire")) {
$query = "ALTER TABLE `glpi_licenses`\n ADD INDEX (`expire`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_licenses.expire");
}
if (!isIndex("glpi_networking", "network")) {
$query = "ALTER TABLE `glpi_networking`\n ADD INDEX (`network`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_networking.network");
}
if (!isIndex("glpi_networking", "domain")) {
$query = "ALTER TABLE `glpi_networking`\n ADD INDEX (`domain`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_networking.domain");
}
if (!isIndex("glpi_networking_ports", "iface")) {
$query = "ALTER TABLE `glpi_networking_ports`\n ADD INDEX (`iface`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_networking_ports.iface");
}
if (FieldExists("glpi_phones", "power", false)) {
$query = "ALTER TABLE `glpi_phones`\n CHANGE `power` `power` INT NOT NULL DEFAULT '0'";
$DB->queryOrDie($query, "0.68.1 alter glpi_phones.power");
}
if (!isIndex("glpi_phones", "power")) {
$query = "ALTER TABLE `glpi_phones`\n ADD INDEX (`power`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_phones.power");
}
if (!isIndex("glpi_reminder", "begin")) {
$query = "ALTER TABLE `glpi_reminder`\n ADD INDEX (`begin`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_reminder.begin");
}
if (!isIndex("glpi_reminder", "end")) {
$query = "ALTER TABLE `glpi_reminder`\n ADD INDEX (`end`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_reminder.end");
}
if (!isIndex("glpi_software", "update_software")) {
$query = "ALTER TABLE `glpi_software`\n ADD INDEX (`update_software`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_software.update_software");
}
if (!isIndex("glpi_state_item", "state")) {
$query = "ALTER TABLE `glpi_state_item`\n ADD INDEX (`state`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_state_item.state");
}
if (!isIndex("glpi_tracking", "FK_group")) {
$query = "ALTER TABLE `glpi_tracking`\n ADD INDEX (`FK_group`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_tracking.FK_group");
}
if (!isIndex("glpi_tracking", "assign_ent")) {
$query = "ALTER TABLE `glpi_tracking`\n ADD INDEX (`assign_ent`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_tracking.assign_ent");
}
if (!isIndex("glpi_tracking", "device_type")) {
$query = "ALTER TABLE `glpi_tracking`\n ADD INDEX (`device_type`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_tracking.device_type");
}
if (!isIndex("glpi_tracking", "priority")) {
$query = "ALTER TABLE `glpi_tracking`\n ADD INDEX (`priority`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_tracking.priority");
}
if (!isIndex("glpi_tracking", "request_type")) {
$query = "ALTER TABLE `glpi_tracking`\n ADD INDEX (`request_type`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_tracking.request_type");
}
if (!isIndex("glpi_users", "location")) {
$query = "ALTER TABLE `glpi_users`\n ADD INDEX (`location`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_users.location");
}
if (!isIndex("glpi_printers", "network")) {
$query = "ALTER TABLE `glpi_printers`\n ADD INDEX (`network`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_printers.network");
}
if (!isIndex("glpi_printers", "domain")) {
$query = "ALTER TABLE `glpi_printers`\n ADD INDEX (`domain`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_printers.domain");
}
if (FieldExists("glpi_device_case", "format", false)) {
$query = "ALTER TABLE `glpi_device_case`\n CHANGE `format` `format` ENUM('Grand', 'Moyen', 'Micro', 'Slim', '')\n NULL DEFAULT 'Moyen'";
$DB->queryOrDie($query, "0.68.1 alter glpi_device_case.format");
}
if (FieldExists("glpi_device_gfxcard", "interface", false)) {
$query = "ALTER TABLE `glpi_device_gfxcard`\n CHANGE `interface` `interface` ENUM('AGP', 'PCI', 'PCI-X', 'Other', '')\n NULL DEFAULT 'AGP'";
$DB->queryOrDie($query, "0.68.1 alter glpi_device_gfxcard.interface");
}
// Add default values in GLPI_DROPDOWN_HDD_TYPE
// Rename glpi_dropdown HDD_TYPE -> INTERFACE
if (!TableExists("glpi_dropdown_interface")) {
$query = "ALTER TABLE `glpi_dropdown_hdd_type`\n RENAME `glpi_dropdown_interface` ";
$DB->queryOrDie($query, "0.68.1 alter dropdown_hdd_type -> dropdown_interface");
$values = array("SATA", "IDE", "SCSI", "USB");
$interfaces = array();
foreach ($values as $val) {
$query = "SELECT *\n FROM `glpi_dropdown_interface`\n WHERE `name` LIKE '{$val}'";
$result = $DB->query($query);
if ($DB->numrows($result) == 1) {
$row = $DB->fetch_array($result);
$interfaces[$val] = $row["ID"];
} else {
$query = "INSERT INTO `glpi_dropdown_interface`\n (`name`)\n VALUES ('{$val}');";
$DB->query($query);
$interfaces[$val] = $DB->insert_id();
}
}
// ALTER TABLES
$query = "ALTER TABLE `glpi_device_control`\n CHANGE `interface` `interface2` ENUM('IDE', 'SATA', 'SCSI', 'USB') NOT NULL\n DEFAULT 'IDE'";
$DB->queryOrDie($query, "0.68.1 alter device_control");
$query = "ALTER TABLE `glpi_device_drive`\n CHANGE `interface` `interface2` ENUM('IDE', 'SATA', 'SCSI') NOT NULL DEFAULT 'IDE'";
$DB->queryOrDie($query, "0.68.1 alter device_drive");
$query = "ALTER TABLE `glpi_device_control`\n ADD `interface` INT NULL ";
$DB->queryOrDie($query, "0.68.1 alter device_control");
$query = "ALTER TABLE `glpi_device_drive`\n ADD `interface` INT NULL ";
$DB->queryOrDie($query, "0.68.1 alter device_drive");
foreach ($interfaces as $name => $ID) {
$query = "UPDATE `glpi_device_drive`\n SET `interface` = '{$ID}'\n WHERE `interface2` = '{$name}'";
$DB->queryOrDie($query, "0.68.1 update data device_drive");
$query = "UPDATE `glpi_device_control`\n SET `interface` = '{$ID}'\n WHERE `interface2` = '{$name}'";
$DB->queryOrDie($query, "0.68.1 update data device_control");
}
// DROP TABLES
$query = "ALTER TABLE `glpi_device_control`\n DROP `interface2`";
$DB->queryOrDie($query, "0.68.1 drop interface2 device_drive");
$query = "ALTER TABLE `glpi_device_drive`\n DROP `interface2`";
$DB->queryOrDie($query, "0.68.1 drop interface2 device_drive");
// ADD INDEX
$query = "ALTER TABLE `glpi_device_drive`\n ADD INDEX (`interface`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_device_drive.interface");
$query = "ALTER TABLE `glpi_device_control`\n ADD INDEX (`interface`)";
$DB->queryOrDie($query, "0.68.1 add index on glpi_device_drive.interface");
}
if (FieldExists("glpi_profiles", "update", false)) {
$query = "ALTER TABLE `glpi_profiles`\n CHANGE `update` `check_update` CHAR( 1 ) NULL DEFAULT NULL";
$DB->queryOrDie($query, "0.68.1 alter glpi_profiles.update");
}
if (FieldExists("glpi_config", "last_update_check", false)) {
$query = "ALTER TABLE `glpi_config`\n DROP `last_update_check`";
$DB->queryOrDie($query, "0.68.1 drop glpi_config.last_update_check");
}
if (!FieldExists("glpi_config", "keep_tracking_on_delete", false)) {
$query = "ALTER TABLE `glpi_config`\n ADD `keep_tracking_on_delete` INT DEFAULT '1'";
$DB->queryOrDie($query, "0.68.1 drop glpi_config.keep_tracking_on_delete");
}
if (!FieldExists("glpi_config", "show_admin_doc", false)) {
$query = "ALTER TABLE `glpi_config`\n ADD `show_admin_doc` INT DEFAULT '0' ";
$DB->queryOrDie($query, "0.68.1 drop glpi_config.show_admin_doc");
}
if (!FieldExists("glpi_config", "time_step", false)) {
$query = "ALTER TABLE `glpi_config`\n ADD `time_step` INT DEFAULT '5' ";
$DB->queryOrDie($query, "0.68.1 drop glpi_config.time_step");
}
$query = "UPDATE `glpi_config`\n SET `time_step` = '5',\n `show_admin_doc` = '0',\n `keep_tracking_on_delete` = '0'";
$DB->queryOrDie($query, "0.68.1 update glpi_config data");
if (!FieldExists("glpi_ocs_config", "cron_sync_number", false)) {
$query = "ALTER TABLE `glpi_ocs_config`\n ADD `cron_sync_number` INT DEFAULT '1' ";
$DB->queryOrDie($query, "0.68.1 drop glpi_ocs_config.cron_sync_number");
}
if (!FieldExists("glpi_profiles", "show_group_ticket", false)) {
$query = "ALTER TABLE `glpi_profiles`\n ADD `show_group_ticket` char(1) DEFAULT '0' ";
$DB->queryOrDie($query, "0.68.1 drop glpi_profiles.show_group_ticket");
}
if (!FieldExists("glpi_config", "ldap_group_condition", false)) {
$query = "ALTER TABLE `glpi_config`\n ADD `ldap_group_condition` VARCHAR( 255 ) NULL ,\n ADD `ldap_search_for_groups` TINYINT NOT NULL DEFAULT '0',\n ADD `ldap_field_group_member` VARCHAR( 255 ) NULL ";
$DB->queryOrDie($query, "0.68.1 add glpi_config.ldap_*_groups");
}
if (!FieldExists("glpi_groups", "ldap_group_dn", false)) {
$query = "ALTER TABLE `glpi_groups`\n ADD `ldap_group_dn` VARCHAR( 255 ) NULL ";
$DB->queryOrDie($query, "0.68.1 add glpi_groups.ldap_group_dn");
}
if (!FieldExists("glpi_ocs_link", "ocs_deviceid", false)) {
$query = "ALTER TABLE `glpi_ocs_link`\n CHANGE `ocs_id` `ocs_deviceid` VARCHAR( 255 ) NOT NULL ";
$DB->queryOrDie($query, "0.68.1 add glpi_ocs_link.ocs_deviceid");
}
if (!FieldExists("glpi_ocs_link", "ocs_id", false)) {
$query = "ALTER TABLE `glpi_ocs_link`\n ADD `ocs_id` INT NOT NULL DEFAULT '0' AFTER `glpi_id` ";
$DB->queryOrDie($query, "0.68.1 add glpi_ocs_link.ocs_id");
}
if (!FieldExists("glpi_ocs_link", "last_ocs_update", false)) {
$query = "ALTER TABLE `glpi_ocs_link`\n ADD `last_ocs_update` DATETIME NULL AFTER `last_update` ";
$DB->queryOrDie($query, "0.68.1 add glpi_ocs_link.last_ocs_update");
}
if (countElementsInTable("glpi_ocs_link")) {
$CFG_GLPI["ocs_mode"] = 1;
$DBocs = new DBocs(1);
// Get datas to update
$query = "SELECT *\n FROM `glpi_ocs_link`";
$result_glpi = $DB->query($query);
while ($data_glpi = $DB->fetch_array($result_glpi)) {
// Get ocs information
$query_ocs = "SELECT *\n FROM `hardware`\n WHERE `DEVICEID` = '" . $data_glpi["ocs_deviceid"] . "'\n LIMIT 1";
$result_ocs = $DBocs->queryOrDie($query_ocs, "0.68.1 get ocs infos");
if ($result_ocs && $DBocs->numrows($result_ocs)) {
$data_ocs = $DBocs->fetch_array($result_ocs);
$query_update = "UPDATE `glpi_ocs_link`\n SET `ocs_id` = '" . $data_ocs["ID"] . "',\n `last_ocs_update` = '" . $data_ocs["LASTDATE"] . "'\n WHERE `ID` = '" . $data_glpi["ID"] . "'";
$DB->queryOrDie($query_update, "0.68.1 update ocs infos");
}
}
}
if (!TableExists("glpi_dropdown_case_type")) {
$query = "CREATE TABLE `glpi_dropdown_case_type` (\n `ID` int(11) NOT NULL auto_increment,\n `name` varchar(255) NOT NULL,\n `comments` text,\n PRIMARY KEY (`ID`),\n KEY `name` (`name`)\n ) ENGINE=MyISAM;";
$DB->queryOrDie($query, "0.68.1 add table dropdown_case_type");
// ajout du champs type
$query = "ALTER TABLE `glpi_device_case`\n ADD `type` INT(11) default NULL AFTER `designation` ";
$DB->queryOrDie($query, "0.68.1 add glpi_device_case.type");
// Ajout des entrees dans la table dropdown_case_type
$query = "INSERT INTO `glpi_dropdown_case_type`\n (`ID` , `name` , `comments`)\n VALUES ('1' , 'Grand', NULL)";
$DB->queryOrDie($query, "0.68.1 glpi_device_case");
$query = "INSERT INTO `glpi_dropdown_case_type`\n (`ID` , `name` , `comments`)\n VALUES ('2' , 'Moyen', NULL)";
$DB->queryOrDie($query, "0.68.1 glpi_device_case");
$query = "INSERT INTO `glpi_dropdown_case_type`\n (`ID` , `name` , `comments`)\n VALUES ('3' , 'Micro', NULL)";
$DB->queryOrDie($query, "0.68.1 glpi_device_case");
// Mapping format enum / type
$query = "UPDATE `glpi_device_case`\n SET `type` = '1'\n WHERE `format` = 'Grand'";
$DB->queryOrDie($query, "0.68.1 glpi_device_case");
$query = "UPDATE `glpi_device_case`\n SET `type` = '2'\n WHERE `format` = 'Moyen'";
$DB->queryOrDie($query, "0.68.1 glpi_device_case");
$query = "UPDATE `glpi_device_case`\n SET `type` = '3'\n WHERE `format` = 'Micro'";
$DB->queryOrDie($query, "0.68.1 glpi_device_case");
// Supression du champ format
$query = "ALTER TABLE `glpi_device_case`\n DROP `format`";
$DB->queryOrDie($query, "0.68.1 drop format from glpi_device_case");
}
// Clean state datas
if (TableExists("glpi_state_item")) {
$query = "SELECT COUNT(*) AS CPT, `device_type`, `id_device`\n FROM `glpi_state_item`\n GROUP BY `device_type`, `id_device`\n HAVING CPT > 1";
$result = $DB->query($query);
if ($DB->numrows($result)) {
while ($data = $DB->fetch_array($result)) {
$query2 = "DELETE\n FROM `glpi_state_item`\n WHERE `device_type` = '" . $data["device_type"] . "'\n AND `id_device` = '" . $data["id_device"] . "'\n LIMIT " . ($data["CPT"] - 1) . "";
$DB->queryOrDie($query2, "0.68.1 clean glpi_state_item");
}
}
if (isIndex("glpi_state_item", "device_type")) {
$query = "ALTER TABLE `glpi_state_item`\n DROP INDEX `device_type` ";
$DB->queryOrDie($query, "0.68.1 drop index glpi_state_item");
}
if (isIndex("glpi_state_item", "device_type2")) {
$query = "ALTER TABLE `glpi_state_item`\n DROP INDEX `device_type2` ";
$DB->queryOrDie($query, "0.68.1 drop index glpi_state_item");
}
$query = "ALTER TABLE `glpi_state_item`\n ADD INDEX (`device_type`) ";
$DB->queryOrDie($query, "0.68.1 add index glpi_state_item");
$query = "ALTER TABLE `glpi_state_item`\n ADD UNIQUE (`device_type`, `id_device`) ";
$DB->queryOrDie($query, "0.68.1 add unique glpi_state_item");
}
}
function glpiuImportPrinters($mode, $start = 0)
{
global $PRINTERSLIST, $UC_OCSIDS, $UC_NAMES, $CFG_GLPI, $LANG;
$DBocs = new DBocs($_SESSION["ocsservers_id"]);
$DB = new DB();
$noPort = 0;
$numrows = 0;
$UC_OCSIDS = array();
// Correspondance UC ocs/glpi
// Recherche les ports
$query_ports = "select distinct hardware.NAME as UC_Name, hardware.DEVICEID, printers.NAME, printers.PORT, printers.DRIVER from printers " . "inner join hardware on hardware.ID = printers.HARDWARE_ID where printers.DRIVER <> '' order by hardware.DEVICEID, printers.NAME, printers.PORT, printers.DRIVER";
$result_ports = $DBocs->query($query_ports) or die($DBocs->error());
if ($DBocs->numrows($result_ports) > 0) {
// Récupère les UC dans GLPI
$query_UC = "select distinct glpi_id, ocs_id from glpi_ocs_link order by glpi_id";
$result_UC = $DB->query($query_UC) or die($DB->error());
if ($DB->numrows($result_UC) > 0) {
while ($data = $DB->fetch_array($result_UC)) {
$UC_OCSIDS[$data["ocs_id"]] = array('glpi_id' => $data["glpi_id"], 'UC_Name' => '', 'driver' => '');
}
}
unset($result_UC);
// Recherche les UC liés à une imprimante dans OCS
$query_UC = "select distinct hardware.NAME as UC_Name, hardware.ID as ocs_id from hardware " . "inner join printers on printers.HARDWARE_ID = hardware.ID order by hardware.DEVICEID, hardware.NAME";
$result_UC = $DBocs->query($query_UC) or die($DBocs->error());
if ($DBocs->numrows($result_UC) > 0) {
while ($data = $DBocs->fetch_array($result_UC)) {
if (array_key_exists($data["ocs_id"], $UC_OCSIDS)) {
$UC_OCSIDS[$data["ocs_id"]]['UC_Name'] = strtoupper($data["UC_Name"]);
}
}
}
unset($result_UC);
// Suppression des UC sans imprimante
// création d'une table des UC avec nom pour clé
foreach ($UC_OCSIDS as $ocs_id => &$item) {
if ($item['UC_Name'] === '') {
unset($UC_OCSIDS[$ocs_id]);
} else {
$UC_NAMES[$item['UC_Name']] = array('glpi_id' => $item["glpi_id"], 'ocs_id' => $ocs_id);
}
}
unset($UC_OCSIDS);
// Création des imprimantes
while ($data = $DBocs->fetch_array($result_ports)) {
glpiuInsertPrinter($data["PORT"], $data["NAME"], $data["UC_Name"], $data["DRIVER"]);
}
unset($result_ports);
unset($UC_NAMES);
// Si en mode action, suppression des imprimantes
/*if ($mode == 1 && count($PRINTERSLIST) > 0)
{
processObjects(PRINTER_TYPE, DELETE_ACTION);
}*/
// Récupère les imprimantes dans GLPI
$printer_names = array();
if (count($PRINTERSLIST) > 0) {
$query_PRN = "select distinct ID, name from glpi_printers where deleted='0' ";
$result_PRN = $DB->query($query_PRN) or die($DB->error());
if ($DB->numrows($result_PRN) > 0) {
while ($data = $DB->fetch_array($result_PRN)) {
$printer_names[$data["name"]] = $data["ID"];
}
}
}
// Complétion des imprimantes et suppression de celles à ne pas importer
$numrows = 0;
foreach ($PRINTERSLIST as $prn_no => &$printer) {
if ($printer->portType <= PORT_TYPE_USB) {
$printer->getName();
if ($printer->server != '' && !isset($printer_names[$printer->name])) {
$numrows++;
} else {
unset($PRINTERSLIST[$prn_no]);
}
} else {
unset($PRINTERSLIST[$prn_no]);
}
}
unset($printer_names);
// Importation
if ($mode == 1 && isset($_POST['toimport'])) {
foreach ($_POST['toimport'] as $prn_no => $val) {
if ($val == "on") {
$PRINTERSLIST[$prn_no]->addToDB();
unset($PRINTERSLIST[$prn_no]);
$numrows--;
}
}
}
unset($_POST['toimport']);
// Affichage
echo "<div align='center'>";
if ($numrows) {
$readOnly = !haveRight("ocsng", "w");
$parameters = "objectType=" . PRINTER_TYPE . "&actionId=" . IMPORT_PRINTERS_ACTION;
printPager($start, $numrows, $_SERVER["PHP_SELF"], $parameters);
// delete end
array_splice($PRINTERSLIST, $start + $_SESSION["glpilist_limit"]);
// delete begin
if ($start > 0) {
array_splice($PRINTERSLIST, 0, $start);
}
echo "<form method='post' name='printer_form' id='printer_form' action='" . $_SERVER["PHP_SELF"] . "'>";
echo "<a href='" . $_SERVER["PHP_SELF"] . "' onclick= \"if ( markAllRows('printer_form') ) return false;\">" . $LANG["buttons"][18] . "</a> / <a href='" . $_SERVER["PHP_SELF"] . "' onclick= \"if ( unMarkAllRows('printer_form') ) return false;\">" . $LANG["buttons"][19] . "</a>";
echo "<input type='hidden' name='objectType' value='" . PRINTER_TYPE . "'>";
echo "<input type='hidden' name='actionId' value='" . IMPORT_PRINTERS_ACTION . "'>";
echo "<table class='tab_cadre'>";
if (!$readOnly) {
echo "<tr class='tab_bg_1'><th colspan=8><input class='submit' type='submit' name='do_action' value='" . $LANG["buttons"][37] . "'></th></tr>" . chr(10);
}
echo '<tr><th></th><th>Type</th><th>IP</th><th>Nom</th><th width="150px">Port</th><th>Serveurs</th><th>Files d\'impression</th><th>Erreurs</th></tr>' . chr(10);
foreach ($PRINTERSLIST as &$printer) {
$printer->display();
}
if (!$readOnly) {
echo "<tr class='tab_bg_1'><th colspan=8><input class='submit' type='submit' name='do_action' value='" . $LANG["buttons"][37] . "'></th></tr>" . chr(10);
}
echo "</table>";
//echo '<br>'.$numrows.'<br>';
echo "</form>";
printPager($start, $numrows, $_SERVER["PHP_SELF"], $parameters);
} else {
echo "<strong>" . $LANG["ocsng"][9] . "<br>";
echo "<a href='../index.php'>" . $LANG["buttons"][13] . "</a></strong>";
}
echo "</div>";
}
return $numrows;
}