[795] | 1 | <?php |
---|
| 2 | /**************************************************************************\ |
---|
| 3 | * eGroupWare - Setup * |
---|
| 4 | * http://www.egroupware.org * |
---|
| 5 | * -------------------------------------------- * |
---|
| 6 | * This program is free software; you can redistribute it and/or modify it * |
---|
| 7 | * under the terms of the GNU General Public License as published by the * |
---|
| 8 | * Free Software Foundation; either version 2 of the License, or (at your * |
---|
| 9 | * option) any later version. * |
---|
| 10 | \**************************************************************************/ |
---|
| 11 | |
---|
| 12 | function extractDatabaseParameters() |
---|
| 13 | { |
---|
| 14 | /* extract the database connection parameters */ |
---|
| 15 | |
---|
| 16 | $workflowHostInfo = array(); |
---|
| 17 | if (!empty($GLOBALS['phpgw']->ADOdb->database)) |
---|
| 18 | { |
---|
| 19 | $workflowHostInfo = array( |
---|
| 20 | 'dbname' => $GLOBALS['phpgw']->ADOdb->database, |
---|
| 21 | 'host' => $GLOBALS['phpgw']->ADOdb->host, |
---|
[1981] | 22 | 'port' => $GLOBALS['phpgw']->ADOdb->port, |
---|
[795] | 23 | 'user' => $GLOBALS['phpgw']->ADOdb->user, |
---|
| 24 | 'password' => $GLOBALS['phpgw']->ADOdb->password); |
---|
| 25 | } |
---|
| 26 | else |
---|
| 27 | { |
---|
| 28 | $hostInfo = "dbname= host= password= port= user= " . $GLOBALS['phpgw']->ADOdb->host; |
---|
| 29 | $hostInfo = explode(' ', $hostInfo); |
---|
| 30 | foreach ($hostInfo as $parameter) |
---|
| 31 | { |
---|
| 32 | $currentParameter = explode('=', $parameter); |
---|
| 33 | $workflowHostInfo[$currentParameter[0]] = isset($currentParameter[1]) ? $currentParameter[1] : ""; |
---|
| 34 | } |
---|
| 35 | } |
---|
| 36 | if (($workflowHostInfo['password']{0} == "'") && ($workflowHostInfo['password']{strlen($workflowHostInfo['password'])-1} == "'")) |
---|
| 37 | $workflowHostInfo['password'] = substr($workflowHostInfo['password'], 1, strlen($workflowHostInfo['password']) - 2); |
---|
| 38 | |
---|
| 39 | return $workflowHostInfo; |
---|
| 40 | } |
---|
[3031] | 41 | // Since Expresso 1.2 using Workflow 1.8.04.000 |
---|
[1229] | 42 | $test[] = '1.8.04.000'; |
---|
| 43 | function workflow_upgrade1_8_04_000() |
---|
| 44 | { |
---|
| 45 | /* Create index for table egw_wf_workitems */ |
---|
| 46 | if (!$GLOBALS['phpgw_setup']->oProc->m_bDeltaOnly) |
---|
| 47 | { |
---|
[1275] | 48 | $GLOBALS['phpgw']->ADOdb->query('CREATE INDEX egw_wf_workitems_wf_instance_id_idx ON egw_wf_workitems(wf_instance_id)'); |
---|
[1229] | 49 | } |
---|
| 50 | |
---|
| 51 | #updating the current version |
---|
| 52 | $GLOBALS['setup_info']['workflow']['currentver'] = '1.8.05.000'; |
---|
| 53 | return $GLOBALS['setup_info']['workflow']['currentver']; |
---|
| 54 | } |
---|
[1275] | 55 | |
---|
| 56 | $test[] = '1.8.05.000'; |
---|
| 57 | function workflow_upgrade1_8_05_000() |
---|
| 58 | { |
---|
| 59 | /* Alter tables of orgchart */ |
---|
| 60 | if (!$GLOBALS['phpgw_setup']->oProc->m_bDeltaOnly) |
---|
| 61 | { |
---|
| 62 | $workflowHostInfo = extractDatabaseParameters(); |
---|
| 63 | |
---|
| 64 | /* connect to workflow database */ |
---|
| 65 | $workflowDB = $GLOBALS['phpgw']->ADOdb; |
---|
[1981] | 66 | if ($workflowDB->connect($workflowHostInfo['host'].":".$workflowHostInfo['port'], $workflowHostInfo['user'], $workflowHostInfo['password'], 'workflow')) |
---|
[1275] | 67 | { |
---|
| 68 | /* add the new columns */ |
---|
| 69 | $workflowDB->query('ALTER TABLE public.funcionario ADD COLUMN titulo CHARACTER VARYING(30)'); |
---|
| 70 | $workflowDB->query('ALTER TABLE public.organizacao ADD COLUMN sitio CHARACTER VARYING(100)'); |
---|
| 71 | $workflowDB->query('ALTER TABLE public.localidade ADD COLUMN empresa CHARACTER VARYING(100)'); |
---|
| 72 | $workflowDB->query('ALTER TABLE public.localidade ADD COLUMN endereco CHARACTER VARYING(100)'); |
---|
| 73 | $workflowDB->query('ALTER TABLE public.localidade ADD COLUMN complemento CHARACTER VARYING(50)'); |
---|
| 74 | $workflowDB->query('ALTER TABLE public.localidade ADD COLUMN cep CHARACTER VARYING(9)'); |
---|
| 75 | $workflowDB->query('ALTER TABLE public.localidade ADD COLUMN bairro CHARACTER VARYING(30)'); |
---|
| 76 | $workflowDB->query('ALTER TABLE public.localidade ADD COLUMN cidade CHARACTER VARYING(50)'); |
---|
| 77 | $workflowDB->query('ALTER TABLE public.localidade ADD COLUMN uf CHARACTER(2)'); |
---|
| 78 | |
---|
| 79 | /* create table telefone */ |
---|
| 80 | $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)'); |
---|
| 81 | $workflowDB->query('ALTER TABLE ONLY public.telefone ADD CONSTRAINT telefone_pkey PRIMARY KEY (telefone_id)'); |
---|
| 82 | $workflowDB->query('ALTER TABLE ONLY public.telefone ADD CONSTRAINT "$1" FOREIGN KEY (organizacao_id) REFERENCES organizacao(organizacao_id)'); |
---|
| 83 | $workflowDB->query("GRANT ALL ON TABLE public.telefone TO admin_workflow"); |
---|
| 84 | $workflowDB->query("GRANT ALL ON TABLE public.telefone TO postgres"); |
---|
| 85 | $workflowDB->query("GRANT SELECT ON TABLE public.telefone TO public"); |
---|
| 86 | $workflowDB->query("GRANT ALL ON TABLE public.telefone_telefone_id_seq TO admin_workflow"); |
---|
| 87 | $workflowDB->query("GRANT ALL ON TABLE public.telefone_telefone_id_seq TO postgres"); |
---|
| 88 | $workflowDB->query("GRANT SELECT ON TABLE public.telefone_telefone_id_seq TO public"); |
---|
| 89 | } |
---|
| 90 | |
---|
| 91 | /* reconnect to the previous database */ |
---|
[1981] | 92 | $GLOBALS['phpgw']->ADOdb->connect($workflowHostInfo['host'].":".$workflowHostInfo['port'], $workflowHostInfo['user'], $workflowHostInfo['password'], $workflowHostInfo['dbname']); |
---|
[1275] | 93 | } |
---|
| 94 | #updating the current version |
---|
[1328] | 95 | $GLOBALS['setup_info']['workflow']['currentver'] = '1.8.06.000'; |
---|
| 96 | return $GLOBALS['setup_info']['workflow']['currentver']; |
---|
| 97 | } |
---|
| 98 | |
---|
| 99 | $test[] = '1.8.06.000'; |
---|
| 100 | function workflow_upgrade1_8_06_000() |
---|
| 101 | { |
---|
| 102 | #updating the current version |
---|
[1324] | 103 | $GLOBALS['setup_info']['workflow']['currentver'] = '2.0.000'; |
---|
[1275] | 104 | return $GLOBALS['setup_info']['workflow']['currentver']; |
---|
| 105 | } |
---|
[1728] | 106 | $test[] = '2.0.000'; |
---|
| 107 | function workflow_upgrade2_0_000() |
---|
| 108 | { |
---|
| 109 | #updating the current version |
---|
[1835] | 110 | $GLOBALS['setup_info']['workflow']['currentver'] = '2.0.001'; |
---|
| 111 | return $GLOBALS['setup_info']['workflow']['currentver']; |
---|
| 112 | } |
---|
| 113 | $test[] = '2.0.001'; |
---|
| 114 | function workflow_upgrade2_0_001() |
---|
| 115 | { |
---|
| 116 | #updating the current version |
---|
[1979] | 117 | $GLOBALS['setup_info']['workflow']['currentver'] = '2.0.002'; |
---|
| 118 | return $GLOBALS['setup_info']['workflow']['currentver']; |
---|
| 119 | } |
---|
| 120 | $test[] = '2.0.002'; |
---|
| 121 | function workflow_upgrade2_0_002() |
---|
| 122 | { |
---|
| 123 | #updating the current version |
---|
[3031] | 124 | $GLOBALS['setup_info']['workflow']['currentver'] = '2.0.003'; |
---|
| 125 | return $GLOBALS['setup_info']['workflow']['currentver']; |
---|
| 126 | } |
---|
| 127 | $test[] = '2.0.003'; |
---|
| 128 | function workflow_upgrade2_0_003() |
---|
| 129 | { |
---|
| 130 | #updating the current version |
---|
| 131 | $GLOBALS['setup_info']['workflow']['currentver'] = '2.0.004'; |
---|
| 132 | return $GLOBALS['setup_info']['workflow']['currentver']; |
---|
| 133 | } |
---|
| 134 | $test[] = '2.0.004'; |
---|
| 135 | function workflow_upgrade2_0_004() |
---|
| 136 | { |
---|
| 137 | #updating the current version |
---|
[1728] | 138 | $GLOBALS['setup_info']['workflow']['currentver'] = '2.1.000'; |
---|
| 139 | return $GLOBALS['setup_info']['workflow']['currentver']; |
---|
| 140 | } |
---|
[3031] | 141 | $test[] = '2.1.000'; |
---|
| 142 | function workflow_upgrade2_1_000() |
---|
| 143 | { |
---|
| 144 | $GLOBALS['setup_info']['workflow']['currentver'] = '2.2.000'; |
---|
| 145 | return $GLOBALS['setup_info']['workflow']['currentver']; |
---|
| 146 | } |
---|
[795] | 147 | ?> |
---|