function plugin_simcard_install() { include_once GLPI_ROOT . "/plugins/simcard/inc/profile.class.php"; include_once GLPI_ROOT . "/plugins/simcard/inc/simcard.class.php"; include_once GLPI_ROOT . "/plugins/simcard/inc/simcardsize.class.php"; include_once GLPI_ROOT . "/plugins/simcard/inc/simcardvoltage.class.php"; include_once GLPI_ROOT . "/plugins/simcard/inc/simcardtype.class.php"; include_once GLPI_ROOT . "/plugins/simcard/inc/phoneoperator.class.php"; include_once GLPI_ROOT . "/plugins/simcard/inc/simcard_item.class.php"; include_once GLPI_ROOT . "/plugins/simcard/inc/config.class.php"; $migration = new Migration(PLUGIN_SIMCARD_VERSION); if (plugin_simcard_currentVersion() == 0) { // Installation of the plugin PluginSimcardConfig::install($migration); PluginSimcardProfile::install($migration); PluginSimcardSimcard::install($migration); PluginSimcardSimcardSize::install($migration); PluginSimcardSimcardVoltage::install($migration); PluginSimcardSimcardType::install($migration); PluginSimcardPhoneOperator::install($migration); PluginSimcardSimcard_Item::install($migration); } else { PluginSimcardConfig::upgrade($migration); PluginSimcardProfile::upgrade($migration); PluginSimcardSimcard::upgrade($migration); PluginSimcardSimcardSize::upgrade($migration); PluginSimcardSimcardVoltage::upgrade($migration); PluginSimcardSimcardType::upgrade($migration); PluginSimcardPhoneOperator::upgrade($migration); PluginSimcardSimcard_Item::upgrade($migration); } return true; }
/** * * * @since 1.3 * */ static function upgrade(Migration $migration) { global $DB; switch (plugin_simcard_currentVersion()) { case '1.2': self::install($migration); break; } }
/** * * * **/ static function upgrade(Migration $migration) { global $DB; switch (plugin_simcard_currentVersion()) { case '1.2': self::install($migration); break; default: $table = getTableForItemType(__CLASS__); $query = "UPDATE `" . $table . "`\n SET `value`= '" . PLUGIN_SIMCARD_VERSION . "'\n WHERE `type`='Version'"; $DB->query($query) or die($DB->error()); } }
/** * * * @since 1.3 **/ static function upgrade(Migration $migration) { global $DB; $table = getTableForItemType(__CLASS__); switch (plugin_simcard_currentVersion()) { case '1.3': case '1.3.1': $query = "SELECT * FROM `glpi_plugin_simcard_profiles`"; $result = $DB->query($query); while ($data = $DB->fetch_assoc($result)) { // Write the access rights into the new ACLs system of GLPI 0.85 $translatedRight = self::translateARight($data['simcard']) + self::translateARight($data['open_ticket']); if ($translatedRight & READ) { $translatedRight = $translatedRight | READNOTE; } if ($translatedRight & UPDATE) { $translatedRight = $translatedRight | READNOTE | UPDATENOTE; } $profileRight = new ProfileRight(); $profileRightFields['profiles_id'] = $data['profiles_id']; $profileRightFields['name'] = self::RIGHT_SIMCARD_SIMCARD; $profileRightFields['rights'] = $translatedRight; if ($profileRight->add($profileRightFields) === false) { die('Fatal error migrating profile rights'); } // The plugin is not yet active, the hook will not trigger automatically plugin_simcard_profileRightUpdate($profileRight); } $query = "DROP TABLE `glpi_plugin_simcard_profiles`"; $DB->query($query) or die($DB->error()); break; case '1.4': case '1.4.1': } }
static function upgrade(Migration $migration) { global $DB; switch (plugin_simcard_currentVersion()) { case '1.2': $sql = "ALTER TABLE `glpi_plugin_simcard_simcards`\n ADD `plugin_simcard_simcardtypes_id` int(11) NOT NULL DEFAULT '0' AFTER `plugin_simcard_simcardvoltages_id`,\n \t ADD `groups_id_tech` int(11) NOT NULL DEFAULT '0' AFTER `groups_id`"; $DB->query($sql) or die($DB->error()); break; case '1.3': case '1.3.1': case '1.4': // Migrate notepad data if (FieldExists('glpi_plugin_simcard_simcards', 'notepad')) { $query = "SELECT id, notepad\n \t \t\tFROM `glpi_plugin_simcard_simcards`\n \t \t\tWHERE notepad IS NOT NULL\n \t \t\tAND notepad <> ''"; foreach ($DB->request($query) as $data) { $iq = "INSERT INTO `glpi_notepads`\n (`itemtype`, `items_id`, `content`, `date`, `date_mod`)\n VALUES ('" . getItemTypeForTable('glpi_plugin_simcard_simcards') . "', '" . $data['id'] . "',\n '" . addslashes($data['notepad']) . "', NOW(), NOW())"; $DB->queryOrDie($iq, "0.85 migrate notepad data"); } $sql = "ALTER TABLE `glpi_plugin_simcard_simcards`\n DROP `notepad`"; $DB->query($sql) or die($DB->error()); } break; } }
/** * * * @since 1.3 **/ static function upgrade(Migration $migration) { global $DB; $table = getTableForItemType(__CLASS__); switch (plugin_simcard_currentVersion()) { case '1.3': $query = "SELECT * FROM `glpi_plugin_simcard_profiles`"; $result = $DB->query($query); while ($data = $DB->fetch_assoc($result)) { // Lire les droits dans le nouveau système d'ACLs GLPI 0.85 $current_rights = ProfileRight::getProfileRights($data['profiles_id'], array_values($matching)); $query = "INSERT INTO `glpi_profilerights`\n SET `rights`='" . self::translateARight($data[$old]) . "',\n\t\t\t `profiles_id`='" . $data['profiles_id'] . "',\n\t\t\t `name`='" . self::RIGHT_SIMCARD_SIMCARD . "'"; $DB->query($query) or die($DB->error()); } $query = "DROP TABLE `glpi_plugin_simcard_profiles`"; $DB->query($query) or die($DB->error()); } }
static function upgrade(Migration $migration) { global $DB; switch (plugin_simcard_currentVersion()) { case '1.2': $sql = "ALTER TABLE `glpi_plugin_simcard_simcards`\n ADD `plugin_simcard_simcardtypes_id` int(11) NOT NULL DEFAULT '0' AFTER `plugin_simcard_simcardvoltages_id`,\n \t ADD `groups_id_tech` int(11) NOT NULL DEFAULT '0' AFTER `groups_id`"; $DB->query($sql) or die($DB->error()); break; } }