Changeset 15767 for trunk/modules

Timestamp:

12/15/11 02:10:04 (5 months ago)

Author:

Alexander Trofimov

Message:

Groups - remake according to new modules widget system

Location:

trunk/modules/boonex/groups/install

Files:

• config.php (modified) (4 diffs)
• sql/disable.sql (modified) (1 diff)
• sql/enable.sql (modified) (2 diffs)
• sql/install.sql (modified) (1 diff)
• sql/uninstall.sql (modified) (2 diffs)

trunk/modules/boonex/groups/install/config.php

@@ -25 +25 @@
      */
     'type' => BX_DOL_MODULE_TYPE_MODULE,
+    'name' => 'bx_groups',
     'title' => 'Groups',
     'note' => 'Socializing by common interests in groups.',
@@ -68 +69 @@
         'recompile_alerts' => 0,
         'clear_db_cache' => 1,
-        'show_conclusion' => 1,
+        'show_conclusion' => 0,
     ),
     'uninstall' => array (
@@ -91 +92 @@
         'recompile_alerts' => 0,
         'clear_db_cache' => 1,
-        'show_conclusion' => 1,
+        'show_conclusion' => 0,
     ),
     'enable' => array(
@@ -160 +161 @@
     'install_info' => array(
         'introduction' => '',
-        'conclusion' => 'inst_concl.html'
+        'conclusion' => ''
     ),
     'uninstall_info' => array(
         'introduction' => '',
-        'conclusion' => 'uninst_concl.html'
+        'conclusion' => ''
     )
 );

trunk/modules/boonex/groups/install/sql/disable.sql

@@ +1 @@
+
+-- studio page and widget
+SET @iPageId = (SELECT `id` FROM `sys_std_pages` WHERE `name`='bx_groups' LIMIT 1);
+UPDATE `sys_std_widgets` SET `status`='2' WHERE `page_id`=@iPageId LIMIT 1;
+
 
 -- compose pages

trunk/modules/boonex/groups/install/sql/enable.sql

@@ +1 @@
+
+-- studio page and widget
+SET @iPageId = (SELECT `id` FROM `sys_std_pages` WHERE `name`='bx_groups' LIMIT 1);
+UPDATE `sys_std_widgets` SET `status`='1' WHERE `page_id`=@iPageId LIMIT 1;
 
 -- page compose pages
@@ -30 +34 @@
 SET @iTypeOrder = (SELECT MAX(`order`) FROM `sys_options_types` WHERE `group`='modules');
 INSERT INTO `sys_options_types`(`group`, `name`, `caption`, `icon`, `order`) VALUES 
-('modules', 'bx_groups', '_bx_groups_adm_stg_cpt_type', 'modules/boonex/groups/|mi-std.png', IF(ISNULL(@iTypeOrder), 1, @iTypeOrder + 1));
+('modules', 'bx_groups', '_bx_groups', 'modules/boonex/groups/|mi-std.png', IF(ISNULL(@iTypeOrder), 1, @iTypeOrder + 1));
 SET @iTypeId = LAST_INSERT_ID();
 
 INSERT INTO `sys_options_categories` (`type_id`, `name`, `caption`, `order` )  
-VALUES (@iTypeId, 'bx_groups', '_bx_groups_adm_stg_cpt_category', 1);
+VALUES (@iTypeId, 'bx_groups', '_bx_groups', 1);
 SET @iCategId = LAST_INSERT_ID();
 

trunk/modules/boonex/groups/install/sql/install.sql

@@ +1 @@
+
+-- Studio page and widget.
+INSERT INTO `sys_std_pages`(`index`, `name`, `header`, `caption`, `icon`) VALUES
+(3, 'bx_groups', '_bx_groups', '_bx_groups', 'modules/boonex/groups/|std-pi.png');
+SET @iPageId = LAST_INSERT_ID();
+
+SET @iParentPageId = (SELECT `id` FROM `sys_std_pages` WHERE `name`='modules');
+SET @iParentPageOrder = (SELECT MAX(`order`) FROM `sys_std_pages_widgets` WHERE `page_id`=@iParentPageId);
+INSERT INTO `sys_std_widgets`(`page_id`, `url`, `click`, `icon`, `caption`, `cnt_notices`, `cnt_actions`, `status`) VALUES
+(@iPageId, CONCAT('{url_studio}module.php?name=', 'bx_groups'), '', 'modules/modules/boonex/groups/|std-wi.png', '_bx_groups', '', '', 2);
+INSERT INTO `sys_std_pages_widgets`(`page_id`, `widget_id`, `order`) VALUES
+(@iParentPageId, LAST_INSERT_ID(), IF(ISNULL(@iParentPageOrder), 1, @iParentPageOrder + 1));
+
+
+
 -- create tables
 CREATE TABLE IF NOT EXISTS `[db_prefix]main` (

trunk/modules/boonex/groups/install/sql/uninstall.sql

@@ +1 @@
+
+-- studio page and widget
+DELETE FROM `tp`, `tw`, `tpw`
+USING `sys_std_pages` AS `tp`, `sys_std_widgets` AS `tw`, `sys_std_pages_widgets` AS `tpw`
+WHERE `tp`.`id`=`tw`.`page_id` AND `tw`.`id`=`tpw`.`widget_id` AND `tp`.`name`='bx_groups';
 
 -- tables
@@ -24 +29 @@
 DELETE FROM `sys_sbs_types` WHERE `unit`='bx_groups';
 
-