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

Timestamp:

08/04/09 14:42:23 (15 years ago)

Author:

rodsouza

Message:

Ticket #589 - Adicionando listagem de todos os funcionarios em ordem alfabetica.

File:

• trunk/workflow/inc/class.so_userinterface.inc.php (modified) (2 diffs)

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

@@ -512 +512 @@
                         . " WHERE (f.area_id = a.area_id)"
                         . " AND (f.funcionario_status_id = s.funcionario_status_id)"
+                        . " AND (f.organizacao_id = ?)"
                         . " AND (f.localidade_id = ?)"
                         . " AND (s.exibir = ?)";
 
-                $result = $this -> db -> query( $query, array( $locationID, 'S' ) );
+                $result = $this -> db -> query( $query, array( $organizationID, $locationID, 'S' ) );
 
                 $employees = $result -> GetArray( -1 );
@@ -566 +567 @@
                 return $output;
         }
+
+        /**
+         * Return the list of employees in alphabetical order
+         * @param int $organizationID The organization ID
+         * @return array The list o employees
+         * @access public
+         */
+        function getAlphabeticalEmployees( $organizationID )
+        {
+                $organizationID = ( int ) $organizationID;
+
+                // load the employees from the location
+                $query = "SELECT f.funcionario_id, f.organizacao_id, f.area_id, a.sigla AS area,"
+                        . " COALESCE(f.funcionario_categoria_id, 0) AS funcionario_categoria_id"
+                        . " FROM funcionario f, funcionario_status s, area a"
+                        . " WHERE (f.area_id = a.area_id)"
+                        . " AND (f.funcionario_status_id = s.funcionario_status_id)"
+                        . " AND (f.organizacao_id = ?)"
+                        . " AND (s.exibir = ?)";
+
+                $result = $this -> db -> query( $query, array( $organizationID, 'S' ) );
+
+                $employees = $result -> GetArray( -1 );
+                $cachedLDAP = $GLOBALS[ 'workflow' ][ 'factory' ] -> newInstance( 'CachedLDAP' );
+                $cachedLDAP -> setOperationMode( $cachedLDAP -> OPERATION_MODE_LDAP_DATABASE );
+
+                $categoriesCount = array( );
+                for ( $i = 0; $i < count( $employees ); $i++ )
+                {
+                        // remove numeric fields
+                        for ( $j = 0; $j < $result -> _numOfFields; $j++ )
+                                unset( $employees[ $i ][ $j ] );
+
+                        $employees[ $i ][ 'cn' ] = '';
+                        $employees[ $i ][ 'telephoneNumber' ] = '';
+
+                        // try to find the telephone number
+                        $entry = $cachedLDAP -> getEntryByID( $employees[ $i ][ 'funcionario_id' ] );
+                        if ( $entry )
+                        {
+                                $employees[ $i ][ 'telephoneNumber' ] = is_null( $entry[ 'telephonenumber' ] ) ? '' : $entry[ 'telephonenumber' ];
+                                $employees[ $i ][ 'cn' ] = is_null( $entry[ 'cn' ] ) ? '' : $entry[ 'cn' ];
+                                $employees[ $i ][ 'removed' ] = is_null( $entry[ 'last_update' ] );
+                        }
+
+                        // count the number of employees in each category
+                        $categoryID = $employees[ $i ][ 'funcionario_categoria_id' ];
+                        if ( isset( $categoriesCount[ $categoryID ] ) )
+                                $categoriesCount[ $categoryID ]++;
+                        else
+                                $categoriesCount[ $categoryID ] = 1;
+                }
+
+                $usedCategories = array_keys( $categoriesCount );
+                $availableCategories = $this -> getCategoriesList( $organizationID );
+                $output = array( );
+                $output[ 'employees' ] = $employees;
+                $output[ 'categories' ] = array( );
+                foreach ( $availableCategories as $category )
+                {
+                        if ( ! in_array( $category[ 'funcionario_categoria_id' ], $usedCategories ) )
+                                continue;
+
+                        $category[ 'contagem' ] = $categoriesCount[ $category[ 'funcionario_categoria_id' ] ];
+                        $output[ 'categories' ][ ] = $category;
+                }
+
+                usort( $output[ 'employees' ], create_function( '$a,$b', 'return strcasecmp($a[\'cn\'],$b[\'cn\']);' ) );
+
+                return $output;
+        }
 }
 ?>