phpgroupware-cvs
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Phpgroupware-cvs] [18388] enhanced roles and default flow


From: Pascal Vilarem
Subject: [Phpgroupware-cvs] [18388] enhanced roles and default flow
Date: Mon, 10 Dec 2007 21:51:55 +0000

Revision: 18388
          
http://svn.sv.gnu.org/viewvc/?view=rev&root=phpgroupware&revision=18388
Author:   maat
Date:     2007-12-10 21:51:54 +0000 (Mon, 10 Dec 2007)

Log Message:
-----------
enhanced roles and default flow

Modified Paths:
--------------
    trunk/ged/setup/default_records.inc.php
    trunk/ged/setup/tables_update.inc.php

Modified: trunk/ged/setup/default_records.inc.php
===================================================================
--- trunk/ged/setup/default_records.inc.php     2007-12-10 21:46:40 UTC (rev 
18387)
+++ trunk/ged/setup/default_records.inc.php     2007-12-10 21:51:54 UTC (rev 
18388)
@@ -192,6 +192,7 @@
 $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')" );
+$oProc->query ("INSERT INTO `phpgw_flows_transitions` VALUES (22, 1, 
'pending_for_acceptation', 'pending_for_acceptation', 'update', 'update')" );
 
 
 // ged default flow : transitions custom values
@@ -206,6 +207,7 @@
 $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')" );
+$oProc->query ("INSERT INTO `phpgw_flows_transitions_custom_values` VALUES 
(11, 22, 'update_mode', 'new')" );
 
 // ged default flow : triggers
 
@@ -222,52 +224,93 @@
 
 $oProc->query ("INSERT INTO `phpgw_flows_conditions` (`condition_id`, 
`transition`, `app`, `class`, `method`, `context`) VALUES (1, 17, 'ged', 
'flow_client', 'is_last_version', '')");
 $oProc->query ("INSERT INTO `phpgw_flows_conditions` (`condition_id`, 
`transition`, `app`, `class`, `method`, `context`) VALUES (2, 18, 'ged', 
'flow_client', 'is_last_version', '')");
+$oProc->query ("INSERT INTO `phpgw_flows_conditions` (`condition_id`, 
`transition`, `app`, `class`, `method`, `context`) VALUES (3, 22, 'ged', 
'flow_client', 'is_last_version', '')");
 
+
 // ged default flow : admin roles
 
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (1,1,6,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (2,2,6,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (3,3,6,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (4,4,6,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (5,5,6,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (6,6,6,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (7,7,6,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (8,8,6,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (9,9,6,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (10,10,6,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (11,11,6,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (12,12,6,NULL)" );
-$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,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)" );
+$admins_uid=2;
 
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (22,1,2,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (23,2,2,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (24,3,2,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (25,4,2,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (26,5,2,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (27,6,2,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (28,7,2,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (29,8,2,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (30,9,2,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (31,10,2,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (32,11,2,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (33,12,2,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (34,13,2,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (35,14,2,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (36,15,2,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (37,16,2,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (38,17,2,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (39,18,2,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (40,19,2,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (41,20,2,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES (42,21,2,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,1,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,2,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,3,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,4,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,5,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,6,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,7,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,8,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,9,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,10,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,11,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,12,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,13,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,14,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,15,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,16,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,17,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,18,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,19,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,21,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,21,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,22,$admins_uid,NULL)" );
 
+// ged default flow : managers roles
 
+$managers_uid=3;
+
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,1,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,2,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,3,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,4,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,5,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,6,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,7,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,8,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,9,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,10,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,11,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,12,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,13,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,14,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,15,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,16,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,17,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,18,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,19,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,20,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,21,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,22,$managers_uid,NULL)" );
+
+// ged default flow : team roles
+
+$teams_uid=4;
+
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,1,$teams_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,16,$teams_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,17,$teams_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,18,$teams_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,19,$teams_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,22,$teams_uid,NULL)" );
+
+
+// ged default flow : quality roles
+
+$quality_uid=5;
+
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,1,$quality_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,16,$quality_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,17,$quality_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,18,$quality_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,19,$quality_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,22,$quality_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,3,$quality_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,8,$quality_uid,NULL)" );
+
+// ged default flow : customer roles
+
+$customers_uid=6;
+
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,5,$customers_uid,NULL)" );
+$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(NULL,6,$customers_uid,NULL)" );
+
 ?>
\ No newline at end of file

Modified: trunk/ged/setup/tables_update.inc.php
===================================================================
--- trunk/ged/setup/tables_update.inc.php       2007-12-10 21:46:40 UTC (rev 
18387)
+++ trunk/ged/setup/tables_update.inc.php       2007-12-10 21:51:54 UTC (rev 
18388)
@@ -372,11 +372,11 @@
                $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')" );        
-               
+               $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
                
                $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_triggers` VALUES 
(1,5,'ged','flow_client','apply_transition_to_previous_versions_matching_status','a:1:{s:10:\"transition\";i:11;}')"
 );
@@ -387,7 +387,7 @@
                $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
 
                $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_conditions` (`condition_id`, `transition`, `app`, `class`, 
`method`, `context`) VALUES (1, 17, 'ged', 'flow_client', 'is_last_version', 
'')");
@@ -395,50 +395,90 @@
 
                // ged default flow : admin roles
                
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (1,1,6,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (2,2,6,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (3,3,6,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (4,4,6,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (5,5,6,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (6,6,6,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (7,7,6,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (8,8,6,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (9,9,6,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (10,10,6,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (11,11,6,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (12,12,6,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (13,13,6,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (14,14,6,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (15,15,6,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (16,16,6,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (17,17,6,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (18,18,6,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (19,19,6,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (20,20,6,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (21,21,6,NULL)" );
+               $admins_uid=2;
 
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (22,1,2,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (23,2,2,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (24,3,2,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (25,4,2,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (26,5,2,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (27,6,2,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (28,7,2,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (29,8,2,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (30,9,2,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (31,10,2,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (32,11,2,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (33,12,2,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (34,13,2,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (35,14,2,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (36,15,2,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (37,16,2,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (38,17,2,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (39,18,2,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (40,19,2,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (41,20,2,NULL)" );
-               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (42,21,2,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,1,$admins_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,2,$admins_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,3,$admins_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,4,$admins_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,5,$admins_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,6,$admins_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,7,$admins_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,8,$admins_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,9,$admins_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,10,$admins_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,11,$admins_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,12,$admins_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,13,$admins_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,14,$admins_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,15,$admins_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,16,$admins_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,17,$admins_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,18,$admins_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,19,$admins_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,21,$admins_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,21,$admins_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,22,$admins_uid,NULL)" );
+
+               // ged default flow : managers roles
                
+               $managers_uid=3;
+
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,1,$managers_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,2,$managers_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,3,$managers_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,4,$managers_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,5,$managers_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,6,$managers_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,7,$managers_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,8,$managers_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,9,$managers_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,10,$managers_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,11,$managers_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,12,$managers_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,13,$managers_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,14,$managers_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,15,$managers_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,16,$managers_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,17,$managers_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,18,$managers_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,19,$managers_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,20,$managers_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,21,$managers_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,22,$managers_uid,NULL)" );
+
+               // ged default flow : team roles
+               
+               $teams_uid=4;
+
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,1,$teams_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,16,$teams_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,17,$teams_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,18,$teams_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,19,$teams_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,22,$teams_uid,NULL)" );
+
+
+               // ged default flow : quality roles
+               
+               $quality_uid=5;
+
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,1,$quality_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,16,$quality_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,17,$quality_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,18,$quality_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,19,$quality_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,22,$quality_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,3,$quality_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,8,$quality_uid,NULL)" );
+
+               // ged default flow : customer roles
+               
+               $customers_uid=6;
+
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,5,$customers_uid,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (NULL,6,$customers_uid,NULL)" );
+               
                $GLOBALS['setup_info']['ged']['currentver']='0.9.18.007';
                return $GLOBALS['setup_info']['ged']['currentver'];             
        
                






reply via email to

[Prev in Thread] Current Thread [Next in Thread]