Changeset 5971 for trunk/prototype/modules/mail

Timestamp:

04/18/12 18:19:41 (12 years ago)

Author:

natan

Message:

Ticket #2633 - Implementação da limitação de numero de marcadores por usuario

File:

• trunk/prototype/modules/mail/interceptors/Helpers.php (modified) (2 diffs)

trunk/prototype/modules/mail/interceptors/Helpers.php

@@ -68 +68 @@
                 }
         }
-        
-        //label:before.create
-        public function verifyNameLabel(&$uri , &$params , &$criteria , $original){
-                $nameLabel = $params['name'];
-                $Labels = Controller::find(array('concept' => 'label'), false, array('filter' => array('i=', 'name', $nameLabel) ));
-                if($Labels){
-                        Throw new Exception('Já existe um marcador com esse nome.');
-                }
-        }
                 
         public static function in_arrayr($needle, $haystack) {
@@ -249 +240 @@
         }       
 
+        //label:before.create
+        public function validateLabel(&$uri , &$params , &$criteria , $original){
+
+                if( !!Controller::find( array('concept' => 'label'), false, array('filter' => array('i=', 'name', $params['name'])) ) )
+                {
+                    throw new Exception('Já existe um marcador com esse nome.');
+                }
+
+                $used = Controller::service('PostgreSQL')->execSql( 'SELECT count(slot) as used from expressomail_label where user_id = '.Config::me('uidNumber'), true );
+
+                if( $used['used'] === '0' )
+                {
+                    $params['id'] = '1';
+                    return;
+                }
+
+                $slot = Controller::service('PostgreSQL')->execSql( 'SELECT label.slot + 1 as id FROM expressomail_label as label, phpgw_config as config WHERE label.user_id = '.Config::me('uidNumber').' AND config.config_name = \'expressoMail_limit_labels\' AND label.slot <= config.config_value::integer AND ( SELECT count(slot) FROM expressomail_label WHERE slot = label.slot + 1 AND user_id = '.Config::me('uidNumber').' ) = 0 limit 1', true );
+
+                if( empty( $slot ) )
+                {
+                    throw new Exception('Nenhum slot disponivel.');
+                }
+
+                $params['id'] = $slot['id'];
+        }
 }