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;
}
}
