Changeset 1245 for trunk/workflow/inc/class.so_userinterface.inc.php

Timestamp:

08/03/09 09:52:13 (15 years ago)

Author:

rodsouza

Message:

Ticket #589 - itens (doc. anexo ao ticket) 1, 2, 3, 4 e 5 integralmente e item 6 parcialmente.

File:

• trunk/workflow/inc/class.so_userinterface.inc.php (modified) (1 diff)

trunk/workflow/inc/class.so_userinterface.inc.php

@@ -426 +426 @@
                 return $output;
         }
+
+        /**
+         * Get useful phones list
+         * @param int $organizationID The organization ID
+         * @return array Useful phones list
+         * @access public
+         */
+        function getUsefulPhones( $organizationID )
+        {
+                $result = $this -> db -> query( "SELECT descricao, numero FROM telefone WHERE (organizacao_id = ?) ORDER BY descricao", array( $organizationID ) );
+
+                $output = $result->GetArray(-1);
+                for ($i = 0; $i < count($output); $i++)
+                        for ($j = 0; $j < $result->_numOfFields; $j++)
+                                unset($output[$i][$j]);
+
+                return $output;
+        }
+
+        /**
+         * Get areas with substitute boss
+         * @param int $organizationID The organization ID
+         * @return array areas with substitute boss
+         * @access public
+         */
+        function getAreaWithSubtituteBoss( $organizationID )
+        {
+                $result = $this -> db -> query( "SELECT sigla as area, titular_funcionario_id as titular, substituto_funcionario_id as substituto FROM area WHERE (organizacao_id = ?) and substituto_funcionario_id is not null ORDER BY area", array( $organizationID ) );
+
+                $cachedLDAP = $GLOBALS[ 'workflow' ][ 'factory' ] -> newInstance( 'CachedLDAP' );
+                $cachedLDAP -> setOperationMode( $cachedLDAP -> OPERATION_MODE_LDAP_DATABASE );
+
+                $output = $result->GetArray(-1);
+                for ( $i = 0; $i < count($output); $i++ )
+                {
+                        for ($j = 0; $j < $result->_numOfFields; $j++)
+                                unset($output[$i][$j]);
+
+                        $entry = $cachedLDAP -> getEntryByID( $output[ $i ][ 'titular' ] );
+                        if ( $entry && ( ! is_null( $entry[ 'cn' ] ) ) )
+                                $output[ $i ][ 'titular' ] = $entry[ 'cn' ];
+
+                        $entry = $cachedLDAP -> getEntryByID( $output[ $i ][ 'substituto' ] );
+                        if ( $entry && ( ! is_null( $entry[ 'cn' ] ) ) )
+                                $output[ $i ][ 'substituto' ] = $entry[ 'cn' ];
+                }
+
+                return $output;
+        }
 }
 ?>