Fork me on GitHub

CPD Results

The following document contains the results of PMD's CPD 6.13.0.

Duplications

File Line
fr/paris/lutece/plugins/carto/business/DataLayerMapTemplateDAO.java 105
fr/paris/lutece/plugins/carto/business/DataLayerMapTemplateDAO.java 402
        try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECT, plugin ) )
        {
            daoUtil.setInt( 1, nKey );
            daoUtil.executeQuery( );
            DataLayerMapTemplate dataLayerMapTemplate = null;

            if ( daoUtil.next( ) )
            {
                dataLayerMapTemplate = new DataLayerMapTemplate( );
                int nIndex = 1;

                dataLayerMapTemplate.setId( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setIdMapTemplate( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setIdDataLayer( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setPictogram( daoUtil.getString( nIndex++ ) );
                dataLayerMapTemplate.setZoomMin( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setZoomMax( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setLayerType( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setColor( daoUtil.getString( nIndex++ ) );
                dataLayerMapTemplate.setThickness( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setIdCoordinate( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setZoomPicto( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setIconImage( daoUtil.getString( nIndex++ ) );
                dataLayerMapTemplate.setPictoSizeZoom07( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setPictoSizeZoom812( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setPictoSizeZoom1315( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setPictoSizeZoom1619( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setMarkerCluster( daoUtil.getBoolean( nIndex++ ) );

            }

            return Optional.ofNullable( dataLayerMapTemplate );
        }
    }
File Line
fr/paris/lutece/plugins/carto/business/DataLayerMapTemplateDAO.java 107
fr/paris/lutece/plugins/carto/business/DataLayerMapTemplateDAO.java 364
            daoUtil.setInt( 1, nKey );
            daoUtil.executeQuery( );
            DataLayerMapTemplate dataLayerMapTemplate = null;

            if ( daoUtil.next( ) )
            {
                dataLayerMapTemplate = new DataLayerMapTemplate( );
                int nIndex = 1;

                dataLayerMapTemplate.setId( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setIdMapTemplate( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setIdDataLayer( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setPictogram( daoUtil.getString( nIndex++ ) );
                dataLayerMapTemplate.setZoomMin( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setZoomMax( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setLayerType( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setColor( daoUtil.getString( nIndex++ ) );
                dataLayerMapTemplate.setThickness( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setIdCoordinate( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setZoomPicto( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setIconImage( daoUtil.getString( nIndex++ ) );
                dataLayerMapTemplate.setPictoSizeZoom07( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setPictoSizeZoom812( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setPictoSizeZoom1315( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setPictoSizeZoom1619( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setMarkerCluster( daoUtil.getBoolean( nIndex++ ) );

            }

            return Optional.ofNullable( dataLayerMapTemplate );
        }
    }

    /**
     * {@inheritDoc }
     */
    @Override
    public void delete( int nKey, Plugin plugin )
File Line
fr/paris/lutece/plugins/carto/business/DataLayerMapTemplateDAO.java 364
fr/paris/lutece/plugins/carto/business/DataLayerMapTemplateDAO.java 404
            daoUtil.setInt( 2, nDataLayerKey );
            daoUtil.executeQuery( );
            DataLayerMapTemplate dataLayerMapTemplate = null;

            if ( daoUtil.next( ) )
            {
                dataLayerMapTemplate = new DataLayerMapTemplate( );
                int nIndex = 1;

                dataLayerMapTemplate.setId( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setIdMapTemplate( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setIdDataLayer( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setPictogram( daoUtil.getString( nIndex++ ) );
                dataLayerMapTemplate.setZoomMin( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setZoomMax( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setLayerType( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setColor( daoUtil.getString( nIndex++ ) );
                dataLayerMapTemplate.setThickness( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setIdCoordinate( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setZoomPicto( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setIconImage( daoUtil.getString( nIndex++ ) );
                dataLayerMapTemplate.setPictoSizeZoom07( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setPictoSizeZoom812( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setPictoSizeZoom1315( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setPictoSizeZoom1619( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setMarkerCluster( daoUtil.getBoolean( nIndex++ ) );
            }

            return Optional.ofNullable( dataLayerMapTemplate );
        }
    }
File Line
fr/paris/lutece/plugins/carto/business/DataLayerMapTemplateDAO.java 194
fr/paris/lutece/plugins/carto/business/DataLayerMapTemplateDAO.java 294
            daoUtil.executeQuery( );

            while ( daoUtil.next( ) )
            {
                DataLayerMapTemplate dataLayerMapTemplate = new DataLayerMapTemplate( );
                int nIndex = 1;

                dataLayerMapTemplate.setId( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setIdMapTemplate( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setIdDataLayer( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setPictogram( daoUtil.getString( nIndex++ ) );
                dataLayerMapTemplate.setZoomMin( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setZoomMax( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setLayerType( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setColor( daoUtil.getString( nIndex++ ) );
                dataLayerMapTemplate.setThickness( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setIdCoordinate( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setZoomPicto( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setIconImage( daoUtil.getString( nIndex++ ) );
                dataLayerMapTemplate.setPictoSizeZoom07( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setPictoSizeZoom812( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setPictoSizeZoom1315( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setPictoSizeZoom1619( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setMarkerCluster( daoUtil.getBoolean( nIndex++ ) );

                dataLayerMapTemplateList.add( dataLayerMapTemplate );
            }
File Line
fr/paris/lutece/plugins/carto/business/DataLayerMapTemplateDAO.java 69
fr/paris/lutece/plugins/carto/business/DataLayerMapTemplateDAO.java 159
        try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_INSERT, Statement.RETURN_GENERATED_KEYS, plugin ) )
        {
            int nIndex = 1;
            daoUtil.setInt( nIndex++, dataLayerMapTemplate.getIdMapTemplate( ) );
            daoUtil.setInt( nIndex++, dataLayerMapTemplate.getIdDataLayer( ) );
            daoUtil.setString( nIndex++, dataLayerMapTemplate.getPictogram( ) );
            daoUtil.setInt( nIndex++, dataLayerMapTemplate.getZoomMin( ) );
            daoUtil.setInt( nIndex++, dataLayerMapTemplate.getZoomMax( ) );
            daoUtil.setInt( nIndex++, dataLayerMapTemplate.getLayerType( ) );
            daoUtil.setString( nIndex++, dataLayerMapTemplate.getColor( ) );
            daoUtil.setInt( nIndex++, dataLayerMapTemplate.getThickness( ) );
            daoUtil.setInt( nIndex++, dataLayerMapTemplate.getIdCoordinate( ) );
            daoUtil.setInt( nIndex++, dataLayerMapTemplate.getZoomPicto() );
            daoUtil.setString( nIndex++, dataLayerMapTemplate.getIconImage( ) );
            daoUtil.setInt( nIndex++, dataLayerMapTemplate.getPictoSizeZoom07( ) );
            daoUtil.setInt( nIndex++, dataLayerMapTemplate.getPictoSizeZoom812( ) );
            daoUtil.setInt( nIndex++, dataLayerMapTemplate.getPictoSizeZoom1315( ) );
            daoUtil.setInt( nIndex++, dataLayerMapTemplate.getPictoSizeZoom1619( ) );
            daoUtil.setBoolean( nIndex++, dataLayerMapTemplate.isMarkerCluster( ) );
            

            daoUtil.executeUpdate( );
File Line
fr/paris/lutece/plugins/carto/business/DataLayerMapTemplateDAO.java 113
fr/paris/lutece/plugins/carto/business/DataLayerMapTemplateDAO.java 198
fr/paris/lutece/plugins/carto/business/DataLayerMapTemplateDAO.java 297
fr/paris/lutece/plugins/carto/business/DataLayerMapTemplateDAO.java 370
fr/paris/lutece/plugins/carto/business/DataLayerMapTemplateDAO.java 410
                dataLayerMapTemplate = new DataLayerMapTemplate( );
                int nIndex = 1;

                dataLayerMapTemplate.setId( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setIdMapTemplate( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setIdDataLayer( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setPictogram( daoUtil.getString( nIndex++ ) );
                dataLayerMapTemplate.setZoomMin( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setZoomMax( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setLayerType( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setColor( daoUtil.getString( nIndex++ ) );
                dataLayerMapTemplate.setThickness( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setIdCoordinate( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setZoomPicto( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setIconImage( daoUtil.getString( nIndex++ ) );
                dataLayerMapTemplate.setPictoSizeZoom07( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setPictoSizeZoom812( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setPictoSizeZoom1315( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setPictoSizeZoom1619( daoUtil.getInt( nIndex++ ) );
                dataLayerMapTemplate.setMarkerCluster( daoUtil.getBoolean( nIndex++ ) );
File Line
fr/paris/lutece/plugins/carto/business/DataLayerDAO.java 98
fr/paris/lutece/plugins/carto/business/DataLayerDAO.java 401
        try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECT, plugin ) )
        {
            daoUtil.setInt( 1, nKey );
            daoUtil.executeQuery( );
            DataLayer dataLayer = null;

            if ( daoUtil.next( ) )
            {
                dataLayer = new DataLayer( );
                int nIndex = 1;

                dataLayer.setId( daoUtil.getInt( nIndex++ ) );
                dataLayer.setTitle( daoUtil.getString( nIndex++ ) );
                dataLayer.setSolrTag( daoUtil.getString( nIndex++ ) );
                // dataLayer.setGeometry( daoUtil.getInt( nIndex ) );
                Optional<GeometryType> geometryType = GeometryTypeHome.findByPrimaryKey( daoUtil.getInt( nIndex++ ) );
                if ( geometryType.isPresent( ) )
                {
                    dataLayer.setGeometryType( geometryType.get( ) );
                }
                dataLayer.setPopupContent( daoUtil.getString( nIndex++ ) );
                dataLayer.setSource( daoUtil.getString( nIndex++ ) );
                dataLayer.setUrlFlux( daoUtil.getString( nIndex++ ) );
                dataLayer.setTypeNameFlux( daoUtil.getString( nIndex++ ) );
                dataLayer.setVersionFlux( daoUtil.getString( nIndex++ ) );
            }

            return Optional.ofNullable( dataLayer );
        }
    }
File Line
fr/paris/lutece/plugins/carto/business/DataLayerDAO.java 100
fr/paris/lutece/plugins/carto/business/DataLayerDAO.java 137
            daoUtil.setInt( 1, nKey );
            daoUtil.executeQuery( );
            DataLayer dataLayer = null;

            if ( daoUtil.next( ) )
            {
                dataLayer = new DataLayer( );
                int nIndex = 1;

                dataLayer.setId( daoUtil.getInt( nIndex++ ) );
                dataLayer.setTitle( daoUtil.getString( nIndex++ ) );
                dataLayer.setSolrTag( daoUtil.getString( nIndex++ ) );
                // dataLayer.setGeometry( daoUtil.getInt( nIndex ) );
                Optional<GeometryType> geometryType = GeometryTypeHome.findByPrimaryKey( daoUtil.getInt( nIndex++ ) );
                if ( geometryType.isPresent( ) )
                {
                    dataLayer.setGeometryType( geometryType.get( ) );
                }
                dataLayer.setPopupContent( daoUtil.getString( nIndex++ ) );
                dataLayer.setSource( daoUtil.getString( nIndex++ ) );
                dataLayer.setUrlFlux( daoUtil.getString( nIndex++ ) );
                dataLayer.setTypeNameFlux( daoUtil.getString( nIndex++ ) );
                dataLayer.setVersionFlux( daoUtil.getString( nIndex++ ) );
            }

            return Optional.ofNullable( dataLayer );
        }
    }
    
    /**
     * {@inheritDoc }
     */
    @Override
    public Optional<DataLayer> loadBySolrTag( String strSolrTag, Plugin plugin )
File Line
fr/paris/lutece/plugins/carto/business/DataLayerDAO.java 213
fr/paris/lutece/plugins/carto/business/DataLayerDAO.java 252
            daoUtil.executeQuery( );

            while ( daoUtil.next( ) )
            {
                DataLayer dataLayer = new DataLayer( );
                int nIndex = 1;

                dataLayer.setId( daoUtil.getInt( nIndex++ ) );
                dataLayer.setTitle( daoUtil.getString( nIndex++ ) );
                dataLayer.setSolrTag( daoUtil.getString( nIndex++ ) );
                // dataLayer.setGeometry( daoUtil.getInt( nIndex ) );
                Optional<GeometryType> geometryType = GeometryTypeHome.findByPrimaryKey( daoUtil.getInt( nIndex++ ) );
                if ( geometryType.isPresent( ) )
                {
                    dataLayer.setGeometryType( geometryType.get( ) );
                }
                dataLayer.setPopupContent( daoUtil.getString( nIndex++ ) );
                dataLayer.setSource( daoUtil.getString( nIndex++ ) );
                dataLayer.setUrlFlux( daoUtil.getString( nIndex++ ) );
                dataLayer.setTypeNameFlux( daoUtil.getString( nIndex++ ) );
                dataLayer.setVersionFlux( daoUtil.getString( nIndex++ ) );

                dataLayerList.add( dataLayer );
            }

            return dataLayerList;
        }
    }
    
    /**
     * {@inheritDoc }
     */
    @Override
    public List<DataLayer> selectDataLayersListWFS( Plugin plugin, int nIdMapTemplate )
File Line
fr/paris/lutece/plugins/carto/business/DataLayerDAO.java 137
fr/paris/lutece/plugins/carto/business/DataLayerDAO.java 403
            daoUtil.setString( 1, strSolrTag );
            daoUtil.executeQuery( );
            DataLayer dataLayer = null;

            if ( daoUtil.next( ) )
            {
                dataLayer = new DataLayer( );
                int nIndex = 1;

                dataLayer.setId( daoUtil.getInt( nIndex++ ) );
                dataLayer.setTitle( daoUtil.getString( nIndex++ ) );
                dataLayer.setSolrTag( daoUtil.getString( nIndex++ ) );
                // dataLayer.setGeometry( daoUtil.getInt( nIndex ) );
                Optional<GeometryType> geometryType = GeometryTypeHome.findByPrimaryKey( daoUtil.getInt( nIndex++ ) );
                if ( geometryType.isPresent( ) )
                {
                    dataLayer.setGeometryType( geometryType.get( ) );
                }
                dataLayer.setPopupContent( daoUtil.getString( nIndex++ ) );
                dataLayer.setSource( daoUtil.getString( nIndex++ ) );
                dataLayer.setUrlFlux( daoUtil.getString( nIndex++ ) );
                dataLayer.setTypeNameFlux( daoUtil.getString( nIndex++ ) );
                dataLayer.setVersionFlux( daoUtil.getString( nIndex++ ) );
            }

            return Optional.ofNullable( dataLayer );
        }
    }
File Line
fr/paris/lutece/plugins/carto/business/MapTemplateDAO.java 99
fr/paris/lutece/plugins/carto/business/MapTemplateDAO.java 303
            daoUtil.executeQuery( );
            MapTemplate mapTemplate = null;

            if ( daoUtil.next( ) )
            {
                mapTemplate = new MapTemplate( );
                int nIndex = 1;

                mapTemplate.setId( daoUtil.getInt( nIndex++ ) );
                mapTemplate.setTitle( daoUtil.getString( nIndex++ ) );
                mapTemplate.setDescription( daoUtil.getString( nIndex++ ) );
                mapTemplate.setMapBackground( daoUtil.getString( nIndex++ ) );
                mapTemplate.setDefaultZoom( daoUtil.getInt( nIndex++ ) );
                mapTemplate.setZoomMin( daoUtil.getInt( nIndex++ ) );
                mapTemplate.setZoomMax( daoUtil.getInt( nIndex++ ) );
                mapTemplate.setCenterMap( daoUtil.getString( nIndex++ ) );
                mapTemplate.setCenterMapX( daoUtil.getDouble( nIndex++ ) );
                mapTemplate.setCenterMapY( daoUtil.getDouble( nIndex++ ) );
                mapTemplate.setFrontOffice( daoUtil.getBoolean( nIndex ) );
            }

            return Optional.ofNullable( mapTemplate );
        }
    }
File Line
fr/paris/lutece/plugins/carto/business/DataLayerDAO.java 213
fr/paris/lutece/plugins/carto/business/DataLayerDAO.java 252
fr/paris/lutece/plugins/carto/business/DataLayerDAO.java 349
            daoUtil.executeQuery( );

            while ( daoUtil.next( ) )
            {
                DataLayer dataLayer = new DataLayer( );
                int nIndex = 1;

                dataLayer.setId( daoUtil.getInt( nIndex++ ) );
                dataLayer.setTitle( daoUtil.getString( nIndex++ ) );
                dataLayer.setSolrTag( daoUtil.getString( nIndex++ ) );
                // dataLayer.setGeometry( daoUtil.getInt( nIndex ) );
                Optional<GeometryType> geometryType = GeometryTypeHome.findByPrimaryKey( daoUtil.getInt( nIndex++ ) );
                if ( geometryType.isPresent( ) )
                {
                    dataLayer.setGeometryType( geometryType.get( ) );
                }
                dataLayer.setPopupContent( daoUtil.getString( nIndex++ ) );
                dataLayer.setSource( daoUtil.getString( nIndex++ ) );
                dataLayer.setUrlFlux( daoUtil.getString( nIndex++ ) );
                dataLayer.setTypeNameFlux( daoUtil.getString( nIndex++ ) );
                dataLayer.setVersionFlux( daoUtil.getString( nIndex++ ) );

                dataLayerList.add( dataLayer );
            }
File Line
fr/paris/lutece/plugins/carto/business/MapTemplateDAO.java 172
fr/paris/lutece/plugins/carto/business/MapTemplateDAO.java 266
            daoUtil.executeQuery( );

            while ( daoUtil.next( ) )
            {
                MapTemplate mapTemplate = new MapTemplate( );
                int nIndex = 1;

                mapTemplate.setId( daoUtil.getInt( nIndex++ ) );
                mapTemplate.setTitle( daoUtil.getString( nIndex++ ) );
                mapTemplate.setDescription( daoUtil.getString( nIndex++ ) );
                mapTemplate.setMapBackground( daoUtil.getString( nIndex++ ) );
                mapTemplate.setDefaultZoom( daoUtil.getInt( nIndex++ ) );
                mapTemplate.setZoomMin( daoUtil.getInt( nIndex++ ) );
                mapTemplate.setZoomMax( daoUtil.getInt( nIndex++ ) );
                mapTemplate.setCenterMap( daoUtil.getString( nIndex++ ) );
                mapTemplate.setCenterMapX( daoUtil.getDouble( nIndex++ ) );
                mapTemplate.setCenterMapY( daoUtil.getDouble( nIndex++ ) );
                mapTemplate.setFrontOffice( daoUtil.getBoolean( nIndex ) );

                mapTemplateList.add( mapTemplate );
            }
File Line
fr/paris/lutece/plugins/carto/business/DataLayerDAO.java 106
fr/paris/lutece/plugins/carto/business/DataLayerDAO.java 143
fr/paris/lutece/plugins/carto/business/DataLayerDAO.java 217
fr/paris/lutece/plugins/carto/business/DataLayerDAO.java 256
fr/paris/lutece/plugins/carto/business/DataLayerDAO.java 352
fr/paris/lutece/plugins/carto/business/DataLayerDAO.java 409
                dataLayer = new DataLayer( );
                int nIndex = 1;

                dataLayer.setId( daoUtil.getInt( nIndex++ ) );
                dataLayer.setTitle( daoUtil.getString( nIndex++ ) );
                dataLayer.setSolrTag( daoUtil.getString( nIndex++ ) );
                // dataLayer.setGeometry( daoUtil.getInt( nIndex ) );
                Optional<GeometryType> geometryType = GeometryTypeHome.findByPrimaryKey( daoUtil.getInt( nIndex++ ) );
                if ( geometryType.isPresent( ) )
                {
                    dataLayer.setGeometryType( geometryType.get( ) );
                }
                dataLayer.setPopupContent( daoUtil.getString( nIndex++ ) );
                dataLayer.setSource( daoUtil.getString( nIndex++ ) );
                dataLayer.setUrlFlux( daoUtil.getString( nIndex++ ) );
                dataLayer.setTypeNameFlux( daoUtil.getString( nIndex++ ) );
                dataLayer.setVersionFlux( daoUtil.getString( nIndex++ ) );
File Line
fr/paris/lutece/plugins/carto/business/MapTemplateDAO.java 67
fr/paris/lutece/plugins/carto/business/MapTemplateDAO.java 143
        try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_INSERT, Statement.RETURN_GENERATED_KEYS, plugin ) )
        {
            int nIndex = 1;
            daoUtil.setString( nIndex++, mapTemplate.getTitle( ) );
            daoUtil.setString( nIndex++, mapTemplate.getDescription( ) );
            daoUtil.setString( nIndex++, mapTemplate.getMapBackground( ) );
            daoUtil.setInt( nIndex++, mapTemplate.getDefaultZoom( ) );
            daoUtil.setInt( nIndex++, mapTemplate.getZoomMin( ) );
            daoUtil.setInt( nIndex++, mapTemplate.getZoomMax( ) );
            daoUtil.setString( nIndex++, mapTemplate.getCenterMap( ) );
            daoUtil.setDouble( nIndex++, mapTemplate.getCenterMapX( ) );
            daoUtil.setDouble( nIndex++, mapTemplate.getCenterMapY( ) );
            daoUtil.setBoolean( nIndex++, mapTemplate.getFrontOffice( ) );

            daoUtil.executeUpdate( );
File Line
fr/paris/lutece/plugins/carto/business/MapTemplateDAO.java 104
fr/paris/lutece/plugins/carto/business/MapTemplateDAO.java 176
fr/paris/lutece/plugins/carto/business/MapTemplateDAO.java 269
fr/paris/lutece/plugins/carto/business/MapTemplateDAO.java 308
                mapTemplate = new MapTemplate( );
                int nIndex = 1;

                mapTemplate.setId( daoUtil.getInt( nIndex++ ) );
                mapTemplate.setTitle( daoUtil.getString( nIndex++ ) );
                mapTemplate.setDescription( daoUtil.getString( nIndex++ ) );
                mapTemplate.setMapBackground( daoUtil.getString( nIndex++ ) );
                mapTemplate.setDefaultZoom( daoUtil.getInt( nIndex++ ) );
                mapTemplate.setZoomMin( daoUtil.getInt( nIndex++ ) );
                mapTemplate.setZoomMax( daoUtil.getInt( nIndex++ ) );
                mapTemplate.setCenterMap( daoUtil.getString( nIndex++ ) );
                mapTemplate.setCenterMapX( daoUtil.getDouble( nIndex++ ) );
                mapTemplate.setCenterMapY( daoUtil.getDouble( nIndex++ ) );
                mapTemplate.setFrontOffice( daoUtil.getBoolean( nIndex ) );
File Line
fr/paris/lutece/plugins/carto/business/CoordonneeDAO.java 160
fr/paris/lutece/plugins/carto/business/CoordonneeDAO.java 253
            daoUtil.executeQuery( );

            while ( daoUtil.next( ) )
            {
                Coordonnee coordonnee = new Coordonnee( );
                int nIndex = 1;

                coordonnee.setId( daoUtil.getInt( nIndex++ ) );
                coordonnee.setAdresse( daoUtil.getString( nIndex++ ) );
                coordonnee.setCoordonneeX( daoUtil.getDouble( nIndex++ ) );
                coordonnee.setCoordonneeY( daoUtil.getDouble( nIndex++ ) );
                coordonnee.setGeoJson( daoUtil.getString( nIndex++ ) );
                Optional<DataLayer> dataLyer = DataLayerHome.findByPrimaryKey( daoUtil.getInt( nIndex ) );
                if ( dataLyer.isPresent( ) )
                {
                    coordonnee.setDataLayer( dataLyer.get( ) );
                }

                coordonneeList.add( coordonnee );
            }
File Line
fr/paris/lutece/plugins/carto/business/BasemapDAO.java 215
fr/paris/lutece/plugins/carto/business/CoordonneeDAO.java 231
fr/paris/lutece/plugins/carto/business/DataLayerDAO.java 327
fr/paris/lutece/plugins/carto/business/DataLayerMapTemplateDAO.java 272
fr/paris/lutece/plugins/carto/business/DataLayerTypeDAO.java 223
fr/paris/lutece/plugins/carto/business/GeometryTypeDAO.java 211
fr/paris/lutece/plugins/carto/business/MapTemplateDAO.java 244
        List<Basemap> basemapList = new ArrayList<>( );

        StringBuilder builder = new StringBuilder( );

        if ( !listIds.isEmpty( ) )
        {
            for ( int i = 0; i < listIds.size( ); i++ )
            {
                builder.append( "?," );
            }

            String placeHolders = builder.deleteCharAt( builder.length( ) - 1 ).toString( );
            String stmt = SQL_QUERY_SELECTALL_BY_IDS + placeHolders + ")";

            try ( DAOUtil daoUtil = new DAOUtil( stmt, plugin ) )
            {
                int index = 1;
                for ( Integer n : listIds )
                {
                    daoUtil.setInt( index++, n );
                }

                daoUtil.executeQuery( );
                while ( daoUtil.next( ) )
                {
File Line
fr/paris/lutece/plugins/carto/business/DataLayerDAO.java 70
fr/paris/lutece/plugins/carto/business/DataLayerDAO.java 185
        try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_INSERT, Statement.RETURN_GENERATED_KEYS, plugin ) )
        {
            int nIndex = 1;
            daoUtil.setString( nIndex++, dataLayer.getTitle( ) );
            daoUtil.setString( nIndex++, dataLayer.getSolrTag( ) );
            daoUtil.setInt( nIndex++, dataLayer.getGeometryType( ).getId( ) );
            daoUtil.setString( nIndex++, dataLayer.getPopupContent( ) );
            daoUtil.setString( nIndex++, dataLayer.getSource( ) );
            daoUtil.setString( nIndex++, dataLayer.getUrlFlux( ) );
            daoUtil.setString( nIndex++, dataLayer.getTypeNameFlux( ) );
            daoUtil.setString( nIndex++, dataLayer.getVersionFlux( ) );
            

            daoUtil.executeUpdate( );
File Line
fr/paris/lutece/plugins/carto/web/DataLayerMapTemplateJspBean.java 260
fr/paris/lutece/plugins/carto/web/DataLayerMapTemplateJspBean.java 434
            return redirect( request, VIEW_CREATE_DATALAYERMAPTEMPLATE, PARAMETER_ID_DATALAYERMAPTEMPLATE, _datalayermaptemplate.getId( ) );
        }

        MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;
        FileItem zoneJsonFileItem = multipartRequest.getFile( PARAMETER_ZONE_JSON );
        String strGeoJSON = null;
        if ( zoneJsonFileItem != null && zoneJsonFileItem.getSize( ) > 0 )
        {
            String strGeoJsonFeatureCollection = zoneJsonFileItem.getString( );
            try
            {
                new ObjectMapper( ).readTree( strGeoJsonFeatureCollection );
                strGeoJSON = getGeoJSON( strGeoJsonFeatureCollection );
            }
            catch( IOException e )
            {
                AppLogService.error( "Exception during GEOJSON parsing : " + strGeoJsonFeatureCollection + " : " + e );
                addError( "GeoJSON not valid" );
                return redirect( request, VIEW_MODIFY_DATALAYERMAPTEMPLATE, PARAMETER_ID_DATALAYERMAPTEMPLATE, _datalayermaptemplate.getId( ) );

            }
File Line
fr/paris/lutece/plugins/carto/business/CoordonneeDAO.java 97
fr/paris/lutece/plugins/carto/business/CoordonneeDAO.java 164
fr/paris/lutece/plugins/carto/business/CoordonneeDAO.java 256
                coordonnee = new Coordonnee( );
                int nIndex = 1;

                coordonnee.setId( daoUtil.getInt( nIndex++ ) );
                coordonnee.setAdresse( daoUtil.getString( nIndex++ ) );
                coordonnee.setCoordonneeX( daoUtil.getDouble( nIndex++ ) );
                coordonnee.setCoordonneeY( daoUtil.getDouble( nIndex++ ) );
                coordonnee.setGeoJson( daoUtil.getString( nIndex++ ) );
                Optional<DataLayer> dataLyer = DataLayerHome.findByPrimaryKey( daoUtil.getInt( nIndex ) );
                if ( dataLyer.isPresent( ) )
                {
                    coordonnee.setDataLayer( dataLyer.get( ) );
                }
File Line
fr/paris/lutece/plugins/carto/business/DataLayerTypeDAO.java 156
fr/paris/lutece/plugins/carto/business/DataLayerTypeDAO.java 245
            daoUtil.executeQuery( );

            while ( daoUtil.next( ) )
            {
                DataLayerType dataLayerType = new DataLayerType( );
                int nIndex = 1;

                dataLayerType.setId( daoUtil.getInt( nIndex++ ) );
                dataLayerType.setTitle( daoUtil.getString( nIndex++ ) );
                dataLayerType.setEditable( daoUtil.getBoolean( nIndex++ ) );
                dataLayerType.setSearchableByOthers( daoUtil.getBoolean( nIndex++ ) );
                dataLayerType.setInclusion( daoUtil.getBoolean( nIndex++ ) );
                dataLayerType.setExclusion( daoUtil.getBoolean( nIndex ) );

                dataLayerTypeList.add( dataLayerType );
            }