[Phpgroupware-cvs] ged/setup tables_update.inc.php default_records...

[Pascal Vilarem]

CVSROOT:        /sources/phpgroupware
Module name:    ged
Changes by:     Pascal Vilarem <maat>   07/10/29 21:22:03

Modified files:
        setup          : tables_update.inc.php default_records.inc.php 

Log message:
        added 2 missing default triggers for default flow

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/ged/setup/tables_update.inc.php?cvsroot=phpgroupware&r1=1.15&r2=1.16
http://cvs.savannah.gnu.org/viewcvs/ged/setup/default_records.inc.php?cvsroot=phpgroupware&r1=1.4&r2=1.5

Patches:
Index: tables_update.inc.php
===================================================================
RCS file: /sources/phpgroupware/ged/setup/tables_update.inc.php,v
retrieving revision 1.15
retrieving revision 1.16
diff -u -b -r1.15 -r1.16
--- tables_update.inc.php       27 Oct 2007 09:09:17 -0000      1.15
+++ tables_update.inc.php       29 Oct 2007 21:22:03 -0000      1.16
@@ -359,10 +359,9 @@
                $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_transitions` VALUES (16, 1, 'working', 'working', 'update', 
'update')" );
                $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_transitions` VALUES (17, 1, 'current', 'current', 'update', 
'update')" );
                $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_transitions` VALUES (18, 1, 'refused', 'refused', 'update', 
'update')" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_transitions` VALUES (19, 1, 'working', 'locked', 'lock', 
'set_status')" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_transitions` VALUES (20, 1, 'locked', 'working', 'unlock', 
'set_status')" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_transitions` VALUES (21, 1, 'locked', 'locked', 'update', 
'update')" );
-
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_transitions` VALUES (19, 1, 'working', 'working_locked', 'lock', 
'set_status')" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_transitions` VALUES (20, 1, 'working_locked', 'working', 'unlock', 
'set_status')" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_transitions` VALUES (21, 1, 'working_locked', 'working_locked', 
'update', 'update')" );
                
                // ged default flow : transitions custom values
                
@@ -372,6 +371,10 @@
                $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_transitions_custom_values` VALUES 
(4,6,'review_file_type','fiche-relecture-externe')" );
                $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_transitions_custom_values` VALUES 
(5,7,'review_file_type','fiche-relecture-interne')" );
                $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_transitions_custom_values` VALUES 
(6,8,'review_file_type','fiche-relecture-interne')" );
+               $GLOBALS['phpgw_setup']->oProc-->query ("INSERT INTO 
`phpgw_flows_transitions_custom_values` VALUES (7, 16, 'update_mode', 
'update')" );
+               $GLOBALS['phpgw_setup']->oProc-->query ("INSERT INTO 
`phpgw_flows_transitions_custom_values` VALUES (8, 17, 'update_mode', 'new')" );
+               $GLOBALS['phpgw_setup']->oProc-->query ("INSERT INTO 
`phpgw_flows_transitions_custom_values` VALUES (9, 18, 'update_mode', 'new')" );
+               $GLOBALS['phpgw_setup']->oProc-->query ("INSERT INTO 
`phpgw_flows_transitions_custom_values` VALUES (10, 21, 'update_mode', 
'update')" );       
                
                // ged default flow : triggers
                
@@ -379,6 +382,10 @@
                $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_triggers` VALUES 
(2,11,'ged','flow_client','apply_transition_to_linking_versions_with_link_type','a:2:{s:10:\"transition\";i:13;s:9:\"link_type\";s:10:\"dependancy\";}')"
 );
                $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_triggers` VALUES 
(3,4,'ged','flow_client','apply_transition_to_linked_versions_with_link_type','a:2:{s:10:\"transition\";i:4;s:9:\"link_type\";s:8:\"delivery\";}')"
 );
                $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_triggers` VALUES 
(4,5,'ged','flow_client','apply_transition_to_previous_versions_matching_status','a:1:{s:10:\"transition\";i:15;}')"
 );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_triggers` VALUES (5,19, 'ged', 'flows', 'grant_role', 
'a:1:{s:10:\"transition\";i:20;}')" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_triggers` VALUES (6,20, 'ged', 'flows', 'remove_role', 
'a:1:{s:10:\"transition\";i:20;}')" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_triggers` VALUES (7,19, 'ged', 'flows', 'grant_role', 
'a:1:{s:10:\"transition\";i:21;}')" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_triggers` VALUES (8,20, 'ged', 'flows', 'remove_role', 
'a:1:{s:10:\"transition\";i:21;}')" );
                
                // ged default flow : conditions
 

Index: default_records.inc.php
===================================================================
RCS file: /sources/phpgroupware/ged/setup/default_records.inc.php,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -b -r1.4 -r1.5
--- default_records.inc.php     27 Oct 2007 09:09:17 -0000      1.4
+++ default_records.inc.php     29 Oct 2007 21:22:03 -0000      1.5
@@ -167,6 +167,7 @@
 $oProc->query ("INSERT INTO `phpgw_flows_statuses` VALUES 
('refused','ged','refused')," );
 $oProc->query ("INSERT INTO `phpgw_flows_statuses` VALUES 
('obsolete','ged','obsolete')," );
 $oProc->query ("INSERT INTO `phpgw_flows_statuses` VALUES 
('alert','ged','alert');" );
+$oProc->query ("INSERT INTO `phpgw_flows_statuses` VALUES ('working_locked', 
'ged', 'working (locked)');" );
 
 // ged default flow : transitions
 
@@ -188,9 +189,9 @@
 $oProc->query ("INSERT INTO `phpgw_flows_transitions` VALUES (16, 1, 
'working', 'working', 'update', 'update')" );
 $oProc->query ("INSERT INTO `phpgw_flows_transitions` VALUES (17, 1, 
'current', 'current', 'update', 'update')" );
 $oProc->query ("INSERT INTO `phpgw_flows_transitions` VALUES (18, 1, 
'refused', 'refused', 'update', 'update')" );
-$oProc->query ("INSERT INTO `phpgw_flows_transitions` VALUES (19, 1, 
'working', 'locked', 'lock', 'set_status')" );
-$oProc->query ("INSERT INTO `phpgw_flows_transitions` VALUES (20, 1, 'locked', 
'working', 'unlock', 'set_status')" );
-$oProc->query ("INSERT INTO `phpgw_flows_transitions` VALUES (21, 1, 'locked', 
'locked', 'update', 'update')" );
+$oProc->query ("INSERT INTO `phpgw_flows_transitions` VALUES (19, 1, 
'working', 'working_locked', 'lock', 'set_status')" );
+$oProc->query ("INSERT INTO `phpgw_flows_transitions` VALUES (20, 1, 
'working_locked', 'working', 'unlock', 'set_status')" );
+$oProc->query ("INSERT INTO `phpgw_flows_transitions` VALUES (21, 1, 
'working_locked', 'working_locked', 'update', 'update')" );
 
 
 // ged default flow : transitions custom values
@@ -201,6 +202,10 @@
 $oProc->query ("INSERT INTO `phpgw_flows_transitions_custom_values` VALUES 
(4,6,'review_file_type','fiche-relecture-externe')" );
 $oProc->query ("INSERT INTO `phpgw_flows_transitions_custom_values` VALUES 
(5,7,'review_file_type','fiche-relecture-interne')" );
 $oProc->query ("INSERT INTO `phpgw_flows_transitions_custom_values` VALUES 
(6,8,'review_file_type','fiche-relecture-interne')" );
+$oProc->query ("INSERT INTO `phpgw_flows_transitions_custom_values` VALUES (7, 
16, 'update_mode', 'update')" );
+$oProc->query ("INSERT INTO `phpgw_flows_transitions_custom_values` VALUES (8, 
17, 'update_mode', 'new')" );
+$oProc->query ("INSERT INTO `phpgw_flows_transitions_custom_values` VALUES (9, 
18, 'update_mode', 'new')" );
+$oProc->query ("INSERT INTO `phpgw_flows_transitions_custom_values` VALUES 
(10, 21, 'update_mode', 'update')" );
 
 // ged default flow : triggers
 
@@ -208,6 +213,10 @@
 $oProc->query ("INSERT INTO `phpgw_flows_triggers` VALUES 
(2,11,'ged','flow_client','apply_transition_to_linking_versions_with_link_type','a:2:{s:10:\"transition\";i:13;s:9:\"link_type\";s:10:\"dependancy\";}')"
 );
 $oProc->query ("INSERT INTO `phpgw_flows_triggers` VALUES 
(3,4,'ged','flow_client','apply_transition_to_linked_versions_with_link_type','a:2:{s:10:\"transition\";i:4;s:9:\"link_type\";s:8:\"delivery\";}')"
 );
 $oProc->query ("INSERT INTO `phpgw_flows_triggers` VALUES 
(4,5,'ged','flow_client','apply_transition_to_previous_versions_matching_status','a:1:{s:10:\"transition\";i:15;}')"
 );
+$oProc->query ("INSERT INTO `phpgw_flows_triggers` VALUES (5,19, 'ged', 
'flows', 'grant_role', 'a:1:{s:10:\"transition\";i:20;}')" );
+$oProc->query ("INSERT INTO `phpgw_flows_triggers` VALUES (6,20, 'ged', 
'flows', 'remove_role', 'a:1:{s:10:\"transition\";i:20;}')" );
+$oProc->query ("INSERT INTO `phpgw_flows_triggers` VALUES (7,19, 'ged', 
'flows', 'grant_role', 'a:1:{s:10:\"transition\";i:21;}')" );
+$oProc->query ("INSERT INTO `phpgw_flows_triggers` VALUES (8,20, 'ged', 
'flows', 'remove_role', 'a:1:{s:10:\"transition\";i:21;}')" );
 
 // ged default flow : conditions
 
@@ -231,10 +240,11 @@
 $oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (13,13,6,NULL)" );
 $oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (14,14,6,NULL)" );
 $oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (15,15,6,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (16,1,16,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (17,16,6, NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (18,17,6, NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (19,18,6, NULL)" );
-
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (16,16,6,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (17,17,6, NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (18,18,6, NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (19,19,6, NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (20,21,6, NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (21,21,6, NULL)" );
 
 ?>
\ No newline at end of file