public Collection<ReferenceItem> selectByDocumentIdAndDocumentType( int nDocumentId, String strCodeDocumentType, PortletOrder pOrder,
            PortletFilter pFilter )
    {
        StringBuilder strSQl = new StringBuilder( );
        strSQl.append( SQL_QUERY_SELECT_DOCUMENTS_BY_TYPE_AND_CATEGORY );

        String strFilter = ( pFilter != null ) ? pFilter.getSQLFilter( ) : null;

        if ( strFilter != null )
        {
            strSQl.append( SQL_QUERY_CASE_AND );
            strSQl.append( strFilter );
        }

        strSQl.append( pOrder.getSQLOrderBy( ) );
        ReferenceList list = new ReferenceList( );
        try ( DAOUtil daoUtil = new DAOUtil( strSQl.toString( ) ) )
        {
            daoUtil.setInt( 1, nDocumentId );
            daoUtil.setString( 2, strCodeDocumentType );
            daoUtil.setInt( 3, nDocumentId );

            if ( strFilter != null )
            {
                if ( pFilter.getPortletFilterType( ).equals( PortletFilter.PAGE_NAME ) )
                {
                    for ( int i = 0; i < pFilter.getPageName( ).length; i++ )
                    {
                        daoUtil.setString( i + 4, "%" + pFilter.getPageName( )[i] + "%" );
                    }
                }
                else
                    if ( pFilter.getPortletFilterType( ).equals( PortletFilter.PORTLET_NAME ) )
                    {
                        for ( int i = 0; i < pFilter.getPortletName( ).length; i++ )
                        {
                            daoUtil.setString( i + 4, "%" + pFilter.getPortletName( )[i] + "%" );
                        }
                    }
                    else
                        if ( pFilter.getPortletFilterType( ).equals( PortletFilter.PAGE_ID ) )
                        {
                            daoUtil.setInt( 4, pFilter.getIdPage( ) );
                        }
            }

            daoUtil.executeQuery( );


            while ( daoUtil.next( ) )
            {
                list.addItem( daoUtil.getInt( 1 ), daoUtil.getString( 2 ) );
            }
        }
        return list;
    }

    /**
     * Tests if is a portlet is portlet type alias
     *
     * @param nPortletId
     *            The identifier of the document
     * @return true if the portlet is alias, false otherwise
     */
    public boolean checkIsAliasPortlet( int nPortletId )
    {
        boolean bIsAlias = false;
        try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_CHECK_IS_ALIAS ) )
        {
            daoUtil.setInt( 1, nPortletId );
            daoUtil.executeQuery( );

            if ( daoUtil.next( ) )
            {
                bIsAlias = true;
            }
        }
        return bIsAlias;
    }

            daoUtil.executeQuery( );

            if ( daoUtil.next( ) )
            {
                int nIndex = 1;
                document = new Document( );
                document.setId( daoUtil.getInt( nIndex++ ) );
                document.setCodeDocumentType( daoUtil.getString( nIndex++ ) );
                document.setTitle( daoUtil.getString( nIndex++ ) );
                document.setDateCreation( daoUtil.getTimestamp( nIndex++ ) );
                document.setDateModification( daoUtil.getTimestamp( nIndex++ ) );
                document.setXmlWorkingContent( daoUtil.getString( nIndex++ ) );
                document.setXmlValidatedContent( daoUtil.getString( nIndex++ ) );
                document.setSpaceId( daoUtil.getInt( nIndex++ ) );
                document.setSpace( daoUtil.getString( nIndex++ ) );
                document.setStateId( daoUtil.getInt( nIndex++ ) );
                document.setStateKey( daoUtil.getString( nIndex++ ) );
                document.setType( daoUtil.getString( nIndex++ ) );
                document.setSummary( daoUtil.getString( nIndex++ ) );
                document.setComment( daoUtil.getString( nIndex++ ) );
                document.setDateValidityBegin( daoUtil.getTimestamp( nIndex++ ) );
                document.setDateValidityEnd( daoUtil.getTimestamp( nIndex++ ) );
                document.setXmlMetadata( daoUtil.getString( nIndex++ ) );
                document.setCreatorId( daoUtil.getInt( nIndex++ ) );
                document.setMailingListId( daoUtil.getInt( nIndex++ ) );
                document.setPageTemplateDocumentId( daoUtil.getInt( nIndex++ ) );
                document.setSkipPortlet( daoUtil.getBoolean( nIndex++ ) );
                document.setSkipCategories( daoUtil.getBoolean( nIndex++ ) );
            }
        }
        return document;
    }

        try ( DAOUtil daoUtil = getDaoFromFilter( SQL_QUERY_SELECT_BY_FILTER, filter ) )
        {
        daoUtil.executeQuery( );

        while ( daoUtil.next( ) )
        {
            Document document = new Document( );
            document.setId( daoUtil.getInt( 1 ) );
            document.setCodeDocumentType( daoUtil.getString( 2 ) );
            document.setTitle( daoUtil.getString( 3 ) );
            document.setDateCreation( daoUtil.getTimestamp( 4 ) );
            document.setDateModification( daoUtil.getTimestamp( 5 ) );
            document.setXmlWorkingContent( daoUtil.getString( 6 ) );
            document.setXmlValidatedContent( daoUtil.getString( 7 ) );
            document.setSpaceId( daoUtil.getInt( 8 ) );
            document.setSpace( daoUtil.getString( 9 ) );
            document.setStateId( daoUtil.getInt( 10 ) );
            document.setStateKey( daoUtil.getString( 11 ) );
            document.setType( daoUtil.getString( 12 ) );
            document.setSummary( daoUtil.getString( 13 ) );
            document.setComment( daoUtil.getString( 14 ) );
            document.setDateValidityBegin( daoUtil.getTimestamp( 15 ) );
            document.setDateValidityEnd( daoUtil.getTimestamp( 16 ) );
            document.setXmlMetadata( daoUtil.getString( 17 ) );
            document.setCreatorId( daoUtil.getInt( 18 ) );
            document.setMailingListId( daoUtil.getInt( 19 ) );
            document.setPageTemplateDocumentId( daoUtil.getInt( 20 ) );
            document.setSkipPortlet( daoUtil.getBoolean( 21 ) );
            document.setSkipCategories( daoUtil.getBoolean( 22 ) );

    public String doChangeState( HttpServletRequest request )
    {
        saveReferer( request );

        String strDocumentId = request.getParameter( PARAMETER_DOCUMENT_ID );
        String strActionId = request.getParameter( PARAMETER_ACTION_ID );
        int nDocumentId = -1;
        int nActionId = -1;

        try
        {
            nDocumentId = Integer.parseInt( strDocumentId );
            nActionId = Integer.parseInt( strActionId );
        }
        catch ( NumberFormatException ne )
        {
            AppLogService.error( ne );
        }

        Document document = DocumentHome.findByPrimaryKeyWithoutBinaries( nDocumentId );
        DocumentAction action = DocumentActionHome.findByPrimaryKey( nActionId );

        if ( ( action == null ) || ( action.getFinishDocumentState(  ) == null ) || ( document == null ) ||
                !DocumentService.getInstance(  )
                                    .isAuthorizedAdminDocument( document.getSpaceId(  ),
                    document.getCodeDocumentType(  ), action.getPermission(  ), getUser(  ) ) )
        {
            return getHomeUrl( request );
        }

        try
        {
            DocumentService.getInstance(  )
                           .changeDocumentState( document, getUser(  ), action.getFinishDocumentState(  ).getId(  ) );

    public void setLocale( Locale locale )
    {
        _locale = locale;
    }

    /**
     * Returns the Url
     *
     * @return The Url
     */
    public String getUrl( )
    {
        return _strUrl;
    }

    /**
     * Sets the Url
     *
     * @param strUrl
     *            The Url
     */
    public void setUrl( String strUrl )
    {
        _strUrl = strUrl;
    }

    /**
     * Returns the NameKey
     *
     * @return The NameKey
     */
    public String getNameKey( )
    {
        return _strNameKey;
    }

    /**
     * Returns the Name
     *
     * @return The Name
     */
    public String getName( )
    {
        return I18nService.getLocalizedString( _strNameKey, _locale );
    }

    /**
     * Sets the NameKey
     *
     * @param strNameKey
     *            The NameKey
     */
    public void setNameKey( String strNameKey )
    {
        _strNameKey = strNameKey;
    }

    /**
     * Returns the DescriptionKey
     *
     * @return The DescriptionKey
     */
    public String getDescriptionKey( )
    {
        return _strDescriptionKey;
    }

    /**
     * Returns the Description
     *
     * @return The Description
     */
    public String getDescription( )
    {
        return I18nService.getLocalizedString( _strDescriptionKey, _locale );
    }

    /**
     * Sets the DescriptionKey
     *
     * @param strDescriptionKey
     *            The DescriptionKey
     */
    public void setDescriptionKey( String strDescriptionKey )
    {
        _strDescriptionKey = strDescriptionKey;
    }

    /**
     * Returns the IconUrl
     *
     * @return The IconUrl
     */
    public String getIconUrl( )
    {
        return _strIconUrl;
    }

    /**
     * Sets the IconUrl
     *
     * @param strIconUrl
     *            The IconUrl
     */
    public void setIconUrl( String strIconUrl )
    {
        _strIconUrl = strIconUrl;
    }

    /**
     * Returns the permission associated to the action
     * 
     * @return The permission
     */
    public String getPermission( )
    {
        return _strPermission;
    }

    /**
     * Sets the Permission
     *
     * @param strPermission
     *            The Permission
     */
    public void setPermission( String strPermission )
    {
        _strPermission = strPermission;
    }
}

    public String doChangeState( HttpServletRequest request )
    {
        saveReferer( request );

        String strDocumentId = request.getParameter( PARAMETER_DOCUMENT_ID );
        String strActionId = request.getParameter( PARAMETER_ACTION_ID );
        int nDocumentId = -1;
        int nActionId = -1;

        try
        {
            nDocumentId = Integer.parseInt( strDocumentId );
            nActionId = Integer.parseInt( strActionId );
        }
        catch ( NumberFormatException ne )
        {
            AppLogService.error( ne );
        }

        Document document = DocumentHome.findByPrimaryKeyWithoutBinaries( nDocumentId );
        DocumentAction action = DocumentActionHome.findByPrimaryKey( nActionId );

        if ( ( action == null ) || ( action.getFinishDocumentState(  ) == null ) || ( document == null ) ||
                !DocumentService.getInstance(  )
                                    .isAuthorizedAdminDocument( document.getSpaceId(  ),
                    document.getCodeDocumentType(  ), action.getPermission(  ), getUser(  ) ) )
        {
            return getHomeUrl( request );
        }

        try (DAOUtil daoUtil = initSelectChildDAOUtil(nSpaceId, strCodeType))
        {
            daoUtil.executeQuery( );

            while ( daoUtil.next( ) )
            {
                DocumentSpace space = new DocumentSpace( );
                space.setId( daoUtil.getInt( 1 ) );
                space.setIdParent( daoUtil.getInt( 2 ) );
                space.setName( daoUtil.getString( 3 ) );
                space.setDescription( daoUtil.getString( 4 ) );
                space.setViewType( daoUtil.getString( 5 ) );
                space.setIdIcon( daoUtil.getInt( 6 ) );
                space.setIconUrl( daoUtil.getString( 7 ) );
                space.setDocumentCreationAllowed( daoUtil.getInt( 8 ) != 0 );
                space.setWorkgroup( daoUtil.getString( 9 ) );
                listDocumentSpaces.add( space );
            }
        }
        return listDocumentSpaces;
    }

                                sbLogs.append( "Adding " );
                                sbLogs.append( doc.get( DocSearchItem.FIELD_TYPE ) );
                                sbLogs.append( " #" );
                                sbLogs.append( doc.get( DocSearchItem.FIELD_UID ) );
                                sbLogs.append( " - " );
                                sbLogs.append( doc.get( DocSearchItem.FIELD_TITLE ) );
                                sbLogs.append( "\r\n" );
                            }
                        }
                    }
                    catch ( Exception e )
                    {
                        sbLogs.append( "Indexing DocId " + luceneDocumentId + " Error durign document indexation parsing.\r\n" );
                        sbLogs.append( "Caught a " );
                        sbLogs.append( e.getClass(  ) );
                        sbLogs.append( "\r\n with message: " );
                        sbLogs.append( e.getMessage(  ) );
                        AppLogService.error( "Indexing error : ", e );
                    }

                    removeIndexerAction( action.getIdAction(  ) );
                }

                //Update all document which must be update
                for ( IndexerAction action : getAllIndexerActionByTask( IndexerAction.TASK_MODIFY ) )

            daoUtil.executeQuery( );

            while ( daoUtil.next( ) )
            {
                DocumentSpace space = new DocumentSpace( );
                space.setId( daoUtil.getInt( 1 ) );
                space.setIdParent( daoUtil.getInt( 2 ) );
                space.setName( daoUtil.getString( 3 ) );
                space.setDescription( daoUtil.getString( 4 ) );
                space.setViewType( daoUtil.getString( 5 ) );
                space.setIdIcon( daoUtil.getInt( 6 ) );
                space.setIconUrl( daoUtil.getString( 7 ) );
                space.setDocumentCreationAllowed( daoUtil.getInt( 8 ) != 0 );
                space.setWorkgroup( daoUtil.getString( 9 ) );
                listDocumentSpaces.add( space );
            }
        }
        return listDocumentSpaces;
    }

    /**
     * Load the list of documentSpaces
     * 
     * @return The Collection of the DocumentSpaces
     */
    public ReferenceList getDocumentSpaceList( )

            daoUtil.executeQuery( );

            while ( daoUtil.next( ) )
            {
                DocumentSpace space = new DocumentSpace( );
                space.setId( daoUtil.getInt( 1 ) );
                space.setIdParent( daoUtil.getInt( 2 ) );
                space.setName( daoUtil.getString( 3 ) );
                space.setDescription( daoUtil.getString( 4 ) );
                space.setViewType( daoUtil.getString( 5 ) );
                space.setIdIcon( daoUtil.getInt( 6 ) );
                space.setIconUrl( daoUtil.getString( 7 ) );
                space.setDocumentCreationAllowed( daoUtil.getInt( 8 ) != 0 );
                space.setWorkgroup( daoUtil.getString( 9 ) );
                listDocumentSpaces.add( space );
            }
        }
        return listDocumentSpaces;
    }

    public static Collection<CategoryDisplay> getAllCategoriesDisplay( AdminUser user )
    {
        Collection<Category> listCategory = CategoryHome.findAll(  );
        listCategory = AdminWorkgroupService.getAuthorizedCollection( listCategory, user );

        Collection<CategoryDisplay> listCategoryDisplay = new ArrayList<CategoryDisplay>(  );

        for ( Category category : listCategory )
        {
            CategoryDisplay categoryDisplay = _singleton.new CategoryDisplay(  );
            categoryDisplay.setCategory( category );
            if(category.getIconContent() != null)
            {
            	categoryDisplay.setIconUrl( getResourceImageCategory( categoryDisplay.getCategory(  ).getId(  ) ) );
            }
            else
            {
            	categoryDisplay.setIconUrl( null );
            }
            categoryDisplay.setCountLinkedDocuments( CategoryHome.findCountIdDocuments( category.getId(  ) ) );
            categoryDisplay.setAssigned( false );

            daoUtil.setInt( 1, documentAttribute.getId( ) );
            daoUtil.setString( 2, documentAttribute.getCodeDocumentType( ) );
            daoUtil.setString( 3, documentAttribute.getCodeAttributeType( ) );
            daoUtil.setString( 4, documentAttribute.getCode( ) );
            daoUtil.setString( 5, documentAttribute.getName( ) );
            daoUtil.setString( 6, documentAttribute.getDescription( ) );
            daoUtil.setInt( 7, documentAttribute.getAttributeOrder( ) );
            daoUtil.setInt( 8, documentAttribute.isRequired( ) ? 1 : 0 );
            daoUtil.setInt( 9, documentAttribute.isSearchable( ) ? 1 : 0 );

            daoUtil.executeUpdate( );

        rt.setResourceTypeKey( DocumentType.RESOURCE_TYPE );
        rt.setResourceTypeLabelKey( PROPERTY_LABEL_RESOURCE_TYPE );

        Permission p = new Permission(  );
        p.setPermissionKey( PERMISSION_CREATE );
        p.setPermissionTitleKey( PROPERTY_LABEL_CREATE );
        rt.registerPermission( p );

        p = new Permission(  );
        p.setPermissionKey( PERMISSION_VIEW );
        p.setPermissionTitleKey( PROPERTY_LABEL_VIEW );
        rt.registerPermission( p );

        p = new Permission(  );
        p.setPermissionKey( PERMISSION_DELETE );
        p.setPermissionTitleKey( PROPERTY_LABEL_DELETE );
        rt.registerPermission( p );

        p = new Permission(  );
        p.setPermissionKey( PERMISSION_MODIFY );
        p.setPermissionTitleKey( PROPERTY_LABEL_MODIFY );
        rt.registerPermission( p );

        p = new Permission(  );
        p.setPermissionKey( PERMISSION_CHANGE );

                for ( IndexerAction action : getAllIndexerActionByTask( IndexerAction.TASK_CREATE ) )
                {
                    ArrayList<Integer> luceneDocumentId = new ArrayList<Integer>(  );
                    try
                    {
                        luceneDocumentId.add( action.getIdDocument(  ) );

                        List<org.apache.lucene.document.Document> luceneDocument = _indexer.getDocuments( luceneDocumentId );

                        if ( ( luceneDocument != null ) && ( luceneDocument.size(  ) > 0 ) )
                        {
                            Iterator<org.apache.lucene.document.Document> it = luceneDocument.iterator(  );

                            while ( it.hasNext(  ) )
                            {
                                org.apache.lucene.document.Document doc = it.next(  );
                                writer.addDocument( doc );

            try
            {
                DocumentService.getInstance(  )
                               .changeDocumentState( document, getUser(  ), DocumentState.STATE_WAITING_FOR_APPROVAL );

                //Reload document in case listeners have modified it in the database
                document = DocumentHome.findByPrimaryKeyWithoutBinaries( IntegerUtils.convert( strDocumentId ) );

                DocumentService.getInstance(  )
                               .validateDocument( document, getUser(  ), DocumentState.STATE_VALIDATE );
            }
            catch ( DocumentException e )
            {
                return getErrorMessageUrl( request, e.getI18nMessage(  ) );
            }

            IndexationService.addIndexerAction( strDocumentId, DocumentIndexer.INDEXER_NAME, IndexerAction.TASK_MODIFY,
                IndexationService.ALL_DOCUMENT );

            DocumentIndexerUtils.addIndexerAction( strDocumentId, IndexerAction.TASK_MODIFY, IndexationService.ALL_DOCUMENT );
        }

        return getHomeUrl( request );
    }

    /**
     * Gets the document modification page
     * @param request The HTTP request
     * @return The URL to go after performing the action
     */
    public String getModifyDocument( HttpServletRequest request )

                documentAttribute = new DocumentAttribute( );
                documentAttribute.setId( daoUtil.getInt( 1 ) );
                documentAttribute.setCodeDocumentType( daoUtil.getString( 2 ) );
                documentAttribute.setCodeAttributeType( daoUtil.getString( 3 ) );
                documentAttribute.setCode( daoUtil.getString( 4 ) );
                documentAttribute.setName( daoUtil.getString( 5 ) );
                documentAttribute.setDescription( daoUtil.getString( 6 ) );
                documentAttribute.setAttributeOrder( daoUtil.getInt( 7 ) );
                documentAttribute.setRequired( daoUtil.getInt( 8 ) != 0 );
                documentAttribute.setSearchable( daoUtil.getInt( 9 ) != 0 );

                space = new DocumentSpace( );
                space.setId( daoUtil.getInt( 1 ) );
                space.setIdParent( daoUtil.getInt( 2 ) );
                space.setName( daoUtil.getString( 3 ) );
                space.setDescription( daoUtil.getString( 4 ) );
                space.setViewType( daoUtil.getString( 5 ) );
                space.setIdIcon( daoUtil.getInt( 6 ) );
                space.setIconUrl( daoUtil.getString( 7 ) );
                space.setDocumentCreationAllowed( daoUtil.getInt( 8 ) != 0 );
                space.setWorkgroup( daoUtil.getString( 9 ) );

            daoUtil.setInt( 1, space.getId( ) );
            daoUtil.setInt( 2, space.getIdParent( ) );
            daoUtil.setString( 3, space.getName( ) );
            daoUtil.setString( 4, space.getDescription( ) );
            daoUtil.setString( 5, space.getViewType( ) );
            daoUtil.setInt( 6, space.getIdIcon( ) );
            daoUtil.setInt( 7, space.isDocumentCreationAllowed( ) ? 1 : 0 );
            daoUtil.setString( 8, space.getWorkgroup( ) );
            daoUtil.executeUpdate( );