static function install(Migration $migration) { global $DB, $GENINVENTORYNUMBER_TYPES; $table = getTableForItemType(__CLASS__); if (TableExists("glpi_plugin_geninventorynumber_fields")) { //Only migrate itemtypes when it's only necessary, otherwise it breaks upgrade procedure ! $migration->renameTable("glpi_plugin_geninventorynumber_fields", $table); } if (!TableExists($table)) { $query = "CREATE TABLE IF NOT EXISTS `{$table}` (\n `id` int(11) NOT NULL auto_increment,\n `plugin_geninventorynumber_configs_id` int(11) NOT NULL default '0',\n `itemtype` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',\n `template` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',\n `is_active` tinyint(1) NOT NULL default '0',\n `use_index` tinyint(1) NOT NULL default '0',\n `index` bigint(20) NOT NULL default '0',\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM CHARSET=utf8 COLLATE=utf8_unicode_ci;"; $DB->query($query); } else { $migration->changeField($table, 'ID', 'id', 'autoincrement'); $migration->changeField($table, 'config_id', 'plugin_geninventorynumber_configs_id', 'integer'); if ($migration->changeField($table, 'device_type', 'itemtype', 'string')) { $migration->migrationOneTable($table); Plugin::migrateItemType(array(), array("glpi_displaypreferences"), array($table)); } $migration->changeField($table, 'enabled', 'is_active', 'boolean'); $migration->changeField($table, 'use_index', 'use_index', 'boolean'); $migration->migrationOneTable($table); } $field = new self(); foreach ($GENINVENTORYNUMBER_TYPES as $type) { if (!countElementsInTable($table, "`itemtype`='{$type}'")) { $input["plugin_geninventorynumber_configs_id"] = 1; $input["itemtype"] = $type; $input["template"] = "<#######>"; $input["is_active"] = 0; $input["index"] = 0; $field->add($input); } } }
/** * Install or update containers * * @param Migration $migration Migration instance * @param string $version Plugin current version * * @return boolean */ static function install(Migration $migration, $version) { global $DB; $obj = new self(); $table = $obj->getTable(); if (!TableExists($table)) { $migration->displayMessage(sprintf(__("Installing %s"), $table)); $query = "CREATE TABLE IF NOT EXISTS `{$table}` (\n `id` INT(11) NOT NULL auto_increment,\n `name` VARCHAR(255) DEFAULT NULL,\n `label` VARCHAR(255) DEFAULT NULL,\n `itemtypes` LONGTEXT DEFAULT NULL,\n `type` VARCHAR(255) DEFAULT NULL,\n `subtype` VARCHAR(255) DEFAULT NULL,\n `entities_id` INT(11) NOT NULL DEFAULT '0',\n `is_recursive` TINYINT(1) NOT NULL DEFAULT '0',\n `is_active` TINYINT(1) NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`),\n KEY `entities_id` (`entities_id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;"; $DB->query($query) or die($DB->error()); } // multiple itemtype for one container if (!FieldExists($table, "itemtypes")) { $migration->changeField($table, 'itemtype', 'itemtypes', 'longtext'); $migration->migrationOneTable($table); $query = "UPDATE `{$table}` SET `itemtypes` = CONCAT('[\"', `itemtypes`, '\"]')"; $DB->query($query) or die($DB->error()); } //add display preferences for this class $d_pref = new DisplayPreference(); $found = $d_pref->find("itemtype = '" . __CLASS__ . "'"); if (count($found) == 0) { for ($i = 2; $i <= 5; $i++) { $DB->query("REPLACE INTO glpi_displaypreferences VALUES\n (NULL, '" . __CLASS__ . "', {$i}, " . ($i - 1) . ", 0)"); } } if (!FieldExists($table, "subtype")) { $migration->addField($table, 'subtype', 'VARCHAR(255) DEFAULT NULL', array('after' => 'type')); $migration->migrationOneTable($table); } $migration->displayMessage(__("Updating generated containers files", "fields")); // -> 0.90-1.3: generated class moved // OLD path: GLPI_ROOT."/plugins/fields/inc/$class_filename" // NEW path: PLUGINFIELDS_CLASS_PATH . "/$class_filename" $obj = new self(); $containers = $obj->find(); foreach ($containers as $container) { //First, drop old fields from plugin directories $itemtypes = count($container['itemtypes']) > 0 ? json_decode($container['itemtypes'], true) : array(); foreach ($itemtypes as $itemtype) { $class_filename = strtolower($itemtype . preg_replace('/s$/', '', $container['name']) . ".class.php"); if (file_exists(GLPI_ROOT . "/plugins/fields/inc/{$class_filename}")) { unlink(GLPI_ROOT . "/plugins/fields/inc/{$class_filename}"); } $injclass_filename = strtolower($itemtype . preg_replace('/s$/', '', $container['name']) . "injection.class.php"); if (file_exists(GLPI_ROOT . "/plugins/fields/inc/{$injclass_filename}")) { unlink(GLPI_ROOT . "/plugins/fields/inc/{$injclass_filename}"); } } //Second, create new files self::generateTemplate($container); } return true; }
public static function install(Migration $migration) { global $DB; $table = getTableForItemType(__CLASS__); if (!TableExists($table) && !TableExists("glpi_dropdown_plugin_order_taxes")) { $migration->displayMessage("Installing {$table}"); //Install $query = "CREATE TABLE `glpi_plugin_order_ordertaxes` (\n `id` int(11) NOT NULL auto_increment,\n `name` varchar(255) collate utf8_unicode_ci default NULL,\n `comment` text collate utf8_unicode_ci,\n PRIMARY KEY (`id`),\n KEY `name` (`name`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;"; $DB->query($query) or die($DB->error()); $taxes = new self(); foreach (array('20', '5.5', '19.6') as $tax) { $taxes->add(array('name' => $tax)); } } else { //Update $migration->displayMessage("Migrating {$table}"); //1.2.0 $migration->renameTable("glpi_dropdown_plugin_order_taxes", $table); $migration->changeField($table, "ID", "id", "int(11) NOT NULL auto_increment"); $migration->changeField($table, "name", "name", "varchar(255) collate utf8_unicode_ci default NULL"); $migration->changeField($table, "comments", "comment", "text collate utf8_unicode_ci"); $migration->migrationOneTable($table); //Remplace , by . in taxes foreach ($DB->request("SELECT `name` FROM `{$table}`") as $data) { if (strpos($data["name"], ',')) { $name = str_replace(',', '.', $data["name"]); $query = "UPDATE `{$table}`\n SET `name` = '" . $name . "'\n WHERE `name`= '" . $data["name"] . "'"; $DB->query($query) or die($DB->error()); } } } }
function plugin_mreporting_install() { global $DB; //get version $plugin = new Plugin(); $found = $plugin->find("name = 'mreporting'"); $plugin_mreporting = array_shift($found); //init migration $migration = new Migration($plugin_mreporting['version']); //create profiles table $queries = array(); $queries[] = "CREATE TABLE IF NOT EXISTS `glpi_plugin_mreporting_profiles` (\n `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,\n `profiles_id` VARCHAR(45) NOT NULL,\n `reports` CHAR(1),\n `config` CHAR(1),\n PRIMARY KEY (`id`)\n )\n ENGINE = MyISAM;"; //create configuration table $queries[] = "CREATE TABLE IF NOT EXISTS `glpi_plugin_mreporting_configs` (\n `id` int(11) NOT NULL auto_increment,\n `name` varchar(255) collate utf8_unicode_ci default NULL,\n `classname` varchar(255) collate utf8_unicode_ci default NULL,\n `is_active` tinyint(1) NOT NULL default '0',\n `is_notified` tinyint(1) NOT NULL default '1',\n `show_graph` tinyint(1) NOT NULL default '0',\n `show_area` tinyint(1) NOT NULL default '0',\n `spline` tinyint(1) NOT NULL default '0',\n `show_label` VARCHAR(10) default NULL,\n `flip_data` tinyint(1) NOT NULL default '0',\n `unit` VARCHAR(10) default NULL,\n `default_delay` VARCHAR(10) default NULL,\n `condition` VARCHAR(255) default NULL,\n `graphtype` VARCHAR(255) default 'GLPI',\n PRIMARY KEY (`id`),\n KEY `is_active` (`is_active`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;"; $queries[] = "CREATE TABLE IF NOT EXISTS `glpi_plugin_mreporting_preferences` (\n `id` int(11) NOT NULL auto_increment,\n `users_id` int(11) NOT NULL default 0,\n `template` varchar(255) collate utf8_unicode_ci default NULL,\n PRIMARY KEY (`id`),\n KEY `users_id` (`users_id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;"; // add display preferences $query_display_pref = "SELECT id \n FROM glpi_displaypreferences\n WHERE itemtype = 'PluginMreportingConfig'"; $res_display_pref = $DB->query($query_display_pref); if ($DB->numrows($res_display_pref) == 0) { $queries[] = "INSERT INTO `glpi_displaypreferences` \n VALUES (NULL,'PluginMreportingConfig','2','2','0');"; $queries[] = "INSERT INTO `glpi_displaypreferences` \n VALUES (NULL,'PluginMreportingConfig','3','3','0');"; $queries[] = "INSERT INTO `glpi_displaypreferences` \n VALUES (NULL,'PluginMreportingConfig','4','4','0');"; $queries[] = "INSERT INTO `glpi_displaypreferences` \n VALUES (NULL,'PluginMreportingConfig','5','5','0');"; $queries[] = "INSERT INTO `glpi_displaypreferences` \n VALUES (NULL,'PluginMreportingConfig','6','6','0');"; $queries[] = "INSERT INTO `glpi_displaypreferences` \n VALUES (NULL,'PluginMreportingConfig','8','8','0');"; } $queries[] = "CREATE TABLE IF NOT EXISTS `glpi_plugin_mreporting_notifications` (\n `id` int(11) NOT NULL auto_increment,\n `entities_id` int(11) NOT NULL default '0',\n `is_recursive` tinyint(1) NOT NULL default '0',\n `name` varchar(255) collate utf8_unicode_ci default NULL,\n `notepad` longtext collate utf8_unicode_ci,\n `date_envoie` DATE DEFAULT NULL,\n `notice`INT(11) NOT NULL DEFAULT 0,\n `alert` INT(11) NOT NULL DEFAULT 0,\n `comment` text collate utf8_unicode_ci,\n `date_mod` datetime default NULL,\n `is_deleted` tinyint(1) NOT NULL default '0',\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;"; foreach ($queries as $query) { $DB->query($query); } // == Update to 2.1 == if (!FieldExists('glpi_plugin_mreporting_configs', 'is_notified')) { $migration->addField('glpi_plugin_mreporting_configs', 'is_notified', 'tinyint(1) NOT NULL default "1"', array('after' => 'is_active')); $migration->migrationOneTable('glpi_plugin_mreporting_configs'); } require_once "inc/profile.class.php"; PluginMreportingProfile::createFirstAccess($_SESSION['glpiactiveprofile']['id']); $rep_files_mreporting = GLPI_PLUGIN_DOC_DIR . "/mreporting"; if (!is_dir($rep_files_mreporting)) { mkdir($rep_files_mreporting); } $notifications_folder = GLPI_PLUGIN_DOC_DIR . "/mreporting/notifications"; if (!is_dir($notifications_folder)) { mkdir($notifications_folder); } require_once "inc/notification.class.php"; PluginMreportingNotification::install(); CronTask::Register('PluginMreportingNotification', 'SendNotifications', MONTH_TIMESTAMP); require_once "inc/baseclass.class.php"; require_once "inc/common.class.php"; require_once "inc/config.class.php"; $config = new PluginMreportingConfig(); $config->createFirstConfig(); return true; }
static function install(Migration $migration) { global $DB; if (!$DB->query("CREATE TABLE IF NOT EXISTS `glpi_plugin_talk_userprefs` (\n `id` INT(11) NOT NULL auto_increment,\n `users_id` INT(11) NOT NULL default '0',\n `talk_tab` TINYINT(1) NOT NULL default '1',\n `old_tabs` TINYINT(1) NOT NULL default '1',\n `split_view` TINYINT(1) NOT NULL default '0',\n PRIMARY KEY (`id`),\n UNIQUE KEY (`users_id`),\n KEY `talk_tab` (`talk_tab`),\n KEY `split_view` (`split_view`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci")) { return false; } if (!FieldExists('glpi_plugin_talk_userprefs', 'old_tabs')) { $migration->addField('glpi_plugin_talk_userprefs', 'old_tabs', 'bool'); $migration->migrationOneTable('glpi_plugin_talk_userprefs'); } }
static function install(Migration $migration) { global $DB; $table = getTableForItemType(__CLASS__); if (!TableExists($table)) { $query = "CREATE TABLE IF NOT EXISTS `{$table}` (\n `id` INT(11) NOT NULL AUTO_INCREMENT,\n `plugin_itilcategorygroups_categories_id` INT(11) NOT NULL DEFAULT '0',\n `level` TINYINT(1) NOT NULL DEFAULT '0',\n `itilcategories_id` INT(11) NOT NULL DEFAULT '0',\n `groups_id` INT(11) NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`),\n UNIQUE KEY `group_lvl_unicity` (plugin_itilcategorygroups_categories_id, level, groups_id),\n KEY `plugin_itilcategorygroups_categories_id` (`plugin_itilcategorygroups_categories_id`),\n KEY `level` (`level`),\n KEY `itilcategories_id` (`itilcategories_id`),\n KEY `groups_id` (`groups_id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;"; $DB->query($query); } $parent_table = "glpi_plugin_itilcategorygroups_categories"; //we must migrate groups datas in sub table if (FieldExists($parent_table, 'groups_id_levelone')) { $all_lvl = $cat_groups = array(); //foreach old levels foreach (array(1 => 'one', 2 => 'two', 3 => 'three', 4 => 'four') as $lvl_num => $lvl_str) { $query = "SELECT id, itilcategories_id, groups_id_level{$lvl_str} FROM {$parent_table}"; $res = $DB->query($query); while ($data = $DB->fetch_assoc($res)) { //specific case (all group of this lvl), store it for further treatment if ($data["groups_id_level{$lvl_str}"] == -1) { $all_lvl[$data['itilcategories_id']][$lvl_num] = $lvl_str; } if ($data["groups_id_level{$lvl_str}"] > 0) { $cat_groups[] = array('plugin_itilcategorygroups_categories_id' => $data['id'], 'level' => $lvl_num, 'itilcategories_id' => $data['itilcategories_id'], 'groups_id' => $data["groups_id_level{$lvl_str}"]); } } //insert "all groups for this lvl' foreach ($all_lvl as $itilcategories_id => $lvl) { foreach ($lvl as $lvl_num => $lvl_str) { $DB->query("UPDATE {$parent_table} SET view_all_lvl{$lvl_num} = 1\n WHERE itilcategories_id = {$itilcategories_id}"); } } //insert groups in sub table foreach ($cat_groups as $cat_groups_data) { $DB->query("REPLACE INTO glpi_plugin_itilcategorygroups_categories_groups\n (plugin_itilcategorygroups_categories_id,\n level,\n itilcategories_id,\n groups_id)\n VALUES (\n " . $cat_groups_data['plugin_itilcategorygroups_categories_id'] . ",\n " . $cat_groups_data['level'] . ",\n " . $cat_groups_data['itilcategories_id'] . ",\n " . $cat_groups_data['groups_id'] . "\n )"); } } //drop migrated fields $migration->dropField($parent_table, "groups_id_levelone"); $migration->dropField($parent_table, "groups_id_leveltwo"); $migration->dropField($parent_table, "groups_id_levelthree"); $migration->dropField($parent_table, "groups_id_levelfour"); $migration->migrationOneTable($parent_table); } return true; }
static function install(Migration $migration) { global $DB; $table = getTableForItemType(__CLASS__); if (!TableExists($table) && !TableExists("glpi_dropdown_plugin_order_payment")) { $migration->displayMessage("Installing {$table}"); $query = "CREATE TABLE `glpi_plugin_order_orderpayments` (\n `id` int(11) NOT NULL auto_increment,\n `name` varchar(255) collate utf8_unicode_ci default NULL,\n `comment` text collate utf8_unicode_ci,\n PRIMARY KEY (`id`),\n KEY `name` (`name`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;"; $DB->query($query) or die($DB->error()); } else { $migration->displayMessage("Upgrading {$table}"); //1.2.0 $migration->renameTable("glpi_dropdown_plugin_order_payment", $table); $migration->changeField($table, "ID", "id", "int(11) NOT NULL auto_increment"); $migration->changeField($table, "name", "name", "varchar(255) collate utf8_unicode_ci default NULL"); $migration->changeField($table, "comments", "comment", "text collate utf8_unicode_ci"); $migration->migrationOneTable($table); } }
function plugin_winadminpassword_install() { global $DB; $migration = new Migration(100); if (!TableExists("glpi_plugin_winadminpassword_profiles")) { $query_profile = "CREATE TABLE IF NOT EXISTS `glpi_plugin_winadminpassword_profiles` (\n\t `id` int(11) NOT NULL,\n\t `profile` varchar(255) default NULL,\n\t `use` tinyint(1) default 0,\n\t PRIMARY KEY (`id`)\n\t ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci"; $DB->queryOrDie($query_profile, $DB->error()); $migration->migrationOneTable("glpi_plugin_winadminpassword_profiles"); // Give right to current Profile include_once GLPI_ROOT . '/plugins/winadminpassword/inc/profile.class.php'; $prof = new PluginWinadminpasswordProfile(); $prof->add(array('id' => $_SESSION['glpiactiveprofile']['id'], 'profile' => $_SESSION['glpiactiveprofile']['name'], 'use' => 1)); } if (!TableExists("glpi_plugin_winadminpassword_configs")) { $query = "CREATE TABLE IF NOT EXISTS `glpi_plugin_winadminpassword_configs` (\n\t `id` int(11) NOT NULL auto_increment,\n\t `key` varchar(255) collate utf8_unicode_ci default NULL,\n\t\t\t\t`length` int(11) default 12,\n\t\t\t\t`algo` int(11) default 1,\n\t\t\t\t`size` int(11) default 14,\n\t\t\t\t`color` varchar(255) collate utf8_unicode_ci,\n\t PRIMARY KEY (`id`)\n\t ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci"; $DB->queryOrDie($query, $DB->error()); } $migration->executeMigration(); return true; }
function plugin_escalation_install() { global $DB; if (!TableExists("glpi_plugin_escalation_groups_groups")) { $empty_sql = "plugin_escalation-empty.sql"; $DB_file = GLPI_ROOT . "/plugins/escalation/install/mysql/{$empty_sql}"; $DBf_handle = fopen($DB_file, "rt"); $sql_query = fread($DBf_handle, filesize($DB_file)); fclose($DBf_handle); foreach (explode(";\n", "{$sql_query}") as $sql_line) { if (Toolbox::get_magic_quotes_runtime()) { $sql_line = Toolbox::stripslashes_deep($sql_line); } if (!empty($sql_line)) { $DB->query($sql_line); } } } else { if (!TableExists("glpi_plugin_escalation_configs")) { $DB->query("CREATE TABLE `glpi_plugin_escalation_configs` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `entities_id` int(11) NOT NULL DEFAULT '0',\n `unique_assigned` varchar(255) DEFAULT NULL,\n `workflow` varchar(255) DEFAULT NULL,\n `limitgroup` varchar(255) DEFAULT NULL,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;"); $DB->query("INSERT INTO `glpi_plugin_escalation_configs`\n (`id` ,`entities_id` ,`unique_assigned` ,`workflow`, `limitgroup`)\n VALUES (NULL , '0', '0', '0', '0');"); } if (!TableExists("glpi_plugin_escalation_profiles")) { $DB->query("CREATE TABLE `glpi_plugin_escalation_profiles` (\n `profiles_id` int(11) NOT NULL DEFAULT '0',\n `bypassworkflow` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,\n `copyticket` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,\n `copyticketonworkflow` char(1) COLLATE utf8_unicode_ci DEFAULT NULL\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;"); } if (!FieldExists('glpi_plugin_escalation_profiles', 'copyticket')) { $DB->query("ALTER TABLE `glpi_plugin_escalation_profiles` \n ADD `copyticket` CHAR( 1 ) NULL "); $DB->query("ALTER TABLE `glpi_plugin_escalation_profiles` \n ADD `copyticketonworkflow` CHAR( 1 ) NULL "); } if (!FieldExists("glpi_plugin_escalation_configs", "limitgroup")) { $migration = new Migration(PLUGIN_ESCALATION_VERSION); $migration->addField('glpi_plugin_escalation_configs', "limitgroup", "varchar(255) DEFAULT NULL"); $migration->migrationOneTable('glpi_plugin_escalation_configs'); $DB->query("UPDATE `glpi_plugin_escalation_configs` \n SET `limitgroup` = '0' WHERE `entities_id` =1"); } } return true; }
static function install(Migration $migration) { global $DB; $obj = new self(); $table = $obj->getTable(); if (!TableExists($table)) { $migration->displayMessage("Installing {$table}"); $query = "CREATE TABLE IF NOT EXISTS `{$table}` (\n `id` INT(11) NOT NULL auto_increment,\n `name` VARCHAR(255) DEFAULT NULL,\n `label` VARCHAR(255) DEFAULT NULL,\n `itemtype` VARCHAR(255) DEFAULT NULL,\n `type` VARCHAR(255) DEFAULT NULL,\n `subtype` VARCHAR(255) DEFAULT NULL,\n `entities_id` INT(11) NOT NULL DEFAULT '0',\n `is_recursive` TINYINT(1) NOT NULL DEFAULT '0',\n `is_active` TINYINT(1) NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`),\n KEY `entities_id` (`entities_id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;"; $DB->query($query) or die($DB->error()); } //add display preferences for this class $d_pref = new DisplayPreference(); $found = $d_pref->find("itemtype = '" . __CLASS__ . "'"); if (count($found) == 0) { for ($i = 2; $i <= 5; $i++) { $DB->query("INSERT INTO glpi_displaypreferences VALUES\n (NULL, '" . __CLASS__ . "', {$i}, " . ($i - 1) . ", 0)"); } } if (!FieldExists($table, "subtype")) { $migration->addField($table, 'subtype', 'VARCHAR(255) DEFAULT NULL', array('after' => 'type')); $migration->migrationOneTable($table); } return true; }
public static function install(Migration $migration) { global $DB; $table = getTableForItemType(__CLASS__); //Installation if (!TableExists($table) && !TableExists("glpi_plugin_order")) { $migration->displayMessage("Installing {$table}"); $query = "CREATE TABLE IF NOT EXISTS `glpi_plugin_order_orders` (\n `id` int(11) NOT NULL auto_increment,\n `entities_id` int(11) NOT NULL default '0',\n `is_template` tinyint(1) NOT NULL default '0',\n `template_name` varchar(255) collate utf8_unicode_ci default NULL,\n `is_recursive` tinyint(1) NOT NULL default '0',\n `name` varchar(255) collate utf8_unicode_ci default NULL,\n `num_order` varchar(255) collate utf8_unicode_ci default NULL,\n `budgets_id` int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_budgets (id)',\n `plugin_order_ordertaxes_id` int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_plugin_order_ordertaxes (id)',\n `plugin_order_orderpayments_id` int (11) NOT NULL default '0' COMMENT 'RELATION to glpi_plugin_order_orderpayments (id)',\n `order_date` date default NULL,\n `duedate` date default NULL,\n `deliverydate` date default NULL,\n `is_late` tinyint(1) NOT NULL default '0',\n `suppliers_id` int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_suppliers (id)',\n `contacts_id` int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_contacts (id)',\n `locations_id` int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_locations (id)',\n `plugin_order_orderstates_id` int(11) NOT NULL default 1,\n `plugin_order_billstates_id` int(11) NOT NULL default 1,\n `port_price` float NOT NULL default 0,\n `comment` text collate utf8_unicode_ci,\n `notepad` longtext collate utf8_unicode_ci,\n `is_deleted` tinyint(1) NOT NULL default '0',\n `users_id` int(11) NOT NULL default '0',\n `groups_id` int(11) NOT NULL default '0',\n `users_id_delivery` int(11) NOT NULL default '0',\n `groups_id_delivery` int(11) NOT NULL default '0',\n `plugin_order_ordertypes_id` int (11) NOT NULL default '0' COMMENT 'RELATION to glpi_plugin_order_ordertypes (id)',\n `date_mod` datetime default NULL,\n `is_helpdesk_visible` tinyint(1) NOT NULL default '1',\n PRIMARY KEY (`id`),\n KEY `name` (`name`),\n KEY `entities_id` (`entities_id`),\n KEY `plugin_order_ordertaxes_id` (`plugin_order_ordertaxes_id`),\n KEY `plugin_order_orderpayments_id` (`plugin_order_orderpayments_id`),\n KEY `states_id` (`plugin_order_orderstates_id`),\n KEY `suppliers_id` (`suppliers_id`),\n KEY `contacts_id` (`contacts_id`),\n KEY `locations_id` (`locations_id`),\n KEY `is_late` (`locations_id`),\n KEY `is_template` (`is_template`),\n KEY `is_deleted` (`is_deleted`),\n KEY date_mod (date_mod)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;"; $DB->query($query) or die($DB->error()); Crontask::Register(__CLASS__, 'computeLateOrders', HOUR_TIMESTAMP, array('param' => 24, 'mode' => CronTask::MODE_EXTERNAL)); } else { //Upgrade $migration->displayMessage("Upgrading {$table}"); if (TableExists('glpi_plugin_order')) { //Update to 1.1.0 $migration->addField('glpi_plugin_order', "port_price", "FLOAT NOT NULL default '0'"); $migration->addField('glpi_plugin_order', "taxes", "FLOAT NOT NULL default '0'"); if (FieldExists("glpi_plugin_order", "numordersupplier")) { foreach ($DB->request("glpi_plugin_order") as $data) { $query = "INSERT INTO `glpi_plugin_order_suppliers`\n (`ID`, `FK_order`, `numorder`, `numbill`) VALUES\n (NULL, '" . $data["ID"] . "', '" . $data["numordersupplier"] . "', '" . $data["numbill"] . "') "; $DB->query($query) or die($DB->error()); } } $migration->dropField('glpi_plugin_order', 'numordersupplier'); $migration->dropField('glpi_plugin_order', 'numbill'); $migration->migrationOneTable('glpi_plugin_order'); } //1.2.0 $domigration_itemtypes = false; if ($migration->renameTable("glpi_plugin_order", $table)) { $domigration_itemtypes = true; } $migration->changeField($table, "ID", "id", "int(11) NOT NULL AUTO_INCREMENT"); $migration->changeField($table, "FK_entities", "entities_id", "int(11) NOT NULL default 0"); $migration->changeField($table, "recursive", "is_recursive", "tinyint(1) NOT NULL default 0"); $migration->changeField($table, "name", "name", "varchar(255) collate utf8_unicode_ci default NULL"); $migration->changeField($table, "budget", "budgets_id", "int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_budgets (id)'"); $migration->changeField($table, "numorder", "num_order", "varchar(255) collate utf8_unicode_ci default NULL"); $migration->changeField($table, "taxes", "plugin_order_ordertaxes_id", "int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_plugin_order_ordertaxes (id)'"); $migration->changeField($table, "payment", "plugin_order_orderpayments_id", "int (11) NOT NULL default '0' COMMENT 'RELATION to glpi_plugin_order_orderpayments (id)'"); $migration->changeField($table, "date", "order_date", "date default NULL"); $migration->changeField($table, "FK_enterprise", "suppliers_id", "int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_suppliers (id)'"); $migration->changeField($table, "FK_contact", "contacts_id", "int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_contacts (id)'"); $migration->changeField($table, "location", "locations_id", "int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_locations (id)'"); $migration->changeField($table, "status", "states_id", "int(11) NOT NULL default '0'"); $migration->changeField($table, "comment", "comment", "text collate utf8_unicode_ci"); $migration->changeField($table, "notes", "notepad", "longtext collate utf8_unicode_ci"); $migration->changeField($table, "deleted", "is_deleted", "tinyint(1) NOT NULL default '0'"); $migration->addKey($table, "name"); $migration->addKey($table, "entities_id"); $migration->addKey($table, "plugin_order_ordertaxes_id"); $migration->addKey($table, "plugin_order_orderpayments_id"); $migration->addKey($table, "states_id"); $migration->addKey($table, "suppliers_id"); $migration->addKey($table, "contacts_id"); $migration->addKey($table, "locations_id"); $migration->addKey($table, "is_deleted"); $migration->migrationOneTable($table); //Only migrate itemtypes when it's only necessary, otherwise it breaks upgrade procedure ! if ($domigration_itemtypes) { Plugin::migrateItemType(array(3150 => 'PluginOrderOrder'), array("glpi_bookmarks", "glpi_bookmarks_users", "glpi_displaypreferences", "glpi_documents_items", "glpi_infocoms", "glpi_logs", "glpi_tickets"), array()); } if (TableExists("glpi_plugin_order_budgets")) { //Manage budgets (here because class has been remove since 1.4.0) $migration->changeField("glpi_plugin_order_budgets", "ID", "id", " int(11) NOT NULL auto_increment"); $migration->changeField("glpi_plugin_order_budgets", "FK_entities", "entities_id", "int(11) NOT NULL default '0'"); $migration->changeField("glpi_plugin_order_budgets", "FK_budget", "budgets_id", "int(11) NOT NULL default '0'"); $migration->changeField("glpi_plugin_order_budgets", "comments", "comment", "text collate utf8_unicode_ci"); $migration->changeField("glpi_plugin_order_budgets", "deleted", "is_deleted", "tinyint(1) NOT NULL default '0'"); $migration->changeField("glpi_plugin_order_budgets", "startdate", "start_date", "date default NULL"); $migration->changeField("glpi_plugin_order_budgets", "enddate", "end_date", "date default NULL"); $migration->changeField("glpi_plugin_order_budgets", "value", "value", "float NOT NULL DEFAULT '0'"); $migration->addKey("glpi_plugin_order_budgets", "entities_id"); $migration->addKey("glpi_plugin_order_budgets", "is_deleted"); $migration->migrationOneTable("glpi_plugin_order_budgets"); Plugin::migrateItemType(array(3153 => 'PluginOrderBudget'), array("glpi_bookmarks", "glpi_bookmarks_users", "glpi_displaypreferences", "glpi_documents_items", "glpi_infocoms", "glpi_logs", "glpi_tickets"), array()); //Manage budgets migration before dropping the table $budget = new Budget(); $matchings = array('budgets_id' => 'id', 'name' => 'name', 'start_date' => 'begin_date', 'end_date' => 'end_date', 'value' => 'value', 'comment' => 'comment', 'entities_id' => 'entities_id', 'is_deleted' => 'is_deleted'); foreach (getAllDatasFromTable("glpi_plugin_order_budgets") as $data) { $tmp = array(); $id = false; foreach ($matchings as $old => $new) { if (!is_null($data[$old])) { $tmp[$new] = $data[$old]; } } $tmp['comment'] = Toolbox::addslashes_deep($tmp['comment']); //Budget already exists in the core: update it if ($budget->getFromDB($data['budgets_id'])) { $budget->update($tmp); $id = $tmp['id']; } else { //Budget doesn't exists in the core: create it unset($tmp['id']); $id = $budget->add($tmp); } } $DB->query("DROP TABLE `glpi_plugin_order_budgets`"); foreach (array('glpi_displaypreferences', 'glpi_documents_items', 'glpi_bookmarks', 'glpi_logs') as $t) { $DB->query("DELETE FROM `{$t}` WHERE `itemtype` = 'PluginOrderBudget'"); } } //1.3.0 $migration->addField($table, "plugin_order_ordertypes_id", "int (11) NOT NULL default '0' COMMENT 'RELATION to glpi_plugin_order_ordertypes (id)'"); $migration->migrationOneTable($table); //1.4.0 if ($migration->changeField("glpi_plugin_order_orders", "states_id", "plugin_order_orderstates_id", "int(11) NOT NULL default 1")) { $migration->migrationOneTable($table); $query = "UPDATE `glpi_plugin_order_orders` SET `plugin_order_orderstates_id`=`plugin_order_orderstates_id`+1"; $DB->query($query) or die($DB->error()); } $migration->addField($table, "duedate", "DATETIME NULL"); $migration->migrationOneTable($table); //1.5.0 if (TableExists("glpi_dropdown_plugin_order_status")) { $DB->query("DROP TABLE `glpi_dropdown_plugin_order_status`") or die($DB->error()); } if (TableExists("glpi_plugin_order_mailing")) { $DB->query("DROP TABLE IF EXISTS `glpi_plugin_order_mailing`;") or die($DB->error()); } $migration->addField($table, 'plugin_order_billstates_id', "int(11) NOT NULL default 0"); //1.5.2 $migration->addField($table, 'deliverydate', "DATETIME NULL"); $migration->addField($table, "is_late", "TINYINT(1) NOT NULL DEFAULT '0'"); $migration->addKey($table, "is_late"); if (!countElementsInTable('glpi_crontasks', "`name`='computeLateOrders'")) { Crontask::Register(__CLASS__, 'computeLateOrders', HOUR_TIMESTAMP, array('param' => 24, 'mode' => CronTask::MODE_EXTERNAL)); } $migration->migrationOneTable($table); if ($migration->addField($table, "is_template", "tinyint(1) NOT NULL DEFAULT 0")) { $migration->addField($table, "template_name", "VARCHAR(255) collate utf8_unicode_ci default NULL"); $migration->migrationOneTable($table); } $migration->addField($table, "users_id", "INT(11) NOT NULL DEFAULT '0'"); $migration->addField($table, "groups_id", "INT(11) NOT NULL DEFAULT '0'"); $migration->addField($table, "users_id_delivery", "INT(11) NOT NULL DEFAULT '0'"); $migration->addField($table, "groups_id_delivery", "INT(11) NOT NULL DEFAULT '0'"); //1.7.0 $migration->addField($table, "date_mod", "datetime"); $migration->addKey($table, "date_mod"); //1.7.2 $migration->addField($table, "is_helpdesk_visible", "bool", array('value' => 1)); $migration->migrationOneTable($table); //Displayprefs $prefs = array(1 => 1, 2 => 2, 4 => 4, 5 => 5, 6 => 6, 7 => 7, 10 => 10); foreach ($prefs as $num => $rank) { if (!countElementsInTable("glpi_displaypreferences", "`itemtype`='PluginOrderOrder' AND `num`='{$num}'\n AND `users_id`='0'")) { $DB->query("INSERT INTO glpi_displaypreferences\n VALUES (NULL,'PluginOrderOrder','{$num}','{$rank}','0');"); } } //Remove unused notifications $notification = new Notification(); $notification->deleteByCriteria("`itemtype`='PluginOrderOrder_Item'"); } }
public static function install(Migration $migration) { global $DB; $table = getTableForItemType(__CLASS__); $config = new self(); //This class is available since version 1.3.0 if (!TableExists($table) && !TableExists("glpi_plugin_order_config")) { $migration->displayMessage("Installing {$table}"); //Install $query = "CREATE TABLE `{$table}` (\n `id` int(11) NOT NULL auto_increment,\n `use_validation` tinyint(1) NOT NULL default '0',\n `use_supplier_satisfaction` tinyint(1) NOT NULL default '0',\n `use_supplier_informations` tinyint(1) NOT NULL default '0',\n `use_supplier_infos` tinyint(1) NOT NULL default '1',\n `generate_order_pdf` tinyint(1) NOT NULL default '0',\n `copy_documents` tinyint(1) NOT NULL default '0',\n `default_taxes` int(11) NOT NULL default '0',\n `generate_assets` int(11) NOT NULL default '0',\n `generated_name` varchar(255) collate utf8_unicode_ci default NULL,\n `generated_serial` varchar(255) collate utf8_unicode_ci default NULL,\n `generated_otherserial` varchar(255) collate utf8_unicode_ci default NULL,\n `default_asset_states_id` int(11) NOT NULL default '0',\n `tickettemplates_id_delivery` int(11) NOT NULL default '0',\n `order_status_draft` int(11) NOT NULL default '0',\n `order_status_waiting_approval` int(11) NOT NULL default '0',\n `order_status_approved` int(11) NOT NULL default '0',\n `order_status_partially_delivred` int(11) NOT NULL default '0',\n `order_status_completly_delivered` int(11) NOT NULL default '0',\n `order_status_canceled` int(11) NOT NULL default '0',\n `order_status_paid` int(11) NOT NULL default '0',\n `shoudbedelivered_color` char(20) collate utf8_unicode_ci default '#ff5555',\n `documentcategories_id` int(11) NOT NULL default '0',\n `groups_id_author` int(11) NOT NULL default '0',\n `groups_id_recipient` int(11) NOT NULL default '0',\n `users_id_recipient` int(11) NOT NULL default '0',\n `add_location` tinyint(1) NOT NULL default '0',\n `add_bill_details` tinyint(1) NOT NULL default '0',\n `hide_inactive_budgets` tinyint(1) NOT NULL default '0',\n `rename_documents` tinyint(1) NOT NULL default '0',\n `transmit_budget_change` tinyint(1) NOT NULL default '0',\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;"; $DB->query($query) or die($DB->error()); $tobefilled = "TOBEFILLED"; $tmp = array('id' => 1, 'use_validation' => 0, 'default_taxes' => 0, 'generate_assets' => 0, 'generated_name' => $tobefilled, 'generated_serial' => $tobefilled, 'generated_otherserial' => $tobefilled, 'default_asset_states_id' => 0, 'generated_title' => $tobefilled, 'generated_content' => $tobefilled, 'default_ticketcategories_id' => 0, 'shoudbedelivered_color' => '#ff5555'); $config->add($tmp); } else { //Upgrade $migration->displayMessage("Upgrading {$table}"); //1.2.0 $migration->renameTable("glpi_plugin_order_config", $table); if (!countElementsInTable("glpi_plugin_order_configs")) { $query = "INSERT INTO `glpi_plugin_order_configs`(`id`,`use_validation`,`default_taxes`) VALUES (1,0,0);"; $DB->query($query) or die($DB->error()); } $migration->changeField($table, "ID", "id", "int(11) NOT NULL auto_increment"); //1.3.0 $migration->addField($table, "generate_assets", "tinyint(1) NOT NULL default '0'"); $migration->addField($table, "generated_name", "varchar(255) collate utf8_unicode_ci default NULL"); $migration->addField($table, "generated_serial", "varchar(255) collate utf8_unicode_ci default NULL"); $migration->addField($table, "generated_otherserial", "varchar(255) collate utf8_unicode_ci default NULL"); $migration->addField($table, "default_asset_entities_id", "int(11) NOT NULL default '0'"); $migration->addField($table, "default_asset_states_id", "int(11) NOT NULL default '0'"); $migration->addField($table, "generated_title", "varchar(255) collate utf8_unicode_ci default NULL"); $migration->addField($table, "generated_content", "text collate utf8_unicode_ci"); $migration->addField($table, "default_ticketcategories_id", "int(11) NOT NULL default '0'"); $migration->addField($table, "use_supplier_satisfaction", "tinyint(1) NOT NULL default '0'"); $migration->addField($table, "generate_order_pdf", "tinyint(1) NOT NULL default '0'"); $migration->addField($table, "use_supplier_informations", "tinyint(1) NOT NULL default '1'"); $migration->addField($table, "shoudbedelivered_color", "char(20) collate utf8_unicode_ci default '#ff5555'"); $migration->addField($table, "copy_documents", "tinyint(1) NOT NULL DEFAULT '0'"); $migration->addField($table, "documentcategories_id", "integer"); $migration->addField($table, "groups_id_author", "integer"); $migration->addField($table, "groups_id_recipient", "integer"); $migration->addField($table, "users_id_recipient", "integer"); $migration->changeField($table, "default_ticketcategories_id", "default_itilcategories_id", "integer"); //1.9.0 $migration->addField($table, "add_location", "TINYINT(1) NOT NULL DEFAULT '0'"); $migration->addField($table, "add_bill_details", "TINYINT(1) NOT NULL DEFAULT '0'"); $config = new self(); $config->getFromDB(1); $templateID = false; $migration->addField($table, "tickettemplates_id_delivery", 'integer'); $migration->migrationOneTable($table); $migration->dropField($table, "generated_title"); $migration->dropField($table, "generated_content"); $migration->dropField($table, "default_itilcategories_id"); $migration->addField($table, "hide_inactive_budgets", "bool"); $migration->addField($table, "rename_documents", "bool"); //0.85+1.2 $migration->addField($table, "transmit_budget_change", "bool"); $migration->migrationOneTable($table); if ($templateID) { $config->update(array('id' => 1, 'tickettemplates_id_delivery' => $templateID)); } } $migration->displayMessage("Add default order state workflow"); $new_states = array('order_status_draft' => 1, 'order_status_waiting_approval' => 2, 'order_status_approved' => 3, 'order_status_partially_delivred' => 4, 'order_status_completly_delivered' => 5, 'order_status_canceled' => 6, 'order_status_paid' => 7); foreach ($new_states as $field => $value) { $migration->addField($table, $field, "int(11) NOT NULL default '0'"); } $migration->migrationOneTable($table); $new_states['id'] = 1; $config->update($new_states); }
static function install(Migration $migration) { global $DB; $table = getTableForItemType(__CLASS__); if (TableExists("glpi_plugin_itilcategorygroups_categories_groups") && FieldExists("glpi_plugin_itilcategorygroups_categories_groups", 'is_active')) { $migration->renameTable("glpi_plugin_itilcategorygroups_categories_groups", $table); } if (!TableExists($table)) { $query = "CREATE TABLE IF NOT EXISTS `{$table}` (\n `id` INT(11) NOT NULL AUTO_INCREMENT,\n `is_active` TINYINT(1) NOT NULL DEFAULT '0',\n `name` VARCHAR(255) COLLATE utf8_unicode_ci DEFAULT '',\n `comment` TEXT COLLATE utf8_unicode_ci,\n `date_mod` DATE default NULL,\n `itilcategories_id` INT(11) NOT NULL DEFAULT '0',\n `view_all_lvl1` TINYINT(1) NOT NULL DEFAULT '0',\n `view_all_lvl2` TINYINT(1) NOT NULL DEFAULT '0',\n `view_all_lvl3` TINYINT(1) NOT NULL DEFAULT '0',\n `view_all_lvl4` TINYINT(1) NOT NULL DEFAULT '0',\n `entities_id` INT(11) NOT NULL DEFAULT '0',\n `is_recursive` TINYINT(1) NOT NULL DEFAULT '1',\n `is_incident` TINYINT(1) NOT NULL DEFAULT '1',\n `is_request` TINYINT(1) NOT NULL DEFAULT '1',\n PRIMARY KEY (`id`),\n KEY `entities_id` (`entities_id`),\n KEY `itilcategories_id` (`itilcategories_id`),\n KEY `is_incident` (`is_incident`),\n KEY `is_request` (`is_request`),\n KEY `is_recursive` (`is_recursive`),\n KEY date_mod (date_mod)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;"; $DB->query($query); } if (!FieldExists($table, 'view_all_lvl1')) { $migration->addField($table, 'view_all_lvl1', "TINYINT(1) NOT NULL DEFAULT '0'", array('after' => 'itilcategories_id')); $migration->addField($table, 'view_all_lvl2', "TINYINT(1) NOT NULL DEFAULT '0'", array('after' => 'itilcategories_id')); $migration->addField($table, 'view_all_lvl3', "TINYINT(1) NOT NULL DEFAULT '0'", array('after' => 'itilcategories_id')); $migration->addField($table, 'view_all_lvl4', "TINYINT(1) NOT NULL DEFAULT '0'", array('after' => 'itilcategories_id')); $migration->migrationOneTable($table); } return true; }
public static function install(Migration $migration) { global $DB; $table = getTableForItemType(__CLASS__); if (!TableExists($table)) { $migration->displayMessage("Installing {$table}"); //Install $query = "CREATE TABLE IF NOT EXISTS `glpi_plugin_order_references` (\n `id` int(11) NOT NULL auto_increment,\n `entities_id` int(11) NOT NULL default '0',\n `is_recursive` tinyint(1) NOT NULL default '0',\n `name` varchar(255) collate utf8_unicode_ci default NULL,\n `manufacturers_id` int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_manufacturers (id)',\n `manufacturers_reference` varchar(255) collate utf8_unicode_ci NOT NULL DEFAULT '',\n `types_id` int(11) NOT NULL default '0' COMMENT 'RELATION to various tables, according to itemtypes tables (id)',\n `models_id` int(11) NOT NULL default '0' COMMENT 'RELATION to various tables, according to itemmodels tables (id)',\n `itemtype` varchar(100) collate utf8_unicode_ci NOT NULL COMMENT 'see .class.php file',\n `templates_id` int(11) NOT NULL default '0' COMMENT 'RELATION to various tables, according to itemtype (id)',\n `comment` text collate utf8_unicode_ci,\n `is_deleted` tinyint(1) NOT NULL default '0',\n `is_active` tinyint(1) NOT NULL default '1',\n `notepad` longtext collate utf8_unicode_ci,\n `date_mod` datetime default NULL,\n PRIMARY KEY (`id`),\n KEY `name` (`name`),\n KEY `entities_id` (`entities_id`),\n KEY `manufacturers_id` (`manufacturers_id`),\n KEY `types_id` (`types_id`),\n KEY `models_id` (`models_id`),\n KEY `templates_id` (`templates_id`),\n KEY `is_active` (`is_active`),\n KEY `is_deleted` (`is_deleted`),\n KEY date_mod (date_mod)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;"; $DB->query($query) or die($DB->error()); } else { //Upgrade $migration->displayMessage("Upgrading {$table}"); //1.1.0 $migration->changeField($table, "FK_manufacturer", "FK_glpi_enterprise", "int(11) NOT NULL DEFAULT '0'"); ///1.2.0 $migration->changeField($table, "ID", "id", "int(11) NOT NULL auto_increment"); $migration->changeField($table, "FK_entities", "entities_id", "int(11) NOT NULL default '0'"); $migration->changeField($table, "recursive", "is_recursive", "tinyint(1) NOT NULL default '0'"); $migration->changeField($table, "name", "name", "varchar(255) collate utf8_unicode_ci default NULL"); $migration->changeField($table, "FK_glpi_enterprise", "manufacturers_id", "int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_manufacturers (id)'"); $migration->changeField($table, "FK_type", "types_id", "int(11) NOT NULL default '0' COMMENT 'RELATION to various tables, according to itemtypes tables (id)'"); $migration->changeField($table, "FK_model", "models_id", "int(11) NOT NULL default '0' COMMENT 'RELATION to various tables, according to itemmodels tables (id)'"); $migration->changeField($table, "type", "itemtype", "varchar(100) collate utf8_unicode_ci NOT NULL COMMENT 'see .class.php file'"); $migration->changeField($table, "template", "templates_id", "int(11) NOT NULL default '0' COMMENT 'RELATION to various tables, according to itemtype (id)'"); $migration->changeField($table, "comments", "comment", "text collate utf8_unicode_ci"); $migration->changeField($table, "deleted", "is_deleted", "tinyint(1) NOT NULL default '0'"); $migration->addField($table, "notepad", "longtext collate utf8_unicode_ci"); $migration->addField($table, "is_active", "TINYINT(1) NOT NULL DEFAULT '1'"); $migration->addField($table, "date_mod", "datetime"); $migration->addKey($table, "name"); $migration->addKey($table, "entities_id"); $migration->addKey($table, "manufacturers_id"); $migration->addKey($table, "types_id"); $migration->addKey($table, "models_id"); $migration->addKey($table, "templates_id"); $migration->addKey($table, "is_deleted"); $migration->addKey($table, "is_active"); $migration->addKey($table, "date_mod"); $migration->migrationOneTable($table); Plugin::migrateItemType(array(3151 => 'PluginOrderReference'), array("glpi_bookmarks", "glpi_bookmarks_users", "glpi_displaypreferences", "glpi_documents_items", "glpi_infocoms", "glpi_logs")); if (FieldExists('glpi_tickets', 'itemtype')) { Plugin::migrateItemType(array(3151 => 'PluginOrderReference'), array("glpi_tickets")); } Plugin::migrateItemType(array(), array(), array($table)); //1.3.0 $DB->query("UPDATE `glpi_plugin_order_references` SET\n `itemtype`='ConsumableItem'\n WHERE `itemtype` ='Consumable'") or die($DB->error()); $DB->query("UPDATE `glpi_plugin_order_references` SET\n `itemtype`='CartridgeItem'\n WHERE `itemtype` ='Cartridge'") or die($DB->error()); //1.7.0 $migration->addField($table, "date_mod", "DATETIME NULL"); $migration->addKey($table, "date_mod"); //Displayprefs $prefs = array(1 => 1, 2 => 4, 4 => 5, 5 => 9, 6 => 6, 7 => 7); foreach ($prefs as $num => $rank) { if (!countElementsInTable("glpi_displaypreferences", "`itemtype`='PluginOrderReference' AND `num`='{$num}'\n AND `users_id`='0'")) { $DB->query("INSERT INTO glpi_displaypreferences\n VALUES (NULL,'PluginOrderReference','{$num}','{$rank}','0');"); } } //Fix error naming field if (FieldExists($table, 'manufacturer_reference')) { $migration->changeField($table, "manufacturer_reference", "manufacturers_reference", "varchar(255) collate utf8_unicode_ci NOT NULL DEFAULT ''"); $migration->migrationOneTable($table); } //2.0.1 if (!FieldExists($table, 'manufacturers_reference')) { $migration->addField($table, "manufacturers_reference", "varchar(255) collate utf8_unicode_ci NOT NULL DEFAULT ''"); $migration->migrationOneTable($table); } } }
public static function install(Migration $migration) { global $DB; $table = getTableForItemType(__CLASS__); if (!TableExists($table)) { if (!TableExists("glpi_plugin_order_suppliers")) { $migration->displayMessage("Installing {$table}"); //install $query = "CREATE TABLE IF NOT EXISTS `glpi_plugin_order_orders_suppliers` (\n `id` int(11) NOT NULL auto_increment,\n `entities_id` int(11) NOT NULL default '0',\n `is_recursive` tinyint(1) NOT NULL default '0',\n `plugin_order_orders_id` int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_plugin_order_orders (id)',\n `suppliers_id` int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_suppliers (id)',\n `num_quote` varchar(255) collate utf8_unicode_ci default NULL,\n `num_order` varchar(255) collate utf8_unicode_ci default NULL,\n `num_bill` varchar(255) collate utf8_unicode_ci default NULL,\n PRIMARY KEY (`id`),\n KEY `plugin_order_orders_id` (`plugin_order_orders_id`),\n KEY `entities_id` (`entities_id`),\n KEY `suppliers_id` (`suppliers_id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;"; $DB->query($query) or die($DB->error()); } else { //Upgrade $migration->displayMessage("Upgrading {$table}"); //1.2.0 $migration->renameTable("glpi_plugin_order_suppliers", $table); $migration->addField($table, "entities_id", "int(11) NOT NULL default '0'"); $migration->addField($table, "is_recursive", "tinyint(1) NOT NULL default '0'"); $migration->addField($table, "suppliers_id", "int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_suppliers (id)'"); $migration->changeField($table, "ID", "id", "int(11) NOT NULL auto_increment"); $migration->changeField($table, "FK_order", "plugin_order_orders_id", "int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_plugin_order_orders (id)'"); $migration->changeField($table, "numquote", "num_quote", "varchar(255) collate utf8_unicode_ci default NULL"); $migration->changeField($table, "numbill", "num_bill", "varchar(255) collate utf8_unicode_ci default NULL"); $migration->changeField($table, "numorder", "num_order", "varchar(255) collate utf8_unicode_ci default NULL"); $migration->addKey($table, "plugin_order_orders_id"); $migration->addKey($table, "suppliers_id"); $migration->migrationOneTable($table); Plugin::migrateItemType(array(3154 => 'PluginOrderOrder_Supplier'), array("glpi_bookmarks", "glpi_bookmarks_users", "glpi_displaypreferences", "glpi_documents_items", "glpi_infocoms", "glpi_logs", "glpi_items_tickets"), array()); //1.5.0 $query = "SELECT `suppliers_id`, `entities_id`,`is_recursive`,`id`\n FROM `glpi_plugin_order_orders` "; foreach ($DB->request($query) as $data) { $query = "UPDATE `glpi_plugin_order_orders_suppliers` SET\n `suppliers_id` = '{$data["suppliers_id"]}'\n WHERE `plugin_order_orders_id` = '{$data["id"]}' "; $DB->query($query) or die($DB->error()); $query = "UPDATE `glpi_plugin_order_orders_suppliers` SET\n `entities_id` = '{$data["entities_id"]}',\n `is_recursive` = '{$data["is_recursive"]}'\n WHERE `plugin_order_orders_id` = '{$data["id"]}' "; $DB->query($query) or die($DB->error()); } } } }
public static function install(Migration $migration) { global $DB; $table = getTableForItemType(__CLASS__); if (!TableExists($table)) { $migration->displayMessage("Installing {$table}"); $query = "CREATE TABLE IF NOT EXISTS `glpi_plugin_order_bills` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',\n `number` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',\n `billdate` datetime DEFAULT NULL,\n `validationdate` datetime DEFAULT NULL,\n `comment` text COLLATE utf8_unicode_ci,\n `plugin_order_billstates_id` int(11) NOT NULL DEFAULT '0',\n `value` decimal(20,4) NOT NULL DEFAULT '0.0000',\n `plugin_order_billtypes_id` int(11) NOT NULL DEFAULT '0',\n `suppliers_id` int(11) NOT NULL DEFAULT '0',\n `plugin_order_orders_id` int(11) NOT NULL DEFAULT '0',\n `users_id_validation` int(11) NOT NULL DEFAULT '0',\n `entities_id` int(11) NOT NULL DEFAULT '0',\n `is_recursive` int(11) NOT NULL DEFAULT '0',\n `notepad` text COLLATE utf8_unicode_ci,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;"; $DB->query($query) or die($DB->error()); } else { if (FieldExists("glpi_plugin_order_orders_suppliers", "num_bill")) { //Migrate bills $bill = new PluginOrderBill(); $query = "SELECT * FROM `glpi_plugin_order_orders_suppliers`"; foreach (getAllDatasFromTable('glpi_plugin_order_orders_suppliers') as $data) { if (!is_null($data['num_bill']) && $data['num_bill'] != '' && !countElementsInTable('glpi_plugin_order_bills', "`number`='" . $data['num_bill'] . "'")) { //create new bill and link it to the order $tmp['name'] = $tmp['number'] = $data['num_bill']; //Get supplier from the order $tmp['suppliers_id'] = $data['suppliers_id']; //Bill has the same entities_id and is_recrusive $tmp['entities_id'] = $data['entities_id']; $tmp['is_recursive'] = $data['is_recursive']; //Link bill to order $tmp['plugin_order_orders_id'] = $data['plugin_order_orders_id']; //Create bill $bills_id = $bill->add($tmp); //All order items are now linked to this bill $query = "UPDATE `glpi_plugin_order_orders_items`\n SET `plugin_order_bills_id` = '{$bills_id}'\n WHERE `plugin_order_orders_id` = '" . $data['plugin_order_orders_id'] . "'"; $DB->query($query); } } } $migration->changeField($table, "value", "value", "decimal(20,4) NOT NULL DEFAULT '0.0000'"); $migration->migrationOneTable($table); } $migration->dropField("glpi_plugin_order_orders_suppliers", "num_bill"); $migration->migrationOneTable("glpi_plugin_order_orders_suppliers"); }
function plugin_archires_updateTo180() { $migration = new Migration(180); $migration->renameTable("glpi_plugin_archires_query_location", "glpi_plugin_archires_locationqueries"); $migration->renameTable("glpi_plugin_archires_query_switch", "glpi_plugin_archires_networkequipmentqueries"); $migration->renameTable("glpi_plugin_archires_query_applicatifs", "glpi_plugin_archires_appliancequeries"); $migration->renameTable("glpi_plugin_archires_image_device", "glpi_plugin_archires_imageitems"); $migration->renameTable("glpi_plugin_archires_query_type", "glpi_plugin_archires_querytypes"); $migration->renameTable("glpi_plugin_archires_color_iface", "glpi_plugin_archires_networkinterfacecolors"); $migration->renameTable("glpi_plugin_archires_color_state", "glpi_plugin_archires_statecolors"); $migration->renameTable("glpi_plugin_archires_color_vlan", "glpi_plugin_archires_vlancolors"); $migration->renameTable("glpi_plugin_archires_config", "glpi_plugin_archires_views"); $migration->dropKey("glpi_plugin_archires_locationqueries", "deleted"); $migration->changeField("glpi_plugin_archires_locationqueries", "ID", "id", 'autoincrement'); $migration->changeField("glpi_plugin_archires_locationqueries", "name", "name", 'string'); $migration->changeField("glpi_plugin_archires_locationqueries", "FK_entities", "entities_id", 'integer'); $migration->changeField("glpi_plugin_archires_locationqueries", "location", "locations_id", 'integer', array('comment' => 'RELATION to glpi_locations (id)')); $migration->changeField("glpi_plugin_archires_locationqueries", "network", "networks_id", 'integer', array('comment' => 'RELATION to glpi_networks (id)')); $migration->changeField("glpi_plugin_archires_locationqueries", "state", "states_id", 'integer', array('comment' => 'RELATION to glpi_states (id)')); $migration->changeField("glpi_plugin_archires_locationqueries", "FK_group", "groups_id", 'integer', array('comment' => 'RELATION to glpi_groups (id)')); $migration->changeField("glpi_plugin_archires_locationqueries", "FK_config", "plugin_archires_views_id", 'integer', array('comment' => 'RELATION to glpi_plugin_archires_views (id)')); $migration->changeField("glpi_plugin_archires_locationqueries", "FK_vlan", "vlans_id", 'integer', array('comment' => 'RELATION to glpi_vlans (id)')); $migration->changeField("glpi_plugin_archires_locationqueries", "deleted", "is_deleted", 'bool'); $migration->changeField("glpi_plugin_archires_locationqueries", "notes", "notepad", 'longtext'); $migration->dropField("glpi_plugin_archires_locationqueries", "link"); $migration->addKey("glpi_plugin_archires_locationqueries", "name"); $migration->addKey("glpi_plugin_archires_locationqueries", "entities_id"); $migration->addKey("glpi_plugin_archires_locationqueries", "locations_id"); $migration->addKey("glpi_plugin_archires_locationqueries", "networks_id"); $migration->addKey("glpi_plugin_archires_locationqueries", "groups_id"); $migration->addKey("glpi_plugin_archires_locationqueries", "plugin_archires_views_id"); $migration->addKey("glpi_plugin_archires_locationqueries", "states_id"); $migration->addKey("glpi_plugin_archires_locationqueries", "vlans_id"); $migration->addKey("glpi_plugin_archires_locationqueries", "is_deleted"); $migration->dropKey("glpi_plugin_archires_networkequipmentqueries", "deleted"); $migration->changeField("glpi_plugin_archires_networkequipmentqueries", "ID", "id", 'autoincrement'); $migration->changeField("glpi_plugin_archires_networkequipmentqueries", "name", "name", 'string'); $migration->changeField("glpi_plugin_archires_networkequipmentqueries", "FK_entities", "entities_id", 'integer'); $migration->changeField("glpi_plugin_archires_networkequipmentqueries", "switch", "networkequipments_id", 'integer', array('comment' => 'RELATION to glpi_networkequipments (id)')); $migration->changeField("glpi_plugin_archires_networkequipmentqueries", "network", "networks_id", 'integer', array('comment' => 'RELATION to glpi_networks (id)')); $migration->changeField("glpi_plugin_archires_networkequipmentqueries", "state", "states_id", 'integer', array('comment' => 'RELATION to glpi_states (id)')); $migration->changeField("glpi_plugin_archires_networkequipmentqueries", "FK_group", "groups_id", 'integer', array('comment' => 'RELATION to glpi_groups (id)')); $migration->changeField("glpi_plugin_archires_networkequipmentqueries", "FK_config", "plugin_archires_views_id", 'integer', array('comment' => 'RELATION to glpi_plugin_archires_views (id)')); $migration->changeField("glpi_plugin_archires_networkequipmentqueries", "FK_vlan", "vlans_id", 'integer', array('comment' => 'RELATION to glpi_vlans (id)')); $migration->changeField("glpi_plugin_archires_networkequipmentqueries", "deleted", "is_deleted", 'bool'); $migration->changeField("glpi_plugin_archires_networkequipmentqueries", "notes", "notepad", 'longtext'); $migration->dropField("glpi_plugin_archires_networkequipmentqueries", "link"); $migration->addKey("glpi_plugin_archires_networkequipmentqueries", "name"); $migration->addKey("glpi_plugin_archires_networkequipmentqueries", "entities_id"); $migration->addKey("glpi_plugin_archires_networkequipmentqueries", "networkequipments_id"); $migration->addKey("glpi_plugin_archires_networkequipmentqueries", "networks_id"); $migration->addKey("glpi_plugin_archires_networkequipmentqueries", "groups_id"); $migration->addKey("glpi_plugin_archires_networkequipmentqueries", "plugin_archires_views_id"); $migration->addKey("glpi_plugin_archires_networkequipmentqueries", "states_id"); $migration->addKey("glpi_plugin_archires_networkequipmentqueries", "vlans_id"); $migration->addKey("glpi_plugin_archires_networkequipmentqueries", "is_deleted"); $migration->dropKey("glpi_plugin_archires_appliancequeries", "deleted"); $migration->changeField("glpi_plugin_archires_appliancequeries", "ID", "id", 'autoincrement'); $migration->changeField("glpi_plugin_archires_appliancequeries", "name", "name", 'string'); $migration->changeField("glpi_plugin_archires_appliancequeries", "FK_entities", "entities_id", 'integer'); $migration->changeField("glpi_plugin_archires_appliancequeries", "applicatifs", "appliances_id", 'integer', array('comment' => 'RELATION to glpi_plugin_appliances (id)')); $migration->changeField("glpi_plugin_archires_appliancequeries", "network", "networks_id", 'integer', array('comment' => 'RELATION to glpi_networks (id)')); $migration->changeField("glpi_plugin_archires_appliancequeries", "state", "states_id", 'integer', array('comment' => 'RELATION to glpi_states (id)')); $migration->changeField("glpi_plugin_archires_appliancequeries", "FK_group", "groups_id", 'integer', array('comment' => 'RELATION to glpi_groups (id)')); $migration->changeField("glpi_plugin_archires_appliancequeries", "FK_config", "plugin_archires_views_id", 'integer', array('comment' => 'RELATION to glpi_plugin_archires_views (id)')); $migration->changeField("glpi_plugin_archires_appliancequeries", "FK_vlan", "vlans_id", 'integer', array('comment' => 'RELATION to glpi_vlans (id)')); $migration->changeField("glpi_plugin_archires_appliancequeries", "deleted", "is_deleted", 'bool'); $migration->changeField("glpi_plugin_archires_appliancequeries", "notes", "notepad", 'longtext'); $migration->dropField("glpi_plugin_archires_appliancequeries", "link"); $migration->addKey("glpi_plugin_archires_appliancequeries", "name"); $migration->addKey("glpi_plugin_archires_appliancequeries", "entities_id"); $migration->addKey("glpi_plugin_archires_appliancequeries", "appliances_id"); $migration->addKey("glpi_plugin_archires_appliancequeries", "networks_id"); $migration->addKey("glpi_plugin_archires_appliancequeries", "groups_id"); $migration->addKey("glpi_plugin_archires_appliancequeries", "plugin_archires_views_id"); $migration->addKey("glpi_plugin_archires_appliancequeries", "states_id"); $migration->addKey("glpi_plugin_archires_appliancequeries", "vlans_id"); $migration->addKey("glpi_plugin_archires_appliancequeries", "is_deleted"); $migration->dropKey("glpi_plugin_archires_imageitems", "device_type"); $migration->changeField("glpi_plugin_archires_imageitems", "ID", "id", 'autoincrement'); $migration->changeField("glpi_plugin_archires_imageitems", "type", "type", 'integer'); $migration->changeField("glpi_plugin_archires_imageitems", "device_type", "itemtype", "varchar(100) collate utf8_unicode_ci NOT NULL", array('comment' => 'see .class.php file')); $migration->dropKey("glpi_plugin_archires_querytypes", "FK_query"); $migration->dropKey("glpi_plugin_archires_querytypes", "type"); $migration->dropKey("glpi_plugin_archires_querytypes", "type_query"); $migration->dropKey("glpi_plugin_archires_querytypes", "device_type"); $migration->changeField("glpi_plugin_archires_querytypes", "ID", "id", 'autoincrement'); $migration->changeField("glpi_plugin_archires_querytypes", "type_query", "querytype", "varchar(100) collate utf8_unicode_ci NOT NULL", array('comment' => 'RELATION to the 3 type of archires (type)')); $migration->changeField("glpi_plugin_archires_querytypes", "type", "type", 'integer'); $migration->changeField("glpi_plugin_archires_querytypes", "device_type", "itemtype", "varchar(100) collate utf8_unicode_ci NOT NULL", array('comment' => 'see .class.php file')); $migration->changeField("glpi_plugin_archires_querytypes", "FK_query", "plugin_archires_queries_id", 'integer', array('comment' => 'RELATION to the 3 queries tables (id)')); $migration->addKey("glpi_plugin_archires_querytypes", "querytype"); $migration->addKey("glpi_plugin_archires_querytypes", "type"); $migration->addKey("glpi_plugin_archires_querytypes", "itemtype"); $migration->addKey("glpi_plugin_archires_querytypes", "plugin_archires_queries_id"); $migration->migrationOneTable("glpi_plugin_archires_querytypes"); $query = "UPDATE `glpi_plugin_archires_querytypes`\n SET `querytype` = 'PluginArchiresLocationQuery'\n WHERE `querytype` = 0"; $DB->queryOrDie($query, __('1.8.0 update glpi_plugin_archires_querytypes (querytype) ', 'archires') . $DB->error()); $query = "UPDATE `glpi_plugin_archires_querytypes`\n SET `querytype` = 'PluginArchiresNetworkEquipmentQuery'\n WHERE `querytype` = 1"; $DB->queryOrDie($query, __('1.8.0 update glpi_plugin_archires_querytypes (querytype) ', 'archires') . $DB->error()); $query = "UPDATE `glpi_plugin_archires_querytypes`\n SET `querytype` = 'PluginArchiresApplianceQuery'\n WHERE `querytype` = 2"; $DB->queryOrDie($query, __('1.8.0 update glpi_plugin_archires_querytypes (querytype) ', 'archires') . $DB->error()); $migration->dropKey("glpi_plugin_archires_networkinterfacecolors", "iface"); $migration->changeField("glpi_plugin_archires_networkinterfacecolors", "ID", "id", 'autoincrement'); $migration->changeField("glpi_plugin_archires_networkinterfacecolors", "iface", "networkinterfaces_id", 'integer', array('comment' => 'RELATION to glpi_networkinterfaces (id)')); $migration->addKey("glpi_plugin_archires_networkinterfacecolors", "networkinterfaces_id"); $migration->changeField("glpi_plugin_archires_statecolors", "ID", "id", 'autoincrement'); $migration->changeField("glpi_plugin_archires_statecolors", "state", "states_id", 'integer', array('comment' => 'RELATION to glpi_states (id)')); $migration->addKey("glpi_plugin_archires_statecolors", "states_id"); $migration->changeField("glpi_plugin_archires_vlancolors", "ID", "id", 'autoincrement'); $migration->changeField("glpi_plugin_archires_vlancolors", "vlan", "vlans_id", 'integer', array('comment' => 'RELATION to glpi_vlans (id)')); $migration->addKey("glpi_plugin_archires_vlancolors", "vlans_id"); $migration->dropKey("glpi_plugin_archires_views", "deleted"); $migration->dropKey("glpi_plugin_archires_views", "FK_entities"); $migration->changeField("glpi_plugin_archires_views", "ID", "id", 'autoincrement'); $migration->changeField("glpi_plugin_archires_views", "name", "name", 'string'); $migration->changeField("glpi_plugin_archires_views", "FK_entities", "entities_id", 'integer'); $migration->changeField("glpi_plugin_archires_views", "deleted", "is_deleted", 'bool'); $migration->addKey("glpi_plugin_archires_views", "entities_id"); $migration->addKey("glpi_plugin_archires_views", "is_deleted"); $migration->changeField("glpi_plugin_archires_profiles", "ID", "id", 'autoincrement'); $migration->addField("glpi_plugin_archires_profiles", "profiles_id", 'integer', array('comment' => 'RELATION to glpi_profiles (id)')); $migration->changeField("glpi_plugin_archires_profiles", "archires", "archires", 'char'); $migration->addKey("glpi_plugin_archires_profiles", "profiles_id"); $query = "DELETE\n FROM `glpi_displaypreferences`\n WHERE `itemtype` = 3000 AND `num` = 9"; $DB->queryOrDie($query, __('1.8.0 delete glpi_displaypreferences (itemtype) ', 'archires') . $DB->error()); $query = "DELETE\n FROM `glpi_displaypreferences`\n WHERE `itemtype` = 3001 AND `num` = 8"; $DB->queryOrDie($query, __('1.8.0 delete glpi_displaypreferences (itemtype) ', 'archires') . $DB->error()); $query = "DELETE\n FROM `glpi_displaypreferences`\n WHERE `itemtype` = 3002 AND `num` = 8"; $DB->queryOrDie($query, __('1.8.0 delete glpi_displaypreferences (itemtype) ', 'archires') . $DB->error()); $migration->executeMigration(); }
function plugin_racks_install() { global $DB; include_once GLPI_ROOT . "/plugins/racks/inc/profile.class.php"; $migration = new Migration("1.6.1"); $update = false; if (!TableExists("glpi_plugin_racks_racks") && !TableExists("glpi_plugin_racks_configs")) { $DB->runFile(GLPI_ROOT . "/plugins/racks/sql/empty-1.5.2.sql"); } elseif (TableExists("glpi_plugin_rack_content") && !FieldExists("glpi_plugin_rack_content", "first_powersupply")) { $update = true; $DB->runFile(GLPI_ROOT . "/plugins/racks/sql/update-1.0.2.sql"); $DB->runFile(GLPI_ROOT . "/plugins/racks/sql/update-1.1.0.sql"); } elseif (!TableExists("glpi_plugin_rack") && TableExists("glpi_plugin_racks_profiles")) { $update = true; $DB->runFile(GLPI_ROOT . "/plugins/racks/sql/update-1.1.0.sql"); } //from 1.1 version if (TableExists("glpi_plugin_racks_racks") && !FieldExists("glpi_plugin_racks_racks", "otherserial")) { $DB->runFile(GLPI_ROOT . "/plugins/racks/sql/update-1.2.1.sql"); } if (TableExists("glpi_plugin_racks_racks") && !FieldExists("glpi_plugin_racks_racks", "users_id_tech")) { $DB->runFile(GLPI_ROOT . "/plugins/racks/sql/update-1.3.0.sql"); } if (!TableExists("glpi_plugin_racks_racktypes")) { $DB->runFile(GLPI_ROOT . "/plugins/racks/sql/update-1.3.2.sql"); } if (TableExists("glpi_plugin_racks_racktypes") && !FieldExists("glpi_plugin_racks_racktypes", "is_recursive")) { $DB->runFile(GLPI_ROOT . "/plugins/racks/sql/update-1.4.1.sql"); } if (TableExists("glpi_plugin_racks_profiles") && !FieldExists("glpi_plugin_racks_profiles", "open_ticket")) { $DB->runFile(GLPI_ROOT . "/plugins/racks/sql/update-1.4.2.sql"); } $migration->addField('glpi_plugin_racks_configs', 'add_location_on_new_item', 'bool'); $migration->addField('glpi_plugin_racks_configs', 'forward_location_on_change', 'bool'); $migration->migrationOneTable('glpi_plugin_racks_configs'); if ($update) { foreach ($DB->request('glpi_plugin_racks_profiles') as $data) { $query = "UPDATE `glpi_plugin_racks_profiles`\r\n SET `profiles_id` = '" . $data["id"] . "'\r\n WHERE `id` = '" . $data["id"] . "';"; $result = $DB->query($query); } $migration->dropField('glpi_plugin_racks_profiles', 'name'); Plugin::migrateItemType(array(4450 => 'PluginRacksRack', 4451 => 'PluginRacksOther'), array("glpi_bookmarks", "glpi_bookmarks_users", "glpi_displaypreferences", "glpi_documents_items", "glpi_infocoms", "glpi_logs", "glpi_items_tickets"), array("glpi_plugin_racks_racks_items", "glpi_plugin_racks_itemspecifications")); } $notepad_tables = array('glpi_plugin_racks_racks'); foreach ($notepad_tables as $t) { // Migrate data if (FieldExists($t, 'notepad')) { $query = "SELECT id, notepad\r\n FROM `{$t}`\r\n WHERE notepad IS NOT NULL\r\n AND notepad <>'';"; foreach ($DB->request($query) as $data) { $iq = "INSERT INTO `glpi_notepads`\r\n (`itemtype`, `items_id`, `content`, `date`, `date_mod`)\r\n VALUES ('" . getItemTypeForTable($t) . "', '" . $data['id'] . "',\r\n '" . addslashes($data['notepad']) . "', NOW(), NOW())"; $DB->queryOrDie($iq, "0.85 migrate notepad data"); } $query = "ALTER TABLE `glpi_plugin_racks_racks` DROP COLUMN `notepad`;"; $DB->query($query); } } //Migrate profiles to the system introduced in 0.85 PluginRacksProfile::initProfile(); PluginRacksProfile::createFirstAccess($_SESSION['glpiactiveprofile']['id']); //Drop old profile table : not used anymore $migration->dropTable('glpi_plugin_racks_profiles'); return true; }
public static function install(Migration $migration) { global $DB; $table = getTableForItemType(__CLASS__); if (!TableExists($table) && !TableExists("glpi_plugin_order_references_manufacturers")) { $migration->displayMessage("Installing {$table}"); $query = "CREATE TABLE IF NOT EXISTS `glpi_plugin_order_references_suppliers` (\n `id` int(11) NOT NULL auto_increment,\n `entities_id` int(11) NOT NULL default '0',\n `is_recursive` tinyint(1) NOT NULL default '0',\n `plugin_order_references_id` int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_plugin_order_references (id)',\n `suppliers_id` int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_suppliers (id)',\n `price_taxfree` decimal(20,4) NOT NULL DEFAULT '0.0000',\n `reference_code` varchar(255) collate utf8_unicode_ci default NULL,\n PRIMARY KEY (`id`),\n KEY `entities_id` (`entities_id`),\n KEY `plugin_order_references_id` (`plugin_order_references_id`),\n KEY `suppliers_id` (`suppliers_id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;"; $DB->query($query) or die($DB->error()); } else { $migration->displayMessage("Upgrading {$table}"); //1.1.0 if (TableExists("glpi_plugin_order_references_manufacturers")) { $migration->addField("glpi_plugin_order_references_manufacturers", "reference_code", "varchar(255) NOT NULL collate utf8_unicode_ci default ''"); $migration->migrationOneTable("glpi_plugin_order_references_manufacturers"); } //1.2.0 $migration->renameTable("glpi_plugin_order_references_manufacturers", $table); $migration->addField($table, "is_recursive", "int(11) NOT NULL default '0'"); $migration->addKey($table, "suppliers_id"); $migration->addKey($table, "plugin_order_references_id"); $migration->changeField($table, "ID", "id", "int(11) NOT NULL auto_increment"); $migration->changeField($table, "FK_entities", "entities_id", "int(11) NOT NULL default '0'"); $migration->changeField($table, "FK_reference", "plugin_order_references_id", "int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_plugin_order_references (id)'"); $migration->changeField($table, "FK_enterprise", "suppliers_id", "int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_suppliers (id)'"); $migration->changeField($table, "reference_code", "reference_code", "varchar(255) collate utf8_unicode_ci default NULL"); $migration->changeField($table, "price_taxfree", "price_taxfree", "decimal(20,4) NOT NULL DEFAULT '0.0000'"); $migration->migrationOneTable($table); Plugin::migrateItemType(array(3152 => 'PluginOrderReference_Supplier'), array("glpi_bookmarks", "glpi_bookmarks_users", "glpi_displaypreferences", "glpi_documents_items", "glpi_infocoms", "glpi_logs"), array()); if (FieldExists('glpi_tickets', 'itemtype')) { Plugin::migrateItemType(array(3152 => 'PluginOrderReference_Supplier'), array("glpi_tickets"), array()); } //1.5.0 $query = "SELECT `entities_id`,`is_recursive`,`id` FROM `glpi_plugin_order_references` "; foreach ($DB->request($query) as $data) { $query = "UPDATE `glpi_plugin_order_references_suppliers`\n SET `entities_id` = '" . $data["entities_id"] . "',`is_recursive` = '" . $data["is_recursive"] . "'\n WHERE `plugin_order_references_id` = '" . $data["id"] . "' "; $DB->query($query) or die($DB->error()); } } }
static function install(Migration $migration) { global $DB; $table = getTableForItemType(__CLASS__); if (!TableExists($table)) { $query = "CREATE TABLE `{$table}` (\n `id` INT( 11 ) NOT NULL AUTO_INCREMENT,\n `entities_id` INT( 11 ) NOT NULL DEFAULT 0,\n `itemtype` varchar(255) collate utf8_unicode_ci default NULL,\n `is_active` tinyint(1) NOT NULL default '0',\n `name` varchar(255) collate utf8_unicode_ci default NULL,\n `comment` text NULL,\n `date_mod` datetime NOT NULL default '0000-00-00 00:00:00',\n `use_global_search` tinyint(1) NOT NULL default '0',\n `use_unicity` tinyint(1) NOT NULL default '0',\n `use_history` tinyint(1) NOT NULL default '0',\n `use_infocoms` tinyint(1) NOT NULL default '0',\n `use_contracts` tinyint(1) NOT NULL default '0',\n `use_documents` tinyint(1) NOT NULL default '0',\n `use_tickets` tinyint(1) NOT NULL default '0',\n `use_links` tinyint(1) NOT NULL default '0',\n `use_loans` tinyint(1) NOT NULL default '0',\n `use_network_ports` tinyint(1) NOT NULL default '0',\n `use_direct_connections` tinyint(1) NOT NULL default '0',\n `use_plugin_datainjection` tinyint(1) NOT NULL default '0',\n `use_plugin_pdf` tinyint(1) NOT NULL default '0',\n `use_plugin_order` tinyint(1) NOT NULL default '0',\n `use_plugin_uninstall` tinyint(1) NOT NULL default '0',\n `use_plugin_geninventorynumber` tinyint(1) NOT NULL default '0',\n `use_menu_entry` tinyint(1) NOT NULL default '0',\n `linked_itemtypes` text NULL,\n PRIMARY KEY ( `id` )\n ) ENGINE = MYISAM COMMENT = 'Object types definition table' DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;"; $DB->query($query) or die($DB->error()); } $migration->addField($table, "use_network_ports", "bool"); $migration->addField($table, "use_direct_connections", "bool"); $migration->addField($table, "use_plugin_geninventorynumber", "bool"); $migration->addField($table, "use_contracts", "bool"); $migration->addField($table, "use_menu_entry", "bool"); $migration->addField($table, "use_global_search", "bool"); $migration->addField($table, "comment", "text"); $migration->addField($table, "date_mod", "datetime"); $migration->addField($table, "linked_itemtypes", "text"); $migration->migrationOneTable($table); //Displayprefs $prefs = array(10 => 6, 9 => 5, 8 => 4, 7 => 3, 6 => 2, 2 => 1, 4 => 1, 11 => 7, 12 => 8, 14 => 10, 15 => 11); foreach ($prefs as $num => $rank) { if (!countElementsInTable("glpi_displaypreferences", "`itemtype`='" . __CLASS__ . "' AND `num`='{$num}'\n AND `users_id`='0'")) { $preference = new DisplayPreference(); $tmp['itemtype'] = __CLASS__; $tmp['num'] = $num; $tmp['rank'] = $rank; $tmp['users_id'] = 0; $preference->add($tmp); } } //If files are missing, recreate them! self::checkClassAndFilesForItemType(); }
public static function install(Migration $migration) { global $DB; //Only avaiable since 1.3.0 $table = getTableForItemType(__CLASS__); if (!TableExists("glpi_plugin_order_surveysuppliers")) { $migration->displayMessage("Installing {$table}"); //Installation $query = "CREATE TABLE IF NOT EXISTS `glpi_plugin_order_surveysuppliers` (\n `id` int(11) NOT NULL auto_increment,\n `entities_id` int(11) NOT NULL default '0',\n `is_recursive` tinyint(1) NOT NULL default '0',\n `plugin_order_orders_id` int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_plugin_order_orders (id)',\n `suppliers_id` int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_suppliers (id)',\n `answer1` int(11) NOT NULL default 0,\n `answer2` int(11) NOT NULL default 0,\n `answer3` int(11) NOT NULL default 0,\n `answer4` int(11) NOT NULL default 0,\n `answer5` int(11) NOT NULL default 0,\n `comment` text collate utf8_unicode_ci,\n PRIMARY KEY (`id`),\n KEY `plugin_order_orders_id` (`plugin_order_orders_id`),\n KEY `entities_id` (`entities_id`),\n KEY `suppliers_id` (`suppliers_id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;"; $DB->query($query) or die($DB->error()); } else { //upgrade $migration->displayMessage("Upgrading {$table}"); //1.2.0 $migration->changeField($table, "ID", "id", "int(11) NOT NULL auto_increment"); $migration->changeField($table, "FK_order", "plugin_order_orders_id", "int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_plugin_order_orders (id)'"); $migration->changeField($table, "FK_enterprise", "suppliers_id", "int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_suppliers (id)'"); $migration->changeField($table, "comment", "comment", "text collate utf8_unicode_ci"); $migration->addField($table, "entities_id", "int(11) NOT NULL default '0'"); $migration->addField($table, "is_recursive", "tinyint(1) NOT NULL default '0'"); $migration->addKey($table, "plugin_order_orders_id"); $migration->addKey($table, "suppliers_id"); $migration->migrationOneTable($table); $query = "SELECT `suppliers_id`, `entities_id`,`is_recursive`,`id`\n FROM `glpi_plugin_order_orders` "; foreach ($DB->request($query) as $data) { $query = "UPDATE `glpi_plugin_order_surveysuppliers` SET\n `entities_id` = '{$data["entities_id"]}',\n `is_recursive` = '{$data["is_recursive"]}'\n WHERE `plugin_order_orders_id` = '{$data["id"]}' "; $DB->query($query) or die($DB->error()); } } }
public static function install(Migration $migration) { global $DB; $table = getTableForItemType(__CLASS__); if (!TableExists($table)) { $query = "CREATE TABLE IF NOT EXISTS `{$table}` (\n `id` int(11) NOT NULL auto_increment,\n `entities_id` int(11) NOT NULL DEFAULT '0',\n `is_recursive` tinyint(1) NOT NULL DEFAULT '1',\n `name` varchar(255) NOT NULL DEFAULT '',\n `comment` text collate utf8_unicode_ci,\n `color` varchar(50) NOT NULL DEFAULT '' COLLATE 'utf8_unicode_ci',\n PRIMARY KEY (`id`),\n KEY `name` (`name`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci"; $GLOBALS['DB']->query($query) or die($GLOBALS['DB']->error()); } if (!FieldExists($table, 'type_menu')) { $migration->addField($table, 'type_menu', "varchar(50) NOT NULL DEFAULT ''"); $migration->addKey($table, 'type_menu'); $migration->migrationOneTable($table); } // Version 0.90-1.1 $result = $DB->query("SHOW FIELDS FROM `{$table}` where Field ='type_menu'"); if ($result && $DB->numrows($result)) { while ($data = $DB->fetch_assoc($result)) { if (stristr($data["Type"], 'varchar') !== FALSE) { $DB->query("ALTER TABLE `{$table}` DROP INDEX `type_menu`;"); $DB->query("ALTER TABLE `{$table}` MODIFY `type_menu` text COLLATE utf8_unicode_ci;"); $datas = getAllDatasFromTable($table, "`type_menu` IS NOT NULL"); if (!empty($datas)) { foreach ($datas as $data) { $itemtypes = PluginTagTagItem::getItemtypes($data['type_menu']); $DB->query("UPDATE `{$table}` SET `type_menu` = '" . json_encode($itemtypes) . "' WHERE `id` = '" . $data['id'] . "'"); } } break; } } } return true; }
/** * Move locks from ocslink.import_* to is_dynamic in related tables * * @param $migration **/ function plugin_ocsinventoryng_migrateComputerLocks(Migration $migration) { global $DB; $import = array('import_printer' => 'Printer', 'import_monitor' => 'Monitor', 'import_peripheral' => 'Peripheral'); foreach ($import as $field => $itemtype) { foreach ($DB->request('ocs_glpi_ocslinks', '', array('computers_id', $field)) as $data) { if (FieldExists('ocs_glpi_ocslinks', $field)) { $import_field = importArrayFromDB($data[$field]); //If array is not empty if (!empty($import_field)) { $query_update = "UPDATE `glpi_computers_items`\n SET `is_dynamic`='1'\n WHERE `id` IN (" . implode(',', array_keys($import_field)) . ")\n AND `itemtype`='{$itemtype}'"; $DB->query($query_update); } } } $migration->dropField('ocs_glpi_ocslinks', $field); } //Migration disks and vms $import = array('import_disk' => 'glpi_computerdisks', 'import_vm' => 'glpi_computervirtualmachines', 'import_software' => 'glpi_computers_softwareversions', 'import_ip' => 'glpi_networkports'); foreach ($import as $field => $table) { if (FieldExists('ocs_glpi_ocslinks', $field)) { foreach ($DB->request('ocs_glpi_ocslinks', '', array('computers_id', $field)) as $data) { $import_field = importArrayFromDB($data[$field]); //If array is not empty if (!empty($import_field)) { $in_where = "(" . implode(',', array_keys($import_field)) . ")"; $query_update = "UPDATE `{$table}`\n SET `is_dynamic`='1'\n WHERE `id` IN {$in_where}"; $DB->query($query_update); if ($table == 'glpi_networkports') { $query_update = "UPDATE `glpi_networkports` AS PORT,\n `glpi_networknames` AS NAME\n SET NAME.`is_dynamic` = 1\n WHERE PORT.`id` IN {$in_where}\n AND NAME.`itemtype` = 'NetworkPort'\n AND NAME.`items_id` = PORT.`id`"; $DB->query($query_update); $query_update = "UPDATE `glpi_networkports` AS PORT,\n `glpi_networknames` AS NAME,\n `glpi_ipaddresses` AS ADDR\n SET ADDR.`is_dynamic` = 1\n WHERE PORT.`id` IN {$in_where}\n AND NAME.`itemtype` = 'NetworkPort'\n AND NAME.`items_id` = PORT.`id`\n AND ADDR.`itemtype` = 'NetworkName'\n AND ADDR.`items_id` = NAME.`id`"; $DB->query($query_update); } } } $migration->dropField('ocs_glpi_ocslinks', $field); } } if (FieldExists('ocs_glpi_ocslinks', 'import_device')) { foreach ($DB->request('ocs_glpi_ocslinks', '', array('computers_id', 'import_device')) as $data) { $import_device = importArrayFromDB($data['import_device']); if (!in_array('_version_078_', $import_device)) { $import_device = plugin_ocsinventoryng_migrateImportDevice($import_device); } $devices = array(); $types = Item_Devices::getDeviceTypes(); foreach ($import_device as $key => $val) { if (!$key) { // OcsServer::IMPORT_TAG_078 continue; } list($type, $nomdev) = explode('$$$$$', $val); list($type, $iddev) = explode('$$$$$', $key); if (!isset($types[$type])) { // should never happen continue; } $devices[$types[$type]][] = $iddev; } foreach ($devices as $type => $data) { //If array is not empty $query_update = "UPDATE `" . getTableForItemType($type) . "`\n SET `is_dynamic`='1'\n WHERE `id` IN (" . implode(',', $data) . ")"; $DB->query($query_update); } } $migration->dropField('ocs_glpi_ocslinks', 'import_device'); } $migration->migrationOneTable('ocs_glpi_ocslinks'); }
static function install(Migration $migration) { global $DB; //Only avaiable since 1.2.0 $table = getTableForItemType(__CLASS__); if (!TableExists($table)) { $migration->displayMessage("Installing {$table}"); $query = "CREATE TABLE `glpi_plugin_order_preferences` (\n `id` int(11) NOT NULL auto_increment,\n `users_id` int(11) NOT NULL default 0,\n `template` varchar(255) collate utf8_unicode_ci default NULL,\n `sign` varchar(255) collate utf8_unicode_ci default NULL,\n PRIMARY KEY (`id`),\n KEY `users_id` (`users_id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;"; $DB->query($query) or die($DB->error()); } else { //1.5.3 $migration->changeField($table, 'ID', 'id', "int(11) NOT NULL auto_increment"); $migration->changeField($table, 'user_id', 'users_id', "INT(11) NOT NULL DEFAULT '0'"); $migration->addKey($table, 'users_id'); $migration->migrationOneTable($table); } }
function plugin_ocsinventoryng_upgrademassocsimport13to14() { $migration = new Migration(14); $migration->renameTable("glpi_plugin_massocsimport", "glpi_plugin_massocsimport_threads"); $migration->changeField("glpi_plugin_massocsimport_threads", "ID", "id", 'autoincrement'); $migration->changeField("glpi_plugin_massocsimport_threads", "thread_id", "threadid", 'integer'); $migration->changeField("glpi_plugin_massocsimport_threads", "status", "status", 'integer'); $migration->changeField("glpi_plugin_massocsimport_threads", "ocs_server_id", "ocsservers_id", 'integer', array('value' => 1)); $migration->changeField("glpi_plugin_massocsimport_threads", "process_id", "processid", 'integer'); $migration->changeField("glpi_plugin_massocsimport_threads", "noupdate_machines_number", "notupdated_machines_number", 'integer'); $migration->migrationOneTable("glpi_plugin_massocsimport_threads"); $migration->addKey("glpi_plugin_massocsimport_threads", array("processid", "threadid"), "process_thread"); $migration->renameTable("glpi_plugin_massocsimport_config", "glpi_plugin_massocsimport_configs"); $migration->dropField("glpi_plugin_massocsimport_configs", "delete_frequency"); $migration->dropField("glpi_plugin_massocsimport_configs", "enable_logging"); $migration->dropField("glpi_plugin_massocsimport_configs", "delete_empty_frequency"); $migration->dropField("glpi_plugin_massocsimport_configs", "warn_if_not_imported"); $migration->dropField("glpi_plugin_massocsimport_configs", "not_imported_threshold"); $migration->changeField("glpi_plugin_massocsimport_configs", "ID", "id", 'autoincrement'); $migration->changeField("glpi_plugin_massocsimport_configs", "thread_log_frequency", "thread_log_frequency", 'integer', array('value' => 10)); $migration->changeField("glpi_plugin_massocsimport_configs", "display_empty", "is_displayempty", 'int(1) NOT NULL default 1'); $migration->changeField("glpi_plugin_massocsimport_configs", "default_ocs_server", "ocsservers_id", 'integer', array('value' => -1)); $migration->changeField("glpi_plugin_massocsimport_configs", "delay_refresh", "delay_refresh", 'integer'); $migration->changeField("glpi_plugin_massocsimport_configs", "comments", "comment", 'text'); $migration->changeField("glpi_plugin_massocsimport_details", "ID", "id", 'autoincrement'); $migration->changeField("glpi_plugin_massocsimport_details", "process_id", "plugin_massocsimport_threads_id", 'integer'); $migration->changeField("glpi_plugin_massocsimport_details", "thread_id", "threadid", 'integer'); $migration->changeField("glpi_plugin_massocsimport_details", "ocs_id", "ocsid", 'integer'); $migration->changeField("glpi_plugin_massocsimport_details", "glpi_id", "computers_id", 'integer'); $migration->changeField("glpi_plugin_massocsimport_details", "ocs_server_id", "ocsservers_id", 'integer', array('value' => 1)); $migration->migrationOneTable('glpi_plugin_massocsimport_details'); $migration->addKey("glpi_plugin_massocsimport_details", array("plugin_massocsimport_threads_id", "threadid"), "process_thread"); $migration->renameTable("glpi_plugin_massocsimport_not_imported", "glpi_plugin_massocsimport_notimported"); $migration->changeField("glpi_plugin_massocsimport_notimported", "ID", "id", 'autoincrement'); $migration->changeField("glpi_plugin_massocsimport_notimported", "ocs_id", "ocsid", 'integer'); $migration->changeField("glpi_plugin_massocsimport_notimported", "ocs_server_id", "ocsservers_id", 'integer'); $migration->changeField("glpi_plugin_massocsimport_notimported", "deviceid", "ocs_deviceid", 'string'); $migration->changeField("glpi_plugin_massocsimport_servers", "ID", "id", 'autoincrement'); $migration->changeField("glpi_plugin_massocsimport_servers", "ocs_server_id", "ocsservers_id", 'integer'); $migration->changeField("glpi_plugin_massocsimport_servers", "max_ocs_id", "max_ocsid", 'int(11) DEFAULT NULL'); $migration->changeField("glpi_plugin_massocsimport_servers", "max_glpi_date", "max_glpidate", 'datetime DEFAULT NULL'); $migration->executeMigration(); }
function plugin_custom_install() { global $DB; $version = plugin_version_custom(); $migration = new Migration($version['version']); // VERSION 1.0 if (!TableExists('glpi_plugin_custom_tabs')) { $query = "CREATE TABLE `glpi_plugin_custom_tabs` (\n `id` INT(11) NOT NULL AUTO_INCREMENT,\n `name` VARCHAR(255) collate utf8_unicode_ci NOT NULL,\n `itemtype` VARCHAR(255) NOT NULL DEFAULT 0,\n `tab` VARCHAR(255) NOT NULL DEFAULT 0,\n `color` VARCHAR(255) NOT NULL DEFAULT 0,\n PRIMARY KEY (`id`)\n ) ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;"; $DB->query($query); } if (!TableExists('glpi_plugin_custom_defaulttabs')) { $query = "CREATE TABLE `glpi_plugin_custom_defaulttabs` (\n `id` INT(11) NOT NULL AUTO_INCREMENT,\n `name` VARCHAR(255) collate utf8_unicode_ci NOT NULL,\n `itemtype` VARCHAR(255) NOT NULL DEFAULT 0,\n `tab` VARCHAR(255) NOT NULL DEFAULT 0,\n PRIMARY KEY (`id`)\n ) ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;"; $DB->query($query); } if (!TableExists('glpi_plugin_custom_styles')) { $query = "CREATE TABLE `glpi_plugin_custom_styles` (\n `id` INT(11) NOT NULL AUTO_INCREMENT,\n `body` VARCHAR(7) NOT NULL DEFAULT '#dfdfdf',\n `button_bg_color` VARCHAR(7) NOT NULL DEFAULT '#e1cc7b',\n `button_border` VARCHAR(7) NOT NULL DEFAULT '#8B8468',\n `button_color` VARCHAR(7) NOT NULL DEFAULT '#000000',\n `button_bg_color_hover` VARCHAR(7) NOT NULL DEFAULT '#ffffff',\n `button_border_hover` VARCHAR(7) NOT NULL DEFAULT '#8B8468',\n `button_color_hover` VARCHAR(7) NOT NULL DEFAULT '#000000',\n `text_color` VARCHAR(7) NOT NULL DEFAULT '#000000',\n `link_color` VARCHAR(7) NOT NULL DEFAULT '#659900',\n `link_hover_color` VARCHAR(7) NOT NULL DEFAULT '#000000',\n `menu_link` VARCHAR(7) NOT NULL DEFAULT '#000000',\n `ssmenu1_link` VARCHAR(7) NOT NULL DEFAULT '#666666',\n `ssmenu2_link` VARCHAR(7) NOT NULL DEFAULT '#000000',\n `link_topright` VARCHAR(7) NOT NULL DEFAULT '#000000',\n `menu_border` VARCHAR(7) NOT NULL DEFAULT '#9BA563',\n `menu_item_bg` VARCHAR(7) NOT NULL DEFAULT '#f1e7c2',\n `menu_item_link` VARCHAR(7) NOT NULL DEFAULT '#000000',\n `menu_item_border` VARCHAR(7) NOT NULL DEFAULT '#CC9900',\n `menu_item_bg_hover` VARCHAR(7) NOT NULL DEFAULT '#d0d99d',\n `table_bg_color` VARCHAR(7) NOT NULL DEFAULT '#F2F2F2',\n `th` VARCHAR(7) NOT NULL DEFAULT '#e1cc7b',\n `th_text_color` VARCHAR(7) NOT NULL DEFAULT '#000000',\n `tab_bg_1` VARCHAR(7) NOT NULL DEFAULT '#f2f2f2',\n `tab_bg_1_2` VARCHAR(7) NOT NULL DEFAULT '#cf9b9b',\n `tab_bg_2` VARCHAR(7) NOT NULL DEFAULT '#f2f2f2',\n `tab_bg_2_2` VARCHAR(7) NOT NULL DEFAULT '#cf9b9b',\n `tab_bg_3` VARCHAR(7) NOT NULL DEFAULT '#e7e7e2',\n `tab_bg_4` VARCHAR(7) NOT NULL DEFAULT '#e4e4e2',\n `tab_bg_5` VARCHAR(7) NOT NULL DEFAULT '#f2f2f2',\n `header_bg1` VARCHAR(7) NOT NULL DEFAULT '#FFFFFF',\n `header_bg2` VARCHAR(7) NOT NULL DEFAULT '#f5efd6',\n `header_bg3` VARCHAR(7) NOT NULL DEFAULT '#d6bc53',\n `header_bg4` VARCHAR(7) NOT NULL DEFAULT '#c0cc7b',\n `header_bg5` VARCHAR(7) NOT NULL DEFAULT '#d0d99d',\n `header_bg6` VARCHAR(7) NOT NULL DEFAULT '#f1f4e3',\n `header_shadow_color` VARCHAR(7) NOT NULL DEFAULT '#011E3A',\n `page_shadow_color` VARCHAR(7) NOT NULL DEFAULT '#011E3A',\n `footer_shadow_color` VARCHAR(7) NOT NULL DEFAULT '#011E3A',\n `footer_bg1` VARCHAR(7) NOT NULL DEFAULT '#FFFFFF',\n `footer_bg2` VARCHAR(7) NOT NULL DEFAULT '#e2cf83',\n `cadre_central_bg1` VARCHAR(7) NOT NULL DEFAULT '#e8dab0',\n `cadre_central_bg2` VARCHAR(7) NOT NULL DEFAULT '#FFFFFF',\n `tabs_bg1` VARCHAR(7) NOT NULL DEFAULT '#fcfcfa',\n `tabs_bg2` VARCHAR(7) NOT NULL DEFAULT '#ddddc8',\n `tabs_bg3` VARCHAR(7) NOT NULL DEFAULT '#cfcfb2',\n `tabs_border` VARCHAR(7) NOT NULL DEFAULT '#909058',\n `tabs_title_color` VARCHAR(7) NOT NULL DEFAULT '#659900',\n PRIMARY KEY (`id`)\n ) ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;"; $DB->query($query); } if (!TableExists('glpi_plugin_custom_profiles')) { $query = "CREATE TABLE `glpi_plugin_custom_profiles` (\n `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,\n `profiles_id` VARCHAR(45) NOT NULL,\n `add_tabs` CHAR(1),\n `add_defaulttabs` CHAR(1),\n `edit_style` CHAR(1),\n PRIMARY KEY (`id`)\n )\n ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;"; $DB->query($query); } if (!FieldExists('glpi_plugin_custom_styles', 'text_color')) { $query = "ALTER TABLE `glpi_plugin_custom_styles` ADD COLUMN `text_color` VARCHAR(7) NOT NULL DEFAULT '#000000'"; $DB->query($query); } if (!FieldExists('glpi_plugin_custom_styles', 'th_text_color')) { $query = "ALTER TABLE `glpi_plugin_custom_styles` ADD COLUMN `th_text_color` VARCHAR(7) NOT NULL DEFAULT '#000000'"; $DB->query($query); $query = "ALTER TABLE `glpi_plugin_custom_styles` ADD COLUMN `table_bg_color` VARCHAR(7) NOT NULL DEFAULT '#F2F2F2'"; $DB->query($query); } if (!FieldExists('glpi_plugin_custom_styles', 'link_topright')) { $query = "ALTER TABLE `glpi_plugin_custom_styles` ADD COLUMN `link_topright` VARCHAR(7) NOT NULL DEFAULT '#000000'"; $DB->query($query); } if (!FieldExists('glpi_plugin_custom_styles', 'button_bg_color')) { $query = "ALTER TABLE `glpi_plugin_custom_styles` ADD COLUMN `button_bg_color` VARCHAR(7) NOT NULL DEFAULT '#e1cc7b'"; $DB->query($query); $query = "ALTER TABLE `glpi_plugin_custom_styles` ADD COLUMN `button_border` VARCHAR(7) NOT NULL DEFAULT '#8B8468'"; $DB->query($query); $query = "ALTER TABLE `glpi_plugin_custom_styles` ADD COLUMN `button_color` VARCHAR(7) NOT NULL DEFAULT '#000000'"; $DB->query($query); $query = "ALTER TABLE `glpi_plugin_custom_styles` ADD COLUMN `button_bg_color_hover` VARCHAR(7) NOT NULL DEFAULT '#FFFFFF'"; $DB->query($query); $query = "ALTER TABLE `glpi_plugin_custom_styles` ADD COLUMN `button_border_hover` VARCHAR(7) NOT NULL DEFAULT '#8B8468'"; $DB->query($query); $query = "ALTER TABLE `glpi_plugin_custom_styles` ADD COLUMN `button_color_hover` VARCHAR(7) NOT NULL DEFAULT '#000000'"; $DB->query($query); } //create plugin file dir if (!is_dir(CUSTOM_FILES_DIR)) { mkdir(CUSTOM_FILES_DIR); } touch(CUSTOM_FILES_DIR . "glpi_style.css"); //create config style require_once "style.class.php"; $style = new PluginCustomStyle(); $found = $style->find(); if (empty($found)) { $style->add(array('id' => 0)); } //Version 1.1 if (!TableExists('glpi_plugin_custom_tabprofiles')) { $query = "CREATE TABLE `glpi_plugin_custom_tabprofiles` (\n `id` INT(11) NOT NULL AUTO_INCREMENT,\n `plugin_custom_tabs_id` INT(11),\n `profiles_id` INT(11),\n PRIMARY KEY (`id`),\n KEY (`plugin_custom_tabs_id`),\n KEY (`profiles_id`)\n ) ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;"; $DB->query($query); } if (!FieldExists('glpi_plugin_custom_styles', 'text_color')) { $migration->addField('glpi_plugin_custom_styles', 'text_color', "VARCHAR(7) NOT NULL DEFAULT '#000000'", array('after' => 'body')); $migration->migrationOneTable('glpi_plugin_custom_styles'); } return true; }
static function install(Migration $migration) { global $DB; $table = getTableForItemType(__CLASS__); if (!TableExists($table)) { $query = "CREATE TABLE `{$table}` (\n `id` INT( 11 ) NOT NULL AUTO_INCREMENT,\n `entities_id` INT( 11 ) NOT NULL DEFAULT 0,\n `itemtype` varchar(255) collate utf8_unicode_ci default NULL,\n `is_active` tinyint(1) NOT NULL default '0',\n `name` varchar(255) collate utf8_unicode_ci default NULL,\n `comment` text NULL,\n `date_mod` datetime DEFAULT NULL,\n `date_creation` datetime DEFAULT NULL,\n `use_global_search` tinyint(1) NOT NULL default '0',\n `use_unicity` tinyint(1) NOT NULL default '0',\n `use_history` tinyint(1) NOT NULL default '0',\n `use_infocoms` tinyint(1) NOT NULL default '0',\n `use_contracts` tinyint(1) NOT NULL default '0',\n `use_documents` tinyint(1) NOT NULL default '0',\n `use_tickets` tinyint(1) NOT NULL default '0',\n `use_links` tinyint(1) NOT NULL default '0',\n `use_loans` tinyint(1) NOT NULL default '0',\n `use_network_ports` tinyint(1) NOT NULL default '0',\n `use_direct_connections` tinyint(1) NOT NULL default '0',\n `use_plugin_datainjection` tinyint(1) NOT NULL default '0',\n `use_plugin_pdf` tinyint(1) NOT NULL default '0',\n `use_plugin_order` tinyint(1) NOT NULL default '0',\n `use_plugin_uninstall` tinyint(1) NOT NULL default '0',\n `use_plugin_geninventorynumber` tinyint(1) NOT NULL default '0',\n `use_menu_entry` tinyint(1) NOT NULL default '0',\n `use_projects` tinyint(1) NOT NULL default '0',\n `linked_itemtypes` text NULL,\n `plugin_genericobject_typefamilies_id` INT( 11 ) NOT NULL DEFAULT 0,\n PRIMARY KEY ( `id` )\n ) ENGINE = MYISAM COMMENT = 'Object types definition table' DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;"; $DB->query($query) or die($DB->error()); } $migration->addField($table, "use_network_ports", "bool"); $migration->addField($table, "use_direct_connections", "bool"); $migration->addField($table, "use_plugin_geninventorynumber", "bool"); $migration->addField($table, "use_contracts", "bool"); $migration->addField($table, "use_menu_entry", "bool"); $migration->addField($table, "use_global_search", "bool"); $migration->addField($table, "use_projects", "bool"); $migration->addField($table, "use_notepad", "bool"); $migration->addField($table, "comment", "text"); if (!$migration->addField($table, "date_mod", "datetime")) { $migration->changeField($table, "date_mod", "date_mod", "datetime"); } $migration->addField($table, "date_creation", "datetime"); $migration->addField($table, "linked_itemtypes", "text"); $migration->addField($table, "plugin_genericobject_typefamilies_id", "integer"); $migration->addField($table, "use_plugin_simcard", "bool"); $migration->migrationOneTable($table); // Migrate notepad data $allGenericObjectTypes = PluginGenericobjectType::getTypes(true); $notepad = new Notepad(); foreach ($allGenericObjectTypes as $genericObjectType => $genericObjectData) { $genericObjectTypeInstance = new $genericObjectType(); if (FieldExists($genericObjectTypeInstance->getTable(), "notepad")) { $query = "INSERT INTO `" . $notepad->getTable() . "`\n (`items_id`,\n `itemtype`,\n `date`,\n `date_mod`,\n `content`\n )\n SELECT\n `id` as `items_id`,\n '" . $genericObjectType . "' as `itemtype`,\n now() as `date`,\n now() as `date_mod`,\n `notepad` as `content`\n FROM `" . $genericObjectTypeInstance->getTable() . "`\n WHERE notepad IS NOT NULL\n AND notepad <> ''"; $DB->query($query) or die($DB->error()); } $query = "UPDATE`" . $notepad->getTable() . "`"; $migration->dropField($genericObjectTypeInstance->getTable(), "notepad"); $migration->migrationOneTable($genericObjectTypeInstance->getTable()); } //Displayprefs $prefs = array(10 => 6, 9 => 5, 8 => 4, 7 => 3, 6 => 2, 2 => 1, 4 => 1, 11 => 7, 12 => 8, 14 => 10, 15 => 11); foreach ($prefs as $num => $rank) { if (!countElementsInTable("glpi_displaypreferences", "`itemtype`='" . __CLASS__ . "' AND `num`='{$num}'\n AND `users_id`='0'")) { $preference = new DisplayPreference(); $tmp['itemtype'] = __CLASS__; $tmp['num'] = $num; $tmp['rank'] = $rank; $tmp['users_id'] = 0; $preference->add($tmp); } } //If files are missing, recreate them! self::checkClassAndFilesForItemType(); }
static function install(Migration $migration) { global $DB; $table = getTableForItemType(__CLASS__); if (!TableExists($table)) { $migration->displayMessage("Installing {$table}"); $query = "CREATE TABLE `glpi_plugin_order_profiles` (\n `id` int(11) NOT NULL auto_increment,\n `profiles_id` int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_profiles (id)',\n `order` char(1) collate utf8_unicode_ci default NULL,\n `reference` char(1) collate utf8_unicode_ci default NULL,\n `validation` char(1) collate utf8_unicode_ci default NULL,\n `cancel` char(1) collate utf8_unicode_ci default NULL,\n `undo_validation` char(1) collate utf8_unicode_ci default NULL,\n `bill` char(1) collate utf8_unicode_ci default NULL,\n `delivery` char(1) collate utf8_unicode_ci default NULL,\n `generate_order_odt` char(1) collate utf8_unicode_ci default NULL,\n `open_ticket` char(1) default NULL,\n PRIMARY KEY (`id`),\n KEY `profiles_id` (`profiles_id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;"; $DB->query($query) or die($DB->error()); PluginOrderProfile::createFirstAccess($_SESSION['glpiactiveprofile']['id']); } else { $migration->displayMessage("Upgrading {$table}"); //1.2.0 $migration->changeField($table, "ID", "id", "int(11) NOT NULL auto_increment"); foreach (array('order', 'reference', 'budget', 'validation', 'cancel', 'undo_validation') as $right) { $migration->changeField($table, $right, $right, "char(1) collate utf8_unicode_ci default NULL"); } $migration->migrationOneTable($table); if ($migration->addField($table, "profiles_id", "int(11) NOT NULL default '0'")) { $migration->addKey($table, "profiles_id"); $migration->migrationOneTable($table); //Migration profiles $DB->query("UPDATE `{$table}` SET `profiles_id`=`id`"); } //1.4.0 $migration->dropField($table, "budget"); $migration->dropField($table, "name"); $migration->migrationOneTable($table); //1.5.0 $migration->addField($table, "bill", "char"); $migration->migrationOneTable($table); self::addRightToProfile($_SESSION['glpiactiveprofile']['id'], "bill", "w"); //1.5.3 //Add delivery right if ($migration->addField($table, "delivery", "char")) { $migration->migrationOneTable($table); //Update profiles : copy order right not to change current behavior $update = "UPDATE `{$table}` SET `delivery`=`order`"; $DB->query($update); self::addRightToProfile($_SESSION['glpiactiveprofile']['id'], "delivery", "w"); } if ($migration->addField($table, "generate_order_odt", "char")) { $migration->migrationOneTable($table); //Update profiles : copy order right not to change current behavior $update = "UPDATE `{$table}` SET `generate_order_odt`=`order`"; $DB->query($update); self::addRightToProfile($_SESSION['glpiactiveprofile']['id'], "generate_order_odt", "w"); } } //1.7.2 $migration->addField($table, "open_ticket", "char"); $migration->migrationOneTable($table); self::addRightToProfile($_SESSION['glpiactiveprofile']['id'], "open_ticket", "w"); self::changeProfile(); }
/** * Migrate tables from plugin fusinvdeploy to fusioninventory * all datas in exploded tables are merged and stored in json in order table * @param Migration $migration * @return nothing */ function migrateTablesFromFusinvDeploy($migration) { global $DB; if (TableExists("glpi_plugin_fusioninventory_deployorders") && TableExists("glpi_plugin_fusinvdeploy_checks") && TableExists("glpi_plugin_fusinvdeploy_files") && TableExists("glpi_plugin_fusinvdeploy_actions")) { //add json field in deploy order table to store datas from old misc tables $field_created = $migration->addField("glpi_plugin_fusioninventory_deployorders", "json", "longtext DEFAULT NULL"); $migration->migrationOneTable("glpi_plugin_fusioninventory_deployorders"); $final_datas = array(); //== glpi_plugin_fusioninventory_deployorders == $o_query = "SELECT * FROM glpi_plugin_fusioninventory_deployorders"; $o_res = $DB->query($o_query); while ($o_datas = $DB->fetch_assoc($o_res)) { $order_id = $o_datas['id']; $o_line = array(); $of_line = array(); $o_line['checks'] = array(); $o_line['actions'] = array(); $o_line['associatedFiles'] = array(); //=== Checks === if (TableExists("glpi_plugin_fusinvdeploy_checks")) { $c_query = "SELECT type, path, value, 'error' as `return`\n FROM glpi_plugin_fusinvdeploy_checks\n WHERE plugin_fusinvdeploy_orders_id = {$order_id}\n ORDER BY ranking ASC"; $c_res = $DB->query($c_query); $c_i = 0; while ($c_datas = $DB->fetch_assoc($c_res)) { foreach ($c_datas as $c_key => $c_value) { //specific case for filesytem sizes, convert to bytes if (!empty($c_value) && is_numeric($c_value) && $c_datas['type'] !== 'freespaceGreater') { $c_value = $c_value * 1024 * 1024; } //construct job check entry $o_line['checks'][$c_i][$c_key] = $c_value; } $c_i++; } } $files_list = array(); //=== Files === if (TableExists("glpi_plugin_fusinvdeploy_files")) { $f_query = "SELECT id, name, is_p2p as p2p, filesize, mimetype, " . "p2p_retention_days as `p2p-retention-duration`, uncompress, sha512 " . "FROM glpi_plugin_fusinvdeploy_files " . "WHERE plugin_fusinvdeploy_orders_id = {$order_id}"; $f_res = $DB->query($f_query); while ($f_datas = $DB->fetch_assoc($f_res)) { //jump to next entry if sha512 is empty // This kind of entries could happen sometimes on upload errors if (empty($f_datas['sha512'])) { continue; } //construct job file entry $o_line['associatedFiles'][] = $f_datas['sha512']; foreach ($f_datas as $f_key => $f_value) { //we don't store the sha512 field in json if ($f_key == "sha512" || $f_key == "id" || $f_key == "filesize" || $f_key == "mimetype") { continue; } //construct order file entry $of_line[$f_datas['sha512']][$f_key] = $f_value; } if (!in_array($f_datas['sha512'], $files_list)) { $files_list[] = $f_datas['sha512']; } } } //=== Actions === $cmdStatus['RETURNCODE_OK'] = 'okCode'; $cmdStatus['RETURNCODE_KO'] = 'errorCode'; $cmdStatus['REGEX_OK'] = 'okPattern'; $cmdStatus['REGEX_KO'] = 'errorPattern'; if (TableExists("glpi_plugin_fusinvdeploy_actions")) { $a_query = "SELECT *\n FROM glpi_plugin_fusinvdeploy_actions\n WHERE plugin_fusinvdeploy_orders_id = {$order_id}\n ORDER BY ranking ASC"; $a_res = $DB->query($a_query); $a_i = 0; while ($a_datas = $DB->fetch_assoc($a_res)) { //get type $type = strtolower(str_replace("PluginFusinvdeployAction_", "", $a_datas['itemtype'])); //specific case for command type $type = str_replace("command", "cmd", $type); //table for action itemtype $a_table = getTableForItemType($a_datas['itemtype']); //get table fields $at_query = "SELECT *\n FROM {$a_table}\n WHERE id = " . $a_datas['items_id']; $at_res = $DB->query($at_query); while ($at_datas = $DB->fetch_assoc($at_res)) { foreach ($at_datas as $at_key => $at_value) { //we don't store the id field of action itemtype table in json if ($at_key == "id") { continue; } //specific case for 'path' field if ($at_key == "path") { $o_line['actions'][$a_i][$type]['list'][] = $at_value; } else { //construct job actions entry $o_line['actions'][$a_i][$type][$at_key] = $at_value; } } //specific case for commands : we must add status and env vars if ($a_datas['itemtype'] === "PluginFusinvdeployAction_Command") { $ret_cmd_query = "SELECT type, value\n FROM glpi_plugin_fusinvdeploy_actions_commandstatus\n WHERE plugin_fusinvdeploy_commands_id = " . $at_datas['id']; $ret_cmd_res = $DB->query($ret_cmd_query); while ($res_cmd_datas = $DB->fetch_assoc($ret_cmd_res)) { // Skip empty retchecks type: // This surely means they have been drop at some point but entry has not been // removed from database. if (!empty($res_cmd_datas['type'])) { //construct command status array entry $o_line['actions'][$a_i][$type]['retChecks'][] = array('type' => $cmdStatus[$res_cmd_datas['type']], 'values' => array($res_cmd_datas['value'])); } } } } $a_i++; } } $final_datas[$order_id]['jobs'] = $o_line; $final_datas[$order_id]['associatedFiles'] = $of_line; unset($o_line); unset($of_line); } $options = 0; if (version_compare(PHP_VERSION, '5.3.3') >= 0) { $options = $options | JSON_NUMERIC_CHECK; } if (version_compare(PHP_VERSION, '5.4.0') >= 0) { $options = $options | JSON_UNESCAPED_SLASHES; } //store json in order table foreach ($final_datas as $order_id => $data) { $json = $DB->escape(json_encode($data, $options)); $order_query = "UPDATE glpi_plugin_fusioninventory_deployorders\n SET json = '{$json}'\n WHERE id = {$order_id}"; $DB->query($order_query); } } //=== Fileparts === if (TableExists('glpi_plugin_fusinvdeploy_fileparts') && TableExists('glpi_plugin_fusinvdeploy_files')) { $files_list = $DB->request('glpi_plugin_fusinvdeploy_files'); // multipart file datas foreach ($files_list as $file) { $sha = $file['sha512']; if (empty($sha)) { continue; } $shortsha = substr($sha, 0, 6); $fp_query = "SELECT fp.`sha512` as filepart_hash, " . " f.`sha512` as file_hash " . "FROM `glpi_plugin_fusinvdeploy_files` as f " . "INNER JOIN `glpi_plugin_fusinvdeploy_fileparts` as fp " . "ON f.`id` = fp.`plugin_fusinvdeploy_files_id` " . " AND f.`shortsha512` = '{$shortsha}' " . "GROUP BY fp.`sha512` " . "ORDER BY fp.`id`"; $fp_res = $DB->query($fp_query); if ($DB->numrows($fp_res) > 0) { //print("writing file : " . GLPI_PLUGIN_DOC_DIR."/fusioninventory/files/manifests/{$sha}" . "\n"); $fhandle = fopen(GLPI_PLUGIN_DOC_DIR . "/fusioninventory/files/manifests/{$sha}", 'w+'); while ($fp_datas = $DB->fetch_assoc($fp_res)) { if ($fp_datas['file_hash'] === $sha) { fwrite($fhandle, $fp_datas['filepart_hash'] . "\n"); } } fclose($fhandle); } } } //migrate fusinvdeploy_files to fusioninventory_deployfiles if (TableExists("glpi_plugin_fusinvdeploy_files")) { $DB->query("TRUNCATE TABLE `glpi_plugin_fusioninventory_deployfiles`"); if (FieldExists("glpi_plugin_fusinvdeploy_files", "filesize")) { $f_query = implode(array("SELECT files.`id`, files.`name`,", " files.`filesize`, files.`mimetype`,", " files.`sha512`, files.`shortsha512`,", " files.`create_date`,", " pkgs.`entities_id`, pkgs.`is_recursive`", "FROM glpi_plugin_fusinvdeploy_files as files", "LEFT JOIN glpi_plugin_fusioninventory_deployorders as orders", " ON orders.`id` = files.`plugin_fusinvdeploy_orders_id`", "LEFT JOIN glpi_plugin_fusioninventory_deploypackages as pkgs", " ON orders.`plugin_fusioninventory_deploypackages_id` = pkgs.`id`", "WHERE", " files.`shortsha512` != \"\""), " \n"); $f_res = $DB->query($f_query); while ($f_datas = $DB->fetch_assoc($f_res)) { $entry = array("id" => $f_datas["id"], "name" => $f_datas["name"], "filesize" => $f_datas["filesize"], "mimetype" => $f_datas["mimetype"], "shortsha512" => $f_datas["shortsha512"], "sha512" => $f_datas["sha512"], "comments" => "", "date_mod" => $f_datas["create_date"], "entities_id" => $f_datas["entities_id"], "is_recursive" => $f_datas["is_recursive"]); $migration->displayMessage("\n"); // Check if file exists $i_DeployFile = new PluginFusioninventoryDeployFile(); $migration->displayMessage("migrating file " . $entry['name'] . " sha:" . $entry['sha512'] . "\n"); if ($i_DeployFile->checkPresenceManifest($entry['sha512'])) { $migration->displayMessage("manifest exists" . "\n"); $migration->insertInTable("glpi_plugin_fusioninventory_deployfiles", $entry); } } } } /** * JSON orders fixer: * This piece of code makes sure that JSON orders in database are valid and will fix it * otherwise. */ $orders = $DB->request('glpi_plugin_fusioninventory_deployorders'); foreach ($orders as $order_config) { $pfDeployOrder = new PluginFusioninventoryDeployOrder(); $json_order = json_decode($order_config['json']); //print("deployorders fixer : actual order structure for ID ".$order_config['id']."\n" . print_r($json_order,true) ."\n"); // Checks for /jobs json property if (!isset($json_order->jobs) || !is_object($json_order->jobs)) { //print("deployorders fixer : create missing required 'jobs' property\n"); $json_order->jobs = new stdClass(); } if (!isset($json_order->jobs->checks)) { //print("deployorders fixer : create missing required '/jobs/checks' array property\n"); $json_order->jobs->checks = array(); } if (!isset($json_order->jobs->actions)) { //print("deployorders fixer : create missing required '/jobs/actions' array property\n"); $json_order->jobs->actions = array(); } if (!isset($json_order->jobs->associatedFiles)) { //print("deployorders fixer : create missing required '/jobs/associatedFiles' array property\n"); $json_order->jobs->associatedFiles = array(); } // Checks for /associatedFiles json property if (!isset($json_order->associatedFiles) || !is_object($json_order->associatedFiles)) { //print("deployorders fixer : create missing required 'associatedFiles' property\n"); $json_order->associatedFiles = new stdClass(); } //print( //"deployorders fixer : final order structure for ID ".$order_config['id']."\n" . // json_encode($json_order,JSON_PRETTY_PRINT) ."\n" //); $pfDeployOrder::updateOrderJson($order_config['id'], $json_order); } /** * Drop unused tables */ $old_deploy_tables = array('glpi_plugin_fusinvdeploy_actions', 'glpi_plugin_fusinvdeploy_actions_commandenvvariables', 'glpi_plugin_fusinvdeploy_actions_commands', 'glpi_plugin_fusinvdeploy_actions_commandstatus', 'glpi_plugin_fusinvdeploy_actions_copies', 'glpi_plugin_fusinvdeploy_actions_deletes', 'glpi_plugin_fusinvdeploy_actions_messages', 'glpi_plugin_fusinvdeploy_actions_mkdirs', 'glpi_plugin_fusinvdeploy_actions_moves', 'glpi_plugin_fusinvdeploy_checks', 'glpi_plugin_fusinvdeploy_fileparts', 'glpi_plugin_fusinvdeploy_files', 'glpi_plugin_fusinvdeploy_files_mirrors'); foreach ($old_deploy_tables as $table) { $migration->dropTable($table); } //drop unused views $old_deploy_views = array('glpi_plugin_fusinvdeploy_taskjobs', 'glpi_plugin_fusinvdeploy_tasks'); foreach ($old_deploy_views as $view) { $DB->query("DROP VIEW IF EXISTS {$view}"); } }
public static function install(Migration $migration) { global $DB; $table = getTableForItemType(__CLASS__); if (!TableExists($table) && !TableExists("glpi_plugin_order_detail")) { $migration->displayMessage("Installing {$table}"); //install $query = "CREATE TABLE IF NOT EXISTS `{$table}` (\n `id` int(11) NOT NULL auto_increment,\n `entities_id` int(11) NOT NULL default '0',\n `is_recursive` tinyint(1) NOT NULL default '0',\n `plugin_order_orders_id` int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_plugin_order_orders (id)',\n `itemtype` varchar(100) collate utf8_unicode_ci NOT NULL COMMENT 'see .class.php file',\n `items_id` int(11) NOT NULL default '0' COMMENT 'RELATION to various tables, according to itemtype (id)',\n `plugin_order_references_id` int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_plugin_order_references (id)',\n `plugin_order_deliverystates_id` int (11) NOT NULL default '0' COMMENT 'RELATION to glpi_plugin_order_deliverystates (id)',\n `plugin_order_ordertaxes_id` float NOT NULL default '0' COMMENT 'RELATION to glpi_plugin_order_ordertaxes (id)',\n `delivery_number` varchar(255) collate utf8_unicode_ci default NULL,\n `delivery_comment` text collate utf8_unicode_ci,\n `price_taxfree` decimal(20,6) NOT NULL DEFAULT '0.000000',\n `price_discounted` decimal(20,6) NOT NULL DEFAULT '0.000000',\n `discount` decimal(20,6) NOT NULL DEFAULT '0.000000',\n `price_ati` decimal(20,6) NOT NULL DEFAULT '0.000000',\n `states_id` int(11) NOT NULL default 1,\n `delivery_date` date default NULL,\n `plugin_order_bills_id` INT( 11 ) NOT NULL DEFAULT '0',\n `plugin_order_billstates_id` INT( 11 ) NOT NULL DEFAULT '0',\n `comment` text collate utf8_unicode_ci,\n PRIMARY KEY (`id`),\n KEY `FK_device` (`items_id`,`itemtype`),\n KEY `entities_id` (`entities_id`),\n KEY `item` (`itemtype`,`items_id`),\n KEY `plugin_order_references_id` (`plugin_order_references_id`),\n KEY `plugin_order_deliverystates_id` (`plugin_order_deliverystates_id`),\n KEY `states_id` (`states_id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;"; $DB->query($query) or die($DB->error()); } else { //Upgrade $migration->displayMessage("Upgrading {$table}"); //1.1.2 if (TableExists("glpi_plugin_order_detail")) { $migration->addField("glpi_plugin_order_detail", "delivery_status", "int(1) NOT NULL default '0'"); $migration->addField("glpi_plugin_order_detail", "delivery_comments", "TEXT"); $migration->migrationOneTable("glpi_plugin_order_detail"); } //1.2.0 $migration->renameTable("glpi_plugin_order_detail", $table); $migration->changeField($table, "ID", "id", "int(11) NOT NULL AUTO_INCREMENT"); $migration->changeField($table, "FK_order", "plugin_order_orders_id", "int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_plugin_order_orders (id)'"); $migration->changeField($table, "device_type", "itemtype", "varchar(100) collate utf8_unicode_ci NOT NULL COMMENT 'see .class.php file'"); $migration->changeField($table, "FK_device", "items_id", "int(11) NOT NULL default '0' COMMENT 'RELATION to various tables, according to itemtype (id)'"); $migration->changeField($table, "FK_reference", "plugin_order_references_id", "int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_plugin_order_references (id)'"); $migration->changeField($table, "delivery_status", "plugin_order_deliverystates_id", "int (11) NOT NULL default '0' COMMENT 'RELATION to glpi_plugin_order_deliverystates (id)'"); $migration->changeField($table, "deliverynum", "delivery_number", "varchar(255) collate utf8_unicode_ci default NULL"); $migration->changeField($table, "delivery_comments", "delivery_comment", "text collate utf8_unicode_ci"); $migration->changeField($table, "status", "states_id", "int(11) NOT NULL default 1"); $migration->changeField($table, "date", "delivery_date", "date default NULL"); $migration->addKey($table, array("items_id", "itemtype"), "FK_device"); $migration->addKey($table, array("itemtype", "items_id"), "item"); $migration->addKey($table, "plugin_order_references_id"); $migration->addKey($table, "plugin_order_deliverystates_id"); $migration->addKey($table, "states_id"); $migration->migrationOneTable($table); Plugin::migrateItemType(array(), array(), array($table)); //1.4.0 $migration->addField($table, "plugin_order_ordertaxes_id", "INT (11) NOT NULL default '0' COMMENT 'RELATION to glpi_plugin_order_ordertaxes (id)'"); $migration->migrationOneTable($table); /* Migrate VAT */ foreach ($DB->request("glpi_plugin_order_orders") as $data) { $query = "UPDATE `glpi_plugin_order_orders_items`\n SET `plugin_order_ordertaxes_id` = '" . $data["plugin_order_ordertaxes_id"] . "'\n WHERE `plugin_order_orders_id` = '" . $data["id"] . "'"; $result = $DB->query($query) or die($DB->error()); } //1.5.0 $migration->addField($table, "entities_id", "INT( 11 ) NOT NULL DEFAULT '0'"); $migration->addField($table, "is_recursive", "TINYINT( 1 ) NOT NULL DEFAULT '0'"); $migration->addField($table, "plugin_order_bills_id", "INT( 11 ) NOT NULL DEFAULT '0'"); $migration->addField($table, "plugin_order_billstates_id", "INT( 11 ) NOT NULL DEFAULT '0'"); $migration->addKey($table, "entities_id"); $migration->addKey($table, "plugin_order_bills_id"); $migration->addKey($table, "plugin_order_billstates_id"); $migration->addField($table, "comment", "text collate utf8_unicode_ci"); $migration->migrationOneTable($table); //Change format for prices : from float to decimal $migration->changeField($table, "price_taxfree", "price_taxfree", "decimal(20,6) NOT NULL DEFAULT '0.000000'"); $migration->changeField($table, "price_discounted", "price_discounted", "decimal(20,6) NOT NULL DEFAULT '0.000000'"); $migration->changeField($table, "price_ati", "price_ati", "decimal(20,6) NOT NULL DEFAULT '0.000000'"); $migration->changeField($table, "discount", "discount", "decimal(20,6) NOT NULL DEFAULT '0.000000'"); //Drop unused fields from previous migration $migration->dropField($table, "price_taxfree2"); $migration->dropField($table, "price_discounted2"); $migration->migrationOneTable($table); //Forward entities_id and is_recursive into table glpi_plugin_order_orders_items $query = "SELECT `go`.`entities_id` as entities_id ,\n `go`.`is_recursive` as is_recursive, `goi`.`id` as items_id\n FROM `glpi_plugin_order_orders` as go, `{$table}` as `goi`\n WHERE `goi`.`plugin_order_orders_id`=`go`.`id`"; foreach ($DB->request($query) as $data) { $update = "UPDATE `{$table}`\n SET `entities_id`='" . $data['entities_id'] . "'\n AND `is_recursive`='" . $data['is_recursive'] . "'\n WHERE `id`='" . $data['items_id'] . "'"; $DB->query($update) or die($DB->error()); } $migration->executeMigration(); } }