1
0

enable.sql 3.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445
  1. -- Email template
  2. INSERT INTO `sys_email_templates` (`Module`, `NameSystem`, `Name`, `Subject`, `Body`) VALUES
  3. ('bx_cidaascon', '_bx_cidaascon_et_password_generated', 'bx_cidaascon_password_generated', '_bx_cidaascon_et_password_generated_subject', '_bx_cidaascon_et_password_generated_body');
  4. -- Auth objects
  5. INSERT INTO `sys_objects_auths` (`Name`, `Title`, `Link`, `Icon`, `Style`) VALUES
  6. ('bx_cidaascon', '_bx_cidaascon_auth_title', 'modules/?r=cidaascon/start', 'fas fingerprint', 'a:1:{s:7:".bx-btn";a:1:{s:10:"background";s:18:"#00a0b0 !important";}}');
  7. -- Alerts
  8. INSERT INTO `sys_alerts_handlers` SET `name` = 'bx_cidaascon', `class` = 'BxCidaasConAlerts', `file` = 'modules/boonex/cidaas_connect/classes/BxCidaasConAlerts.php';
  9. SET @iHandlerId := (SELECT `id` FROM `sys_alerts_handlers` WHERE `name` = 'bx_cidaascon');
  10. INSERT INTO `sys_alerts` (`unit`, `action`, `handler_id`) VALUES
  11. ('account', 'logout', @iHandlerId),
  12. ('profile', 'delete', @iHandlerId),
  13. ('profile', 'add', @iHandlerId);
  14. -- Options
  15. SET @iTypeOrder = (SELECT MAX(`order`) FROM `sys_options_types` WHERE `group` = 'modules');
  16. INSERT INTO `sys_options_types` (`group`, `name`, `caption`, `icon`, `order`) VALUES
  17. ('modules', 'bx_cidaascon', '_bx_cidaascon_adm_stg_cpt_type', 'bx_cidaascon@modules/boonex/cidaas_connect/|std-icon.svg', IF(NOT ISNULL(@iTypeOrder), @iTypeOrder + 1, 1));
  18. SET @iTypeId = LAST_INSERT_ID();
  19. INSERT INTO `sys_options_categories` (`type_id`, `name`, `caption`, `order` )
  20. VALUES (@iTypeId, 'bx_cidaascon_general', '_sys_connect_adm_stg_cpt_category_general', 1);
  21. SET @iCategId = LAST_INSERT_ID();
  22. INSERT INTO `sys_options` (`name`, `value`, `category_id`, `caption`, `type`, `check`, `check_error`, `order`, `extra`) VALUES
  23. ('bx_cidaascon_base_url', '', @iCategId, '_bx_cidaascon_option_base_url', 'digit', '', '', 20, ''),
  24. ('bx_cidaascon_client_id', '', @iCategId, '_bx_cidaascon_option_client_id', 'digit', '', '', 22, ''),
  25. ('bx_cidaascon_secret', '', @iCategId, '_bx_cidaascon_option_secret', 'secret', '', '', 24, ''),
  26. ('bx_cidaascon_scope', 'openid profile email offline_access', @iCategId, '_bx_cidaascon_option_scope', 'digit', '', '', 26, ''),
  27. ('bx_cidaascon_pkce', '', @iCategId, '_bx_cidaascon_option_pkce', 'checkbox', '', '', 28, ''),
  28. ('bx_cidaascon_redirect_page', 'index', @iCategId, '_sys_connect_option_redirect', 'select', '', '', 40, 'join,settings,dashboard,index'),
  29. ('bx_cidaascon_module', 'bx_persons', @iCategId, '_sys_connect_option_module', 'select', '', '', 50, 'a:2:{s:6:"module";s:12:"bx_cidaascon";s:6:"method";s:20:"get_profiles_modules";}'),
  30. ('bx_cidaascon_privacy', '3', @iCategId, '_sys_connect_option_privacy', 'select', '', '', 54, 'a:2:{s:6:"module";s:12:"bx_cidaascon";s:6:"method";s:18:"get_privacy_groups";}'),
  31. ('bx_cidaascon_confirm_email', 'on', @iCategId, '_sys_connect_option_confirm_email', 'checkbox', '', '', 70, ''),
  32. ('bx_cidaascon_approve', '', @iCategId, '_sys_connect_option_approve', 'checkbox', '', '', 80, ''),
  33. ('bx_cidaascon_debug', '', @iCategId, '_bx_cidaascon_option_debug', 'checkbox', '', '', 90, '');