Changeset 1275 for trunk/workflow/setup

Timestamp:

08/05/09 16:46:05 (15 years ago)

Author:

viani

Message:

Ticket #589 - Atualizacao de tabelas no organograma do workflow

Location:

trunk/workflow/setup

Files:

• setup.inc.php (modified) (2 diffs)
• tables_update.inc.php (modified) (3 diffs)

trunk/workflow/setup/setup.inc.php

@@ -13 +13 @@
         $setup_info['workflow']['name']                 = 'workflow';
         $setup_info['workflow']['title']                = 'Workflow management';
-        $setup_info['workflow']['version']              = '1.8.05.000';
-        $setup_info['workflow']['app_order']            = 10;
+        $setup_info['workflow']['version']              = '1.8.06.000';
+        $setup_info['workflow']['app_order']    = 10;
         $setup_info['workflow']['enable']               = 1;
-        $setup_info['workflow']['author']               = 'Ported from tikiwiki, modified by regis_glc alpeb & mbartz<br>Customized to ExpressoLivre by viani, rodrigolira, mariceli, drovetto, carloseduardo, rufino, asaikawa & gbisotto';
+        $setup_info['workflow']['author']               = 'Ported from tikiwiki, modified by regis_glc alpeb & mbartz<br>Customized to ExpressoLivre by viani, rodrigolira, mariceli, drovetto, carloseduardo, rufino, asaikawa, gbisotto & rodsouza<br>See changeLog for full names.';
         $setup_info['workflow']['note']                 = 'Workflow engine';
         $setup_info['workflow']['license']              = 'GPL';
-        $setup_info['workflow']['description']          = 'Workflow management';
-        $setup_info['workflow']['maintainer']           = 'Regis Leroy';
-        $setup_info['workflow']['maintainer_email']     = 'regis.leroy AT glconseil DOT com';
+        $setup_info['workflow']['description']          = 'Workflow Management';
+        $setup_info['workflow']['maintainer']           = 'Mauricio Luiz Viani';
+        $setup_info['workflow']['maintainer_email']     = 'viani AT celepar DOT pr DOT gov DOT br';
         $setup_info['workflow']['tables']               = array(
-                                                                'egw_wf_activities', 
-                                                                'egw_wf_activity_roles', 
-                                                                'egw_wf_instance_activities', 
-                                                                'egw_wf_instances', 
-                                                                'egw_wf_processes', 
-                                                                'egw_wf_roles', 
-                                                                'egw_wf_transitions', 
+                                                                'egw_wf_activities',
+                                                                'egw_wf_activity_roles',
+                                                                'egw_wf_instance_activities',
+                                                                'egw_wf_instances',
+                                                                'egw_wf_processes',
+                                                                'egw_wf_roles',
+                                                                'egw_wf_transitions',
                                                                 'egw_wf_user_roles',
                                                                 'egw_wf_workitems',
@@ -56 +56 @@
         $setup_info['workflow']['hooks'][] = 'home';
 
-        /* Dependencies for this app to work */ 
+        /* Dependencies for this app to work */
         $setup_info['workflow']['depends'][] = array(
                 'appname' => 'phpgwapi',

trunk/workflow/setup/tables_update.inc.php

@@ -1132 +1132 @@
                 return $GLOBALS['setup_info']['workflow']['currentver'];
         }
-        
+
         $test[] = '1.8.04.000';
         function workflow_upgrade1_8_04_000()
@@ -1139 +1139 @@
                 if (!$GLOBALS['phpgw_setup']->oProc->m_bDeltaOnly)
                 {
-                        $GLOBALS['phpgw']->ADOdb->query('CREATE INDEX egw_wf_workitems_wf_instance_id_idx ON egw_wf_workitems(wf_instance_id)');                        
+                        $GLOBALS['phpgw']->ADOdb->query('CREATE INDEX egw_wf_workitems_wf_instance_id_idx ON egw_wf_workitems(wf_instance_id)');
                 }
 
@@ -1146 +1146 @@
                 return $GLOBALS['setup_info']['workflow']['currentver'];
         }
+
+        $test[] = '1.8.05.000';
+        function workflow_upgrade1_8_05_000()
+        {
+                /* Alter tables of orgchart */
+                if (!$GLOBALS['phpgw_setup']->oProc->m_bDeltaOnly)
+                {
+                        $workflowHostInfo = extractDatabaseParameters();
+
+                        /* connect to workflow database */
+                        $workflowDB = $GLOBALS['phpgw']->ADOdb;
+                        if ($workflowDB->connect($workflowHostInfo['host'], $workflowHostInfo['user'], $workflowHostInfo['password'], 'workflow'))
+                        {
+                                /* add the new columns */
+                                $workflowDB->query('ALTER TABLE public.funcionario ADD COLUMN titulo CHARACTER VARYING(30)');
+                                $workflowDB->query('ALTER TABLE public.organizacao ADD COLUMN sitio CHARACTER VARYING(100)');
+                                $workflowDB->query('ALTER TABLE public.localidade ADD COLUMN empresa CHARACTER VARYING(100)');
+                                $workflowDB->query('ALTER TABLE public.localidade ADD COLUMN endereco CHARACTER VARYING(100)');
+                                $workflowDB->query('ALTER TABLE public.localidade ADD COLUMN complemento CHARACTER VARYING(50)');
+                                $workflowDB->query('ALTER TABLE public.localidade ADD COLUMN cep CHARACTER VARYING(9)');
+                                $workflowDB->query('ALTER TABLE public.localidade ADD COLUMN bairro CHARACTER VARYING(30)');
+                                $workflowDB->query('ALTER TABLE public.localidade ADD COLUMN cidade CHARACTER VARYING(50)');
+                                $workflowDB->query('ALTER TABLE public.localidade ADD COLUMN uf CHARACTER(2)');
+
+                                /* create table telefone */
+                                $workflowDB->query('CREATE TABLE public.telefone (telefone_id serial NOT NULL, descricao character varying(50) NOT NULL, numero character varying(50) NOT NULL, organizacao_id integer NOT NULL)');
+                                $workflowDB->query('ALTER TABLE ONLY public.telefone ADD CONSTRAINT telefone_pkey PRIMARY KEY (telefone_id)');
+                                $workflowDB->query('ALTER TABLE ONLY public.telefone ADD CONSTRAINT "$1" FOREIGN KEY (organizacao_id) REFERENCES organizacao(organizacao_id)');
+                                $workflowDB->query("GRANT ALL ON TABLE public.telefone TO admin_workflow");
+                                $workflowDB->query("GRANT ALL ON TABLE public.telefone TO postgres");
+                                $workflowDB->query("GRANT SELECT ON TABLE public.telefone TO public");
+                                $workflowDB->query("GRANT ALL ON TABLE public.telefone_telefone_id_seq TO admin_workflow");
+                                $workflowDB->query("GRANT ALL ON TABLE public.telefone_telefone_id_seq TO postgres");
+                                $workflowDB->query("GRANT SELECT ON TABLE public.telefone_telefone_id_seq TO public");
+                        }
+
+                        /* reconnect to the previous database */
+                        $GLOBALS['phpgw']->ADOdb->connect($workflowHostInfo['host'], $workflowHostInfo['user'], $workflowHostInfo['password'], $workflowHostInfo['dbname']);
+                }
+                #updating the current version
+                $GLOBALS['setup_info']['workflow']['currentver'] = '1.8.06.000';
+                return $GLOBALS['setup_info']['workflow']['currentver'];
+        }
 ?>