Changeset 1266

Timestamp:

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

Author:

rodsouza

Message:

Ticket #589 - Adicionando filtro por localidade.

Location:

trunk/workflow

Files:

• inc/class.bo_userinterface.inc.php (modified) (1 diff)
• inc/class.so_userinterface.inc.php (modified) (1 diff)
• js/userinterface/orgchart.js (modified) (3 diffs)

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;
+        }
 }
 ?>

trunk/workflow/js/userinterface/orgchart.js

@@ -38 +38 @@
         content += '<option onclick="">Alfabética</option>'
         content += '<option onclick="getHierarchicalArea( );">Áreas</option>'
-        content += '<option onclick="">Lotação</option>'
+        content += '<option onclick="getManning( )">Lotação</option>'
         content += '<option onclick="getUsefulPhones( );">Telefones Úteis</option>'
         content += '<option onclick="getAreaWithSubtituteBoss( )">Substituição de Chefia</option>'
         content += '<option onclick="getCostCenters( );">Centros de Custo</option>'
-        content += '<option onclick="">Vínculos</option>'
+        content += '<option onclick="getCategoriesList( )">Vínculos</option>'
         content += '</select></li>';
         content += '<li><a href="#" onclick="window.open(\'' + enderecoImagem + '\', \'extwindow\'); return false;"><img src="templateFile.php?file=images/Process.gif">&nbsp;&nbsp;Gráfico</a></li>';
@@ -244 +244 @@
 
         cExecute("$this.bo_userinterface.getCategoriesList", resultGetCategoriesList, "");
+}
+
+function getManning( )
+{
+        function resultGetManning( data )
+        {
+                if ( _checkError( data ) )
+                        return;
+
+                var content = '<center><strong>Lotalidades</strong></center>';
+                for ( var i = 0; i < data.length; i++ )
+                        content += '<br/>' + '&nbsp; &nbsp; &nbsp; &nbsp;<a href="javascript:void(0)" id="localidade_' + data[i]['localidade_id'] + '" onclick="tmp = $$(\'div#orgchartAreas a.destaque\'); if (tmp[0]) tmp[0].removeClassName(\'destaque\'); this.addClassName(\'destaque\');loadManningEmployees(' + data[i]['localidade_id'] + ')">' + data[i]['descricao'] + '</a>';
+
+                content += '<br/><br/>';
+
+                $('orgchartAreas').innerHTML = content;
+        }
+
+        cExecute("$this.bo_userinterface.getManning", resultGetManning, "");
 }
 
@@ -349 +368 @@
 }
 
+function loadManningEmployees( locationID )
+{
+        workflowUserInterfaceCurrentAreaID = 0;
+        cExecute('$this.bo_userinterface.getManningEmployees', printEmployeesHandler, 'locationID=' + locationID);
+}
+
 function orgchartSearchEmployee(searchTerm)
 {