Changeset 1266 for trunk/workflow/inc

Timestamp:

08/04/09 11:51:39 (15 years ago)

Author:

rodsouza

Message:

Ticket #589 - Adicionando filtro por localidade.

Location:

trunk/workflow/inc

Files:

• class.bo_userinterface.inc.php (modified) (1 diff)
• class.so_userinterface.inc.php (modified) (1 diff)

trunk/workflow/inc/class.bo_userinterface.inc.php

@@ -1006 +1006 @@
                 return $this -> so -> getAreaWithSubtituteBoss( $this -> organizationInfo[ 'organizacao_id' ] );
         }
+
+        /**
+         * Retorna a lista de localidades
+         * @return array lista de localidades
+         * @access public
+         */
+        function getManning( )
+        {
+                /* check for access */
+                if ( ( $checkWarnings = $this->checkOrgchartAccess( ) ) !== true )
+                        return $checkWarnings;
+
+                return $this -> so -> getManning( $this -> organizationInfo[ 'organizacao_id' ] );
+        }
+
+        /**
+         * Return the employees of a manning
+         * @param $params parameters
+         * @access public
+         * @return array array of employees
+         */
+        function getManningEmployees( $params )
+        {
+                /* check for access */
+                if ( ( $checkWarnings = $this -> checkOrgchartAccess( ) ) !== true )
+                        return $checkWarnings;
+
+                $employees = $this -> so -> getManningEmployees( ( int ) $params[ 'locationID' ], $this -> organizationInfo[ 'organizacao_id' ] );
+
+                if ( $employees === false )
+                        return array( 'error' => 'Localidade não encontrada.' );
+
+                //usort( $employees['employees'], create_function( '$a,$b', 'return strcasecmp($a[\'cn\'],$b[\'cn\']);' ) );
+
+                return $employees;
+        }
 }
 ?>

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

@@ -475 +475 @@
                 return $output;
         }
+
+        /**
+         * Get manning list
+         * @param int $organizationID The organization ID
+         * @return array The manning list
+         * @access public
+         */
+        function getManning( $organizationID )
+        {
+                $result = $this -> db -> query( 'SELECT localidade_id, descricao FROM localidade 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 employees from a specific location
+         * @param int $categoryID The category ID
+         * @param int $organizationID The organization ID
+         * @return array The list o employees of that location
+         * @access public
+         */
+        function getManningEmployees( $locationID, $organizationID )
+        {
+                $organizationID = ( int ) $organizationID;
+                $locationID = ( int ) $locationID;
+
+                // 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.localidade_id = ?)"
+                        . " AND (s.exibir = ?)";
+
+                $result = $this -> db -> query( $query, array( $locationID, '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;
+        }
 }
 ?>