[Fmsystem-commits] [8686] controller: configurable status

[Sigurd Nes]

Revision: 8686
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=8686
Author:   sigurdne
Date:     2012-01-25 14:47:55 +0000 (Wed, 25 Jan 2012)
Log Message:
-----------
controller: configurable status

Modified Paths:
--------------
    trunk/controller/inc/class.menu.inc.php
    trunk/controller/setup/setup.inc.php
    trunk/controller/setup/tables_current.inc.php
    trunk/controller/setup/tables_update.inc.php

Modified: trunk/controller/inc/class.menu.inc.php
===================================================================
--- trunk/controller/inc/class.menu.inc.php     2012-01-25 10:14:05 UTC (rev 
8685)
+++ trunk/controller/inc/class.menu.inc.php     2012-01-25 14:47:55 UTC (rev 
8686)
@@ -144,6 +144,11 @@
                                                'text'  => lang('Configure 
Access Permissions'),
                                                'url'   => 
$GLOBALS['phpgw']->link('/index.php', array('menuaction' => 
'preferences.uiadmin_acl.list_acl', 'acl_app' => 'controller') )
                                        ),
+                                       'check_item_status'     => array
+                                       (
+                                               'text'  => lang('check item 
status'),
+                                               'url'   => 
$GLOBALS['phpgw']->link('/index.php', array('menuaction' => 
'property.uigeneric.index', 'type' => 'controller_check_item_status') )
+                                       ),
                                        'control_cats'  => array
                                        (
                                                'text'  => lang('Control area'),

Modified: trunk/controller/setup/setup.inc.php
===================================================================
--- trunk/controller/setup/setup.inc.php        2012-01-25 10:14:05 UTC (rev 
8685)
+++ trunk/controller/setup/setup.inc.php        2012-01-25 14:47:55 UTC (rev 
8686)
@@ -1,6 +1,6 @@
 <?php
        $setup_info['controller']['name'] = 'controller';
-       $setup_info['controller']['version'] = '0.1.22';
+       $setup_info['controller']['version'] = '0.1.23';
        $setup_info['controller']['app_order'] = 100;
        $setup_info['controller']['enable'] = 1;
        $setup_info['controller']['app_group']  = 'office';
@@ -50,5 +50,6 @@
                'controller_control_component_list',
                'controller_document',
                'controller_document_types',
-               'controller_check_item_case'
+               'controller_check_item_case',
+               'controller_check_item_status'
        );

Modified: trunk/controller/setup/tables_current.inc.php
===================================================================
--- trunk/controller/setup/tables_current.inc.php       2012-01-25 10:14:05 UTC 
(rev 8685)
+++ trunk/controller/setup/tables_current.inc.php       2012-01-25 14:47:55 UTC 
(rev 8686)
@@ -206,5 +206,19 @@
                 'fk' => array('controller_check_item' => array('check_item_id' 
=> 'id')),
                 'ix' => array(),
                 'uc' => array()
+               ),
+               'controller_check_item_status' => array(
+                       'fd' => array(
+                               'id' => array('type' => 'auto','nullable' => 
False),
+                               'name' => array('type' => 'varchar','precision' 
=> '50','nullable' => False),
+                               'open' => array('type' => 'int','precision' => 
'2','nullable' => True),
+                               'closed' => array('type' => 'int','precision' 
=> '2','nullable' => True),
+                               'pending' => array('type' => 'int','precision' 
=> '2','nullable' => True),
+                               'sorting' => array('type' => 'int','precision' 
=> '4','nullable' => True)
+                       ),
+                       'pk' => array('id'),
+                       'ix' => array(),
+                       'ix' => array(),
+                       'uc' => array()
                )
        );

Modified: trunk/controller/setup/tables_update.inc.php
===================================================================
--- trunk/controller/setup/tables_update.inc.php        2012-01-25 10:14:05 UTC 
(rev 8685)
+++ trunk/controller/setup/tables_update.inc.php        2012-01-25 14:47:55 UTC 
(rev 8686)
@@ -463,3 +463,36 @@
                $GLOBALS['setup_info']['controller']['currentver'] = '0.1.22';
                return $GLOBALS['setup_info']['controller']['currentver'];
        }
+
+       /* Update Controller from v 0.1.22 to 0.1.23 
+        * Add table for configurable status
+       */
+
+       $test[] = '0.1.22';
+       function controller_upgrade0_1_22()
+       {
+               $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_begin();
+
+               $GLOBALS['phpgw_setup']->oProc->CreateTable(
+                       'controller_check_item_status', array(
+                               'fd' => array(
+                                       'id' => array('type' => 
'auto','nullable' => False),
+                                       'name' => array('type' => 
'varchar','precision' => '50','nullable' => False),
+                                       'open' => array('type' => 
'int','precision' => '2','nullable' => True),
+                                       'closed' => array('type' => 
'int','precision' => '2','nullable' => True),
+                                       'pending' => array('type' => 
'int','precision' => '2','nullable' => True),
+                                       'sorting' => array('type' => 
'int','precision' => '4','nullable' => True)
+                               ),
+                               'pk' => array('id'),
+                               'ix' => array(),
+                               'ix' => array(),
+                               'uc' => array()
+                       )
+               );
+
+               if($GLOBALS['phpgw_setup']->oProc->m_odb->transaction_commit())
+               {
+                       $GLOBALS['setup_info']['controller']['currentver'] = 
'0.1.23';
+                       return 
$GLOBALS['setup_info']['controller']['currentver'];
+               }               
+       }