.
* ---------------------------------------------------------------------
* @copyright Copyright © 2021 - 2022 Edgard
* @license http://www.gnu.org/licenses/gpl.txt GPLv3+
* @link https://github.com/edgardmessias/glpi-singlesignon/
* ---------------------------------------------------------------------
*/
function plugin_singlesignon_display_login() {
global $CFG_GLPI;
$signon_provider = new PluginSinglesignonProvider();
$condition = '`is_active` = 1';
if (version_compare(GLPI_VERSION, '9.4', '>=')) {
$condition = [$condition];
}
$rows = $signon_provider->find($condition);
$html = [];
foreach ($rows as $row) {
$query = [];
if (isset($_REQUEST['redirect'])) {
$query['redirect'] = $_REQUEST['redirect'];
}
$url = PluginSinglesignonToolbox::getCallbackUrl($row['id'], $query);
$isDefault = PluginSinglesignonToolbox::isDefault($row);
if ($isDefault && !isset($_GET["noAUTO"])) {
Html::redirect($url);
return;
}
$html[] = PluginSinglesignonToolbox::renderButton($url, $row);
}
if (!empty($html)) {
echo '';
echo implode(" \n", $html);
echo PluginSinglesignonToolbox::renderButton('#', ['name' => __('GLPI')], 'vsubmit old-login');
echo '
';
?>
$value) {
if (!isset($current[$key])) {
$current[$key] = $value;
}
}
Config::setConfigurationValues('singlesignon', $current);
if (!sso_TableExists("glpi_plugin_singlesignon_providers")) {
$query = "CREATE TABLE `glpi_plugin_singlesignon_providers` (
`id` int(11) NOT NULL auto_increment,
`is_default` tinyint(1) NOT NULL DEFAULT '0',
`popup` tinyint(1) NOT NULL DEFAULT '0',
`split_domain` tinyint(1) NOT NULL DEFAULT '0',
`authorized_domains` varchar(255) COLLATE utf8_unicode_ci NULL,
`type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`client_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`client_secret` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`scope` varchar(255) COLLATE utf8_unicode_ci NULL,
`extra_options` varchar(255) COLLATE utf8_unicode_ci NULL,
`url_authorize` varchar(255) COLLATE utf8_unicode_ci NULL,
`url_access_token` varchar(255) COLLATE utf8_unicode_ci NULL,
`url_resource_owner_details` varchar(255) COLLATE utf8_unicode_ci NULL,
`is_active` tinyint(1) NOT NULL DEFAULT '0',
`use_email_for_login` tinyint(1) NOT NULL DEFAULT '0',
`split_name` tinyint(1) NOT NULL DEFAULT '0',
`is_deleted` tinyint(1) NOT NULL default '0',
`comment` text COLLATE utf8_unicode_ci,
`date_mod` timestamp NULL DEFAULT NULL,
`date_creation` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `date_mod` (`date_mod`),
KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query) or die("error creating glpi_plugin_singlesignon_providers " . $DB->error());
} else {
$query = "SHOW COLUMNS FROM glpi_plugin_singlesignon_providers LIKE 'is_default'";
$result = $DB->query($query) or die($DB->error());
if ($DB->numrows($result) != 1) {
$DB->query("ALTER TABLE glpi_plugin_singlesignon_providers ADD is_default tinyint(1) NOT NULL DEFAULT '0'") or die($DB->error());
}
$query = "SHOW COLUMNS FROM glpi_plugin_singlesignon_providers LIKE 'popup'";
$result = $DB->query($query) or die($DB->error());
if ($DB->numrows($result) != 1) {
$DB->query("ALTER TABLE glpi_plugin_singlesignon_providers ADD popup tinyint(1) NOT NULL DEFAULT '0'") or die($DB->error());
}
$query = "SHOW COLUMNS FROM glpi_plugin_singlesignon_providers LIKE 'split_domain'";
$result = $DB->query($query) or die($DB->error());
if ($DB->numrows($result) != 1) {
$DB->query("ALTER TABLE glpi_plugin_singlesignon_providers ADD split_domain tinyint(1) NOT NULL DEFAULT '0'") or die($DB->error());
}
$query = "SHOW COLUMNS FROM glpi_plugin_singlesignon_providers LIKE 'authorized_domains'";
$result = $DB->query($query) or die($DB->error());
if ($DB->numrows($result) != 1) {
$DB->query("ALTER TABLE glpi_plugin_singlesignon_providers ADD authorized_domains varchar(255) COLLATE utf8_unicode_ci NULL") or die($DB->error());
}
$query = "SHOW COLUMNS FROM glpi_plugin_singlesignon_providers LIKE 'use_email_for_login'";
$result = $DB->query($query) or die($DB->error());
if ($DB->numrows($result) != 1) {
$DB->query("ALTER TABLE glpi_plugin_singlesignon_providers ADD use_email_for_login tinyint(1) NOT NULL DEFAULT '0'") or die($DB->error());
}
$query = "SHOW COLUMNS FROM glpi_plugin_singlesignon_providers LIKE 'split_name'";
$result = $DB->query($query) or die($DB->error());
if ($DB->numrows($result) != 1) {
$DB->query("ALTER TABLE glpi_plugin_singlesignon_providers ADD split_name tinyint(1) NOT NULL DEFAULT '0'") or die($DB->error());
}
}
// add display preferences
$query_display_pref = "SELECT id
FROM glpi_displaypreferences
WHERE itemtype = 'PluginSinglesignonProvider'";
$res_display_pref = $DB->query($query_display_pref);
if ($DB->numrows($res_display_pref) == 0) {
$DB->query("INSERT INTO `glpi_displaypreferences` VALUES (NULL,'PluginSinglesignonProvider','2','1','0');");
$DB->query("INSERT INTO `glpi_displaypreferences` VALUES (NULL,'PluginSinglesignonProvider','3','2','0');");
$DB->query("INSERT INTO `glpi_displaypreferences` VALUES (NULL,'PluginSinglesignonProvider','5','4','0');");
$DB->query("INSERT INTO `glpi_displaypreferences` VALUES (NULL,'PluginSinglesignonProvider','6','5','0');");
$DB->query("INSERT INTO `glpi_displaypreferences` VALUES (NULL,'PluginSinglesignonProvider','10','6','0');");
}
if (!sso_TableExists("glpi_plugin_singlesignon_providers_users") && version_compare($currentVersion, "1.2.0", '<')) {
$query = "ALTER TABLE `glpi_plugin_singlesignon_providers`
ADD `picture` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
ADD `bgcolor` varchar(7) DEFAULT NULL,
ADD `color` varchar(7) DEFAULT NULL";
$DB->query($query) or die("error adding picture column " . $DB->error());
}
if (!sso_TableExists("glpi_plugin_singlesignon_providers_users") && version_compare($currentVersion, "1.3.0", '<')) {
$query = "CREATE TABLE `glpi_plugin_singlesignon_providers_users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`plugin_singlesignon_providers_id` int(11) NOT NULL DEFAULT '0',
`users_id` int(11) NOT NULL DEFAULT '0',
`remote_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `unicity` (`plugin_singlesignon_providers_id`,`users_id`),
UNIQUE KEY `unicity_remote` (`plugin_singlesignon_providers_id`,`remote_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;";
$DB->query($query) or die("error creating glpi_plugin_singlesignon_providers_users " . $DB->error());
}
Config::setConfigurationValues('singlesignon', [
'version' => PLUGIN_SINGLESIGNON_VERSION,
]);
return true;
}
function plugin_singlesignon_uninstall() {
global $DB;
$config = new Config();
$condition = "`context` LIKE 'singlesignon%'";
if (version_compare(GLPI_VERSION, '9.4', '>=')) {
$condition = [$condition];
}
$rows = $config->find($condition);
foreach ($rows as $id => $row) {
$config->delete(['id' => $id]);
}
// Old version tables
if (sso_TableExists("glpi_plugin_singlesignon_providers")) {
$query = "DROP TABLE `glpi_plugin_singlesignon_providers`";
$DB->query($query) or die("error deleting glpi_plugin_singlesignon_providers");
}
return true;
}